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 | 4.43 ms | 4.43 ms | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 2666 | 545.64 ms | 1.56 ms | 221.26 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 2666 | 261.51 ms | 3.62 ms | 90.13 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 2666 | 17.02 ms | 39.63 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 101301 | 43.37 s | 926.75 ms | 14.08 s | 248625 | 1913424 | 0 | 26253 | |
root | show_fields | 3376 | 3.41 s | 6.84 ms | 1.26 s | 166223 | 841918 | 0 | 0 | |
root | show_variables | 3597 | 3.11 s | 16.96 ms | 316.32 ms | 65973 | 2061948 | 0 | 3597 | |
root | show_keys | 3015 | 2.92 s | 77.86 ms | 1.06 s | 3903 | 34274 | 0 | 0 | |
root | set_option | 8216 | 526.47 ms | 4.34 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_table | 1703 | 363.98 ms | 3.94 ms | 295.00 us | 0 | 0 | 0 | 0 | |
root | show_status | 226 | 331.99 ms | 116.28 ms | 23.32 ms | 51302 | 101700 | 0 | 226 | |
root | show_tables | 625 | 330.20 ms | 3.75 ms | 186.15 ms | 6330 | 17025 | 0 | 0 | |
root | create_table | 1 | 280.56 ms | 280.56 ms | 5.14 ms | 0 | 0 | 0 | 0 | |
root | Init DB | 2559 | 153.20 ms | 1.36 ms | 18.34 ms | 0 | 0 | 0 | 0 | |
root | show_grants | 1576 | 129.12 ms | 974.96 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_table_status | 691 | 97.45 ms | 2.51 ms | 55.23 ms | 1 | 64 | 0 | 0 | |
root | show_slave_status | 140 | 64.22 ms | 51.99 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | create_db | 2 | 51.38 ms | 50.96 ms | 1.38 ms | 0 | 0 | 1 | 0 | |
root | show_warnings | 1651 | 48.05 ms | 188.44 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Execute | 161 | 27.71 ms | 721.87 us | 8.67 ms | 9 | 313 | 0 | 152 | |
root | freturn | 14170 | 24.73 ms | 1.65 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Prepare | 161 | 23.32 ms | 939.02 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Quit | 2963 | 20.29 ms | 313.36 us | 0 ps | 0 | 0 | 0 | 0 | |
root | jump_if_not | 13063 | 18.47 ms | 6.93 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_binlogs | 75 | 13.21 ms | 3.80 ms | 0 ps | 0 | 0 | 0 | 0 |
|