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 | 4339 | 759.10 ms | 2.33 ms | 304.75 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 4339 | 347.46 ms | 1.12 ms | 120.37 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 4337 | 26.07 ms | 91.63 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 223538 | 1.57 m | 1.02 s | 31.28 s | 557320 | 3680829 | 0 | 47851 | |
root | show_fields | 8553 | 8.64 s | 7.27 ms | 3.41 s | 336206 | 1713413 | 0 | 0 | |
root | show_variables | 7604 | 6.63 s | 8.54 ms | 659.46 ms | 7602 | 4364150 | 0 | 7604 | |
root | show_keys | 7926 | 6.62 s | 109.61 ms | 3.01 s | 8580 | 140486 | 0 | 0 | |
root | drop_db | 34 | 5.44 s | 1.06 s | 22.22 ms | 0 | 0 | 71 | 0 | |
root | show_tables | 3773 | 2.30 s | 19.93 ms | 1.15 s | 83765 | 257954 | 0 | 0 | |
root | create_table | 5 | 1.20 s | 427.25 ms | 11.01 ms | 0 | 0 | 0 | 0 | |
root | set_option | 17800 | 953.77 ms | 8.42 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_table | 4250 | 849.85 ms | 8.84 ms | 1.35 ms | 0 | 0 | 0 | 0 | |
root | create_db | 15 | 547.55 ms | 63.56 ms | 809.00 us | 0 | 0 | 12 | 0 | |
root | Init DB | 5747 | 292.15 ms | 533.68 us | 18.12 ms | 0 | 0 | 0 | 0 | |
root | show_grants | 3104 | 244.71 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 | 3619 | 110.82 ms | 1.17 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | jump_if_not | 82266 | 65.05 ms | 1.01 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Quit | 7653 | 47.60 ms | 332.72 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_table_status | 249 | 41.16 ms | 1.52 ms | 22.72 ms | 66 | 493 | 0 | 0 | |
root | insert | 1 | 28.91 ms | 28.91 ms | 1.85 ms | 0 | 0 | 1 | 0 | |
root | freturn | 13353 | 25.52 ms | 529.67 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_binlogs | 199 | 20.33 ms | 4.33 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_master_status | 62 | 14.00 ms | 9.08 ms | 0 ps | 0 | 0 | 0 | 0 |
|