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.69 ms | 1.69 ms | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 1210 | 212.00 ms | 2.31 ms | 86.46 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 1210 | 95.21 ms | 1.31 ms | 33.44 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 1218 | 7.96 ms | 62.96 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 62009 | 27.34 s | 466.82 ms | 8.75 s | 148610 | 1127995 | 0 | 13135 | |
root | show_fields | 1863 | 1.86 s | 11.29 ms | 727.86 ms | 75159 | 382130 | 0 | 0 | |
root | show_variables | 1773 | 1.61 s | 7.80 ms | 158.96 ms | 2324 | 1017387 | 0 | 1773 | |
root | show_keys | 2020 | 1.55 s | 79.13 ms | 759.02 ms | 1748 | 19698 | 0 | 0 | |
root | create_table | 2 | 380.60 ms | 211.41 ms | 2.86 ms | 0 | 0 | 0 | 0 | |
root | show_tables | 392 | 280.83 ms | 12.53 ms | 150.51 ms | 8248 | 22812 | 0 | 0 | |
root | set_option | 3885 | 244.00 ms | 14.14 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_table | 986 | 217.19 ms | 10.83 ms | 236.00 us | 0 | 0 | 0 | 0 | |
root | create_db | 3 | 134.76 ms | 55.83 ms | 2.26 ms | 0 | 0 | 3 | 0 | |
root | show_grants | 914 | 80.01 ms | 8.30 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | insert | 2 | 70.86 ms | 38.77 ms | 4.83 ms | 0 | 0 | 6 | 0 | |
root | show_table_status | 40 | 60.36 ms | 47.98 ms | 8.69 ms | 37 | 266 | 0 | 0 | |
root | Init DB | 1181 | 55.16 ms | 1.11 ms | 2.65 ms | 0 | 0 | 0 | 0 | |
root | freturn | 16769 | 38.86 ms | 6.23 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_warnings | 830 | 26.17 ms | 735.49 us | 0 ps | 0 | 0 | 0 | 0 | |
root | jump_if_not | 26182 | 25.90 ms | 1.92 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_binlogs | 30 | 22.90 ms | 16.27 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_master_status | 21 | 16.71 ms | 15.96 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Quit | 1412 | 8.94 ms | 204.48 us | 0 ps | 0 | 0 | 0 | 0 | |
root | set | 166 | 7.47 ms | 1.47 ms | 0 ps | 0 | 33 | 0 | 0 | |
root | show_slave_status | 21 | 5.92 ms | 3.48 ms | 0 ps | 0 | 0 | 0 | 0 |
|