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 | 89.23 us | 89.23 us | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 213 | 37.56 ms | 1.65 ms | 15.67 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 213 | 13.74 ms | 348.20 us | 4.89 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 211 | 1.27 ms | 29.18 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 12258 | 5.24 s | 366.45 ms | 1.65 s | 26378 | 192716 | 0 | 2227 | |
root | show_keys | 287 | 348.30 ms | 48.69 ms | 102.52 ms | 243 | 2249 | 0 | 0 | |
root | show_fields | 256 | 246.79 ms | 2.84 ms | 97.50 ms | 10702 | 54326 | 0 | 0 | |
root | show_variables | 254 | 236.93 ms | 8.83 ms | 24.26 ms | 254 | 145775 | 0 | 254 | |
root | set_option | 683 | 46.55 ms | 4.30 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_tables | 81 | 30.08 ms | 2.84 ms | 14.83 ms | 1237 | 3306 | 0 | 0 | |
root | show_create_table | 129 | 27.46 ms | 766.29 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Init DB | 202 | 11.63 ms | 223.42 us | 1.93 ms | 0 | 0 | 0 | 0 | |
root | show_grants | 148 | 10.75 ms | 219.90 us | 0 ps | 0 | 0 | 0 | 0 | |
root | jump_if_not | 5941 | 7.62 ms | 1.93 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | freturn | 2586 | 5.06 ms | 963.21 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_warnings | 117 | 3.44 ms | 147.04 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_table_status | 9 | 2.90 ms | 1.99 ms | 2.42 ms | 0 | 0 | 0 | 0 | |
root | show_binlogs | 14 | 2.63 ms | 1.26 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | stmt | 1 | 2.05 ms | 2.05 ms | 0 ps | 0 | 1 | 0 | 0 | |
root | set | 2 | 2.01 ms | 2.01 ms | 0 ps | 0 | 1 | 0 | 0 | |
root | Quit | 251 | 1.43 ms | 21.53 us | 0 ps | 0 | 0 | 0 | 0 | |
root | error | 5 | 995.13 us | 551.74 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Prepare | 2 | 797.16 us | 733.41 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_slave_status | 1 | 728.50 us | 728.50 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_storage_engines | 3 | 557.91 us | 398.24 us | 414.00 us | 27 | 27 | 0 | 3 |
|