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 | 970.54 us | 970.54 us | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 29 | 9.29 ms | 1.26 ms | 4.53 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 29 | 3.66 ms | 305.67 us | 1.24 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 28 | 198.88 us | 21.02 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 552 | 315.74 ms | 67.98 ms | 77.18 ms | 4922 | 23740 | 0 | 288 | |
root | show_keys | 23 | 92.57 ms | 29.61 ms | 9.96 ms | 40 | 390 | 0 | 0 | |
root | show_fields | 44 | 39.42 ms | 3.52 ms | 15.20 ms | 1514 | 7672 | 0 | 0 | |
root | show_variables | 32 | 36.41 ms | 4.89 ms | 3.19 ms | 32 | 18368 | 0 | 32 | |
root | set_option | 90 | 12.36 ms | 4.39 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_tables | 4 | 5.11 ms | 4.26 ms | 2.30 ms | 67 | 137 | 0 | 0 | |
root | show_create_table | 22 | 4.40 ms | 1.08 ms | 350.00 us | 0 | 0 | 0 | 0 | |
root | show_grants | 22 | 1.85 ms | 245.67 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Init DB | 22 | 1.19 ms | 144.42 us | 191.00 us | 0 | 0 | 0 | 0 | |
root | show_table_status | 9 | 948.72 us | 165.24 us | 505.00 us | 0 | 0 | 0 | 0 | |
root | show_storage_engines | 7 | 932.94 us | 318.80 us | 460.00 us | 63 | 63 | 0 | 7 | |
root | show_warnings | 14 | 409.94 us | 62.36 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Quit | 30 | 169.01 us | 21.07 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_binlogs | 3 | 164.90 us | 61.51 us | 0 ps | 0 | 0 | 0 | 0 |
|