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 | 2.54 ms | 2.54 ms | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 2144 | 394.00 ms | 1.73 ms | 159.26 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 2085 | 181.64 ms | 1.42 ms | 63.10 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 2113 | 13.63 ms | 35.99 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 111435 | 44.29 s | 368.85 ms | 15.03 s | 287366 | 2052221 | 0 | 29415 | |
root | show_keys | 4236 | 4.68 s | 1.17 s | 1.59 s | 4124 | 69992 | 0 | 0 | |
root | show_fields | 4290 | 4.24 s | 6.07 ms | 1.69 s | 172713 | 879838 | 0 | 0 | |
root | show_variables | 3987 | 3.44 s | 6.34 ms | 341.48 ms | 4538 | 2287866 | 0 | 3987 | |
root | show_tables | 2259 | 1.57 s | 5.72 ms | 841.27 ms | 47508 | 137846 | 0 | 0 | |
root | set_option | 8839 | 519.52 ms | 5.20 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_table | 2166 | 437.22 ms | 4.84 ms | 273.00 us | 0 | 0 | 0 | 0 | |
root | create_table | 1 | 307.38 ms | 307.38 ms | 3.45 ms | 0 | 0 | 0 | 0 | |
root | create_db | 6 | 160.17 ms | 70.49 ms | 1.96 ms | 0 | 0 | 3 | 0 | |
root | Init DB | 2989 | 137.88 ms | 416.20 us | 4.65 ms | 0 | 0 | 0 | 0 | |
root | show_grants | 1714 | 136.88 ms | 1.34 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_table_status | 109 | 121.51 ms | 73.74 ms | 32.75 ms | 15 | 171 | 0 | 0 | |
root | show_warnings | 1898 | 57.18 ms | 349.94 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Quit | 3844 | 25.15 ms | 219.83 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_status | 1 | 17.45 ms | 17.45 ms | 154.00 us | 450 | 450 | 0 | 1 | |
root | show_create_proc | 54 | 14.88 ms | 6.05 ms | 1.68 ms | 0 | 0 | 0 | 0 | |
root | jump_if_not | 7513 | 8.42 ms | 1.75 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_binlogs | 97 | 6.65 ms | 699.04 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_func | 44 | 6.54 ms | 801.49 us | 1.06 ms | 0 | 0 | 0 | 0 | |
root | freturn | 1253 | 4.23 ms | 2.06 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | stmt | 7 | 4.06 ms | 2.23 ms | 0 ps | 0 | 7 | 0 | 0 |
|