limit 1变快了 但是目测是因为有缓存 limit100照样非常慢
Limit_7 1.00 1 root time:2.1s, loops:2 offset:0, count:1 N/A N/A
└─TableReader_11 1.00 1 root time:2.1s, loops:1, cop_task: {num: 1445, max: 283ms, min: 181µs, avg: 1.42ms, p95: 1.92ms, max_proc_keys: 1, p95_proc_keys: 0, tot_proc: 995ms, tot_wait: 151ms, rpc_num: 1445, rpc_time: 2.04s, copr_cache_hit_ratio: 1.00, distsql_concurrency: 1} data:Limit_10 540 Bytes N/A
└─Limit_10 1.00 1 cop[tikv] tikv_task:{proc max:752ms, min:0s, avg: 376.1ms, p80:483ms, p95:552ms, iters:1445, tasks:1445}, scan_detail: {total_process_keys: 1, total_process_keys_size: 152, total_keys: 4129043, get_snapshot_time: 547.2ms, rocksdb: {delete_skipped_count: 270700, key_skipped_count: 4399736, block: {cache_hit_count: 6387, read_count: 1, read_byte: 64.0 KB, read_time: 64.7µs}}} offset:0, count:1 N/A N/A
└─TableFullScan_9 1.00 1 cop[tikv] table:h_equip_bin_box_status_history tikv_task:{proc max:752ms, min:0s, avg: 376.1ms, p80:483ms, p95:552ms, iters:1445, tasks:1445} keep order:false N/A N/A