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 | 89.23 us | 89.23 us | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 470 | 84.38 ms | 1.65 ms | 35.26 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 470 | 33.72 ms | 348.20 us | 12.05 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 469 | 2.92 ms | 29.18 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 30276 | 12.06 s | 366.45 ms | 4.07 s | 62111 | 444280 | 0 | 5260 | |
root | show_keys | 712 | 830.94 ms | 69.93 ms | 251.38 ms | 604 | 6013 | 0 | 0 | |
root | show_fields | 645 | 624.65 ms | 6.19 ms | 255.14 ms | 26336 | 133771 | 0 | 0 | |
root | show_variables | 636 | 551.30 ms | 8.83 ms | 55.92 ms | 636 | 365022 | 0 | 636 | |
root | create_db | 2 | 158.83 ms | 109.45 ms | 5.33 ms | 0 | 0 | 2 | 0 | |
root | set_option | 1523 | 98.46 ms | 7.61 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_table | 323 | 74.75 ms | 5.34 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_tables | 177 | 74.43 ms | 2.84 ms | 38.19 ms | 2790 | 6663 | 0 | 0 | |
root | Init DB | 450 | 24.82 ms | 313.11 us | 3.12 ms | 0 | 0 | 0 | 0 | |
root | show_grants | 289 | 21.37 ms | 219.90 us | 0 ps | 0 | 0 | 0 | 0 | |
root | jump_if_not | 14958 | 14.96 ms | 1.93 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | freturn | 6819 | 10.10 ms | 963.21 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_warnings | 298 | 8.72 ms | 147.04 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_table_status | 20 | 4.77 ms | 1.99 ms | 3.56 ms | 0 | 4 | 0 | 0 | |
root | Quit | 563 | 3.42 ms | 147.51 us | 0 ps | 0 | 0 | 0 | 0 | |
root | error | 13 | 3.32 ms | 1.89 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_binlogs | 18 | 3.15 ms | 1.26 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | stmt | 5 | 2.45 ms | 2.05 ms | 0 ps | 0 | 5 | 0 | 0 | |
root | set | 10 | 2.31 ms | 2.01 ms | 0 ps | 0 | 5 | 0 | 0 | |
root | Prepare | 5 | 1.44 ms | 733.41 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_storage_engines | 11 | 1.21 ms | 398.24 us | 724.00 us | 99 | 99 | 0 | 11 |
|