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 | 2.21 ms | 2.21 ms | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 5329 | 1.15 s | 1.38 ms | 464.55 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 5329 | 553.72 ms | 601.77 us | 190.13 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 5336 | 38.12 ms | 180.88 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 120849 | 53.95 s | 811.05 ms | 18.00 s | 447878 | 3190600 | 0 | 30867 | |
root | alter_table | 68 | 21.04 s | 703.19 ms | 18.66 ms | 0 | 0 | 87 | 0 | |
root | create_table | 48 | 6.26 s | 394.62 ms | 16.97 ms | 0 | 0 | 0 | 0 | |
root | show_keys | 3175 | 4.21 s | 91.22 ms | 1.26 s | 3433 | 40578 | 0 | 0 | |
root | show_variables | 4042 | 3.97 s | 22.32 ms | 372.93 ms | 4577 | 2317441 | 0 | 4042 | |
root | show_fields | 3452 | 3.37 s | 6.60 ms | 1.38 s | 129411 | 659153 | 0 | 0 | |
root | insert | 45 | 1.27 s | 122.97 ms | 10.32 ms | 0 | 0 | 100 | 0 | |
root | create_db | 30 | 1.14 s | 79.36 ms | 4.72 ms | 0 | 0 | 22 | 0 | |
root | set_option | 16470 | 1.11 s | 8.50 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_tables | 1524 | 1.11 s | 4.87 ms | 698.02 ms | 11437 | 33683 | 0 | 0 | |
root | show_create_table | 1700 | 664.28 ms | 269.16 ms | 6.59 ms | 0 | 0 | 0 | 0 | |
root | create_trigger | 4 | 224.08 ms | 73.02 ms | 4.90 ms | 0 | 0 | 0 | 0 | |
root | Init DB | 3324 | 199.14 ms | 414.62 us | 9.89 ms | 0 | 0 | 0 | 0 | |
root | show_grants | 2068 | 170.77 ms | 779.46 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_table_status | 142 | 127.23 ms | 3.63 ms | 85.00 ms | 94 | 754 | 0 | 0 | |
root | rename_table | 1 | 110.47 ms | 110.47 ms | 2.17 ms | 0 | 0 | 0 | 0 | |
root | drop_db | 2 | 104.22 ms | 65.44 ms | 292.00 us | 0 | 0 | 0 | 0 | |
root | show_warnings | 1580 | 55.54 ms | 872.00 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Quit | 5624 | 43.85 ms | 309.28 us | 0 ps | 0 | 0 | 0 | 0 | |
root | jump_if_not | 36486 | 31.24 ms | 796.30 us | 0 ps | 0 | 0 | 0 | 0 | |
root | freturn | 17625 | 27.98 ms | 1.20 ms | 0 ps | 0 | 0 | 0 | 0 |
|