mysql> explain analyze select o_orderkey from orders where exists (select 1 from lineitem where lineitem.l_suppkey = orders.o_custkey);
+-----------------------------+-------------+----------+-----------+----------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------------------------------------------------------------------------------------------------+---------+---------+
| id                          | estRows     | actRows  | task      | access object  | execution info                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | operator info                                                                                       | memory  | disk    |
+-----------------------------+-------------+----------+-----------+----------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------------------------------------------------------------------------------------------------+---------+---------+
| HashJoin_10                 | 12492339.20 | 999503   | root      |                | time:13.3s, open:159.9µs, close:26.1µs, loops:993, RU:232943.15, build_hash_table:{concurrency:5, total:2.24s, fetch:1.2s, partition:4.67s, max_partition:939.2ms, build:341.3ms, max_build:101.1ms}, probe:{concurrency:5, total:13s, max:13s, probe:10s, fetch_and_wait:2.94s, probe_collision:59203192}, spill:{round:1, spilled_partition_num_per_round:[5/8], total_spill_GiB_per_round:[1.64], build_spill_row_table_GiB_per_round:[0.50], build_spill_hash_table_per_round:[0.12]}   | semi join, left side:TableReader_12, equal:[eq(tpch10.orders.o_custkey, tpch10.lineitem.l_suppkey)] | 1.02 GB | 1.64 GB |
| ├─TableReader_12(Build)     | 15615424.00 | 15000000 | root      |                | time:529.1ms, open:73.7µs, close:14.6µs, loops:14668, cop_task: {num: 379, max: 58.5ms, min: 194.1µs, avg: 29.9ms, p95: 50.9ms, max_proc_keys: 50144, p95_proc_keys: 50144, tot_proc: 10.9s, tot_wait: 21.9ms, copr_cache_hit_ratio: 0.07, build_task_duration: 26.6µs, max_distsql_concurrency: 10}, rpc_info:{Cop:{num_rpc:379, total_time:11.3s}}                                                                                                                                        | data:TableFullScan_11                                                                               | 3.07 MB | N/A     |
| │ └─TableFullScan_11        | 15615424.00 | 15000000 | cop[tikv] | table:orders   | tikv_task:{proc max:57ms, min:0s, avg: 27.7ms, p80:38ms, p95:48ms, iters:16165, tasks:379}, scan_detail: {total_process_keys: 14925888, total_process_keys_size: 2266487226, total_keys: 14926239, get_snapshot_time: 12.3ms, rocksdb: {key_skipped_count: 14925888, block: {cache_hit_count: 76865}}}, time_detail: {total_process_time: 10.9s, total_suspend_time: 21.8ms, total_wait_time: 21.9ms, total_kv_read_wall_time: 10.4s, tikv_wall_time: 11s}                                  | keep order:false                                                                                    | N/A     | N/A     |
| └─TableReader_14(Probe)     | 59986052.00 | 59986052 | root      |                | time:568ms, open:68.5µs, close:3.8µs, loops:58643, cop_task: {num: 1605, max: 66.6ms, min: 305.3µs, avg: 27.6ms, p95: 50ms, max_proc_keys: 50144, p95_proc_keys: 50144, tot_proc: 43s, tot_wait: 96.2ms, copr_cache_hit_ratio: 0.00, build_task_duration: 46.7µs, max_distsql_concurrency: 15}, rpc_info:{Cop:{num_rpc:1605, total_time:44.2s}}                                                                                                                                             | data:TableFullScan_13                                                                               | 4.39 MB | N/A     |
|   └─TableFullScan_13        | 59986052.00 | 59986052 | cop[tikv] | table:lineitem | tikv_task:{proc max:65ms, min:0s, avg: 26ms, p80:36ms, p95:47ms, iters:64976, tasks:1605}, scan_detail: {total_process_keys: 59975940, total_process_keys_size: 11761091416, total_keys: 59977541, get_snapshot_time: 48.2ms, rocksdb: {key_skipped_count: 59975940, block: {cache_hit_count: 378694}}}, time_detail: {total_process_time: 43s, total_suspend_time: 89.5ms, total_wait_time: 96.2ms, total_kv_read_wall_time: 41.8s, tikv_wall_time: 43.3s}                                 | keep order:false                                                                                    | N/A     | N/A     |
+-----------------------------+-------------+----------+-----------+----------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------------------------------------------------------------------------------------------------+---------+---------+
5 rows in set (13.35 sec)

None