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.77 ms | 1.77 ms | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 2742 | 659.64 ms | 828.08 us | 267.23 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 2742 | 333.28 ms | 630.92 us | 113.10 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 2746 | 22.05 ms | 63.96 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 42475 | 22.25 s | 496.17 ms | 6.00 s | 259927 | 3262151 | 0 | 15350 | |
root | alter_table | 8 | 2.32 s | 447.59 ms | 948.00 us | 0 | 0 | 0 | 0 | |
root | show_fields | 1742 | 1.75 s | 7.00 ms | 738.81 ms | 59888 | 306336 | 0 | 0 | |
root | show_variables | 1774 | 1.72 s | 25.96 ms | 165.41 ms | 2319 | 1016554 | 0 | 1774 | |
root | show_keys | 1199 | 1.63 s | 153.48 ms | 465.35 ms | 1510 | 22520 | 0 | 0 | |
root | create_table | 17 | 1.13 s | 249.15 ms | 8.95 ms | 0 | 0 | 0 | 0 | |
root | show_tables | 1368 | 1.01 s | 4.30 ms | 628.23 ms | 9430 | 41360 | 0 | 0 | |
root | set_option | 8517 | 754.70 ms | 81.97 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | create_db | 11 | 632.50 ms | 71.38 ms | 3.40 ms | 0 | 0 | 11 | 0 | |
root | truncate | 1 | 293.26 ms | 293.26 ms | 155.00 us | 0 | 0 | 0 | 0 | |
root | show_table_status | 217 | 218.84 ms | 3.28 ms | 148.49 ms | 88 | 674 | 0 | 0 | |
root | show_create_table | 819 | 190.17 ms | 4.49 ms | 8.18 ms | 0 | 0 | 0 | 0 | |
root | show_grants | 1542 | 166.18 ms | 31.35 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Init DB | 1921 | 123.49 ms | 611.91 us | 4.51 ms | 0 | 0 | 0 | 0 | |
root | grant | 3 | 105.86 ms | 40.93 ms | 1.38 ms | 0 | 0 | 0 | 0 | |
root | alter_user | 4 | 97.03 ms | 38.60 ms | 1.57 ms | 0 | 0 | 0 | 0 | |
root | insert | 5 | 93.38 ms | 40.41 ms | 2.97 ms | 0 | 0 | 5 | 0 | |
root | update | 2 | 75.47 ms | 43.58 ms | 270.00 us | 0 | 2 | 2 | 0 | |
root | drop_db | 1 | 48.52 ms | 48.52 ms | 149.00 us | 0 | 0 | 0 | 0 | |
root | revoke_all | 1 | 33.20 ms | 33.20 ms | 1.27 ms | 0 | 0 | 0 | 0 | |
root | create_user | 1 | 26.42 ms | 26.42 ms | 2.76 ms | 0 | 0 | 0 | 0 |
|