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 | 1100 | 169.20 ms | 6.44 ms | 66.42 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 1100 | 69.79 ms | 281.40 us | 24.50 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 1097 | 6.17 ms | 41.24 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 106987 | 48.62 s | 1.01 s | 18.75 s | 182221 | 1335832 | 0 | 14024 | |
root | show_keys | 2305 | 2.94 s | 571.04 ms | 946.84 ms | 1612 | 21211 | 0 | 0 | |
root | show_fields | 1904 | 2.01 s | 9.33 ms | 824.79 ms | 67910 | 346015 | 0 | 0 | |
root | show_variables | 1821 | 1.89 s | 71.09 ms | 159.31 ms | 10237 | 1044582 | 0 | 1821 | |
root | show_tables | 560 | 295.00 ms | 5.40 ms | 151.14 ms | 11817 | 29922 | 0 | 0 | |
root | show_create_table | 954 | 232.72 ms | 3.46 ms | 92.00 us | 0 | 0 | 0 | 0 | |
root | set_option | 3863 | 198.53 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 | Init DB | 1293 | 64.88 ms | 1.99 ms | 5.03 ms | 0 | 0 | 0 | 0 | |
root | show_grants | 735 | 63.70 ms | 1.61 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_warnings | 869 | 29.89 ms | 1.45 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | jump_if_not | 25912 | 28.22 ms | 2.02 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 | show_create_proc | 104 | 23.62 ms | 4.53 ms | 3.43 ms | 0 | 0 | 0 | 0 | |
root | show_binlogs | 48 | 23.30 ms | 12.32 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | stmt | 13 | 19.71 ms | 7.29 ms | 0 ps | 0 | 13 | 0 | 0 | |
root | freturn | 10511 | 16.75 ms | 621.24 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_func | 88 | 11.83 ms | 1.03 ms | 1.34 ms | 0 | 0 | 0 | 0 | |
root | show_table_status | 43 | 11.52 ms | 2.08 ms | 7.80 ms | 0 | 14 | 0 | 0 | |
root | set | 26 | 10.48 ms | 7.24 ms | 0 ps | 0 | 13 | 0 | 0 | |
root | Quit | 1492 | 9.49 ms | 216.42 us | 0 ps | 0 | 0 | 0 | 0 |
|