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 | 2.98 ms | 2.98 ms | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 181 | 38.71 ms | 564.89 us | 15.70 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 181 | 17.93 ms | 271.46 us | 6.13 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 180 | 1.35 ms | 24.99 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 2805 | 1.80 s | 316.46 ms | 375.82 ms | 14535 | 101117 | 0 | 1381 | |
root | show_keys | 81 | 443.57 ms | 79.30 ms | 32.42 ms | 87 | 1012 | 0 | 0 | |
root | show_fields | 131 | 152.78 ms | 3.49 ms | 67.58 ms | 3904 | 20066 | 0 | 0 | |
root | show_variables | 99 | 111.53 ms | 8.23 ms | 9.62 ms | 99 | 56763 | 0 | 99 | |
root | show_tables | 182 | 92.48 ms | 3.38 ms | 49.71 ms | 2058 | 11204 | 0 | 0 | |
root | set_option | 523 | 63.74 ms | 7.63 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_grants | 181 | 16.09 ms | 340.56 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Init DB | 183 | 13.99 ms | 408.51 us | 2.64 ms | 0 | 0 | 0 | 0 | |
root | show_create_table | 43 | 10.28 ms | 1.54 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_binlogs | 69 | 5.48 ms | 395.09 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_master_status | 6 | 2.91 ms | 2.53 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Quit | 212 | 1.57 ms | 148.89 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_slave_status | 6 | 1.54 ms | 1.04 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_warnings | 38 | 1.43 ms | 141.55 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_table_status | 2 | 921.45 us | 471.51 us | 728.00 us | 0 | 2 | 0 | 0 | |
root | error | 3 | 505.79 us | 268.43 us | 0 ps | 0 | 0 | 0 | 0 |
|