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.05 ms | 2.05 ms | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 3629 | 633.67 ms | 2.33 ms | 253.94 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 3629 | 289.56 ms | 1.12 ms | 100.42 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 3629 | 21.62 ms | 49.55 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 187929 | 1.36 m | 1.02 s | 26.28 s | 483443 | 3207448 | 0 | 41686 | |
root | show_fields | 7240 | 7.32 s | 5.65 ms | 2.89 s | 284067 | 1447686 | 0 | 0 | |
root | show_keys | 6749 | 5.83 s | 109.61 ms | 2.57 s | 7194 | 118362 | 0 | 0 | |
root | show_variables | 6452 | 5.63 s | 8.54 ms | 559.78 ms | 6450 | 3702944 | 0 | 6452 | |
root | drop_db | 34 | 5.44 s | 1.06 s | 22.22 ms | 0 | 0 | 71 | 0 | |
root | show_tables | 3253 | 1.98 s | 19.93 ms | 990.37 ms | 72726 | 221801 | 0 | 0 | |
root | create_table | 5 | 1.20 s | 427.25 ms | 11.01 ms | 0 | 0 | 0 | 0 | |
root | set_option | 15021 | 809.39 ms | 8.42 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_table | 3598 | 723.64 ms | 8.84 ms | 1.22 ms | 0 | 0 | 0 | 0 | |
root | create_db | 14 | 503.51 ms | 63.56 ms | 747.00 us | 0 | 0 | 11 | 0 | |
root | Init DB | 4854 | 245.39 ms | 533.68 us | 14.97 ms | 0 | 0 | 0 | 0 | |
root | show_grants | 2621 | 206.40 ms | 1.10 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | drop_table | 1 | 120.71 ms | 120.71 ms | 79.00 us | 0 | 0 | 0 | 0 | |
root | show_warnings | 3068 | 93.41 ms | 1.17 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | jump_if_not | 72040 | 58.69 ms | 1.01 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Quit | 6504 | 40.04 ms | 332.72 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_table_status | 202 | 35.32 ms | 1.52 ms | 19.51 ms | 66 | 489 | 0 | 0 | |
root | insert | 1 | 28.91 ms | 28.91 ms | 1.85 ms | 0 | 0 | 1 | 0 | |
root | freturn | 11691 | 23.09 ms | 529.67 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_binlogs | 162 | 17.91 ms | 4.33 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_master_status | 51 | 13.63 ms | 9.08 ms | 0 ps | 0 | 0 | 0 | 0 |
|