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.24 ms | 1.24 ms | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 385 | 64.38 ms | 3.99 ms | 25.99 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 385 | 23.99 ms | 216.55 us | 8.68 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 382 | 2.50 ms | 33.09 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 9641 | 5.05 s | 349.60 ms | 1.45 s | 30876 | 274325 | 0 | 3565 | |
root | show_keys | 430 | 677.88 ms | 115.37 ms | 175.18 ms | 240 | 3733 | 0 | 0 | |
root | show_variables | 395 | 409.20 ms | 6.21 ms | 37.02 ms | 393 | 226625 | 0 | 395 | |
root | show_fields | 346 | 375.49 ms | 6.46 ms | 149.67 ms | 12692 | 64619 | 0 | 0 | |
root | set_option | 1224 | 141.39 ms | 80.27 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | create_db | 2 | 101.07 ms | 59.43 ms | 907.00 us | 0 | 0 | 2 | 0 | |
root | show_create_table | 179 | 53.91 ms | 2.77 ms | 66.00 us | 0 | 0 | 0 | 0 | |
root | show_tables | 132 | 40.62 ms | 1.47 ms | 21.04 ms | 1115 | 2442 | 0 | 0 | |
root | Init DB | 309 | 20.02 ms | 428.33 us | 3.73 ms | 0 | 0 | 0 | 0 | |
root | show_grants | 205 | 16.78 ms | 408.34 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_proc | 27 | 10.05 ms | 4.08 ms | 3.18 ms | 0 | 0 | 0 | 0 | |
root | freturn | 2570 | 8.19 ms | 2.00 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_func | 22 | 6.50 ms | 2.40 ms | 861.00 us | 0 | 0 | 0 | 0 | |
root | show_warnings | 172 | 5.71 ms | 81.69 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_table_status | 9 | 5.40 ms | 2.99 ms | 4.48 ms | 0 | 4 | 0 | 0 | |
root | jump_if_not | 3047 | 4.43 ms | 807.20 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_master_status | 6 | 4.22 ms | 2.12 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Quit | 428 | 3.34 ms | 211.97 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_binlogs | 11 | 3.22 ms | 1.93 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | error | 9 | 2.99 ms | 1.73 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | stmt | 3 | 1.68 ms | 1.46 ms | 0 ps | 0 | 3 | 0 | 0 |
|