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.05 ms | 2.05 ms | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 759 | 134.31 ms | 673.21 us | 54.25 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 759 | 61.25 ms | 535.17 us | 21.37 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 756 | 4.66 ms | 43.89 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 32272 | 17.16 s | 387.89 ms | 4.46 s | 95782 | 626881 | 0 | 8796 | |
root | show_keys | 1367 | 1.64 s | 109.61 ms | 514.85 ms | 1476 | 23383 | 0 | 0 | |
root | show_fields | 1472 | 1.49 s | 4.90 ms | 587.43 ms | 58170 | 296358 | 0 | 0 | |
root | show_variables | 1286 | 1.14 s | 7.28 ms | 114.10 ms | 1286 | 738101 | 0 | 1286 | |
root | show_tables | 644 | 379.88 ms | 4.07 ms | 190.70 ms | 14415 | 44533 | 0 | 0 | |
root | set_option | 3069 | 205.27 ms | 8.42 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | create_table | 1 | 195.69 ms | 195.69 ms | 4.71 ms | 0 | 0 | 0 | 0 | |
root | show_create_table | 727 | 148.50 ms | 2.11 ms | 277.00 us | 0 | 0 | 0 | 0 | |
root | Init DB | 1004 | 51.22 ms | 533.68 us | 3.75 ms | 0 | 0 | 0 | 0 | |
root | show_grants | 593 | 47.26 ms | 691.61 us | 0 ps | 0 | 0 | 0 | 0 | |
root | create_db | 1 | 42.11 ms | 42.11 ms | 99.00 us | 0 | 0 | 1 | 0 | |
root | show_warnings | 611 | 18.64 ms | 131.75 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_master_status | 11 | 12.03 ms | 9.08 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Quit | 1314 | 8.54 ms | 332.72 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_table_status | 42 | 6.69 ms | 939.18 us | 4.05 ms | 0 | 2 | 0 | 0 | |
root | show_binlogs | 36 | 4.36 ms | 1.97 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_slave_status | 11 | 3.76 ms | 2.46 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_storage_engines | 14 | 3.51 ms | 2.13 ms | 2.78 ms | 126 | 126 | 0 | 14 | |
root | Execute | 13 | 2.70 ms | 699.85 us | 1.08 ms | 10 | 18 | 0 | 4 | |
root | Prepare | 13 | 2.63 ms | 923.81 us | 0 ps | 0 | 0 | 0 | 0 | |
root | jump_if_not | 1522 | 1.73 ms | 283.92 us | 0 ps | 0 | 0 | 0 | 0 |
|