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 | 2.54 ms | 2.54 ms | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 4502 | 815.27 ms | 1.73 ms | 331.04 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 4443 | 378.83 ms | 1.42 ms | 132.10 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 4473 | 28.15 ms | 57.19 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 231889 | 1.64 m | 381.64 ms | 31.65 s | 564599 | 4099713 | 0 | 57543 | |
root | show_fields | 9072 | 9.00 s | 6.62 ms | 3.59 s | 362471 | 1846790 | 0 | 0 | |
root | show_keys | 8883 | 8.23 s | 1.17 s | 3.34 s | 8828 | 147012 | 0 | 0 | |
root | show_variables | 8463 | 7.28 s | 8.06 ms | 734.28 ms | 9005 | 4856250 | 0 | 8463 | |
root | drop_db | 30 | 5.42 s | 1.15 s | 22.71 ms | 0 | 0 | 73 | 0 | |
root | show_tables | 4326 | 3.03 s | 7.19 ms | 1.61 s | 95933 | 275316 | 0 | 0 | |
root | create_table | 6 | 1.12 s | 324.33 ms | 4.16 ms | 0 | 0 | 0 | 0 | |
root | set_option | 18457 | 1.04 s | 5.20 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_table | 4593 | 926.08 ms | 4.84 ms | 662.00 us | 0 | 0 | 0 | 0 | |
root | Init DB | 6233 | 290.72 ms | 421.58 us | 9.42 ms | 0 | 0 | 0 | 0 | |
root | show_grants | 3467 | 275.87 ms | 1.34 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | create_db | 8 | 242.24 ms | 70.49 ms | 2.68 ms | 0 | 0 | 5 | 0 | |
root | show_table_status | 264 | 166.35 ms | 73.74 ms | 59.99 ms | 36 | 332 | 0 | 0 | |
root | show_warnings | 4005 | 122.20 ms | 432.58 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Quit | 7906 | 51.29 ms | 1.04 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_proc | 135 | 27.29 ms | 6.05 ms | 1.68 ms | 0 | 0 | 0 | 0 | |
root | jump_if_not | 22846 | 19.17 ms | 1.75 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_status | 1 | 17.45 ms | 17.45 ms | 154.00 us | 450 | 450 | 0 | 1 | |
root | show_create_func | 111 | 15.98 ms | 2.85 ms | 3.45 ms | 0 | 0 | 0 | 0 | |
root | show_binlogs | 170 | 11.37 ms | 699.04 us | 0 ps | 0 | 0 | 0 | 0 | |
root | stmt | 19 | 10.85 ms | 2.23 ms | 0 ps | 0 | 19 | 0 | 0 |
|