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 | 481.47 us | 481.47 us | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 864 | 197.31 ms | 665.82 us | 79.20 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 864 | 95.37 ms | 353.61 us | 32.45 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 863 | 5.89 ms | 39.30 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 31472 | 16.30 s | 692.82 ms | 4.20 s | 100303 | 699943 | 0 | 7397 | |
root | show_keys | 1821 | 2.55 s | 152.26 ms | 688.47 ms | 830 | 12499 | 0 | 0 | |
root | show_fields | 1303 | 1.12 s | 9.92 ms | 517.40 ms | 29446 | 151588 | 0 | 0 | |
root | show_variables | 1166 | 1.06 s | 32.33 ms | 102.74 ms | 2814 | 668129 | 0 | 1166 | |
root | set_option | 2221 | 207.94 ms | 10.52 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_table | 621 | 129.59 ms | 2.48 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_tables | 147 | 99.88 ms | 3.23 ms | 50.89 ms | 2712 | 8302 | 0 | 0 | |
root | show_grants | 868 | 66.37 ms | 280.10 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Init DB | 952 | 48.06 ms | 627.01 us | 2.21 ms | 0 | 0 | 0 | 0 | |
root | show_status | 2 | 27.10 ms | 25.22 ms | 573.00 us | 900 | 900 | 0 | 2 | |
root | show_warnings | 488 | 15.10 ms | 141.58 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_binlogs | 45 | 12.20 ms | 7.21 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_storage_engines | 46 | 10.81 ms | 6.00 ms | 8.00 ms | 414 | 414 | 0 | 46 | |
root | jump_if_not | 6669 | 8.83 ms | 1.94 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Quit | 945 | 8.05 ms | 318.96 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Prepare | 7 | 4.87 ms | 3.74 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_master_status | 3 | 3.19 ms | 2.73 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | freturn | 2127 | 2.15 ms | 353.97 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Execute | 7 | 1.62 ms | 746.22 us | 722.00 us | 0 | 14 | 0 | 7 | |
root | show_slave_status | 3 | 1.39 ms | 961.20 us | 0 ps | 0 | 0 | 0 | 0 | |
root | stmt | 4 | 983.59 us | 737.26 us | 0 ps | 0 | 4 | 0 | 0 |
|