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 | 1926 | 377.15 ms | 2.09 ms | 152.23 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 1926 | 179.50 ms | 1.33 ms | 61.79 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 1930 | 12.42 ms | 95.22 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 91976 | 36.17 s | 794.64 ms | 12.63 s | 217142 | 1878638 | 0 | 19623 | |
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 | 3016 | 2.95 s | 6.21 ms | 1.16 s | 117978 | 601149 | 0 | 0 | |
root | create_table | 13 | 2.90 s | 447.50 ms | 8.83 ms | 0 | 0 | 0 | 0 | |
root | show_variables | 3068 | 2.71 s | 7.86 ms | 268.78 ms | 3062 | 1760591 | 0 | 3068 | |
root | show_keys | 2952 | 2.65 s | 81.34 ms | 1.10 s | 2884 | 46387 | 0 | 0 | |
root | show_create_table | 1522 | 1.60 s | 998.46 ms | 999.15 ms | 0 | 0 | 0 | 0 | |
root | show_tables | 1375 | 970.74 ms | 4.69 ms | 503.92 ms | 31510 | 88750 | 0 | 0 | |
root | create_db | 11 | 667.57 ms | 168.07 ms | 3.48 ms | 0 | 0 | 11 | 0 | |
root | set_option | 7356 | 457.36 ms | 7.84 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Init DB | 2285 | 126.36 ms | 429.51 us | 11.98 ms | 0 | 0 | 0 | 0 | |
root | insert | 5 | 120.18 ms | 34.89 ms | 1.78 ms | 0 | 0 | 25 | 0 | |
root | show_grants | 1230 | 96.73 ms | 514.36 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_binlogs | 67 | 62.87 ms | 56.16 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_table_status | 256 | 50.57 ms | 3.04 ms | 31.08 ms | 0 | 48 | 0 | 0 | |
root | show_warnings | 1394 | 45.89 ms | 1.20 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Quit | 3036 | 25.54 ms | 3.83 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | jump_if_not | 30908 | 23.20 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 | 7130 | 10.30 ms | 2.30 ms | 0 ps | 0 | 0 | 0 | 0 |
|