版本
4.0-rc
问题描述
+---------------------------+---------+---------+-----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------+------+
| id | estRows | actRows | task | access object | execution info | operator info | memory | disk |
+---------------------------+---------+---------+-----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------+------+
| Projection_9 | 0.00 | 5 | root | | time:391.787286ms, loops:2, Concurrency:OFF | dev.dc_F_D_sale.create_time | 4.1171875 KB | N/A |
| └─Union_10 | 0.00 | 5 | root | | time:391.779852ms, loops:2 | | N/A | N/A |
| ├─IndexLookUp_25 | 0.00 | 5 | root | | time:391.740658ms, loops:2, rpc num: 1, rpc time:389.761186ms, proc keys:419916 | | 12.1953125 KB | N/A |
| │ ├─Selection_23(Build) | 0.00 | 5 | cop[tikv] | | time:353ms, loops:414 | eq(dev.dc_F_D_sale.br_status, "3"), eq(dev.dc_F_D_sale.is_del, "0"), like(dev.dc_F_D_sale.normal_organ_code, "%DS0046778%", 92), like(dev.dc_F_D_sale.normal_product_code, "%11705%", 92), like(dev.dc_F_D_sale.normal_seller_code, "%DI00018479%", 92), ne(dev.dc_F_D_sale.normal_organ_code, "99999"), ne(dev.dc_F_D_sale.normal_product_code, "99999")... | N/A | N/A |
| │ │ └─IndexRangeScan_21 | 250.00 | 419726 | cop[tikv] | table:DcFDSale, partition:p202002, index:index1(seller_date, is_del, normal_product_code, normal_seller_code, normal_organ_code, br_status, distributor_code) | time:248ms, loops:414 | range:[2020-02-29,2020-03-01], keep order:false, stats:pseudo | N/A | N/A |
| │ └─Selection_24(Probe) | 0.00 | 5 | cop[tikv] | | time:0s, loops:1 | ne(dev.dc_F_D_sale.agent_status, "1"), ne(dev.dc_F_D_sale.data_flag, "1") | N/A | N/A |
| │ └─TableRowIDScan_22 | 0.00 | 5 | cop[tikv] | table:DcFDSale, partition:p202002 | time:0s, loops:1 | keep order:false, stats:pseudo | N/A | N/A |
| └─IndexLookUp_49 | 0.00 | 0 | root | | time:14.228493ms, loops:1, rpc num: 1, rpc time:12.081936ms, proc keys:7864 | | 8.15625 KB | N/A |
| ├─Selection_47(Build) | 0.00 | 10 | cop[tikv] | | time:9ms, loops:12 | eq(dev.dc_F_D_sale.br_status, "3"), eq(dev.dc_F_D_sale.is_del, "0"), like(dev.dc_F_D_sale.normal_organ_code, "%DS0046778%", 92), like(dev.dc_F_D_sale.normal_product_code, "%11705%", 92), like(dev.dc_F_D_sale.normal_seller_code, "%DI00018479%", 92), ne(dev.dc_F_D_sale.normal_organ_code, "99999"), ne(dev.dc_F_D_sale.normal_product_code, "99999")... | N/A | N/A |
| │ └─IndexRangeScan_45 | 250.00 | 7724 | cop[tikv] | table:DcFDSale, partition:p202003, index:index1(seller_date, is_del, normal_product_code, normal_seller_code, normal_organ_code, br_status, distributor_code) | time:7ms, loops:12 | range:[2020-02-29,2020-03-01], keep order:false, stats:pseudo | N/A | N/A |
| └─Selection_48(Probe) | 0.00 | 0 | cop[tikv] | | proc max:1ms, min:0s, p80:1ms, p95:1ms, iters:3, tasks:3 | ne(dev.dc_F_D_sale.agent_status, "1"), ne(dev.dc_F_D_sale.data_flag, "1") | N/A | N/A |
| └─TableRowIDScan_46 | 0.00 | 10 | cop[tikv] | table:DcFDSale, partition:p202003 | proc max:1ms, min:0s, p80:1ms, p95:1ms, iters:3, tasks:3 | keep order:false, stats:pseudo | N/A | N/A |
+---------------------------+---------+---------+-----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------+------+