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.24 ms | 1.24 ms | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 1131 | 211.84 ms | 3.99 ms | 87.11 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 1010 | 90.13 ms | 2.81 ms | 32.96 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 1068 | 7.24 ms | 54.76 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 36022 | 15.45 s | 374.48 ms | 5.12 s | 103131 | 820923 | 0 | 9879 | |
root | alter_table | 5 | 2.27 s | 1.35 s | 1.65 ms | 0 | 0 | 0 | 0 | |
root | show_keys | 1170 | 1.32 s | 115.37 ms | 470.42 ms | 710 | 9143 | 0 | 0 | |
root | show_variables | 1059 | 990.38 ms | 6.21 ms | 94.50 ms | 1057 | 607509 | 0 | 1059 | |
root | show_fields | 949 | 967.41 ms | 26.99 ms | 401.61 ms | 34124 | 173749 | 0 | 0 | |
root | create_table | 3 | 612.40 ms | 285.78 ms | 3.91 ms | 0 | 0 | 0 | 0 | |
root | create_db | 7 | 325.83 ms | 59.43 ms | 1.43 ms | 0 | 0 | 7 | 0 | |
root | set_option | 3425 | 288.45 ms | 80.27 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_table_status | 49 | 221.77 ms | 192.90 ms | 20.84 ms | 23 | 149 | 0 | 0 | |
root | show_tables | 391 | 219.94 ms | 4.63 ms | 127.82 ms | 4323 | 12195 | 0 | 0 | |
root | show_create_table | 479 | 120.58 ms | 2.77 ms | 603.00 us | 0 | 0 | 0 | 0 | |
root | grant | 2 | 73.55 ms | 45.80 ms | 940.00 us | 0 | 0 | 0 | 0 | |
root | Init DB | 828 | 49.18 ms | 428.33 us | 5.87 ms | 0 | 0 | 0 | 0 | |
root | alter_user | 1 | 40.09 ms | 40.09 ms | 490.00 us | 0 | 0 | 0 | 0 | |
root | show_grants | 435 | 37.36 ms | 769.80 us | 0 ps | 0 | 0 | 0 | 0 | |
root | create_user | 1 | 36.53 ms | 36.53 ms | 2.67 ms | 0 | 0 | 0 | 0 | |
root | show_warnings | 456 | 14.83 ms | 170.40 us | 0 ps | 0 | 0 | 0 | 0 | |
root | jump_if_not | 14240 | 13.81 ms | 807.20 us | 0 ps | 0 | 0 | 0 | 0 | |
root | freturn | 7566 | 13.39 ms | 2.00 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_proc | 54 | 12.96 ms | 4.08 ms | 3.18 ms | 0 | 0 | 0 | 0 | |
root | Quit | 1211 | 8.80 ms | 211.97 us | 0 ps | 0 | 0 | 0 | 0 |
|