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.88 ms | 2.88 ms | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 455 | 106.42 ms | 618.48 us | 42.84 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 455 | 51.62 ms | 362.75 us | 17.67 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 454 | 2.85 ms | 37.83 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 9100 | 6.41 s | 392.41 ms | 1.27 s | 49163 | 2335607 | 0 | 4240 | |
root | show_keys | 559 | 2.06 s | 117.69 ms | 219.04 ms | 902 | 11291 | 0 | 0 | |
root | show_fields | 622 | 583.05 ms | 5.28 ms | 251.12 ms | 20492 | 104983 | 0 | 0 | |
root | show_table_status | 28 | 473.93 ms | 208.31 ms | 19.67 ms | 385 | 1756 | 0 | 0 | |
root | show_variables | 473 | 452.87 ms | 23.39 ms | 44.18 ms | 462 | 270704 | 0 | 473 | |
root | set_option | 1542 | 151.24 ms | 6.00 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_tables | 205 | 141.72 ms | 2.95 ms | 77.79 ms | 2640 | 9587 | 0 | 0 | |
root | show_create_table | 302 | 70.95 ms | 5.83 ms | 3.13 ms | 0 | 0 | 0 | 0 | |
root | show_grants | 464 | 38.77 ms | 370.84 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Init DB | 522 | 29.78 ms | 354.51 us | 1.49 ms | 0 | 0 | 0 | 0 | |
root | show_binlogs | 34 | 12.17 ms | 9.85 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_warnings | 188 | 5.46 ms | 58.12 us | 0 ps | 0 | 0 | 0 | 0 | |
root | jump_if_not | 1528 | 5.02 ms | 1.74 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Quit | 572 | 4.06 ms | 230.68 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Prepare | 15 | 3.69 ms | 627.78 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Execute | 15 | 3.26 ms | 405.84 us | 938.00 us | 0 | 30 | 0 | 15 | |
root | show_storage_engines | 28 | 2.94 ms | 397.41 us | 1.39 ms | 252 | 252 | 0 | 28 | |
root | freturn | 252 | 2.47 ms | 778.89 us | 0 ps | 0 | 0 | 0 | 0 | |
root | stmt | 2 | 2.26 ms | 2.11 ms | 0 ps | 0 | 2 | 0 | 0 | |
root | show_master_status | 1 | 2.20 ms | 2.20 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | set | 4 | 2.15 ms | 2.05 ms | 0 ps | 0 | 2 | 0 | 0 |
|