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.89 ms | 3.89 ms | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 1531 | 301.42 ms | 1.53 ms | 122.01 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 1531 | 141.56 ms | 396.52 us | 49.39 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 1529 | 10.12 ms | 65.55 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 81266 | 32.27 s | 965.49 ms | 10.79 s | 195664 | 1827373 | 0 | 20821 | |
root | show_fields | 3210 | 3.18 s | 13.30 ms | 1.22 s | 131704 | 670603 | 0 | 0 | |
root | show_keys | 2978 | 3.16 s | 109.02 ms | 1.08 s | 3170 | 52124 | 0 | 0 | |
root | show_variables | 2929 | 2.51 s | 4.36 ms | 254.27 ms | 2927 | 1680931 | 0 | 2929 | |
root | show_tables | 1428 | 952.86 ms | 4.96 ms | 472.36 ms | 32477 | 98168 | 0 | 0 | |
root | set_option | 6284 | 459.27 ms | 45.72 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_table | 1621 | 330.08 ms | 13.00 ms | 482.00 us | 0 | 0 | 0 | 0 | |
root | create_table | 1 | 171.59 ms | 171.59 ms | 1.85 ms | 0 | 0 | 0 | 0 | |
root | Init DB | 2121 | 113.89 ms | 1.90 ms | 9.49 ms | 0 | 0 | 0 | 0 | |
root | create_db | 2 | 92.62 ms | 53.03 ms | 346.00 us | 0 | 0 | 2 | 0 | |
root | show_grants | 1183 | 91.92 ms | 693.54 us | 0 ps | 0 | 0 | 0 | 0 | |
root | grant | 2 | 83.93 ms | 43.11 ms | 1.27 ms | 0 | 0 | 0 | 0 | |
root | create_user | 1 | 45.87 ms | 45.87 ms | 4.81 ms | 0 | 0 | 0 | 0 | |
root | show_warnings | 1432 | 44.19 ms | 1.09 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | alter_user | 1 | 38.45 ms | 38.45 ms | 555.00 us | 0 | 0 | 0 | 0 | |
root | insert | 1 | 32.46 ms | 32.46 ms | 3.17 ms | 0 | 0 | 1 | 0 | |
root | Quit | 2716 | 19.00 ms | 324.82 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_table_status | 93 | 15.51 ms | 2.31 ms | 7.50 ms | 66 | 466 | 0 | 0 | |
root | show_slave_status | 12 | 7.82 ms | 6.86 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | jump_if_not | 7084 | 5.96 ms | 236.26 us | 0 ps | 0 | 0 | 0 | 0 | |
root | freturn | 1179 | 5.41 ms | 1.58 ms | 0 ps | 0 | 0 | 0 | 0 |
|