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 | 79.14 us | 79.14 us | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 119 | 33.41 ms | 1.33 ms | 13.25 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 119 | 14.46 ms | 282.92 us | 4.89 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 117 | 848.37 us | 23.26 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 2365 | 1.42 s | 438.79 ms | 299.14 ms | 9235 | 61911 | 0 | 1258 | |
root | show_keys | 140 | 276.74 ms | 60.21 ms | 52.59 ms | 160 | 1624 | 0 | 0 | |
root | show_fields | 142 | 154.19 ms | 5.28 ms | 58.45 ms | 6080 | 30876 | 0 | 0 | |
root | show_variables | 137 | 128.81 ms | 5.18 ms | 13.77 ms | 137 | 78596 | 0 | 137 | |
root | set_option | 361 | 41.17 ms | 8.06 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_tables | 39 | 16.63 ms | 2.79 ms | 7.49 ms | 323 | 1082 | 0 | 0 | |
root | show_create_table | 70 | 14.32 ms | 1.75 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_grants | 115 | 10.21 ms | 290.63 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Init DB | 116 | 9.98 ms | 353.08 us | 2.04 ms | 0 | 0 | 0 | 0 | |
root | show_binlogs | 1 | 2.29 ms | 2.29 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_table_status | 20 | 2.06 ms | 155.21 us | 1.11 ms | 0 | 0 | 0 | 0 | |
root | show_warnings | 63 | 1.82 ms | 137.34 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Prepare | 4 | 1.61 ms | 1.13 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Quit | 129 | 921.30 us | 37.68 us | 0 ps | 0 | 0 | 0 | 0 | |
root | freturn | 30 | 717.90 us | 671.00 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Execute | 4 | 540.58 us | 234.21 us | 169.00 us | 0 | 8 | 0 | 4 | |
root | error | 7 | 323.33 us | 83.65 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_storage_engines | 3 | 288.37 us | 99.78 us | 136.00 us | 27 | 27 | 0 | 3 | |
root | jump_if_not | 198 | 160.25 us | 15.31 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Close stmt | 4 | 46.20 us | 18.62 us | 0 ps | 0 | 0 | 0 | 0 |
|