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 | 105.96 us | 105.96 us | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 991 | 161.24 ms | 1.77 ms | 64.84 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 991 | 71.32 ms | 770.46 us | 24.88 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 990 | 5.76 ms | 264.75 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 115460 | 42.14 s | 203.75 ms | 17.52 s | 196218 | 1499790 | 0 | 12325 | |
root | show_fields | 1765 | 1.81 s | 5.22 ms | 726.89 ms | 62765 | 319986 | 0 | 0 | |
root | show_variables | 1609 | 1.50 s | 9.92 ms | 138.89 ms | 2160 | 923251 | 0 | 1609 | |
root | show_keys | 2097 | 1.50 s | 68.68 ms | 823.78 ms | 1650 | 21592 | 0 | 0 | |
root | show_tables | 510 | 310.13 ms | 4.88 ms | 167.04 ms | 9242 | 23997 | 0 | 0 | |
root | show_create_table | 907 | 214.16 ms | 4.84 ms | 2.05 ms | 0 | 0 | 0 | 0 | |
root | create_table | 1 | 207.55 ms | 207.55 ms | 2.48 ms | 0 | 0 | 0 | 0 | |
root | set_option | 3465 | 184.61 ms | 4.87 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Init DB | 1191 | 54.87 ms | 434.79 us | 2.66 ms | 0 | 0 | 0 | 0 | |
root | show_grants | 645 | 51.50 ms | 1.11 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | create_db | 1 | 48.52 ms | 48.52 ms | 2.14 ms | 0 | 0 | 1 | 0 | |
root | show_warnings | 770 | 24.23 ms | 1.17 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_status | 1 | 24.08 ms | 24.08 ms | 137.00 us | 450 | 450 | 0 | 1 | |
root | show_table_status | 27 | 14.05 ms | 2.58 ms | 10.55 ms | 0 | 28 | 0 | 0 | |
root | jump_if_not | 14631 | 13.52 ms | 391.34 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Quit | 1328 | 9.77 ms | 199.00 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_proc | 26 | 9.08 ms | 1.61 ms | 2.48 ms | 0 | 0 | 0 | 0 | |
root | freturn | 6079 | 7.92 ms | 1.11 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_binlogs | 20 | 7.65 ms | 4.79 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_func | 22 | 3.68 ms | 288.66 us | 1.06 ms | 0 | 0 | 0 | 0 | |
root | show_storage_engines | 12 | 3.17 ms | 1.88 ms | 2.62 ms | 108 | 108 | 0 | 12 |
|