SuccessConsole Output

Skipping 1,193 KB.. Full Log
44	194.5 MB	N/A
20:37:41 [2021-06-04T20:37:41.405Z]         └─HashJoin_59	9711455.06	634004	root		time:43.4s, loops:626, build_hash_table:{total:3.56s, fetch:3.35s, build:210.7ms}, probe:{concurrency:5, total:3m37.1s, max:43.4s, probe:14.4s, fetch:3m22.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:37:41 [2021-06-04T20:37:41.405Z]           ├─IndexHashJoin_67(Build)	321865.05	435528	root		time:3.54s, loops:430, inner:{total:3.64s, concurrency:5, task:12, construct:136.5ms, fetch:3.15s, build:26.8ms, join:351.5ms}	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:37:41 [2021-06-04T20:37:41.405Z]           │ ├─TableReader_96(Build)	80007.93	108882	root		time:3.08s, loops:112, cop_task: {num: 20, max: 1.93s, min: 701ms, avg: 1.39s, p95: 1.93s, max_proc_keys: 686055, p95_proc_keys: 686055, tot_proc: 27.7s, tot_wait: 14ms, rpc_num: 20, rpc_time: 27.7s, copr_cache: disabled}	data:Selection_95	660.2 KB	N/A
20:37:41 [2021-06-04T20:37:41.405Z]           │ │ └─Selection_95	80007.93	108882	cop[tikv]		tikv_task:{proc max:1.89s, min:696ms, p80:1.64s, p95:1.89s, 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:37:41 [2021-06-04T20:37:41.405Z]           │ │   └─TableFullScan_94	10000000.00	10000000	cop[tikv]	table:part	tikv_task:{proc max:1.78s, min:650ms, p80:1.52s, p95:1.78s, iters:9859, tasks:20}	keep order:false	N/A	N/A
20:37:41 [2021-06-04T20:37:41.405Z]           │ └─IndexLookUp_64(Probe)	4.02	435528	root		time:3.05s, loops:447, index_task: {total_time: 1.89s, fetch_handle: 1.89s, build: 85.9µs, wait: 263.5µs}, table_task: {total_time: 11.8s, num: 55, concurrency: 60}		20.7 KB	N/A
20:37:41 [2021-06-04T20:37:41.405Z]           │   ├─IndexRangeScan_62(Build)	4.02	435528	cop[tikv]	table:partsupp, index:PRIMARY(PS_PARTKEY, PS_SUPPKEY)	time:1.84s, loops:477, cop_task: {num: 58, max: 331.8ms, min: 5.95ms, avg: 131.8ms, p95: 320.1ms, max_proc_keys: 15288, p95_proc_keys: 15008, tot_proc: 7.03s, tot_wait: 72ms, rpc_num: 58, rpc_time: 7.64s, copr_cache: disabled}, tikv_task:{proc max:305ms, min:5ms, p80:176ms, p95:302ms, iters:687, 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:37:41 [2021-06-04T20:37:41.405Z]           │   └─TableRowIDScan_63(Probe)	4.02	435528	cop[tikv]	table:partsupp	time:4.14s, loops:502, cop_task: {num: 1382, max: 119.5ms, min: 512.4µs, avg: 31.3ms, p95: 68ms, max_proc_keys: 972, p95_proc_keys: 632, tot_proc: 31s, tot_wait: 9.39s, rpc_num: 1382, rpc_time: 43.2s, copr_cache: disabled}, tikv_task:{proc max:92ms, min:0s, p80:25ms, p95:41ms, iters:5187, tasks:1382}, scan_detail: {total_process_keys: 435528, total_keys: 473505, rocksdb: {delete_skipped_count: 0, key_skipped_count: 194047, block: {cache_hit_count: 3643978, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:37:41 [2021-06-04T20:37:41.405Z]           └─TableReader_101(Probe)	46310896.67	45504356	root		time:38s, loops:44289, cop_task: {num: 761, max: 1.47s, min: 403.9ms, avg: 800ms, p95: 1.07s, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 10m5.4s, tot_wait: 128ms, rpc_num: 761, rpc_time: 10m8.8s, copr_cache: disabled}	data:Selection_100	52.6 MB	N/A
20:37:41 [2021-06-04T20:37:41.406Z]             └─Selection_100	46310896.67	45504356	cop[tikv]		tikv_task:{proc max:1.44s, min:393ms, p80:860ms, p95:1.05s, 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:37:41 [2021-06-04T20:37:41.406Z]               └─TableFullScan_99	300005811.00	300005811	cop[tikv]	table:lineitem	tikv_task:{proc max:1.38s, min:377ms, p80:823ms, p95:1.02s, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:37:41 [2021-06-04T20:37:41.406Z] + sync
20:37:41 [2021-06-04T20:37:41.406Z] + /usr/bin/echo 3
20:38:28 [2021-06-04T20:38:28.018Z] + sync
20:38:28 [2021-06-04T20:38:28.018Z] + /usr/bin/echo 3
20:39:06 [2021-06-04T20:39:06.726Z] 
20:39:06 [2021-06-04T20:39:06.726Z] queries/20.sql
20:39:06 [2021-06-04T20:39:06.726Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:39:06 [2021-06-04T20:39:06.726Z] Sort_30	20000.00	8982	root		time:42s, loops:10	tpch50.supplier.s_name	620.9 KB	0 Bytes
20:39:06 [2021-06-04T20:39:06.726Z] └─HashJoin_35	20000.00	8982	root		time:42s, loops:11, build_hash_table:{total:1.52s, fetch:1.51s, build:8.38ms}, probe:{concurrency:5, total:3m30.2s, max:42s, probe:48.8ms, fetch:3m30.1s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.partsupp.ps_suppkey)]	1.43 MB	0 Bytes
20:39:06 [2021-06-04T20:39:06.726Z]   ├─HashJoin_48(Build)	20000.00	19972	root		time:1.52s, loops:21, build_hash_table:{total:185.8µs, fetch:178.5µs, build:7.36µs}, probe:{concurrency:5, total:7.6s, max:1.52s, probe:92.5ms, fetch:7.5s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:39:06 [2021-06-04T20:39:06.726Z]   │ ├─TableReader_53(Build)	1.00	1	root		time:45.9µs, loops:2, cop_task: {num: 1, max: 1.01ms, proc_keys: 25, rpc_num: 1, rpc_time: 968.1µs, copr_cache: disabled}	data:Selection_52	240 Bytes	N/A
20:39:06 [2021-06-04T20:39:06.726Z]   │ │ └─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:06 [2021-06-04T20:39:06.726Z]   │ │   └─TableFullScan_51	25.00	25	cop[tikv]	table:nation	tikv_task:{time:0s, loops:1}	keep order:false	N/A	N/A
20:39:06 [2021-06-04T20:39:06.726Z]   │ └─TableReader_50(Probe)	500000.00	500000	root		time:1.5s, loops:490, cop_task: {num: 1, max: 1.5s, proc_keys: 500000, tot_proc: 1.43s, rpc_num: 1, rpc_time: 1.5s, copr_cache: disabled}	data:TableFullScan_49	35.8 MB	N/A
20:39:06 [2021-06-04T20:39:06.726Z]   │   └─TableFullScan_49	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:1.27s, 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:06 [2021-06-04T20:39:06.726Z]   └─HashAgg_54(Probe)	257492.04	223999	root		time:42s, loops:222, partial_worker:{wall_time:41.921740309s, concurrency:5, task_num:289, tot_wait:3m29.353467994s, tot_exec:211.537165ms, tot_time:3m29.600640463s, max:41.921704838s, p95:41.921704838s}, final_worker:{wall_time:42.032204333s, concurrency:5, task_num:25, tot_wait:3m29.597244822s, tot_exec:537.43758ms, tot_time:3m30.134700543s, max:42.032154477s, p95:42.032154477s}	group by:tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_suppkey)->tpch50.partsupp.ps_suppkey	61.4 MB	N/A
20:39:06 [2021-06-04T20:39:06.726Z]     └─Selection_55	257492.04	295898	root		time:41.9s, loops:290	gt(cast(tpch50.partsupp.ps_availqty, decimal(20,0) BINARY), mul(0.5, Column#44))	59.2 KB	N/A
20:39:06 [2021-06-04T20:39:06.726Z]       └─HashAgg_56	321865.05	435528	root		time:41.8s, loops:430, partial_worker:{wall_time:41.556011744s, concurrency:5, task_num:622, tot_wait:3m26.595945704s, tot_exec:1.047588537s, tot_time:3m27.761626267s, max:41.555951001s, p95:41.555951001s}, final_worker:{wall_time:41.911777444s, concurrency:5, task_num:25, tot_wait:3m27.750421268s, tot_exec:1.762054505s, tot_time:3m29.512493061s, max:41.911733665s, p95:41.911733665s}	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:06 [2021-06-04T20:39:06.726Z]         └─HashJoin_59	9711455.06	634004	root		time:41.5s, loops:623, build_hash_table:{total:2.84s, fetch:2.62s, build:217.1ms}, probe:{concurrency:5, total:3m27.4s, max:41.5s, probe:14.6s, fetch:3m12.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:06 [2021-06-04T20:39:06.726Z]           ├─IndexHashJoin_67(Build)	321865.05	435528	root		time:2.81s, loops:429, inner:{total:3.26s, concurrency:5, task:12, construct:121.5ms, fetch:2.78s, build:24.3ms, join:353.3ms}	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:06 [2021-06-04T20:39:06.726Z]           │ ├─TableReader_96(Build)	80007.93	108882	root		time:2.38s, loops:112, cop_task: {num: 20, max: 1.73s, min: 537.3ms, avg: 1.25s, p95: 1.73s, max_proc_keys: 686055, p95_proc_keys: 686055, tot_proc: 25s, tot_wait: 13ms, rpc_num: 20, rpc_time: 25s, copr_cache: disabled}	data:Selection_95	665.9 KB	N/A
20:39:06 [2021-06-04T20:39:06.726Z]           │ │ └─Selection_95	80007.93	108882	cop[tikv]		tikv_task:{proc max:1.71s, min:532ms, p80:1.43s, p95:1.71s, 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:06 [2021-06-04T20:39:06.726Z]           │ │   └─TableFullScan_94	10000000.00	10000000	cop[tikv]	table:part	tikv_task:{proc max:1.62s, min:500ms, p80:1.34s, p95:1.62s, iters:9859, tasks:20}	keep order:false	N/A	N/A
20:39:06 [2021-06-04T20:39:06.726Z]           │ └─IndexLookUp_64(Probe)	4.02	435528	root		time:2.67s, loops:447, index_task: {total_time: 1.47s, fetch_handle: 1.47s, build: 108.6µs, wait: 289.4µs}, table_task: {total_time: 10.5s, num: 56, concurrency: 60}		20.5 KB	N/A
20:39:06 [2021-06-04T20:39:06.726Z]           │   ├─IndexRangeScan_62(Build)	4.02	435528	cop[tikv]	table:partsupp, index:PRIMARY(PS_PARTKEY, PS_SUPPKEY)	time:1.43s, loops:478, cop_task: {num: 60, max: 308ms, min: 5.06ms, avg: 108.9ms, p95: 230.6ms, max_proc_keys: 15288, p95_proc_keys: 15008, tot_proc: 6.06s, tot_wait: 26ms, rpc_num: 60, rpc_time: 6.53s, copr_cache: disabled}, tikv_task:{proc max:294ms, min:4ms, p80:161ms, p95:220ms, iters:697, 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:39:06 [2021-06-04T20:39:06.726Z]           │   └─TableRowIDScan_63(Probe)	4.02	435528	cop[tikv]	table:partsupp	time:4.27s, loops:507, cop_task: {num: 1446, max: 121.8ms, min: 803.2µs, avg: 30.9ms, p95: 68.9ms, max_proc_keys: 924, p95_proc_keys: 556, tot_proc: 30.6s, tot_wait: 11.7s, rpc_num: 1446, rpc_time: 44.7s, copr_cache: disabled}, tikv_task:{proc max:63ms, min:0s, p80:23ms, p95:35ms, iters:5346, tasks:1446}, scan_detail: {total_process_keys: 435528, total_keys: 473482, rocksdb: {delete_skipped_count: 0, key_skipped_count: 193986, block: {cache_hit_count: 3644384, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:39:06 [2021-06-04T20:39:06.726Z]           └─TableReader_101(Probe)	46310896.67	45504356	root		time:36.7s, loops:44290, cop_task: {num: 761, max: 1.43s, min: 387.3ms, avg: 771.5ms, p95: 1.08s, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 9m43.7s, tot_wait: 118ms, rpc_num: 761, rpc_time: 9m47.1s, copr_cache: disabled}	data:Selection_100	52.6 MB	N/A
20:39:06 [2021-06-04T20:39:06.726Z]             └─Selection_100	46310896.67	45504356	cop[tikv]		tikv_task:{proc max:1.35s, min:375ms, p80:832ms, p95:1.06s, 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:06 [2021-06-04T20:39:06.726Z]               └─TableFullScan_99	300005811.00	300005811	cop[tikv]	table:lineitem	tikv_task:{proc max:1.29s, min:352ms, p80:796ms, p95:1.02s, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:39:06 [2021-06-04T20:39:06.726Z] 
20:39:06 [2021-06-04T20:39:06.726Z] queries/20.sql
20:39:06 [2021-06-04T20:39:06.726Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:39:06 [2021-06-04T20:39:06.726Z] Sort_30	20000.00	8982	root		time:38.2s, loops:10	tpch50.supplier.s_name	607.7 KB	0 Bytes
20:39:06 [2021-06-04T20:39:06.726Z] └─HashJoin_35	20000.00	8982	root		time:38.2s, loops:11, build_hash_table:{total:1.49s, fetch:1.48s, build:9.6ms}, probe:{concurrency:5, total:3m11s, max:38.2s, probe:50.4ms, fetch:3m11s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.partsupp.ps_suppkey)]	1.51 MB	0 Bytes
20:39:06 [2021-06-04T20:39:06.726Z]   ├─HashJoin_48(Build)	20000.00	19972	root		time:1.48s, loops:23, build_hash_table:{total:142.3µs, fetch:136.9µs, build:5.32µs}, probe:{concurrency:5, total:7.43s, max:1.49s, probe:109.3ms, fetch:7.32s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:39:06 [2021-06-04T20:39:06.726Z]   │ ├─TableReader_53(Build)	1.00	1	root		time:36.6µs, loops:2, cop_task: {num: 1, max: 1.08ms, proc_keys: 25, rpc_num: 1, rpc_time: 1.06ms, copr_cache: disabled}	data:Selection_52	236 Bytes	N/A
20:39:06 [2021-06-04T20:39:06.726Z]   │ │ └─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:06 [2021-06-04T20:39:06.726Z]   │ │   └─TableFullScan_51	25.00	25	cop[tikv]	table:nation	tikv_task:{time:0s, loops:1}	keep order:false	N/A	N/A
20:39:06 [2021-06-04T20:39:06.726Z]   │ └─TableReader_50(Probe)	500000.00	500000	root		time:1.47s, loops:490, cop_task: {num: 1, max: 1.47s, proc_keys: 500000, tot_proc: 1.39s, rpc_num: 1, rpc_time: 1.47s, copr_cache: disabled}	data:TableFullScan_49	35.8 MB	N/A
20:39:06 [2021-06-04T20:39:06.726Z]   │   └─TableFullScan_49	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:1.27s, 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:06 [2021-06-04T20:39:06.726Z]   └─HashAgg_54(Probe)	257492.04	223999	root		time:38.2s, loops:222, partial_worker:{wall_time:38.079228916s, concurrency:5, task_num:289, tot_wait:3m10.146744437s, tot_exec:205.311836ms, tot_time:3m10.389912004s, max:38.079140941s, p95:38.079140941s}, final_worker:{wall_time:38.200594272s, concurrency:5, task_num:25, tot_wait:3m10.385969934s, tot_exec:606.221136ms, tot_time:3m10.992205792s, max:38.200521144s, p95:38.200521144s}	group by:tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_suppkey)->tpch50.partsupp.ps_suppkey	61.4 MB	N/A
20:39:06 [2021-06-04T20:39:06.726Z]     └─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:39:06 [2021-06-04T20:39:06.726Z]       └─HashAgg_56	321865.05	435528	root		time:38s, loops:430, partial_worker:{wall_time:37.711618061s, concurrency:5, task_num:623, tot_wait:3m7.386255227s, tot_exec:1.044346156s, tot_time:3m8.550036127s, max:37.711476446s, p95:37.711476446s}, final_worker:{wall_time:38.069680659s, concurrency:5, task_num:25, tot_wait:3m8.535812475s, tot_exec:1.755993891s, tot_time:3m10.291824419s, max:38.069544395s, p95:38.069544395s}	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:06 [2021-06-04T20:39:06.726Z]         └─HashJoin_59	9711455.06	634004	root		time:37.6s, loops:624, build_hash_table:{total:2.62s, fetch:2.39s, build:236ms}, probe:{concurrency:5, total:3m8.2s, max:37.6s, probe:14.7s, fetch:2m53.5s}	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:06 [2021-06-04T20:39:06.726Z]           ├─IndexHashJoin_67(Build)	321865.05	435528	root		time:2.55s, loops:430, inner:{total:2.82s, concurrency:5, task:12, construct:124ms, fetch:2.35s, build:27.4ms, join:348.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)	20.0 MB	N/A
20:39:06 [2021-06-04T20:39:06.726Z]           │ ├─TableReader_96(Build)	80007.93	108882	root		time:2.23s, loops:112, cop_task: {num: 20, max: 1.56s, min: 651.6ms, avg: 1.16s, p95: 1.56s, max_proc_keys: 686055, p95_proc_keys: 686055, tot_proc: 23.2s, tot_wait: 20ms, rpc_num: 20, rpc_time: 23.2s, copr_cache: disabled}	data:Selection_95	725.8 KB	N/A
20:39:06 [2021-06-04T20:39:06.726Z]           │ │ └─Selection_95	80007.93	108882	cop[tikv]		tikv_task:{proc max:1.53s, min:645ms, p80:1.33s, p95:1.53s, 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:06 [2021-06-04T20:39:06.726Z]           │ │   └─TableFullScan_94	10000000.00	10000000	cop[tikv]	table:part	tikv_task:{proc max:1.42s, min:597ms, p80:1.23s, p95:1.42s, iters:9859, tasks:20}	keep order:false	N/A	N/A
20:39:06 [2021-06-04T20:39:06.726Z]           │ └─IndexLookUp_64(Probe)	4.02	435528	root		time:2.26s, loops:447, index_task: {total_time: 1.42s, fetch_handle: 1.42s, build: 87.5µs, wait: 290.7µs}, table_task: {total_time: 8.83s, num: 56, concurrency: 60}		20.5 KB	N/A
20:39:06 [2021-06-04T20:39:06.726Z]           │   ├─IndexRangeScan_62(Build)	4.02	435528	cop[tikv]	table:partsupp, index:PRIMARY(PS_PARTKEY, PS_SUPPKEY)	time:1.38s, loops:478, cop_task: {num: 59, max: 270.7ms, min: 7.79ms, avg: 97.4ms, p95: 224.4ms, max_proc_keys: 15288, p95_proc_keys: 15008, tot_proc: 5.29s, tot_wait: 51ms, rpc_num: 59, rpc_time: 5.75s, copr_cache: disabled}, tikv_task:{proc max:258ms, min:4ms, p80:150ms, p95:188ms, 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:06 [2021-06-04T20:39:06.726Z]           │   └─TableRowIDScan_63(Probe)	4.02	435528	cop[tikv]	table:partsupp	time:2.59s, loops:505, cop_task: {num: 1399, max: 59.1ms, min: 480.5µs, avg: 18.5ms, p95: 37.7ms, max_proc_keys: 976, p95_proc_keys: 624, tot_proc: 19.5s, tot_wait: 4.28s, rpc_num: 1399, rpc_time: 25.9s, copr_cache: disabled}, tikv_task:{proc max:43ms, min:0s, p80:18ms, p95:26ms, iters:5217, tasks:1399}, scan_detail: {total_process_keys: 435528, total_keys: 473513, rocksdb: {delete_skipped_count: 0, key_skipped_count: 194123, block: {cache_hit_count: 3643766, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:39:06 [2021-06-04T20:39:06.726Z]           └─TableReader_101(Probe)	46310896.67	45504356	root		time:32.9s, loops:44289, cop_task: {num: 761, max: 1.25s, min: 295.6ms, avg: 698ms, p95: 840.1ms, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 8m48s, tot_wait: 108ms, rpc_num: 761, rpc_time: 8m51.1s, copr_cache: disabled}	data:Selection_100	52.6 MB	N/A
20:39:06 [2021-06-04T20:39:06.727Z]             └─Selection_100	46310896.67	45504356	cop[tikv]		tikv_task:{proc max:1.2s, min:281ms, p80:744ms, p95:825ms, 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:06 [2021-06-04T20:39:06.727Z]               └─TableFullScan_99	300005811.00	300005811	cop[tikv]	table:lineitem	tikv_task:{proc max:1.15s, min:270ms, p80:712ms, p95:793ms, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:39:06 [2021-06-04T20:39:06.727Z] + sync
20:39:06 [2021-06-04T20:39:06.727Z] + /usr/bin/echo 3
20:39:53 [2021-06-04T20:39:53.320Z] + sync
20:39:53 [2021-06-04T20:39:53.320Z] + /usr/bin/echo 3
20:40:31 [2021-06-04T20:40:31.981Z] 
20:40:31 [2021-06-04T20:40:31.981Z] queries/20.sql
20:40:31 [2021-06-04T20:40:31.981Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:40:31 [2021-06-04T20:40:31.981Z] Sort_30	20000.00	8982	root		time:37.8s, loops:10	tpch50.supplier.s_name	607.7 KB	0 Bytes
20:40:31 [2021-06-04T20:40:31.981Z] └─HashJoin_35	20000.00	8982	root		time:37.7s, loops:11, build_hash_table:{total:1.25s, fetch:1.24s, build:10.6ms}, probe:{concurrency:5, total:3m8.7s, max:37.7s, probe:46.7ms, fetch:3m8.7s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.partsupp.ps_suppkey)]	1.51 MB	0 Bytes
20:40:31 [2021-06-04T20:40:31.981Z]   ├─HashJoin_48(Build)	20000.00	19972	root		time:1.24s, loops:23, build_hash_table:{total:233.1µs, fetch:226.1µs, build:7.02µs}, probe:{concurrency:5, total:6.23s, max:1.25s, probe:114.6ms, fetch:6.12s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:40:31 [2021-06-04T20:40:31.981Z]   │ ├─TableReader_53(Build)	1.00	1	root		time:56.6µs, loops:2, cop_task: {num: 1, max: 979.1µs, proc_keys: 25, tot_proc: 1ms, rpc_num: 1, rpc_time: 966.5µs, copr_cache: disabled}	data:Selection_52	244 Bytes	N/A
20:40:31 [2021-06-04T20:40:31.981Z]   │ │ └─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:31 [2021-06-04T20:40:31.981Z]   │ │   └─TableFullScan_51	25.00	25	cop[tikv]	table:nation	tikv_task:{time:1ms, loops:1}	keep order:false	N/A	N/A
20:40:31 [2021-06-04T20:40:31.981Z]   │ └─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.15s, rpc_num: 1, rpc_time: 1.22s, copr_cache: disabled}	data:TableFullScan_49	35.8 MB	N/A
20:40:31 [2021-06-04T20:40:31.981Z]   │   └─TableFullScan_49	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:992ms, 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:31 [2021-06-04T20:40:31.981Z]   └─HashAgg_54(Probe)	257492.04	223999	root		time:37.7s, loops:222, partial_worker:{wall_time:37.677688521s, concurrency:5, task_num:289, tot_wait:3m8.120476971s, tot_exec:216.052979ms, tot_time:3m8.379126946s, max:37.677620178s, p95:37.677620178s}, final_worker:{wall_time:37.745868287s, concurrency:5, task_num:25, tot_wait:3m8.373034362s, tot_exec:333.770637ms, tot_time:3m8.706820072s, max:37.745825658s, p95:37.745825658s}	group by:tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_suppkey)->tpch50.partsupp.ps_suppkey	61.4 MB	N/A
20:40:31 [2021-06-04T20:40:31.981Z]     └─Selection_55	257492.04	295898	root		time:37.7s, loops:290	gt(cast(tpch50.partsupp.ps_availqty, decimal(20,0) BINARY), mul(0.5, Column#44))	59.2 KB	N/A
20:40:31 [2021-06-04T20:40:31.981Z]       └─HashAgg_56	321865.05	435528	root		time:37.6s, loops:430, partial_worker:{wall_time:37.315996477s, concurrency:5, task_num:624, tot_wait:3m5.282810561s, tot_exec:1.1736161s, tot_time:3m6.569804811s, max:37.315959354s, p95:37.315959354s}, final_worker:{wall_time:37.665315147s, concurrency:5, task_num:25, tot_wait:3m6.55793625s, tot_exec:1.7078059s, tot_time:3m8.265776949s, max:37.665223782s, p95:37.665223782s}	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:31 [2021-06-04T20:40:31.981Z]         └─HashJoin_59	9711455.06	634004	root		time:37.2s, loops:625, build_hash_table:{total:2.45s, fetch:2.24s, build:211ms}, probe:{concurrency:5, total:3m6.1s, max:37.2s, probe:14.6s, fetch:2m51.5s}	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:31 [2021-06-04T20:40:31.981Z]           ├─IndexHashJoin_67(Build)	321865.05	435528	root		time:2.43s, loops:430, inner:{total:2.85s, concurrency:5, task:12, construct:151.3ms, fetch:2.35s, build:30.9ms, join:353.5ms}	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:31 [2021-06-04T20:40:31.982Z]           │ ├─TableReader_96(Build)	80007.93	108882	root		time:2.03s, loops:112, cop_task: {num: 20, max: 1.47s, min: 665.5ms, avg: 1.07s, p95: 1.47s, max_proc_keys: 686055, p95_proc_keys: 686055, tot_proc: 21.3s, tot_wait: 2ms, rpc_num: 20, rpc_time: 21.3s, copr_cache: disabled}	data:Selection_95	725.8 KB	N/A
20:40:31 [2021-06-04T20:40:31.982Z]           │ │ └─Selection_95	80007.93	108882	cop[tikv]		tikv_task:{proc max:1.43s, min:661ms, p80:1.21s, p95:1.43s, 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:31 [2021-06-04T20:40:31.982Z]           │ │   └─TableFullScan_94	10000000.00	10000000	cop[tikv]	table:part	tikv_task:{proc max:1.32s, min:615ms, p80:1.12s, p95:1.32s, iters:9859, tasks:20}	keep order:false	N/A	N/A
20:40:31 [2021-06-04T20:40:31.982Z]           │ └─IndexLookUp_64(Probe)	4.02	435528	root		time:2.22s, loops:447, index_task: {total_time: 1.27s, fetch_handle: 1.27s, build: 92µs, wait: 280.4µs}, table_task: {total_time: 8.34s, num: 55, concurrency: 60}		20.7 KB	N/A
20:40:31 [2021-06-04T20:40:31.982Z]           │   ├─IndexRangeScan_62(Build)	4.02	435528	cop[tikv]	table:partsupp, index:PRIMARY(PS_PARTKEY, PS_SUPPKEY)	time:1.22s, loops:475, cop_task: {num: 58, max: 211.1ms, min: 4.45ms, avg: 93.4ms, p95: 194.1ms, max_proc_keys: 15288, p95_proc_keys: 15008, tot_proc: 5s, tot_wait: 36ms, rpc_num: 58, rpc_time: 5.42s, copr_cache: disabled}, tikv_task:{proc max:195ms, min:4ms, p80:145ms, p95:186ms, iters:688, 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:40:31 [2021-06-04T20:40:31.982Z]           │   └─TableRowIDScan_63(Probe)	4.02	435528	cop[tikv]	table:partsupp	time:2.66s, loops:504, cop_task: {num: 1485, max: 58.4ms, min: 436.9µs, avg: 17.8ms, p95: 34.6ms, max_proc_keys: 1028, p95_proc_keys: 528, tot_proc: 19.1s, tot_wait: 5.27s, rpc_num: 1485, rpc_time: 26.4s, copr_cache: disabled}, tikv_task:{proc max:43ms, min:0s, p80:16ms, p95:23ms, iters:5455, tasks:1485}, scan_detail: {total_process_keys: 435528, total_keys: 473500, rocksdb: {delete_skipped_count: 0, key_skipped_count: 194064, block: {cache_hit_count: 3644340, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:40:31 [2021-06-04T20:40:31.982Z]           └─TableReader_101(Probe)	46310896.67	45504356	root		time:32.8s, loops:44290, cop_task: {num: 761, max: 1.23s, min: 377.1ms, avg: 693.9ms, p95: 833ms, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 8m44.9s, tot_wait: 117ms, rpc_num: 761, rpc_time: 8m48.1s, copr_cache: disabled}	data:Selection_100	52.6 MB	N/A
20:40:31 [2021-06-04T20:40:31.982Z]             └─Selection_100	46310896.67	45504356	cop[tikv]		tikv_task:{proc max:1.16s, min:363ms, p80:741ms, p95:813ms, 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:31 [2021-06-04T20:40:31.982Z]               └─TableFullScan_99	300005811.00	300005811	cop[tikv]	table:lineitem	tikv_task:{proc max:1.12s, min:341ms, p80:709ms, p95:779ms, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:40:31 [2021-06-04T20:40:31.982Z] 
20:40:31 [2021-06-04T20:40:31.982Z] queries/20.sql
20:40:31 [2021-06-04T20:40:31.982Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:40:31 [2021-06-04T20:40:31.982Z] Sort_30	20000.00	8982	root		time:38.1s, loops:10	tpch50.supplier.s_name	620.9 KB	0 Bytes
20:40:31 [2021-06-04T20:40:31.982Z] └─HashJoin_35	20000.00	8982	root		time:38.1s, loops:11, build_hash_table:{total:1.24s, fetch:1.23s, build:9.04ms}, probe:{concurrency:5, total:3m10.6s, max:38.1s, probe:47.9ms, fetch:3m10.6s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.partsupp.ps_suppkey)]	1.43 MB	0 Bytes
20:40:31 [2021-06-04T20:40:31.982Z]   ├─HashJoin_48(Build)	20000.00	19972	root		time:1.23s, loops:21, build_hash_table:{total:206.5µs, fetch:199.8µs, build:6.64µs}, probe:{concurrency:5, total:6.18s, max:1.24s, probe:96.1ms, fetch:6.08s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:40:31 [2021-06-04T20:40:31.982Z]   │ ├─TableReader_53(Build)	1.00	1	root		time:50.1µs, loops:2, cop_task: {num: 1, max: 1.13ms, proc_keys: 25, tot_proc: 1ms, rpc_num: 1, rpc_time: 1.1ms, copr_cache: disabled}	data:Selection_52	244 Bytes	N/A
20:40:31 [2021-06-04T20:40:31.982Z]   │ │ └─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:31 [2021-06-04T20:40:31.982Z]   │ │   └─TableFullScan_51	25.00	25	cop[tikv]	table:nation	tikv_task:{time:1ms, loops:1}	keep order:false	N/A	N/A
20:40:31 [2021-06-04T20:40:31.982Z]   │ └─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.13s, rpc_num: 1, rpc_time: 1.22s, copr_cache: disabled}	data:TableFullScan_49	35.8 MB	N/A
20:40:31 [2021-06-04T20:40:31.982Z]   │   └─TableFullScan_49	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:959ms, 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:31 [2021-06-04T20:40:31.982Z]   └─HashAgg_54(Probe)	257492.04	223999	root		time:38.1s, loops:222, partial_worker:{wall_time:38.063063259s, concurrency:5, task_num:289, tot_wait:3m9.955598949s, tot_exec:309.858054ms, tot_time:3m10.305131958s, max:38.063018825s, p95:38.063018825s}, final_worker:{wall_time:38.125687131s, concurrency:5, task_num:25, tot_wait:3m10.291835041s, tot_exec:331.365941ms, tot_time:3m10.623213273s, max:38.125656522s, p95:38.125656522s}	group by:tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_suppkey)->tpch50.partsupp.ps_suppkey	61.4 MB	N/A
20:40:31 [2021-06-04T20:40:31.982Z]     └─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:40:31 [2021-06-04T20:40:31.982Z]       └─HashAgg_56	321865.05	435528	root		time:37.9s, loops:430, partial_worker:{wall_time:37.681627961s, concurrency:5, task_num:625, tot_wait:3m7.171853983s, tot_exec:1.100666502s, tot_time:3m8.387608798s, max:37.681572125s, p95:37.681572125s}, final_worker:{wall_time:38.051151451s, concurrency:5, task_num:25, tot_wait:3m8.374145818s, tot_exec:1.75554566s, tot_time:3m10.129709766s, max:38.051094169s, p95:38.051094169s}	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:31 [2021-06-04T20:40:31.982Z]         └─HashJoin_59	9711455.06	634004	root		time:37.6s, loops:626, build_hash_table:{total:2.44s, fetch:2.25s, build:190.9ms}, probe:{concurrency:5, total:3m7.9s, max:37.6s, probe:14.3s, fetch:2m53.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:40:31 [2021-06-04T20:40:31.982Z]           ├─IndexHashJoin_67(Build)	321865.05	435528	root		time:2.43s, loops:430, inner:{total:2.67s, concurrency:5, task:12, construct:127.5ms, fetch:2.21s, build:25.2ms, join:326.6ms}	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:31 [2021-06-04T20:40:31.982Z]           │ ├─TableReader_96(Build)	80007.93	108882	root		time:2.05s, loops:112, cop_task: {num: 20, max: 1.43s, min: 534.8ms, avg: 1.04s, p95: 1.43s, max_proc_keys: 686055, p95_proc_keys: 686055, tot_proc: 20.7s, tot_wait: 18ms, rpc_num: 20, rpc_time: 20.8s, copr_cache: disabled}	data:Selection_95	725.8 KB	N/A
20:40:31 [2021-06-04T20:40:31.982Z]           │ │ └─Selection_95	80007.93	108882	cop[tikv]		tikv_task:{proc max:1.4s, min:531ms, p80:1.22s, p95:1.4s, 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:31 [2021-06-04T20:40:31.982Z]           │ │   └─TableFullScan_94	10000000.00	10000000	cop[tikv]	table:part	tikv_task:{proc max:1.3s, min:496ms, p80:1.12s, p95:1.3s, iters:9859, tasks:20}	keep order:false	N/A	N/A
20:40:31 [2021-06-04T20:40:31.982Z]           │ └─IndexLookUp_64(Probe)	4.02	435528	root		time:2.1s, loops:447, index_task: {total_time: 1.15s, fetch_handle: 1.15s, build: 109.2µs, wait: 272.8µs}, table_task: {total_time: 7.83s, num: 55, concurrency: 60}		20.7 KB	N/A
20:40:31 [2021-06-04T20:40:31.982Z]           │   ├─IndexRangeScan_62(Build)	4.02	435528	cop[tikv]	table:partsupp, index:PRIMARY(PS_PARTKEY, PS_SUPPKEY)	time:1.11s, loops:478, cop_task: {num: 59, max: 190.1ms, min: 2.94ms, avg: 86.6ms, p95: 171.3ms, max_proc_keys: 15288, p95_proc_keys: 14960, tot_proc: 4.73s, tot_wait: 94ms, rpc_num: 59, rpc_time: 5.11s, copr_cache: disabled}, tikv_task:{proc max:178ms, min:2ms, p80:138ms, p95:160ms, 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:40:31 [2021-06-04T20:40:31.982Z]           │   └─TableRowIDScan_63(Probe)	4.02	435528	cop[tikv]	table:partsupp	time:2.73s, loops:504, cop_task: {num: 1399, max: 113.5ms, min: 466.6µs, avg: 18.9ms, p95: 42.5ms, max_proc_keys: 932, p95_proc_keys: 616, tot_proc: 18.7s, tot_wait: 4.7s, rpc_num: 1399, rpc_time: 26.4s, copr_cache: disabled}, tikv_task:{proc max:42ms, min:0s, p80:17ms, p95:24ms, iters:5229, tasks:1399}, scan_detail: {total_process_keys: 435528, total_keys: 473508, rocksdb: {delete_skipped_count: 0, key_skipped_count: 194080, block: {cache_hit_count: 3644017, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:40:31 [2021-06-04T20:40:31.982Z]           └─TableReader_101(Probe)	46310896.67	45504356	root		time:33.1s, loops:44289, cop_task: {num: 761, max: 1.15s, min: 320.1ms, avg: 700.8ms, p95: 855.6ms, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 8m50.1s, tot_wait: 122ms, rpc_num: 761, rpc_time: 8m53.3s, copr_cache: disabled}	data:Selection_100	52.6 MB	N/A
20:40:31 [2021-06-04T20:40:31.982Z]             └─Selection_100	46310896.67	45504356	cop[tikv]		tikv_task:{proc max:1.12s, min:313ms, p80:750ms, p95:834ms, 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:31 [2021-06-04T20:40:31.982Z]               └─TableFullScan_99	300005811.00	300005811	cop[tikv]	table:lineitem	tikv_task:{proc max:1.07s, min:300ms, p80:717ms, p95:795ms, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:40:31 [2021-06-04T20:40:31.982Z] + sync
20:40:31 [2021-06-04T20:40:31.982Z] + /usr/bin/echo 3
20:41:10 [2021-06-04T20:41:10.641Z] + tiup cluster stop benchbot -y
20:41:10 [2021-06-04T20:41:10.641Z] Starting component `cluster`: /home/tidb/.tiup/components/cluster/v1.4.4/tiup-cluster stop benchbot -y
20:41:25 [2021-06-04T20:41:25.474Z] + rm -rf '/data1/tidb-deploy/*/log/*'
20:41:25 [2021-06-04T20:41:25.474Z] + rm -rf /data1/jenkins/deploy/data/tikv-20160
20:41:27 [2021-06-04T20:41:27.986Z] + rm -rf /data1/jenkins/deploy/data/pd-2379
20:41:27 [2021-06-04T20:41:27.986Z] + rm -rf /data1/jenkins/restore_data/tpch50/data/last_tikv.toml
20:41:27 [2021-06-04T20:41:27.986Z] + cp -R /data1/jenkins/restore_data/tpch50/data /data1/jenkins/deploy/data/tikv-20160
20:43:19 [2021-06-04T20:43:19.350Z] + cp -R /data1/jenkins/restore_data/tpch50/data.pd /data1/jenkins/deploy/data/pd-2379
20:43:19 [2021-06-04T20:43:19.350Z] + '[' -n '' ']'
20:43:19 [2021-06-04T20:43:19.350Z] + tiup cluster start benchbot --wait-timeout=300
20:43:19 [2021-06-04T20:43:19.350Z] Starting component `cluster`: /home/tidb/.tiup/components/cluster/v1.4.4/tiup-cluster start benchbot --wait-timeout=300
20:43:41 [2021-06-04T20:43:41.227Z] + sync
20:43:41 [2021-06-04T20:43:41.227Z] + /usr/bin/echo 3
20:45:17 [2021-06-04T20:45:17.601Z] 
20:45:17 [2021-06-04T20:45:17.601Z] queries/20.sql
20:45:17 [2021-06-04T20:45:17.601Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:45:17 [2021-06-04T20:45:17.601Z] Sort_30	20000.00	8982	root		time:37.6s, loops:10	tpch50.supplier.s_name	606.3 KB	0 Bytes
20:45:17 [2021-06-04T20:45:17.601Z] └─HashJoin_35	20000.00	8982	root		time:37.5s, loops:11, build_hash_table:{total:1.39s, fetch:1.38s, build:9.72ms}, probe:{concurrency:5, total:3m7.7s, max:37.5s, probe:53.7ms, fetch:3m7.7s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.partsupp.ps_suppkey)]	1.54 MB	0 Bytes
20:45:17 [2021-06-04T20:45:17.601Z]   ├─HashJoin_48(Build)	20000.00	19972	root		time:1.39s, loops:24, build_hash_table:{total:145.8µs, fetch:140µs, build:5.85µs}, probe:{concurrency:5, total:6.95s, max:1.39s, probe:108.7ms, fetch:6.84s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:45:17 [2021-06-04T20:45:17.601Z]   │ ├─TableReader_53(Build)	1.00	1	root		time:35µs, loops:2, cop_task: {num: 1, max: 1.09ms, proc_keys: 25, rpc_num: 1, rpc_time: 1.07ms, copr_cache: disabled}	data:Selection_52	240 Bytes	N/A
20:45:17 [2021-06-04T20:45:17.601Z]   │ │ └─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:17 [2021-06-04T20:45:17.601Z]   │ │   └─TableFullScan_51	25.00	25	cop[tikv]	table:nation	tikv_task:{time:0s, loops:1}	keep order:false	N/A	N/A
20:45:17 [2021-06-04T20:45:17.601Z]   │ └─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, tot_wait: 1ms, rpc_num: 1, rpc_time: 1.37s, copr_cache: disabled}	data:TableFullScan_49	35.8 MB	N/A
20:45:17 [2021-06-04T20:45:17.601Z]   │   └─TableFullScan_49	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:1.16s, 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:17 [2021-06-04T20:45:17.601Z]   └─HashAgg_54(Probe)	257492.04	223999	root		time:37.5s, loops:222, partial_worker:{wall_time:37.4751962s, concurrency:5, task_num:289, tot_wait:3m6.944958179s, tot_exec:272.614382ms, tot_time:3m7.352559542s, max:37.475097211s, p95:37.475097211s}, final_worker:{wall_time:37.542519253s, concurrency:5, task_num:25, tot_wait:3m7.339480086s, tot_exec:363.715403ms, tot_time:3m7.703210228s, max:37.542462329s, p95:37.542462329s}	group by:tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_suppkey)->tpch50.partsupp.ps_suppkey	61.4 MB	N/A
20:45:17 [2021-06-04T20:45:17.601Z]     └─Selection_55	257492.04	295898	root		time:37.4s, loops:290	gt(cast(tpch50.partsupp.ps_availqty, decimal(20,0) BINARY), mul(0.5, Column#44))	59.2 KB	N/A
20:45:17 [2021-06-04T20:45:17.601Z]       └─HashAgg_56	321865.05	435528	root		time:37.3s, loops:430, partial_worker:{wall_time:37.086841365s, concurrency:5, task_num:625, tot_wait:3m4.336851811s, tot_exec:974.245935ms, tot_time:3m5.421334379s, max:37.086764538s, p95:37.086764538s}, final_worker:{wall_time:37.436045772s, concurrency:5, task_num:25, tot_wait:3m5.411897489s, tot_exec:1.656365844s, tot_time:3m7.068283531s, max:37.435705805s, p95:37.435705805s}	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:17 [2021-06-04T20:45:17.601Z]         └─HashJoin_59	9711455.06	634004	root		time:37s, loops:626, build_hash_table:{total:2.44s, fetch:2.25s, build:194.5ms}, probe:{concurrency:5, total:3m5.1s, max:37s, probe:14.5s, 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:45:17 [2021-06-04T20:45:17.601Z]           ├─IndexHashJoin_67(Build)	321865.05	435528	root		time:2.41s, loops:430, inner:{total:2.79s, concurrency:5, task:12, construct:121.3ms, fetch:2.31s, build:25.5ms, join:352.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:45:17 [2021-06-04T20:45:17.601Z]           │ ├─TableReader_96(Build)	80007.93	108882	root		time:2.05s, loops:112, cop_task: {num: 20, max: 1.61s, min: 582.4ms, avg: 1.09s, p95: 1.61s, max_proc_keys: 686055, p95_proc_keys: 686055, tot_proc: 21.7s, tot_wait: 3ms, rpc_num: 20, rpc_time: 21.7s, copr_cache: disabled}	data:Selection_95	725.8 KB	N/A
20:45:17 [2021-06-04T20:45:17.601Z]           │ │ └─Selection_95	80007.93	108882	cop[tikv]		tikv_task:{proc max:1.56s, min:580ms, p80:1.24s, p95:1.56s, 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:17 [2021-06-04T20:45:17.601Z]           │ │   └─TableFullScan_94	10000000.00	10000000	cop[tikv]	table:part	tikv_task:{proc max:1.46s, min:542ms, p80:1.15s, p95:1.46s, iters:9859, tasks:20}	keep order:false	N/A	N/A
20:45:17 [2021-06-04T20:45:17.601Z]           │ └─IndexLookUp_64(Probe)	4.02	435528	root		time:2.2s, loops:447, index_task: {total_time: 1.22s, fetch_handle: 1.22s, build: 80.3µs, wait: 271.8µs}, table_task: {total_time: 8.25s, num: 56, concurrency: 60}		20.5 KB	N/A
20:45:17 [2021-06-04T20:45:17.602Z]           │   ├─IndexRangeScan_62(Build)	4.02	435528	cop[tikv]	table:partsupp, index:PRIMARY(PS_PARTKEY, PS_SUPPKEY)	time:1.16s, loops:484, cop_task: {num: 57, max: 240.3ms, min: 5.46ms, avg: 94ms, p95: 190.9ms, max_proc_keys: 15288, p95_proc_keys: 15008, tot_proc: 4.87s, tot_wait: 65ms, rpc_num: 57, rpc_time: 5.36s, copr_cache: disabled}, tikv_task:{proc max:212ms, min:4ms, p80:143ms, p95:175ms, iters:683, 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:45:17 [2021-06-04T20:45:17.602Z]           │   └─TableRowIDScan_63(Probe)	4.02	435528	cop[tikv]	table:partsupp	time:2.94s, loops:506, cop_task: {num: 1465, max: 91.3ms, min: 463.5µs, avg: 20.1ms, p95: 43.3ms, max_proc_keys: 996, p95_proc_keys: 544, tot_proc: 20s, tot_wait: 6.2s, rpc_num: 1465, rpc_time: 29.4s, copr_cache: disabled}, tikv_task:{proc max:44ms, min:0s, p80:16ms, p95:23ms, iters:5399, tasks:1465}, scan_detail: {total_process_keys: 435528, total_keys: 473508, rocksdb: {delete_skipped_count: 0, key_skipped_count: 194126, block: {cache_hit_count: 3643990, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:45:17 [2021-06-04T20:45:17.602Z]           └─TableReader_101(Probe)	46310896.67	45504356	root		time:32.6s, loops:44289, cop_task: {num: 761, max: 1.17s, min: 350.9ms, avg: 689.9ms, p95: 840.8ms, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 8m41.8s, tot_wait: 107ms, rpc_num: 761, rpc_time: 8m45s, copr_cache: disabled}	data:Selection_100	52.6 MB	N/A
20:45:17 [2021-06-04T20:45:17.602Z]             └─Selection_100	46310896.67	45504356	cop[tikv]		tikv_task:{proc max:1.09s, min:344ms, p80:737ms, p95:822ms, 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:17 [2021-06-04T20:45:17.602Z]               └─TableFullScan_99	300005811.00	300005811	cop[tikv]	table:lineitem	tikv_task:{proc max:1.05s, min:327ms, p80:705ms, p95:788ms, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:45:17 [2021-06-04T20:45:17.602Z] 
20:45:17 [2021-06-04T20:45:17.602Z] queries/21.sql
20:45:17 [2021-06-04T20:45:17.602Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:45:17 [2021-06-04T20:45:17.602Z] Projection_26	100.00	100	root		time:1m23.2s, loops:2, Concurrency:OFF	tpch50.supplier.s_name, Column#72	4.62 KB	N/A
20:45:17 [2021-06-04T20:45:17.602Z] └─TopN_29	100.00	100	root		time:1m23.2s, loops:2	Column#72:desc, tpch50.supplier.s_name, offset:0, count:100	58.4 KB	N/A
20:45:17 [2021-06-04T20:45:17.602Z]   └─HashAgg_34	12800.00	20057	root		time:1m23.2s, loops:21, partial_worker:{wall_time:1m23.206894864s, concurrency:5, task_num:197, tot_wait:6m55.715802274s, tot_exec:302.312483ms, tot_time:6m56.032064324s, max:1m23.206853624s, p95:1m23.206853624s}, final_worker:{wall_time:1m23.221054928s, concurrency:5, task_num:25, tot_wait:6m56.029242629s, tot_exec:66.705497ms, tot_time:6m56.095961091s, max:1m23.221002419s, p95:1m23.221002419s}	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:17 [2021-06-04T20:45:17.602Z]     └─IndexHashJoin_42	7828961.66	198698	root		time:1m23.2s, loops:198, inner:{total:2m23.3s, concurrency:5, task:147, construct:6.44s, fetch:2m0.8s, build:1.19s, join:16.1s}	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:17 [2021-06-04T20:45:17.602Z]       ├─IndexHashJoin_83(Build)	9786202.08	3542799	root		time:1m22.6s, loops:3464, inner:{total:2m31.5s, concurrency:5, task:152, construct:7.8s, fetch:2m6.3s, build:1.26s, 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:45:17 [2021-06-04T20:45:17.602Z]       │ ├─IndexJoin_99(Build)	12232752.60	3675878	root		time:1m22.1s, loops:3595, inner:{total:2m9.3s, concurrency:5, task:305, construct:16.3s, fetch:1m51.2s, build:1.85s}, probe:5s	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:17 [2021-06-04T20:45:17.602Z]       │ │ ├─HashJoin_107(Build)	12232752.60	7609895	root		time:1m21.5s, loops:7436, build_hash_table:{total:830ms, fetch:823.2ms, build:6.81ms}, probe:{concurrency:5, total:6m50.1s, max:1m22s, probe:1m0.1s, fetch:5m50.1s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.lineitem.l_suppkey)]	757.3 KB	0 Bytes
20:45:17 [2021-06-04T20:45:17.602Z]       │ │ │ ├─HashJoin_120(Build)	20000.00	20058	root		time:827.4ms, loops:23, build_hash_table:{total:369µs, fetch:140.5µs, build:228.5µs}, probe:{concurrency:5, total:4.14s, max:828.9ms, probe:70.1ms, fetch:4.07s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:45:17 [2021-06-04T20:45:17.602Z]       │ │ │ │ ├─TableReader_125(Build)	1.00	1	root		time:63.6µs, loops:2, cop_task: {num: 1, max: 870.5µs, proc_keys: 25, tot_proc: 1ms, rpc_num: 1, rpc_time: 850.2µs, copr_cache: disabled}	data:Selection_124	242 Bytes	N/A
20:45:17 [2021-06-04T20:45:17.602Z]       │ │ │ │ │ └─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: 18, read_count: 0, read_byte: 0 Bytes}}}	eq(tpch50.nation.n_name, "EGYPT")	N/A	N/A
20:45:17 [2021-06-04T20:45:17.602Z]       │ │ │ │ │   └─TableFullScan_123	25.00	25	cop[tikv]	table:nation	tikv_task:{time:1ms, loops:1}	keep order:false	N/A	N/A
20:45:17 [2021-06-04T20:45:17.602Z]       │ │ │ │ └─TableReader_122(Probe)	500000.00	500000	root		time:814.2ms, loops:490, cop_task: {num: 1, max: 917.4ms, proc_keys: 500000, tot_proc: 892ms, rpc_num: 1, rpc_time: 917.4ms, copr_cache: disabled}	data:TableFullScan_121	20.0 MB	N/A
20:45:17 [2021-06-04T20:45:17.602Z]       │ │ │ │   └─TableFullScan_121	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:850ms, 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:17 [2021-06-04T20:45:17.602Z]       │ │ │ └─TableReader_128(Probe)	240004648.80	189670348	root		time:1m9.9s, loops:184597, cop_task: {num: 761, max: 2.77s, min: 299.7ms, avg: 1.58s, p95: 2.07s, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 18m45.6s, tot_wait: 1m0.4s, rpc_num: 761, rpc_time: 19m59.5s, copr_cache: disabled}	data:Selection_127	99.2 MB	N/A
20:45:17 [2021-06-04T20:45:17.602Z]       │ │ │   └─Selection_127	240004648.80	189670348	cop[tikv]		tikv_task:{proc max:1.48s, min:284ms, p80:1.23s, p95:1.34s, 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: 18679, read_count: 1131784, read_byte: 23.9 GB}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:45:17 [2021-06-04T20:45:17.602Z]       │ │ │     └─TableFullScan_126	300005811.00	300005811	cop[tikv]	table:l1	tikv_task:{proc max:1.4s, min:271ms, p80:1.15s, p95:1.25s, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:45:17 [2021-06-04T20:45:17.602Z]       │ │ └─TableReader_95(Probe)	0.49	3496187	root		time:1m42.3s, loops:3875, cop_task: {num: 5282, max: 561.6ms, min: 616.3µs, avg: 184.8ms, p95: 349.2ms, max_proc_keys: 3952, p95_proc_keys: 1964, tot_proc: 11m44.7s, tot_wait: 3m51s, rpc_num: 5282, rpc_time: 16m15.8s, copr_cache: disabled}	data:Selection_94	N/A	N/A
20:45:17 [2021-06-04T20:45:17.602Z]       │ │   └─Selection_94	0.49	3496187	cop[tikv]		tikv_task:{proc max:130ms, min:0s, p80:72ms, p95:85ms, iters:30308, tasks:5282}, scan_detail: {total_process_keys: 7236299, total_keys: 7795514, rocksdb: {delete_skipped_count: 0, key_skipped_count: 1778301, block: {cache_hit_count: 54007247, read_count: 220088, read_byte: 4.74 GB}}}	eq(tpch50.orders.o_orderstatus, "F")	N/A	N/A
20:45:17 [2021-06-04T20:45:17.602Z]       │ │     └─TableRangeScan_93	1.00	7236299	cop[tikv]	table:orders	tikv_task:{proc max:130ms, min:0s, p80:71ms, p95:85ms, iters:30308, tasks:5282}	range: decided by [tpch50.lineitem.l_orderkey], keep order:false	N/A	N/A
20:45:17 [2021-06-04T20:45:17.602Z]       │ └─IndexLookUp_80(Probe)	4.05	17316358	root		time:2m0.8s, loops:17135, index_task: {total_time: 1m8.2s, fetch_handle: 1m0.1s, build: 4.26ms, wait: 8.05s}, table_task: {total_time: 8m43.4s, num: 1458, concurrency: 760}		19.4 KB	N/A
20:45:17 [2021-06-04T20:45:17.602Z]       │   ├─IndexRangeScan_78(Build)	4.05	17316358	cop[tikv]	table:l2, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:57.9s, loops:18607, cop_task: {num: 3013, max: 783.6ms, min: 659.5µs, avg: 194.4ms, p95: 399.6ms, max_proc_keys: 14686, p95_proc_keys: 8739, tot_proc: 7m28.6s, tot_wait: 1m55.9s, rpc_num: 3013, rpc_time: 9m45.5s, copr_cache: disabled}, tikv_task:{proc max:173ms, min:0s, p80:101ms, p95:117ms, iters:30243, tasks:3013}, scan_detail: {total_process_keys: 17316358, total_keys: 20812445, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17316358, block: {cache_hit_count: 24260061, read_count: 226939, read_byte: 2.41 GB}}}	range: decided by [eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey)], keep order:false	N/A	N/A
20:45:17 [2021-06-04T20:45:17.602Z]       │   └─TableRowIDScan_79(Probe)	4.05	17316358	cop[tikv]	table:l2	time:6m29.4s, loops:20999, cop_task: {num: 7797, max: 673.6ms, min: 495.1µs, avg: 182.7ms, p95: 368.4ms, max_proc_keys: 11834, p95_proc_keys: 4878, tot_proc: 17m1.8s, tot_wait: 5m51.7s, rpc_num: 7797, rpc_time: 23m44s, copr_cache: disabled}, tikv_task:{proc max:266ms, min:0s, p80:106ms, p95:145ms, iters:49960, tasks:7797}, scan_detail: {total_process_keys: 17316358, total_keys: 18288508, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5626704, block: {cache_hit_count: 99018735, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:45:17 [2021-06-04T20:45:17.602Z]       └─IndexLookUp_39(Probe)	4.05	12022714	root		time:1m56s, loops:11946, index_task: {total_time: 1m2.5s, fetch_handle: 51.1s, build: 3.91ms, wait: 11.4s}, table_task: {total_time: 8m21.8s, num: 1410, concurrency: 735}		219.8 KB	N/A
20:45:17 [2021-06-04T20:45:17.602Z]         ├─IndexRangeScan_36(Build)	5.06	17183276	cop[tikv]	table:l3, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:48.8s, loops:18344, cop_task: {num: 2795, max: 733.3ms, min: 1.41ms, avg: 172.7ms, p95: 371.8ms, max_proc_keys: 18644, p95_proc_keys: 13454, tot_proc: 6m1.1s, tot_wait: 1m40.6s, rpc_num: 2795, rpc_time: 8m2.7s, copr_cache: disabled}, tikv_task:{proc max:188ms, min:0s, p80:80ms, p95:119ms, iters:29116, tasks:2795}, scan_detail: {total_process_keys: 17183276, total_keys: 20546283, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17183276, block: {cache_hit_count: 23553855, 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:17 [2021-06-04T20:45:17.602Z]         └─Selection_38(Probe)	4.05	12022714	cop[tikv]		time:6m27.4s, loops:13774, cop_task: {num: 10193, max: 652.8ms, min: 562.7µs, avg: 180.1ms, p95: 368.4ms, max_proc_keys: 8135, p95_proc_keys: 3961, tot_proc: 21m41.5s, tot_wait: 7m47.5s, rpc_num: 10193, rpc_time: 30m35.6s, copr_cache: disabled}, tikv_task:{proc max:267ms, min:0s, p80:78ms, p95:119ms, iters:60584, tasks:10193}, scan_detail: {total_process_keys: 17183276, total_keys: 18129504, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5529048, block: {cache_hit_count: 98285802, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:45:17 [2021-06-04T20:45:17.602Z]           └─TableRowIDScan_37	5.06	17183276	cop[tikv]	table:l3	tikv_task:{proc max:265ms, min:0s, p80:78ms, p95:118ms, iters:60584, tasks:10193}	keep order:false	N/A	N/A
20:45:17 [2021-06-04T20:45:17.602Z] + sync
20:45:17 [2021-06-04T20:45:17.602Z] + /usr/bin/echo 3
20:46:53 [2021-06-04T20:46:53.985Z] 
20:46:53 [2021-06-04T20:46:53.985Z] queries/21.sql
20:46:53 [2021-06-04T20:46:53.985Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:46:53 [2021-06-04T20:46:53.985Z] Projection_26	100.00	100	root		time:1m28.2s, loops:2, Concurrency:OFF	tpch50.supplier.s_name, Column#72	4.62 KB	N/A
20:46:53 [2021-06-04T20:46:53.985Z] └─TopN_29	100.00	100	root		time:1m28.2s, loops:2	Column#72:desc, tpch50.supplier.s_name, offset:0, count:100	55.9 KB	N/A
20:46:53 [2021-06-04T20:46:53.985Z]   └─HashAgg_34	12800.00	20057	root		time:1m28.2s, loops:21, partial_worker:{wall_time:1m28.18970294s, concurrency:5, task_num:196, tot_wait:7m20.65266362s, tot_exec:282.120323ms, tot_time:7m20.946898392s, max:1m28.1896759s, p95:1m28.1896759s}, final_worker:{wall_time:1m28.205479467s, concurrency:5, task_num:25, tot_wait:7m20.946115522s, tot_exec:73.037578ms, tot_time:7m21.019166133s, max:1m28.205459679s, p95:1m28.205459679s}	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:53 [2021-06-04T20:46:53.985Z]     └─IndexHashJoin_42	7828961.66	198698	root		time:1m28.2s, loops:197, inner:{total:2m29.2s, concurrency:5, task:147, construct:6.49s, fetch:2m6.3s, build:1.1s, 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.0 MB	N/A
20:46:53 [2021-06-04T20:46:53.985Z]       ├─IndexHashJoin_83(Build)	9786202.08	3542799	root		time:1m27.7s, loops:3464, inner:{total:2m38.5s, concurrency:5, task:152, construct:7.66s, fetch:2m13.3s, 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:46:53 [2021-06-04T20:46:53.985Z]       │ ├─IndexJoin_99(Build)	12232752.60	3675878	root		time:1m27.2s, loops:3595, inner:{total:2m17.7s, concurrency:5, task:305, construct:16.2s, fetch:1m59.6s, build:1.89s}, probe:5.14s	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:46:53 [2021-06-04T20:46:53.985Z]       │ │ ├─HashJoin_107(Build)	12232752.60	7609895	root		time:1m26.7s, loops:7437, build_hash_table:{total:1.14s, fetch:1.14s, build:5.89ms}, probe:{concurrency:5, total:7m15.1s, max:1m27s, probe:1m0.2s, fetch:6m14.9s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.lineitem.l_suppkey)]	757.3 KB	0 Bytes
20:46:53 [2021-06-04T20:46:53.985Z]       │ │ │ ├─HashJoin_120(Build)	20000.00	20058	root		time:1.14s, loops:23, build_hash_table:{total:177.8µs, fetch:172.3µs, build:5.51µs}, probe:{concurrency:5, total:5.71s, max:1.14s, probe:58.5ms, fetch:5.66s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:46:53 [2021-06-04T20:46:53.985Z]       │ │ │ │ ├─TableReader_125(Build)	1.00	1	root		time:73µs, loops:2, cop_task: {num: 1, max: 1.37ms, proc_keys: 25, rpc_num: 1, rpc_time: 1.34ms, copr_cache: disabled}	data:Selection_124	240 Bytes	N/A
20:46:53 [2021-06-04T20:46:53.986Z]       │ │ │ │ │ └─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:46:53 [2021-06-04T20:46:53.986Z]       │ │ │ │ │   └─TableFullScan_123	25.00	25	cop[tikv]	table:nation	tikv_task:{time:0s, loops:1}	keep order:false	N/A	N/A
20:46:53 [2021-06-04T20:46:53.986Z]       │ │ │ │ └─TableReader_122(Probe)	500000.00	500000	root		time:1.13s, loops:490, cop_task: {num: 1, max: 1.13s, proc_keys: 500000, tot_proc: 1.1s, tot_wait: 1ms, rpc_num: 1, rpc_time: 1.13s, copr_cache: disabled}	data:TableFullScan_121	20.0 MB	N/A
20:46:53 [2021-06-04T20:46:53.986Z]       │ │ │ │   └─TableFullScan_121	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:1.04s, 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:53 [2021-06-04T20:46:53.986Z]       │ │ │ └─TableReader_128(Probe)	240004648.80	189670348	root		time:1m14.5s, loops:184596, cop_task: {num: 761, max: 2.82s, min: 291.3ms, avg: 1.67s, p95: 2.17s, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 19m54.1s, tot_wait: 1m6.2s, rpc_num: 761, rpc_time: 21m13.9s, copr_cache: disabled}	data:Selection_127	109.4 MB	N/A
20:46:53 [2021-06-04T20:46:53.986Z]       │ │ │   └─Selection_127	240004648.80	189670348	cop[tikv]		tikv_task:{proc max:1.55s, min:274ms, p80:1.34s, p95:1.42s, 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: 10453, read_count: 1114195, read_byte: 23.6 GB}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:46:53 [2021-06-04T20:46:53.986Z]       │ │ │     └─TableFullScan_126	300005811.00	300005811	cop[tikv]	table:l1	tikv_task:{proc max:1.46s, min:254ms, p80:1.25s, p95:1.33s, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:46:53 [2021-06-04T20:46:53.986Z]       │ │ └─TableReader_95(Probe)	0.49	3496196	root		time:1m50.7s, loops:3875, cop_task: {num: 5252, max: 608.1ms, min: 1.07ms, avg: 195.8ms, p95: 362.3ms, max_proc_keys: 3431, p95_proc_keys: 1945, tot_proc: 12m19.3s, tot_wait: 4m7.1s, rpc_num: 5252, rpc_time: 17m8.1s, copr_cache: disabled}	data:Selection_94	N/A	N/A
20:46:53 [2021-06-04T20:46:53.986Z]       │ │   └─Selection_94	0.49	3496196	cop[tikv]		tikv_task:{proc max:143ms, min:0s, p80:77ms, p95:91ms, iters:30192, tasks:5252}, scan_detail: {total_process_keys: 7236291, total_keys: 7795510, rocksdb: {delete_skipped_count: 0, key_skipped_count: 1778375, block: {cache_hit_count: 54006430, read_count: 218027, read_byte: 4.21 GB}}}	eq(tpch50.orders.o_orderstatus, "F")	N/A	N/A
20:46:53 [2021-06-04T20:46:53.986Z]       │ │     └─TableRangeScan_93	1.00	7236291	cop[tikv]	table:orders	tikv_task:{proc max:143ms, min:0s, p80:77ms, p95:91ms, iters:30192, tasks:5252}	range: decided by [tpch50.lineitem.l_orderkey], keep order:false	N/A	N/A
20:46:53 [2021-06-04T20:46:53.986Z]       │ └─IndexLookUp_80(Probe)	4.05	17316475	root		time:2m7.9s, loops:17132, index_task: {total_time: 1m11.6s, fetch_handle: 1m1.8s, build: 3.23ms, wait: 9.82s}, table_task: {total_time: 9m11.8s, num: 1458, concurrency: 760}		19.3 KB	N/A
20:46:53 [2021-06-04T20:46:53.986Z]       │   ├─IndexRangeScan_78(Build)	4.05	17316475	cop[tikv]	table:l2, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:59.5s, loops:18619, cop_task: {num: 2992, max: 862.4ms, min: 376.3µs, avg: 205.9ms, p95: 402.7ms, max_proc_keys: 13996, p95_proc_keys: 8772, tot_proc: 7m47.1s, tot_wait: 2m7.1s, rpc_num: 2992, rpc_time: 10m16.1s, copr_cache: disabled}, tikv_task:{proc max:222ms, min:0s, p80:108ms, p95:127ms, iters:30170, tasks:2992}, scan_detail: {total_process_keys: 17316475, total_keys: 20812579, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17316475, block: {cache_hit_count: 24259971, read_count: 225685, 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:53 [2021-06-04T20:46:53.986Z]       │   └─TableRowIDScan_79(Probe)	4.05	17316475	cop[tikv]	table:l2	time:6m48.5s, loops:21006, cop_task: {num: 7811, max: 811.3ms, min: 455.8µs, avg: 191.3ms, p95: 380.6ms, max_proc_keys: 10415, p95_proc_keys: 4859, tot_proc: 18m3.9s, tot_wait: 5m58.4s, rpc_num: 7811, rpc_time: 24m54.1s, copr_cache: disabled}, tikv_task:{proc max:362ms, min:0s, p80:112ms, p95:150ms, iters:49972, tasks:7811}, scan_detail: {total_process_keys: 17316475, total_keys: 18290013, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5630050, block: {cache_hit_count: 99022713, read_count: 1106, read_byte: 390.4 MB}}}	keep order:false	N/A	N/A
20:46:53 [2021-06-04T20:46:53.986Z]       └─IndexLookUp_39(Probe)	4.05	12022802	root		time:2m1.2s, loops:11948, index_task: {total_time: 1m3.9s, fetch_handle: 54s, build: 3.32ms, wait: 9.88s}, table_task: {total_time: 8m39.8s, num: 1410, concurrency: 735}		271.4 KB	N/A
20:46:53 [2021-06-04T20:46:53.986Z]         ├─IndexRangeScan_36(Build)	5.06	17183398	cop[tikv]	table:l3, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:51.5s, loops:18386, cop_task: {num: 2795, max: 770.3ms, min: 729.8µs, avg: 180.9ms, p95: 376.2ms, max_proc_keys: 19833, p95_proc_keys: 13331, tot_proc: 6m17.8s, tot_wait: 1m46.5s, rpc_num: 2795, rpc_time: 8m25.5s, copr_cache: disabled}, tikv_task:{proc max:199ms, min:0s, p80:83ms, p95:127ms, iters:29170, tasks:2795}, scan_detail: {total_process_keys: 17183398, total_keys: 20546423, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17183398, block: {cache_hit_count: 23553982, 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:53 [2021-06-04T20:46:53.986Z]         └─Selection_38(Probe)	4.05	12022802	cop[tikv]		time:6m41.2s, loops:13776, cop_task: {num: 10177, max: 731.6ms, min: 421.5µs, avg: 187.1ms, p95: 382.1ms, max_proc_keys: 6876, p95_proc_keys: 4012, tot_proc: 22m33.6s, tot_wait: 8m0.7s, rpc_num: 10177, rpc_time: 31m43.5s, copr_cache: disabled}, tikv_task:{proc max:227ms, min:0s, p80:83ms, p95:125ms, iters:60335, tasks:10177}, scan_detail: {total_process_keys: 17183398, total_keys: 18129692, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5529076, block: {cache_hit_count: 98287406, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:46:53 [2021-06-04T20:46:53.986Z]           └─TableRowIDScan_37	5.06	17183398	cop[tikv]	table:l3	tikv_task:{proc max:225ms, min:0s, p80:83ms, p95:124ms, iters:60335, tasks:10177}	keep order:false	N/A	N/A
20:46:53 [2021-06-04T20:46:53.986Z] + sync
20:46:53 [2021-06-04T20:46:53.986Z] + /usr/bin/echo 3
20:48:15 [2021-06-04T20:48:15.362Z] 
20:48:15 [2021-06-04T20:48:15.362Z] queries/21.sql
20:48:15 [2021-06-04T20:48:15.362Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:48:15 [2021-06-04T20:48:15.362Z] Projection_26	100.00	100	root		time:1m23.2s, loops:2, Concurrency:OFF	tpch50.supplier.s_name, Column#72	4.62 KB	N/A
20:48:15 [2021-06-04T20:48:15.362Z] └─TopN_29	100.00	100	root		time:1m23.2s, loops:2	Column#72:desc, tpch50.supplier.s_name, offset:0, count:100	58.4 KB	N/A
20:48:15 [2021-06-04T20:48:15.362Z]   └─HashAgg_34	12800.00	20057	root		time:1m23.2s, loops:21, partial_worker:{wall_time:1m23.150276239s, concurrency:5, task_num:196, tot_wait:6m55.43287149s, tot_exec:301.56985ms, tot_time:6m55.748690806s, max:1m23.15023609s, p95:1m23.15023609s}, final_worker:{wall_time:1m23.164444136s, concurrency:5, task_num:25, tot_wait:6m55.745747421s, tot_exec:75.34144ms, tot_time:6m55.821102126s, max:1m23.164410023s, p95:1m23.164410023s}	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-04T20:48:15.362Z]     └─IndexHashJoin_42	7828961.66	198698	root		time:1m23.1s, loops:197, inner:{total:2m19.8s, concurrency:5, task:146, construct:6.48s, fetch:1m57.1s, build:1.17s, 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:48:15 [2021-06-04T20:48:15.362Z]       ├─IndexHashJoin_83(Build)	9786202.08	3542799	root		time:1m22.6s, loops:3463, inner:{total:2m31s, concurrency:5, task:152, construct:7.85s, fetch:2m5.4s, build:1.21s, 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)	556.0 MB	N/A
20:48:15 [2021-06-04T20:48:15.362Z]       │ ├─IndexJoin_99(Build)	12232752.60	3675878	root		time:1m22s, loops:3595, inner:{total:2m9.1s, concurrency:5, task:305, construct:16.5s, fetch:1m50.7s, build:1.91s}, 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:48:15 [2021-06-04T20:48:15.362Z]       │ │ ├─HashJoin_107(Build)	12232752.60	7609895	root		time:1m21.6s, loops:7436, build_hash_table:{total:1.09s, fetch:1.08s, build:7.69ms}, probe:{concurrency:5, total:6m49.8s, max:1m22s, probe:1m1.6s, fetch:5m48.1s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.lineitem.l_suppkey)]	713.1 KB	0 Bytes
20:48:15 [2021-06-04T20:48:15.362Z]       │ │ │ ├─HashJoin_120(Build)	20000.00	20058	root		time:1.08s, loops:21, build_hash_table:{total:141.3µs, fetch:135.1µs, build:6.15µs}, probe:{concurrency:5, total:5.43s, max:1.09s, probe:66.3ms, fetch:5.37s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:48:15 [2021-06-04T20:48:15.362Z]       │ │ │ │ ├─TableReader_125(Build)	1.00	1	root		time:37.8µs, loops:2, cop_task: {num: 1, max: 1.03ms, proc_keys: 25, rpc_num: 1, rpc_time: 1.01ms, copr_cache: disabled}	data:Selection_124	234 Bytes	N/A
20:48:15 [2021-06-04T20:48:15.362Z]       │ │ │ │ │ └─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:48:15 [2021-06-04T20:48:15.362Z]       │ │ │ │ │   └─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-04T20:48:15.362Z]       │ │ │ │ └─TableReader_122(Probe)	500000.00	500000	root		time:1.07s, loops:490, cop_task: {num: 1, max: 1.07s, proc_keys: 500000, tot_proc: 1.04s, tot_wait: 1ms, rpc_num: 1, rpc_time: 1.07s, copr_cache: disabled}	data:TableFullScan_121	20.0 MB	N/A
20:48:15 [2021-06-04T20:48:15.362Z]       │ │ │ │   └─TableFullScan_121	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:979ms, loops:493}, scan_detail: {total_process_keys: 500000, total_keys: 500001, rocksdb: {delete_skipped_count: 0, key_skipped_count: 999999, block: {cache_hit_count: 14, read_count: 1678, read_byte: 104.5 MB}}}	keep order:false	N/A	N/A
20:48:15 [2021-06-04T20:48:15.362Z]       │ │ │ └─TableReader_128(Probe)	240004648.80	189670348	root		time:1m9.1s, loops:184596, cop_task: {num: 761, max: 3.11s, min: 339.4ms, avg: 1.58s, p95: 2.08s, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 18m46.3s, tot_wait: 59.5s, rpc_num: 761, rpc_time: 19m59.5s, copr_cache: disabled}	data:Selection_127	109.4 MB	N/A
20:48:15 [2021-06-04T20:48:15.362Z]       │ │ │   └─Selection_127	240004648.80	189670348	cop[tikv]		tikv_task:{proc max:1.43s, min:322ms, p80:1.24s, p95:1.32s, 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:48:15 [2021-06-04T20:48:15.362Z]       │ │ │     └─TableFullScan_126	300005811.00	300005811	cop[tikv]	table:l1	tikv_task:{proc max:1.31s, min:304ms, p80:1.15s, p95:1.23s, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:48:15 [2021-06-04T20:48:15.362Z]       │ │ └─TableReader_95(Probe)	0.49	3496188	root		time:1m42s, loops:3875, cop_task: {num: 5263, max: 575ms, min: 2.77ms, avg: 181.6ms, p95: 341.9ms, max_proc_keys: 3736, p95_proc_keys: 1952, tot_proc: 11m26.1s, tot_wait: 3m49s, rpc_num: 5263, rpc_time: 15m55.8s, copr_cache: disabled}	data:Selection_94	N/A	N/A
20:48:15 [2021-06-04T20:48:15.362Z]       │ │   └─Selection_94	0.49	3496188	cop[tikv]		tikv_task:{proc max:140ms, min:0s, p80:72ms, p95:86ms, iters:30262, tasks:5263}, scan_detail: {total_process_keys: 7236288, total_keys: 7795496, rocksdb: {delete_skipped_count: 0, key_skipped_count: 1778310, block: {cache_hit_count: 54006781, read_count: 218154, read_byte: 4.21 GB}}}	eq(tpch50.orders.o_orderstatus, "F")	N/A	N/A
20:48:15 [2021-06-04T20:48:15.362Z]       │ │     └─TableRangeScan_93	1.00	7236288	cop[tikv]	table:orders	tikv_task:{proc max:139ms, min:0s, p80:72ms, p95:85ms, iters:30262, tasks:5263}	range: decided by [tpch50.lineitem.l_orderkey], keep order:false	N/A	N/A
20:48:15 [2021-06-04T20:48:15.363Z]       │ └─IndexLookUp_80(Probe)	4.05	17316468	root		time:1m59.7s, loops:17125, index_task: {total_time: 1m5.9s, fetch_handle: 56.3s, build: 3.21ms, wait: 9.58s}, table_task: {total_time: 8m35.5s, num: 1458, concurrency: 760}		19.1 KB	N/A
20:48:15 [2021-06-04T20:48:15.363Z]       │   ├─IndexRangeScan_78(Build)	4.05	17316468	cop[tikv]	table:l2, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:54.1s, loops:18630, cop_task: {num: 2965, max: 676.9ms, min: 720.3µs, avg: 190.9ms, p95: 380.1ms, max_proc_keys: 12806, p95_proc_keys: 8821, tot_proc: 7m11s, tot_wait: 1m54.7s, rpc_num: 2965, rpc_time: 9m25.9s, copr_cache: disabled}, tikv_task:{proc max:169ms, min:0s, p80:100ms, p95:118ms, iters:30069, tasks:2965}, scan_detail: {total_process_keys: 17316468, total_keys: 20812571, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17316468, block: {cache_hit_count: 24259959, read_count: 225689, 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-04T20:48:15.363Z]       │   └─TableRowIDScan_79(Probe)	4.05	17316468	cop[tikv]	table:l2	time:6m25.2s, loops:21021, cop_task: {num: 7783, max: 675ms, min: 498.8µs, avg: 179.7ms, p95: 367.4ms, max_proc_keys: 12994, p95_proc_keys: 4825, tot_proc: 16m54.4s, tot_wait: 5m33.9s, rpc_num: 7783, rpc_time: 23m18.5s, copr_cache: disabled}, tikv_task:{proc max:258ms, min:0s, p80:106ms, p95:144ms, iters:49851, tasks:7783}, scan_detail: {total_process_keys: 17316468, total_keys: 18289695, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5629107, block: {cache_hit_count: 99022580, read_count: 1105, read_byte: 386.2 MB}}}	keep order:false	N/A	N/A
20:48:15 [2021-06-04T20:48:15.363Z]       └─IndexLookUp_39(Probe)	4.05	12022830	root		time:1m52.2s, loops:11939, index_task: {total_time: 1m1.5s, fetch_handle: 50.7s, build: 3.06ms, wait: 10.8s}, table_task: {total_time: 8m4s, num: 1408, concurrency: 730}		222.9 KB	N/A
20:48:15 [2021-06-04T20:48:15.363Z]         ├─IndexRangeScan_36(Build)	5.06	17183406	cop[tikv]	table:l3, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:48.4s, loops:18361, cop_task: {num: 2787, max: 685.3ms, min: 2.39ms, avg: 168.9ms, p95: 368.8ms, max_proc_keys: 19409, p95_proc_keys: 13593, tot_proc: 5m52.8s, tot_wait: 1m37.2s, rpc_num: 2787, rpc_time: 7m50.5s, copr_cache: disabled}, tikv_task:{proc max:188ms, min:0s, p80:80ms, p95:124ms, iters:29141, tasks:2787}, scan_detail: {total_process_keys: 17183406, total_keys: 20546434, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17183406, block: {cache_hit_count: 23554002, 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-04T20:48:15.363Z]         └─Selection_38(Probe)	4.05	12022830	cop[tikv]		time:6m12.6s, loops:13790, cop_task: {num: 10161, max: 659.1ms, min: 398.6µs, avg: 174.3ms, p95: 360.6ms, max_proc_keys: 6780, p95_proc_keys: 4023, tot_proc: 20m54.7s, tot_wait: 7m30.8s, rpc_num: 10161, rpc_time: 29m30.5s, copr_cache: disabled}, tikv_task:{proc max:292ms, min:0s, p80:79ms, p95:119ms, iters:60372, tasks:10161}, scan_detail: {total_process_keys: 17183406, total_keys: 18130420, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5533496, block: {cache_hit_count: 98281427, 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-04T20:48:15.363Z]           └─TableRowIDScan_37	5.06	17183406	cop[tikv]	table:l3	tikv_task:{proc max:291ms, min:0s, p80:78ms, p95:119ms, iters:60372, tasks:10161}	keep order:false	N/A	N/A
20:48:15 [2021-06-04T20:48:15.363Z] + sync
20:48:15 [2021-06-04T20:48:15.363Z] + /usr/bin/echo 3
20:49:36 [2021-06-04T20:49:36.737Z] 
20:49:36 [2021-06-04T20:49:36.737Z] queries/21.sql
20:49:36 [2021-06-04T20:49:36.737Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:49:36 [2021-06-04T20:49:36.737Z] Projection_26	100.00	100	root		time:1m20.5s, loops:2, Concurrency:OFF	tpch50.supplier.s_name, Column#72	4.62 KB	N/A
20:49:36 [2021-06-04T20:49:36.737Z] └─TopN_29	100.00	100	root		time:1m20.5s, loops:2	Column#72:desc, tpch50.supplier.s_name, offset:0, count:100	58.4 KB	N/A
20:49:36 [2021-06-04T20:49:36.737Z]   └─HashAgg_34	12800.00	20057	root		time:1m20.5s, loops:21, partial_worker:{wall_time:1m20.502788345s, concurrency:5, task_num:198, tot_wait:6m42.237074765s, tot_exec:263.21108ms, tot_time:6m42.512068005s, max:1m20.502771018s, p95:1m20.502771018s}, final_worker:{wall_time:1m20.516613107s, concurrency:5, task_num:25, tot_wait:6m42.51078571s, tot_exec:67.712882ms, tot_time:6m42.578510544s, max:1m20.516584056s, p95:1m20.516584056s}	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-04T20:49:36.737Z]     └─IndexHashJoin_42	7828961.66	198698	root		time:1m20.5s, loops:199, inner:{total:2m21s, concurrency:5, task:146, construct:6.41s, fetch:1m57.9s, build:1.27s, join:16.7s}	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-04T20:49:36.737Z]       ├─IndexHashJoin_83(Build)	9786202.08	3542799	root		time:1m20s, loops:3462, inner:{total:2m31.3s, concurrency:5, task:152, construct:7.88s, fetch:2m5.6s, build:1.23s, 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-04T20:49:36.737Z]       │ ├─IndexJoin_99(Build)	12232752.60	3675878	root		time:1m19.4s, loops:3595, inner:{total:2m8.9s, concurrency:5, task:305, construct:16.7s, fetch:1m50.4s, build:1.84s}, probe:5.01s	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-04T20:49:36.737Z]       │ │ ├─HashJoin_107(Build)	12232752.60	7609895	root		time:1m18.9s, loops:7437, build_hash_table:{total:1.05s, fetch:1.04s, build:6.97ms}, probe:{concurrency:5, total:6m36.3s, max:1m19.3s, probe:1m2.4s, fetch:5m33.9s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.lineitem.l_suppkey)]	752.5 KB	0 Bytes
20:49:36 [2021-06-04T20:49:36.737Z]       │ │ │ ├─HashJoin_120(Build)	20000.00	20058	root		time:1.05s, loops:23, build_hash_table:{total:181.1µs, fetch:175.7µs, build:5.45µs}, probe:{concurrency:5, total:5.25s, max:1.05s, probe:61.1ms, fetch:5.19s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:49:36 [2021-06-04T20:49:36.737Z]       │ │ │ │ ├─TableReader_125(Build)	1.00	1	root		time:42.2µs, loops:2, cop_task: {num: 1, max: 1.47ms, proc_keys: 25, rpc_num: 1, rpc_time: 1.44ms, copr_cache: disabled}	data:Selection_124	244 Bytes	N/A
20:49:36 [2021-06-04T20:49:36.737Z]       │ │ │ │ │ └─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:49:36 [2021-06-04T20:49:36.737Z]       │ │ │ │ │   └─TableFullScan_123	25.00	25	cop[tikv]	table:nation	tikv_task:{time:0s, loops:1}	keep order:false	N/A	N/A
20:49:36 [2021-06-04T20:49:36.737Z]       │ │ │ │ └─TableReader_122(Probe)	500000.00	500000	root		time:1.04s, loops:490, cop_task: {num: 1, max: 1.04s, proc_keys: 500000, tot_proc: 1s, tot_wait: 1ms, rpc_num: 1, rpc_time: 1.04s, copr_cache: disabled}	data:TableFullScan_121	20.0 MB	N/A
20:49:36 [2021-06-04T20:49:36.737Z]       │ │ │ │   └─TableFullScan_121	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:945ms, 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-04T20:49:36.737Z]       │ │ │ └─TableReader_128(Probe)	240004648.80	189670348	root		time:1m6.2s, loops:184596, cop_task: {num: 761, max: 2.57s, min: 242.1ms, avg: 1.52s, p95: 1.98s, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 18m2.1s, tot_wait: 1m1.4s, rpc_num: 761, rpc_time: 19m16.7s, copr_cache: disabled}	data:Selection_127	109.4 MB	N/A
20:49:36 [2021-06-04T20:49:36.737Z]       │ │ │   └─Selection_127	240004648.80	189670348	cop[tikv]		tikv_task:{proc max:1.32s, min:226ms, p80:1.17s, p95:1.22s, 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-04T20:49:36.737Z]       │ │ │     └─TableFullScan_126	300005811.00	300005811	cop[tikv]	table:l1	tikv_task:{proc max:1.24s, min:218ms, p80:1.09s, p95:1.13s, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:49:36 [2021-06-04T20:49:36.737Z]       │ │ └─TableReader_95(Probe)	0.49	3496167	root		time:1m41.5s, loops:3875, cop_task: {num: 5283, max: 625.7ms, min: 695.9µs, avg: 177.4ms, p95: 339.7ms, max_proc_keys: 3606, p95_proc_keys: 1948, tot_proc: 11m20.3s, tot_wait: 3m38.7s, rpc_num: 5283, rpc_time: 15m37.2s, copr_cache: disabled}	data:Selection_94	N/A	N/A
20:49:36 [2021-06-04T20:49:36.737Z]       │ │   └─Selection_94	0.49	3496167	cop[tikv]		tikv_task:{proc max:172ms, min:0s, p80:68ms, p95:81ms, iters:30247, tasks:5283}, scan_detail: {total_process_keys: 7236258, total_keys: 7795494, rocksdb: {delete_skipped_count: 0, key_skipped_count: 1778384, block: {cache_hit_count: 54006186, read_count: 218207, read_byte: 4.21 GB}}}	eq(tpch50.orders.o_orderstatus, "F")	N/A	N/A
20:49:36 [2021-06-04T20:49:36.737Z]       │ │     └─TableRangeScan_93	1.00	7236258	cop[tikv]	table:orders	tikv_task:{proc max:172ms, min:0s, p80:68ms, p95:81ms, iters:30247, tasks:5283}	range: decided by [tpch50.lineitem.l_orderkey], keep order:false	N/A	N/A
20:49:36 [2021-06-04T20:49:36.737Z]       │ └─IndexLookUp_80(Probe)	4.05	17316422	root		time:1m59.9s, loops:17124, index_task: {total_time: 1m5.7s, fetch_handle: 57.8s, build: 3.24ms, wait: 7.96s}, table_task: {total_time: 8m34.7s, num: 1458, concurrency: 760}		19.2 KB	N/A
20:49:36 [2021-06-04T20:49:36.737Z]       │   ├─IndexRangeScan_78(Build)	4.05	17316422	cop[tikv]	table:l2, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:55.5s, loops:18644, cop_task: {num: 2994, max: 694.3ms, min: 472.9µs, avg: 195ms, p95: 383.7ms, max_proc_keys: 13438, p95_proc_keys: 8711, tot_proc: 7m15.8s, tot_wait: 2m7.9s, rpc_num: 2994, rpc_time: 9m43.8s, copr_cache: disabled}, tikv_task:{proc max:192ms, min:0s, p80:95ms, p95:110ms, iters:30154, tasks:2994}, scan_detail: {total_process_keys: 17316422, total_keys: 20812517, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17316422, block: {cache_hit_count: 24259909, 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-04T20:49:36.737Z]       │   └─TableRowIDScan_79(Probe)	4.05	17316422	cop[tikv]	table:l2	time:6m19s, loops:21046, cop_task: {num: 7838, max: 587.9ms, min: 400.3µs, avg: 175.6ms, p95: 354.3ms, max_proc_keys: 12919, p95_proc_keys: 4840, tot_proc: 16m28.8s, tot_wait: 5m36.6s, rpc_num: 7838, rpc_time: 22m56.1s, copr_cache: disabled}, tikv_task:{proc max:232ms, min:0s, p80:104ms, p95:138ms, iters:50030, tasks:7838}, scan_detail: {total_process_keys: 17316422, total_keys: 18288570, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5625844, block: {cache_hit_count: 99021279, read_count: 1102, read_byte: 385.6 MB}}}	keep order:false	N/A	N/A
20:49:36 [2021-06-04T20:49:36.737Z]       └─IndexLookUp_39(Probe)	4.05	12022773	root		time:1m53.1s, loops:11949, index_task: {total_time: 1m0.4s, fetch_handle: 50.1s, build: 3.68ms, wait: 10.2s}, table_task: {total_time: 8m7.7s, num: 1408, concurrency: 730}		267.2 KB	N/A
20:49:36 [2021-06-04T20:49:36.737Z]         ├─IndexRangeScan_36(Build)	5.06	17183359	cop[tikv]	table:l3, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:47.8s, loops:18350, cop_task: {num: 2781, max: 841ms, min: 912.3µs, avg: 171.3ms, p95: 352.8ms, max_proc_keys: 19686, p95_proc_keys: 13740, tot_proc: 5m52s, tot_wait: 1m45.1s, rpc_num: 2781, rpc_time: 7m56.4s, copr_cache: disabled}, tikv_task:{proc max:178ms, min:0s, p80:79ms, p95:123ms, iters:29094, tasks:2781}, scan_detail: {total_process_keys: 17183359, total_keys: 20546378, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17183359, block: {cache_hit_count: 23553939, 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-04T20:49:36.737Z]         └─Selection_38(Probe)	4.05	12022773	cop[tikv]		time:6m13.3s, loops:13798, cop_task: {num: 10279, max: 606.5ms, min: 520.3µs, avg: 173.1ms, p95: 351.5ms, max_proc_keys: 7909, p95_proc_keys: 3962, tot_proc: 20m59.1s, tot_wait: 7m35.6s, rpc_num: 10279, rpc_time: 29m38.9s, copr_cache: disabled}, tikv_task:{proc max:239ms, min:0s, p80:76ms, p95:116ms, iters:60799, tasks:10279}, scan_detail: {total_process_keys: 17183359, total_keys: 18128500, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5523545, block: {cache_hit_count: 98296265, 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-04T20:49:36.737Z]           └─TableRowIDScan_37	5.06	17183359	cop[tikv]	table:l3	tikv_task:{proc max:238ms, min:0s, p80:76ms, p95:115ms, iters:60799, tasks:10279}	keep order:false	N/A	N/A
20:49:36 [2021-06-04T20:49:36.737Z] + sync
20:49:36 [2021-06-04T20:49:36.737Z] + /usr/bin/echo 3
20:51:13 [2021-06-04T20:51:13.116Z] 
20:51:13 [2021-06-04T20:51:13.116Z] queries/21.sql
20:51:13 [2021-06-04T20:51:13.116Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:51:13 [2021-06-04T20:51:13.116Z] Projection_26	100.00	100	root		time:1m20.5s, loops:2, Concurrency:OFF	tpch50.supplier.s_name, Column#72	4.62 KB	N/A
20:51:13 [2021-06-04T20:51:13.116Z] └─TopN_29	100.00	100	root		time:1m20.5s, loops:2	Column#72:desc, tpch50.supplier.s_name, offset:0, count:100	58.4 KB	N/A
20:51:13 [2021-06-04T20:51:13.116Z]   └─HashAgg_34	12800.00	20057	root		time:1m20.5s, loops:21, partial_worker:{wall_time:1m20.471732954s, concurrency:5, task_num:196, tot_wait:6m42.077408621s, tot_exec:264.995339ms, tot_time:6m42.356075489s, max:1m20.471692472s, p95:1m20.471692472s}, final_worker:{wall_time:1m20.487173079s, concurrency:5, task_num:25, tot_wait:6m42.35374068s, tot_exec:73.76771ms, tot_time:6m42.427521293s, max:1m20.487142659s, p95:1m20.487142659s}	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-04T20:51:13.116Z]     └─IndexHashJoin_42	7828961.66	198698	root		time:1m20.5s, loops:197, inner:{total:2m20.6s, concurrency:5, task:146, construct:6.45s, fetch:1m57.7s, build:1.15s, 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:51:13 [2021-06-04T20:51:13.116Z]       ├─IndexHashJoin_83(Build)	9786202.08	3542799	root		time:1m19.9s, loops:3463, inner:{total:2m28.2s, concurrency:5, task:152, construct:7.72s, fetch:2m3.1s, build:1.29s, 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:51:13 [2021-06-04T20:51:13.116Z]       │ ├─IndexJoin_99(Build)	12232752.60	3675878	root		time:1m19.4s, loops:3595, inner:{total:2m6.6s, concurrency:5, task:305, construct:15.9s, fetch:1m48.9s, build:1.85s}, 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.3 MB	N/A
20:51:13 [2021-06-04T20:51:13.116Z]       │ │ ├─HashJoin_107(Build)	12232752.60	7609895	root		time:1m18.9s, loops:7436, build_hash_table:{total:1.14s, fetch:1.13s, build:6.38ms}, probe:{concurrency:5, total:6m36.5s, max:1m19.3s, probe:1m0.8s, fetch:5m35.7s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.lineitem.l_suppkey)]	762.0 KB	0 Bytes
20:51:13 [2021-06-04T20:51:13.116Z]       │ │ │ ├─HashJoin_120(Build)	20000.00	20058	root		time:1.13s, loops:23, build_hash_table:{total:146.2µs, fetch:140.8µs, build:5.39µs}, probe:{concurrency:5, total:5.67s, max:1.13s, probe:62.8ms, fetch:5.61s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:51:13 [2021-06-04T20:51:13.116Z]       │ │ │ │ ├─TableReader_125(Build)	1.00	1	root		time:32.3µs, loops:2, cop_task: {num: 1, max: 1.12ms, proc_keys: 25, tot_proc: 1ms, rpc_num: 1, rpc_time: 1.09ms, copr_cache: disabled}	data:Selection_124	248 Bytes	N/A
20:51:13 [2021-06-04T20:51:13.116Z]       │ │ │ │ │ └─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-04T20:51:13.116Z]       │ │ │ │ │   └─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-04T20:51:13.116Z]       │ │ │ │ └─TableReader_122(Probe)	500000.00	500000	root		time:1.12s, loops:490, cop_task: {num: 1, max: 1.12s, proc_keys: 500000, tot_proc: 1.09s, rpc_num: 1, rpc_time: 1.12s, copr_cache: disabled}	data:TableFullScan_121	20.0 MB	N/A
20:51:13 [2021-06-04T20:51:13.116Z]       │ │ │ │   └─TableFullScan_121	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:1.02s, 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-04T20:51:13.116Z]       │ │ │ └─TableReader_128(Probe)	240004648.80	189670348	root		time:1m6.6s, loops:184595, cop_task: {num: 761, max: 2.61s, min: 388.6ms, avg: 1.52s, p95: 1.99s, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 18m4.3s, tot_wait: 1m0.8s, rpc_num: 761, rpc_time: 19m18.5s, copr_cache: disabled}	data:Selection_127	109.4 MB	N/A
20:51:13 [2021-06-04T20:51:13.116Z]       │ │ │   └─Selection_127	240004648.80	189670348	cop[tikv]		tikv_task:{proc max:1.28s, min:371ms, p80:1.18s, p95:1.22s, 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: 10459, read_count: 1114189, read_byte: 23.6 GB}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:51:13 [2021-06-04T20:51:13.116Z]       │ │ │     └─TableFullScan_126	300005811.00	300005811	cop[tikv]	table:l1	tikv_task:{proc max:1.21s, min:343ms, p80:1.09s, p95:1.14s, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:51:13 [2021-06-04T20:51:13.116Z]       │ │ └─TableReader_95(Probe)	0.49	3496183	root		time:1m40s, loops:3875, cop_task: {num: 5275, max: 566.9ms, min: 1.99ms, avg: 178.7ms, p95: 344.3ms, max_proc_keys: 3672, p95_proc_keys: 1968, tot_proc: 11m20.7s, tot_wait: 3m43.6s, rpc_num: 5275, rpc_time: 15m42.5s, copr_cache: disabled}	data:Selection_94	N/A	N/A
20:51:13 [2021-06-04T20:51:13.116Z]       │ │   └─Selection_94	0.49	3496183	cop[tikv]		tikv_task:{proc max:149ms, min:0s, p80:69ms, p95:82ms, iters:30322, tasks:5275}, scan_detail: {total_process_keys: 7236276, total_keys: 7795494, rocksdb: {delete_skipped_count: 0, key_skipped_count: 1778340, block: {cache_hit_count: 54006478, read_count: 218218, read_byte: 4.21 GB}}}	eq(tpch50.orders.o_orderstatus, "F")	N/A	N/A
20:51:13 [2021-06-04T20:51:13.116Z]       │ │     └─TableRangeScan_93	1.00	7236276	cop[tikv]	table:orders	tikv_task:{proc max:148ms, min:0s, p80:69ms, p95:82ms, iters:30322, tasks:5275}	range: decided by [tpch50.lineitem.l_orderkey], keep order:false	N/A	N/A
20:51:13 [2021-06-04T20:51:13.116Z]       │ └─IndexLookUp_80(Probe)	4.05	17316510	root		time:1m57.7s, loops:17132, index_task: {total_time: 1m4.7s, fetch_handle: 56.5s, build: 3.08ms, wait: 8.18s}, table_task: {total_time: 8m29.5s, num: 1458, concurrency: 760}		19.0 KB	N/A
20:51:13 [2021-06-04T20:51:13.116Z]       │   ├─IndexRangeScan_78(Build)	4.05	17316510	cop[tikv]	table:l2, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:54.2s, loops:18594, cop_task: {num: 2999, max: 792.7ms, min: 453.2µs, avg: 188.2ms, p95: 372ms, max_proc_keys: 12913, p95_proc_keys: 8740, tot_proc: 7m6s, tot_wait: 1m57.7s, rpc_num: 2999, rpc_time: 9m24.3s, copr_cache: disabled}, tikv_task:{proc max:177ms, min:0s, p80:95ms, p95:108ms, iters:30197, tasks:2999}, scan_detail: {total_process_keys: 17316510, total_keys: 20812621, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17316510, block: {cache_hit_count: 24260029, read_count: 225676, 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-04T20:51:13.116Z]       │   └─TableRowIDScan_79(Probe)	4.05	17316510	cop[tikv]	table:l2	time:6m18.8s, loops:20963, cop_task: {num: 7842, max: 616.5ms, min: 529.1µs, avg: 176.5ms, p95: 360.9ms, max_proc_keys: 12685, p95_proc_keys: 4808, tot_proc: 16m35s, tot_wait: 5m38.4s, rpc_num: 7842, rpc_time: 23m4.2s, copr_cache: disabled}, tikv_task:{proc max:285ms, min:0s, p80:104ms, p95:139ms, iters:50061, tasks:7842}, scan_detail: {total_process_keys: 17316510, total_keys: 18289432, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5627672, block: {cache_hit_count: 99024242, read_count: 1115, read_byte: 398.5 MB}}}	keep order:false	N/A	N/A
20:51:13 [2021-06-04T20:51:13.116Z]       └─IndexLookUp_39(Probe)	4.05	12022858	root		time:1m52.7s, loops:11945, index_task: {total_time: 1m0.8s, fetch_handle: 50.1s, build: 2.98ms, wait: 10.7s}, table_task: {total_time: 8m6.2s, num: 1408, concurrency: 730}		270.5 KB	N/A
20:51:13 [2021-06-04T20:51:13.116Z]         ├─IndexRangeScan_36(Build)	5.06	17183453	cop[tikv]	table:l3, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:47.8s, loops:18362, cop_task: {num: 2785, max: 849.6ms, min: 431.5µs, avg: 170.7ms, p95: 366.4ms, max_proc_keys: 17882, p95_proc_keys: 13560, tot_proc: 5m50.8s, tot_wait: 1m44.8s, rpc_num: 2785, rpc_time: 7m55.3s, copr_cache: disabled}, tikv_task:{proc max:173ms, min:0s, p80:78ms, p95:121ms, iters:29148, tasks:2785}, scan_detail: {total_process_keys: 17183453, total_keys: 20546489, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17183453, block: {cache_hit_count: 23554059, 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-04T20:51:13.116Z]         └─Selection_38(Probe)	4.05	12022858	cop[tikv]		time:6m12.2s, loops:13762, cop_task: {num: 10159, max: 644.8ms, min: 456µs, avg: 172.6ms, p95: 353ms, max_proc_keys: 7940, p95_proc_keys: 3924, tot_proc: 20m38.6s, tot_wait: 7m29.3s, rpc_num: 10159, rpc_time: 29m13.2s, copr_cache: disabled}, tikv_task:{proc max:218ms, min:0s, p80:77ms, p95:116ms, iters:60339, tasks:10159}, scan_detail: {total_process_keys: 17183453, total_keys: 18129545, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5529364, block: {cache_hit_count: 98284166, 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-04T20:51:13.116Z]           └─TableRowIDScan_37	5.06	17183453	cop[tikv]	table:l3	tikv_task:{proc max:218ms, min:0s, p80:77ms, p95:115ms, iters:60339, tasks:10159}	keep order:false	N/A	N/A
20:51:13 [2021-06-04T20:51:13.116Z] + sync
20:51:13 [2021-06-04T20:51:13.116Z] + /usr/bin/echo 3
20:52:34 [2021-06-04T20:52:34.486Z] 
20:52:34 [2021-06-04T20:52:34.486Z] queries/21.sql
20:52:34 [2021-06-04T20:52:34.486Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:52:34 [2021-06-04T20:52:34.486Z] Projection_26	100.00	100	root		time:1m20.5s, loops:2, Concurrency:OFF	tpch50.supplier.s_name, Column#72	4.62 KB	N/A
20:52:34 [2021-06-04T20:52:34.486Z] └─TopN_29	100.00	100	root		time:1m20.5s, loops:2	Column#72:desc, tpch50.supplier.s_name, offset:0, count:100	58.4 KB	N/A
20:52:34 [2021-06-04T20:52:34.486Z]   └─HashAgg_34	12800.00	20057	root		time:1m20.5s, loops:21, partial_worker:{wall_time:1m20.505267325s, concurrency:5, task_num:197, tot_wait:6m42.271810128s, tot_exec:241.131971ms, tot_time:6m42.524799509s, max:1m20.505239589s, p95:1m20.505239589s}, final_worker:{wall_time:1m20.518663362s, concurrency:5, task_num:25, tot_wait:6m42.523227334s, tot_exec:68.798937ms, tot_time:6m42.592038784s, max:1m20.518642754s, p95:1m20.518642754s}	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-04T20:52:34.486Z]     └─IndexHashJoin_42	7828961.66	198698	root		time:1m20.5s, loops:198, inner:{total:2m19.3s, concurrency:5, task:147, construct:6.58s, fetch:1m56.1s, build:1.16s, 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:52:34 [2021-06-04T20:52:34.486Z]       ├─IndexHashJoin_83(Build)	9786202.08	3542799	root		time:1m19.9s, loops:3463, inner:{total:2m26.8s, concurrency:5, task:152, construct:7.81s, fetch:2m1.4s, build:1.3s, 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-04T20:52:34.486Z]       │ ├─IndexJoin_99(Build)	12232752.60	3675878	root		time:1m19.5s, loops:3595, inner:{total:2m4.7s, concurrency:5, task:305, construct:16s, fetch:1m46.8s, build:1.85s}, probe:5.01s	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:52:34 [2021-06-04T20:52:34.486Z]       │ │ ├─HashJoin_107(Build)	12232752.60	7609895	root		time:1m19s, loops:7437, build_hash_table:{total:1.14s, fetch:1.13s, build:6.2ms}, probe:{concurrency:5, total:6m36.8s, max:1m19.4s, probe:1m1.2s, fetch:5m35.7s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.lineitem.l_suppkey)]	762.0 KB	0 Bytes
20:52:34 [2021-06-04T20:52:34.486Z]       │ │ │ ├─HashJoin_120(Build)	20000.00	20058	root		time:1.13s, loops:23, build_hash_table:{total:2.61ms, fetch:2.61ms, build:5.31µs}, probe:{concurrency:5, total:5.67s, max:1.13s, probe:58.3ms, fetch:5.61s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:52:34 [2021-06-04T20:52:34.486Z]       │ │ │ │ ├─TableReader_125(Build)	1.00	1	root		time:2.52ms, loops:2, cop_task: {num: 1, max: 4.54ms, proc_keys: 25, tot_proc: 1ms, rpc_num: 1, rpc_time: 4.52ms, copr_cache: disabled}	data:Selection_124	242 Bytes	N/A
20:52:34 [2021-06-04T20:52:34.486Z]       │ │ │ │ │ └─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: 18, read_count: 0, read_byte: 0 Bytes}}}	eq(tpch50.nation.n_name, "EGYPT")	N/A	N/A
20:52:34 [2021-06-04T20:52:34.486Z]       │ │ │ │ │   └─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-04T20:52:34.486Z]       │ │ │ │ └─TableReader_122(Probe)	500000.00	500000	root		time:1.12s, loops:490, cop_task: {num: 1, max: 1.12s, proc_keys: 500000, tot_proc: 1.09s, rpc_num: 1, rpc_time: 1.12s, copr_cache: disabled}	data:TableFullScan_121	20.0 MB	N/A
20:52:34 [2021-06-04T20:52:34.486Z]       │ │ │ │   └─TableFullScan_121	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:1.03s, loops:493}, scan_detail: {total_process_keys: 500000, total_keys: 500001, rocksdb: {delete_skipped_count: 0, key_skipped_count: 999999, block: {cache_hit_count: 12, read_count: 1680, read_byte: 104.5 MB}}}	keep order:false	N/A	N/A
20:52:34 [2021-06-04T20:52:34.486Z]       │ │ │ └─TableReader_128(Probe)	240004648.80	189670348	root		time:1m6.3s, loops:184598, cop_task: {num: 761, max: 2.66s, min: 267.6ms, avg: 1.52s, p95: 2s, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 18m5.3s, tot_wait: 59.3s, rpc_num: 761, rpc_time: 19m18s, copr_cache: disabled}	data:Selection_127	109.4 MB	N/A
20:52:34 [2021-06-04T20:52:34.486Z]       │ │ │   └─Selection_127	240004648.80	189670348	cop[tikv]		tikv_task:{proc max:1.33s, min:248ms, p80:1.18s, p95:1.22s, 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: 10456, read_count: 1114192, read_byte: 23.6 GB}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:52:34 [2021-06-04T20:52:34.486Z]       │ │ │     └─TableFullScan_126	300005811.00	300005811	cop[tikv]	table:l1	tikv_task:{proc max:1.24s, min:227ms, p80:1.09s, p95:1.13s, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:52:34 [2021-06-04T20:52:34.486Z]       │ │ └─TableReader_95(Probe)	0.49	3496172	root		time:1m38.3s, loops:3875, cop_task: {num: 5269, max: 554.5ms, min: 2ms, avg: 173.6ms, p95: 329.9ms, max_proc_keys: 3555, p95_proc_keys: 1958, tot_proc: 10m57.4s, tot_wait: 3m38.4s, rpc_num: 5269, rpc_time: 15m14.7s, copr_cache: disabled}	data:Selection_94	N/A	N/A
20:52:34 [2021-06-04T20:52:34.486Z]       │ │   └─Selection_94	0.49	3496172	cop[tikv]		tikv_task:{proc max:146ms, min:0s, p80:69ms, p95:82ms, iters:30285, tasks:5269}, scan_detail: {total_process_keys: 7236264, total_keys: 7795469, rocksdb: {delete_skipped_count: 0, key_skipped_count: 1778253, block: {cache_hit_count: 54006502, read_count: 218199, read_byte: 4.21 GB}}}	eq(tpch50.orders.o_orderstatus, "F")	N/A	N/A
20:52:34 [2021-06-04T20:52:34.486Z]       │ │     └─TableRangeScan_93	1.00	7236264	cop[tikv]	table:orders	tikv_task:{proc max:146ms, min:0s, p80:69ms, p95:82ms, iters:30285, tasks:5269}	range: decided by [tpch50.lineitem.l_orderkey], keep order:false	N/A	N/A
20:52:34 [2021-06-04T20:52:34.486Z]       │ └─IndexLookUp_80(Probe)	4.05	17316450	root		time:1m56.1s, loops:17129, index_task: {total_time: 1m4.2s, fetch_handle: 55.3s, build: 3.08ms, wait: 8.84s}, table_task: {total_time: 8m20.2s, num: 1458, concurrency: 760}		19.2 KB	N/A
20:52:34 [2021-06-04T20:52:34.486Z]       │   ├─IndexRangeScan_78(Build)	4.05	17316450	cop[tikv]	table:l2, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:53s, loops:18593, cop_task: {num: 2982, max: 651ms, min: 614µs, avg: 185.2ms, p95: 367.9ms, max_proc_keys: 12953, p95_proc_keys: 8820, tot_proc: 6m56.9s, tot_wait: 1m53.9s, rpc_num: 2982, rpc_time: 9m12.1s, copr_cache: disabled}, tikv_task:{proc max:155ms, min:0s, p80:96ms, p95:110ms, iters:30096, tasks:2982}, scan_detail: {total_process_keys: 17316450, total_keys: 20812550, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17316450, block: {cache_hit_count: 24259936, read_count: 225691, 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-04T20:52:34.486Z]       │   └─TableRowIDScan_79(Probe)	4.05	17316450	cop[tikv]	table:l2	time:6m11.1s, loops:20977, cop_task: {num: 7840, max: 705.8ms, min: 454.6µs, avg: 173.5ms, p95: 350.6ms, max_proc_keys: 11263, p95_proc_keys: 4824, tot_proc: 16m17.1s, tot_wait: 5m32s, rpc_num: 7840, rpc_time: 22m40.1s, copr_cache: disabled}, tikv_task:{proc max:243ms, min:0s, p80:103ms, p95:137ms, iters:50039, tasks:7840}, scan_detail: {total_process_keys: 17316450, total_keys: 18288842, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5628404, block: {cache_hit_count: 99016482, read_count: 1112, read_byte: 397.4 MB}}}	keep order:false	N/A	N/A
20:52:34 [2021-06-04T20:52:34.486Z]       └─IndexLookUp_39(Probe)	4.05	12022821	root		time:1m51.3s, loops:11950, index_task: {total_time: 59.6s, fetch_handle: 49.8s, build: 17.7ms, wait: 9.81s}, table_task: {total_time: 7m56.5s, num: 1410, concurrency: 735}		270 KB	N/A
20:52:34 [2021-06-04T20:52:34.486Z]         ├─IndexRangeScan_36(Build)	5.06	17183427	cop[tikv]	table:l3, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:47.4s, loops:18364, cop_task: {num: 2772, max: 806.4ms, min: 1.27ms, avg: 166.2ms, p95: 362.8ms, max_proc_keys: 17617, p95_proc_keys: 13776, tot_proc: 5m43.4s, tot_wait: 1m37.4s, rpc_num: 2772, rpc_time: 7m40.6s, copr_cache: disabled}, tikv_task:{proc max:173ms, min:0s, p80:78ms, p95:119ms, iters:29020, tasks:2772}, scan_detail: {total_process_keys: 17183427, total_keys: 20546460, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17183427, block: {cache_hit_count: 23554037, 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-04T20:52:34.486Z]         └─Selection_38(Probe)	4.05	12022821	cop[tikv]		time:6m4.4s, loops:13784, cop_task: {num: 10156, max: 572.3ms, min: 646.2µs, avg: 169.4ms, p95: 344.7ms, max_proc_keys: 7490, p95_proc_keys: 3977, tot_proc: 20m17.2s, tot_wait: 7m19.3s, rpc_num: 10156, rpc_time: 28m40.6s, copr_cache: disabled}, tikv_task:{proc max:207ms, min:0s, p80:77ms, p95:116ms, iters:60324, tasks:10156}, scan_detail: {total_process_keys: 17183427, total_keys: 18129506, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5526981, block: {cache_hit_count: 98291158, 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-04T20:52:34.486Z]           └─TableRowIDScan_37	5.06	17183427	cop[tikv]	table:l3	tikv_task:{proc max:203ms, min:0s, p80:76ms, p95:115ms, iters:60324, tasks:10156}	keep order:false	N/A	N/A
20:52:34 [2021-06-04T20:52:34.486Z] + sync
20:52:34 [2021-06-04T20:52:34.486Z] + /usr/bin/echo 3
20:53:55 [2021-06-04T20:53:55.894Z] 
20:53:55 [2021-06-04T20:53:55.894Z] queries/21.sql
20:53:55 [2021-06-04T20:53:55.894Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:53:55 [2021-06-04T20:53:55.894Z] Projection_26	100.00	100	root		time:1m20.5s, loops:2, Concurrency:OFF	tpch50.supplier.s_name, Column#72	4.62 KB	N/A
20:53:55 [2021-06-04T20:53:55.894Z] └─TopN_29	100.00	100	root		time:1m20.5s, loops:2	Column#72:desc, tpch50.supplier.s_name, offset:0, count:100	58.4 KB	N/A
20:53:55 [2021-06-04T20:53:55.894Z]   └─HashAgg_34	12800.00	20057	root		time:1m20.5s, loops:21, partial_worker:{wall_time:1m20.493623085s, concurrency:5, task_num:197, tot_wait:6m42.220987907s, tot_exec:234.743445ms, tot_time:6m42.467238385s, max:1m20.493603699s, p95:1m20.493603699s}, final_worker:{wall_time:1m20.50948202s, concurrency:5, task_num:25, tot_wait:6m42.466643936s, tot_exec:71.12747ms, tot_time:6m42.537784711s, max:1m20.509444514s, p95:1m20.509444514s}	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:55 [2021-06-04T20:53:55.894Z]     └─IndexHashJoin_42	7828961.66	198698	root		time:1m20.5s, loops:198, inner:{total:2m19.5s, concurrency:5, task:146, construct:6.18s, fetch:1m57s, build:1.14s, 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:55 [2021-06-04T20:53:55.894Z]       ├─IndexHashJoin_83(Build)	9786202.08	3542799	root		time:1m20s, loops:3463, inner:{total:2m27.4s, concurrency:5, task:152, construct:7.47s, fetch:2m2.8s, build:1.26s, join:17.2s}	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:55 [2021-06-04T20:53:55.895Z]       │ ├─IndexJoin_99(Build)	12232752.60	3675878	root		time:1m19.5s, loops:3595, inner:{total:2m5.6s, concurrency:5, task:305, construct:16.2s, fetch:1m47.6s, build:1.82s}, probe:5.11s	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:53:55 [2021-06-04T20:53:55.895Z]       │ │ ├─HashJoin_107(Build)	12232752.60	7609895	root		time:1m18.9s, loops:7436, build_hash_table:{total:963.9ms, fetch:957.6ms, build:6.32ms}, probe:{concurrency:5, total:6m36.3s, max:1m19.3s, probe:1m1.1s, fetch:5m35.2s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.lineitem.l_suppkey)]	757.3 KB	0 Bytes
20:53:55 [2021-06-04T20:53:55.895Z]       │ │ │ ├─HashJoin_120(Build)	20000.00	20058	root		time:962.1ms, loops:23, build_hash_table:{total:152.2µs, fetch:146.8µs, build:5.45µs}, probe:{concurrency:5, total:4.81s, max:962.4ms, probe:59.2ms, fetch:4.75s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:53:55 [2021-06-04T20:53:55.895Z]       │ │ │ │ ├─TableReader_125(Build)	1.00	1	root		time:47.8µs, loops:2, cop_task: {num: 1, max: 1.31ms, proc_keys: 25, tot_proc: 1ms, rpc_num: 1, rpc_time: 1.27ms, copr_cache: disabled}	data:Selection_124	248 Bytes	N/A
20:53:55 [2021-06-04T20:53:55.895Z]       │ │ │ │ │ └─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:53:55 [2021-06-04T20:53:55.895Z]       │ │ │ │ │   └─TableFullScan_123	25.00	25	cop[tikv]	table:nation	tikv_task:{time:1ms, loops:1}	keep order:false	N/A	N/A
20:53:55 [2021-06-04T20:53:55.895Z]       │ │ │ │ └─TableReader_122(Probe)	500000.00	500000	root		time:950.4ms, loops:490, cop_task: {num: 1, max: 951.3ms, proc_keys: 500000, tot_proc: 920ms, rpc_num: 1, rpc_time: 951.3ms, copr_cache: disabled}	data:TableFullScan_121	20.0 MB	N/A
20:53:55 [2021-06-04T20:53:55.895Z]       │ │ │ │   └─TableFullScan_121	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:850ms, 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:55 [2021-06-04T20:53:55.895Z]       │ │ │ └─TableReader_128(Probe)	240004648.80	189670348	root		time:1m6.6s, loops:184596, cop_task: {num: 761, max: 2.88s, min: 281.1ms, avg: 1.52s, p95: 1.99s, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 18m9.8s, tot_wait: 57.1s, rpc_num: 761, rpc_time: 19m19.8s, copr_cache: disabled}	data:Selection_127	109.4 MB	N/A
20:53:55 [2021-06-04T20:53:55.895Z]       │ │ │   └─Selection_127	240004648.80	189670348	cop[tikv]		tikv_task:{proc max:1.27s, min:265ms, p80:1.17s, p95:1.21s, 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: 10458, read_count: 1114190, read_byte: 23.6 GB}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:53:55 [2021-06-04T20:53:55.895Z]       │ │ │     └─TableFullScan_126	300005811.00	300005811	cop[tikv]	table:l1	tikv_task:{proc max:1.19s, min:248ms, p80:1.09s, p95:1.12s, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:53:55 [2021-06-04T20:53:55.895Z]       │ │ └─TableReader_95(Probe)	0.49	3496199	root		time:1m38.8s, loops:3875, cop_task: {num: 5256, max: 499.4ms, min: 2.59ms, avg: 175.9ms, p95: 340.7ms, max_proc_keys: 3818, p95_proc_keys: 1976, tot_proc: 11m8s, tot_wait: 3m37.7s, rpc_num: 5256, rpc_time: 15m24.2s, copr_cache: disabled}	data:Selection_94	N/A	N/A
20:53:55 [2021-06-04T20:53:55.895Z]       │ │   └─Selection_94	0.49	3496199	cop[tikv]		tikv_task:{proc max:142ms, min:0s, p80:69ms, p95:81ms, iters:30232, tasks:5256}, scan_detail: {total_process_keys: 7236302, total_keys: 7795526, rocksdb: {delete_skipped_count: 0, key_skipped_count: 1778308, block: {cache_hit_count: 54008747, read_count: 216270, read_byte: 4.17 GB}}}	eq(tpch50.orders.o_orderstatus, "F")	N/A	N/A
20:53:55 [2021-06-04T20:53:55.895Z]       │ │     └─TableRangeScan_93	1.00	7236302	cop[tikv]	table:orders	tikv_task:{proc max:141ms, min:0s, p80:69ms, p95:81ms, iters:30232, tasks:5256}	range: decided by [tpch50.lineitem.l_orderkey], keep order:false	N/A	N/A
20:53:55 [2021-06-04T20:53:55.895Z]       │ └─IndexLookUp_80(Probe)	4.05	17316506	root		time:1m57.5s, loops:17128, index_task: {total_time: 1m4.5s, fetch_handle: 55s, build: 3.01ms, wait: 9.41s}, table_task: {total_time: 8m30.8s, num: 1458, concurrency: 760}		19.0 KB	N/A
20:53:55 [2021-06-04T20:53:55.895Z]       │   ├─IndexRangeScan_78(Build)	4.05	17316506	cop[tikv]	table:l2, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:52.8s, loops:18617, cop_task: {num: 3011, max: 733.4ms, min: 614.1µs, avg: 187.3ms, p95: 376.4ms, max_proc_keys: 13063, p95_proc_keys: 8733, tot_proc: 7m5.6s, tot_wait: 1m57.3s, rpc_num: 3011, rpc_time: 9m23.8s, copr_cache: disabled}, tikv_task:{proc max:167ms, min:0s, p80:95ms, p95:111ms, iters:30188, tasks:3011}, scan_detail: {total_process_keys: 17316506, total_keys: 20812618, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17316506, block: {cache_hit_count: 24260029, 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:53:55 [2021-06-04T20:53:55.895Z]       │   └─TableRowIDScan_79(Probe)	4.05	17316506	cop[tikv]	table:l2	time:6m19.9s, loops:20994, cop_task: {num: 7764, max: 591.5ms, min: 492.5µs, avg: 180ms, p95: 362.3ms, max_proc_keys: 12128, p95_proc_keys: 4805, tot_proc: 16m44.8s, tot_wait: 5m42.8s, rpc_num: 7764, rpc_time: 23m17s, copr_cache: disabled}, tikv_task:{proc max:237ms, min:0s, p80:104ms, p95:140ms, iters:49798, tasks:7764}, scan_detail: {total_process_keys: 17316506, total_keys: 18290243, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5631055, block: {cache_hit_count: 99019288, read_count: 1110, read_byte: 392.9 MB}}}	keep order:false	N/A	N/A
20:53:55 [2021-06-04T20:53:55.895Z]       └─IndexLookUp_39(Probe)	4.05	12022834	root		time:1m52.2s, loops:11945, index_task: {total_time: 1m0.4s, fetch_handle: 49.2s, build: 4.1ms, wait: 11.2s}, table_task: {total_time: 8m5.3s, num: 1408, concurrency: 730}		215.5 KB	N/A
20:53:55 [2021-06-04T20:53:55.895Z]         ├─IndexRangeScan_36(Build)	5.06	17183450	cop[tikv]	table:l3, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:46.9s, loops:18363, cop_task: {num: 2801, max: 963ms, min: 448.3µs, avg: 165.8ms, p95: 357.1ms, max_proc_keys: 19331, p95_proc_keys: 13738, tot_proc: 5m45.8s, tot_wait: 1m38.5s, rpc_num: 2801, rpc_time: 7m44.3s, copr_cache: disabled}, tikv_task:{proc max:175ms, min:0s, p80:78ms, p95:119ms, iters:29154, tasks:2801}, scan_detail: {total_process_keys: 17183450, total_keys: 20546486, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17183450, block: {cache_hit_count: 23554058, 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:55 [2021-06-04T20:53:55.895Z]         └─Selection_38(Probe)	4.05	12022834	cop[tikv]		time:6m13.4s, loops:13755, cop_task: {num: 10194, max: 576.6ms, min: 443.2µs, avg: 173.8ms, p95: 358.3ms, max_proc_keys: 7122, p95_proc_keys: 3992, tot_proc: 20m45.5s, tot_wait: 7m39.7s, rpc_num: 10194, rpc_time: 29m31s, copr_cache: disabled}, tikv_task:{proc max:223ms, min:0s, p80:77ms, p95:116ms, iters:60392, tasks:10194}, scan_detail: {total_process_keys: 17183450, total_keys: 18129773, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5528467, block: {cache_hit_count: 98290825, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:53:55 [2021-06-04T20:53:55.895Z]           └─TableRowIDScan_37	5.06	17183450	cop[tikv]	table:l3	tikv_task:{proc max:221ms, min:0s, p80:76ms, p95:115ms, iters:60392, tasks:10194}	keep order:false	N/A	N/A
20:53:55 [2021-06-04T20:53:55.895Z] + tiup cluster stop benchbot -y
20:53:55 [2021-06-04T20:53:55.895Z] Starting component `cluster`: /home/tidb/.tiup/components/cluster/v1.4.4/tiup-cluster stop benchbot -y
20:54:05 [2021-06-04T20:54:05.834Z] + rm -rf '/data1/tidb-deploy/*/log/*'
20:54:05 [2021-06-04T20:54:05.834Z] + rm -rf /data1/jenkins/deploy/data/tikv-20160
20:54:09 [2021-06-04T20:54:09.111Z] + rm -rf /data1/jenkins/deploy/data/pd-2379
20:54:09 [2021-06-04T20:54:09.111Z] + rm -rf /data1/jenkins/restore_data/tpch50/data/last_tikv.toml
20:54:09 [2021-06-04T20:54:09.111Z] + cp -R /data1/jenkins/restore_data/tpch50/data /data1/jenkins/deploy/data/tikv-20160
20:56:00 [2021-06-04T20:56:00.783Z] + cp -R /data1/jenkins/restore_data/tpch50/data.pd /data1/jenkins/deploy/data/pd-2379
20:56:00 [2021-06-04T20:56:00.783Z] + '[' -n '' ']'
20:56:00 [2021-06-04T20:56:00.783Z] + tiup cluster start benchbot --wait-timeout=300
20:56:00 [2021-06-04T20:56:00.783Z] Starting component `cluster`: /home/tidb/.tiup/components/cluster/v1.4.4/tiup-cluster start benchbot --wait-timeout=300
20:56:22 [2021-06-04T20:56:22.664Z] + sync
20:56:22 [2021-06-04T20:56:22.664Z] + /usr/bin/echo 3
20:57:01 [2021-06-04T20:57:01.311Z] + sync
20:57:01 [2021-06-04T20:57:01.311Z] + /usr/bin/echo 3
20:57:27 [2021-06-04T20:57:27.803Z] + sync
20:57:27 [2021-06-04T20:57:27.803Z] + /usr/bin/echo 3
20:57:59 [2021-06-04T20:57:59.832Z] 
20:57:59 [2021-06-04T20:57:59.833Z] queries/22.sql
20:57:59 [2021-06-04T20:57:59.833Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:57:59 [2021-06-04T20:57:59.833Z] Sort_39	1600000.00	4	root		time:26.4s, loops:2	Column#27	9.48 KB	0 Bytes
20:57:59 [2021-06-04T20:57:59.833Z] └─Projection_41	1600000.00	4	root		time:26.4s, loops:5, Concurrency:5	Column#27, Column#28, Column#29	23.7 KB	N/A
20:57:59 [2021-06-04T20:57:59.833Z]   └─HashAgg_42	1600000.00	4	root		time:26.4s, loops:5, partial_worker:{wall_time:26.414055484s, concurrency:5, task_num:181, tot_wait:2m12.017812801s, tot_exec:51.531164ms, tot_time:2m12.069482234s, max:26.413982929s, p95:26.413982929s}, final_worker:{wall_time:26.414071383s, concurrency:5, task_num:20, tot_wait:2m12.069774033s, tot_exec:198.976µs, tot_time:2m12.069981019s, max:26.414005206s, p95:26.414005206s}	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:59 [2021-06-04T20:57:59.833Z]     └─Projection_51	1600000.00	181704	root		time:26.4s, loops:182, 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:59 [2021-06-04T20:57:59.833Z]       └─HashJoin_43	1600000.00	181704	root		time:26.4s, loops:182, build_hash_table:{total:25s, fetch:1.04s, build:24s}, probe:{concurrency:5, total:2m12.1s, max:26.4s, probe:5.93s, fetch:2m6.1s}	anti semi join, equal:[eq(tpch50.customer.c_custkey, tpch50.orders.o_custkey)]	590.2 MB	0 Bytes
20:57:59 [2021-06-04T20:57:59.833Z]         ├─TableReader_49(Build)	75000000.00	75000000	root		time:1.05s, loops:73364, cop_task: {num: 153, max: 1s, min: 286ms, avg: 582.8ms, p95: 926.8ms, max_proc_keys: 723875, p95_proc_keys: 553332, tot_proc: 1m28.3s, tot_wait: 29ms, rpc_num: 153, rpc_time: 1m29.2s, copr_cache: disabled}	data:TableFullScan_48	57.8 MB	N/A
20:57:59 [2021-06-04T20:57:59.833Z]         │ └─TableFullScan_48	75000000.00	75000000	cop[tikv]	table:orders	tikv_task:{proc max:970ms, min:271ms, p80:571ms, p95:888ms, 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: 219937, read_byte: 4.29 GB}}}	keep order:false	N/A	N/A
20:57:59 [2021-06-04T20:57:59.833Z]         └─Selection_47(Probe)	2000000.00	545246	root		time:1.23s, loops:534	in(substring(tpch50.customer.c_phone, 1, 2), "20", "40", "22", "30", "39", "42", "21")	94.6 KB	N/A
20:57:59 [2021-06-04T20:57:59.833Z]           └─TableReader_46	2000000.00	3407619	root		time:423.3ms, loops:3319, cop_task: {num: 18, max: 1.07s, min: 358.9ms, avg: 768.9ms, p95: 1.07s, max_proc_keys: 582617, p95_proc_keys: 582617, tot_proc: 13.4s, tot_wait: 8ms, rpc_num: 18, rpc_time: 13.8s, copr_cache: disabled}	data:Selection_45	192.5 MB	N/A
20:57:59 [2021-06-04T20:57:59.833Z]             └─Selection_45	2000000.00	3407619	cop[tikv]		tikv_task:{proc max:989ms, min:335ms, p80:847ms, p95:989ms, 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:59 [2021-06-04T20:57:59.833Z]               └─TableFullScan_44	7500000.00	7500000	cop[tikv]	table:customer	tikv_task:{proc max:901ms, min:305ms, p80:765ms, p95:901ms, iters:7404, tasks:18}	keep order:false	N/A	N/A
20:57:59 [2021-06-04T20:57:59.833Z] 
20:57:59 [2021-06-04T20:57:59.833Z] queries/22.sql
20:57:59 [2021-06-04T20:57:59.833Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:57:59 [2021-06-04T20:57:59.833Z] Sort_39	2186432.06	4	root		time:26.3s, loops:2	Column#27	9.48 KB	0 Bytes
20:57:59 [2021-06-04T20:57:59.833Z] └─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:57:59 [2021-06-04T20:57:59.833Z]   └─HashAgg_42	2186432.06	4	root		time:26.3s, loops:5, partial_worker:{wall_time:26.330807262s, concurrency:5, task_num:180, tot_wait:2m11.596203471s, tot_exec:55.533055ms, tot_time:2m11.651853528s, max:26.33071895s, p95:26.33071895s}, final_worker:{wall_time:26.3308511s, concurrency:5, task_num:20, tot_wait:2m11.653611241s, tot_exec:157.899µs, tot_time:2m11.653776291s, max:26.330785424s, p95:26.330785424s}	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:59 [2021-06-04T20:57:59.833Z]     └─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:57:59 [2021-06-04T20:57:59.833Z]       └─HashJoin_43	2186432.06	181704	root		time:26.3s, loops:181, build_hash_table:{total:24.8s, fetch:1.01s, build:23.8s}, probe:{concurrency:5, total:2m11.6s, max:26.3s, probe:6.08s, fetch:2m5.6s}	anti semi join, equal:[eq(tpch50.customer.c_custkey, tpch50.orders.o_custkey)]	590.2 MB	0 Bytes
20:57:59 [2021-06-04T20:57:59.833Z]         ├─TableReader_49(Build)	75000000.00	75000000	root		time:1.04s, loops:73364, cop_task: {num: 153, max: 1.16s, min: 274.9ms, avg: 545.4ms, p95: 978.6ms, max_proc_keys: 723875, p95_proc_keys: 553332, tot_proc: 1m22.6s, tot_wait: 50ms, rpc_num: 153, rpc_time: 1m23.4s, copr_cache: disabled}	data:TableFullScan_48	57.8 MB	N/A
20:57:59 [2021-06-04T20:57:59.833Z]         │ └─TableFullScan_48	75000000.00	75000000	cop[tikv]	table:orders	tikv_task:{proc max:1.13s, min:260ms, p80:596ms, p95:949ms, 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:59 [2021-06-04T20:57:59.833Z]         └─Selection_47(Probe)	2733040.07	545246	root		time:1.62s, loops:534	in(substring(tpch50.customer.c_phone, 1, 2), "20", "40", "22", "30", "39", "42", "21")	94.6 KB	N/A
20:57:59 [2021-06-04T20:57:59.833Z]           └─TableReader_46	2733040.07	3407619	root		time:749.8ms, loops:3319, cop_task: {num: 18, max: 1.3s, min: 458ms, avg: 903ms, p95: 1.3s, max_proc_keys: 582617, p95_proc_keys: 582617, tot_proc: 15.8s, tot_wait: 1ms, rpc_num: 18, rpc_time: 16.3s, copr_cache: disabled}	data:Selection_45	192.5 MB	N/A
20:57:59 [2021-06-04T20:57:59.833Z]             └─Selection_45	2733040.07	3407619	cop[tikv]		tikv_task:{proc max:1.22s, min:424ms, p80:1.04s, p95:1.22s, 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:59 [2021-06-04T20:57:59.833Z]               └─TableFullScan_44	7500000.00	7500000	cop[tikv]	table:customer	tikv_task:{proc max:1.12s, min:387ms, p80:972ms, p95:1.12s, iters:7404, tasks:18}	keep order:false	N/A	N/A
20:57:59 [2021-06-04T20:57:59.833Z] 
20:57:59 [2021-06-04T20:57:59.833Z] queries/22.sql
20:57:59 [2021-06-04T20:57:59.833Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:57:59 [2021-06-04T20:57:59.833Z] Sort_39	2186432.06	4	root		time:26.8s, loops:2	Column#27	9.48 KB	0 Bytes
20:57:59 [2021-06-04T20:57:59.833Z] └─Projection_41	2186432.06	4	root		time:26.8s, loops:5, Concurrency:5	Column#27, Column#28, Column#29	23.7 KB	N/A
20:57:59 [2021-06-04T20:57:59.833Z]   └─HashAgg_42	2186432.06	4	root		time:26.8s, loops:5, partial_worker:{wall_time:26.820046365s, concurrency:5, task_num:180, tot_wait:2m14.038704164s, tot_exec:60.49974ms, tot_time:2m14.099350324s, max:26.819997082s, p95:26.819997082s}, final_worker:{wall_time:26.820062144s, concurrency:5, task_num:20, tot_wait:2m14.099859047s, tot_exec:205.884µs, tot_time:2m14.100071475s, max:26.820023596s, p95:26.820023596s}	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:59 [2021-06-04T20:57:59.833Z]     └─Projection_51	2186432.06	181704	root		time:26.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:57:59 [2021-06-04T20:57:59.833Z]       └─HashJoin_43	2186432.06	181704	root		time:26.8s, loops:181, build_hash_table:{total:25.3s, fetch:1.02s, build:24.3s}, probe:{concurrency:5, total:2m14.1s, max:26.8s, probe:6.16s, fetch:2m7.9s}	anti semi join, equal:[eq(tpch50.customer.c_custkey, tpch50.orders.o_custkey)]	590.2 MB	0 Bytes
20:57:59 [2021-06-04T20:57:59.833Z]         ├─TableReader_49(Build)	75000000.00	75000000	root		time:1.06s, loops:73364, cop_task: {num: 153, max: 974ms, min: 232.5ms, avg: 499.7ms, p95: 894.2ms, max_proc_keys: 723875, p95_proc_keys: 553332, tot_proc: 1m15.7s, tot_wait: 32ms, rpc_num: 153, rpc_time: 1m16.4s, copr_cache: disabled}	data:TableFullScan_48	57.8 MB	N/A
20:57:59 [2021-06-04T20:57:59.833Z]         │ └─TableFullScan_48	75000000.00	75000000	cop[tikv]	table:orders	tikv_task:{proc max:958ms, min:221ms, p80:490ms, p95:863ms, 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:59 [2021-06-04T20:57:59.833Z]         └─Selection_47(Probe)	2733040.07	545246	root		time:1.54s, loops:534	in(substring(tpch50.customer.c_phone, 1, 2), "20", "40", "22", "30", "39", "42", "21")	94.6 KB	N/A
20:57:59 [2021-06-04T20:57:59.833Z]           └─TableReader_46	2733040.07	3407619	root		time:624.1ms, loops:3319, cop_task: {num: 18, max: 1.2s, min: 496.9ms, avg: 855.5ms, p95: 1.2s, max_proc_keys: 582617, p95_proc_keys: 582617, tot_proc: 15s, tot_wait: 1ms, rpc_num: 18, rpc_time: 15.4s, copr_cache: disabled}	data:Selection_45	192.5 MB	N/A
20:57:59 [2021-06-04T20:57:59.833Z]             └─Selection_45	2733040.07	3407619	cop[tikv]		tikv_task:{proc max:1.11s, min:470ms, p80:907ms, p95:1.11s, 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:59 [2021-06-04T20:57:59.833Z]               └─TableFullScan_44	7500000.00	7500000	cop[tikv]	table:customer	tikv_task:{proc max:1.03s, min:434ms, p80:841ms, p95:1.03s, iters:7404, tasks:18}	keep order:false	N/A	N/A
20:57:59 [2021-06-04T20:57:59.833Z] + sync
20:57:59 [2021-06-04T20:57:59.833Z] + /usr/bin/echo 3
20:58:26 [2021-06-04T20:58:26.324Z] + sync
20:58:26 [2021-06-04T20:58:26.324Z] + /usr/bin/echo 3
20:58:58 [2021-06-04T20:58:58.344Z] + sync
20:58:58 [2021-06-04T20:58:58.344Z] + /usr/bin/echo 3
20:59:30 [2021-06-04T20:59:30.363Z] 
20:59:30 [2021-06-04T20:59:30.363Z] queries/22.sql
20:59:30 [2021-06-04T20:59:30.363Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:59:30 [2021-06-04T20:59:30.363Z] Sort_39	2186432.06	4	root		time:26.9s, loops:2	Column#27	9.48 KB	0 Bytes
20:59:30 [2021-06-04T20:59:30.363Z] └─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:59:30 [2021-06-04T20:59:30.363Z]   └─HashAgg_42	2186432.06	4	root		time:26.9s, loops:5, partial_worker:{wall_time:26.879115336s, concurrency:5, task_num:180, tot_wait:2m14.345013112s, tot_exec:49.526934ms, tot_time:2m14.394686428s, max:26.879078644s, p95:26.879078644s}, final_worker:{wall_time:26.879134474s, concurrency:5, task_num:20, tot_wait:2m14.395306567s, tot_exec:196.98µs, tot_time:2m14.395513021s, max:26.879108731s, p95:26.879108731s}	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:30 [2021-06-04T20:59:30.363Z]     └─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:59:30 [2021-06-04T20:59:30.363Z]       └─HashJoin_43	2186432.06	181704	root		time:26.9s, loops:181, build_hash_table:{total:25.5s, fetch:1.01s, build:24.5s}, probe:{concurrency:5, total:2m14.4s, max:26.9s, probe:5.91s, fetch:2m8.5s}	anti semi join, equal:[eq(tpch50.customer.c_custkey, tpch50.orders.o_custkey)]	590.2 MB	0 Bytes
20:59:30 [2021-06-04T20:59:30.363Z]         ├─TableReader_49(Build)	75000000.00	75000000	root		time:1.06s, loops:73364, cop_task: {num: 153, max: 1.09s, min: 237.4ms, avg: 507.7ms, p95: 863.6ms, max_proc_keys: 723875, p95_proc_keys: 553332, tot_proc: 1m17s, tot_wait: 38ms, rpc_num: 153, rpc_time: 1m17.7s, copr_cache: disabled}	data:TableFullScan_48	57.8 MB	N/A
20:59:30 [2021-06-04T20:59:30.363Z]         │ └─TableFullScan_48	75000000.00	75000000	cop[tikv]	table:orders	tikv_task:{proc max:1.06s, min:230ms, p80:493ms, p95:833ms, 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:30 [2021-06-04T20:59:30.363Z]         └─Selection_47(Probe)	2733040.07	545246	root		time:1.34s, loops:534	in(substring(tpch50.customer.c_phone, 1, 2), "20", "40", "22", "30", "39", "42", "21")	94.6 KB	N/A
20:59:30 [2021-06-04T20:59:30.363Z]           └─TableReader_46	2733040.07	3407619	root		time:535.2ms, loops:3319, cop_task: {num: 18, max: 1.21s, min: 409.8ms, avg: 845.9ms, p95: 1.21s, max_proc_keys: 582617, p95_proc_keys: 582617, tot_proc: 14.8s, rpc_num: 18, rpc_time: 15.2s, copr_cache: disabled}	data:Selection_45	192.5 MB	N/A
20:59:30 [2021-06-04T20:59:30.363Z]             └─Selection_45	2733040.07	3407619	cop[tikv]		tikv_task:{proc max:1.13s, min:380ms, p80:907ms, p95:1.13s, 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:30 [2021-06-04T20:59:30.363Z]               └─TableFullScan_44	7500000.00	7500000	cop[tikv]	table:customer	tikv_task:{proc max:1.04s, min:350ms, p80:835ms, p95:1.04s, iters:7404, tasks:18}	keep order:false	N/A	N/A
20:59:30 [2021-06-04T20:59:30.363Z] 
20:59:30 [2021-06-04T20:59:30.363Z] queries/22.sql
20:59:30 [2021-06-04T20:59:30.363Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:59:30 [2021-06-04T20:59:30.363Z] Sort_39	2186432.06	4	root		time:26.5s, loops:2	Column#27	9.48 KB	0 Bytes
20:59:30 [2021-06-04T20:59:30.363Z] └─Projection_41	2186432.06	4	root		time:26.5s, loops:5, Concurrency:5	Column#27, Column#28, Column#29	23.7 KB	N/A
20:59:30 [2021-06-04T20:59:30.363Z]   └─HashAgg_42	2186432.06	4	root		time:26.5s, loops:5, partial_worker:{wall_time:26.468810342s, concurrency:5, task_num:180, tot_wait:2m12.291562281s, tot_exec:51.458903ms, tot_time:2m12.343151212s, max:26.468778455s, p95:26.468778455s}, final_worker:{wall_time:26.46884624s, concurrency:5, task_num:20, tot_wait:2m12.343883643s, tot_exec:165.567µs, tot_time:2m12.344056691s, max:26.468814365s, p95:26.468814365s}	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:30 [2021-06-04T20:59:30.363Z]     └─Projection_51	2186432.06	181704	root		time:26.5s, 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:30 [2021-06-04T20:59:30.363Z]       └─HashJoin_43	2186432.06	181704	root		time:26.5s, loops:181, build_hash_table:{total:25s, fetch:1.02s, build:24s}, probe:{concurrency:5, total:2m12.3s, max:26.5s, probe:6s, fetch:2m6.3s}	anti semi join, equal:[eq(tpch50.customer.c_custkey, tpch50.orders.o_custkey)]	590.2 MB	0 Bytes
20:59:30 [2021-06-04T20:59:30.363Z]         ├─TableReader_49(Build)	75000000.00	75000000	root		time:1.07s, loops:73364, cop_task: {num: 153, max: 998.5ms, min: 248ms, avg: 499.4ms, p95: 890.1ms, max_proc_keys: 723875, p95_proc_keys: 553332, tot_proc: 1m15.7s, tot_wait: 31ms, rpc_num: 153, rpc_time: 1m16.4s, copr_cache: disabled}	data:TableFullScan_48	57.8 MB	N/A
20:59:30 [2021-06-04T20:59:30.363Z]         │ └─TableFullScan_48	75000000.00	75000000	cop[tikv]	table:orders	tikv_task:{proc max:974ms, min:232ms, p80:506ms, p95:857ms, 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:30 [2021-06-04T20:59:30.363Z]         └─Selection_47(Probe)	2733040.07	545246	root		time:1.49s, loops:534	in(substring(tpch50.customer.c_phone, 1, 2), "20", "40", "22", "30", "39", "42", "21")	94.6 KB	N/A
20:59:30 [2021-06-04T20:59:30.363Z]           └─TableReader_46	2733040.07	3407619	root		time:619.2ms, loops:3319, cop_task: {num: 18, max: 1.24s, min: 516.6ms, avg: 885.2ms, p95: 1.24s, max_proc_keys: 582617, p95_proc_keys: 582617, tot_proc: 15.6s, rpc_num: 18, rpc_time: 15.9s, copr_cache: disabled}	data:Selection_45	192.5 MB	N/A
20:59:30 [2021-06-04T20:59:30.363Z]             └─Selection_45	2733040.07	3407619	cop[tikv]		tikv_task:{proc max:1.16s, min:492ms, p80:984ms, p95:1.16s, 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:30 [2021-06-04T20:59:30.363Z]               └─TableFullScan_44	7500000.00	7500000	cop[tikv]	table:customer	tikv_task:{proc max:1.07s, min:466ms, p80:892ms, p95:1.07s, iters:7404, tasks:18}	keep order:false	N/A	N/A
20:59:30 [2021-06-04T20:59:30.363Z] 
20:59:30 [2021-06-04T20:59:30.363Z] queries/22.sql
20:59:30 [2021-06-04T20:59:30.363Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:59:30 [2021-06-04T20:59:30.363Z] Sort_39	2186432.06	4	root		time:26.3s, loops:2	Column#27	9.48 KB	0 Bytes
20:59:30 [2021-06-04T20:59:30.363Z] └─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:30 [2021-06-04T20:59:30.363Z]   └─HashAgg_42	2186432.06	4	root		time:26.3s, loops:5, partial_worker:{wall_time:26.335355423s, concurrency:5, task_num:180, tot_wait:2m11.625144286s, tot_exec:50.322423ms, tot_time:2m11.67560589s, max:26.335310242s, p95:26.335310242s}, final_worker:{wall_time:26.335374812s, concurrency:5, task_num:20, tot_wait:2m11.676450051s, tot_exec:284.927µs, tot_time:2m11.676743148s, max:26.335350852s, p95:26.335350852s}	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:30 [2021-06-04T20:59:30.363Z]     └─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:30 [2021-06-04T20:59:30.363Z]       └─HashJoin_43	2186432.06	181704	root		time:26.3s, loops:181, build_hash_table:{total:25s, fetch:887.3ms, build:24.1s}, probe:{concurrency:5, total:2m11.7s, max:26.3s, probe:5.39s, fetch:2m6.3s}	anti semi join, equal:[eq(tpch50.customer.c_custkey, tpch50.orders.o_custkey)]	590.2 MB	0 Bytes
20:59:30 [2021-06-04T20:59:30.363Z]         ├─TableReader_49(Build)	75000000.00	75000000	root		time:936ms, loops:73364, cop_task: {num: 153, max: 911ms, min: 228.9ms, avg: 498.3ms, p95: 858.7ms, max_proc_keys: 723875, p95_proc_keys: 553332, tot_proc: 1m15.5s, tot_wait: 59ms, rpc_num: 153, rpc_time: 1m16.2s, copr_cache: disabled}	data:TableFullScan_48	57.8 MB	N/A
20:59:30 [2021-06-04T20:59:30.363Z]         │ └─TableFullScan_48	75000000.00	75000000	cop[tikv]	table:orders	tikv_task:{proc max:885ms, min:220ms, p80:495ms, p95:835ms, 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:30 [2021-06-04T20:59:30.363Z]         └─Selection_47(Probe)	2733040.07	545246	root		time:1.44s, loops:534	in(substring(tpch50.customer.c_phone, 1, 2), "20", "40", "22", "30", "39", "42", "21")	94.6 KB	N/A
20:59:30 [2021-06-04T20:59:30.363Z]           └─TableReader_46	2733040.07	3407619	root		time:629.3ms, loops:3319, cop_task: {num: 18, max: 1.11s, min: 504.2ms, avg: 826.6ms, p95: 1.11s, max_proc_keys: 582617, p95_proc_keys: 582617, tot_proc: 14.5s, tot_wait: 5ms, rpc_num: 18, rpc_time: 14.9s, copr_cache: disabled}	data:Selection_45	192.5 MB	N/A
20:59:30 [2021-06-04T20:59:30.364Z]             └─Selection_45	2733040.07	3407619	cop[tikv]		tikv_task:{proc max:1.04s, min:461ms, p80:906ms, p95:1.04s, 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:30 [2021-06-04T20:59:30.364Z]               └─TableFullScan_44	7500000.00	7500000	cop[tikv]	table:customer	tikv_task:{proc max:949ms, min:424ms, p80:842ms, p95:949ms, iters:7404, tasks:18}	keep order:false	N/A	N/A
20:59:30 [2021-06-04T20:59:30.364Z] + sync
20:59:30 [2021-06-04T20:59:30.364Z] + /usr/bin/echo 3
21:00:02 [2021-06-04T21:00:02.373Z] 
21:00:02 [2021-06-04T21:00:02.373Z] queries/22.sql
21:00:02 [2021-06-04T21:00:02.373Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
21:00:02 [2021-06-04T21:00:02.373Z] Sort_39	2186432.06	4	root		time:25.9s, loops:2	Column#27	9.48 KB	0 Bytes
21:00:02 [2021-06-04T21:00:02.373Z] └─Projection_41	2186432.06	4	root		time:25.9s, loops:5, Concurrency:5	Column#27, Column#28, Column#29	23.7 KB	N/A
21:00:02 [2021-06-04T21:00:02.373Z]   └─HashAgg_42	2186432.06	4	root		time:25.9s, loops:5, partial_worker:{wall_time:25.921108999s, concurrency:5, task_num:180, tot_wait:2m9.554268884s, tot_exec:50.465775ms, tot_time:2m9.604925226s, max:25.921071389s, p95:25.921071389s}, final_worker:{wall_time:25.921162974s, concurrency:5, task_num:20, tot_wait:2m9.605276467s, tot_exec:334.592µs, tot_time:2m9.605618052s, max:25.921139328s, p95:25.921139328s}	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
21:00:02 [2021-06-04T21:00:02.373Z]     └─Projection_51	2186432.06	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
21:00:02 [2021-06-04T21:00:02.373Z]       └─HashJoin_43	2186432.06	181704	root		time:25.9s, loops:181, build_hash_table:{total:24.6s, fetch:857.2ms, build:23.8s}, probe:{concurrency:5, total:2m9.6s, max:25.9s, probe:5.39s, fetch:2m4.2s}	anti semi join, equal:[eq(tpch50.customer.c_custkey, tpch50.orders.o_custkey)]	590.2 MB	0 Bytes
21:00:02 [2021-06-04T21:00:02.373Z]         ├─TableReader_49(Build)	75000000.00	75000000	root		time:899.9ms, loops:73364, cop_task: {num: 153, max: 1.01s, min: 229.5ms, avg: 495.8ms, p95: 885.8ms, max_proc_keys: 723875, p95_proc_keys: 553332, tot_proc: 1m15.1s, tot_wait: 44ms, rpc_num: 153, rpc_time: 1m15.9s, copr_cache: disabled}	data:TableFullScan_48	57.8 MB	N/A
21:00:02 [2021-06-04T21:00:02.373Z]         │ └─TableFullScan_48	75000000.00	75000000	cop[tikv]	table:orders	tikv_task:{proc max:983ms, min:214ms, p80:511ms, p95:852ms, 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
21:00:02 [2021-06-04T21:00:02.373Z]         └─Selection_47(Probe)	2733040.07	545246	root		time:1.57s, loops:534	in(substring(tpch50.customer.c_phone, 1, 2), "20", "40", "22", "30", "39", "42", "21")	94.6 KB	N/A
21:00:02 [2021-06-04T21:00:02.373Z]           └─TableReader_46	2733040.07	3407619	root		time:763.8ms, loops:3319, cop_task: {num: 18, max: 1.21s, min: 480.2ms, avg: 852.5ms, p95: 1.21s, max_proc_keys: 582617, p95_proc_keys: 582617, tot_proc: 14.9s, tot_wait: 1ms, rpc_num: 18, rpc_time: 15.3s, copr_cache: disabled}	data:Selection_45	192.5 MB	N/A
21:00:02 [2021-06-04T21:00:02.373Z]             └─Selection_45	2733040.07	3407619	cop[tikv]		tikv_task:{proc max:1.12s, min:430ms, p80:999ms, p95:1.12s, 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
21:00:02 [2021-06-04T21:00:02.373Z]               └─TableFullScan_44	7500000.00	7500000	cop[tikv]	table:customer	tikv_task:{proc max:1.04s, min:391ms, p80:921ms, p95:1.04s, iters:7404, tasks:18}	keep order:false	N/A	N/A
21:00:02 [2021-06-04T21:00:02.373Z] 
21:00:02 [2021-06-04T21:00:02.373Z] + tiup cluster stop benchbot
21:00:02 [2021-06-04T21:00:02.373Z] Starting component `cluster`: /home/tidb/.tiup/components/cluster/v1.4.4/tiup-cluster stop benchbot
21:00:02 [2021-06-04T21:00:02.373Z] + [ 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
21:00:02 [2021-06-04T21:00:02.373Z] + [Parallel] - UserSSH: user=tidb, host=172.16.5.86
21:00:02 [2021-06-04T21:00:02.373Z] + [Parallel] - UserSSH: user=tidb, host=172.16.5.86
21:00:02 [2021-06-04T21:00:02.373Z] + [Parallel] - UserSSH: user=tidb, host=172.16.5.86
21:00:02 [2021-06-04T21:00:02.373Z] + [Parallel] - UserSSH: user=tidb, host=172.16.5.86
21:00:02 [2021-06-04T21:00:02.373Z] + [Parallel] - UserSSH: user=tidb, host=172.16.5.86
21:00:02 [2021-06-04T21:00:02.373Z] + [ Serial ] - StopCluster
21:00:02 [2021-06-04T21:00:02.373Z] Stopping component grafana
21:00:02 [2021-06-04T21:00:02.373Z] 	Stopping instance 172.16.5.86
21:00:02 [2021-06-04T21:00:02.373Z] 	Stop grafana 172.16.5.86:3000 success
21:00:02 [2021-06-04T21:00:02.373Z] Stopping component prometheus
21:00:02 [2021-06-04T21:00:02.373Z] 	Stopping instance 172.16.5.86
21:00:02 [2021-06-04T21:00:02.373Z] 	Stop prometheus 172.16.5.86:9090 success
21:00:02 [2021-06-04T21:00:02.373Z] Stopping component tidb
21:00:02 [2021-06-04T21:00:02.373Z] 	Stopping instance 172.16.5.86
21:00:03 [2021-06-04T21:00:03.734Z] 	Stop tidb 172.16.5.86:4000 success
21:00:03 [2021-06-04T21:00:03.734Z] Stopping component tikv
21:00:03 [2021-06-04T21:00:03.734Z] 	Stopping instance 172.16.5.86
21:00:07 [2021-06-04T21:00:07.891Z] 	Stop tikv 172.16.5.86:20160 success
21:00:07 [2021-06-04T21:00:07.891Z] Stopping component pd
21:00:07 [2021-06-04T21:00:07.891Z] 	Stopping instance 172.16.5.86
21:00:07 [2021-06-04T21:00:07.891Z] 	Stop pd 172.16.5.86:2379 success
21:00:07 [2021-06-04T21:00:07.891Z] Stopping component node_exporter
21:00:07 [2021-06-04T21:00:07.891Z] Stopping component blackbox_exporter
21:00:07 [2021-06-04T21:00:07.891Z] Stopped cluster `benchbot` successfully
21:00:07 [2021-06-04T21:00:07.898Z] [Pipeline] sh
21:00:08 [2021-06-04T21:00:08.179Z] + cat bench_result
21:00:08 [2021-06-04T21:00:08.185Z] [Pipeline] }
21:00:08 [2021-06-04T21:00:08.188Z] [Pipeline] // dir
21:00:08 [2021-06-04T21:00:08.189Z] [Pipeline] }
21:00:08 [2021-06-04T21:00:08.191Z] [Pipeline] // stage
21:00:08 [2021-06-04T21:00:08.193Z] [Pipeline] }
21:00:08 [2021-06-04T21:00:08.195Z] [Pipeline] // node
21:00:08 [2021-06-04T21:00:08.198Z] [Pipeline] }
21:00:08 [2021-06-04T21:00:08.200Z] [Pipeline] // catchError
21:00:08 [2021-06-04T21:00:08.205Z] [Pipeline] stage
21:00:08 [2021-06-04T21:00:08.208Z] [Pipeline] { (Summary)
21:00:08 [2021-06-04T21:00:08.220Z] [Pipeline] slackSend
21:00:08 [2021-06-04T21:00:08.221Z] 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>
21:00:08 [2021-06-04T21:00:08.246Z] sh: line 1: 103944 Terminated              sleep 3
21:00:08 [2021-06-04T21:00:08.261Z] sh: line 1: 103956 Terminated              sleep 3
21:00:08 [2021-06-04T21:00:08.917Z] [Pipeline] }
21:00:08 [2021-06-04T21:00:08.919Z] [Pipeline] // stage
21:00:08 [2021-06-04T21:00:08.922Z] [Pipeline] End of Pipeline
21:00:08 [2021-06-04T21:00:08.945Z] Finished: SUCCESS