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 | 3056 | 532.09 ms | 2.33 ms | 213.51 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 3056 | 241.58 ms | 560.05 us | 84.12 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 3055 | 18.27 ms | 49.55 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 152690 | 1.15 m | 1.02 s | 21.28 s | 415891 | 2785924 | 0 | 35669 | |
root | show_fields | 6051 | 6.10 s | 5.65 ms | 2.42 s | 236562 | 1205681 | 0 | 0 | |
root | show_keys | 5627 | 5.09 s | 109.61 ms | 2.15 s | 6038 | 98933 | 0 | 0 | |
root | show_variables | 5398 | 4.72 s | 8.54 ms | 468.40 ms | 5396 | 3098011 | 0 | 5398 | |
root | show_tables | 2706 | 1.65 s | 5.49 ms | 832.20 ms | 60528 | 185196 | 0 | 0 | |
root | create_table | 4 | 1.07 s | 427.25 ms | 10.90 ms | 0 | 0 | 0 | 0 | |
root | set_option | 12611 | 684.10 ms | 8.42 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_table | 3008 | 604.51 ms | 8.84 ms | 1.04 ms | 0 | 0 | 0 | 0 | |
root | create_db | 10 | 321.80 ms | 63.56 ms | 484.00 us | 0 | 0 | 7 | 0 | |
root | Init DB | 4049 | 202.84 ms | 533.68 us | 12.18 ms | 0 | 0 | 0 | 0 | |
root | show_grants | 2184 | 172.66 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 | 2566 | 78.24 ms | 1.17 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | jump_if_not | 45978 | 40.10 ms | 1.01 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Quit | 5450 | 33.84 ms | 332.72 us | 0 ps | 0 | 0 | 0 | 0 | |
root | insert | 1 | 28.91 ms | 28.91 ms | 1.85 ms | 0 | 0 | 1 | 0 | |
root | show_table_status | 168 | 28.89 ms | 1.52 ms | 15.68 ms | 66 | 481 | 0 | 0 | |
root | freturn | 7343 | 15.02 ms | 529.67 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_master_status | 41 | 13.28 ms | 9.08 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_binlogs | 134 | 10.95 ms | 1.97 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_storage_engines | 60 | 8.79 ms | 2.13 ms | 5.25 ms | 540 | 540 | 0 | 60 |
|