SuccessConsole Output

Skipping 1,193 KB.. Full Log
supp.ps_suppkey)->tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_availqty)->tpch50.partsupp.ps_availqty, funcs:sum(tpch50.lineitem.l_quantity)->Column#44	194.5 MB	N/A
20:41:06 [2021-05-30T20:41:06.720Z]         └─HashJoin_59	9711455.06	634004	root		time:43.9s, loops:624, build_hash_table:{total:3.14s, fetch:2.93s, build:203.9ms}, probe:{concurrency:5, total:3m39.4s, max:43.9s, probe:15.3s, fetch:3m24.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:41:06 [2021-05-30T20:41:06.720Z]           ├─IndexHashJoin_67(Build)	321865.05	435528	root		time:3.09s, loops:430, inner:{total:3.62s, concurrency:5, task:12, construct:136.8ms, fetch:3.14s, build:30ms, join:342.6ms}	inner join, inner:IndexLookUp_64, outer key:tpch50.part.p_partkey, inner key:tpch50.partsupp.ps_partkey, equal cond:eq(tpch50.part.p_partkey, tpch50.partsupp.ps_partkey)	20.5 MB	N/A
20:41:06 [2021-05-30T20:41:06.720Z]           │ ├─TableReader_96(Build)	80007.93	108882	root		time:2.62s, loops:112, cop_task: {num: 20, max: 1.73s, min: 607.9ms, avg: 1.33s, p95: 1.73s, max_proc_keys: 686055, p95_proc_keys: 686055, tot_proc: 26.5s, tot_wait: 15ms, rpc_num: 20, rpc_time: 26.6s, copr_cache: disabled}	data:Selection_95	665.9 KB	N/A
20:41:06 [2021-05-30T20:41:06.720Z]           │ │ └─Selection_95	80007.93	108882	cop[tikv]		tikv_task:{proc max:1.69s, min:602ms, p80:1.62s, p95:1.69s, iters:9859, tasks:20}, scan_detail: {total_process_keys: 10000000, total_keys: 10000020, rocksdb: {delete_skipped_count: 0, key_skipped_count: 19999980, block: {cache_hit_count: 31499, read_count: 0, read_byte: 0 Bytes}}}	like(tpch50.part.p_name, "green%", 92)	N/A	N/A
20:41:06 [2021-05-30T20:41:06.720Z]           │ │   └─TableFullScan_94	10000000.00	10000000	cop[tikv]	table:part	tikv_task:{proc max:1.56s, min:566ms, p80:1.52s, p95:1.56s, iters:9859, tasks:20}	keep order:false	N/A	N/A
20:41:06 [2021-05-30T20:41:06.720Z]           │ └─IndexLookUp_64(Probe)	4.02	435528	root		time:3.04s, loops:447, index_task: {total_time: 2.06s, fetch_handle: 2.06s, build: 97.3µs, wait: 287.2µs}, table_task: {total_time: 12.1s, num: 56, concurrency: 60}		19.4 KB	N/A
20:41:06 [2021-05-30T20:41:06.720Z]           │   ├─IndexRangeScan_62(Build)	4.02	435528	cop[tikv]	table:partsupp, index:PRIMARY(PS_PARTKEY, PS_SUPPKEY)	time:2.02s, loops:477, cop_task: {num: 57, max: 399.4ms, min: 7.34ms, avg: 122.4ms, p95: 334.5ms, max_proc_keys: 15288, p95_proc_keys: 15048, tot_proc: 6.44s, tot_wait: 34ms, rpc_num: 57, rpc_time: 6.98s, copr_cache: disabled}, tikv_task:{proc max:391ms, min:6ms, p80:166ms, p95:309ms, iters:681, tasks:57}, scan_detail: {total_process_keys: 435528, total_keys: 544410, rocksdb: {delete_skipped_count: 0, key_skipped_count: 435528, block: {cache_hit_count: 980292, read_count: 0, read_byte: 0 Bytes}}}	range: decided by [eq(tpch50.partsupp.ps_partkey, tpch50.part.p_partkey)], keep order:false	N/A	N/A
20:41:06 [2021-05-30T20:41:06.720Z]           │   └─TableRowIDScan_63(Probe)	4.02	435528	cop[tikv]	table:partsupp	time:3.55s, loops:503, cop_task: {num: 1480, max: 148ms, min: 636.3µs, avg: 23.1ms, p95: 48.7ms, max_proc_keys: 868, p95_proc_keys: 524, tot_proc: 26.8s, tot_wait: 5s, rpc_num: 1480, rpc_time: 34.2s, copr_cache: disabled}, tikv_task:{proc max:83ms, min:0s, p80:23ms, p95:34ms, iters:5449, tasks:1480}, scan_detail: {total_process_keys: 435528, total_keys: 473496, rocksdb: {delete_skipped_count: 0, key_skipped_count: 194032, block: {cache_hit_count: 3644525, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:41:06 [2021-05-30T20:41:06.720Z]           └─TableReader_101(Probe)	46310896.67	45504356	root		time:38.6s, loops:44289, cop_task: {num: 761, max: 1.41s, min: 296.6ms, avg: 815.1ms, p95: 1.1s, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 10m16.9s, tot_wait: 145ms, rpc_num: 761, rpc_time: 10m20.3s, copr_cache: disabled}	data:Selection_100	52.6 MB	N/A
20:41:06 [2021-05-30T20:41:06.720Z]             └─Selection_100	46310896.67	45504356	cop[tikv]		tikv_task:{proc max:1.31s, min:289ms, p80:907ms, p95:1.08s, iters:296606, tasks:761}, scan_detail: {total_process_keys: 300005811, total_keys: 300006572, rocksdb: {delete_skipped_count: 0, key_skipped_count: 600010861, block: {cache_hit_count: 1124648, read_count: 0, read_byte: 0 Bytes}}}	ge(tpch50.lineitem.l_shipdate, 1993-01-01 00:00:00.000000), lt(tpch50.lineitem.l_shipdate, 1994-01-01)	N/A	N/A
20:41:06 [2021-05-30T20:41:06.720Z]               └─TableFullScan_99	300005811.00	300005811	cop[tikv]	table:lineitem	tikv_task:{proc max:1.27s, min:280ms, p80:875ms, p95:1.05s, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:41:06 [2021-05-30T20:41:06.720Z] + sync
20:41:06 [2021-05-30T20:41:06.720Z] + /usr/bin/echo 3
20:41:49 [2021-05-30T20:41:49.433Z] + sync
20:41:49 [2021-05-30T20:41:49.433Z] + /usr/bin/echo 3
20:42:31 [2021-05-30T20:42:31.019Z] 
20:42:31 [2021-05-30T20:42:31.019Z] queries/20.sql
20:42:31 [2021-05-30T20:42:31.019Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:42:31 [2021-05-30T20:42:31.019Z] Sort_30	20000.00	8982	root		time:39.7s, loops:10	tpch50.supplier.s_name	637.8 KB	0 Bytes
20:42:31 [2021-05-30T20:42:31.019Z] └─HashJoin_35	20000.00	8982	root		time:39.7s, loops:11, build_hash_table:{total:1.62s, fetch:1.61s, build:7.84ms}, probe:{concurrency:5, total:3m18.3s, max:39.7s, probe:67.2ms, fetch:3m18.3s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.partsupp.ps_suppkey)]	1.46 MB	0 Bytes
20:42:31 [2021-05-30T20:42:31.019Z]   ├─HashJoin_48(Build)	20000.00	19972	root		time:1.62s, loops:21, build_hash_table:{total:220.2µs, fetch:212.8µs, build:7.42µs}, probe:{concurrency:5, total:8.09s, max:1.62s, probe:83.8ms, fetch:8.01s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:42:31 [2021-05-30T20:42:31.019Z]   │ ├─TableReader_53(Build)	1.00	1	root		time:54.8µs, loops:2, cop_task: {num: 1, max: 979.3µs, proc_keys: 25, rpc_num: 1, rpc_time: 950.8µs, copr_cache: disabled}	data:Selection_52	236 Bytes	N/A
20:42:31 [2021-05-30T20:42:31.019Z]   │ │ └─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:31 [2021-05-30T20:42:31.019Z]   │ │   └─TableFullScan_51	25.00	25	cop[tikv]	table:nation	tikv_task:{time:0s, loops:1}	keep order:false	N/A	N/A
20:42:31 [2021-05-30T20:42:31.019Z]   │ └─TableReader_50(Probe)	500000.00	500000	root		time:1.6s, loops:490, cop_task: {num: 1, max: 1.6s, proc_keys: 500000, tot_proc: 1.54s, rpc_num: 1, rpc_time: 1.6s, copr_cache: disabled}	data:TableFullScan_49	35.8 MB	N/A
20:42:31 [2021-05-30T20:42:31.019Z]   │   └─TableFullScan_49	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:1.37s, 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:31 [2021-05-30T20:42:31.019Z]   └─HashAgg_54(Probe)	257492.04	223999	root		time:39.7s, loops:222, partial_worker:{wall_time:39.538608726s, concurrency:5, task_num:289, tot_wait:3m17.461869072s, tot_exec:186.885518ms, tot_time:3m17.685506263s, max:39.538521029s, p95:39.538521029s}, final_worker:{wall_time:39.664977891s, concurrency:5, task_num:25, tot_wait:3m17.674262299s, tot_exec:641.644753ms, tot_time:3m18.315938494s, max:39.664911662s, p95:39.664911662s}	group by:tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_suppkey)->tpch50.partsupp.ps_suppkey	61.4 MB	N/A
20:42:31 [2021-05-30T20:42:31.019Z]     └─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:31 [2021-05-30T20:42:31.019Z]       └─HashAgg_56	321865.05	435528	root		time:39.4s, loops:430, partial_worker:{wall_time:39.165124241s, concurrency:5, task_num:624, tot_wait:3m14.609782024s, tot_exec:1.08474268s, tot_time:3m15.814826708s, max:39.165035195s, p95:39.165035195s}, final_worker:{wall_time:39.526996887s, concurrency:5, task_num:25, tot_wait:3m15.806482137s, tot_exec:1.809921816s, tot_time:3m17.6164232s, max:39.52688757s, p95:39.52688757s}	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:31 [2021-05-30T20:42:31.019Z]         └─HashJoin_59	9711455.06	634004	root		time:39.1s, loops:625, build_hash_table:{total:2.86s, fetch:2.63s, build:229.5ms}, probe:{concurrency:5, total:3m15.4s, max:39.1s, probe:15.3s, fetch:3m0.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:42:31 [2021-05-30T20:42:31.020Z]           ├─IndexHashJoin_67(Build)	321865.05	435528	root		time:2.84s, loops:430, inner:{total:3.19s, concurrency:5, task:12, construct:98.4ms, fetch:2.74s, build:25.8ms, join:348.7ms}	inner join, inner:IndexLookUp_64, outer key:tpch50.part.p_partkey, inner key:tpch50.partsupp.ps_partkey, equal cond:eq(tpch50.part.p_partkey, tpch50.partsupp.ps_partkey)	20.4 MB	N/A
20:42:31 [2021-05-30T20:42:31.020Z]           │ ├─TableReader_96(Build)	80007.93	108882	root		time:2.42s, loops:112, cop_task: {num: 20, max: 1.79s, min: 746.9ms, avg: 1.28s, p95: 1.79s, max_proc_keys: 686055, p95_proc_keys: 686055, tot_proc: 25.5s, tot_wait: 10ms, rpc_num: 20, rpc_time: 25.6s, copr_cache: disabled}	data:Selection_95	680.6 KB	N/A
20:42:31 [2021-05-30T20:42:31.020Z]           │ │ └─Selection_95	80007.93	108882	cop[tikv]		tikv_task:{proc max:1.74s, min:739ms, p80:1.41s, p95:1.74s, 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:31 [2021-05-30T20:42:31.020Z]           │ │   └─TableFullScan_94	10000000.00	10000000	cop[tikv]	table:part	tikv_task:{proc max:1.65s, min:676ms, p80:1.32s, p95:1.65s, iters:9859, tasks:20}	keep order:false	N/A	N/A
20:42:31 [2021-05-30T20:42:31.020Z]           │ └─IndexLookUp_64(Probe)	4.02	435528	root		time:2.65s, loops:447, index_task: {total_time: 1.62s, fetch_handle: 1.62s, build: 98.1µs, wait: 306µs}, table_task: {total_time: 10.1s, num: 55, concurrency: 60}		20.7 KB	N/A
20:42:31 [2021-05-30T20:42:31.020Z]           │   ├─IndexRangeScan_62(Build)	4.02	435528	cop[tikv]	table:partsupp, index:PRIMARY(PS_PARTKEY, PS_SUPPKEY)	time:1.57s, loops:483, cop_task: {num: 60, max: 334.5ms, min: 5.29ms, avg: 107.9ms, p95: 256.8ms, max_proc_keys: 14948, p95_proc_keys: 14948, tot_proc: 6s, tot_wait: 92ms, rpc_num: 60, rpc_time: 6.47s, copr_cache: disabled}, tikv_task:{proc max:317ms, min:4ms, p80:161ms, p95:240ms, iters:698, tasks:60}, scan_detail: {total_process_keys: 435528, total_keys: 544410, rocksdb: {delete_skipped_count: 0, key_skipped_count: 435528, block: {cache_hit_count: 980292, read_count: 0, read_byte: 0 Bytes}}}	range: decided by [eq(tpch50.partsupp.ps_partkey, tpch50.part.p_partkey)], keep order:false	N/A	N/A
20:42:31 [2021-05-30T20:42:31.020Z]           │   └─TableRowIDScan_63(Probe)	4.02	435528	cop[tikv]	table:partsupp	time:3.46s, loops:501, cop_task: {num: 1458, max: 93.6ms, min: 469.4µs, avg: 23.4ms, p95: 54.5ms, max_proc_keys: 1124, p95_proc_keys: 560, tot_proc: 25.5s, tot_wait: 6.37s, rpc_num: 1458, rpc_time: 34.1s, copr_cache: disabled}, tikv_task:{proc max:58ms, min:0s, p80:21ms, p95:32ms, iters:5378, tasks:1458}, scan_detail: {total_process_keys: 435528, total_keys: 473500, rocksdb: {delete_skipped_count: 0, key_skipped_count: 194080, block: {cache_hit_count: 3644090, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:42:31 [2021-05-30T20:42:31.020Z]           └─TableReader_101(Probe)	46310896.67	45504356	root		time:34.1s, loops:44289, cop_task: {num: 761, max: 1.3s, min: 328ms, avg: 726.6ms, p95: 924.1ms, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 9m9.7s, tot_wait: 124ms, rpc_num: 761, rpc_time: 9m12.9s, copr_cache: disabled}	data:Selection_100	52.6 MB	N/A
20:42:31 [2021-05-30T20:42:31.020Z]             └─Selection_100	46310896.67	45504356	cop[tikv]		tikv_task:{proc max:1.23s, min:318ms, p80:775ms, p95:906ms, 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:31 [2021-05-30T20:42:31.020Z]               └─TableFullScan_99	300005811.00	300005811	cop[tikv]	table:lineitem	tikv_task:{proc max:1.18s, min:308ms, p80:741ms, p95:879ms, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:42:31 [2021-05-30T20:42:31.020Z] 
20:42:31 [2021-05-30T20:42:31.020Z] queries/20.sql
20:42:31 [2021-05-30T20:42:31.020Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:42:31 [2021-05-30T20:42:31.020Z] Sort_30	20000.00	8982	root		time:38.1s, loops:10	tpch50.supplier.s_name	645.0 KB	0 Bytes
20:42:31 [2021-05-30T20:42:31.020Z] └─HashJoin_35	20000.00	8982	root		time:38.1s, loops:11, build_hash_table:{total:1.17s, fetch:1.16s, build:10.4ms}, probe:{concurrency:5, total:3m10.6s, max:38.1s, probe:53.5ms, fetch:3m10.5s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.partsupp.ps_suppkey)]	1.51 MB	0 Bytes
20:42:31 [2021-05-30T20:42:31.020Z]   ├─HashJoin_48(Build)	20000.00	19972	root		time:1.17s, loops:23, build_hash_table:{total:131.3µs, fetch:126.3µs, build:5µs}, probe:{concurrency:5, total:5.87s, max:1.17s, probe:120.4ms, fetch:5.74s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:42:31 [2021-05-30T20:42:31.020Z]   │ ├─TableReader_53(Build)	1.00	1	root		time:41.6µs, loops:2, cop_task: {num: 1, max: 1.53ms, proc_keys: 25, rpc_num: 1, rpc_time: 1.49ms, copr_cache: disabled}	data:Selection_52	240 Bytes	N/A
20:42:31 [2021-05-30T20:42:31.020Z]   │ │ └─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:31 [2021-05-30T20:42:31.020Z]   │ │   └─TableFullScan_51	25.00	25	cop[tikv]	table:nation	tikv_task:{time:0s, loops:1}	keep order:false	N/A	N/A
20:42:31 [2021-05-30T20:42:31.020Z]   │ └─TableReader_50(Probe)	500000.00	500000	root		time:1.15s, loops:490, cop_task: {num: 1, max: 1.15s, proc_keys: 500000, tot_proc: 1.06s, rpc_num: 1, rpc_time: 1.15s, copr_cache: disabled}	data:TableFullScan_49	35.8 MB	N/A
20:42:31 [2021-05-30T20:42:31.020Z]   │   └─TableFullScan_49	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:916ms, 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:31 [2021-05-30T20:42:31.020Z]   └─HashAgg_54(Probe)	257492.04	223999	root		time:38.1s, loops:222, partial_worker:{wall_time:38.014821359s, concurrency:5, task_num:289, tot_wait:3m9.760224051s, tot_exec:214.229665ms, tot_time:3m10.047075075s, max:38.014552211s, p95:38.014552211s}, final_worker:{wall_time:38.118470354s, concurrency:5, task_num:25, tot_wait:3m10.005280549s, tot_exec:559.717013ms, tot_time:3m10.565014589s, max:38.118217974s, p95:38.118217974s}	group by:tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_suppkey)->tpch50.partsupp.ps_suppkey	61.4 MB	N/A
20:42:31 [2021-05-30T20:42:31.020Z]     └─Selection_55	257492.04	295898	root		time:38s, loops:290	gt(cast(tpch50.partsupp.ps_availqty, decimal(20,0) BINARY), mul(0.5, Column#44))	59.2 KB	N/A
20:42:31 [2021-05-30T20:42:31.020Z]       └─HashAgg_56	321865.05	435528	root		time:37.9s, loops:430, partial_worker:{wall_time:37.646548669s, concurrency:5, task_num:625, tot_wait:3m6.977343594s, tot_exec:1.11945442s, tot_time:3m8.215893907s, max:37.646453827s, p95:37.646453827s}, final_worker:{wall_time:37.992253806s, concurrency:5, task_num:25, tot_wait:3m8.180561836s, tot_exec:1.755641399s, tot_time:3m9.936219857s, max:37.992150049s, p95:37.992150049s}	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:31 [2021-05-30T20:42:31.020Z]         └─HashJoin_59	9711455.06	634004	root		time:37.6s, loops:626, build_hash_table:{total:2.57s, fetch:2.37s, build:198.1ms}, probe:{concurrency:5, total:3m7.8s, max:37.6s, probe:15.1s, fetch:2m52.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:42:31 [2021-05-30T20:42:31.020Z]           ├─IndexHashJoin_67(Build)	321865.05	435528	root		time:2.54s, loops:429, inner:{total:2.82s, concurrency:5, task:12, construct:117.6ms, fetch:2.39s, build:28.2ms, join:315.8ms}	inner join, inner:IndexLookUp_64, outer key:tpch50.part.p_partkey, inner key:tpch50.partsupp.ps_partkey, equal cond:eq(tpch50.part.p_partkey, tpch50.partsupp.ps_partkey)	20.5 MB	N/A
20:42:31 [2021-05-30T20:42:31.020Z]           │ ├─TableReader_96(Build)	80007.93	108882	root		time:2.18s, loops:112, cop_task: {num: 20, max: 1.44s, min: 626.3ms, avg: 1.07s, p95: 1.44s, max_proc_keys: 686055, p95_proc_keys: 686055, tot_proc: 21.2s, tot_wait: 67ms, rpc_num: 20, rpc_time: 21.3s, copr_cache: disabled}	data:Selection_95	725.8 KB	N/A
20:42:31 [2021-05-30T20:42:31.020Z]           │ │ └─Selection_95	80007.93	108882	cop[tikv]		tikv_task:{proc max:1.42s, min:619ms, p80:1.28s, p95:1.42s, iters:9859, tasks:20}, scan_detail: {total_process_keys: 10000000, total_keys: 10000020, rocksdb: {delete_skipped_count: 0, key_skipped_count: 19999980, block: {cache_hit_count: 31499, read_count: 0, read_byte: 0 Bytes}}}	like(tpch50.part.p_name, "green%", 92)	N/A	N/A
20:42:31 [2021-05-30T20:42:31.020Z]           │ │   └─TableFullScan_94	10000000.00	10000000	cop[tikv]	table:part	tikv_task:{proc max:1.32s, min:574ms, p80:1.2s, p95:1.32s, iters:9859, tasks:20}	keep order:false	N/A	N/A
20:42:31 [2021-05-30T20:42:31.020Z]           │ └─IndexLookUp_64(Probe)	4.02	435528	root		time:2.28s, loops:447, index_task: {total_time: 1.32s, fetch_handle: 1.32s, build: 102µs, wait: 294.7µs}, table_task: {total_time: 8.77s, num: 56, concurrency: 60}		20.5 KB	N/A
20:42:31 [2021-05-30T20:42:31.020Z]           │   ├─IndexRangeScan_62(Build)	4.02	435528	cop[tikv]	table:partsupp, index:PRIMARY(PS_PARTKEY, PS_SUPPKEY)	time:1.28s, loops:482, cop_task: {num: 62, max: 208.1ms, min: 5.27ms, avg: 91.2ms, p95: 180.8ms, max_proc_keys: 15288, p95_proc_keys: 14948, tot_proc: 4.97s, tot_wait: 74ms, rpc_num: 62, rpc_time: 5.65s, copr_cache: disabled}, tikv_task:{proc max:201ms, min:2ms, p80:132ms, p95:164ms, iters:706, tasks:62}, scan_detail: {total_process_keys: 435528, total_keys: 544410, rocksdb: {delete_skipped_count: 0, key_skipped_count: 435528, block: {cache_hit_count: 980292, read_count: 0, read_byte: 0 Bytes}}}	range: decided by [eq(tpch50.partsupp.ps_partkey, tpch50.part.p_partkey)], keep order:false	N/A	N/A
20:42:31 [2021-05-30T20:42:31.020Z]           │   └─TableRowIDScan_63(Probe)	4.02	435528	cop[tikv]	table:partsupp	time:2.87s, loops:503, cop_task: {num: 1497, max: 87ms, min: 481.4µs, avg: 18.3ms, p95: 38.1ms, max_proc_keys: 908, p95_proc_keys: 504, tot_proc: 19.8s, tot_wait: 5.63s, rpc_num: 1497, rpc_time: 27.4s, copr_cache: disabled}, tikv_task:{proc max:39ms, min:0s, p80:16ms, p95:22ms, iters:5481, tasks:1497}, scan_detail: {total_process_keys: 435528, total_keys: 473492, rocksdb: {delete_skipped_count: 0, key_skipped_count: 194028, block: {cache_hit_count: 3644554, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:42:31 [2021-05-30T20:42:31.020Z]           └─TableReader_101(Probe)	46310896.67	45504356	root		time:32.9s, loops:44289, cop_task: {num: 761, max: 1.09s, min: 338.7ms, avg: 698.3ms, p95: 858.4ms, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 8m48.2s, tot_wait: 133ms, rpc_num: 761, rpc_time: 8m51.4s, copr_cache: disabled}	data:Selection_100	52.6 MB	N/A
20:42:31 [2021-05-30T20:42:31.020Z]             └─Selection_100	46310896.67	45504356	cop[tikv]		tikv_task:{proc max:1.05s, min:326ms, p80:745ms, p95:838ms, iters:296606, tasks:761}, scan_detail: {total_process_keys: 300005811, total_keys: 300006572, rocksdb: {delete_skipped_count: 0, key_skipped_count: 600010861, block: {cache_hit_count: 1124648, read_count: 0, read_byte: 0 Bytes}}}	ge(tpch50.lineitem.l_shipdate, 1993-01-01 00:00:00.000000), lt(tpch50.lineitem.l_shipdate, 1994-01-01)	N/A	N/A
20:42:31 [2021-05-30T20:42:31.020Z]               └─TableFullScan_99	300005811.00	300005811	cop[tikv]	table:lineitem	tikv_task:{proc max:998ms, min:315ms, p80:713ms, p95:804ms, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:42:31 [2021-05-30T20:42:31.020Z] + sync
20:42:31 [2021-05-30T20:42:31.020Z] + /usr/bin/echo 3
20:43:22 [2021-05-30T20:43:22.479Z] + sync
20:43:22 [2021-05-30T20:43:22.479Z] + /usr/bin/echo 3
20:44:02 [2021-05-30T20:44:02.198Z] 
20:44:02 [2021-05-30T20:44:02.198Z] queries/20.sql
20:44:02 [2021-05-30T20:44:02.198Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:44:02 [2021-05-30T20:44:02.198Z] Sort_30	20000.00	8982	root		time:37.8s, loops:10	tpch50.supplier.s_name	633.0 KB	0 Bytes
20:44:02 [2021-05-30T20:44:02.198Z] └─HashJoin_35	20000.00	8982	root		time:37.8s, loops:11, build_hash_table:{total:1.32s, fetch:1.31s, build:16ms}, probe:{concurrency:5, total:3m9s, max:37.8s, probe:49.5ms, fetch:3m8.9s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.partsupp.ps_suppkey)]	1.54 MB	0 Bytes
20:44:02 [2021-05-30T20:44:02.198Z]   ├─HashJoin_48(Build)	20000.00	19972	root		time:1.31s, loops:23, build_hash_table:{total:223.5µs, fetch:215.8µs, build:7.7µs}, probe:{concurrency:5, total:6.6s, max:1.32s, probe:118.6ms, fetch:6.48s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:44:02 [2021-05-30T20:44:02.198Z]   │ ├─TableReader_53(Build)	1.00	1	root		time:61.5µs, loops:2, cop_task: {num: 1, max: 1.07ms, proc_keys: 25, tot_proc: 1ms, rpc_num: 1, rpc_time: 1.04ms, copr_cache: disabled}	data:Selection_52	244 Bytes	N/A
20:44:02 [2021-05-30T20:44:02.199Z]   │ │ └─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:44:02 [2021-05-30T20:44:02.199Z]   │ │   └─TableFullScan_51	25.00	25	cop[tikv]	table:nation	tikv_task:{time:1ms, loops:1}	keep order:false	N/A	N/A
20:44:02 [2021-05-30T20:44:02.199Z]   │ └─TableReader_50(Probe)	500000.00	500000	root		time:1.3s, loops:490, cop_task: {num: 1, max: 1.3s, proc_keys: 500000, tot_proc: 1.23s, rpc_num: 1, rpc_time: 1.3s, copr_cache: disabled}	data:TableFullScan_49	35.8 MB	N/A
20:44:02 [2021-05-30T20:44:02.199Z]   │   └─TableFullScan_49	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:1.08s, 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:44:02 [2021-05-30T20:44:02.199Z]   └─HashAgg_54(Probe)	257492.04	223999	root		time:37.8s, loops:222, partial_worker:{wall_time:37.68426375s, concurrency:5, task_num:289, tot_wait:3m8.165523186s, tot_exec:204.686308ms, tot_time:3m8.415169457s, max:37.684211178s, p95:37.684211178s}, final_worker:{wall_time:37.796646062s, concurrency:5, task_num:25, tot_wait:3m8.41031927s, tot_exec:563.440072ms, tot_time:3m8.973775976s, max:37.796629798s, p95:37.796629798s}	group by:tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_suppkey)->tpch50.partsupp.ps_suppkey	61.4 MB	N/A
20:44:02 [2021-05-30T20:44:02.199Z]     └─Selection_55	257492.04	295898	root		time:37.7s, loops:290	gt(cast(tpch50.partsupp.ps_availqty, decimal(20,0) BINARY), mul(0.5, Column#44))	59.2 KB	N/A
20:44:02 [2021-05-30T20:44:02.199Z]       └─HashAgg_56	321865.05	435528	root		time:37.6s, loops:430, partial_worker:{wall_time:37.298475789s, concurrency:5, task_num:623, tot_wait:3m5.338261885s, tot_exec:1.028634384s, tot_time:3m6.480676034s, max:37.298435739s, p95:37.298435739s}, final_worker:{wall_time:37.669003875s, concurrency:5, task_num:25, tot_wait:3m6.468513814s, tot_exec:1.860586736s, tot_time:3m8.329118105s, max:37.668966928s, p95:37.668966928s}	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:44:02 [2021-05-30T20:44:02.199Z]         └─HashJoin_59	9711455.06	634004	root		time:37.2s, loops:624, build_hash_table:{total:2.48s, fetch:2.26s, build:219.5ms}, probe:{concurrency:5, total:3m6.1s, max:37.2s, probe:14.7s, fetch:2m51.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:44:02 [2021-05-30T20:44:02.199Z]           ├─IndexHashJoin_67(Build)	321865.05	435528	root		time:2.43s, loops:429, inner:{total:2.61s, concurrency:5, task:12, construct:124.8ms, fetch:2.14s, build:27.5ms, join:339ms}	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.5 MB	N/A
20:44:02 [2021-05-30T20:44:02.199Z]           │ ├─TableReader_96(Build)	80007.93	108882	root		time:2.1s, loops:112, cop_task: {num: 20, max: 1.37s, min: 594.3ms, avg: 1.08s, p95: 1.37s, max_proc_keys: 686055, p95_proc_keys: 686055, tot_proc: 21.5s, tot_wait: 6ms, rpc_num: 20, rpc_time: 21.6s, copr_cache: disabled}	data:Selection_95	725.8 KB	N/A
20:44:02 [2021-05-30T20:44:02.199Z]           │ │ └─Selection_95	80007.93	108882	cop[tikv]		tikv_task:{proc max:1.35s, min:590ms, p80:1.33s, p95:1.35s, iters:9859, tasks:20}, scan_detail: {total_process_keys: 10000000, total_keys: 10000020, rocksdb: {delete_skipped_count: 0, key_skipped_count: 19999980, block: {cache_hit_count: 31499, read_count: 0, read_byte: 0 Bytes}}}	like(tpch50.part.p_name, "green%", 92)	N/A	N/A
20:44:02 [2021-05-30T20:44:02.199Z]           │ │   └─TableFullScan_94	10000000.00	10000000	cop[tikv]	table:part	tikv_task:{proc max:1.26s, min:543ms, p80:1.23s, p95:1.26s, iters:9859, tasks:20}	keep order:false	N/A	N/A
20:44:02 [2021-05-30T20:44:02.199Z]           │ └─IndexLookUp_64(Probe)	4.02	435528	root		time:2.05s, loops:447, index_task: {total_time: 1.2s, fetch_handle: 1.2s, build: 89.2µs, wait: 274.9µs}, table_task: {total_time: 7.94s, num: 56, concurrency: 60}		31.3 KB	N/A
20:44:02 [2021-05-30T20:44:02.199Z]           │   ├─IndexRangeScan_62(Build)	4.02	435528	cop[tikv]	table:partsupp, index:PRIMARY(PS_PARTKEY, PS_SUPPKEY)	time:1.16s, loops:479, cop_task: {num: 58, max: 190.2ms, min: 4.46ms, avg: 89.3ms, p95: 169.2ms, max_proc_keys: 15288, p95_proc_keys: 15008, tot_proc: 4.71s, tot_wait: 102ms, rpc_num: 58, rpc_time: 5.17s, copr_cache: disabled}, tikv_task:{proc max:179ms, min:4ms, p80:139ms, p95:157ms, iters:689, tasks:58}, scan_detail: {total_process_keys: 435528, total_keys: 544410, rocksdb: {delete_skipped_count: 0, key_skipped_count: 435528, block: {cache_hit_count: 980292, read_count: 0, read_byte: 0 Bytes}}}	range: decided by [eq(tpch50.partsupp.ps_partkey, tpch50.part.p_partkey)], keep order:false	N/A	N/A
20:44:02 [2021-05-30T20:44:02.199Z]           │   └─TableRowIDScan_63(Probe)	4.02	435528	cop[tikv]	table:partsupp	time:2.5s, loops:506, cop_task: {num: 1384, max: 70.6ms, min: 364µs, avg: 17.8ms, p95: 35.4ms, max_proc_keys: 1040, p95_proc_keys: 652, tot_proc: 18.7s, tot_wait: 4.11s, rpc_num: 1384, rpc_time: 24.6s, copr_cache: disabled}, tikv_task:{proc max:43ms, min:0s, p80:18ms, p95:26ms, iters:5163, tasks:1384}, scan_detail: {total_process_keys: 435528, total_keys: 473528, rocksdb: {delete_skipped_count: 0, key_skipped_count: 194146, block: {cache_hit_count: 3643765, read_count: 1, read_byte: 26.8 KB}}}	keep order:false	N/A	N/A
20:44:02 [2021-05-30T20:44:02.199Z]           └─TableReader_101(Probe)	46310896.67	45504356	root		time:32.7s, loops:44289, cop_task: {num: 761, max: 1.15s, min: 313ms, avg: 693.1ms, p95: 839.5ms, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 8m44.3s, tot_wait: 145ms, rpc_num: 761, rpc_time: 8m47.5s, copr_cache: disabled}	data:Selection_100	52.6 MB	N/A
20:44:02 [2021-05-30T20:44:02.199Z]             └─Selection_100	46310896.67	45504356	cop[tikv]		tikv_task:{proc max:1.09s, min:302ms, p80:734ms, p95:820ms, 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:44:02 [2021-05-30T20:44:02.199Z]               └─TableFullScan_99	300005811.00	300005811	cop[tikv]	table:lineitem	tikv_task:{proc max:1.04s, min:283ms, p80:705ms, p95:788ms, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:44:02 [2021-05-30T20:44:02.199Z] 
20:44:02 [2021-05-30T20:44:02.199Z] queries/20.sql
20:44:02 [2021-05-30T20:44:02.199Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:44:02 [2021-05-30T20:44:02.199Z] Sort_30	20000.00	8982	root		time:37.5s, loops:10	tpch50.supplier.s_name	628.3 KB	0 Bytes
20:44:02 [2021-05-30T20:44:02.199Z] └─HashJoin_35	20000.00	8982	root		time:37.5s, loops:11, build_hash_table:{total:1.26s, fetch:1.25s, build:10.9ms}, probe:{concurrency:5, total:3m7.7s, max:37.5s, probe:51.5ms, fetch:3m7.6s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.partsupp.ps_suppkey)]	1.52 MB	0 Bytes
20:44:02 [2021-05-30T20:44:02.199Z]   ├─HashJoin_48(Build)	20000.00	19972	root		time:1.26s, loops:23, build_hash_table:{total:196µs, fetch:189.7µs, build:6.29µs}, probe:{concurrency:5, total:6.29s, max:1.26s, probe:109.8ms, fetch:6.18s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:44:02 [2021-05-30T20:44:02.199Z]   │ ├─TableReader_53(Build)	1.00	1	root		time:46.9µs, loops:2, cop_task: {num: 1, max: 1.02ms, proc_keys: 25, rpc_num: 1, rpc_time: 994.2µs, copr_cache: disabled}	data:Selection_52	240 Bytes	N/A
20:44:02 [2021-05-30T20:44:02.199Z]   │ │ └─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:44:02 [2021-05-30T20:44:02.199Z]   │ │   └─TableFullScan_51	25.00	25	cop[tikv]	table:nation	tikv_task:{time:0s, loops:1}	keep order:false	N/A	N/A
20:44:02 [2021-05-30T20:44:02.199Z]   │ └─TableReader_50(Probe)	500000.00	500000	root		time:1.24s, loops:490, cop_task: {num: 1, max: 1.24s, proc_keys: 500000, tot_proc: 1.16s, tot_wait: 1ms, rpc_num: 1, rpc_time: 1.24s, copr_cache: disabled}	data:TableFullScan_49	35.8 MB	N/A
20:44:02 [2021-05-30T20:44:02.199Z]   │   └─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:44:02 [2021-05-30T20:44:02.199Z]   └─HashAgg_54(Probe)	257492.04	223999	root		time:37.5s, loops:222, partial_worker:{wall_time:37.412070011s, concurrency:5, task_num:289, tot_wait:3m6.785268168s, tot_exec:228.913742ms, tot_time:3m7.053027223s, max:37.412004268s, p95:37.412004268s}, final_worker:{wall_time:37.530712455s, concurrency:5, task_num:25, tot_wait:3m7.0488387s, tot_exec:597.754785ms, tot_time:3m7.646611696s, max:37.530577088s, p95:37.530577088s}	group by:tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_suppkey)->tpch50.partsupp.ps_suppkey	61.4 MB	N/A
20:44:02 [2021-05-30T20:44:02.199Z]     └─Selection_55	257492.04	295898	root		time:37.4s, loops:290	gt(cast(tpch50.partsupp.ps_availqty, decimal(20,0) BINARY), mul(0.5, Column#44))	59.2 KB	N/A
20:44:02 [2021-05-30T20:44:02.199Z]       └─HashAgg_56	321865.05	435528	root		time:37.3s, loops:430, partial_worker:{wall_time:37.031020361s, concurrency:5, task_num:624, tot_wait:3m3.984542065s, tot_exec:1.043244428s, tot_time:3m5.152331161s, max:37.03097234s, p95:37.03097234s}, final_worker:{wall_time:37.400482205s, concurrency:5, task_num:25, tot_wait:3m5.14554359s, tot_exec:1.804244156s, tot_time:3m6.94980291s, max:37.40043607s, p95:37.40043607s}	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.6 MB	N/A
20:44:02 [2021-05-30T20:44:02.199Z]         └─HashJoin_59	9711455.06	634004	root		time:37s, loops:625, build_hash_table:{total:2.49s, fetch:2.29s, build:202.4ms}, probe:{concurrency:5, total:3m4.8s, max:37s, probe:14.9s, fetch:2m49.9s}	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:44:02 [2021-05-30T20:44:02.199Z]           ├─IndexHashJoin_67(Build)	321865.05	435528	root		time:2.45s, loops:429, inner:{total:2.67s, concurrency:5, task:12, construct:117ms, fetch:2.23s, build:31.2ms, join:323.3ms}	inner join, inner:IndexLookUp_64, outer key:tpch50.part.p_partkey, inner key:tpch50.partsupp.ps_partkey, equal cond:eq(tpch50.part.p_partkey, tpch50.partsupp.ps_partkey)	20.6 MB	N/A
20:44:02 [2021-05-30T20:44:02.199Z]           │ ├─TableReader_96(Build)	80007.93	108882	root		time:2.11s, loops:111, cop_task: {num: 20, max: 1.52s, min: 607ms, avg: 1.09s, p95: 1.52s, max_proc_keys: 686055, p95_proc_keys: 686055, tot_proc: 21.8s, tot_wait: 14ms, rpc_num: 20, rpc_time: 21.9s, copr_cache: disabled}	data:Selection_95	725.8 KB	N/A
20:44:02 [2021-05-30T20:44:02.199Z]           │ │ └─Selection_95	80007.93	108882	cop[tikv]		tikv_task:{proc max:1.5s, min:603ms, p80:1.24s, p95:1.5s, iters:9859, tasks:20}, scan_detail: {total_process_keys: 10000000, total_keys: 10000020, rocksdb: {delete_skipped_count: 0, key_skipped_count: 19999980, block: {cache_hit_count: 31499, read_count: 0, read_byte: 0 Bytes}}}	like(tpch50.part.p_name, "green%", 92)	N/A	N/A
20:44:02 [2021-05-30T20:44:02.199Z]           │ │   └─TableFullScan_94	10000000.00	10000000	cop[tikv]	table:part	tikv_task:{proc max:1.41s, min:562ms, p80:1.16s, p95:1.41s, iters:9859, tasks:20}	keep order:false	N/A	N/A
20:44:02 [2021-05-30T20:44:02.199Z]           │ └─IndexLookUp_64(Probe)	4.02	435528	root		time:2.13s, loops:447, index_task: {total_time: 1.23s, fetch_handle: 1.23s, build: 83.3µs, wait: 285.9µs}, table_task: {total_time: 7.92s, num: 56, concurrency: 60}		20.5 KB	N/A
20:44:02 [2021-05-30T20:44:02.199Z]           │   ├─IndexRangeScan_62(Build)	4.02	435528	cop[tikv]	table:partsupp, index:PRIMARY(PS_PARTKEY, PS_SUPPKEY)	time:1.19s, loops:479, cop_task: {num: 60, max: 202ms, min: 4.51ms, avg: 85.3ms, p95: 189.4ms, max_proc_keys: 15288, p95_proc_keys: 14948, tot_proc: 4.58s, tot_wait: 20ms, rpc_num: 60, rpc_time: 5.12s, copr_cache: disabled}, tikv_task:{proc max:186ms, min:2ms, p80:129ms, p95:174ms, iters:699, tasks:60}, scan_detail: {total_process_keys: 435528, total_keys: 544410, rocksdb: {delete_skipped_count: 0, key_skipped_count: 435528, block: {cache_hit_count: 980292, read_count: 0, read_byte: 0 Bytes}}}	range: decided by [eq(tpch50.partsupp.ps_partkey, tpch50.part.p_partkey)], keep order:false	N/A	N/A
20:44:02 [2021-05-30T20:44:02.199Z]           │   └─TableRowIDScan_63(Probe)	4.02	435528	cop[tikv]	table:partsupp	time:2.48s, loops:505, cop_task: {num: 1398, max: 86ms, min: 373.7µs, avg: 16.4ms, p95: 33.5ms, max_proc_keys: 976, p95_proc_keys: 624, tot_proc: 17.9s, tot_wait: 3.39s, rpc_num: 1398, rpc_time: 22.9s, copr_cache: disabled}, tikv_task:{proc max:45ms, min:0s, p80:17ms, p95:24ms, iters:5225, tasks:1398}, scan_detail: {total_process_keys: 435528, total_keys: 473513, rocksdb: {delete_skipped_count: 0, key_skipped_count: 194101, block: {cache_hit_count: 3643899, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:44:02 [2021-05-30T20:44:02.199Z]           └─TableReader_101(Probe)	46310896.67	45504356	root		time:32.4s, loops:44289, cop_task: {num: 761, max: 1.2s, min: 347.1ms, avg: 687.5ms, p95: 850.4ms, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 8m40s, tot_wait: 117ms, rpc_num: 761, rpc_time: 8m43.2s, copr_cache: disabled}	data:Selection_100	52.6 MB	N/A
20:44:02 [2021-05-30T20:44:02.200Z]             └─Selection_100	46310896.67	45504356	cop[tikv]		tikv_task:{proc max:1.13s, min:336ms, p80:735ms, p95:830ms, 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:44:02 [2021-05-30T20:44:02.200Z]               └─TableFullScan_99	300005811.00	300005811	cop[tikv]	table:lineitem	tikv_task:{proc max:1.07s, min:322ms, p80:704ms, p95:799ms, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:44:02 [2021-05-30T20:44:02.200Z] + sync
20:44:02 [2021-05-30T20:44:02.200Z] + /usr/bin/echo 3
20:44:41 [2021-05-30T20:44:41.606Z] + tiup cluster stop benchbot -y
20:44:41 [2021-05-30T20:44:41.606Z] Starting component `cluster`: /home/tidb/.tiup/components/cluster/v1.4.4/tiup-cluster stop benchbot -y
20:44:48 [2021-05-30T20:44:48.140Z] + rm -rf '/data1/tidb-deploy/*/log/*'
20:44:48 [2021-05-30T20:44:48.140Z] + rm -rf /data1/jenkins/deploy/data/tikv-20160
20:45:01 [2021-05-30T20:45:01.816Z] + rm -rf /data1/jenkins/deploy/data/pd-2379
20:45:01 [2021-05-30T20:45:01.816Z] + rm -rf /data1/jenkins/restore_data/tpch50/data/last_tikv.toml
20:45:01 [2021-05-30T20:45:01.816Z] + cp -R /data1/jenkins/restore_data/tpch50/data /data1/jenkins/deploy/data/tikv-20160
20:46:38 [2021-05-30T20:46:38.760Z] + cp -R /data1/jenkins/restore_data/tpch50/data.pd /data1/jenkins/deploy/data/pd-2379
20:46:38 [2021-05-30T20:46:38.760Z] + '[' -n '' ']'
20:46:38 [2021-05-30T20:46:38.760Z] + tiup cluster start benchbot --wait-timeout=300
20:46:38 [2021-05-30T20:46:38.760Z] Starting component `cluster`: /home/tidb/.tiup/components/cluster/v1.4.4/tiup-cluster start benchbot --wait-timeout=300
20:47:04 [2021-05-30T20:47:04.120Z] + sync
20:47:04 [2021-05-30T20:47:04.120Z] + /usr/bin/echo 3
20:49:04 [2021-05-30T20:49:04.077Z] 
20:49:04 [2021-05-30T20:49:04.077Z] queries/20.sql
20:49:04 [2021-05-30T20:49:04.077Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:49:04 [2021-05-30T20:49:04.077Z] Sort_30	20000.00	8982	root		time:37.4s, loops:10	tpch50.supplier.s_name	649.8 KB	0 Bytes
20:49:04 [2021-05-30T20:49:04.077Z] └─HashJoin_35	20000.00	8982	root		time:37.3s, loops:11, build_hash_table:{total:1.38s, fetch:1.37s, build:8.69ms}, probe:{concurrency:5, total:3m6.7s, max:37.3s, probe:47.9ms, fetch:3m6.7s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.partsupp.ps_suppkey)]	1.49 MB	0 Bytes
20:49:04 [2021-05-30T20:49:04.077Z]   ├─HashJoin_48(Build)	20000.00	19972	root		time:1.38s, loops:22, build_hash_table:{total:154.7µs, fetch:149.5µs, build:5.27µs}, probe:{concurrency:5, total:6.89s, max:1.38s, probe:98ms, fetch:6.79s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:49:04 [2021-05-30T20:49:04.077Z]   │ ├─TableReader_53(Build)	1.00	1	root		time:29.7µs, loops:2, cop_task: {num: 1, max: 781.8µs, proc_keys: 25, rpc_num: 1, rpc_time: 765.3µs, copr_cache: disabled}	data:Selection_52	236 Bytes	N/A
20:49:04 [2021-05-30T20:49:04.077Z]   │ │ └─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:49:04 [2021-05-30T20:49:04.077Z]   │ │   └─TableFullScan_51	25.00	25	cop[tikv]	table:nation	tikv_task:{time:0s, loops:1}	keep order:false	N/A	N/A
20:49:04 [2021-05-30T20:49:04.077Z]   │ └─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.27s, rpc_num: 1, rpc_time: 1.36s, copr_cache: disabled}	data:TableFullScan_49	35.8 MB	N/A
20:49:04 [2021-05-30T20:49:04.077Z]   │   └─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:49:04 [2021-05-30T20:49:04.077Z]   └─HashAgg_54(Probe)	257492.04	223999	root		time:37.3s, loops:222, partial_worker:{wall_time:37.282315024s, concurrency:5, task_num:289, tot_wait:3m5.970255371s, tot_exec:314.358618ms, tot_time:3m6.401406297s, max:37.282295633s, p95:37.282295633s}, final_worker:{wall_time:37.348381102s, concurrency:5, task_num:25, tot_wait:3m6.390092422s, tot_exec:341.232846ms, tot_time:3m6.731338726s, max:37.348361463s, p95:37.348361463s}	group by:tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_suppkey)->tpch50.partsupp.ps_suppkey	61.4 MB	N/A
20:49:04 [2021-05-30T20:49:04.078Z]     └─Selection_55	257492.04	295898	root		time:37.2s, loops:290	gt(cast(tpch50.partsupp.ps_availqty, decimal(20,0) BINARY), mul(0.5, Column#44))	59.2 KB	N/A
20:49:04 [2021-05-30T20:49:04.078Z]       └─HashAgg_56	321865.05	435528	root		time:37.1s, loops:430, partial_worker:{wall_time:36.851648675s, concurrency:5, task_num:624, tot_wait:3m2.978738187s, tot_exec:1.11757289s, tot_time:3m4.222723035s, max:36.851622912s, p95:36.851622912s}, final_worker:{wall_time:37.250209641s, concurrency:5, task_num:25, tot_wait:3m4.18991194s, tot_exec:2.009751096s, tot_time:3m6.199682646s, max:37.249789138s, p95:37.249789138s}	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:49:04 [2021-05-30T20:49:04.078Z]         └─HashJoin_59	9711455.06	634004	root		time:36.8s, loops:625, build_hash_table:{total:2.66s, fetch:2.47s, build:194.3ms}, probe:{concurrency:5, total:3m3.8s, max:36.8s, probe:14.7s, fetch:2m49.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:49:04 [2021-05-30T20:49:04.078Z]           ├─IndexHashJoin_67(Build)	321865.05	435528	root		time:2.61s, loops:430, inner:{total:2.86s, concurrency:5, task:12, construct:121.9ms, fetch:2.42s, build:26.2ms, join:321.7ms}	inner join, inner:IndexLookUp_64, outer key:tpch50.part.p_partkey, inner key:tpch50.partsupp.ps_partkey, equal cond:eq(tpch50.part.p_partkey, tpch50.partsupp.ps_partkey)	20.6 MB	N/A
20:49:04 [2021-05-30T20:49:04.078Z]           │ ├─TableReader_96(Build)	80007.93	108882	root		time:2.26s, loops:112, cop_task: {num: 20, max: 1.54s, min: 535.9ms, avg: 1.08s, p95: 1.54s, max_proc_keys: 686055, p95_proc_keys: 686055, tot_proc: 21.6s, tot_wait: 95ms, rpc_num: 20, rpc_time: 21.7s, copr_cache: disabled}	data:Selection_95	725.8 KB	N/A
20:49:04 [2021-05-30T20:49:04.078Z]           │ │ └─Selection_95	80007.93	108882	cop[tikv]		tikv_task:{proc max:1.53s, min:529ms, p80:1.44s, 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:49:04 [2021-05-30T20:49:04.078Z]           │ │   └─TableFullScan_94	10000000.00	10000000	cop[tikv]	table:part	tikv_task:{proc max:1.42s, min:492ms, p80:1.33s, p95:1.42s, iters:9859, tasks:20}	keep order:false	N/A	N/A
20:49:04 [2021-05-30T20:49:04.078Z]           │ └─IndexLookUp_64(Probe)	4.02	435528	root		time:2.31s, loops:447, index_task: {total_time: 1.2s, fetch_handle: 1.2s, build: 81.9µs, wait: 299µs}, table_task: {total_time: 8.45s, num: 56, concurrency: 60}		20.5 KB	N/A
20:49:04 [2021-05-30T20:49:04.078Z]           │   ├─IndexRangeScan_62(Build)	4.02	435528	cop[tikv]	table:partsupp, index:PRIMARY(PS_PARTKEY, PS_SUPPKEY)	time:1.16s, loops:483, cop_task: {num: 60, max: 199.9ms, min: 4.33ms, avg: 90.4ms, p95: 191.3ms, max_proc_keys: 15288, p95_proc_keys: 14764, tot_proc: 4.97s, tot_wait: 128ms, rpc_num: 60, rpc_time: 5.42s, copr_cache: disabled}, tikv_task:{proc max:189ms, min:3ms, p80:139ms, p95:183ms, iters:697, tasks:60}, scan_detail: {total_process_keys: 435528, total_keys: 544410, rocksdb: {delete_skipped_count: 0, key_skipped_count: 435528, block: {cache_hit_count: 980292, read_count: 0, read_byte: 0 Bytes}}}	range: decided by [eq(tpch50.partsupp.ps_partkey, tpch50.part.p_partkey)], keep order:false	N/A	N/A
20:49:04 [2021-05-30T20:49:04.078Z]           │   └─TableRowIDScan_63(Probe)	4.02	435528	cop[tikv]	table:partsupp	time:3s, loops:505, cop_task: {num: 1412, max: 97.6ms, min: 602.8µs, avg: 19.9ms, p95: 45ms, max_proc_keys: 976, p95_proc_keys: 616, tot_proc: 19.8s, tot_wait: 5.33s, rpc_num: 1412, rpc_time: 28.1s, copr_cache: disabled}, tikv_task:{proc max:41ms, min:0s, p80:17ms, p95:24ms, iters:5263, tasks:1412}, scan_detail: {total_process_keys: 435528, total_keys: 473510, rocksdb: {delete_skipped_count: 0, key_skipped_count: 194078, block: {cache_hit_count: 3644077, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:49:04 [2021-05-30T20:49:04.078Z]           └─TableReader_101(Probe)	46310896.67	45504356	root		time:32.1s, loops:44289, cop_task: {num: 761, max: 1.11s, min: 355ms, avg: 679.6ms, p95: 821.8ms, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 8m34s, tot_wait: 137ms, rpc_num: 761, rpc_time: 8m37.2s, copr_cache: disabled}	data:Selection_100	52.6 MB	N/A
20:49:04 [2021-05-30T20:49:04.086Z]             └─Selection_100	46310896.67	45504356	cop[tikv]		tikv_task:{proc max:1.08s, min:339ms, p80:721ms, p95:805ms, 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:49:04 [2021-05-30T20:49:04.086Z]               └─TableFullScan_99	300005811.00	300005811	cop[tikv]	table:lineitem	tikv_task:{proc max:1.03s, min:326ms, p80:690ms, p95:772ms, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:49:04 [2021-05-30T20:49:04.086Z] 
20:49:04 [2021-05-30T20:49:04.086Z] queries/21.sql
20:49:04 [2021-05-30T20:49:04.086Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:49:04 [2021-05-30T20:49:04.086Z] Projection_26	100.00	100	root		time:1m22s, loops:2, Concurrency:OFF	tpch50.supplier.s_name, Column#72	4.37 KB	N/A
20:49:04 [2021-05-30T20:49:04.086Z] └─TopN_29	100.00	100	root		time:1m22s, loops:2	Column#72:desc, tpch50.supplier.s_name, offset:0, count:100	58.3 KB	N/A
20:49:04 [2021-05-30T20:49:04.086Z]   └─HashAgg_34	12800.00	20057	root		time:1m22s, loops:21, partial_worker:{wall_time:1m21.964364227s, concurrency:5, task_num:197, tot_wait:6m49.510146246s, tot_exec:291.948221ms, tot_time:6m49.816356125s, max:1m21.964331179s, p95:1m21.964331179s}, final_worker:{wall_time:1m21.978111998s, concurrency:5, task_num:25, tot_wait:6m49.81321233s, tot_exec:76.771853ms, tot_time:6m49.889996642s, max:1m21.978042182s, p95:1m21.978042182s}	group by:tpch50.supplier.s_name, funcs:count(1)->Column#72, funcs:firstrow(tpch50.supplier.s_name)->tpch50.supplier.s_name	17.3 MB	N/A
20:49:04 [2021-05-30T20:49:04.086Z]     └─IndexHashJoin_42	7828961.66	198698	root		time:1m22s, loops:198, inner:{total:2m23.3s, concurrency:5, task:146, construct:6.61s, fetch:1m59.4s, build:1.21s, join:17.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:49:04 [2021-05-30T20:49:04.086Z]       ├─IndexHashJoin_83(Build)	9786202.08	3542799	root		time:1m21.4s, loops:3463, inner:{total:2m35.9s, concurrency:5, task:152, construct:8.34s, fetch:2m8.8s, build:1.28s, join:18.7s}	semi join, inner:IndexLookUp_80, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey), ne(tpch50.lineitem.l_suppkey, tpch50.supplier.s_suppkey)	555.9 MB	N/A
20:49:04 [2021-05-30T20:49:04.086Z]       │ ├─IndexJoin_99(Build)	12232752.60	3675878	root		time:1m20.8s, loops:3595, inner:{total:2m12.8s, concurrency:5, task:305, construct:16.8s, fetch:1m54.1s, build:1.9s}, probe:5.41s	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)	581.9 MB	N/A
20:49:04 [2021-05-30T20:49:04.086Z]       │ │ ├─HashJoin_107(Build)	12232752.60	7609895	root		time:1m20s, loops:7437, build_hash_table:{total:805.3ms, fetch:793.5ms, build:11.8ms}, probe:{concurrency:5, total:6m43.4s, max:1m20.7s, probe:1m4.2s, fetch:5m39.2s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.lineitem.l_suppkey)]	742.5 KB	0 Bytes
20:49:04 [2021-05-30T20:49:04.086Z]       │ │ │ ├─HashJoin_120(Build)	20000.00	20058	root		time:802.3ms, loops:23, build_hash_table:{total:351.7µs, fetch:192.1µs, build:159.6µs}, probe:{concurrency:5, total:4.01s, max:802.8ms, probe:117.4ms, fetch:3.9s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:49:04 [2021-05-30T20:49:04.086Z]       │ │ │ │ ├─TableReader_125(Build)	1.00	1	root		time:67.7µs, loops:2, cop_task: {num: 1, max: 1.04ms, proc_keys: 25, rpc_num: 1, rpc_time: 1.01ms, copr_cache: disabled}	data:Selection_124	234 Bytes	N/A
20:49:04 [2021-05-30T20:49:04.086Z]       │ │ │ │ │ └─Selection_124	1.00	1	cop[tikv]		tikv_task:{time:0s, loops:1}, scan_detail: {total_process_keys: 25, total_keys: 26, rocksdb: {delete_skipped_count: 0, key_skipped_count: 46, block: {cache_hit_count: 18, read_count: 0, read_byte: 0 Bytes}}}	eq(tpch50.nation.n_name, "EGYPT")	N/A	N/A
20:49:04 [2021-05-30T20:49:04.086Z]       │ │ │ │ │   └─TableFullScan_123	25.00	25	cop[tikv]	table:nation	tikv_task:{time:0s, loops:1}	keep order:false	N/A	N/A
20:49:04 [2021-05-30T20:49:04.086Z]       │ │ │ │ └─TableReader_122(Probe)	500000.00	500000	root		time:779.4ms, loops:490, cop_task: {num: 1, max: 897.2ms, proc_keys: 500000, tot_proc: 861ms, rpc_num: 1, rpc_time: 897.2ms, copr_cache: disabled}	data:TableFullScan_121	20.0 MB	N/A
20:49:04 [2021-05-30T20:49:04.086Z]       │ │ │ │   └─TableFullScan_121	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:801ms, 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:49:04 [2021-05-30T20:49:04.086Z]       │ │ │ └─TableReader_128(Probe)	240004648.80	189670348	root		time:1m7.8s, loops:184597, cop_task: {num: 761, max: 2.78s, min: 304.8ms, avg: 1.55s, p95: 2.07s, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 18m24.1s, tot_wait: 1m2.2s, rpc_num: 761, rpc_time: 19m40.8s, copr_cache: disabled}	data:Selection_127	99.2 MB	N/A
20:49:04 [2021-05-30T20:49:04.086Z]       │ │ │   └─Selection_127	240004648.80	189670348	cop[tikv]		tikv_task:{proc max:1.44s, min:294ms, p80:1.19s, p95:1.25s, 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: 18669, read_count: 1131794, read_byte: 23.9 GB}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:49:04 [2021-05-30T20:49:04.086Z]       │ │ │     └─TableFullScan_126	300005811.00	300005811	cop[tikv]	table:l1	tikv_task:{proc max:1.34s, min:276ms, p80:1.11s, p95:1.17s, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:49:04 [2021-05-30T20:49:04.086Z]       │ │ └─TableReader_95(Probe)	0.49	3496185	root		time:1m44.9s, loops:3875, cop_task: {num: 5263, max: 570.7ms, min: 510.3µs, avg: 187.2ms, p95: 359.1ms, max_proc_keys: 3716, p95_proc_keys: 1970, tot_proc: 11m38.5s, tot_wait: 3m57.9s, rpc_num: 5263, rpc_time: 16m24.8s, copr_cache: disabled}	data:Selection_94	N/A	N/A
20:49:04 [2021-05-30T20:49:04.086Z]       │ │   └─Selection_94	0.49	3496185	cop[tikv]		tikv_task:{proc max:162ms, min:0s, p80:71ms, p95:84ms, iters:30281, tasks:5263}, scan_detail: {total_process_keys: 7236308, total_keys: 7795486, rocksdb: {delete_skipped_count: 0, key_skipped_count: 1778216, block: {cache_hit_count: 54006912, read_count: 220007, read_byte: 4.66 GB}}}	eq(tpch50.orders.o_orderstatus, "F")	N/A	N/A
20:49:04 [2021-05-30T20:49:04.086Z]       │ │     └─TableRangeScan_93	1.00	7236308	cop[tikv]	table:orders	tikv_task:{proc max:162ms, min:0s, p80:71ms, p95:84ms, iters:30281, tasks:5263}	range: decided by [tpch50.lineitem.l_orderkey], keep order:false	N/A	N/A
20:49:04 [2021-05-30T20:49:04.086Z]       │ └─IndexLookUp_80(Probe)	4.05	17316416	root		time:2m3s, loops:17131, index_task: {total_time: 1m7.7s, fetch_handle: 58.3s, build: 3.25ms, wait: 9.46s}, table_task: {total_time: 8m50.7s, num: 1458, concurrency: 760}		19.2 KB	N/A
20:49:04 [2021-05-30T20:49:04.086Z]       │   ├─IndexRangeScan_78(Build)	4.05	17316416	cop[tikv]	table:l2, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:56s, loops:18607, cop_task: {num: 2983, max: 839.3ms, min: 745.6µs, avg: 196.8ms, p95: 398.4ms, max_proc_keys: 13436, p95_proc_keys: 8734, tot_proc: 7m17.7s, tot_wait: 2m5.8s, rpc_num: 2983, rpc_time: 9m46.8s, copr_cache: disabled}, tikv_task:{proc max:184ms, min:0s, p80:98ms, p95:114ms, iters:30148, tasks:2983}, scan_detail: {total_process_keys: 17316416, total_keys: 20812513, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17316416, block: {cache_hit_count: 24260155, read_count: 226887, read_byte: 2.40 GB}}}	range: decided by [eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey)], keep order:false	N/A	N/A
20:49:04 [2021-05-30T20:49:04.086Z]       │   └─TableRowIDScan_79(Probe)	4.05	17316416	cop[tikv]	table:l2	time:6m36.6s, loops:21016, cop_task: {num: 7793, max: 721.8ms, min: 565.6µs, avg: 185.3ms, p95: 375.4ms, max_proc_keys: 12685, p95_proc_keys: 4825, tot_proc: 17m10.7s, tot_wait: 5m55.7s, rpc_num: 7793, rpc_time: 24m4s, copr_cache: disabled}, tikv_task:{proc max:251ms, min:0s, p80:108ms, p95:145ms, iters:49821, tasks:7793}, scan_detail: {total_process_keys: 17316416, total_keys: 18289641, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5628021, block: {cache_hit_count: 99027144, read_count: 2, read_byte: 33.6 KB}}}	keep order:false	N/A	N/A
20:49:04 [2021-05-30T20:49:04.086Z]       └─IndexLookUp_39(Probe)	4.05	12022740	root		time:1m54.4s, loops:11944, index_task: {total_time: 1m1.4s, fetch_handle: 51.2s, build: 3.68ms, wait: 10.3s}, table_task: {total_time: 8m16.9s, num: 1408, concurrency: 730}		220.8 KB	N/A
20:49:04 [2021-05-30T20:49:04.086Z]         ├─IndexRangeScan_36(Build)	5.06	17183313	cop[tikv]	table:l3, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:48.8s, loops:18377, cop_task: {num: 2760, max: 768.8ms, min: 1.13ms, avg: 171ms, p95: 383.9ms, max_proc_keys: 18353, p95_proc_keys: 13753, tot_proc: 5m47.5s, tot_wait: 1m40.7s, rpc_num: 2760, rpc_time: 7m52s, copr_cache: disabled}, tikv_task:{proc max:275ms, min:0s, p80:77ms, p95:121ms, iters:29022, tasks:2760}, scan_detail: {total_process_keys: 17183313, total_keys: 20546328, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17183313, block: {cache_hit_count: 23553911, 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:04 [2021-05-30T20:49:04.086Z]         └─Selection_38(Probe)	4.05	12022740	cop[tikv]		time:6m23.3s, loops:13771, cop_task: {num: 10205, max: 685.8ms, min: 897.4µs, avg: 181.8ms, p95: 371.6ms, max_proc_keys: 6872, p95_proc_keys: 4007, tot_proc: 21m44s, tot_wait: 7m54.4s, rpc_num: 10205, rpc_time: 30m54.5s, copr_cache: disabled}, tikv_task:{proc max:227ms, min:0s, p80:78ms, p95:119ms, iters:60462, tasks:10205}, scan_detail: {total_process_keys: 17183313, total_keys: 18129094, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5526933, block: {cache_hit_count: 98290627, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:49:04 [2021-05-30T20:49:04.086Z]           └─TableRowIDScan_37	5.06	17183313	cop[tikv]	table:l3	tikv_task:{proc max:226ms, min:0s, p80:78ms, p95:118ms, iters:60462, tasks:10205}	keep order:false	N/A	N/A
20:49:04 [2021-05-30T20:49:04.086Z] + sync
20:49:04 [2021-05-30T20:49:04.086Z] + /usr/bin/echo 3
20:50:19 [2021-05-30T20:50:19.198Z] 
20:50:19 [2021-05-30T20:50:19.198Z] queries/21.sql
20:50:19 [2021-05-30T20:50:19.198Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:50:19 [2021-05-30T20:50:19.198Z] Projection_26	100.00	100	root		time:1m20.3s, loops:2, Concurrency:OFF	tpch50.supplier.s_name, Column#72	4.37 KB	N/A
20:50:19 [2021-05-30T20:50:19.198Z] └─TopN_29	100.00	100	root		time:1m20.3s, loops:2	Column#72:desc, tpch50.supplier.s_name, offset:0, count:100	58.3 KB	N/A
20:50:19 [2021-05-30T20:50:19.198Z]   └─HashAgg_34	12800.00	20057	root		time:1m20.3s, loops:21, partial_worker:{wall_time:1m20.248461863s, concurrency:5, task_num:196, tot_wait:6m40.935312084s, tot_exec:290.084876ms, tot_time:6m41.239790196s, max:1m20.248429417s, p95:1m20.248429417s}, final_worker:{wall_time:1m20.264606175s, concurrency:5, task_num:25, tot_wait:6m41.238466767s, tot_exec:74.098631ms, tot_time:6m41.312577512s, max:1m20.264582393s, p95:1m20.264582393s}	group by:tpch50.supplier.s_name, funcs:count(1)->Column#72, funcs:firstrow(tpch50.supplier.s_name)->tpch50.supplier.s_name	17.3 MB	N/A
20:50:19 [2021-05-30T20:50:19.198Z]     └─IndexHashJoin_42	7828961.66	198698	root		time:1m20.2s, loops:197, inner:{total:2m22.5s, concurrency:5, task:146, construct:6.37s, fetch:1m58.3s, build:1.22s, join:17.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.1 MB	N/A
20:50:19 [2021-05-30T20:50:19.198Z]       ├─IndexHashJoin_83(Build)	9786202.08	3542799	root		time:1m19.6s, loops:3464, inner:{total:2m32.8s, concurrency:5, task:152, construct:8.03s, fetch:2m5.9s, build:1.26s, join:18.8s}	semi join, inner:IndexLookUp_80, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey), ne(tpch50.lineitem.l_suppkey, tpch50.supplier.s_suppkey)	555.9 MB	N/A
20:50:19 [2021-05-30T20:50:19.199Z]       │ ├─IndexJoin_99(Build)	12232752.60	3675878	root		time:1m18.9s, loops:3595, inner:{total:2m10.2s, concurrency:5, task:305, construct:17.3s, fetch:1m50.9s, build:1.94s}, probe:5.42s	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)	581.8 MB	N/A
20:50:19 [2021-05-30T20:50:19.199Z]       │ │ ├─HashJoin_107(Build)	12232752.60	7609895	root		time:1m18.2s, loops:7437, build_hash_table:{total:1.01s, fetch:1.01s, build:6.69ms}, probe:{concurrency:5, total:6m34s, max:1m18.8s, probe:1m5.2s, fetch:5m28.8s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.lineitem.l_suppkey)]	752.0 KB	0 Bytes
20:50:19 [2021-05-30T20:50:19.199Z]       │ │ │ ├─HashJoin_120(Build)	20000.00	20058	root		time:1.01s, loops:23, build_hash_table:{total:372.2µs, fetch:314.5µs, build:57.7µs}, probe:{concurrency:5, total:5.05s, max:1.01s, probe:61ms, fetch:4.99s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:50:19 [2021-05-30T20:50:19.199Z]       │ │ │ │ ├─TableReader_125(Build)	1.00	1	root		time:57.9µs, loops:2, cop_task: {num: 1, max: 1.4ms, proc_keys: 25, tot_proc: 1ms, rpc_num: 1, rpc_time: 1.37ms, copr_cache: disabled}	data:Selection_124	248 Bytes	N/A
20:50:19 [2021-05-30T20:50:19.199Z]       │ │ │ │ │ └─Selection_124	1.00	1	cop[tikv]		tikv_task:{time:1ms, loops:1}, scan_detail: {total_process_keys: 25, total_keys: 26, rocksdb: {delete_skipped_count: 0, key_skipped_count: 46, block: {cache_hit_count: 17, read_count: 1, read_byte: 23.8 KB}}}	eq(tpch50.nation.n_name, "EGYPT")	N/A	N/A
20:50:19 [2021-05-30T20:50:19.199Z]       │ │ │ │ │   └─TableFullScan_123	25.00	25	cop[tikv]	table:nation	tikv_task:{time:1ms, loops:1}	keep order:false	N/A	N/A
20:50:19 [2021-05-30T20:50:19.199Z]       │ │ │ │ └─TableReader_122(Probe)	500000.00	500000	root		time:998.2ms, loops:490, cop_task: {num: 1, max: 999.1ms, proc_keys: 500000, tot_proc: 962ms, rpc_num: 1, rpc_time: 999.1ms, copr_cache: disabled}	data:TableFullScan_121	20.0 MB	N/A
20:50:19 [2021-05-30T20:50:19.199Z]       │ │ │ │   └─TableFullScan_121	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:915ms, loops:493}, scan_detail: {total_process_keys: 500000, total_keys: 500001, rocksdb: {delete_skipped_count: 0, key_skipped_count: 999999, block: {cache_hit_count: 13, read_count: 1679, read_byte: 104.5 MB}}}	keep order:false	N/A	N/A
20:50:19 [2021-05-30T20:50:19.199Z]       │ │ │ └─TableReader_128(Probe)	240004648.80	189670348	root		time:1m5.4s, loops:184595, cop_task: {num: 761, max: 2.62s, min: 284.5ms, avg: 1.52s, p95: 2s, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 18m0.2s, tot_wait: 59.7s, rpc_num: 761, rpc_time: 19m14.9s, copr_cache: disabled}	data:Selection_127	109.4 MB	N/A
20:50:19 [2021-05-30T20:50:19.199Z]       │ │ │   └─Selection_127	240004648.80	189670348	cop[tikv]		tikv_task:{proc max:1.28s, min:268ms, p80:1.15s, p95:1.2s, iters:296606, tasks:761}, scan_detail: {total_process_keys: 300005811, total_keys: 300006572, rocksdb: {delete_skipped_count: 0, key_skipped_count: 600010861, block: {cache_hit_count: 10453, read_count: 1114195, read_byte: 23.6 GB}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:50:19 [2021-05-30T20:50:19.199Z]       │ │ │     └─TableFullScan_126	300005811.00	300005811	cop[tikv]	table:l1	tikv_task:{proc max:1.2s, min:257ms, p80:1.08s, p95:1.12s, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:50:19 [2021-05-30T20:50:19.199Z]       │ │ └─TableReader_95(Probe)	0.49	3496188	root		time:1m41.5s, loops:3875, cop_task: {num: 5284, max: 576.8ms, min: 846.1µs, avg: 179.2ms, p95: 341.6ms, max_proc_keys: 3837, p95_proc_keys: 1959, tot_proc: 11m15.8s, tot_wait: 3m44.4s, rpc_num: 5284, rpc_time: 15m46.7s, copr_cache: disabled}	data:Selection_94	N/A	N/A
20:50:19 [2021-05-30T20:50:19.199Z]       │ │   └─Selection_94	0.49	3496188	cop[tikv]		tikv_task:{proc max:148ms, min:0s, p80:69ms, p95:82ms, iters:30269, tasks:5284}, scan_detail: {total_process_keys: 7236294, total_keys: 7795561, rocksdb: {delete_skipped_count: 0, key_skipped_count: 1778491, block: {cache_hit_count: 54007516, read_count: 217284, read_byte: 4.19 GB}}}	eq(tpch50.orders.o_orderstatus, "F")	N/A	N/A
20:50:19 [2021-05-30T20:50:19.201Z]       │ │     └─TableRangeScan_93	1.00	7236294	cop[tikv]	table:orders	tikv_task:{proc max:148ms, min:0s, p80:69ms, p95:82ms, iters:30269, tasks:5284}	range: decided by [tpch50.lineitem.l_orderkey], keep order:false	N/A	N/A
20:50:19 [2021-05-30T20:50:19.201Z]       │ └─IndexLookUp_80(Probe)	4.05	17316367	root		time:2m0.2s, loops:17128, index_task: {total_time: 1m5.7s, fetch_handle: 57.5s, build: 3.17ms, wait: 8.26s}, table_task: {total_time: 8m30.4s, num: 1458, concurrency: 760}		18.9 KB	N/A
20:50:19 [2021-05-30T20:50:19.201Z]       │   ├─IndexRangeScan_78(Build)	4.05	17316367	cop[tikv]	table:l2, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:55.1s, loops:18649, cop_task: {num: 3031, max: 629.2ms, min: 461.5µs, avg: 188.4ms, p95: 376.4ms, max_proc_keys: 12978, p95_proc_keys: 8797, tot_proc: 7m4.6s, tot_wait: 2m0.8s, rpc_num: 3031, rpc_time: 9m31s, copr_cache: disabled}, tikv_task:{proc max:175ms, min:0s, p80:95ms, p95:110ms, iters:30296, tasks:3031}, scan_detail: {total_process_keys: 17316367, total_keys: 20812460, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17316367, block: {cache_hit_count: 24259902, read_count: 225677, read_byte: 2.00 GB}}}	range: decided by [eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey)], keep order:false	N/A	N/A
20:50:19 [2021-05-30T20:50:19.201Z]       │   └─TableRowIDScan_79(Probe)	4.05	17316367	cop[tikv]	table:l2	time:6m17.4s, loops:21000, cop_task: {num: 7781, max: 705.5ms, min: 558.7µs, avg: 176.8ms, p95: 353.1ms, max_proc_keys: 9761, p95_proc_keys: 4901, tot_proc: 16m21.8s, tot_wait: 5m35.4s, rpc_num: 7781, rpc_time: 22m55.8s, copr_cache: disabled}, tikv_task:{proc max:243ms, min:0s, p80:104ms, p95:141ms, iters:49833, tasks:7781}, scan_detail: {total_process_keys: 17316367, total_keys: 18289564, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5631093, block: {cache_hit_count: 99015242, read_count: 1109, read_byte: 387.4 MB}}}	keep order:false	N/A	N/A
20:50:19 [2021-05-30T20:50:19.207Z]       └─IndexLookUp_39(Probe)	4.05	12022735	root		time:1m53.3s, loops:11947, index_task: {total_time: 1m0.9s, fetch_handle: 50s, build: 3.19ms, wait: 10.9s}, table_task: {total_time: 8m9.2s, num: 1408, concurrency: 730}		209.2 KB	N/A
20:50:19 [2021-05-30T20:50:19.207Z]         ├─IndexRangeScan_36(Build)	5.06	17183320	cop[tikv]	table:l3, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:47.7s, loops:18355, cop_task: {num: 2805, max: 853.1ms, min: 446.6µs, avg: 167.1ms, p95: 362ms, max_proc_keys: 19061, p95_proc_keys: 13560, tot_proc: 5m45s, tot_wait: 1m39.1s, rpc_num: 2805, rpc_time: 7m48.5s, copr_cache: disabled}, tikv_task:{proc max:181ms, min:0s, p80:78ms, p95:121ms, iters:29158, tasks:2805}, scan_detail: {total_process_keys: 17183320, total_keys: 20546337, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17183320, block: {cache_hit_count: 23553926, read_count: 0, read_byte: 0 Bytes}}}	range: decided by [eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey)], keep order:false	N/A	N/A
20:50:19 [2021-05-30T20:50:19.207Z]         └─Selection_38(Probe)	4.05	12022735	cop[tikv]		time:6m14.8s, loops:13767, cop_task: {num: 10242, max: 610.5ms, min: 488.5µs, avg: 174.2ms, p95: 346.8ms, max_proc_keys: 8977, p95_proc_keys: 3916, tot_proc: 20m44.1s, tot_wait: 7m42.1s, rpc_num: 10242, rpc_time: 29m43.5s, copr_cache: disabled}, tikv_task:{proc max:211ms, min:0s, p80:77ms, p95:117ms, iters:60819, tasks:10242}, scan_detail: {total_process_keys: 17183320, total_keys: 18128558, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5525434, block: {cache_hit_count: 98287510, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:50:19 [2021-05-30T20:50:19.207Z]           └─TableRowIDScan_37	5.06	17183320	cop[tikv]	table:l3	tikv_task:{proc max:209ms, min:0s, p80:76ms, p95:116ms, iters:60819, tasks:10242}	keep order:false	N/A	N/A
20:50:19 [2021-05-30T20:50:19.207Z] + sync
20:50:19 [2021-05-30T20:50:19.207Z] + /usr/bin/echo 3
20:52:09 [2021-05-30T20:52:09.675Z] 
20:52:09 [2021-05-30T20:52:09.675Z] queries/21.sql
20:52:09 [2021-05-30T20:52:09.675Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:52:09 [2021-05-30T20:52:09.675Z] Projection_26	100.00	100	root		time:1m20.7s, loops:2, Concurrency:OFF	tpch50.supplier.s_name, Column#72	4.37 KB	N/A
20:52:09 [2021-05-30T20:52:09.675Z] └─TopN_29	100.00	100	root		time:1m20.7s, loops:2	Column#72:desc, tpch50.supplier.s_name, offset:0, count:100	58.3 KB	N/A
20:52:09 [2021-05-30T20:52:09.675Z]   └─HashAgg_34	12800.00	20057	root		time:1m20.7s, loops:21, partial_worker:{wall_time:1m20.653529802s, concurrency:5, task_num:197, tot_wait:6m42.98048241s, tot_exec:270.948379ms, tot_time:6m43.26571629s, max:1m20.653494731s, p95:1m20.653494731s}, final_worker:{wall_time:1m20.679151376s, concurrency:5, task_num:25, tot_wait:6m43.264366508s, tot_exec:123.113752ms, tot_time:6m43.38752112s, max:1m20.679130913s, p95:1m20.679130913s}	group by:tpch50.supplier.s_name, funcs:count(1)->Column#72, funcs:firstrow(tpch50.supplier.s_name)->tpch50.supplier.s_name	17.3 MB	N/A
20:52:09 [2021-05-30T20:52:09.675Z]     └─IndexHashJoin_42	7828961.66	198698	root		time:1m20.6s, loops:198, inner:{total:2m23.4s, concurrency:5, task:146, construct:6.32s, fetch:1m59.3s, build:1.2s, join:17.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:52:09 [2021-05-30T20:52:09.675Z]       ├─IndexHashJoin_83(Build)	9786202.08	3542799	root		time:1m20.1s, loops:3463, inner:{total:2m32.3s, concurrency:5, task:152, construct:7.88s, fetch:2m6.3s, build:1.21s, join:18.1s}	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:09 [2021-05-30T20:52:09.675Z]       │ ├─IndexJoin_99(Build)	12232752.60	3675878	root		time:1m19.5s, loops:3595, inner:{total:2m9.6s, concurrency:5, task:305, construct:16.8s, fetch:1m51s, build:1.87s}, probe:5.32s	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)	582.1 MB	N/A
20:52:09 [2021-05-30T20:52:09.675Z]       │ │ ├─HashJoin_107(Build)	12232752.60	7609895	root		time:1m18.8s, loops:7435, build_hash_table:{total:1.03s, fetch:1.03s, build:7.37ms}, probe:{concurrency:5, total:6m37.1s, max:1m19.4s, probe:1m5s, fetch:5m32s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.lineitem.l_suppkey)]	747.3 KB	0 Bytes
20:52:09 [2021-05-30T20:52:09.675Z]       │ │ │ ├─HashJoin_120(Build)	20000.00	20058	root		time:1.03s, loops:23, build_hash_table:{total:168.6µs, fetch:162.7µs, build:5.97µs}, probe:{concurrency:5, total:5.16s, max:1.03s, probe:70.9ms, fetch:5.09s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:52:09 [2021-05-30T20:52:09.675Z]       │ │ │ │ ├─TableReader_125(Build)	1.00	1	root		time:43.2µs, loops:2, cop_task: {num: 1, max: 1.4ms, proc_keys: 25, tot_proc: 1ms, rpc_num: 1, rpc_time: 1.38ms, copr_cache: disabled}	data:Selection_124	248 Bytes	N/A
20:52:09 [2021-05-30T20:52:09.675Z]       │ │ │ │ │ └─Selection_124	1.00	1	cop[tikv]		tikv_task:{time:1ms, loops:1}, scan_detail: {total_process_keys: 25, total_keys: 26, rocksdb: {delete_skipped_count: 0, key_skipped_count: 46, block: {cache_hit_count: 17, read_count: 1, read_byte: 23.8 KB}}}	eq(tpch50.nation.n_name, "EGYPT")	N/A	N/A
20:52:09 [2021-05-30T20:52:09.675Z]       │ │ │ │ │   └─TableFullScan_123	25.00	25	cop[tikv]	table:nation	tikv_task:{time:1ms, loops:1}	keep order:false	N/A	N/A
20:52:09 [2021-05-30T20:52:09.676Z]       │ │ │ │ └─TableReader_122(Probe)	500000.00	500000	root		time:1.02s, loops:490, cop_task: {num: 1, max: 1.02s, proc_keys: 500000, tot_proc: 983ms, rpc_num: 1, rpc_time: 1.02s, copr_cache: disabled}	data:TableFullScan_121	20.0 MB	N/A
20:52:09 [2021-05-30T20:52:09.676Z]       │ │ │ │   └─TableFullScan_121	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:934ms, loops:493}, scan_detail: {total_process_keys: 500000, total_keys: 500001, rocksdb: {delete_skipped_count: 0, key_skipped_count: 999999, block: {cache_hit_count: 13, read_count: 1679, read_byte: 104.5 MB}}}	keep order:false	N/A	N/A
20:52:09 [2021-05-30T20:52:09.676Z]       │ │ │ └─TableReader_128(Probe)	240004648.80	189670348	root		time:1m6.1s, loops:184596, cop_task: {num: 761, max: 2.57s, min: 317.9ms, avg: 1.52s, p95: 2.01s, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 18m1.6s, tot_wait: 1m3.3s, rpc_num: 761, rpc_time: 19m19.5s, copr_cache: disabled}	data:Selection_127	109.4 MB	N/A
20:52:09 [2021-05-30T20:52:09.676Z]       │ │ │   └─Selection_127	240004648.80	189670348	cop[tikv]		tikv_task:{proc max:1.3s, min:304ms, 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:52:09 [2021-05-30T20:52:09.676Z]       │ │ │     └─TableFullScan_126	300005811.00	300005811	cop[tikv]	table:l1	tikv_task:{proc max:1.23s, min:291ms, p80:1.07s, p95:1.12s, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:52:09 [2021-05-30T20:52:09.676Z]       │ │ └─TableReader_95(Probe)	0.49	3496189	root		time:1m41.6s, loops:3875, cop_task: {num: 5257, max: 560.6ms, min: 1.64ms, avg: 182.2ms, p95: 346.9ms, max_proc_keys: 3950, p95_proc_keys: 1960, tot_proc: 11m25.7s, tot_wait: 3m45.7s, rpc_num: 5257, rpc_time: 15m57.4s, copr_cache: disabled}	data:Selection_94	N/A	N/A
20:52:09 [2021-05-30T20:52:09.676Z]       │ │   └─Selection_94	0.49	3496189	cop[tikv]		tikv_task:{proc max:151ms, min:0s, p80:69ms, p95:83ms, iters:30221, tasks:5257}, scan_detail: {total_process_keys: 7236304, total_keys: 7795491, rocksdb: {delete_skipped_count: 0, key_skipped_count: 1778185, block: {cache_hit_count: 54007035, read_count: 217962, read_byte: 4.21 GB}}}	eq(tpch50.orders.o_orderstatus, "F")	N/A	N/A
20:52:09 [2021-05-30T20:52:09.676Z]       │ │     └─TableRangeScan_93	1.00	7236304	cop[tikv]	table:orders	tikv_task:{proc max:148ms, min:0s, p80:69ms, p95:83ms, iters:30221, tasks:5257}	range: decided by [tpch50.lineitem.l_orderkey], keep order:false	N/A	N/A
20:52:09 [2021-05-30T20:52:09.676Z]       │ └─IndexLookUp_80(Probe)	4.05	17316451	root		time:2m0.8s, loops:17125, index_task: {total_time: 1m5.4s, fetch_handle: 56.1s, build: 6.08ms, wait: 9.33s}, table_task: {total_time: 8m42.4s, num: 1458, concurrency: 760}		19.2 KB	N/A
20:52:09 [2021-05-30T20:52:09.676Z]       │   ├─IndexRangeScan_78(Build)	4.05	17316451	cop[tikv]	table:l2, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:53.8s, loops:18610, cop_task: {num: 2997, max: 751.9ms, min: 618.6µs, avg: 189.9ms, p95: 381.7ms, max_proc_keys: 11891, p95_proc_keys: 8754, tot_proc: 7m3.1s, tot_wait: 2m1s, rpc_num: 2997, rpc_time: 9m29s, copr_cache: disabled}, tikv_task:{proc max:157ms, min:0s, p80:96ms, p95:111ms, iters:30178, tasks:2997}, scan_detail: {total_process_keys: 17316451, total_keys: 20812554, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17316451, 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:52:09 [2021-05-30T20:52:09.685Z]       │   └─TableRowIDScan_79(Probe)	4.05	17316451	cop[tikv]	table:l2	time:6m30.5s, loops:20978, cop_task: {num: 7817, max: 651.4ms, min: 655.9µs, avg: 183ms, p95: 366.4ms, max_proc_keys: 12102, p95_proc_keys: 4847, tot_proc: 17m5.2s, tot_wait: 5m47.4s, rpc_num: 7817, rpc_time: 23m50.1s, copr_cache: disabled}, tikv_task:{proc max:270ms, min:0s, p80:106ms, p95:143ms, iters:49976, tasks:7817}, scan_detail: {total_process_keys: 17316451, total_keys: 18289815, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5629808, block: {cache_hit_count: 99020254, read_count: 1107, read_byte: 388.2 MB}}}	keep order:false	N/A	N/A
20:52:09 [2021-05-30T20:52:09.685Z]       └─IndexLookUp_39(Probe)	4.05	12022830	root		time:1m54.2s, loops:11944, index_task: {total_time: 1m1.7s, fetch_handle: 49.9s, build: 3.08ms, wait: 11.7s}, table_task: {total_time: 8m10.4s, num: 1408, concurrency: 730}		218.8 KB	N/A
20:52:09 [2021-05-30T20:52:09.685Z]         ├─IndexRangeScan_36(Build)	5.06	17183408	cop[tikv]	table:l3, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:47.5s, loops:18343, cop_task: {num: 2770, max: 798.4ms, min: 635.9µs, avg: 169.7ms, p95: 360.6ms, max_proc_keys: 17485, p95_proc_keys: 13912, tot_proc: 5m44.7s, tot_wait: 1m41.2s, rpc_num: 2770, rpc_time: 7m50s, copr_cache: disabled}, tikv_task:{proc max:168ms, min:0s, p80:77ms, p95:121ms, iters:29032, tasks:2770}, scan_detail: {total_process_keys: 17183408, total_keys: 20546438, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17183408, block: {cache_hit_count: 23554016, 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:09 [2021-05-30T20:52:09.685Z]         └─Selection_38(Probe)	4.05	12022830	cop[tikv]		time:6m15.9s, loops:13784, cop_task: {num: 10280, max: 635.7ms, min: 387.6µs, avg: 174.9ms, p95: 351.8ms, max_proc_keys: 6924, p95_proc_keys: 3923, tot_proc: 20m50.4s, tot_wait: 7m50.3s, rpc_num: 10280, rpc_time: 29m57.9s, copr_cache: disabled}, tikv_task:{proc max:234ms, min:0s, p80:77ms, p95:116ms, iters:60844, tasks:10280}, scan_detail: {total_process_keys: 17183408, total_keys: 18128574, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5524604, block: {cache_hit_count: 98290428, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:52:09 [2021-05-30T20:52:09.685Z]           └─TableRowIDScan_37	5.06	17183408	cop[tikv]	table:l3	tikv_task:{proc max:233ms, min:0s, p80:76ms, p95:115ms, iters:60844, tasks:10280}	keep order:false	N/A	N/A
20:52:09 [2021-05-30T20:52:09.685Z] + sync
20:52:09 [2021-05-30T20:52:09.685Z] + /usr/bin/echo 3
20:53:11 [2021-05-30T20:53:11.838Z] 
20:53:11 [2021-05-30T20:53:11.853Z] queries/21.sql
20:53:11 [2021-05-30T20:53:11.853Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:53:11 [2021-05-30T20:53:11.853Z] Projection_26	100.00	100	root		time:1m20.6s, loops:2, Concurrency:OFF	tpch50.supplier.s_name, Column#72	4.37 KB	N/A
20:53:11 [2021-05-30T20:53:11.853Z] └─TopN_29	100.00	100	root		time:1m20.6s, loops:2	Column#72:desc, tpch50.supplier.s_name, offset:0, count:100	58.3 KB	N/A
20:53:11 [2021-05-30T20:53:11.853Z]   └─HashAgg_34	12800.00	20057	root		time:1m20.6s, loops:21, partial_worker:{wall_time:1m20.548226337s, concurrency:5, task_num:197, tot_wait:6m42.430900557s, tot_exec:296.383188ms, tot_time:6m42.740840247s, max:1m20.548205304s, p95:1m20.548205304s}, final_worker:{wall_time:1m20.562483077s, concurrency:5, task_num:25, tot_wait:6m42.740839879s, tot_exec:66.523943ms, tot_time:6m42.807376018s, max:1m20.562458336s, p95:1m20.562458336s}	group by:tpch50.supplier.s_name, funcs:count(1)->Column#72, funcs:firstrow(tpch50.supplier.s_name)->tpch50.supplier.s_name	17.3 MB	N/A
20:53:11 [2021-05-30T20:53:11.854Z]     └─IndexHashJoin_42	7828961.66	198698	root		time:1m20.5s, loops:198, inner:{total:2m21.9s, concurrency:5, task:147, construct:6.34s, fetch:1m58.1s, build:1.16s, join:17.5s}	anti semi join, inner:IndexLookUp_39, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey)	641.0 MB	N/A
20:53:11 [2021-05-30T20:53:11.854Z]       ├─IndexHashJoin_83(Build)	9786202.08	3542799	root		time:1m20s, loops:3463, inner:{total:2m29.7s, concurrency:5, task:152, construct:7.77s, fetch:2m3.6s, build:1.22s, join:18.3s}	semi join, inner:IndexLookUp_80, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey), ne(tpch50.lineitem.l_suppkey, tpch50.supplier.s_suppkey)	555.9 MB	N/A
20:53:11 [2021-05-30T20:53:11.854Z]       │ ├─IndexJoin_99(Build)	12232752.60	3675878	root		time:1m19.5s, loops:3595, inner:{total:2m7.1s, concurrency:5, task:305, construct:16.1s, fetch:1m49.1s, build:1.88s}, probe:5.43s	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)	581.9 MB	N/A
20:53:11 [2021-05-30T20:53:11.854Z]       │ │ ├─HashJoin_107(Build)	12232752.60	7609895	root		time:1m18.8s, loops:7436, build_hash_table:{total:1.04s, fetch:1.03s, build:10.7ms}, probe:{concurrency:5, total:6m36.6s, max:1m19.3s, probe:1m4.1s, fetch:5m32.5s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.lineitem.l_suppkey)]	718.1 KB	0 Bytes
20:53:11 [2021-05-30T20:53:11.854Z]       │ │ │ ├─HashJoin_120(Build)	20000.00	20058	root		time:1.04s, loops:22, build_hash_table:{total:184.5µs, fetch:176.6µs, build:7.9µs}, probe:{concurrency:5, total:5.21s, max:1.04s, probe:86.1ms, fetch:5.12s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:53:11 [2021-05-30T20:53:11.854Z]       │ │ │ │ ├─TableReader_125(Build)	1.00	1	root		time:57.6µs, loops:2, cop_task: {num: 1, max: 1.51ms, proc_keys: 25, tot_proc: 1ms, rpc_num: 1, rpc_time: 1.46ms, copr_cache: disabled}	data:Selection_124	248 Bytes	N/A
20:53:11 [2021-05-30T20:53:11.854Z]       │ │ │ │ │ └─Selection_124	1.00	1	cop[tikv]		tikv_task:{time:1ms, loops:1}, scan_detail: {total_process_keys: 25, total_keys: 26, rocksdb: {delete_skipped_count: 0, key_skipped_count: 46, block: {cache_hit_count: 17, read_count: 1, read_byte: 23.8 KB}}}	eq(tpch50.nation.n_name, "EGYPT")	N/A	N/A
20:53:11 [2021-05-30T20:53:11.854Z]       │ │ │ │ │   └─TableFullScan_123	25.00	25	cop[tikv]	table:nation	tikv_task:{time:1ms, loops:1}	keep order:false	N/A	N/A
20:53:11 [2021-05-30T20:53:11.854Z]       │ │ │ │ └─TableReader_122(Probe)	500000.00	500000	root		time:1.02s, loops:490, cop_task: {num: 1, max: 1.02s, proc_keys: 500000, tot_proc: 977ms, rpc_num: 1, rpc_time: 1.02s, copr_cache: disabled}	data:TableFullScan_121	20.0 MB	N/A
20:53:11 [2021-05-30T20:53:11.854Z]       │ │ │ │   └─TableFullScan_121	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:910ms, 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:11 [2021-05-30T20:53:11.854Z]       │ │ │ └─TableReader_128(Probe)	240004648.80	189670348	root		time:1m6s, loops:184597, cop_task: {num: 761, max: 2.71s, min: 289ms, avg: 1.52s, p95: 1.98s, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 18m2s, tot_wait: 1m1.7s, rpc_num: 761, rpc_time: 19m18.2s, copr_cache: disabled}	data:Selection_127	109.4 MB	N/A
20:53:11 [2021-05-30T20:53:11.854Z]       │ │ │   └─Selection_127	240004648.80	189670348	cop[tikv]		tikv_task:{proc max:1.27s, min:272ms, 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:11 [2021-05-30T20:53:11.854Z]       │ │ │     └─TableFullScan_126	300005811.00	300005811	cop[tikv]	table:l1	tikv_task:{proc max:1.18s, min:256ms, p80:1.08s, p95:1.12s, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:53:11 [2021-05-30T20:53:11.854Z]       │ │ └─TableReader_95(Probe)	0.49	3496169	root		time:1m40.2s, loops:3875, cop_task: {num: 5266, max: 541.7ms, min: 1.03ms, avg: 178.7ms, p95: 329.7ms, max_proc_keys: 3621, p95_proc_keys: 1956, tot_proc: 11m9.1s, tot_wait: 3m45.2s, rpc_num: 5266, rpc_time: 15m40.9s, copr_cache: disabled}	data:Selection_94	N/A	N/A
20:53:11 [2021-05-30T20:53:11.854Z]       │ │   └─Selection_94	0.49	3496169	cop[tikv]		tikv_task:{proc max:148ms, min:0s, p80:70ms, p95:82ms, iters:30196, tasks:5266}, scan_detail: {total_process_keys: 7236263, total_keys: 7795568, rocksdb: {delete_skipped_count: 0, key_skipped_count: 1778625, block: {cache_hit_count: 54006034, read_count: 218229, read_byte: 4.21 GB}}}	eq(tpch50.orders.o_orderstatus, "F")	N/A	N/A
20:53:11 [2021-05-30T20:53:11.854Z]       │ │     └─TableRangeScan_93	1.00	7236263	cop[tikv]	table:orders	tikv_task:{proc max:148ms, min:0s, p80:69ms, p95:82ms, iters:30196, tasks:5266}	range: decided by [tpch50.lineitem.l_orderkey], keep order:false	N/A	N/A
20:53:11 [2021-05-30T20:53:11.854Z]       │ └─IndexLookUp_80(Probe)	4.05	17316400	root		time:1m57.9s, loops:17136, index_task: {total_time: 1m4.5s, fetch_handle: 55.3s, build: 4.07ms, wait: 9.16s}, table_task: {total_time: 8m31.5s, num: 1458, concurrency: 760}		19.2 KB	N/A
20:53:11 [2021-05-30T20:53:11.854Z]       │   ├─IndexRangeScan_78(Build)	4.05	17316400	cop[tikv]	table:l2, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:53s, loops:18648, cop_task: {num: 2983, max: 763.9ms, min: 706.5µs, avg: 190.6ms, p95: 384.5ms, max_proc_keys: 12581, p95_proc_keys: 8835, tot_proc: 7m1.4s, tot_wait: 2m3.2s, rpc_num: 2983, rpc_time: 9m28.5s, copr_cache: disabled}, tikv_task:{proc max:148ms, min:0s, p80:96ms, p95:111ms, iters:30112, tasks:2983}, scan_detail: {total_process_keys: 17316400, total_keys: 20812493, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17316400, block: {cache_hit_count: 24259899, read_count: 225679, read_byte: 2.00 GB}}}	range: decided by [eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey)], keep order:false	N/A	N/A
20:53:11 [2021-05-30T20:53:11.854Z]       │   └─TableRowIDScan_79(Probe)	4.05	17316400	cop[tikv]	table:l2	time:6m19.9s, loops:20956, cop_task: {num: 7786, max: 637.4ms, min: 363.7µs, avg: 177.6ms, p95: 355.3ms, max_proc_keys: 8581, p95_proc_keys: 4883, tot_proc: 16m31.8s, tot_wait: 5m32.6s, rpc_num: 7786, rpc_time: 23m2.1s, copr_cache: disabled}, tikv_task:{proc max:253ms, min:0s, p80:106ms, p95:141ms, iters:49785, tasks:7786}, scan_detail: {total_process_keys: 17316400, total_keys: 18290284, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5631690, block: {cache_hit_count: 99018811, read_count: 1109, read_byte: 399.7 MB}}}	keep order:false	N/A	N/A
20:53:11 [2021-05-30T20:53:11.854Z]       └─IndexLookUp_39(Probe)	4.05	12022797	root		time:1m53.1s, loops:11949, index_task: {total_time: 1m0.3s, fetch_handle: 49.4s, build: 3.16ms, wait: 11s}, table_task: {total_time: 8m4.4s, num: 1410, concurrency: 735}		219.8 KB	N/A
20:53:11 [2021-05-30T20:53:11.854Z]         ├─IndexRangeScan_36(Build)	5.06	17183387	cop[tikv]	table:l3, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:47.1s, loops:18342, cop_task: {num: 2763, max: 857.4ms, min: 569.2µs, avg: 169.2ms, p95: 349.2ms, max_proc_keys: 23327, p95_proc_keys: 13790, tot_proc: 5m41.9s, tot_wait: 1m42.7s, rpc_num: 2763, rpc_time: 7m47.5s, copr_cache: disabled}, tikv_task:{proc max:186ms, min:0s, p80:79ms, p95:120ms, iters:28993, tasks:2763}, scan_detail: {total_process_keys: 17183387, total_keys: 20546412, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17183387, block: {cache_hit_count: 23553981, 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:11 [2021-05-30T20:53:11.854Z]         └─Selection_38(Probe)	4.05	12022797	cop[tikv]		time:6m12.2s, loops:13769, cop_task: {num: 10397, max: 587.2ms, min: 388.4µs, avg: 173.2ms, p95: 346.3ms, max_proc_keys: 8282, p95_proc_keys: 3874, tot_proc: 21m0s, tot_wait: 7m43.7s, rpc_num: 10397, rpc_time: 29m59.9s, copr_cache: disabled}, tikv_task:{proc max:242ms, min:0s, p80:75ms, p95:114ms, iters:61388, tasks:10397}, scan_detail: {total_process_keys: 17183387, total_keys: 18127365, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5519794, block: {cache_hit_count: 98298182, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:53:11 [2021-05-30T20:53:11.854Z]           └─TableRowIDScan_37	5.06	17183387	cop[tikv]	table:l3	tikv_task:{proc max:242ms, min:0s, p80:74ms, p95:113ms, iters:61388, tasks:10397}	keep order:false	N/A	N/A
20:53:11 [2021-05-30T20:53:11.854Z] + sync
20:53:11 [2021-05-30T20:53:11.854Z] + /usr/bin/echo 3
20:54:14 [2021-05-30T20:54:14.104Z] 
20:54:14 [2021-05-30T20:54:14.105Z] queries/21.sql
20:54:14 [2021-05-30T20:54:14.105Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:54:14 [2021-05-30T20:54:14.105Z] Projection_26	100.00	100	root		time:1m20.8s, loops:2, Concurrency:OFF	tpch50.supplier.s_name, Column#72	4.37 KB	N/A
20:54:14 [2021-05-30T20:54:14.105Z] └─TopN_29	100.00	100	root		time:1m20.8s, loops:2	Column#72:desc, tpch50.supplier.s_name, offset:0, count:100	58.3 KB	N/A
20:54:14 [2021-05-30T20:54:14.105Z]   └─HashAgg_34	12800.00	20057	root		time:1m20.8s, loops:21, partial_worker:{wall_time:1m20.781703757s, concurrency:5, task_num:197, tot_wait:6m43.626186614s, tot_exec:267.417857ms, tot_time:6m43.906576397s, max:1m20.781679222s, p95:1m20.781679222s}, final_worker:{wall_time:1m20.793814836s, concurrency:5, task_num:25, tot_wait:6m43.905779686s, tot_exec:62.8735ms, tot_time:6m43.968665854s, max:1m20.793787641s, p95:1m20.793787641s}	group by:tpch50.supplier.s_name, funcs:count(1)->Column#72, funcs:firstrow(tpch50.supplier.s_name)->tpch50.supplier.s_name	17.3 MB	N/A
20:54:14 [2021-05-30T20:54:14.105Z]     └─IndexHashJoin_42	7828961.66	198698	root		time:1m20.8s, loops:198, inner:{total:2m18.2s, concurrency:5, task:146, construct:6.6s, fetch:1m54.6s, build:1.23s, join:17s}	anti semi join, inner:IndexLookUp_39, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey)	641.1 MB	N/A
20:54:14 [2021-05-30T20:54:14.105Z]       ├─IndexHashJoin_83(Build)	9786202.08	3542799	root		time:1m20.2s, loops:3463, inner:{total:2m30.8s, concurrency:5, task:152, construct:7.88s, fetch:2m4.4s, build:1.36s, join:18.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:54:14 [2021-05-30T20:54:14.105Z]       │ ├─IndexJoin_99(Build)	12232752.60	3675878	root		time:1m19.6s, loops:3595, inner:{total:2m9.5s, concurrency:5, task:305, construct:16.3s, fetch:1m51.3s, build:1.94s}, probe:5.37s	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)	582.1 MB	N/A
20:54:14 [2021-05-30T20:54:14.105Z]       │ │ ├─HashJoin_107(Build)	12232752.60	7609895	root		time:1m18.8s, loops:7436, build_hash_table:{total:1.11s, fetch:1.1s, build:6.61ms}, probe:{concurrency:5, total:6m36.5s, max:1m19.3s, probe:1m4.3s, fetch:5m32.2s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.lineitem.l_suppkey)]	722.8 KB	0 Bytes
20:54:14 [2021-05-30T20:54:14.105Z]       │ │ │ ├─HashJoin_120(Build)	20000.00	20058	root		time:1.1s, loops:22, build_hash_table:{total:230.1µs, fetch:224.5µs, build:5.57µs}, probe:{concurrency:5, total:5.52s, max:1.1s, probe:62.2ms, fetch:5.46s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:54:14 [2021-05-30T20:54:14.105Z]       │ │ │ │ ├─TableReader_125(Build)	1.00	1	root		time:55.9µs, loops:2, cop_task: {num: 1, max: 1.41ms, proc_keys: 25, tot_proc: 1ms, rpc_num: 1, rpc_time: 1.35ms, copr_cache: disabled}	data:Selection_124	248 Bytes	N/A
20:54:14 [2021-05-30T20:54:14.105Z]       │ │ │ │ │ └─Selection_124	1.00	1	cop[tikv]		tikv_task:{time:1ms, loops:1}, scan_detail: {total_process_keys: 25, total_keys: 26, rocksdb: {delete_skipped_count: 0, key_skipped_count: 46, block: {cache_hit_count: 17, read_count: 1, read_byte: 23.8 KB}}}	eq(tpch50.nation.n_name, "EGYPT")	N/A	N/A
20:54:14 [2021-05-30T20:54:14.105Z]       │ │ │ │ │   └─TableFullScan_123	25.00	25	cop[tikv]	table:nation	tikv_task:{time:1ms, loops:1}	keep order:false	N/A	N/A
20:54:14 [2021-05-30T20:54:14.105Z]       │ │ │ │ └─TableReader_122(Probe)	500000.00	500000	root		time:1.09s, loops:490, cop_task: {num: 1, max: 1.09s, proc_keys: 500000, tot_proc: 1.06s, rpc_num: 1, rpc_time: 1.09s, copr_cache: disabled}	data:TableFullScan_121	20.0 MB	N/A
20:54:14 [2021-05-30T20:54:14.105Z]       │ │ │ │   └─TableFullScan_121	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:999ms, loops:493}, scan_detail: {total_process_keys: 500000, total_keys: 500001, rocksdb: {delete_skipped_count: 0, key_skipped_count: 999999, block: {cache_hit_count: 13, read_count: 1679, read_byte: 104.5 MB}}}	keep order:false	N/A	N/A
20:54:14 [2021-05-30T20:54:14.105Z]       │ │ │ └─TableReader_128(Probe)	240004648.80	189670348	root		time:1m5.8s, loops:184597, cop_task: {num: 761, max: 2.82s, min: 324.3ms, avg: 1.52s, p95: 1.97s, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 18m3.3s, tot_wait: 1m0.7s, rpc_num: 761, rpc_time: 19m18.7s, copr_cache: disabled}	data:Selection_127	109.4 MB	N/A
20:54:14 [2021-05-30T20:54:14.105Z]       │ │ │   └─Selection_127	240004648.80	189670348	cop[tikv]		tikv_task:{proc max:1.29s, min:301ms, 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: 10455, read_count: 1114193, read_byte: 23.6 GB}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:54:14 [2021-05-30T20:54:14.105Z]       │ │ │     └─TableFullScan_126	300005811.00	300005811	cop[tikv]	table:l1	tikv_task:{proc max:1.2s, min:281ms, p80:1.08s, p95:1.12s, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:54:14 [2021-05-30T20:54:14.105Z]       │ │ └─TableReader_95(Probe)	0.49	3496200	root		time:1m42.1s, loops:3875, cop_task: {num: 5260, max: 510.9ms, min: 574.2µs, avg: 181.3ms, p95: 338.8ms, max_proc_keys: 4452, p95_proc_keys: 1964, tot_proc: 11m15.6s, tot_wait: 3m50.7s, rpc_num: 5260, rpc_time: 15m53.4s, copr_cache: disabled}	data:Selection_94	N/A	N/A
20:54:14 [2021-05-30T20:54:14.105Z]       │ │   └─Selection_94	0.49	3496200	cop[tikv]		tikv_task:{proc max:187ms, min:0s, p80:69ms, p95:83ms, iters:30211, tasks:5260}, scan_detail: {total_process_keys: 7236302, total_keys: 7795575, rocksdb: {delete_skipped_count: 0, key_skipped_count: 1778509, block: {cache_hit_count: 54006826, read_count: 218184, read_byte: 4.21 GB}}}	eq(tpch50.orders.o_orderstatus, "F")	N/A	N/A
20:54:14 [2021-05-30T20:54:14.105Z]       │ │     └─TableRangeScan_93	1.00	7236302	cop[tikv]	table:orders	tikv_task:{proc max:187ms, min:0s, p80:69ms, p95:82ms, iters:30211, tasks:5260}	range: decided by [tpch50.lineitem.l_orderkey], keep order:false	N/A	N/A
20:54:14 [2021-05-30T20:54:14.105Z]       │ └─IndexLookUp_80(Probe)	4.05	17316523	root		time:1m58.8s, loops:17131, index_task: {total_time: 1m5.2s, fetch_handle: 57.1s, build: 3.19ms, wait: 8.17s}, table_task: {total_time: 8m33.3s, num: 1458, concurrency: 760}		19.0 KB	N/A
20:54:14 [2021-05-30T20:54:14.105Z]       │   ├─IndexRangeScan_78(Build)	4.05	17316523	cop[tikv]	table:l2, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:54.7s, loops:18627, cop_task: {num: 2972, max: 900.7ms, min: 413.3µs, avg: 190ms, p95: 372.3ms, max_proc_keys: 10957, p95_proc_keys: 8723, tot_proc: 7m0.3s, tot_wait: 1m59.1s, rpc_num: 2972, rpc_time: 9m24.5s, copr_cache: disabled}, tikv_task:{proc max:186ms, min:0s, p80:96ms, p95:111ms, iters:30087, tasks:2972}, scan_detail: {total_process_keys: 17316523, total_keys: 20812639, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17316523, block: {cache_hit_count: 24260053, read_count: 225686, read_byte: 2.00 GB}}}	range: decided by [eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey)], keep order:false	N/A	N/A
20:54:14 [2021-05-30T20:54:14.105Z]       │   └─TableRowIDScan_79(Probe)	4.05	17316523	cop[tikv]	table:l2	time:6m19.1s, loops:20995, cop_task: {num: 7797, max: 696.6ms, min: 498.5µs, avg: 177.8ms, p95: 358.1ms, max_proc_keys: 10903, p95_proc_keys: 4847, tot_proc: 16m31.9s, tot_wait: 5m35.6s, rpc_num: 7797, rpc_time: 23m5.8s, copr_cache: disabled}, tikv_task:{proc max:246ms, min:0s, p80:105ms, p95:141ms, iters:49973, tasks:7797}, scan_detail: {total_process_keys: 17316523, total_keys: 18288906, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5627971, block: {cache_hit_count: 99016965, read_count: 1114, read_byte: 398.5 MB}}}	keep order:false	N/A	N/A
20:54:14 [2021-05-30T20:54:14.105Z]       └─IndexLookUp_39(Probe)	4.05	12022838	root		time:1m49.5s, loops:11945, index_task: {total_time: 58.6s, fetch_handle: 48s, build: 3.12ms, wait: 10.6s}, table_task: {total_time: 7m55.3s, num: 1408, concurrency: 730}		206.9 KB	N/A
20:54:14 [2021-05-30T20:54:14.105Z]         ├─IndexRangeScan_36(Build)	5.06	17183423	cop[tikv]	table:l3, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:45.7s, loops:18353, cop_task: {num: 2758, max: 693.6ms, min: 794.2µs, avg: 165.8ms, p95: 345.9ms, max_proc_keys: 24372, p95_proc_keys: 13741, tot_proc: 5m36.8s, tot_wait: 1m37.2s, rpc_num: 2758, rpc_time: 7m37.3s, copr_cache: disabled}, tikv_task:{proc max:222ms, min:0s, p80:78ms, p95:122ms, iters:28975, tasks:2758}, scan_detail: {total_process_keys: 17183423, total_keys: 20546456, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17183423, block: {cache_hit_count: 23554038, read_count: 0, read_byte: 0 Bytes}}}	range: decided by [eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey)], keep order:false	N/A	N/A
20:54:14 [2021-05-30T20:54:14.105Z]         └─Selection_38(Probe)	4.05	12022838	cop[tikv]		time:6m4.2s, loops:13776, cop_task: {num: 10200, max: 639.1ms, min: 616.2µs, avg: 168.9ms, p95: 341.9ms, max_proc_keys: 7996, p95_proc_keys: 4003, tot_proc: 20m0.4s, tot_wait: 7m25.3s, rpc_num: 10200, rpc_time: 28m42.8s, copr_cache: disabled}, tikv_task:{proc max:242ms, min:0s, p80:77ms, p95:117ms, iters:60564, tasks:10200}, scan_detail: {total_process_keys: 17183423, total_keys: 18128925, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5526684, block: {cache_hit_count: 98285695, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:54:14 [2021-05-30T20:54:14.105Z]           └─TableRowIDScan_37	5.06	17183423	cop[tikv]	table:l3	tikv_task:{proc max:240ms, min:0s, p80:77ms, p95:117ms, iters:60564, tasks:10200}	keep order:false	N/A	N/A
20:54:14 [2021-05-30T20:54:14.105Z] + sync
20:54:14 [2021-05-30T20:54:14.105Z] + /usr/bin/echo 3
20:55:45 [2021-05-30T20:55:45.533Z] 
20:55:45 [2021-05-30T20:55:45.533Z] queries/21.sql
20:55:45 [2021-05-30T20:55:45.533Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:55:45 [2021-05-30T20:55:45.533Z] Projection_26	100.00	100	root		time:1m20.7s, loops:2, Concurrency:OFF	tpch50.supplier.s_name, Column#72	4.37 KB	N/A
20:55:45 [2021-05-30T20:55:45.533Z] └─TopN_29	100.00	100	root		time:1m20.7s, loops:2	Column#72:desc, tpch50.supplier.s_name, offset:0, count:100	58.3 KB	N/A
20:55:45 [2021-05-30T20:55:45.533Z]   └─HashAgg_34	12800.00	20057	root		time:1m20.7s, loops:21, partial_worker:{wall_time:1m20.71425828s, concurrency:5, task_num:197, tot_wait:6m43.278259143s, tot_exec:260.813813ms, tot_time:6m43.558315536s, max:1m20.714181948s, p95:1m20.714181948s}, final_worker:{wall_time:1m20.728503278s, concurrency:5, task_num:25, tot_wait:6m43.553298167s, tot_exec:79.896315ms, tot_time:6m43.633222536s, max:1m20.72845762s, p95:1m20.72845762s}	group by:tpch50.supplier.s_name, funcs:count(1)->Column#72, funcs:firstrow(tpch50.supplier.s_name)->tpch50.supplier.s_name	17.3 MB	N/A
20:55:45 [2021-05-30T20:55:45.533Z]     └─IndexHashJoin_42	7828961.66	198698	root		time:1m20.7s, loops:198, inner:{total:2m22.3s, concurrency:5, task:146, construct:6.26s, fetch:1m59s, build:1.25s, join:17s}	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:45 [2021-05-30T20:55:45.533Z]       ├─IndexHashJoin_83(Build)	9786202.08	3542799	root		time:1m20.2s, loops:3463, inner:{total:2m28.9s, concurrency:5, task:152, construct:8.05s, fetch:2m2.9s, build:1.32s, 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:55:45 [2021-05-30T20:55:45.533Z]       │ ├─IndexJoin_99(Build)	12232752.60	3675878	root		time:1m19.6s, loops:3595, inner:{total:2m9.2s, concurrency:5, task:305, construct:16s, fetch:1m51.3s, build:1.85s}, 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)	582.0 MB	N/A
20:55:45 [2021-05-30T20:55:45.533Z]       │ │ ├─HashJoin_107(Build)	12232752.60	7609895	root		time:1m19s, loops:7437, build_hash_table:{total:1.04s, fetch:1.03s, build:7.91ms}, probe:{concurrency:5, total:6m37.8s, max:1m19.6s, probe:1m3.8s, fetch:5m34s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.lineitem.l_suppkey)]	752.0 KB	0 Bytes
20:55:45 [2021-05-30T20:55:45.533Z]       │ │ │ ├─HashJoin_120(Build)	20000.00	20058	root		time:1.04s, loops:23, build_hash_table:{total:186.3µs, fetch:178.5µs, build:7.82µs}, probe:{concurrency:5, total:5.18s, max:1.04s, probe:74.2ms, fetch:5.11s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:55:45 [2021-05-30T20:55:45.533Z]       │ │ │ │ ├─TableReader_125(Build)	1.00	1	root		time:64.6µs, loops:2, cop_task: {num: 1, max: 1.41ms, proc_keys: 25, tot_proc: 1ms, rpc_num: 1, rpc_time: 1.38ms, copr_cache: disabled}	data:Selection_124	248 Bytes	N/A
20:55:45 [2021-05-30T20:55:45.533Z]       │ │ │ │ │ └─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:55:45 [2021-05-30T20:55:45.533Z]       │ │ │ │ │   └─TableFullScan_123	25.00	25	cop[tikv]	table:nation	tikv_task:{time:1ms, loops:1}	keep order:false	N/A	N/A
20:55:45 [2021-05-30T20:55:45.533Z]       │ │ │ │ └─TableReader_122(Probe)	500000.00	500000	root		time:1.02s, loops:490, cop_task: {num: 1, max: 1.02s, proc_keys: 500000, tot_proc: 986ms, rpc_num: 1, rpc_time: 1.02s, copr_cache: disabled}	data:TableFullScan_121	20.0 MB	N/A
20:55:45 [2021-05-30T20:55:45.533Z]       │ │ │ │   └─TableFullScan_121	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:904ms, 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:45 [2021-05-30T20:55:45.533Z]       │ │ │ └─TableReader_128(Probe)	240004648.80	189670348	root		time:1m6.3s, loops:184597, cop_task: {num: 761, max: 2.7s, min: 263.8ms, avg: 1.53s, p95: 2.04s, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 18m4.7s, tot_wait: 1m1.7s, rpc_num: 761, rpc_time: 19m21s, copr_cache: disabled}	data:Selection_127	109.4 MB	N/A
20:55:45 [2021-05-30T20:55:45.534Z]       │ │ │   └─Selection_127	240004648.80	189670348	cop[tikv]		tikv_task:{proc max:1.28s, min:247ms, 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:55:45 [2021-05-30T20:55:45.534Z]       │ │ │     └─TableFullScan_126	300005811.00	300005811	cop[tikv]	table:l1	tikv_task:{proc max:1.19s, min:238ms, p80:1.08s, p95:1.12s, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:55:45 [2021-05-30T20:55:45.534Z]       │ │ └─TableReader_95(Probe)	0.49	3496191	root		time:1m42.5s, loops:3875, cop_task: {num: 5285, max: 535.2ms, min: 1.81ms, avg: 180.9ms, p95: 342.7ms, max_proc_keys: 3626, p95_proc_keys: 1948, tot_proc: 11m21.9s, tot_wait: 3m46.9s, rpc_num: 5285, rpc_time: 15m55.9s, copr_cache: disabled}	data:Selection_94	N/A	N/A
20:55:45 [2021-05-30T20:55:45.534Z]       │ │   └─Selection_94	0.49	3496191	cop[tikv]		tikv_task:{proc max:142ms, min:0s, p80:69ms, p95:82ms, iters:30263, tasks:5285}, scan_detail: {total_process_keys: 7236280, total_keys: 7795518, rocksdb: {delete_skipped_count: 0, key_skipped_count: 1778382, block: {cache_hit_count: 54006393, read_count: 218170, read_byte: 4.21 GB}}}	eq(tpch50.orders.o_orderstatus, "F")	N/A	N/A
20:55:45 [2021-05-30T20:55:45.534Z]       │ │     └─TableRangeScan_93	1.00	7236280	cop[tikv]	table:orders	tikv_task:{proc max:142ms, min:0s, p80:69ms, p95:81ms, iters:30263, tasks:5285}	range: decided by [tpch50.lineitem.l_orderkey], keep order:false	N/A	N/A
20:55:45 [2021-05-30T20:55:45.534Z]       │ └─IndexLookUp_80(Probe)	4.05	17316393	root		time:1m57.4s, loops:17127, index_task: {total_time: 1m5s, fetch_handle: 56.8s, build: 3.1ms, wait: 8.24s}, table_task: {total_time: 8m28.9s, num: 1458, concurrency: 760}		19.1 KB	N/A
20:55:45 [2021-05-30T20:55:45.534Z]       │   ├─IndexRangeScan_78(Build)	4.05	17316393	cop[tikv]	table:l2, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:54.5s, loops:18622, cop_task: {num: 2987, max: 681.8ms, min: 490.3µs, avg: 188.7ms, p95: 374.7ms, max_proc_keys: 14173, p95_proc_keys: 8755, tot_proc: 6m55.7s, tot_wait: 2m2.8s, rpc_num: 2987, rpc_time: 9m23.6s, copr_cache: disabled}, tikv_task:{proc max:203ms, min:0s, p80:95ms, p95:111ms, iters:30069, tasks:2987}, scan_detail: {total_process_keys: 17316393, total_keys: 20812487, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17316393, block: {cache_hit_count: 24259907, read_count: 225678, 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:45 [2021-05-30T20:55:45.534Z]       │   └─TableRowIDScan_79(Probe)	4.05	17316393	cop[tikv]	table:l2	time:6m17.8s, loops:21038, cop_task: {num: 7842, max: 618.1ms, min: 544.1µs, avg: 178.2ms, p95: 357.8ms, max_proc_keys: 12871, p95_proc_keys: 4860, tot_proc: 16m38.5s, tot_wait: 5m41s, rpc_num: 7842, rpc_time: 23m17.3s, copr_cache: disabled}, tikv_task:{proc max:272ms, min:0s, p80:105ms, p95:142ms, iters:50052, tasks:7842}, scan_detail: {total_process_keys: 17316393, total_keys: 18287462, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5618765, block: {cache_hit_count: 99033650, read_count: 1111, read_byte: 394.3 MB}}}	keep order:false	N/A	N/A
20:55:45 [2021-05-30T20:55:45.534Z]       └─IndexLookUp_39(Probe)	4.05	12022787	root		time:1m54.1s, loops:11946, index_task: {total_time: 1m0.8s, fetch_handle: 49.7s, build: 3.44ms, wait: 11.1s}, table_task: {total_time: 8m9.4s, num: 1408, concurrency: 730}		270.4 KB	N/A
20:55:45 [2021-05-30T20:55:45.534Z]         ├─IndexRangeScan_36(Build)	5.06	17183377	cop[tikv]	table:l3, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:47.4s, loops:18335, cop_task: {num: 2722, max: 778.1ms, min: 415.8µs, avg: 168.1ms, p95: 356.2ms, max_proc_keys: 20919, p95_proc_keys: 13855, tot_proc: 5m40.4s, tot_wait: 1m33.8s, rpc_num: 2722, rpc_time: 7m37.5s, copr_cache: disabled}, tikv_task:{proc max:190ms, min:0s, p80:80ms, p95:122ms, iters:28843, tasks:2722}, scan_detail: {total_process_keys: 17183377, total_keys: 20546405, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17183377, block: {cache_hit_count: 23554002, read_count: 0, read_byte: 0 Bytes}}}	range: decided by [eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey)], keep order:false	N/A	N/A
20:55:45 [2021-05-30T20:55:45.534Z]         └─Selection_38(Probe)	4.05	12022787	cop[tikv]		time:6m16.2s, loops:13770, cop_task: {num: 10313, max: 640.5ms, min: 398.7µs, avg: 176.3ms, p95: 355.1ms, max_proc_keys: 7909, p95_proc_keys: 3882, tot_proc: 21m11.7s, tot_wait: 7m50.1s, rpc_num: 10313, rpc_time: 30m18.2s, copr_cache: disabled}, tikv_task:{proc max:234ms, min:0s, p80:77ms, p95:116ms, iters:60961, tasks:10313}, scan_detail: {total_process_keys: 17183377, total_keys: 18128682, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5525085, block: {cache_hit_count: 98289371, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:55:45 [2021-05-30T20:55:45.534Z]           └─TableRowIDScan_37	5.06	17183377	cop[tikv]	table:l3	tikv_task:{proc max:231ms, min:0s, p80:76ms, p95:115ms, iters:60961, tasks:10313}	keep order:false	N/A	N/A
20:55:45 [2021-05-30T20:55:45.534Z] + sync
20:55:45 [2021-05-30T20:55:45.534Z] + /usr/bin/echo 3
20:57:08 [2021-05-30T20:57:08.002Z] 
20:57:08 [2021-05-30T20:57:08.002Z] queries/21.sql
20:57:08 [2021-05-30T20:57:08.002Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:57:08 [2021-05-30T20:57:08.002Z] Projection_26	100.00	100	root		time:1m20.7s, loops:2, Concurrency:OFF	tpch50.supplier.s_name, Column#72	4.37 KB	N/A
20:57:08 [2021-05-30T20:57:08.002Z] └─TopN_29	100.00	100	root		time:1m20.7s, loops:2	Column#72:desc, tpch50.supplier.s_name, offset:0, count:100	55.0 KB	N/A
20:57:08 [2021-05-30T20:57:08.003Z]   └─HashAgg_34	12800.00	20057	root		time:1m20.7s, loops:21, partial_worker:{wall_time:1m20.733024215s, concurrency:5, task_num:197, tot_wait:6m43.386119028s, tot_exec:263.170125ms, tot_time:6m43.662796323s, max:1m20.732992507s, p95:1m20.732992507s}, final_worker:{wall_time:1m20.74500989s, concurrency:5, task_num:25, tot_wait:6m43.661114193s, tot_exec:63.206149ms, tot_time:6m43.72433157s, max:1m20.745002783s, p95:1m20.745002783s}	group by:tpch50.supplier.s_name, funcs:count(1)->Column#72, funcs:firstrow(tpch50.supplier.s_name)->tpch50.supplier.s_name	17.3 MB	N/A
20:57:08 [2021-05-30T20:57:08.003Z]     └─IndexHashJoin_42	7828961.66	198698	root		time:1m20.7s, loops:198, inner:{total:2m20.1s, concurrency:5, task:146, construct:5.87s, fetch:1m57.3s, build:1.21s, join:16.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:57:08 [2021-05-30T20:57:08.003Z]       ├─IndexHashJoin_83(Build)	9786202.08	3542799	root		time:1m20.2s, loops:3462, inner:{total:2m28.6s, concurrency:5, task:152, construct:7.51s, fetch:2m3.3s, build:1.25s, join:17.7s}	semi join, inner:IndexLookUp_80, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey), ne(tpch50.lineitem.l_suppkey, tpch50.supplier.s_suppkey)	555.9 MB	N/A
20:57:08 [2021-05-30T20:57:08.003Z]       │ ├─IndexJoin_99(Build)	12232752.60	3675878	root		time:1m19.6s, loops:3595, inner:{total:2m5.7s, concurrency:5, task:305, construct:15.9s, fetch:1m48s, build:1.81s}, probe:5.08s	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)	581.9 MB	N/A
20:57:08 [2021-05-30T20:57:08.003Z]       │ │ ├─HashJoin_107(Build)	12232752.60	7609895	root		time:1m19.1s, loops:7436, build_hash_table:{total:1.08s, fetch:1.07s, build:7.36ms}, probe:{concurrency:5, total:6m37.8s, max:1m19.6s, probe:1m2.6s, fetch:5m35.1s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.lineitem.l_suppkey)]	747.3 KB	0 Bytes
20:57:08 [2021-05-30T20:57:08.003Z]       │ │ │ ├─HashJoin_120(Build)	20000.00	20058	root		time:1.07s, loops:23, build_hash_table:{total:280µs, fetch:272.1µs, build:7.92µs}, probe:{concurrency:5, total:5.37s, max:1.07s, probe:66.7ms, fetch:5.31s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:57:08 [2021-05-30T20:57:08.003Z]       │ │ │ │ ├─TableReader_125(Build)	1.00	1	root		time:60.5µs, loops:2, cop_task: {num: 1, max: 1.41ms, proc_keys: 25, tot_proc: 1ms, rpc_num: 1, rpc_time: 1.38ms, copr_cache: disabled}	data:Selection_124	248 Bytes	N/A
20:57:08 [2021-05-30T20:57:08.003Z]       │ │ │ │ │ └─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:57:08 [2021-05-30T20:57:08.003Z]       │ │ │ │ │   └─TableFullScan_123	25.00	25	cop[tikv]	table:nation	tikv_task:{time:1ms, loops:1}	keep order:false	N/A	N/A
20:57:08 [2021-05-30T20:57:08.003Z]       │ │ │ │ └─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:57:08 [2021-05-30T20:57:08.003Z]       │ │ │ │   └─TableFullScan_121	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:971ms, 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:57:08 [2021-05-30T20:57:08.003Z]       │ │ │ └─TableReader_128(Probe)	240004648.80	189670348	root		time:1m6.4s, loops:184597, cop_task: {num: 761, max: 2.69s, min: 280ms, avg: 1.53s, p95: 1.99s, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 18m7.7s, tot_wait: 58.7s, rpc_num: 761, rpc_time: 19m20.7s, copr_cache: disabled}	data:Selection_127	109.4 MB	N/A
20:57:08 [2021-05-30T20:57:08.003Z]       │ │ │   └─Selection_127	240004648.80	189670348	cop[tikv]		tikv_task:{proc max:1.27s, min:263ms, 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: 10455, read_count: 1114193, read_byte: 23.6 GB}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:57:08 [2021-05-30T20:57:08.003Z]       │ │ │     └─TableFullScan_126	300005811.00	300005811	cop[tikv]	table:l1	tikv_task:{proc max:1.2s, min:255ms, p80:1.08s, p95:1.13s, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:57:08 [2021-05-30T20:57:08.003Z]       │ │ └─TableReader_95(Probe)	0.49	3496194	root		time:1m39.1s, loops:3875, cop_task: {num: 5265, max: 555.2ms, min: 2.16ms, avg: 177.6ms, p95: 347.1ms, max_proc_keys: 4117, p95_proc_keys: 1968, tot_proc: 11m5.5s, tot_wait: 3m42.3s, rpc_num: 5265, rpc_time: 15m35s, copr_cache: disabled}	data:Selection_94	N/A	N/A
20:57:08 [2021-05-30T20:57:08.003Z]       │ │   └─Selection_94	0.49	3496194	cop[tikv]		tikv_task:{proc max:175ms, min:0s, p80:69ms, p95:82ms, iters:30214, tasks:5265}, scan_detail: {total_process_keys: 7236304, total_keys: 7795557, rocksdb: {delete_skipped_count: 0, key_skipped_count: 1778449, block: {cache_hit_count: 54006594, read_count: 218261, read_byte: 4.21 GB}}}	eq(tpch50.orders.o_orderstatus, "F")	N/A	N/A
20:57:08 [2021-05-30T20:57:08.003Z]       │ │     └─TableRangeScan_93	1.00	7236304	cop[tikv]	table:orders	tikv_task:{proc max:175ms, min:0s, p80:69ms, p95:82ms, iters:30214, tasks:5265}	range: decided by [tpch50.lineitem.l_orderkey], keep order:false	N/A	N/A
20:57:08 [2021-05-30T20:57:08.003Z]       │ └─IndexLookUp_80(Probe)	4.05	17316553	root		time:1m57.9s, loops:17127, index_task: {total_time: 1m4.6s, fetch_handle: 54.1s, build: 3.07ms, wait: 10.5s}, table_task: {total_time: 8m32.8s, num: 1458, concurrency: 760}		19.0 KB	N/A
20:57:08 [2021-05-30T20:57:08.003Z]       │   ├─IndexRangeScan_78(Build)	4.05	17316553	cop[tikv]	table:l2, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:51.8s, loops:18577, cop_task: {num: 2978, max: 629.9ms, min: 333µs, avg: 183.4ms, p95: 374.4ms, max_proc_keys: 13277, p95_proc_keys: 8736, tot_proc: 6m51.6s, tot_wait: 1m49.5s, rpc_num: 2978, rpc_time: 9m6.2s, copr_cache: disabled}, tikv_task:{proc max:166ms, min:0s, p80:96ms, p95:111ms, iters:30027, tasks:2978}, scan_detail: {total_process_keys: 17316553, total_keys: 20812672, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17316553, block: {cache_hit_count: 24260081, read_count: 225679, read_byte: 2.00 GB}}}	range: decided by [eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey)], keep order:false	N/A	N/A
20:57:08 [2021-05-30T20:57:08.003Z]       │   └─TableRowIDScan_79(Probe)	4.05	17316553	cop[tikv]	table:l2	time:6m25.9s, loops:20989, cop_task: {num: 7823, max: 593.9ms, min: 734.2µs, avg: 180.7ms, p95: 371ms, max_proc_keys: 12685, p95_proc_keys: 4872, tot_proc: 16m56.8s, tot_wait: 5m39s, rpc_num: 7823, rpc_time: 23m33.6s, copr_cache: disabled}, tikv_task:{proc max:237ms, min:0s, p80:106ms, p95:143ms, iters:49984, tasks:7823}, scan_detail: {total_process_keys: 17316553, total_keys: 18288808, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5624689, block: {cache_hit_count: 99026721, read_count: 1110, read_byte: 392.4 MB}}}	keep order:false	N/A	N/A
20:57:08 [2021-05-30T20:57:08.003Z]       └─IndexLookUp_39(Probe)	4.05	12022831	root		time:1m52.6s, loops:11945, index_task: {total_time: 1m0.5s, fetch_handle: 50.3s, build: 4.79ms, wait: 10.2s}, table_task: {total_time: 8m6.1s, num: 1408, concurrency: 730}		219.4 KB	N/A
20:57:08 [2021-05-30T20:57:08.003Z]         ├─IndexRangeScan_36(Build)	5.06	17183438	cop[tikv]	table:l3, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:48s, loops:18331, cop_task: {num: 2763, max: 740.6ms, min: 690.3µs, avg: 167.7ms, p95: 368.2ms, max_proc_keys: 17365, p95_proc_keys: 13992, tot_proc: 5m39.7s, tot_wait: 1m39.7s, rpc_num: 2763, rpc_time: 7m43.2s, copr_cache: disabled}, tikv_task:{proc max:176ms, min:0s, p80:78ms, p95:124ms, iters:28929, tasks:2763}, scan_detail: {total_process_keys: 17183438, total_keys: 20546475, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17183438, block: {cache_hit_count: 23554065, 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:57:08 [2021-05-30T20:57:08.003Z]         └─Selection_38(Probe)	4.05	12022831	cop[tikv]		time:6m14.4s, loops:13773, cop_task: {num: 10314, max: 612.9ms, min: 433.3µs, avg: 173.5ms, p95: 355.8ms, max_proc_keys: 7839, p95_proc_keys: 3955, tot_proc: 20m55.5s, tot_wait: 7m36.9s, rpc_num: 10314, rpc_time: 29m49.1s, copr_cache: disabled}, tikv_task:{proc max:213ms, min:0s, p80:77ms, p95:117ms, iters:60927, tasks:10314}, scan_detail: {total_process_keys: 17183438, total_keys: 18129022, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5527314, block: {cache_hit_count: 98287414, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:57:08 [2021-05-30T20:57:08.003Z]           └─TableRowIDScan_37	5.06	17183438	cop[tikv]	table:l3	tikv_task:{proc max:204ms, min:0s, p80:77ms, p95:116ms, iters:60927, tasks:10314}	keep order:false	N/A	N/A
20:57:08 [2021-05-30T20:57:08.003Z] + tiup cluster stop benchbot -y
20:57:08 [2021-05-30T20:57:08.003Z] Starting component `cluster`: /home/tidb/.tiup/components/cluster/v1.4.4/tiup-cluster stop benchbot -y
20:57:23 [2021-05-30T20:57:23.742Z] + rm -rf '/data1/tidb-deploy/*/log/*'
20:57:23 [2021-05-30T20:57:23.742Z] + rm -rf /data1/jenkins/deploy/data/tikv-20160
20:57:23 [2021-05-30T20:57:23.742Z] + rm -rf /data1/jenkins/deploy/data/pd-2379
20:57:23 [2021-05-30T20:57:23.742Z] + rm -rf /data1/jenkins/restore_data/tpch50/data/last_tikv.toml
20:57:23 [2021-05-30T20:57:23.742Z] + cp -R /data1/jenkins/restore_data/tpch50/data /data1/jenkins/deploy/data/tikv-20160
20:58:58 [2021-05-30T20:58:58.584Z] + cp -R /data1/jenkins/restore_data/tpch50/data.pd /data1/jenkins/deploy/data/pd-2379
20:58:58 [2021-05-30T20:58:58.839Z] + '[' -n '' ']'
20:58:58 [2021-05-30T20:58:58.839Z] + tiup cluster start benchbot --wait-timeout=300
20:58:59 [2021-05-30T20:58:59.398Z] Starting component `cluster`: /home/tidb/.tiup/components/cluster/v1.4.4/tiup-cluster start benchbot --wait-timeout=300
20:59:37 [2021-05-30T20:59:37.415Z] + sync
20:59:37 [2021-05-30T20:59:37.415Z] + /usr/bin/echo 3
21:00:30 [2021-05-30T21:00:30.496Z] + sync
21:00:30 [2021-05-30T21:00:30.496Z] + /usr/bin/echo 3
21:00:37 [2021-05-30T21:00:37.028Z] + sync
21:00:37 [2021-05-30T21:00:37.028Z] + /usr/bin/echo 3
21:01:10 [2021-05-30T21:01:10.266Z] 
21:01:10 [2021-05-30T21:01:10.266Z] queries/22.sql
21:01:10 [2021-05-30T21:01:10.266Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
21:01:10 [2021-05-30T21:01:10.266Z] Sort_39	1600000.00	4	root		time:26.5s, loops:2	Column#27	9.48 KB	0 Bytes
21:01:10 [2021-05-30T21:01:10.266Z] └─Projection_41	1600000.00	4	root		time:26.5s, loops:5, Concurrency:5	Column#27, Column#28, Column#29	23.7 KB	N/A
21:01:10 [2021-05-30T21:01:10.266Z]   └─HashAgg_42	1600000.00	4	root		time:26.5s, loops:5, partial_worker:{wall_time:26.500835775s, concurrency:5, task_num:180, tot_wait:2m12.451350632s, tot_exec:51.638276ms, tot_time:2m12.503107082s, max:26.500764966s, p95:26.500764966s}, final_worker:{wall_time:26.500858466s, concurrency:5, task_num:20, tot_wait:2m12.503684438s, tot_exec:229.704µs, tot_time:2m12.503936514s, max:26.500795453s, p95:26.500795453s}	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:01:10 [2021-05-30T21:01:10.266Z]     └─Projection_51	1600000.00	181704	root		time:26.5s, loops:181, Concurrency:5	tpch50.customer.c_acctbal, substring(tpch50.customer.c_phone, 1, 2)->Column#32, substring(tpch50.customer.c_phone, 1, 2)->Column#33	703.6 KB	N/A
21:01:10 [2021-05-30T21:01:10.266Z]       └─HashJoin_43	1600000.00	181704	root		time:26.5s, loops:181, build_hash_table:{total:25s, fetch:1.1s, build:23.9s}, probe:{concurrency:5, total:2m12.5s, max:26.5s, probe:6.16s, fetch:2m6.3s}	anti semi join, equal:[eq(tpch50.customer.c_custkey, tpch50.orders.o_custkey)]	590.2 MB	0 Bytes
21:01:10 [2021-05-30T21:01:10.266Z]         ├─TableReader_49(Build)	75000000.00	75000000	root		time:1.12s, loops:73364, cop_task: {num: 153, max: 978.3ms, min: 269.9ms, avg: 590ms, p95: 874.5ms, max_proc_keys: 723875, p95_proc_keys: 553332, tot_proc: 1m29.4s, tot_wait: 43ms, rpc_num: 153, rpc_time: 1m30.3s, copr_cache: disabled}	data:TableFullScan_48	56.0 MB	N/A
21:01:10 [2021-05-30T21:01:10.266Z]         │ └─TableFullScan_48	75000000.00	75000000	cop[tikv]	table:orders	tikv_task:{proc max:949ms, min:255ms, p80:592ms, p95:845ms, 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: 3016, read_count: 219937, read_byte: 4.30 GB}}}	keep order:false	N/A	N/A
21:01:10 [2021-05-30T21:01:10.266Z]         └─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
21:01:10 [2021-05-30T21:01:10.266Z]           └─TableReader_46	2000000.00	3407619	root		time:510.4ms, loops:3319, cop_task: {num: 18, max: 1.16s, min: 445.9ms, avg: 786.8ms, p95: 1.16s, max_proc_keys: 582617, p95_proc_keys: 582617, tot_proc: 13.7s, tot_wait: 2ms, rpc_num: 18, rpc_time: 14.2s, copr_cache: disabled}	data:Selection_45	192.5 MB	N/A
21:01:10 [2021-05-30T21:01:10.266Z]             └─Selection_45	2000000.00	3407619	cop[tikv]		tikv_task:{proc max:1.1s, min:418ms, p80:882ms, p95:1.1s, iters:7404, tasks:18}, scan_detail: {total_process_keys: 7500000, total_keys: 7500018, rocksdb: {delete_skipped_count: 0, key_skipped_count: 14999982, block: {cache_hit_count: 28451, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.customer.c_acctbal, 5000.602894)	N/A	N/A
21:01:10 [2021-05-30T21:01:10.266Z]               └─TableFullScan_44	7500000.00	7500000	cop[tikv]	table:customer	tikv_task:{proc max:1.03s, min:373ms, p80:813ms, p95:1.03s, iters:7404, tasks:18}	keep order:false	N/A	N/A
21:01:10 [2021-05-30T21:01:10.266Z] 
21:01:10 [2021-05-30T21:01:10.266Z] queries/22.sql
21:01:10 [2021-05-30T21:01:10.266Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
21:01:10 [2021-05-30T21:01:10.266Z] Sort_39	2186432.06	4	root		time:26.4s, loops:2	Column#27	9.48 KB	0 Bytes
21:01:10 [2021-05-30T21:01:10.266Z] └─Projection_41	2186432.06	4	root		time:26.4s, loops:5, Concurrency:5	Column#27, Column#28, Column#29	23.7 KB	N/A
21:01:10 [2021-05-30T21:01:10.266Z]   └─HashAgg_42	2186432.06	4	root		time:26.4s, loops:5, partial_worker:{wall_time:26.359068977s, concurrency:5, task_num:180, tot_wait:2m11.745079296s, tot_exec:49.331482ms, tot_time:2m11.794516078s, max:26.359023597s, p95:26.359023597s}, final_worker:{wall_time:26.359077721s, concurrency:5, task_num:20, tot_wait:2m11.794979246s, tot_exec:257.878µs, tot_time:2m11.79524444s, max:26.359053253s, p95:26.359053253s}	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:01:10 [2021-05-30T21:01:10.266Z]     └─Projection_51	2186432.06	181704	root		time:26.4s, loops:181, Concurrency:5	tpch50.customer.c_acctbal, substring(tpch50.customer.c_phone, 1, 2)->Column#32, substring(tpch50.customer.c_phone, 1, 2)->Column#33	703.6 KB	N/A
21:01:10 [2021-05-30T21:01:10.266Z]       └─HashJoin_43	2186432.06	181704	root		time:26.4s, loops:181, build_hash_table:{total:25s, fetch:1.05s, build:23.9s}, probe:{concurrency:5, total:2m11.8s, max:26.4s, probe:5.76s, fetch:2m6s}	anti semi join, equal:[eq(tpch50.customer.c_custkey, tpch50.orders.o_custkey)]	590.2 MB	0 Bytes
21:01:10 [2021-05-30T21:01:10.266Z]         ├─TableReader_49(Build)	75000000.00	75000000	root		time:1.09s, loops:73364, cop_task: {num: 153, max: 1.21s, min: 244.9ms, avg: 536.1ms, p95: 923.4ms, max_proc_keys: 723875, p95_proc_keys: 553332, tot_proc: 1m21.3s, tot_wait: 27ms, rpc_num: 153, rpc_time: 1m22s, copr_cache: disabled}	data:TableFullScan_48	57.8 MB	N/A
21:01:10 [2021-05-30T21:01:10.266Z]         │ └─TableFullScan_48	75000000.00	75000000	cop[tikv]	table:orders	tikv_task:{proc max:1.19s, min:225ms, p80:579ms, p95:885ms, 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:01:10 [2021-05-30T21:01:10.266Z]         └─Selection_47(Probe)	2733040.07	545246	root		time:1.44s, loops:534	in(substring(tpch50.customer.c_phone, 1, 2), "20", "40", "22", "30", "39", "42", "21")	94.6 KB	N/A
21:01:10 [2021-05-30T21:01:10.266Z]           └─TableReader_46	2733040.07	3407619	root		time:588.4ms, loops:3319, cop_task: {num: 18, max: 1.26s, min: 479.5ms, avg: 891.7ms, p95: 1.26s, max_proc_keys: 582617, p95_proc_keys: 582617, tot_proc: 15.6s, rpc_num: 18, rpc_time: 16s, copr_cache: disabled}	data:Selection_45	192.5 MB	N/A
21:01:10 [2021-05-30T21:01:10.266Z]             └─Selection_45	2733040.07	3407619	cop[tikv]		tikv_task:{proc max:1.19s, min:434ms, p80:957ms, p95:1.19s, 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:01:10 [2021-05-30T21:01:10.266Z]               └─TableFullScan_44	7500000.00	7500000	cop[tikv]	table:customer	tikv_task:{proc max:1.1s, min:383ms, p80:885ms, p95:1.1s, iters:7404, tasks:18}	keep order:false	N/A	N/A
21:01:10 [2021-05-30T21:01:10.266Z] 
21:01:10 [2021-05-30T21:01:10.266Z] queries/22.sql
21:01:10 [2021-05-30T21:01:10.266Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
21:01:10 [2021-05-30T21:01:10.266Z] Sort_39	2186432.06	4	root		time:25.9s, loops:2	Column#27	9.48 KB	0 Bytes
21:01:10 [2021-05-30T21:01:10.266Z] └─Projection_41	2186432.06	4	root		time:25.9s, loops:5, Concurrency:5	Column#27, Column#28, Column#29	23.7 KB	N/A
21:01:10 [2021-05-30T21:01:10.266Z]   └─HashAgg_42	2186432.06	4	root		time:25.9s, loops:5, partial_worker:{wall_time:25.947390716s, concurrency:5, task_num:180, tot_wait:2m9.685533655s, tot_exec:50.579264ms, tot_time:2m9.736221248s, max:25.947319679s, p95:25.947319679s}, final_worker:{wall_time:25.947378615s, concurrency:5, task_num:20, tot_wait:2m9.736361298s, tot_exec:279.011µs, tot_time:2m9.736647709s, max:25.947353542s, p95:25.947353542s}	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:01:10 [2021-05-30T21:01:10.266Z]     └─Projection_51	2186432.06	181704	root		time:25.9s, loops:181, Concurrency:5	tpch50.customer.c_acctbal, substring(tpch50.customer.c_phone, 1, 2)->Column#32, substring(tpch50.customer.c_phone, 1, 2)->Column#33	703.6 KB	N/A
21:01:10 [2021-05-30T21:01:10.266Z]       └─HashJoin_43	2186432.06	181704	root		time:25.9s, loops:181, build_hash_table:{total:24.7s, fetch:908.3ms, build:23.8s}, probe:{concurrency:5, total:2m9.7s, max:25.9s, probe:5.29s, fetch:2m4.4s}	anti semi join, equal:[eq(tpch50.customer.c_custkey, tpch50.orders.o_custkey)]	590.2 MB	0 Bytes
21:01:10 [2021-05-30T21:01:10.266Z]         ├─TableReader_49(Build)	75000000.00	75000000	root		time:949.4ms, loops:73364, cop_task: {num: 153, max: 939.9ms, min: 239.8ms, avg: 491.5ms, p95: 788.4ms, max_proc_keys: 723875, p95_proc_keys: 553332, tot_proc: 1m14.5s, tot_wait: 50ms, rpc_num: 153, rpc_time: 1m15.2s, copr_cache: disabled}	data:TableFullScan_48	57.8 MB	N/A
21:01:10 [2021-05-30T21:01:10.266Z]         │ └─TableFullScan_48	75000000.00	75000000	cop[tikv]	table:orders	tikv_task:{proc max:916ms, min:228ms, p80:495ms, p95:759ms, 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:01:10 [2021-05-30T21:01:10.266Z]         └─Selection_47(Probe)	2733040.07	545246	root		time:1.43s, loops:534	in(substring(tpch50.customer.c_phone, 1, 2), "20", "40", "22", "30", "39", "42", "21")	94.6 KB	N/A
21:01:10 [2021-05-30T21:01:10.266Z]           └─TableReader_46	2733040.07	3407619	root		time:579ms, loops:3319, cop_task: {num: 18, max: 1.11s, min: 471.6ms, avg: 817.2ms, p95: 1.11s, max_proc_keys: 582617, p95_proc_keys: 582617, tot_proc: 14.3s, rpc_num: 18, rpc_time: 14.7s, copr_cache: disabled}	data:Selection_45	192.5 MB	N/A
21:01:10 [2021-05-30T21:01:10.266Z]             └─Selection_45	2733040.07	3407619	cop[tikv]		tikv_task:{proc max:1.03s, min:427ms, p80:952ms, p95:1.03s, 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:01:10 [2021-05-30T21:01:10.266Z]               └─TableFullScan_44	7500000.00	7500000	cop[tikv]	table:customer	tikv_task:{proc max:938ms, min:379ms, p80:889ms, p95:938ms, iters:7404, tasks:18}	keep order:false	N/A	N/A
21:01:10 [2021-05-30T21:01:10.266Z] + sync
21:01:10 [2021-05-30T21:01:10.266Z] + /usr/bin/echo 3
21:01:58 [2021-05-30T21:01:58.180Z] + sync
21:01:58 [2021-05-30T21:01:58.180Z] + /usr/bin/echo 3
21:02:04 [2021-05-30T21:02:04.714Z] + sync
21:02:04 [2021-05-30T21:02:04.714Z] + /usr/bin/echo 3
21:02:35 [2021-05-30T21:02:35.223Z] 
21:02:35 [2021-05-30T21:02:35.223Z] queries/22.sql
21:02:35 [2021-05-30T21:02:35.223Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
21:02:35 [2021-05-30T21:02:35.223Z] Sort_39	2186432.06	4	root		time:26s, loops:2	Column#27	9.48 KB	0 Bytes
21:02:35 [2021-05-30T21:02:35.223Z] └─Projection_41	2186432.06	4	root		time:26s, loops:5, Concurrency:5	Column#27, Column#28, Column#29	23.7 KB	N/A
21:02:35 [2021-05-30T21:02:35.223Z]   └─HashAgg_42	2186432.06	4	root		time:26s, loops:5, partial_worker:{wall_time:26.04561079s, concurrency:5, task_num:180, tot_wait:2m10.177903508s, tot_exec:48.818001ms, tot_time:2m10.226819358s, max:26.045570714s, p95:26.045570714s}, final_worker:{wall_time:26.045640655s, concurrency:5, task_num:20, tot_wait:2m10.227588865s, tot_exec:264.22µs, tot_time:2m10.22788031s, max:26.045589026s, p95:26.045589026s}	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:35 [2021-05-30T21:02:35.223Z]     └─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	703.6 KB	N/A
21:02:35 [2021-05-30T21:02:35.223Z]       └─HashJoin_43	2186432.06	181704	root		time:26s, loops:181, build_hash_table:{total:24.8s, fetch:945.5ms, build:23.8s}, probe:{concurrency:5, total:2m10.2s, max:26s, probe:5.14s, fetch:2m5.1s}	anti semi join, equal:[eq(tpch50.customer.c_custkey, tpch50.orders.o_custkey)]	590.2 MB	0 Bytes
21:02:35 [2021-05-30T21:02:35.223Z]         ├─TableReader_49(Build)	75000000.00	75000000	root		time:985.7ms, loops:73364, cop_task: {num: 153, max: 961.8ms, min: 240.1ms, avg: 497.9ms, p95: 879ms, max_proc_keys: 723875, p95_proc_keys: 553332, tot_proc: 1m15.4s, tot_wait: 40ms, rpc_num: 153, rpc_time: 1m16.2s, copr_cache: disabled}	data:TableFullScan_48	57.8 MB	N/A
21:02:35 [2021-05-30T21:02:35.223Z]         │ └─TableFullScan_48	75000000.00	75000000	cop[tikv]	table:orders	tikv_task:{proc max:930ms, min:227ms, p80:478ms, p95:840ms, iters:73975, tasks:153}, scan_detail: {total_process_keys: 75000000, total_keys: 75000153, rocksdb: {delete_skipped_count: 0, key_skipped_count: 149999847, block: {cache_hit_count: 220923, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
21:02:35 [2021-05-30T21:02:35.223Z]         └─Selection_47(Probe)	2733040.07	545246	root		time:1.35s, loops:534	in(substring(tpch50.customer.c_phone, 1, 2), "20", "40", "22", "30", "39", "42", "21")	94.6 KB	N/A
21:02:35 [2021-05-30T21:02:35.223Z]           └─TableReader_46	2733040.07	3407619	root		time:519ms, loops:3319, cop_task: {num: 18, max: 1.16s, min: 427.2ms, avg: 845.3ms, p95: 1.16s, max_proc_keys: 582617, p95_proc_keys: 582617, tot_proc: 14.8s, tot_wait: 1ms, rpc_num: 18, rpc_time: 15.2s, copr_cache: disabled}	data:Selection_45	192.5 MB	N/A
21:02:35 [2021-05-30T21:02:35.223Z]             └─Selection_45	2733040.07	3407619	cop[tikv]		tikv_task:{proc max:1.09s, min:395ms, p80:913ms, p95:1.09s, iters:7404, tasks:18}, scan_detail: {total_process_keys: 7500000, total_keys: 7500018, rocksdb: {delete_skipped_count: 0, key_skipped_count: 14999982, block: {cache_hit_count: 28451, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.customer.c_acctbal, 5000.602894)	N/A	N/A
21:02:35 [2021-05-30T21:02:35.223Z]               └─TableFullScan_44	7500000.00	7500000	cop[tikv]	table:customer	tikv_task:{proc max:997ms, min:358ms, p80:846ms, p95:997ms, iters:7404, tasks:18}	keep order:false	N/A	N/A
21:02:35 [2021-05-30T21:02:35.223Z] 
21:02:35 [2021-05-30T21:02:35.223Z] queries/22.sql
21:02:35 [2021-05-30T21:02:35.223Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
21:02:35 [2021-05-30T21:02:35.223Z] Sort_39	2186432.06	4	root		time:25.1s, loops:2	Column#27	9.48 KB	0 Bytes
21:02:35 [2021-05-30T21:02:35.223Z] └─Projection_41	2186432.06	4	root		time:25.1s, loops:5, Concurrency:5	Column#27, Column#28, Column#29	23.7 KB	N/A
21:02:35 [2021-05-30T21:02:35.223Z]   └─HashAgg_42	2186432.06	4	root		time:25.1s, loops:5, partial_worker:{wall_time:25.132419722s, concurrency:5, task_num:180, tot_wait:2m5.603179533s, tot_exec:57.213359ms, tot_time:2m5.660488557s, max:25.13235262s, p95:25.13235262s}, final_worker:{wall_time:25.132454985s, concurrency:5, task_num:20, tot_wait:2m5.661793129s, tot_exec:181.887µs, tot_time:2m5.661993897s, max:25.132410018s, p95:25.132410018s}	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:35 [2021-05-30T21:02:35.223Z]     └─Projection_51	2186432.06	181704	root		time:25.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	703.6 KB	N/A
21:02:35 [2021-05-30T21:02:35.223Z]       └─HashJoin_43	2186432.06	181704	root		time:25.1s, loops:181, build_hash_table:{total:23.6s, fetch:989.4ms, build:22.6s}, probe:{concurrency:5, total:2m5.6s, max:25.1s, probe:6.32s, fetch:1m59.3s}	anti semi join, equal:[eq(tpch50.customer.c_custkey, tpch50.orders.o_custkey)]	590.2 MB	0 Bytes
21:02:35 [2021-05-30T21:02:35.223Z]         ├─TableReader_49(Build)	75000000.00	75000000	root		time:1.01s, loops:73364, cop_task: {num: 153, max: 1s, min: 208.7ms, avg: 497.1ms, p95: 881.3ms, max_proc_keys: 723875, p95_proc_keys: 553332, tot_proc: 1m15.3s, tot_wait: 34ms, rpc_num: 153, rpc_time: 1m16.1s, copr_cache: disabled}	data:TableFullScan_48	57.8 MB	N/A
21:02:35 [2021-05-30T21:02:35.223Z]         │ └─TableFullScan_48	75000000.00	75000000	cop[tikv]	table:orders	tikv_task:{proc max:970ms, min:200ms, p80:493ms, p95:844ms, 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:35 [2021-05-30T21:02:35.223Z]         └─Selection_47(Probe)	2733040.07	545246	root		time:1.61s, loops:534	in(substring(tpch50.customer.c_phone, 1, 2), "20", "40", "22", "30", "39", "42", "21")	94.6 KB	N/A
21:02:35 [2021-05-30T21:02:35.223Z]           └─TableReader_46	2733040.07	3407619	root		time:643.3ms, loops:3319, cop_task: {num: 18, max: 1.15s, min: 493.6ms, avg: 846.2ms, p95: 1.15s, max_proc_keys: 582617, p95_proc_keys: 582617, tot_proc: 14.8s, rpc_num: 18, rpc_time: 15.2s, copr_cache: disabled}	data:Selection_45	192.5 MB	N/A
21:02:35 [2021-05-30T21:02:35.223Z]             └─Selection_45	2733040.07	3407619	cop[tikv]		tikv_task:{proc max:1.08s, min:468ms, p80:924ms, p95:1.08s, 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:35 [2021-05-30T21:02:35.223Z]               └─TableFullScan_44	7500000.00	7500000	cop[tikv]	table:customer	tikv_task:{proc max:985ms, min:427ms, p80:850ms, p95:985ms, iters:7404, tasks:18}	keep order:false	N/A	N/A
21:02:35 [2021-05-30T21:02:35.223Z] 
21:02:35 [2021-05-30T21:02:35.223Z] queries/22.sql
21:02:35 [2021-05-30T21:02:35.223Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
21:02:35 [2021-05-30T21:02:35.223Z] Sort_39	2186432.06	4	root		time:25.1s, loops:2	Column#27	9.48 KB	0 Bytes
21:02:35 [2021-05-30T21:02:35.223Z] └─Projection_41	2186432.06	4	root		time:25.1s, loops:5, Concurrency:5	Column#27, Column#28, Column#29	23.7 KB	N/A
21:02:35 [2021-05-30T21:02:35.223Z]   └─HashAgg_42	2186432.06	4	root		time:25.1s, loops:5, partial_worker:{wall_time:25.122806972s, concurrency:5, task_num:180, tot_wait:2m5.561087028s, tot_exec:51.745033ms, tot_time:2m5.613020903s, max:25.1227238s, p95:25.1227238s}, final_worker:{wall_time:25.122831541s, concurrency:5, task_num:20, tot_wait:2m5.613618785s, tot_exec:270.818µs, tot_time:2m5.613897364s, max:25.122783175s, p95:25.122783175s}	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:35 [2021-05-30T21:02:35.223Z]     └─Projection_51	2186432.06	181704	root		time:25.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	703.6 KB	N/A
21:02:35 [2021-05-30T21:02:35.223Z]       └─HashJoin_43	2186432.06	181704	root		time:25.1s, loops:181, build_hash_table:{total:23.6s, fetch:771.7ms, build:22.9s}, probe:{concurrency:5, total:2m5.6s, max:25.1s, probe:6.04s, fetch:1m59.6s}	anti semi join, equal:[eq(tpch50.customer.c_custkey, tpch50.orders.o_custkey)]	590.2 MB	0 Bytes
21:02:35 [2021-05-30T21:02:35.223Z]         ├─TableReader_49(Build)	75000000.00	75000000	root		time:778.6ms, loops:73364, cop_task: {num: 153, max: 1.02s, min: 276.3ms, avg: 496.3ms, p95: 799.2ms, max_proc_keys: 723875, p95_proc_keys: 553332, tot_proc: 1m15.1s, tot_wait: 35ms, rpc_num: 153, rpc_time: 1m15.9s, copr_cache: disabled}	data:TableFullScan_48	57.8 MB	N/A
21:02:35 [2021-05-30T21:02:35.223Z]         │ └─TableFullScan_48	75000000.00	75000000	cop[tikv]	table:orders	tikv_task:{proc max:970ms, min:263ms, p80:486ms, p95:769ms, 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:35 [2021-05-30T21:02:35.224Z]         └─Selection_47(Probe)	2733040.07	545246	root		time:1.55s, loops:534	in(substring(tpch50.customer.c_phone, 1, 2), "20", "40", "22", "30", "39", "42", "21")	94.6 KB	N/A
21:02:35 [2021-05-30T21:02:35.224Z]           └─TableReader_46	2733040.07	3407619	root		time:673.5ms, loops:3319, cop_task: {num: 18, max: 1.15s, min: 488.8ms, avg: 868.5ms, p95: 1.15s, max_proc_keys: 582617, p95_proc_keys: 582617, tot_proc: 15.1s, tot_wait: 5ms, rpc_num: 18, rpc_time: 15.6s, copr_cache: disabled}	data:Selection_45	192.5 MB	N/A
21:02:35 [2021-05-30T21:02:35.224Z]             └─Selection_45	2733040.07	3407619	cop[tikv]		tikv_task:{proc max:1.09s, min:449ms, p80:976ms, p95:1.09s, iters:7404, tasks:18}, scan_detail: {total_process_keys: 7500000, total_keys: 7500018, rocksdb: {delete_skipped_count: 0, key_skipped_count: 14999982, block: {cache_hit_count: 28451, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.customer.c_acctbal, 5000.602894)	N/A	N/A
21:02:35 [2021-05-30T21:02:35.224Z]               └─TableFullScan_44	7500000.00	7500000	cop[tikv]	table:customer	tikv_task:{proc max:988ms, min:405ms, p80:913ms, p95:988ms, iters:7404, tasks:18}	keep order:false	N/A	N/A
21:02:35 [2021-05-30T21:02:35.224Z] + sync
21:02:35 [2021-05-30T21:02:35.224Z] + /usr/bin/echo 3
21:03:11 [2021-05-30T21:03:11.020Z] 
21:03:11 [2021-05-30T21:03:11.020Z] queries/22.sql
21:03:11 [2021-05-30T21:03:11.020Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
21:03:11 [2021-05-30T21:03:11.020Z] Sort_39	2186432.06	4	root		time:25.7s, loops:2	Column#27	9.48 KB	0 Bytes
21:03:11 [2021-05-30T21:03:11.020Z] └─Projection_41	2186432.06	4	root		time:25.7s, loops:5, Concurrency:5	Column#27, Column#28, Column#29	23.7 KB	N/A
21:03:11 [2021-05-30T21:03:11.020Z]   └─HashAgg_42	2186432.06	4	root		time:25.7s, loops:5, partial_worker:{wall_time:25.695877771s, concurrency:5, task_num:179, tot_wait:2m8.424273556s, tot_exec:54.153034ms, tot_time:2m8.478544706s, max:25.69583661s, p95:25.69583661s}, final_worker:{wall_time:25.69595343s, concurrency:5, task_num:20, tot_wait:2m8.479216351s, tot_exec:275.513µs, tot_time:2m8.479500021s, max:25.695927327s, p95:25.695927327s}	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:03:11 [2021-05-30T21:03:11.020Z]     └─Projection_51	2186432.06	181704	root		time:25.7s, 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	703.6 KB	N/A
21:03:11 [2021-05-30T21:03:11.020Z]       └─HashJoin_43	2186432.06	181704	root		time:25.7s, loops:180, build_hash_table:{total:24.2s, fetch:917.3ms, build:23.3s}, probe:{concurrency:5, total:2m8.5s, max:25.7s, probe:5.89s, fetch:2m2.6s}	anti semi join, equal:[eq(tpch50.customer.c_custkey, tpch50.orders.o_custkey)]	590.2 MB	0 Bytes
21:03:11 [2021-05-30T21:03:11.020Z]         ├─TableReader_49(Build)	75000000.00	75000000	root		time:922.6ms, loops:73364, cop_task: {num: 153, max: 953ms, min: 239.6ms, avg: 484.4ms, p95: 806.3ms, max_proc_keys: 723875, p95_proc_keys: 553332, tot_proc: 1m13.3s, tot_wait: 36ms, rpc_num: 153, rpc_time: 1m14.1s, copr_cache: disabled}	data:TableFullScan_48	57.8 MB	N/A
21:03:11 [2021-05-30T21:03:11.020Z]         │ └─TableFullScan_48	75000000.00	75000000	cop[tikv]	table:orders	tikv_task:{proc max:928ms, min:234ms, p80:465ms, p95:775ms, 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:03:11 [2021-05-30T21:03:11.020Z]         └─Selection_47(Probe)	2733040.07	545246	root		time:1.44s, loops:534	in(substring(tpch50.customer.c_phone, 1, 2), "20", "40", "22", "30", "39", "42", "21")	94.6 KB	N/A
21:03:11 [2021-05-30T21:03:11.020Z]           └─TableReader_46	2733040.07	3407619	root		time:507.6ms, loops:3319, cop_task: {num: 18, max: 1.15s, min: 387.3ms, avg: 836.1ms, p95: 1.15s, max_proc_keys: 582617, p95_proc_keys: 582617, tot_proc: 14.6s, tot_wait: 3ms, rpc_num: 18, rpc_time: 15s, copr_cache: disabled}	data:Selection_45	192.5 MB	N/A
21:03:11 [2021-05-30T21:03:11.020Z]             └─Selection_45	2733040.07	3407619	cop[tikv]		tikv_task:{proc max:1.08s, min:362ms, p80:902ms, p95:1.08s, 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:03:11 [2021-05-30T21:03:11.020Z]               └─TableFullScan_44	7500000.00	7500000	cop[tikv]	table:customer	tikv_task:{proc max:980ms, min:329ms, p80:847ms, p95:980ms, iters:7404, tasks:18}	keep order:false	N/A	N/A
21:03:11 [2021-05-30T21:03:11.020Z] 
21:03:11 [2021-05-30T21:03:11.021Z] + tiup cluster stop benchbot
21:03:11 [2021-05-30T21:03:11.021Z] Starting component `cluster`: /home/tidb/.tiup/components/cluster/v1.4.4/tiup-cluster stop benchbot
21:03:11 [2021-05-30T21:03:11.021Z] + [ 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:03:11 [2021-05-30T21:03:11.021Z] + [Parallel] - UserSSH: user=tidb, host=172.16.5.86
21:03:11 [2021-05-30T21:03:11.021Z] + [Parallel] - UserSSH: user=tidb, host=172.16.5.86
21:03:11 [2021-05-30T21:03:11.021Z] + [Parallel] - UserSSH: user=tidb, host=172.16.5.86
21:03:11 [2021-05-30T21:03:11.021Z] + [Parallel] - UserSSH: user=tidb, host=172.16.5.86
21:03:11 [2021-05-30T21:03:11.021Z] + [Parallel] - UserSSH: user=tidb, host=172.16.5.86
21:03:11 [2021-05-30T21:03:11.021Z] + [ Serial ] - StopCluster
21:03:11 [2021-05-30T21:03:11.021Z] Stopping component grafana
21:03:11 [2021-05-30T21:03:11.021Z] 	Stopping instance 172.16.5.86
21:03:11 [2021-05-30T21:03:11.021Z] 	Stop grafana 172.16.5.86:3000 success
21:03:11 [2021-05-30T21:03:11.021Z] Stopping component prometheus
21:03:11 [2021-05-30T21:03:11.021Z] 	Stopping instance 172.16.5.86
21:03:11 [2021-05-30T21:03:11.021Z] 	Stop prometheus 172.16.5.86:9090 success
21:03:11 [2021-05-30T21:03:11.021Z] Stopping component tidb
21:03:11 [2021-05-30T21:03:11.021Z] 	Stopping instance 172.16.5.86
21:03:11 [2021-05-30T21:03:11.021Z] 	Stop tidb 172.16.5.86:4000 success
21:03:11 [2021-05-30T21:03:11.021Z] Stopping component tikv
21:03:11 [2021-05-30T21:03:11.021Z] 	Stopping instance 172.16.5.86
21:03:14 [2021-05-30T21:03:14.280Z] 	Stop tikv 172.16.5.86:20160 success
21:03:14 [2021-05-30T21:03:14.280Z] Stopping component pd
21:03:14 [2021-05-30T21:03:14.280Z] 	Stopping instance 172.16.5.86
21:03:14 [2021-05-30T21:03:14.280Z] 	Stop pd 172.16.5.86:2379 success
21:03:14 [2021-05-30T21:03:14.280Z] Stopping component node_exporter
21:03:14 [2021-05-30T21:03:14.534Z] Stopping component blackbox_exporter
21:03:14 [2021-05-30T21:03:14.788Z] Stopped cluster `benchbot` successfully
21:03:15 [2021-05-30T21:03:15.049Z] [Pipeline] sh
21:03:15 [2021-05-30T21:03:15.329Z] + cat bench_result
21:03:15 [2021-05-30T21:03:15.334Z] [Pipeline] }
21:03:15 [2021-05-30T21:03:15.336Z] [Pipeline] // dir
21:03:15 [2021-05-30T21:03:15.338Z] [Pipeline] }
21:03:15 [2021-05-30T21:03:15.339Z] [Pipeline] // stage
21:03:15 [2021-05-30T21:03:15.341Z] [Pipeline] }
21:03:15 [2021-05-30T21:03:15.343Z] [Pipeline] // node
21:03:15 [2021-05-30T21:03:15.345Z] [Pipeline] }
21:03:15 [2021-05-30T21:03:15.347Z] [Pipeline] // catchError
21:03:15 [2021-05-30T21:03:15.350Z] [Pipeline] stage
21:03:15 [2021-05-30T21:03:15.352Z] [Pipeline] { (Summary)
21:03:15 [2021-05-30T21:03:15.363Z] [Pipeline] slackSend
21:03:15 [2021-05-30T21:03:15.363Z] 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:03:15 [2021-05-30T21:03:15.389Z] sh: line 1: 157794 Terminated              sleep 3
21:03:15 [2021-05-30T21:03:15.998Z] [Pipeline] }
21:03:16 [2021-05-30T21:03:16.000Z] [Pipeline] // stage
21:03:16 [2021-05-30T21:03:16.002Z] [Pipeline] End of Pipeline
21:03:16 [2021-05-30T21:03:16.014Z] Finished: SUCCESS