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 | 3749 | 654.92 ms | 2.33 ms | 262.40 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 3749 | 299.31 ms | 1.12 ms | 103.81 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 3749 | 22.34 ms | 49.55 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 199446 | 1.42 m | 1.02 s | 27.96 s | 500332 | 3327483 | 0 | 42792 | |
root | show_fields | 7477 | 7.56 s | 7.27 ms | 2.98 s | 293672 | 1496602 | 0 | 0 | |
root | show_keys | 6968 | 5.98 s | 109.61 ms | 2.65 s | 7434 | 122201 | 0 | 0 | |
root | show_variables | 6660 | 5.81 s | 8.54 ms | 576.93 ms | 6658 | 3822336 | 0 | 6660 | |
root | drop_db | 34 | 5.44 s | 1.06 s | 22.22 ms | 0 | 0 | 71 | 0 | |
root | show_tables | 3337 | 2.03 s | 19.93 ms | 1.01 s | 74662 | 227573 | 0 | 0 | |
root | create_table | 5 | 1.20 s | 427.25 ms | 11.01 ms | 0 | 0 | 0 | 0 | |
root | set_option | 15487 | 833.40 ms | 8.42 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_table | 3715 | 746.66 ms | 8.84 ms | 1.25 ms | 0 | 0 | 0 | 0 | |
root | create_db | 14 | 503.51 ms | 63.56 ms | 747.00 us | 0 | 0 | 11 | 0 | |
root | Init DB | 5005 | 252.98 ms | 533.68 us | 15.42 ms | 0 | 0 | 0 | 0 | |
root | show_grants | 2707 | 212.62 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 | 3170 | 96.51 ms | 1.17 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | jump_if_not | 72578 | 58.96 ms | 1.01 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Quit | 6695 | 41.55 ms | 332.72 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_table_status | 205 | 35.64 ms | 1.52 ms | 19.68 ms | 66 | 489 | 0 | 0 | |
root | insert | 1 | 28.91 ms | 28.91 ms | 1.85 ms | 0 | 0 | 1 | 0 | |
root | freturn | 11766 | 23.16 ms | 529.67 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_binlogs | 167 | 18.20 ms | 4.33 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_master_status | 52 | 13.65 ms | 9.08 ms | 0 ps | 0 | 0 | 0 | 0 |
|