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 | 315 | 151.11 ms | 32.67 ms | 75.09 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 315 | 29.18 ms | 334.65 us | 10.07 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 314 | 1.76 ms | 22.57 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 49551 | 21.21 s | 1.06 s | 7.36 s | 71262 | 515623 | 0 | 4174 | |
root | show_keys | 787 | 1.15 s | 77.20 ms | 288.74 ms | 522 | 6766 | 0 | 0 | |
root | show_fields | 637 | 596.10 ms | 4.43 ms | 248.74 ms | 22026 | 112272 | 0 | 0 | |
root | show_variables | 609 | 552.03 ms | 10.16 ms | 52.75 ms | 608 | 349461 | 0 | 609 | |
root | show_tables | 129 | 93.30 ms | 4.14 ms | 45.86 ms | 3489 | 8460 | 0 | 0 | |
root | set_option | 1125 | 89.59 ms | 11.74 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_table | 318 | 75.16 ms | 3.89 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | create_db | 1 | 41.78 ms | 41.78 ms | 57.00 us | 0 | 0 | 1 | 0 | |
root | show_grants | 240 | 18.21 ms | 966.97 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Init DB | 385 | 17.00 ms | 286.68 us | 661.00 us | 0 | 0 | 0 | 0 | |
root | jump_if_not | 14559 | 16.59 ms | 3.36 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | freturn | 7558 | 11.11 ms | 1.02 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_warnings | 293 | 8.94 ms | 104.41 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_binlogs | 10 | 5.34 ms | 2.21 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_master_status | 2 | 3.66 ms | 2.77 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_table_status | 6 | 3.15 ms | 1.94 ms | 2.30 ms | 0 | 2 | 0 | 0 | |
root | Quit | 433 | 3.13 ms | 164.40 us | 0 ps | 0 | 0 | 0 | 0 | |
root | stmt | 7 | 2.20 ms | 839.07 us | 0 ps | 0 | 7 | 0 | 0 | |
root | set | 14 | 1.55 ms | 778.85 us | 0 ps | 0 | 7 | 0 | 0 | |
root | show_storage_engines | 5 | 1.33 ms | 834.85 us | 1.04 ms | 45 | 45 | 0 | 5 | |
root | show_slave_status | 2 | 1.12 ms | 897.10 us | 0 ps | 0 | 0 | 0 | 0 |
|