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.72 ms | 3.72 ms | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 3622 | 666.18 ms | 1.30 ms | 267.10 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 3622 | 309.84 ms | 564.88 us | 107.64 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 3621 | 22.48 ms | 113.04 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 264575 | 1.58 m | 638.34 ms | 37.88 s | 437067 | 2885888 | 0 | 32183 | |
root | drop_db | 33 | 6.00 s | 993.05 ms | 31.24 ms | 0 | 0 | 71 | 0 | |
root | show_keys | 5354 | 4.55 s | 126.25 ms | 1.97 s | 4070 | 45380 | 0 | 0 | |
root | show_fields | 4574 | 4.36 s | 7.10 ms | 1.80 s | 171600 | 873114 | 0 | 0 | |
root | show_variables | 4785 | 4.24 s | 8.88 ms | 415.57 ms | 6461 | 2745666 | 0 | 4785 | |
root | create_table | 6 | 1.05 s | 190.43 ms | 8.60 ms | 0 | 0 | 0 | 0 | |
root | show_tables | 1370 | 826.22 ms | 4.51 ms | 483.69 ms | 17867 | 48946 | 0 | 0 | |
root | create_db | 15 | 739.80 ms | 74.84 ms | 10.28 ms | 0 | 0 | 15 | 0 | |
root | set_option | 11682 | 659.74 ms | 8.06 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_table | 2327 | 521.99 ms | 2.78 ms | 848.00 us | 0 | 0 | 0 | 0 | |
root | insert | 10 | 420.70 ms | 71.42 ms | 2.55 ms | 0 | 0 | 10 | 0 | |
root | Init DB | 3474 | 184.74 ms | 747.69 us | 15.34 ms | 0 | 0 | 0 | 0 | |
root | update | 4 | 139.77 ms | 52.54 ms | 2.32 ms | 0 | 4 | 4 | 0 | |
root | show_grants | 1757 | 138.44 ms | 662.43 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_table_status | 173 | 67.07 ms | 2.69 ms | 44.72 ms | 0 | 140 | 0 | 0 | |
root | show_warnings | 2180 | 65.23 ms | 309.33 us | 0 ps | 0 | 0 | 0 | 0 | |
root | jump_if_not | 58623 | 52.66 ms | 1.46 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Quit | 4233 | 29.15 ms | 293.15 us | 0 ps | 0 | 0 | 0 | 0 | |
root | freturn | 25286 | 25.50 ms | 1.29 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | stmt | 40 | 18.93 ms | 2.13 ms | 0 ps | 0 | 40 | 0 | 0 | |
root | show_status | 1 | 17.79 ms | 17.79 ms | 139.00 us | 450 | 450 | 0 | 1 |
|