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 | 1185 | 353.00 ms | 7.36 ms | 109.75 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 1185 | 135.88 ms | 365.07 us | 46.53 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 1187 | 8.28 ms | 29.96 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 87232 | 33.38 s | 814.40 ms | 12.15 s | 169099 | 1853089 | 0 | 12139 | |
root | show_keys | 2141 | 2.48 s | 131.84 ms | 742.44 ms | 1741 | 19103 | 0 | 0 | |
root | show_variables | 1940 | 1.71 s | 7.86 ms | 178.63 ms | 1940 | 1113518 | 0 | 1940 | |
root | show_fields | 1844 | 1.66 s | 6.80 ms | 663.64 ms | 71178 | 362043 | 0 | 0 | |
root | create_table | 6 | 1.23 s | 293.94 ms | 6.29 ms | 0 | 0 | 0 | 0 | |
root | freturn | 12045 | 726.97 ms | 709.52 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | set_option | 3970 | 311.30 ms | 7.96 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_tables | 353 | 310.29 ms | 24.58 ms | 165.19 ms | 8064 | 21805 | 0 | 0 | |
root | update | 3 | 210.18 ms | 136.68 ms | 1.49 ms | 0 | 3 | 3 | 0 | |
root | show_create_table | 934 | 194.08 ms | 1.98 ms | 107.00 us | 0 | 0 | 0 | 0 | |
root | create_db | 3 | 162.23 ms | 70.59 ms | 2.36 ms | 0 | 0 | 3 | 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 | show_grants | 867 | 63.30 ms | 344.26 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Init DB | 1188 | 61.81 ms | 1.70 ms | 2.91 ms | 0 | 0 | 0 | 0 | |
root | show_warnings | 888 | 28.95 ms | 213.98 us | 0 ps | 0 | 0 | 0 | 0 | |
root | jump_if_not | 28562 | 28.71 ms | 982.08 us | 0 ps | 0 | 0 | 0 | 0 | |
root | stmt | 16 | 12.48 ms | 7.01 ms | 0 ps | 0 | 16 | 0 | 0 | |
root | Quit | 1464 | 11.39 ms | 248.34 us | 0 ps | 0 | 0 | 0 | 0 | |
root | set | 32 | 8.14 ms | 6.97 ms | 0 ps | 0 | 16 | 0 | 0 |
|