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 | 4.43 ms | 4.43 ms | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 2051 | 433.49 ms | 1.56 ms | 175.72 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 2051 | 209.24 ms | 3.62 ms | 71.93 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 2052 | 13.34 ms | 39.63 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 66039 | 29.13 s | 926.75 ms | 9.13 s | 180189 | 1368974 | 0 | 19265 | |
root | show_fields | 2340 | 2.33 s | 6.84 ms | 868.95 ms | 112865 | 571906 | 0 | 0 | |
root | show_keys | 2084 | 2.30 s | 77.86 ms | 734.01 ms | 2740 | 24902 | 0 | 0 | |
root | show_variables | 2532 | 2.22 s | 16.96 ms | 224.86 ms | 56076 | 1450974 | 0 | 2532 | |
root | set_option | 6334 | 427.07 ms | 4.34 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_status | 194 | 308.56 ms | 116.28 ms | 20.98 ms | 44038 | 87300 | 0 | 194 | |
root | create_table | 1 | 280.56 ms | 280.56 ms | 5.14 ms | 0 | 0 | 0 | 0 | |
root | show_tables | 513 | 273.77 ms | 3.75 ms | 158.68 ms | 4223 | 11810 | 0 | 0 | |
root | show_create_table | 1175 | 248.20 ms | 3.94 ms | 295.00 us | 0 | 0 | 0 | 0 | |
root | Init DB | 1918 | 121.21 ms | 1.36 ms | 15.72 ms | 0 | 0 | 0 | 0 | |
root | show_grants | 1309 | 109.42 ms | 974.96 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_table_status | 576 | 84.96 ms | 2.51 ms | 48.63 ms | 1 | 61 | 0 | 0 | |
root | show_slave_status | 124 | 63.20 ms | 51.99 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | create_db | 2 | 51.38 ms | 50.96 ms | 1.38 ms | 0 | 0 | 1 | 0 | |
root | show_warnings | 1131 | 32.87 ms | 180.07 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Execute | 145 | 25.92 ms | 721.87 us | 8.11 ms | 9 | 281 | 0 | 136 | |
root | Prepare | 145 | 21.79 ms | 939.02 us | 0 ps | 0 | 0 | 0 | 0 | |
root | freturn | 9969 | 18.53 ms | 1.65 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | jump_if_not | 9853 | 16.24 ms | 6.93 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Quit | 2261 | 15.56 ms | 313.36 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_binlogs | 66 | 12.47 ms | 3.80 ms | 0 ps | 0 | 0 | 0 | 0 |
|