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 | 3.36 ms | 3.36 ms | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 1979 | 467.66 ms | 2.12 ms | 189.62 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 1979 | 228.27 ms | 366.38 us | 78.08 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 1979 | 14.30 ms | 40.48 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 46874 | 23.30 s | 566.16 ms | 6.40 s | 175161 | 1304384 | 0 | 14105 | |
root | drop_db | 32 | 7.49 s | 1.96 s | 36.22 ms | 0 | 0 | 79 | 0 | |
root | create_table | 22 | 4.26 s | 521.30 ms | 12.82 ms | 0 | 0 | 0 | 0 | |
root | show_keys | 2076 | 2.51 s | 110.09 ms | 773.02 ms | 1250 | 18914 | 0 | 0 | |
root | show_variables | 1790 | 1.88 s | 197.86 ms | 169.97 ms | 3446 | 1024940 | 0 | 1790 | |
root | show_fields | 1860 | 1.60 s | 8.29 ms | 731.52 ms | 42410 | 218743 | 0 | 0 | |
root | insert | 21 | 754.42 ms | 67.62 ms | 10.00 ms | 0 | 0 | 33 | 0 | |
root | Init DB | 1845 | 740.01 ms | 618.33 ms | 626.83 ms | 0 | 0 | 0 | 0 | |
root | create_db | 14 | 588.63 ms | 75.66 ms | 3.62 ms | 0 | 0 | 11 | 0 | |
root | show_tables | 854 | 545.48 ms | 3.65 ms | 312.16 ms | 10309 | 32557 | 0 | 0 | |
root | set_option | 6185 | 500.66 ms | 9.08 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_table_status | 95 | 213.56 ms | 82.32 ms | 43.87 ms | 186 | 1156 | 0 | 0 | |
root | show_create_table | 889 | 199.39 ms | 3.27 ms | 689.00 us | 0 | 0 | 0 | 0 | |
root | jump_if_not | 260433 | 180.47 ms | 847.71 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_grants | 1523 | 127.94 ms | 456.30 us | 0 ps | 0 | 0 | 0 | 0 | |
root | freturn | 58730 | 72.37 ms | 6.42 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_warnings | 652 | 23.83 ms | 289.20 us | 0 ps | 0 | 0 | 0 | 0 | |
root | set | 334 | 23.65 ms | 10.47 ms | 0 ps | 0 | 67 | 0 | 0 | |
root | Quit | 2328 | 16.61 ms | 205.62 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_binlogs | 133 | 13.73 ms | 2.76 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | stmt | 17 | 12.19 ms | 10.52 ms | 0 ps | 0 | 17 | 0 | 0 |
|