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 | 4.65 ms | 4.65 ms | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 253 | 59.44 ms | 7.36 ms | 19.50 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 253 | 19.37 ms | 290.37 us | 6.76 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 250 | 1.58 ms | 29.82 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 31441 | 15.02 s | 1.11 s | 4.72 s | 47400 | 357296 | 0 | 3022 | |
root | show_keys | 451 | 634.67 ms | 57.03 ms | 174.77 ms | 297 | 3642 | 0 | 0 | |
root | show_fields | 368 | 380.33 ms | 3.75 ms | 148.24 ms | 13982 | 71114 | 0 | 0 | |
root | show_variables | 373 | 362.05 ms | 7.27 ms | 35.48 ms | 925 | 214060 | 0 | 373 | |
root | set_option | 787 | 59.92 ms | 6.59 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_table | 185 | 53.05 ms | 2.46 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_tables | 88 | 35.97 ms | 2.86 ms | 17.70 ms | 1371 | 3451 | 0 | 0 | |
root | Init DB | 254 | 14.44 ms | 370.08 us | 1.94 ms | 0 | 0 | 0 | 0 | |
root | show_grants | 147 | 12.74 ms | 654.70 us | 0 ps | 0 | 0 | 0 | 0 | |
root | freturn | 4053 | 9.33 ms | 2.16 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | jump_if_not | 5955 | 7.82 ms | 1.47 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_warnings | 179 | 5.61 ms | 148.71 us | 0 ps | 0 | 0 | 0 | 0 | |
root | stmt | 4 | 2.76 ms | 2.38 ms | 0 ps | 0 | 4 | 0 | 0 | |
root | show_table_status | 2 | 2.75 ms | 2.55 ms | 2.65 ms | 0 | 0 | 0 | 0 | |
root | show_binlogs | 11 | 2.73 ms | 1.13 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | set | 8 | 2.61 ms | 2.33 ms | 0 ps | 0 | 4 | 0 | 0 | |
root | show_slave_status | 2 | 1.94 ms | 1.50 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Quit | 294 | 1.88 ms | 146.82 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_master_status | 2 | 1.22 ms | 698.72 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Prepare | 1 | 1.07 ms | 1.07 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Execute | 1 | 490.67 us | 490.67 us | 380.00 us | 0 | 2 | 0 | 1 |
|