SuccessConsole Output

Skipping 1,193 KB.. Full Log
partsupp.ps_suppkey)->tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_availqty)->tpch50.partsupp.ps_availqty, funcs:sum(tpch50.lineitem.l_quantity)->Column#44	194.5 MB	N/A
20:39:21 [2021-06-01T20:39:21.702Z]         └─HashJoin_59	9711455.06	634004	root		time:36.8s, loops:625, build_hash_table:{total:2.41s, fetch:2.19s, build:224.8ms}, probe:{concurrency:5, total:3m4.1s, max:36.8s, probe:14.3s, fetch:2m49.8s}	left outer join, equal:[eq(tpch50.partsupp.ps_partkey, tpch50.lineitem.l_partkey) eq(tpch50.partsupp.ps_suppkey, tpch50.lineitem.l_suppkey)]	10.4 MB	0 Bytes
20:39:21 [2021-06-01T20:39:21.702Z]           ├─IndexHashJoin_67(Build)	321865.05	435528	root		time:2.37s, loops:430, inner:{total:2.53s, concurrency:5, task:12, construct:147.7ms, fetch:2.02s, build:28.3ms, join:356ms}	inner join, inner:IndexLookUp_64, outer key:tpch50.part.p_partkey, inner key:tpch50.partsupp.ps_partkey, equal cond:eq(tpch50.part.p_partkey, tpch50.partsupp.ps_partkey)	20.0 MB	N/A
20:39:21 [2021-06-01T20:39:21.702Z]           │ ├─TableReader_96(Build)	80007.93	108882	root		time:2.04s, loops:112, cop_task: {num: 20, max: 1.58s, min: 600.9ms, avg: 1.08s, p95: 1.58s, max_proc_keys: 686055, p95_proc_keys: 686055, tot_proc: 21.5s, tot_wait: 3ms, rpc_num: 20, rpc_time: 21.6s, copr_cache: disabled}	data:Selection_95	725.8 KB	N/A
20:39:21 [2021-06-01T20:39:21.702Z]           │ │ └─Selection_95	80007.93	108882	cop[tikv]		tikv_task:{proc max:1.57s, min:598ms, p80:1.29s, p95:1.57s, iters:9859, tasks:20}, scan_detail: {total_process_keys: 10000000, total_keys: 10000020, rocksdb: {delete_skipped_count: 0, key_skipped_count: 19999980, block: {cache_hit_count: 31499, read_count: 0, read_byte: 0 Bytes}}}	like(tpch50.part.p_name, "green%", 92)	N/A	N/A
20:39:21 [2021-06-01T20:39:21.702Z]           │ │   └─TableFullScan_94	10000000.00	10000000	cop[tikv]	table:part	tikv_task:{proc max:1.47s, min:553ms, p80:1.21s, p95:1.47s, iters:9859, tasks:20}	keep order:false	N/A	N/A
20:39:21 [2021-06-01T20:39:21.702Z]           │ └─IndexLookUp_64(Probe)	4.02	435528	root		time:1.9s, loops:447, index_task: {total_time: 1.15s, fetch_handle: 1.15s, build: 95µs, wait: 273.4µs}, table_task: {total_time: 7.5s, num: 56, concurrency: 60}		19.4 KB	N/A
20:39:21 [2021-06-01T20:39:21.702Z]           │   ├─IndexRangeScan_62(Build)	4.02	435528	cop[tikv]	table:partsupp, index:PRIMARY(PS_PARTKEY, PS_SUPPKEY)	time:1.11s, loops:479, cop_task: {num: 59, max: 195ms, min: 4.45ms, avg: 86.8ms, p95: 181.5ms, max_proc_keys: 15288, p95_proc_keys: 15008, tot_proc: 4.75s, tot_wait: 37ms, rpc_num: 59, rpc_time: 5.12s, copr_cache: disabled}, tikv_task:{proc max:187ms, min:3ms, p80:137ms, p95:176ms, iters:692, tasks:59}, scan_detail: {total_process_keys: 435528, total_keys: 544410, rocksdb: {delete_skipped_count: 0, key_skipped_count: 435528, block: {cache_hit_count: 980292, read_count: 0, read_byte: 0 Bytes}}}	range: decided by [eq(tpch50.partsupp.ps_partkey, tpch50.part.p_partkey)], keep order:false	N/A	N/A
20:39:21 [2021-06-01T20:39:21.702Z]           │   └─TableRowIDScan_63(Probe)	4.02	435528	cop[tikv]	table:partsupp	time:2.3s, loops:504, cop_task: {num: 1452, max: 65.1ms, min: 429.2µs, avg: 16.1ms, p95: 32.8ms, max_proc_keys: 1028, p95_proc_keys: 556, tot_proc: 17.6s, tot_wait: 3.72s, rpc_num: 1452, rpc_time: 23.3s, copr_cache: disabled}, tikv_task:{proc max:42ms, min:0s, p80:16ms, p95:22ms, iters:5370, tasks:1452}, scan_detail: {total_process_keys: 435528, total_keys: 473513, rocksdb: {delete_skipped_count: 0, key_skipped_count: 194109, block: {cache_hit_count: 3644173, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:39:21 [2021-06-01T20:39:21.702Z]           └─TableReader_101(Probe)	46310896.67	45504356	root		time:32.5s, loops:44290, cop_task: {num: 761, max: 1.11s, min: 357.9ms, avg: 686.5ms, p95: 831.6ms, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 8m39.3s, tot_wait: 111ms, rpc_num: 761, rpc_time: 8m42.4s, copr_cache: disabled}	data:Selection_100	52.6 MB	N/A
20:39:21 [2021-06-01T20:39:21.702Z]             └─Selection_100	46310896.67	45504356	cop[tikv]		tikv_task:{proc max:1.08s, min:348ms, p80:731ms, 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:39:21 [2021-06-01T20:39:21.702Z]               └─TableFullScan_99	300005811.00	300005811	cop[tikv]	table:lineitem	tikv_task:{proc max:1.03s, min:327ms, p80:700ms, p95:775ms, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:39:21 [2021-06-01T20:39:21.702Z] + sync
20:39:21 [2021-06-01T20:39:21.702Z] + /usr/bin/echo 3
20:40:04 [2021-06-01T20:40:04.913Z] + sync
20:40:04 [2021-06-01T20:40:04.913Z] + /usr/bin/echo 3
20:40:44 [2021-06-01T20:40:44.498Z] 
20:40:44 [2021-06-01T20:40:44.498Z] queries/20.sql
20:40:44 [2021-06-01T20:40:44.498Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:40:44 [2021-06-01T20:40:44.498Z] Sort_30	20000.00	8982	root		time:37.9s, loops:10	tpch50.supplier.s_name	614.3 KB	0 Bytes
20:40:44 [2021-06-01T20:40:44.498Z] └─HashJoin_35	20000.00	8982	root		time:37.9s, loops:11, build_hash_table:{total:1.38s, fetch:1.37s, build:10.6ms}, probe:{concurrency:5, total:3m9.6s, max:37.9s, probe:50.4ms, fetch:3m9.5s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.partsupp.ps_suppkey)]	1.46 MB	0 Bytes
20:40:44 [2021-06-01T20:40:44.498Z]   ├─HashJoin_48(Build)	20000.00	19972	root		time:1.38s, loops:22, build_hash_table:{total:127.7µs, fetch:122.5µs, build:5.22µs}, probe:{concurrency:5, total:6.91s, max:1.38s, probe:111.2ms, fetch:6.8s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:40:44 [2021-06-01T20:40:44.498Z]   │ ├─TableReader_53(Build)	1.00	1	root		time:37.2µs, loops:2, cop_task: {num: 1, max: 989.6µs, proc_keys: 25, tot_proc: 1ms, rpc_num: 1, rpc_time: 973µs, copr_cache: disabled}	data:Selection_52	244 Bytes	N/A
20:40:44 [2021-06-01T20:40:44.498Z]   │ │ └─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:44 [2021-06-01T20:40:44.498Z]   │ │   └─TableFullScan_51	25.00	25	cop[tikv]	table:nation	tikv_task:{time:1ms, loops:1}	keep order:false	N/A	N/A
20:40:44 [2021-06-01T20:40:44.498Z]   │ └─TableReader_50(Probe)	500000.00	500000	root		time:1.36s, loops:490, cop_task: {num: 1, max: 1.36s, proc_keys: 500000, tot_proc: 1.28s, rpc_num: 1, rpc_time: 1.36s, copr_cache: disabled}	data:TableFullScan_49	35.8 MB	N/A
20:40:44 [2021-06-01T20:40:44.498Z]   │   └─TableFullScan_49	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:1.14s, loops:493}, scan_detail: {total_process_keys: 500000, total_keys: 500001, rocksdb: {delete_skipped_count: 0, key_skipped_count: 999999, block: {cache_hit_count: 1692, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:40:44 [2021-06-01T20:40:44.498Z]   └─HashAgg_54(Probe)	257492.04	223999	root		time:37.9s, loops:222, partial_worker:{wall_time:37.830071424s, concurrency:5, task_num:289, tot_wait:3m8.832088692s, tot_exec:274.71124ms, tot_time:3m9.140652473s, max:37.829820612s, p95:37.829820612s}, final_worker:{wall_time:37.91204158s, concurrency:5, task_num:25, tot_wait:3m9.133674287s, tot_exec:369.422845ms, tot_time:3m9.503110201s, max:37.91180435s, p95:37.91180435s}	group by:tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_suppkey)->tpch50.partsupp.ps_suppkey	61.4 MB	N/A
20:40:44 [2021-06-01T20:40:44.498Z]     └─Selection_55	257492.04	295898	root		time:37.8s, loops:290	gt(cast(tpch50.partsupp.ps_availqty, decimal(20,0) BINARY), mul(0.5, Column#44))	59.2 KB	N/A
20:40:44 [2021-06-01T20:40:44.498Z]       └─HashAgg_56	321865.05	435528	root		time:37.7s, loops:430, partial_worker:{wall_time:37.46790157s, concurrency:5, task_num:624, tot_wait:3m6.038954479s, tot_exec:1.097234685s, tot_time:3m7.320400642s, max:37.467810043s, p95:37.467810043s}, final_worker:{wall_time:37.818534197s, concurrency:5, task_num:25, tot_wait:3m7.308338419s, tot_exec:1.764904006s, tot_time:3m9.073258661s, max:37.818464323s, p95:37.818464323s}	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:44 [2021-06-01T20:40:44.498Z]         └─HashJoin_59	9711455.06	634004	root		time:37.4s, loops:625, build_hash_table:{total:2.34s, fetch:2.14s, build:203.5ms}, probe:{concurrency:5, total:3m6.8s, max:37.4s, probe:14.6s, fetch:2m52.2s}	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:44 [2021-06-01T20:40:44.498Z]           ├─IndexHashJoin_67(Build)	321865.05	435528	root		time:2.31s, loops:429, inner:{total:2.86s, concurrency:5, task:12, construct:125ms, fetch:2.39s, build:24.6ms, join:339.9ms}	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:44 [2021-06-01T20:40:44.498Z]           │ ├─TableReader_96(Build)	80007.93	108882	root		time:1.94s, loops:112, cop_task: {num: 20, max: 1.58s, min: 630.6ms, avg: 1.07s, p95: 1.58s, max_proc_keys: 686055, p95_proc_keys: 686055, tot_proc: 21.4s, tot_wait: 17ms, rpc_num: 20, rpc_time: 21.4s, copr_cache: disabled}	data:Selection_95	680.6 KB	N/A
20:40:44 [2021-06-01T20:40:44.499Z]           │ │ └─Selection_95	80007.93	108882	cop[tikv]		tikv_task:{proc max:1.53s, min:626ms, p80:1.26s, 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:40:44 [2021-06-01T20:40:44.499Z]           │ │   └─TableFullScan_94	10000000.00	10000000	cop[tikv]	table:part	tikv_task:{proc max:1.44s, min:577ms, p80:1.17s, p95:1.44s, iters:9859, tasks:20}	keep order:false	N/A	N/A
20:40:44 [2021-06-01T20:40:44.499Z]           │ └─IndexLookUp_64(Probe)	4.02	435528	root		time:2.28s, loops:447, index_task: {total_time: 1.27s, fetch_handle: 1.27s, build: 87.8µs, wait: 266.7µs}, table_task: {total_time: 8.7s, num: 56, concurrency: 60}		20.6 KB	N/A
20:40:44 [2021-06-01T20:40:44.499Z]           │   ├─IndexRangeScan_62(Build)	4.02	435528	cop[tikv]	table:partsupp, index:PRIMARY(PS_PARTKEY, PS_SUPPKEY)	time:1.23s, loops:482, cop_task: {num: 59, max: 231.9ms, min: 4.5ms, avg: 95.1ms, p95: 206.5ms, max_proc_keys: 15288, p95_proc_keys: 14948, tot_proc: 5.08s, tot_wait: 212ms, rpc_num: 59, rpc_time: 5.61s, copr_cache: disabled}, tikv_task:{proc max:205ms, min:4ms, p80:147ms, p95:181ms, iters:690, tasks:59}, scan_detail: {total_process_keys: 435528, total_keys: 544410, rocksdb: {delete_skipped_count: 0, key_skipped_count: 435528, block: {cache_hit_count: 980292, read_count: 0, read_byte: 0 Bytes}}}	range: decided by [eq(tpch50.partsupp.ps_partkey, tpch50.part.p_partkey)], keep order:false	N/A	N/A
20:40:44 [2021-06-01T20:40:44.499Z]           │   └─TableRowIDScan_63(Probe)	4.02	435528	cop[tikv]	table:partsupp	time:2.92s, loops:506, cop_task: {num: 1414, max: 96.1ms, min: 420.3µs, avg: 20.4ms, p95: 41.8ms, max_proc_keys: 992, p95_proc_keys: 628, tot_proc: 19.7s, tot_wait: 6.25s, rpc_num: 1414, rpc_time: 28.8s, copr_cache: disabled}, tikv_task:{proc max:40ms, min:0s, p80:17ms, p95:24ms, iters:5270, tasks:1414}, scan_detail: {total_process_keys: 435528, total_keys: 473506, rocksdb: {delete_skipped_count: 0, key_skipped_count: 194082, block: {cache_hit_count: 3643872, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:40:44 [2021-06-01T20:40:44.499Z]           └─TableReader_101(Probe)	46310896.67	45504356	root		time:32.9s, loops:44290, cop_task: {num: 761, max: 1.14s, min: 299.7ms, avg: 698.8ms, p95: 850.4ms, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 8m48.7s, tot_wait: 122ms, rpc_num: 761, rpc_time: 8m51.7s, copr_cache: disabled}	data:Selection_100	52.6 MB	N/A
20:40:44 [2021-06-01T20:40:44.499Z]             └─Selection_100	46310896.67	45504356	cop[tikv]		tikv_task:{proc max:1.07s, min:287ms, p80:745ms, p95:833ms, iters:296606, tasks:761}, scan_detail: {total_process_keys: 300005811, total_keys: 300006572, rocksdb: {delete_skipped_count: 0, key_skipped_count: 600010861, block: {cache_hit_count: 1124648, read_count: 0, read_byte: 0 Bytes}}}	ge(tpch50.lineitem.l_shipdate, 1993-01-01 00:00:00.000000), lt(tpch50.lineitem.l_shipdate, 1994-01-01)	N/A	N/A
20:40:44 [2021-06-01T20:40:44.499Z]               └─TableFullScan_99	300005811.00	300005811	cop[tikv]	table:lineitem	tikv_task:{proc max:1.03s, min:272ms, p80:712ms, p95:803ms, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:40:44 [2021-06-01T20:40:44.499Z] 
20:40:44 [2021-06-01T20:40:44.499Z] queries/20.sql
20:40:44 [2021-06-01T20:40:44.499Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:40:44 [2021-06-01T20:40:44.499Z] Sort_30	20000.00	8982	root		time:38.9s, loops:10	tpch50.supplier.s_name	614.3 KB	0 Bytes
20:40:44 [2021-06-01T20:40:44.499Z] └─HashJoin_35	20000.00	8982	root		time:38.9s, loops:11, build_hash_table:{total:1.26s, fetch:1.24s, build:14.2ms}, probe:{concurrency:5, total:3m14.7s, max:38.9s, probe:50.4ms, fetch:3m14.6s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.partsupp.ps_suppkey)]	1.47 MB	0 Bytes
20:40:44 [2021-06-01T20:40:44.499Z]   ├─HashJoin_48(Build)	20000.00	19972	root		time:1.25s, loops:22, build_hash_table:{total:222.2µs, fetch:216.3µs, build:5.86µs}, probe:{concurrency:5, total:6.27s, max:1.25s, probe:146.4ms, fetch:6.12s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:40:44 [2021-06-01T20:40:44.499Z]   │ ├─TableReader_53(Build)	1.00	1	root		time:45.4µs, loops:2, cop_task: {num: 1, max: 1.08ms, proc_keys: 25, tot_proc: 1ms, rpc_num: 1, rpc_time: 1.06ms, copr_cache: disabled}	data:Selection_52	244 Bytes	N/A
20:40:44 [2021-06-01T20:40:44.499Z]   │ │ └─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:44 [2021-06-01T20:40:44.499Z]   │ │   └─TableFullScan_51	25.00	25	cop[tikv]	table:nation	tikv_task:{time:1ms, loops:1}	keep order:false	N/A	N/A
20:40:44 [2021-06-01T20:40:44.499Z]   │ └─TableReader_50(Probe)	500000.00	500000	root		time:1.23s, loops:490, cop_task: {num: 1, max: 1.22s, proc_keys: 500000, tot_proc: 1.15s, rpc_num: 1, rpc_time: 1.22s, copr_cache: disabled}	data:TableFullScan_49	35.8 MB	N/A
20:40:44 [2021-06-01T20:40:44.499Z]   │   └─TableFullScan_49	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:1.01s, loops:493}, scan_detail: {total_process_keys: 500000, total_keys: 500001, rocksdb: {delete_skipped_count: 0, key_skipped_count: 999999, block: {cache_hit_count: 1692, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:40:44 [2021-06-01T20:40:44.499Z]   └─HashAgg_54(Probe)	257492.04	223999	root		time:38.9s, loops:222, partial_worker:{wall_time:38.828180193s, concurrency:5, task_num:289, tot_wait:3m13.873682557s, tot_exec:192.548173ms, tot_time:3m14.106258564s, max:38.828155419s, p95:38.828155419s}, final_worker:{wall_time:38.939401817s, concurrency:5, task_num:25, tot_wait:3m14.093882197s, tot_exec:558.737792ms, tot_time:3m14.65263747s, max:38.93939312s, p95:38.93939312s}	group by:tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_suppkey)->tpch50.partsupp.ps_suppkey	61.4 MB	N/A
20:40:44 [2021-06-01T20:40:44.499Z]     └─Selection_55	257492.04	295898	root		time:38.8s, loops:290	gt(cast(tpch50.partsupp.ps_availqty, decimal(20,0) BINARY), mul(0.5, Column#44))	59.2 KB	N/A
20:40:44 [2021-06-01T20:40:44.499Z]       └─HashAgg_56	321865.05	435528	root		time:38.7s, loops:430, partial_worker:{wall_time:38.48158233s, concurrency:5, task_num:627, tot_wait:3m11.289401603s, tot_exec:964.78456ms, tot_time:3m12.38071356s, max:38.481539074s, p95:38.481539074s}, final_worker:{wall_time:38.811271604s, concurrency:5, task_num:25, tot_wait:3m12.362786949s, tot_exec:1.675035837s, tot_time:3m14.037838727s, max:38.811252283s, p95:38.811252283s}	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:44 [2021-06-01T20:40:44.499Z]         └─HashJoin_59	9711455.06	634004	root		time:38.4s, loops:628, build_hash_table:{total:2.48s, fetch:2.27s, build:204.9ms}, probe:{concurrency:5, total:3m12s, max:38.4s, probe:13.9s, fetch:2m58.1s}	left outer join, equal:[eq(tpch50.partsupp.ps_partkey, tpch50.lineitem.l_partkey) eq(tpch50.partsupp.ps_suppkey, tpch50.lineitem.l_suppkey)]	10.4 MB	0 Bytes
20:40:44 [2021-06-01T20:40:44.499Z]           ├─IndexHashJoin_67(Build)	321865.05	435528	root		time:2.43s, loops:430, inner:{total:2.59s, concurrency:5, task:12, construct:132.6ms, fetch:2.14s, build:32.2ms, join:319.1ms}	inner join, inner:IndexLookUp_64, outer key:tpch50.part.p_partkey, inner key:tpch50.partsupp.ps_partkey, equal cond:eq(tpch50.part.p_partkey, tpch50.partsupp.ps_partkey)	20.1 MB	N/A
20:40:44 [2021-06-01T20:40:44.499Z]           │ ├─TableReader_96(Build)	80007.93	108882	root		time:2.11s, loops:112, cop_task: {num: 20, max: 1.52s, min: 583.6ms, avg: 1.1s, p95: 1.52s, max_proc_keys: 686055, p95_proc_keys: 686055, tot_proc: 21.9s, tot_wait: 21ms, rpc_num: 20, rpc_time: 21.9s, copr_cache: disabled}	data:Selection_95	665.9 KB	N/A
20:40:44 [2021-06-01T20:40:44.499Z]           │ │ └─Selection_95	80007.93	108882	cop[tikv]		tikv_task:{proc max:1.51s, min:582ms, p80:1.32s, p95:1.51s, 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:44 [2021-06-01T20:40:44.499Z]           │ │   └─TableFullScan_94	10000000.00	10000000	cop[tikv]	table:part	tikv_task:{proc max:1.41s, min:543ms, p80:1.23s, p95:1.41s, iters:9859, tasks:20}	keep order:false	N/A	N/A
20:40:44 [2021-06-01T20:40:44.499Z]           │ └─IndexLookUp_64(Probe)	4.02	435528	root		time:2.03s, loops:447, index_task: {total_time: 1.22s, fetch_handle: 1.22s, build: 110.5µs, wait: 281.8µs}, table_task: {total_time: 7.9s, num: 56, concurrency: 60}		19.4 KB	N/A
20:40:44 [2021-06-01T20:40:44.499Z]           │   ├─IndexRangeScan_62(Build)	4.02	435528	cop[tikv]	table:partsupp, index:PRIMARY(PS_PARTKEY, PS_SUPPKEY)	time:1.17s, loops:479, cop_task: {num: 60, max: 203ms, min: 4.58ms, avg: 84ms, p95: 186.2ms, max_proc_keys: 15288, p95_proc_keys: 15008, tot_proc: 4.64s, tot_wait: 51ms, rpc_num: 60, rpc_time: 5.04s, copr_cache: disabled}, tikv_task:{proc max:196ms, min:3ms, p80:137ms, p95:178ms, iters:694, tasks:60}, scan_detail: {total_process_keys: 435528, total_keys: 544410, rocksdb: {delete_skipped_count: 0, key_skipped_count: 435528, block: {cache_hit_count: 980292, read_count: 0, read_byte: 0 Bytes}}}	range: decided by [eq(tpch50.partsupp.ps_partkey, tpch50.part.p_partkey)], keep order:false	N/A	N/A
20:40:44 [2021-06-01T20:40:44.499Z]           │   └─TableRowIDScan_63(Probe)	4.02	435528	cop[tikv]	table:partsupp	time:2.49s, loops:503, cop_task: {num: 1499, max: 82ms, min: 498.8µs, avg: 16ms, p95: 31.7ms, max_proc_keys: 952, p95_proc_keys: 504, tot_proc: 18s, tot_wait: 3.66s, rpc_num: 1499, rpc_time: 23.9s, copr_cache: disabled}, tikv_task:{proc max:37ms, min:0s, p80:16ms, p95:21ms, iters:5487, tasks:1499}, scan_detail: {total_process_keys: 435528, total_keys: 473484, rocksdb: {delete_skipped_count: 0, key_skipped_count: 193988, block: {cache_hit_count: 3644626, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:40:44 [2021-06-01T20:40:44.499Z]           └─TableReader_101(Probe)	46310896.67	45504356	root		time:33.9s, loops:44289, cop_task: {num: 761, max: 1.24s, min: 284ms, avg: 717.5ms, p95: 863.4ms, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 9m2.9s, tot_wait: 140ms, rpc_num: 761, rpc_time: 9m6s, copr_cache: disabled}	data:Selection_100	52.6 MB	N/A
20:40:44 [2021-06-01T20:40:44.499Z]             └─Selection_100	46310896.67	45504356	cop[tikv]		tikv_task:{proc max:1.21s, min:271ms, p80:763ms, p95:845ms, 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:44 [2021-06-01T20:40:44.499Z]               └─TableFullScan_99	300005811.00	300005811	cop[tikv]	table:lineitem	tikv_task:{proc max:1.16s, min:241ms, p80:733ms, p95:812ms, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:40:44 [2021-06-01T20:40:44.499Z] + sync
20:40:44 [2021-06-01T20:40:44.499Z] + /usr/bin/echo 3
20:41:26 [2021-06-01T20:41:26.252Z] + sync
20:41:26 [2021-06-01T20:41:26.252Z] + /usr/bin/echo 3
20:42:09 [2021-06-01T20:42:09.071Z] 
20:42:09 [2021-06-01T20:42:09.071Z] queries/20.sql
20:42:09 [2021-06-01T20:42:09.071Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:42:09 [2021-06-01T20:42:09.071Z] Sort_30	20000.00	8982	root		time:39.6s, loops:10	tpch50.supplier.s_name	612.9 KB	0 Bytes
20:42:09 [2021-06-01T20:42:09.071Z] └─HashJoin_35	20000.00	8982	root		time:39.6s, loops:11, build_hash_table:{total:1.28s, fetch:1.27s, build:9.79ms}, probe:{concurrency:5, total:3m17.9s, max:39.6s, probe:50.4ms, fetch:3m17.8s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.partsupp.ps_suppkey)]	1.51 MB	0 Bytes
20:42:09 [2021-06-01T20:42:09.071Z]   ├─HashJoin_48(Build)	20000.00	19972	root		time:1.27s, loops:23, build_hash_table:{total:181µs, fetch:175.1µs, build:5.87µs}, probe:{concurrency:5, total:6.36s, max:1.27s, probe:100.7ms, fetch:6.26s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:42:09 [2021-06-01T20:42:09.071Z]   │ ├─TableReader_53(Build)	1.00	1	root		time:40.5µs, loops:2, cop_task: {num: 1, max: 1.04ms, proc_keys: 25, rpc_num: 1, rpc_time: 1.02ms, copr_cache: disabled}	data:Selection_52	236 Bytes	N/A
20:42:09 [2021-06-01T20:42:09.071Z]   │ │ └─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:42:09 [2021-06-01T20:42:09.072Z]   │ │   └─TableFullScan_51	25.00	25	cop[tikv]	table:nation	tikv_task:{time:0s, loops:1}	keep order:false	N/A	N/A
20:42:09 [2021-06-01T20:42:09.072Z]   │ └─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:42:09 [2021-06-01T20:42:09.072Z]   │   └─TableFullScan_49	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:1.02s, loops:493}, scan_detail: {total_process_keys: 500000, total_keys: 500001, rocksdb: {delete_skipped_count: 0, key_skipped_count: 999999, block: {cache_hit_count: 1692, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:42:09 [2021-06-01T20:42:09.072Z]   └─HashAgg_54(Probe)	257492.04	223999	root		time:39.6s, loops:222, partial_worker:{wall_time:39.506074817s, concurrency:5, task_num:289, tot_wait:3m17.29593137s, tot_exec:196.490733ms, tot_time:3m17.526034347s, max:39.506007203s, p95:39.506007203s}, final_worker:{wall_time:39.574075215s, concurrency:5, task_num:25, tot_wait:3m17.518243748s, tot_exec:344.206196ms, tot_time:3m17.862463787s, max:39.574015558s, p95:39.574015558s}	group by:tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_suppkey)->tpch50.partsupp.ps_suppkey	61.4 MB	N/A
20:42:09 [2021-06-01T20:42:09.072Z]     └─Selection_55	257492.04	295898	root		time:39.5s, loops:290	gt(cast(tpch50.partsupp.ps_availqty, decimal(20,0) BINARY), mul(0.5, Column#44))	59.2 KB	N/A
20:42:09 [2021-06-01T20:42:09.072Z]       └─HashAgg_56	321865.05	435528	root		time:39.4s, loops:430, partial_worker:{wall_time:39.168060137s, concurrency:5, task_num:626, tot_wait:3m14.607905087s, tot_exec:1.101466886s, tot_time:3m15.816217891s, max:39.168021168s, p95:39.168021168s}, final_worker:{wall_time:39.496521085s, concurrency:5, task_num:25, tot_wait:3m15.790701704s, tot_exec:1.674590772s, tot_time:3m17.465325568s, max:39.496496065s, p95:39.496496065s}	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:42:09 [2021-06-01T20:42:09.072Z]         └─HashJoin_59	9711455.06	634004	root		time:39.1s, loops:627, build_hash_table:{total:2.6s, fetch:2.41s, build:187.9ms}, probe:{concurrency:5, total:3m15.3s, max:39.1s, probe:13.9s, fetch:3m1.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:42:09 [2021-06-01T20:42:09.072Z]           ├─IndexHashJoin_67(Build)	321865.05	435528	root		time:2.57s, loops:430, inner:{total:2.69s, concurrency:5, task:12, construct:130.5ms, fetch:2.24s, build:25.5ms, join:318.8ms}	inner join, inner:IndexLookUp_64, outer key:tpch50.part.p_partkey, inner key:tpch50.partsupp.ps_partkey, equal cond:eq(tpch50.part.p_partkey, tpch50.partsupp.ps_partkey)	19.9 MB	N/A
20:42:09 [2021-06-01T20:42:09.072Z]           │ ├─TableReader_96(Build)	80007.93	108882	root		time:2.22s, loops:112, cop_task: {num: 20, max: 1.46s, min: 415.5ms, avg: 1.08s, p95: 1.46s, max_proc_keys: 686055, p95_proc_keys: 686055, tot_proc: 21.6s, tot_wait: 5ms, rpc_num: 20, rpc_time: 21.7s, copr_cache: disabled}	data:Selection_95	680.6 KB	N/A
20:42:09 [2021-06-01T20:42:09.072Z]           │ │ └─Selection_95	80007.93	108882	cop[tikv]		tikv_task:{proc max:1.43s, min:413ms, p80:1.33s, p95:1.43s, iters:9859, tasks:20}, scan_detail: {total_process_keys: 10000000, total_keys: 10000020, rocksdb: {delete_skipped_count: 0, key_skipped_count: 19999980, block: {cache_hit_count: 31499, read_count: 0, read_byte: 0 Bytes}}}	like(tpch50.part.p_name, "green%", 92)	N/A	N/A
20:42:09 [2021-06-01T20:42:09.072Z]           │ │   └─TableFullScan_94	10000000.00	10000000	cop[tikv]	table:part	tikv_task:{proc max:1.33s, min:381ms, p80:1.25s, p95:1.33s, iters:9859, tasks:20}	keep order:false	N/A	N/A
20:42:09 [2021-06-01T20:42:09.072Z]           │ └─IndexLookUp_64(Probe)	4.02	435528	root		time:2.15s, loops:447, index_task: {total_time: 1.18s, fetch_handle: 1.18s, build: 95.5µs, wait: 276.6µs}, table_task: {total_time: 7.97s, num: 57, concurrency: 60}		20.5 KB	N/A
20:42:09 [2021-06-01T20:42:09.072Z]           │   ├─IndexRangeScan_62(Build)	4.02	435528	cop[tikv]	table:partsupp, index:PRIMARY(PS_PARTKEY, PS_SUPPKEY)	time:1.14s, loops:479, cop_task: {num: 59, max: 190.8ms, min: 4.58ms, avg: 86.5ms, p95: 171.4ms, max_proc_keys: 15288, p95_proc_keys: 14960, tot_proc: 4.58s, tot_wait: 60ms, rpc_num: 59, rpc_time: 5.1s, copr_cache: disabled}, tikv_task:{proc max:185ms, min:3ms, p80:130ms, p95:160ms, iters:694, 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:42:09 [2021-06-01T20:42:09.072Z]           │   └─TableRowIDScan_63(Probe)	4.02	435528	cop[tikv]	table:partsupp	time:2.74s, loops:506, cop_task: {num: 1485, max: 79.8ms, min: 438.5µs, avg: 17.2ms, p95: 37.5ms, max_proc_keys: 976, p95_proc_keys: 524, tot_proc: 19s, tot_wait: 4.44s, rpc_num: 1485, rpc_time: 25.5s, copr_cache: disabled}, tikv_task:{proc max:40ms, min:0s, p80:16ms, p95:21ms, iters:5440, tasks:1485}, scan_detail: {total_process_keys: 435528, total_keys: 473503, rocksdb: {delete_skipped_count: 0, key_skipped_count: 194047, block: {cache_hit_count: 3644451, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:42:09 [2021-06-01T20:42:09.072Z]           └─TableReader_101(Probe)	46310896.67	45504356	root		time:34.4s, loops:44289, cop_task: {num: 761, max: 1.09s, min: 241.4ms, avg: 723.9ms, p95: 867.6ms, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 9m7.8s, tot_wait: 143ms, rpc_num: 761, rpc_time: 9m10.8s, copr_cache: disabled}	data:Selection_100	52.6 MB	N/A
20:42:09 [2021-06-01T20:42:09.072Z]             └─Selection_100	46310896.67	45504356	cop[tikv]		tikv_task:{proc max:1.06s, min:227ms, p80:771ms, p95:845ms, 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:42:09 [2021-06-01T20:42:09.072Z]               └─TableFullScan_99	300005811.00	300005811	cop[tikv]	table:lineitem	tikv_task:{proc max:1.01s, min:218ms, p80:740ms, p95:817ms, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:42:09 [2021-06-01T20:42:09.072Z] 
20:42:09 [2021-06-01T20:42:09.072Z] queries/20.sql
20:42:09 [2021-06-01T20:42:09.072Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:42:09 [2021-06-01T20:42:09.072Z] Sort_30	20000.00	8982	root		time:39.1s, loops:10	tpch50.supplier.s_name	610.3 KB	0 Bytes
20:42:09 [2021-06-01T20:42:09.072Z] └─HashJoin_35	20000.00	8982	root		time:39.1s, loops:11, build_hash_table:{total:1.3s, fetch:1.29s, build:9.67ms}, probe:{concurrency:5, total:3m15.4s, max:39.1s, probe:46.2ms, fetch:3m15.4s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.partsupp.ps_suppkey)]	1.54 MB	0 Bytes
20:42:09 [2021-06-01T20:42:09.072Z]   ├─HashJoin_48(Build)	20000.00	19972	root		time:1.3s, loops:24, build_hash_table:{total:10.2ms, fetch:10.2ms, build:7.54µs}, probe:{concurrency:5, total:6.51s, max:1.3s, probe:114.8ms, fetch:6.4s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:42:09 [2021-06-01T20:42:09.072Z]   │ ├─TableReader_53(Build)	1.00	1	root		time:10.1ms, loops:2, cop_task: {num: 1, max: 12.7ms, proc_keys: 25, tot_proc: 1ms, rpc_num: 1, rpc_time: 12.7ms, copr_cache: disabled}	data:Selection_52	244 Bytes	N/A
20:42:09 [2021-06-01T20:42:09.072Z]   │ │ └─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:42:09 [2021-06-01T20:42:09.072Z]   │ │   └─TableFullScan_51	25.00	25	cop[tikv]	table:nation	tikv_task:{time:1ms, loops:1}	keep order:false	N/A	N/A
20:42:09 [2021-06-01T20:42:09.072Z]   │ └─TableReader_50(Probe)	500000.00	500000	root		time:1.28s, loops:490, cop_task: {num: 1, max: 1.28s, proc_keys: 500000, tot_proc: 1.22s, rpc_num: 1, rpc_time: 1.28s, copr_cache: disabled}	data:TableFullScan_49	35.8 MB	N/A
20:42:09 [2021-06-01T20:42:09.072Z]   │   └─TableFullScan_49	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:1.07s, 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:42:09 [2021-06-01T20:42:09.072Z]   └─HashAgg_54(Probe)	257492.04	223999	root		time:39.1s, loops:222, partial_worker:{wall_time:39.014312053s, concurrency:5, task_num:289, tot_wait:3m14.788919856s, tot_exec:238.064129ms, tot_time:3m15.065629826s, max:39.014278786s, p95:39.014278786s}, final_worker:{wall_time:39.087847359s, concurrency:5, task_num:25, tot_wait:3m15.059716702s, tot_exec:372.477446ms, tot_time:3m15.432208919s, max:39.087825585s, p95:39.087825585s}	group by:tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_suppkey)->tpch50.partsupp.ps_suppkey	61.4 MB	N/A
20:42:09 [2021-06-01T20:42:09.072Z]     └─Selection_55	257492.04	295898	root		time:39s, loops:290	gt(cast(tpch50.partsupp.ps_availqty, decimal(20,0) BINARY), mul(0.5, Column#44))	59.2 KB	N/A
20:42:09 [2021-06-01T20:42:09.072Z]       └─HashAgg_56	321865.05	435528	root		time:38.9s, loops:430, partial_worker:{wall_time:38.649550329s, concurrency:5, task_num:625, tot_wait:3m12.026080189s, tot_exec:1.081462482s, tot_time:3m13.224498643s, max:38.649517878s, p95:38.649517878s}, final_worker:{wall_time:39.004279954s, concurrency:5, task_num:25, tot_wait:3m13.202182437s, tot_exec:1.696233892s, tot_time:3m14.898435004s, max:39.004263614s, p95:39.004263614s}	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:42:09 [2021-06-01T20:42:09.072Z]         └─HashJoin_59	9711455.06	634004	root		time:38.5s, loops:626, build_hash_table:{total:2.49s, fetch:2.31s, build:182.3ms}, probe:{concurrency:5, total:3m12.7s, max:38.5s, probe:13.8s, fetch:2m59s}	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:42:09 [2021-06-01T20:42:09.072Z]           ├─IndexHashJoin_67(Build)	321865.05	435528	root		time:2.47s, loops:429, inner:{total:2.57s, concurrency:5, task:12, construct:125.3ms, fetch:2.13s, build:34.1ms, join:315ms}	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:42:09 [2021-06-01T20:42:09.072Z]           │ ├─TableReader_96(Build)	80007.93	108882	root		time:2.11s, loops:112, cop_task: {num: 20, max: 1.41s, min: 659.7ms, avg: 1.06s, p95: 1.41s, max_proc_keys: 686055, p95_proc_keys: 686055, tot_proc: 21.2s, tot_wait: 7ms, rpc_num: 20, rpc_time: 21.2s, copr_cache: disabled}	data:Selection_95	725.8 KB	N/A
20:42:09 [2021-06-01T20:42:09.072Z]           │ │ └─Selection_95	80007.93	108882	cop[tikv]		tikv_task:{proc max:1.39s, min:651ms, p80:1.23s, p95:1.39s, 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:42:09 [2021-06-01T20:42:09.072Z]           │ │   └─TableFullScan_94	10000000.00	10000000	cop[tikv]	table:part	tikv_task:{proc max:1.32s, min:621ms, p80:1.14s, p95:1.32s, iters:9859, tasks:20}	keep order:false	N/A	N/A
20:42:09 [2021-06-01T20:42:09.072Z]           │ └─IndexLookUp_64(Probe)	4.02	435528	root		time:2.03s, loops:447, index_task: {total_time: 1.21s, fetch_handle: 1.21s, build: 89.7µs, wait: 262.2µs}, table_task: {total_time: 7.87s, num: 56, concurrency: 60}		20.5 KB	N/A
20:42:09 [2021-06-01T20:42:09.072Z]           │   ├─IndexRangeScan_62(Build)	4.02	435528	cop[tikv]	table:partsupp, index:PRIMARY(PS_PARTKEY, PS_SUPPKEY)	time:1.17s, loops:475, cop_task: {num: 58, max: 219.1ms, min: 5.17ms, avg: 88.3ms, p95: 185.6ms, max_proc_keys: 15288, p95_proc_keys: 15008, tot_proc: 4.67s, tot_wait: 140ms, rpc_num: 58, rpc_time: 5.12s, copr_cache: disabled}, tikv_task:{proc max:196ms, min:4ms, p80:134ms, p95:173ms, 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:42:09 [2021-06-01T20:42:09.072Z]           │   └─TableRowIDScan_63(Probe)	4.02	435528	cop[tikv]	table:partsupp	time:2.46s, loops:502, cop_task: {num: 1404, max: 64.1ms, min: 361.6µs, avg: 17.3ms, p95: 36.4ms, max_proc_keys: 976, p95_proc_keys: 604, tot_proc: 18.4s, tot_wait: 3.98s, rpc_num: 1404, rpc_time: 24.3s, copr_cache: disabled}, tikv_task:{proc max:43ms, min:0s, p80:17ms, p95:25ms, iters:5223, tasks:1404}, scan_detail: {total_process_keys: 435528, total_keys: 473507, rocksdb: {delete_skipped_count: 0, key_skipped_count: 194059, block: {cache_hit_count: 3643947, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:42:09 [2021-06-01T20:42:09.072Z]           └─TableReader_101(Probe)	46310896.67	45504356	root		time:34s, loops:44289, cop_task: {num: 761, max: 1.14s, min: 229.7ms, avg: 716.6ms, p95: 873.3ms, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 9m2.2s, tot_wait: 119ms, rpc_num: 761, rpc_time: 9m5.3s, copr_cache: disabled}	data:Selection_100	52.6 MB	N/A
20:42:09 [2021-06-01T20:42:09.072Z]             └─Selection_100	46310896.67	45504356	cop[tikv]		tikv_task:{proc max:1.11s, min:221ms, p80:758ms, p95:845ms, 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:42:09 [2021-06-01T20:42:09.072Z]               └─TableFullScan_99	300005811.00	300005811	cop[tikv]	table:lineitem	tikv_task:{proc max:1.05s, min:207ms, p80:730ms, p95:817ms, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:42:09 [2021-06-01T20:42:09.072Z] + sync
20:42:09 [2021-06-01T20:42:09.072Z] + /usr/bin/echo 3
20:42:51 [2021-06-01T20:42:51.254Z] + tiup cluster stop benchbot -y
20:42:51 [2021-06-01T20:42:51.510Z] Starting component `cluster`: /home/tidb/.tiup/components/cluster/v1.4.4/tiup-cluster stop benchbot -y
20:43:04 [2021-06-01T20:43:04.753Z] + rm -rf '/data1/tidb-deploy/*/log/*'
20:43:04 [2021-06-01T20:43:04.753Z] + rm -rf /data1/jenkins/deploy/data/tikv-20160
20:43:08 [2021-06-01T20:43:08.019Z] + rm -rf /data1/jenkins/deploy/data/pd-2379
20:43:08 [2021-06-01T20:43:08.019Z] + rm -rf /data1/jenkins/restore_data/tpch50/data/last_tikv.toml
20:43:08 [2021-06-01T20:43:08.019Z] + cp -R /data1/jenkins/restore_data/tpch50/data /data1/jenkins/deploy/data/tikv-20160
20:44:59 [2021-06-01T20:44:59.639Z] + cp -R /data1/jenkins/restore_data/tpch50/data.pd /data1/jenkins/deploy/data/pd-2379
20:44:59 [2021-06-01T20:44:59.639Z] + '[' -n '' ']'
20:44:59 [2021-06-01T20:44:59.639Z] + tiup cluster start benchbot --wait-timeout=300
20:44:59 [2021-06-01T20:44:59.639Z] Starting component `cluster`: /home/tidb/.tiup/components/cluster/v1.4.4/tiup-cluster start benchbot --wait-timeout=300
20:45:20 [2021-06-01T20:45:20.430Z] + sync
20:45:20 [2021-06-01T20:45:20.430Z] + /usr/bin/echo 3
20:46:56 [2021-06-01T20:46:56.591Z] 
20:46:56 [2021-06-01T20:46:56.591Z] queries/20.sql
20:46:56 [2021-06-01T20:46:56.591Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:46:56 [2021-06-01T20:46:56.591Z] Sort_30	20000.00	8982	root		time:38.5s, loops:10	tpch50.supplier.s_name	614.3 KB	0 Bytes
20:46:56 [2021-06-01T20:46:56.591Z] └─HashJoin_35	20000.00	8982	root		time:38.5s, loops:11, build_hash_table:{total:1.34s, fetch:1.33s, build:10.3ms}, probe:{concurrency:5, total:3m12.4s, max:38.5s, probe:45.5ms, fetch:3m12.4s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.partsupp.ps_suppkey)]	1.54 MB	0 Bytes
20:46:56 [2021-06-01T20:46:56.591Z]   ├─HashJoin_48(Build)	20000.00	19972	root		time:1.33s, loops:24, build_hash_table:{total:4.38ms, fetch:4.38ms, build:5.2µs}, probe:{concurrency:5, total:6.67s, max:1.34s, probe:114.6ms, fetch:6.56s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:46:56 [2021-06-01T20:46:56.591Z]   │ ├─TableReader_53(Build)	1.00	1	root		time:4.27ms, loops:2, cop_task: {num: 1, max: 7.2ms, proc_keys: 25, rpc_num: 1, rpc_time: 7.16ms, copr_cache: disabled}	data:Selection_52	236 Bytes	N/A
20:46:56 [2021-06-01T20:46:56.591Z]   │ │ └─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:46:56 [2021-06-01T20:46:56.591Z]   │ │   └─TableFullScan_51	25.00	25	cop[tikv]	table:nation	tikv_task:{time:0s, loops:1}	keep order:false	N/A	N/A
20:46:56 [2021-06-01T20:46:56.591Z]   │ └─TableReader_50(Probe)	500000.00	500000	root		time:1.31s, loops:490, cop_task: {num: 1, max: 1.31s, proc_keys: 500000, tot_proc: 1.23s, rpc_num: 1, rpc_time: 1.31s, copr_cache: disabled}	data:TableFullScan_49	35.8 MB	N/A
20:46:56 [2021-06-01T20:46:56.591Z]   │   └─TableFullScan_49	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:1.09s, 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:46:56 [2021-06-01T20:46:56.591Z]   └─HashAgg_54(Probe)	257492.04	223999	root		time:38.5s, loops:222, partial_worker:{wall_time:38.419318588s, concurrency:5, task_num:289, tot_wait:3m11.851474722s, tot_exec:203.221866ms, tot_time:3m12.088900083s, max:38.419276522s, p95:38.419276522s}, final_worker:{wall_time:38.482792386s, concurrency:5, task_num:25, tot_wait:3m12.083703994s, tot_exec:318.852685ms, tot_time:3m12.402569481s, max:38.482759012s, p95:38.482759012s}	group by:tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_suppkey)->tpch50.partsupp.ps_suppkey	61.4 MB	N/A
20:46:56 [2021-06-01T20:46:56.591Z]     └─Selection_55	257492.04	295898	root		time:38.4s, loops:290	gt(cast(tpch50.partsupp.ps_availqty, decimal(20,0) BINARY), mul(0.5, Column#44))	59.2 KB	N/A
20:46:56 [2021-06-01T20:46:56.592Z]       └─HashAgg_56	321865.05	435528	root		time:38.3s, loops:430, partial_worker:{wall_time:38.072837461s, concurrency:5, task_num:624, tot_wait:3m9.098161804s, tot_exec:1.121559938s, tot_time:3m10.335196061s, max:38.072780782s, p95:38.072780782s}, final_worker:{wall_time:38.409225968s, concurrency:5, task_num:25, tot_wait:3m10.322934414s, tot_exec:1.672789138s, tot_time:3m11.995740787s, max:38.409183702s, p95:38.409183702s}	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:46:56 [2021-06-01T20:46:56.592Z]         └─HashJoin_59	9711455.06	634004	root		time:38s, loops:625, build_hash_table:{total:2.49s, fetch:2.28s, build:210.2ms}, probe:{concurrency:5, total:3m9.8s, max:38s, probe:13.7s, fetch:2m56.1s}	left outer join, equal:[eq(tpch50.partsupp.ps_partkey, tpch50.lineitem.l_partkey) eq(tpch50.partsupp.ps_suppkey, tpch50.lineitem.l_suppkey)]	10.4 MB	0 Bytes
20:46:56 [2021-06-01T20:46:56.592Z]           ├─IndexHashJoin_67(Build)	321865.05	435528	root		time:2.43s, loops:430, inner:{total:2.57s, concurrency:5, task:12, construct:117.5ms, fetch:2.11s, build:25.4ms, join:345.9ms}	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:46:56 [2021-06-01T20:46:56.592Z]           │ ├─TableReader_96(Build)	80007.93	108882	root		time:2.1s, loops:112, cop_task: {num: 20, max: 1.61s, min: 663.1ms, avg: 1.13s, p95: 1.61s, max_proc_keys: 686055, p95_proc_keys: 686055, tot_proc: 22.5s, tot_wait: 11ms, rpc_num: 20, rpc_time: 22.6s, copr_cache: disabled}	data:Selection_95	725.8 KB	N/A
20:46:56 [2021-06-01T20:46:56.592Z]           │ │ └─Selection_95	80007.93	108882	cop[tikv]		tikv_task:{proc max:1.59s, min:658ms, p80:1.35s, p95:1.59s, 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:46:56 [2021-06-01T20:46:56.592Z]           │ │   └─TableFullScan_94	10000000.00	10000000	cop[tikv]	table:part	tikv_task:{proc max:1.5s, min:612ms, p80:1.26s, p95:1.5s, iters:9859, tasks:20}	keep order:false	N/A	N/A
20:46:56 [2021-06-01T20:46:56.592Z]           │ └─IndexLookUp_64(Probe)	4.02	435528	root		time:2.02s, loops:447, index_task: {total_time: 1.2s, fetch_handle: 1.2s, build: 88.8µs, wait: 232.2µs}, table_task: {total_time: 8.12s, num: 56, concurrency: 60}		20.5 KB	N/A
20:46:56 [2021-06-01T20:46:56.592Z]           │   ├─IndexRangeScan_62(Build)	4.02	435528	cop[tikv]	table:partsupp, index:PRIMARY(PS_PARTKEY, PS_SUPPKEY)	time:1.16s, loops:484, cop_task: {num: 59, max: 255.3ms, min: 5.48ms, avg: 89ms, p95: 165.4ms, max_proc_keys: 15288, p95_proc_keys: 15008, tot_proc: 4.78s, tot_wait: 16ms, rpc_num: 59, rpc_time: 5.25s, copr_cache: disabled}, tikv_task:{proc max:248ms, min:4ms, p80:140ms, p95:154ms, iters:693, tasks:59}, scan_detail: {total_process_keys: 435528, total_keys: 544410, rocksdb: {delete_skipped_count: 0, key_skipped_count: 435528, block: {cache_hit_count: 980292, read_count: 0, read_byte: 0 Bytes}}}	range: decided by [eq(tpch50.partsupp.ps_partkey, tpch50.part.p_partkey)], keep order:false	N/A	N/A
20:46:56 [2021-06-01T20:46:56.592Z]           │   └─TableRowIDScan_63(Probe)	4.02	435528	cop[tikv]	table:partsupp	time:2.59s, loops:508, cop_task: {num: 1433, max: 62ms, min: 368.4µs, avg: 19.1ms, p95: 37.9ms, max_proc_keys: 1020, p95_proc_keys: 604, tot_proc: 19.9s, tot_wait: 5.71s, rpc_num: 1433, rpc_time: 27.4s, copr_cache: disabled}, tikv_task:{proc max:45ms, min:0s, p80:17ms, p95:25ms, iters:5307, tasks:1433}, scan_detail: {total_process_keys: 435528, total_keys: 473516, rocksdb: {delete_skipped_count: 0, key_skipped_count: 194090, block: {cache_hit_count: 3644129, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:46:56 [2021-06-01T20:46:56.592Z]           └─TableReader_101(Probe)	46310896.67	45504356	root		time:33.5s, loops:44291, cop_task: {num: 761, max: 1.05s, min: 327.1ms, avg: 706.6ms, p95: 865.1ms, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 8m54.6s, tot_wait: 113ms, rpc_num: 761, rpc_time: 8m57.7s, copr_cache: disabled}	data:Selection_100	52.6 MB	N/A
20:46:56 [2021-06-01T20:46:56.592Z]             └─Selection_100	46310896.67	45504356	cop[tikv]		tikv_task:{proc max:1.03s, min:318ms, p80:749ms, p95:844ms, 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:46:56 [2021-06-01T20:46:56.592Z]               └─TableFullScan_99	300005811.00	300005811	cop[tikv]	table:lineitem	tikv_task:{proc max:991ms, min:306ms, p80:716ms, p95:814ms, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:46:56 [2021-06-01T20:46:56.592Z] 
20:46:56 [2021-06-01T20:46:56.592Z] queries/21.sql
20:46:56 [2021-06-01T20:46:56.592Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:46:56 [2021-06-01T20:46:56.592Z] Projection_26	100.00	100	root		time:1m20.6s, loops:2, Concurrency:OFF	tpch50.supplier.s_name, Column#72	4.62 KB	N/A
20:46:56 [2021-06-01T20:46:56.592Z] └─TopN_29	100.00	100	root		time:1m20.6s, loops:2	Column#72:desc, tpch50.supplier.s_name, offset:0, count:100	58.4 KB	N/A
20:46:56 [2021-06-01T20:46:56.592Z]   └─HashAgg_34	12800.00	20057	root		time:1m20.6s, loops:21, partial_worker:{wall_time:1m20.567676702s, concurrency:5, task_num:197, tot_wait:6m42.560446946s, tot_exec:264.142937ms, tot_time:6m42.837252682s, max:1m20.567651286s, p95:1m20.567651286s}, final_worker:{wall_time:1m20.580436976s, concurrency:5, task_num:25, tot_wait:6m42.835588368s, tot_exec:65.493901ms, tot_time:6m42.901093331s, max:1m20.580423169s, p95:1m20.580423169s}	group by:tpch50.supplier.s_name, funcs:count(1)->Column#72, funcs:firstrow(tpch50.supplier.s_name)->tpch50.supplier.s_name	17.2 MB	N/A
20:46:56 [2021-06-01T20:46:56.592Z]     └─IndexHashJoin_42	7828961.66	198698	root		time:1m20.6s, loops:198, inner:{total:2m15s, concurrency:5, task:146, construct:6.67s, fetch:1m52s, build:1.18s, join:16.3s}	anti semi join, inner:IndexLookUp_39, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey)	641.1 MB	N/A
20:46:56 [2021-06-01T20:46:56.592Z]       ├─IndexHashJoin_83(Build)	9786202.08	3542799	root		time:1m20.1s, loops:3463, inner:{total:2m25s, concurrency:5, task:152, construct:7.7s, fetch:1m59.3s, build:1.21s, join:17.9s}	semi join, inner:IndexLookUp_80, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey), ne(tpch50.lineitem.l_suppkey, tpch50.supplier.s_suppkey)	555.9 MB	N/A
20:46:56 [2021-06-01T20:46:56.592Z]       │ ├─IndexJoin_99(Build)	12232752.60	3675878	root		time:1m19.5s, loops:3595, inner:{total:2m5.4s, concurrency:5, task:305, construct:16.3s, fetch:1m47.2s, build:1.91s}, probe:5.1s	inner join, inner:TableReader_95, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.orders.o_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.orders.o_orderkey)	575.4 MB	N/A
20:46:56 [2021-06-01T20:46:56.592Z]       │ │ ├─HashJoin_107(Build)	12232752.60	7609895	root		time:1m18.9s, loops:7435, build_hash_table:{total:829.6ms, fetch:821.3ms, build:8.27ms}, probe:{concurrency:5, total:6m36.6s, max:1m19.3s, probe:1m0.1s, fetch:5m36.6s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.lineitem.l_suppkey)]	737.6 KB	0 Bytes
20:46:56 [2021-06-01T20:46:56.592Z]       │ │ │ ├─HashJoin_120(Build)	20000.00	20058	root		time:825.5ms, loops:22, build_hash_table:{total:352.6µs, fetch:146.3µs, build:206.3µs}, probe:{concurrency:5, total:4.13s, max:827.1ms, probe:88.5ms, fetch:4.05s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:46:56 [2021-06-01T20:46:56.592Z]       │ │ │ │ ├─TableReader_125(Build)	1.00	1	root		time:40.3µs, loops:2, cop_task: {num: 1, max: 948.4µs, proc_keys: 25, tot_proc: 1ms, rpc_num: 1, rpc_time: 936.5µs, copr_cache: disabled}	data:Selection_124	242 Bytes	N/A
20:46:56 [2021-06-01T20:46:56.592Z]       │ │ │ │ │ └─Selection_124	1.00	1	cop[tikv]		tikv_task:{time:1ms, loops:1}, scan_detail: {total_process_keys: 25, total_keys: 26, rocksdb: {delete_skipped_count: 0, key_skipped_count: 46, block: {cache_hit_count: 18, read_count: 0, read_byte: 0 Bytes}}}	eq(tpch50.nation.n_name, "EGYPT")	N/A	N/A
20:46:56 [2021-06-01T20:46:56.592Z]       │ │ │ │ │   └─TableFullScan_123	25.00	25	cop[tikv]	table:nation	tikv_task:{time:1ms, loops:1}	keep order:false	N/A	N/A
20:46:56 [2021-06-01T20:46:56.592Z]       │ │ │ │ └─TableReader_122(Probe)	500000.00	500000	root		time:809ms, loops:490, cop_task: {num: 1, max: 921.5ms, proc_keys: 500000, tot_proc: 885ms, rpc_num: 1, rpc_time: 921.4ms, copr_cache: disabled}	data:TableFullScan_121	20.0 MB	N/A
20:46:56 [2021-06-01T20:46:56.592Z]       │ │ │ │   └─TableFullScan_121	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:827ms, 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:46:56 [2021-06-01T20:46:56.592Z]       │ │ │ └─TableReader_128(Probe)	240004648.80	189670348	root		time:1m7.1s, loops:184597, cop_task: {num: 761, max: 2.59s, min: 273.9ms, avg: 1.53s, p95: 1.94s, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 18m10.8s, tot_wait: 57.7s, rpc_num: 761, rpc_time: 19m21.6s, copr_cache: disabled}	data:Selection_127	83.9 MB	N/A
20:46:56 [2021-06-01T20:46:56.592Z]       │ │ │   └─Selection_127	240004648.80	189670348	cop[tikv]		tikv_task:{proc max:1.37s, min:264ms, p80:1.2s, p95:1.26s, 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: 18671, read_count: 1131793, read_byte: 23.9 GB}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:46:56 [2021-06-01T20:46:56.592Z]       │ │ │     └─TableFullScan_126	300005811.00	300005811	cop[tikv]	table:l1	tikv_task:{proc max:1.3s, min:247ms, p80:1.12s, p95:1.18s, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:46:56 [2021-06-01T20:46:56.592Z]       │ │ └─TableReader_95(Probe)	0.49	3496178	root		time:1m38.1s, loops:3875, cop_task: {num: 5263, max: 540.1ms, min: 596.9µs, avg: 175.8ms, p95: 329.8ms, max_proc_keys: 3846, p95_proc_keys: 1948, tot_proc: 11m3.7s, tot_wait: 3m40.8s, rpc_num: 5263, rpc_time: 15m24.9s, copr_cache: disabled}	data:Selection_94	N/A	N/A
20:46:56 [2021-06-01T20:46:56.592Z]       │ │   └─Selection_94	0.49	3496178	cop[tikv]		tikv_task:{proc max:142ms, min:0s, p80:69ms, p95:82ms, iters:30195, tasks:5263}, scan_detail: {total_process_keys: 7236287, total_keys: 7795495, rocksdb: {delete_skipped_count: 0, key_skipped_count: 1778304, block: {cache_hit_count: 54006811, read_count: 220249, read_byte: 4.88 GB}}}	eq(tpch50.orders.o_orderstatus, "F")	N/A	N/A
20:46:56 [2021-06-01T20:46:56.592Z]       │ │     └─TableRangeScan_93	1.00	7236287	cop[tikv]	table:orders	tikv_task:{proc max:142ms, min:0s, p80:69ms, p95:81ms, iters:30195, tasks:5263}	range: decided by [tpch50.lineitem.l_orderkey], keep order:false	N/A	N/A
20:46:56 [2021-06-01T20:46:56.592Z]       │ └─IndexLookUp_80(Probe)	4.05	17316462	root		time:1m54s, loops:17133, index_task: {total_time: 1m2.1s, fetch_handle: 53.6s, build: 3.65ms, wait: 8.49s}, table_task: {total_time: 8m11.1s, num: 1458, concurrency: 760}		19.2 KB	N/A
20:46:56 [2021-06-01T20:46:56.592Z]       │   ├─IndexRangeScan_78(Build)	4.05	17316462	cop[tikv]	table:l2, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:51.3s, loops:18633, cop_task: {num: 3016, max: 743.8ms, min: 795.8µs, avg: 177.1ms, p95: 354.8ms, max_proc_keys: 12941, p95_proc_keys: 8734, tot_proc: 6m43.5s, tot_wait: 1m48s, rpc_num: 3016, rpc_time: 8m54.2s, copr_cache: disabled}, tikv_task:{proc max:186ms, min:0s, p80:96ms, p95:112ms, iters:30179, tasks:3016}, scan_detail: {total_process_keys: 17316462, total_keys: 20812568, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17316462, block: {cache_hit_count: 24260197, read_count: 226881, read_byte: 2.39 GB}}}	range: decided by [eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey)], keep order:false	N/A	N/A
20:46:56 [2021-06-01T20:46:56.592Z]       │   └─TableRowIDScan_79(Probe)	4.05	17316462	cop[tikv]	table:l2	time:6m2.6s, loops:20993, cop_task: {num: 7799, max: 678.9ms, min: 457.2µs, avg: 169ms, p95: 349.3ms, max_proc_keys: 10057, p95_proc_keys: 4867, tot_proc: 15m52.3s, tot_wait: 5m17.1s, rpc_num: 7799, rpc_time: 21m57.9s, copr_cache: disabled}, tikv_task:{proc max:302ms, min:0s, p80:104ms, p95:140ms, iters:49873, tasks:7799}, scan_detail: {total_process_keys: 17316462, total_keys: 18288217, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5623141, block: {cache_hit_count: 99025437, read_count: 5, read_byte: 36.7 KB}}}	keep order:false	N/A	N/A
20:46:56 [2021-06-01T20:46:56.592Z]       └─IndexLookUp_39(Probe)	4.05	12022800	root		time:1m47.2s, loops:11944, index_task: {total_time: 58.5s, fetch_handle: 49.8s, build: 3.33ms, wait: 8.7s}, table_task: {total_time: 7m45.4s, num: 1408, concurrency: 730}		213.6 KB	N/A
20:46:56 [2021-06-01T20:46:56.592Z]         ├─IndexRangeScan_36(Build)	5.06	17183375	cop[tikv]	table:l3, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:47.5s, loops:18360, cop_task: {num: 2803, max: 831.7ms, min: 467.2µs, avg: 164.2ms, p95: 352.9ms, max_proc_keys: 18699, p95_proc_keys: 13445, tot_proc: 5m45.1s, tot_wait: 1m35.3s, rpc_num: 2803, rpc_time: 7m40.1s, copr_cache: disabled}, tikv_task:{proc max:182ms, min:0s, p80:76ms, p95:117ms, iters:29139, tasks:2803}, scan_detail: {total_process_keys: 17183375, total_keys: 20546401, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17183375, block: {cache_hit_count: 23553989, read_count: 0, read_byte: 0 Bytes}}}	range: decided by [eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey)], keep order:false	N/A	N/A
20:46:56 [2021-06-01T20:46:56.593Z]         └─Selection_38(Probe)	4.05	12022800	cop[tikv]		time:5m52.5s, loops:13786, cop_task: {num: 10209, max: 625.9ms, min: 430.6µs, avg: 165.4ms, p95: 333.7ms, max_proc_keys: 7926, p95_proc_keys: 4003, tot_proc: 19m43.9s, tot_wait: 7m21.3s, rpc_num: 10209, rpc_time: 28m8.6s, copr_cache: disabled}, tikv_task:{proc max:240ms, min:0s, p80:75ms, p95:114ms, iters:60549, tasks:10209}, scan_detail: {total_process_keys: 17183375, total_keys: 18128722, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5526421, block: {cache_hit_count: 98286083, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:46:56 [2021-06-01T20:46:56.593Z]           └─TableRowIDScan_37	5.06	17183375	cop[tikv]	table:l3	tikv_task:{proc max:240ms, min:0s, p80:74ms, p95:114ms, iters:60549, tasks:10209}	keep order:false	N/A	N/A
20:46:56 [2021-06-01T20:46:56.593Z] + sync
20:46:56 [2021-06-01T20:46:56.593Z] + /usr/bin/echo 3
20:48:13 [2021-06-01T20:48:13.980Z] 
20:48:13 [2021-06-01T20:48:13.980Z] queries/21.sql
20:48:13 [2021-06-01T20:48:13.980Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:48:13 [2021-06-01T20:48:13.980Z] Projection_26	100.00	100	root		time:1m18.9s, loops:2, Concurrency:OFF	tpch50.supplier.s_name, Column#72	4.62 KB	N/A
20:48:13 [2021-06-01T20:48:13.980Z] └─TopN_29	100.00	100	root		time:1m18.9s, loops:2	Column#72:desc, tpch50.supplier.s_name, offset:0, count:100	58.4 KB	N/A
20:48:13 [2021-06-01T20:48:13.980Z]   └─HashAgg_34	12800.00	20057	root		time:1m18.9s, loops:21, partial_worker:{wall_time:1m18.884039991s, concurrency:5, task_num:198, tot_wait:6m34.166187007s, tot_exec:241.039502ms, tot_time:6m34.41892599s, max:1m18.883998786s, p95:1m18.883998786s}, final_worker:{wall_time:1m18.896004075s, concurrency:5, task_num:25, tot_wait:6m34.417779946s, tot_exec:61.416456ms, tot_time:6m34.47921017s, max:1m18.89598541s, p95:1m18.89598541s}	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:13 [2021-06-01T20:48:13.980Z]     └─IndexHashJoin_42	7828961.66	198698	root		time:1m18.9s, loops:199, inner:{total:2m16.2s, concurrency:5, task:147, construct:6.65s, fetch:1m53s, build:1.2s, join:16.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:48:13 [2021-06-01T20:48:13.980Z]       ├─IndexHashJoin_83(Build)	9786202.08	3542799	root		time:1m18.4s, loops:3464, inner:{total:2m24.5s, concurrency:5, task:152, construct:7.98s, fetch:1m58.6s, build:1.25s, join:17.9s}	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:13 [2021-06-01T20:48:13.980Z]       │ ├─IndexJoin_99(Build)	12232752.60	3675878	root		time:1m17.8s, loops:3595, inner:{total:2m2.4s, concurrency:5, task:305, construct:16.6s, fetch:1m43.9s, build:1.85s}, probe:5.25s	inner join, inner:TableReader_95, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.orders.o_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.orders.o_orderkey)	575.4 MB	N/A
20:48:13 [2021-06-01T20:48:13.980Z]       │ │ ├─HashJoin_107(Build)	12232752.60	7609895	root		time:1m17.3s, loops:7436, build_hash_table:{total:1.07s, fetch:1.07s, build:6.02ms}, probe:{concurrency:5, total:6m28.2s, max:1m17.6s, probe:1m1.3s, fetch:5m26.9s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.lineitem.l_suppkey)]	737.6 KB	0 Bytes
20:48:13 [2021-06-01T20:48:13.980Z]       │ │ │ ├─HashJoin_120(Build)	20000.00	20058	root		time:1.07s, loops:22, build_hash_table:{total:180.2µs, fetch:172.7µs, build:7.47µs}, probe:{concurrency:5, total:5.35s, max:1.07s, probe:58.6ms, fetch:5.29s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:48:13 [2021-06-01T20:48:13.980Z]       │ │ │ │ ├─TableReader_125(Build)	1.00	1	root		time:60.8µs, loops:2, cop_task: {num: 1, max: 1.35ms, proc_keys: 25, tot_proc: 1ms, rpc_num: 1, rpc_time: 1.32ms, copr_cache: disabled}	data:Selection_124	248 Bytes	N/A
20:48:13 [2021-06-01T20:48:13.980Z]       │ │ │ │ │ └─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:13 [2021-06-01T20:48:13.980Z]       │ │ │ │ │   └─TableFullScan_123	25.00	25	cop[tikv]	table:nation	tikv_task:{time:1ms, loops:1}	keep order:false	N/A	N/A
20:48:13 [2021-06-01T20:48:13.980Z]       │ │ │ │ └─TableReader_122(Probe)	500000.00	500000	root		time:1.06s, loops:490, cop_task: {num: 1, max: 1.06s, proc_keys: 500000, tot_proc: 1.03s, rpc_num: 1, rpc_time: 1.06s, copr_cache: disabled}	data:TableFullScan_121	20.0 MB	N/A
20:48:13 [2021-06-01T20:48:13.980Z]       │ │ │ │   └─TableFullScan_121	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:966ms, 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:13 [2021-06-01T20:48:13.980Z]       │ │ │ └─TableReader_128(Probe)	240004648.80	189670348	root		time:1m4.8s, loops:184597, cop_task: {num: 761, max: 2.65s, min: 286.2ms, avg: 1.49s, p95: 1.92s, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 17m43.8s, tot_wait: 56.2s, rpc_num: 761, rpc_time: 18m53.2s, copr_cache: disabled}	data:Selection_127	109.4 MB	N/A
20:48:13 [2021-06-01T20:48:13.980Z]       │ │ │   └─Selection_127	240004648.80	189670348	cop[tikv]		tikv_task:{proc max:1.29s, min:273ms, p80:1.16s, 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: 10459, read_count: 1114189, read_byte: 23.6 GB}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:48:13 [2021-06-01T20:48:13.980Z]       │ │ │     └─TableFullScan_126	300005811.00	300005811	cop[tikv]	table:l1	tikv_task:{proc max:1.22s, min:253ms, p80:1.08s, p95:1.12s, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:48:13 [2021-06-01T20:48:13.980Z]       │ │ └─TableReader_95(Probe)	0.49	3496181	root		time:1m35s, loops:3875, cop_task: {num: 5266, max: 552.7ms, min: 2.41ms, avg: 169.8ms, p95: 326.2ms, max_proc_keys: 3848, p95_proc_keys: 1958, tot_proc: 10m39.8s, tot_wait: 3m35.1s, rpc_num: 5266, rpc_time: 14m54.1s, copr_cache: disabled}	data:Selection_94	N/A	N/A
20:48:13 [2021-06-01T20:48:13.980Z]       │ │   └─Selection_94	0.49	3496181	cop[tikv]		tikv_task:{proc max:163ms, min:0s, p80:68ms, p95:81ms, iters:30235, tasks:5266}, scan_detail: {total_process_keys: 7236304, total_keys: 7795523, rocksdb: {delete_skipped_count: 0, key_skipped_count: 1778351, block: {cache_hit_count: 54006392, read_count: 218274, read_byte: 4.21 GB}}}	eq(tpch50.orders.o_orderstatus, "F")	N/A	N/A
20:48:13 [2021-06-01T20:48:13.980Z]       │ │     └─TableRangeScan_93	1.00	7236304	cop[tikv]	table:orders	tikv_task:{proc max:163ms, min:0s, p80:67ms, p95:80ms, iters:30235, tasks:5266}	range: decided by [tpch50.lineitem.l_orderkey], keep order:false	N/A	N/A
20:48:13 [2021-06-01T20:48:13.980Z]       │ └─IndexLookUp_80(Probe)	4.05	17316449	root		time:1m53.3s, loops:17136, index_task: {total_time: 1m4.3s, fetch_handle: 56.7s, build: 3.3ms, wait: 7.59s}, table_task: {total_time: 8m4.9s, num: 1458, concurrency: 760}		19.2 KB	N/A
20:48:13 [2021-06-01T20:48:13.980Z]       │   ├─IndexRangeScan_78(Build)	4.05	17316449	cop[tikv]	table:l2, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:54.6s, loops:18648, cop_task: {num: 3036, max: 697.8ms, min: 388.6µs, avg: 180ms, p95: 353ms, max_proc_keys: 13918, p95_proc_keys: 8814, tot_proc: 6m47.6s, tot_wait: 1m58.3s, rpc_num: 3036, rpc_time: 9m6.4s, copr_cache: disabled}, tikv_task:{proc max:150ms, min:0s, p80:92ms, p95:107ms, iters:30232, tasks:3036}, scan_detail: {total_process_keys: 17316449, total_keys: 20812552, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17316449, block: {cache_hit_count: 24259966, read_count: 225682, read_byte: 2.00 GB}}}	range: decided by [eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey)], keep order:false	N/A	N/A
20:48:13 [2021-06-01T20:48:13.980Z]       │   └─TableRowIDScan_79(Probe)	4.05	17316449	cop[tikv]	table:l2	time:5m52.5s, loops:21027, cop_task: {num: 7796, max: 655ms, min: 478.9µs, avg: 166.5ms, p95: 337.2ms, max_proc_keys: 12685, p95_proc_keys: 4853, tot_proc: 15m31.5s, tot_wait: 5m16.7s, rpc_num: 7796, rpc_time: 21m37.9s, copr_cache: disabled}, tikv_task:{proc max:271ms, min:0s, p80:101ms, p95:136ms, iters:49833, tasks:7796}, scan_detail: {total_process_keys: 17316449, total_keys: 18290583, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5633868, block: {cache_hit_count: 99013400, read_count: 1111, read_byte: 396.8 MB}}}	keep order:false	N/A	N/A
20:48:13 [2021-06-01T20:48:13.980Z]       └─IndexLookUp_39(Probe)	4.05	12022814	root		time:1m48s, loops:11951, index_task: {total_time: 57s, fetch_handle: 47.4s, build: 3.78ms, wait: 9.57s}, table_task: {total_time: 7m42.7s, num: 1410, concurrency: 735}		207.0 KB	N/A
20:48:13 [2021-06-01T20:48:13.980Z]         ├─IndexRangeScan_36(Build)	5.06	17183408	cop[tikv]	table:l3, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:45.1s, loops:18365, cop_task: {num: 2809, max: 598.2ms, min: 881.3µs, avg: 157.9ms, p95: 341.6ms, max_proc_keys: 19743, p95_proc_keys: 13514, tot_proc: 5m27.7s, tot_wait: 1m36.2s, rpc_num: 2809, rpc_time: 7m23.5s, copr_cache: disabled}, tikv_task:{proc max:177ms, min:0s, p80:76ms, p95:117ms, iters:29137, tasks:2809}, scan_detail: {total_process_keys: 17183408, total_keys: 20546440, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17183408, block: {cache_hit_count: 23554030, read_count: 0, read_byte: 0 Bytes}}}	range: decided by [eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey)], keep order:false	N/A	N/A
20:48:13 [2021-06-01T20:48:13.981Z]         └─Selection_38(Probe)	4.05	12022814	cop[tikv]		time:5m55.5s, loops:13758, cop_task: {num: 10169, max: 624.2ms, min: 416.2µs, avg: 165.8ms, p95: 333.1ms, max_proc_keys: 7272, p95_proc_keys: 3975, tot_proc: 19m39.5s, tot_wait: 7m21.9s, rpc_num: 10169, rpc_time: 28m5.5s, copr_cache: disabled}, tikv_task:{proc max:235ms, min:0s, p80:75ms, p95:113ms, iters:60462, tasks:10169}, scan_detail: {total_process_keys: 17183408, total_keys: 18128775, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5524497, block: {cache_hit_count: 98292383, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:48:13 [2021-06-01T20:48:13.981Z]           └─TableRowIDScan_37	5.06	17183408	cop[tikv]	table:l3	tikv_task:{proc max:235ms, min:0s, p80:75ms, p95:112ms, iters:60462, tasks:10169}	keep order:false	N/A	N/A
20:48:13 [2021-06-01T20:48:13.981Z] + sync
20:48:13 [2021-06-01T20:48:13.981Z] + /usr/bin/echo 3
20:49:51 [2021-06-01T20:49:51.325Z] 
20:49:51 [2021-06-01T20:49:51.325Z] queries/21.sql
20:49:51 [2021-06-01T20:49:51.325Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:49:51 [2021-06-01T20:49:51.325Z] Projection_26	100.00	100	root		time:1m19.3s, loops:2, Concurrency:OFF	tpch50.supplier.s_name, Column#72	4.62 KB	N/A
20:49:51 [2021-06-01T20:49:51.325Z] └─TopN_29	100.00	100	root		time:1m19.3s, loops:2	Column#72:desc, tpch50.supplier.s_name, offset:0, count:100	55.9 KB	N/A
20:49:51 [2021-06-01T20:49:51.325Z]   └─HashAgg_34	12800.00	20057	root		time:1m19.3s, loops:21, partial_worker:{wall_time:1m19.289945773s, concurrency:5, task_num:198, tot_wait:6m36.189928243s, tot_exec:244.411348ms, tot_time:6m36.446994683s, max:1m19.28989378s, p95:1m19.28989378s}, final_worker:{wall_time:1m19.305474957s, concurrency:5, task_num:25, tot_wait:6m36.446167004s, tot_exec:73.116331ms, tot_time:6m36.519296351s, max:1m19.3054577s, p95:1m19.3054577s}	group by:tpch50.supplier.s_name, funcs:count(1)->Column#72, funcs:firstrow(tpch50.supplier.s_name)->tpch50.supplier.s_name	17.2 MB	N/A
20:49:51 [2021-06-01T20:49:51.325Z]     └─IndexHashJoin_42	7828961.66	198698	root		time:1m19.3s, loops:199, inner:{total:2m14.4s, concurrency:5, task:147, construct:6.32s, fetch:1m52.2s, build:1.16s, join:15.9s}	anti semi join, inner:IndexLookUp_39, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey)	641.0 MB	N/A
20:49:51 [2021-06-01T20:49:51.325Z]       ├─IndexHashJoin_83(Build)	9786202.08	3542799	root		time:1m18.8s, loops:3463, inner:{total:2m24.7s, concurrency:5, task:152, construct:7.98s, fetch:1m58.9s, build:1.22s, join:17.8s}	semi join, inner:IndexLookUp_80, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey), ne(tpch50.lineitem.l_suppkey, tpch50.supplier.s_suppkey)	555.9 MB	N/A
20:49:51 [2021-06-01T20:49:51.325Z]       │ ├─IndexJoin_99(Build)	12232752.60	3675878	root		time:1m18.2s, loops:3595, inner:{total:2m1s, concurrency:5, task:305, construct:16.7s, fetch:1m42.5s, build:1.81s}, probe:5.13s	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:49:51 [2021-06-01T20:49:51.325Z]       │ │ ├─HashJoin_107(Build)	12232752.60	7609895	root		time:1m17.8s, loops:7437, build_hash_table:{total:1.14s, fetch:1.14s, build:7.03ms}, probe:{concurrency:5, total:6m30.6s, max:1m18.1s, probe:1m0.4s, fetch:5m30.2s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.lineitem.l_suppkey)]	757.3 KB	0 Bytes
20:49:51 [2021-06-01T20:49:51.325Z]       │ │ │ ├─HashJoin_120(Build)	20000.00	20058	root		time:1.14s, loops:23, build_hash_table:{total:190.7µs, fetch:184.6µs, build:6.11µs}, probe:{concurrency:5, total:5.71s, max:1.14s, probe:64.2ms, fetch:5.65s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:49:51 [2021-06-01T20:49:51.325Z]       │ │ │ │ ├─TableReader_125(Build)	1.00	1	root		time:50.8µs, loops:2, cop_task: {num: 1, max: 1.21ms, proc_keys: 25, rpc_num: 1, rpc_time: 1.19ms, copr_cache: disabled}	data:Selection_124	244 Bytes	N/A
20:49:51 [2021-06-01T20:49:51.325Z]       │ │ │ │ │ └─Selection_124	1.00	1	cop[tikv]		tikv_task:{time:0s, loops:1}, scan_detail: {total_process_keys: 25, total_keys: 26, rocksdb: {delete_skipped_count: 0, key_skipped_count: 46, block: {cache_hit_count: 17, read_count: 1, read_byte: 23.8 KB}}}	eq(tpch50.nation.n_name, "EGYPT")	N/A	N/A
20:49:51 [2021-06-01T20:49:51.325Z]       │ │ │ │ │   └─TableFullScan_123	25.00	25	cop[tikv]	table:nation	tikv_task:{time:0s, loops:1}	keep order:false	N/A	N/A
20:49:51 [2021-06-01T20:49:51.325Z]       │ │ │ │ └─TableReader_122(Probe)	500000.00	500000	root		time:1.13s, loops:490, cop_task: {num: 1, max: 1.13s, proc_keys: 500000, tot_proc: 1.1s, rpc_num: 1, rpc_time: 1.13s, copr_cache: disabled}	data:TableFullScan_121	20.0 MB	N/A
20:49:51 [2021-06-01T20:49:51.325Z]       │ │ │ │   └─TableFullScan_121	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:1.04s, loops:493}, scan_detail: {total_process_keys: 500000, total_keys: 500001, rocksdb: {delete_skipped_count: 0, key_skipped_count: 999999, block: {cache_hit_count: 13, read_count: 1679, read_byte: 104.5 MB}}}	keep order:false	N/A	N/A
20:49:51 [2021-06-01T20:49:51.325Z]       │ │ │ └─TableReader_128(Probe)	240004648.80	189670348	root		time:1m5.4s, loops:184598, cop_task: {num: 761, max: 2.81s, min: 284.4ms, avg: 1.5s, p95: 1.93s, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 17m48.3s, tot_wait: 56.7s, rpc_num: 761, rpc_time: 18m57.9s, copr_cache: disabled}	data:Selection_127	109.4 MB	N/A
20:49:51 [2021-06-01T20:49:51.325Z]       │ │ │   └─Selection_127	240004648.80	189670348	cop[tikv]		tikv_task:{proc max:1.32s, min:266ms, 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: 10458, read_count: 1114190, read_byte: 23.6 GB}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:49:51 [2021-06-01T20:49:51.325Z]       │ │ │     └─TableFullScan_126	300005811.00	300005811	cop[tikv]	table:l1	tikv_task:{proc max:1.24s, min:249ms, p80:1.09s, p95:1.13s, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:49:51 [2021-06-01T20:49:51.325Z]       │ │ └─TableReader_95(Probe)	0.49	3496205	root		time:1m33.6s, loops:3875, cop_task: {num: 5244, max: 530.3ms, min: 765.6µs, avg: 170ms, p95: 323.2ms, max_proc_keys: 3789, p95_proc_keys: 1967, tot_proc: 10m41.7s, tot_wait: 3m30.3s, rpc_num: 5244, rpc_time: 14m51.2s, copr_cache: disabled}	data:Selection_94	N/A	N/A
20:49:51 [2021-06-01T20:49:51.325Z]       │ │   └─Selection_94	0.49	3496205	cop[tikv]		tikv_task:{proc max:144ms, min:0s, p80:67ms, p95:80ms, iters:30168, tasks:5244}, scan_detail: {total_process_keys: 7236295, total_keys: 7795479, rocksdb: {delete_skipped_count: 0, key_skipped_count: 1778258, block: {cache_hit_count: 54006119, read_count: 218243, read_byte: 4.21 GB}}}	eq(tpch50.orders.o_orderstatus, "F")	N/A	N/A
20:49:51 [2021-06-01T20:49:51.325Z]       │ │     └─TableRangeScan_93	1.00	7236295	cop[tikv]	table:orders	tikv_task:{proc max:142ms, min:0s, p80:67ms, p95:80ms, iters:30168, tasks:5244}	range: decided by [tpch50.lineitem.l_orderkey], keep order:false	N/A	N/A
20:49:51 [2021-06-01T20:49:51.325Z]       │ └─IndexLookUp_80(Probe)	4.05	17316465	root		time:1m53.4s, loops:17129, index_task: {total_time: 1m3.2s, fetch_handle: 55.3s, build: 3.44ms, wait: 7.86s}, table_task: {total_time: 8m5.8s, num: 1458, concurrency: 760}		19.0 KB	N/A
20:49:51 [2021-06-01T20:49:51.325Z]       │   ├─IndexRangeScan_78(Build)	4.05	17316465	cop[tikv]	table:l2, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:53s, loops:18598, cop_task: {num: 2988, max: 700.5ms, min: 446.4µs, avg: 180.7ms, p95: 365ms, max_proc_keys: 13429, p95_proc_keys: 8824, tot_proc: 6m47.1s, tot_wait: 1m52.2s, rpc_num: 2988, rpc_time: 8m59.9s, copr_cache: disabled}, tikv_task:{proc max:169ms, min:0s, p80:93ms, p95:109ms, iters:30079, tasks:2988}, scan_detail: {total_process_keys: 17316465, total_keys: 20812569, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17316465, 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:49:51 [2021-06-01T20:49:51.325Z]       │   └─TableRowIDScan_79(Probe)	4.05	17316465	cop[tikv]	table:l2	time:5m58.3s, loops:21017, cop_task: {num: 7766, max: 594.2ms, min: 529.4µs, avg: 167.8ms, p95: 336.7ms, max_proc_keys: 10285, p95_proc_keys: 4868, tot_proc: 15m31.2s, tot_wait: 5m21.1s, rpc_num: 7766, rpc_time: 21m42.8s, copr_cache: disabled}, tikv_task:{proc max:248ms, min:0s, p80:102ms, p95:137ms, iters:49928, tasks:7766}, scan_detail: {total_process_keys: 17316465, total_keys: 18289915, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5631250, block: {cache_hit_count: 99015604, read_count: 1104, read_byte: 386.7 MB}}}	keep order:false	N/A	N/A
20:49:51 [2021-06-01T20:49:51.325Z]       └─IndexLookUp_39(Probe)	4.05	12022764	root		time:1m47.3s, loops:11948, index_task: {total_time: 56.1s, fetch_handle: 46.3s, build: 3.66ms, wait: 9.83s}, table_task: {total_time: 7m39.6s, num: 1410, concurrency: 735}		220.4 KB	N/A
20:49:51 [2021-06-01T20:49:51.325Z]         ├─IndexRangeScan_36(Build)	5.06	17183356	cop[tikv]	table:l3, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:43.9s, loops:18354, cop_task: {num: 2784, max: 659.8ms, min: 656.6µs, avg: 157.6ms, p95: 331.3ms, max_proc_keys: 20692, p95_proc_keys: 13857, tot_proc: 5m24.8s, tot_wait: 1m34.2s, rpc_num: 2784, rpc_time: 7m18.7s, copr_cache: disabled}, tikv_task:{proc max:168ms, min:0s, p80:76ms, p95:119ms, iters:29037, tasks:2784}, scan_detail: {total_process_keys: 17183356, total_keys: 20546376, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17183356, block: {cache_hit_count: 23553946, read_count: 0, read_byte: 0 Bytes}}}	range: decided by [eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey)], keep order:false	N/A	N/A
20:49:51 [2021-06-01T20:49:51.325Z]         └─Selection_38(Probe)	4.05	12022764	cop[tikv]		time:5m54.1s, loops:13768, cop_task: {num: 10148, max: 585.2ms, min: 464.4µs, avg: 164.9ms, p95: 331.2ms, max_proc_keys: 7298, p95_proc_keys: 4018, tot_proc: 19m33.5s, tot_wait: 7m15.1s, rpc_num: 10148, rpc_time: 27m53.1s, copr_cache: disabled}, tikv_task:{proc max:205ms, min:0s, p80:74ms, p95:114ms, iters:60368, tasks:10148}, scan_detail: {total_process_keys: 17183356, total_keys: 18129076, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5526032, block: {cache_hit_count: 98290634, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:49:51 [2021-06-01T20:49:51.325Z]           └─TableRowIDScan_37	5.06	17183356	cop[tikv]	table:l3	tikv_task:{proc max:203ms, min:0s, p80:74ms, p95:113ms, iters:60368, tasks:10148}	keep order:false	N/A	N/A
20:49:51 [2021-06-01T20:49:51.325Z] + sync
20:49:51 [2021-06-01T20:49:51.325Z] + /usr/bin/echo 3
20:51:09 [2021-06-01T20:51:09.064Z] 
20:51:09 [2021-06-01T20:51:09.064Z] queries/21.sql
20:51:09 [2021-06-01T20:51:09.064Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:51:09 [2021-06-01T20:51:09.064Z] Projection_26	100.00	100	root		time:1m19.2s, loops:2, Concurrency:OFF	tpch50.supplier.s_name, Column#72	4.62 KB	N/A
20:51:09 [2021-06-01T20:51:09.064Z] └─TopN_29	100.00	100	root		time:1m19.2s, loops:2	Column#72:desc, tpch50.supplier.s_name, offset:0, count:100	55.9 KB	N/A
20:51:09 [2021-06-01T20:51:09.064Z]   └─HashAgg_34	12800.00	20057	root		time:1m19.2s, loops:21, partial_worker:{wall_time:1m19.184882078s, concurrency:5, task_num:196, tot_wait:6m35.633379639s, tot_exec:278.331524ms, tot_time:6m35.923367406s, max:1m19.184855697s, p95:1m19.184855697s}, final_worker:{wall_time:1m19.197479642s, concurrency:5, task_num:25, tot_wait:6m35.922911937s, tot_exec:63.301602ms, tot_time:6m35.986224976s, max:1m19.197463316s, p95:1m19.197463316s}	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:09 [2021-06-01T20:51:09.064Z]     └─IndexHashJoin_42	7828961.66	198698	root		time:1m19.2s, loops:197, inner:{total:2m14.3s, concurrency:5, task:147, construct:6.48s, fetch:1m51.2s, build:1.21s, join:16.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:51:09 [2021-06-01T20:51:09.064Z]       ├─IndexHashJoin_83(Build)	9786202.08	3542799	root		time:1m18.7s, loops:3464, inner:{total:2m22.8s, concurrency:5, task:152, construct:7.97s, fetch:1m56.9s, build:1.26s, join:17.9s}	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:09 [2021-06-01T20:51:09.064Z]       │ ├─IndexJoin_99(Build)	12232752.60	3675878	root		time:1m18.1s, loops:3595, inner:{total:2m4.1s, concurrency:5, task:305, construct:16.6s, fetch:1m45.6s, build:1.9s}, probe:5.25s	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:51:09 [2021-06-01T20:51:09.064Z]       │ │ ├─HashJoin_107(Build)	12232752.60	7609895	root		time:1m17.7s, loops:7436, build_hash_table:{total:1.11s, fetch:1.1s, build:6.83ms}, probe:{concurrency:5, total:6m30s, max:1m18s, probe:1m0.5s, fetch:5m29.5s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.lineitem.l_suppkey)]	737.6 KB	0 Bytes
20:51:09 [2021-06-01T20:51:09.064Z]       │ │ │ ├─HashJoin_120(Build)	20000.00	20058	root		time:1.11s, loops:22, build_hash_table:{total:123.1µs, fetch:117.4µs, build:5.69µs}, probe:{concurrency:5, total:5.54s, max:1.11s, probe:66.2ms, fetch:5.47s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:51:09 [2021-06-01T20:51:09.064Z]       │ │ │ │ ├─TableReader_125(Build)	1.00	1	root		time:30.6µs, loops:2, cop_task: {num: 1, max: 1.33ms, proc_keys: 25, tot_proc: 2ms, rpc_num: 1, rpc_time: 1.3ms, copr_cache: disabled}	data:Selection_124	248 Bytes	N/A
20:51:09 [2021-06-01T20:51:09.064Z]       │ │ │ │ │ └─Selection_124	1.00	1	cop[tikv]		tikv_task:{time:2ms, 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:09 [2021-06-01T20:51:09.064Z]       │ │ │ │ │   └─TableFullScan_123	25.00	25	cop[tikv]	table:nation	tikv_task:{time:2ms, loops:1}	keep order:false	N/A	N/A
20:51:09 [2021-06-01T20:51:09.064Z]       │ │ │ │ └─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.07s, rpc_num: 1, rpc_time: 1.09s, copr_cache: disabled}	data:TableFullScan_121	20.0 MB	N/A
20:51:09 [2021-06-01T20:51:09.064Z]       │ │ │ │   └─TableFullScan_121	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:1s, loops:493}, scan_detail: {total_process_keys: 500000, total_keys: 500001, rocksdb: {delete_skipped_count: 0, key_skipped_count: 999999, block: {cache_hit_count: 13, read_count: 1679, read_byte: 104.5 MB}}}	keep order:false	N/A	N/A
20:51:09 [2021-06-01T20:51:09.064Z]       │ │ │ └─TableReader_128(Probe)	240004648.80	189670348	root		time:1m5.3s, loops:184596, cop_task: {num: 761, max: 2.51s, min: 276.5ms, avg: 1.49s, p95: 1.94s, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 17m47.9s, tot_wait: 56.7s, rpc_num: 761, rpc_time: 18m57.5s, copr_cache: disabled}	data:Selection_127	109.4 MB	N/A
20:51:09 [2021-06-01T20:51:09.064Z]       │ │ │   └─Selection_127	240004648.80	189670348	cop[tikv]		tikv_task:{proc max:1.33s, min:259ms, p80:1.17s, p95:1.21s, iters:296606, tasks:761}, scan_detail: {total_process_keys: 300005811, total_keys: 300006572, rocksdb: {delete_skipped_count: 0, key_skipped_count: 600010861, block: {cache_hit_count: 10458, read_count: 1114190, read_byte: 23.6 GB}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:51:09 [2021-06-01T20:51:09.064Z]       │ │ │     └─TableFullScan_126	300005811.00	300005811	cop[tikv]	table:l1	tikv_task:{proc max:1.25s, min:244ms, p80:1.09s, p95:1.14s, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:51:09 [2021-06-01T20:51:09.064Z]       │ │ └─TableReader_95(Probe)	0.49	3496174	root		time:1m36.6s, loops:3875, cop_task: {num: 5290, max: 517.7ms, min: 2.23ms, avg: 170.4ms, p95: 330ms, max_proc_keys: 3763, p95_proc_keys: 1948, tot_proc: 10m52.3s, tot_wait: 3m30.8s, rpc_num: 5290, rpc_time: 15m1.1s, copr_cache: disabled}	data:Selection_94	N/A	N/A
20:51:09 [2021-06-01T20:51:09.064Z]       │ │   └─Selection_94	0.49	3496174	cop[tikv]		tikv_task:{proc max:167ms, min:0s, p80:67ms, p95:79ms, iters:30257, tasks:5290}, scan_detail: {total_process_keys: 7236258, total_keys: 7795475, rocksdb: {delete_skipped_count: 0, key_skipped_count: 1778323, block: {cache_hit_count: 54005990, read_count: 218277, read_byte: 4.21 GB}}}	eq(tpch50.orders.o_orderstatus, "F")	N/A	N/A
20:51:09 [2021-06-01T20:51:09.064Z]       │ │     └─TableRangeScan_93	1.00	7236258	cop[tikv]	table:orders	tikv_task:{proc max:166ms, min:0s, p80:67ms, p95:79ms, iters:30257, tasks:5290}	range: decided by [tpch50.lineitem.l_orderkey], keep order:false	N/A	N/A
20:51:09 [2021-06-01T20:51:09.064Z]       │ └─IndexLookUp_80(Probe)	4.05	17316498	root		time:1m51.6s, loops:17131, index_task: {total_time: 1m1.7s, fetch_handle: 53.3s, build: 3.44ms, wait: 8.36s}, table_task: {total_time: 8m1.1s, num: 1458, concurrency: 760}		18.8 KB	N/A
20:51:09 [2021-06-01T20:51:09.064Z]       │   ├─IndexRangeScan_78(Build)	4.05	17316498	cop[tikv]	table:l2, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:50.9s, loops:18614, cop_task: {num: 3012, max: 680.7ms, min: 474.1µs, avg: 177.2ms, p95: 355.4ms, max_proc_keys: 15143, p95_proc_keys: 8771, tot_proc: 6m40.6s, tot_wait: 1m53.4s, rpc_num: 3012, rpc_time: 8m53.6s, copr_cache: disabled}, tikv_task:{proc max:149ms, min:0s, p80:93ms, p95:110ms, iters:30172, tasks:3012}, scan_detail: {total_process_keys: 17316498, total_keys: 20812608, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17316498, block: {cache_hit_count: 24260016, 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:09 [2021-06-01T20:51:09.064Z]       │   └─TableRowIDScan_79(Probe)	4.05	17316498	cop[tikv]	table:l2	time:5m54.8s, loops:21003, cop_task: {num: 7807, max: 644ms, min: 478.4µs, avg: 166.2ms, p95: 332.9ms, max_proc_keys: 9760, p95_proc_keys: 4887, tot_proc: 15m31.6s, tot_wait: 5m16.1s, rpc_num: 7807, rpc_time: 21m37s, copr_cache: disabled}, tikv_task:{proc max:218ms, min:0s, p80:102ms, p95:136ms, iters:49988, tasks:7807}, scan_detail: {total_process_keys: 17316498, total_keys: 18289671, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5630223, block: {cache_hit_count: 99017624, read_count: 1112, read_byte: 396.8 MB}}}	keep order:false	N/A	N/A
20:51:09 [2021-06-01T20:51:09.064Z]       └─IndexLookUp_39(Probe)	4.05	12022779	root		time:1m46.2s, loops:11947, index_task: {total_time: 56.3s, fetch_handle: 46.9s, build: 4.27ms, wait: 9.45s}, table_task: {total_time: 7m36.6s, num: 1410, concurrency: 735}		260.0 KB	N/A
20:51:09 [2021-06-01T20:51:09.064Z]         ├─IndexRangeScan_36(Build)	5.06	17183372	cop[tikv]	table:l3, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:44.5s, loops:18360, cop_task: {num: 2802, max: 653.9ms, min: 476.9µs, avg: 156.2ms, p95: 327.9ms, max_proc_keys: 19581, p95_proc_keys: 13659, tot_proc: 5m24.4s, tot_wait: 1m33s, rpc_num: 2802, rpc_time: 7m17.7s, copr_cache: disabled}, tikv_task:{proc max:174ms, min:0s, p80:76ms, p95:115ms, iters:29141, tasks:2802}, scan_detail: {total_process_keys: 17183372, total_keys: 20546396, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17183372, block: {cache_hit_count: 23553974, 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:09 [2021-06-01T20:51:09.064Z]         └─Selection_38(Probe)	4.05	12022779	cop[tikv]		time:5m52.3s, loops:13778, cop_task: {num: 10089, max: 576.2ms, min: 535µs, avg: 164.3ms, p95: 332.1ms, max_proc_keys: 7880, p95_proc_keys: 4046, tot_proc: 19m23s, tot_wait: 7m11.3s, rpc_num: 10089, rpc_time: 27m37.5s, copr_cache: disabled}, tikv_task:{proc max:221ms, min:0s, p80:75ms, p95:114ms, iters:60144, tasks:10089}, scan_detail: {total_process_keys: 17183372, total_keys: 18130294, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5532772, block: {cache_hit_count: 98281647, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:51:09 [2021-06-01T20:51:09.064Z]           └─TableRowIDScan_37	5.06	17183372	cop[tikv]	table:l3	tikv_task:{proc max:221ms, min:0s, p80:75ms, p95:114ms, iters:60144, tasks:10089}	keep order:false	N/A	N/A
20:51:09 [2021-06-01T20:51:09.064Z] + sync
20:51:09 [2021-06-01T20:51:09.064Z] + /usr/bin/echo 3
20:52:21 [2021-06-01T20:52:21.873Z] 
20:52:21 [2021-06-01T20:52:21.873Z] queries/21.sql
20:52:21 [2021-06-01T20:52:21.873Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:52:21 [2021-06-01T20:52:21.873Z] Projection_26	100.00	100	root		time:1m19.4s, loops:2, Concurrency:OFF	tpch50.supplier.s_name, Column#72	4.62 KB	N/A
20:52:21 [2021-06-01T20:52:21.873Z] └─TopN_29	100.00	100	root		time:1m19.4s, loops:2	Column#72:desc, tpch50.supplier.s_name, offset:0, count:100	55.9 KB	N/A
20:52:21 [2021-06-01T20:52:21.873Z]   └─HashAgg_34	12800.00	20057	root		time:1m19.4s, loops:21, partial_worker:{wall_time:1m19.35371315s, concurrency:5, task_num:197, tot_wait:6m36.506171037s, tot_exec:249.166069ms, tot_time:6m36.767223092s, max:1m19.353680286s, p95:1m19.353680286s}, final_worker:{wall_time:1m19.366806213s, concurrency:5, task_num:25, tot_wait:6m36.766107982s, tot_exec:66.765363ms, tot_time:6m36.832885293s, max:1m19.366785815s, p95:1m19.366785815s}	group by:tpch50.supplier.s_name, funcs:count(1)->Column#72, funcs:firstrow(tpch50.supplier.s_name)->tpch50.supplier.s_name	17.2 MB	N/A
20:52:21 [2021-06-01T20:52:21.873Z]     └─IndexHashJoin_42	7828961.66	198698	root		time:1m19.4s, loops:198, inner:{total:2m15s, concurrency:5, task:146, construct:6.63s, fetch:1m52.2s, build:1.15s, 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:52:21 [2021-06-01T20:52:21.873Z]       ├─IndexHashJoin_83(Build)	9786202.08	3542799	root		time:1m18.9s, loops:3463, inner:{total:2m22.8s, concurrency:5, task:152, construct:7.61s, fetch:1m57.4s, build:1.21s, join:17.8s}	semi join, inner:IndexLookUp_80, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey), ne(tpch50.lineitem.l_suppkey, tpch50.supplier.s_suppkey)	555.9 MB	N/A
20:52:21 [2021-06-01T20:52:21.873Z]       │ ├─IndexJoin_99(Build)	12232752.60	3675878	root		time:1m18.4s, loops:3595, inner:{total:2m4s, concurrency:5, task:305, construct:16.4s, fetch:1m45.6s, build:1.91s}, probe:5.01s	inner join, inner:TableReader_95, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.orders.o_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.orders.o_orderkey)	575.5 MB	N/A
20:52:21 [2021-06-01T20:52:21.873Z]       │ │ ├─HashJoin_107(Build)	12232752.60	7609895	root		time:1m18s, loops:7436, build_hash_table:{total:1.06s, fetch:1.06s, build:6ms}, probe:{concurrency:5, total:6m31.8s, max:1m18.4s, probe:1m0.3s, fetch:5m31.5s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.lineitem.l_suppkey)]	737.6 KB	0 Bytes
20:52:21 [2021-06-01T20:52:21.873Z]       │ │ │ ├─HashJoin_120(Build)	20000.00	20058	root		time:1.06s, loops:22, build_hash_table:{total:139.8µs, fetch:133.8µs, build:6.01µs}, probe:{concurrency:5, total:5.3s, max:1.06s, probe:63.4ms, fetch:5.23s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:52:21 [2021-06-01T20:52:21.873Z]       │ │ │ │ ├─TableReader_125(Build)	1.00	1	root		time:40.4µs, loops:2, cop_task: {num: 1, max: 1.38ms, proc_keys: 25, rpc_num: 1, rpc_time: 1.36ms, copr_cache: disabled}	data:Selection_124	240 Bytes	N/A
20:52:21 [2021-06-01T20:52:21.873Z]       │ │ │ │ │ └─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:52:21 [2021-06-01T20:52:21.873Z]       │ │ │ │ │   └─TableFullScan_123	25.00	25	cop[tikv]	table:nation	tikv_task:{time:0s, loops:1}	keep order:false	N/A	N/A
20:52:21 [2021-06-01T20:52:21.873Z]       │ │ │ │ └─TableReader_122(Probe)	500000.00	500000	root		time:1.05s, loops:490, cop_task: {num: 1, max: 1.05s, proc_keys: 500000, tot_proc: 1.02s, tot_wait: 1ms, rpc_num: 1, rpc_time: 1.05s, copr_cache: disabled}	data:TableFullScan_121	20.0 MB	N/A
20:52:21 [2021-06-01T20:52:21.873Z]       │ │ │ │   └─TableFullScan_121	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: 13, read_count: 1679, read_byte: 104.5 MB}}}	keep order:false	N/A	N/A
20:52:21 [2021-06-01T20:52:21.873Z]       │ │ │ └─TableReader_128(Probe)	240004648.80	189670348	root		time:1m5.9s, loops:184597, cop_task: {num: 761, max: 2.69s, min: 388.1ms, avg: 1.5s, p95: 1.95s, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 17m48.1s, tot_wait: 57.7s, rpc_num: 761, rpc_time: 18m58.6s, copr_cache: disabled}	data:Selection_127	109.4 MB	N/A
20:52:21 [2021-06-01T20:52:21.873Z]       │ │ │   └─Selection_127	240004648.80	189670348	cop[tikv]		tikv_task:{proc max:1.27s, min:374ms, p80:1.16s, 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:52:21 [2021-06-01T20:52:21.873Z]       │ │ │     └─TableFullScan_126	300005811.00	300005811	cop[tikv]	table:l1	tikv_task:{proc max:1.19s, min:345ms, p80:1.09s, p95:1.13s, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:52:21 [2021-06-01T20:52:21.873Z]       │ │ └─TableReader_95(Probe)	0.49	3496176	root		time:1m36.6s, loops:3875, cop_task: {num: 5254, max: 499.2ms, min: 1.58ms, avg: 172.8ms, p95: 326.5ms, max_proc_keys: 3539, p95_proc_keys: 1956, tot_proc: 10m48.4s, tot_wait: 3m39.6s, rpc_num: 5254, rpc_time: 15m7.6s, copr_cache: disabled}	data:Selection_94	N/A	N/A
20:52:21 [2021-06-01T20:52:21.873Z]       │ │   └─Selection_94	0.49	3496176	cop[tikv]		tikv_task:{proc max:140ms, min:0s, p80:68ms, p95:80ms, iters:30205, tasks:5254}, scan_detail: {total_process_keys: 7236254, total_keys: 7795467, rocksdb: {delete_skipped_count: 0, key_skipped_count: 1778291, block: {cache_hit_count: 54006191, read_count: 218295, read_byte: 4.21 GB}}}	eq(tpch50.orders.o_orderstatus, "F")	N/A	N/A
20:52:21 [2021-06-01T20:52:21.873Z]       │ │     └─TableRangeScan_93	1.00	7236254	cop[tikv]	table:orders	tikv_task:{proc max:139ms, min:0s, p80:67ms, p95:80ms, iters:30205, tasks:5254}	range: decided by [tpch50.lineitem.l_orderkey], keep order:false	N/A	N/A
20:52:21 [2021-06-01T20:52:21.873Z]       │ └─IndexLookUp_80(Probe)	4.05	17316466	root		time:1m52s, loops:17129, index_task: {total_time: 1m2.4s, fetch_handle: 55.4s, build: 3.33ms, wait: 6.95s}, table_task: {total_time: 8m2.3s, num: 1458, concurrency: 760}		19.4 KB	N/A
20:52:21 [2021-06-01T20:52:21.874Z]       │   ├─IndexRangeScan_78(Build)	4.05	17316466	cop[tikv]	table:l2, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:53.2s, loops:18638, cop_task: {num: 3015, max: 614.5ms, min: 622.2µs, avg: 178.7ms, p95: 356.7ms, max_proc_keys: 14097, p95_proc_keys: 8815, tot_proc: 6m40.5s, tot_wait: 1m56.6s, rpc_num: 3015, rpc_time: 8m58.6s, copr_cache: disabled}, tikv_task:{proc max:152ms, min:0s, p80:93ms, p95:108ms, iters:30267, tasks:3015}, scan_detail: {total_process_keys: 17316466, total_keys: 20812572, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17316466, block: {cache_hit_count: 24259983, read_count: 225687, read_byte: 2.00 GB}}}	range: decided by [eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey)], keep order:false	N/A	N/A
20:52:21 [2021-06-01T20:52:21.874Z]       │   └─TableRowIDScan_79(Probe)	4.05	17316466	cop[tikv]	table:l2	time:5m55.6s, loops:21040, cop_task: {num: 7879, max: 663.2ms, min: 539µs, avg: 166.4ms, p95: 334.7ms, max_proc_keys: 12685, p95_proc_keys: 4849, tot_proc: 15m34.3s, tot_wait: 5m26.9s, rpc_num: 7879, rpc_time: 21m51.2s, copr_cache: disabled}, tikv_task:{proc max:339ms, min:0s, p80:101ms, p95:136ms, iters:50039, tasks:7879}, scan_detail: {total_process_keys: 17316466, total_keys: 18288095, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5623997, block: {cache_hit_count: 99024085, read_count: 1115, read_byte: 398.5 MB}}}	keep order:false	N/A	N/A
20:52:21 [2021-06-01T20:52:21.874Z]       └─IndexLookUp_39(Probe)	4.05	12022840	root		time:1m47s, loops:11943, index_task: {total_time: 56.7s, fetch_handle: 46s, build: 3.36ms, wait: 10.8s}, table_task: {total_time: 7m43.4s, num: 1408, concurrency: 730}		228.2 KB	N/A
20:52:21 [2021-06-01T20:52:21.874Z]         ├─IndexRangeScan_36(Build)	5.06	17183450	cop[tikv]	table:l3, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:43.7s, loops:18384, cop_task: {num: 2786, max: 755.2ms, min: 985.6µs, avg: 159.7ms, p95: 340.6ms, max_proc_keys: 20642, p95_proc_keys: 13413, tot_proc: 5m32s, tot_wait: 1m33.2s, rpc_num: 2786, rpc_time: 7m24.8s, copr_cache: disabled}, tikv_task:{proc max:189ms, min:0s, p80:76ms, p95:115ms, iters:29103, tasks:2786}, scan_detail: {total_process_keys: 17183450, total_keys: 20546487, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17183450, block: {cache_hit_count: 23554066, read_count: 0, read_byte: 0 Bytes}}}	range: decided by [eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey)], keep order:false	N/A	N/A
20:52:21 [2021-06-01T20:52:21.874Z]         └─Selection_38(Probe)	4.05	12022840	cop[tikv]		time:5m56.6s, loops:13767, cop_task: {num: 10231, max: 630.3ms, min: 419.7µs, avg: 164.8ms, p95: 331.5ms, max_proc_keys: 7157, p95_proc_keys: 4004, tot_proc: 19m41.6s, tot_wait: 7m18.9s, rpc_num: 10231, rpc_time: 28m6s, copr_cache: disabled}, tikv_task:{proc max:222ms, min:0s, p80:74ms, p95:114ms, iters:60526, tasks:10231}, scan_detail: {total_process_keys: 17183450, total_keys: 18128971, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5524871, block: {cache_hit_count: 98294802, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:52:21 [2021-06-01T20:52:21.874Z]           └─TableRowIDScan_37	5.06	17183450	cop[tikv]	table:l3	tikv_task:{proc max:220ms, min:0s, p80:73ms, p95:114ms, iters:60526, tasks:10231}	keep order:false	N/A	N/A
20:52:21 [2021-06-01T20:52:21.874Z] + sync
20:52:21 [2021-06-01T20:52:21.874Z] + /usr/bin/echo 3
20:53:53 [2021-06-01T20:53:53.143Z] 
20:53:53 [2021-06-01T20:53:53.143Z] queries/21.sql
20:53:53 [2021-06-01T20:53:53.143Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:53:53 [2021-06-01T20:53:53.143Z] Projection_26	100.00	100	root		time:1m19.1s, loops:2, Concurrency:OFF	tpch50.supplier.s_name, Column#72	4.62 KB	N/A
20:53:53 [2021-06-01T20:53:53.143Z] └─TopN_29	100.00	100	root		time:1m19.1s, loops:2	Column#72:desc, tpch50.supplier.s_name, offset:0, count:100	58.4 KB	N/A
20:53:53 [2021-06-01T20:53:53.143Z]   └─HashAgg_34	12800.00	20057	root		time:1m19.1s, loops:21, partial_worker:{wall_time:1m19.051037967s, concurrency:5, task_num:197, tot_wait:6m34.980378158s, tot_exec:260.459687ms, tot_time:6m35.253785334s, max:1m19.051003255s, p95:1m19.051003255s}, final_worker:{wall_time:1m19.06400973s, concurrency:5, task_num:25, tot_wait:6m35.251855972s, tot_exec:63.089408ms, tot_time:6m35.314957425s, max:1m19.063978634s, p95:1m19.063978634s}	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:53 [2021-06-01T20:53:53.143Z]     └─IndexHashJoin_42	7828961.66	198698	root		time:1m19s, loops:198, inner:{total:2m15.4s, concurrency:5, task:146, construct:6.2s, fetch:1m52.8s, build:1.21s, join:16.4s}	anti semi join, inner:IndexLookUp_39, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey)	641.0 MB	N/A
20:53:53 [2021-06-01T20:53:53.143Z]       ├─IndexHashJoin_83(Build)	9786202.08	3542799	root		time:1m18.5s, loops:3463, inner:{total:2m24.6s, concurrency:5, task:152, construct:7.84s, fetch:1m59.3s, build:1.13s, join:17.4s}	semi join, inner:IndexLookUp_80, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey), ne(tpch50.lineitem.l_suppkey, tpch50.supplier.s_suppkey)	555.9 MB	N/A
20:53:53 [2021-06-01T20:53:53.144Z]       │ ├─IndexJoin_99(Build)	12232752.60	3675878	root		time:1m18s, loops:3595, inner:{total:2m4.1s, concurrency:5, task:305, construct:16.4s, fetch:1m45.9s, build:1.75s}, 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.3 MB	N/A
20:53:53 [2021-06-01T20:53:53.144Z]       │ │ ├─HashJoin_107(Build)	12232752.60	7609895	root		time:1m17.4s, loops:7436, build_hash_table:{total:1.13s, fetch:1.13s, build:6.72ms}, probe:{concurrency:5, total:6m28.8s, max:1m17.8s, probe:1m0.8s, fetch:5m28s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.lineitem.l_suppkey)]	737.6 KB	0 Bytes
20:53:53 [2021-06-01T20:53:53.144Z]       │ │ │ ├─HashJoin_120(Build)	20000.00	20058	root		time:1.13s, loops:22, build_hash_table:{total:199.1µs, fetch:190.7µs, build:8.33µs}, probe:{concurrency:5, total:5.66s, max:1.13s, probe:65.2ms, fetch:5.6s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:53:53 [2021-06-01T20:53:53.144Z]       │ │ │ │ ├─TableReader_125(Build)	1.00	1	root		time:70.3µs, loops:2, cop_task: {num: 1, max: 1.2ms, proc_keys: 25, rpc_num: 1, rpc_time: 1.17ms, copr_cache: disabled}	data:Selection_124	240 Bytes	N/A
20:53:53 [2021-06-01T20:53:53.144Z]       │ │ │ │ │ └─Selection_124	1.00	1	cop[tikv]		tikv_task:{time:0s, loops:1}, scan_detail: {total_process_keys: 25, total_keys: 26, rocksdb: {delete_skipped_count: 0, key_skipped_count: 46, block: {cache_hit_count: 17, read_count: 1, read_byte: 23.8 KB}}}	eq(tpch50.nation.n_name, "EGYPT")	N/A	N/A
20:53:53 [2021-06-01T20:53:53.144Z]       │ │ │ │ │   └─TableFullScan_123	25.00	25	cop[tikv]	table:nation	tikv_task:{time:0s, loops:1}	keep order:false	N/A	N/A
20:53:53 [2021-06-01T20:53:53.144Z]       │ │ │ │ └─TableReader_122(Probe)	500000.00	500000	root		time:1.12s, loops:490, cop_task: {num: 1, max: 1.12s, proc_keys: 500000, tot_proc: 1.08s, rpc_num: 1, rpc_time: 1.12s, copr_cache: disabled}	data:TableFullScan_121	20.0 MB	N/A
20:53:53 [2021-06-01T20:53:53.144Z]       │ │ │ │   └─TableFullScan_121	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:1s, loops:493}, scan_detail: {total_process_keys: 500000, total_keys: 500001, rocksdb: {delete_skipped_count: 0, key_skipped_count: 999999, block: {cache_hit_count: 13, read_count: 1679, read_byte: 104.5 MB}}}	keep order:false	N/A	N/A
20:53:53 [2021-06-01T20:53:53.144Z]       │ │ │ └─TableReader_128(Probe)	240004648.80	189670348	root		time:1m4.9s, loops:184597, cop_task: {num: 761, max: 2.58s, min: 373.7ms, avg: 1.49s, p95: 1.95s, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 17m45s, tot_wait: 57.6s, rpc_num: 761, rpc_time: 18m55.4s, copr_cache: disabled}	data:Selection_127	109.4 MB	N/A
20:53:53 [2021-06-01T20:53:53.144Z]       │ │ │   └─Selection_127	240004648.80	189670348	cop[tikv]		tikv_task:{proc max:1.31s, min:356ms, p80:1.16s, 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: 10453, read_count: 1114195, read_byte: 23.6 GB}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:53:53 [2021-06-01T20:53:53.144Z]       │ │ │     └─TableFullScan_126	300005811.00	300005811	cop[tikv]	table:l1	tikv_task:{proc max:1.23s, min:329ms, p80:1.08s, p95:1.12s, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:53:53 [2021-06-01T20:53:53.144Z]       │ │ └─TableReader_95(Probe)	0.49	3496187	root		time:1m36.9s, loops:3875, cop_task: {num: 5262, max: 545.1ms, min: 1.98ms, avg: 172.8ms, p95: 329.5ms, max_proc_keys: 3391, p95_proc_keys: 1958, tot_proc: 10m54.7s, tot_wait: 3m36s, rpc_num: 5262, rpc_time: 15m9.4s, copr_cache: disabled}	data:Selection_94	N/A	N/A
20:53:53 [2021-06-01T20:53:53.144Z]       │ │   └─Selection_94	0.49	3496187	cop[tikv]		tikv_task:{proc max:143ms, min:0s, p80:67ms, p95:80ms, iters:30224, tasks:5262}, scan_detail: {total_process_keys: 7236295, total_keys: 7795554, rocksdb: {delete_skipped_count: 0, key_skipped_count: 1778415, block: {cache_hit_count: 54007057, read_count: 218211, read_byte: 4.21 GB}}}	eq(tpch50.orders.o_orderstatus, "F")	N/A	N/A
20:53:53 [2021-06-01T20:53:53.144Z]       │ │     └─TableRangeScan_93	1.00	7236295	cop[tikv]	table:orders	tikv_task:{proc max:143ms, min:0s, p80:67ms, p95:80ms, iters:30224, tasks:5262}	range: decided by [tpch50.lineitem.l_orderkey], keep order:false	N/A	N/A
20:53:53 [2021-06-01T20:53:53.144Z]       │ └─IndexLookUp_80(Probe)	4.05	17316494	root		time:1m53.6s, loops:17132, index_task: {total_time: 1m2.8s, fetch_handle: 53.9s, build: 4.96ms, wait: 8.91s}, table_task: {total_time: 8m10.7s, num: 1458, concurrency: 760}		19.2 KB	N/A
20:53:53 [2021-06-01T20:53:53.144Z]       │   ├─IndexRangeScan_78(Build)	4.05	17316494	cop[tikv]	table:l2, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:51.6s, loops:18617, cop_task: {num: 2967, max: 697.8ms, min: 463.3µs, avg: 183.5ms, p95: 364.1ms, max_proc_keys: 14443, p95_proc_keys: 8733, tot_proc: 6m43.1s, tot_wait: 1m59.4s, rpc_num: 2967, rpc_time: 9m4.3s, copr_cache: disabled}, tikv_task:{proc max:158ms, min:0s, p80:94ms, p95:108ms, iters:30034, tasks:2967}, scan_detail: {total_process_keys: 17316494, total_keys: 20812603, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17316494, block: {cache_hit_count: 24260014, read_count: 225676, read_byte: 2.00 GB}}}	range: decided by [eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey)], keep order:false	N/A	N/A
20:53:53 [2021-06-01T20:53:53.144Z]       │   └─TableRowIDScan_79(Probe)	4.05	17316494	cop[tikv]	table:l2	time:5m59.8s, loops:20965, cop_task: {num: 7815, max: 639.4ms, min: 390.8µs, avg: 168.6ms, p95: 339.4ms, max_proc_keys: 9709, p95_proc_keys: 4845, tot_proc: 15m45.9s, tot_wait: 5m21.9s, rpc_num: 7815, rpc_time: 21m57.7s, copr_cache: disabled}, tikv_task:{proc max:242ms, min:0s, p80:101ms, p95:136ms, iters:49921, tasks:7815}, scan_detail: {total_process_keys: 17316494, total_keys: 18290453, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5634177, block: {cache_hit_count: 99013352, read_count: 1113, read_byte: 393.6 MB}}}	keep order:false	N/A	N/A
20:53:53 [2021-06-01T20:53:53.144Z]       └─IndexLookUp_39(Probe)	4.05	12022816	root		time:1m47.7s, loops:11946, index_task: {total_time: 56.6s, fetch_handle: 46.3s, build: 3.58ms, wait: 10.2s}, table_task: {total_time: 7m46.7s, num: 1408, concurrency: 730}		268.1 KB	N/A
20:53:53 [2021-06-01T20:53:53.144Z]         ├─IndexRangeScan_36(Build)	5.06	17183395	cop[tikv]	table:l3, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:44s, loops:18352, cop_task: {num: 2742, max: 639.3ms, min: 357.1µs, avg: 161ms, p95: 341.7ms, max_proc_keys: 19593, p95_proc_keys: 13974, tot_proc: 5m25.4s, tot_wait: 1m35.7s, rpc_num: 2742, rpc_time: 7m21.5s, copr_cache: disabled}, tikv_task:{proc max:173ms, min:0s, p80:77ms, p95:120ms, iters:28879, tasks:2742}, scan_detail: {total_process_keys: 17183395, total_keys: 20546421, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17183395, block: {cache_hit_count: 23553988, read_count: 0, read_byte: 0 Bytes}}}	range: decided by [eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey)], keep order:false	N/A	N/A
20:53:53 [2021-06-01T20:53:53.144Z]         └─Selection_38(Probe)	4.05	12022816	cop[tikv]		time:5m57s, loops:13779, cop_task: {num: 10313, max: 587.6ms, min: 425.1µs, avg: 166ms, p95: 330.3ms, max_proc_keys: 7155, p95_proc_keys: 3957, tot_proc: 19m56.6s, tot_wait: 7m31.7s, rpc_num: 10313, rpc_time: 28m32.3s, copr_cache: disabled}, tikv_task:{proc max:220ms, min:0s, p80:73ms, p95:111ms, iters:60867, tasks:10313}, scan_detail: {total_process_keys: 17183395, total_keys: 18128713, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5525086, block: {cache_hit_count: 98291349, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:53:53 [2021-06-01T20:53:53.144Z]           └─TableRowIDScan_37	5.06	17183395	cop[tikv]	table:l3	tikv_task:{proc max:218ms, min:0s, p80:73ms, p95:110ms, iters:60867, tasks:10313}	keep order:false	N/A	N/A
20:53:53 [2021-06-01T20:53:53.144Z] + sync
20:53:53 [2021-06-01T20:53:53.144Z] + /usr/bin/echo 3
20:55:13 [2021-06-01T20:55:13.069Z] 
20:55:13 [2021-06-01T20:55:13.069Z] queries/21.sql
20:55:13 [2021-06-01T20:55:13.069Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:55:13 [2021-06-01T20:55:13.069Z] Projection_26	100.00	100	root		time:1m19.2s, loops:2, Concurrency:OFF	tpch50.supplier.s_name, Column#72	4.62 KB	N/A
20:55:13 [2021-06-01T20:55:13.069Z] └─TopN_29	100.00	100	root		time:1m19.2s, loops:2	Column#72:desc, tpch50.supplier.s_name, offset:0, count:100	58.4 KB	N/A
20:55:13 [2021-06-01T20:55:13.069Z]   └─HashAgg_34	12800.00	20057	root		time:1m19.2s, loops:21, partial_worker:{wall_time:1m19.142104907s, concurrency:5, task_num:197, tot_wait:6m35.429438276s, tot_exec:266.99313ms, tot_time:6m35.708609616s, max:1m19.142085213s, p95:1m19.142085213s}, final_worker:{wall_time:1m19.155381095s, concurrency:5, task_num:25, tot_wait:6m35.707651759s, tot_exec:65.222439ms, tot_time:6m35.772885766s, max:1m19.155370021s, p95:1m19.155370021s}	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:55:13 [2021-06-01T20:55:13.069Z]     └─IndexHashJoin_42	7828961.66	198698	root		time:1m19.1s, loops:198, inner:{total:2m13.8s, concurrency:5, task:147, construct:6.27s, fetch:1m50.8s, build:1.15s, join:16.7s}	anti semi join, inner:IndexLookUp_39, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey)	641.0 MB	N/A
20:55:13 [2021-06-01T20:55:13.069Z]       ├─IndexHashJoin_83(Build)	9786202.08	3542799	root		time:1m18.7s, loops:3463, inner:{total:2m21.5s, concurrency:5, task:152, construct:7.51s, fetch:1m56.5s, build:1.22s, join:17.5s}	semi join, inner:IndexLookUp_80, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey), ne(tpch50.lineitem.l_suppkey, tpch50.supplier.s_suppkey)	555.9 MB	N/A
20:55:13 [2021-06-01T20:55:13.069Z]       │ ├─IndexJoin_99(Build)	12232752.60	3675878	root		time:1m18.2s, loops:3595, inner:{total:2m3.1s, concurrency:5, task:305, construct:16.3s, fetch:1m44.9s, build:1.84s}, probe:5.12s	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:55:13 [2021-06-01T20:55:13.069Z]       │ │ ├─HashJoin_107(Build)	12232752.60	7609895	root		time:1m17.7s, loops:7436, build_hash_table:{total:1.03s, fetch:1.03s, build:6.36ms}, probe:{concurrency:5, total:6m30.1s, max:1m18s, probe:1m1.4s, fetch:5m28.8s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.lineitem.l_suppkey)]	729.6 KB	0 Bytes
20:55:13 [2021-06-01T20:55:13.069Z]       │ │ │ ├─HashJoin_120(Build)	20000.00	20058	root		time:1.03s, loops:22, build_hash_table:{total:182.9µs, fetch:174.1µs, build:8.83µs}, probe:{concurrency:5, total:5.15s, max:1.03s, probe:65.2ms, fetch:5.09s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:55:13 [2021-06-01T20:55:13.069Z]       │ │ │ │ ├─TableReader_125(Build)	1.00	1	root		time:45.3µs, loops:2, cop_task: {num: 1, max: 1.15ms, proc_keys: 25, rpc_num: 1, rpc_time: 1.09ms, copr_cache: disabled}	data:Selection_124	240 Bytes	N/A
20:55:13 [2021-06-01T20:55:13.069Z]       │ │ │ │ │ └─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:55:13 [2021-06-01T20:55:13.069Z]       │ │ │ │ │   └─TableFullScan_123	25.00	25	cop[tikv]	table:nation	tikv_task:{time:0s, loops:1}	keep order:false	N/A	N/A
20:55:13 [2021-06-01T20:55:13.069Z]       │ │ │ │ └─TableReader_122(Probe)	500000.00	500000	root		time:1.02s, loops:490, cop_task: {num: 1, max: 1.02s, proc_keys: 500000, tot_proc: 988ms, rpc_num: 1, rpc_time: 1.02s, copr_cache: disabled}	data:TableFullScan_121	20.0 MB	N/A
20:55:13 [2021-06-01T20:55:13.069Z]       │ │ │ │   └─TableFullScan_121	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:941ms, 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:55:13 [2021-06-01T20:55:13.069Z]       │ │ │ └─TableReader_128(Probe)	240004648.80	189670348	root		time:1m5.3s, loops:184598, cop_task: {num: 761, max: 2.45s, min: 356.6ms, avg: 1.49s, p95: 1.93s, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 17m47.1s, tot_wait: 56.3s, rpc_num: 761, rpc_time: 18m56.6s, copr_cache: disabled}	data:Selection_127	101.7 MB	N/A
20:55:13 [2021-06-01T20:55:13.069Z]       │ │ │   └─Selection_127	240004648.80	189670348	cop[tikv]		tikv_task:{proc max:1.3s, min:341ms, 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: 10452, read_count: 1114196, read_byte: 23.6 GB}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:55:13 [2021-06-01T20:55:13.069Z]       │ │ │     └─TableFullScan_126	300005811.00	300005811	cop[tikv]	table:l1	tikv_task:{proc max:1.21s, min:328ms, p80:1.08s, p95:1.13s, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:55:13 [2021-06-01T20:55:13.069Z]       │ │ └─TableReader_95(Probe)	0.49	3496188	root		time:1m36.1s, loops:3875, cop_task: {num: 5271, max: 479.3ms, min: 1.98ms, avg: 169.7ms, p95: 324.7ms, max_proc_keys: 3514, p95_proc_keys: 1959, tot_proc: 10m45.8s, tot_wait: 3m30.4s, rpc_num: 5271, rpc_time: 14m54.3s, copr_cache: disabled}	data:Selection_94	N/A	N/A
20:55:13 [2021-06-01T20:55:13.069Z]       │ │   └─Selection_94	0.49	3496188	cop[tikv]		tikv_task:{proc max:150ms, min:0s, p80:67ms, p95:80ms, iters:30274, tasks:5271}, scan_detail: {total_process_keys: 7236291, total_keys: 7795500, rocksdb: {delete_skipped_count: 0, key_skipped_count: 1778315, block: {cache_hit_count: 54006514, read_count: 218179, read_byte: 4.21 GB}}}	eq(tpch50.orders.o_orderstatus, "F")	N/A	N/A
20:55:13 [2021-06-01T20:55:13.069Z]       │ │     └─TableRangeScan_93	1.00	7236291	cop[tikv]	table:orders	tikv_task:{proc max:150ms, min:0s, p80:67ms, p95:79ms, iters:30274, tasks:5271}	range: decided by [tpch50.lineitem.l_orderkey], keep order:false	N/A	N/A
20:55:13 [2021-06-01T20:55:13.069Z]       │ └─IndexLookUp_80(Probe)	4.05	17316430	root		time:1m51.1s, loops:17130, index_task: {total_time: 1m1s, fetch_handle: 54.4s, build: 3.41ms, wait: 6.59s}, table_task: {total_time: 7m59.7s, num: 1458, concurrency: 760}		18.9 KB	N/A
20:55:13 [2021-06-01T20:55:13.069Z]       │   ├─IndexRangeScan_78(Build)	4.05	17316430	cop[tikv]	table:l2, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:52.1s, loops:18621, cop_task: {num: 2973, max: 665.7ms, min: 405.7µs, avg: 178.7ms, p95: 370.2ms, max_proc_keys: 13633, p95_proc_keys: 8809, tot_proc: 6m41.5s, tot_wait: 1m48.6s, rpc_num: 2973, rpc_time: 8m51.3s, copr_cache: disabled}, tikv_task:{proc max:180ms, min:0s, p80:93ms, p95:109ms, iters:30099, tasks:2973}, scan_detail: {total_process_keys: 17316430, total_keys: 20812526, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17316430, block: {cache_hit_count: 24259912, read_count: 225687, read_byte: 2.00 GB}}}	range: decided by [eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey)], keep order:false	N/A	N/A
20:55:13 [2021-06-01T20:55:13.069Z]       │   └─TableRowIDScan_79(Probe)	4.05	17316430	cop[tikv]	table:l2	time:5m54.5s, loops:20999, cop_task: {num: 7887, max: 576.8ms, min: 542.8µs, avg: 166.3ms, p95: 339.6ms, max_proc_keys: 12685, p95_proc_keys: 4887, tot_proc: 15m40.3s, tot_wait: 5m21s, rpc_num: 7887, rpc_time: 21m51.7s, copr_cache: disabled}, tikv_task:{proc max:273ms, min:0s, p80:101ms, p95:137ms, iters:50125, tasks:7887}, scan_detail: {total_process_keys: 17316430, total_keys: 18290504, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5634230, block: {cache_hit_count: 99017122, read_count: 1116, read_byte: 402.2 MB}}}	keep order:false	N/A	N/A
20:55:13 [2021-06-01T20:55:13.069Z]       └─IndexLookUp_39(Probe)	4.05	12022743	root		time:1m45.9s, loops:11951, index_task: {total_time: 58.3s, fetch_handle: 48.8s, build: 3.33ms, wait: 9.55s}, table_task: {total_time: 7m40.2s, num: 1410, concurrency: 735}		261.1 KB	N/A
20:55:13 [2021-06-01T20:55:13.070Z]         ├─IndexRangeScan_36(Build)	5.06	17183331	cop[tikv]	table:l3, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:46.5s, loops:18354, cop_task: {num: 2765, max: 686.2ms, min: 493.8µs, avg: 158ms, p95: 351.6ms, max_proc_keys: 18673, p95_proc_keys: 13873, tot_proc: 5m25.8s, tot_wait: 1m30.5s, rpc_num: 2765, rpc_time: 7m16.9s, copr_cache: disabled}, tikv_task:{proc max:180ms, min:0s, p80:77ms, p95:120ms, iters:29031, tasks:2765}, scan_detail: {total_process_keys: 17183331, total_keys: 20546345, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17183331, block: {cache_hit_count: 23553904, 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:55:13 [2021-06-01T20:55:13.070Z]         └─Selection_38(Probe)	4.05	12022743	cop[tikv]		time:5m53.7s, loops:13762, cop_task: {num: 10169, max: 626.4ms, min: 607.2µs, avg: 166ms, p95: 332.8ms, max_proc_keys: 7402, p95_proc_keys: 4023, tot_proc: 19m43.7s, tot_wait: 7m20.9s, rpc_num: 10169, rpc_time: 28m8.3s, copr_cache: disabled}, tikv_task:{proc max:203ms, min:0s, p80:74ms, p95:113ms, iters:60463, tasks:10169}, scan_detail: {total_process_keys: 17183331, total_keys: 18128637, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5525354, block: {cache_hit_count: 98288157, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:55:13 [2021-06-01T20:55:13.070Z]           └─TableRowIDScan_37	5.06	17183331	cop[tikv]	table:l3	tikv_task:{proc max:200ms, min:0s, p80:73ms, p95:112ms, iters:60463, tasks:10169}	keep order:false	N/A	N/A
20:55:13 [2021-06-01T20:55:13.070Z] + tiup cluster stop benchbot -y
20:55:13 [2021-06-01T20:55:13.070Z] Starting component `cluster`: /home/tidb/.tiup/components/cluster/v1.4.4/tiup-cluster stop benchbot -y
20:55:33 [2021-06-01T20:55:33.249Z] + rm -rf '/data1/tidb-deploy/*/log/*'
20:55:33 [2021-06-01T20:55:33.249Z] + rm -rf /data1/jenkins/deploy/data/tikv-20160
20:55:33 [2021-06-01T20:55:33.249Z] + rm -rf /data1/jenkins/deploy/data/pd-2379
20:55:33 [2021-06-01T20:55:33.249Z] + rm -rf /data1/jenkins/restore_data/tpch50/data/last_tikv.toml
20:55:33 [2021-06-01T20:55:33.249Z] + cp -R /data1/jenkins/restore_data/tpch50/data /data1/jenkins/deploy/data/tikv-20160
20:57:11 [2021-06-01T20:57:11.380Z] + cp -R /data1/jenkins/restore_data/tpch50/data.pd /data1/jenkins/deploy/data/pd-2379
20:57:11 [2021-06-01T20:57:11.380Z] + '[' -n '' ']'
20:57:11 [2021-06-01T20:57:11.380Z] + tiup cluster start benchbot --wait-timeout=300
20:57:11 [2021-06-01T20:57:11.380Z] Starting component `cluster`: /home/tidb/.tiup/components/cluster/v1.4.4/tiup-cluster start benchbot --wait-timeout=300
20:57:39 [2021-06-01T20:57:39.340Z] + sync
20:57:39 [2021-06-01T20:57:39.340Z] + /usr/bin/echo 3
20:58:29 [2021-06-01T20:58:29.047Z] + sync
20:58:29 [2021-06-01T20:58:29.047Z] + /usr/bin/echo 3
20:58:47 [2021-06-01T20:58:47.369Z] + sync
20:58:47 [2021-06-01T20:58:47.369Z] + /usr/bin/echo 3
20:59:22 [2021-06-01T20:59:22.597Z] 
20:59:22 [2021-06-01T20:59:22.597Z] queries/22.sql
20:59:22 [2021-06-01T20:59:22.597Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:59:22 [2021-06-01T20:59:22.597Z] Sort_39	1600000.00	4	root		time:26.9s, loops:2	Column#27	9.48 KB	0 Bytes
20:59:22 [2021-06-01T20:59:22.597Z] └─Projection_41	1600000.00	4	root		time:26.9s, loops:5, Concurrency:5	Column#27, Column#28, Column#29	23.7 KB	N/A
20:59:22 [2021-06-01T20:59:22.597Z]   └─HashAgg_42	1600000.00	4	root		time:26.9s, loops:5, partial_worker:{wall_time:26.883527275s, concurrency:5, task_num:180, tot_wait:2m14.362645154s, tot_exec:54.309761ms, tot_time:2m14.417095796s, max:26.883499245s, p95:26.883499245s}, final_worker:{wall_time:26.883575888s, concurrency:5, task_num:20, tot_wait:2m14.417254031s, tot_exec:311.21µs, tot_time:2m14.417572718s, max:26.883560372s, p95:26.883560372s}	group by:Column#33, funcs:count(1)->Column#28, funcs:sum(Column#31)->Column#29, funcs:firstrow(Column#32)->Column#27	857.7 KB	N/A
20:59:22 [2021-06-01T20:59:22.597Z]     └─Projection_51	1600000.00	181704	root		time:26.9s, loops:181, Concurrency:5	tpch50.customer.c_acctbal, substring(tpch50.customer.c_phone, 1, 2)->Column#32, substring(tpch50.customer.c_phone, 1, 2)->Column#33	693.6 KB	N/A
20:59:22 [2021-06-01T20:59:22.597Z]       └─HashJoin_43	1600000.00	181704	root		time:26.9s, loops:181, build_hash_table:{total:25.3s, fetch:1.06s, build:24.2s}, probe:{concurrency:5, total:2m14.4s, max:26.9s, probe:6.79s, fetch:2m7.6s}	anti semi join, equal:[eq(tpch50.customer.c_custkey, tpch50.orders.o_custkey)]	590.2 MB	0 Bytes
20:59:22 [2021-06-01T20:59:22.597Z]         ├─TableReader_49(Build)	75000000.00	75000000	root		time:1.07s, loops:73364, cop_task: {num: 153, max: 1s, min: 291.9ms, avg: 613.7ms, p95: 900.6ms, max_proc_keys: 723875, p95_proc_keys: 553332, tot_proc: 1m33.1s, tot_wait: 26ms, rpc_num: 153, rpc_time: 1m33.9s, copr_cache: disabled}	data:TableFullScan_48	54.1 MB	N/A
20:59:22 [2021-06-01T20:59:22.597Z]         │ └─TableFullScan_48	75000000.00	75000000	cop[tikv]	table:orders	tikv_task:{proc max:979ms, min:282ms, p80:627ms, p95:862ms, 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: 3026, read_count: 219927, read_byte: 4.30 GB}}}	keep order:false	N/A	N/A
20:59:22 [2021-06-01T20:59:22.597Z]         └─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:59:22 [2021-06-01T20:59:22.597Z]           └─TableReader_46	2000000.00	3407619	root		time:507.4ms, loops:3319, cop_task: {num: 18, max: 1.07s, min: 381.8ms, avg: 765.8ms, p95: 1.07s, max_proc_keys: 582617, p95_proc_keys: 582617, tot_proc: 13.4s, rpc_num: 18, rpc_time: 13.8s, copr_cache: disabled}	data:Selection_45	192.5 MB	N/A
20:59:22 [2021-06-01T20:59:22.597Z]             └─Selection_45	2000000.00	3407619	cop[tikv]		tikv_task:{proc max:1.02s, min:359ms, p80:871ms, 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:59:22 [2021-06-01T20:59:22.597Z]               └─TableFullScan_44	7500000.00	7500000	cop[tikv]	table:customer	tikv_task:{proc max:923ms, min:323ms, p80:800ms, p95:923ms, iters:7404, tasks:18}	keep order:false	N/A	N/A
20:59:22 [2021-06-01T20:59:22.597Z] 
20:59:22 [2021-06-01T20:59:22.597Z] queries/22.sql
20:59:22 [2021-06-01T20:59:22.597Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:59:22 [2021-06-01T20:59:22.597Z] Sort_39	2186432.06	4	root		time:26.3s, loops:2	Column#27	9.48 KB	0 Bytes
20:59:22 [2021-06-01T20:59:22.597Z] └─Projection_41	2186432.06	4	root		time:26.3s, loops:5, Concurrency:5	Column#27, Column#28, Column#29	23.7 KB	N/A
20:59:22 [2021-06-01T20:59:22.598Z]   └─HashAgg_42	2186432.06	4	root		time:26.3s, loops:5, partial_worker:{wall_time:26.319349141s, concurrency:5, task_num:181, tot_wait:2m11.54371173s, tot_exec:52.121278ms, tot_time:2m11.595952687s, max:26.319318314s, p95:26.319318314s}, final_worker:{wall_time:26.319355734s, concurrency:5, task_num:20, tot_wait:2m11.596483102s, tot_exec:180.626µs, tot_time:2m11.59667248s, max:26.319338953s, p95:26.319338953s}	group by:Column#33, funcs:count(1)->Column#28, funcs:sum(Column#31)->Column#29, funcs:firstrow(Column#32)->Column#27	857.7 KB	N/A
20:59:22 [2021-06-01T20:59:22.598Z]     └─Projection_51	2186432.06	181704	root		time:26.3s, 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:59:22 [2021-06-01T20:59:22.598Z]       └─HashJoin_43	2186432.06	181704	root		time:26.3s, loops:182, build_hash_table:{total:24.9s, fetch:996.6ms, build:23.9s}, probe:{concurrency:5, total:2m11.6s, max:26.3s, probe:5.71s, fetch:2m5.9s}	anti semi join, equal:[eq(tpch50.customer.c_custkey, tpch50.orders.o_custkey)]	590.2 MB	0 Bytes
20:59:22 [2021-06-01T20:59:22.598Z]         ├─TableReader_49(Build)	75000000.00	75000000	root		time:1.01s, loops:73364, cop_task: {num: 153, max: 1.13s, min: 230.1ms, avg: 533.7ms, p95: 872.8ms, max_proc_keys: 723875, p95_proc_keys: 553332, tot_proc: 1m20.8s, tot_wait: 31ms, rpc_num: 153, rpc_time: 1m21.6s, copr_cache: disabled}	data:TableFullScan_48	57.8 MB	N/A
20:59:22 [2021-06-01T20:59:22.598Z]         │ └─TableFullScan_48	75000000.00	75000000	cop[tikv]	table:orders	tikv_task:{proc max:1.11s, min:214ms, p80:557ms, p95:834ms, iters:73975, tasks:153}, scan_detail: {total_process_keys: 75000000, total_keys: 75000153, rocksdb: {delete_skipped_count: 0, key_skipped_count: 149999847, block: {cache_hit_count: 220923, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:59:22 [2021-06-01T20:59:22.598Z]         └─Selection_47(Probe)	2733040.07	545246	root		time:1.39s, loops:534	in(substring(tpch50.customer.c_phone, 1, 2), "20", "40", "22", "30", "39", "42", "21")	94.6 KB	N/A
20:59:22 [2021-06-01T20:59:22.610Z]           └─TableReader_46	2733040.07	3407619	root		time:569.4ms, loops:3319, cop_task: {num: 18, max: 1.25s, min: 437.3ms, avg: 842.7ms, p95: 1.25s, 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:59:22 [2021-06-01T20:59:22.610Z]             └─Selection_45	2733040.07	3407619	cop[tikv]		tikv_task:{proc max:1.18s, min:399ms, p80:982ms, p95:1.18s, iters:7404, tasks:18}, scan_detail: {total_process_keys: 7500000, total_keys: 7500018, rocksdb: {delete_skipped_count: 0, key_skipped_count: 14999982, block: {cache_hit_count: 28451, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.customer.c_acctbal, 5000.602894)	N/A	N/A
20:59:22 [2021-06-01T20:59:22.610Z]               └─TableFullScan_44	7500000.00	7500000	cop[tikv]	table:customer	tikv_task:{proc max:1.07s, min:371ms, p80:908ms, p95:1.07s, iters:7404, tasks:18}	keep order:false	N/A	N/A
20:59:22 [2021-06-01T20:59:22.610Z] 
20:59:22 [2021-06-01T20:59:22.610Z] queries/22.sql
20:59:22 [2021-06-01T20:59:22.610Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:59:22 [2021-06-01T20:59:22.610Z] Sort_39	2186432.06	4	root		time:26.5s, loops:2	Column#27	9.48 KB	0 Bytes
20:59:22 [2021-06-01T20:59:22.610Z] └─Projection_41	2186432.06	4	root		time:26.5s, loops:5, Concurrency:5	Column#27, Column#28, Column#29	23.7 KB	N/A
20:59:22 [2021-06-01T20:59:22.610Z]   └─HashAgg_42	2186432.06	4	root		time:26.5s, loops:5, partial_worker:{wall_time:26.477423089s, concurrency:5, task_num:179, tot_wait:2m12.340054042s, tot_exec:45.900377ms, tot_time:2m12.386117098s, max:26.47737304s, p95:26.47737304s}, final_worker:{wall_time:26.477443368s, concurrency:5, task_num:20, tot_wait:2m12.386776508s, tot_exec:162.669µs, tot_time:2m12.386959287s, max:26.477405365s, p95:26.477405365s}	group by:Column#33, funcs:count(1)->Column#28, funcs:sum(Column#31)->Column#29, funcs:firstrow(Column#32)->Column#27	857.7 KB	N/A
20:59:22 [2021-06-01T20:59:22.610Z]     └─Projection_51	2186432.06	181704	root		time:26.5s, loops:180, Concurrency:5	tpch50.customer.c_acctbal, substring(tpch50.customer.c_phone, 1, 2)->Column#32, substring(tpch50.customer.c_phone, 1, 2)->Column#33	693.6 KB	N/A
20:59:22 [2021-06-01T20:59:22.610Z]       └─HashJoin_43	2186432.06	181704	root		time:26.5s, loops:180, build_hash_table:{total:25.1s, fetch:998.1ms, build:24.1s}, probe:{concurrency:5, total:2m12.4s, max:26.5s, probe:5.74s, fetch:2m6.6s}	anti semi join, equal:[eq(tpch50.customer.c_custkey, tpch50.orders.o_custkey)]	590.2 MB	0 Bytes
20:59:22 [2021-06-01T20:59:22.610Z]         ├─TableReader_49(Build)	75000000.00	75000000	root		time:1.03s, loops:73364, cop_task: {num: 153, max: 946.4ms, min: 218.7ms, avg: 515.3ms, p95: 840.8ms, max_proc_keys: 723875, p95_proc_keys: 553332, tot_proc: 1m18.1s, tot_wait: 29ms, rpc_num: 153, rpc_time: 1m18.8s, copr_cache: disabled}	data:TableFullScan_48	57.8 MB	N/A
20:59:22 [2021-06-01T20:59:22.610Z]         │ └─TableFullScan_48	75000000.00	75000000	cop[tikv]	table:orders	tikv_task:{proc max:915ms, min:208ms, p80:525ms, p95:796ms, iters:73975, tasks:153}, scan_detail: {total_process_keys: 75000000, total_keys: 75000153, rocksdb: {delete_skipped_count: 0, key_skipped_count: 149999847, block: {cache_hit_count: 220923, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:59:22 [2021-06-01T20:59:22.610Z]         └─Selection_47(Probe)	2733040.07	545246	root		time:1.3s, loops:534	in(substring(tpch50.customer.c_phone, 1, 2), "20", "40", "22", "30", "39", "42", "21")	94.6 KB	N/A
20:59:22 [2021-06-01T20:59:22.610Z]           └─TableReader_46	2733040.07	3407619	root		time:543.6ms, loops:3319, cop_task: {num: 18, max: 1.23s, min: 433.8ms, avg: 880.8ms, p95: 1.23s, max_proc_keys: 582617, p95_proc_keys: 582617, tot_proc: 15.4s, rpc_num: 18, rpc_time: 15.9s, copr_cache: disabled}	data:Selection_45	192.5 MB	N/A
20:59:22 [2021-06-01T20:59:22.610Z]             └─Selection_45	2733040.07	3407619	cop[tikv]		tikv_task:{proc max:1.15s, min:403ms, p80:995ms, p95:1.15s, iters:7404, tasks:18}, scan_detail: {total_process_keys: 7500000, total_keys: 7500018, rocksdb: {delete_skipped_count: 0, key_skipped_count: 14999982, block: {cache_hit_count: 28451, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.customer.c_acctbal, 5000.602894)	N/A	N/A
20:59:22 [2021-06-01T20:59:22.610Z]               └─TableFullScan_44	7500000.00	7500000	cop[tikv]	table:customer	tikv_task:{proc max:1.07s, min:375ms, p80:926ms, p95:1.07s, iters:7404, tasks:18}	keep order:false	N/A	N/A
20:59:22 [2021-06-01T20:59:22.610Z] + sync
20:59:22 [2021-06-01T20:59:22.610Z] + /usr/bin/echo 3
20:59:55 [2021-06-01T20:59:55.948Z] + sync
20:59:55 [2021-06-01T20:59:55.948Z] + /usr/bin/echo 3
21:00:14 [2021-06-01T21:00:14.180Z] + sync
21:00:14 [2021-06-01T21:00:14.180Z] + /usr/bin/echo 3
21:00:46 [2021-06-01T21:00:46.701Z] 
21:00:46 [2021-06-01T21:00:46.701Z] queries/22.sql
21:00:46 [2021-06-01T21:00:46.701Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
21:00:46 [2021-06-01T21:00:46.701Z] Sort_39	2186432.06	4	root		time:26.1s, loops:2	Column#27	9.48 KB	0 Bytes
21:00:46 [2021-06-01T21:00:46.701Z] └─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:46 [2021-06-01T21:00:46.701Z]   └─HashAgg_42	2186432.06	4	root		time:26.1s, loops:5, partial_worker:{wall_time:26.112325459s, concurrency:5, task_num:180, tot_wait:2m10.504438834s, tot_exec:56.311685ms, tot_time:2m10.560857054s, max:26.112303568s, p95:26.112303568s}, final_worker:{wall_time:26.112357046s, concurrency:5, task_num:20, tot_wait:2m10.561336542s, tot_exec:176.514µs, tot_time:2m10.5615206s, max:26.112310239s, p95:26.112310239s}	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:46 [2021-06-01T21:00:46.701Z]     └─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:46 [2021-06-01T21:00:46.701Z]       └─HashJoin_43	2186432.06	181704	root		time:26.1s, loops:181, build_hash_table:{total:24.6s, fetch:1.03s, build:23.6s}, probe:{concurrency:5, total:2m10.5s, max:26.1s, probe:5.97s, fetch:2m4.6s}	anti semi join, equal:[eq(tpch50.customer.c_custkey, tpch50.orders.o_custkey)]	590.2 MB	0 Bytes
21:00:46 [2021-06-01T21:00:46.701Z]         ├─TableReader_49(Build)	75000000.00	75000000	root		time:1.05s, loops:73364, cop_task: {num: 153, max: 993.4ms, min: 235.7ms, avg: 518.9ms, p95: 878.5ms, max_proc_keys: 723875, p95_proc_keys: 553332, tot_proc: 1m18.6s, tot_wait: 26ms, rpc_num: 153, rpc_time: 1m19.4s, copr_cache: disabled}	data:TableFullScan_48	54.1 MB	N/A
21:00:46 [2021-06-01T21:00:46.701Z]         │ └─TableFullScan_48	75000000.00	75000000	cop[tikv]	table:orders	tikv_task:{proc max:960ms, min:225ms, p80:508ms, p95:846ms, 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:46 [2021-06-01T21:00:46.701Z]         └─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:46 [2021-06-01T21:00:46.701Z]           └─TableReader_46	2733040.07	3407619	root		time:604.5ms, loops:3319, cop_task: {num: 18, max: 1.17s, min: 478.1ms, avg: 841.9ms, p95: 1.17s, 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:46 [2021-06-01T21:00:46.701Z]             └─Selection_45	2733040.07	3407619	cop[tikv]		tikv_task:{proc max:1.12s, min:439ms, p80:926ms, p95:1.12s, iters:7404, tasks:18}, scan_detail: {total_process_keys: 7500000, total_keys: 7500018, rocksdb: {delete_skipped_count: 0, key_skipped_count: 14999982, block: {cache_hit_count: 28451, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.customer.c_acctbal, 5000.602894)	N/A	N/A
21:00:46 [2021-06-01T21:00:46.701Z]               └─TableFullScan_44	7500000.00	7500000	cop[tikv]	table:customer	tikv_task:{proc max:1.05s, min:406ms, p80:864ms, p95:1.05s, iters:7404, tasks:18}	keep order:false	N/A	N/A
21:00:46 [2021-06-01T21:00:46.701Z] 
21:00:46 [2021-06-01T21:00:46.701Z] queries/22.sql
21:00:46 [2021-06-01T21:00:46.701Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
21:00:46 [2021-06-01T21:00:46.701Z] Sort_39	2186432.06	4	root		time:25.8s, loops:2	Column#27	9.48 KB	0 Bytes
21:00:46 [2021-06-01T21:00:46.701Z] └─Projection_41	2186432.06	4	root		time:25.8s, loops:5, Concurrency:5	Column#27, Column#28, Column#29	23.7 KB	N/A
21:00:46 [2021-06-01T21:00:46.701Z]   └─HashAgg_42	2186432.06	4	root		time:25.8s, loops:5, partial_worker:{wall_time:25.799916115s, concurrency:5, task_num:180, tot_wait:2m8.944800484s, tot_exec:54.21805ms, tot_time:2m8.999165888s, max:25.799871952s, p95:25.799871952s}, final_worker:{wall_time:25.799959684s, concurrency:5, task_num:20, tot_wait:2m8.999282314s, tot_exec:264.243µs, tot_time:2m8.999556208s, max:25.799923491s, p95:25.799923491s}	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:46 [2021-06-01T21:00:46.701Z]     └─Projection_51	2186432.06	181704	root		time:25.8s, loops:181, Concurrency:5	tpch50.customer.c_acctbal, substring(tpch50.customer.c_phone, 1, 2)->Column#32, substring(tpch50.customer.c_phone, 1, 2)->Column#33	693.6 KB	N/A
21:00:46 [2021-06-01T21:00:46.701Z]       └─HashJoin_43	2186432.06	181704	root		time:25.8s, loops:181, build_hash_table:{total:24.4s, fetch:1.05s, build:23.4s}, probe:{concurrency:5, total:2m9s, max:25.8s, probe:5.48s, fetch:2m3.5s}	anti semi join, equal:[eq(tpch50.customer.c_custkey, tpch50.orders.o_custkey)]	590.2 MB	0 Bytes
21:00:46 [2021-06-01T21:00:46.701Z]         ├─TableReader_49(Build)	75000000.00	75000000	root		time:1.05s, loops:73364, cop_task: {num: 153, max: 990.1ms, min: 235ms, avg: 516.6ms, p95: 909.9ms, max_proc_keys: 723875, p95_proc_keys: 553332, tot_proc: 1m18.3s, tot_wait: 36ms, rpc_num: 153, rpc_time: 1m19s, copr_cache: disabled}	data:TableFullScan_48	57.8 MB	N/A
21:00:46 [2021-06-01T21:00:46.701Z]         │ └─TableFullScan_48	75000000.00	75000000	cop[tikv]	table:orders	tikv_task:{proc max:953ms, min:223ms, p80:512ms, p95:881ms, 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:46 [2021-06-01T21:00:46.701Z]         └─Selection_47(Probe)	2733040.07	545246	root		time:1.39s, loops:534	in(substring(tpch50.customer.c_phone, 1, 2), "20", "40", "22", "30", "39", "42", "21")	94.6 KB	N/A
21:00:46 [2021-06-01T21:00:46.701Z]           └─TableReader_46	2733040.07	3407619	root		time:531.8ms, loops:3319, cop_task: {num: 18, max: 1.2s, min: 371.6ms, avg: 837.1ms, p95: 1.2s, max_proc_keys: 582617, p95_proc_keys: 582617, tot_proc: 14.6s, rpc_num: 18, rpc_time: 15.1s, copr_cache: disabled}	data:Selection_45	192.5 MB	N/A
21:00:46 [2021-06-01T21:00:46.701Z]             └─Selection_45	2733040.07	3407619	cop[tikv]		tikv_task:{proc max:1.13s, min:342ms, p80:976ms, p95:1.13s, iters:7404, tasks:18}, scan_detail: {total_process_keys: 7500000, total_keys: 7500018, rocksdb: {delete_skipped_count: 0, key_skipped_count: 14999982, block: {cache_hit_count: 28451, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.customer.c_acctbal, 5000.602894)	N/A	N/A
21:00:46 [2021-06-01T21:00:46.701Z]               └─TableFullScan_44	7500000.00	7500000	cop[tikv]	table:customer	tikv_task:{proc max:1.03s, min:309ms, p80:900ms, p95:1.03s, iters:7404, tasks:18}	keep order:false	N/A	N/A
21:00:46 [2021-06-01T21:00:46.701Z] 
21:00:46 [2021-06-01T21:00:46.701Z] queries/22.sql
21:00:46 [2021-06-01T21:00:46.701Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
21:00:46 [2021-06-01T21:00:46.701Z] Sort_39	2186432.06	4	root		time:26s, loops:2	Column#27	9.48 KB	0 Bytes
21:00:46 [2021-06-01T21:00:46.701Z] └─Projection_41	2186432.06	4	root		time:26s, loops:5, Concurrency:5	Column#27, Column#28, Column#29	23.7 KB	N/A
21:00:46 [2021-06-01T21:00:46.701Z]   └─HashAgg_42	2186432.06	4	root		time:26s, loops:5, partial_worker:{wall_time:26.040227692s, concurrency:5, task_num:180, tot_wait:2m10.150306247s, tot_exec:49.566206ms, tot_time:2m10.199992703s, max:26.040135406s, p95:26.040135406s}, final_worker:{wall_time:26.040250817s, concurrency:5, task_num:20, tot_wait:2m10.200597664s, tot_exec:202.906µs, tot_time:2m10.200807558s, max:26.040167824s, p95:26.040167824s}	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:46 [2021-06-01T21:00:46.701Z]     └─Projection_51	2186432.06	181704	root		time:26s, loops:181, Concurrency:5	tpch50.customer.c_acctbal, substring(tpch50.customer.c_phone, 1, 2)->Column#32, substring(tpch50.customer.c_phone, 1, 2)->Column#33	693.6 KB	N/A
21:00:46 [2021-06-01T21:00:46.701Z]       └─HashJoin_43	2186432.06	181704	root		time:26s, loops:181, build_hash_table:{total:24.6s, fetch:886.6ms, build:23.8s}, probe:{concurrency:5, total:2m10.2s, max:26s, probe:5.51s, fetch:2m4.7s}	anti semi join, equal:[eq(tpch50.customer.c_custkey, tpch50.orders.o_custkey)]	590.2 MB	0 Bytes
21:00:46 [2021-06-01T21:00:46.701Z]         ├─TableReader_49(Build)	75000000.00	75000000	root		time:875.4ms, loops:73364, cop_task: {num: 153, max: 969.7ms, min: 228.8ms, avg: 525.8ms, p95: 870.7ms, max_proc_keys: 723875, p95_proc_keys: 553332, tot_proc: 1m19.6s, tot_wait: 24ms, rpc_num: 153, rpc_time: 1m20.4s, copr_cache: disabled}	data:TableFullScan_48	57.8 MB	N/A
21:00:46 [2021-06-01T21:00:46.701Z]         │ └─TableFullScan_48	75000000.00	75000000	cop[tikv]	table:orders	tikv_task:{proc max:940ms, min:219ms, p80:535ms, p95:834ms, 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:46 [2021-06-01T21:00:46.701Z]         └─Selection_47(Probe)	2733040.07	545246	root		time:1.41s, loops:534	in(substring(tpch50.customer.c_phone, 1, 2), "20", "40", "22", "30", "39", "42", "21")	94.6 KB	N/A
21:00:46 [2021-06-01T21:00:46.701Z]           └─TableReader_46	2733040.07	3407619	root		time:582.4ms, loops:3319, cop_task: {num: 18, max: 1.23s, min: 389.6ms, avg: 879.6ms, p95: 1.23s, max_proc_keys: 582617, p95_proc_keys: 582617, tot_proc: 15.4s, tot_wait: 3ms, rpc_num: 18, rpc_time: 15.8s, copr_cache: disabled}	data:Selection_45	192.5 MB	N/A
21:00:46 [2021-06-01T21:00:46.701Z]             └─Selection_45	2733040.07	3407619	cop[tikv]		tikv_task:{proc max:1.14s, min:362ms, p80:1s, p95:1.14s, iters:7404, tasks:18}, scan_detail: {total_process_keys: 7500000, total_keys: 7500018, rocksdb: {delete_skipped_count: 0, key_skipped_count: 14999982, block: {cache_hit_count: 28451, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.customer.c_acctbal, 5000.602894)	N/A	N/A
21:00:46 [2021-06-01T21:00:46.701Z]               └─TableFullScan_44	7500000.00	7500000	cop[tikv]	table:customer	tikv_task:{proc max:1.06s, min:338ms, p80:910ms, p95:1.06s, iters:7404, tasks:18}	keep order:false	N/A	N/A
21:00:46 [2021-06-01T21:00:46.701Z] + sync
21:00:46 [2021-06-01T21:00:46.701Z] + /usr/bin/echo 3
21:02:09 [2021-06-01T21:02:09.039Z] 
21:02:09 [2021-06-01T21:02:09.039Z] queries/22.sql
21:02:09 [2021-06-01T21:02:09.039Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
21:02:09 [2021-06-01T21:02:09.039Z] Sort_39	2186432.06	4	root		time:25.3s, loops:2	Column#27	9.48 KB	0 Bytes
21:02:09 [2021-06-01T21:02:09.039Z] └─Projection_41	2186432.06	4	root		time:25.3s, loops:5, Concurrency:5	Column#27, Column#28, Column#29	23.7 KB	N/A
21:02:09 [2021-06-01T21:02:09.039Z]   └─HashAgg_42	2186432.06	4	root		time:25.3s, loops:5, partial_worker:{wall_time:25.307582513s, concurrency:5, task_num:180, tot_wait:2m6.482234824s, tot_exec:54.780149ms, tot_time:2m6.537129849s, max:25.307528585s, p95:25.307528585s}, final_worker:{wall_time:25.307601644s, concurrency:5, task_num:20, tot_wait:2m6.537494456s, tot_exec:209.485µs, tot_time:2m6.537728165s, max:25.307557814s, p95:25.307557814s}	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:02:09 [2021-06-01T21:02:09.039Z]     └─Projection_51	2186432.06	181704	root		time:25.3s, loops:181, Concurrency:5	tpch50.customer.c_acctbal, substring(tpch50.customer.c_phone, 1, 2)->Column#32, substring(tpch50.customer.c_phone, 1, 2)->Column#33	693.6 KB	N/A
21:02:09 [2021-06-01T21:02:09.039Z]       └─HashJoin_43	2186432.06	181704	root		time:25.3s, loops:181, build_hash_table:{total:23.8s, fetch:837.6ms, build:22.9s}, probe:{concurrency:5, total:2m6.5s, max:25.3s, probe:5.99s, fetch:2m0.5s}	anti semi join, equal:[eq(tpch50.customer.c_custkey, tpch50.orders.o_custkey)]	590.2 MB	0 Bytes
21:02:09 [2021-06-01T21:02:09.039Z]         ├─TableReader_49(Build)	75000000.00	75000000	root		time:838.2ms, loops:73364, cop_task: {num: 153, max: 999.9ms, min: 260.7ms, avg: 516.5ms, p95: 930.3ms, max_proc_keys: 723875, p95_proc_keys: 553332, tot_proc: 1m18.2s, tot_wait: 42ms, rpc_num: 153, rpc_time: 1m19s, copr_cache: disabled}	data:TableFullScan_48	57.8 MB	N/A
21:02:09 [2021-06-01T21:02:09.039Z]         │ └─TableFullScan_48	75000000.00	75000000	cop[tikv]	table:orders	tikv_task:{proc max:978ms, min:251ms, p80:517ms, p95:865ms, 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:02:09 [2021-06-01T21:02:09.039Z]         └─Selection_47(Probe)	2733040.07	545246	root		time:1.53s, loops:534	in(substring(tpch50.customer.c_phone, 1, 2), "20", "40", "22", "30", "39", "42", "21")	94.6 KB	N/A
21:02:09 [2021-06-01T21:02:09.039Z]           └─TableReader_46	2733040.07	3407619	root		time:647.8ms, loops:3319, cop_task: {num: 18, max: 1.13s, min: 475.2ms, avg: 857.4ms, p95: 1.13s, max_proc_keys: 582617, p95_proc_keys: 582617, tot_proc: 15s, tot_wait: 1ms, rpc_num: 18, rpc_time: 15.4s, copr_cache: disabled}	data:Selection_45	192.5 MB	N/A
21:02:09 [2021-06-01T21:02:09.039Z]             └─Selection_45	2733040.07	3407619	cop[tikv]		tikv_task:{proc max:1.07s, min:444ms, p80:974ms, p95:1.07s, 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:02:09 [2021-06-01T21:02:09.039Z]               └─TableFullScan_44	7500000.00	7500000	cop[tikv]	table:customer	tikv_task:{proc max:988ms, min:400ms, p80:892ms, p95:988ms, iters:7404, tasks:18}	keep order:false	N/A	N/A
21:02:09 [2021-06-01T21:02:09.039Z] 
21:02:09 [2021-06-01T21:02:09.039Z] + tiup cluster stop benchbot
21:02:09 [2021-06-01T21:02:09.039Z] Starting component `cluster`: /home/tidb/.tiup/components/cluster/v1.4.4/tiup-cluster stop benchbot
21:02:09 [2021-06-01T21:02:09.039Z] + [ 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:02:09 [2021-06-01T21:02:09.039Z] + [Parallel] - UserSSH: user=tidb, host=172.16.5.86
21:02:09 [2021-06-01T21:02:09.039Z] + [Parallel] - UserSSH: user=tidb, host=172.16.5.86
21:02:09 [2021-06-01T21:02:09.039Z] + [Parallel] - UserSSH: user=tidb, host=172.16.5.86
21:02:09 [2021-06-01T21:02:09.039Z] + [Parallel] - UserSSH: user=tidb, host=172.16.5.86
21:02:09 [2021-06-01T21:02:09.039Z] + [Parallel] - UserSSH: user=tidb, host=172.16.5.86
21:02:09 [2021-06-01T21:02:09.039Z] + [ Serial ] - StopCluster
21:02:09 [2021-06-01T21:02:09.039Z] Stopping component grafana
21:02:09 [2021-06-01T21:02:09.039Z] 	Stopping instance 172.16.5.86
21:02:09 [2021-06-01T21:02:09.039Z] 	Stop grafana 172.16.5.86:3000 success
21:02:09 [2021-06-01T21:02:09.039Z] Stopping component prometheus
21:02:09 [2021-06-01T21:02:09.039Z] 	Stopping instance 172.16.5.86
21:02:09 [2021-06-01T21:02:09.039Z] 	Stop prometheus 172.16.5.86:9090 success
21:02:09 [2021-06-01T21:02:09.039Z] Stopping component tidb
21:02:09 [2021-06-01T21:02:09.039Z] 	Stopping instance 172.16.5.86
21:02:09 [2021-06-01T21:02:09.039Z] 	Stop tidb 172.16.5.86:4000 success
21:02:09 [2021-06-01T21:02:09.039Z] Stopping component tikv
21:02:09 [2021-06-01T21:02:09.039Z] 	Stopping instance 172.16.5.86
21:02:09 [2021-06-01T21:02:09.039Z] 	Stop tikv 172.16.5.86:20160 success
21:02:09 [2021-06-01T21:02:09.039Z] Stopping component pd
21:02:09 [2021-06-01T21:02:09.039Z] 	Stopping instance 172.16.5.86
21:02:09 [2021-06-01T21:02:09.039Z] 	Stop pd 172.16.5.86:2379 success
21:02:09 [2021-06-01T21:02:09.039Z] Stopping component node_exporter
21:02:09 [2021-06-01T21:02:09.039Z] Stopping component blackbox_exporter
21:02:09 [2021-06-01T21:02:09.039Z] Stopped cluster `benchbot` successfully
21:02:09 [2021-06-01T21:02:09.070Z] [Pipeline] sh
21:02:09 [2021-06-01T21:02:09.391Z] + cat bench_result
21:02:09 [2021-06-01T21:02:09.396Z] [Pipeline] }
21:02:09 [2021-06-01T21:02:09.397Z] [Pipeline] // dir
21:02:09 [2021-06-01T21:02:09.399Z] [Pipeline] }
21:02:09 [2021-06-01T21:02:09.400Z] [Pipeline] // stage
21:02:09 [2021-06-01T21:02:09.402Z] [Pipeline] }
21:02:09 [2021-06-01T21:02:09.403Z] [Pipeline] // node
21:02:09 [2021-06-01T21:02:09.406Z] [Pipeline] }
21:02:09 [2021-06-01T21:02:09.407Z] [Pipeline] // catchError
21:02:09 [2021-06-01T21:02:09.412Z] [Pipeline] stage
21:02:09 [2021-06-01T21:02:09.416Z] [Pipeline] { (Summary)
21:02:09 [2021-06-01T21:02:09.452Z] sh: line 1: 57779 Terminated              sleep 3
21:02:09 [2021-06-01T21:02:09.428Z] [Pipeline] slackSend
21:02:09 [2021-06-01T21:02:09.429Z] 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:02:10 [2021-06-01T21:02:10.016Z] [Pipeline] }
21:02:10 [2021-06-01T21:02:10.018Z] [Pipeline] // stage
21:02:10 [2021-06-01T21:02:10.020Z] [Pipeline] End of Pipeline
21:02:10 [2021-06-01T21:02:10.034Z] Finished: SUCCESS