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 | 3459 | 695.27 ms | 1.53 ms | 282.15 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 3459 | 333.59 ms | 611.31 us | 116.53 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 3461 | 22.78 ms | 65.55 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 169843 | 1.09 m | 965.49 ms | 22.25 s | 450796 | 5153405 | 0 | 46850 | |
root | show_fields | 7220 | 6.97 s | 13.30 ms | 2.72 s | 296450 | 1509449 | 0 | 0 | |
root | show_keys | 6684 | 5.76 s | 109.02 ms | 2.41 s | 7159 | 117540 | 0 | 0 | |
root | show_variables | 6716 | 5.68 s | 6.43 ms | 582.73 ms | 6713 | 3854396 | 0 | 6716 | |
root | alter_table | 8 | 3.37 s | 510.57 ms | 1.42 ms | 0 | 0 | 27 | 0 | |
root | show_tables | 3091 | 2.13 s | 5.68 ms | 1.07 s | 70515 | 212757 | 0 | 0 | |
root | create_table | 8 | 1.55 s | 235.82 ms | 6.62 ms | 0 | 0 | 0 | 0 | |
root | set_option | 14115 | 939.41 ms | 45.72 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_table | 3640 | 854.05 ms | 96.70 ms | 1.53 ms | 0 | 0 | 0 | 0 | |
root | create_db | 7 | 333.67 ms | 57.86 ms | 856.00 us | 0 | 0 | 7 | 0 | |
root | Init DB | 4730 | 247.11 ms | 1.90 ms | 18.82 ms | 0 | 0 | 0 | 0 | |
root | insert | 6 | 212.51 ms | 67.72 ms | 4.10 ms | 0 | 0 | 29 | 0 | |
root | show_grants | 2548 | 198.57 ms | 1.10 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_warnings | 3255 | 98.88 ms | 1.09 ms | 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 | Quit | 6067 | 43.53 ms | 1.09 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_table_status | 204 | 39.40 ms | 2.35 ms | 20.48 ms | 132 | 1021 | 0 | 0 | |
root | alter_user | 1 | 38.45 ms | 38.45 ms | 555.00 us | 0 | 0 | 0 | 0 | |
root | jump_if_not | 23091 | 19.78 ms | 236.26 us | 0 ps | 0 | 0 | 0 | 0 | |
root | freturn | 3857 | 11.24 ms | 1.58 ms | 0 ps | 0 | 0 | 0 | 0 |
|