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 | 890.51 us | 890.51 us | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 4406 | 845.57 ms | 1.65 ms | 342.54 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 4406 | 393.90 ms | 411.21 us | 136.09 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 4404 | 28.67 ms | 67.81 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 198272 | 1.83 m | 994.74 ms | 26.30 s | 554866 | 7011281 | 0 | 56941 | |
root | show_fields | 9540 | 9.02 s | 8.53 ms | 3.64 s | 352294 | 1797608 | 0 | 0 | |
root | show_keys | 9628 | 7.83 s | 100.81 ms | 3.51 s | 9393 | 146746 | 0 | 0 | |
root | show_variables | 8810 | 7.50 s | 5.10 ms | 755.16 ms | 8943 | 5055764 | 0 | 8810 | |
root | alter_table | 8 | 3.27 s | 454.94 ms | 1.45 ms | 0 | 0 | 9 | 0 | |
root | show_tables | 4139 | 3.07 s | 5.43 ms | 1.59 s | 97048 | 278753 | 0 | 0 | |
root | create_table | 26 | 3.01 s | 244.34 ms | 7.24 ms | 0 | 0 | 0 | 0 | |
root | set_option | 18264 | 1.07 s | 8.33 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_table | 4887 | 936.09 ms | 9.48 ms | 866.00 us | 0 | 0 | 0 | 0 | |
root | insert | 15 | 447.40 ms | 45.99 ms | 5.56 ms | 0 | 0 | 32 | 0 | |
root | Init DB | 6469 | 302.44 ms | 409.74 us | 7.61 ms | 0 | 0 | 0 | 0 | |
root | show_grants | 3600 | 276.07 ms | 1.68 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | create_db | 5 | 216.08 ms | 60.12 ms | 968.00 us | 0 | 0 | 5 | 0 | |
root | show_warnings | 4144 | 127.20 ms | 389.58 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Quit | 7812 | 51.49 ms | 750.49 us | 0 ps | 0 | 0 | 0 | 0 | |
root | jump_if_not | 74662 | 50.18 ms | 494.31 us | 0 ps | 0 | 0 | 0 | 0 | |
root | freturn | 21123 | 32.81 ms | 1.65 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_table_status | 120 | 27.99 ms | 3.49 ms | 17.78 ms | 1 | 41 | 0 | 0 | |
root | drop_db | 1 | 19.58 ms | 19.58 ms | 48.00 us | 0 | 0 | 0 | 0 | |
root | show_binlogs | 94 | 12.21 ms | 2.37 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_func | 27 | 8.42 ms | 2.45 ms | 1.00 ms | 0 | 0 | 0 | 0 |
|