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.00 us | 90.00 us | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 1920 | 291.69 ms | 1.32 ms | 119.71 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 1920 | 119.36 ms | 590.90 us | 43.25 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 1919 | 12.89 ms | 73.63 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 64175 | 41.41 s | 651.27 ms | 10.42 s | 236986 | 4877734 | 0 | 24254 | |
root | show_keys | 3124 | 3.37 s | 77.71 ms | 1.39 s | 2792 | 41669 | 0 | 0 | |
root | show_fields | 2920 | 3.31 s | 6.95 ms | 1.34 s | 105693 | 539275 | 0 | 0 | |
root | show_variables | 2867 | 2.87 s | 6.29 ms | 281.24 ms | 3413 | 1644671 | 0 | 2867 | |
root | alter_table | 8 | 2.60 s | 454.21 ms | 1.27 ms | 0 | 0 | 0 | 0 | |
root | create_table | 11 | 2.22 s | 302.17 ms | 4.52 ms | 0 | 0 | 0 | 0 | |
root | show_tables | 1558 | 904.63 ms | 17.98 ms | 464.98 ms | 32372 | 90022 | 0 | 0 | |
root | create_db | 9 | 346.00 ms | 69.12 ms | 1.35 ms | 0 | 0 | 7 | 0 | |
root | show_create_table | 1453 | 344.35 ms | 3.40 ms | 88.00 us | 0 | 0 | 0 | 0 | |
root | set_option | 7444 | 343.75 ms | 7.32 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | insert | 7 | 295.59 ms | 55.76 ms | 1.86 ms | 0 | 0 | 166 | 0 | |
root | Init DB | 2299 | 122.84 ms | 844.40 us | 9.80 ms | 0 | 0 | 0 | 0 | |
root | show_grants | 1183 | 105.93 ms | 1.17 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | drop_db | 2 | 83.44 ms | 55.79 ms | 593.00 us | 0 | 0 | 0 | 0 | |
root | jump_if_not | 50584 | 48.88 ms | 2.15 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_warnings | 1260 | 45.11 ms | 1.10 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_table_status | 166 | 38.18 ms | 1.17 ms | 23.30 ms | 17 | 135 | 0 | 0 | |
root | show_create_proc | 234 | 34.40 ms | 4.18 ms | 3.74 ms | 0 | 0 | 0 | 0 | |
root | show_create_func | 198 | 23.63 ms | 1.42 ms | 1.94 ms | 0 | 0 | 0 | 0 | |
root | freturn | 9103 | 22.20 ms | 1.27 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Quit | 3154 | 21.73 ms | 195.01 us | 0 ps | 0 | 0 | 0 | 0 |
|