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 | 2.14 ms | 2.14 ms | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 857 | 202.12 ms | 640.03 us | 81.71 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 857 | 101.16 ms | 340.52 us | 34.55 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 860 | 6.12 ms | 24.52 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 24934 | 11.56 s | 1.25 s | 3.38 s | 84316 | 675236 | 0 | 7263 | |
root | show_keys | 813 | 1.30 s | 72.58 ms | 274.83 ms | 1051 | 13285 | 0 | 0 | |
root | show_fields | 1178 | 1.01 s | 5.65 ms | 418.27 ms | 38902 | 199282 | 0 | 0 | |
root | show_variables | 1049 | 928.24 ms | 10.23 ms | 95.04 ms | 1601 | 601979 | 0 | 1049 | |
root | create_table | 2 | 508.72 ms | 303.34 ms | 5.84 ms | 0 | 0 | 0 | 0 | |
root | set_option | 2892 | 251.58 ms | 7.91 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_tables | 402 | 219.32 ms | 3.76 ms | 113.03 ms | 6381 | 23529 | 0 | 0 | |
root | create_db | 4 | 166.87 ms | 49.50 ms | 31.77 ms | 0 | 0 | 3 | 0 | |
root | show_create_table | 468 | 80.39 ms | 1.70 ms | 155.00 us | 0 | 0 | 0 | 0 | |
root | show_grants | 747 | 59.32 ms | 857.47 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Init DB | 869 | 51.56 ms | 344.22 us | 5.10 ms | 0 | 0 | 0 | 0 | |
root | insert | 1 | 34.71 ms | 34.71 ms | 1.10 ms | 0 | 0 | 3 | 0 | |
root | show_binlogs | 181 | 15.61 ms | 1.92 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_func | 22 | 13.90 ms | 7.44 ms | 967.00 us | 0 | 0 | 0 | 0 | |
root | show_warnings | 445 | 13.70 ms | 174.89 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_proc | 27 | 11.11 ms | 5.61 ms | 1.28 ms | 0 | 0 | 0 | 0 | |
root | Quit | 1072 | 8.11 ms | 232.70 us | 0 ps | 0 | 0 | 0 | 0 | |
root | jump_if_not | 9870 | 7.62 ms | 78.49 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_table_status | 37 | 6.24 ms | 793.24 us | 4.00 ms | 0 | 8 | 0 | 0 | |
root | freturn | 2796 | 5.44 ms | 866.03 us | 0 ps | 0 | 0 | 0 | 0 | |
root | error | 53 | 4.24 ms | 1.74 ms | 0 ps | 0 | 0 | 0 | 0 |
|