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 | 3.57 ms | 3.57 ms | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 692 | 144.53 ms | 582.70 us | 59.04 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 692 | 70.41 ms | 553.39 us | 24.01 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 691 | 4.60 ms | 23.71 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 11241 | 4.72 s | 168.00 ms | 1.40 s | 49783 | 453909 | 0 | 5449 | |
root | show_variables | 733 | 670.14 ms | 5.73 ms | 66.79 ms | 733 | 420658 | 0 | 733 | |
root | show_fields | 650 | 662.87 ms | 3.84 ms | 238.32 ms | 33650 | 170382 | 0 | 0 | |
root | show_keys | 496 | 638.85 ms | 69.43 ms | 173.40 ms | 784 | 7046 | 0 | 0 | |
root | set_option | 2182 | 155.78 ms | 5.52 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_tables | 308 | 116.76 ms | 2.96 ms | 64.91 ms | 1470 | 3890 | 0 | 0 | |
root | create_db | 2 | 97.31 ms | 50.12 ms | 423.00 us | 0 | 0 | 2 | 0 | |
root | show_create_table | 327 | 64.95 ms | 1.96 ms | 126.00 us | 0 | 0 | 0 | 0 | |
root | Init DB | 647 | 47.80 ms | 370.77 us | 8.90 ms | 0 | 0 | 0 | 0 | |
root | show_grants | 565 | 44.13 ms | 309.14 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_table_status | 60 | 14.20 ms | 2.27 ms | 9.04 ms | 0 | 16 | 0 | 0 | |
root | show_warnings | 324 | 9.22 ms | 166.10 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Quit | 757 | 4.71 ms | 209.14 us | 0 ps | 0 | 0 | 0 | 0 | |
root | error | 13 | 4.71 ms | 1.82 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_slave_status | 12 | 2.84 ms | 1.91 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_master_status | 12 | 2.72 ms | 2.17 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_binlogs | 17 | 1.37 ms | 494.06 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_storage_engines | 2 | 834.58 us | 492.12 us | 605.00 us | 18 | 18 | 0 | 2 | |
root | Prepare | 1 | 538.41 us | 538.41 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Execute | 1 | 129.21 us | 129.21 us | 41.00 us | 0 | 2 | 0 | 1 | |
root | begin | 1 | 31.92 us | 31.92 us | 0 ps | 0 | 0 | 0 | 0 |
|