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.18 ms | 1.18 ms | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 321 | 152.21 ms | 32.67 ms | 75.59 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 321 | 29.58 ms | 334.65 us | 10.22 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 320 | 1.80 ms | 22.57 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 49827 | 21.34 s | 1.06 s | 7.39 s | 71913 | 522893 | 0 | 4233 | |
root | show_keys | 807 | 1.16 s | 77.20 ms | 295.18 ms | 530 | 6917 | 0 | 0 | |
root | show_fields | 652 | 608.93 ms | 4.43 ms | 254.11 ms | 22585 | 115116 | 0 | 0 | |
root | show_variables | 623 | 563.28 ms | 10.16 ms | 53.93 ms | 622 | 357497 | 0 | 623 | |
root | show_tables | 133 | 95.03 ms | 4.14 ms | 46.69 ms | 3623 | 8734 | 0 | 0 | |
root | set_option | 1149 | 90.81 ms | 11.74 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_table | 325 | 76.46 ms | 3.89 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | create_db | 1 | 41.78 ms | 41.78 ms | 57.00 us | 0 | 0 | 1 | 0 | |
root | show_grants | 245 | 18.55 ms | 966.97 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Init DB | 393 | 17.27 ms | 286.68 us | 661.00 us | 0 | 0 | 0 | 0 | |
root | jump_if_not | 15120 | 16.91 ms | 3.36 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | freturn | 7633 | 11.48 ms | 1.02 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_warnings | 300 | 9.12 ms | 104.41 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_binlogs | 10 | 5.34 ms | 2.21 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_master_status | 2 | 3.66 ms | 2.77 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Quit | 443 | 3.21 ms | 164.40 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_table_status | 6 | 3.15 ms | 1.94 ms | 2.30 ms | 0 | 2 | 0 | 0 | |
root | stmt | 7 | 2.20 ms | 839.07 us | 0 ps | 0 | 7 | 0 | 0 | |
root | set | 14 | 1.55 ms | 778.85 us | 0 ps | 0 | 7 | 0 | 0 | |
root | show_storage_engines | 5 | 1.33 ms | 834.85 us | 1.04 ms | 45 | 45 | 0 | 5 | |
root | show_slave_status | 2 | 1.12 ms | 897.10 us | 0 ps | 0 | 0 | 0 | 0 |
|