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 | 142.17 us | 142.17 us | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 652 | 143.07 ms | 710.24 us | 57.54 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 652 | 68.65 ms | 372.97 us | 23.53 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 651 | 4.36 ms | 32.61 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 20975 | 9.08 s | 600.17 ms | 2.67 s | 58552 | 408224 | 0 | 4615 | |
root | show_keys | 717 | 998.49 ms | 97.52 ms | 247.33 ms | 632 | 6424 | 0 | 0 | |
root | show_variables | 681 | 600.06 ms | 9.27 ms | 64.99 ms | 680 | 390831 | 0 | 681 | |
root | show_fields | 626 | 581.89 ms | 3.47 ms | 228.93 ms | 24998 | 127040 | 0 | 0 | |
root | create_table | 3 | 427.23 ms | 236.20 ms | 2.51 ms | 0 | 0 | 0 | 0 | |
root | create_db | 4 | 175.91 ms | 71.93 ms | 2.62 ms | 0 | 0 | 3 | 0 | |
root | set_option | 2103 | 144.65 ms | 5.02 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_tables | 162 | 115.94 ms | 3.53 ms | 62.89 ms | 2866 | 7554 | 0 | 0 | |
root | show_create_table | 324 | 67.00 ms | 2.24 ms | 157.00 us | 0 | 0 | 0 | 0 | |
root | Init DB | 443 | 26.04 ms | 2.33 ms | 1.58 ms | 0 | 0 | 0 | 0 | |
root | show_grants | 316 | 23.76 ms | 272.24 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_table_status | 15 | 13.49 ms | 3.82 ms | 9.09 ms | 0 | 22 | 0 | 0 | |
root | show_warnings | 301 | 9.58 ms | 232.91 us | 0 ps | 0 | 0 | 0 | 0 | |
root | jump_if_not | 9071 | 7.00 ms | 716.80 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Quit | 749 | 6.38 ms | 259.14 us | 0 ps | 0 | 0 | 0 | 0 | |
root | freturn | 4587 | 5.00 ms | 751.47 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_binlog_events | 1 | 4.69 ms | 4.69 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | error | 10 | 3.15 ms | 2.23 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_slave_status | 20 | 1.87 ms | 455.33 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_master_status | 20 | 1.08 ms | 140.68 us | 0 ps | 0 | 0 | 0 | 0 | |
root | stmt | 5 | 1.06 ms | 711.68 us | 0 ps | 0 | 5 | 0 | 0 |
|