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 | 4.22 ms | 4.22 ms | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 216 | 40.32 ms | 630.51 us | 16.30 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 216 | 17.35 ms | 271.13 us | 6.14 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 215 | 1.23 ms | 21.90 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 14602 | 8.35 s | 693.52 ms | 2.62 s | 30792 | 278481 | 0 | 3095 | |
root | show_keys | 558 | 881.93 ms | 67.31 ms | 214.74 ms | 405 | 4905 | 0 | 0 | |
root | show_fields | 471 | 483.04 ms | 10.18 ms | 195.61 ms | 16594 | 84556 | 0 | 0 | |
root | show_variables | 466 | 450.60 ms | 6.16 ms | 44.35 ms | 466 | 267484 | 0 | 466 | |
root | show_tables | 112 | 77.65 ms | 3.02 ms | 38.37 ms | 2840 | 7549 | 0 | 0 | |
root | show_create_table | 237 | 57.95 ms | 4.49 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | set_option | 814 | 55.03 ms | 3.20 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | freturn | 2335 | 25.84 ms | 20.52 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | set | 156 | 25.16 ms | 6.77 ms | 0 ps | 0 | 28 | 0 | 0 | |
root | show_grants | 201 | 20.96 ms | 5.72 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Init DB | 290 | 14.50 ms | 1.52 ms | 513.00 us | 0 | 0 | 0 | 0 | |
root | jump_if_not | 4064 | 7.73 ms | 1.18 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | stmt | 3 | 7.62 ms | 6.86 ms | 0 ps | 0 | 3 | 0 | 0 | |
root | show_warnings | 223 | 6.74 ms | 121.97 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_binlogs | 7 | 5.16 ms | 2.01 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Prepare | 1 | 3.37 ms | 3.37 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Execute | 1 | 2.93 ms | 2.93 ms | 2.84 ms | 0 | 2 | 0 | 1 | |
root | Quit | 320 | 2.42 ms | 240.12 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_table_status | 4 | 780.05 us | 368.32 us | 518.00 us | 0 | 0 | 0 | 0 | |
root | show_storage_engines | 1 | 525.86 us | 525.86 us | 478.00 us | 9 | 9 | 0 | 1 | |
root | error | 1 | 425.12 us | 425.12 us | 0 ps | 0 | 0 | 0 | 0 |
|