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 | 890.51 us | 890.51 us | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 1471 | 283.76 ms | 1.65 ms | 114.48 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 1471 | 131.10 ms | 411.21 us | 45.13 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 1468 | 9.76 ms | 63.06 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 60314 | 32.91 s | 360.82 ms | 7.87 s | 171217 | 3921669 | 0 | 18200 | |
root | show_keys | 2926 | 3.02 s | 86.87 ms | 1.07 s | 2951 | 44935 | 0 | 0 | |
root | show_fields | 2939 | 2.81 s | 8.53 ms | 1.13 s | 111176 | 566907 | 0 | 0 | |
root | show_variables | 2711 | 2.35 s | 5.10 ms | 233.91 ms | 2711 | 1555673 | 0 | 2711 | |
root | create_table | 16 | 1.23 s | 212.57 ms | 3.97 ms | 0 | 0 | 0 | 0 | |
root | show_tables | 1438 | 1.05 s | 3.99 ms | 547.76 ms | 31345 | 92389 | 0 | 0 | |
root | set_option | 6026 | 371.93 ms | 8.33 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_table | 1505 | 298.80 ms | 9.48 ms | 374.00 us | 0 | 0 | 0 | 0 | |
root | create_db | 4 | 179.11 ms | 60.12 ms | 922.00 us | 0 | 0 | 4 | 0 | |
root | insert | 6 | 165.61 ms | 33.87 ms | 1.17 ms | 0 | 0 | 15 | 0 | |
root | Init DB | 2072 | 101.00 ms | 409.74 us | 4.61 ms | 0 | 0 | 0 | 0 | |
root | show_grants | 1256 | 95.97 ms | 1.16 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_warnings | 1268 | 39.43 ms | 204.49 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_table_status | 85 | 21.74 ms | 3.49 ms | 13.94 ms | 1 | 33 | 0 | 0 | |
root | Quit | 2554 | 18.06 ms | 750.49 us | 0 ps | 0 | 0 | 0 | 0 | |
root | freturn | 2733 | 7.10 ms | 1.65 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | jump_if_not | 7484 | 6.87 ms | 494.31 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_proc | 26 | 6.74 ms | 1.30 ms | 1.29 ms | 0 | 0 | 0 | 0 | |
root | show_create_func | 26 | 5.97 ms | 2.04 ms | 1.00 ms | 0 | 0 | 0 | 0 | |
root | show_binlogs | 22 | 5.66 ms | 2.37 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Execute | 29 | 4.88 ms | 368.54 us | 1.65 ms | 18 | 40 | 0 | 11 |
|