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 | 1.38 ms | 1.38 ms | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 963 | 150.77 ms | 6.44 ms | 59.08 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 963 | 62.04 ms | 281.40 us | 21.78 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 960 | 5.32 ms | 41.24 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 89921 | 41.87 s | 1.01 s | 16.19 s | 155150 | 1113361 | 0 | 12311 | |
root | show_keys | 2015 | 2.74 s | 571.04 ms | 833.55 ms | 1400 | 18132 | 0 | 0 | |
root | show_fields | 1654 | 1.75 s | 9.33 ms | 717.30 ms | 58522 | 298219 | 0 | 0 | |
root | show_variables | 1573 | 1.66 s | 71.09 ms | 139.84 ms | 9989 | 902293 | 0 | 1573 | |
root | show_tables | 494 | 259.24 ms | 5.40 ms | 131.46 ms | 10409 | 26755 | 0 | 0 | |
root | show_create_table | 830 | 200.55 ms | 3.46 ms | 92.00 us | 0 | 0 | 0 | 0 | |
root | set_option | 3387 | 181.48 ms | 9.77 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | create_db | 2 | 79.86 ms | 43.73 ms | 810.00 us | 0 | 0 | 2 | 0 | |
root | show_grants | 652 | 57.58 ms | 1.61 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Init DB | 1130 | 57.53 ms | 1.99 ms | 4.71 ms | 0 | 0 | 0 | 0 | |
root | show_warnings | 752 | 26.39 ms | 1.45 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_status | 9 | 24.30 ms | 13.84 ms | 1.36 ms | 4050 | 4050 | 0 | 9 | |
root | jump_if_not | 20990 | 23.03 ms | 2.02 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_proc | 78 | 21.81 ms | 4.53 ms | 3.43 ms | 0 | 0 | 0 | 0 | |
root | show_binlogs | 43 | 21.18 ms | 12.32 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | stmt | 9 | 17.00 ms | 7.29 ms | 0 ps | 0 | 9 | 0 | 0 | |
root | freturn | 8075 | 11.38 ms | 621.24 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_table_status | 39 | 10.39 ms | 2.08 ms | 7.11 ms | 0 | 12 | 0 | 0 | |
root | show_create_func | 66 | 10.23 ms | 1.03 ms | 1.34 ms | 0 | 0 | 0 | 0 | |
root | set | 18 | 10.22 ms | 7.24 ms | 0 ps | 0 | 9 | 0 | 0 | |
root | Quit | 1311 | 8.16 ms | 216.42 us | 0 ps | 0 | 0 | 0 | 0 |
|