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 | 1.18 ms | 1.18 ms | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 2395 | 572.34 ms | 32.67 ms | 245.77 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 2395 | 226.53 ms | 534.80 us | 78.26 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 2394 | 14.16 ms | 59.66 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 313684 | 1.88 m | 1.06 s | 43.84 s | 492396 | 3457109 | 0 | 33559 | |
root | show_keys | 6264 | 5.59 s | 118.81 ms | 2.23 s | 4629 | 58809 | 0 | 0 | |
root | show_fields | 5161 | 4.69 s | 4.81 ms | 1.96 s | 183117 | 933191 | 0 | 0 | |
root | show_variables | 4716 | 3.99 s | 10.16 ms | 406.58 ms | 4712 | 2706522 | 0 | 4716 | |
root | show_tables | 1210 | 887.35 ms | 4.97 ms | 447.89 ms | 32099 | 81072 | 0 | 0 | |
root | set_option | 8800 | 549.98 ms | 11.74 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_table | 2578 | 537.02 ms | 3.89 ms | 501.00 us | 0 | 0 | 0 | 0 | |
root | Init DB | 3068 | 132.87 ms | 363.69 us | 2.21 ms | 0 | 0 | 0 | 0 | |
root | show_grants | 1396 | 103.28 ms | 966.97 us | 0 ps | 0 | 0 | 0 | 0 | |
root | create_db | 2 | 102.38 ms | 60.59 ms | 1.68 ms | 0 | 0 | 2 | 0 | |
root | show_table_status | 21 | 88.28 ms | 77.18 ms | 8.91 ms | 33 | 244 | 0 | 0 | |
root | show_warnings | 2306 | 70.94 ms | 236.23 us | 0 ps | 0 | 0 | 0 | 0 | |
root | jump_if_not | 72946 | 65.44 ms | 3.36 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | freturn | 30019 | 37.02 ms | 1.12 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Quit | 3466 | 22.71 ms | 241.42 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_proc | 104 | 14.19 ms | 1.50 ms | 2.53 ms | 0 | 0 | 0 | 0 | |
root | stmt | 34 | 12.02 ms | 2.11 ms | 0 ps | 0 | 34 | 0 | 0 | |
root | show_create_func | 88 | 11.32 ms | 2.16 ms | 866.00 us | 0 | 0 | 0 | 0 | |
root | show_binlogs | 55 | 10.17 ms | 2.21 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_storage_engines | 32 | 4.31 ms | 834.85 us | 2.44 ms | 288 | 288 | 0 | 32 | |
root | Prepare | 4 | 3.95 ms | 3.41 ms | 0 ps | 0 | 0 | 0 | 0 |
|