SuccessConsole Output

Skipping 1,193 KB.. Full Log
funcs:firstrow(tpch50.partsupp.ps_availqty)->tpch50.partsupp.ps_availqty, funcs:sum(tpch50.lineitem.l_quantity)->Column#44	194.5 MB	N/A
20:38:34 [2021-06-02T20:38:34.077Z]         └─HashJoin_59	9711455.06	634004	root		time:37.6s, loops:625, build_hash_table:{total:2.53s, fetch:2.33s, build:199.7ms}, probe:{concurrency:5, total:3m8.2s, max:37.6s, probe:14.9s, fetch:2m53.3s}	left outer join, equal:[eq(tpch50.partsupp.ps_partkey, tpch50.lineitem.l_partkey) eq(tpch50.partsupp.ps_suppkey, tpch50.lineitem.l_suppkey)]	10.4 MB	0 Bytes
20:38:34 [2021-06-02T20:38:34.077Z]           ├─IndexHashJoin_67(Build)	321865.05	435528	root		time:2.5s, loops:430, inner:{total:2.52s, concurrency:5, task:12, construct:122.7ms, fetch:2.08s, build:23.4ms, join:317.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:38:34 [2021-06-02T20:38:34.077Z]           │ ├─TableReader_96(Build)	80007.93	108882	root		time:2.17s, loops:112, cop_task: {num: 20, max: 1.47s, min: 678.1ms, avg: 1.1s, p95: 1.47s, max_proc_keys: 686055, p95_proc_keys: 686055, tot_proc: 22s, tot_wait: 5ms, rpc_num: 20, rpc_time: 22s, copr_cache: disabled}	data:Selection_95	725.8 KB	N/A
20:38:34 [2021-06-02T20:38:34.077Z]           │ │ └─Selection_95	80007.93	108882	cop[tikv]		tikv_task:{proc max:1.44s, min:671ms, p80:1.25s, p95:1.44s, iters:9859, tasks:20}, scan_detail: {total_process_keys: 10000000, total_keys: 10000020, rocksdb: {delete_skipped_count: 0, key_skipped_count: 19999980, block: {cache_hit_count: 31499, read_count: 0, read_byte: 0 Bytes}}}	like(tpch50.part.p_name, "green%", 92)	N/A	N/A
20:38:34 [2021-06-02T20:38:34.077Z]           │ │   └─TableFullScan_94	10000000.00	10000000	cop[tikv]	table:part	tikv_task:{proc max:1.33s, min:623ms, p80:1.16s, p95:1.33s, iters:9859, tasks:20}	keep order:false	N/A	N/A
20:38:34 [2021-06-02T20:38:34.077Z]           │ └─IndexLookUp_64(Probe)	4.02	435528	root		time:1.97s, loops:447, index_task: {total_time: 1.21s, fetch_handle: 1.21s, build: 103.5µs, wait: 269.5µs}, table_task: {total_time: 7.71s, num: 56, concurrency: 60}		20.5 KB	N/A
20:38:34 [2021-06-02T20:38:34.077Z]           │   ├─IndexRangeScan_62(Build)	4.02	435528	cop[tikv]	table:partsupp, index:PRIMARY(PS_PARTKEY, PS_SUPPKEY)	time:1.17s, loops:482, cop_task: {num: 58, max: 216.6ms, min: 5.48ms, avg: 89.3ms, p95: 194.2ms, max_proc_keys: 15288, p95_proc_keys: 15008, tot_proc: 4.75s, tot_wait: 80ms, rpc_num: 58, rpc_time: 5.18s, copr_cache: disabled}, tikv_task:{proc max:190ms, min:4ms, p80:140ms, p95:178ms, iters:690, tasks:58}, scan_detail: {total_process_keys: 435528, total_keys: 544410, rocksdb: {delete_skipped_count: 0, key_skipped_count: 435528, block: {cache_hit_count: 980292, read_count: 0, read_byte: 0 Bytes}}}	range: decided by [eq(tpch50.partsupp.ps_partkey, tpch50.part.p_partkey)], keep order:false	N/A	N/A
20:38:34 [2021-06-02T20:38:34.077Z]           │   └─TableRowIDScan_63(Probe)	4.02	435528	cop[tikv]	table:partsupp	time:2.33s, loops:503, cop_task: {num: 1480, max: 75.3ms, min: 353.2µs, avg: 16ms, p95: 32ms, max_proc_keys: 908, p95_proc_keys: 520, tot_proc: 17.9s, tot_wait: 3.45s, rpc_num: 1480, rpc_time: 23.6s, copr_cache: disabled}, tikv_task:{proc max:45ms, min:0s, p80:15ms, p95:22ms, iters:5437, tasks:1480}, scan_detail: {total_process_keys: 435528, total_keys: 473497, rocksdb: {delete_skipped_count: 0, key_skipped_count: 194043, block: {cache_hit_count: 3644508, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:38:34 [2021-06-02T20:38:34.077Z]           └─TableReader_101(Probe)	46310896.67	45504356	root		time:33.1s, loops:44289, cop_task: {num: 761, max: 1.26s, min: 353.1ms, avg: 700.2ms, p95: 842.7ms, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 8m49.6s, tot_wait: 134ms, rpc_num: 761, rpc_time: 8m52.9s, copr_cache: disabled}	data:Selection_100	52.6 MB	N/A
20:38:34 [2021-06-02T20:38:34.077Z]             └─Selection_100	46310896.67	45504356	cop[tikv]		tikv_task:{proc max:1.22s, min:342ms, p80:748ms, p95:826ms, iters:296606, tasks:761}, scan_detail: {total_process_keys: 300005811, total_keys: 300006572, rocksdb: {delete_skipped_count: 0, key_skipped_count: 600010861, block: {cache_hit_count: 1124648, read_count: 0, read_byte: 0 Bytes}}}	ge(tpch50.lineitem.l_shipdate, 1993-01-01 00:00:00.000000), lt(tpch50.lineitem.l_shipdate, 1994-01-01)	N/A	N/A
20:38:34 [2021-06-02T20:38:34.077Z]               └─TableFullScan_99	300005811.00	300005811	cop[tikv]	table:lineitem	tikv_task:{proc max:1.17s, min:319ms, p80:718ms, p95:793ms, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:38:34 [2021-06-02T20:38:34.077Z] + sync
20:38:34 [2021-06-02T20:38:34.077Z] + /usr/bin/echo 3
20:40:02 [2021-06-02T20:40:02.439Z] + sync
20:40:02 [2021-06-02T20:40:02.439Z] + /usr/bin/echo 3
20:40:02 [2021-06-02T20:40:02.439Z] 
20:40:02 [2021-06-02T20:40:02.439Z] queries/20.sql
20:40:02 [2021-06-02T20:40:02.439Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:40:02 [2021-06-02T20:40:02.439Z] Sort_30	20000.00	8982	root		time:36.7s, loops:10	tpch50.supplier.s_name	614.3 KB	0 Bytes
20:40:02 [2021-06-02T20:40:02.439Z] └─HashJoin_35	20000.00	8982	root		time:36.7s, loops:11, build_hash_table:{total:1.46s, fetch:1.45s, build:10.5ms}, probe:{concurrency:5, total:3m3.6s, max:36.7s, probe:45.9ms, fetch:3m3.5s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.partsupp.ps_suppkey)]	1.51 MB	0 Bytes
20:40:02 [2021-06-02T20:40:02.439Z]   ├─HashJoin_48(Build)	20000.00	19972	root		time:1.46s, loops:23, build_hash_table:{total:188.5µs, fetch:182.5µs, build:6.1µs}, probe:{concurrency:5, total:7.29s, max:1.46s, probe:104.7ms, fetch:7.18s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:40:02 [2021-06-02T20:40:02.439Z]   │ ├─TableReader_53(Build)	1.00	1	root		time:47µs, loops:2, cop_task: {num: 1, max: 1.02ms, proc_keys: 25, tot_proc: 1ms, rpc_num: 1, rpc_time: 1.01ms, copr_cache: disabled}	data:Selection_52	244 Bytes	N/A
20:40:02 [2021-06-02T20:40:02.439Z]   │ │ └─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:02 [2021-06-02T20:40:02.439Z]   │ │   └─TableFullScan_51	25.00	25	cop[tikv]	table:nation	tikv_task:{time:1ms, loops:1}	keep order:false	N/A	N/A
20:40:02 [2021-06-02T20:40:02.439Z]   │ └─TableReader_50(Probe)	500000.00	500000	root		time:1.44s, loops:490, cop_task: {num: 1, max: 1.44s, proc_keys: 500000, tot_proc: 1.36s, rpc_num: 1, rpc_time: 1.44s, copr_cache: disabled}	data:TableFullScan_49	35.8 MB	N/A
20:40:02 [2021-06-02T20:40:02.439Z]   │   └─TableFullScan_49	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:1.22s, 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:02 [2021-06-02T20:40:02.439Z]   └─HashAgg_54(Probe)	257492.04	223999	root		time:36.7s, loops:222, partial_worker:{wall_time:36.608065825s, concurrency:5, task_num:289, tot_wait:3m2.793020326s, tot_exec:203.356317ms, tot_time:3m3.033640623s, max:36.608028435s, p95:36.608028435s}, final_worker:{wall_time:36.716247903s, concurrency:5, task_num:25, tot_wait:3m3.026816704s, tot_exec:540.901269ms, tot_time:3m3.567735032s, max:36.716230874s, p95:36.716230874s}	group by:tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_suppkey)->tpch50.partsupp.ps_suppkey	61.4 MB	N/A
20:40:02 [2021-06-02T20:40:02.439Z]     └─Selection_55	257492.04	295898	root		time:36.6s, loops:290	gt(cast(tpch50.partsupp.ps_availqty, decimal(20,0) BINARY), mul(0.5, Column#44))	59.2 KB	N/A
20:40:02 [2021-06-02T20:40:02.439Z]       └─HashAgg_56	321865.05	435528	root		time:36.5s, loops:430, partial_worker:{wall_time:36.253211933s, concurrency:5, task_num:624, tot_wait:3m0.079060765s, tot_exec:1.055308183s, tot_time:3m1.25099379s, max:36.253134497s, p95:36.253134497s}, final_worker:{wall_time:36.598199388s, concurrency:5, task_num:25, tot_wait:3m1.235393556s, tot_exec:1.726477113s, tot_time:3m2.961885979s, max:36.598111213s, p95:36.598111213s}	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:02 [2021-06-02T20:40:02.439Z]         └─HashJoin_59	9711455.06	634004	root		time:36.2s, loops:625, build_hash_table:{total:2.43s, fetch:2.23s, build:206.1ms}, probe:{concurrency:5, total:3m0.9s, max:36.2s, probe:14.6s, fetch:2m46.3s}	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:02 [2021-06-02T20:40:02.439Z]           ├─IndexHashJoin_67(Build)	321865.05	435528	root		time:2.4s, loops:430, inner:{total:2.91s, concurrency:5, task:12, construct:132.7ms, fetch:2.44s, build:33.6ms, join:333.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:02 [2021-06-02T20:40:02.439Z]           │ ├─TableReader_96(Build)	80007.93	108882	root		time:2.03s, loops:112, cop_task: {num: 20, max: 1.44s, min: 630.2ms, avg: 1.09s, p95: 1.44s, max_proc_keys: 686055, p95_proc_keys: 686055, tot_proc: 21.8s, tot_wait: 40ms, rpc_num: 20, rpc_time: 21.9s, copr_cache: disabled}	data:Selection_95	665.9 KB	N/A
20:40:02 [2021-06-02T20:40:02.439Z]           │ │ └─Selection_95	80007.93	108882	cop[tikv]		tikv_task:{proc max:1.37s, min:625ms, p80:1.33s, p95:1.37s, 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:02 [2021-06-02T20:40:02.439Z]           │ │   └─TableFullScan_94	10000000.00	10000000	cop[tikv]	table:part	tikv_task:{proc max:1.28s, min:576ms, p80:1.24s, p95:1.28s, iters:9859, tasks:20}	keep order:false	N/A	N/A
20:40:02 [2021-06-02T20:40:02.439Z]           │ └─IndexLookUp_64(Probe)	4.02	435528	root		time:2.32s, loops:447, index_task: {total_time: 1.18s, fetch_handle: 1.18s, build: 98.6µs, wait: 305.5µs}, table_task: {total_time: 8.56s, num: 56, concurrency: 60}		20.7 KB	N/A
20:40:02 [2021-06-02T20:40:02.439Z]           │   ├─IndexRangeScan_62(Build)	4.02	435528	cop[tikv]	table:partsupp, index:PRIMARY(PS_PARTKEY, PS_SUPPKEY)	time:1.14s, loops:477, cop_task: {num: 58, max: 189ms, min: 4.6ms, avg: 88.4ms, p95: 165.2ms, max_proc_keys: 15288, p95_proc_keys: 15008, tot_proc: 4.61s, tot_wait: 118ms, rpc_num: 58, rpc_time: 5.12s, copr_cache: disabled}, tikv_task:{proc max:170ms, min:4ms, p80:133ms, p95:159ms, 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:40:02 [2021-06-02T20:40:02.439Z]           │   └─TableRowIDScan_63(Probe)	4.02	435528	cop[tikv]	table:partsupp	time:3.17s, loops:505, cop_task: {num: 1396, max: 124.2ms, min: 475.2µs, avg: 22ms, p95: 48.9ms, max_proc_keys: 964, p95_proc_keys: 620, tot_proc: 20.7s, tot_wait: 7.68s, rpc_num: 1396, rpc_time: 30.7s, copr_cache: disabled}, tikv_task:{proc max:44ms, min:0s, p80:17ms, p95:25ms, iters:5216, tasks:1396}, scan_detail: {total_process_keys: 435528, total_keys: 473513, rocksdb: {delete_skipped_count: 0, key_skipped_count: 194097, block: {cache_hit_count: 3643927, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:40:02 [2021-06-02T20:40:02.439Z]           └─TableReader_101(Probe)	46310896.67	45504356	root		time:31.7s, loops:44289, cop_task: {num: 761, max: 1.2s, min: 299.5ms, avg: 673.9ms, p95: 816ms, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 8m29.7s, tot_wait: 96ms, rpc_num: 761, rpc_time: 8m32.8s, copr_cache: disabled}	data:Selection_100	52.6 MB	N/A
20:40:02 [2021-06-02T20:40:02.439Z]             └─Selection_100	46310896.67	45504356	cop[tikv]		tikv_task:{proc max:1.17s, min:283ms, p80:714ms, p95:801ms, 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:02 [2021-06-02T20:40:02.439Z]               └─TableFullScan_99	300005811.00	300005811	cop[tikv]	table:lineitem	tikv_task:{proc max:1.12s, min:269ms, p80:685ms, p95:766ms, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:40:02 [2021-06-02T20:40:02.439Z] 
20:40:02 [2021-06-02T20:40:02.439Z] queries/20.sql
20:40:02 [2021-06-02T20:40:02.439Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:40:02 [2021-06-02T20:40:02.439Z] Sort_30	20000.00	8982	root		time:38s, loops:10	tpch50.supplier.s_name	607.7 KB	0 Bytes
20:40:02 [2021-06-02T20:40:02.439Z] └─HashJoin_35	20000.00	8982	root		time:38s, loops:11, build_hash_table:{total:1.32s, fetch:1.31s, build:10.7ms}, probe:{concurrency:5, total:3m9.8s, max:38s, probe:50.4ms, fetch:3m9.7s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.partsupp.ps_suppkey)]	1.54 MB	0 Bytes
20:40:02 [2021-06-02T20:40:02.439Z]   ├─HashJoin_48(Build)	20000.00	19972	root		time:1.31s, loops:24, build_hash_table:{total:241µs, fetch:234.4µs, build:6.57µs}, probe:{concurrency:5, total:6.57s, max:1.31s, probe:126.1ms, fetch:6.44s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:40:02 [2021-06-02T20:40:02.439Z]   │ ├─TableReader_53(Build)	1.00	1	root		time:70.3µs, loops:2, cop_task: {num: 1, max: 935.9µs, proc_keys: 25, tot_proc: 1ms, rpc_num: 1, rpc_time: 922.3µs, copr_cache: disabled}	data:Selection_52	244 Bytes	N/A
20:40:02 [2021-06-02T20:40:02.439Z]   │ │ └─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:02 [2021-06-02T20:40:02.439Z]   │ │   └─TableFullScan_51	25.00	25	cop[tikv]	table:nation	tikv_task:{time:1ms, loops:1}	keep order:false	N/A	N/A
20:40:02 [2021-06-02T20:40:02.439Z]   │ └─TableReader_50(Probe)	500000.00	500000	root		time:1.29s, loops:490, cop_task: {num: 1, max: 1.29s, proc_keys: 500000, tot_proc: 1.21s, rpc_num: 1, rpc_time: 1.29s, copr_cache: disabled}	data:TableFullScan_49	35.8 MB	N/A
20:40:02 [2021-06-02T20:40:02.439Z]   │   └─TableFullScan_49	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:1.05s, 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:02 [2021-06-02T20:40:02.439Z]   └─HashAgg_54(Probe)	257492.04	223999	root		time:37.9s, loops:222, partial_worker:{wall_time:37.86691892s, concurrency:5, task_num:289, tot_wait:3m8.983685371s, tot_exec:293.779435ms, tot_time:3m9.318152569s, max:37.866850985s, p95:37.866850985s}, final_worker:{wall_time:37.950889067s, concurrency:5, task_num:25, tot_wait:3m9.306470717s, tot_exec:361.434816ms, tot_time:3m9.667918571s, max:37.950812536s, p95:37.950812536s}	group by:tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_suppkey)->tpch50.partsupp.ps_suppkey	61.4 MB	N/A
20:40:02 [2021-06-02T20:40:02.440Z]     └─Selection_55	257492.04	295898	root		time:37.9s, loops:290	gt(cast(tpch50.partsupp.ps_availqty, decimal(20,0) BINARY), mul(0.5, Column#44))	59.2 KB	N/A
20:40:02 [2021-06-02T20:40:02.440Z]       └─HashAgg_56	321865.05	435528	root		time:37.7s, loops:430, partial_worker:{wall_time:37.507390108s, concurrency:5, task_num:625, tot_wait:3m6.25254019s, tot_exec:1.044680448s, tot_time:3m7.458104493s, max:37.507302742s, p95:37.507302742s}, final_worker:{wall_time:37.854489087s, concurrency:5, task_num:25, tot_wait:3m7.368034024s, tot_exec:1.877915973s, tot_time:3m9.24596499s, max:37.854288337s, p95:37.854288337s}	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:02 [2021-06-02T20:40:02.440Z]         └─HashJoin_59	9711455.06	634004	root		time:37.4s, loops:626, build_hash_table:{total:2.43s, fetch:2.14s, build:284.4ms}, probe:{concurrency:5, total:3m7s, max:37.4s, probe:14.4s, fetch:2m52.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:40:02 [2021-06-02T20:40:02.440Z]           ├─IndexHashJoin_67(Build)	321865.05	435528	root		time:2.35s, loops:430, inner:{total:3s, concurrency:5, task:12, construct:128.4ms, fetch:2.46s, build:32.5ms, join:410ms}	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:02 [2021-06-02T20:40:02.440Z]           │ ├─TableReader_96(Build)	80007.93	108882	root		time:1.97s, loops:112, cop_task: {num: 20, max: 1.46s, min: 702.4ms, avg: 1.04s, p95: 1.46s, max_proc_keys: 686055, p95_proc_keys: 686055, tot_proc: 20.8s, tot_wait: 24ms, rpc_num: 20, rpc_time: 20.9s, copr_cache: disabled}	data:Selection_95	660.2 KB	N/A
20:40:02 [2021-06-02T20:40:02.440Z]           │ │ └─Selection_95	80007.93	108882	cop[tikv]		tikv_task:{proc max:1.45s, min:699ms, p80:1.23s, p95:1.45s, 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:02 [2021-06-02T20:40:02.440Z]           │ │   └─TableFullScan_94	10000000.00	10000000	cop[tikv]	table:part	tikv_task:{proc max:1.37s, min:659ms, p80:1.14s, p95:1.37s, iters:9859, tasks:20}	keep order:false	N/A	N/A
20:40:02 [2021-06-02T20:40:02.440Z]           │ └─IndexLookUp_64(Probe)	4.02	435528	root		time:2.36s, loops:447, index_task: {total_time: 1.31s, fetch_handle: 1.31s, build: 98.7µs, wait: 286.2µs}, table_task: {total_time: 9.05s, num: 57, concurrency: 60}		20.5 KB	N/A
20:40:02 [2021-06-02T20:40:02.440Z]           │   ├─IndexRangeScan_62(Build)	4.02	435528	cop[tikv]	table:partsupp, index:PRIMARY(PS_PARTKEY, PS_SUPPKEY)	time:1.27s, loops:481, cop_task: {num: 54, max: 231.7ms, min: 4.79ms, avg: 103.4ms, p95: 225.6ms, max_proc_keys: 15288, p95_proc_keys: 15008, tot_proc: 5.21s, tot_wait: 62ms, rpc_num: 54, rpc_time: 5.58s, copr_cache: disabled}, tikv_task:{proc max:224ms, min:4ms, p80:158ms, p95:207ms, iters:672, tasks:54}, 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:02 [2021-06-02T20:40:02.440Z]           │   └─TableRowIDScan_63(Probe)	4.02	435528	cop[tikv]	table:partsupp	time:3.19s, loops:506, cop_task: {num: 1390, max: 133.9ms, min: 470.8µs, avg: 22.5ms, p95: 49.1ms, max_proc_keys: 1028, p95_proc_keys: 628, tot_proc: 20.8s, tot_wait: 7.75s, rpc_num: 1390, rpc_time: 31.3s, copr_cache: disabled}, tikv_task:{proc max:43ms, min:0s, p80:18ms, p95:25ms, iters:5197, tasks:1390}, scan_detail: {total_process_keys: 435528, total_keys: 473519, rocksdb: {delete_skipped_count: 0, key_skipped_count: 194115, block: {cache_hit_count: 3643846, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:40:02 [2021-06-02T20:40:02.440Z]           └─TableReader_101(Probe)	46310896.67	45504356	root		time:33s, loops:44289, cop_task: {num: 761, max: 1.18s, min: 350.7ms, avg: 698.5ms, p95: 851ms, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 8m48.4s, tot_wait: 102ms, rpc_num: 761, rpc_time: 8m51.5s, copr_cache: disabled}	data:Selection_100	52.6 MB	N/A
20:40:02 [2021-06-02T20:40:02.440Z]             └─Selection_100	46310896.67	45504356	cop[tikv]		tikv_task:{proc max:1.13s, min:338ms, p80:748ms, p95:832ms, 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:02 [2021-06-02T20:40:02.440Z]               └─TableFullScan_99	300005811.00	300005811	cop[tikv]	table:lineitem	tikv_task:{proc max:1.08s, min:325ms, p80:718ms, p95:798ms, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:40:02 [2021-06-02T20:40:02.440Z] + sync
20:40:02 [2021-06-02T20:40:02.440Z] + /usr/bin/echo 3
20:40:35 [2021-06-02T20:40:35.630Z] + sync
20:40:35 [2021-06-02T20:40:35.630Z] + /usr/bin/echo 3
20:41:17 [2021-06-02T20:41:17.280Z] 
20:41:17 [2021-06-02T20:41:17.280Z] queries/20.sql
20:41:17 [2021-06-02T20:41:17.280Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:41:17 [2021-06-02T20:41:17.280Z] Sort_30	20000.00	8982	root		time:37.2s, loops:10	tpch50.supplier.s_name	607.7 KB	0 Bytes
20:41:17 [2021-06-02T20:41:17.280Z] └─HashJoin_35	20000.00	8982	root		time:37.2s, loops:11, build_hash_table:{total:1.19s, fetch:1.18s, build:10.4ms}, probe:{concurrency:5, total:3m5.9s, max:37.2s, probe:48.5ms, fetch:3m5.8s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.partsupp.ps_suppkey)]	1.50 MB	0 Bytes
20:41:17 [2021-06-02T20:41:17.280Z]   ├─HashJoin_48(Build)	20000.00	19972	root		time:1.19s, loops:23, build_hash_table:{total:121.5µs, fetch:117µs, build:4.51µs}, probe:{concurrency:5, total:5.94s, max:1.19s, probe:92ms, fetch:5.85s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:41:17 [2021-06-02T20:41:17.280Z]   │ ├─TableReader_53(Build)	1.00	1	root		time:37.6µs, loops:2, cop_task: {num: 1, max: 895.4µs, proc_keys: 25, rpc_num: 1, rpc_time: 874.9µs, copr_cache: disabled}	data:Selection_52	236 Bytes	N/A
20:41:17 [2021-06-02T20:41:17.280Z]   │ │ └─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:41:17 [2021-06-02T20:41:17.280Z]   │ │   └─TableFullScan_51	25.00	25	cop[tikv]	table:nation	tikv_task:{time:0s, loops:1}	keep order:false	N/A	N/A
20:41:17 [2021-06-02T20:41:17.280Z]   │ └─TableReader_50(Probe)	500000.00	500000	root		time:1.17s, loops:490, cop_task: {num: 1, max: 1.17s, proc_keys: 500000, tot_proc: 1.1s, rpc_num: 1, rpc_time: 1.17s, copr_cache: disabled}	data:TableFullScan_49	35.8 MB	N/A
20:41:17 [2021-06-02T20:41:17.280Z]   │   └─TableFullScan_49	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:954ms, 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:41:17 [2021-06-02T20:41:17.280Z]   └─HashAgg_54(Probe)	257492.04	223999	root		time:37.2s, loops:222, partial_worker:{wall_time:37.093487524s, concurrency:5, task_num:289, tot_wait:3m5.228336649s, tot_exec:198.172175ms, tot_time:3m5.461763057s, max:37.093414371s, p95:37.093414371s}, final_worker:{wall_time:37.163917338s, concurrency:5, task_num:25, tot_wait:3m5.453402205s, tot_exec:338.018914ms, tot_time:3m5.791432401s, max:37.163849916s, p95:37.163849916s}	group by:tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_suppkey)->tpch50.partsupp.ps_suppkey	61.4 MB	N/A
20:41:17 [2021-06-02T20:41:17.280Z]     └─Selection_55	257492.04	295898	root		time:37.1s, loops:290	gt(cast(tpch50.partsupp.ps_availqty, decimal(20,0) BINARY), mul(0.5, Column#44))	59.2 KB	N/A
20:41:17 [2021-06-02T20:41:17.280Z]       └─HashAgg_56	321865.05	435528	root		time:37s, loops:430, partial_worker:{wall_time:36.744550942s, concurrency:5, task_num:625, tot_wait:3m2.474957754s, tot_exec:1.125292724s, tot_time:3m3.714022782s, max:36.74444342s, p95:36.74444342s}, final_worker:{wall_time:37.084045674s, concurrency:5, task_num:25, tot_wait:3m3.70327631s, tot_exec:1.672184783s, tot_time:3m5.375473895s, max:37.083945526s, p95:37.083945526s}	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:41:17 [2021-06-02T20:41:17.280Z]         └─HashJoin_59	9711455.06	634004	root		time:36.7s, loops:626, build_hash_table:{total:2.5s, fetch:2.3s, build:200.2ms}, probe:{concurrency:5, total:3m3.3s, max:36.7s, probe:14s, fetch:2m49.3s}	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:41:17 [2021-06-02T20:41:17.280Z]           ├─IndexHashJoin_67(Build)	321865.05	435528	root		time:2.47s, loops:429, inner:{total:2.53s, concurrency:5, task:12, construct:112.2ms, fetch:2.1s, build:27.8ms, join:314.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)	19.9 MB	N/A
20:41:17 [2021-06-02T20:41:17.280Z]           │ ├─TableReader_96(Build)	80007.93	108882	root		time:2.12s, loops:112, cop_task: {num: 20, max: 1.57s, min: 586.4ms, avg: 1.07s, p95: 1.57s, max_proc_keys: 686055, p95_proc_keys: 686055, tot_proc: 21.4s, tot_wait: 2ms, rpc_num: 20, rpc_time: 21.4s, copr_cache: disabled}	data:Selection_95	725.8 KB	N/A
20:41:17 [2021-06-02T20:41:17.280Z]           │ │ └─Selection_95	80007.93	108882	cop[tikv]		tikv_task:{proc max:1.53s, min:582ms, p80:1.2s, 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:41:17 [2021-06-02T20:41:17.280Z]           │ │   └─TableFullScan_94	10000000.00	10000000	cop[tikv]	table:part	tikv_task:{proc max:1.44s, min:541ms, p80:1.1s, p95:1.44s, iters:9859, tasks:20}	keep order:false	N/A	N/A
20:41:17 [2021-06-02T20:41:17.280Z]           │ └─IndexLookUp_64(Probe)	4.02	435528	root		time:2.02s, loops:447, index_task: {total_time: 1.23s, fetch_handle: 1.23s, build: 93.5µs, wait: 281.3µs}, table_task: {total_time: 7.99s, num: 56, concurrency: 60}		20.5 KB	N/A
20:41:17 [2021-06-02T20:41:17.280Z]           │   ├─IndexRangeScan_62(Build)	4.02	435528	cop[tikv]	table:partsupp, index:PRIMARY(PS_PARTKEY, PS_SUPPKEY)	time:1.19s, loops:479, cop_task: {num: 62, max: 219.3ms, min: 4.62ms, avg: 86.8ms, p95: 170.3ms, max_proc_keys: 15288, p95_proc_keys: 14948, tot_proc: 4.78s, tot_wait: 269ms, rpc_num: 62, rpc_time: 5.38s, copr_cache: disabled}, tikv_task:{proc max:192ms, min:4ms, p80:135ms, p95:153ms, iters:706, tasks:62}, 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:41:17 [2021-06-02T20:41:17.280Z]           │   └─TableRowIDScan_63(Probe)	4.02	435528	cop[tikv]	table:partsupp	time:2.37s, loops:505, cop_task: {num: 1447, max: 81.6ms, min: 1.03ms, avg: 16.4ms, p95: 34.7ms, max_proc_keys: 1028, p95_proc_keys: 580, tot_proc: 18.3s, tot_wait: 3.76s, rpc_num: 1447, rpc_time: 23.8s, copr_cache: disabled}, tikv_task:{proc max:40ms, min:0s, p80:16ms, p95:24ms, iters:5344, tasks:1447}, scan_detail: {total_process_keys: 435528, total_keys: 473504, rocksdb: {delete_skipped_count: 0, key_skipped_count: 194040, block: {cache_hit_count: 3644218, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:41:17 [2021-06-02T20:41:17.280Z]           └─TableReader_101(Probe)	46310896.67	45504356	root		time:32.3s, loops:44290, cop_task: {num: 761, max: 1.07s, min: 357.9ms, avg: 680ms, p95: 824ms, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 8m34.3s, tot_wait: 131ms, rpc_num: 761, rpc_time: 8m37.4s, copr_cache: disabled}	data:Selection_100	52.6 MB	N/A
20:41:17 [2021-06-02T20:41:17.280Z]             └─Selection_100	46310896.67	45504356	cop[tikv]		tikv_task:{proc max:1.02s, min:347ms, p80:728ms, p95:806ms, 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:41:17 [2021-06-02T20:41:17.280Z]               └─TableFullScan_99	300005811.00	300005811	cop[tikv]	table:lineitem	tikv_task:{proc max:980ms, min:324ms, p80:700ms, p95:776ms, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:41:17 [2021-06-02T20:41:17.280Z] 
20:41:17 [2021-06-02T20:41:17.280Z] queries/20.sql
20:41:17 [2021-06-02T20:41:17.280Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:41:17 [2021-06-02T20:41:17.280Z] Sort_30	20000.00	8982	root		time:37.1s, loops:10	tpch50.supplier.s_name	614.3 KB	0 Bytes
20:41:17 [2021-06-02T20:41:17.280Z] └─HashJoin_35	20000.00	8982	root		time:37.1s, loops:11, build_hash_table:{total:1.27s, fetch:1.26s, build:9.13ms}, probe:{concurrency:5, total:3m5.7s, max:37.1s, probe:47.1ms, fetch:3m5.6s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.partsupp.ps_suppkey)]	1.49 MB	0 Bytes
20:41:17 [2021-06-02T20:41:17.280Z]   ├─HashJoin_48(Build)	20000.00	19972	root		time:1.27s, loops:23, build_hash_table:{total:189.9µs, fetch:183µs, build:6.93µs}, probe:{concurrency:5, total:6.36s, max:1.27s, probe:113.9ms, fetch:6.25s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:41:17 [2021-06-02T20:41:17.280Z]   │ ├─TableReader_53(Build)	1.00	1	root		time:48.8µs, loops:2, cop_task: {num: 1, max: 1.16ms, proc_keys: 25, rpc_num: 1, rpc_time: 1.15ms, copr_cache: disabled}	data:Selection_52	236 Bytes	N/A
20:41:17 [2021-06-02T20:41:17.280Z]   │ │ └─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:41:17 [2021-06-02T20:41:17.280Z]   │ │   └─TableFullScan_51	25.00	25	cop[tikv]	table:nation	tikv_task:{time:0s, loops:1}	keep order:false	N/A	N/A
20:41:17 [2021-06-02T20:41:17.280Z]   │ └─TableReader_50(Probe)	500000.00	500000	root		time:1.25s, loops:490, cop_task: {num: 1, max: 1.25s, proc_keys: 500000, tot_proc: 1.17s, rpc_num: 1, rpc_time: 1.25s, copr_cache: disabled}	data:TableFullScan_49	35.8 MB	N/A
20:41:17 [2021-06-02T20:41:17.280Z]   │   └─TableFullScan_49	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:988ms, 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:41:17 [2021-06-02T20:41:17.280Z]   └─HashAgg_54(Probe)	257492.04	223999	root		time:37.1s, loops:222, partial_worker:{wall_time:37.071410674s, concurrency:5, task_num:289, tot_wait:3m5.066260971s, tot_exec:241.792635ms, tot_time:3m5.342496889s, max:37.071345801s, p95:37.071345801s}, final_worker:{wall_time:37.134920603s, concurrency:5, task_num:25, tot_wait:3m5.335757913s, tot_exec:328.440456ms, tot_time:3m5.664208859s, max:37.134877427s, p95:37.134877427s}	group by:tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_suppkey)->tpch50.partsupp.ps_suppkey	61.4 MB	N/A
20:41:17 [2021-06-02T20:41:17.280Z]     └─Selection_55	257492.04	295898	root		time:37.1s, loops:290	gt(cast(tpch50.partsupp.ps_availqty, decimal(20,0) BINARY), mul(0.5, Column#44))	59.2 KB	N/A
20:41:17 [2021-06-02T20:41:17.280Z]       └─HashAgg_56	321865.05	435528	root		time:36.9s, loops:430, partial_worker:{wall_time:36.707659944s, concurrency:5, task_num:627, tot_wait:3m2.287018852s, tot_exec:1.118188262s, tot_time:3m3.520504494s, max:36.707609437s, p95:36.707609437s}, final_worker:{wall_time:37.059626589s, concurrency:5, task_num:25, tot_wait:3m3.471682833s, tot_exec:1.76242215s, tot_time:3m5.234120736s, max:37.059582211s, p95:37.059582211s}	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:41:17 [2021-06-02T20:41:17.280Z]         └─HashJoin_59	9711455.06	634004	root		time:36.6s, loops:628, build_hash_table:{total:2.41s, fetch:2.21s, build:202.2ms}, probe:{concurrency:5, total:3m3s, max:36.6s, probe:14.4s, fetch:2m48.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:41:17 [2021-06-02T20:41:17.280Z]           ├─IndexHashJoin_67(Build)	321865.05	435528	root		time:2.38s, loops:429, inner:{total:2.66s, concurrency:5, task:12, construct:124.6ms, fetch:2.19s, build:26.9ms, join:344.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.1 MB	N/A
20:41:17 [2021-06-02T20:41:17.280Z]           │ ├─TableReader_96(Build)	80007.93	108882	root		time:2.02s, loops:112, cop_task: {num: 20, max: 1.51s, min: 561ms, avg: 1.08s, p95: 1.51s, max_proc_keys: 686055, p95_proc_keys: 686055, tot_proc: 21.6s, tot_wait: 32ms, rpc_num: 20, rpc_time: 21.7s, copr_cache: disabled}	data:Selection_95	680.6 KB	N/A
20:41:17 [2021-06-02T20:41:17.281Z]           │ │ └─Selection_95	80007.93	108882	cop[tikv]		tikv_task:{proc max:1.47s, min:557ms, p80:1.32s, p95:1.47s, iters:9859, tasks:20}, scan_detail: {total_process_keys: 10000000, total_keys: 10000020, rocksdb: {delete_skipped_count: 0, key_skipped_count: 19999980, block: {cache_hit_count: 31499, read_count: 0, read_byte: 0 Bytes}}}	like(tpch50.part.p_name, "green%", 92)	N/A	N/A
20:41:17 [2021-06-02T20:41:17.281Z]           │ │   └─TableFullScan_94	10000000.00	10000000	cop[tikv]	table:part	tikv_task:{proc max:1.39s, min:521ms, p80:1.22s, p95:1.39s, iters:9859, tasks:20}	keep order:false	N/A	N/A
20:41:17 [2021-06-02T20:41:17.281Z]           │ └─IndexLookUp_64(Probe)	4.02	435528	root		time:2.07s, loops:447, index_task: {total_time: 1.22s, fetch_handle: 1.22s, build: 93.5µs, wait: 269.7µs}, table_task: {total_time: 8.1s, num: 56, concurrency: 60}		20.7 KB	N/A
20:41:17 [2021-06-02T20:41:17.281Z]           │   ├─IndexRangeScan_62(Build)	4.02	435528	cop[tikv]	table:partsupp, index:PRIMARY(PS_PARTKEY, PS_SUPPKEY)	time:1.18s, loops:480, cop_task: {num: 59, max: 217.9ms, min: 9.78ms, avg: 91.5ms, p95: 186.5ms, max_proc_keys: 15288, p95_proc_keys: 14948, tot_proc: 4.88s, tot_wait: 96ms, rpc_num: 59, rpc_time: 5.4s, copr_cache: disabled}, tikv_task:{proc max:193ms, min:4ms, p80:136ms, p95:177ms, iters:691, 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:41:17 [2021-06-02T20:41:17.281Z]           │   └─TableRowIDScan_63(Probe)	4.02	435528	cop[tikv]	table:partsupp	time:2.7s, loops:504, cop_task: {num: 1383, max: 75.4ms, min: 452.9µs, avg: 19.1ms, p95: 39.2ms, max_proc_keys: 928, p95_proc_keys: 628, tot_proc: 19.4s, tot_wait: 4.82s, rpc_num: 1383, rpc_time: 26.4s, copr_cache: disabled}, tikv_task:{proc max:45ms, min:0s, p80:17ms, p95:25ms, iters:5196, tasks:1383}, scan_detail: {total_process_keys: 435528, total_keys: 473515, rocksdb: {delete_skipped_count: 0, key_skipped_count: 194121, block: {cache_hit_count: 3643808, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:41:17 [2021-06-02T20:41:17.281Z]           └─TableReader_101(Probe)	46310896.67	45504356	root		time:32.3s, loops:44290, cop_task: {num: 761, max: 1.16s, min: 383.1ms, avg: 682.6ms, p95: 835.5ms, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 8m36.3s, tot_wait: 133ms, rpc_num: 761, rpc_time: 8m39.4s, copr_cache: disabled}	data:Selection_100	52.6 MB	N/A
20:41:17 [2021-06-02T20:41:17.281Z]             └─Selection_100	46310896.67	45504356	cop[tikv]		tikv_task:{proc max:1.13s, min:371ms, p80:728ms, p95:816ms, iters:296606, tasks:761}, scan_detail: {total_process_keys: 300005811, total_keys: 300006572, rocksdb: {delete_skipped_count: 0, key_skipped_count: 600010861, block: {cache_hit_count: 1124648, read_count: 0, read_byte: 0 Bytes}}}	ge(tpch50.lineitem.l_shipdate, 1993-01-01 00:00:00.000000), lt(tpch50.lineitem.l_shipdate, 1994-01-01)	N/A	N/A
20:41:17 [2021-06-02T20:41:17.281Z]               └─TableFullScan_99	300005811.00	300005811	cop[tikv]	table:lineitem	tikv_task:{proc max:1.08s, min:360ms, p80:697ms, p95:785ms, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:41:17 [2021-06-02T20:41:17.281Z] + sync
20:41:17 [2021-06-02T20:41:17.281Z] + /usr/bin/echo 3
20:42:37 [2021-06-02T20:42:37.573Z] + tiup cluster stop benchbot -y
20:42:37 [2021-06-02T20:42:37.573Z] Starting component `cluster`: /home/tidb/.tiup/components/cluster/v1.4.4/tiup-cluster stop benchbot -y
20:42:37 [2021-06-02T20:42:37.573Z] + rm -rf '/data1/tidb-deploy/*/log/*'
20:42:37 [2021-06-02T20:42:37.573Z] + rm -rf /data1/jenkins/deploy/data/tikv-20160
20:42:37 [2021-06-02T20:42:37.573Z] + rm -rf /data1/jenkins/deploy/data/pd-2379
20:42:37 [2021-06-02T20:42:37.573Z] + rm -rf /data1/jenkins/restore_data/tpch50/data/last_tikv.toml
20:42:37 [2021-06-02T20:42:37.573Z] + cp -R /data1/jenkins/restore_data/tpch50/data /data1/jenkins/deploy/data/tikv-20160
20:44:07 [2021-06-02T20:44:07.795Z] + cp -R /data1/jenkins/restore_data/tpch50/data.pd /data1/jenkins/deploy/data/pd-2379
20:44:07 [2021-06-02T20:44:07.795Z] + '[' -n '' ']'
20:44:07 [2021-06-02T20:44:07.795Z] + tiup cluster start benchbot --wait-timeout=300
20:44:07 [2021-06-02T20:44:07.795Z] Starting component `cluster`: /home/tidb/.tiup/components/cluster/v1.4.4/tiup-cluster start benchbot --wait-timeout=300
20:44:31 [2021-06-02T20:44:31.448Z] + sync
20:44:31 [2021-06-02T20:44:31.448Z] + /usr/bin/echo 3
20:45:59 [2021-06-02T20:45:59.406Z] 
20:45:59 [2021-06-02T20:45:59.406Z] queries/20.sql
20:45:59 [2021-06-02T20:45:59.406Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:45:59 [2021-06-02T20:45:59.406Z] Sort_30	20000.00	8982	root		time:37.1s, loops:10	tpch50.supplier.s_name	604.7 KB	0 Bytes
20:45:59 [2021-06-02T20:45:59.407Z] └─HashJoin_35	20000.00	8982	root		time:37.1s, loops:11, build_hash_table:{total:1.27s, fetch:1.26s, build:7.69ms}, probe:{concurrency:5, total:3m5.6s, max:37.1s, probe:68.3ms, fetch:3m5.5s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.partsupp.ps_suppkey)]	1.48 MB	0 Bytes
20:45:59 [2021-06-02T20:45:59.407Z]   ├─HashJoin_48(Build)	20000.00	19972	root		time:1.26s, loops:22, build_hash_table:{total:249.1µs, fetch:242.7µs, build:6.38µs}, probe:{concurrency:5, total:6.32s, max:1.26s, probe:82.9ms, fetch:6.24s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:45:59 [2021-06-02T20:45:59.407Z]   │ ├─TableReader_53(Build)	1.00	1	root		time:53.1µ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_52	236 Bytes	N/A
20:45:59 [2021-06-02T20:45:59.407Z]   │ │ └─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:59 [2021-06-02T20:45:59.407Z]   │ │   └─TableFullScan_51	25.00	25	cop[tikv]	table:nation	tikv_task:{time:0s, loops:1}	keep order:false	N/A	N/A
20:45:59 [2021-06-02T20:45:59.407Z]   │ └─TableReader_50(Probe)	500000.00	500000	root		time:1.25s, loops:490, cop_task: {num: 1, max: 1.25s, proc_keys: 500000, tot_proc: 1.18s, rpc_num: 1, rpc_time: 1.25s, copr_cache: disabled}	data:TableFullScan_49	35.8 MB	N/A
20:45:59 [2021-06-02T20:45:59.407Z]   │   └─TableFullScan_49	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: 1692, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:45:59 [2021-06-02T20:45:59.407Z]   └─HashAgg_54(Probe)	257492.04	223999	root		time:37.1s, loops:222, partial_worker:{wall_time:37.035371143s, concurrency:5, task_num:289, tot_wait:3m4.931756978s, tot_exec:200.421469ms, tot_time:3m5.168595668s, max:37.035311526s, p95:37.035311526s}, final_worker:{wall_time:37.111346957s, concurrency:5, task_num:25, tot_wait:3m5.162421555s, tot_exec:371.220743ms, tot_time:3m5.53365332s, max:37.111302999s, p95:37.111302999s}	group by:tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_suppkey)->tpch50.partsupp.ps_suppkey	61.4 MB	N/A
20:45:59 [2021-06-02T20:45:59.407Z]     └─Selection_55	257492.04	295898	root		time:37s, loops:290	gt(cast(tpch50.partsupp.ps_availqty, decimal(20,0) BINARY), mul(0.5, Column#44))	59.2 KB	N/A
20:45:59 [2021-06-02T20:45:59.407Z]       └─HashAgg_56	321865.05	435528	root		time:36.9s, loops:430, partial_worker:{wall_time:36.670784716s, concurrency:5, task_num:623, tot_wait:3m2.026062515s, tot_exec:1.190720457s, tot_time:3m3.337714401s, max:36.670714264s, p95:36.670714264s}, final_worker:{wall_time:37.024926742s, concurrency:5, task_num:25, tot_wait:3m3.32211353s, tot_exec:1.776431574s, tot_time:3m5.098560682s, max:37.0248955s, p95:37.0248955s}	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:59 [2021-06-02T20:45:59.407Z]         └─HashJoin_59	9711455.06	634004	root		time:36.6s, loops:624, build_hash_table:{total:2.35s, fetch:2.14s, build:210.5ms}, probe:{concurrency:5, total:3m2.8s, max:36.6s, probe:14.5s, fetch:2m48.4s}	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:59 [2021-06-02T20:45:59.407Z]           ├─IndexHashJoin_67(Build)	321865.05	435528	root		time:2.31s, loops:429, inner:{total:2.81s, concurrency:5, task:12, construct:135ms, fetch:2.35s, build:26ms, join:327ms}	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:59 [2021-06-02T20:45:59.407Z]           │ ├─TableReader_96(Build)	80007.93	108882	root		time:1.89s, loops:112, cop_task: {num: 20, max: 1.49s, min: 554.9ms, avg: 1.04s, p95: 1.49s, max_proc_keys: 686055, p95_proc_keys: 686055, tot_proc: 20.8s, tot_wait: 6ms, rpc_num: 20, rpc_time: 20.9s, copr_cache: disabled}	data:Selection_95	725.8 KB	N/A
20:45:59 [2021-06-02T20:45:59.407Z]           │ │ └─Selection_95	80007.93	108882	cop[tikv]		tikv_task:{proc max:1.48s, min:554ms, p80:1.23s, p95:1.48s, 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:59 [2021-06-02T20:45:59.407Z]           │ │   └─TableFullScan_94	10000000.00	10000000	cop[tikv]	table:part	tikv_task:{proc max:1.38s, min:505ms, p80:1.14s, p95:1.38s, iters:9859, tasks:20}	keep order:false	N/A	N/A
20:45:59 [2021-06-02T20:45:59.407Z]           │ └─IndexLookUp_64(Probe)	4.02	435528	root		time:2.25s, loops:447, index_task: {total_time: 1.29s, fetch_handle: 1.29s, build: 114µs, wait: 295.5µs}, table_task: {total_time: 8.57s, num: 56, concurrency: 60}		20.5 KB	N/A
20:45:59 [2021-06-02T20:45:59.407Z]           │   ├─IndexRangeScan_62(Build)	4.02	435528	cop[tikv]	table:partsupp, index:PRIMARY(PS_PARTKEY, PS_SUPPKEY)	time:1.25s, loops:482, cop_task: {num: 58, max: 246.1ms, min: 4.59ms, avg: 96ms, p95: 227.8ms, max_proc_keys: 15288, p95_proc_keys: 14948, tot_proc: 5.2s, tot_wait: 40ms, rpc_num: 58, rpc_time: 5.57s, copr_cache: disabled}, tikv_task:{proc max:235ms, min:4ms, p80:150ms, p95:218ms, 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:45:59 [2021-06-02T20:45:59.407Z]           │   └─TableRowIDScan_63(Probe)	4.02	435528	cop[tikv]	table:partsupp	time:2.88s, loops:507, cop_task: {num: 1440, max: 101.9ms, min: 904.9µs, avg: 20.2ms, p95: 41.8ms, max_proc_keys: 1092, p95_proc_keys: 576, tot_proc: 20s, tot_wait: 6.05s, rpc_num: 1440, rpc_time: 29s, copr_cache: disabled}, tikv_task:{proc max:52ms, min:0s, p80:17ms, p95:25ms, iters:5325, tasks:1440}, scan_detail: {total_process_keys: 435528, total_keys: 473493, rocksdb: {delete_skipped_count: 0, key_skipped_count: 194013, block: {cache_hit_count: 3644429, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:45:59 [2021-06-02T20:45:59.407Z]           └─TableReader_101(Probe)	46310896.67	45504356	root		time:32.3s, loops:44289, cop_task: {num: 761, max: 1.14s, min: 393.4ms, avg: 682.7ms, p95: 827.7ms, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 8m36.3s, tot_wait: 160ms, rpc_num: 761, rpc_time: 8m39.5s, copr_cache: disabled}	data:Selection_100	52.6 MB	N/A
20:45:59 [2021-06-02T20:45:59.407Z]             └─Selection_100	46310896.67	45504356	cop[tikv]		tikv_task:{proc max:1.08s, min:383ms, p80:734ms, p95:806ms, 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:59 [2021-06-02T20:45:59.407Z]               └─TableFullScan_99	300005811.00	300005811	cop[tikv]	table:lineitem	tikv_task:{proc max:1.04s, min:366ms, p80:703ms, p95:774ms, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:45:59 [2021-06-02T20:45:59.407Z] 
20:45:59 [2021-06-02T20:45:59.407Z] queries/21.sql
20:45:59 [2021-06-02T20:45:59.407Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:45:59 [2021-06-02T20:45:59.407Z] Projection_26	100.00	100	root		time:1m21.3s, loops:2, Concurrency:OFF	tpch50.supplier.s_name, Column#72	4.62 KB	N/A
20:45:59 [2021-06-02T20:45:59.407Z] └─TopN_29	100.00	100	root		time:1m21.3s, loops:2	Column#72:desc, tpch50.supplier.s_name, offset:0, count:100	58.4 KB	N/A
20:45:59 [2021-06-02T20:45:59.407Z]   └─HashAgg_34	12800.00	20057	root		time:1m21.3s, loops:21, partial_worker:{wall_time:1m21.271114026s, concurrency:5, task_num:196, tot_wait:6m46.079243788s, tot_exec:262.573529ms, tot_time:6m46.354391343s, max:1m21.271089494s, p95:1m21.271089494s}, final_worker:{wall_time:0s, concurrency:5, task_num:25, tot_wait:6m46.352916715s, tot_exec:87.042646ms, tot_time:6m46.439972505s, max:1m21.290546754s, p95:1m21.290546754s}	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:59 [2021-06-02T20:45:59.407Z]     └─IndexHashJoin_42	7828961.66	198698	root		time:1m21.3s, loops:197, inner:{total:2m19.8s, concurrency:5, task:146, construct:6.16s, fetch:1m57.1s, 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.1 MB	N/A
20:45:59 [2021-06-02T20:45:59.407Z]       ├─IndexHashJoin_83(Build)	9786202.08	3542799	root		time:1m20.7s, loops:3463, inner:{total:2m29s, concurrency:5, task:152, construct:8.01s, fetch:2m3.8s, build:1.27s, 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:45:59 [2021-06-02T20:45:59.407Z]       │ ├─IndexJoin_99(Build)	12232752.60	3675878	root		time:1m20.3s, loops:3595, inner:{total:2m7.9s, concurrency:5, task:305, construct:16.5s, fetch:1m49.5s, build:2.03s}, probe:5.44s	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:45:59 [2021-06-02T20:45:59.407Z]       │ │ ├─HashJoin_107(Build)	12232752.60	7609895	root		time:1m19.7s, loops:7435, build_hash_table:{total:846.6ms, fetch:838.4ms, build:8.24ms}, probe:{concurrency:5, total:6m41.1s, max:1m20.2s, probe:1m0.1s, fetch:5m40.9s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.lineitem.l_suppkey)]	757.3 KB	0 Bytes
20:45:59 [2021-06-02T20:45:59.407Z]       │ │ │ ├─HashJoin_120(Build)	20000.00	20058	root		time:843.8ms, loops:23, build_hash_table:{total:1.84ms, fetch:280.2µs, build:1.56ms}, probe:{concurrency:5, total:4.22s, max:845.2ms, probe:80.2ms, fetch:4.14s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:45:59 [2021-06-02T20:45:59.407Z]       │ │ │ │ ├─TableReader_125(Build)	1.00	1	root		time:114.4µs, loops:2, cop_task: {num: 1, max: 1.03ms, proc_keys: 25, tot_proc: 1ms, rpc_num: 1, rpc_time: 1.02ms, copr_cache: disabled}	data:Selection_124	238 Bytes	N/A
20:45:59 [2021-06-02T20:45:59.407Z]       │ │ │ │ │ └─Selection_124	1.00	1	cop[tikv]		tikv_task:{time:0s, loops:1}, scan_detail: {total_process_keys: 25, total_keys: 26, rocksdb: {delete_skipped_count: 0, key_skipped_count: 46, block: {cache_hit_count: 18, read_count: 0, read_byte: 0 Bytes}}}	eq(tpch50.nation.n_name, "EGYPT")	N/A	N/A
20:45:59 [2021-06-02T20:45:59.407Z]       │ │ │ │ │   └─TableFullScan_123	25.00	25	cop[tikv]	table:nation	tikv_task:{time:0s, loops:1}	keep order:false	N/A	N/A
20:45:59 [2021-06-02T20:45:59.407Z]       │ │ │ │ └─TableReader_122(Probe)	500000.00	500000	root		time:828.4ms, loops:490, cop_task: {num: 1, max: 941.6ms, proc_keys: 500000, tot_proc: 904ms, rpc_num: 1, rpc_time: 941.6ms, copr_cache: disabled}	data:TableFullScan_121	20.0 MB	N/A
20:45:59 [2021-06-02T20:45:59.407Z]       │ │ │ │   └─TableFullScan_121	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:856ms, 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:59 [2021-06-02T20:45:59.407Z]       │ │ │ └─TableReader_128(Probe)	240004648.80	189670348	root		time:1m8s, loops:184596, cop_task: {num: 761, max: 2.75s, min: 252.1ms, avg: 1.53s, p95: 2.03s, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 18m14.4s, tot_wait: 59.2s, rpc_num: 761, rpc_time: 19m27.2s, copr_cache: disabled}	data:Selection_127	99.2 MB	N/A
20:45:59 [2021-06-02T20:45:59.407Z]       │ │ │   └─Selection_127	240004648.80	189670348	cop[tikv]		tikv_task:{proc max:1.33s, min:237ms, p80:1.18s, p95:1.23s, iters:296606, tasks:761}, scan_detail: {total_process_keys: 300005811, total_keys: 300006572, rocksdb: {delete_skipped_count: 0, key_skipped_count: 600010861, block: {cache_hit_count: 18665, read_count: 1131794, read_byte: 23.9 GB}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:45:59 [2021-06-02T20:45:59.407Z]       │ │ │     └─TableFullScan_126	300005811.00	300005811	cop[tikv]	table:l1	tikv_task:{proc max:1.25s, min:224ms, p80:1.1s, p95:1.15s, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:45:59 [2021-06-02T20:45:59.408Z]       │ │ └─TableReader_95(Probe)	0.49	3496190	root		time:1m40.2s, loops:3875, cop_task: {num: 5276, max: 582.9ms, min: 1.68ms, avg: 177.7ms, p95: 333.3ms, max_proc_keys: 3486, p95_proc_keys: 1951, tot_proc: 11m10.7s, tot_wait: 3m48.2s, rpc_num: 5276, rpc_time: 15m37.5s, copr_cache: disabled}	data:Selection_94	N/A	N/A
20:45:59 [2021-06-02T20:45:59.408Z]       │ │   └─Selection_94	0.49	3496190	cop[tikv]		tikv_task:{proc max:150ms, min:0s, p80:70ms, p95:83ms, iters:30237, tasks:5276}, scan_detail: {total_process_keys: 7236293, total_keys: 7795509, rocksdb: {delete_skipped_count: 0, key_skipped_count: 1778304, block: {cache_hit_count: 54007000, read_count: 220118, read_byte: 4.76 GB}}}	eq(tpch50.orders.o_orderstatus, "F")	N/A	N/A
20:45:59 [2021-06-02T20:45:59.408Z]       │ │     └─TableRangeScan_93	1.00	7236293	cop[tikv]	table:orders	tikv_task:{proc max:150ms, min:0s, p80:70ms, p95:83ms, iters:30237, tasks:5276}	range: decided by [tpch50.lineitem.l_orderkey], keep order:false	N/A	N/A
20:45:59 [2021-06-02T20:45:59.408Z]       │ └─IndexLookUp_80(Probe)	4.05	17316529	root		time:1m58.2s, loops:17132, index_task: {total_time: 1m5.9s, fetch_handle: 58.2s, build: 3.33ms, wait: 7.69s}, table_task: {total_time: 8m33.3s, num: 1458, concurrency: 760}		28.5 KB	N/A
20:45:59 [2021-06-02T20:45:59.408Z]       │   ├─IndexRangeScan_78(Build)	4.05	17316529	cop[tikv]	table:l2, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:56s, loops:18649, cop_task: {num: 3048, max: 662.5ms, min: 674.8µs, avg: 188.7ms, p95: 370.6ms, max_proc_keys: 11195, p95_proc_keys: 8729, tot_proc: 7m13.2s, tot_wait: 2m1.5s, rpc_num: 3048, rpc_time: 9m35.2s, copr_cache: disabled}, tikv_task:{proc max:184ms, min:0s, p80:98ms, p95:114ms, iters:30386, tasks:3048}, scan_detail: {total_process_keys: 17316529, total_keys: 20812644, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17316529, block: {cache_hit_count: 24260277, read_count: 226871, read_byte: 2.40 GB}}}	range: decided by [eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey)], keep order:false	N/A	N/A
20:45:59 [2021-06-02T20:45:59.408Z]       │   └─TableRowIDScan_79(Probe)	4.05	17316529	cop[tikv]	table:l2	time:6m16.8s, loops:21008, cop_task: {num: 7855, max: 718.3ms, min: 633.1µs, avg: 175.7ms, p95: 351.1ms, max_proc_keys: 12646, p95_proc_keys: 4823, tot_proc: 16m31.7s, tot_wait: 5m38.5s, rpc_num: 7855, rpc_time: 22m59.7s, copr_cache: disabled}, tikv_task:{proc max:294ms, min:0s, p80:104ms, p95:140ms, iters:50033, tasks:7855}, scan_detail: {total_process_keys: 17316529, total_keys: 18289334, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5626893, block: {cache_hit_count: 99026921, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:45:59 [2021-06-02T20:45:59.408Z]       └─IndexLookUp_39(Probe)	4.05	12022803	root		time:1m52.3s, loops:11939, index_task: {total_time: 1m1.2s, fetch_handle: 51.3s, build: 3.3ms, wait: 9.95s}, table_task: {total_time: 8m3s, num: 1408, concurrency: 730}		218.0 KB	N/A
20:45:59 [2021-06-02T20:45:59.408Z]         ├─IndexRangeScan_36(Build)	5.06	17183389	cop[tikv]	table:l3, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:48.8s, loops:18382, cop_task: {num: 2806, max: 923ms, min: 645.6µs, avg: 163.6ms, p95: 353.9ms, max_proc_keys: 23218, p95_proc_keys: 13737, tot_proc: 5m42s, tot_wait: 1m36.6s, rpc_num: 2806, rpc_time: 7m38.9s, copr_cache: disabled}, tikv_task:{proc max:224ms, min:0s, p80:79ms, p95:124ms, iters:29216, tasks:2806}, scan_detail: {total_process_keys: 17183389, total_keys: 20546417, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17183389, 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:45:59 [2021-06-02T20:45:59.408Z]         └─Selection_38(Probe)	4.05	12022803	cop[tikv]		time:6m9.2s, loops:13755, cop_task: {num: 10307, max: 721ms, min: 536.1µs, avg: 171.6ms, p95: 343ms, max_proc_keys: 7126, p95_proc_keys: 3962, tot_proc: 20m43.6s, tot_wait: 7m40.4s, rpc_num: 10307, rpc_time: 29m28.4s, copr_cache: disabled}, tikv_task:{proc max:267ms, min:0s, p80:76ms, p95:116ms, iters:60945, tasks:10307}, scan_detail: {total_process_keys: 17183389, total_keys: 18128843, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5526160, block: {cache_hit_count: 98290167, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:45:59 [2021-06-02T20:45:59.408Z]           └─TableRowIDScan_37	5.06	17183389	cop[tikv]	table:l3	tikv_task:{proc max:265ms, min:0s, p80:75ms, p95:115ms, iters:60945, tasks:10307}	keep order:false	N/A	N/A
20:45:59 [2021-06-02T20:45:59.408Z] + sync
20:45:59 [2021-06-02T20:45:59.408Z] + /usr/bin/echo 3
20:47:27 [2021-06-02T20:47:27.534Z] 
20:47:27 [2021-06-02T20:47:27.534Z] queries/21.sql
20:47:27 [2021-06-02T20:47:27.534Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:47:27 [2021-06-02T20:47:27.534Z] Projection_26	100.00	100	root		time:1m19.6s, loops:2, Concurrency:OFF	tpch50.supplier.s_name, Column#72	4.62 KB	N/A
20:47:27 [2021-06-02T20:47:27.534Z] └─TopN_29	100.00	100	root		time:1m19.6s, loops:2	Column#72:desc, tpch50.supplier.s_name, offset:0, count:100	55.9 KB	N/A
20:47:27 [2021-06-02T20:47:27.534Z]   └─HashAgg_34	12800.00	20057	root		time:1m19.6s, loops:21, partial_worker:{wall_time:1m19.574712256s, concurrency:5, task_num:197, tot_wait:6m37.60386728s, tot_exec:257.721885ms, tot_time:6m37.87260464s, max:1m19.5746909s, p95:1m19.5746909s}, final_worker:{wall_time:1m19.586272333s, concurrency:5, task_num:25, tot_wait:6m37.871797152s, tot_exec:59.253449ms, tot_time:6m37.931062223s, max:1m19.586260947s, p95:1m19.586260947s}	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:47:27 [2021-06-02T20:47:27.534Z]     └─IndexHashJoin_42	7828961.66	198698	root		time:1m19.6s, loops:198, inner:{total:2m18s, concurrency:5, task:146, construct:6s, fetch:1m56.2s, build:1.16s, join:15.8s}	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:47:27 [2021-06-02T20:47:27.534Z]       ├─IndexHashJoin_83(Build)	9786202.08	3542799	root		time:1m19s, loops:3463, inner:{total:2m26.2s, concurrency:5, task:152, construct:7.57s, fetch:2m1.6s, build:1.24s, join:17s}	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:47:27 [2021-06-02T20:47:27.534Z]       │ ├─IndexJoin_99(Build)	12232752.60	3675878	root		time:1m18.3s, loops:3595, inner:{total:2m5.4s, concurrency:5, task:305, construct:15.5s, fetch:1m48s, build:1.95s}, probe:5.02s	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:47:27 [2021-06-02T20:47:27.534Z]       │ │ ├─HashJoin_107(Build)	12232752.60	7609895	root		time:1m17.8s, loops:7437, build_hash_table:{total:1.04s, fetch:1.04s, build:6.29ms}, probe:{concurrency:5, total:6m31s, max:1m18.2s, probe:59.6s, fetch:5m31.5s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.lineitem.l_suppkey)]	713.1 KB	0 Bytes
20:47:27 [2021-06-02T20:47:27.534Z]       │ │ │ ├─HashJoin_120(Build)	20000.00	20058	root		time:1.04s, loops:21, build_hash_table:{total:222.4µs, fetch:217.9µs, build:4.45µs}, probe:{concurrency:5, total:5.2s, max:1.04s, probe:61.9ms, fetch:5.14s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:47:27 [2021-06-02T20:47:27.534Z]       │ │ │ │ ├─TableReader_125(Build)	1.00	1	root		time:54.7µs, loops:2, cop_task: {num: 1, max: 1.4ms, proc_keys: 25, rpc_num: 1, rpc_time: 1.39ms, copr_cache: disabled}	data:Selection_124	244 Bytes	N/A
20:47:27 [2021-06-02T20:47:27.534Z]       │ │ │ │ │ └─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:47:27 [2021-06-02T20:47:27.535Z]       │ │ │ │ │   └─TableFullScan_123	25.00	25	cop[tikv]	table:nation	tikv_task:{time:0s, loops:1}	keep order:false	N/A	N/A
20:47:27 [2021-06-02T20:47:27.535Z]       │ │ │ │ └─TableReader_122(Probe)	500000.00	500000	root		time:1.03s, loops:490, cop_task: {num: 1, max: 1.03s, proc_keys: 500000, tot_proc: 996ms, tot_wait: 1ms, rpc_num: 1, rpc_time: 1.03s, copr_cache: disabled}	data:TableFullScan_121	20.0 MB	N/A
20:47:27 [2021-06-02T20:47:27.535Z]       │ │ │ │   └─TableFullScan_121	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:934ms, 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:47:27 [2021-06-02T20:47:27.535Z]       │ │ │ └─TableReader_128(Probe)	240004648.80	189670348	root		time:1m5.6s, loops:184598, cop_task: {num: 761, max: 2.65s, min: 267.4ms, avg: 1.5s, p95: 1.95s, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 17m48.8s, tot_wait: 1m1.3s, rpc_num: 761, rpc_time: 19m3.7s, copr_cache: disabled}	data:Selection_127	109.4 MB	N/A
20:47:27 [2021-06-02T20:47:27.535Z]       │ │ │   └─Selection_127	240004648.80	189670348	cop[tikv]		tikv_task:{proc max:1.32s, min:252ms, p80:1.15s, 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:47:27 [2021-06-02T20:47:27.535Z]       │ │ │     └─TableFullScan_126	300005811.00	300005811	cop[tikv]	table:l1	tikv_task:{proc max:1.23s, min:235ms, p80:1.07s, p95:1.13s, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:47:27 [2021-06-02T20:47:27.535Z]       │ │ └─TableReader_95(Probe)	0.49	3496168	root		time:1m39.4s, loops:3875, cop_task: {num: 5278, max: 582ms, min: 2.39ms, avg: 176ms, p95: 340.9ms, max_proc_keys: 3556, p95_proc_keys: 1976, tot_proc: 11m10.2s, tot_wait: 3m40.2s, rpc_num: 5278, rpc_time: 15m28.6s, copr_cache: disabled}	data:Selection_94	N/A	N/A
20:47:27 [2021-06-02T20:47:27.535Z]       │ │   └─Selection_94	0.49	3496168	cop[tikv]		tikv_task:{proc max:134ms, min:0s, p80:68ms, p95:81ms, iters:30275, tasks:5278}, scan_detail: {total_process_keys: 7236251, total_keys: 7795460, rocksdb: {delete_skipped_count: 0, key_skipped_count: 1778299, block: {cache_hit_count: 54006775, read_count: 218205, read_byte: 4.21 GB}}}	eq(tpch50.orders.o_orderstatus, "F")	N/A	N/A
20:47:27 [2021-06-02T20:47:27.535Z]       │ │     └─TableRangeScan_93	1.00	7236251	cop[tikv]	table:orders	tikv_task:{proc max:132ms, min:0s, p80:68ms, p95:81ms, iters:30275, tasks:5278}	range: decided by [tpch50.lineitem.l_orderkey], keep order:false	N/A	N/A
20:47:27 [2021-06-02T20:47:27.535Z]       │ └─IndexLookUp_80(Probe)	4.05	17316336	root		time:1m56.2s, loops:17131, index_task: {total_time: 1m3.4s, fetch_handle: 55.5s, build: 3.15ms, wait: 7.86s}, table_task: {total_time: 8m21.8s, num: 1458, concurrency: 760}		18.9 KB	N/A
20:47:27 [2021-06-02T20:47:27.535Z]       │   ├─IndexRangeScan_78(Build)	4.05	17316336	cop[tikv]	table:l2, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:53.2s, loops:18618, cop_task: {num: 3011, max: 674.8ms, min: 524.5µs, avg: 183.4ms, p95: 370.2ms, max_proc_keys: 13400, p95_proc_keys: 8774, tot_proc: 6m55.6s, tot_wait: 1m55.9s, rpc_num: 3011, rpc_time: 9m12.1s, copr_cache: disabled}, tikv_task:{proc max:176ms, min:0s, p80:95ms, p95:111ms, iters:30139, tasks:3011}, scan_detail: {total_process_keys: 17316336, total_keys: 20812416, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17316336, block: {cache_hit_count: 24259794, read_count: 225693, 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:47:27 [2021-06-02T20:47:27.535Z]       │   └─TableRowIDScan_79(Probe)	4.05	17316336	cop[tikv]	table:l2	time:6m11.3s, loops:21024, cop_task: {num: 7834, max: 648ms, min: 822.1µs, avg: 174.3ms, p95: 352.1ms, max_proc_keys: 8819, p95_proc_keys: 4868, tot_proc: 16m19.3s, tot_wait: 5m37.2s, rpc_num: 7834, rpc_time: 22m45.1s, copr_cache: disabled}, tikv_task:{proc max:235ms, min:0s, p80:103ms, p95:138ms, iters:50051, tasks:7834}, scan_detail: {total_process_keys: 17316336, total_keys: 18289141, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5628605, block: {cache_hit_count: 99017011, read_count: 1125, read_byte: 417.7 MB}}}	keep order:false	N/A	N/A
20:47:27 [2021-06-02T20:47:27.535Z]       └─IndexLookUp_39(Probe)	4.05	12022727	root		time:1m51.3s, loops:11944, index_task: {total_time: 59.6s, fetch_handle: 48.9s, build: 8.85ms, wait: 10.7s}, table_task: {total_time: 8m0.5s, num: 1408, concurrency: 730}		266.6 KB	N/A
20:47:27 [2021-06-02T20:47:27.535Z]         ├─IndexRangeScan_36(Build)	5.06	17183298	cop[tikv]	table:l3, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:46.5s, loops:18398, cop_task: {num: 2810, max: 799.5ms, min: 635.6µs, avg: 165.1ms, p95: 356.5ms, max_proc_keys: 18469, p95_proc_keys: 13685, tot_proc: 5m44.9s, tot_wait: 1m38.8s, rpc_num: 2810, rpc_time: 7m43.9s, copr_cache: disabled}, tikv_task:{proc max:183ms, min:0s, p80:78ms, p95:122ms, iters:29192, tasks:2810}, scan_detail: {total_process_keys: 17183298, total_keys: 20546308, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17183298, block: {cache_hit_count: 23553876, 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:47:27 [2021-06-02T20:47:27.535Z]         └─Selection_38(Probe)	4.05	12022727	cop[tikv]		time:6m9.7s, loops:13760, cop_task: {num: 10273, max: 568.9ms, min: 681.9µs, avg: 172.2ms, p95: 344.7ms, max_proc_keys: 8014, p95_proc_keys: 3961, tot_proc: 20m44.1s, tot_wait: 7m41.2s, rpc_num: 10273, rpc_time: 29m28.7s, copr_cache: disabled}, tikv_task:{proc max:243ms, min:0s, p80:75ms, p95:115ms, iters:60834, tasks:10273}, scan_detail: {total_process_keys: 17183298, total_keys: 18129070, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5524736, block: {cache_hit_count: 98295867, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:47:27 [2021-06-02T20:47:27.535Z]           └─TableRowIDScan_37	5.06	17183298	cop[tikv]	table:l3	tikv_task:{proc max:243ms, min:0s, p80:75ms, p95:114ms, iters:60834, tasks:10273}	keep order:false	N/A	N/A
20:47:27 [2021-06-02T20:47:27.535Z] + sync
20:47:27 [2021-06-02T20:47:27.535Z] + /usr/bin/echo 3
20:48:43 [2021-06-02T20:48:43.401Z] 
20:48:43 [2021-06-02T20:48:43.401Z] queries/21.sql
20:48:43 [2021-06-02T20:48:43.401Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:48:43 [2021-06-02T20:48:43.401Z] Projection_26	100.00	100	root		time:1m19.9s, loops:2, Concurrency:OFF	tpch50.supplier.s_name, Column#72	4.62 KB	N/A
20:48:43 [2021-06-02T20:48:43.401Z] └─TopN_29	100.00	100	root		time:1m19.9s, loops:2	Column#72:desc, tpch50.supplier.s_name, offset:0, count:100	58.4 KB	N/A
20:48:43 [2021-06-02T20:48:43.401Z]   └─HashAgg_34	12800.00	20057	root		time:1m19.9s, loops:21, partial_worker:{wall_time:1m19.875657655s, concurrency:5, task_num:197, tot_wait:6m39.107175015s, tot_exec:237.276423ms, tot_time:6m39.370994001s, max:1m19.875629098s, p95:1m19.875629098s}, final_worker:{wall_time:1m19.885953697s, concurrency:5, task_num:25, tot_wait:6m39.363776365s, tot_exec:65.21845ms, tot_time:6m39.429007062s, max:1m19.885924981s, p95:1m19.885924981s}	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:43 [2021-06-02T20:48:43.401Z]     └─IndexHashJoin_42	7828961.66	198698	root		time:1m19.9s, loops:198, inner:{total:2m17.1s, concurrency:5, task:146, construct:5.97s, fetch:1m55s, build:1.14s, 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.1 MB	N/A
20:48:43 [2021-06-02T20:48:43.401Z]       ├─IndexHashJoin_83(Build)	9786202.08	3542799	root		time:1m19.4s, loops:3463, inner:{total:2m26.9s, concurrency:5, task:152, construct:7.53s, fetch:2m3.1s, build:1.22s, join:16.3s}	semi join, inner:IndexLookUp_80, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey), ne(tpch50.lineitem.l_suppkey, tpch50.supplier.s_suppkey)	555.9 MB	N/A
20:48:43 [2021-06-02T20:48:43.401Z]       │ ├─IndexJoin_99(Build)	12232752.60	3675878	root		time:1m18.8s, loops:3595, inner:{total:2m5.1s, concurrency:5, task:305, construct:15.6s, fetch:1m47.4s, build:2.05s}, 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.2 MB	N/A
20:48:43 [2021-06-02T20:48:43.401Z]       │ │ ├─HashJoin_107(Build)	12232752.60	7609895	root		time:1m18.3s, loops:7435, build_hash_table:{total:1.08s, fetch:1.07s, build:5.76ms}, probe:{concurrency:5, total:6m33.2s, max:1m18.6s, probe:1m0.7s, fetch:5m32.5s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.lineitem.l_suppkey)]	737.6 KB	0 Bytes
20:48:43 [2021-06-02T20:48:43.401Z]       │ │ │ ├─HashJoin_120(Build)	20000.00	20058	root		time:1.08s, loops:22, build_hash_table:{total:181.2µs, fetch:176.7µs, build:4.5µs}, probe:{concurrency:5, total:5.39s, max:1.08s, probe:58.1ms, fetch:5.33s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:48:43 [2021-06-02T20:48:43.401Z]       │ │ │ │ ├─TableReader_125(Build)	1.00	1	root		time:43.2µs, loops:2, cop_task: {num: 1, max: 1.36ms, proc_keys: 25, tot_proc: 1ms, rpc_num: 1, rpc_time: 1.34ms, copr_cache: disabled}	data:Selection_124	248 Bytes	N/A
20:48:43 [2021-06-02T20:48:43.401Z]       │ │ │ │ │ └─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:48:43 [2021-06-02T20:48:43.401Z]       │ │ │ │ │   └─TableFullScan_123	25.00	25	cop[tikv]	table:nation	tikv_task:{time:1ms, loops:1}	keep order:false	N/A	N/A
20:48:43 [2021-06-02T20:48:43.401Z]       │ │ │ │ └─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, rpc_num: 1, rpc_time: 1.07s, copr_cache: disabled}	data:TableFullScan_121	20.0 MB	N/A
20:48:43 [2021-06-02T20:48:43.401Z]       │ │ │ │   └─TableFullScan_121	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:982ms, loops:493}, scan_detail: {total_process_keys: 500000, total_keys: 500001, rocksdb: {delete_skipped_count: 0, key_skipped_count: 999999, block: {cache_hit_count: 13, read_count: 1679, read_byte: 104.5 MB}}}	keep order:false	N/A	N/A
20:48:43 [2021-06-02T20:48:43.401Z]       │ │ │ └─TableReader_128(Probe)	240004648.80	189670348	root		time:1m5.9s, loops:184597, cop_task: {num: 761, max: 2.51s, min: 284.7ms, avg: 1.51s, p95: 1.99s, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 17m57.7s, tot_wait: 58s, rpc_num: 761, rpc_time: 19m9s, copr_cache: disabled}	data:Selection_127	109.4 MB	N/A
20:48:43 [2021-06-02T20:48:43.401Z]       │ │ │   └─Selection_127	240004648.80	189670348	cop[tikv]		tikv_task:{proc max:1.31s, min:272ms, p80:1.15s, 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: 10452, read_count: 1114196, read_byte: 23.6 GB}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:48:43 [2021-06-02T20:48:43.401Z]       │ │ │     └─TableFullScan_126	300005811.00	300005811	cop[tikv]	table:l1	tikv_task:{proc max:1.24s, min:256ms, p80:1.08s, p95:1.13s, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:48:43 [2021-06-02T20:48:43.401Z]       │ │ └─TableReader_95(Probe)	0.49	3496190	root		time:1m38.6s, loops:3875, cop_task: {num: 5291, max: 522.5ms, min: 1.25ms, avg: 174.2ms, p95: 326.1ms, max_proc_keys: 4507, p95_proc_keys: 1965, tot_proc: 11m4.5s, tot_wait: 3m39.2s, rpc_num: 5291, rpc_time: 15m21.4s, copr_cache: disabled}	data:Selection_94	N/A	N/A
20:48:43 [2021-06-02T20:48:43.401Z]       │ │   └─Selection_94	0.49	3496190	cop[tikv]		tikv_task:{proc max:180ms, min:0s, p80:68ms, p95:81ms, iters:30343, tasks:5291}, scan_detail: {total_process_keys: 7236304, total_keys: 7795474, rocksdb: {delete_skipped_count: 0, key_skipped_count: 1778204, block: {cache_hit_count: 54006381, read_count: 218238, read_byte: 4.21 GB}}}	eq(tpch50.orders.o_orderstatus, "F")	N/A	N/A
20:48:43 [2021-06-02T20:48:43.401Z]       │ │     └─TableRangeScan_93	1.00	7236304	cop[tikv]	table:orders	tikv_task:{proc max:179ms, min:0s, p80:68ms, p95:81ms, iters:30343, tasks:5291}	range: decided by [tpch50.lineitem.l_orderkey], keep order:false	N/A	N/A
20:48:43 [2021-06-02T20:48:43.401Z]       │ └─IndexLookUp_80(Probe)	4.05	17316514	root		time:1m58s, loops:17129, index_task: {total_time: 1m5s, fetch_handle: 56s, build: 6.68ms, wait: 9s}, table_task: {total_time: 8m26.7s, num: 1458, concurrency: 760}		19.2 KB	N/A
20:48:43 [2021-06-02T20:48:43.401Z]       │   ├─IndexRangeScan_78(Build)	4.05	17316514	cop[tikv]	table:l2, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:53.9s, loops:18624, cop_task: {num: 2985, max: 725.4ms, min: 625.6µs, avg: 189ms, p95: 379.1ms, max_proc_keys: 11342, p95_proc_keys: 8802, tot_proc: 7m1.9s, tot_wait: 2m1.3s, rpc_num: 2985, rpc_time: 9m24.1s, copr_cache: disabled}, tikv_task:{proc max:158ms, min:0s, p80:95ms, p95:110ms, iters:30086, tasks:2985}, scan_detail: {total_process_keys: 17316514, total_keys: 20812629, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17316514, block: {cache_hit_count: 24260057, read_count: 225675, 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:43 [2021-06-02T20:48:43.401Z]       │   └─TableRowIDScan_79(Probe)	4.05	17316514	cop[tikv]	table:l2	time:6m16.3s, loops:20985, cop_task: {num: 7777, max: 649.7ms, min: 383.5µs, avg: 176ms, p95: 356.2ms, max_proc_keys: 10941, p95_proc_keys: 4811, tot_proc: 16m31s, tot_wait: 5m29s, rpc_num: 7777, rpc_time: 22m48.3s, copr_cache: disabled}, tikv_task:{proc max:300ms, min:0s, p80:104ms, p95:138ms, iters:49882, tasks:7777}, scan_detail: {total_process_keys: 17316514, total_keys: 18288990, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5625522, block: {cache_hit_count: 99025593, read_count: 1106, read_byte: 386.8 MB}}}	keep order:false	N/A	N/A
20:48:43 [2021-06-02T20:48:43.401Z]       └─IndexLookUp_39(Probe)	4.05	12022829	root		time:1m50.3s, loops:11942, index_task: {total_time: 58.5s, fetch_handle: 48.4s, build: 3.06ms, wait: 10s}, table_task: {total_time: 7m52.7s, num: 1408, concurrency: 730}		215.5 KB	N/A
20:48:43 [2021-06-02T20:48:43.401Z]         ├─IndexRangeScan_36(Build)	5.06	17183446	cop[tikv]	table:l3, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:46.3s, loops:18302, cop_task: {num: 2744, max: 698.6ms, min: 467.6µs, avg: 165.7ms, p95: 353.2ms, max_proc_keys: 18478, p95_proc_keys: 13747, tot_proc: 5m40.1s, tot_wait: 1m35s, rpc_num: 2744, rpc_time: 7m34.5s, copr_cache: disabled}, tikv_task:{proc max:197ms, min:0s, p80:82ms, p95:122ms, iters:28882, tasks:2744}, scan_detail: {total_process_keys: 17183446, total_keys: 20546485, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17183446, block: {cache_hit_count: 23554079, 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:43 [2021-06-02T20:48:43.401Z]         └─Selection_38(Probe)	4.05	12022829	cop[tikv]		time:6m2.7s, loops:13775, cop_task: {num: 10183, max: 614.1ms, min: 394.3µs, avg: 168ms, p95: 341.5ms, max_proc_keys: 8247, p95_proc_keys: 3962, tot_proc: 20m7.1s, tot_wait: 7m21.1s, rpc_num: 10183, rpc_time: 28m30.8s, copr_cache: disabled}, tikv_task:{proc max:208ms, min:0s, p80:76ms, p95:115ms, iters:60437, tasks:10183}, scan_detail: {total_process_keys: 17183446, total_keys: 18129133, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5525935, block: {cache_hit_count: 98290539, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:48:43 [2021-06-02T20:48:43.401Z]           └─TableRowIDScan_37	5.06	17183446	cop[tikv]	table:l3	tikv_task:{proc max:206ms, min:0s, p80:75ms, p95:114ms, iters:60437, tasks:10183}	keep order:false	N/A	N/A
20:48:43 [2021-06-02T20:48:43.401Z] + sync
20:48:43 [2021-06-02T20:48:43.401Z] + /usr/bin/echo 3
20:50:07 [2021-06-02T20:50:07.450Z] 
20:50:07 [2021-06-02T20:50:07.450Z] queries/21.sql
20:50:07 [2021-06-02T20:50:07.450Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:50:07 [2021-06-02T20:50:07.450Z] Projection_26	100.00	100	root		time:1m20s, loops:2, Concurrency:OFF	tpch50.supplier.s_name, Column#72	4.62 KB	N/A
20:50:07 [2021-06-02T20:50:07.450Z] └─TopN_29	100.00	100	root		time:1m20s, loops:2	Column#72:desc, tpch50.supplier.s_name, offset:0, count:100	55.9 KB	N/A
20:50:07 [2021-06-02T20:50:07.450Z]   └─HashAgg_34	12800.00	20057	root		time:1m20s, loops:21, partial_worker:{wall_time:1m20.00089671s, concurrency:5, task_num:197, tot_wait:6m39.74618882s, tot_exec:243.854143ms, tot_time:6m40.001651674s, max:1m20.000855892s, p95:1m20.000855892s}, final_worker:{wall_time:1m20.016302143s, concurrency:5, task_num:25, tot_wait:6m40.000151552s, tot_exec:67.878461ms, tot_time:6m40.068041651s, max:1m20.016280416s, p95:1m20.016280416s}	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:50:07 [2021-06-02T20:50:07.451Z]     └─IndexHashJoin_42	7828961.66	198698	root		time:1m20s, loops:198, inner:{total:2m17.1s, concurrency:5, task:147, construct:6.12s, fetch:1m55s, build:1.14s, join:16s}	anti semi join, inner:IndexLookUp_39, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey)	641.0 MB	N/A
20:50:07 [2021-06-02T20:50:07.451Z]       ├─IndexHashJoin_83(Build)	9786202.08	3542799	root		time:1m19.4s, loops:3463, inner:{total:2m23.7s, concurrency:5, task:152, construct:7.38s, fetch:1m59.5s, build:1.26s, join:16.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:50:07 [2021-06-02T20:50:07.451Z]       │ ├─IndexJoin_99(Build)	12232752.60	3675878	root		time:1m18.8s, loops:3595, inner:{total:2m3.4s, concurrency:5, task:305, construct:15.5s, fetch:1m45.8s, build:2.06s}, probe:5.07s	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:50:07 [2021-06-02T20:50:07.451Z]       │ │ ├─HashJoin_107(Build)	12232752.60	7609895	root		time:1m18.4s, loops:7436, build_hash_table:{total:960.7ms, fetch:953.5ms, build:7.19ms}, probe:{concurrency:5, total:6m33.6s, max:1m18.7s, probe:59.9s, fetch:5m33.8s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.lineitem.l_suppkey)]	737.6 KB	0 Bytes
20:50:07 [2021-06-02T20:50:07.451Z]       │ │ │ ├─HashJoin_120(Build)	20000.00	20058	root		time:958.9ms, loops:22, build_hash_table:{total:191.3µs, fetch:180.3µs, build:11µs}, probe:{concurrency:5, total:4.8s, max:959.1ms, probe:64ms, fetch:4.73s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:50:07 [2021-06-02T20:50:07.451Z]       │ │ │ │ ├─TableReader_125(Build)	1.00	1	root		time:52.5µs, loops:2, cop_task: {num: 1, max: 1.46ms, proc_keys: 25, tot_proc: 1ms, rpc_num: 1, rpc_time: 1.44ms, copr_cache: disabled}	data:Selection_124	248 Bytes	N/A
20:50:07 [2021-06-02T20:50:07.451Z]       │ │ │ │ │ └─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:50:07 [2021-06-02T20:50:07.451Z]       │ │ │ │ │   └─TableFullScan_123	25.00	25	cop[tikv]	table:nation	tikv_task:{time:1ms, loops:1}	keep order:false	N/A	N/A
20:50:07 [2021-06-02T20:50:07.451Z]       │ │ │ │ └─TableReader_122(Probe)	500000.00	500000	root		time:946ms, loops:490, cop_task: {num: 1, max: 946.8ms, proc_keys: 500000, tot_proc: 916ms, rpc_num: 1, rpc_time: 946.8ms, copr_cache: disabled}	data:TableFullScan_121	20.0 MB	N/A
20:50:07 [2021-06-02T20:50:07.451Z]       │ │ │ │   └─TableFullScan_121	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:865ms, 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:50:07 [2021-06-02T20:50:07.451Z]       │ │ │ └─TableReader_128(Probe)	240004648.80	189670348	root		time:1m6.4s, loops:184597, cop_task: {num: 761, max: 3.03s, min: 300.6ms, avg: 1.52s, p95: 1.98s, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 18m0.4s, tot_wait: 59.6s, rpc_num: 761, rpc_time: 19m12.9s, copr_cache: disabled}	data:Selection_127	109.4 MB	N/A
20:50:07 [2021-06-02T20:50:07.451Z]       │ │ │   └─Selection_127	240004648.80	189670348	cop[tikv]		tikv_task:{proc max:1.28s, min:285ms, p80:1.16s, 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: 10457, read_count: 1114191, read_byte: 23.6 GB}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:50:07 [2021-06-02T20:50:07.451Z]       │ │ │     └─TableFullScan_126	300005811.00	300005811	cop[tikv]	table:l1	tikv_task:{proc max:1.2s, min:274ms, p80:1.08s, p95:1.13s, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:50:07 [2021-06-02T20:50:07.451Z]       │ │ └─TableReader_95(Probe)	0.49	3496171	root		time:1m37.2s, loops:3875, cop_task: {num: 5304, max: 510.7ms, min: 2.17ms, avg: 172.2ms, p95: 335ms, max_proc_keys: 3588, p95_proc_keys: 1956, tot_proc: 10m56.6s, tot_wait: 3m40s, rpc_num: 5304, rpc_time: 15m13.4s, copr_cache: disabled}	data:Selection_94	N/A	N/A
20:50:07 [2021-06-02T20:50:07.451Z]       │ │   └─Selection_94	0.49	3496171	cop[tikv]		tikv_task:{proc max:141ms, min:0s, p80:68ms, p95:82ms, iters:30333, tasks:5304}, scan_detail: {total_process_keys: 7236280, total_keys: 7795524, rocksdb: {delete_skipped_count: 0, key_skipped_count: 1778400, block: {cache_hit_count: 54006351, read_count: 218278, read_byte: 4.21 GB}}}	eq(tpch50.orders.o_orderstatus, "F")	N/A	N/A
20:50:07 [2021-06-02T20:50:07.451Z]       │ │     └─TableRangeScan_93	1.00	7236280	cop[tikv]	table:orders	tikv_task:{proc max:141ms, min:0s, p80:68ms, p95:81ms, iters:30333, tasks:5304}	range: decided by [tpch50.lineitem.l_orderkey], keep order:false	N/A	N/A
20:50:07 [2021-06-02T20:50:07.451Z]       │ └─IndexLookUp_80(Probe)	4.05	17316508	root		time:1m54.1s, loops:17132, index_task: {total_time: 1m3.2s, fetch_handle: 54.8s, build: 3.12ms, wait: 8.36s}, table_task: {total_time: 8m14.1s, num: 1458, concurrency: 760}		19.1 KB	N/A
20:50:07 [2021-06-02T20:50:07.451Z]       │   ├─IndexRangeScan_78(Build)	4.05	17316508	cop[tikv]	table:l2, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:52.7s, loops:18619, cop_task: {num: 3008, max: 918.2ms, min: 451.8µs, avg: 179.7ms, p95: 368.7ms, max_proc_keys: 13238, p95_proc_keys: 8790, tot_proc: 6m46.4s, tot_wait: 1m55.2s, rpc_num: 3008, rpc_time: 9m0.4s, copr_cache: disabled}, tikv_task:{proc max:174ms, min:0s, p80:96ms, p95:111ms, iters:30137, tasks:3008}, scan_detail: {total_process_keys: 17316508, total_keys: 20812620, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17316508, block: {cache_hit_count: 24260023, 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:50:07 [2021-06-02T20:50:07.451Z]       │   └─TableRowIDScan_79(Probe)	4.05	17316508	cop[tikv]	table:l2	time:6m6s, loops:21002, cop_task: {num: 7822, max: 718.2ms, min: 645.6µs, avg: 171.9ms, p95: 348.1ms, max_proc_keys: 13189, p95_proc_keys: 4855, tot_proc: 16m13.1s, tot_wait: 5m23.5s, rpc_num: 7822, rpc_time: 22m24.2s, copr_cache: disabled}, tikv_task:{proc max:302ms, min:0s, p80:103ms, p95:140ms, iters:49984, tasks:7822}, scan_detail: {total_process_keys: 17316508, total_keys: 18288967, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5625665, block: {cache_hit_count: 99024064, read_count: 1118, read_byte: 404.1 MB}}}	keep order:false	N/A	N/A
20:50:07 [2021-06-02T20:50:07.451Z]       └─IndexLookUp_39(Probe)	4.05	12022864	root		time:1m50.1s, loops:11944, index_task: {total_time: 58.8s, fetch_handle: 49s, build: 2.97ms, wait: 9.83s}, table_task: {total_time: 7m52.4s, num: 1410, concurrency: 735}		207.7 KB	N/A
20:50:07 [2021-06-02T20:50:07.451Z]         ├─IndexRangeScan_36(Build)	5.06	17183475	cop[tikv]	table:l3, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:46.8s, loops:18358, cop_task: {num: 2775, max: 754.4ms, min: 507.5µs, avg: 164.7ms, p95: 351ms, max_proc_keys: 18486, p95_proc_keys: 13551, tot_proc: 5m42.2s, tot_wait: 1m36.1s, rpc_num: 2775, rpc_time: 7m36.9s, copr_cache: disabled}, tikv_task:{proc max:185ms, min:0s, p80:79ms, p95:121ms, iters:29025, tasks:2775}, scan_detail: {total_process_keys: 17183475, total_keys: 20546518, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17183475, block: {cache_hit_count: 23554108, 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:50:07 [2021-06-02T20:50:07.451Z]         └─Selection_38(Probe)	4.05	12022864	cop[tikv]		time:6m2s, loops:13764, cop_task: {num: 10314, max: 619.5ms, min: 500.4µs, avg: 169.9ms, p95: 342.4ms, max_proc_keys: 7925, p95_proc_keys: 4008, tot_proc: 20m25.9s, tot_wait: 7m42.9s, rpc_num: 10314, rpc_time: 29m11.8s, copr_cache: disabled}, tikv_task:{proc max:257ms, min:0s, p80:76ms, p95:117ms, iters:60953, tasks:10314}, scan_detail: {total_process_keys: 17183475, total_keys: 18127780, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5521609, block: {cache_hit_count: 98292930, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:50:07 [2021-06-02T20:50:07.451Z]           └─TableRowIDScan_37	5.06	17183475	cop[tikv]	table:l3	tikv_task:{proc max:256ms, min:0s, p80:75ms, p95:116ms, iters:60953, tasks:10314}	keep order:false	N/A	N/A
20:50:07 [2021-06-02T20:50:07.451Z] + sync
20:50:07 [2021-06-02T20:50:07.451Z] + /usr/bin/echo 3
20:51:39 [2021-06-02T20:51:39.163Z] 
20:51:39 [2021-06-02T20:51:39.163Z] queries/21.sql
20:51:39 [2021-06-02T20:51:39.163Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:51:39 [2021-06-02T20:51:39.163Z] Projection_26	100.00	100	root		time:1m20.2s, loops:2, Concurrency:OFF	tpch50.supplier.s_name, Column#72	4.62 KB	N/A
20:51:39 [2021-06-02T20:51:39.163Z] └─TopN_29	100.00	100	root		time:1m20.2s, loops:2	Column#72:desc, tpch50.supplier.s_name, offset:0, count:100	58.4 KB	N/A
20:51:39 [2021-06-02T20:51:39.164Z]   └─HashAgg_34	12800.00	20057	root		time:1m20.1s, loops:21, partial_worker:{wall_time:1m20.139551384s, concurrency:5, task_num:196, tot_wait:6m40.418645445s, tot_exec:262.08159ms, tot_time:6m40.693446708s, max:1m20.139518168s, p95:1m20.139518168s}, final_worker:{wall_time:1m20.151300157s, concurrency:5, task_num:25, tot_wait:6m40.692241163s, tot_exec:63.610399ms, tot_time:6m40.755862309s, max:1m20.151288016s, p95:1m20.151288016s}	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:39 [2021-06-02T20:51:39.164Z]     └─IndexHashJoin_42	7828961.66	198698	root		time:1m20.1s, loops:197, inner:{total:2m21s, concurrency:5, task:146, construct:6.13s, fetch:1m59s, build:1.26s, join:15.8s}	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:39 [2021-06-02T20:51:39.164Z]       ├─IndexHashJoin_83(Build)	9786202.08	3542799	root		time:1m19.6s, loops:3463, inner:{total:2m28.6s, concurrency:5, task:152, construct:7.23s, fetch:2m4.6s, build:1.2s, join:16.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:51:39 [2021-06-02T20:51:39.164Z]       │ ├─IndexJoin_99(Build)	12232752.60	3675878	root		time:1m19.1s, loops:3595, inner:{total:2m10.6s, concurrency:5, task:305, construct:15.9s, fetch:1m52.8s, build:1.93s}, probe:4.98s	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:51:39 [2021-06-02T20:51:39.164Z]       │ │ ├─HashJoin_107(Build)	12232752.60	7609895	root		time:1m18.7s, loops:7437, build_hash_table:{total:1.1s, fetch:1.1s, build:5.81ms}, probe:{concurrency:5, total:6m35s, max:1m19s, probe:58.7s, fetch:5m36.4s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.lineitem.l_suppkey)]	737.6 KB	0 Bytes
20:51:39 [2021-06-02T20:51:39.164Z]       │ │ │ ├─HashJoin_120(Build)	20000.00	20058	root		time:1.1s, loops:22, build_hash_table:{total:200.3µs, fetch:193.9µs, build:6.4µs}, probe:{concurrency:5, total:5.51s, max:1.1s, probe:61ms, fetch:5.45s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:51:39 [2021-06-02T20:51:39.164Z]       │ │ │ │ ├─TableReader_125(Build)	1.00	1	root		time:47.6µs, loops:2, cop_task: {num: 1, max: 1.32ms, proc_keys: 25, tot_proc: 1ms, rpc_num: 1, rpc_time: 1.31ms, copr_cache: disabled}	data:Selection_124	248 Bytes	N/A
20:51:39 [2021-06-02T20:51:39.164Z]       │ │ │ │ │ └─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:39 [2021-06-02T20:51:39.164Z]       │ │ │ │ │   └─TableFullScan_123	25.00	25	cop[tikv]	table:nation	tikv_task:{time:1ms, loops:1}	keep order:false	N/A	N/A
20:51:39 [2021-06-02T20:51:39.164Z]       │ │ │ │ └─TableReader_122(Probe)	500000.00	500000	root		time:1.09s, loops:490, cop_task: {num: 1, max: 1.09s, proc_keys: 500000, tot_proc: 1.06s, rpc_num: 1, rpc_time: 1.09s, copr_cache: disabled}	data:TableFullScan_121	20.0 MB	N/A
20:51:39 [2021-06-02T20:51:39.164Z]       │ │ │ │   └─TableFullScan_121	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:999ms, 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:39 [2021-06-02T20:51:39.164Z]       │ │ │ └─TableReader_128(Probe)	240004648.80	189670348	root		time:1m6.7s, loops:184597, cop_task: {num: 761, max: 2.78s, min: 327.7ms, avg: 1.52s, p95: 1.98s, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 17m57.8s, tot_wait: 1m2.1s, rpc_num: 761, rpc_time: 19m13.1s, copr_cache: disabled}	data:Selection_127	109.4 MB	N/A
20:51:39 [2021-06-02T20:51:39.164Z]       │ │ │   └─Selection_127	240004648.80	189670348	cop[tikv]		tikv_task:{proc max:1.3s, min:313ms, p80:1.15s, p95:1.2s, iters:296606, tasks:761}, scan_detail: {total_process_keys: 300005811, total_keys: 300006572, rocksdb: {delete_skipped_count: 0, key_skipped_count: 600010861, block: {cache_hit_count: 10456, read_count: 1114192, read_byte: 23.6 GB}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:51:39 [2021-06-02T20:51:39.164Z]       │ │ │     └─TableFullScan_126	300005811.00	300005811	cop[tikv]	table:l1	tikv_task:{proc max:1.21s, min:293ms, p80:1.07s, p95:1.12s, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:51:39 [2021-06-02T20:51:39.164Z]       │ │ └─TableReader_95(Probe)	0.49	3496172	root		time:1m44s, loops:3875, cop_task: {num: 5303, max: 545.2ms, min: 607.2µs, avg: 184.1ms, p95: 350.6ms, max_proc_keys: 3619, p95_proc_keys: 1945, tot_proc: 11m43s, tot_wait: 3m55.6s, rpc_num: 5303, rpc_time: 16m16s, copr_cache: disabled}	data:Selection_94	N/A	N/A
20:51:39 [2021-06-02T20:51:39.164Z]       │ │   └─Selection_94	0.49	3496172	cop[tikv]		tikv_task:{proc max:146ms, min:0s, p80:69ms, p95:81ms, iters:30358, tasks:5303}, scan_detail: {total_process_keys: 7236280, total_keys: 7795453, rocksdb: {delete_skipped_count: 0, key_skipped_count: 1778199, block: {cache_hit_count: 54006867, read_count: 218243, read_byte: 4.21 GB}}}	eq(tpch50.orders.o_orderstatus, "F")	N/A	N/A
20:51:39 [2021-06-02T20:51:39.164Z]       │ │     └─TableRangeScan_93	1.00	7236280	cop[tikv]	table:orders	tikv_task:{proc max:146ms, min:0s, p80:68ms, p95:81ms, iters:30358, tasks:5303}	range: decided by [tpch50.lineitem.l_orderkey], keep order:false	N/A	N/A
20:51:39 [2021-06-02T20:51:39.164Z]       │ └─IndexLookUp_80(Probe)	4.05	17316379	root		time:1m59.4s, loops:17127, index_task: {total_time: 1m6.6s, fetch_handle: 57.5s, build: 3.03ms, wait: 9.1s}, table_task: {total_time: 8m32.1s, num: 1458, concurrency: 760}		19.0 KB	N/A
20:51:39 [2021-06-02T20:51:39.164Z]       │   ├─IndexRangeScan_78(Build)	4.05	17316379	cop[tikv]	table:l2, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:55.3s, loops:18606, cop_task: {num: 3029, max: 765ms, min: 414µs, avg: 184.5ms, p95: 368.4ms, max_proc_keys: 14257, p95_proc_keys: 8778, tot_proc: 6m58.2s, tot_wait: 2m0.1s, rpc_num: 3029, rpc_time: 9m18.7s, copr_cache: disabled}, tikv_task:{proc max:166ms, min:0s, p80:96ms, p95:111ms, iters:30275, tasks:3029}, scan_detail: {total_process_keys: 17316379, total_keys: 20812468, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17316379, block: {cache_hit_count: 24259869, read_count: 225681, 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:39 [2021-06-02T20:51:39.164Z]       │   └─TableRowIDScan_79(Probe)	4.05	17316379	cop[tikv]	table:l2	time:6m20s, loops:21008, cop_task: {num: 7828, max: 738.6ms, min: 415.7µs, avg: 178.5ms, p95: 363.8ms, max_proc_keys: 9840, p95_proc_keys: 4828, tot_proc: 16m42.7s, tot_wait: 5m47.4s, rpc_num: 7828, rpc_time: 23m17.4s, copr_cache: disabled}, tikv_task:{proc max:238ms, min:0s, p80:103ms, p95:138ms, iters:49947, tasks:7828}, scan_detail: {total_process_keys: 17316379, total_keys: 18289084, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5628255, block: {cache_hit_count: 99018476, read_count: 1111, read_byte: 386.9 MB}}}	keep order:false	N/A	N/A
20:51:39 [2021-06-02T20:51:39.164Z]       └─IndexLookUp_39(Probe)	4.05	12022731	root		time:1m54.4s, loops:11947, index_task: {total_time: 1m1.6s, fetch_handle: 53.3s, build: 3.09ms, wait: 8.22s}, table_task: {total_time: 8m12.7s, num: 1408, concurrency: 730}		269.0 KB	N/A
20:51:39 [2021-06-02T20:51:39.164Z]         ├─IndexRangeScan_36(Build)	5.06	17183325	cop[tikv]	table:l3, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:51s, loops:18375, cop_task: {num: 2817, max: 699.4ms, min: 432.4µs, avg: 172.7ms, p95: 382.6ms, max_proc_keys: 20291, p95_proc_keys: 13757, tot_proc: 6m5.6s, tot_wait: 1m41.9s, rpc_num: 2817, rpc_time: 8m6.4s, copr_cache: disabled}, tikv_task:{proc max:189ms, min:0s, p80:78ms, p95:123ms, iters:29211, tasks:2817}, scan_detail: {total_process_keys: 17183325, total_keys: 20546338, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17183325, block: {cache_hit_count: 23553897, 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:39 [2021-06-02T20:51:39.164Z]         └─Selection_38(Probe)	4.05	12022731	cop[tikv]		time:6m18.5s, loops:13781, cop_task: {num: 10327, max: 562.1ms, min: 508.6µs, avg: 180ms, p95: 367.2ms, max_proc_keys: 7792, p95_proc_keys: 3917, tot_proc: 21m47.7s, tot_wait: 8m6.7s, rpc_num: 10327, rpc_time: 30m59.1s, copr_cache: disabled}, tikv_task:{proc max:251ms, min:0s, p80:75ms, p95:115ms, iters:60982, tasks:10327}, scan_detail: {total_process_keys: 17183325, total_keys: 18128459, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5525806, block: {cache_hit_count: 98287010, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:51:39 [2021-06-02T20:51:39.164Z]           └─TableRowIDScan_37	5.06	17183325	cop[tikv]	table:l3	tikv_task:{proc max:247ms, min:0s, p80:75ms, p95:114ms, iters:60982, tasks:10327}	keep order:false	N/A	N/A
20:51:39 [2021-06-02T20:51:39.164Z] + sync
20:51:39 [2021-06-02T20:51:39.164Z] + /usr/bin/echo 3
20:53:37 [2021-06-02T20:53:37.584Z] 
20:53:37 [2021-06-02T20:53:37.584Z] queries/21.sql
20:53:37 [2021-06-02T20:53:37.584Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:53:37 [2021-06-02T20:53:37.584Z] Projection_26	100.00	100	root		time:1m20.1s, loops:2, Concurrency:OFF	tpch50.supplier.s_name, Column#72	4.62 KB	N/A
20:53:37 [2021-06-02T20:53:37.584Z] └─TopN_29	100.00	100	root		time:1m20.1s, loops:2	Column#72:desc, tpch50.supplier.s_name, offset:0, count:100	58.4 KB	N/A
20:53:37 [2021-06-02T20:53:37.584Z]   └─HashAgg_34	12800.00	20057	root		time:1m20.1s, loops:21, partial_worker:{wall_time:1m20.129869986s, concurrency:5, task_num:196, tot_wait:6m40.391440859s, tot_exec:242.781486ms, tot_time:6m40.645776586s, max:1m20.129842382s, p95:1m20.129842382s}, final_worker:{wall_time:1m20.143847058s, concurrency:5, task_num:25, tot_wait:6m40.644182652s, tot_exec:66.414523ms, tot_time:6m40.710609629s, max:1m20.143821054s, p95:1m20.143821054s}	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:37 [2021-06-02T20:53:37.584Z]     └─IndexHashJoin_42	7828961.66	198698	root		time:1m20.1s, loops:197, inner:{total:2m15.8s, concurrency:5, task:147, construct:6.07s, fetch:1m54.3s, build:1.29s, join:15.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:53:37 [2021-06-02T20:53:37.584Z]       ├─IndexHashJoin_83(Build)	9786202.08	3542799	root		time:1m19.5s, loops:3463, inner:{total:2m24.3s, concurrency:5, task:152, construct:7.11s, fetch:2m0.5s, build:1.2s, join:16.7s}	semi join, inner:IndexLookUp_80, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey), ne(tpch50.lineitem.l_suppkey, tpch50.supplier.s_suppkey)	556.0 MB	N/A
20:53:37 [2021-06-02T20:53:37.584Z]       │ ├─IndexJoin_99(Build)	12232752.60	3675878	root		time:1m19s, loops:3595, inner:{total:2m3.8s, concurrency:5, task:305, construct:15.3s, fetch:1m46.4s, build:2.1s}, probe:4.99s	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:37 [2021-06-02T20:53:37.584Z]       │ │ ├─HashJoin_107(Build)	12232752.60	7609895	root		time:1m18.4s, loops:7436, build_hash_table:{total:1.06s, fetch:1.06s, build:6.26ms}, probe:{concurrency:5, total:6m33.8s, max:1m18.8s, probe:1m0.3s, fetch:5m33.5s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.lineitem.l_suppkey)]	737.6 KB	0 Bytes
20:53:37 [2021-06-02T20:53:37.584Z]       │ │ │ ├─HashJoin_120(Build)	20000.00	20058	root		time:1.06s, loops:22, build_hash_table:{total:195.4µs, fetch:191.1µs, build:4.31µs}, probe:{concurrency:5, total:5.31s, max:1.06s, probe:58.7ms, fetch:5.25s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:53:37 [2021-06-02T20:53:37.584Z]       │ │ │ │ ├─TableReader_125(Build)	1.00	1	root		time:45.2µs, loops:2, cop_task: {num: 1, max: 1.25ms, proc_keys: 25, tot_proc: 1ms, rpc_num: 1, rpc_time: 1.23ms, copr_cache: disabled}	data:Selection_124	248 Bytes	N/A
20:53:37 [2021-06-02T20:53:37.584Z]       │ │ │ │ │ └─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:37 [2021-06-02T20:53:37.584Z]       │ │ │ │ │   └─TableFullScan_123	25.00	25	cop[tikv]	table:nation	tikv_task:{time:1ms, loops:1}	keep order:false	N/A	N/A
20:53:37 [2021-06-02T20:53:37.585Z]       │ │ │ │ └─TableReader_122(Probe)	500000.00	500000	root		time:1.05s, loops:490, cop_task: {num: 1, max: 1.05s, proc_keys: 500000, tot_proc: 1.01s, rpc_num: 1, rpc_time: 1.05s, copr_cache: disabled}	data:TableFullScan_121	20.0 MB	N/A
20:53:37 [2021-06-02T20:53:37.585Z]       │ │ │ │   └─TableFullScan_121	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:964ms, 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:37 [2021-06-02T20:53:37.585Z]       │ │ │ └─TableReader_128(Probe)	240004648.80	189670348	root		time:1m6.2s, loops:184597, cop_task: {num: 761, max: 2.53s, min: 297ms, avg: 1.51s, p95: 1.96s, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 17m59.6s, tot_wait: 59.8s, rpc_num: 761, rpc_time: 19m12.4s, copr_cache: disabled}	data:Selection_127	109.4 MB	N/A
20:53:37 [2021-06-02T20:53:37.585Z]       │ │ │   └─Selection_127	240004648.80	189670348	cop[tikv]		tikv_task:{proc max:1.28s, min:280ms, p80:1.15s, p95:1.2s, iters:296606, tasks:761}, scan_detail: {total_process_keys: 300005811, total_keys: 300006572, rocksdb: {delete_skipped_count: 0, key_skipped_count: 600010861, block: {cache_hit_count: 10456, read_count: 1114192, read_byte: 23.6 GB}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:53:37 [2021-06-02T20:53:37.585Z]       │ │ │     └─TableFullScan_126	300005811.00	300005811	cop[tikv]	table:l1	tikv_task:{proc max:1.21s, min:265ms, p80:1.08s, p95:1.12s, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:53:37 [2021-06-02T20:53:37.585Z]       │ │ └─TableReader_95(Probe)	0.49	3496173	root		time:1m38.1s, loops:3875, cop_task: {num: 5262, max: 601.1ms, min: 1.32ms, avg: 175.9ms, p95: 332.8ms, max_proc_keys: 3327, p95_proc_keys: 1956, tot_proc: 11m7.5s, tot_wait: 3m41.5s, rpc_num: 5262, rpc_time: 15m25.6s, copr_cache: disabled}	data:Selection_94	N/A	N/A
20:53:37 [2021-06-02T20:53:37.585Z]       │ │   └─Selection_94	0.49	3496173	cop[tikv]		tikv_task:{proc max:147ms, min:0s, p80:68ms, p95:81ms, iters:30250, tasks:5262}, scan_detail: {total_process_keys: 7236282, total_keys: 7795519, rocksdb: {delete_skipped_count: 0, key_skipped_count: 1778415, block: {cache_hit_count: 54006255, read_count: 218217, read_byte: 4.21 GB}}}	eq(tpch50.orders.o_orderstatus, "F")	N/A	N/A
20:53:37 [2021-06-02T20:53:37.585Z]       │ │     └─TableRangeScan_93	1.00	7236282	cop[tikv]	table:orders	tikv_task:{proc max:147ms, min:0s, p80:68ms, p95:81ms, iters:30250, tasks:5262}	range: decided by [tpch50.lineitem.l_orderkey], keep order:false	N/A	N/A
20:53:37 [2021-06-02T20:53:37.585Z]       │ └─IndexLookUp_80(Probe)	4.05	17316387	root		time:1m55.3s, loops:17131, index_task: {total_time: 1m3.8s, fetch_handle: 54.4s, build: 3.08ms, wait: 9.4s}, table_task: {total_time: 8m16.8s, num: 1458, concurrency: 760}		19.2 KB	N/A
20:53:37 [2021-06-02T20:53:37.585Z]       │   ├─IndexRangeScan_78(Build)	4.05	17316387	cop[tikv]	table:l2, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:52.2s, loops:18603, cop_task: {num: 2977, max: 605.9ms, min: 576.3µs, avg: 178.6ms, p95: 365.9ms, max_proc_keys: 13763, p95_proc_keys: 8693, tot_proc: 6m40.7s, tot_wait: 1m51.2s, rpc_num: 2977, rpc_time: 8m51.6s, copr_cache: disabled}, tikv_task:{proc max:169ms, min:0s, p80:96ms, p95:110ms, iters:30092, tasks:2977}, scan_detail: {total_process_keys: 17316387, total_keys: 20812479, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17316387, block: {cache_hit_count: 24259882, read_count: 225690, 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:37 [2021-06-02T20:53:37.585Z]       │   └─TableRowIDScan_79(Probe)	4.05	17316387	cop[tikv]	table:l2	time:6m10.2s, loops:20999, cop_task: {num: 7754, max: 628.4ms, min: 512.4µs, avg: 174.8ms, p95: 352.9ms, max_proc_keys: 9396, p95_proc_keys: 4824, tot_proc: 16m19.6s, tot_wait: 5m27.2s, rpc_num: 7754, rpc_time: 22m35.6s, copr_cache: disabled}, tikv_task:{proc max:258ms, min:0s, p80:105ms, p95:138ms, iters:49787, tasks:7754}, scan_detail: {total_process_keys: 17316387, total_keys: 18289841, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5631128, block: {cache_hit_count: 99018371, read_count: 1098, read_byte: 382.1 MB}}}	keep order:false	N/A	N/A
20:53:37 [2021-06-02T20:53:37.585Z]       └─IndexLookUp_39(Probe)	4.05	12022750	root		time:1m49.7s, loops:11950, index_task: {total_time: 1m0.3s, fetch_handle: 50s, build: 3.21ms, wait: 10.2s}, table_task: {total_time: 7m55.3s, num: 1410, concurrency: 735}		218.6 KB	N/A
20:53:37 [2021-06-02T20:53:37.585Z]         ├─IndexRangeScan_36(Build)	5.06	17183313	cop[tikv]	table:l3, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:47.7s, loops:18365, cop_task: {num: 2790, max: 702.7ms, min: 1.11ms, avg: 165.3ms, p95: 361.7ms, max_proc_keys: 19108, p95_proc_keys: 13527, tot_proc: 5m49.4s, tot_wait: 1m32.3s, rpc_num: 2790, rpc_time: 7m41.3s, copr_cache: disabled}, tikv_task:{proc max:186ms, min:0s, p80:79ms, p95:122ms, iters:29172, tasks:2790}, scan_detail: {total_process_keys: 17183313, total_keys: 20546328, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17183313, block: {cache_hit_count: 23553912, 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:37 [2021-06-02T20:53:37.585Z]         └─Selection_38(Probe)	4.05	12022750	cop[tikv]		time:6m3.9s, loops:13775, cop_task: {num: 10190, max: 633.4ms, min: 501.2µs, avg: 170.3ms, p95: 344.9ms, max_proc_keys: 6751, p95_proc_keys: 3980, tot_proc: 20m29.5s, tot_wait: 7m23.7s, rpc_num: 10190, rpc_time: 28m55.4s, copr_cache: disabled}, tikv_task:{proc max:229ms, min:0s, p80:76ms, p95:115ms, iters:60531, tasks:10190}, scan_detail: {total_process_keys: 17183313, total_keys: 18128331, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5523688, block: {cache_hit_count: 98290585, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:53:37 [2021-06-02T20:53:37.585Z]           └─TableRowIDScan_37	5.06	17183313	cop[tikv]	table:l3	tikv_task:{proc max:229ms, min:0s, p80:76ms, p95:114ms, iters:60531, tasks:10190}	keep order:false	N/A	N/A
20:53:37 [2021-06-02T20:53:37.585Z] + sync
20:53:37 [2021-06-02T20:53:37.585Z] + /usr/bin/echo 3
20:54:22 [2021-06-02T20:54:22.720Z] 
20:54:22 [2021-06-02T20:54:22.721Z] queries/21.sql
20:54:22 [2021-06-02T20:54:22.721Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:54:22 [2021-06-02T20:54:22.721Z] Projection_26	100.00	100	root		time:1m19.8s, loops:2, Concurrency:OFF	tpch50.supplier.s_name, Column#72	4.62 KB	N/A
20:54:22 [2021-06-02T20:54:22.721Z] └─TopN_29	100.00	100	root		time:1m19.8s, loops:2	Column#72:desc, tpch50.supplier.s_name, offset:0, count:100	58.4 KB	N/A
20:54:22 [2021-06-02T20:54:22.721Z]   └─HashAgg_34	12800.00	20057	root		time:1m19.8s, loops:21, partial_worker:{wall_time:1m19.815962962s, concurrency:5, task_num:197, tot_wait:6m38.83880933s, tot_exec:226.793629ms, tot_time:6m39.077881701s, max:1m19.815925622s, p95:1m19.815925622s}, final_worker:{wall_time:1m19.829313866s, concurrency:5, task_num:25, tot_wait:6m39.076621158s, tot_exec:64.727016ms, tot_time:6m39.141359266s, max:1m19.829294431s, p95:1m19.829294431s}	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:54:22 [2021-06-02T20:54:22.721Z]     └─IndexHashJoin_42	7828961.66	198698	root		time:1m19.8s, loops:198, inner:{total:2m17.1s, concurrency:5, task:146, construct:6.21s, fetch:1m55.3s, build:1.2s, join:15.6s}	anti semi join, inner:IndexLookUp_39, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey)	641.1 MB	N/A
20:54:22 [2021-06-02T20:54:22.721Z]       ├─IndexHashJoin_83(Build)	9786202.08	3542799	root		time:1m19.3s, loops:3463, inner:{total:2m28.3s, concurrency:5, task:152, construct:7.78s, fetch:2m3.2s, build:1.22s, 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:54:22 [2021-06-02T20:54:22.721Z]       │ ├─IndexJoin_99(Build)	12232752.60	3675878	root		time:1m18.9s, loops:3595, inner:{total:2m7.3s, concurrency:5, task:305, construct:15.9s, fetch:1m49.5s, build:1.9s}, probe:5.05s	inner join, inner:TableReader_95, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.orders.o_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.orders.o_orderkey)	575.3 MB	N/A
20:54:22 [2021-06-02T20:54:22.721Z]       │ │ ├─HashJoin_107(Build)	12232752.60	7609895	root		time:1m18.4s, loops:7437, build_hash_table:{total:1.05s, fetch:1.04s, build:6.5ms}, probe:{concurrency:5, total:6m33.7s, max:1m18.7s, probe:1m0.4s, fetch:5m33.3s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.lineitem.l_suppkey)]	737.6 KB	0 Bytes
20:54:22 [2021-06-02T20:54:22.721Z]       │ │ │ ├─HashJoin_120(Build)	20000.00	20058	root		time:1.04s, loops:22, build_hash_table:{total:190.3µs, fetch:185.4µs, build:4.87µs}, probe:{concurrency:5, total:5.22s, max:1.04s, probe:60.7ms, fetch:5.16s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:54:22 [2021-06-02T20:54:22.721Z]       │ │ │ │ ├─TableReader_125(Build)	1.00	1	root		time:65.8µs, loops:2, cop_task: {num: 1, max: 1.54ms, proc_keys: 25, tot_proc: 1ms, rpc_num: 1, rpc_time: 1.52ms, copr_cache: disabled}	data:Selection_124	248 Bytes	N/A
20:54:22 [2021-06-02T20:54:22.721Z]       │ │ │ │ │ └─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:54:22 [2021-06-02T20:54:22.721Z]       │ │ │ │ │   └─TableFullScan_123	25.00	25	cop[tikv]	table:nation	tikv_task:{time:1ms, loops:1}	keep order:false	N/A	N/A
20:54:22 [2021-06-02T20:54:22.721Z]       │ │ │ │ └─TableReader_122(Probe)	500000.00	500000	root		time:1.03s, loops:490, cop_task: {num: 1, max: 1.03s, proc_keys: 500000, tot_proc: 1s, rpc_num: 1, rpc_time: 1.03s, copr_cache: disabled}	data:TableFullScan_121	20.0 MB	N/A
20:54:22 [2021-06-02T20:54:22.721Z]       │ │ │ │   └─TableFullScan_121	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:940ms, 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:54:22 [2021-06-02T20:54:22.721Z]       │ │ │ └─TableReader_128(Probe)	240004648.80	189670348	root		time:1m6.2s, loops:184596, cop_task: {num: 761, max: 2.63s, min: 326.3ms, avg: 1.51s, p95: 1.99s, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 17m53.3s, tot_wait: 1m1.6s, rpc_num: 761, rpc_time: 19m7.8s, copr_cache: disabled}	data:Selection_127	109.4 MB	N/A
20:54:22 [2021-06-02T20:54:22.721Z]       │ │ │   └─Selection_127	240004648.80	189670348	cop[tikv]		tikv_task:{proc max:1.27s, min:307ms, p80:1.15s, p95:1.2s, iters:296606, tasks:761}, scan_detail: {total_process_keys: 300005811, total_keys: 300006572, rocksdb: {delete_skipped_count: 0, key_skipped_count: 600010861, block: {cache_hit_count: 10458, read_count: 1114190, read_byte: 23.6 GB}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:54:22 [2021-06-02T20:54:22.721Z]       │ │ │     └─TableFullScan_126	300005811.00	300005811	cop[tikv]	table:l1	tikv_task:{proc max:1.19s, min:284ms, p80:1.07s, p95:1.11s, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:54:22 [2021-06-02T20:54:22.721Z]       │ │ └─TableReader_95(Probe)	0.49	3496176	root		time:1m40.8s, loops:3875, cop_task: {num: 5290, max: 470.7ms, min: 401.7µs, avg: 179.1ms, p95: 332.6ms, max_proc_keys: 3611, p95_proc_keys: 1957, tot_proc: 11m23.1s, tot_wait: 3m46.5s, rpc_num: 5290, rpc_time: 15m47.1s, copr_cache: disabled}	data:Selection_94	N/A	N/A
20:54:22 [2021-06-02T20:54:22.721Z]       │ │   └─Selection_94	0.49	3496176	cop[tikv]		tikv_task:{proc max:140ms, min:0s, p80:68ms, p95:81ms, iters:30346, tasks:5290}, scan_detail: {total_process_keys: 7236296, total_keys: 7795510, rocksdb: {delete_skipped_count: 0, key_skipped_count: 1778284, block: {cache_hit_count: 54006773, read_count: 218182, read_byte: 4.21 GB}}}	eq(tpch50.orders.o_orderstatus, "F")	N/A	N/A
20:54:22 [2021-06-02T20:54:22.721Z]       │ │     └─TableRangeScan_93	1.00	7236296	cop[tikv]	table:orders	tikv_task:{proc max:140ms, min:0s, p80:68ms, p95:81ms, iters:30346, tasks:5290}	range: decided by [tpch50.lineitem.l_orderkey], keep order:false	N/A	N/A
20:54:22 [2021-06-02T20:54:22.721Z]       │ └─IndexLookUp_80(Probe)	4.05	17316471	root		time:1m57.8s, loops:17130, index_task: {total_time: 1m5.2s, fetch_handle: 57.2s, build: 3.15ms, wait: 8.02s}, table_task: {total_time: 8m26.3s, num: 1458, concurrency: 760}		19.0 KB	N/A
20:54:22 [2021-06-02T20:54:22.721Z]       │   ├─IndexRangeScan_78(Build)	4.05	17316471	cop[tikv]	table:l2, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:55s, loops:18634, cop_task: {num: 3015, max: 672.1ms, min: 437.5µs, avg: 187.3ms, p95: 367.7ms, max_proc_keys: 14251, p95_proc_keys: 8757, tot_proc: 7m5.4s, tot_wait: 1m59.3s, rpc_num: 3015, rpc_time: 9m24.6s, copr_cache: disabled}, tikv_task:{proc max:185ms, min:0s, p80:95ms, p95:110ms, iters:30264, tasks:3015}, scan_detail: {total_process_keys: 17316471, total_keys: 20812575, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17316471, block: {cache_hit_count: 24259970, 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:54:22 [2021-06-02T20:54:22.721Z]       │   └─TableRowIDScan_79(Probe)	4.05	17316471	cop[tikv]	table:l2	time:6m15.9s, loops:21041, cop_task: {num: 7809, max: 579.5ms, min: 436.3µs, avg: 176.6ms, p95: 348.7ms, max_proc_keys: 9187, p95_proc_keys: 4880, tot_proc: 16m34.6s, tot_wait: 5m36.6s, rpc_num: 7809, rpc_time: 22m59s, copr_cache: disabled}, tikv_task:{proc max:272ms, min:0s, p80:103ms, p95:137ms, iters:49916, tasks:7809}, scan_detail: {total_process_keys: 17316471, total_keys: 18289973, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5631688, block: {cache_hit_count: 99015895, read_count: 1113, read_byte: 401.8 MB}}}	keep order:false	N/A	N/A
20:54:22 [2021-06-02T20:54:22.721Z]       └─IndexLookUp_39(Probe)	4.05	12022804	root		time:1m50.6s, loops:11943, index_task: {total_time: 59.7s, fetch_handle: 49.5s, build: 3.07ms, wait: 10.2s}, table_task: {total_time: 7m59.3s, num: 1408, concurrency: 730}		219.1 KB	N/A
20:54:22 [2021-06-02T20:54:22.721Z]         ├─IndexRangeScan_36(Build)	5.06	17183411	cop[tikv]	table:l3, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:47.2s, loops:18364, cop_task: {num: 2799, max: 729.4ms, min: 2.23ms, avg: 168.9ms, p95: 359.7ms, max_proc_keys: 18313, p95_proc_keys: 13598, tot_proc: 5m51.7s, tot_wait: 1m41.5s, rpc_num: 2799, rpc_time: 7m52.7s, copr_cache: disabled}, tikv_task:{proc max:185ms, min:0s, p80:78ms, p95:119ms, iters:29180, tasks:2799}, scan_detail: {total_process_keys: 17183411, total_keys: 20546439, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17183411, 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:54:22 [2021-06-02T20:54:22.721Z]         └─Selection_38(Probe)	4.05	12022804	cop[tikv]		time:6m6.1s, loops:13778, cop_task: {num: 10183, max: 578.3ms, min: 380.3µs, avg: 169.9ms, p95: 341.1ms, max_proc_keys: 7530, p95_proc_keys: 3944, tot_proc: 20m20.8s, tot_wait: 7m23.7s, rpc_num: 10183, rpc_time: 28m50.2s, copr_cache: disabled}, tikv_task:{proc max:217ms, min:0s, p80:76ms, p95:114ms, iters:60461, tasks:10183}, scan_detail: {total_process_keys: 17183411, total_keys: 18130040, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5531089, block: {cache_hit_count: 98284515, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:54:22 [2021-06-02T20:54:22.721Z]           └─TableRowIDScan_37	5.06	17183411	cop[tikv]	table:l3	tikv_task:{proc max:215ms, min:0s, p80:75ms, p95:114ms, iters:60461, tasks:10183}	keep order:false	N/A	N/A
20:54:22 [2021-06-02T20:54:22.721Z] + tiup cluster stop benchbot -y
20:54:24 [2021-06-02T20:54:24.083Z] Starting component `cluster`: /home/tidb/.tiup/components/cluster/v1.4.4/tiup-cluster stop benchbot -y
20:54:44 [2021-06-02T20:54:44.645Z] + rm -rf '/data1/tidb-deploy/*/log/*'
20:54:44 [2021-06-02T20:54:44.645Z] + rm -rf /data1/jenkins/deploy/data/tikv-20160
20:54:44 [2021-06-02T20:54:44.645Z] + rm -rf /data1/jenkins/deploy/data/pd-2379
20:54:44 [2021-06-02T20:54:44.645Z] + rm -rf /data1/jenkins/restore_data/tpch50/data/last_tikv.toml
20:54:44 [2021-06-02T20:54:44.645Z] + cp -R /data1/jenkins/restore_data/tpch50/data /data1/jenkins/deploy/data/tikv-20160
20:56:48 [2021-06-02T20:56:48.848Z] + cp -R /data1/jenkins/restore_data/tpch50/data.pd /data1/jenkins/deploy/data/pd-2379
20:56:48 [2021-06-02T20:56:48.848Z] + '[' -n '' ']'
20:56:48 [2021-06-02T20:56:48.848Z] + tiup cluster start benchbot --wait-timeout=300
20:56:48 [2021-06-02T20:56:48.848Z] Starting component `cluster`: /home/tidb/.tiup/components/cluster/v1.4.4/tiup-cluster start benchbot --wait-timeout=300
20:56:49 [2021-06-02T20:56:49.776Z] + sync
20:56:49 [2021-06-02T20:56:49.776Z] + /usr/bin/echo 3
20:57:39 [2021-06-02T20:57:39.256Z] + sync
20:57:39 [2021-06-02T20:57:39.256Z] + /usr/bin/echo 3
20:58:32 [2021-06-02T20:58:32.373Z] + sync
20:58:32 [2021-06-02T20:58:32.373Z] + /usr/bin/echo 3
20:58:32 [2021-06-02T20:58:32.373Z] 
20:58:32 [2021-06-02T20:58:32.373Z] queries/22.sql
20:58:32 [2021-06-02T20:58:32.374Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:58:32 [2021-06-02T20:58:32.374Z] Sort_39	1600000.00	4	root		time:27s, loops:2	Column#27	9.48 KB	0 Bytes
20:58:32 [2021-06-02T20:58:32.374Z] └─Projection_41	1600000.00	4	root		time:27s, loops:5, Concurrency:5	Column#27, Column#28, Column#29	23.7 KB	N/A
20:58:32 [2021-06-02T20:58:32.374Z]   └─HashAgg_42	1600000.00	4	root		time:27s, loops:5, partial_worker:{wall_time:27.038511243s, concurrency:5, task_num:180, tot_wait:2m15.136035988s, tot_exec:55.406795ms, tot_time:2m15.191540483s, max:27.038426908s, p95:27.038426908s}, final_worker:{wall_time:27.038524214s, concurrency:5, task_num:20, tot_wait:2m15.192101087s, tot_exec:152.902µs, tot_time:2m15.192262121s, max:27.038460116s, p95:27.038460116s}	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:58:32 [2021-06-02T20:58:32.374Z]     └─Projection_51	1600000.00	181704	root		time:27s, 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:58:32 [2021-06-02T20:58:32.374Z]       └─HashJoin_43	1600000.00	181704	root		time:27s, loops:181, build_hash_table:{total:25.6s, fetch:1.05s, build:24.5s}, probe:{concurrency:5, total:2m15.2s, max:27s, probe:6.02s, fetch:2m9.1s}	anti semi join, equal:[eq(tpch50.customer.c_custkey, tpch50.orders.o_custkey)]	590.2 MB	0 Bytes
20:58:32 [2021-06-02T20:58:32.374Z]         ├─TableReader_49(Build)	75000000.00	75000000	root		time:1.11s, loops:73364, cop_task: {num: 153, max: 952.5ms, min: 267.7ms, avg: 584ms, p95: 865.6ms, max_proc_keys: 723875, p95_proc_keys: 553332, tot_proc: 1m28.5s, tot_wait: 42ms, rpc_num: 153, rpc_time: 1m29.3s, copr_cache: disabled}	data:TableFullScan_48	56.0 MB	N/A
20:58:32 [2021-06-02T20:58:32.374Z]         │ └─TableFullScan_48	75000000.00	75000000	cop[tikv]	table:orders	tikv_task:{proc max:927ms, min:259ms, p80:580ms, p95:838ms, 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: 3013, read_count: 219940, read_byte: 4.30 GB}}}	keep order:false	N/A	N/A
20:58:32 [2021-06-02T20:58:32.374Z]         └─Selection_47(Probe)	2000000.00	545246	root		time:1.36s, loops:534	in(substring(tpch50.customer.c_phone, 1, 2), "20", "40", "22", "30", "39", "42", "21")	94.6 KB	N/A
20:58:32 [2021-06-02T20:58:32.374Z]           └─TableReader_46	2000000.00	3407619	root		time:479.6ms, loops:3319, cop_task: {num: 18, max: 1.09s, min: 391.2ms, avg: 754.3ms, p95: 1.09s, max_proc_keys: 582617, p95_proc_keys: 582617, tot_proc: 13.2s, tot_wait: 6ms, rpc_num: 18, rpc_time: 13.6s, copr_cache: disabled}	data:Selection_45	192.5 MB	N/A
20:58:32 [2021-06-02T20:58:32.374Z]             └─Selection_45	2000000.00	3407619	cop[tikv]		tikv_task:{proc max:1.02s, min:362ms, p80:861ms, p95:1.02s, 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:58:32 [2021-06-02T20:58:32.374Z]               └─TableFullScan_44	7500000.00	7500000	cop[tikv]	table:customer	tikv_task:{proc max:924ms, min:335ms, p80:772ms, p95:924ms, iters:7404, tasks:18}	keep order:false	N/A	N/A
20:58:32 [2021-06-02T20:58:32.374Z] 
20:58:32 [2021-06-02T20:58:32.374Z] queries/22.sql
20:58:32 [2021-06-02T20:58:32.374Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:58:32 [2021-06-02T20:58:32.374Z] Sort_39	2186432.06	4	root		time:26.2s, loops:2	Column#27	9.48 KB	0 Bytes
20:58:32 [2021-06-02T20:58:32.374Z] └─Projection_41	2186432.06	4	root		time:26.2s, loops:5, Concurrency:5	Column#27, Column#28, Column#29	23.7 KB	N/A
20:58:32 [2021-06-02T20:58:32.374Z]   └─HashAgg_42	2186432.06	4	root		time:26.2s, loops:5, partial_worker:{wall_time:26.200275091s, concurrency:5, task_num:181, tot_wait:2m10.947848957s, tot_exec:52.288206ms, tot_time:2m11.00025226s, max:26.200196014s, p95:26.200196014s}, final_worker:{wall_time:26.200297871s, concurrency:5, task_num:20, tot_wait:2m11.00081334s, tot_exec:324.725µs, tot_time:2m11.00114679s, max:26.200240885s, p95:26.200240885s}	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:58:32 [2021-06-02T20:58:32.374Z]     └─Projection_51	2186432.06	181704	root		time:26.2s, 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:58:32 [2021-06-02T20:58:32.374Z]       └─HashJoin_43	2186432.06	181704	root		time:26.2s, loops:182, build_hash_table:{total:24.8s, fetch:1.03s, build:23.7s}, probe:{concurrency:5, total:2m11s, max:26.2s, probe:5.73s, fetch:2m5.2s}	anti semi join, equal:[eq(tpch50.customer.c_custkey, tpch50.orders.o_custkey)]	590.2 MB	0 Bytes
20:58:32 [2021-06-02T20:58:32.374Z]         ├─TableReader_49(Build)	75000000.00	75000000	root		time:1.05s, loops:73364, cop_task: {num: 153, max: 1.07s, min: 234.8ms, avg: 538.3ms, p95: 882.8ms, max_proc_keys: 723875, p95_proc_keys: 553332, tot_proc: 1m21.5s, tot_wait: 33ms, rpc_num: 153, rpc_time: 1m22.3s, copr_cache: disabled}	data:TableFullScan_48	57.8 MB	N/A
20:58:32 [2021-06-02T20:58:32.374Z]         │ └─TableFullScan_48	75000000.00	75000000	cop[tikv]	table:orders	tikv_task:{proc max:1.04s, min:227ms, p80:608ms, p95:838ms, 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:58:32 [2021-06-02T20:58:32.374Z]         └─Selection_47(Probe)	2733040.07	545246	root		time:1.61s, loops:534	in(substring(tpch50.customer.c_phone, 1, 2), "20", "40", "22", "30", "39", "42", "21")	94.6 KB	N/A
20:58:32 [2021-06-02T20:58:32.374Z]           └─TableReader_46	2733040.07	3407619	root		time:759ms, loops:3319, cop_task: {num: 18, max: 1.1s, min: 511.1ms, avg: 846.8ms, p95: 1.1s, max_proc_keys: 582617, p95_proc_keys: 582617, tot_proc: 14.7s, rpc_num: 18, rpc_time: 15.2s, copr_cache: disabled}	data:Selection_45	192.5 MB	N/A
20:58:32 [2021-06-02T20:58:32.374Z]             └─Selection_45	2733040.07	3407619	cop[tikv]		tikv_task:{proc max:1.01s, min:460ms, p80:951ms, p95:1.01s, 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:58:32 [2021-06-02T20:58:32.374Z]               └─TableFullScan_44	7500000.00	7500000	cop[tikv]	table:customer	tikv_task:{proc max:918ms, min:424ms, p80:847ms, p95:918ms, iters:7404, tasks:18}	keep order:false	N/A	N/A
20:58:32 [2021-06-02T20:58:32.374Z] 
20:58:32 [2021-06-02T20:58:32.374Z] queries/22.sql
20:58:32 [2021-06-02T20:58:32.374Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:58:32 [2021-06-02T20:58:32.374Z] Sort_39	2186432.06	4	root		time:25.9s, loops:2	Column#27	9.48 KB	0 Bytes
20:58:32 [2021-06-02T20:58:32.374Z] └─Projection_41	2186432.06	4	root		time:25.9s, loops:5, Concurrency:5	Column#27, Column#28, Column#29	23.7 KB	N/A
20:58:32 [2021-06-02T20:58:32.374Z]   └─HashAgg_42	2186432.06	4	root		time:25.9s, loops:5, partial_worker:{wall_time:25.8754522s, concurrency:5, task_num:180, tot_wait:2m9.325133303s, tot_exec:51.110071ms, tot_time:2m9.376382039s, max:25.87541573s, p95:25.87541573s}, final_worker:{wall_time:25.875468991s, concurrency:5, task_num:20, tot_wait:2m9.376924737s, tot_exec:269.483µs, tot_time:2m9.377204821s, max:25.875444584s, p95:25.875444584s}	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:58:32 [2021-06-02T20:58:32.374Z]     └─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
20:58:32 [2021-06-02T20:58:32.374Z]       └─HashJoin_43	2186432.06	181704	root		time:25.9s, loops:181, build_hash_table:{total:24.5s, fetch:921ms, build:23.5s}, probe:{concurrency:5, total:2m9.4s, max:25.9s, probe:5.86s, fetch:2m3.5s}	anti semi join, equal:[eq(tpch50.customer.c_custkey, tpch50.orders.o_custkey)]	590.2 MB	0 Bytes
20:58:32 [2021-06-02T20:58:32.374Z]         ├─TableReader_49(Build)	75000000.00	75000000	root		time:921.3ms, loops:73364, cop_task: {num: 153, max: 958.7ms, min: 229.5ms, avg: 488ms, p95: 880.2ms, max_proc_keys: 723875, p95_proc_keys: 553332, tot_proc: 1m14s, tot_wait: 36ms, rpc_num: 153, rpc_time: 1m14.7s, copr_cache: disabled}	data:TableFullScan_48	57.8 MB	N/A
20:58:32 [2021-06-02T20:58:32.374Z]         │ └─TableFullScan_48	75000000.00	75000000	cop[tikv]	table:orders	tikv_task:{proc max:935ms, min:210ms, p80:476ms, p95:847ms, 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:58:32 [2021-06-02T20:58:32.374Z]         └─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:58:32 [2021-06-02T20:58:32.374Z]           └─TableReader_46	2733040.07	3407619	root		time:670ms, loops:3319, cop_task: {num: 18, max: 1.13s, min: 508.3ms, avg: 848ms, p95: 1.13s, max_proc_keys: 582617, p95_proc_keys: 582617, tot_proc: 14.9s, tot_wait: 6ms, rpc_num: 18, rpc_time: 15.3s, copr_cache: disabled}	data:Selection_45	192.5 MB	N/A
20:58:32 [2021-06-02T20:58:32.374Z]             └─Selection_45	2733040.07	3407619	cop[tikv]		tikv_task:{proc max:1.06s, min:461ms, p80:940ms, p95:1.06s, 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:58:32 [2021-06-02T20:58:32.374Z]               └─TableFullScan_44	7500000.00	7500000	cop[tikv]	table:customer	tikv_task:{proc max:966ms, min:420ms, p80:861ms, p95:966ms, iters:7404, tasks:18}	keep order:false	N/A	N/A
20:58:32 [2021-06-02T20:58:32.374Z] + sync
20:58:32 [2021-06-02T20:58:32.374Z] + /usr/bin/echo 3
20:58:55 [2021-06-02T20:58:55.730Z] + sync
20:58:55 [2021-06-02T20:58:55.730Z] + /usr/bin/echo 3
20:59:37 [2021-06-02T20:59:37.044Z] + sync
20:59:37 [2021-06-02T20:59:37.044Z] + /usr/bin/echo 3
21:00:34 [2021-06-02T21:00:34.063Z] 
21:00:34 [2021-06-02T21:00:34.063Z] queries/22.sql
21:00:34 [2021-06-02T21:00:34.063Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
21:00:34 [2021-06-02T21:00:34.063Z] Sort_39	2186432.06	4	root		time:26.2s, loops:2	Column#27	9.48 KB	0 Bytes
21:00:34 [2021-06-02T21:00:34.063Z] └─Projection_41	2186432.06	4	root		time:26.2s, loops:5, Concurrency:5	Column#27, Column#28, Column#29	23.7 KB	N/A
21:00:34 [2021-06-02T21:00:34.063Z]   └─HashAgg_42	2186432.06	4	root		time:26.2s, loops:5, partial_worker:{wall_time:26.21267078s, concurrency:5, task_num:180, tot_wait:2m11.014178496s, tot_exec:48.639593ms, tot_time:2m11.062919294s, max:26.212646949s, p95:26.212646949s}, final_worker:{wall_time:26.212774281s, concurrency:5, task_num:20, tot_wait:2m11.062741597s, tot_exec:341.217µs, tot_time:2m11.063095754s, max:26.212684934s, p95:26.212684934s}	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:34 [2021-06-02T21:00:34.063Z]     └─Projection_51	2186432.06	181704	root		time:26.2s, loops:181, Concurrency:5	tpch50.customer.c_acctbal, substring(tpch50.customer.c_phone, 1, 2)->Column#32, substring(tpch50.customer.c_phone, 1, 2)->Column#33	693.6 KB	N/A
21:00:34 [2021-06-02T21:00:34.063Z]       └─HashJoin_43	2186432.06	181704	root		time:26.2s, loops:181, build_hash_table:{total:24.8s, fetch:955.4ms, build:23.9s}, probe:{concurrency:5, total:2m11s, max:26.2s, probe:5.48s, fetch:2m5.6s}	anti semi join, equal:[eq(tpch50.customer.c_custkey, tpch50.orders.o_custkey)]	590.2 MB	0 Bytes
21:00:34 [2021-06-02T21:00:34.063Z]         ├─TableReader_49(Build)	75000000.00	75000000	root		time:971.5ms, loops:73364, cop_task: {num: 153, max: 988.8ms, min: 268.6ms, avg: 493ms, p95: 789.6ms, max_proc_keys: 723875, p95_proc_keys: 553332, tot_proc: 1m14.6s, tot_wait: 36ms, rpc_num: 153, rpc_time: 1m15.4s, copr_cache: disabled}	data:TableFullScan_48	57.8 MB	N/A
21:00:34 [2021-06-02T21:00:34.063Z]         │ └─TableFullScan_48	75000000.00	75000000	cop[tikv]	table:orders	tikv_task:{proc max:957ms, min:256ms, p80:495ms, p95:764ms, 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:34 [2021-06-02T21:00:34.063Z]         └─Selection_47(Probe)	2733040.07	545246	root		time:1.48s, loops:534	in(substring(tpch50.customer.c_phone, 1, 2), "20", "40", "22", "30", "39", "42", "21")	94.6 KB	N/A
21:00:34 [2021-06-02T21:00:34.063Z]           └─TableReader_46	2733040.07	3407619	root		time:676.3ms, loops:3319, cop_task: {num: 18, max: 1.12s, min: 506.2ms, avg: 858.3ms, p95: 1.12s, max_proc_keys: 582617, p95_proc_keys: 582617, tot_proc: 14.9s, tot_wait: 1ms, rpc_num: 18, rpc_time: 15.4s, copr_cache: disabled}	data:Selection_45	192.5 MB	N/A
21:00:34 [2021-06-02T21:00:34.063Z]             └─Selection_45	2733040.07	3407619	cop[tikv]		tikv_task:{proc max:1.04s, min:464ms, p80:951ms, 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
21:00:34 [2021-06-02T21:00:34.063Z]               └─TableFullScan_44	7500000.00	7500000	cop[tikv]	table:customer	tikv_task:{proc max:944ms, min:412ms, p80:870ms, p95:944ms, iters:7404, tasks:18}	keep order:false	N/A	N/A
21:00:34 [2021-06-02T21:00:34.063Z] 
21:00:34 [2021-06-02T21:00:34.063Z] queries/22.sql
21:00:34 [2021-06-02T21:00:34.063Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
21:00:34 [2021-06-02T21:00:34.063Z] Sort_39	2186432.06	4	root		time:26.1s, loops:2	Column#27	9.48 KB	0 Bytes
21:00:34 [2021-06-02T21:00:34.063Z] └─Projection_41	2186432.06	4	root		time:26.1s, loops:5, Concurrency:5	Column#27, Column#28, Column#29	23.7 KB	N/A
21:00:34 [2021-06-02T21:00:34.064Z]   └─HashAgg_42	2186432.06	4	root		time:26.1s, loops:5, partial_worker:{wall_time:26.077824384s, concurrency:5, task_num:180, tot_wait:2m10.32993007s, tot_exec:58.246679ms, tot_time:2m10.388310954s, max:26.077748262s, p95:26.077748262s}, final_worker:{wall_time:26.077834898s, concurrency:5, task_num:20, tot_wait:2m10.388585938s, tot_exec:177.042µs, tot_time:2m10.388771073s, max:26.077767521s, p95:26.077767521s}	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:34 [2021-06-02T21:00:34.064Z]     └─Projection_51	2186432.06	181704	root		time:26.1s, 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:34 [2021-06-02T21:00:34.064Z]       └─HashJoin_43	2186432.06	181704	root		time:26.1s, loops:181, build_hash_table:{total:24.4s, fetch:954.7ms, build:23.4s}, probe:{concurrency:5, total:2m10.4s, max:26.1s, probe:7.01s, fetch:2m3.4s}	anti semi join, equal:[eq(tpch50.customer.c_custkey, tpch50.orders.o_custkey)]	590.2 MB	0 Bytes
21:00:34 [2021-06-02T21:00:34.064Z]         ├─TableReader_49(Build)	75000000.00	75000000	root		time:992.9ms, loops:73364, cop_task: {num: 153, max: 922ms, min: 197.6ms, avg: 491.1ms, p95: 830.6ms, max_proc_keys: 723875, p95_proc_keys: 553332, tot_proc: 1m14.4s, tot_wait: 30ms, rpc_num: 153, rpc_time: 1m15.1s, copr_cache: disabled}	data:TableFullScan_48	57.8 MB	N/A
21:00:34 [2021-06-02T21:00:34.064Z]         │ └─TableFullScan_48	75000000.00	75000000	cop[tikv]	table:orders	tikv_task:{proc max:884ms, min:183ms, p80:486ms, p95:789ms, 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:34 [2021-06-02T21:00:34.064Z]         └─Selection_47(Probe)	2733040.07	545246	root		time:1.66s, loops:534	in(substring(tpch50.customer.c_phone, 1, 2), "20", "40", "22", "30", "39", "42", "21")	94.6 KB	N/A
21:00:34 [2021-06-02T21:00:34.064Z]           └─TableReader_46	2733040.07	3407619	root		time:719.8ms, loops:3319, cop_task: {num: 18, max: 1.18s, min: 527.2ms, avg: 864.4ms, p95: 1.18s, max_proc_keys: 582617, p95_proc_keys: 582617, tot_proc: 15.1s, tot_wait: 1ms, rpc_num: 18, rpc_time: 15.6s, copr_cache: disabled}	data:Selection_45	192.5 MB	N/A
21:00:34 [2021-06-02T21:00:34.064Z]             └─Selection_45	2733040.07	3407619	cop[tikv]		tikv_task:{proc max:1.1s, min:488ms, p80:1.01s, p95:1.1s, iters:7404, tasks:18}, scan_detail: {total_process_keys: 7500000, total_keys: 7500018, rocksdb: {delete_skipped_count: 0, key_skipped_count: 14999982, block: {cache_hit_count: 28451, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.customer.c_acctbal, 5000.602894)	N/A	N/A
21:00:34 [2021-06-02T21:00:34.064Z]               └─TableFullScan_44	7500000.00	7500000	cop[tikv]	table:customer	tikv_task:{proc max:1.02s, min:452ms, p80:920ms, p95:1.02s, iters:7404, tasks:18}	keep order:false	N/A	N/A
21:00:34 [2021-06-02T21:00:34.064Z] 
21:00:34 [2021-06-02T21:00:34.064Z] queries/22.sql
21:00:34 [2021-06-02T21:00:34.064Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
21:00:34 [2021-06-02T21:00:34.064Z] Sort_39	2186432.06	4	root		time:25.7s, loops:2	Column#27	9.48 KB	0 Bytes
21:00:34 [2021-06-02T21:00:34.064Z] └─Projection_41	2186432.06	4	root		time:25.7s, loops:5, Concurrency:5	Column#27, Column#28, Column#29	23.7 KB	N/A
21:00:34 [2021-06-02T21:00:34.064Z]   └─HashAgg_42	2186432.06	4	root		time:25.7s, loops:5, partial_worker:{wall_time:25.675842337s, concurrency:5, task_num:180, tot_wait:2m8.324191552s, tot_exec:53.759675ms, tot_time:2m8.378091163s, max:25.675777648s, p95:25.675777648s}, final_worker:{wall_time:25.675851242s, concurrency:5, task_num:20, tot_wait:2m8.378794908s, tot_exec:242.476µs, tot_time:2m8.379045073s, max:25.675835608s, p95:25.675835608s}	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:34 [2021-06-02T21:00:34.064Z]     └─Projection_51	2186432.06	181704	root		time:25.7s, 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:34 [2021-06-02T21:00:34.064Z]       └─HashJoin_43	2186432.06	181704	root		time:25.7s, loops:181, build_hash_table:{total:24.4s, fetch:1.01s, build:23.3s}, probe:{concurrency:5, total:2m8.4s, max:25.7s, probe:5.37s, fetch:2m3s}	anti semi join, equal:[eq(tpch50.customer.c_custkey, tpch50.orders.o_custkey)]	590.2 MB	0 Bytes
21:00:34 [2021-06-02T21:00:34.064Z]         ├─TableReader_49(Build)	75000000.00	75000000	root		time:1.03s, loops:73364, cop_task: {num: 153, max: 978.4ms, min: 240.7ms, avg: 492.2ms, p95: 876.8ms, max_proc_keys: 723875, p95_proc_keys: 553332, tot_proc: 1m14.5s, tot_wait: 35ms, rpc_num: 153, rpc_time: 1m15.3s, copr_cache: disabled}	data:TableFullScan_48	57.8 MB	N/A
21:00:34 [2021-06-02T21:00:34.064Z]         │ └─TableFullScan_48	75000000.00	75000000	cop[tikv]	table:orders	tikv_task:{proc max:914ms, min:220ms, p80:496ms, p95:837ms, 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:34 [2021-06-02T21:00:34.064Z]         └─Selection_47(Probe)	2733040.07	545246	root		time:1.43s, loops:534	in(substring(tpch50.customer.c_phone, 1, 2), "20", "40", "22", "30", "39", "42", "21")	94.6 KB	N/A
21:00:34 [2021-06-02T21:00:34.064Z]           └─TableReader_46	2733040.07	3407619	root		time:621.1ms, loops:3319, cop_task: {num: 18, max: 1.13s, min: 489.4ms, avg: 844.5ms, p95: 1.13s, max_proc_keys: 582617, p95_proc_keys: 582617, tot_proc: 14.7s, rpc_num: 18, rpc_time: 15.2s, copr_cache: disabled}	data:Selection_45	192.5 MB	N/A
21:00:34 [2021-06-02T21:00:34.064Z]             └─Selection_45	2733040.07	3407619	cop[tikv]		tikv_task:{proc max:1.04s, min:455ms, p80:908ms, 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
21:00:34 [2021-06-02T21:00:34.064Z]               └─TableFullScan_44	7500000.00	7500000	cop[tikv]	table:customer	tikv_task:{proc max:940ms, min:416ms, p80:851ms, p95:940ms, iters:7404, tasks:18}	keep order:false	N/A	N/A
21:00:34 [2021-06-02T21:00:34.064Z] + sync
21:00:34 [2021-06-02T21:00:34.064Z] + /usr/bin/echo 3
21:00:34 [2021-06-02T21:00:34.064Z] 
21:00:34 [2021-06-02T21:00:34.064Z] queries/22.sql
21:00:34 [2021-06-02T21:00:34.064Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
21:00:34 [2021-06-02T21:00:34.064Z] Sort_39	2186432.06	4	root		time:25.5s, loops:2	Column#27	9.48 KB	0 Bytes
21:00:34 [2021-06-02T21:00:34.064Z] └─Projection_41	2186432.06	4	root		time:25.5s, loops:5, Concurrency:5	Column#27, Column#28, Column#29	23.7 KB	N/A
21:00:34 [2021-06-02T21:00:34.064Z]   └─HashAgg_42	2186432.06	4	root		time:25.5s, loops:5, partial_worker:{wall_time:25.495392646s, concurrency:5, task_num:180, tot_wait:2m7.417394425s, tot_exec:58.301731ms, tot_time:2m7.475795722s, max:25.495242602s, p95:25.495242602s}, final_worker:{wall_time:25.495361231s, concurrency:5, task_num:20, tot_wait:2m7.476100652s, tot_exec:233.645µs, tot_time:2m7.476342389s, max:25.495269675s, p95:25.495269675s}	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:34 [2021-06-02T21:00:34.064Z]     └─Projection_51	2186432.06	181704	root		time:25.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
21:00:34 [2021-06-02T21:00:34.064Z]       └─HashJoin_43	2186432.06	181704	root		time:25.5s, loops:181, build_hash_table:{total:24.1s, fetch:908.5ms, build:23.1s}, probe:{concurrency:5, total:2m7.5s, max:25.5s, probe:5.66s, fetch:2m1.8s}	anti semi join, equal:[eq(tpch50.customer.c_custkey, tpch50.orders.o_custkey)]	590.2 MB	0 Bytes
21:00:34 [2021-06-02T21:00:34.064Z]         ├─TableReader_49(Build)	75000000.00	75000000	root		time:919.5ms, loops:73364, cop_task: {num: 153, max: 928.8ms, min: 257.2ms, avg: 492.9ms, p95: 850.5ms, max_proc_keys: 723875, p95_proc_keys: 553332, tot_proc: 1m14.6s, tot_wait: 28ms, rpc_num: 153, rpc_time: 1m15.4s, copr_cache: disabled}	data:TableFullScan_48	57.8 MB	N/A
21:00:34 [2021-06-02T21:00:34.064Z]         │ └─TableFullScan_48	75000000.00	75000000	cop[tikv]	table:orders	tikv_task:{proc max:889ms, min:249ms, p80:480ms, p95:826ms, 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:34 [2021-06-02T21:00:34.064Z]         └─Selection_47(Probe)	2733040.07	545246	root		time:1.59s, loops:534	in(substring(tpch50.customer.c_phone, 1, 2), "20", "40", "22", "30", "39", "42", "21")	94.6 KB	N/A
21:00:34 [2021-06-02T21:00:34.064Z]           └─TableReader_46	2733040.07	3407619	root		time:642.5ms, loops:3319, cop_task: {num: 18, max: 1.16s, min: 508.5ms, avg: 837.8ms, p95: 1.16s, max_proc_keys: 582617, p95_proc_keys: 582617, tot_proc: 14.7s, tot_wait: 1ms, rpc_num: 18, rpc_time: 15.1s, copr_cache: disabled}	data:Selection_45	192.5 MB	N/A
21:00:34 [2021-06-02T21:00:34.064Z]             └─Selection_45	2733040.07	3407619	cop[tikv]		tikv_task:{proc max:1.1s, min:458ms, p80:903ms, p95:1.1s, iters:7404, tasks:18}, scan_detail: {total_process_keys: 7500000, total_keys: 7500018, rocksdb: {delete_skipped_count: 0, key_skipped_count: 14999982, block: {cache_hit_count: 28451, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.customer.c_acctbal, 5000.602894)	N/A	N/A
21:00:34 [2021-06-02T21:00:34.064Z]               └─TableFullScan_44	7500000.00	7500000	cop[tikv]	table:customer	tikv_task:{proc max:1.02s, min:414ms, p80:824ms, p95:1.02s, iters:7404, tasks:18}	keep order:false	N/A	N/A
21:00:34 [2021-06-02T21:00:34.064Z] 
21:00:34 [2021-06-02T21:00:34.064Z] + tiup cluster stop benchbot
21:00:34 [2021-06-02T21:00:34.064Z] Starting component `cluster`: /home/tidb/.tiup/components/cluster/v1.4.4/tiup-cluster stop benchbot
21:00:34 [2021-06-02T21:00:34.064Z] + [ 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:34 [2021-06-02T21:00:34.064Z] + [Parallel] - UserSSH: user=tidb, host=172.16.5.86
21:00:34 [2021-06-02T21:00:34.064Z] + [Parallel] - UserSSH: user=tidb, host=172.16.5.86
21:00:34 [2021-06-02T21:00:34.064Z] + [Parallel] - UserSSH: user=tidb, host=172.16.5.86
21:00:34 [2021-06-02T21:00:34.064Z] + [Parallel] - UserSSH: user=tidb, host=172.16.5.86
21:00:34 [2021-06-02T21:00:34.064Z] + [Parallel] - UserSSH: user=tidb, host=172.16.5.86
21:00:34 [2021-06-02T21:00:34.064Z] + [ Serial ] - StopCluster
21:00:34 [2021-06-02T21:00:34.064Z] Stopping component grafana
21:00:34 [2021-06-02T21:00:34.064Z] 	Stopping instance 172.16.5.86
21:00:34 [2021-06-02T21:00:34.064Z] 	Stop grafana 172.16.5.86:3000 success
21:00:34 [2021-06-02T21:00:34.064Z] Stopping component prometheus
21:00:34 [2021-06-02T21:00:34.064Z] 	Stopping instance 172.16.5.86
21:00:34 [2021-06-02T21:00:34.064Z] 	Stop prometheus 172.16.5.86:9090 success
21:00:34 [2021-06-02T21:00:34.064Z] Stopping component tidb
21:00:34 [2021-06-02T21:00:34.064Z] 	Stopping instance 172.16.5.86
21:00:34 [2021-06-02T21:00:34.064Z] 	Stop tidb 172.16.5.86:4000 success
21:00:34 [2021-06-02T21:00:34.064Z] Stopping component tikv
21:00:34 [2021-06-02T21:00:34.064Z] 	Stopping instance 172.16.5.86
21:00:35 [2021-06-02T21:00:35.430Z] 	Stop tikv 172.16.5.86:20160 success
21:00:35 [2021-06-02T21:00:35.430Z] Stopping component pd
21:00:35 [2021-06-02T21:00:35.430Z] 	Stopping instance 172.16.5.86
21:00:35 [2021-06-02T21:00:35.430Z] 	Stop pd 172.16.5.86:2379 success
21:00:35 [2021-06-02T21:00:35.430Z] Stopping component node_exporter
21:00:35 [2021-06-02T21:00:35.989Z] Stopping component blackbox_exporter
21:00:35 [2021-06-02T21:00:35.989Z] Stopped cluster `benchbot` successfully
21:00:36 [2021-06-02T21:00:36.249Z] [Pipeline] sh
21:00:36 [2021-06-02T21:00:36.525Z] + cat bench_result
21:00:36 [2021-06-02T21:00:36.530Z] [Pipeline] }
21:00:36 [2021-06-02T21:00:36.532Z] [Pipeline] // dir
21:00:36 [2021-06-02T21:00:36.534Z] [Pipeline] }
21:00:36 [2021-06-02T21:00:36.536Z] [Pipeline] // stage
21:00:36 [2021-06-02T21:00:36.538Z] [Pipeline] }
21:00:36 [2021-06-02T21:00:36.539Z] [Pipeline] // node
21:00:36 [2021-06-02T21:00:36.542Z] [Pipeline] }
21:00:36 [2021-06-02T21:00:36.543Z] [Pipeline] // catchError
21:00:36 [2021-06-02T21:00:36.548Z] [Pipeline] stage
21:00:36 [2021-06-02T21:00:36.550Z] [Pipeline] { (Summary)
21:00:36 [2021-06-02T21:00:36.563Z] [Pipeline] slackSend
21:00:36 [2021-06-02T21:00:36.563Z] 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:36 [2021-06-02T21:00:36.589Z] sh: line 1:  7676 Terminated              sleep 3
21:00:36 [2021-06-02T21:00:36.602Z] sh: line 1:  7751 Terminated              sleep 3
21:00:55 [2021-06-02T21:00:55.038Z] [Pipeline] }
21:00:55 [2021-06-02T21:00:55.040Z] [Pipeline] // stage
21:00:55 [2021-06-02T21:00:55.042Z] [Pipeline] End of Pipeline
21:00:55 [2021-06-02T21:00:55.056Z] Finished: SUCCESS