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 | 2924 | 441.79 ms | 3.86 ms | 183.59 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 2924 | 183.04 ms | 313.86 us | 66.08 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 2925 | 18.93 ms | 58.82 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 89246 | 46.26 s | 858.79 ms | 14.01 s | 342967 | 3179721 | 0 | 36416 | |
root | alter_table | 25 | 11.47 s | 609.16 ms | 6.63 ms | 0 | 0 | 1725 | 0 | |
root | show_fields | 4632 | 5.22 s | 8.86 ms | 2.16 s | 168713 | 860588 | 0 | 0 | |
root | show_keys | 4922 | 5.19 s | 93.69 ms | 2.12 s | 4459 | 65007 | 0 | 0 | |
root | show_variables | 4786 | 4.74 s | 6.60 ms | 466.01 ms | 6453 | 2745841 | 0 | 4786 | |
root | create_table | 21 | 3.78 s | 303.18 ms | 8.36 ms | 0 | 0 | 0 | 0 | |
root | show_tables | 2642 | 1.51 s | 4.08 ms | 803.37 ms | 54518 | 153888 | 0 | 0 | |
root | show_create_table | 2348 | 669.74 ms | 81.74 ms | 637.00 us | 0 | 0 | 0 | 0 | |
root | insert | 15 | 609.35 ms | 60.46 ms | 5.05 ms | 0 | 0 | 1100 | 0 | |
root | set_option | 11772 | 517.09 ms | 6.41 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_table_status | 174 | 470.27 ms | 420.40 ms | 32.57 ms | 66 | 540 | 0 | 0 | |
root | create_db | 11 | 381.94 ms | 52.64 ms | 1.75 ms | 0 | 0 | 9 | 0 | |
root | Init DB | 3628 | 188.84 ms | 2.00 ms | 13.60 ms | 0 | 0 | 0 | 0 | |
root | show_grants | 1974 | 173.73 ms | 1.70 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | drop_db | 2 | 74.90 ms | 54.58 ms | 2.22 ms | 0 | 0 | 0 | 0 | |
root | show_warnings | 2114 | 70.97 ms | 456.28 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_proc | 182 | 36.07 ms | 9.94 ms | 1.82 ms | 0 | 0 | 0 | 0 | |
root | jump_if_not | 37782 | 35.47 ms | 398.91 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Quit | 4971 | 34.29 ms | 240.14 us | 0 ps | 0 | 0 | 0 | 0 | |
root | freturn | 7724 | 19.09 ms | 951.16 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_func | 154 | 16.86 ms | 656.37 us | 1.80 ms | 0 | 0 | 0 | 0 |
|