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 | 850.07 us | 850.07 us | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 482 | 117.20 ms | 5.65 ms | 46.38 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 482 | 50.06 ms | 736.25 us | 17.23 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 481 | 3.12 ms | 45.74 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 12677 | 11.05 s | 993.74 ms | 1.89 s | 49979 | 415362 | 0 | 3852 | |
root | show_keys | 595 | 1.17 s | 140.85 ms | 237.93 ms | 338 | 5864 | 0 | 0 | |
root | show_fields | 523 | 496.02 ms | 5.22 ms | 233.16 ms | 11058 | 57196 | 0 | 0 | |
root | show_variables | 348 | 373.03 ms | 46.91 ms | 49.90 ms | 345 | 199143 | 0 | 348 | |
root | create_table | 1 | 206.05 ms | 206.05 ms | 2.48 ms | 0 | 0 | 0 | 0 | |
root | show_tables | 220 | 139.00 ms | 3.75 ms | 73.00 ms | 2983 | 11062 | 0 | 0 | |
root | set_option | 1619 | 133.14 ms | 8.57 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_table_status | 77 | 126.80 ms | 105.28 ms | 9.54 ms | 99 | 698 | 0 | 0 | |
root | create_db | 2 | 89.19 ms | 48.76 ms | 2.61 ms | 0 | 0 | 2 | 0 | |
root | show_create_table | 246 | 79.35 ms | 18.95 ms | 109.00 us | 0 | 0 | 0 | 0 | |
root | show_grants | 461 | 39.48 ms | 1.61 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Init DB | 485 | 31.94 ms | 295.51 us | 2.98 ms | 0 | 0 | 0 | 0 | |
root | jump_if_not | 38919 | 22.96 ms | 697.77 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_binlogs | 24 | 20.50 ms | 12.98 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | freturn | 11188 | 15.05 ms | 1.93 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_storage_engines | 30 | 6.39 ms | 2.12 ms | 1.95 ms | 270 | 270 | 0 | 30 | |
root | error | 8 | 5.74 ms | 5.40 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_warnings | 133 | 4.79 ms | 595.54 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Quit | 595 | 4.01 ms | 255.03 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Prepare | 10 | 3.33 ms | 1.77 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_slave_status | 9 | 3.22 ms | 1.93 ms | 0 ps | 0 | 0 | 0 | 0 |
|