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.70 ms | 2.70 ms | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 463 | 96.01 ms | 636.08 us | 39.57 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 463 | 46.32 ms | 486.20 us | 15.95 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 461 | 3.31 ms | 65.90 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 11378 | 5.76 s | 370.95 ms | 1.44 s | 44324 | 1055202 | 0 | 4071 | |
root | show_keys | 485 | 809.74 ms | 101.31 ms | 171.95 ms | 571 | 8504 | 0 | 0 | |
root | show_fields | 615 | 555.16 ms | 7.27 ms | 223.40 ms | 22455 | 114411 | 0 | 0 | |
root | show_variables | 521 | 473.67 ms | 15.82 ms | 47.49 ms | 520 | 299012 | 0 | 521 | |
root | show_tables | 302 | 175.57 ms | 3.23 ms | 86.62 ms | 5419 | 17273 | 0 | 0 | |
root | set_option | 1493 | 128.62 ms | 6.48 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_table | 296 | 54.53 ms | 2.03 ms | 990.00 us | 0 | 0 | 0 | 0 | |
root | show_grants | 446 | 36.24 ms | 1.23 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Init DB | 483 | 35.90 ms | 1.31 ms | 6.04 ms | 0 | 0 | 0 | 0 | |
root | show_table_status | 112 | 13.75 ms | 1.65 ms | 7.82 ms | 0 | 0 | 0 | 0 | |
root | show_warnings | 245 | 7.26 ms | 116.28 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_storage_engines | 23 | 5.10 ms | 2.03 ms | 3.45 ms | 207 | 207 | 0 | 23 | |
root | Quit | 623 | 4.37 ms | 206.78 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Prepare | 5 | 3.40 ms | 2.69 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_master_status | 8 | 2.63 ms | 2.14 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_binlogs | 27 | 2.59 ms | 416.68 us | 0 ps | 0 | 0 | 0 | 0 | |
root | freturn | 303 | 1.98 ms | 1.12 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | error | 12 | 1.95 ms | 1.21 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | jump_if_not | 1723 | 1.70 ms | 199.74 us | 0 ps | 0 | 0 | 0 | 0 | |
root | stmt | 2 | 1.25 ms | 1.18 ms | 0 ps | 0 | 2 | 0 | 0 | |
root | set | 4 | 1.20 ms | 1.15 ms | 0 ps | 0 | 2 | 0 | 0 |
|