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 | 79.14 us | 79.14 us | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 1951 | 472.42 ms | 1.33 ms | 191.40 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 1951 | 233.12 ms | 428.26 us | 79.54 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 1950 | 14.30 ms | 109.25 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 75592 | 30.38 s | 954.33 ms | 9.25 s | 187692 | 1302595 | 0 | 20742 | |
root | show_keys | 2400 | 2.77 s | 73.64 ms | 834.89 ms | 2224 | 24995 | 0 | 0 | |
root | show_fields | 2346 | 2.16 s | 5.28 ms | 888.62 ms | 85865 | 437636 | 0 | 0 | |
root | show_variables | 2220 | 1.91 s | 14.58 ms | 199.83 ms | 39426 | 1272663 | 0 | 2220 | |
root | set_option | 6074 | 481.16 ms | 8.06 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_tables | 729 | 386.01 ms | 4.30 ms | 200.97 ms | 10594 | 37873 | 0 | 0 | |
root | show_create_table | 1123 | 245.44 ms | 12.56 ms | 655.00 us | 0 | 0 | 0 | 0 | |
root | show_grants | 1709 | 147.21 ms | 4.38 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Init DB | 1890 | 123.80 ms | 483.06 us | 15.74 ms | 0 | 0 | 0 | 0 | |
root | show_status | 71 | 111.97 ms | 24.80 ms | 7.68 ms | 19477 | 31955 | 0 | 71 | |
root | show_binlogs | 235 | 36.64 ms | 14.35 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_warnings | 1010 | 30.79 ms | 209.04 us | 0 ps | 0 | 0 | 0 | 0 | |
root | stmt | 15 | 22.34 ms | 21.08 ms | 0 ps | 0 | 15 | 0 | 0 | |
root | set | 30 | 21.94 ms | 21.04 ms | 0 ps | 0 | 15 | 0 | 0 | |
root | show_table_status | 200 | 21.40 ms | 646.24 us | 11.40 ms | 0 | 4 | 0 | 0 | |
root | Quit | 2176 | 18.35 ms | 2.00 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | jump_if_not | 21509 | 17.01 ms | 1.04 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | freturn | 10195 | 11.47 ms | 671.00 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_slave_status | 65 | 7.94 ms | 1.82 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Prepare | 43 | 6.61 ms | 1.13 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Execute | 43 | 6.57 ms | 622.86 us | 2.29 ms | 9 | 77 | 0 | 34 |
|