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 | 3638 | 661.15 ms | 1.73 ms | 268.68 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 3579 | 307.46 ms | 1.42 ms | 107.36 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 3609 | 22.78 ms | 39.88 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 186326 | 1.37 m | 381.64 ms | 25.23 s | 484808 | 3526325 | 0 | 48881 | |
root | show_fields | 7466 | 7.40 s | 6.07 ms | 2.95 s | 295637 | 1506589 | 0 | 0 | |
root | show_keys | 7354 | 7.20 s | 1.17 s | 2.77 s | 7295 | 121143 | 0 | 0 | |
root | show_variables | 6900 | 5.95 s | 8.06 ms | 600.64 ms | 7442 | 3959214 | 0 | 6900 | |
root | drop_db | 30 | 5.42 s | 1.15 s | 22.71 ms | 0 | 0 | 73 | 0 | |
root | show_tables | 3625 | 2.53 s | 5.72 ms | 1.34 s | 79596 | 228612 | 0 | 0 | |
root | create_table | 6 | 1.12 s | 324.33 ms | 4.16 ms | 0 | 0 | 0 | 0 | |
root | set_option | 15015 | 847.26 ms | 5.20 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_table | 3789 | 761.56 ms | 4.84 ms | 662.00 us | 0 | 0 | 0 | 0 | |
root | Init DB | 5123 | 234.88 ms | 416.20 us | 6.11 ms | 0 | 0 | 0 | 0 | |
root | show_grants | 2878 | 226.50 ms | 1.34 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | create_db | 7 | 203.72 ms | 70.49 ms | 2.62 ms | 0 | 0 | 4 | 0 | |
root | show_table_status | 154 | 146.22 ms | 73.74 ms | 48.06 ms | 36 | 314 | 0 | 0 | |
root | show_warnings | 3273 | 100.21 ms | 432.58 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Quit | 6458 | 42.29 ms | 1.04 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_proc | 108 | 24.56 ms | 6.05 ms | 1.68 ms | 0 | 0 | 0 | 0 | |
root | jump_if_not | 21033 | 17.47 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 | 89 | 14.26 ms | 2.85 ms | 3.45 ms | 0 | 0 | 0 | 0 | |
root | stmt | 18 | 10.30 ms | 2.23 ms | 0 ps | 0 | 18 | 0 | 0 | |
root | show_binlogs | 135 | 9.05 ms | 699.04 us | 0 ps | 0 | 0 | 0 | 0 |
|