SuccessConsole Output

Skipping 1,193 KB.. Full Log
pp.ps_suppkey)->tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_availqty)->tpch50.partsupp.ps_availqty, funcs:sum(tpch50.lineitem.l_quantity)->Column#44	194.5 MB	N/A
20:38:11 [2021-06-07T20:38:11.146Z]         └─HashJoin_59	9711455.06	634004	root		time:37s, loops:626, build_hash_table:{total:2.44s, fetch:2.23s, build:208.7ms}, probe:{concurrency:5, total:3m5.2s, max:37s, probe:14.7s, fetch:2m50.6s}	left outer join, equal:[eq(tpch50.partsupp.ps_partkey, tpch50.lineitem.l_partkey) eq(tpch50.partsupp.ps_suppkey, tpch50.lineitem.l_suppkey)]	10.4 MB	0 Bytes
20:38:11 [2021-06-07T20:38:11.146Z]           ├─IndexHashJoin_67(Build)	321865.05	435528	root		time:2.39s, loops:429, inner:{total:2.44s, concurrency:5, task:12, construct:119ms, fetch:1.98s, build:30.8ms, join:334.2ms}	inner join, inner:IndexLookUp_64, outer key:tpch50.part.p_partkey, inner key:tpch50.partsupp.ps_partkey, equal cond:eq(tpch50.part.p_partkey, tpch50.partsupp.ps_partkey)	20.0 MB	N/A
20:38:11 [2021-06-07T20:38:11.146Z]           │ ├─TableReader_96(Build)	80007.93	108882	root		time:2.06s, loops:112, cop_task: {num: 20, max: 1.5s, min: 584.8ms, avg: 1.06s, p95: 1.5s, max_proc_keys: 686055, p95_proc_keys: 686055, tot_proc: 21.1s, tot_wait: 5ms, rpc_num: 20, rpc_time: 21.1s, copr_cache: disabled}	data:Selection_95	725.8 KB	N/A
20:38:11 [2021-06-07T20:38:11.146Z]           │ │ └─Selection_95	80007.93	108882	cop[tikv]		tikv_task:{proc max:1.47s, min:578ms, p80:1.25s, p95:1.47s, iters:9859, tasks:20}, scan_detail: {total_process_keys: 10000000, total_keys: 10000020, rocksdb: {delete_skipped_count: 0, key_skipped_count: 19999980, block: {cache_hit_count: 31499, read_count: 0, read_byte: 0 Bytes}}}	like(tpch50.part.p_name, "green%", 92)	N/A	N/A
20:38:11 [2021-06-07T20:38:11.146Z]           │ │   └─TableFullScan_94	10000000.00	10000000	cop[tikv]	table:part	tikv_task:{proc max:1.36s, min:534ms, p80:1.16s, p95:1.36s, iters:9859, tasks:20}	keep order:false	N/A	N/A
20:38:11 [2021-06-07T20:38:11.146Z]           │ └─IndexLookUp_64(Probe)	4.02	435528	root		time:1.89s, loops:447, index_task: {total_time: 1.12s, fetch_handle: 1.12s, build: 141.9µs, wait: 289.5µs}, table_task: {total_time: 7.41s, num: 57, concurrency: 60}		20.7 KB	N/A
20:38:11 [2021-06-07T20:38:11.146Z]           │   ├─IndexRangeScan_62(Build)	4.02	435528	cop[tikv]	table:partsupp, index:PRIMARY(PS_PARTKEY, PS_SUPPKEY)	time:1.07s, loops:480, cop_task: {num: 58, max: 214.9ms, min: 6.37ms, avg: 86.5ms, p95: 187ms, max_proc_keys: 15288, p95_proc_keys: 14960, tot_proc: 4.68s, tot_wait: 8ms, rpc_num: 58, rpc_time: 5.02s, copr_cache: disabled}, tikv_task:{proc max:204ms, min:4ms, p80:137ms, p95:178ms, iters:689, tasks:58}, scan_detail: {total_process_keys: 435528, total_keys: 544410, rocksdb: {delete_skipped_count: 0, key_skipped_count: 435528, block: {cache_hit_count: 980292, read_count: 0, read_byte: 0 Bytes}}}	range: decided by [eq(tpch50.partsupp.ps_partkey, tpch50.part.p_partkey)], keep order:false	N/A	N/A
20:38:11 [2021-06-07T20:38:11.146Z]           │   └─TableRowIDScan_63(Probe)	4.02	435528	cop[tikv]	table:partsupp	time:2.44s, loops:509, cop_task: {num: 1369, max: 65.7ms, min: 425.7µs, avg: 18ms, p95: 36.8ms, max_proc_keys: 976, p95_proc_keys: 632, tot_proc: 18.2s, tot_wait: 4.45s, rpc_num: 1369, rpc_time: 24.6s, copr_cache: disabled}, tikv_task:{proc max:44ms, min:0s, p80:17ms, p95:24ms, iters:5154, tasks:1369}, scan_detail: {total_process_keys: 435528, total_keys: 473522, rocksdb: {delete_skipped_count: 0, key_skipped_count: 194122, block: {cache_hit_count: 3643751, read_count: 1, read_byte: 26.8 KB}}}	keep order:false	N/A	N/A
20:38:11 [2021-06-07T20:38:11.146Z]           └─TableReader_101(Probe)	46310896.67	45504356	root		time:32.6s, loops:44290, cop_task: {num: 761, max: 1.22s, min: 367.1ms, avg: 691.1ms, p95: 834.8ms, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 8m42.8s, tot_wait: 134ms, rpc_num: 761, rpc_time: 8m45.9s, copr_cache: disabled}	data:Selection_100	52.6 MB	N/A
20:38:11 [2021-06-07T20:38:11.146Z]             └─Selection_100	46310896.67	45504356	cop[tikv]		tikv_task:{proc max:1.14s, min:358ms, p80:739ms, p95:816ms, iters:296606, tasks:761}, scan_detail: {total_process_keys: 300005811, total_keys: 300006572, rocksdb: {delete_skipped_count: 0, key_skipped_count: 600010861, block: {cache_hit_count: 1124648, read_count: 0, read_byte: 0 Bytes}}}	ge(tpch50.lineitem.l_shipdate, 1993-01-01 00:00:00.000000), lt(tpch50.lineitem.l_shipdate, 1994-01-01)	N/A	N/A
20:38:11 [2021-06-07T20:38:11.146Z]               └─TableFullScan_99	300005811.00	300005811	cop[tikv]	table:lineitem	tikv_task:{proc max:1.08s, min:335ms, p80:708ms, p95:785ms, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:38:11 [2021-06-07T20:38:11.146Z] + sync
20:38:11 [2021-06-07T20:38:11.146Z] + /usr/bin/echo 3
20:38:49 [2021-06-07T20:38:49.794Z] + sync
20:38:49 [2021-06-07T20:38:49.794Z] + /usr/bin/echo 3
20:39:36 [2021-06-07T20:39:36.399Z] 
20:39:36 [2021-06-07T20:39:36.399Z] queries/20.sql
20:39:36 [2021-06-07T20:39:36.399Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:39:36 [2021-06-07T20:39:36.399Z] Sort_30	20000.00	8982	root		time:37.9s, loops:10	tpch50.supplier.s_name	614.3 KB	0 Bytes
20:39:36 [2021-06-07T20:39:36.399Z] └─HashJoin_35	20000.00	8982	root		time:37.8s, loops:11, build_hash_table:{total:1.34s, fetch:1.33s, build:11.5ms}, probe:{concurrency:5, total:3m9.2s, max:37.8s, probe:51.4ms, fetch:3m9.2s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.partsupp.ps_suppkey)]	1.50 MB	0 Bytes
20:39:36 [2021-06-07T20:39:36.399Z]   ├─HashJoin_48(Build)	20000.00	19972	root		time:1.34s, loops:23, build_hash_table:{total:223.4µs, fetch:217.5µs, build:5.88µs}, probe:{concurrency:5, total:6.71s, max:1.34s, probe:118.7ms, fetch:6.59s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:39:36 [2021-06-07T20:39:36.399Z]   │ ├─TableReader_53(Build)	1.00	1	root		time:51.4µs, loops:2, cop_task: {num: 1, max: 1.03ms, proc_keys: 25, rpc_num: 1, rpc_time: 1.02ms, copr_cache: disabled}	data:Selection_52	236 Bytes	N/A
20:39:36 [2021-06-07T20:39:36.400Z]   │ │ └─Selection_52	1.00	1	cop[tikv]		tikv_task:{time:0s, loops:1}, scan_detail: {total_process_keys: 25, total_keys: 26, rocksdb: {delete_skipped_count: 0, key_skipped_count: 46, block: {cache_hit_count: 18, read_count: 0, read_byte: 0 Bytes}}}	eq(tpch50.nation.n_name, "ALGERIA")	N/A	N/A
20:39:36 [2021-06-07T20:39:36.400Z]   │ │   └─TableFullScan_51	25.00	25	cop[tikv]	table:nation	tikv_task:{time:0s, loops:1}	keep order:false	N/A	N/A
20:39:36 [2021-06-07T20:39:36.400Z]   │ └─TableReader_50(Probe)	500000.00	500000	root		time:1.32s, loops:490, cop_task: {num: 1, max: 1.32s, proc_keys: 500000, tot_proc: 1.24s, rpc_num: 1, rpc_time: 1.32s, copr_cache: disabled}	data:TableFullScan_49	35.8 MB	N/A
20:39:36 [2021-06-07T20:39:36.400Z]   │   └─TableFullScan_49	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:1.1s, loops:493}, scan_detail: {total_process_keys: 500000, total_keys: 500001, rocksdb: {delete_skipped_count: 0, key_skipped_count: 999999, block: {cache_hit_count: 1692, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:39:36 [2021-06-07T20:39:36.400Z]   └─HashAgg_54(Probe)	257492.04	223999	root		time:37.8s, loops:222, partial_worker:{wall_time:37.773073294s, concurrency:5, task_num:289, tot_wait:3m8.589953179s, tot_exec:231.500002ms, tot_time:3m8.857586212s, max:37.77301074s, p95:37.77301074s}, final_worker:{wall_time:37.840533834s, concurrency:5, task_num:25, tot_wait:3m8.851795454s, tot_exec:341.659893ms, tot_time:3m9.193467473s, max:37.84048628s, p95:37.84048628s}	group by:tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_suppkey)->tpch50.partsupp.ps_suppkey	61.4 MB	N/A
20:39:36 [2021-06-07T20:39:36.400Z]     └─Selection_55	257492.04	295898	root		time:37.8s, loops:290	gt(cast(tpch50.partsupp.ps_availqty, decimal(20,0) BINARY), mul(0.5, Column#44))	59.2 KB	N/A
20:39:36 [2021-06-07T20:39:36.400Z]       └─HashAgg_56	321865.05	435528	root		time:37.6s, loops:430, partial_worker:{wall_time:37.421550353s, concurrency:5, task_num:623, tot_wait:3m5.810633658s, tot_exec:1.169144337s, tot_time:3m7.094235592s, max:37.42149166s, p95:37.42149166s}, final_worker:{wall_time:37.762064s, concurrency:5, task_num:25, tot_wait:3m7.07595575s, tot_exec:1.621402141s, tot_time:3m8.697373979s, max:37.762012883s, p95:37.762012883s}	group by:tpch50.partsupp.ps_partkey, tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_suppkey)->tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_availqty)->tpch50.partsupp.ps_availqty, funcs:sum(tpch50.lineitem.l_quantity)->Column#44	194.5 MB	N/A
20:39:36 [2021-06-07T20:39:36.400Z]         └─HashJoin_59	9711455.06	634004	root		time:37.3s, loops:624, build_hash_table:{total:2.32s, fetch:2.12s, build:201.4ms}, probe:{concurrency:5, total:3m6.6s, max:37.3s, probe:14.8s, fetch:2m51.8s}	left outer join, equal:[eq(tpch50.partsupp.ps_partkey, tpch50.lineitem.l_partkey) eq(tpch50.partsupp.ps_suppkey, tpch50.lineitem.l_suppkey)]	10.4 MB	0 Bytes
20:39:36 [2021-06-07T20:39:36.400Z]           ├─IndexHashJoin_67(Build)	321865.05	435528	root		time:2.28s, loops:429, inner:{total:2.67s, concurrency:5, task:12, construct:145.4ms, fetch:2.2s, build:34.8ms, join:322ms}	inner join, inner:IndexLookUp_64, outer key:tpch50.part.p_partkey, inner key:tpch50.partsupp.ps_partkey, equal cond:eq(tpch50.part.p_partkey, tpch50.partsupp.ps_partkey)	20.0 MB	N/A
20:39:36 [2021-06-07T20:39:36.400Z]           │ ├─TableReader_96(Build)	80007.93	108882	root		time:1.93s, loops:112, cop_task: {num: 20, max: 1.52s, min: 495.7ms, avg: 1.03s, p95: 1.52s, max_proc_keys: 686055, p95_proc_keys: 686055, tot_proc: 20.5s, tot_wait: 22ms, rpc_num: 20, rpc_time: 20.6s, copr_cache: disabled}	data:Selection_95	657.9 KB	N/A
20:39:36 [2021-06-07T20:39:36.400Z]           │ │ └─Selection_95	80007.93	108882	cop[tikv]		tikv_task:{proc max:1.5s, min:493ms, p80:1.22s, p95:1.5s, iters:9859, tasks:20}, scan_detail: {total_process_keys: 10000000, total_keys: 10000020, rocksdb: {delete_skipped_count: 0, key_skipped_count: 19999980, block: {cache_hit_count: 31499, read_count: 0, read_byte: 0 Bytes}}}	like(tpch50.part.p_name, "green%", 92)	N/A	N/A
20:39:36 [2021-06-07T20:39:36.400Z]           │ │   └─TableFullScan_94	10000000.00	10000000	cop[tikv]	table:part	tikv_task:{proc max:1.38s, min:458ms, p80:1.13s, p95:1.38s, iters:9859, tasks:20}	keep order:false	N/A	N/A
20:39:36 [2021-06-07T20:39:36.400Z]           │ └─IndexLookUp_64(Probe)	4.02	435528	root		time:2.1s, loops:447, index_task: {total_time: 1.22s, fetch_handle: 1.22s, build: 115.4µs, wait: 283.9µs}, table_task: {total_time: 8.12s, num: 56, concurrency: 60}		20.7 KB	N/A
20:39:36 [2021-06-07T20:39:36.400Z]           │   ├─IndexRangeScan_62(Build)	4.02	435528	cop[tikv]	table:partsupp, index:PRIMARY(PS_PARTKEY, PS_SUPPKEY)	time:1.18s, loops:475, cop_task: {num: 57, max: 207.3ms, min: 5.41ms, avg: 93.2ms, p95: 190.7ms, max_proc_keys: 15288, p95_proc_keys: 15008, tot_proc: 4.7s, tot_wait: 187ms, rpc_num: 57, rpc_time: 5.31s, copr_cache: disabled}, tikv_task:{proc max:187ms, min:4ms, p80:142ms, p95:174ms, iters:679, tasks:57}, scan_detail: {total_process_keys: 435528, total_keys: 544410, rocksdb: {delete_skipped_count: 0, key_skipped_count: 435528, block: {cache_hit_count: 980292, read_count: 0, read_byte: 0 Bytes}}}	range: decided by [eq(tpch50.partsupp.ps_partkey, tpch50.part.p_partkey)], keep order:false	N/A	N/A
20:39:36 [2021-06-07T20:39:36.400Z]           │   └─TableRowIDScan_63(Probe)	4.02	435528	cop[tikv]	table:partsupp	time:2.67s, loops:505, cop_task: {num: 1501, max: 91.3ms, min: 443.5µs, avg: 17.9ms, p95: 35.2ms, max_proc_keys: 976, p95_proc_keys: 492, tot_proc: 19.3s, tot_wait: 5.6s, rpc_num: 1501, rpc_time: 26.8s, copr_cache: disabled}, tikv_task:{proc max:46ms, min:0s, p80:16ms, p95:21ms, iters:5484, tasks:1501}, scan_detail: {total_process_keys: 435528, total_keys: 473486, rocksdb: {delete_skipped_count: 0, key_skipped_count: 193990, block: {cache_hit_count: 3644758, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:39:36 [2021-06-07T20:39:36.400Z]           └─TableReader_101(Probe)	46310896.67	45504356	root		time:32.9s, loops:44290, cop_task: {num: 761, max: 1.22s, min: 285.3ms, avg: 700ms, p95: 850.7ms, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 8m49.6s, tot_wait: 127ms, rpc_num: 761, rpc_time: 8m52.7s, copr_cache: disabled}	data:Selection_100	52.6 MB	N/A
20:39:36 [2021-06-07T20:39:36.400Z]             └─Selection_100	46310896.67	45504356	cop[tikv]		tikv_task:{proc max:1.19s, min:280ms, p80:747ms, p95:833ms, iters:296606, tasks:761}, scan_detail: {total_process_keys: 300005811, total_keys: 300006572, rocksdb: {delete_skipped_count: 0, key_skipped_count: 600010861, block: {cache_hit_count: 1124648, read_count: 0, read_byte: 0 Bytes}}}	ge(tpch50.lineitem.l_shipdate, 1993-01-01 00:00:00.000000), lt(tpch50.lineitem.l_shipdate, 1994-01-01)	N/A	N/A
20:39:36 [2021-06-07T20:39:36.400Z]               └─TableFullScan_99	300005811.00	300005811	cop[tikv]	table:lineitem	tikv_task:{proc max:1.14s, min:272ms, p80:715ms, p95:801ms, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:39:36 [2021-06-07T20:39:36.400Z] 
20:39:36 [2021-06-07T20:39:36.400Z] queries/20.sql
20:39:36 [2021-06-07T20:39:36.400Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:39:36 [2021-06-07T20:39:36.400Z] Sort_30	20000.00	8982	root		time:38s, loops:10	tpch50.supplier.s_name	614.3 KB	0 Bytes
20:39:36 [2021-06-07T20:39:36.400Z] └─HashJoin_35	20000.00	8982	root		time:37.9s, loops:11, build_hash_table:{total:1.23s, fetch:1.23s, build:8.27ms}, probe:{concurrency:5, total:3m9.7s, max:37.9s, probe:46.4ms, fetch:3m9.7s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.partsupp.ps_suppkey)]	1.51 MB	0 Bytes
20:39:36 [2021-06-07T20:39:36.400Z]   ├─HashJoin_48(Build)	20000.00	19972	root		time:1.23s, loops:23, build_hash_table:{total:228.9µs, fetch:221.9µs, build:7.06µs}, probe:{concurrency:5, total:6.16s, max:1.23s, probe:81.3ms, fetch:6.08s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:39:36 [2021-06-07T20:39:36.400Z]   │ ├─TableReader_53(Build)	1.00	1	root		time:40.1µs, loops:2, cop_task: {num: 1, max: 840.9µs, proc_keys: 25, rpc_num: 1, rpc_time: 826.1µs, copr_cache: disabled}	data:Selection_52	236 Bytes	N/A
20:39:36 [2021-06-07T20:39:36.400Z]   │ │ └─Selection_52	1.00	1	cop[tikv]		tikv_task:{time:0s, loops:1}, scan_detail: {total_process_keys: 25, total_keys: 26, rocksdb: {delete_skipped_count: 0, key_skipped_count: 46, block: {cache_hit_count: 18, read_count: 0, read_byte: 0 Bytes}}}	eq(tpch50.nation.n_name, "ALGERIA")	N/A	N/A
20:39:36 [2021-06-07T20:39:36.400Z]   │ │   └─TableFullScan_51	25.00	25	cop[tikv]	table:nation	tikv_task:{time:0s, loops:1}	keep order:false	N/A	N/A
20:39:36 [2021-06-07T20:39:36.400Z]   │ └─TableReader_50(Probe)	500000.00	500000	root		time:1.22s, loops:490, cop_task: {num: 1, max: 1.22s, proc_keys: 500000, tot_proc: 1.16s, rpc_num: 1, rpc_time: 1.22s, copr_cache: disabled}	data:TableFullScan_49	35.8 MB	N/A
20:39:36 [2021-06-07T20:39:36.400Z]   │   └─TableFullScan_49	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:1.01s, loops:493}, scan_detail: {total_process_keys: 500000, total_keys: 500001, rocksdb: {delete_skipped_count: 0, key_skipped_count: 999999, block: {cache_hit_count: 1692, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:39:36 [2021-06-07T20:39:36.400Z]   └─HashAgg_54(Probe)	257492.04	223999	root		time:37.9s, loops:222, partial_worker:{wall_time:37.876947727s, concurrency:5, task_num:289, tot_wait:3m8.931106619s, tot_exec:312.032444ms, tot_time:3m9.379609799s, max:37.876493903s, p95:37.876493903s}, final_worker:{wall_time:37.948144901s, concurrency:5, task_num:25, tot_wait:3m9.373794571s, tot_exec:349.307783ms, tot_time:3m9.723114151s, max:37.947671194s, p95:37.947671194s}	group by:tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_suppkey)->tpch50.partsupp.ps_suppkey	61.4 MB	N/A
20:39:36 [2021-06-07T20:39:36.400Z]     └─Selection_55	257492.04	295898	root		time:37.8s, loops:290	gt(cast(tpch50.partsupp.ps_availqty, decimal(20,0) BINARY), mul(0.5, Column#44))	59.2 KB	N/A
20:39:36 [2021-06-07T20:39:36.400Z]       └─HashAgg_56	321865.05	435528	root		time:37.7s, loops:430, partial_worker:{wall_time:37.474257592s, concurrency:5, task_num:624, tot_wait:3m6.149693814s, tot_exec:1.076413671s, tot_time:3m7.352406185s, max:37.474220635s, p95:37.474220635s}, final_worker:{wall_time:37.835849794s, concurrency:5, task_num:25, tot_wait:3m7.316970789s, tot_exec:1.839934223s, tot_time:3m9.15692406s, max:37.835812564s, p95:37.835812564s}	group by:tpch50.partsupp.ps_partkey, tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_suppkey)->tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_availqty)->tpch50.partsupp.ps_availqty, funcs:sum(tpch50.lineitem.l_quantity)->Column#44	194.5 MB	N/A
20:39:36 [2021-06-07T20:39:36.400Z]         └─HashJoin_59	9711455.06	634004	root		time:37.4s, loops:625, build_hash_table:{total:2.44s, fetch:2.24s, build:199.4ms}, probe:{concurrency:5, total:3m6.9s, max:37.4s, probe:14.4s, fetch:2m52.6s}	left outer join, equal:[eq(tpch50.partsupp.ps_partkey, tpch50.lineitem.l_partkey) eq(tpch50.partsupp.ps_suppkey, tpch50.lineitem.l_suppkey)]	10.4 MB	0 Bytes
20:39:36 [2021-06-07T20:39:36.400Z]           ├─IndexHashJoin_67(Build)	321865.05	435528	root		time:2.41s, loops:430, inner:{total:2.52s, concurrency:5, task:12, construct:111.3ms, fetch:2.09s, build:23.5ms, join:321.1ms}	inner join, inner:IndexLookUp_64, outer key:tpch50.part.p_partkey, inner key:tpch50.partsupp.ps_partkey, equal cond:eq(tpch50.part.p_partkey, tpch50.partsupp.ps_partkey)	20.0 MB	N/A
20:39:36 [2021-06-07T20:39:36.400Z]           │ ├─TableReader_96(Build)	80007.93	108882	root		time:2.08s, loops:112, cop_task: {num: 20, max: 1.37s, min: 649.3ms, avg: 1.08s, p95: 1.37s, max_proc_keys: 686055, p95_proc_keys: 686055, tot_proc: 21.3s, tot_wait: 14ms, rpc_num: 20, rpc_time: 21.6s, copr_cache: disabled}	data:Selection_95	1.00 MB	N/A
20:39:36 [2021-06-07T20:39:36.400Z]           │ │ └─Selection_95	80007.93	108882	cop[tikv]		tikv_task:{proc max:1.36s, min:643ms, p80:1.25s, p95:1.36s, iters:9859, tasks:20}, scan_detail: {total_process_keys: 10000000, total_keys: 10000020, rocksdb: {delete_skipped_count: 0, key_skipped_count: 19999980, block: {cache_hit_count: 31499, read_count: 0, read_byte: 0 Bytes}}}	like(tpch50.part.p_name, "green%", 92)	N/A	N/A
20:39:36 [2021-06-07T20:39:36.400Z]           │ │   └─TableFullScan_94	10000000.00	10000000	cop[tikv]	table:part	tikv_task:{proc max:1.26s, min:599ms, p80:1.16s, p95:1.26s, iters:9859, tasks:20}	keep order:false	N/A	N/A
20:39:36 [2021-06-07T20:39:36.400Z]           │ └─IndexLookUp_64(Probe)	4.02	435528	root		time:2s, loops:447, index_task: {total_time: 1.16s, fetch_handle: 1.16s, build: 92.7µs, wait: 299.6µs}, table_task: {total_time: 7.85s, num: 56, concurrency: 60}		20.5 KB	N/A
20:39:36 [2021-06-07T20:39:36.400Z]           │   ├─IndexRangeScan_62(Build)	4.02	435528	cop[tikv]	table:partsupp, index:PRIMARY(PS_PARTKEY, PS_SUPPKEY)	time:1.12s, loops:481, cop_task: {num: 59, max: 214.3ms, min: 4.78ms, avg: 85.7ms, p95: 177.6ms, max_proc_keys: 15288, p95_proc_keys: 15008, tot_proc: 4.69s, tot_wait: 32ms, rpc_num: 59, rpc_time: 5.06s, copr_cache: disabled}, tikv_task:{proc max:195ms, min:4ms, p80:132ms, p95:162ms, iters:693, tasks:59}, scan_detail: {total_process_keys: 435528, total_keys: 544410, rocksdb: {delete_skipped_count: 0, key_skipped_count: 435528, block: {cache_hit_count: 980292, read_count: 0, read_byte: 0 Bytes}}}	range: decided by [eq(tpch50.partsupp.ps_partkey, tpch50.part.p_partkey)], keep order:false	N/A	N/A
20:39:36 [2021-06-07T20:39:36.400Z]           │   └─TableRowIDScan_63(Probe)	4.02	435528	cop[tikv]	table:partsupp	time:2.59s, loops:506, cop_task: {num: 1430, max: 66ms, min: 744.9µs, avg: 19.1ms, p95: 37.3ms, max_proc_keys: 908, p95_proc_keys: 600, tot_proc: 19.2s, tot_wait: 5.93s, rpc_num: 1430, rpc_time: 27.3s, copr_cache: disabled}, tikv_task:{proc max:51ms, min:0s, p80:17ms, p95:23ms, iters:5301, tasks:1430}, scan_detail: {total_process_keys: 435528, total_keys: 473506, rocksdb: {delete_skipped_count: 0, key_skipped_count: 194076, block: {cache_hit_count: 3644034, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:39:36 [2021-06-07T20:39:36.400Z]           └─TableReader_101(Probe)	46310896.67	45504356	root		time:33s, loops:44289, cop_task: {num: 761, max: 1.22s, min: 417.7ms, avg: 698.9ms, p95: 846.7ms, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 8m48.7s, tot_wait: 107ms, rpc_num: 761, rpc_time: 8m51.8s, copr_cache: disabled}	data:Selection_100	52.6 MB	N/A
20:39:36 [2021-06-07T20:39:36.400Z]             └─Selection_100	46310896.67	45504356	cop[tikv]		tikv_task:{proc max:1.14s, min:408ms, p80:750ms, p95:826ms, iters:296606, tasks:761}, scan_detail: {total_process_keys: 300005811, total_keys: 300006572, rocksdb: {delete_skipped_count: 0, key_skipped_count: 600010861, block: {cache_hit_count: 1124648, read_count: 0, read_byte: 0 Bytes}}}	ge(tpch50.lineitem.l_shipdate, 1993-01-01 00:00:00.000000), lt(tpch50.lineitem.l_shipdate, 1994-01-01)	N/A	N/A
20:39:36 [2021-06-07T20:39:36.400Z]               └─TableFullScan_99	300005811.00	300005811	cop[tikv]	table:lineitem	tikv_task:{proc max:1.1s, min:390ms, p80:718ms, p95:794ms, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:39:36 [2021-06-07T20:39:36.400Z] + sync
20:39:36 [2021-06-07T20:39:36.400Z] + /usr/bin/echo 3
20:40:15 [2021-06-07T20:40:15.192Z] + sync
20:40:15 [2021-06-07T20:40:15.192Z] + /usr/bin/echo 3
20:40:53 [2021-06-07T20:40:53.837Z] 
20:40:53 [2021-06-07T20:40:53.837Z] queries/20.sql
20:40:53 [2021-06-07T20:40:53.837Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:40:53 [2021-06-07T20:40:53.837Z] Sort_30	20000.00	8982	root		time:38.3s, loops:10	tpch50.supplier.s_name	607.7 KB	0 Bytes
20:40:53 [2021-06-07T20:40:53.837Z] └─HashJoin_35	20000.00	8982	root		time:38.3s, loops:11, build_hash_table:{total:1.39s, fetch:1.38s, build:9.02ms}, probe:{concurrency:5, total:3m11.5s, max:38.3s, probe:49.7ms, fetch:3m11.4s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.partsupp.ps_suppkey)]	1.47 MB	0 Bytes
20:40:53 [2021-06-07T20:40:53.837Z]   ├─HashJoin_48(Build)	20000.00	19972	root		time:1.39s, loops:22, build_hash_table:{total:131µs, fetch:126.1µs, build:4.9µs}, probe:{concurrency:5, total:6.95s, max:1.39s, probe:104.3ms, fetch:6.84s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:40:53 [2021-06-07T20:40:53.837Z]   │ ├─TableReader_53(Build)	1.00	1	root		time:35.7µs, loops:2, cop_task: {num: 1, max: 1.13ms, proc_keys: 25, tot_proc: 1ms, rpc_num: 1, rpc_time: 1.11ms, copr_cache: disabled}	data:Selection_52	244 Bytes	N/A
20:40:53 [2021-06-07T20:40:53.837Z]   │ │ └─Selection_52	1.00	1	cop[tikv]		tikv_task:{time:1ms, loops:1}, scan_detail: {total_process_keys: 25, total_keys: 26, rocksdb: {delete_skipped_count: 0, key_skipped_count: 46, block: {cache_hit_count: 18, read_count: 0, read_byte: 0 Bytes}}}	eq(tpch50.nation.n_name, "ALGERIA")	N/A	N/A
20:40:53 [2021-06-07T20:40:53.837Z]   │ │   └─TableFullScan_51	25.00	25	cop[tikv]	table:nation	tikv_task:{time:1ms, loops:1}	keep order:false	N/A	N/A
20:40:53 [2021-06-07T20:40:53.837Z]   │ └─TableReader_50(Probe)	500000.00	500000	root		time:1.37s, loops:490, cop_task: {num: 1, max: 1.37s, proc_keys: 500000, tot_proc: 1.29s, rpc_num: 1, rpc_time: 1.37s, copr_cache: disabled}	data:TableFullScan_49	35.8 MB	N/A
20:40:53 [2021-06-07T20:40:53.837Z]   │   └─TableFullScan_49	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:1.14s, loops:493}, scan_detail: {total_process_keys: 500000, total_keys: 500001, rocksdb: {delete_skipped_count: 0, key_skipped_count: 999999, block: {cache_hit_count: 1692, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:40:53 [2021-06-07T20:40:53.837Z]   └─HashAgg_54(Probe)	257492.04	223999	root		time:38.3s, loops:222, partial_worker:{wall_time:38.223521309s, concurrency:5, task_num:289, tot_wait:3m10.705123178s, tot_exec:300.166508ms, tot_time:3m11.103724101s, max:38.223254292s, p95:38.223254292s}, final_worker:{wall_time:38.293525524s, concurrency:5, task_num:25, tot_wait:3m11.090405914s, tot_exec:340.49177ms, tot_time:3m11.430926362s, max:38.293278639s, p95:38.293278639s}	group by:tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_suppkey)->tpch50.partsupp.ps_suppkey	61.4 MB	N/A
20:40:53 [2021-06-07T20:40:53.837Z]     └─Selection_55	257492.04	295898	root		time:38.2s, loops:290	gt(cast(tpch50.partsupp.ps_availqty, decimal(20,0) BINARY), mul(0.5, Column#44))	59.2 KB	N/A
20:40:53 [2021-06-07T20:40:53.837Z]       └─HashAgg_56	321865.05	435528	root		time:38.1s, loops:430, partial_worker:{wall_time:37.831761159s, concurrency:5, task_num:625, tot_wait:3m7.987414205s, tot_exec:1.019164097s, tot_time:3m9.13365923s, max:37.831663366s, p95:37.831663366s}, final_worker:{wall_time:38.195178894s, concurrency:5, task_num:25, tot_wait:3m9.10742549s, tot_exec:1.740144956s, tot_time:3m10.847588539s, max:38.194602843s, p95:38.194602843s}	group by:tpch50.partsupp.ps_partkey, tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_suppkey)->tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_availqty)->tpch50.partsupp.ps_availqty, funcs:sum(tpch50.lineitem.l_quantity)->Column#44	194.5 MB	N/A
20:40:53 [2021-06-07T20:40:53.837Z]         └─HashJoin_59	9711455.06	634004	root		time:37.7s, loops:626, build_hash_table:{total:2.52s, fetch:2.33s, build:184.9ms}, probe:{concurrency:5, total:3m8.7s, max:37.7s, probe:13.7s, fetch:2m55.1s}	left outer join, equal:[eq(tpch50.partsupp.ps_partkey, tpch50.lineitem.l_partkey) eq(tpch50.partsupp.ps_suppkey, tpch50.lineitem.l_suppkey)]	10.4 MB	0 Bytes
20:40:53 [2021-06-07T20:40:53.837Z]           ├─IndexHashJoin_67(Build)	321865.05	435528	root		time:2.51s, loops:430, inner:{total:2.52s, concurrency:5, task:12, construct:132.1ms, fetch:2.08s, build:26.2ms, join:310.7ms}	inner join, inner:IndexLookUp_64, outer key:tpch50.part.p_partkey, inner key:tpch50.partsupp.ps_partkey, equal cond:eq(tpch50.part.p_partkey, tpch50.partsupp.ps_partkey)	20.0 MB	N/A
20:40:53 [2021-06-07T20:40:53.837Z]           │ ├─TableReader_96(Build)	80007.93	108882	root		time:2.14s, loops:112, cop_task: {num: 20, max: 1.4s, min: 645.4ms, avg: 1.07s, p95: 1.4s, max_proc_keys: 686055, p95_proc_keys: 686055, tot_proc: 21.3s, tot_wait: 8ms, rpc_num: 20, rpc_time: 21.3s, copr_cache: disabled}	data:Selection_95	725.8 KB	N/A
20:40:53 [2021-06-07T20:40:53.837Z]           │ │ └─Selection_95	80007.93	108882	cop[tikv]		tikv_task:{proc max:1.35s, min:643ms, p80:1.29s, p95:1.35s, iters:9859, tasks:20}, scan_detail: {total_process_keys: 10000000, total_keys: 10000020, rocksdb: {delete_skipped_count: 0, key_skipped_count: 19999980, block: {cache_hit_count: 31499, read_count: 0, read_byte: 0 Bytes}}}	like(tpch50.part.p_name, "green%", 92)	N/A	N/A
20:40:53 [2021-06-07T20:40:53.837Z]           │ │   └─TableFullScan_94	10000000.00	10000000	cop[tikv]	table:part	tikv_task:{proc max:1.25s, min:598ms, p80:1.2s, p95:1.25s, iters:9859, tasks:20}	keep order:false	N/A	N/A
20:40:53 [2021-06-07T20:40:53.837Z]           │ └─IndexLookUp_64(Probe)	4.02	435528	root		time:1.98s, loops:447, index_task: {total_time: 1.22s, fetch_handle: 1.22s, build: 90.6µs, wait: 272.4µs}, table_task: {total_time: 7.85s, num: 56, concurrency: 60}		19.4 KB	N/A
20:40:53 [2021-06-07T20:40:53.837Z]           │   ├─IndexRangeScan_62(Build)	4.02	435528	cop[tikv]	table:partsupp, index:PRIMARY(PS_PARTKEY, PS_SUPPKEY)	time:1.18s, loops:482, cop_task: {num: 60, max: 208.4ms, min: 5.9ms, avg: 86.2ms, p95: 184.1ms, max_proc_keys: 15288, p95_proc_keys: 14948, tot_proc: 4.77s, tot_wait: 39ms, rpc_num: 60, rpc_time: 5.17s, copr_cache: disabled}, tikv_task:{proc max:202ms, min:5ms, p80:130ms, p95:175ms, iters:698, tasks:60}, scan_detail: {total_process_keys: 435528, total_keys: 544410, rocksdb: {delete_skipped_count: 0, key_skipped_count: 435528, block: {cache_hit_count: 980292, read_count: 0, read_byte: 0 Bytes}}}	range: decided by [eq(tpch50.partsupp.ps_partkey, tpch50.part.p_partkey)], keep order:false	N/A	N/A
20:40:53 [2021-06-07T20:40:53.837Z]           │   └─TableRowIDScan_63(Probe)	4.02	435528	cop[tikv]	table:partsupp	time:2.4s, loops:503, cop_task: {num: 1423, max: 108.2ms, min: 448.7µs, avg: 17.5ms, p95: 34.9ms, max_proc_keys: 896, p95_proc_keys: 600, tot_proc: 18.2s, tot_wait: 4.31s, rpc_num: 1423, rpc_time: 24.9s, copr_cache: disabled}, tikv_task:{proc max:42ms, min:0s, p80:16ms, p95:24ms, iters:5305, tasks:1423}, scan_detail: {total_process_keys: 435528, total_keys: 473513, rocksdb: {delete_skipped_count: 0, key_skipped_count: 194097, block: {cache_hit_count: 3644018, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:40:53 [2021-06-07T20:40:53.837Z]           └─TableReader_101(Probe)	46310896.67	45504356	root		time:33.4s, loops:44290, cop_task: {num: 761, max: 1.28s, min: 380.5ms, avg: 702.9ms, p95: 857ms, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 8m51.8s, tot_wait: 120ms, rpc_num: 761, rpc_time: 8m54.9s, copr_cache: disabled}	data:Selection_100	52.6 MB	N/A
20:40:53 [2021-06-07T20:40:53.837Z]             └─Selection_100	46310896.67	45504356	cop[tikv]		tikv_task:{proc max:1.22s, min:367ms, p80:747ms, p95:838ms, iters:296606, tasks:761}, scan_detail: {total_process_keys: 300005811, total_keys: 300006572, rocksdb: {delete_skipped_count: 0, key_skipped_count: 600010861, block: {cache_hit_count: 1124648, read_count: 0, read_byte: 0 Bytes}}}	ge(tpch50.lineitem.l_shipdate, 1993-01-01 00:00:00.000000), lt(tpch50.lineitem.l_shipdate, 1994-01-01)	N/A	N/A
20:40:53 [2021-06-07T20:40:53.837Z]               └─TableFullScan_99	300005811.00	300005811	cop[tikv]	table:lineitem	tikv_task:{proc max:1.17s, min:350ms, p80:717ms, p95:803ms, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:40:53 [2021-06-07T20:40:53.837Z] 
20:40:53 [2021-06-07T20:40:53.837Z] queries/20.sql
20:40:53 [2021-06-07T20:40:53.837Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:40:53 [2021-06-07T20:40:53.837Z] Sort_30	20000.00	8982	root		time:36.7s, loops:10	tpch50.supplier.s_name	614.3 KB	0 Bytes
20:40:53 [2021-06-07T20:40:53.837Z] └─HashJoin_35	20000.00	8982	root		time:36.7s, loops:11, build_hash_table:{total:1.42s, fetch:1.41s, build:9.05ms}, probe:{concurrency:5, total:3m3.5s, max:36.7s, probe:49.9ms, fetch:3m3.5s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.partsupp.ps_suppkey)]	1.46 MB	0 Bytes
20:40:53 [2021-06-07T20:40:53.837Z]   ├─HashJoin_48(Build)	20000.00	19972	root		time:1.42s, loops:22, build_hash_table:{total:117.6µs, fetch:113.2µs, build:4.48µs}, probe:{concurrency:5, total:7.1s, max:1.42s, probe:90.4ms, fetch:7.01s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:40:53 [2021-06-07T20:40:53.837Z]   │ ├─TableReader_53(Build)	1.00	1	root		time:33.9µs, loops:2, cop_task: {num: 1, max: 2.09ms, proc_keys: 25, tot_proc: 1ms, rpc_num: 1, rpc_time: 2.08ms, copr_cache: disabled}	data:Selection_52	242 Bytes	N/A
20:40:53 [2021-06-07T20:40:53.837Z]   │ │ └─Selection_52	1.00	1	cop[tikv]		tikv_task:{time:1ms, loops:1}, scan_detail: {total_process_keys: 25, total_keys: 26, rocksdb: {delete_skipped_count: 0, key_skipped_count: 46, block: {cache_hit_count: 18, read_count: 0, read_byte: 0 Bytes}}}	eq(tpch50.nation.n_name, "ALGERIA")	N/A	N/A
20:40:53 [2021-06-07T20:40:53.837Z]   │ │   └─TableFullScan_51	25.00	25	cop[tikv]	table:nation	tikv_task:{time:0s, loops:1}	keep order:false	N/A	N/A
20:40:53 [2021-06-07T20:40:53.837Z]   │ └─TableReader_50(Probe)	500000.00	500000	root		time:1.4s, loops:490, cop_task: {num: 1, max: 1.4s, proc_keys: 500000, tot_proc: 1.34s, rpc_num: 1, rpc_time: 1.4s, copr_cache: disabled}	data:TableFullScan_49	35.8 MB	N/A
20:40:53 [2021-06-07T20:40:53.837Z]   │   └─TableFullScan_49	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:1.17s, loops:493}, scan_detail: {total_process_keys: 500000, total_keys: 500001, rocksdb: {delete_skipped_count: 0, key_skipped_count: 999999, block: {cache_hit_count: 1692, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:40:53 [2021-06-07T20:40:53.837Z]   └─HashAgg_54(Probe)	257492.04	223999	root		time:36.7s, loops:222, partial_worker:{wall_time:36.626160037s, concurrency:5, task_num:289, tot_wait:3m2.764912376s, tot_exec:324.760838ms, tot_time:3m3.12583859s, max:36.626120837s, p95:36.626120837s}, final_worker:{wall_time:36.702531448s, concurrency:5, task_num:25, tot_wait:3m3.120163153s, tot_exec:371.712328ms, tot_time:3m3.491885665s, max:36.702501622s, p95:36.702501622s}	group by:tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_suppkey)->tpch50.partsupp.ps_suppkey	56.0 MB	N/A
20:40:53 [2021-06-07T20:40:53.837Z]     └─Selection_55	257492.04	295898	root		time:36.6s, loops:290	gt(cast(tpch50.partsupp.ps_availqty, decimal(20,0) BINARY), mul(0.5, Column#44))	59.2 KB	N/A
20:40:53 [2021-06-07T20:40:53.837Z]       └─HashAgg_56	321865.05	435528	root		time:36.5s, loops:430, partial_worker:{wall_time:36.255945681s, concurrency:5, task_num:624, tot_wait:3m0.096832425s, tot_exec:951.39467ms, tot_time:3m1.195092346s, max:36.255917916s, p95:36.255917916s}, final_worker:{wall_time:36.617523688s, concurrency:5, task_num:25, tot_wait:3m1.158721902s, tot_exec:1.854722434s, tot_time:3m3.013459802s, max:36.617491058s, p95:36.617491058s}	group by:tpch50.partsupp.ps_partkey, tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_suppkey)->tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_availqty)->tpch50.partsupp.ps_availqty, funcs:sum(tpch50.lineitem.l_quantity)->Column#44	194.5 MB	N/A
20:40:53 [2021-06-07T20:40:53.838Z]         └─HashJoin_59	9711455.06	634004	root		time:36.2s, loops:625, build_hash_table:{total:2.39s, fetch:2.2s, build:189.7ms}, probe:{concurrency:5, total:3m0.8s, max:36.2s, probe:13.7s, fetch:2m47.1s}	left outer join, equal:[eq(tpch50.partsupp.ps_partkey, tpch50.lineitem.l_partkey) eq(tpch50.partsupp.ps_suppkey, tpch50.lineitem.l_suppkey)]	10.4 MB	0 Bytes
20:40:53 [2021-06-07T20:40:53.838Z]           ├─IndexHashJoin_67(Build)	321865.05	435528	root		time:2.37s, loops:430, inner:{total:2.46s, concurrency:5, task:12, construct:124.9ms, fetch:2.02s, build:28.5ms, join:320ms}	inner join, inner:IndexLookUp_64, outer key:tpch50.part.p_partkey, inner key:tpch50.partsupp.ps_partkey, equal cond:eq(tpch50.part.p_partkey, tpch50.partsupp.ps_partkey)	19.9 MB	N/A
20:40:53 [2021-06-07T20:40:53.838Z]           │ ├─TableReader_96(Build)	80007.93	108882	root		time:1.98s, loops:112, cop_task: {num: 20, max: 1.43s, min: 749.6ms, avg: 1.05s, p95: 1.43s, max_proc_keys: 686055, p95_proc_keys: 686055, tot_proc: 21s, tot_wait: 2ms, rpc_num: 20, rpc_time: 21.1s, copr_cache: disabled}	data:Selection_95	725.8 KB	N/A
20:40:53 [2021-06-07T20:40:53.838Z]           │ │ └─Selection_95	80007.93	108882	cop[tikv]		tikv_task:{proc max:1.42s, min:746ms, p80:1.22s, p95:1.42s, iters:9859, tasks:20}, scan_detail: {total_process_keys: 10000000, total_keys: 10000020, rocksdb: {delete_skipped_count: 0, key_skipped_count: 19999980, block: {cache_hit_count: 31499, read_count: 0, read_byte: 0 Bytes}}}	like(tpch50.part.p_name, "green%", 92)	N/A	N/A
20:40:53 [2021-06-07T20:40:53.838Z]           │ │   └─TableFullScan_94	10000000.00	10000000	cop[tikv]	table:part	tikv_task:{proc max:1.3s, min:691ms, p80:1.14s, p95:1.3s, iters:9859, tasks:20}	keep order:false	N/A	N/A
20:40:53 [2021-06-07T20:40:53.838Z]           │ └─IndexLookUp_64(Probe)	4.02	435528	root		time:1.92s, loops:447, index_task: {total_time: 1.11s, fetch_handle: 1.11s, build: 80.9µs, wait: 307µs}, table_task: {total_time: 7.46s, num: 56, concurrency: 60}		20.5 KB	N/A
20:40:53 [2021-06-07T20:40:53.838Z]           │   ├─IndexRangeScan_62(Build)	4.02	435528	cop[tikv]	table:partsupp, index:PRIMARY(PS_PARTKEY, PS_SUPPKEY)	time:1.07s, loops:484, cop_task: {num: 60, max: 189ms, min: 4.05ms, avg: 85.9ms, p95: 174.5ms, max_proc_keys: 15288, p95_proc_keys: 14948, tot_proc: 4.77s, tot_wait: 50ms, rpc_num: 60, rpc_time: 5.15s, copr_cache: disabled}, tikv_task:{proc max:167ms, min:4ms, p80:136ms, p95:158ms, iters:699, tasks:60}, scan_detail: {total_process_keys: 435528, total_keys: 544410, rocksdb: {delete_skipped_count: 0, key_skipped_count: 435528, block: {cache_hit_count: 980292, read_count: 0, read_byte: 0 Bytes}}}	range: decided by [eq(tpch50.partsupp.ps_partkey, tpch50.part.p_partkey)], keep order:false	N/A	N/A
20:40:53 [2021-06-07T20:40:53.838Z]           │   └─TableRowIDScan_63(Probe)	4.02	435528	cop[tikv]	table:partsupp	time:2.39s, loops:507, cop_task: {num: 1444, max: 81.7ms, min: 441.9µs, avg: 16.7ms, p95: 33.1ms, max_proc_keys: 992, p95_proc_keys: 580, tot_proc: 18.5s, tot_wait: 3.85s, rpc_num: 1444, rpc_time: 24.1s, copr_cache: disabled}, tikv_task:{proc max:47ms, min:0s, p80:16ms, p95:23ms, iters:5343, tasks:1444}, scan_detail: {total_process_keys: 435528, total_keys: 473507, rocksdb: {delete_skipped_count: 0, key_skipped_count: 194089, block: {cache_hit_count: 3644212, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:40:53 [2021-06-07T20:40:53.838Z]           └─TableReader_101(Probe)	46310896.67	45504356	root		time:31.9s, loops:44289, cop_task: {num: 761, max: 1.15s, min: 342.1ms, avg: 674.8ms, p95: 812.3ms, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 8m30.5s, tot_wait: 116ms, rpc_num: 761, rpc_time: 8m33.5s, copr_cache: disabled}	data:Selection_100	52.6 MB	N/A
20:40:53 [2021-06-07T20:40:53.838Z]             └─Selection_100	46310896.67	45504356	cop[tikv]		tikv_task:{proc max:1.1s, min:332ms, p80:718ms, p95:795ms, iters:296606, tasks:761}, scan_detail: {total_process_keys: 300005811, total_keys: 300006572, rocksdb: {delete_skipped_count: 0, key_skipped_count: 600010861, block: {cache_hit_count: 1124648, read_count: 0, read_byte: 0 Bytes}}}	ge(tpch50.lineitem.l_shipdate, 1993-01-01 00:00:00.000000), lt(tpch50.lineitem.l_shipdate, 1994-01-01)	N/A	N/A
20:40:53 [2021-06-07T20:40:53.838Z]               └─TableFullScan_99	300005811.00	300005811	cop[tikv]	table:lineitem	tikv_task:{proc max:1.05s, min:318ms, p80:687ms, p95:763ms, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:40:53 [2021-06-07T20:40:53.838Z] + sync
20:40:53 [2021-06-07T20:40:53.838Z] + /usr/bin/echo 3
20:41:40 [2021-06-07T20:41:40.441Z] + tiup cluster stop benchbot -y
20:41:40 [2021-06-07T20:41:40.441Z] Starting component `cluster`: /home/tidb/.tiup/components/cluster/v1.4.4/tiup-cluster stop benchbot -y
20:41:48 [2021-06-07T20:41:48.513Z] + rm -rf '/data1/tidb-deploy/*/log/*'
20:41:48 [2021-06-07T20:41:48.513Z] + rm -rf /data1/jenkins/deploy/data/tikv-20160
20:41:51 [2021-06-07T20:41:51.022Z] + rm -rf /data1/jenkins/deploy/data/pd-2379
20:41:51 [2021-06-07T20:41:51.022Z] + rm -rf /data1/jenkins/restore_data/tpch50/data/last_tikv.toml
20:41:51 [2021-06-07T20:41:51.022Z] + cp -R /data1/jenkins/restore_data/tpch50/data /data1/jenkins/deploy/data/tikv-20160
20:43:27 [2021-06-07T20:43:27.375Z] + cp -R /data1/jenkins/restore_data/tpch50/data.pd /data1/jenkins/deploy/data/pd-2379
20:43:27 [2021-06-07T20:43:27.375Z] + '[' -n '' ']'
20:43:27 [2021-06-07T20:43:27.375Z] + tiup cluster start benchbot --wait-timeout=300
20:43:27 [2021-06-07T20:43:27.630Z] Starting component `cluster`: /home/tidb/.tiup/components/cluster/v1.4.4/tiup-cluster start benchbot --wait-timeout=300
20:43:59 [2021-06-07T20:43:59.637Z] + sync
20:43:59 [2021-06-07T20:43:59.637Z] + /usr/bin/echo 3
20:45:35 [2021-06-07T20:45:35.996Z] 
20:45:35 [2021-06-07T20:45:35.996Z] queries/20.sql
20:45:35 [2021-06-07T20:45:35.996Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:45:35 [2021-06-07T20:45:35.996Z] Sort_30	20000.00	8982	root		time:38.2s, loops:10	tpch50.supplier.s_name	620.9 KB	0 Bytes
20:45:35 [2021-06-07T20:45:35.996Z] └─HashJoin_35	20000.00	8982	root		time:38.2s, loops:11, build_hash_table:{total:1.19s, fetch:1.18s, build:10.2ms}, probe:{concurrency:5, total:3m11.1s, max:38.2s, probe:47.8ms, fetch:3m11s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.partsupp.ps_suppkey)]	1.56 MB	0 Bytes
20:45:35 [2021-06-07T20:45:35.996Z]   ├─HashJoin_48(Build)	20000.00	19972	root		time:1.18s, loops:24, build_hash_table:{total:184.1µs, fetch:178.3µs, build:5.74µs}, probe:{concurrency:5, total:5.92s, max:1.18s, probe:95.4ms, fetch:5.82s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:45:35 [2021-06-07T20:45:35.996Z]   │ ├─TableReader_53(Build)	1.00	1	root		time:44.5µs, loops:2, cop_task: {num: 1, max: 950.3µs, proc_keys: 25, rpc_num: 1, rpc_time: 916.5µs, copr_cache: disabled}	data:Selection_52	236 Bytes	N/A
20:45:35 [2021-06-07T20:45:35.996Z]   │ │ └─Selection_52	1.00	1	cop[tikv]		tikv_task:{time:0s, loops:1}, scan_detail: {total_process_keys: 25, total_keys: 26, rocksdb: {delete_skipped_count: 0, key_skipped_count: 46, block: {cache_hit_count: 18, read_count: 0, read_byte: 0 Bytes}}}	eq(tpch50.nation.n_name, "ALGERIA")	N/A	N/A
20:45:35 [2021-06-07T20:45:35.996Z]   │ │   └─TableFullScan_51	25.00	25	cop[tikv]	table:nation	tikv_task:{time:0s, loops:1}	keep order:false	N/A	N/A
20:45:35 [2021-06-07T20:45:35.996Z]   │ └─TableReader_50(Probe)	500000.00	500000	root		time:1.16s, loops:490, cop_task: {num: 1, max: 1.17s, proc_keys: 500000, tot_proc: 1.09s, rpc_num: 1, rpc_time: 1.17s, copr_cache: disabled}	data:TableFullScan_49	35.8 MB	N/A
20:45:35 [2021-06-07T20:45:35.996Z]   │   └─TableFullScan_49	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:960ms, loops:493}, scan_detail: {total_process_keys: 500000, total_keys: 500001, rocksdb: {delete_skipped_count: 0, key_skipped_count: 999999, block: {cache_hit_count: 1692, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:45:35 [2021-06-07T20:45:35.996Z]   └─HashAgg_54(Probe)	257492.04	223999	root		time:38.2s, loops:222, partial_worker:{wall_time:38.140583568s, concurrency:5, task_num:289, tot_wait:3m10.253114588s, tot_exec:361.872611ms, tot_time:3m10.688159535s, max:38.140485519s, p95:38.140485519s}, final_worker:{wall_time:38.214357625s, concurrency:5, task_num:25, tot_wait:3m10.68101874s, tot_exec:344.839023ms, tot_time:3m11.025870246s, max:38.214223513s, p95:38.214223513s}	group by:tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_suppkey)->tpch50.partsupp.ps_suppkey	61.4 MB	N/A
20:45:35 [2021-06-07T20:45:35.996Z]     └─Selection_55	257492.04	295898	root		time:38.1s, loops:290	gt(cast(tpch50.partsupp.ps_availqty, decimal(20,0) BINARY), mul(0.5, Column#44))	59.2 KB	N/A
20:45:35 [2021-06-07T20:45:35.996Z]       └─HashAgg_56	321865.05	435528	root		time:38s, loops:430, partial_worker:{wall_time:37.756325459s, concurrency:5, task_num:624, tot_wait:3m7.655235411s, tot_exec:966.005385ms, tot_time:3m8.740394641s, max:37.756121674s, p95:37.756121674s}, final_worker:{wall_time:38.1153188s, concurrency:5, task_num:25, tot_wait:3m8.700478067s, tot_exec:1.764891007s, tot_time:3m10.465384955s, max:38.115104153s, p95:38.115104153s}	group by:tpch50.partsupp.ps_partkey, tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_suppkey)->tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_availqty)->tpch50.partsupp.ps_availqty, funcs:sum(tpch50.lineitem.l_quantity)->Column#44	194.5 MB	N/A
20:45:35 [2021-06-07T20:45:35.996Z]         └─HashJoin_59	9711455.06	634004	root		time:37.7s, loops:625, build_hash_table:{total:2.52s, fetch:2.31s, build:215.6ms}, probe:{concurrency:5, total:3m8.3s, max:37.7s, probe:13.7s, fetch:2m54.7s}	left outer join, equal:[eq(tpch50.partsupp.ps_partkey, tpch50.lineitem.l_partkey) eq(tpch50.partsupp.ps_suppkey, tpch50.lineitem.l_suppkey)]	10.4 MB	0 Bytes
20:45:35 [2021-06-07T20:45:35.996Z]           ├─IndexHashJoin_67(Build)	321865.05	435528	root		time:2.47s, loops:430, inner:{total:2.78s, concurrency:5, task:12, construct:135.3ms, fetch:2.29s, build:23.4ms, join:347.8ms}	inner join, inner:IndexLookUp_64, outer key:tpch50.part.p_partkey, inner key:tpch50.partsupp.ps_partkey, equal cond:eq(tpch50.part.p_partkey, tpch50.partsupp.ps_partkey)	19.9 MB	N/A
20:45:35 [2021-06-07T20:45:35.996Z]           │ ├─TableReader_96(Build)	80007.93	108882	root		time:2.11s, loops:112, cop_task: {num: 20, max: 1.48s, min: 648.3ms, avg: 1.09s, p95: 1.48s, max_proc_keys: 686055, p95_proc_keys: 686055, tot_proc: 21.7s, tot_wait: 27ms, rpc_num: 20, rpc_time: 21.8s, copr_cache: disabled}	data:Selection_95	680.6 KB	N/A
20:45:35 [2021-06-07T20:45:35.996Z]           │ │ └─Selection_95	80007.93	108882	cop[tikv]		tikv_task:{proc max:1.44s, min:646ms, p80:1.26s, p95:1.44s, iters:9859, tasks:20}, scan_detail: {total_process_keys: 10000000, total_keys: 10000020, rocksdb: {delete_skipped_count: 0, key_skipped_count: 19999980, block: {cache_hit_count: 31499, read_count: 0, read_byte: 0 Bytes}}}	like(tpch50.part.p_name, "green%", 92)	N/A	N/A
20:45:35 [2021-06-07T20:45:35.996Z]           │ │   └─TableFullScan_94	10000000.00	10000000	cop[tikv]	table:part	tikv_task:{proc max:1.33s, min:594ms, p80:1.17s, p95:1.33s, iters:9859, tasks:20}	keep order:false	N/A	N/A
20:45:35 [2021-06-07T20:45:35.996Z]           │ └─IndexLookUp_64(Probe)	4.02	435528	root		time:2.18s, loops:447, index_task: {total_time: 1.26s, fetch_handle: 1.26s, build: 90.7µs, wait: 276.1µs}, table_task: {total_time: 8.48s, num: 56, concurrency: 60}		20.6 KB	N/A
20:45:35 [2021-06-07T20:45:35.996Z]           │   ├─IndexRangeScan_62(Build)	4.02	435528	cop[tikv]	table:partsupp, index:PRIMARY(PS_PARTKEY, PS_SUPPKEY)	time:1.22s, loops:481, cop_task: {num: 59, max: 222.3ms, min: 6.58ms, avg: 93.2ms, p95: 211.8ms, max_proc_keys: 15288, p95_proc_keys: 14960, tot_proc: 4.95s, tot_wait: 83ms, rpc_num: 59, rpc_time: 5.5s, copr_cache: disabled}, tikv_task:{proc max:213ms, min:5ms, p80:141ms, p95:198ms, iters:692, tasks:59}, scan_detail: {total_process_keys: 435528, total_keys: 544410, rocksdb: {delete_skipped_count: 0, key_skipped_count: 435528, block: {cache_hit_count: 980292, read_count: 0, read_byte: 0 Bytes}}}	range: decided by [eq(tpch50.partsupp.ps_partkey, tpch50.part.p_partkey)], keep order:false	N/A	N/A
20:45:35 [2021-06-07T20:45:35.996Z]           │   └─TableRowIDScan_63(Probe)	4.02	435528	cop[tikv]	table:partsupp	time:2.82s, loops:504, cop_task: {num: 1465, max: 64.7ms, min: 373.1µs, avg: 19.2ms, p95: 38.5ms, max_proc_keys: 1028, p95_proc_keys: 540, tot_proc: 19.7s, tot_wait: 6.64s, rpc_num: 1465, rpc_time: 28.1s, copr_cache: disabled}, tikv_task:{proc max:42ms, min:0s, p80:16ms, p95:22ms, iters:5404, tasks:1465}, scan_detail: {total_process_keys: 435528, total_keys: 473505, rocksdb: {delete_skipped_count: 0, key_skipped_count: 194073, block: {cache_hit_count: 3644325, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:45:35 [2021-06-07T20:45:35.996Z]           └─TableReader_101(Probe)	46310896.67	45504356	root		time:33.3s, loops:44289, cop_task: {num: 761, max: 1.19s, min: 379.2ms, avg: 700.6ms, p95: 837.7ms, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 8m50.1s, tot_wait: 138ms, rpc_num: 761, rpc_time: 8m53.1s, copr_cache: disabled}	data:Selection_100	52.6 MB	N/A
20:45:35 [2021-06-07T20:45:35.996Z]             └─Selection_100	46310896.67	45504356	cop[tikv]		tikv_task:{proc max:1.15s, min:368ms, p80:744ms, p95:817ms, iters:296606, tasks:761}, scan_detail: {total_process_keys: 300005811, total_keys: 300006572, rocksdb: {delete_skipped_count: 0, key_skipped_count: 600010861, block: {cache_hit_count: 1124648, read_count: 0, read_byte: 0 Bytes}}}	ge(tpch50.lineitem.l_shipdate, 1993-01-01 00:00:00.000000), lt(tpch50.lineitem.l_shipdate, 1994-01-01)	N/A	N/A
20:45:35 [2021-06-07T20:45:35.996Z]               └─TableFullScan_99	300005811.00	300005811	cop[tikv]	table:lineitem	tikv_task:{proc max:1.1s, min:354ms, p80:711ms, p95:789ms, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:45:35 [2021-06-07T20:45:35.996Z] 
20:45:35 [2021-06-07T20:45:35.996Z] queries/21.sql
20:45:35 [2021-06-07T20:45:35.996Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:45:35 [2021-06-07T20:45:35.996Z] Projection_26	100.00	100	root		time:1m20.2s, loops:2, Concurrency:OFF	tpch50.supplier.s_name, Column#72	4.62 KB	N/A
20:45:35 [2021-06-07T20:45:35.996Z] └─TopN_29	100.00	100	root		time:1m20.2s, loops:2	Column#72:desc, tpch50.supplier.s_name, offset:0, count:100	58.4 KB	N/A
20:45:35 [2021-06-07T20:45:35.996Z]   └─HashAgg_34	12800.00	20057	root		time:1m20.2s, loops:21, partial_worker:{wall_time:1m20.208309258s, concurrency:5, task_num:198, tot_wait:6m40.74607387s, tot_exec:256.470358ms, tot_time:6m41.027898955s, max:1m20.208280239s, p95:1m20.208280239s}, final_worker:{wall_time:1m20.229328227s, concurrency:5, task_num:25, tot_wait:6m41.027320781s, tot_exec:104.419212ms, tot_time:6m41.131752699s, max:1m20.22931037s, p95:1m20.22931037s}	group by:tpch50.supplier.s_name, funcs:count(1)->Column#72, funcs:firstrow(tpch50.supplier.s_name)->tpch50.supplier.s_name	17.2 MB	N/A
20:45:35 [2021-06-07T20:45:35.996Z]     └─IndexHashJoin_42	7828961.66	198698	root		time:1m20.2s, loops:199, inner:{total:2m19.5s, concurrency:5, task:146, construct:6.45s, fetch:1m56.5s, build:1.18s, join:16.5s}	anti semi join, inner:IndexLookUp_39, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey)	641.0 MB	N/A
20:45:35 [2021-06-07T20:45:35.996Z]       ├─IndexHashJoin_83(Build)	9786202.08	3542799	root		time:1m19.7s, loops:3463, inner:{total:2m28.2s, concurrency:5, task:152, construct:7.79s, fetch:2m2.8s, build:1.15s, join:17.5s}	semi join, inner:IndexLookUp_80, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey), ne(tpch50.lineitem.l_suppkey, tpch50.supplier.s_suppkey)	555.9 MB	N/A
20:45:35 [2021-06-07T20:45:35.996Z]       │ ├─IndexJoin_99(Build)	12232752.60	3675878	root		time:1m19.1s, loops:3595, inner:{total:2m11.2s, concurrency:5, task:305, construct:16.3s, fetch:1m53.1s, build:1.79s}, probe:5.19s	inner join, inner:TableReader_95, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.orders.o_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.orders.o_orderkey)	575.4 MB	N/A
20:45:35 [2021-06-07T20:45:35.996Z]       │ │ ├─HashJoin_107(Build)	12232752.60	7609895	root		time:1m18.5s, loops:7435, build_hash_table:{total:837.2ms, fetch:830.4ms, build:6.8ms}, probe:{concurrency:5, total:6m35s, max:1m19s, probe:1m0s, fetch:5m35s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.lineitem.l_suppkey)]	732.8 KB	0 Bytes
20:45:35 [2021-06-07T20:45:35.996Z]       │ │ │ ├─HashJoin_120(Build)	20000.00	20058	root		time:835.2ms, loops:22, build_hash_table:{total:672.8µs, fetch:128.2µs, build:544.6µs}, probe:{concurrency:5, total:4.18s, max:835.4ms, probe:74.9ms, fetch:4.1s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:45:35 [2021-06-07T20:45:35.996Z]       │ │ │ │ ├─TableReader_125(Build)	1.00	1	root		time:52.2µs, loops:2, cop_task: {num: 1, max: 817.6µs, proc_keys: 25, rpc_num: 1, rpc_time: 806.8µs, copr_cache: disabled}	data:Selection_124	234 Bytes	N/A
20:45:35 [2021-06-07T20:45:35.996Z]       │ │ │ │ │ └─Selection_124	1.00	1	cop[tikv]		tikv_task:{time:0s, loops:1}, scan_detail: {total_process_keys: 25, total_keys: 26, rocksdb: {delete_skipped_count: 0, key_skipped_count: 46, block: {cache_hit_count: 18, read_count: 0, read_byte: 0 Bytes}}}	eq(tpch50.nation.n_name, "EGYPT")	N/A	N/A
20:45:35 [2021-06-07T20:45:35.996Z]       │ │ │ │ │   └─TableFullScan_123	25.00	25	cop[tikv]	table:nation	tikv_task:{time:0s, loops:1}	keep order:false	N/A	N/A
20:45:35 [2021-06-07T20:45:35.996Z]       │ │ │ │ └─TableReader_122(Probe)	500000.00	500000	root		time:820.1ms, loops:490, cop_task: {num: 1, max: 931.5ms, proc_keys: 500000, tot_proc: 904ms, rpc_num: 1, rpc_time: 931.5ms, copr_cache: disabled}	data:TableFullScan_121	20.0 MB	N/A
20:45:35 [2021-06-07T20:45:35.996Z]       │ │ │ │   └─TableFullScan_121	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:854ms, loops:493}, scan_detail: {total_process_keys: 500000, total_keys: 500001, rocksdb: {delete_skipped_count: 0, key_skipped_count: 999999, block: {cache_hit_count: 15, read_count: 1689, read_byte: 108.5 MB}}}	keep order:false	N/A	N/A
20:45:35 [2021-06-07T20:45:35.996Z]       │ │ │ └─TableReader_128(Probe)	240004648.80	189670348	root		time:1m6.8s, loops:184596, cop_task: {num: 761, max: 2.55s, min: 258.1ms, avg: 1.52s, p95: 1.99s, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 18m0.4s, tot_wait: 59.9s, rpc_num: 761, rpc_time: 19m13.9s, copr_cache: disabled}	data:Selection_127	99.2 MB	N/A
20:45:35 [2021-06-07T20:45:35.996Z]       │ │ │   └─Selection_127	240004648.80	189670348	cop[tikv]		tikv_task:{proc max:1.31s, min:242ms, p80:1.17s, p95:1.23s, iters:296606, tasks:761}, scan_detail: {total_process_keys: 300005811, total_keys: 300006572, rocksdb: {delete_skipped_count: 0, key_skipped_count: 600010861, block: {cache_hit_count: 18670, read_count: 1131774, read_byte: 23.9 GB}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:45:35 [2021-06-07T20:45:35.997Z]       │ │ │     └─TableFullScan_126	300005811.00	300005811	cop[tikv]	table:l1	tikv_task:{proc max:1.22s, min:231ms, p80:1.09s, p95:1.15s, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:45:35 [2021-06-07T20:45:35.997Z]       │ │ └─TableReader_95(Probe)	0.49	3496188	root		time:1m44s, loops:3875, cop_task: {num: 5278, max: 665.8ms, min: 3.99ms, avg: 183ms, p95: 351.2ms, max_proc_keys: 3866, p95_proc_keys: 1969, tot_proc: 11m34.6s, tot_wait: 3m51.9s, rpc_num: 5278, rpc_time: 16m5.9s, copr_cache: disabled}	data:Selection_94	N/A	N/A
20:45:35 [2021-06-07T20:45:35.997Z]       │ │   └─Selection_94	0.49	3496188	cop[tikv]		tikv_task:{proc max:154ms, min:0s, p80:70ms, p95:83ms, iters:30267, tasks:5278}, scan_detail: {total_process_keys: 7236304, total_keys: 7795497, rocksdb: {delete_skipped_count: 0, key_skipped_count: 1778255, block: {cache_hit_count: 54007439, read_count: 220290, read_byte: 4.93 GB}}}	eq(tpch50.orders.o_orderstatus, "F")	N/A	N/A
20:45:35 [2021-06-07T20:45:35.997Z]       │ │     └─TableRangeScan_93	1.00	7236304	cop[tikv]	table:orders	tikv_task:{proc max:153ms, min:0s, p80:70ms, p95:83ms, iters:30267, tasks:5278}	range: decided by [tpch50.lineitem.l_orderkey], keep order:false	N/A	N/A
20:45:35 [2021-06-07T20:45:35.997Z]       │ └─IndexLookUp_80(Probe)	4.05	17316562	root		time:1m57.4s, loops:17130, index_task: {total_time: 1m4.3s, fetch_handle: 56.4s, build: 4.01ms, wait: 7.87s}, table_task: {total_time: 8m27.5s, num: 1458, concurrency: 760}		19.0 KB	N/A
20:45:35 [2021-06-07T20:45:35.997Z]       │   ├─IndexRangeScan_78(Build)	4.05	17316562	cop[tikv]	table:l2, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:54.1s, loops:18624, cop_task: {num: 3011, max: 656.7ms, min: 832.1µs, avg: 184.4ms, p95: 374.5ms, max_proc_keys: 12790, p95_proc_keys: 8775, tot_proc: 6m52.9s, tot_wait: 2m1.7s, rpc_num: 3011, rpc_time: 9m15.1s, copr_cache: disabled}, tikv_task:{proc max:164ms, min:0s, p80:95ms, p95:112ms, iters:30157, tasks:3011}, scan_detail: {total_process_keys: 17316562, total_keys: 20812681, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17316562, block: {cache_hit_count: 24260297, read_count: 226871, read_byte: 2.40 GB}}}	range: decided by [eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey)], keep order:false	N/A	N/A
20:45:35 [2021-06-07T20:45:35.997Z]       │   └─TableRowIDScan_79(Probe)	4.05	17316562	cop[tikv]	table:l2	time:6m17.9s, loops:21022, cop_task: {num: 7821, max: 895.7ms, min: 551.5µs, avg: 179ms, p95: 362.6ms, max_proc_keys: 12685, p95_proc_keys: 4838, tot_proc: 16m40s, tot_wait: 5m49s, rpc_num: 7821, rpc_time: 23m20s, copr_cache: disabled}, tikv_task:{proc max:265ms, min:0s, p80:103ms, p95:138ms, iters:49934, tasks:7821}, scan_detail: {total_process_keys: 17316562, total_keys: 18288559, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5626755, block: {cache_hit_count: 99015221, read_count: 5, read_byte: 36.7 KB}}}	keep order:false	N/A	N/A
20:45:35 [2021-06-07T20:45:35.997Z]       └─IndexLookUp_39(Probe)	4.05	12022848	root		time:1m51.8s, loops:11953, index_task: {total_time: 59.8s, fetch_handle: 49.5s, build: 3.86ms, wait: 10.3s}, table_task: {total_time: 8m3s, num: 1408, concurrency: 730}		213.1 KB	N/A
20:45:35 [2021-06-07T20:45:35.997Z]         ├─IndexRangeScan_36(Build)	5.06	17183457	cop[tikv]	table:l3, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:47.2s, loops:18342, cop_task: {num: 2764, max: 772.2ms, min: 383.9µs, avg: 162.6ms, p95: 351.9ms, max_proc_keys: 18186, p95_proc_keys: 13728, tot_proc: 5m33.2s, tot_wait: 1m36.2s, rpc_num: 2764, rpc_time: 7m29.4s, copr_cache: disabled}, tikv_task:{proc max:170ms, min:0s, p80:76ms, p95:114ms, iters:29023, tasks:2764}, scan_detail: {total_process_keys: 17183457, total_keys: 20546495, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17183457, block: {cache_hit_count: 23554072, read_count: 0, read_byte: 0 Bytes}}}	range: decided by [eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey)], keep order:false	N/A	N/A
20:45:35 [2021-06-07T20:45:35.997Z]         └─Selection_38(Probe)	4.05	12022848	cop[tikv]		time:6m14.1s, loops:13767, cop_task: {num: 10273, max: 818.6ms, min: 607.5µs, avg: 174.5ms, p95: 357.4ms, max_proc_keys: 6471, p95_proc_keys: 3943, tot_proc: 20m57.8s, tot_wait: 7m50.7s, rpc_num: 10273, rpc_time: 29m52.5s, copr_cache: disabled}, tikv_task:{proc max:360ms, min:0s, p80:75ms, p95:114ms, iters:60736, tasks:10273}, scan_detail: {total_process_keys: 17183457, total_keys: 18129029, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5525256, block: {cache_hit_count: 98293055, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:45:35 [2021-06-07T20:45:35.997Z]           └─TableRowIDScan_37	5.06	17183457	cop[tikv]	table:l3	tikv_task:{proc max:359ms, min:0s, p80:75ms, p95:113ms, iters:60736, tasks:10273}	keep order:false	N/A	N/A
20:45:35 [2021-06-07T20:45:35.997Z] + sync
20:45:35 [2021-06-07T20:45:35.997Z] + /usr/bin/echo 3
20:46:54 [2021-06-07T20:46:54.049Z] 
20:46:54 [2021-06-07T20:46:54.049Z] queries/21.sql
20:46:54 [2021-06-07T20:46:54.049Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:46:54 [2021-06-07T20:46:54.049Z] Projection_26	100.00	100	root		time:1m18.6s, loops:2, Concurrency:OFF	tpch50.supplier.s_name, Column#72	4.62 KB	N/A
20:46:54 [2021-06-07T20:46:54.049Z] └─TopN_29	100.00	100	root		time:1m18.6s, loops:2	Column#72:desc, tpch50.supplier.s_name, offset:0, count:100	58.4 KB	N/A
20:46:54 [2021-06-07T20:46:54.049Z]   └─HashAgg_34	12800.00	20057	root		time:1m18.6s, loops:21, partial_worker:{wall_time:1m18.592842767s, concurrency:5, task_num:196, tot_wait:6m32.69907017s, tot_exec:251.200729ms, tot_time:6m32.962190548s, max:1m18.592818767s, p95:1m18.592818767s}, final_worker:{wall_time:1m18.60476573s, concurrency:5, task_num:25, tot_wait:6m32.960852845s, tot_exec:62.225439ms, tot_time:6m33.023088844s, max:1m18.604738397s, p95:1m18.604738397s}	group by:tpch50.supplier.s_name, funcs:count(1)->Column#72, funcs:firstrow(tpch50.supplier.s_name)->tpch50.supplier.s_name	17.2 MB	N/A
20:46:54 [2021-06-07T20:46:54.049Z]     └─IndexHashJoin_42	7828961.66	198698	root		time:1m18.6s, loops:197, inner:{total:2m17.5s, concurrency:5, task:147, construct:6.3s, fetch:1m54.8s, build:1.19s, join:16.3s}	anti semi join, inner:IndexLookUp_39, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey)	641.1 MB	N/A
20:46:54 [2021-06-07T20:46:54.049Z]       ├─IndexHashJoin_83(Build)	9786202.08	3542799	root		time:1m18.1s, loops:3464, inner:{total:2m27.5s, concurrency:5, task:152, construct:7.83s, fetch:2m2s, build:1.23s, join:17.7s}	semi join, inner:IndexLookUp_80, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey), ne(tpch50.lineitem.l_suppkey, tpch50.supplier.s_suppkey)	555.9 MB	N/A
20:46:54 [2021-06-07T20:46:54.050Z]       │ ├─IndexJoin_99(Build)	12232752.60	3675878	root		time:1m17.5s, loops:3595, inner:{total:2m6.6s, concurrency:5, task:305, construct:16.7s, fetch:1m48.1s, build:1.85s}, probe:5.15s	inner join, inner:TableReader_95, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.orders.o_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.orders.o_orderkey)	575.3 MB	N/A
20:46:54 [2021-06-07T20:46:54.050Z]       │ │ ├─HashJoin_107(Build)	12232752.60	7609895	root		time:1m17s, loops:7436, build_hash_table:{total:961.8ms, fetch:956ms, build:5.76ms}, probe:{concurrency:5, total:6m27s, max:1m17.4s, probe:1m1.5s, fetch:5m25.5s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.lineitem.l_suppkey)]	757.3 KB	0 Bytes
20:46:54 [2021-06-07T20:46:54.050Z]       │ │ │ ├─HashJoin_120(Build)	20000.00	20058	root		time:958.1ms, loops:23, build_hash_table:{total:167.9µs, fetch:162.6µs, build:5.3µs}, probe:{concurrency:5, total:4.8s, max:960.9ms, probe:60.9ms, fetch:4.74s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:46:54 [2021-06-07T20:46:54.050Z]       │ │ │ │ ├─TableReader_125(Build)	1.00	1	root		time:47.6µs, loops:2, cop_task: {num: 1, max: 1.27ms, proc_keys: 25, tot_proc: 1ms, rpc_num: 1, rpc_time: 1.21ms, copr_cache: disabled}	data:Selection_124	246 Bytes	N/A
20:46:54 [2021-06-07T20:46:54.050Z]       │ │ │ │ │ └─Selection_124	1.00	1	cop[tikv]		tikv_task:{time:1ms, loops:1}, scan_detail: {total_process_keys: 25, total_keys: 26, rocksdb: {delete_skipped_count: 0, key_skipped_count: 46, block: {cache_hit_count: 17, read_count: 1, read_byte: 23.8 KB}}}	eq(tpch50.nation.n_name, "EGYPT")	N/A	N/A
20:46:54 [2021-06-07T20:46:54.050Z]       │ │ │ │ │   └─TableFullScan_123	25.00	25	cop[tikv]	table:nation	tikv_task:{time:0s, loops:1}	keep order:false	N/A	N/A
20:46:54 [2021-06-07T20:46:54.050Z]       │ │ │ │ └─TableReader_122(Probe)	500000.00	500000	root		time:947.9ms, loops:490, cop_task: {num: 1, max: 948.8ms, proc_keys: 500000, tot_proc: 906ms, rpc_num: 1, rpc_time: 948.8ms, copr_cache: disabled}	data:TableFullScan_121	20.0 MB	N/A
20:46:54 [2021-06-07T20:46:54.050Z]       │ │ │ │   └─TableFullScan_121	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:842ms, loops:493}, scan_detail: {total_process_keys: 500000, total_keys: 500001, rocksdb: {delete_skipped_count: 0, key_skipped_count: 999999, block: {cache_hit_count: 13, read_count: 1679, read_byte: 104.5 MB}}}	keep order:false	N/A	N/A
20:46:54 [2021-06-07T20:46:54.050Z]       │ │ │ └─TableReader_128(Probe)	240004648.80	189670348	root		time:1m4.5s, loops:184596, cop_task: {num: 761, max: 2.78s, min: 238.9ms, avg: 1.49s, p95: 1.96s, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 17m37.2s, tot_wait: 1m0.2s, rpc_num: 761, rpc_time: 18m50.9s, copr_cache: disabled}	data:Selection_127	109.4 MB	N/A
20:46:54 [2021-06-07T20:46:54.050Z]       │ │ │   └─Selection_127	240004648.80	189670348	cop[tikv]		tikv_task:{proc max:1.26s, min:228ms, p80:1.14s, p95:1.18s, iters:296606, tasks:761}, scan_detail: {total_process_keys: 300005811, total_keys: 300006572, rocksdb: {delete_skipped_count: 0, key_skipped_count: 600010861, block: {cache_hit_count: 10454, read_count: 1114194, read_byte: 23.6 GB}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:46:54 [2021-06-07T20:46:54.050Z]       │ │ │     └─TableFullScan_126	300005811.00	300005811	cop[tikv]	table:l1	tikv_task:{proc max:1.18s, min:219ms, p80:1.06s, p95:1.11s, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:46:54 [2021-06-07T20:46:54.050Z]       │ │ └─TableReader_95(Probe)	0.49	3496192	root		time:1m39.1s, loops:3875, cop_task: {num: 5269, max: 632.9ms, min: 2.85ms, avg: 175.5ms, p95: 338.5ms, max_proc_keys: 3781, p95_proc_keys: 1968, tot_proc: 11m5.2s, tot_wait: 3m41.6s, rpc_num: 5269, rpc_time: 15m24.7s, copr_cache: disabled}	data:Selection_94	N/A	N/A
20:46:54 [2021-06-07T20:46:54.050Z]       │ │   └─Selection_94	0.49	3496192	cop[tikv]		tikv_task:{proc max:156ms, min:0s, p80:68ms, p95:81ms, iters:30293, tasks:5269}, scan_detail: {total_process_keys: 7236293, total_keys: 7795434, rocksdb: {delete_skipped_count: 0, key_skipped_count: 1778021, block: {cache_hit_count: 54007084, read_count: 218163, read_byte: 4.21 GB}}}	eq(tpch50.orders.o_orderstatus, "F")	N/A	N/A
20:46:54 [2021-06-07T20:46:54.050Z]       │ │     └─TableRangeScan_93	1.00	7236293	cop[tikv]	table:orders	tikv_task:{proc max:155ms, min:0s, p80:68ms, p95:81ms, iters:30293, tasks:5269}	range: decided by [tpch50.lineitem.l_orderkey], keep order:false	N/A	N/A
20:46:54 [2021-06-07T20:46:54.050Z]       │ └─IndexLookUp_80(Probe)	4.05	17316403	root		time:1m56.6s, loops:17131, index_task: {total_time: 1m4.4s, fetch_handle: 55.9s, build: 3.45ms, wait: 8.5s}, table_task: {total_time: 8m22.9s, num: 1458, concurrency: 760}		19.0 KB	N/A
20:46:54 [2021-06-07T20:46:54.050Z]       │   ├─IndexRangeScan_78(Build)	4.05	17316403	cop[tikv]	table:l2, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:53.7s, loops:18631, cop_task: {num: 3019, max: 655.6ms, min: 650.8µs, avg: 184.1ms, p95: 388.3ms, max_proc_keys: 14365, p95_proc_keys: 8758, tot_proc: 6m54.7s, tot_wait: 2m0.6s, rpc_num: 3019, rpc_time: 9m15.7s, copr_cache: disabled}, tikv_task:{proc max:178ms, min:0s, p80:91ms, p95:106ms, iters:30316, tasks:3019}, scan_detail: {total_process_keys: 17316403, total_keys: 20812498, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17316403, block: {cache_hit_count: 24259908, read_count: 225684, read_byte: 2.00 GB}}}	range: decided by [eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey)], keep order:false	N/A	N/A
20:46:54 [2021-06-07T20:46:54.050Z]       │   └─TableRowIDScan_79(Probe)	4.05	17316403	cop[tikv]	table:l2	time:6m14.5s, loops:20981, cop_task: {num: 7814, max: 590.4ms, min: 520.3µs, avg: 176.2ms, p95: 360.1ms, max_proc_keys: 13350, p95_proc_keys: 4853, tot_proc: 16m24.5s, tot_wait: 5m43.4s, rpc_num: 7814, rpc_time: 22m56.9s, copr_cache: disabled}, tikv_task:{proc max:249ms, min:0s, p80:102ms, p95:136ms, iters:50010, tasks:7814}, scan_detail: {total_process_keys: 17316403, total_keys: 18287764, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5622079, block: {cache_hit_count: 99025430, read_count: 1126, read_byte: 401.2 MB}}}	keep order:false	N/A	N/A
20:46:54 [2021-06-07T20:46:54.050Z]       └─IndexLookUp_39(Probe)	4.05	12022715	root		time:1m50.3s, loops:11947, index_task: {total_time: 59.8s, fetch_handle: 50.1s, build: 3.45ms, wait: 9.68s}, table_task: {total_time: 7m55.2s, num: 1410, concurrency: 735}		225.3 KB	N/A
20:46:54 [2021-06-07T20:46:54.050Z]         ├─IndexRangeScan_36(Build)	5.06	17183282	cop[tikv]	table:l3, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:47.8s, loops:18387, cop_task: {num: 2789, max: 751.4ms, min: 655.6µs, avg: 166.4ms, p95: 365.4ms, max_proc_keys: 19141, p95_proc_keys: 13782, tot_proc: 5m44.7s, tot_wait: 1m39.2s, rpc_num: 2789, rpc_time: 7m44.1s, copr_cache: disabled}, tikv_task:{proc max:178ms, min:0s, p80:75ms, p95:116ms, iters:29143, tasks:2789}, scan_detail: {total_process_keys: 17183282, total_keys: 20546291, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17183282, block: {cache_hit_count: 23553869, read_count: 0, read_byte: 0 Bytes}}}	range: decided by [eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey)], keep order:false	N/A	N/A
20:46:54 [2021-06-07T20:46:54.050Z]         └─Selection_38(Probe)	4.05	12022715	cop[tikv]		time:6m4.3s, loops:13774, cop_task: {num: 10258, max: 545.2ms, min: 447.6µs, avg: 169.7ms, p95: 345.4ms, max_proc_keys: 7226, p95_proc_keys: 3959, tot_proc: 20m15s, tot_wait: 7m42.1s, rpc_num: 10258, rpc_time: 29m1s, copr_cache: disabled}, tikv_task:{proc max:223ms, min:0s, p80:75ms, p95:113ms, iters:60743, tasks:10258}, scan_detail: {total_process_keys: 17183282, total_keys: 18127634, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5521862, block: {cache_hit_count: 98294542, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:46:54 [2021-06-07T20:46:54.050Z]           └─TableRowIDScan_37	5.06	17183282	cop[tikv]	table:l3	tikv_task:{proc max:221ms, min:0s, p80:74ms, p95:112ms, iters:60743, tasks:10258}	keep order:false	N/A	N/A
20:46:54 [2021-06-07T20:46:54.050Z] + sync
20:46:54 [2021-06-07T20:46:54.050Z] + /usr/bin/echo 3
20:48:15 [2021-06-07T20:48:15.412Z] 
20:48:15 [2021-06-07T20:48:15.413Z] queries/21.sql
20:48:15 [2021-06-07T20:48:15.413Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:48:15 [2021-06-07T20:48:15.413Z] Projection_26	100.00	100	root		time:1m18.9s, loops:2, Concurrency:OFF	tpch50.supplier.s_name, Column#72	4.62 KB	N/A
20:48:15 [2021-06-07T20:48:15.413Z] └─TopN_29	100.00	100	root		time:1m18.9s, loops:2	Column#72:desc, tpch50.supplier.s_name, offset:0, count:100	58.4 KB	N/A
20:48:15 [2021-06-07T20:48:15.413Z]   └─HashAgg_34	12800.00	20057	root		time:1m18.9s, loops:21, partial_worker:{wall_time:1m18.881271239s, concurrency:5, task_num:197, tot_wait:6m34.147778927s, tot_exec:245.79157ms, tot_time:6m34.405321759s, max:1m18.881228312s, p95:1m18.881228312s}, final_worker:{wall_time:1m18.897222653s, concurrency:5, task_num:25, tot_wait:6m34.404699879s, tot_exec:70.939504ms, tot_time:6m34.475650767s, max:1m18.897178445s, p95:1m18.897178445s}	group by:tpch50.supplier.s_name, funcs:count(1)->Column#72, funcs:firstrow(tpch50.supplier.s_name)->tpch50.supplier.s_name	17.2 MB	N/A
20:48:15 [2021-06-07T20:48:15.413Z]     └─IndexHashJoin_42	7828961.66	198698	root		time:1m18.9s, loops:198, inner:{total:2m15.8s, concurrency:5, task:146, construct:6.29s, fetch:1m53.1s, build:1.21s, join:16.4s}	anti semi join, inner:IndexLookUp_39, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey)	641.1 MB	N/A
20:48:15 [2021-06-07T20:48:15.413Z]       ├─IndexHashJoin_83(Build)	9786202.08	3542799	root		time:1m18.4s, loops:3463, inner:{total:2m27.7s, concurrency:5, task:152, construct:7.84s, fetch:2m2.4s, build:1.22s, join:17.5s}	semi join, inner:IndexLookUp_80, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey), ne(tpch50.lineitem.l_suppkey, tpch50.supplier.s_suppkey)	555.9 MB	N/A
20:48:15 [2021-06-07T20:48:15.413Z]       │ ├─IndexJoin_99(Build)	12232752.60	3675878	root		time:1m17.9s, loops:3595, inner:{total:2m6.4s, concurrency:5, task:305, construct:16.3s, fetch:1m48.2s, build:1.86s}, probe:4.92s	inner join, inner:TableReader_95, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.orders.o_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.orders.o_orderkey)	575.4 MB	N/A
20:48:15 [2021-06-07T20:48:15.413Z]       │ │ ├─HashJoin_107(Build)	12232752.60	7609895	root		time:1m17.3s, loops:7436, build_hash_table:{total:1.06s, fetch:1.06s, build:6.67ms}, probe:{concurrency:5, total:6m28.2s, max:1m17.6s, probe:1m0.7s, fetch:5m27.4s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.lineitem.l_suppkey)]	737.6 KB	0 Bytes
20:48:15 [2021-06-07T20:48:15.413Z]       │ │ │ ├─HashJoin_120(Build)	20000.00	20058	root		time:1.06s, loops:22, build_hash_table:{total:144.3µs, fetch:139µs, build:5.27µs}, probe:{concurrency:5, total:5.31s, max:1.06s, probe:63.8ms, fetch:5.24s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:48:15 [2021-06-07T20:48:15.413Z]       │ │ │ │ ├─TableReader_125(Build)	1.00	1	root		time:39.8µs, loops:2, cop_task: {num: 1, max: 1.25ms, proc_keys: 25, rpc_num: 1, rpc_time: 1.22ms, copr_cache: disabled}	data:Selection_124	240 Bytes	N/A
20:48:15 [2021-06-07T20:48:15.413Z]       │ │ │ │ │ └─Selection_124	1.00	1	cop[tikv]		tikv_task:{time:0s, loops:1}, scan_detail: {total_process_keys: 25, total_keys: 26, rocksdb: {delete_skipped_count: 0, key_skipped_count: 46, block: {cache_hit_count: 17, read_count: 1, read_byte: 23.8 KB}}}	eq(tpch50.nation.n_name, "EGYPT")	N/A	N/A
20:48:15 [2021-06-07T20:48:15.413Z]       │ │ │ │ │   └─TableFullScan_123	25.00	25	cop[tikv]	table:nation	tikv_task:{time:0s, loops:1}	keep order:false	N/A	N/A
20:48:15 [2021-06-07T20:48:15.413Z]       │ │ │ │ └─TableReader_122(Probe)	500000.00	500000	root		time:1.05s, loops:490, cop_task: {num: 1, max: 1.05s, proc_keys: 500000, tot_proc: 1.02s, rpc_num: 1, rpc_time: 1.05s, copr_cache: disabled}	data:TableFullScan_121	20.0 MB	N/A
20:48:15 [2021-06-07T20:48:15.413Z]       │ │ │ │   └─TableFullScan_121	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:948ms, loops:493}, scan_detail: {total_process_keys: 500000, total_keys: 500001, rocksdb: {delete_skipped_count: 0, key_skipped_count: 999999, block: {cache_hit_count: 13, read_count: 1679, read_byte: 104.5 MB}}}	keep order:false	N/A	N/A
20:48:15 [2021-06-07T20:48:15.413Z]       │ │ │ └─TableReader_128(Probe)	240004648.80	189670348	root		time:1m4.9s, loops:184595, cop_task: {num: 761, max: 2.71s, min: 284.5ms, avg: 1.49s, p95: 1.95s, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 17m40.6s, tot_wait: 59s, rpc_num: 761, rpc_time: 18m52.8s, copr_cache: disabled}	data:Selection_127	109.4 MB	N/A
20:48:15 [2021-06-07T20:48:15.413Z]       │ │ │   └─Selection_127	240004648.80	189670348	cop[tikv]		tikv_task:{proc max:1.3s, min:274ms, p80:1.14s, p95:1.19s, iters:296606, tasks:761}, scan_detail: {total_process_keys: 300005811, total_keys: 300006572, rocksdb: {delete_skipped_count: 0, key_skipped_count: 600010861, block: {cache_hit_count: 10457, read_count: 1114191, read_byte: 23.6 GB}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:48:15 [2021-06-07T20:48:15.413Z]       │ │ │     └─TableFullScan_126	300005811.00	300005811	cop[tikv]	table:l1	tikv_task:{proc max:1.21s, min:264ms, p80:1.07s, p95:1.11s, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:48:15 [2021-06-07T20:48:15.413Z]       │ │ └─TableReader_95(Probe)	0.49	3496176	root		time:1m39.7s, loops:3875, cop_task: {num: 5284, max: 517.6ms, min: 2.03ms, avg: 176.7ms, p95: 335.1ms, max_proc_keys: 3519, p95_proc_keys: 1963, tot_proc: 11m11.4s, tot_wait: 3m43.2s, rpc_num: 5284, rpc_time: 15m33.8s, copr_cache: disabled}	data:Selection_94	N/A	N/A
20:48:15 [2021-06-07T20:48:15.413Z]       │ │   └─Selection_94	0.49	3496176	cop[tikv]		tikv_task:{proc max:196ms, min:0s, p80:68ms, p95:81ms, iters:30298, tasks:5284}, scan_detail: {total_process_keys: 7236264, total_keys: 7795463, rocksdb: {delete_skipped_count: 0, key_skipped_count: 1778255, block: {cache_hit_count: 54006487, read_count: 218269, read_byte: 4.21 GB}}}	eq(tpch50.orders.o_orderstatus, "F")	N/A	N/A
20:48:15 [2021-06-07T20:48:15.413Z]       │ │     └─TableRangeScan_93	1.00	7236264	cop[tikv]	table:orders	tikv_task:{proc max:196ms, min:0s, p80:68ms, p95:80ms, iters:30298, tasks:5284}	range: decided by [tpch50.lineitem.l_orderkey], keep order:false	N/A	N/A
20:48:15 [2021-06-07T20:48:15.413Z]       │ └─IndexLookUp_80(Probe)	4.05	17316397	root		time:1m56.9s, loops:17127, index_task: {total_time: 1m3.9s, fetch_handle: 53.9s, build: 3.57ms, wait: 10.1s}, table_task: {total_time: 8m21.3s, num: 1458, concurrency: 760}		19.0 KB	N/A
20:48:15 [2021-06-07T20:48:15.413Z]       │   ├─IndexRangeScan_78(Build)	4.05	17316397	cop[tikv]	table:l2, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:51.7s, loops:18599, cop_task: {num: 3013, max: 656.7ms, min: 359.3µs, avg: 179.2ms, p95: 364.7ms, max_proc_keys: 13477, p95_proc_keys: 8786, tot_proc: 6m46.3s, tot_wait: 1m51.8s, rpc_num: 3013, rpc_time: 8m59.8s, copr_cache: disabled}, tikv_task:{proc max:169ms, min:0s, p80:92ms, p95:107ms, iters:30132, tasks:3013}, scan_detail: {total_process_keys: 17316397, total_keys: 20812489, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17316397, block: {cache_hit_count: 24259889, read_count: 225682, read_byte: 2.00 GB}}}	range: decided by [eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey)], keep order:false	N/A	N/A
20:48:15 [2021-06-07T20:48:15.413Z]       │   └─TableRowIDScan_79(Probe)	4.05	17316397	cop[tikv]	table:l2	time:6m13.7s, loops:21012, cop_task: {num: 7800, max: 617.5ms, min: 420.8µs, avg: 175.1ms, p95: 349.8ms, max_proc_keys: 13280, p95_proc_keys: 4864, tot_proc: 16m20.9s, tot_wait: 5m34.4s, rpc_num: 7800, rpc_time: 22m45.5s, copr_cache: disabled}, tikv_task:{proc max:279ms, min:0s, p80:102ms, p95:139ms, iters:49895, tasks:7800}, scan_detail: {total_process_keys: 17316397, total_keys: 18289579, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5628678, block: {cache_hit_count: 99018435, read_count: 1122, read_byte: 403.6 MB}}}	keep order:false	N/A	N/A
20:48:15 [2021-06-07T20:48:15.413Z]       └─IndexLookUp_39(Probe)	4.05	12022751	root		time:1m48.1s, loops:11942, index_task: {total_time: 57.1s, fetch_handle: 46.6s, build: 3.6ms, wait: 10.5s}, table_task: {total_time: 7m45.4s, num: 1408, concurrency: 730}		214.0 KB	N/A
20:48:15 [2021-06-07T20:48:15.413Z]         ├─IndexRangeScan_36(Build)	5.06	17183344	cop[tikv]	table:l3, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:44.3s, loops:18345, cop_task: {num: 2810, max: 756.7ms, min: 630.1µs, avg: 159.5ms, p95: 339.4ms, max_proc_keys: 18270, p95_proc_keys: 13725, tot_proc: 5m26.2s, tot_wait: 1m41.9s, rpc_num: 2810, rpc_time: 7m28.1s, copr_cache: disabled}, tikv_task:{proc max:163ms, min:0s, p80:74ms, p95:117ms, iters:29144, tasks:2810}, scan_detail: {total_process_keys: 17183344, total_keys: 20546360, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17183344, block: {cache_hit_count: 23553918, read_count: 0, read_byte: 0 Bytes}}}	range: decided by [eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey)], keep order:false	N/A	N/A
20:48:15 [2021-06-07T20:48:15.413Z]         └─Selection_38(Probe)	4.05	12022751	cop[tikv]		time:5m56.9s, loops:13766, cop_task: {num: 10196, max: 614.6ms, min: 511.7µs, avg: 166.2ms, p95: 345.9ms, max_proc_keys: 7354, p95_proc_keys: 3983, tot_proc: 19m53.8s, tot_wait: 7m15.4s, rpc_num: 10196, rpc_time: 28m14.3s, copr_cache: disabled}, tikv_task:{proc max:236ms, min:0s, p80:76ms, p95:115ms, iters:60462, tasks:10196}, scan_detail: {total_process_keys: 17183344, total_keys: 18129492, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5527318, block: {cache_hit_count: 98290069, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:48:15 [2021-06-07T20:48:15.413Z]           └─TableRowIDScan_37	5.06	17183344	cop[tikv]	table:l3	tikv_task:{proc max:234ms, min:0s, p80:75ms, p95:114ms, iters:60462, tasks:10196}	keep order:false	N/A	N/A
20:48:15 [2021-06-07T20:48:15.413Z] + sync
20:48:15 [2021-06-07T20:48:15.413Z] + /usr/bin/echo 3
20:49:36 [2021-06-07T20:49:36.928Z] 
20:49:36 [2021-06-07T20:49:36.928Z] queries/21.sql
20:49:36 [2021-06-07T20:49:36.928Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:49:36 [2021-06-07T20:49:36.928Z] Projection_26	100.00	100	root		time:1m18.6s, loops:2, Concurrency:OFF	tpch50.supplier.s_name, Column#72	4.62 KB	N/A
20:49:36 [2021-06-07T20:49:36.928Z] └─TopN_29	100.00	100	root		time:1m18.6s, loops:2	Column#72:desc, tpch50.supplier.s_name, offset:0, count:100	55.9 KB	N/A
20:49:36 [2021-06-07T20:49:36.928Z]   └─HashAgg_34	12800.00	20057	root		time:1m18.6s, loops:21, partial_worker:{wall_time:1m18.595686029s, concurrency:5, task_num:197, tot_wait:6m32.713458879s, tot_exec:251.216238ms, tot_time:6m32.977177815s, max:1m18.595660101s, p95:1m18.595660101s}, final_worker:{wall_time:1m18.608819945s, concurrency:5, task_num:25, tot_wait:6m32.976815569s, tot_exec:63.938539ms, tot_time:6m33.040764739s, max:1m18.608800399s, p95:1m18.608800399s}	group by:tpch50.supplier.s_name, funcs:count(1)->Column#72, funcs:firstrow(tpch50.supplier.s_name)->tpch50.supplier.s_name	17.2 MB	N/A
20:49:36 [2021-06-07T20:49:36.928Z]     └─IndexHashJoin_42	7828961.66	198698	root		time:1m18.6s, loops:198, inner:{total:2m17.5s, concurrency:5, task:146, construct:6.29s, fetch:1m55s, build:1.23s, join:16.2s}	anti semi join, inner:IndexLookUp_39, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey)	641.0 MB	N/A
20:49:36 [2021-06-07T20:49:36.928Z]       ├─IndexHashJoin_83(Build)	9786202.08	3542799	root		time:1m18.1s, loops:3463, inner:{total:2m24.6s, concurrency:5, task:152, construct:7.96s, fetch:1m58.8s, build:1.22s, join:17.8s}	semi join, inner:IndexLookUp_80, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey), ne(tpch50.lineitem.l_suppkey, tpch50.supplier.s_suppkey)	555.9 MB	N/A
20:49:36 [2021-06-07T20:49:36.928Z]       │ ├─IndexJoin_99(Build)	12232752.60	3675878	root		time:1m17.5s, loops:3595, inner:{total:2m5s, concurrency:5, task:305, construct:16s, fetch:1m47.1s, build:1.86s}, probe:5.06s	inner join, inner:TableReader_95, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.orders.o_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.orders.o_orderkey)	575.5 MB	N/A
20:49:36 [2021-06-07T20:49:36.928Z]       │ │ ├─HashJoin_107(Build)	12232752.60	7609895	root		time:1m17s, loops:7436, build_hash_table:{total:966.1ms, fetch:959.9ms, build:6.17ms}, probe:{concurrency:5, total:6m26.7s, max:1m17.3s, probe:1m0.9s, fetch:5m25.9s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.lineitem.l_suppkey)]	781.7 KB	0 Bytes
20:49:36 [2021-06-07T20:49:36.928Z]       │ │ │ ├─HashJoin_120(Build)	20000.00	20058	root		time:963.8ms, loops:24, build_hash_table:{total:153.2µs, fetch:147.8µs, build:5.42µs}, probe:{concurrency:5, total:4.82s, max:964.8ms, probe:66.1ms, fetch:4.76s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:49:36 [2021-06-07T20:49:36.928Z]       │ │ │ │ ├─TableReader_125(Build)	1.00	1	root		time:44.5µs, loops:2, cop_task: {num: 1, max: 1.21ms, proc_keys: 25, tot_proc: 1ms, rpc_num: 1, rpc_time: 1.17ms, copr_cache: disabled}	data:Selection_124	248 Bytes	N/A
20:49:36 [2021-06-07T20:49:36.929Z]       │ │ │ │ │ └─Selection_124	1.00	1	cop[tikv]		tikv_task:{time:1ms, loops:1}, scan_detail: {total_process_keys: 25, total_keys: 26, rocksdb: {delete_skipped_count: 0, key_skipped_count: 46, block: {cache_hit_count: 17, read_count: 1, read_byte: 23.8 KB}}}	eq(tpch50.nation.n_name, "EGYPT")	N/A	N/A
20:49:36 [2021-06-07T20:49:36.929Z]       │ │ │ │ │   └─TableFullScan_123	25.00	25	cop[tikv]	table:nation	tikv_task:{time:1ms, loops:1}	keep order:false	N/A	N/A
20:49:36 [2021-06-07T20:49:36.929Z]       │ │ │ │ └─TableReader_122(Probe)	500000.00	500000	root		time:950.9ms, loops:490, cop_task: {num: 1, max: 951.3ms, proc_keys: 500000, tot_proc: 916ms, rpc_num: 1, rpc_time: 951.3ms, copr_cache: disabled}	data:TableFullScan_121	20.0 MB	N/A
20:49:36 [2021-06-07T20:49:36.929Z]       │ │ │ │   └─TableFullScan_121	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:859ms, loops:493}, scan_detail: {total_process_keys: 500000, total_keys: 500001, rocksdb: {delete_skipped_count: 0, key_skipped_count: 999999, block: {cache_hit_count: 13, read_count: 1679, read_byte: 104.5 MB}}}	keep order:false	N/A	N/A
20:49:36 [2021-06-07T20:49:36.929Z]       │ │ │ └─TableReader_128(Probe)	240004648.80	189670348	root		time:1m4.8s, loops:184597, cop_task: {num: 761, max: 2.77s, min: 290.4ms, avg: 1.49s, p95: 1.92s, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 17m39s, tot_wait: 59.3s, rpc_num: 761, rpc_time: 18m51.4s, copr_cache: disabled}	data:Selection_127	106.9 MB	N/A
20:49:36 [2021-06-07T20:49:36.929Z]       │ │ │   └─Selection_127	240004648.80	189670348	cop[tikv]		tikv_task:{proc max:1.29s, min:276ms, p80:1.15s, p95:1.2s, iters:296606, tasks:761}, scan_detail: {total_process_keys: 300005811, total_keys: 300006572, rocksdb: {delete_skipped_count: 0, key_skipped_count: 600010861, block: {cache_hit_count: 10455, read_count: 1114193, read_byte: 23.6 GB}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:49:36 [2021-06-07T20:49:36.929Z]       │ │ │     └─TableFullScan_126	300005811.00	300005811	cop[tikv]	table:l1	tikv_task:{proc max:1.21s, min:261ms, p80:1.07s, p95:1.12s, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:49:36 [2021-06-07T20:49:36.929Z]       │ │ └─TableReader_95(Probe)	0.49	3496189	root		time:1m38.4s, loops:3875, cop_task: {num: 5268, max: 596.1ms, min: 1.69ms, avg: 173.7ms, p95: 327.2ms, max_proc_keys: 3472, p95_proc_keys: 1966, tot_proc: 10m54.5s, tot_wait: 3m38.3s, rpc_num: 5268, rpc_time: 15m15s, copr_cache: disabled}	data:Selection_94	N/A	N/A
20:49:36 [2021-06-07T20:49:36.929Z]       │ │   └─Selection_94	0.49	3496189	cop[tikv]		tikv_task:{proc max:158ms, min:0s, p80:69ms, p95:81ms, iters:30304, tasks:5268}, scan_detail: {total_process_keys: 7236304, total_keys: 7795518, rocksdb: {delete_skipped_count: 0, key_skipped_count: 1778300, block: {cache_hit_count: 54006912, read_count: 218218, read_byte: 4.21 GB}}}	eq(tpch50.orders.o_orderstatus, "F")	N/A	N/A
20:49:36 [2021-06-07T20:49:36.929Z]       │ │     └─TableRangeScan_93	1.00	7236304	cop[tikv]	table:orders	tikv_task:{proc max:157ms, min:0s, p80:68ms, p95:81ms, iters:30304, tasks:5268}	range: decided by [tpch50.lineitem.l_orderkey], keep order:false	N/A	N/A
20:49:36 [2021-06-07T20:49:36.929Z]       │ └─IndexLookUp_80(Probe)	4.05	17316463	root		time:1m53.5s, loops:17127, index_task: {total_time: 1m3.3s, fetch_handle: 55.7s, build: 4.88ms, wait: 7.6s}, table_task: {total_time: 8m9.4s, num: 1458, concurrency: 760}		19.1 KB	N/A
20:49:36 [2021-06-07T20:49:36.929Z]       │   ├─IndexRangeScan_78(Build)	4.05	17316463	cop[tikv]	table:l2, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:53.5s, loops:18608, cop_task: {num: 3000, max: 669.7ms, min: 297.5µs, avg: 183.1ms, p95: 367.1ms, max_proc_keys: 13907, p95_proc_keys: 8679, tot_proc: 6m52.5s, tot_wait: 1m55.3s, rpc_num: 3000, rpc_time: 9m9.2s, copr_cache: disabled}, tikv_task:{proc max:177ms, min:0s, p80:92ms, p95:106ms, iters:30204, tasks:3000}, scan_detail: {total_process_keys: 17316463, total_keys: 20812569, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17316463, block: {cache_hit_count: 24259986, read_count: 225683, read_byte: 2.00 GB}}}	range: decided by [eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey)], keep order:false	N/A	N/A
20:49:36 [2021-06-07T20:49:36.929Z]       │   └─TableRowIDScan_79(Probe)	4.05	17316463	cop[tikv]	table:l2	time:6m2.3s, loops:20996, cop_task: {num: 7822, max: 610.1ms, min: 484µs, avg: 170.7ms, p95: 344.2ms, max_proc_keys: 12928, p95_proc_keys: 4882, tot_proc: 15m56.7s, tot_wait: 5m28.4s, rpc_num: 7822, rpc_time: 22m15.1s, copr_cache: disabled}, tikv_task:{proc max:276ms, min:0s, p80:101ms, p95:138ms, iters:50011, tasks:7822}, scan_detail: {total_process_keys: 17316463, total_keys: 18290073, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5631562, block: {cache_hit_count: 99018082, read_count: 1118, read_byte: 397.9 MB}}}	keep order:false	N/A	N/A
20:49:36 [2021-06-07T20:49:36.929Z]       └─IndexLookUp_39(Probe)	4.05	12022767	root		time:1m50.3s, loops:11949, index_task: {total_time: 58.8s, fetch_handle: 49.6s, build: 3.44ms, wait: 9.2s}, table_task: {total_time: 7m52.9s, num: 1408, concurrency: 730}		219.7 KB	N/A
20:49:36 [2021-06-07T20:49:36.929Z]         ├─IndexRangeScan_36(Build)	5.06	17183364	cop[tikv]	table:l3, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:47.4s, loops:18385, cop_task: {num: 2783, max: 720.5ms, min: 485.5µs, avg: 167.4ms, p95: 350.6ms, max_proc_keys: 21470, p95_proc_keys: 13818, tot_proc: 5m48.7s, tot_wait: 1m38.2s, rpc_num: 2783, rpc_time: 7m45.8s, copr_cache: disabled}, tikv_task:{proc max:170ms, min:0s, p80:74ms, p95:117ms, iters:29124, tasks:2783}, scan_detail: {total_process_keys: 17183364, total_keys: 20546387, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17183364, block: {cache_hit_count: 23553967, read_count: 0, read_byte: 0 Bytes}}}	range: decided by [eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey)], keep order:false	N/A	N/A
20:49:36 [2021-06-07T20:49:36.929Z]         └─Selection_38(Probe)	4.05	12022767	cop[tikv]		time:6m2s, loops:13767, cop_task: {num: 10238, max: 677.8ms, min: 365.6µs, avg: 167.4ms, p95: 336.4ms, max_proc_keys: 7179, p95_proc_keys: 3990, tot_proc: 20m1.9s, tot_wait: 7m27.1s, rpc_num: 10238, rpc_time: 28m33.8s, copr_cache: disabled}, tikv_task:{proc max:215ms, min:0s, p80:75ms, p95:112ms, iters:60639, tasks:10238}, scan_detail: {total_process_keys: 17183364, total_keys: 18129089, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5527745, block: {cache_hit_count: 98285809, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:49:36 [2021-06-07T20:49:36.929Z]           └─TableRowIDScan_37	5.06	17183364	cop[tikv]	table:l3	tikv_task:{proc max:214ms, min:0s, p80:74ms, p95:111ms, iters:60639, tasks:10238}	keep order:false	N/A	N/A
20:49:36 [2021-06-07T20:49:36.929Z] + sync
20:49:36 [2021-06-07T20:49:36.929Z] + /usr/bin/echo 3
20:51:13 [2021-06-07T20:51:13.290Z] 
20:51:13 [2021-06-07T20:51:13.290Z] queries/21.sql
20:51:13 [2021-06-07T20:51:13.290Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:51:13 [2021-06-07T20:51:13.290Z] Projection_26	100.00	100	root		time:1m18.9s, loops:2, Concurrency:OFF	tpch50.supplier.s_name, Column#72	4.62 KB	N/A
20:51:13 [2021-06-07T20:51:13.290Z] └─TopN_29	100.00	100	root		time:1m18.9s, loops:2	Column#72:desc, tpch50.supplier.s_name, offset:0, count:100	58.4 KB	N/A
20:51:13 [2021-06-07T20:51:13.290Z]   └─HashAgg_34	12800.00	20057	root		time:1m18.9s, loops:21, partial_worker:{wall_time:1m18.922103787s, concurrency:5, task_num:197, tot_wait:6m34.327595712s, tot_exec:268.198578ms, tot_time:6m34.608662978s, max:1m18.922073041s, p95:1m18.922073041s}, final_worker:{wall_time:1m18.934856671s, concurrency:5, task_num:25, tot_wait:6m34.607219876s, tot_exec:63.459772ms, tot_time:6m34.670691553s, max:1m18.934828482s, p95:1m18.934828482s}	group by:tpch50.supplier.s_name, funcs:count(1)->Column#72, funcs:firstrow(tpch50.supplier.s_name)->tpch50.supplier.s_name	17.2 MB	N/A
20:51:13 [2021-06-07T20:51:13.290Z]     └─IndexHashJoin_42	7828961.66	198698	root		time:1m18.9s, loops:198, inner:{total:2m17.4s, concurrency:5, task:146, construct:6.51s, fetch:1m54.5s, build:1.24s, join:16.3s}	anti semi join, inner:IndexLookUp_39, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey)	641.1 MB	N/A
20:51:13 [2021-06-07T20:51:13.290Z]       ├─IndexHashJoin_83(Build)	9786202.08	3542799	root		time:1m18.4s, loops:3463, inner:{total:2m26.4s, concurrency:5, task:152, construct:7.6s, fetch:2m1.4s, build:1.23s, join:17.5s}	semi join, inner:IndexLookUp_80, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey), ne(tpch50.lineitem.l_suppkey, tpch50.supplier.s_suppkey)	555.9 MB	N/A
20:51:13 [2021-06-07T20:51:13.290Z]       │ ├─IndexJoin_99(Build)	12232752.60	3675878	root		time:1m17.9s, loops:3595, inner:{total:2m6.1s, concurrency:5, task:305, construct:16.1s, fetch:1m48.1s, build:1.83s}, probe:5.1s	inner join, inner:TableReader_95, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.orders.o_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.orders.o_orderkey)	575.3 MB	N/A
20:51:13 [2021-06-07T20:51:13.290Z]       │ │ ├─HashJoin_107(Build)	12232752.60	7609895	root		time:1m17.3s, loops:7436, build_hash_table:{total:1.21s, fetch:1.2s, build:5.82ms}, probe:{concurrency:5, total:6m28.5s, max:1m17.7s, probe:1m0.8s, fetch:5m27.7s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.lineitem.l_suppkey)]	732.8 KB	0 Bytes
20:51:13 [2021-06-07T20:51:13.290Z]       │ │ │ ├─HashJoin_120(Build)	20000.00	20058	root		time:1.21s, loops:22, build_hash_table:{total:168.4µs, fetch:162.7µs, build:5.72µs}, probe:{concurrency:5, total:6.03s, max:1.21s, probe:63.3ms, fetch:5.96s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:51:13 [2021-06-07T20:51:13.290Z]       │ │ │ │ ├─TableReader_125(Build)	1.00	1	root		time:50.8µs, loops:2, cop_task: {num: 1, max: 1.21ms, proc_keys: 25, tot_proc: 1ms, rpc_num: 1, rpc_time: 1.18ms, copr_cache: disabled}	data:Selection_124	248 Bytes	N/A
20:51:13 [2021-06-07T20:51:13.290Z]       │ │ │ │ │ └─Selection_124	1.00	1	cop[tikv]		tikv_task:{time:1ms, loops:1}, scan_detail: {total_process_keys: 25, total_keys: 26, rocksdb: {delete_skipped_count: 0, key_skipped_count: 46, block: {cache_hit_count: 17, read_count: 1, read_byte: 23.8 KB}}}	eq(tpch50.nation.n_name, "EGYPT")	N/A	N/A
20:51:13 [2021-06-07T20:51:13.290Z]       │ │ │ │ │   └─TableFullScan_123	25.00	25	cop[tikv]	table:nation	tikv_task:{time:1ms, loops:1}	keep order:false	N/A	N/A
20:51:13 [2021-06-07T20:51:13.290Z]       │ │ │ │ └─TableReader_122(Probe)	500000.00	500000	root		time:1.19s, loops:490, cop_task: {num: 1, max: 1.19s, proc_keys: 500000, tot_proc: 1.17s, rpc_num: 1, rpc_time: 1.19s, copr_cache: disabled}	data:TableFullScan_121	20.0 MB	N/A
20:51:13 [2021-06-07T20:51:13.290Z]       │ │ │ │   └─TableFullScan_121	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:1.1s, loops:493}, scan_detail: {total_process_keys: 500000, total_keys: 500001, rocksdb: {delete_skipped_count: 0, key_skipped_count: 999999, block: {cache_hit_count: 13, read_count: 1679, read_byte: 104.5 MB}}}	keep order:false	N/A	N/A
20:51:13 [2021-06-07T20:51:13.290Z]       │ │ │ └─TableReader_128(Probe)	240004648.80	189670348	root		time:1m4.9s, loops:184597, cop_task: {num: 761, max: 2.4s, min: 296.8ms, avg: 1.49s, p95: 1.96s, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 17m40.3s, tot_wait: 59.9s, rpc_num: 761, rpc_time: 18m53.2s, copr_cache: disabled}	data:Selection_127	109.4 MB	N/A
20:51:13 [2021-06-07T20:51:13.290Z]       │ │ │   └─Selection_127	240004648.80	189670348	cop[tikv]		tikv_task:{proc max:1.29s, min:283ms, p80:1.15s, p95:1.19s, iters:296606, tasks:761}, scan_detail: {total_process_keys: 300005811, total_keys: 300006572, rocksdb: {delete_skipped_count: 0, key_skipped_count: 600010861, block: {cache_hit_count: 10455, read_count: 1114193, read_byte: 23.6 GB}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:51:13 [2021-06-07T20:51:13.290Z]       │ │ │     └─TableFullScan_126	300005811.00	300005811	cop[tikv]	table:l1	tikv_task:{proc max:1.2s, min:264ms, p80:1.07s, p95:1.11s, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:51:13 [2021-06-07T20:51:13.290Z]       │ │ └─TableReader_95(Probe)	0.49	3496176	root		time:1m39.4s, loops:3875, cop_task: {num: 5292, max: 518.4ms, min: 1.54ms, avg: 174.9ms, p95: 333.5ms, max_proc_keys: 3589, p95_proc_keys: 1959, tot_proc: 11m3.9s, tot_wait: 3m42.5s, rpc_num: 5292, rpc_time: 15m25.6s, copr_cache: disabled}	data:Selection_94	N/A	N/A
20:51:13 [2021-06-07T20:51:13.290Z]       │ │   └─Selection_94	0.49	3496176	cop[tikv]		tikv_task:{proc max:132ms, min:0s, p80:68ms, p95:82ms, iters:30327, tasks:5292}, scan_detail: {total_process_keys: 7236286, total_keys: 7795550, rocksdb: {delete_skipped_count: 0, key_skipped_count: 1778446, block: {cache_hit_count: 54006858, read_count: 218186, read_byte: 4.21 GB}}}	eq(tpch50.orders.o_orderstatus, "F")	N/A	N/A
20:51:13 [2021-06-07T20:51:13.290Z]       │ │     └─TableRangeScan_93	1.00	7236286	cop[tikv]	table:orders	tikv_task:{proc max:132ms, min:0s, p80:68ms, p95:81ms, iters:30327, tasks:5292}	range: decided by [tpch50.lineitem.l_orderkey], keep order:false	N/A	N/A
20:51:13 [2021-06-07T20:51:13.290Z]       │ └─IndexLookUp_80(Probe)	4.05	17316465	root		time:1m56s, loops:17128, index_task: {total_time: 1m5.6s, fetch_handle: 56.8s, build: 3.51ms, wait: 8.79s}, table_task: {total_time: 8m19.8s, num: 1458, concurrency: 760}		18.9 KB	N/A
20:51:13 [2021-06-07T20:51:13.290Z]       │   ├─IndexRangeScan_78(Build)	4.05	17316465	cop[tikv]	table:l2, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:54.6s, loops:18609, cop_task: {num: 3007, max: 718.3ms, min: 472.3µs, avg: 183.3ms, p95: 366.7ms, max_proc_keys: 12464, p95_proc_keys: 8712, tot_proc: 6m51.1s, tot_wait: 1m59.5s, rpc_num: 3007, rpc_time: 9m11.2s, copr_cache: disabled}, tikv_task:{proc max:159ms, min:0s, p80:92ms, p95:106ms, iters:30193, tasks:3007}, scan_detail: {total_process_keys: 17316465, total_keys: 20812572, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17316465, block: {cache_hit_count: 24259989, read_count: 225687, read_byte: 2.00 GB}}}	range: decided by [eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey)], keep order:false	N/A	N/A
20:51:13 [2021-06-07T20:51:13.290Z]       │   └─TableRowIDScan_79(Probe)	4.05	17316465	cop[tikv]	table:l2	time:6m8.8s, loops:20967, cop_task: {num: 7830, max: 675.7ms, min: 493.7µs, avg: 171.7ms, p95: 341.7ms, max_proc_keys: 9930, p95_proc_keys: 4877, tot_proc: 15m57.5s, tot_wait: 5m37.5s, rpc_num: 7830, rpc_time: 22m24s, copr_cache: disabled}, tikv_task:{proc max:288ms, min:0s, p80:102ms, p95:137ms, iters:50052, tasks:7830}, scan_detail: {total_process_keys: 17316465, total_keys: 18289906, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5630827, block: {cache_hit_count: 99018136, read_count: 1110, read_byte: 388.7 MB}}}	keep order:false	N/A	N/A
20:51:13 [2021-06-07T20:51:13.290Z]       └─IndexLookUp_39(Probe)	4.05	12022796	root		time:1m49.7s, loops:11943, index_task: {total_time: 59.1s, fetch_handle: 48.8s, build: 3.41ms, wait: 10.3s}, table_task: {total_time: 7m54.1s, num: 1408, concurrency: 730}		219.0 KB	N/A
20:51:13 [2021-06-07T20:51:13.290Z]         ├─IndexRangeScan_36(Build)	5.06	17183390	cop[tikv]	table:l3, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:46.6s, loops:18335, cop_task: {num: 2778, max: 627.2ms, min: 808.5µs, avg: 165.9ms, p95: 358.3ms, max_proc_keys: 19083, p95_proc_keys: 13792, tot_proc: 5m41.3s, tot_wait: 1m39.4s, rpc_num: 2778, rpc_time: 7m40.7s, copr_cache: disabled}, tikv_task:{proc max:182ms, min:0s, p80:76ms, p95:117ms, iters:29068, tasks:2778}, scan_detail: {total_process_keys: 17183390, total_keys: 20546416, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17183390, block: {cache_hit_count: 23553988, read_count: 0, read_byte: 0 Bytes}}}	range: decided by [eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey)], keep order:false	N/A	N/A
20:51:13 [2021-06-07T20:51:13.290Z]         └─Selection_38(Probe)	4.05	12022796	cop[tikv]		time:6m4.8s, loops:13782, cop_task: {num: 10262, max: 561.1ms, min: 486.5µs, avg: 168.9ms, p95: 342.1ms, max_proc_keys: 8657, p95_proc_keys: 3924, tot_proc: 20m11.2s, tot_wait: 7m36.2s, rpc_num: 10262, rpc_time: 28m53s, copr_cache: disabled}, tikv_task:{proc max:208ms, min:0s, p80:74ms, p95:113ms, iters:60729, tasks:10262}, scan_detail: {total_process_keys: 17183390, total_keys: 18129084, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5529634, block: {cache_hit_count: 98282741, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:51:13 [2021-06-07T20:51:13.290Z]           └─TableRowIDScan_37	5.06	17183390	cop[tikv]	table:l3	tikv_task:{proc max:205ms, min:0s, p80:74ms, p95:112ms, iters:60729, tasks:10262}	keep order:false	N/A	N/A
20:51:13 [2021-06-07T20:51:13.290Z] + sync
20:51:13 [2021-06-07T20:51:13.290Z] + /usr/bin/echo 3
20:52:34 [2021-06-07T20:52:34.660Z] 
20:52:34 [2021-06-07T20:52:34.660Z] queries/21.sql
20:52:34 [2021-06-07T20:52:34.660Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:52:34 [2021-06-07T20:52:34.660Z] Projection_26	100.00	100	root		time:1m19s, loops:2, Concurrency:OFF	tpch50.supplier.s_name, Column#72	4.62 KB	N/A
20:52:34 [2021-06-07T20:52:34.660Z] └─TopN_29	100.00	100	root		time:1m19s, loops:2	Column#72:desc, tpch50.supplier.s_name, offset:0, count:100	58.4 KB	N/A
20:52:34 [2021-06-07T20:52:34.660Z]   └─HashAgg_34	12800.00	20057	root		time:1m19s, loops:21, partial_worker:{wall_time:1m18.972930043s, concurrency:5, task_num:197, tot_wait:6m34.590082547s, tot_exec:258.692883ms, tot_time:6m34.862003083s, max:1m18.972902365s, p95:1m18.972902365s}, final_worker:{wall_time:1m18.984350924s, concurrency:5, task_num:25, tot_wait:6m34.859052643s, tot_exec:61.880539ms, tot_time:6m34.920944688s, max:1m18.984337034s, p95:1m18.984337034s}	group by:tpch50.supplier.s_name, funcs:count(1)->Column#72, funcs:firstrow(tpch50.supplier.s_name)->tpch50.supplier.s_name	17.2 MB	N/A
20:52:34 [2021-06-07T20:52:34.660Z]     └─IndexHashJoin_42	7828961.66	198698	root		time:1m19s, loops:198, inner:{total:2m15.2s, concurrency:5, task:147, construct:6.24s, fetch:1m52.9s, build:1.1s, join:16s}	anti semi join, inner:IndexLookUp_39, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey)	641.1 MB	N/A
20:52:34 [2021-06-07T20:52:34.660Z]       ├─IndexHashJoin_83(Build)	9786202.08	3542799	root		time:1m18.5s, loops:3464, inner:{total:2m26.9s, concurrency:5, task:152, construct:7.72s, fetch:2m1.6s, build:1.23s, join:17.6s}	semi join, inner:IndexLookUp_80, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey), ne(tpch50.lineitem.l_suppkey, tpch50.supplier.s_suppkey)	555.9 MB	N/A
20:52:34 [2021-06-07T20:52:34.660Z]       │ ├─IndexJoin_99(Build)	12232752.60	3675878	root		time:1m18s, loops:3595, inner:{total:2m3.1s, concurrency:5, task:305, construct:16s, fetch:1m45.2s, build:1.9s}, probe:5.17s	inner join, inner:TableReader_95, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.orders.o_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.orders.o_orderkey)	575.3 MB	N/A
20:52:34 [2021-06-07T20:52:34.660Z]       │ │ ├─HashJoin_107(Build)	12232752.60	7609895	root		time:1m17.4s, loops:7435, build_hash_table:{total:951.7ms, fetch:943.8ms, build:7.9ms}, probe:{concurrency:5, total:6m28.9s, max:1m17.8s, probe:1m1.2s, fetch:5m27.7s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.lineitem.l_suppkey)]	737.6 KB	0 Bytes
20:52:34 [2021-06-07T20:52:34.660Z]       │ │ │ ├─HashJoin_120(Build)	20000.00	20058	root		time:949.2ms, loops:22, build_hash_table:{total:186.6µs, fetch:178.9µs, build:7.7µs}, probe:{concurrency:5, total:4.75s, max:949.8ms, probe:67.9ms, fetch:4.68s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:52:34 [2021-06-07T20:52:34.660Z]       │ │ │ │ ├─TableReader_125(Build)	1.00	1	root		time:63µs, loops:2, cop_task: {num: 1, max: 1.19ms, proc_keys: 25, tot_proc: 1ms, rpc_num: 1, rpc_time: 1.17ms, copr_cache: disabled}	data:Selection_124	248 Bytes	N/A
20:52:34 [2021-06-07T20:52:34.660Z]       │ │ │ │ │ └─Selection_124	1.00	1	cop[tikv]		tikv_task:{time:1ms, loops:1}, scan_detail: {total_process_keys: 25, total_keys: 26, rocksdb: {delete_skipped_count: 0, key_skipped_count: 46, block: {cache_hit_count: 17, read_count: 1, read_byte: 23.8 KB}}}	eq(tpch50.nation.n_name, "EGYPT")	N/A	N/A
20:52:34 [2021-06-07T20:52:34.660Z]       │ │ │ │ │   └─TableFullScan_123	25.00	25	cop[tikv]	table:nation	tikv_task:{time:1ms, loops:1}	keep order:false	N/A	N/A
20:52:34 [2021-06-07T20:52:34.660Z]       │ │ │ │ └─TableReader_122(Probe)	500000.00	500000	root		time:936.2ms, loops:490, cop_task: {num: 1, max: 936.9ms, proc_keys: 500000, tot_proc: 890ms, rpc_num: 1, rpc_time: 936.9ms, copr_cache: disabled}	data:TableFullScan_121	20.0 MB	N/A
20:52:34 [2021-06-07T20:52:34.660Z]       │ │ │ │   └─TableFullScan_121	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:836ms, loops:493}, scan_detail: {total_process_keys: 500000, total_keys: 500001, rocksdb: {delete_skipped_count: 0, key_skipped_count: 999999, block: {cache_hit_count: 13, read_count: 1679, read_byte: 104.5 MB}}}	keep order:false	N/A	N/A
20:52:34 [2021-06-07T20:52:34.660Z]       │ │ │ └─TableReader_128(Probe)	240004648.80	189670348	root		time:1m5.1s, loops:184598, cop_task: {num: 761, max: 2.77s, min: 287.8ms, avg: 1.5s, p95: 1.99s, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 17m46.7s, tot_wait: 58.9s, rpc_num: 761, rpc_time: 18m58.8s, copr_cache: disabled}	data:Selection_127	101.7 MB	N/A
20:52:34 [2021-06-07T20:52:34.660Z]       │ │ │   └─Selection_127	240004648.80	189670348	cop[tikv]		tikv_task:{proc max:1.27s, min:275ms, p80:1.15s, p95:1.19s, iters:296606, tasks:761}, scan_detail: {total_process_keys: 300005811, total_keys: 300006572, rocksdb: {delete_skipped_count: 0, key_skipped_count: 600010861, block: {cache_hit_count: 10451, read_count: 1114197, read_byte: 23.6 GB}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:52:34 [2021-06-07T20:52:34.660Z]       │ │ │     └─TableFullScan_126	300005811.00	300005811	cop[tikv]	table:l1	tikv_task:{proc max:1.19s, min:264ms, p80:1.07s, p95:1.12s, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:52:34 [2021-06-07T20:52:34.660Z]       │ │ └─TableReader_95(Probe)	0.49	3496179	root		time:1m36.3s, loops:3875, cop_task: {num: 5275, max: 533.2ms, min: 1.85ms, avg: 172.8ms, p95: 330.1ms, max_proc_keys: 3533, p95_proc_keys: 1960, tot_proc: 10m54.7s, tot_wait: 3m38.1s, rpc_num: 5275, rpc_time: 15m11.7s, copr_cache: disabled}	data:Selection_94	N/A	N/A
20:52:34 [2021-06-07T20:52:34.660Z]       │ │   └─Selection_94	0.49	3496179	cop[tikv]		tikv_task:{proc max:151ms, min:0s, p80:68ms, p95:81ms, iters:30213, tasks:5275}, scan_detail: {total_process_keys: 7236279, total_keys: 7795452, rocksdb: {delete_skipped_count: 0, key_skipped_count: 1778145, block: {cache_hit_count: 54006590, read_count: 218223, read_byte: 4.21 GB}}}	eq(tpch50.orders.o_orderstatus, "F")	N/A	N/A
20:52:34 [2021-06-07T20:52:34.660Z]       │ │     └─TableRangeScan_93	1.00	7236279	cop[tikv]	table:orders	tikv_task:{proc max:151ms, min:0s, p80:68ms, p95:81ms, iters:30213, tasks:5275}	range: decided by [tpch50.lineitem.l_orderkey], keep order:false	N/A	N/A
20:52:34 [2021-06-07T20:52:34.660Z]       │ └─IndexLookUp_80(Probe)	4.05	17316352	root		time:1m56.2s, loops:17131, index_task: {total_time: 1m4.7s, fetch_handle: 55.9s, build: 3.4ms, wait: 8.84s}, table_task: {total_time: 8m17.6s, num: 1458, concurrency: 760}		19.0 KB	N/A
20:52:34 [2021-06-07T20:52:34.660Z]       │   ├─IndexRangeScan_78(Build)	4.05	17316352	cop[tikv]	table:l2, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:53.7s, loops:18641, cop_task: {num: 3029, max: 771.4ms, min: 372.7µs, avg: 179.5ms, p95: 367.4ms, max_proc_keys: 12369, p95_proc_keys: 8784, tot_proc: 6m51s, tot_wait: 1m51.7s, rpc_num: 3029, rpc_time: 9m3.6s, copr_cache: disabled}, tikv_task:{proc max:155ms, min:0s, p80:91ms, p95:106ms, iters:30264, tasks:3029}, scan_detail: {total_process_keys: 17316352, total_keys: 20812435, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17316352, block: {cache_hit_count: 24259826, read_count: 225682, read_byte: 2.00 GB}}}	range: decided by [eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey)], keep order:false	N/A	N/A
20:52:34 [2021-06-07T20:52:34.660Z]       │   └─TableRowIDScan_79(Probe)	4.05	17316352	cop[tikv]	table:l2	time:6m11.8s, loops:20993, cop_task: {num: 7811, max: 678ms, min: 481.9µs, avg: 173.9ms, p95: 358ms, max_proc_keys: 11690, p95_proc_keys: 4841, tot_proc: 16m18.2s, tot_wait: 5m31.3s, rpc_num: 7811, rpc_time: 22m38.1s, copr_cache: disabled}, tikv_task:{proc max:229ms, min:0s, p80:103ms, p95:137ms, iters:49905, tasks:7811}, scan_detail: {total_process_keys: 17316352, total_keys: 18291544, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5637728, block: {cache_hit_count: 99012150, read_count: 1120, read_byte: 397.9 MB}}}	keep order:false	N/A	N/A
20:52:34 [2021-06-07T20:52:34.660Z]       └─IndexLookUp_39(Probe)	4.05	12022691	root		time:1m48.2s, loops:11946, index_task: {total_time: 57.8s, fetch_handle: 45.8s, build: 3.77ms, wait: 12s}, table_task: {total_time: 7m49.5s, num: 1410, concurrency: 735}		269.2 KB	N/A
20:52:34 [2021-06-07T20:52:34.660Z]         ├─IndexRangeScan_36(Build)	5.06	17183265	cop[tikv]	table:l3, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:43.6s, loops:18355, cop_task: {num: 2797, max: 833.6ms, min: 793µs, avg: 156.2ms, p95: 342.3ms, max_proc_keys: 18563, p95_proc_keys: 13688, tot_proc: 5m23.2s, tot_wait: 1m34.7s, rpc_num: 2797, rpc_time: 7m16.8s, copr_cache: disabled}, tikv_task:{proc max:166ms, min:0s, p80:76ms, p95:115ms, iters:29128, tasks:2797}, scan_detail: {total_process_keys: 17183265, total_keys: 20546268, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17183265, block: {cache_hit_count: 23553828, read_count: 0, read_byte: 0 Bytes}}}	range: decided by [eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey)], keep order:false	N/A	N/A
20:52:34 [2021-06-07T20:52:34.660Z]         └─Selection_38(Probe)	4.05	12022691	cop[tikv]		time:6m3.7s, loops:13772, cop_task: {num: 10224, max: 674ms, min: 364.9µs, avg: 169.2ms, p95: 342.9ms, max_proc_keys: 7469, p95_proc_keys: 4011, tot_proc: 20m19.1s, tot_wait: 7m26.2s, rpc_num: 10224, rpc_time: 28m49.8s, copr_cache: disabled}, tikv_task:{proc max:305ms, min:0s, p80:76ms, p95:115ms, iters:60670, tasks:10224}, scan_detail: {total_process_keys: 17183265, total_keys: 18129082, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5525471, block: {cache_hit_count: 98294981, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:52:34 [2021-06-07T20:52:34.660Z]           └─TableRowIDScan_37	5.06	17183265	cop[tikv]	table:l3	tikv_task:{proc max:302ms, min:0s, p80:75ms, p95:114ms, iters:60670, tasks:10224}	keep order:false	N/A	N/A
20:52:34 [2021-06-07T20:52:34.660Z] + sync
20:52:34 [2021-06-07T20:52:34.660Z] + /usr/bin/echo 3
20:53:56 [2021-06-07T20:53:56.027Z] 
20:53:56 [2021-06-07T20:53:56.027Z] queries/21.sql
20:53:56 [2021-06-07T20:53:56.027Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:53:56 [2021-06-07T20:53:56.027Z] Projection_26	100.00	100	root		time:1m19s, loops:2, Concurrency:OFF	tpch50.supplier.s_name, Column#72	4.62 KB	N/A
20:53:56 [2021-06-07T20:53:56.027Z] └─TopN_29	100.00	100	root		time:1m19s, loops:2	Column#72:desc, tpch50.supplier.s_name, offset:0, count:100	58.4 KB	N/A
20:53:56 [2021-06-07T20:53:56.027Z]   └─HashAgg_34	12800.00	20057	root		time:1m19s, loops:21, partial_worker:{wall_time:1m18.983786951s, concurrency:5, task_num:196, tot_wait:6m34.6139948s, tot_exec:291.414082ms, tot_time:6m34.917004907s, max:1m18.98376382s, p95:1m18.98376382s}, final_worker:{wall_time:1m18.996191073s, concurrency:5, task_num:25, tot_wait:6m34.915983455s, tot_exec:62.110776ms, tot_time:6m34.978105671s, max:1m18.996172447s, p95:1m18.996172447s}	group by:tpch50.supplier.s_name, funcs:count(1)->Column#72, funcs:firstrow(tpch50.supplier.s_name)->tpch50.supplier.s_name	17.2 MB	N/A
20:53:56 [2021-06-07T20:53:56.027Z]     └─IndexHashJoin_42	7828961.66	198698	root		time:1m19s, loops:197, inner:{total:2m16s, concurrency:5, task:146, construct:6.41s, fetch:1m53.3s, build:1.24s, join:16.3s}	anti semi join, inner:IndexLookUp_39, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey)	641.0 MB	N/A
20:53:56 [2021-06-07T20:53:56.027Z]       ├─IndexHashJoin_83(Build)	9786202.08	3542799	root		time:1m18.5s, loops:3463, inner:{total:2m23.5s, concurrency:5, task:152, construct:7.95s, fetch:1m58.2s, build:1.27s, join:17.4s}	semi join, inner:IndexLookUp_80, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey), ne(tpch50.lineitem.l_suppkey, tpch50.supplier.s_suppkey)	555.9 MB	N/A
20:53:56 [2021-06-07T20:53:56.027Z]       │ ├─IndexJoin_99(Build)	12232752.60	3675878	root		time:1m18s, loops:3595, inner:{total:2m7.1s, concurrency:5, task:305, construct:16.3s, fetch:1m48.9s, build:1.92s}, probe:5.05s	inner join, inner:TableReader_95, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.orders.o_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.orders.o_orderkey)	575.3 MB	N/A
20:53:56 [2021-06-07T20:53:56.027Z]       │ │ ├─HashJoin_107(Build)	12232752.60	7609895	root		time:1m17.6s, loops:7436, build_hash_table:{total:1.03s, fetch:1.02s, build:6.42ms}, probe:{concurrency:5, total:6m29.5s, max:1m17.9s, probe:1m0.7s, fetch:5m28.8s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.lineitem.l_suppkey)]	732.8 KB	0 Bytes
20:53:56 [2021-06-07T20:53:56.027Z]       │ │ │ ├─HashJoin_120(Build)	20000.00	20058	root		time:1.02s, loops:22, build_hash_table:{total:184.3µs, fetch:178.4µs, build:5.83µs}, probe:{concurrency:5, total:5.13s, max:1.03s, probe:66.9ms, fetch:5.06s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:53:56 [2021-06-07T20:53:56.027Z]       │ │ │ │ ├─TableReader_125(Build)	1.00	1	root		time:41.4µs, loops:2, cop_task: {num: 1, max: 1.39ms, proc_keys: 25, rpc_num: 1, rpc_time: 1.35ms, copr_cache: disabled}	data:Selection_124	240 Bytes	N/A
20:53:56 [2021-06-07T20:53:56.027Z]       │ │ │ │ │ └─Selection_124	1.00	1	cop[tikv]		tikv_task:{time:0s, loops:1}, scan_detail: {total_process_keys: 25, total_keys: 26, rocksdb: {delete_skipped_count: 0, key_skipped_count: 46, block: {cache_hit_count: 17, read_count: 1, read_byte: 23.8 KB}}}	eq(tpch50.nation.n_name, "EGYPT")	N/A	N/A
20:53:56 [2021-06-07T20:53:56.027Z]       │ │ │ │ │   └─TableFullScan_123	25.00	25	cop[tikv]	table:nation	tikv_task:{time:0s, loops:1}	keep order:false	N/A	N/A
20:53:56 [2021-06-07T20:53:56.027Z]       │ │ │ │ └─TableReader_122(Probe)	500000.00	500000	root		time:1.01s, loops:490, cop_task: {num: 1, max: 1.01s, proc_keys: 500000, tot_proc: 980ms, rpc_num: 1, rpc_time: 1.01s, copr_cache: disabled}	data:TableFullScan_121	20.0 MB	N/A
20:53:56 [2021-06-07T20:53:56.027Z]       │ │ │ │   └─TableFullScan_121	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:900ms, loops:493}, scan_detail: {total_process_keys: 500000, total_keys: 500001, rocksdb: {delete_skipped_count: 0, key_skipped_count: 999999, block: {cache_hit_count: 13, read_count: 1679, read_byte: 104.5 MB}}}	keep order:false	N/A	N/A
20:53:56 [2021-06-07T20:53:56.027Z]       │ │ │ └─TableReader_128(Probe)	240004648.80	189670348	root		time:1m5.4s, loops:184595, cop_task: {num: 761, max: 2.35s, min: 315.6ms, avg: 1.49s, p95: 1.96s, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 17m42.9s, tot_wait: 59.2s, rpc_num: 761, rpc_time: 18m55s, copr_cache: disabled}	data:Selection_127	109.4 MB	N/A
20:53:56 [2021-06-07T20:53:56.027Z]       │ │ │   └─Selection_127	240004648.80	189670348	cop[tikv]		tikv_task:{proc max:1.29s, min:302ms, p80:1.15s, p95:1.19s, iters:296606, tasks:761}, scan_detail: {total_process_keys: 300005811, total_keys: 300006572, rocksdb: {delete_skipped_count: 0, key_skipped_count: 600010861, block: {cache_hit_count: 10452, read_count: 1114196, read_byte: 23.6 GB}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:53:56 [2021-06-07T20:53:56.027Z]       │ │ │     └─TableFullScan_126	300005811.00	300005811	cop[tikv]	table:l1	tikv_task:{proc max:1.2s, min:283ms, p80:1.07s, p95:1.11s, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:53:56 [2021-06-07T20:53:56.027Z]       │ │ └─TableReader_95(Probe)	0.49	3496177	root		time:1m40.1s, loops:3875, cop_task: {num: 5277, max: 514.7ms, min: 1.45ms, avg: 177.8ms, p95: 343.2ms, max_proc_keys: 3775, p95_proc_keys: 1940, tot_proc: 11m13.3s, tot_wait: 3m45.9s, rpc_num: 5277, rpc_time: 15m37.9s, copr_cache: disabled}	data:Selection_94	N/A	N/A
20:53:56 [2021-06-07T20:53:56.028Z]       │ │   └─Selection_94	0.49	3496177	cop[tikv]		tikv_task:{proc max:165ms, min:0s, p80:68ms, p95:80ms, iters:30293, tasks:5277}, scan_detail: {total_process_keys: 7236284, total_keys: 7795535, rocksdb: {delete_skipped_count: 0, key_skipped_count: 1778443, block: {cache_hit_count: 54006388, read_count: 218172, read_byte: 4.21 GB}}}	eq(tpch50.orders.o_orderstatus, "F")	N/A	N/A
20:53:56 [2021-06-07T20:53:56.028Z]       │ │     └─TableRangeScan_93	1.00	7236284	cop[tikv]	table:orders	tikv_task:{proc max:165ms, min:0s, p80:67ms, p95:80ms, iters:30293, tasks:5277}	range: decided by [tpch50.lineitem.l_orderkey], keep order:false	N/A	N/A
20:53:56 [2021-06-07T20:53:56.028Z]       │ └─IndexLookUp_80(Probe)	4.05	17316468	root		time:1m52.8s, loops:17127, index_task: {total_time: 1m2s, fetch_handle: 54.2s, build: 3.66ms, wait: 7.79s}, table_task: {total_time: 8m5.2s, num: 1458, concurrency: 760}		19.2 KB	N/A
20:53:56 [2021-06-07T20:53:56.028Z]       │   ├─IndexRangeScan_78(Build)	4.05	17316468	cop[tikv]	table:l2, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:52s, loops:18614, cop_task: {num: 2987, max: 706.3ms, min: 708.1µs, avg: 176.3ms, p95: 358.9ms, max_proc_keys: 13368, p95_proc_keys: 8741, tot_proc: 6m34.6s, tot_wait: 1m51.4s, rpc_num: 2987, rpc_time: 8m46.4s, copr_cache: disabled}, tikv_task:{proc max:176ms, min:0s, p80:93ms, p95:107ms, iters:30066, tasks:2987}, scan_detail: {total_process_keys: 17316468, total_keys: 20812574, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17316468, block: {cache_hit_count: 24259990, read_count: 225679, read_byte: 2.00 GB}}}	range: decided by [eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey)], keep order:false	N/A	N/A
20:53:56 [2021-06-07T20:53:56.028Z]       │   └─TableRowIDScan_79(Probe)	4.05	17316468	cop[tikv]	table:l2	time:5m58.7s, loops:20982, cop_task: {num: 7800, max: 618.3ms, min: 532.3µs, avg: 168.2ms, p95: 346.7ms, max_proc_keys: 11690, p95_proc_keys: 4877, tot_proc: 15m42.5s, tot_wait: 5m20.7s, rpc_num: 7800, rpc_time: 21m51.5s, copr_cache: disabled}, tikv_task:{proc max:269ms, min:0s, p80:102ms, p95:137ms, iters:49890, tasks:7800}, scan_detail: {total_process_keys: 17316468, total_keys: 18289181, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5626963, block: {cache_hit_count: 99020362, read_count: 1110, read_byte: 391.4 MB}}}	keep order:false	N/A	N/A
20:53:56 [2021-06-07T20:53:56.028Z]       └─IndexLookUp_39(Probe)	4.05	12022810	root		time:1m48.3s, loops:11946, index_task: {total_time: 58.3s, fetch_handle: 48.2s, build: 3.42ms, wait: 10.1s}, table_task: {total_time: 7m49.1s, num: 1408, concurrency: 730}		272.4 KB	N/A
20:53:56 [2021-06-07T20:53:56.028Z]         ├─IndexRangeScan_36(Build)	5.06	17183412	cop[tikv]	table:l3, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:45.9s, loops:18370, cop_task: {num: 2759, max: 725.5ms, min: 520.6µs, avg: 163.9ms, p95: 353.2ms, max_proc_keys: 17740, p95_proc_keys: 13834, tot_proc: 5m36.3s, tot_wait: 1m36.7s, rpc_num: 2759, rpc_time: 7m32s, copr_cache: disabled}, tikv_task:{proc max:172ms, min:0s, p80:76ms, p95:117ms, iters:28989, tasks:2759}, scan_detail: {total_process_keys: 17183412, total_keys: 20546444, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17183412, block: {cache_hit_count: 23554030, read_count: 0, read_byte: 0 Bytes}}}	range: decided by [eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey)], keep order:false	N/A	N/A
20:53:56 [2021-06-07T20:53:56.028Z]         └─Selection_38(Probe)	4.05	12022810	cop[tikv]		time:6m1.4s, loops:13760, cop_task: {num: 10312, max: 657.1ms, min: 513.5µs, avg: 167.4ms, p95: 341ms, max_proc_keys: 8957, p95_proc_keys: 3928, tot_proc: 20m4.9s, tot_wait: 7m36s, rpc_num: 10312, rpc_time: 28m45.7s, copr_cache: disabled}, tikv_task:{proc max:232ms, min:0s, p80:74ms, p95:113ms, iters:61024, tasks:10312}, scan_detail: {total_process_keys: 17183412, total_keys: 18129382, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5526674, block: {cache_hit_count: 98291267, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:53:56 [2021-06-07T20:53:56.028Z]           └─TableRowIDScan_37	5.06	17183412	cop[tikv]	table:l3	tikv_task:{proc max:229ms, min:0s, p80:74ms, p95:112ms, iters:61024, tasks:10312}	keep order:false	N/A	N/A
20:53:56 [2021-06-07T20:53:56.028Z] + tiup cluster stop benchbot -y
20:53:56 [2021-06-07T20:53:56.028Z] Starting component `cluster`: /home/tidb/.tiup/components/cluster/v1.4.4/tiup-cluster stop benchbot -y
20:54:02 [2021-06-07T20:54:02.554Z] + rm -rf '/data1/tidb-deploy/*/log/*'
20:54:02 [2021-06-07T20:54:02.554Z] + rm -rf /data1/jenkins/deploy/data/tikv-20160
20:54:06 [2021-06-07T20:54:06.713Z] + rm -rf /data1/jenkins/deploy/data/pd-2379
20:54:06 [2021-06-07T20:54:06.713Z] + rm -rf /data1/jenkins/restore_data/tpch50/data/last_tikv.toml
20:54:06 [2021-06-07T20:54:06.713Z] + cp -R /data1/jenkins/restore_data/tpch50/data /data1/jenkins/deploy/data/tikv-20160
20:55:43 [2021-06-07T20:55:43.067Z] + cp -R /data1/jenkins/restore_data/tpch50/data.pd /data1/jenkins/deploy/data/pd-2379
20:55:43 [2021-06-07T20:55:43.067Z] + '[' -n '' ']'
20:55:43 [2021-06-07T20:55:43.067Z] + tiup cluster start benchbot --wait-timeout=300
20:55:43 [2021-06-07T20:55:43.067Z] Starting component `cluster`: /home/tidb/.tiup/components/cluster/v1.4.4/tiup-cluster start benchbot --wait-timeout=300
20:56:09 [2021-06-07T20:56:09.600Z] + sync
20:56:09 [2021-06-07T20:56:09.600Z] + /usr/bin/echo 3
20:56:48 [2021-06-07T20:56:48.242Z] + sync
20:56:48 [2021-06-07T20:56:48.242Z] + /usr/bin/echo 3
20:57:20 [2021-06-07T20:57:20.252Z] + sync
20:57:20 [2021-06-07T20:57:20.252Z] + /usr/bin/echo 3
20:57:46 [2021-06-07T20:57:46.734Z] 
20:57:46 [2021-06-07T20:57:46.734Z] queries/22.sql
20:57:46 [2021-06-07T20:57:46.734Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:57:46 [2021-06-07T20:57:46.734Z] Sort_39	1600000.00	4	root		time:25.9s, loops:2	Column#27	9.48 KB	0 Bytes
20:57:46 [2021-06-07T20:57:46.734Z] └─Projection_41	1600000.00	4	root		time:25.9s, loops:5, Concurrency:5	Column#27, Column#28, Column#29	23.7 KB	N/A
20:57:46 [2021-06-07T20:57:46.734Z]   └─HashAgg_42	1600000.00	4	root		time:25.9s, loops:5, partial_worker:{wall_time:25.935975976s, concurrency:5, task_num:180, tot_wait:2m9.631755347s, tot_exec:47.240592ms, tot_time:2m9.679138958s, max:25.935867599s, p95:25.935867599s}, final_worker:{wall_time:25.936015953s, concurrency:5, task_num:20, tot_wait:2m9.679221431s, tot_exec:196.22µs, tot_time:2m9.679426527s, max:25.935904229s, p95:25.935904229s}	group by:Column#33, funcs:count(1)->Column#28, funcs:sum(Column#31)->Column#29, funcs:firstrow(Column#32)->Column#27	857.7 KB	N/A
20:57:46 [2021-06-07T20:57:46.734Z]     └─Projection_51	1600000.00	181704	root		time:25.9s, loops:181, Concurrency:5	tpch50.customer.c_acctbal, substring(tpch50.customer.c_phone, 1, 2)->Column#32, substring(tpch50.customer.c_phone, 1, 2)->Column#33	693.6 KB	N/A
20:57:46 [2021-06-07T20:57:46.734Z]       └─HashJoin_43	1600000.00	181704	root		time:25.9s, loops:181, build_hash_table:{total:24.5s, fetch:1.07s, build:23.4s}, probe:{concurrency:5, total:2m9.7s, max:25.9s, probe:5.84s, fetch:2m3.8s}	anti semi join, equal:[eq(tpch50.customer.c_custkey, tpch50.orders.o_custkey)]	590.2 MB	0 Bytes
20:57:46 [2021-06-07T20:57:46.734Z]         ├─TableReader_49(Build)	75000000.00	75000000	root		time:1.05s, loops:73364, cop_task: {num: 153, max: 1.01s, min: 288.4ms, avg: 620.2ms, p95: 931.9ms, max_proc_keys: 723875, p95_proc_keys: 553332, tot_proc: 1m34s, tot_wait: 36ms, rpc_num: 153, rpc_time: 1m34.9s, copr_cache: disabled}	data:TableFullScan_48	56.0 MB	N/A
20:57:46 [2021-06-07T20:57:46.734Z]         │ └─TableFullScan_48	75000000.00	75000000	cop[tikv]	table:orders	tikv_task:{proc max:991ms, min:279ms, p80:622ms, p95:910ms, iters:73975, tasks:153}, scan_detail: {total_process_keys: 75000000, total_keys: 75000153, rocksdb: {delete_skipped_count: 0, key_skipped_count: 149999847, block: {cache_hit_count: 3012, read_count: 219945, read_byte: 4.30 GB}}}	keep order:false	N/A	N/A
20:57:46 [2021-06-07T20:57:46.734Z]         └─Selection_47(Probe)	2000000.00	545246	root		time:1.32s, loops:534	in(substring(tpch50.customer.c_phone, 1, 2), "20", "40", "22", "30", "39", "42", "21")	94.6 KB	N/A
20:57:46 [2021-06-07T20:57:46.734Z]           └─TableReader_46	2000000.00	3407619	root		time:523.3ms, loops:3319, cop_task: {num: 18, max: 1.04s, min: 390.3ms, avg: 806.2ms, p95: 1.04s, max_proc_keys: 582617, p95_proc_keys: 582617, tot_proc: 14.1s, rpc_num: 18, rpc_time: 14.5s, copr_cache: disabled}	data:Selection_45	192.5 MB	N/A
20:57:46 [2021-06-07T20:57:46.734Z]             └─Selection_45	2000000.00	3407619	cop[tikv]		tikv_task:{proc max:944ms, min:367ms, p80:919ms, p95:944ms, iters:7404, tasks:18}, scan_detail: {total_process_keys: 7500000, total_keys: 7500018, rocksdb: {delete_skipped_count: 0, key_skipped_count: 14999982, block: {cache_hit_count: 28451, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.customer.c_acctbal, 5000.602894)	N/A	N/A
20:57:46 [2021-06-07T20:57:46.734Z]               └─TableFullScan_44	7500000.00	7500000	cop[tikv]	table:customer	tikv_task:{proc max:858ms, min:341ms, p80:835ms, p95:858ms, iters:7404, tasks:18}	keep order:false	N/A	N/A
20:57:46 [2021-06-07T20:57:46.734Z] 
20:57:46 [2021-06-07T20:57:46.734Z] queries/22.sql
20:57:46 [2021-06-07T20:57:46.734Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:57:46 [2021-06-07T20:57:46.734Z] Sort_39	2186432.06	4	root		time:26.9s, loops:2	Column#27	9.48 KB	0 Bytes
20:57:46 [2021-06-07T20:57:46.734Z] └─Projection_41	2186432.06	4	root		time:26.9s, loops:5, Concurrency:5	Column#27, Column#28, Column#29	23.7 KB	N/A
20:57:46 [2021-06-07T20:57:46.735Z]   └─HashAgg_42	2186432.06	4	root		time:26.9s, loops:5, partial_worker:{wall_time:26.936231344s, concurrency:5, task_num:180, tot_wait:2m14.632082131s, tot_exec:48.627947ms, tot_time:2m14.680827704s, max:26.936200517s, p95:26.936200517s}, final_worker:{wall_time:26.936286216s, concurrency:5, task_num:20, tot_wait:2m14.680529454s, tot_exec:167.844µs, tot_time:2m14.680709305s, max:26.936233492s, p95:26.936233492s}	group by:Column#33, funcs:count(1)->Column#28, funcs:sum(Column#31)->Column#29, funcs:firstrow(Column#32)->Column#27	857.7 KB	N/A
20:57:46 [2021-06-07T20:57:46.735Z]     └─Projection_51	2186432.06	181704	root		time:26.9s, loops:181, Concurrency:5	tpch50.customer.c_acctbal, substring(tpch50.customer.c_phone, 1, 2)->Column#32, substring(tpch50.customer.c_phone, 1, 2)->Column#33	693.6 KB	N/A
20:57:46 [2021-06-07T20:57:46.735Z]       └─HashJoin_43	2186432.06	181704	root		time:26.9s, loops:181, build_hash_table:{total:25.6s, fetch:1.04s, build:24.6s}, probe:{concurrency:5, total:2m14.7s, max:26.9s, probe:5.54s, fetch:2m9.1s}	anti semi join, equal:[eq(tpch50.customer.c_custkey, tpch50.orders.o_custkey)]	590.2 MB	0 Bytes
20:57:46 [2021-06-07T20:57:46.735Z]         ├─TableReader_49(Build)	75000000.00	75000000	root		time:1.08s, loops:73364, cop_task: {num: 153, max: 1.14s, min: 241.7ms, avg: 552ms, p95: 933.8ms, max_proc_keys: 723875, p95_proc_keys: 553332, tot_proc: 1m23.7s, tot_wait: 28ms, rpc_num: 153, rpc_time: 1m24.4s, copr_cache: disabled}	data:TableFullScan_48	57.8 MB	N/A
20:57:46 [2021-06-07T20:57:46.735Z]         │ └─TableFullScan_48	75000000.00	75000000	cop[tikv]	table:orders	tikv_task:{proc max:1.12s, min:232ms, p80:578ms, p95:879ms, iters:73975, tasks:153}, scan_detail: {total_process_keys: 75000000, total_keys: 75000153, rocksdb: {delete_skipped_count: 0, key_skipped_count: 149999847, block: {cache_hit_count: 220923, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:57:46 [2021-06-07T20:57:46.735Z]         └─Selection_47(Probe)	2733040.07	545246	root		time:1.51s, loops:534	in(substring(tpch50.customer.c_phone, 1, 2), "20", "40", "22", "30", "39", "42", "21")	94.6 KB	N/A
20:57:46 [2021-06-07T20:57:46.735Z]           └─TableReader_46	2733040.07	3407619	root		time:735.9ms, loops:3319, cop_task: {num: 18, max: 1.32s, min: 542.1ms, avg: 946.2ms, p95: 1.32s, max_proc_keys: 582617, p95_proc_keys: 582617, tot_proc: 16.6s, tot_wait: 1ms, rpc_num: 18, rpc_time: 17s, copr_cache: disabled}	data:Selection_45	192.5 MB	N/A
20:57:46 [2021-06-07T20:57:46.735Z]             └─Selection_45	2733040.07	3407619	cop[tikv]		tikv_task:{proc max:1.23s, min:498ms, p80:1.04s, p95:1.23s, iters:7404, tasks:18}, scan_detail: {total_process_keys: 7500000, total_keys: 7500018, rocksdb: {delete_skipped_count: 0, key_skipped_count: 14999982, block: {cache_hit_count: 28451, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.customer.c_acctbal, 5000.602894)	N/A	N/A
20:57:46 [2021-06-07T20:57:46.735Z]               └─TableFullScan_44	7500000.00	7500000	cop[tikv]	table:customer	tikv_task:{proc max:1.14s, min:457ms, p80:953ms, p95:1.14s, iters:7404, tasks:18}	keep order:false	N/A	N/A
20:57:46 [2021-06-07T20:57:46.735Z] 
20:57:46 [2021-06-07T20:57:46.735Z] queries/22.sql
20:57:46 [2021-06-07T20:57:46.735Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:57:46 [2021-06-07T20:57:46.735Z] Sort_39	2186432.06	4	root		time:26.4s, loops:2	Column#27	9.48 KB	0 Bytes
20:57:46 [2021-06-07T20:57:46.735Z] └─Projection_41	2186432.06	4	root		time:26.4s, loops:5, Concurrency:5	Column#27, Column#28, Column#29	23.7 KB	N/A
20:57:46 [2021-06-07T20:57:46.735Z]   └─HashAgg_42	2186432.06	4	root		time:26.4s, loops:5, partial_worker:{wall_time:26.448865666s, concurrency:5, task_num:180, tot_wait:2m12.193829999s, tot_exec:49.791585ms, tot_time:2m12.243766786s, max:26.448828612s, p95:26.448828612s}, final_worker:{wall_time:26.448878773s, concurrency:5, task_num:20, tot_wait:2m12.244057388s, tot_exec:201.031µs, tot_time:2m12.244266224s, max:26.448864816s, p95:26.448864816s}	group by:Column#33, funcs:count(1)->Column#28, funcs:sum(Column#31)->Column#29, funcs:firstrow(Column#32)->Column#27	857.7 KB	N/A
20:57:46 [2021-06-07T20:57:46.735Z]     └─Projection_51	2186432.06	181704	root		time:26.4s, loops:181, Concurrency:5	tpch50.customer.c_acctbal, substring(tpch50.customer.c_phone, 1, 2)->Column#32, substring(tpch50.customer.c_phone, 1, 2)->Column#33	693.6 KB	N/A
20:57:46 [2021-06-07T20:57:46.735Z]       └─HashJoin_43	2186432.06	181704	root		time:26.4s, loops:181, build_hash_table:{total:25s, fetch:833.3ms, build:24.2s}, probe:{concurrency:5, total:2m12.2s, max:26.4s, probe:5.71s, fetch:2m6.5s}	anti semi join, equal:[eq(tpch50.customer.c_custkey, tpch50.orders.o_custkey)]	590.2 MB	0 Bytes
20:57:46 [2021-06-07T20:57:46.735Z]         ├─TableReader_49(Build)	75000000.00	75000000	root		time:870.9ms, loops:73364, cop_task: {num: 153, max: 980ms, min: 262.3ms, avg: 515.9ms, p95: 837.5ms, max_proc_keys: 723875, p95_proc_keys: 553332, tot_proc: 1m18.2s, tot_wait: 54ms, rpc_num: 153, rpc_time: 1m18.9s, copr_cache: disabled}	data:TableFullScan_48	57.8 MB	N/A
20:57:46 [2021-06-07T20:57:46.735Z]         │ └─TableFullScan_48	75000000.00	75000000	cop[tikv]	table:orders	tikv_task:{proc max:955ms, min:247ms, p80:514ms, p95:810ms, iters:73975, tasks:153}, scan_detail: {total_process_keys: 75000000, total_keys: 75000153, rocksdb: {delete_skipped_count: 0, key_skipped_count: 149999847, block: {cache_hit_count: 220923, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:57:46 [2021-06-07T20:57:46.735Z]         └─Selection_47(Probe)	2733040.07	545246	root		time:1.51s, loops:534	in(substring(tpch50.customer.c_phone, 1, 2), "20", "40", "22", "30", "39", "42", "21")	94.6 KB	N/A
20:57:46 [2021-06-07T20:57:46.735Z]           └─TableReader_46	2733040.07	3407619	root		time:681.8ms, loops:3319, cop_task: {num: 18, max: 1.21s, min: 484.7ms, avg: 812.5ms, p95: 1.21s, max_proc_keys: 582617, p95_proc_keys: 582617, tot_proc: 14.2s, tot_wait: 1ms, rpc_num: 18, rpc_time: 14.6s, copr_cache: disabled}	data:Selection_45	192.5 MB	N/A
20:57:46 [2021-06-07T20:57:46.735Z]             └─Selection_45	2733040.07	3407619	cop[tikv]		tikv_task:{proc max:1.14s, min:460ms, p80:964ms, p95:1.14s, iters:7404, tasks:18}, scan_detail: {total_process_keys: 7500000, total_keys: 7500018, rocksdb: {delete_skipped_count: 0, key_skipped_count: 14999982, block: {cache_hit_count: 28451, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.customer.c_acctbal, 5000.602894)	N/A	N/A
20:57:46 [2021-06-07T20:57:46.735Z]               └─TableFullScan_44	7500000.00	7500000	cop[tikv]	table:customer	tikv_task:{proc max:1.03s, min:414ms, p80:882ms, p95:1.03s, iters:7404, tasks:18}	keep order:false	N/A	N/A
20:57:46 [2021-06-07T20:57:46.735Z] + sync
20:57:46 [2021-06-07T20:57:46.735Z] + /usr/bin/echo 3
20:58:18 [2021-06-07T20:58:18.748Z] + sync
20:58:18 [2021-06-07T20:58:18.748Z] + /usr/bin/echo 3
20:58:45 [2021-06-07T20:58:45.233Z] + sync
20:58:45 [2021-06-07T20:58:45.233Z] + /usr/bin/echo 3
20:59:17 [2021-06-07T20:59:17.243Z] 
20:59:17 [2021-06-07T20:59:17.243Z] queries/22.sql
20:59:17 [2021-06-07T20:59:17.243Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:59:17 [2021-06-07T20:59:17.243Z] Sort_39	2186432.06	4	root		time:25.8s, loops:2	Column#27	9.48 KB	0 Bytes
20:59:17 [2021-06-07T20:59:17.243Z] └─Projection_41	2186432.06	4	root		time:25.8s, loops:5, Concurrency:5	Column#27, Column#28, Column#29	23.7 KB	N/A
20:59:17 [2021-06-07T20:59:17.243Z]   └─HashAgg_42	2186432.06	4	root		time:25.8s, loops:5, partial_worker:{wall_time:25.763302664s, concurrency:5, task_num:180, tot_wait:2m8.761438979s, tot_exec:54.074517ms, tot_time:2m8.815636305s, max:25.763266074s, p95:25.763266074s}, final_worker:{wall_time:25.763338958s, concurrency:5, task_num:20, tot_wait:2m8.816378589s, tot_exec:186.971µs, tot_time:2m8.816572568s, max:25.763321831s, p95:25.763321831s}	group by:Column#33, funcs:count(1)->Column#28, funcs:sum(Column#31)->Column#29, funcs:firstrow(Column#32)->Column#27	857.7 KB	N/A
20:59:17 [2021-06-07T20:59:17.243Z]     └─Projection_51	2186432.06	181704	root		time:25.8s, loops:181, Concurrency:5	tpch50.customer.c_acctbal, substring(tpch50.customer.c_phone, 1, 2)->Column#32, substring(tpch50.customer.c_phone, 1, 2)->Column#33	693.6 KB	N/A
20:59:17 [2021-06-07T20:59:17.243Z]       └─HashJoin_43	2186432.06	181704	root		time:25.8s, loops:181, build_hash_table:{total:24.3s, fetch:769.6ms, build:23.5s}, probe:{concurrency:5, total:2m8.8s, max:25.8s, probe:6.11s, fetch:2m2.7s}	anti semi join, equal:[eq(tpch50.customer.c_custkey, tpch50.orders.o_custkey)]	590.2 MB	0 Bytes
20:59:17 [2021-06-07T20:59:17.243Z]         ├─TableReader_49(Build)	75000000.00	75000000	root		time:804.8ms, loops:73364, cop_task: {num: 153, max: 1.17s, min: 224.1ms, avg: 527.7ms, p95: 817ms, max_proc_keys: 723875, p95_proc_keys: 553332, tot_proc: 1m20s, tot_wait: 43ms, rpc_num: 153, rpc_time: 1m20.7s, copr_cache: disabled}	data:TableFullScan_48	57.8 MB	N/A
20:59:17 [2021-06-07T20:59:17.243Z]         │ └─TableFullScan_48	75000000.00	75000000	cop[tikv]	table:orders	tikv_task:{proc max:1.13s, min:209ms, p80:530ms, p95:795ms, iters:73975, tasks:153}, scan_detail: {total_process_keys: 75000000, total_keys: 75000153, rocksdb: {delete_skipped_count: 0, key_skipped_count: 149999847, block: {cache_hit_count: 220923, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:59:17 [2021-06-07T20:59:17.243Z]         └─Selection_47(Probe)	2733040.07	545246	root		time:1.36s, loops:534	in(substring(tpch50.customer.c_phone, 1, 2), "20", "40", "22", "30", "39", "42", "21")	94.6 KB	N/A
20:59:17 [2021-06-07T20:59:17.243Z]           └─TableReader_46	2733040.07	3407619	root		time:447ms, loops:3319, cop_task: {num: 18, max: 1.18s, min: 322.7ms, avg: 906.4ms, p95: 1.18s, max_proc_keys: 582617, p95_proc_keys: 582617, tot_proc: 15.9s, tot_wait: 6ms, rpc_num: 18, rpc_time: 16.3s, copr_cache: disabled}	data:Selection_45	192.5 MB	N/A
20:59:17 [2021-06-07T20:59:17.244Z]             └─Selection_45	2733040.07	3407619	cop[tikv]		tikv_task:{proc max:1.1s, min:299ms, p80:974ms, p95:1.1s, iters:7404, tasks:18}, scan_detail: {total_process_keys: 7500000, total_keys: 7500018, rocksdb: {delete_skipped_count: 0, key_skipped_count: 14999982, block: {cache_hit_count: 28451, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.customer.c_acctbal, 5000.602894)	N/A	N/A
20:59:17 [2021-06-07T20:59:17.244Z]               └─TableFullScan_44	7500000.00	7500000	cop[tikv]	table:customer	tikv_task:{proc max:1.01s, min:273ms, p80:896ms, p95:1.01s, iters:7404, tasks:18}	keep order:false	N/A	N/A
20:59:17 [2021-06-07T20:59:17.244Z] 
20:59:17 [2021-06-07T20:59:17.244Z] queries/22.sql
20:59:17 [2021-06-07T20:59:17.244Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:59:17 [2021-06-07T20:59:17.244Z] Sort_39	2186432.06	4	root		time:25.2s, loops:2	Column#27	9.48 KB	0 Bytes
20:59:17 [2021-06-07T20:59:17.244Z] └─Projection_41	2186432.06	4	root		time:25.2s, loops:5, Concurrency:5	Column#27, Column#28, Column#29	23.7 KB	N/A
20:59:17 [2021-06-07T20:59:17.244Z]   └─HashAgg_42	2186432.06	4	root		time:25.2s, loops:5, partial_worker:{wall_time:25.153528011s, concurrency:5, task_num:180, tot_wait:2m5.712281446s, tot_exec:53.729899ms, tot_time:2m5.76613083s, max:25.153439491s, p95:25.153439491s}, final_worker:{wall_time:25.153566509s, concurrency:5, task_num:20, tot_wait:2m5.767127323s, tot_exec:219.033µs, tot_time:2m5.767355585s, max:25.153476861s, p95:25.153476861s}	group by:Column#33, funcs:count(1)->Column#28, funcs:sum(Column#31)->Column#29, funcs:firstrow(Column#32)->Column#27	857.7 KB	N/A
20:59:17 [2021-06-07T20:59:17.244Z]     └─Projection_51	2186432.06	181704	root		time:25.2s, loops:181, Concurrency:5	tpch50.customer.c_acctbal, substring(tpch50.customer.c_phone, 1, 2)->Column#32, substring(tpch50.customer.c_phone, 1, 2)->Column#33	693.6 KB	N/A
20:59:17 [2021-06-07T20:59:17.244Z]       └─HashJoin_43	2186432.06	181704	root		time:25.2s, loops:181, build_hash_table:{total:23.8s, fetch:967.4ms, build:22.8s}, probe:{concurrency:5, total:2m5.7s, max:25.2s, probe:5.68s, fetch:2m0.1s}	anti semi join, equal:[eq(tpch50.customer.c_custkey, tpch50.orders.o_custkey)]	590.2 MB	0 Bytes
20:59:17 [2021-06-07T20:59:17.244Z]         ├─TableReader_49(Build)	75000000.00	75000000	root		time:965.9ms, loops:73364, cop_task: {num: 153, max: 955ms, min: 230.3ms, avg: 524.3ms, p95: 893ms, max_proc_keys: 723875, p95_proc_keys: 553332, tot_proc: 1m19.4s, tot_wait: 43ms, rpc_num: 153, rpc_time: 1m20.2s, copr_cache: disabled}	data:TableFullScan_48	54.1 MB	N/A
20:59:17 [2021-06-07T20:59:17.244Z]         │ └─TableFullScan_48	75000000.00	75000000	cop[tikv]	table:orders	tikv_task:{proc max:931ms, min:222ms, p80:513ms, p95:840ms, iters:73975, tasks:153}, scan_detail: {total_process_keys: 75000000, total_keys: 75000153, rocksdb: {delete_skipped_count: 0, key_skipped_count: 149999847, block: {cache_hit_count: 220923, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:59:17 [2021-06-07T20:59:17.244Z]         └─Selection_47(Probe)	2733040.07	545246	root		time:1.46s, loops:534	in(substring(tpch50.customer.c_phone, 1, 2), "20", "40", "22", "30", "39", "42", "21")	94.6 KB	N/A
20:59:17 [2021-06-07T20:59:17.244Z]           └─TableReader_46	2733040.07	3407619	root		time:618.4ms, loops:3319, cop_task: {num: 18, max: 1.16s, min: 472.1ms, avg: 822.2ms, p95: 1.16s, max_proc_keys: 582617, p95_proc_keys: 582617, tot_proc: 14.3s, rpc_num: 18, rpc_time: 14.8s, copr_cache: disabled}	data:Selection_45	192.5 MB	N/A
20:59:17 [2021-06-07T20:59:17.244Z]             └─Selection_45	2733040.07	3407619	cop[tikv]		tikv_task:{proc max:1.09s, min:439ms, p80:1s, p95:1.09s, iters:7404, tasks:18}, scan_detail: {total_process_keys: 7500000, total_keys: 7500018, rocksdb: {delete_skipped_count: 0, key_skipped_count: 14999982, block: {cache_hit_count: 28451, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.customer.c_acctbal, 5000.602894)	N/A	N/A
20:59:17 [2021-06-07T20:59:17.244Z]               └─TableFullScan_44	7500000.00	7500000	cop[tikv]	table:customer	tikv_task:{proc max:1.01s, min:388ms, p80:914ms, p95:1.01s, iters:7404, tasks:18}	keep order:false	N/A	N/A
20:59:17 [2021-06-07T20:59:17.244Z] 
20:59:17 [2021-06-07T20:59:17.244Z] queries/22.sql
20:59:17 [2021-06-07T20:59:17.244Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:59:17 [2021-06-07T20:59:17.244Z] Sort_39	2186432.06	4	root		time:26.3s, loops:2	Column#27	9.48 KB	0 Bytes
20:59:17 [2021-06-07T20:59:17.244Z] └─Projection_41	2186432.06	4	root		time:26.3s, loops:5, Concurrency:5	Column#27, Column#28, Column#29	23.7 KB	N/A
20:59:17 [2021-06-07T20:59:17.244Z]   └─HashAgg_42	2186432.06	4	root		time:26.3s, loops:5, partial_worker:{wall_time:26.323309539s, concurrency:5, task_num:180, tot_wait:2m11.561208732s, tot_exec:53.944465ms, tot_time:2m11.615314003s, max:26.323278355s, p95:26.323278355s}, final_worker:{wall_time:26.32333753s, concurrency:5, task_num:20, tot_wait:2m11.616246421s, tot_exec:244.652µs, tot_time:2m11.616498669s, max:26.323317058s, p95:26.323317058s}	group by:Column#33, funcs:count(1)->Column#28, funcs:sum(Column#31)->Column#29, funcs:firstrow(Column#32)->Column#27	857.7 KB	N/A
20:59:17 [2021-06-07T20:59:17.244Z]     └─Projection_51	2186432.06	181704	root		time:26.3s, loops:181, Concurrency:5	tpch50.customer.c_acctbal, substring(tpch50.customer.c_phone, 1, 2)->Column#32, substring(tpch50.customer.c_phone, 1, 2)->Column#33	693.6 KB	N/A
20:59:17 [2021-06-07T20:59:17.244Z]       └─HashJoin_43	2186432.06	181704	root		time:26.3s, loops:181, build_hash_table:{total:24.9s, fetch:1.02s, build:23.9s}, probe:{concurrency:5, total:2m11.6s, max:26.3s, probe:5.78s, fetch:2m5.8s}	anti semi join, equal:[eq(tpch50.customer.c_custkey, tpch50.orders.o_custkey)]	590.2 MB	0 Bytes
20:59:17 [2021-06-07T20:59:17.244Z]         ├─TableReader_49(Build)	75000000.00	75000000	root		time:1.03s, loops:73364, cop_task: {num: 153, max: 1.07s, min: 230.4ms, avg: 543.7ms, p95: 930.5ms, max_proc_keys: 723875, p95_proc_keys: 553332, tot_proc: 1m22.4s, tot_wait: 35ms, rpc_num: 153, rpc_time: 1m23.2s, copr_cache: disabled}	data:TableFullScan_48	57.8 MB	N/A
20:59:17 [2021-06-07T20:59:17.244Z]         │ └─TableFullScan_48	75000000.00	75000000	cop[tikv]	table:orders	tikv_task:{proc max:1.04s, min:212ms, p80:545ms, p95:910ms, iters:73975, tasks:153}, scan_detail: {total_process_keys: 75000000, total_keys: 75000153, rocksdb: {delete_skipped_count: 0, key_skipped_count: 149999847, block: {cache_hit_count: 220923, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:59:17 [2021-06-07T20:59:17.244Z]         └─Selection_47(Probe)	2733040.07	545246	root		time:1.47s, loops:534	in(substring(tpch50.customer.c_phone, 1, 2), "20", "40", "22", "30", "39", "42", "21")	94.6 KB	N/A
20:59:17 [2021-06-07T20:59:17.244Z]           └─TableReader_46	2733040.07	3407619	root		time:632.9ms, loops:3319, cop_task: {num: 18, max: 1.26s, min: 426.1ms, avg: 894.3ms, p95: 1.26s, max_proc_keys: 582617, p95_proc_keys: 582617, tot_proc: 15.7s, tot_wait: 2ms, rpc_num: 18, rpc_time: 16.1s, copr_cache: disabled}	data:Selection_45	192.5 MB	N/A
20:59:17 [2021-06-07T20:59:17.244Z]             └─Selection_45	2733040.07	3407619	cop[tikv]		tikv_task:{proc max:1.18s, min:401ms, p80:1.09s, p95:1.18s, iters:7404, tasks:18}, scan_detail: {total_process_keys: 7500000, total_keys: 7500018, rocksdb: {delete_skipped_count: 0, key_skipped_count: 14999982, block: {cache_hit_count: 28451, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.customer.c_acctbal, 5000.602894)	N/A	N/A
20:59:17 [2021-06-07T20:59:17.244Z]               └─TableFullScan_44	7500000.00	7500000	cop[tikv]	table:customer	tikv_task:{proc max:1.11s, min:372ms, p80:1.01s, p95:1.11s, iters:7404, tasks:18}	keep order:false	N/A	N/A
20:59:17 [2021-06-07T20:59:17.244Z] + sync
20:59:17 [2021-06-07T20:59:17.244Z] + /usr/bin/echo 3
20:59:49 [2021-06-07T20:59:49.252Z] 
20:59:49 [2021-06-07T20:59:49.252Z] queries/22.sql
20:59:49 [2021-06-07T20:59:49.252Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:59:49 [2021-06-07T20:59:49.252Z] Sort_39	2186432.06	4	root		time:26s, loops:2	Column#27	9.48 KB	0 Bytes
20:59:49 [2021-06-07T20:59:49.252Z] └─Projection_41	2186432.06	4	root		time:26s, loops:5, Concurrency:5	Column#27, Column#28, Column#29	23.7 KB	N/A
20:59:49 [2021-06-07T20:59:49.252Z]   └─HashAgg_42	2186432.06	4	root		time:26s, loops:5, partial_worker:{wall_time:25.958318322s, concurrency:5, task_num:180, tot_wait:2m9.731448006s, tot_exec:58.931893ms, tot_time:2m9.790476787s, max:25.958232191s, p95:25.958232191s}, final_worker:{wall_time:25.958331293s, concurrency:5, task_num:20, tot_wait:2m9.791087613s, tot_exec:169.719µs, tot_time:2m9.791263731s, max:25.95826639s, p95:25.95826639s}	group by:Column#33, funcs:count(1)->Column#28, funcs:sum(Column#31)->Column#29, funcs:firstrow(Column#32)->Column#27	857.7 KB	N/A
20:59:49 [2021-06-07T20:59:49.252Z]     └─Projection_51	2186432.06	181704	root		time:26s, loops:181, Concurrency:5	tpch50.customer.c_acctbal, substring(tpch50.customer.c_phone, 1, 2)->Column#32, substring(tpch50.customer.c_phone, 1, 2)->Column#33	693.6 KB	N/A
20:59:49 [2021-06-07T20:59:49.252Z]       └─HashJoin_43	2186432.06	181704	root		time:26s, loops:181, build_hash_table:{total:24.5s, fetch:1s, build:23.5s}, probe:{concurrency:5, total:2m9.8s, max:26s, probe:5.82s, fetch:2m4s}	anti semi join, equal:[eq(tpch50.customer.c_custkey, tpch50.orders.o_custkey)]	590.2 MB	0 Bytes
20:59:49 [2021-06-07T20:59:49.252Z]         ├─TableReader_49(Build)	75000000.00	75000000	root		time:1.04s, loops:73364, cop_task: {num: 153, max: 1.02s, min: 273.5ms, avg: 526.9ms, p95: 866.7ms, max_proc_keys: 723875, p95_proc_keys: 553332, tot_proc: 1m19.9s, tot_wait: 35ms, rpc_num: 153, rpc_time: 1m20.6s, copr_cache: disabled}	data:TableFullScan_48	54.1 MB	N/A
20:59:49 [2021-06-07T20:59:49.252Z]         │ └─TableFullScan_48	75000000.00	75000000	cop[tikv]	table:orders	tikv_task:{proc max:999ms, min:260ms, p80:550ms, p95:839ms, iters:73975, tasks:153}, scan_detail: {total_process_keys: 75000000, total_keys: 75000153, rocksdb: {delete_skipped_count: 0, key_skipped_count: 149999847, block: {cache_hit_count: 220923, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:59:49 [2021-06-07T20:59:49.252Z]         └─Selection_47(Probe)	2733040.07	545246	root		time:1.63s, loops:534	in(substring(tpch50.customer.c_phone, 1, 2), "20", "40", "22", "30", "39", "42", "21")	94.6 KB	N/A
20:59:49 [2021-06-07T20:59:49.252Z]           └─TableReader_46	2733040.07	3407619	root		time:705.7ms, loops:3319, cop_task: {num: 18, max: 1.2s, min: 569.7ms, avg: 924ms, p95: 1.2s, max_proc_keys: 582617, p95_proc_keys: 582617, tot_proc: 16.2s, tot_wait: 1ms, rpc_num: 18, rpc_time: 16.6s, copr_cache: disabled}	data:Selection_45	192.5 MB	N/A
20:59:49 [2021-06-07T20:59:49.252Z]             └─Selection_45	2733040.07	3407619	cop[tikv]		tikv_task:{proc max:1.14s, min:535ms, p80:1s, p95:1.14s, iters:7404, tasks:18}, scan_detail: {total_process_keys: 7500000, total_keys: 7500018, rocksdb: {delete_skipped_count: 0, key_skipped_count: 14999982, block: {cache_hit_count: 28451, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.customer.c_acctbal, 5000.602894)	N/A	N/A
20:59:49 [2021-06-07T20:59:49.252Z]               └─TableFullScan_44	7500000.00	7500000	cop[tikv]	table:customer	tikv_task:{proc max:1.06s, min:484ms, p80:934ms, p95:1.06s, iters:7404, tasks:18}	keep order:false	N/A	N/A
20:59:49 [2021-06-07T20:59:49.252Z] 
20:59:49 [2021-06-07T20:59:49.252Z] + tiup cluster stop benchbot
20:59:49 [2021-06-07T20:59:49.252Z] Starting component `cluster`: /home/tidb/.tiup/components/cluster/v1.4.4/tiup-cluster stop benchbot
20:59:49 [2021-06-07T20:59:49.252Z] + [ Serial ] - SSHKeySet: privateKey=/home/tidb/.tiup/storage/cluster/clusters/benchbot/ssh/id_rsa, publicKey=/home/tidb/.tiup/storage/cluster/clusters/benchbot/ssh/id_rsa.pub
20:59:49 [2021-06-07T20:59:49.252Z] + [Parallel] - UserSSH: user=tidb, host=172.16.5.86
20:59:49 [2021-06-07T20:59:49.252Z] + [Parallel] - UserSSH: user=tidb, host=172.16.5.86
20:59:49 [2021-06-07T20:59:49.252Z] + [Parallel] - UserSSH: user=tidb, host=172.16.5.86
20:59:49 [2021-06-07T20:59:49.252Z] + [Parallel] - UserSSH: user=tidb, host=172.16.5.86
20:59:49 [2021-06-07T20:59:49.252Z] + [Parallel] - UserSSH: user=tidb, host=172.16.5.86
20:59:49 [2021-06-07T20:59:49.252Z] + [ Serial ] - StopCluster
20:59:49 [2021-06-07T20:59:49.252Z] Stopping component grafana
20:59:49 [2021-06-07T20:59:49.252Z] 	Stopping instance 172.16.5.86
20:59:49 [2021-06-07T20:59:49.252Z] 	Stop grafana 172.16.5.86:3000 success
20:59:49 [2021-06-07T20:59:49.252Z] Stopping component prometheus
20:59:49 [2021-06-07T20:59:49.252Z] 	Stopping instance 172.16.5.86
20:59:49 [2021-06-07T20:59:49.252Z] 	Stop prometheus 172.16.5.86:9090 success
20:59:49 [2021-06-07T20:59:49.252Z] Stopping component tidb
20:59:49 [2021-06-07T20:59:49.252Z] 	Stopping instance 172.16.5.86
20:59:52 [2021-06-07T20:59:52.512Z] 	Stop tidb 172.16.5.86:4000 success
20:59:52 [2021-06-07T20:59:52.512Z] Stopping component tikv
20:59:52 [2021-06-07T20:59:52.512Z] 	Stopping instance 172.16.5.86
20:59:56 [2021-06-07T20:59:56.670Z] 	Stop tikv 172.16.5.86:20160 success
20:59:56 [2021-06-07T20:59:56.670Z] Stopping component pd
20:59:56 [2021-06-07T20:59:56.670Z] 	Stopping instance 172.16.5.86
20:59:56 [2021-06-07T20:59:56.670Z] 	Stop pd 172.16.5.86:2379 success
20:59:56 [2021-06-07T20:59:56.670Z] Stopping component node_exporter
20:59:56 [2021-06-07T20:59:56.671Z] Stopping component blackbox_exporter
20:59:56 [2021-06-07T20:59:56.671Z] Stopped cluster `benchbot` successfully
20:59:56 [2021-06-07T20:59:56.933Z] [Pipeline] sh
20:59:57 [2021-06-07T20:59:57.212Z] + cat bench_result
20:59:57 [2021-06-07T20:59:57.218Z] [Pipeline] }
20:59:57 [2021-06-07T20:59:57.219Z] [Pipeline] // dir
20:59:57 [2021-06-07T20:59:57.221Z] [Pipeline] }
20:59:57 [2021-06-07T20:59:57.222Z] [Pipeline] // stage
20:59:57 [2021-06-07T20:59:57.223Z] [Pipeline] }
20:59:57 [2021-06-07T20:59:57.225Z] [Pipeline] // node
20:59:57 [2021-06-07T20:59:57.229Z] [Pipeline] }
20:59:57 [2021-06-07T20:59:57.231Z] [Pipeline] // catchError
20:59:57 [2021-06-07T20:59:57.236Z] [Pipeline] stage
20:59:57 [2021-06-07T20:59:57.242Z] [Pipeline] { (Summary)
20:59:57 [2021-06-07T20:59:57.276Z] sh: line 1: 147639 Terminated              sleep 3
20:59:57 [2021-06-07T20:59:57.256Z] [Pipeline] slackSend
20:59:57 [2021-06-07T20:59:57.257Z] Slack Send Pipeline step running, values are - baseUrl: <empty>, teamDomain: pingcap, channel: #daily_bench, color: good, botUser: false, tokenCredentialId: slack-pingcap-token, iconEmoji <empty>, username <empty>
20:59:57 [2021-06-07T20:59:57.922Z] [Pipeline] }
20:59:57 [2021-06-07T20:59:57.923Z] [Pipeline] // stage
20:59:57 [2021-06-07T20:59:57.925Z] [Pipeline] End of Pipeline
20:59:57 [2021-06-07T20:59:57.944Z] Finished: SUCCESS