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.22 ms | 4.22 ms | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 5028 | 888.72 ms | 9.35 ms | 362.58 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 5028 | 394.69 ms | 441.71 us | 138.78 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 5023 | 31.15 ms | 46.64 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 190486 | 1.20 m | 995.46 ms | 26.14 s | 470815 | 4436959 | 0 | 49467 | |
root | show_fields | 8503 | 8.97 s | 32.76 ms | 3.19 s | 453811 | 2296085 | 0 | 0 | |
root | show_variables | 8550 | 7.24 s | 41.03 ms | 746.40 ms | 9102 | 4907427 | 0 | 8550 | |
root | show_keys | 6689 | 5.01 s | 125.12 ms | 2.33 s | 10169 | 79347 | 0 | 0 | |
root | show_create_table | 4209 | 950.12 ms | 16.10 ms | 56.00 us | 0 | 0 | 0 | 0 | |
root | set_option | 15650 | 824.23 ms | 30.86 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_tables | 941 | 598.33 ms | 5.41 ms | 328.12 ms | 18587 | 72312 | 0 | 0 | |
root | create_table | 2 | 425.75 ms | 235.61 ms | 11.85 ms | 0 | 0 | 0 | 0 | |
root | insert | 10 | 319.54 ms | 40.11 ms | 3.00 ms | 0 | 0 | 10 | 0 | |
root | create_db | 6 | 272.17 ms | 53.52 ms | 8.44 ms | 0 | 0 | 6 | 0 | |
root | Init DB | 4748 | 219.16 ms | 1.99 ms | 3.10 ms | 0 | 0 | 0 | 0 | |
root | show_grants | 2554 | 190.62 ms | 671.96 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_warnings | 4163 | 117.97 ms | 981.42 us | 0 ps | 0 | 0 | 0 | 0 | |
root | freturn | 32631 | 57.28 ms | 1.98 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Quit | 5411 | 40.16 ms | 1.90 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | jump_if_not | 33509 | 36.31 ms | 2.56 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | stmt | 57 | 23.02 ms | 2.24 ms | 0 ps | 0 | 57 | 0 | 0 | |
root | show_table_status | 33 | 18.24 ms | 1.15 ms | 13.17 ms | 0 | 50 | 0 | 0 | |
root | show_binlogs | 214 | 17.63 ms | 654.78 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_slave_status | 33 | 5.56 ms | 2.86 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_master_status | 33 | 4.77 ms | 2.07 ms | 0 ps | 0 | 0 | 0 | 0 |
|