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 | 536.28 us | 536.28 us | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 1344 | 202.38 ms | 1.40 ms | 83.63 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 1344 | 83.91 ms | 292.40 us | 30.08 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 1343 | 8.52 ms | 58.82 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 43452 | 22.05 s | 858.79 ms | 6.75 s | 155474 | 1649018 | 0 | 16447 | |
root | show_keys | 2167 | 2.71 s | 93.69 ms | 931.76 ms | 1906 | 28415 | 0 | 0 | |
root | alter_table | 6 | 2.47 s | 533.17 ms | 2.15 ms | 0 | 0 | 0 | 0 | |
root | show_fields | 2019 | 2.28 s | 7.41 ms | 929.13 ms | 74811 | 381426 | 0 | 0 | |
root | show_variables | 2093 | 2.08 s | 6.60 ms | 208.19 ms | 2640 | 1200773 | 0 | 2093 | |
root | create_table | 7 | 1.26 s | 224.33 ms | 2.65 ms | 0 | 0 | 0 | 0 | |
root | show_tables | 1178 | 668.03 ms | 3.49 ms | 354.74 ms | 24527 | 68655 | 0 | 0 | |
root | show_table_status | 110 | 448.40 ms | 420.40 ms | 18.94 ms | 33 | 272 | 0 | 0 | |
root | insert | 7 | 295.30 ms | 60.46 ms | 1.85 ms | 0 | 0 | 166 | 0 | |
root | set_option | 5351 | 244.65 ms | 4.06 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_table | 1028 | 242.44 ms | 5.88 ms | 232.00 us | 0 | 0 | 0 | 0 | |
root | create_db | 4 | 179.09 ms | 52.64 ms | 1.25 ms | 0 | 0 | 4 | 0 | |
root | Init DB | 1648 | 91.24 ms | 2.00 ms | 9.38 ms | 0 | 0 | 0 | 0 | |
root | show_grants | 945 | 83.84 ms | 1.70 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_warnings | 927 | 31.06 ms | 234.59 us | 0 ps | 0 | 0 | 0 | 0 | |
root | jump_if_not | 26921 | 26.33 ms | 398.91 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_proc | 78 | 25.63 ms | 9.94 ms | 1.82 ms | 0 | 0 | 0 | 0 | |
root | drop_db | 1 | 20.33 ms | 20.33 ms | 71.00 us | 0 | 0 | 0 | 0 | |
root | show_status | 1 | 15.05 ms | 15.05 ms | 172.00 us | 450 | 450 | 0 | 1 | |
root | Quit | 2239 | 14.97 ms | 200.52 us | 0 ps | 0 | 0 | 0 | 0 | |
root | freturn | 5164 | 14.63 ms | 951.16 us | 0 ps | 0 | 0 | 0 | 0 |
|