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.93 ms | 2.93 ms | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 361 | 75.66 ms | 584.11 us | 30.55 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 361 | 36.65 ms | 321.43 us | 12.51 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 361 | 2.14 ms | 23.40 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 21791 | 9.28 s | 540.62 ms | 3.35 s | 38289 | 298721 | 0 | 2836 | |
root | show_keys | 503 | 696.58 ms | 61.33 ms | 185.27 ms | 400 | 4245 | 0 | 0 | |
root | show_variables | 433 | 454.51 ms | 41.64 ms | 37.83 ms | 433 | 248542 | 0 | 433 | |
root | show_fields | 437 | 422.55 ms | 4.29 ms | 172.40 ms | 17086 | 86851 | 0 | 0 | |
root | set_option | 1191 | 96.55 ms | 7.81 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_table | 223 | 49.18 ms | 1.07 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_tables | 74 | 47.15 ms | 3.21 ms | 21.62 ms | 1675 | 4473 | 0 | 0 | |
root | show_grants | 183 | 13.68 ms | 303.99 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Init DB | 263 | 12.66 ms | 376.97 us | 725.00 us | 0 | 0 | 0 | 0 | |
root | jump_if_not | 8880 | 10.18 ms | 614.30 us | 0 ps | 0 | 0 | 0 | 0 | |
root | freturn | 4697 | 7.30 ms | 830.75 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_warnings | 210 | 6.32 ms | 89.08 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Quit | 432 | 4.34 ms | 1.64 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_binlogs | 11 | 3.64 ms | 3.03 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_master_status | 2 | 2.09 ms | 2.05 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | stmt | 5 | 1.27 ms | 882.21 us | 0 ps | 0 | 5 | 0 | 0 | |
root | set | 10 | 1.11 ms | 845.63 us | 0 ps | 0 | 5 | 0 | 0 | |
root | show_slave_status | 2 | 883.65 us | 849.10 us | 0 ps | 0 | 0 | 0 | 0 | |
root | error | 1 | 51.73 us | 51.73 us | 0 ps | 0 | 0 | 0 | 0 |
|