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 | 4.56 ms | 4.56 ms | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 2124 | 418.22 ms | 2.09 ms | 168.97 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 2124 | 200.89 ms | 1.33 ms | 68.87 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 2128 | 13.77 ms | 95.22 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 98307 | 39.20 s | 794.64 ms | 13.47 s | 235510 | 2053758 | 0 | 21622 | |
root | drop_db | 31 | 5.85 s | 1.04 s | 25.94 ms | 0 | 0 | 80 | 0 | |
root | alter_table | 14 | 5.59 s | 568.71 ms | 2.53 ms | 0 | 0 | 25 | 0 | |
root | show_fields | 3350 | 3.27 s | 6.21 ms | 1.29 s | 131883 | 671915 | 0 | 0 | |
root | create_table | 14 | 3.14 s | 447.50 ms | 9.48 ms | 0 | 0 | 0 | 0 | |
root | show_variables | 3385 | 2.98 s | 7.86 ms | 297.00 ms | 3379 | 1942528 | 0 | 3385 | |
root | show_keys | 3269 | 2.86 s | 81.34 ms | 1.21 s | 3187 | 51480 | 0 | 0 | |
root | show_create_table | 1690 | 1.63 s | 998.46 ms | 999.20 ms | 0 | 0 | 0 | 0 | |
root | show_tables | 1544 | 1.08 s | 4.69 ms | 561.95 ms | 35156 | 99224 | 0 | 0 | |
root | create_db | 11 | 667.57 ms | 168.07 ms | 3.48 ms | 0 | 0 | 11 | 0 | |
root | set_option | 8140 | 506.20 ms | 7.84 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Init DB | 2524 | 140.03 ms | 429.51 us | 13.25 ms | 0 | 0 | 0 | 0 | |
root | insert | 5 | 120.18 ms | 34.89 ms | 1.78 ms | 0 | 0 | 25 | 0 | |
root | show_grants | 1355 | 108.02 ms | 854.82 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_binlogs | 79 | 63.73 ms | 56.16 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_table_status | 281 | 54.95 ms | 3.04 ms | 33.97 ms | 0 | 50 | 0 | 0 | |
root | show_warnings | 1545 | 50.19 ms | 1.20 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Quit | 3372 | 29.41 ms | 3.83 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | jump_if_not | 32191 | 23.92 ms | 1.76 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_proc | 27 | 12.81 ms | 2.94 ms | 2.54 ms | 0 | 0 | 0 | 0 | |
root | freturn | 7635 | 11.15 ms | 2.30 ms | 0 ps | 0 | 0 | 0 | 0 |
|