id task estRows operator info actRows execution info memory disk
Limit_7 root 1 offset:0, count:1 1 time:22m22.3s, loops:2 N/A N/A
└─TableReader_11 root 1 data:Limit_10 1 time:22m22.3s, loops:1, cop_task: {num: 3122, max: 4.31s, min: 577µs, avg: 429.7ms, p95: 677.7ms, max_proc_keys: 1, p95_proc_keys: 0, tot_proc: 20m37.8s, tot_wait: 4.18s, rpc_num: 3122, rpc_time: 22m21.6s, copr_cache_hit_ratio: 0.12} 609 Bytes N/A
└─Limit_10 cop[tikv] 1 offset:0, count:1 1 tikv_task:{proc max:1.05s, min:0s, p80:543ms, p95:617ms, iters:3122, tasks:3122}, scan_detail: {total_process_keys: 1, total_keys: 2562906823, rocksdb: {delete_skipped_count: 10718623, key_skipped_count: 2577837683, block: {cache_hit_count: 35660, read_count: 3994627, read_byte: 19.9 GB}}} N/A N/A
└─TableFullScan_9 cop[tikv] 1 table:dws_if_date_shence_promotion_data_hive, keep order:false 1 tikv_task:{proc max:1.05s, min:0s, p80:543ms, p95:617ms, iters:3122, tasks:3122}, scan_detail: {total_process_keys: 0, total_keys: 0, rocksdb: {delete_skipped_count: 0, key_skipped_count: 0, block: {cache_hit_count: 0, read_count: 0, read_byte: 0 Bytes}}} N/A N/A
select /*+ LIMIT_TO_COP() */ * from sharpengine_bi.dws_if_date_shence_promotion_data_hive limit 1
效果一样，
论坛里面有这个帖子
我的使用场景和他差不多，只是这个语句我没法像他一样增加where调整，