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 | 3.72 ms | 3.72 ms | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 1985 | 374.79 ms | 1.30 ms | 150.95 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 1985 | 173.78 ms | 366.29 us | 59.76 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 1982 | 12.56 ms | 113.04 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 125946 | 45.74 s | 638.34 ms | 17.86 s | 226291 | 1612964 | 0 | 17790 | |
root | drop_db | 33 | 6.00 s | 993.05 ms | 31.24 ms | 0 | 0 | 71 | 0 | |
root | show_keys | 2709 | 2.74 s | 126.25 ms | 990.18 ms | 2147 | 24345 | 0 | 0 | |
root | show_fields | 2367 | 2.25 s | 5.52 ms | 918.91 ms | 91154 | 463618 | 0 | 0 | |
root | show_variables | 2485 | 2.22 s | 8.88 ms | 216.25 ms | 4162 | 1425928 | 0 | 2485 | |
root | create_table | 3 | 522.91 ms | 189.11 ms | 2.98 ms | 0 | 0 | 0 | 0 | |
root | show_tables | 707 | 404.78 ms | 4.31 ms | 235.26 ms | 8124 | 21455 | 0 | 0 | |
root | set_option | 6386 | 376.34 ms | 8.06 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | create_db | 8 | 356.82 ms | 52.58 ms | 9.88 ms | 0 | 0 | 8 | 0 | |
root | show_create_table | 1202 | 272.18 ms | 2.78 ms | 188.00 us | 0 | 0 | 0 | 0 | |
root | insert | 5 | 148.39 ms | 36.54 ms | 947.00 us | 0 | 0 | 5 | 0 | |
root | Init DB | 1825 | 103.38 ms | 747.69 us | 10.56 ms | 0 | 0 | 0 | 0 | |
root | show_grants | 963 | 76.90 ms | 662.43 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_warnings | 1136 | 33.72 ms | 309.33 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_table_status | 77 | 30.09 ms | 2.14 ms | 19.84 ms | 0 | 64 | 0 | 0 | |
root | jump_if_not | 32300 | 29.74 ms | 1.46 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_status | 1 | 17.79 ms | 17.79 ms | 139.00 us | 450 | 450 | 0 | 1 | |
root | Quit | 2268 | 16.88 ms | 293.15 us | 0 ps | 0 | 0 | 0 | 0 | |
root | freturn | 14672 | 16.38 ms | 1.29 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | stmt | 21 | 10.69 ms | 2.13 ms | 0 ps | 0 | 21 | 0 | 0 | |
root | show_binlogs | 44 | 8.18 ms | 2.00 ms | 0 ps | 0 | 0 | 0 | 0 |
|