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 | 90.56 us | 90.56 us | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 4319 | 893.18 ms | 1.38 ms | 361.24 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 4319 | 424.42 ms | 659.35 us | 146.82 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 4319 | 29.98 ms | 183.05 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 150174 | 58.70 s | 879.31 ms | 20.56 s | 325632 | 2150778 | 0 | 33292 | |
root | drop_db | 39 | 7.52 s | 1.16 s | 20.25 ms | 0 | 0 | 87 | 0 | |
root | create_table | 37 | 6.32 s | 387.83 ms | 16.88 ms | 0 | 0 | 0 | 0 | |
root | show_variables | 4965 | 4.38 s | 5.70 ms | 434.80 ms | 7173 | 2849133 | 0 | 4965 | |
root | show_fields | 4161 | 3.99 s | 7.91 ms | 1.59 s | 161847 | 823085 | 0 | 0 | |
root | show_keys | 4766 | 3.93 s | 80.68 ms | 1.71 s | 3550 | 44077 | 0 | 0 | |
root | create_db | 27 | 1.19 s | 73.70 ms | 5.42 ms | 0 | 0 | 24 | 0 | |
root | insert | 36 | 1.16 s | 149.34 ms | 8.93 ms | 0 | 0 | 162 | 0 | |
root | show_tables | 1546 | 888.18 ms | 14.01 ms | 511.27 ms | 16353 | 45361 | 0 | 0 | |
root | set_option | 13685 | 863.63 ms | 6.75 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_table | 2131 | 461.69 ms | 1.76 ms | 1.70 ms | 0 | 0 | 0 | 0 | |
root | Init DB | 3529 | 211.21 ms | 438.18 us | 24.32 ms | 0 | 0 | 0 | 0 | |
root | show_grants | 1981 | 159.79 ms | 349.54 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_table_status | 241 | 144.22 ms | 39.96 ms | 65.89 ms | 40 | 453 | 0 | 0 | |
root | show_warnings | 2115 | 67.24 ms | 494.78 us | 0 ps | 0 | 0 | 0 | 0 | |
root | jump_if_not | 46030 | 37.60 ms | 1.36 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_master_status | 118 | 33.32 ms | 16.32 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Quit | 4888 | 33.02 ms | 252.70 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_status | 4 | 32.98 ms | 16.39 ms | 583.00 us | 1800 | 1800 | 0 | 4 | |
root | freturn | 16138 | 15.22 ms | 1.71 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_binlogs | 116 | 11.09 ms | 1.80 ms | 0 ps | 0 | 0 | 0 | 0 |
|