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.47 ms | 1.47 ms | 0 ps | 1 | 1 | 0 | 0 | |
manager | delete | 18 | 574.28 ms | 60.09 ms | 1.38 ms | 0 | 62 | 18 | 0 | |
manager | insert | 8 | 223.57 ms | 39.95 ms | 696.00 us | 0 | 8 | 8 | 0 | |
manager | update | 8 | 213.11 ms | 48.98 ms | 505.00 us | 0 | 49 | 7 | 0 | |
manager | show_variables | 174 | 161.50 ms | 2.59 ms | 14.66 ms | 174 | 99855 | 0 | 174 | |
manager | select | 538 | 141.41 ms | 12.95 ms | 45.19 ms | 1779 | 18243 | 0 | 146 | |
manager | show_fields | 71 | 53.96 ms | 3.20 ms | 29.67 ms | 333 | 2016 | 0 | 0 | |
manager | show_keys | 20 | 13.13 ms | 1.15 ms | 7.23 ms | 24 | 320 | 0 | 0 | |
manager | set_option | 163 | 8.65 ms | 193.33 us | 0 ps | 0 | 0 | 0 | 0 | |
manager | show_tables | 11 | 6.87 ms | 961.88 us | 4.44 ms | 56 | 238 | 0 | 0 | |
manager | Init DB | 70 | 3.66 ms | 182.09 us | 0 ps | 0 | 0 | 0 | 0 | |
manager | show_create_table | 25 | 2.72 ms | 284.34 us | 0 ps | 0 | 0 | 0 | 0 | |
manager | show_warnings | 58 | 2.71 ms | 245.63 us | 0 ps | 0 | 0 | 0 | 0 | |
manager | stmt | 46 | 1.90 ms | 174.14 us | 0 ps | 0 | 24 | 46 | 0 | |
manager | Quit | 74 | 591.28 us | 230.22 us | 0 ps | 0 | 0 | 0 | 0 | |
manager | show_slave_status | 2 | 170.25 us | 121.99 us | 0 ps | 0 | 0 | 0 | 0 | |
manager | show_master_status | 2 | 123.51 us | 89.95 us | 0 ps | 0 | 0 | 0 | 0 | |
manager | set | 24 | 103.76 us | 15.40 us | 0 ps | 0 | 0 | 0 | 0 | |
manager | show_storage_engines | 1 | 93.57 us | 93.57 us | 46.00 us | 9 | 9 | 0 | 1 | |
manager | error | 2 | 75.19 us | 41.57 us | 0 ps | 0 | 0 | 0 | 0 | |
manager | show_grants | 1 | 59.59 us | 59.59 us | 0 ps | 0 | 0 | 0 | 0 | |
manager | show_binlogs | 1 | 51.11 us | 51.11 us | 0 ps | 0 | 0 | 0 | 0 | |
manager | jump_if_not | 2 | 5.48 us | 2.78 us | 0 ps | 0 | 0 | 0 | 0 | |
pma | show_tables | 3754 | 699.03 ms | 1.68 ms | 285.50 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 3518 | 301.03 ms | 379.13 us | 106.04 ms | 0 | 0 | 0 | 0 |
|