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 | 842.55 us | 842.55 us | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 1478 | 328.68 ms | 1.01 ms | 133.79 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 1459 | 154.69 ms | 367.32 us | 53.21 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 1482 | 10.71 ms | 118.92 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 36482 | 15.52 s | 296.37 ms | 4.86 s | 151138 | 868772 | 0 | 12027 | |
root | alter_table | 12 | 3.78 s | 536.05 ms | 3.71 ms | 0 | 0 | 20 | 0 | |
root | show_keys | 1373 | 2.77 s | 186.98 ms | 516.04 ms | 1555 | 23222 | 0 | 0 | |
root | show_variables | 1535 | 1.50 s | 25.79 ms | 146.06 ms | 2073 | 879725 | 0 | 1535 | |
root | show_fields | 1462 | 1.35 s | 4.80 ms | 563.72 ms | 48504 | 248339 | 0 | 0 | |
root | create_table | 5 | 1.20 s | 410.01 ms | 6.29 ms | 0 | 0 | 0 | 0 | |
root | show_tables | 822 | 684.39 ms | 4.62 ms | 392.47 ms | 11632 | 35679 | 0 | 0 | |
root | set_option | 5057 | 368.00 ms | 4.84 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_table | 731 | 292.75 ms | 142.21 ms | 70.00 us | 0 | 0 | 0 | 0 | |
root | create_db | 4 | 198.56 ms | 58.11 ms | 1.75 ms | 0 | 0 | 4 | 0 | |
root | insert | 5 | 196.44 ms | 59.36 ms | 2.46 ms | 0 | 0 | 21 | 0 | |
root | show_grants | 1047 | 84.08 ms | 387.64 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Init DB | 1348 | 79.80 ms | 354.50 us | 4.00 ms | 0 | 0 | 0 | 0 | |
root | show_table_status | 49 | 74.24 ms | 21.05 ms | 35.14 ms | 84 | 508 | 0 | 0 | |
root | flush | 1 | 44.54 ms | 44.54 ms | 5.25 ms | 0 | 0 | 0 | 0 | |
root | update | 1 | 31.00 ms | 31.00 ms | 238.00 us | 0 | 1 | 1 | 0 | |
root | show_warnings | 615 | 21.23 ms | 343.53 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_status | 1 | 15.24 ms | 15.24 ms | 95.00 us | 450 | 450 | 0 | 1 | |
root | Quit | 1853 | 13.73 ms | 204.08 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Execute | 50 | 10.63 ms | 553.04 us | 3.82 ms | 36 | 64 | 0 | 14 | |
root | Prepare | 50 | 9.10 ms | 947.53 us | 0 ps | 0 | 0 | 0 | 0 |
|