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 | 2581 | 447.30 ms | 2.31 ms | 182.30 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 2581 | 200.33 ms | 1.31 ms | 70.91 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 2589 | 16.78 ms | 62.96 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 132515 | 57.50 s | 594.33 ms | 18.93 s | 324461 | 2405470 | 0 | 28589 | |
root | show_fields | 4013 | 4.07 s | 11.29 ms | 1.58 s | 162684 | 826872 | 0 | 0 | |
root | show_variables | 3852 | 3.46 s | 13.35 ms | 346.38 ms | 4955 | 2210208 | 0 | 3852 | |
root | show_keys | 4324 | 3.21 s | 79.13 ms | 1.64 s | 3911 | 41490 | 0 | 0 | |
root | show_tables | 883 | 593.80 ms | 12.53 ms | 327.20 ms | 16162 | 43489 | 0 | 0 | |
root | set_option | 8343 | 461.16 ms | 14.14 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_table | 2068 | 453.02 ms | 10.83 ms | 387.00 us | 0 | 0 | 0 | 0 | |
root | alter_table | 2 | 380.91 ms | 378.79 ms | 806.00 us | 0 | 0 | 0 | 0 | |
root | create_table | 2 | 380.60 ms | 211.41 ms | 2.86 ms | 0 | 0 | 0 | 0 | |
root | show_grants | 1980 | 165.85 ms | 8.30 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | create_db | 3 | 134.76 ms | 55.83 ms | 2.26 ms | 0 | 0 | 3 | 0 | |
root | Init DB | 2617 | 123.93 ms | 1.11 ms | 5.84 ms | 0 | 0 | 0 | 0 | |
root | insert | 9 | 101.09 ms | 38.77 ms | 5.87 ms | 0 | 0 | 7 | 0 | |
root | freturn | 32926 | 71.71 ms | 10.79 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_table_status | 69 | 64.38 ms | 47.98 ms | 11.01 ms | 37 | 271 | 0 | 0 | |
root | jump_if_not | 64205 | 62.38 ms | 2.28 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_warnings | 1798 | 55.28 ms | 735.49 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_binlogs | 70 | 30.30 ms | 16.27 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Quit | 3047 | 20.59 ms | 256.86 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_master_status | 41 | 19.50 ms | 15.96 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | set | 340 | 14.10 ms | 1.47 ms | 0 ps | 0 | 70 | 0 | 0 |
|