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 | 970.54 us | 970.54 us | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 144 | 37.40 ms | 1.26 ms | 15.42 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 144 | 16.68 ms | 305.67 us | 5.63 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 142 | 1.07 ms | 23.95 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 3771 | 1.61 s | 141.38 ms | 500.56 ms | 16467 | 127272 | 0 | 1176 | |
root | show_keys | 114 | 201.83 ms | 54.45 ms | 41.33 ms | 167 | 1468 | 0 | 0 | |
root | show_fields | 183 | 175.11 ms | 3.52 ms | 68.14 ms | 7314 | 37107 | 0 | 0 | |
root | show_variables | 153 | 140.21 ms | 4.89 ms | 14.54 ms | 153 | 87780 | 0 | 153 | |
root | set_option | 439 | 59.11 ms | 6.05 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | create_db | 1 | 57.75 ms | 57.75 ms | 2.98 ms | 0 | 0 | 1 | 0 | |
root | show_tables | 70 | 42.50 ms | 4.26 ms | 23.45 ms | 1060 | 5581 | 0 | 0 | |
root | show_create_table | 84 | 16.01 ms | 1.08 ms | 703.00 us | 0 | 0 | 0 | 0 | |
root | show_grants | 98 | 8.47 ms | 255.95 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Init DB | 122 | 6.93 ms | 259.47 us | 669.00 us | 0 | 0 | 0 | 0 | |
root | show_table_status | 22 | 3.96 ms | 544.44 us | 2.43 ms | 0 | 8 | 0 | 0 | |
root | freturn | 754 | 3.94 ms | 2.89 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_storage_engines | 14 | 1.97 ms | 318.80 us | 945.00 us | 126 | 126 | 0 | 14 | |
root | show_warnings | 68 | 1.88 ms | 62.36 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_binlogs | 20 | 1.65 ms | 224.10 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Quit | 150 | 1.02 ms | 171.88 us | 0 ps | 0 | 0 | 0 | 0 | |
root | jump_if_not | 594 | 629.92 us | 253.44 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_slave_status | 5 | 363.13 us | 188.13 us | 0 ps | 0 | 0 | 0 | 0 | |
root | error | 4 | 281.13 us | 110.90 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_master_status | 5 | 226.50 us | 118.48 us | 0 ps | 0 | 0 | 0 | 0 |
|