16:58:07 [10.221.202.67] {root} (dw_trade_order_seller_db) > explain analyze SELECT /*+ USE_INDEX(trade_order_seller idx_seller_id_create_time_us)*/
-> id,
-> order_no,
-> sub_order_no,
-> biz_type,
-> biz_channel,
-> biz_code,
-> biz_id,
-> abs(sub_order_status) AS sub_order_status,
-> buyer_id,
-> buyer_name,
-> seller_id,
-> seller_name,
-> pay_amount,
-> discount_amount,
-> inventory_id,
-> spu_id,
-> sku_id,
-> sku_title,
-> sku_price,
-> sku_count,
-> buyer_note,
-> deposit_amount,
-> poundage_amount,
-> poundage_info,
-> item_info,
-> close_type,
-> close_time,
-> feature,
-> is_del,
-> create_time,
-> modify_time,
-> product_amount,
-> freight_amount,
-> sku_logo,
-> seller_note,
-> seller_address_info,
-> seller_address_back,
-> merchant_info,
-> repository_address,
-> delivery_deadline,
-> tab_tag,
-> flag,
-> relation_info,
-> create_time_us,
-> seller_feature,
-> seller_type,
-> delivery_start_time,
-> delivery_no,
-> warehouse_code,
-> warehouse_address_id,
-> down_payment_time,
-> balance_payment_time,
-> merchant_accept,
-> delivery_mode,
-> sub_is_del,
-> order_status,
-> order_deliver_status,
-> order_product_amount,
-> order_freight_amount,
-> order_pay_amount,
-> order_discount_amount,
-> buyer_address_info,
-> order_platform,
-> order_source_name,
-> order_feature,
-> order_flag,
-> order_relation_info,
-> order_is_del,
-> oversea_tax,
-> platform_received_time,
-> trade_close_reason_id,
-> seller_bidding_no,
-> sub_order_modify_time,
-> main_order_modify_time,
-> logistics_delivery_deadline,
-> virtual_delivery_type,
-> sale_type,
-> seller_earliest_logistic_delivery_time,
-> seller_earliest_logistic_collect_time,
-> seller_earliest_logistic_no,
-> seller_earliest_logistic_modify_time,
-> seller_earliest_logistic_express_no,
-> seller_earliest_logistic_express_status,
-> receive_address_confirmed
-> FROM
-> trade_order_seller
-> WHERE
-> seller_id = 1759982590
-> AND sub_order_status > 0
-> ORDER BY
-> create_time_us DESC
-> LIMIT
-> 0, 4;
+------------------------------------+------------+---------+-----------+-----------------------------------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------+------+
| id | estRows | actRows | task | access object | execution info | operator info | memory | disk |
+------------------------------------+------------+---------+-----------+-----------------------------------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------+------+
| Projection_7 | 4.00 | 4 | root | | time:2.82s, loops:2, RU:49978.065809, Concurrency:OFF | dw_trade_order_seller_db.trade_order_seller.id, dw_trade_order_seller_db.trade_order_seller.order_no, dw_trade_order_seller_db.trade_order_seller.sub_order_no, dw_trade_order_seller_db.trade_order_seller.biz_type, dw_trade_order_seller_db.trade_order_seller.biz_channel, dw_trade_order_seller_db.trade_order_seller.biz_code, dw_trade_order_seller_db.trade_order_seller.biz_id, abs(dw_trade_order_seller_db.trade_order_seller.sub_order_status)->Column#85, dw_trade_order_seller_db.trade_order_seller.buyer_id, dw_trade_order_seller_db.trade_order_seller.buyer_name, dw_trade_order_seller_db.trade_order_seller.seller_id, dw_trade_order_seller_db.trade_order_seller.seller_name, dw_trade_order_seller_db.trade_order_seller.pay_amount, dw_trade_order_seller_db.trade_order_seller.discount_amount, dw_trade_order_seller_db.trade_order_seller.inventory_id, dw_trade_order_seller_db.trade_order_seller.spu_id, dw_trade_order_seller_db.trade_order_seller.sku_id, dw_trade_order_seller_db.trade_order_seller.sku_title, dw_trade_order_seller_db.trade_order_seller.sku_price, dw_trade_order_seller_db.trade_order_seller.sku_count, dw_trade_order_seller_db.trade_order_seller.buyer_note, dw_trade_order_seller_db.trade_order_seller.deposit_amount, dw_trade_order_seller_db.trade_order_seller.poundage_amount, dw_trade_order_seller_db.trade_order_seller.poundage_info, dw_trade_order_seller_db.trade_order_seller.item_info, dw_trade_order_seller_db.trade_order_seller.close_type, dw_trade_order_seller_db.trade_order_seller.close_time, dw_trade_order_seller_db.trade_order_seller.feature, dw_trade_order_seller_db.trade_order_seller.is_del, dw_trade_order_seller_db.trade_order_seller.create_time, dw_trade_order_seller_db.trade_order_seller.modify_time, dw_trade_order_seller_db.trade_order_seller.product_amount, dw_trade_order_seller_db.trade_order_seller.freight_amount, dw_trade_order_seller_db.trade_order_seller.sku_logo, dw_trade_order_seller_db.trade_order_seller.seller_note, dw_trade_order_seller_db.trade_order_seller.seller_address_info, dw_trade_order_seller_db.trade_order_seller.seller_address_back, dw_trade_order_seller_db.trade_order_seller.merchant_info, dw_trade_order_seller_db.trade_order_seller.repository_address, dw_trade_order_seller_db.trade_order_seller.delivery_deadline, dw_trade_order_seller_db.trade_order_seller.tab_tag, dw_trade_order_seller_db.trade_order_seller.flag, dw_trade_order_seller_db.trade_order_seller.relation_info, dw_trade_order_seller_db.trade_order_seller.create_time_us, dw_trade_order_seller_db.trade_order_seller.seller_feature, dw_trade_order_seller_db.trade_order_seller.seller_type, dw_trade_order_seller_db.trade_order_seller.delivery_start_time, dw_trade_order_seller_db.trade_order_seller.delivery_no, dw_trade_order_seller_db.trade_order_seller.warehouse_code, dw_trade_order_seller_db.trade_order_seller.warehouse_address_id, dw_trade_order_seller_db.trade_order_seller.down_payment_time, dw_trade_order_seller_db.trade_order_seller.balance_payment_time, dw_trade_order_seller_db.trade_order_seller.merchant_accept, dw_trade_order_seller_db.trade_order_seller.delivery_mode, dw_trade_order_seller_db.trade_order_seller.sub_is_del, dw_trade_order_seller_db.trade_order_seller.order_status, dw_trade_order_seller_db.trade_order_seller.order_deliver_status, dw_trade_order_seller_db.trade_order_seller.order_product_amount, dw_trade_order_seller_db.trade_order_seller.order_freight_amount, dw_trade_order_seller_db.trade_order_seller.order_pay_amount, dw_trade_order_seller_db.trade_order_seller.order_discount_amount, dw_trade_order_seller_db.trade_order_seller.buyer_address_info, dw_trade_order_seller_db.trade_order_seller.order_platform, dw_trade_order_seller_db.trade_order_seller.order_source_name, dw_trade_order_seller_db.trade_order_seller.order_feature, dw_trade_order_seller_db.trade_order_seller.order_flag, dw_trade_order_seller_db.trade_order_seller.order_relation_info, dw_trade_order_seller_db.trade_order_seller.order_is_del, dw_trade_order_seller_db.trade_order_seller.oversea_tax, dw_trade_order_seller_db.trade_order_seller.platform_received_time, dw_trade_order_seller_db.trade_order_seller.trade_close_reason_id, dw_trade_order_seller_db.trade_order_seller.seller_bidding_no, dw_trade_order_seller_db.trade_order_seller.sub_order_modify_time, dw_trade_order_seller_db.trade_order_seller.main_order_modify_time, dw_trade_order_seller_db.trade_order_seller.logistics_delivery_deadline, dw_trade_order_seller_db.trade_order_seller.virtual_delivery_type, dw_trade_order_seller_db.trade_order_seller.sale_type, dw_trade_order_seller_db.trade_order_seller.seller_earliest_logistic_delivery_time, dw_trade_order_seller_db.trade_order_seller.seller_earliest_logistic_collect_time, dw_trade_order_seller_db.trade_order_seller.seller_earliest_logistic_no, dw_trade_order_seller_db.trade_order_seller.seller_earliest_logistic_modify_time, dw_trade_order_seller_db.trade_order_seller.seller_earliest_logistic_express_no, dw_trade_order_seller_db.trade_order_seller.seller_earliest_logistic_express_status, dw_trade_order_seller_db.trade_order_seller.receive_address_confirmed | 64.0 KB | N/A |
| └─TopN_9 | 4.00 | 4 | root | | time:2.82s, loops:2 | dw_trade_order_seller_db.trade_order_seller.create_time_us:desc, offset:0, count:4 | 1.65 MB | N/A |
| └─IndexLookUp_17 | 4.00 | 459669 | root | | time:2.7s, loops:115, index_task: {total_time: 2.69s, fetch_handle: 419.2ms, build: 121.5µs, wait: 2.27s}, table_task: {total_time: 12.7s, num: 89, concurrency: 5}, next: {wait_index: 149.4ms, wait_table_lookup_build: 9.33ms, wait_table_lookup_resp: 1.57s} | | 546.6 MB | N/A |
| ├─IndexRangeScan_13(Build) | 1599407.00 | 1552483 | cop[tikv] | table:trade_order_seller, index:idx_seller_id_create_time_us(seller_id, create_time_us) | time:347.2ms, loops:399, cop_task: {num: 3, max: 1.29s, min: 45.9ms, avg: 576.5ms, p95: 1.29s, max_proc_keys: 960000, p95_proc_keys: 960000, tot_proc: 1.16s, tot_wait: 567.5µs, copr_cache_hit_ratio: 0.00, build_task_duration: 37.6µs, max_distsql_concurrency: 3}, rpc_info:{Cop:{num_rpc:3, total_time:1.73s}}, tikv_task:{proc max:1.25s, min:41ms, avg: 553.3ms, p80:1.25s, p95:1.25s, iters:1529, tasks:3}, scan_detail: {total_process_keys: 1552483, total_process_keys_size: 85386565, total_keys: 1552486, get_snapshot_time: 445.1µs, rocksdb: {key_skipped_count: 1552483, block: {cache_hit_count: 24, read_count: 2464, read_byte: 32.5 MB, read_time: 18.8ms}}} | range:[1759982590,1759982590], keep order:false | N/A | N/A |
| └─TopN_16(Probe) | 4.00 | 459669 | cop[tikv] | | time:11.4s, loops:248, cop_task: {num: 123237, max: 95.9ms, min: 0s, avg: 4.91ms, p95: 18.6ms, max_proc_keys: 114, p95_proc_keys: 31, tot_proc: 4m15.9s, tot_wait: 11m31.2s, copr_cache_hit_ratio: 0.07, build_task_duration: 553.6ms, max_distsql_concurrency: 15, max_extra_concurrency: 320, store_batch_num: 91623}, rpc_info:{Cop:{num_rpc:31614, total_time:10m5.1s}}, tikv_task:{proc max:0s, min:0s, avg: 13.6ms, p80:21ms, p95:46ms, iters:123237, tasks:123237}, scan_detail: {total_process_keys: 1177706, total_process_keys_size: 6763520793, total_keys: 1283655, get_snapshot_time: 4.91s, rocksdb: {delete_skipped_count: 769471, key_skipped_count: 129519, block: {cache_hit_count: 10773550, read_count: 909716, read_byte: 12.3 GB, read_time: 9.29s}}} | dw_trade_order_seller_db.trade_order_seller.create_time_us:desc, offset:0, count:4 | N/A | N/A |
| └─Selection_15 | 1595197.23 | 1552483 | cop[tikv] | | tikv_task:{proc max:0s, min:0s, avg: 13.4ms, p80:25ms, p95:53ms, iters:123237, tasks:123237} | gt(dw_trade_order_seller_db.trade_order_seller.sub_order_status, 0) | N/A | N/A |
| └─TableRowIDScan_14 | 1599407.00 | 1552483 | cop[tikv] | table:trade_order_seller | tikv_task:{proc max:0s, min:0s, avg: 13.4ms, p80:19ms, p95:42ms, iters:123237, tasks:123237} | keep order:false | N/A | N/A |
+------------------------------------+------------+---------+-----------+-----------------------------------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------+------+
7 rows in set (2.85 sec)