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 | 367.64 us | 367.64 us | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 1334 | 216.39 ms | 8.01 ms | 90.56 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 1334 | 81.37 ms | 345.17 us | 29.43 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 1334 | 7.21 ms | 45.52 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 101538 | 47.43 s | 646.62 ms | 15.76 s | 187876 | 1325063 | 0 | 17466 | |
root | show_keys | 2749 | 2.85 s | 107.80 ms | 1.13 s | 2028 | 21911 | 0 | 0 | |
root | show_fields | 2274 | 2.46 s | 18.74 ms | 1.00 s | 85920 | 436999 | 0 | 0 | |
root | show_variables | 2210 | 2.29 s | 60.53 ms | 215.11 ms | 2209 | 1268456 | 0 | 2210 | |
root | show_create_table | 1167 | 429.01 ms | 104.07 ms | 2.60 ms | 0 | 0 | 0 | 0 | |
root | create_table | 1 | 248.81 ms | 248.81 ms | 3.75 ms | 0 | 0 | 0 | 0 | |
root | show_tables | 457 | 235.65 ms | 9.39 ms | 119.83 ms | 9982 | 24613 | 0 | 0 | |
root | set_option | 4454 | 222.79 ms | 9.29 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | create_db | 2 | 101.68 ms | 51.76 ms | 3.55 ms | 0 | 0 | 2 | 0 | |
root | Init DB | 1451 | 79.07 ms | 4.26 ms | 6.54 ms | 0 | 0 | 0 | 0 | |
root | show_grants | 638 | 62.83 ms | 6.05 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | jump_if_not | 38293 | 46.39 ms | 4.50 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | freturn | 16709 | 33.37 ms | 3.52 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_warnings | 1078 | 32.64 ms | 422.92 us | 0 ps | 0 | 0 | 0 | 0 | |
root | set | 184 | 17.11 ms | 7.84 ms | 0 ps | 0 | 42 | 0 | 0 | |
root | stmt | 17 | 11.94 ms | 7.96 ms | 0 ps | 0 | 17 | 0 | 0 | |
root | Quit | 1655 | 11.80 ms | 207.37 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_table_status | 57 | 11.22 ms | 1.21 ms | 6.37 ms | 0 | 4 | 0 | 0 | |
root | show_binlogs | 15 | 10.04 ms | 2.47 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_master_status | 10 | 8.77 ms | 3.28 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Prepare | 6 | 8.70 ms | 4.41 ms | 0 ps | 0 | 0 | 0 | 0 |
|