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 | 722 | 158.93 ms | 710.24 us | 63.98 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 722 | 76.30 ms | 372.97 us | 26.09 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 721 | 4.82 ms | 32.61 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 22277 | 9.53 s | 600.17 ms | 2.81 s | 64117 | 447924 | 0 | 5182 | |
root | show_keys | 820 | 1.12 s | 97.52 ms | 281.96 ms | 721 | 7478 | 0 | 0 | |
root | show_variables | 763 | 668.15 ms | 9.27 ms | 72.36 ms | 762 | 437878 | 0 | 763 | |
root | show_fields | 712 | 659.88 ms | 3.47 ms | 261.02 ms | 28042 | 142567 | 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 | 2340 | 160.36 ms | 5.02 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_tables | 182 | 131.90 ms | 3.53 ms | 70.80 ms | 3268 | 8902 | 0 | 0 | |
root | show_create_table | 368 | 74.59 ms | 2.24 ms | 157.00 us | 0 | 0 | 0 | 0 | |
root | Init DB | 499 | 28.73 ms | 2.33 ms | 1.61 ms | 0 | 0 | 0 | 0 | |
root | show_grants | 358 | 26.72 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 | 340 | 10.74 ms | 232.91 us | 0 ps | 0 | 0 | 0 | 0 | |
root | jump_if_not | 9634 | 7.32 ms | 716.80 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Quit | 837 | 7.09 ms | 259.14 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_binlogs | 18 | 6.91 ms | 5.99 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | freturn | 4662 | 5.09 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 |
|