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 | 168.95 us | 168.95 us | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 2475 | 497.19 ms | 1.39 ms | 200.70 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 2475 | 233.87 ms | 498.91 us | 80.79 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 2474 | 16.52 ms | 202.39 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 69549 | 31.31 s | 309.84 ms | 8.71 s | 229145 | 3010800 | 0 | 26892 | |
root | show_fields | 4775 | 4.77 s | 6.70 ms | 1.82 s | 207018 | 1054131 | 0 | 0 | |
root | show_variables | 4155 | 3.49 s | 6.71 ms | 358.12 ms | 5832 | 2384613 | 0 | 4155 | |
root | show_keys | 3415 | 2.96 s | 64.62 ms | 1.20 s | 4543 | 75219 | 0 | 0 | |
root | show_tables | 1989 | 1.34 s | 5.15 ms | 710.86 ms | 40375 | 154756 | 0 | 0 | |
root | set_option | 9292 | 585.88 ms | 9.33 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_table | 2208 | 405.29 ms | 1.64 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Init DB | 3137 | 154.84 ms | 2.29 ms | 5.27 ms | 0 | 0 | 0 | 0 | |
root | create_db | 3 | 145.55 ms | 59.50 ms | 2.04 ms | 0 | 0 | 3 | 0 | |
root | show_grants | 1719 | 134.79 ms | 487.78 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_warnings | 1980 | 59.89 ms | 1.72 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_table_status | 69 | 33.37 ms | 2.34 ms | 22.51 ms | 0 | 62 | 0 | 0 | |
root | show_binlogs | 364 | 29.84 ms | 1.98 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Quit | 3718 | 25.62 ms | 1.26 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | jump_if_not | 17522 | 12.31 ms | 288.79 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_status | 1 | 11.49 ms | 11.49 ms | 1.27 ms | 450 | 450 | 0 | 1 | |
root | set | 160 | 8.30 ms | 568.30 us | 0 ps | 0 | 30 | 0 | 0 | |
root | freturn | 4124 | 5.67 ms | 816.50 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Prepare | 1 | 4.00 ms | 4.00 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_slave_status | 31 | 2.74 ms | 220.59 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_storage_engines | 1 | 2.09 ms | 2.09 ms | 2.04 ms | 9 | 9 | 0 | 1 |
|