SELECT * FROM `user_summary_by_statement_type`
|
user | statement | total | total_latency | max_latency | lock_latency | rows_sent | rows_examined | rows_affected | full_scans | |
---|---|---|---|---|---|---|---|---|---|---|
background | select | 1 | 90.56 us | 90.56 us | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 3235 | 677.30 ms | 1.38 ms | 273.07 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 3235 | 321.48 ms | 659.35 us | 110.91 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 3236 | 22.83 ms | 183.05 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 105810 | 40.63 s | 879.31 ms | 14.67 s | 236005 | 1506169 | 0 | 22611 | |
root | drop_db | 39 | 7.52 s | 1.16 s | 20.25 ms | 0 | 0 | 87 | 0 | |
root | create_table | 35 | 6.12 s | 387.83 ms | 13.52 ms | 0 | 0 | 0 | 0 | |
root | show_variables | 3463 | 3.10 s | 5.70 ms | 305.97 ms | 5119 | 1987153 | 0 | 3463 | |
root | show_keys | 3123 | 2.74 s | 80.68 ms | 1.11 s | 2428 | 31086 | 0 | 0 | |
root | show_fields | 2792 | 2.65 s | 7.15 ms | 1.06 s | 108655 | 552646 | 0 | 0 | |
root | insert | 36 | 1.16 s | 149.34 ms | 8.93 ms | 0 | 0 | 162 | 0 | |
root | create_db | 22 | 1.09 s | 73.70 ms | 5.31 ms | 0 | 0 | 22 | 0 | |
root | set_option | 10162 | 657.10 ms | 6.75 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_tables | 1139 | 633.88 ms | 14.01 ms | 364.69 ms | 10689 | 30307 | 0 | 0 | |
root | show_create_table | 1423 | 300.67 ms | 1.76 ms | 1.62 ms | 0 | 0 | 0 | 0 | |
root | Init DB | 2545 | 161.49 ms | 438.18 us | 20.76 ms | 0 | 0 | 0 | 0 | |
root | show_table_status | 200 | 122.31 ms | 39.96 ms | 51.65 ms | 40 | 419 | 0 | 0 | |
root | show_grants | 1452 | 119.28 ms | 345.08 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_warnings | 1433 | 46.35 ms | 494.78 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_master_status | 99 | 32.46 ms | 16.32 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_status | 3 | 32.08 ms | 16.39 ms | 477.00 us | 1350 | 1350 | 0 | 3 | |
root | Quit | 3605 | 25.19 ms | 252.70 us | 0 ps | 0 | 0 | 0 | 0 | |
root | jump_if_not | 26235 | 23.56 ms | 1.36 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | freturn | 9498 | 10.30 ms | 1.71 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | set | 178 | 9.54 ms | 2.09 ms | 0 ps | 0 | 39 | 0 | 0 |
|