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 | 96.87 us | 96.87 us | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 149 | 25.83 ms | 501.62 us | 10.57 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 149 | 11.01 ms | 242.12 us | 3.88 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 145 | 797.15 us | 19.63 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 12353 | 4.82 s | 84.12 ms | 1.97 s | 22342 | 167639 | 0 | 1822 | |
root | show_keys | 292 | 418.33 ms | 46.04 ms | 111.24 ms | 253 | 3028 | 0 | 0 | |
root | show_fields | 260 | 259.04 ms | 3.74 ms | 104.62 ms | 9707 | 49436 | 0 | 0 | |
root | show_variables | 236 | 224.13 ms | 3.01 ms | 21.40 ms | 236 | 135443 | 0 | 236 | |
root | show_tables | 74 | 53.63 ms | 4.95 ms | 28.91 ms | 1503 | 3894 | 0 | 0 | |
root | set_option | 511 | 47.38 ms | 5.90 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_table | 135 | 31.66 ms | 1.07 ms | 1.33 ms | 0 | 0 | 0 | 0 | |
root | Init DB | 172 | 7.64 ms | 191.56 us | 333.00 us | 0 | 0 | 0 | 0 | |
root | show_grants | 90 | 7.26 ms | 292.38 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_warnings | 114 | 3.34 ms | 70.01 us | 0 ps | 0 | 0 | 0 | 0 | |
root | jump_if_not | 1531 | 3.33 ms | 972.16 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_binlogs | 3 | 3.27 ms | 1.95 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | freturn | 612 | 3.04 ms | 2.49 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | stmt | 1 | 1.31 ms | 1.31 ms | 0 ps | 0 | 1 | 0 | 0 | |
root | set | 2 | 1.25 ms | 1.25 ms | 0 ps | 0 | 1 | 0 | 0 | |
root | show_table_status | 3 | 1.24 ms | 580.47 us | 869.00 us | 0 | 4 | 0 | 0 | |
root | Quit | 191 | 1.19 ms | 148.34 us | 0 ps | 0 | 0 | 0 | 0 | |
root | error | 2 | 868.60 us | 652.36 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_slave_status | 3 | 224.11 us | 130.58 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_master_status | 3 | 135.76 us | 85.60 us | 0 ps | 0 | 0 | 0 | 0 |
|