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 | 951.20 us | 951.20 us | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 2875 | 575.43 ms | 1.20 ms | 234.11 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 2875 | 269.99 ms | 1.30 ms | 94.61 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 2874 | 19.46 ms | 66.12 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 113011 | 51.06 s | 754.40 ms | 16.19 s | 299721 | 2420231 | 0 | 25803 | |
root | alter_table | 21 | 8.51 s | 1.02 s | 37.17 ms | 0 | 0 | 8 | 0 | |
root | create_table | 39 | 8.02 s | 359.96 ms | 155.35 ms | 0 | 0 | 0 | 0 | |
root | show_keys | 3624 | 3.91 s | 127.32 ms | 1.35 s | 3447 | 49158 | 0 | 0 | |
root | show_variables | 3628 | 3.80 s | 394.04 ms | 326.83 ms | 3627 | 2081695 | 0 | 3628 | |
root | show_fields | 3712 | 3.67 s | 12.80 ms | 1.46 s | 144902 | 738555 | 0 | 0 | |
root | set_option | 9030 | 757.63 ms | 176.19 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_tables | 1023 | 657.42 ms | 5.30 ms | 371.48 ms | 16206 | 53747 | 0 | 0 | |
root | insert | 22 | 497.16 ms | 38.20 ms | 7.50 ms | 0 | 0 | 73 | 0 | |
root | show_create_table | 2089 | 423.13 ms | 9.31 ms | 2.04 ms | 0 | 0 | 0 | 0 | |
root | create_db | 6 | 361.42 ms | 81.41 ms | 2.21 ms | 0 | 0 | 6 | 0 | |
root | show_grants | 1988 | 164.70 ms | 1.59 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Init DB | 2592 | 152.27 ms | 1.18 ms | 13.85 ms | 0 | 0 | 0 | 0 | |
root | jump_if_not | 59122 | 55.95 ms | 1.91 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_warnings | 1604 | 55.16 ms | 1.67 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | freturn | 29569 | 40.94 ms | 693.05 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_table_status | 134 | 32.81 ms | 2.43 ms | 19.53 ms | 0 | 40 | 0 | 0 | |
root | show_binlogs | 101 | 24.15 ms | 11.63 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Quit | 3230 | 22.96 ms | 324.56 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_master_status | 60 | 17.45 ms | 12.82 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | stmt | 27 | 11.75 ms | 2.09 ms | 0 ps | 0 | 27 | 0 | 0 |
|