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.69 ms | 1.69 ms | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 1074 | 188.40 ms | 2.31 ms | 76.73 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 1074 | 84.50 ms | 1.31 ms | 29.77 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 1079 | 7.01 ms | 30.73 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 53423 | 22.55 s | 462.35 ms | 7.54 s | 128689 | 992395 | 0 | 11515 | |
root | show_fields | 1632 | 1.65 s | 11.29 ms | 645.36 ms | 67413 | 342633 | 0 | 0 | |
root | show_variables | 1554 | 1.41 s | 7.80 ms | 139.17 ms | 2105 | 891765 | 0 | 1554 | |
root | show_keys | 1729 | 1.34 s | 79.13 ms | 650.48 ms | 1544 | 17409 | 0 | 0 | |
root | show_tables | 343 | 242.05 ms | 12.53 ms | 131.05 ms | 6966 | 19368 | 0 | 0 | |
root | set_option | 3443 | 216.01 ms | 14.14 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | create_table | 1 | 211.41 ms | 211.41 ms | 2.75 ms | 0 | 0 | 0 | 0 | |
root | show_create_table | 872 | 194.60 ms | 10.83 ms | 236.00 us | 0 | 0 | 0 | 0 | |
root | create_db | 3 | 134.76 ms | 55.83 ms | 2.26 ms | 0 | 0 | 3 | 0 | |
root | insert | 2 | 70.86 ms | 38.77 ms | 4.83 ms | 0 | 0 | 6 | 0 | |
root | show_grants | 794 | 69.55 ms | 8.30 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Init DB | 1034 | 48.56 ms | 1.11 ms | 2.43 ms | 0 | 0 | 0 | 0 | |
root | freturn | 14746 | 35.92 ms | 6.23 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_warnings | 729 | 23.00 ms | 735.49 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_binlogs | 28 | 22.72 ms | 16.27 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | jump_if_not | 15815 | 18.20 ms | 1.92 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_master_status | 20 | 16.67 ms | 15.96 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_table_status | 34 | 11.85 ms | 2.65 ms | 7.89 ms | 4 | 36 | 0 | 0 | |
root | Quit | 1245 | 8.09 ms | 204.48 us | 0 ps | 0 | 0 | 0 | 0 | |
root | set | 162 | 7.35 ms | 1.47 ms | 0 ps | 0 | 31 | 0 | 0 | |
root | show_slave_status | 20 | 5.87 ms | 3.48 ms | 0 ps | 0 | 0 | 0 | 0 |
|