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.05 ms | 2.05 ms | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 4004 | 698.87 ms | 2.33 ms | 280.23 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 4004 | 319.64 ms | 1.12 ms | 110.66 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 4003 | 23.98 ms | 91.63 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 210316 | 1.49 m | 1.02 s | 29.48 s | 524950 | 3475905 | 0 | 44979 | |
root | show_fields | 7958 | 8.04 s | 7.27 ms | 3.17 s | 313254 | 1596334 | 0 | 0 | |
root | show_keys | 7389 | 6.26 s | 109.61 ms | 2.81 s | 7969 | 130023 | 0 | 0 | |
root | show_variables | 7079 | 6.17 s | 8.54 ms | 613.71 ms | 7077 | 4062821 | 0 | 7079 | |
root | drop_db | 34 | 5.44 s | 1.06 s | 22.22 ms | 0 | 0 | 71 | 0 | |
root | show_tables | 3521 | 2.14 s | 19.93 ms | 1.07 s | 78565 | 240584 | 0 | 0 | |
root | create_table | 5 | 1.20 s | 427.25 ms | 11.01 ms | 0 | 0 | 0 | 0 | |
root | set_option | 16477 | 883.03 ms | 8.42 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_table | 3952 | 791.04 ms | 8.84 ms | 1.32 ms | 0 | 0 | 0 | 0 | |
root | create_db | 15 | 547.55 ms | 63.56 ms | 809.00 us | 0 | 0 | 12 | 0 | |
root | Init DB | 5322 | 269.23 ms | 533.68 us | 16.34 ms | 0 | 0 | 0 | 0 | |
root | show_grants | 2878 | 226.09 ms | 1.10 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | drop_table | 1 | 120.71 ms | 120.71 ms | 79.00 us | 0 | 0 | 0 | 0 | |
root | show_warnings | 3371 | 102.78 ms | 1.17 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | jump_if_not | 73115 | 59.27 ms | 1.01 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Quit | 7106 | 44.20 ms | 332.72 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_table_status | 225 | 38.69 ms | 1.52 ms | 21.50 ms | 66 | 493 | 0 | 0 | |
root | insert | 1 | 28.91 ms | 28.91 ms | 1.85 ms | 0 | 0 | 1 | 0 | |
root | freturn | 11841 | 23.24 ms | 529.67 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_binlogs | 179 | 19.06 ms | 4.33 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_master_status | 58 | 13.84 ms | 9.08 ms | 0 ps | 0 | 0 | 0 | 0 |
|