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.96 ms | 2.96 ms | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 205 | 42.52 ms | 1.58 ms | 17.25 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 205 | 20.17 ms | 712.97 us | 7.01 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 204 | 1.42 ms | 56.98 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 4133 | 2.00 s | 90.50 ms | 610.58 ms | 15410 | 109083 | 0 | 1698 | |
root | show_keys | 145 | 724.13 ms | 87.87 ms | 58.45 ms | 211 | 2661 | 0 | 0 | |
root | error | 11 | 604.48 ms | 604.11 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_fields | 191 | 209.18 ms | 6.09 ms | 81.74 ms | 7678 | 39110 | 0 | 0 | |
root | show_variables | 186 | 186.59 ms | 5.40 ms | 17.86 ms | 186 | 106764 | 0 | 186 | |
root | create_db | 1 | 101.11 ms | 101.11 ms | 251.00 us | 0 | 0 | 1 | 0 | |
root | set_option | 657 | 69.93 ms | 7.02 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_tables | 84 | 32.10 ms | 2.61 ms | 14.89 ms | 682 | 2176 | 0 | 0 | |
root | show_create_table | 93 | 21.20 ms | 1.98 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_grants | 205 | 17.07 ms | 308.29 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Init DB | 206 | 16.21 ms | 378.30 us | 3.77 ms | 0 | 0 | 0 | 0 | |
root | show_table_status | 69 | 9.86 ms | 1.50 ms | 4.55 ms | 0 | 69 | 0 | 0 | |
root | Prepare | 6 | 3.22 ms | 2.47 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_warnings | 85 | 2.55 ms | 52.91 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_binlogs | 8 | 2.41 ms | 1.87 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Quit | 242 | 1.86 ms | 242.20 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_slave_status | 2 | 1.53 ms | 1.48 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Execute | 6 | 1.47 ms | 650.57 us | 528.00 us | 0 | 12 | 0 | 6 | |
root | show_storage_engines | 1 | 1.04 ms | 1.04 ms | 857.00 us | 9 | 9 | 0 | 1 | |
root | show_master_status | 2 | 575.91 us | 546.08 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Close stmt | 6 | 83.09 us | 31.30 us | 0 ps | 0 | 0 | 0 | 0 |
|