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 | 536.28 us | 536.28 us | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 5733 | 869.74 ms | 3.86 ms | 358.52 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 5733 | 388.46 ms | 29.87 ms | 160.25 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 5737 | 37.14 ms | 59.90 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 179674 | 1.70 m | 858.79 ms | 28.31 s | 722691 | 5848212 | 0 | 71387 | |
root | alter_table | 65 | 28.13 s | 665.16 ms | 16.23 ms | 0 | 0 | 5175 | 0 | |
root | show_fields | 9444 | 10.60 s | 71.54 ms | 4.38 s | 337265 | 1721170 | 0 | 0 | |
root | show_variables | 9664 | 9.49 s | 6.60 ms | 931.09 ms | 11306 | 5543671 | 0 | 9664 | |
root | show_keys | 10087 | 9.40 s | 93.69 ms | 4.37 s | 9129 | 134593 | 0 | 0 | |
root | create_table | 41 | 7.17 s | 303.18 ms | 14.03 ms | 0 | 0 | 0 | 0 | |
root | show_tables | 5136 | 2.93 s | 4.08 ms | 1.56 s | 107120 | 303413 | 0 | 0 | |
root | show_create_table | 4736 | 1.39 s | 110.99 ms | 1.36 ms | 0 | 0 | 0 | 0 | |
root | insert | 33 | 1.34 s | 66.58 ms | 12.50 ms | 0 | 0 | 2972 | 0 | |
root | set_option | 23249 | 991.70 ms | 6.41 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | create_db | 19 | 620.07 ms | 67.14 ms | 2.21 ms | 0 | 0 | 15 | 0 | |
root | show_table_status | 321 | 545.47 ms | 420.40 ms | 75.58 ms | 330 | 2006 | 0 | 0 | |
root | Init DB | 7243 | 369.56 ms | 2.00 ms | 20.48 ms | 0 | 0 | 0 | 0 | |
root | show_grants | 3789 | 335.44 ms | 1.91 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | create_view | 4 | 241.50 ms | 70.38 ms | 3.29 ms | 0 | 0 | 0 | 0 | |
root | show_warnings | 4255 | 145.21 ms | 906.43 us | 0 ps | 0 | 0 | 0 | 0 | |
root | jump_if_not | 109323 | 96.85 ms | 398.91 us | 0 ps | 0 | 0 | 0 | 0 | |
root | grant | 3 | 81.54 ms | 31.59 ms | 1.91 ms | 0 | 0 | 0 | 0 | |
root | drop_db | 2 | 74.90 ms | 54.58 ms | 2.22 ms | 0 | 0 | 0 | 0 | |
root | Quit | 9791 | 67.54 ms | 1.29 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_proc | 312 | 48.80 ms | 9.94 ms | 1.82 ms | 0 | 0 | 0 | 0 |
|