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 | 904.04 us | 904.04 us | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 130 | 25.76 ms | 805.58 us | 10.28 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 130 | 12.04 ms | 290.93 us | 4.19 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 129 | 842.49 us | 74.35 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 6318 | 3.59 s | 463.69 ms | 1.02 s | 18287 | 107375 | 0 | 1092 | |
root | show_keys | 80 | 674.37 ms | 146.08 ms | 31.03 ms | 137 | 2011 | 0 | 0 | |
root | show_variables | 106 | 123.54 ms | 5.34 ms | 10.58 ms | 98 | 60382 | 0 | 106 | |
root | show_fields | 116 | 119.36 ms | 10.80 ms | 48.48 ms | 3199 | 16505 | 0 | 0 | |
root | show_tables | 121 | 66.18 ms | 1.21 ms | 37.42 ms | 2227 | 13061 | 0 | 0 | |
root | show_table_status | 2 | 48.57 ms | 46.08 ms | 2.36 ms | 40 | 263 | 0 | 0 | |
root | set_option | 414 | 40.51 ms | 6.82 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_table | 54 | 18.99 ms | 5.17 ms | 788.00 us | 0 | 0 | 0 | 0 | |
root | show_grants | 129 | 12.57 ms | 1.54 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Init DB | 147 | 11.53 ms | 582.59 us | 1.85 ms | 0 | 0 | 0 | 0 | |
root | Prepare | 8 | 2.98 ms | 2.30 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_storage_engines | 13 | 1.45 ms | 307.34 us | 652.00 us | 117 | 117 | 0 | 13 | |
root | Execute | 8 | 1.08 ms | 398.72 us | 515.00 us | 1 | 17 | 0 | 8 | |
root | show_warnings | 33 | 996.81 us | 45.52 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Quit | 145 | 848.94 us | 129.54 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_binlogs | 7 | 698.64 us | 376.50 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_master_status | 2 | 683.56 us | 545.02 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_slave_status | 2 | 233.67 us | 177.95 us | 0 ps | 0 | 0 | 0 | 0 | |
root | error | 2 | 70.27 us | 37.96 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Close stmt | 8 | 45.66 us | 6.75 us | 0 ps | 0 | 0 | 0 | 0 |
|