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 | 4.50 ms | 4.50 ms | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 1284 | 366.95 ms | 8.36 ms | 134.46 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 1272 | 146.26 ms | 491.93 us | 49.85 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 1277 | 8.51 ms | 52.06 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 81840 | 30.58 s | 1.05 s | 10.38 s | 166527 | 1299623 | 0 | 13242 | |
root | show_keys | 2347 | 3.78 s | 192.62 ms | 820.62 ms | 1866 | 24397 | 0 | 0 | |
root | show_fields | 2058 | 1.84 s | 3.67 ms | 771.73 ms | 69546 | 355019 | 0 | 0 | |
root | show_variables | 1952 | 1.65 s | 8.68 ms | 177.19 ms | 1950 | 1119923 | 0 | 1952 | |
root | show_table_status | 7 | 449.85 ms | 444.74 ms | 4.30 ms | 66 | 462 | 0 | 0 | |
root | show_tables | 510 | 424.11 ms | 5.43 ms | 210.10 ms | 13679 | 38259 | 0 | 0 | |
root | set_option | 4432 | 340.45 ms | 6.40 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | create_table | 1 | 263.75 ms | 263.75 ms | 1.68 ms | 0 | 0 | 0 | 0 | |
root | show_create_table | 1019 | 201.03 ms | 2.63 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | insert | 3 | 155.14 ms | 60.41 ms | 8.94 ms | 0 | 0 | 6 | 0 | |
root | create_db | 1 | 75.75 ms | 75.75 ms | 1.74 ms | 0 | 0 | 1 | 0 | |
root | show_grants | 974 | 71.49 ms | 330.26 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Init DB | 1340 | 69.03 ms | 1.37 ms | 3.24 ms | 0 | 0 | 0 | 0 | |
root | show_warnings | 902 | 27.64 ms | 203.47 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_proc | 52 | 13.28 ms | 3.06 ms | 2.32 ms | 0 | 0 | 0 | 0 | |
root | freturn | 4061 | 13.17 ms | 7.18 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_binlogs | 44 | 12.45 ms | 3.13 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Quit | 1675 | 11.98 ms | 244.43 us | 0 ps | 0 | 0 | 0 | 0 | |
root | jump_if_not | 9660 | 10.74 ms | 602.41 us | 0 ps | 0 | 0 | 0 | 0 | |
root | stmt | 10 | 5.53 ms | 2.01 ms | 0 ps | 0 | 10 | 0 | 0 | |
root | show_create_func | 44 | 5.04 ms | 542.50 us | 723.00 us | 0 | 0 | 0 | 0 |
|