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.54 ms | 2.54 ms | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 2663 | 484.17 ms | 1.73 ms | 196.20 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 2604 | 223.65 ms | 1.42 ms | 78.00 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 2633 | 16.80 ms | 39.88 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 140817 | 58.09 s | 368.85 ms | 19.08 s | 358634 | 2597770 | 0 | 36143 | |
root | show_keys | 5315 | 5.51 s | 1.17 s | 1.99 s | 5249 | 88930 | 0 | 0 | |
root | show_fields | 5400 | 5.35 s | 6.07 ms | 2.12 s | 216469 | 1102904 | 0 | 0 | |
root | show_variables | 4996 | 4.32 s | 8.06 ms | 437.05 ms | 5547 | 2866843 | 0 | 4996 | |
root | show_tables | 2788 | 1.96 s | 5.72 ms | 1.04 s | 59173 | 172600 | 0 | 0 | |
root | set_option | 11027 | 634.59 ms | 5.20 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_table | 2733 | 549.11 ms | 4.84 ms | 273.00 us | 0 | 0 | 0 | 0 | |
root | create_table | 1 | 307.38 ms | 307.38 ms | 3.45 ms | 0 | 0 | 0 | 0 | |
root | Init DB | 3749 | 171.64 ms | 416.20 us | 5.07 ms | 0 | 0 | 0 | 0 | |
root | show_grants | 2141 | 169.31 ms | 1.34 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | create_db | 6 | 160.17 ms | 70.49 ms | 1.96 ms | 0 | 0 | 3 | 0 | |
root | show_table_status | 130 | 131.39 ms | 73.74 ms | 39.26 ms | 16 | 196 | 0 | 0 | |
root | show_warnings | 2382 | 72.62 ms | 349.94 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Quit | 4785 | 30.94 ms | 219.83 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_proc | 81 | 21.12 ms | 6.05 ms | 1.68 ms | 0 | 0 | 0 | 0 | |
root | show_status | 1 | 17.45 ms | 17.45 ms | 154.00 us | 450 | 450 | 0 | 1 | |
root | show_create_func | 67 | 12.31 ms | 2.85 ms | 3.45 ms | 0 | 0 | 0 | 0 | |
root | jump_if_not | 12638 | 11.86 ms | 1.75 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_binlogs | 110 | 7.67 ms | 699.04 us | 0 ps | 0 | 0 | 0 | 0 | |
root | stmt | 11 | 6.64 ms | 2.23 ms | 0 ps | 0 | 11 | 0 | 0 | |
root | freturn | 2116 | 5.42 ms | 2.06 ms | 0 ps | 0 | 0 | 0 | 0 |
|