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.92 ms | 1.92 ms | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 1018 | 312.12 ms | 7.36 ms | 93.32 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 1018 | 115.53 ms | 365.07 us | 39.66 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 1020 | 7.17 ms | 28.14 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 77684 | 30.35 s | 814.40 ms | 11.02 s | 147261 | 1683672 | 0 | 10041 | |
root | show_keys | 1750 | 1.96 s | 131.58 ms | 611.09 ms | 1415 | 15358 | 0 | 0 | |
root | show_variables | 1610 | 1.45 s | 7.86 ms | 149.70 ms | 1610 | 924098 | 0 | 1610 | |
root | show_fields | 1502 | 1.36 s | 6.80 ms | 547.21 ms | 58808 | 299024 | 0 | 0 | |
root | create_table | 6 | 1.23 s | 293.94 ms | 6.29 ms | 0 | 0 | 0 | 0 | |
root | freturn | 11317 | 726.45 ms | 709.52 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_tables | 292 | 264.93 ms | 24.58 ms | 143.07 ms | 6490 | 17800 | 0 | 0 | |
root | set_option | 3385 | 264.55 ms | 7.96 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | update | 3 | 210.18 ms | 136.68 ms | 1.49 ms | 0 | 3 | 3 | 0 | |
root | create_db | 3 | 162.23 ms | 70.59 ms | 2.36 ms | 0 | 0 | 3 | 0 | |
root | show_create_table | 761 | 160.19 ms | 1.98 ms | 107.00 us | 0 | 0 | 0 | 0 | |
root | insert | 3 | 143.14 ms | 50.24 ms | 2.60 ms | 0 | 0 | 9 | 0 | |
root | delete | 4 | 135.98 ms | 64.96 ms | 1.29 ms | 0 | 7 | 6 | 0 | |
root | alter_table | 1 | 128.68 ms | 128.68 ms | 104.00 us | 0 | 0 | 0 | 0 | |
root | Init DB | 986 | 51.84 ms | 1.70 ms | 2.48 ms | 0 | 0 | 0 | 0 | |
root | show_grants | 715 | 51.64 ms | 344.26 us | 0 ps | 0 | 0 | 0 | 0 | |
root | jump_if_not | 25926 | 27.04 ms | 982.08 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_warnings | 729 | 24.31 ms | 213.98 us | 0 ps | 0 | 0 | 0 | 0 | |
root | stmt | 15 | 12.40 ms | 7.01 ms | 0 ps | 0 | 15 | 0 | 0 | |
root | Quit | 1241 | 9.57 ms | 248.34 us | 0 ps | 0 | 0 | 0 | 0 | |
root | set | 30 | 8.08 ms | 6.97 ms | 0 ps | 0 | 15 | 0 | 0 |
|