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 | 1.69 ms | 1.69 ms | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 2298 | 397.54 ms | 2.31 ms | 161.68 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 2298 | 177.91 ms | 1.31 ms | 62.77 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 2307 | 14.96 ms | 62.96 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 117926 | 51.47 s | 594.33 ms | 16.92 s | 287588 | 2104004 | 0 | 24883 | |
root | show_fields | 3546 | 3.61 s | 11.29 ms | 1.40 s | 144272 | 733307 | 0 | 0 | |
root | show_variables | 3371 | 3.04 s | 13.35 ms | 303.13 ms | 4474 | 1934261 | 0 | 3371 | |
root | show_keys | 3783 | 2.87 s | 79.13 ms | 1.44 s | 3478 | 37100 | 0 | 0 | |
root | show_tables | 753 | 511.94 ms | 12.53 ms | 281.82 ms | 13975 | 38087 | 0 | 0 | |
root | set_option | 7392 | 413.25 ms | 14.14 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_table | 1836 | 402.72 ms | 10.83 ms | 387.00 us | 0 | 0 | 0 | 0 | |
root | alter_table | 2 | 380.91 ms | 378.79 ms | 806.00 us | 0 | 0 | 0 | 0 | |
root | create_table | 2 | 380.60 ms | 211.41 ms | 2.86 ms | 0 | 0 | 0 | 0 | |
root | show_grants | 1734 | 146.42 ms | 8.30 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | create_db | 3 | 134.76 ms | 55.83 ms | 2.26 ms | 0 | 0 | 3 | 0 | |
root | Init DB | 2290 | 107.99 ms | 1.11 ms | 4.97 ms | 0 | 0 | 0 | 0 | |
root | insert | 3 | 99.04 ms | 38.77 ms | 5.58 ms | 0 | 0 | 7 | 0 | |
root | freturn | 29163 | 66.09 ms | 10.79 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_table_status | 66 | 64.07 ms | 47.98 ms | 10.83 ms | 37 | 271 | 0 | 0 | |
root | jump_if_not | 56820 | 53.00 ms | 1.92 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_warnings | 1583 | 48.76 ms | 735.49 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_binlogs | 61 | 28.60 ms | 16.27 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Quit | 2687 | 18.15 ms | 256.86 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_master_status | 40 | 17.47 ms | 15.96 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | stmt | 17 | 9.21 ms | 2.65 ms | 0 ps | 0 | 17 | 0 | 0 |
|