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.38 ms | 1.38 ms | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 660 | 102.80 ms | 6.44 ms | 39.46 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 660 | 40.85 ms | 281.40 us | 14.40 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 657 | 3.55 ms | 41.24 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 63583 | 31.97 s | 1.01 s | 12.40 s | 108473 | 750876 | 0 | 8376 | |
root | show_keys | 1401 | 2.31 s | 571.04 ms | 604.29 ms | 941 | 12195 | 0 | 0 | |
root | show_fields | 1139 | 1.26 s | 9.33 ms | 519.99 ms | 39741 | 202559 | 0 | 0 | |
root | show_variables | 1079 | 1.22 s | 71.09 ms | 97.42 ms | 8391 | 618821 | 0 | 1079 | |
root | show_tables | 365 | 179.39 ms | 2.75 ms | 88.51 ms | 7996 | 20572 | 0 | 0 | |
root | show_create_table | 568 | 145.62 ms | 3.46 ms | 92.00 us | 0 | 0 | 0 | 0 | |
root | set_option | 2360 | 131.08 ms | 9.77 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | create_db | 1 | 43.73 ms | 43.73 ms | 737.00 us | 0 | 0 | 1 | 0 | |
root | show_grants | 473 | 42.79 ms | 1.61 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Init DB | 786 | 41.95 ms | 1.99 ms | 3.88 ms | 0 | 0 | 0 | 0 | |
root | show_binlogs | 37 | 20.81 ms | 12.32 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_warnings | 514 | 19.68 ms | 1.45 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_proc | 52 | 17.56 ms | 4.53 ms | 3.43 ms | 0 | 0 | 0 | 0 | |
root | jump_if_not | 14141 | 14.88 ms | 492.64 us | 0 ps | 0 | 0 | 0 | 0 | |
root | stmt | 6 | 10.16 ms | 7.29 ms | 0 ps | 0 | 6 | 0 | 0 | |
root | show_status | 7 | 9.93 ms | 5.10 ms | 1.13 ms | 3150 | 3150 | 0 | 7 | |
root | set | 12 | 9.75 ms | 7.24 ms | 0 ps | 0 | 6 | 0 | 0 | |
root | show_create_func | 44 | 8.55 ms | 1.03 ms | 1.34 ms | 0 | 0 | 0 | 0 | |
root | show_table_status | 30 | 6.92 ms | 2.08 ms | 4.89 ms | 0 | 4 | 0 | 0 | |
root | Quit | 927 | 5.94 ms | 216.42 us | 0 ps | 0 | 0 | 0 | 0 | |
root | freturn | 4380 | 5.91 ms | 621.24 us | 0 ps | 0 | 0 | 0 | 0 |
|