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 | 118.07 us | 118.07 us | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 467 | 93.15 ms | 2.62 ms | 33.93 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 467 | 32.85 ms | 805.40 us | 11.61 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 466 | 2.81 ms | 24.05 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 34700 | 15.17 s | 266.49 ms | 5.31 s | 71072 | 600548 | 0 | 6165 | |
root | show_fields | 828 | 893.11 ms | 7.15 ms | 364.78 ms | 30560 | 155678 | 0 | 0 | |
root | show_keys | 987 | 830.22 ms | 72.92 ms | 417.05 ms | 734 | 10130 | 0 | 0 | |
root | show_variables | 768 | 816.59 ms | 46.36 ms | 73.32 ms | 768 | 440727 | 0 | 768 | |
root | show_tables | 233 | 149.50 ms | 3.17 ms | 84.51 ms | 4505 | 13012 | 0 | 0 | |
root | show_create_table | 426 | 114.98 ms | 3.14 ms | 554.00 us | 0 | 0 | 0 | 0 | |
root | set_option | 1612 | 101.25 ms | 4.95 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | freturn | 3325 | 37.00 ms | 14.01 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Init DB | 589 | 29.52 ms | 2.26 ms | 1.33 ms | 0 | 0 | 0 | 0 | |
root | show_grants | 271 | 24.08 ms | 1.16 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_binlogs | 18 | 13.71 ms | 5.07 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_warnings | 365 | 11.64 ms | 145.05 us | 0 ps | 0 | 0 | 0 | 0 | |
root | jump_if_not | 4290 | 11.46 ms | 4.59 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | set | 154 | 10.07 ms | 638.44 us | 0 ps | 0 | 27 | 0 | 0 | |
root | show_table_status | 14 | 9.22 ms | 2.69 ms | 5.17 ms | 33 | 244 | 0 | 0 | |
root | Quit | 609 | 4.05 ms | 183.99 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_slave_status | 6 | 3.17 ms | 2.93 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_master_status | 6 | 2.88 ms | 2.71 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Prepare | 1 | 2.46 ms | 2.46 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | stmt | 2 | 1.33 ms | 679.09 us | 0 ps | 0 | 2 | 0 | 0 | |
root | show_storage_engines | 2 | 1.15 ms | 692.46 us | 692.00 us | 18 | 18 | 0 | 2 |
|