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 | 904.04 us | 904.04 us | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 475 | 112.96 ms | 805.58 us | 45.33 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 475 | 56.42 ms | 479.58 us | 19.26 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 475 | 3.19 ms | 74.35 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 48511 | 17.69 s | 740.45 ms | 6.42 s | 89328 | 566611 | 0 | 4019 | |
root | show_keys | 544 | 2.04 s | 146.08 ms | 199.20 ms | 644 | 7746 | 0 | 0 | |
root | show_fields | 552 | 463.13 ms | 10.80 ms | 207.39 ms | 12136 | 62931 | 0 | 0 | |
root | show_variables | 496 | 444.40 ms | 5.34 ms | 43.29 ms | 486 | 283843 | 0 | 496 | |
root | show_tables | 250 | 173.02 ms | 8.39 ms | 91.09 ms | 4328 | 23471 | 0 | 0 | |
root | set_option | 1507 | 138.93 ms | 7.46 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_table | 264 | 63.40 ms | 5.17 ms | 1.19 ms | 0 | 0 | 0 | 0 | |
root | show_table_status | 10 | 62.02 ms | 46.08 ms | 6.47 ms | 150 | 1018 | 0 | 0 | |
root | create_db | 1 | 43.69 ms | 43.69 ms | 1.72 ms | 0 | 0 | 1 | 0 | |
root | show_grants | 459 | 39.03 ms | 1.54 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Init DB | 521 | 35.39 ms | 582.59 us | 3.20 ms | 0 | 0 | 0 | 0 | |
root | freturn | 5304 | 17.33 ms | 10.77 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | jump_if_not | 13446 | 12.56 ms | 1.24 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Prepare | 19 | 6.44 ms | 2.30 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Execute | 19 | 6.35 ms | 747.38 us | 2.16 ms | 10 | 30 | 0 | 10 | |
root | show_warnings | 192 | 5.66 ms | 57.06 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Quit | 530 | 4.57 ms | 203.84 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_binlogs | 30 | 3.37 ms | 997.47 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_storage_engines | 31 | 3.06 ms | 307.34 us | 1.40 ms | 279 | 279 | 0 | 31 | |
root | show_master_status | 9 | 1.00 ms | 545.02 us | 0 ps | 0 | 0 | 0 | 0 | |
root | stmt | 7 | 930.03 us | 336.13 us | 0 ps | 0 | 7 | 0 | 0 |
|