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 | 3.08 ms | 3.08 ms | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 305 | 66.73 ms | 511.13 us | 27.09 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 305 | 31.74 ms | 368.07 us | 10.93 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 304 | 2.29 ms | 45.72 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 5476 | 2.99 s | 263.73 ms | 671.96 ms | 30066 | 154065 | 0 | 2636 | |
root | show_keys | 301 | 496.83 ms | 61.68 ms | 103.43 ms | 418 | 5422 | 0 | 0 | |
root | show_fields | 396 | 361.95 ms | 2.88 ms | 135.27 ms | 18264 | 92761 | 0 | 0 | |
root | show_variables | 405 | 344.27 ms | 5.93 ms | 36.05 ms | 405 | 232470 | 0 | 405 | |
root | set_option | 979 | 97.81 ms | 6.14 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_table | 195 | 35.33 ms | 1.73 ms | 407.00 us | 0 | 0 | 0 | 0 | |
root | show_tables | 76 | 27.96 ms | 2.17 ms | 15.51 ms | 345 | 942 | 0 | 0 | |
root | Init DB | 291 | 18.65 ms | 809.53 us | 2.59 ms | 0 | 0 | 0 | 0 | |
root | show_grants | 234 | 17.95 ms | 325.76 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_warnings | 184 | 5.24 ms | 117.38 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_binlogs | 42 | 2.71 ms | 117.94 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_table_status | 1 | 2.36 ms | 2.36 ms | 2.18 ms | 0 | 2 | 0 | 0 | |
root | Quit | 348 | 2.22 ms | 35.10 us | 0 ps | 0 | 0 | 0 | 0 | |
root | jump_if_not | 2187 | 2.16 ms | 403.95 us | 0 ps | 0 | 0 | 0 | 0 | |
root | freturn | 710 | 1.54 ms | 521.15 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_master_status | 6 | 1.19 ms | 744.52 us | 0 ps | 0 | 0 | 0 | 0 | |
root | stmt | 3 | 1.11 ms | 938.15 us | 0 ps | 0 | 3 | 0 | 0 | |
root | set | 6 | 1.04 ms | 905.73 us | 0 ps | 0 | 3 | 0 | 0 | |
root | show_slave_status | 6 | 782.76 us | 201.20 us | 0 ps | 0 | 0 | 0 | 0 | |
root | error | 5 | 646.76 us | 428.60 us | 0 ps | 0 | 0 | 0 | 0 |
|