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 | 367.64 us | 367.64 us | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 1264 | 206.83 ms | 8.01 ms | 86.62 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 1264 | 77.22 ms | 345.17 us | 27.88 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 1262 | 6.80 ms | 45.52 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 95465 | 45.09 s | 646.62 ms | 14.75 s | 176851 | 1258737 | 0 | 16536 | |
root | show_keys | 2621 | 2.72 s | 107.80 ms | 1.08 s | 1919 | 20551 | 0 | 0 | |
root | show_fields | 2160 | 2.35 s | 18.74 ms | 954.39 ms | 81748 | 415749 | 0 | 0 | |
root | show_variables | 2102 | 2.19 s | 60.53 ms | 205.99 ms | 2102 | 1206548 | 0 | 2102 | |
root | show_create_table | 1111 | 415.09 ms | 104.07 ms | 2.60 ms | 0 | 0 | 0 | 0 | |
root | show_tables | 445 | 230.61 ms | 9.39 ms | 117.07 ms | 9812 | 24126 | 0 | 0 | |
root | set_option | 4238 | 214.61 ms | 9.29 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | create_db | 2 | 101.68 ms | 51.76 ms | 3.55 ms | 0 | 0 | 2 | 0 | |
root | Init DB | 1376 | 75.69 ms | 4.26 ms | 6.40 ms | 0 | 0 | 0 | 0 | |
root | show_grants | 608 | 60.42 ms | 6.05 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | jump_if_not | 36169 | 43.09 ms | 4.50 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | freturn | 16025 | 31.14 ms | 3.52 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_warnings | 1027 | 31.06 ms | 422.92 us | 0 ps | 0 | 0 | 0 | 0 | |
root | set | 182 | 16.77 ms | 7.84 ms | 0 ps | 0 | 41 | 0 | 0 | |
root | stmt | 16 | 11.22 ms | 7.96 ms | 0 ps | 0 | 16 | 0 | 0 | |
root | Quit | 1577 | 11.20 ms | 200.91 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_table_status | 56 | 11.09 ms | 1.21 ms | 6.31 ms | 0 | 4 | 0 | 0 | |
root | show_binlogs | 15 | 10.04 ms | 2.47 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Prepare | 6 | 8.70 ms | 4.41 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_master_status | 9 | 5.49 ms | 2.82 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_slave_status | 9 | 4.55 ms | 2.57 ms | 0 ps | 0 | 0 | 0 | 0 |
|