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.56 ms | 4.56 ms | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 2230 | 439.54 ms | 2.09 ms | 177.70 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 2230 | 211.41 ms | 1.33 ms | 72.51 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 2232 | 14.56 ms | 95.22 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 101324 | 40.41 s | 794.64 ms | 13.89 s | 244641 | 2130962 | 0 | 22731 | |
root | drop_db | 31 | 5.85 s | 1.04 s | 25.94 ms | 0 | 0 | 80 | 0 | |
root | alter_table | 14 | 5.59 s | 568.71 ms | 2.53 ms | 0 | 0 | 25 | 0 | |
root | show_fields | 3543 | 3.45 s | 6.21 ms | 1.36 s | 139401 | 710230 | 0 | 0 | |
root | show_variables | 3567 | 3.14 s | 7.86 ms | 312.56 ms | 4113 | 2046954 | 0 | 3567 | |
root | create_table | 14 | 3.14 s | 447.50 ms | 9.48 ms | 0 | 0 | 0 | 0 | |
root | show_keys | 3475 | 3.00 s | 81.34 ms | 1.29 s | 3366 | 54426 | 0 | 0 | |
root | show_create_table | 1789 | 1.65 s | 998.46 ms | 999.20 ms | 0 | 0 | 0 | 0 | |
root | show_tables | 1641 | 1.15 s | 4.69 ms | 594.42 ms | 37532 | 105790 | 0 | 0 | |
root | create_db | 12 | 728.12 ms | 168.07 ms | 3.53 ms | 0 | 0 | 12 | 0 | |
root | set_option | 8584 | 531.66 ms | 7.84 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Init DB | 2653 | 145.78 ms | 429.51 us | 13.34 ms | 0 | 0 | 0 | 0 | |
root | insert | 5 | 120.18 ms | 34.89 ms | 1.78 ms | 0 | 0 | 25 | 0 | |
root | show_grants | 1430 | 113.65 ms | 854.82 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_binlogs | 83 | 63.95 ms | 56.16 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_table_status | 283 | 55.66 ms | 3.04 ms | 34.43 ms | 0 | 52 | 0 | 0 | |
root | show_warnings | 1631 | 52.78 ms | 1.20 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Quit | 3555 | 30.59 ms | 3.83 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_status | 1 | 25.31 ms | 25.31 ms | 460.00 us | 450 | 450 | 0 | 1 | |
root | jump_if_not | 32724 | 24.90 ms | 1.76 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_proc | 27 | 12.81 ms | 2.94 ms | 2.54 ms | 0 | 0 | 0 | 0 |
|