SuccessConsole Output

Skipping 1,194 KB.. Full Log
ineitem.l_quantity)->Column#44	194.5 MB	N/A
20:41:15 [2021-05-27T20:41:15.288Z]         └─HashJoin_59	9711455.06	634004	root		time:44.9s, loops:625, build_hash_table:{total:3.41s, fetch:3.09s, build:323.5ms}, probe:{concurrency:5, total:3m44.4s, max:44.9s, probe:15.2s, fetch:3m29.2s}	left outer join, equal:[eq(tpch50.partsupp.ps_partkey, tpch50.lineitem.l_partkey) eq(tpch50.partsupp.ps_suppkey, tpch50.lineitem.l_suppkey)]	10.4 MB	0 Bytes
20:41:15 [2021-05-27T20:41:15.288Z]           ├─IndexHashJoin_67(Build)	321865.05	435528	root		time:3.26s, loops:430, inner:{total:3.85s, concurrency:5, task:12, construct:104.9ms, fetch:3.31s, build:29ms, join:441.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.5 MB	N/A
20:41:15 [2021-05-27T20:41:15.288Z]           │ ├─TableReader_96(Build)	80007.93	108882	root		time:2.9s, loops:112, cop_task: {num: 20, max: 1.9s, min: 695.3ms, avg: 1.45s, p95: 1.9s, max_proc_keys: 686055, p95_proc_keys: 686055, tot_proc: 28.9s, tot_wait: 2ms, rpc_num: 20, rpc_time: 28.9s, copr_cache: disabled}	data:Selection_95	725.8 KB	N/A
20:41:15 [2021-05-27T20:41:15.288Z]           │ │ └─Selection_95	80007.93	108882	cop[tikv]		tikv_task:{proc max:1.85s, min:693ms, p80:1.71s, p95:1.85s, 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:15 [2021-05-27T20:41:15.288Z]           │ │   └─TableFullScan_94	10000000.00	10000000	cop[tikv]	table:part	tikv_task:{proc max:1.74s, min:646ms, p80:1.58s, p95:1.74s, iters:9859, tasks:20}	keep order:false	N/A	N/A
20:41:15 [2021-05-27T20:41:15.288Z]           │ └─IndexLookUp_64(Probe)	4.02	435528	root		time:3.21s, loops:447, index_task: {total_time: 2.04s, fetch_handle: 2.04s, build: 111µs, wait: 276.5µs}, table_task: {total_time: 12.3s, num: 55, concurrency: 60}		19.6 KB	N/A
20:41:15 [2021-05-27T20:41:15.288Z]           │   ├─IndexRangeScan_62(Build)	4.02	435528	cop[tikv]	table:partsupp, index:PRIMARY(PS_PARTKEY, PS_SUPPKEY)	time:1.99s, loops:477, cop_task: {num: 58, max: 383ms, min: 6.04ms, avg: 141.8ms, p95: 336.4ms, max_proc_keys: 15288, p95_proc_keys: 15008, tot_proc: 7.65s, tot_wait: 75ms, rpc_num: 58, rpc_time: 8.22s, copr_cache: disabled}, tikv_task:{proc max:348ms, min:5ms, p80:226ms, p95:327ms, iters:687, tasks:58}, scan_detail: {total_process_keys: 435528, total_keys: 544410, rocksdb: {delete_skipped_count: 0, key_skipped_count: 435528, block: {cache_hit_count: 980292, read_count: 0, read_byte: 0 Bytes}}}	range: decided by [eq(tpch50.partsupp.ps_partkey, tpch50.part.p_partkey)], keep order:false	N/A	N/A
20:41:15 [2021-05-27T20:41:15.288Z]           │   └─TableRowIDScan_63(Probe)	4.02	435528	cop[tikv]	table:partsupp	time:3.55s, loops:505, cop_task: {num: 1397, max: 104ms, min: 1.74ms, avg: 24.2ms, p95: 58.2ms, max_proc_keys: 976, p95_proc_keys: 644, tot_proc: 25.9s, tot_wait: 4.38s, rpc_num: 1397, rpc_time: 33.8s, copr_cache: disabled}, tikv_task:{proc max:72ms, min:0s, p80:24ms, p95:37ms, iters:5203, tasks:1397}, scan_detail: {total_process_keys: 435528, total_keys: 473507, rocksdb: {delete_skipped_count: 0, key_skipped_count: 194081, block: {cache_hit_count: 3643939, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:41:15 [2021-05-27T20:41:15.288Z]           └─TableReader_101(Probe)	46310896.67	45504356	root		time:39.6s, loops:44289, cop_task: {num: 761, max: 1.74s, min: 513.6ms, avg: 830.8ms, p95: 1.11s, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 10m28.6s, tot_wait: 157ms, rpc_num: 761, rpc_time: 10m32.2s, copr_cache: disabled}	data:Selection_100	52.6 MB	N/A
20:41:15 [2021-05-27T20:41:15.288Z]             └─Selection_100	46310896.67	45504356	cop[tikv]		tikv_task:{proc max:1.64s, min:498ms, p80:915ms, p95:1.09s, 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:15 [2021-05-27T20:41:15.288Z]               └─TableFullScan_99	300005811.00	300005811	cop[tikv]	table:lineitem	tikv_task:{proc max:1.59s, min:476ms, p80:882ms, p95:1.05s, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:41:15 [2021-05-27T20:41:15.288Z] + sync
20:41:15 [2021-05-27T20:41:15.288Z] + /usr/bin/echo 3
20:42:01 [2021-05-27T20:42:01.907Z] + sync
20:42:01 [2021-05-27T20:42:01.907Z] + /usr/bin/echo 3
20:42:40 [2021-05-27T20:42:40.562Z] 
20:42:40 [2021-05-27T20:42:40.562Z] queries/20.sql
20:42:40 [2021-05-27T20:42:40.562Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:42:40 [2021-05-27T20:42:40.562Z] Sort_30	20000.00	8982	root		time:40s, loops:10	tpch50.supplier.s_name	635.0 KB	0 Bytes
20:42:40 [2021-05-27T20:42:40.562Z] └─HashJoin_35	20000.00	8982	root		time:40s, loops:11, build_hash_table:{total:1.52s, fetch:1.51s, build:9.58ms}, probe:{concurrency:5, total:3m20s, max:40s, probe:47.8ms, fetch:3m19.9s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.partsupp.ps_suppkey)]	1.49 MB	0 Bytes
20:42:40 [2021-05-27T20:42:40.562Z]   ├─HashJoin_48(Build)	20000.00	19972	root		time:1.51s, loops:22, build_hash_table:{total:196.3µs, fetch:188.9µs, build:7.42µs}, probe:{concurrency:5, total:7.57s, max:1.51s, probe:93.4ms, fetch:7.48s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:42:40 [2021-05-27T20:42:40.562Z]   │ ├─TableReader_53(Build)	1.00	1	root		time:57.8µs, loops:2, cop_task: {num: 1, max: 1.06ms, proc_keys: 25, tot_proc: 1ms, rpc_num: 1, rpc_time: 1.03ms, copr_cache: disabled}	data:Selection_52	244 Bytes	N/A
20:42:40 [2021-05-27T20:42:40.562Z]   │ │ └─Selection_52	1.00	1	cop[tikv]		tikv_task:{time:1ms, loops:1}, scan_detail: {total_process_keys: 25, total_keys: 26, rocksdb: {delete_skipped_count: 0, key_skipped_count: 46, block: {cache_hit_count: 18, read_count: 0, read_byte: 0 Bytes}}}	eq(tpch50.nation.n_name, "ALGERIA")	N/A	N/A
20:42:40 [2021-05-27T20:42:40.562Z]   │ │   └─TableFullScan_51	25.00	25	cop[tikv]	table:nation	tikv_task:{time:1ms, loops:1}	keep order:false	N/A	N/A
20:42:40 [2021-05-27T20:42:40.562Z]   │ └─TableReader_50(Probe)	500000.00	500000	root		time:1.5s, loops:490, cop_task: {num: 1, max: 1.5s, proc_keys: 500000, tot_proc: 1.44s, rpc_num: 1, rpc_time: 1.5s, copr_cache: disabled}	data:TableFullScan_49	35.8 MB	N/A
20:42:40 [2021-05-27T20:42:40.562Z]   │   └─TableFullScan_49	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:1.21s, 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:40 [2021-05-27T20:42:40.562Z]   └─HashAgg_54(Probe)	257492.04	223999	root		time:40s, loops:222, partial_worker:{wall_time:39.928008401s, concurrency:5, task_num:289, tot_wait:3m19.384412667s, tot_exec:206.063419ms, tot_time:3m19.629828581s, max:39.927648031s, p95:39.927648031s}, final_worker:{wall_time:39.995026917s, concurrency:5, task_num:25, tot_wait:3m19.613545141s, tot_exec:338.031995ms, tot_time:3m19.951590544s, max:39.994677543s, p95:39.994677543s}	group by:tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_suppkey)->tpch50.partsupp.ps_suppkey	61.4 MB	N/A
20:42:40 [2021-05-27T20:42:40.562Z]     └─Selection_55	257492.04	295898	root		time:39.9s, loops:290	gt(cast(tpch50.partsupp.ps_availqty, decimal(20,0) BINARY), mul(0.5, Column#44))	59.2 KB	N/A
20:42:40 [2021-05-27T20:42:40.562Z]       └─HashAgg_56	321865.05	435528	root		time:39.8s, loops:430, partial_worker:{wall_time:39.556044994s, concurrency:5, task_num:625, tot_wait:3m16.397253434s, tot_exec:1.237949476s, tot_time:3m17.75715182s, max:39.555913663s, p95:39.555913663s}, final_worker:{wall_time:39.916146842s, concurrency:5, task_num:25, tot_wait:3m17.741312508s, tot_exec:1.798720741s, tot_time:3m19.54005066s, max:39.916035366s, p95:39.916035366s}	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:40 [2021-05-27T20:42:40.562Z]         └─HashJoin_59	9711455.06	634004	root		time:39.4s, loops:626, build_hash_table:{total:2.75s, fetch:2.53s, build:217.3ms}, probe:{concurrency:5, total:3m17.2s, max:39.4s, probe:15s, fetch:3m2.2s}	left outer join, equal:[eq(tpch50.partsupp.ps_partkey, tpch50.lineitem.l_partkey) eq(tpch50.partsupp.ps_suppkey, tpch50.lineitem.l_suppkey)]	10.4 MB	0 Bytes
20:42:40 [2021-05-27T20:42:40.562Z]           ├─IndexHashJoin_67(Build)	321865.05	435528	root		time:2.7s, loops:430, inner:{total:3.14s, concurrency:5, task:12, construct:124.1ms, fetch:2.68s, build:28.2ms, join:336.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:42:40 [2021-05-27T20:42:40.562Z]           │ ├─TableReader_96(Build)	80007.93	108882	root		time:2.24s, loops:112, cop_task: {num: 20, max: 1.72s, min: 770.5ms, avg: 1.27s, p95: 1.72s, max_proc_keys: 686055, p95_proc_keys: 686055, tot_proc: 25.4s, tot_wait: 10ms, rpc_num: 20, rpc_time: 25.4s, copr_cache: disabled}	data:Selection_95	725.8 KB	N/A
20:42:40 [2021-05-27T20:42:40.562Z]           │ │ └─Selection_95	80007.93	108882	cop[tikv]		tikv_task:{proc max:1.67s, min:766ms, p80:1.46s, p95:1.67s, 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:40 [2021-05-27T20:42:40.562Z]           │ │   └─TableFullScan_94	10000000.00	10000000	cop[tikv]	table:part	tikv_task:{proc max:1.55s, min:723ms, p80:1.37s, p95:1.55s, iters:9859, tasks:20}	keep order:false	N/A	N/A
20:42:40 [2021-05-27T20:42:40.562Z]           │ └─IndexLookUp_64(Probe)	4.02	435528	root		time:2.57s, loops:447, index_task: {total_time: 1.5s, fetch_handle: 1.5s, build: 94.6µs, wait: 258.8µs}, table_task: {total_time: 10.2s, num: 55, concurrency: 60}		19.6 KB	N/A
20:42:40 [2021-05-27T20:42:40.562Z]           │   ├─IndexRangeScan_62(Build)	4.02	435528	cop[tikv]	table:partsupp, index:PRIMARY(PS_PARTKEY, PS_SUPPKEY)	time:1.46s, loops:481, cop_task: {num: 59, max: 251.6ms, min: 5.63ms, avg: 116.8ms, p95: 247ms, max_proc_keys: 15288, p95_proc_keys: 15008, tot_proc: 6.14s, tot_wait: 259ms, rpc_num: 59, rpc_time: 6.89s, copr_cache: disabled}, tikv_task:{proc max:235ms, min:4ms, p80:171ms, p95:230ms, iters:692, tasks:59}, scan_detail: {total_process_keys: 435528, total_keys: 544410, rocksdb: {delete_skipped_count: 0, key_skipped_count: 435528, block: {cache_hit_count: 980292, read_count: 0, read_byte: 0 Bytes}}}	range: decided by [eq(tpch50.partsupp.ps_partkey, tpch50.part.p_partkey)], keep order:false	N/A	N/A
20:42:40 [2021-05-27T20:42:40.562Z]           │   └─TableRowIDScan_63(Probe)	4.02	435528	cop[tikv]	table:partsupp	time:3.6s, loops:505, cop_task: {num: 1461, max: 94.2ms, min: 545.4µs, avg: 24.7ms, p95: 53ms, max_proc_keys: 904, p95_proc_keys: 540, tot_proc: 26.3s, tot_wait: 7.63s, rpc_num: 1461, rpc_time: 36s, copr_cache: disabled}, tikv_task:{proc max:72ms, min:0s, p80:22ms, p95:32ms, iters:5393, tasks:1461}, scan_detail: {total_process_keys: 435528, total_keys: 473497, rocksdb: {delete_skipped_count: 0, key_skipped_count: 194025, block: {cache_hit_count: 3644434, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:42:40 [2021-05-27T20:42:40.562Z]           └─TableReader_101(Probe)	46310896.67	45504356	root		time:34.5s, loops:44288, cop_task: {num: 761, max: 1.38s, min: 254.1ms, avg: 733.2ms, p95: 893.9ms, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 9m14.8s, tot_wait: 125ms, rpc_num: 761, rpc_time: 9m18s, copr_cache: disabled}	data:Selection_100	52.6 MB	N/A
20:42:40 [2021-05-27T20:42:40.562Z]             └─Selection_100	46310896.67	45504356	cop[tikv]		tikv_task:{proc max:1.3s, min:245ms, p80:780ms, p95:876ms, 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:40 [2021-05-27T20:42:40.562Z]               └─TableFullScan_99	300005811.00	300005811	cop[tikv]	table:lineitem	tikv_task:{proc max:1.25s, min:235ms, p80:748ms, p95:854ms, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:42:40 [2021-05-27T20:42:40.562Z] 
20:42:40 [2021-05-27T20:42:40.562Z] queries/20.sql
20:42:40 [2021-05-27T20:42:40.562Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:42:40 [2021-05-27T20:42:40.562Z] Sort_30	20000.00	8982	root		time:38.5s, loops:10	tpch50.supplier.s_name	616.9 KB	0 Bytes
20:42:40 [2021-05-27T20:42:40.562Z] └─HashJoin_35	20000.00	8982	root		time:38.5s, loops:11, build_hash_table:{total:1.29s, fetch:1.28s, build:15ms}, probe:{concurrency:5, total:3m12.3s, max:38.5s, probe:53.4ms, fetch:3m12.3s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.partsupp.ps_suppkey)]	1.56 MB	0 Bytes
20:42:40 [2021-05-27T20:42:40.562Z]   ├─HashJoin_48(Build)	20000.00	19972	root		time:1.28s, loops:24, build_hash_table:{total:231.1µs, fetch:223.5µs, build:7.52µs}, probe:{concurrency:5, total:6.44s, max:1.29s, probe:128.9ms, fetch:6.32s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:42:40 [2021-05-27T20:42:40.562Z]   │ ├─TableReader_53(Build)	1.00	1	root		time:57.9µs, loops:2, cop_task: {num: 1, max: 885.5µs, proc_keys: 25, tot_proc: 1ms, rpc_num: 1, rpc_time: 857.3µs, copr_cache: disabled}	data:Selection_52	244 Bytes	N/A
20:42:40 [2021-05-27T20:42:40.562Z]   │ │ └─Selection_52	1.00	1	cop[tikv]		tikv_task:{time:1ms, loops:1}, scan_detail: {total_process_keys: 25, total_keys: 26, rocksdb: {delete_skipped_count: 0, key_skipped_count: 46, block: {cache_hit_count: 18, read_count: 0, read_byte: 0 Bytes}}}	eq(tpch50.nation.n_name, "ALGERIA")	N/A	N/A
20:42:40 [2021-05-27T20:42:40.562Z]   │ │   └─TableFullScan_51	25.00	25	cop[tikv]	table:nation	tikv_task:{time:1ms, loops:1}	keep order:false	N/A	N/A
20:42:40 [2021-05-27T20:42:40.562Z]   │ └─TableReader_50(Probe)	500000.00	500000	root		time:1.26s, loops:490, cop_task: {num: 1, max: 1.26s, proc_keys: 500000, tot_proc: 1.17s, rpc_num: 1, rpc_time: 1.26s, copr_cache: disabled}	data:TableFullScan_49	35.8 MB	N/A
20:42:40 [2021-05-27T20:42:40.562Z]   │   └─TableFullScan_49	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:1.02s, loops:493}, scan_detail: {total_process_keys: 500000, total_keys: 500001, rocksdb: {delete_skipped_count: 0, key_skipped_count: 999999, block: {cache_hit_count: 1692, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:42:40 [2021-05-27T20:42:40.562Z]   └─HashAgg_54(Probe)	257492.04	223999	root		time:38.5s, loops:222, partial_worker:{wall_time:38.396954004s, concurrency:5, task_num:289, tot_wait:3m11.740059502s, tot_exec:195.538777ms, tot_time:3m11.973460546s, max:38.396873434s, p95:38.396873434s}, final_worker:{wall_time:38.468129135s, concurrency:5, task_num:25, tot_wait:3m11.967602402s, tot_exec:362.582882ms, tot_time:3m12.330197507s, max:38.468057412s, p95:38.468057412s}	group by:tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_suppkey)->tpch50.partsupp.ps_suppkey	61.4 MB	N/A
20:42:40 [2021-05-27T20:42:40.562Z]     └─Selection_55	257492.04	295898	root		time:38.4s, loops:290	gt(cast(tpch50.partsupp.ps_availqty, decimal(20,0) BINARY), mul(0.5, Column#44))	59.2 KB	N/A
20:42:40 [2021-05-27T20:42:40.562Z]       └─HashAgg_56	321865.05	435528	root		time:38.3s, loops:430, partial_worker:{wall_time:38.010723754s, concurrency:5, task_num:623, tot_wait:3m8.590516831s, tot_exec:1.288828284s, tot_time:3m10.027059943s, max:38.010563435s, p95:38.010563435s}, final_worker:{wall_time:38.386056017s, concurrency:5, task_num:25, tot_wait:3m9.988267097s, tot_exec:1.910198799s, tot_time:3m11.898481063s, max:38.385887046s, p95:38.385887046s}	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:40 [2021-05-27T20:42:40.562Z]         └─HashJoin_59	9711455.06	634004	root		time:37.9s, loops:624, build_hash_table:{total:2.46s, fetch:2.25s, build:215.7ms}, probe:{concurrency:5, total:3m9.5s, max:37.9s, probe:15.2s, fetch:2m54.3s}	left outer join, equal:[eq(tpch50.partsupp.ps_partkey, tpch50.lineitem.l_partkey) eq(tpch50.partsupp.ps_suppkey, tpch50.lineitem.l_suppkey)]	10.4 MB	0 Bytes
20:42:40 [2021-05-27T20:42:40.562Z]           ├─IndexHashJoin_67(Build)	321865.05	435528	root		time:2.42s, loops:430, inner:{total:2.67s, concurrency:5, task:12, construct:138.1ms, fetch:2.2s, build:32.2ms, join:326.1ms}	inner join, inner:IndexLookUp_64, outer key:tpch50.part.p_partkey, inner key:tpch50.partsupp.ps_partkey, equal cond:eq(tpch50.part.p_partkey, tpch50.partsupp.ps_partkey)	20.4 MB	N/A
20:42:40 [2021-05-27T20:42:40.562Z]           │ ├─TableReader_96(Build)	80007.93	108882	root		time:2.04s, loops:112, cop_task: {num: 20, max: 1.42s, min: 525.5ms, avg: 1.07s, p95: 1.42s, max_proc_keys: 686055, p95_proc_keys: 686055, tot_proc: 21.4s, tot_wait: 1ms, rpc_num: 20, rpc_time: 21.5s, copr_cache: disabled}	data:Selection_95	657.9 KB	N/A
20:42:40 [2021-05-27T20:42:40.562Z]           │ │ └─Selection_95	80007.93	108882	cop[tikv]		tikv_task:{proc max:1.4s, min:519ms, p80:1.27s, p95:1.4s, iters:9859, tasks:20}, scan_detail: {total_process_keys: 10000000, total_keys: 10000020, rocksdb: {delete_skipped_count: 0, key_skipped_count: 19999980, block: {cache_hit_count: 31499, read_count: 0, read_byte: 0 Bytes}}}	like(tpch50.part.p_name, "green%", 92)	N/A	N/A
20:42:40 [2021-05-27T20:42:40.562Z]           │ │   └─TableFullScan_94	10000000.00	10000000	cop[tikv]	table:part	tikv_task:{proc max:1.3s, min:480ms, p80:1.19s, p95:1.3s, iters:9859, tasks:20}	keep order:false	N/A	N/A
20:42:40 [2021-05-27T20:42:40.563Z]           │ └─IndexLookUp_64(Probe)	4.02	435528	root		time:2.08s, loops:447, index_task: {total_time: 1.24s, fetch_handle: 1.23s, build: 99.9µs, wait: 481.1µs}, table_task: {total_time: 8.11s, num: 56, concurrency: 60}		20.7 KB	N/A
20:42:40 [2021-05-27T20:42:40.563Z]           │   ├─IndexRangeScan_62(Build)	4.02	435528	cop[tikv]	table:partsupp, index:PRIMARY(PS_PARTKEY, PS_SUPPKEY)	time:1.19s, loops:477, cop_task: {num: 59, max: 195.9ms, min: 4.7ms, avg: 88.2ms, p95: 189.1ms, max_proc_keys: 15288, p95_proc_keys: 14948, tot_proc: 4.8s, tot_wait: 40ms, rpc_num: 59, rpc_time: 5.2s, copr_cache: disabled}, tikv_task:{proc max:185ms, min:4ms, p80:140ms, p95:181ms, iters:693, tasks:59}, scan_detail: {total_process_keys: 435528, total_keys: 544410, rocksdb: {delete_skipped_count: 0, key_skipped_count: 435528, block: {cache_hit_count: 980292, read_count: 0, read_byte: 0 Bytes}}}	range: decided by [eq(tpch50.partsupp.ps_partkey, tpch50.part.p_partkey)], keep order:false	N/A	N/A
20:42:40 [2021-05-27T20:42:40.563Z]           │   └─TableRowIDScan_63(Probe)	4.02	435528	cop[tikv]	table:partsupp	time:2.77s, loops:506, cop_task: {num: 1384, max: 106.9ms, min: 495µs, avg: 18.8ms, p95: 38.1ms, max_proc_keys: 1104, p95_proc_keys: 628, tot_proc: 18.6s, tot_wait: 4.11s, rpc_num: 1384, rpc_time: 26.1s, copr_cache: disabled}, tikv_task:{proc max:49ms, min:0s, p80:17ms, p95:26ms, iters:5158, tasks:1384}, scan_detail: {total_process_keys: 435528, total_keys: 473525, rocksdb: {delete_skipped_count: 0, key_skipped_count: 194155, block: {cache_hit_count: 3643599, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:42:40 [2021-05-27T20:42:40.563Z]           └─TableReader_101(Probe)	46310896.67	45504356	root		time:33.3s, loops:44289, cop_task: {num: 761, max: 1.11s, min: 340.1ms, avg: 705ms, p95: 835.9ms, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 8m53.3s, tot_wait: 106ms, rpc_num: 761, rpc_time: 8m56.5s, copr_cache: disabled}	data:Selection_100	52.6 MB	N/A
20:42:40 [2021-05-27T20:42:40.563Z]             └─Selection_100	46310896.67	45504356	cop[tikv]		tikv_task:{proc max:1.09s, min:330ms, p80:750ms, p95:816ms, iters:296606, tasks:761}, scan_detail: {total_process_keys: 300005811, total_keys: 300006572, rocksdb: {delete_skipped_count: 0, key_skipped_count: 600010861, block: {cache_hit_count: 1124648, read_count: 0, read_byte: 0 Bytes}}}	ge(tpch50.lineitem.l_shipdate, 1993-01-01 00:00:00.000000), lt(tpch50.lineitem.l_shipdate, 1994-01-01)	N/A	N/A
20:42:40 [2021-05-27T20:42:40.563Z]               └─TableFullScan_99	300005811.00	300005811	cop[tikv]	table:lineitem	tikv_task:{proc max:1.04s, min:315ms, p80:718ms, p95:786ms, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:42:40 [2021-05-27T20:42:40.563Z] + sync
20:42:40 [2021-05-27T20:42:40.563Z] + /usr/bin/echo 3
20:43:27 [2021-05-27T20:43:27.184Z] + sync
20:43:27 [2021-05-27T20:43:27.184Z] + /usr/bin/echo 3
20:44:05 [2021-05-27T20:44:05.986Z] 
20:44:05 [2021-05-27T20:44:05.986Z] queries/20.sql
20:44:05 [2021-05-27T20:44:05.986Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:44:05 [2021-05-27T20:44:05.986Z] Sort_30	20000.00	8982	root		time:39.2s, loops:10	tpch50.supplier.s_name	643.8 KB	0 Bytes
20:44:05 [2021-05-27T20:44:05.986Z] └─HashJoin_35	20000.00	8982	root		time:39.2s, loops:11, build_hash_table:{total:1.48s, fetch:1.48s, build:8.1ms}, probe:{concurrency:5, total:3m16.1s, max:39.2s, probe:49.7ms, fetch:3m16.1s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.partsupp.ps_suppkey)]	1.56 MB	0 Bytes
20:44:05 [2021-05-27T20:44:05.986Z]   ├─HashJoin_48(Build)	20000.00	19972	root		time:1.48s, loops:24, build_hash_table:{total:202.5µs, fetch:195.6µs, build:6.81µs}, probe:{concurrency:5, total:7.41s, max:1.48s, probe:85.8ms, fetch:7.32s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:44:05 [2021-05-27T20:44:05.986Z]   │ ├─TableReader_53(Build)	1.00	1	root		time:52.7µs, loops:2, cop_task: {num: 1, max: 1ms, proc_keys: 25, tot_proc: 1ms, rpc_num: 1, rpc_time: 952.9µs, copr_cache: disabled}	data:Selection_52	244 Bytes	N/A
20:44:05 [2021-05-27T20:44:05.986Z]   │ │ └─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:05 [2021-05-27T20:44:05.986Z]   │ │   └─TableFullScan_51	25.00	25	cop[tikv]	table:nation	tikv_task:{time:1ms, loops:1}	keep order:false	N/A	N/A
20:44:05 [2021-05-27T20:44:05.986Z]   │ └─TableReader_50(Probe)	500000.00	500000	root		time:1.46s, loops:490, cop_task: {num: 1, max: 1.47s, proc_keys: 500000, tot_proc: 1.4s, rpc_num: 1, rpc_time: 1.47s, copr_cache: disabled}	data:TableFullScan_49	35.8 MB	N/A
20:44:05 [2021-05-27T20:44:05.986Z]   │   └─TableFullScan_49	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:1.26s, 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:05 [2021-05-27T20:44:05.986Z]   └─HashAgg_54(Probe)	257492.04	223999	root		time:39.2s, loops:222, partial_worker:{wall_time:39.102371416s, concurrency:5, task_num:289, tot_wait:3m15.25610637s, tot_exec:203.715508ms, tot_time:3m15.502145507s, max:39.101998679s, p95:39.101998679s}, final_worker:{wall_time:39.220649942s, concurrency:5, task_num:25, tot_wait:3m15.492874971s, tot_exec:556.688535ms, tot_time:3m16.049582502s, max:39.220266584s, p95:39.220266584s}	group by:tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_suppkey)->tpch50.partsupp.ps_suppkey	61.4 MB	N/A
20:44:05 [2021-05-27T20:44:05.986Z]     └─Selection_55	257492.04	295898	root		time:39.1s, loops:290	gt(cast(tpch50.partsupp.ps_availqty, decimal(20,0) BINARY), mul(0.5, Column#44))	59.2 KB	N/A
20:44:05 [2021-05-27T20:44:05.986Z]       └─HashAgg_56	321865.05	435528	root		time:39s, loops:430, partial_worker:{wall_time:38.727936142s, concurrency:5, task_num:623, tot_wait:3m12.364208821s, tot_exec:1.13056839s, tot_time:3m13.625031173s, max:38.727778211s, p95:38.727778211s}, final_worker:{wall_time:39.089328513s, concurrency:5, task_num:25, tot_wait:3m13.612834544s, tot_exec:1.821145262s, tot_time:3m15.433993917s, max:39.089157331s, p95:39.089157331s}	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:05 [2021-05-27T20:44:05.986Z]         └─HashJoin_59	9711455.06	634004	root		time:38.6s, loops:624, build_hash_table:{total:2.56s, fetch:2.34s, build:218.1ms}, probe:{concurrency:5, total:3m13.2s, max:38.6s, probe:14.8s, fetch:2m58.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:05 [2021-05-27T20:44:05.986Z]           ├─IndexHashJoin_67(Build)	321865.05	435528	root		time:2.5s, loops:430, inner:{total:2.56s, concurrency:5, task:12, construct:134ms, fetch:2.1s, build:29.6ms, join:327.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.4 MB	N/A
20:44:05 [2021-05-27T20:44:05.986Z]           │ ├─TableReader_96(Build)	80007.93	108882	root		time:2.16s, loops:112, cop_task: {num: 20, max: 1.54s, min: 727.9ms, avg: 1.1s, p95: 1.54s, max_proc_keys: 686055, p95_proc_keys: 686055, tot_proc: 21.9s, tot_wait: 16ms, rpc_num: 20, rpc_time: 21.9s, copr_cache: disabled}	data:Selection_95	725.8 KB	N/A
20:44:05 [2021-05-27T20:44:05.986Z]           │ │ └─Selection_95	80007.93	108882	cop[tikv]		tikv_task:{proc max:1.48s, min:723ms, p80:1.22s, p95:1.48s, iters:9859, tasks:20}, scan_detail: {total_process_keys: 10000000, total_keys: 10000020, rocksdb: {delete_skipped_count: 0, key_skipped_count: 19999980, block: {cache_hit_count: 31499, read_count: 0, read_byte: 0 Bytes}}}	like(tpch50.part.p_name, "green%", 92)	N/A	N/A
20:44:05 [2021-05-27T20:44:05.986Z]           │ │   └─TableFullScan_94	10000000.00	10000000	cop[tikv]	table:part	tikv_task:{proc max:1.38s, min:681ms, p80:1.14s, p95:1.38s, iters:9859, tasks:20}	keep order:false	N/A	N/A
20:44:05 [2021-05-27T20:44:05.986Z]           │ └─IndexLookUp_64(Probe)	4.02	435528	root		time:1.99s, loops:447, index_task: {total_time: 1.18s, fetch_handle: 1.18s, build: 111.4µs, wait: 330.2µs}, table_task: {total_time: 7.65s, num: 56, concurrency: 60}		19.4 KB	N/A
20:44:05 [2021-05-27T20:44:05.986Z]           │   ├─IndexRangeScan_62(Build)	4.02	435528	cop[tikv]	table:partsupp, index:PRIMARY(PS_PARTKEY, PS_SUPPKEY)	time:1.13s, loops:483, cop_task: {num: 58, max: 224.5ms, min: 5.11ms, avg: 92.1ms, p95: 170.4ms, max_proc_keys: 15288, p95_proc_keys: 15008, tot_proc: 4.85s, tot_wait: 19ms, rpc_num: 58, rpc_time: 5.34s, copr_cache: disabled}, tikv_task:{proc max:208ms, min:4ms, p80:136ms, p95:164ms, iters:690, tasks:58}, scan_detail: {total_process_keys: 435528, total_keys: 544410, rocksdb: {delete_skipped_count: 0, key_skipped_count: 435528, block: {cache_hit_count: 980292, read_count: 0, read_byte: 0 Bytes}}}	range: decided by [eq(tpch50.partsupp.ps_partkey, tpch50.part.p_partkey)], keep order:false	N/A	N/A
20:44:05 [2021-05-27T20:44:05.986Z]           │   └─TableRowIDScan_63(Probe)	4.02	435528	cop[tikv]	table:partsupp	time:2.48s, loops:504, cop_task: {num: 1337, max: 77.3ms, min: 384.6µs, avg: 18.3ms, p95: 37.3ms, max_proc_keys: 1028, p95_proc_keys: 672, tot_proc: 18.4s, tot_wait: 4.04s, rpc_num: 1337, rpc_time: 24.5s, copr_cache: disabled}, tikv_task:{proc max:41ms, min:0s, p80:18ms, p95:27ms, iters:5042, tasks:1337}, scan_detail: {total_process_keys: 435528, total_keys: 473516, rocksdb: {delete_skipped_count: 0, key_skipped_count: 194090, block: {cache_hit_count: 3643681, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:44:05 [2021-05-27T20:44:05.986Z]           └─TableReader_101(Probe)	46310896.67	45504356	root		time:34.1s, loops:44289, cop_task: {num: 761, max: 1.17s, min: 352.1ms, avg: 720.1ms, p95: 867.3ms, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 9m4.9s, tot_wait: 121ms, rpc_num: 761, rpc_time: 9m8s, copr_cache: disabled}	data:Selection_100	52.6 MB	N/A
20:44:05 [2021-05-27T20:44:05.986Z]             └─Selection_100	46310896.67	45504356	cop[tikv]		tikv_task:{proc max:1.13s, min:340ms, p80:770ms, p95:850ms, 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:05 [2021-05-27T20:44:05.986Z]               └─TableFullScan_99	300005811.00	300005811	cop[tikv]	table:lineitem	tikv_task:{proc max:1.07s, min:325ms, p80:735ms, p95:820ms, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:44:05 [2021-05-27T20:44:05.986Z] 
20:44:05 [2021-05-27T20:44:05.986Z] queries/20.sql
20:44:05 [2021-05-27T20:44:05.986Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:44:05 [2021-05-27T20:44:05.986Z] Sort_30	20000.00	8982	root		time:37.8s, loops:10	tpch50.supplier.s_name	639.0 KB	0 Bytes
20:44:05 [2021-05-27T20:44:05.986Z] └─HashJoin_35	20000.00	8982	root		time:37.8s, loops:11, build_hash_table:{total:1.38s, fetch:1.37s, build:11.6ms}, probe:{concurrency:5, total:3m9s, max:37.8s, probe:52.4ms, fetch:3m8.9s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.partsupp.ps_suppkey)]	1.52 MB	0 Bytes
20:44:05 [2021-05-27T20:44:05.986Z]   ├─HashJoin_48(Build)	20000.00	19972	root		time:1.38s, loops:23, build_hash_table:{total:216.3µs, fetch:209.6µs, build:6.7µs}, probe:{concurrency:5, total:6.88s, max:1.38s, probe:113.1ms, fetch:6.77s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:44:05 [2021-05-27T20:44:05.986Z]   │ ├─TableReader_53(Build)	1.00	1	root		time:61.8µs, loops:2, cop_task: {num: 1, max: 1.08ms, proc_keys: 25, rpc_num: 1, rpc_time: 1.04ms, copr_cache: disabled}	data:Selection_52	236 Bytes	N/A
20:44:05 [2021-05-27T20:44:05.986Z]   │ │ └─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:05 [2021-05-27T20:44:05.986Z]   │ │   └─TableFullScan_51	25.00	25	cop[tikv]	table:nation	tikv_task:{time:0s, loops:1}	keep order:false	N/A	N/A
20:44:05 [2021-05-27T20:44:05.986Z]   │ └─TableReader_50(Probe)	500000.00	500000	root		time:1.35s, loops:490, cop_task: {num: 1, max: 1.35s, proc_keys: 500000, tot_proc: 1.26s, rpc_num: 1, rpc_time: 1.35s, copr_cache: disabled}	data:TableFullScan_49	35.8 MB	N/A
20:44:05 [2021-05-27T20:44:05.986Z]   │   └─TableFullScan_49	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:1.11s, 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:05 [2021-05-27T20:44:05.987Z]   └─HashAgg_54(Probe)	257492.04	223999	root		time:37.8s, loops:222, partial_worker:{wall_time:37.683544506s, concurrency:5, task_num:289, tot_wait:3m8.167743977s, tot_exec:202.735165ms, tot_time:3m8.407115366s, max:37.683471879s, p95:37.683471879s}, final_worker:{wall_time:37.792788637s, concurrency:5, task_num:25, tot_wait:3m8.402661324s, tot_exec:540.237227ms, tot_time:3m8.942914802s, max:37.792718598s, p95:37.792718598s}	group by:tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_suppkey)->tpch50.partsupp.ps_suppkey	61.4 MB	N/A
20:44:05 [2021-05-27T20:44:05.987Z]     └─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:05 [2021-05-27T20:44:05.987Z]       └─HashAgg_56	321865.05	435528	root		time:37.6s, loops:430, partial_worker:{wall_time:37.315767488s, concurrency:5, task_num:625, tot_wait:3m5.378855477s, tot_exec:1.068040139s, tot_time:3m6.567690742s, max:37.315726835s, p95:37.315726835s}, final_worker:{wall_time:37.672756951s, concurrency:5, task_num:25, tot_wait:3m6.56232111s, tot_exec:1.76550636s, tot_time:3m8.327843751s, max:37.672729828s, p95:37.672729828s}	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:05 [2021-05-27T20:44:05.987Z]         └─HashJoin_59	9711455.06	634004	root		time:37.2s, loops:626, build_hash_table:{total:2.51s, fetch:2.3s, build:210.2ms}, probe:{concurrency:5, total:3m6.2s, max:37.2s, probe:14.7s, fetch:2m51.5s}	left outer join, equal:[eq(tpch50.partsupp.ps_partkey, tpch50.lineitem.l_partkey) eq(tpch50.partsupp.ps_suppkey, tpch50.lineitem.l_suppkey)]	10.4 MB	0 Bytes
20:44:05 [2021-05-27T20:44:05.987Z]           ├─IndexHashJoin_67(Build)	321865.05	435528	root		time:2.47s, loops:430, inner:{total:2.74s, concurrency:5, task:12, construct:128.1ms, fetch:2.27s, build:29.9ms, join:343.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:44:05 [2021-05-27T20:44:05.987Z]           │ ├─TableReader_96(Build)	80007.93	108882	root		time:2.12s, loops:112, cop_task: {num: 20, max: 1.45s, min: 554.1ms, avg: 1.1s, p95: 1.45s, max_proc_keys: 686055, p95_proc_keys: 686055, tot_proc: 21.9s, tot_wait: 31ms, rpc_num: 20, rpc_time: 22s, copr_cache: disabled}	data:Selection_95	665.9 KB	N/A
20:44:05 [2021-05-27T20:44:05.987Z]           │ │ └─Selection_95	80007.93	108882	cop[tikv]		tikv_task:{proc max:1.43s, min:550ms, p80:1.32s, p95:1.43s, iters:9859, tasks:20}, scan_detail: {total_process_keys: 10000000, total_keys: 10000020, rocksdb: {delete_skipped_count: 0, key_skipped_count: 19999980, block: {cache_hit_count: 31499, read_count: 0, read_byte: 0 Bytes}}}	like(tpch50.part.p_name, "green%", 92)	N/A	N/A
20:44:05 [2021-05-27T20:44:05.987Z]           │ │   └─TableFullScan_94	10000000.00	10000000	cop[tikv]	table:part	tikv_task:{proc max:1.34s, min:507ms, p80:1.25s, p95:1.34s, iters:9859, tasks:20}	keep order:false	N/A	N/A
20:44:05 [2021-05-27T20:44:05.987Z]           │ └─IndexLookUp_64(Probe)	4.02	435528	root		time:2.16s, loops:447, index_task: {total_time: 1.29s, fetch_handle: 1.28s, build: 92.7µs, wait: 292.3µs}, table_task: {total_time: 8.44s, num: 57, concurrency: 60}		19.4 KB	N/A
20:44:05 [2021-05-27T20:44:05.987Z]           │   ├─IndexRangeScan_62(Build)	4.02	435528	cop[tikv]	table:partsupp, index:PRIMARY(PS_PARTKEY, PS_SUPPKEY)	time:1.24s, loops:481, cop_task: {num: 61, max: 216ms, min: 6.09ms, avg: 89.2ms, p95: 184ms, max_proc_keys: 15288, p95_proc_keys: 14948, tot_proc: 4.97s, tot_wait: 100ms, rpc_num: 61, rpc_time: 5.44s, copr_cache: disabled}, tikv_task:{proc max:204ms, min:4ms, p80:137ms, p95:169ms, iters:701, tasks:61}, 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:05 [2021-05-27T20:44:05.987Z]           │   └─TableRowIDScan_63(Probe)	4.02	435528	cop[tikv]	table:partsupp	time:2.84s, loops:505, cop_task: {num: 1409, max: 106.9ms, min: 546.8µs, avg: 20.3ms, p95: 41.9ms, max_proc_keys: 972, p95_proc_keys: 628, tot_proc: 19.8s, tot_wait: 5.57s, rpc_num: 1409, rpc_time: 28.5s, copr_cache: disabled}, tikv_task:{proc max:48ms, min:0s, p80:18ms, p95:26ms, iters:5254, tasks:1409}, scan_detail: {total_process_keys: 435528, total_keys: 473535, rocksdb: {delete_skipped_count: 0, key_skipped_count: 194179, block: {cache_hit_count: 3643740, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:44:05 [2021-05-27T20:44:05.987Z]           └─TableReader_101(Probe)	46310896.67	45504356	root		time:32.8s, loops:44290, cop_task: {num: 761, max: 1.16s, min: 386.4ms, avg: 692.2ms, p95: 837.2ms, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 8m43.7s, tot_wait: 137ms, rpc_num: 761, rpc_time: 8m46.8s, copr_cache: disabled}	data:Selection_100	52.6 MB	N/A
20:44:05 [2021-05-27T20:44:05.987Z]             └─Selection_100	46310896.67	45504356	cop[tikv]		tikv_task:{proc max:1.13s, min:371ms, p80:744ms, p95:817ms, iters:296606, tasks:761}, scan_detail: {total_process_keys: 300005811, total_keys: 300006572, rocksdb: {delete_skipped_count: 0, key_skipped_count: 600010861, block: {cache_hit_count: 1124648, read_count: 0, read_byte: 0 Bytes}}}	ge(tpch50.lineitem.l_shipdate, 1993-01-01 00:00:00.000000), lt(tpch50.lineitem.l_shipdate, 1994-01-01)	N/A	N/A
20:44:05 [2021-05-27T20:44:05.987Z]               └─TableFullScan_99	300005811.00	300005811	cop[tikv]	table:lineitem	tikv_task:{proc max:1.09s, min:344ms, p80:711ms, p95:786ms, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:44:05 [2021-05-27T20:44:05.987Z] + sync
20:44:05 [2021-05-27T20:44:05.987Z] + /usr/bin/echo 3
20:44:52 [2021-05-27T20:44:52.654Z] + tiup cluster stop benchbot -y
20:44:52 [2021-05-27T20:44:52.654Z] Starting component `cluster`: /home/tidb/.tiup/components/cluster/v1.4.4/tiup-cluster stop benchbot -y
20:45:00 [2021-05-27T20:45:00.738Z] + rm -rf '/data1/tidb-deploy/*/log/*'
20:45:00 [2021-05-27T20:45:00.738Z] + rm -rf /data1/jenkins/deploy/data/tikv-20160
20:45:02 [2021-05-27T20:45:02.626Z] + rm -rf /data1/jenkins/deploy/data/pd-2379
20:45:02 [2021-05-27T20:45:02.626Z] + rm -rf /data1/jenkins/restore_data/tpch50/data/last_tikv.toml
20:45:02 [2021-05-27T20:45:02.626Z] + cp -R /data1/jenkins/restore_data/tpch50/data /data1/jenkins/deploy/data/tikv-20160
20:46:54 [2021-05-27T20:46:54.057Z] + cp -R /data1/jenkins/restore_data/tpch50/data.pd /data1/jenkins/deploy/data/pd-2379
20:46:54 [2021-05-27T20:46:54.057Z] + '[' -n '' ']'
20:46:54 [2021-05-27T20:46:54.057Z] + tiup cluster start benchbot --wait-timeout=300
20:46:54 [2021-05-27T20:46:54.057Z] Starting component `cluster`: /home/tidb/.tiup/components/cluster/v1.4.4/tiup-cluster start benchbot --wait-timeout=300
20:47:16 [2021-05-27T20:47:16.011Z] + sync
20:47:16 [2021-05-27T20:47:16.011Z] + /usr/bin/echo 3
20:48:54 [2021-05-27T20:48:54.070Z] 
20:48:54 [2021-05-27T20:48:54.070Z] queries/20.sql
20:48:54 [2021-05-27T20:48:54.070Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:48:54 [2021-05-27T20:48:54.070Z] Sort_30	20000.00	8982	root		time:38.4s, loops:10	tpch50.supplier.s_name	641.7 KB	0 Bytes
20:48:54 [2021-05-27T20:48:54.070Z] └─HashJoin_35	20000.00	8982	root		time:38.4s, loops:11, build_hash_table:{total:1.32s, fetch:1.31s, build:8.6ms}, probe:{concurrency:5, total:3m12s, max:38.4s, probe:52ms, fetch:3m11.9s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.partsupp.ps_suppkey)]	1.50 MB	0 Bytes
20:48:54 [2021-05-27T20:48:54.070Z]   ├─HashJoin_48(Build)	20000.00	19972	root		time:1.32s, loops:22, build_hash_table:{total:243.6µs, fetch:237µs, build:6.65µs}, probe:{concurrency:5, total:6.6s, max:1.32s, probe:102.7ms, fetch:6.5s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:48:54 [2021-05-27T20:48:54.070Z]   │ ├─TableReader_53(Build)	1.00	1	root		time:56.1µs, loops:2, cop_task: {num: 1, max: 984.2µs, proc_keys: 25, rpc_num: 1, rpc_time: 937.4µs, copr_cache: disabled}	data:Selection_52	236 Bytes	N/A
20:48:54 [2021-05-27T20:48:54.070Z]   │ │ └─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:48:54 [2021-05-27T20:48:54.070Z]   │ │   └─TableFullScan_51	25.00	25	cop[tikv]	table:nation	tikv_task:{time:0s, loops:1}	keep order:false	N/A	N/A
20:48:54 [2021-05-27T20:48:54.070Z]   │ └─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, tot_wait: 1ms, rpc_num: 1, rpc_time: 1.3s, copr_cache: disabled}	data:TableFullScan_49	35.8 MB	N/A
20:48:54 [2021-05-27T20:48:54.070Z]   │   └─TableFullScan_49	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:1.09s, loops:493}, scan_detail: {total_process_keys: 500000, total_keys: 500001, rocksdb: {delete_skipped_count: 0, key_skipped_count: 999999, block: {cache_hit_count: 1692, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:48:54 [2021-05-27T20:48:54.070Z]   └─HashAgg_54(Probe)	257492.04	223999	root		time:38.4s, loops:222, partial_worker:{wall_time:38.324226302s, concurrency:5, task_num:289, tot_wait:3m11.372634155s, tot_exec:204.902933ms, tot_time:3m11.611547713s, max:38.324209776s, p95:38.324209776s}, final_worker:{wall_time:38.393834988s, concurrency:5, task_num:25, tot_wait:3m11.603529087s, tot_exec:342.37109ms, tot_time:3m11.945914402s, max:38.393810213s, p95:38.393810213s}	group by:tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_suppkey)->tpch50.partsupp.ps_suppkey	61.4 MB	N/A
20:48:54 [2021-05-27T20:48:54.070Z]     └─Selection_55	257492.04	295898	root		time:38.3s, loops:290	gt(cast(tpch50.partsupp.ps_availqty, decimal(20,0) BINARY), mul(0.5, Column#44))	59.2 KB	N/A
20:48:54 [2021-05-27T20:48:54.070Z]       └─HashAgg_56	321865.05	435528	root		time:38.2s, loops:430, partial_worker:{wall_time:37.926622218s, concurrency:5, task_num:624, tot_wait:3m8.233964887s, tot_exec:1.258837083s, tot_time:3m9.618606964s, max:37.926461416s, p95:37.926461416s}, final_worker:{wall_time:38.313378394s, concurrency:5, task_num:25, tot_wait:3m9.602336448s, tot_exec:1.951518907s, tot_time:3m11.553882761s, max:38.313229316s, p95:38.313229316s}	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:48:54 [2021-05-27T20:48:54.070Z]         └─HashJoin_59	9711455.06	634004	root		time:37.8s, loops:625, build_hash_table:{total:2.44s, fetch:2.22s, build:219.1ms}, probe:{concurrency:5, total:3m9s, max:37.8s, probe:14.3s, fetch:2m54.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:48:54 [2021-05-27T20:48:54.070Z]           ├─IndexHashJoin_67(Build)	321865.05	435528	root		time:2.38s, loops:429, inner:{total:2.86s, concurrency:5, task:12, construct:104.5ms, fetch:2.41s, build:27.5ms, join:349.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.5 MB	N/A
20:48:54 [2021-05-27T20:48:54.070Z]           │ ├─TableReader_96(Build)	80007.93	108882	root		time:2.03s, loops:112, cop_task: {num: 20, max: 1.35s, min: 667.4ms, avg: 1.05s, p95: 1.35s, max_proc_keys: 686055, p95_proc_keys: 686055, tot_proc: 20.9s, tot_wait: 36ms, rpc_num: 20, rpc_time: 21.1s, copr_cache: disabled}	data:Selection_95	725.8 KB	N/A
20:48:54 [2021-05-27T20:48:54.070Z]           │ │ └─Selection_95	80007.93	108882	cop[tikv]		tikv_task:{proc max:1.34s, min:664ms, p80:1.26s, p95:1.34s, 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:48:54 [2021-05-27T20:48:54.070Z]           │ │   └─TableFullScan_94	10000000.00	10000000	cop[tikv]	table:part	tikv_task:{proc max:1.23s, min:619ms, p80:1.16s, p95:1.23s, iters:9859, tasks:20}	keep order:false	N/A	N/A
20:48:54 [2021-05-27T20:48:54.070Z]           │ └─IndexLookUp_64(Probe)	4.02	435528	root		time:2.3s, loops:447, index_task: {total_time: 1.37s, fetch_handle: 1.37s, build: 85µs, wait: 275.8µs}, table_task: {total_time: 8.87s, num: 55, concurrency: 60}		20.7 KB	N/A
20:48:54 [2021-05-27T20:48:54.070Z]           │   ├─IndexRangeScan_62(Build)	4.02	435528	cop[tikv]	table:partsupp, index:PRIMARY(PS_PARTKEY, PS_SUPPKEY)	time:1.33s, loops:478, cop_task: {num: 57, max: 282.2ms, min: 6.14ms, avg: 101.3ms, p95: 188.3ms, max_proc_keys: 15288, p95_proc_keys: 15008, tot_proc: 5.2s, tot_wait: 158ms, rpc_num: 57, rpc_time: 5.77s, copr_cache: disabled}, tikv_task:{proc max:268ms, min:4ms, p80:148ms, p95:173ms, iters:684, 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:48:54 [2021-05-27T20:48:54.070Z]           │   └─TableRowIDScan_63(Probe)	4.02	435528	cop[tikv]	table:partsupp	time:2.61s, loops:503, cop_task: {num: 1411, max: 70.3ms, min: 443.9µs, avg: 17.8ms, p95: 37.7ms, max_proc_keys: 1028, p95_proc_keys: 624, tot_proc: 19s, tot_wait: 3.87s, rpc_num: 1411, rpc_time: 25.1s, copr_cache: disabled}, tikv_task:{proc max:47ms, min:0s, p80:17ms, p95:25ms, iters:5245, tasks:1411}, scan_detail: {total_process_keys: 435528, total_keys: 473519, rocksdb: {delete_skipped_count: 0, key_skipped_count: 194103, block: {cache_hit_count: 3644021, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:48:54 [2021-05-27T20:48:54.070Z]           └─TableReader_101(Probe)	46310896.67	45504356	root		time:33.4s, loops:44289, cop_task: {num: 761, max: 1.17s, min: 322.7ms, avg: 704.5ms, p95: 852.2ms, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 8m52.9s, tot_wait: 122ms, rpc_num: 761, rpc_time: 8m56.1s, copr_cache: disabled}	data:Selection_100	52.6 MB	N/A
20:48:54 [2021-05-27T20:48:54.070Z]             └─Selection_100	46310896.67	45504356	cop[tikv]		tikv_task:{proc max:1.14s, min:317ms, p80:748ms, p95:831ms, 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:48:54 [2021-05-27T20:48:54.070Z]               └─TableFullScan_99	300005811.00	300005811	cop[tikv]	table:lineitem	tikv_task:{proc max:1.09s, min:297ms, p80:717ms, p95:800ms, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:48:54 [2021-05-27T20:48:54.070Z] 
20:48:54 [2021-05-27T20:48:54.070Z] queries/21.sql
20:48:54 [2021-05-27T20:48:54.070Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:48:54 [2021-05-27T20:48:54.070Z] 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:48:54 [2021-05-27T20:48:54.070Z] └─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:48:54 [2021-05-27T20:48:54.071Z]   └─HashAgg_34	12800.00	20057	root		time:1m20.7s, loops:21, partial_worker:{wall_time:1m20.711379456s, concurrency:5, task_num:196, tot_wait:6m43.259047733s, tot_exec:283.517929ms, tot_time:6m43.555736431s, max:1m20.711364599s, p95:1m20.711364599s}, final_worker:{wall_time:1m20.733703933s, concurrency:5, task_num:25, tot_wait:6m43.554404436s, tot_exec:109.562573ms, tot_time:6m43.663982539s, max:1m20.733691784s, p95:1m20.733691784s}	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:48:54 [2021-05-27T20:48:54.071Z]     └─IndexHashJoin_42	7828961.66	198698	root		time:1m20.7s, loops:197, inner:{total:2m20.2s, concurrency:5, task:146, construct:6.25s, fetch:1m56.7s, build:1.18s, join:17.2s}	anti semi join, inner:IndexLookUp_39, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey)	641.0 MB	N/A
20:48:54 [2021-05-27T20:48:54.071Z]       ├─IndexHashJoin_83(Build)	9786202.08	3542799	root		time:1m20.2s, loops:3463, inner:{total:2m29.8s, concurrency:5, task:152, construct:7.5s, fetch:2m4.3s, build:1.22s, join:18s}	semi join, inner:IndexLookUp_80, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey), ne(tpch50.lineitem.l_suppkey, tpch50.supplier.s_suppkey)	555.9 MB	N/A
20:48:54 [2021-05-27T20:48:54.071Z]       │ ├─IndexJoin_99(Build)	12232752.60	3675878	root		time:1m19.5s, loops:3595, inner:{total:2m8.7s, concurrency:5, task:305, construct:15.9s, fetch:1m51s, build:1.85s}, probe:5.15s	inner join, inner:TableReader_95, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.orders.o_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.orders.o_orderkey)	582.1 MB	N/A
20:48:54 [2021-05-27T20:48:54.071Z]       │ │ ├─HashJoin_107(Build)	12232752.60	7609895	root		time:1m18.8s, loops:7436, build_hash_table:{total:778.1ms, fetch:767.7ms, build:10.4ms}, probe:{concurrency:5, total:6m36.9s, max:1m19.4s, probe:1m3.6s, fetch:5m33.3s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.lineitem.l_suppkey)]	747.3 KB	0 Bytes
20:48:54 [2021-05-27T20:48:54.071Z]       │ │ │ ├─HashJoin_120(Build)	20000.00	20058	root		time:773.6ms, loops:23, build_hash_table:{total:890µs, fetch:200.3µs, build:689.7µs}, probe:{concurrency:5, total:3.87s, max:775ms, probe:76.4ms, fetch:3.8s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:48:54 [2021-05-27T20:48:54.071Z]       │ │ │ │ ├─TableReader_125(Build)	1.00	1	root		time:61µs, loops:2, cop_task: {num: 1, max: 815.6µs, proc_keys: 25, tot_proc: 1ms, rpc_num: 1, rpc_time: 792.1µs, copr_cache: disabled}	data:Selection_124	242 Bytes	N/A
20:48:54 [2021-05-27T20:48:54.071Z]       │ │ │ │ │ └─Selection_124	1.00	1	cop[tikv]		tikv_task:{time:1ms, loops:1}, scan_detail: {total_process_keys: 25, total_keys: 26, rocksdb: {delete_skipped_count: 0, key_skipped_count: 46, block: {cache_hit_count: 18, read_count: 0, read_byte: 0 Bytes}}}	eq(tpch50.nation.n_name, "EGYPT")	N/A	N/A
20:48:54 [2021-05-27T20:48:54.071Z]       │ │ │ │ │   └─TableFullScan_123	25.00	25	cop[tikv]	table:nation	tikv_task:{time:1ms, loops:1}	keep order:false	N/A	N/A
20:48:54 [2021-05-27T20:48:54.071Z]       │ │ │ │ └─TableReader_122(Probe)	500000.00	500000	root		time:759.6ms, loops:490, cop_task: {num: 1, max: 871.9ms, proc_keys: 500000, tot_proc: 850ms, rpc_num: 1, rpc_time: 871.9ms, copr_cache: disabled}	data:TableFullScan_121	20.0 MB	N/A
20:48:54 [2021-05-27T20:48:54.071Z]       │ │ │ │   └─TableFullScan_121	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:804ms, 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:48:54 [2021-05-27T20:48:54.071Z]       │ │ │ └─TableReader_128(Probe)	240004648.80	189670348	root		time:1m6.6s, loops:184596, cop_task: {num: 761, max: 2.52s, min: 273.2ms, avg: 1.53s, p95: 2.01s, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 18m10s, tot_wait: 59.8s, rpc_num: 761, rpc_time: 19m24.2s, copr_cache: disabled}	data:Selection_127	91.6 MB	N/A
20:48:54 [2021-05-27T20:48:54.071Z]       │ │ │   └─Selection_127	240004648.80	189670348	cop[tikv]		tikv_task:{proc max:1.31s, min:254ms, 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: 18673, read_count: 1131794, read_byte: 23.9 GB}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:48:54 [2021-05-27T20:48:54.071Z]       │ │ │     └─TableFullScan_126	300005811.00	300005811	cop[tikv]	table:l1	tikv_task:{proc max:1.23s, min:240ms, p80:1.12s, p95:1.17s, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:48:54 [2021-05-27T20:48:54.071Z]       │ │ └─TableReader_95(Probe)	0.49	3496173	root		time:1m42s, loops:3875, cop_task: {num: 5257, max: 655.6ms, min: 3.88ms, avg: 182.6ms, p95: 345ms, max_proc_keys: 3702, p95_proc_keys: 1963, tot_proc: 11m19.6s, tot_wait: 3m53.5s, rpc_num: 5257, rpc_time: 15m59.8s, copr_cache: disabled}	data:Selection_94	N/A	N/A
20:48:54 [2021-05-27T20:48:54.071Z]       │ │   └─Selection_94	0.49	3496173	cop[tikv]		tikv_task:{proc max:166ms, min:0s, p80:69ms, p95:82ms, iters:30221, tasks:5257}, scan_detail: {total_process_keys: 7236259, total_keys: 7795497, rocksdb: {delete_skipped_count: 0, key_skipped_count: 1778422, block: {cache_hit_count: 54006666, read_count: 220031, read_byte: 4.63 GB}}}	eq(tpch50.orders.o_orderstatus, "F")	N/A	N/A
20:48:54 [2021-05-27T20:48:54.071Z]       │ │     └─TableRangeScan_93	1.00	7236259	cop[tikv]	table:orders	tikv_task:{proc max:164ms, min:0s, p80:69ms, p95:82ms, iters:30221, tasks:5257}	range: decided by [tpch50.lineitem.l_orderkey], keep order:false	N/A	N/A
20:48:54 [2021-05-27T20:48:54.071Z]       │ └─IndexLookUp_80(Probe)	4.05	17316485	root		time:1m58.9s, loops:17126, index_task: {total_time: 1m5.2s, fetch_handle: 57.5s, build: 3.11ms, wait: 7.74s}, table_task: {total_time: 8m32.3s, num: 1458, concurrency: 760}		19.2 KB	N/A
20:48:54 [2021-05-27T20:48:54.071Z]       │   ├─IndexRangeScan_78(Build)	4.05	17316485	cop[tikv]	table:l2, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:55.2s, loops:18626, cop_task: {num: 2984, max: 683.7ms, min: 2.09ms, avg: 191.2ms, p95: 376.5ms, max_proc_keys: 12044, p95_proc_keys: 8729, tot_proc: 7m6.9s, tot_wait: 1m57.5s, rpc_num: 2984, rpc_time: 9m30.4s, copr_cache: disabled}, tikv_task:{proc max:173ms, min:0s, p80:97ms, p95:114ms, iters:30147, tasks:2984}, scan_detail: {total_process_keys: 17316485, total_keys: 20812593, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17316485, block: {cache_hit_count: 24260227, read_count: 226884, 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:48:54 [2021-05-27T20:48:54.071Z]       │   └─TableRowIDScan_79(Probe)	4.05	17316485	cop[tikv]	table:l2	time:6m16s, loops:20993, cop_task: {num: 7789, max: 800.4ms, min: 439.2µs, avg: 178.5ms, p95: 362.5ms, max_proc_keys: 12685, p95_proc_keys: 4856, tot_proc: 16m36.3s, tot_wait: 5m37.1s, rpc_num: 7789, rpc_time: 23m9.8s, copr_cache: disabled}, tikv_task:{proc max:297ms, min:0s, p80:105ms, p95:141ms, iters:49827, tasks:7789}, scan_detail: {total_process_keys: 17316485, total_keys: 18289663, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5629058, block: {cache_hit_count: 99019519, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:48:54 [2021-05-27T20:48:54.071Z]       └─IndexLookUp_39(Probe)	4.05	12022807	root		time:1m51.6s, loops:11946, index_task: {total_time: 1m0s, fetch_handle: 50.4s, build: 2.97ms, wait: 9.65s}, table_task: {total_time: 7m58.6s, num: 1408, concurrency: 730}		217.1 KB	N/A
20:48:54 [2021-05-27T20:48:54.071Z]         ├─IndexRangeScan_36(Build)	5.06	17183415	cop[tikv]	table:l3, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:48.1s, loops:18361, cop_task: {num: 2790, max: 946.9ms, min: 581µs, avg: 170.1ms, p95: 367.9ms, max_proc_keys: 21689, p95_proc_keys: 13534, tot_proc: 5m51.3s, tot_wait: 1m38.5s, rpc_num: 2790, rpc_time: 7m54.6s, copr_cache: disabled}, tikv_task:{proc max:230ms, min:0s, p80:77ms, p95:116ms, iters:29156, tasks:2790}, scan_detail: {total_process_keys: 17183415, total_keys: 20546446, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17183415, block: {cache_hit_count: 23554023, read_count: 0, read_byte: 0 Bytes}}}	range: decided by [eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey)], keep order:false	N/A	N/A
20:48:54 [2021-05-27T20:48:54.071Z]         └─Selection_38(Probe)	4.05	12022807	cop[tikv]		time:6m5.2s, loops:13765, cop_task: {num: 10166, max: 746.3ms, min: 499.6µs, avg: 170.4ms, p95: 347.8ms, max_proc_keys: 8247, p95_proc_keys: 3983, tot_proc: 20m1.7s, tot_wait: 7m33s, rpc_num: 10166, rpc_time: 28m51.6s, copr_cache: disabled}, tikv_task:{proc max:235ms, min:0s, p80:77ms, p95:116ms, iters:60281, tasks:10166}, scan_detail: {total_process_keys: 17183415, total_keys: 18129907, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5528098, block: {cache_hit_count: 98292550, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:48:54 [2021-05-27T20:48:54.071Z]           └─TableRowIDScan_37	5.06	17183415	cop[tikv]	table:l3	tikv_task:{proc max:235ms, min:0s, p80:76ms, p95:115ms, iters:60281, tasks:10166}	keep order:false	N/A	N/A
20:48:54 [2021-05-27T20:48:54.071Z] + sync
20:48:54 [2021-05-27T20:48:54.071Z] + /usr/bin/echo 3
20:50:15 [2021-05-27T20:50:15.447Z] 
20:50:15 [2021-05-27T20:50:15.447Z] queries/21.sql
20:50:15 [2021-05-27T20:50:15.447Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:50:15 [2021-05-27T20:50:15.447Z] Projection_26	100.00	100	root		time:1m19.2s, loops:2, Concurrency:OFF	tpch50.supplier.s_name, Column#72	4.37 KB	N/A
20:50:15 [2021-05-27T20:50:15.447Z] └─TopN_29	100.00	100	root		time:1m19.2s, loops:2	Column#72:desc, tpch50.supplier.s_name, offset:0, count:100	58.3 KB	N/A
20:50:15 [2021-05-27T20:50:15.447Z]   └─HashAgg_34	12800.00	20057	root		time:1m19.2s, loops:21, partial_worker:{wall_time:1m19.227866365s, concurrency:5, task_num:196, tot_wait:6m35.821488742s, tot_exec:300.980507ms, tot_time:6m36.135982543s, max:1m19.227840372s, p95:1m19.227840372s}, final_worker:{wall_time:1m19.240971717s, concurrency:5, task_num:25, tot_wait:6m36.134801224s, tot_exec:67.6594ms, tot_time:6m36.202473739s, max:1m19.240953429s, p95:1m19.240953429s}	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:15 [2021-05-27T20:50:15.447Z]     └─IndexHashJoin_42	7828961.66	198698	root		time:1m19.2s, loops:197, inner:{total:2m18.7s, concurrency:5, task:146, construct:6.25s, fetch:1m55.4s, build:1.19s, 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:50:15 [2021-05-27T20:50:15.447Z]       ├─IndexHashJoin_83(Build)	9786202.08	3542799	root		time:1m18.7s, loops:3463, inner:{total:2m27s, concurrency:5, task:152, construct:7.79s, fetch:2m1.3s, build:1.27s, join:17.8s}	semi join, inner:IndexLookUp_80, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey), ne(tpch50.lineitem.l_suppkey, tpch50.supplier.s_suppkey)	555.9 MB	N/A
20:50:15 [2021-05-27T20:50:15.447Z]       │ ├─IndexJoin_99(Build)	12232752.60	3675878	root		time:1m18.2s, loops:3595, inner:{total:2m6.2s, concurrency:5, task:305, construct:16.1s, fetch:1m48.2s, build:1.84s}, probe:5.18s	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:50:15 [2021-05-27T20:50:15.447Z]       │ │ ├─HashJoin_107(Build)	12232752.60	7609895	root		time:1m17.6s, loops:7436, build_hash_table:{total:1.09s, fetch:1.08s, build:7.03ms}, probe:{concurrency:5, total:6m30.4s, max:1m18.1s, probe:1m2.7s, fetch:5m27.7s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.lineitem.l_suppkey)]	727.6 KB	0 Bytes
20:50:15 [2021-05-27T20:50:15.447Z]       │ │ │ ├─HashJoin_120(Build)	20000.00	20058	root		time:1.09s, loops:22, build_hash_table:{total:173.7µs, fetch:167.7µs, build:6.03µs}, probe:{concurrency:5, total:5.44s, max:1.09s, probe:65.8ms, fetch:5.37s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:50:15 [2021-05-27T20:50:15.447Z]       │ │ │ │ ├─TableReader_125(Build)	1.00	1	root		time:50.5µs, loops:2, cop_task: {num: 1, max: 1.31ms, proc_keys: 25, rpc_num: 1, rpc_time: 1.29ms, copr_cache: disabled}	data:Selection_124	244 Bytes	N/A
20:50:15 [2021-05-27T20:50:15.447Z]       │ │ │ │ │ └─Selection_124	1.00	1	cop[tikv]		tikv_task:{time:0s, loops:1}, scan_detail: {total_process_keys: 25, total_keys: 26, rocksdb: {delete_skipped_count: 0, key_skipped_count: 46, block: {cache_hit_count: 17, read_count: 1, read_byte: 23.8 KB}}}	eq(tpch50.nation.n_name, "EGYPT")	N/A	N/A
20:50:15 [2021-05-27T20:50:15.447Z]       │ │ │ │ │   └─TableFullScan_123	25.00	25	cop[tikv]	table:nation	tikv_task:{time:0s, loops:1}	keep order:false	N/A	N/A
20:50:15 [2021-05-27T20:50:15.447Z]       │ │ │ │ └─TableReader_122(Probe)	500000.00	500000	root		time:1.07s, loops:490, cop_task: {num: 1, max: 1.08s, proc_keys: 500000, tot_proc: 1.03s, rpc_num: 1, rpc_time: 1.08s, copr_cache: disabled}	data:TableFullScan_121	20.0 MB	N/A
20:50:15 [2021-05-27T20:50:15.447Z]       │ │ │ │   └─TableFullScan_121	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:974ms, 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:15 [2021-05-27T20:50:15.447Z]       │ │ │ └─TableReader_128(Probe)	240004648.80	189670348	root		time:1m5.1s, loops:184598, cop_task: {num: 761, max: 2.58s, min: 289.4ms, avg: 1.5s, p95: 1.91s, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 17m45.2s, tot_wait: 58.7s, rpc_num: 761, rpc_time: 18m58.4s, copr_cache: disabled}	data:Selection_127	109.4 MB	N/A
20:50:15 [2021-05-27T20:50:15.447Z]       │ │ │   └─Selection_127	240004648.80	189670348	cop[tikv]		tikv_task:{proc max:1.28s, min:275ms, 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: 10448, read_count: 1114200, read_byte: 23.6 GB}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:50:15 [2021-05-27T20:50:15.447Z]       │ │ │     └─TableFullScan_126	300005811.00	300005811	cop[tikv]	table:l1	tikv_task:{proc max:1.21s, min:250ms, p80:1.07s, p95:1.12s, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:50:15 [2021-05-27T20:50:15.447Z]       │ │ └─TableReader_95(Probe)	0.49	3496197	root		time:1m39.3s, loops:3875, cop_task: {num: 5266, max: 496.5ms, min: 1.22ms, avg: 176.7ms, p95: 336.9ms, max_proc_keys: 3464, p95_proc_keys: 1970, tot_proc: 11m1.6s, tot_wait: 3m42.9s, rpc_num: 5266, rpc_time: 15m30.5s, copr_cache: disabled}	data:Selection_94	N/A	N/A
20:50:15 [2021-05-27T20:50:15.448Z]       │ │   └─Selection_94	0.49	3496197	cop[tikv]		tikv_task:{proc max:157ms, min:0s, p80:68ms, p95:81ms, iters:30267, tasks:5266}, scan_detail: {total_process_keys: 7236311, total_keys: 7795476, rocksdb: {delete_skipped_count: 0, key_skipped_count: 1778147, block: {cache_hit_count: 54007252, read_count: 218197, read_byte: 4.21 GB}}}	eq(tpch50.orders.o_orderstatus, "F")	N/A	N/A
20:50:15 [2021-05-27T20:50:15.448Z]       │ │     └─TableRangeScan_93	1.00	7236311	cop[tikv]	table:orders	tikv_task:{proc max:156ms, min:0s, p80:68ms, p95:80ms, iters:30267, tasks:5266}	range: decided by [tpch50.lineitem.l_orderkey], keep order:false	N/A	N/A
20:50:15 [2021-05-27T20:50:15.448Z]       │ └─IndexLookUp_80(Probe)	4.05	17316426	root		time:1m55.8s, loops:17135, index_task: {total_time: 1m3.9s, fetch_handle: 55.1s, build: 3.03ms, wait: 8.83s}, table_task: {total_time: 8m18.9s, num: 1458, concurrency: 760}		19.2 KB	N/A
20:50:15 [2021-05-27T20:50:15.448Z]       │   ├─IndexRangeScan_78(Build)	4.05	17316426	cop[tikv]	table:l2, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:52.8s, loops:18617, cop_task: {num: 2977, max: 710.7ms, min: 796.6µs, avg: 186ms, p95: 370.9ms, max_proc_keys: 11555, p95_proc_keys: 8747, tot_proc: 6m49.6s, tot_wait: 1m59.3s, rpc_num: 2977, rpc_time: 9m13.7s, copr_cache: disabled}, tikv_task:{proc max:164ms, min:0s, p80:93ms, p95:108ms, iters:30106, tasks:2977}, scan_detail: {total_process_keys: 17316426, total_keys: 20812525, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17316426, block: {cache_hit_count: 24259942, 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:50:15 [2021-05-27T20:50:15.448Z]       │   └─TableRowIDScan_79(Probe)	4.05	17316426	cop[tikv]	table:l2	time:6m8.5s, loops:20980, cop_task: {num: 7820, max: 635.8ms, min: 525.5µs, avg: 172.2ms, p95: 343.8ms, max_proc_keys: 12940, p95_proc_keys: 4875, tot_proc: 15m58s, tot_wait: 5m29.9s, rpc_num: 7820, rpc_time: 22m26.1s, copr_cache: disabled}, tikv_task:{proc max:293ms, min:0s, p80:102ms, p95:137ms, iters:49963, tasks:7820}, scan_detail: {total_process_keys: 17316426, total_keys: 18289789, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5628185, block: {cache_hit_count: 99025038, read_count: 1111, read_byte: 393.3 MB}}}	keep order:false	N/A	N/A
20:50:15 [2021-05-27T20:50:15.448Z]       └─IndexLookUp_39(Probe)	4.05	12022773	root		time:1m50.3s, loops:11945, index_task: {total_time: 59.1s, fetch_handle: 47.4s, build: 2.94ms, wait: 11.6s}, table_task: {total_time: 7m51.1s, num: 1408, concurrency: 730}		270.8 KB	N/A
20:50:15 [2021-05-27T20:50:15.448Z]         ├─IndexRangeScan_36(Build)	5.06	17183342	cop[tikv]	table:l3, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:45s, loops:18365, cop_task: {num: 2753, max: 911.1ms, min: 706µs, avg: 163.4ms, p95: 347.6ms, max_proc_keys: 21597, p95_proc_keys: 13756, tot_proc: 5m31.1s, tot_wait: 1m34.7s, rpc_num: 2753, rpc_time: 7m29.9s, copr_cache: disabled}, tikv_task:{proc max:161ms, min:0s, p80:76ms, p95:118ms, iters:29005, tasks:2753}, scan_detail: {total_process_keys: 17183342, total_keys: 20546361, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17183342, block: {cache_hit_count: 23553940, 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:15 [2021-05-27T20:50:15.448Z]         └─Selection_38(Probe)	4.05	12022773	cop[tikv]		time:6m2.3s, loops:13783, cop_task: {num: 10229, max: 599.3ms, min: 513.6µs, avg: 168.8ms, p95: 338.2ms, max_proc_keys: 7088, p95_proc_keys: 3966, tot_proc: 19m59s, tot_wait: 7m30.2s, rpc_num: 10229, rpc_time: 28m45.9s, copr_cache: disabled}, tikv_task:{proc max:220ms, min:0s, p80:75ms, p95:113ms, iters:60590, tasks:10229}, scan_detail: {total_process_keys: 17183342, total_keys: 18129966, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5529170, block: {cache_hit_count: 98288781, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:50:15 [2021-05-27T20:50:15.448Z]           └─TableRowIDScan_37	5.06	17183342	cop[tikv]	table:l3	tikv_task:{proc max:220ms, min:0s, p80:75ms, p95:113ms, iters:60590, tasks:10229}	keep order:false	N/A	N/A
20:50:15 [2021-05-27T20:50:15.448Z] + sync
20:50:15 [2021-05-27T20:50:15.448Z] + /usr/bin/echo 3
20:51:36 [2021-05-27T20:51:36.824Z] 
20:51:36 [2021-05-27T20:51:36.824Z] queries/21.sql
20:51:36 [2021-05-27T20:51:36.824Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:51:36 [2021-05-27T20:51:36.824Z] Projection_26	100.00	100	root		time:1m19.5s, loops:2, Concurrency:OFF	tpch50.supplier.s_name, Column#72	4.37 KB	N/A
20:51:36 [2021-05-27T20:51:36.824Z] └─TopN_29	100.00	100	root		time:1m19.5s, loops:2	Column#72:desc, tpch50.supplier.s_name, offset:0, count:100	58.3 KB	N/A
20:51:36 [2021-05-27T20:51:36.824Z]   └─HashAgg_34	12800.00	20057	root		time:1m19.5s, loops:21, partial_worker:{wall_time:1m19.457883422s, concurrency:5, task_num:196, tot_wait:6m36.9904977s, tot_exec:283.065464ms, tot_time:6m37.287020616s, max:1m19.45786005s, p95:1m19.45786005s}, final_worker:{wall_time:1m19.473941275s, concurrency:5, task_num:25, tot_wait:6m37.285907614s, tot_exec:72.548479ms, tot_time:6m37.358468974s, max:1m19.473915727s, p95:1m19.473915727s}	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:51:36 [2021-05-27T20:51:36.824Z]     └─IndexHashJoin_42	7828961.66	198698	root		time:1m19.5s, loops:197, inner:{total:2m18s, concurrency:5, task:146, construct:6.08s, fetch:1m55.5s, build:1.22s, join:16.5s}	anti semi join, inner:IndexLookUp_39, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey)	641.0 MB	N/A
20:51:36 [2021-05-27T20:51:36.824Z]       ├─IndexHashJoin_83(Build)	9786202.08	3542799	root		time:1m18.9s, loops:3463, inner:{total:2m24.7s, concurrency:5, task:152, construct:7.67s, fetch:1m58.9s, build:1.24s, 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:51:36 [2021-05-27T20:51:36.824Z]       │ ├─IndexJoin_99(Build)	12232752.60	3675878	root		time:1m18.4s, loops:3595, inner:{total:2m5s, concurrency:5, task:305, construct:15.9s, fetch:1m47.3s, build:1.91s}, probe:5.09s	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:51:36 [2021-05-27T20:51:36.824Z]       │ │ ├─HashJoin_107(Build)	12232752.60	7609895	root		time:1m17.7s, loops:7436, build_hash_table:{total:1.06s, fetch:1.05s, build:9.39ms}, probe:{concurrency:5, total:6m31.1s, max:1m18.2s, probe:1m2.7s, fetch:5m28.4s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.lineitem.l_suppkey)]	742.5 KB	0 Bytes
20:51:36 [2021-05-27T20:51:36.824Z]       │ │ │ ├─HashJoin_120(Build)	20000.00	20058	root		time:1.06s, loops:23, build_hash_table:{total:195.8µs, fetch:190µs, build:5.77µs}, probe:{concurrency:5, total:5.31s, max:1.06s, probe:74.6ms, fetch:5.23s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:51:36 [2021-05-27T20:51:36.824Z]       │ │ │ │ ├─TableReader_125(Build)	1.00	1	root		time:58.2µs, loops:2, cop_task: {num: 1, max: 1.45ms, proc_keys: 25, rpc_num: 1, rpc_time: 1.4ms, copr_cache: disabled}	data:Selection_124	244 Bytes	N/A
20:51:36 [2021-05-27T20:51:36.824Z]       │ │ │ │ │ └─Selection_124	1.00	1	cop[tikv]		tikv_task:{time:0s, loops:1}, scan_detail: {total_process_keys: 25, total_keys: 26, rocksdb: {delete_skipped_count: 0, key_skipped_count: 46, block: {cache_hit_count: 17, read_count: 1, read_byte: 23.8 KB}}}	eq(tpch50.nation.n_name, "EGYPT")	N/A	N/A
20:51:36 [2021-05-27T20:51:36.825Z]       │ │ │ │ │   └─TableFullScan_123	25.00	25	cop[tikv]	table:nation	tikv_task:{time:0s, loops:1}	keep order:false	N/A	N/A
20:51:36 [2021-05-27T20:51:36.825Z]       │ │ │ │ └─TableReader_122(Probe)	500000.00	500000	root		time:1.05s, loops:490, cop_task: {num: 1, max: 1.05s, proc_keys: 500000, tot_proc: 1.01s, tot_wait: 1ms, rpc_num: 1, rpc_time: 1.05s, copr_cache: disabled}	data:TableFullScan_121	20.0 MB	N/A
20:51:36 [2021-05-27T20:51:36.825Z]       │ │ │ │   └─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:51:36 [2021-05-27T20:51:36.825Z]       │ │ │ └─TableReader_128(Probe)	240004648.80	189670348	root		time:1m5.1s, loops:184598, cop_task: {num: 761, max: 2.51s, min: 316.1ms, avg: 1.5s, p95: 1.96s, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 17m48.3s, tot_wait: 58.3s, rpc_num: 761, rpc_time: 19m1s, copr_cache: disabled}	data:Selection_127	109.4 MB	N/A
20:51:36 [2021-05-27T20:51:36.825Z]       │ │ │   └─Selection_127	240004648.80	189670348	cop[tikv]		tikv_task:{proc max:1.28s, min:297ms, 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: 10451, read_count: 1114197, read_byte: 23.6 GB}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:51:36 [2021-05-27T20:51:36.825Z]       │ │ │     └─TableFullScan_126	300005811.00	300005811	cop[tikv]	table:l1	tikv_task:{proc max:1.21s, min:284ms, p80:1.07s, p95:1.12s, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:51:36 [2021-05-27T20:51:36.825Z]       │ │ └─TableReader_95(Probe)	0.49	3496162	root		time:1m38.2s, loops:3875, cop_task: {num: 5292, max: 586.8ms, min: 868.1µs, avg: 174.4ms, p95: 325.9ms, max_proc_keys: 4464, p95_proc_keys: 1950, tot_proc: 10m58.3s, tot_wait: 3m37s, rpc_num: 5292, rpc_time: 15m22.8s, copr_cache: disabled}	data:Selection_94	N/A	N/A
20:51:36 [2021-05-27T20:51:36.825Z]       │ │   └─Selection_94	0.49	3496162	cop[tikv]		tikv_task:{proc max:147ms, min:0s, p80:68ms, p95:81ms, iters:30290, tasks:5292}, scan_detail: {total_process_keys: 7236281, total_keys: 7795515, rocksdb: {delete_skipped_count: 0, key_skipped_count: 1778360, block: {cache_hit_count: 54006604, read_count: 218250, read_byte: 4.21 GB}}}	eq(tpch50.orders.o_orderstatus, "F")	N/A	N/A
20:51:36 [2021-05-27T20:51:36.825Z]       │ │     └─TableRangeScan_93	1.00	7236281	cop[tikv]	table:orders	tikv_task:{proc max:146ms, min:0s, p80:68ms, p95:81ms, iters:30290, tasks:5292}	range: decided by [tpch50.lineitem.l_orderkey], keep order:false	N/A	N/A
20:51:36 [2021-05-27T20:51:36.825Z]       │ └─IndexLookUp_80(Probe)	4.05	17316468	root		time:1m53.4s, loops:17131, index_task: {total_time: 1m2.5s, fetch_handle: 54.7s, build: 3.34ms, wait: 7.84s}, table_task: {total_time: 8m13.1s, num: 1458, concurrency: 760}		19.2 KB	N/A
20:51:36 [2021-05-27T20:51:36.825Z]       │   ├─IndexRangeScan_78(Build)	4.05	17316468	cop[tikv]	table:l2, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:52.3s, loops:18645, cop_task: {num: 3020, max: 736ms, min: 476µs, avg: 181.4ms, p95: 359.7ms, max_proc_keys: 10754, p95_proc_keys: 8780, tot_proc: 6m44.4s, tot_wait: 1m57.4s, rpc_num: 3020, rpc_time: 9m7.8s, copr_cache: disabled}, tikv_task:{proc max:151ms, min:0s, p80:93ms, p95:108ms, iters:30219, tasks:3020}, scan_detail: {total_process_keys: 17316468, total_keys: 20812572, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17316468, block: {cache_hit_count: 24259975, read_count: 225680, read_byte: 2.00 GB}}}	range: decided by [eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey)], keep order:false	N/A	N/A
20:51:36 [2021-05-27T20:51:36.825Z]       │   └─TableRowIDScan_79(Probe)	4.05	17316468	cop[tikv]	table:l2	time:6m3.2s, loops:21041, cop_task: {num: 7853, max: 654.6ms, min: 412.4µs, avg: 169.8ms, p95: 347.9ms, max_proc_keys: 11970, p95_proc_keys: 4831, tot_proc: 15m51.8s, tot_wait: 5m24.6s, rpc_num: 7853, rpc_time: 22m13.4s, copr_cache: disabled}, tikv_task:{proc max:276ms, min:0s, p80:102ms, p95:138ms, iters:50051, tasks:7853}, scan_detail: {total_process_keys: 17316468, total_keys: 18289902, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5631350, block: {cache_hit_count: 99016677, read_count: 1111, read_byte: 397.1 MB}}}	keep order:false	N/A	N/A
20:51:36 [2021-05-27T20:51:36.825Z]       └─IndexLookUp_39(Probe)	4.05	12022848	root		time:1m50.5s, loops:11945, index_task: {total_time: 59.5s, fetch_handle: 48.9s, build: 4.68ms, wait: 10.6s}, table_task: {total_time: 7m55.1s, num: 1408, concurrency: 730}		232.0 KB	N/A
20:51:36 [2021-05-27T20:51:36.825Z]         ├─IndexRangeScan_36(Build)	5.06	17183455	cop[tikv]	table:l3, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:46.4s, loops:18375, cop_task: {num: 2809, max: 898.9ms, min: 606.8µs, avg: 164.2ms, p95: 351.3ms, max_proc_keys: 21246, p95_proc_keys: 13623, tot_proc: 5m38.3s, tot_wait: 1m38.8s, rpc_num: 2809, rpc_time: 7m41s, copr_cache: disabled}, tikv_task:{proc max:179ms, min:0s, p80:77ms, p95:117ms, iters:29180, tasks:2809}, scan_detail: {total_process_keys: 17183455, total_keys: 20546492, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17183455, 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:51:36 [2021-05-27T20:51:36.825Z]         └─Selection_38(Probe)	4.05	12022848	cop[tikv]		time:6m3.5s, loops:13769, cop_task: {num: 10318, max: 615.3ms, min: 513µs, avg: 168.4ms, p95: 340.8ms, max_proc_keys: 7685, p95_proc_keys: 3924, tot_proc: 20m6.5s, tot_wait: 7m33.1s, rpc_num: 10318, rpc_time: 28m57.3s, copr_cache: disabled}, tikv_task:{proc max:248ms, min:0s, p80:75ms, p95:113ms, iters:60981, tasks:10318}, scan_detail: {total_process_keys: 17183455, total_keys: 18128929, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5525798, block: {cache_hit_count: 98290848, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:51:36 [2021-05-27T20:51:36.825Z]           └─TableRowIDScan_37	5.06	17183455	cop[tikv]	table:l3	tikv_task:{proc max:246ms, min:0s, p80:74ms, p95:112ms, iters:60981, tasks:10318}	keep order:false	N/A	N/A
20:51:36 [2021-05-27T20:51:36.825Z] + sync
20:51:36 [2021-05-27T20:51:36.825Z] + /usr/bin/echo 3
20:52:58 [2021-05-27T20:52:58.202Z] 
20:52:58 [2021-05-27T20:52:58.202Z] queries/21.sql
20:52:58 [2021-05-27T20:52:58.202Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:52:58 [2021-05-27T20:52:58.202Z] Projection_26	100.00	100	root		time:1m19.3s, loops:2, Concurrency:OFF	tpch50.supplier.s_name, Column#72	4.37 KB	N/A
20:52:58 [2021-05-27T20:52:58.202Z] └─TopN_29	100.00	100	root		time:1m19.3s, loops:2	Column#72:desc, tpch50.supplier.s_name, offset:0, count:100	55.0 KB	N/A
20:52:58 [2021-05-27T20:52:58.202Z]   └─HashAgg_34	12800.00	20057	root		time:1m19.3s, loops:21, partial_worker:{wall_time:1m19.274143493s, concurrency:5, task_num:197, tot_wait:6m36.080894755s, tot_exec:275.253822ms, tot_time:6m36.368759833s, max:1m19.274129415s, p95:1m19.274129415s}, final_worker:{wall_time:1m19.289440815s, concurrency:5, task_num:25, tot_wait:6m36.367941655s, tot_exec:70.060708ms, tot_time:6m36.438014144s, max:1m19.289420983s, p95:1m19.289420983s}	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:58 [2021-05-27T20:52:58.202Z]     └─IndexHashJoin_42	7828961.66	198698	root		time:1m19.3s, loops:198, inner:{total:2m16.6s, concurrency:5, task:146, construct:6.32s, fetch:1m53.5s, build:1.3s, join:16.8s}	anti semi join, inner:IndexLookUp_39, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey)	641.1 MB	N/A
20:52:58 [2021-05-27T20:52:58.202Z]       ├─IndexHashJoin_83(Build)	9786202.08	3542799	root		time:1m18.7s, loops:3463, inner:{total:2m26.2s, concurrency:5, task:152, construct:7.8s, fetch:2m0.2s, build:1.23s, join:18.2s}	semi join, inner:IndexLookUp_80, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey), ne(tpch50.lineitem.l_suppkey, tpch50.supplier.s_suppkey)	555.9 MB	N/A
20:52:58 [2021-05-27T20:52:58.202Z]       │ ├─IndexJoin_99(Build)	12232752.60	3675878	root		time:1m18.2s, loops:3595, inner:{total:2m2.7s, concurrency:5, task:305, construct:15.7s, fetch:1m45.2s, build:1.79s}, probe:5.05s	inner join, inner:TableReader_95, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.orders.o_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.orders.o_orderkey)	582.2 MB	N/A
20:52:58 [2021-05-27T20:52:58.202Z]       │ │ ├─HashJoin_107(Build)	12232752.60	7609895	root		time:1m17.7s, loops:7437, build_hash_table:{total:972.9ms, fetch:965ms, build:7.88ms}, probe:{concurrency:5, total:6m31s, max:1m18.2s, probe:1m2.5s, fetch:5m28.5s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.lineitem.l_suppkey)]	727.6 KB	0 Bytes
20:52:58 [2021-05-27T20:52:58.202Z]       │ │ │ ├─HashJoin_120(Build)	20000.00	20058	root		time:969.8ms, loops:22, build_hash_table:{total:178.7µs, fetch:172.7µs, build:5.98µs}, probe:{concurrency:5, total:4.86s, max:971.1ms, probe:75.9ms, fetch:4.78s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:52:58 [2021-05-27T20:52:58.202Z]       │ │ │ │ ├─TableReader_125(Build)	1.00	1	root		time:52.2µs, loops:2, cop_task: {num: 1, max: 1.52ms, proc_keys: 25, tot_proc: 1ms, rpc_num: 1, rpc_time: 1.49ms, copr_cache: disabled}	data:Selection_124	248 Bytes	N/A
20:52:58 [2021-05-27T20:52:58.202Z]       │ │ │ │ │ └─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:58 [2021-05-27T20:52:58.202Z]       │ │ │ │ │   └─TableFullScan_123	25.00	25	cop[tikv]	table:nation	tikv_task:{time:1ms, loops:1}	keep order:false	N/A	N/A
20:52:58 [2021-05-27T20:52:58.202Z]       │ │ │ │ └─TableReader_122(Probe)	500000.00	500000	root		time:955.7ms, loops:490, cop_task: {num: 1, max: 956.2ms, proc_keys: 500000, tot_proc: 918ms, rpc_num: 1, rpc_time: 956.2ms, copr_cache: disabled}	data:TableFullScan_121	20.0 MB	N/A
20:52:58 [2021-05-27T20:52:58.202Z]       │ │ │ │   └─TableFullScan_121	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:857ms, 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:58 [2021-05-27T20:52:58.202Z]       │ │ │ └─TableReader_128(Probe)	240004648.80	189670348	root		time:1m5.4s, loops:184598, cop_task: {num: 761, max: 2.7s, min: 299.2ms, avg: 1.5s, p95: 1.99s, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 17m47.9s, tot_wait: 57.6s, rpc_num: 761, rpc_time: 19m0.3s, copr_cache: disabled}	data:Selection_127	91.6 MB	N/A
20:52:58 [2021-05-27T20:52:58.202Z]       │ │ │   └─Selection_127	240004648.80	189670348	cop[tikv]		tikv_task:{proc max:1.33s, min:287ms, p80:1.15s, p95:1.19s, iters:296606, tasks:761}, scan_detail: {total_process_keys: 300005811, total_keys: 300006572, rocksdb: {delete_skipped_count: 0, key_skipped_count: 600010861, block: {cache_hit_count: 10455, read_count: 1114193, read_byte: 23.6 GB}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:52:58 [2021-05-27T20:52:58.202Z]       │ │ │     └─TableFullScan_126	300005811.00	300005811	cop[tikv]	table:l1	tikv_task:{proc max:1.25s, min:270ms, p80:1.07s, p95:1.11s, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:52:58 [2021-05-27T20:52:58.202Z]       │ │ └─TableReader_95(Probe)	0.49	3496204	root		time:1m36.4s, loops:3875, cop_task: {num: 5276, max: 515.1ms, min: 1.53ms, avg: 174ms, p95: 327ms, max_proc_keys: 4401, p95_proc_keys: 1956, tot_proc: 10m52.2s, tot_wait: 3m37s, rpc_num: 5276, rpc_time: 15m17.9s, copr_cache: disabled}	data:Selection_94	N/A	N/A
20:52:58 [2021-05-27T20:52:58.202Z]       │ │   └─Selection_94	0.49	3496204	cop[tikv]		tikv_task:{proc max:159ms, min:0s, p80:68ms, p95:82ms, iters:30243, tasks:5276}, scan_detail: {total_process_keys: 7236312, total_keys: 7795506, rocksdb: {delete_skipped_count: 0, key_skipped_count: 1778278, block: {cache_hit_count: 54006969, read_count: 218177, read_byte: 4.21 GB}}}	eq(tpch50.orders.o_orderstatus, "F")	N/A	N/A
20:52:58 [2021-05-27T20:52:58.202Z]       │ │     └─TableRangeScan_93	1.00	7236312	cop[tikv]	table:orders	tikv_task:{proc max:159ms, min:0s, p80:67ms, p95:81ms, iters:30243, tasks:5276}	range: decided by [tpch50.lineitem.l_orderkey], keep order:false	N/A	N/A
20:52:58 [2021-05-27T20:52:58.202Z]       │ └─IndexLookUp_80(Probe)	4.05	17316418	root		time:1m54.9s, loops:17128, index_task: {total_time: 1m1.9s, fetch_handle: 53.8s, build: 3.26ms, wait: 8.07s}, table_task: {total_time: 8m12.6s, num: 1458, concurrency: 760}		19.2 KB	N/A
20:52:58 [2021-05-27T20:52:58.202Z]       │   ├─IndexRangeScan_78(Build)	4.05	17316418	cop[tikv]	table:l2, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:51.4s, loops:18630, cop_task: {num: 2994, max: 613.3ms, min: 463.7µs, avg: 183.4ms, p95: 356.4ms, max_proc_keys: 15310, p95_proc_keys: 8722, tot_proc: 6m45.7s, tot_wait: 1m57.4s, rpc_num: 2994, rpc_time: 9m9s, copr_cache: disabled}, tikv_task:{proc max:204ms, min:0s, p80:94ms, p95:108ms, iters:30132, tasks:2994}, scan_detail: {total_process_keys: 17316418, total_keys: 20812515, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17316418, block: {cache_hit_count: 24259930, 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:52:58 [2021-05-27T20:52:58.202Z]       │   └─TableRowIDScan_79(Probe)	4.05	17316418	cop[tikv]	table:l2	time:6m1.2s, loops:21006, cop_task: {num: 7797, max: 567ms, min: 498.7µs, avg: 169.4ms, p95: 344.2ms, max_proc_keys: 10957, p95_proc_keys: 4847, tot_proc: 15m43.3s, tot_wait: 5m18.1s, rpc_num: 7797, rpc_time: 22m0.6s, copr_cache: disabled}, tikv_task:{proc max:237ms, min:0s, p80:102ms, p95:138ms, iters:49877, tasks:7797}, scan_detail: {total_process_keys: 17316418, total_keys: 18288473, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5625237, block: {cache_hit_count: 99023733, read_count: 1112, read_byte: 393.5 MB}}}	keep order:false	N/A	N/A
20:52:58 [2021-05-27T20:52:58.202Z]       └─IndexLookUp_39(Probe)	4.05	12022749	root		time:1m48.6s, loops:11936, index_task: {total_time: 58.1s, fetch_handle: 47.5s, build: 2.85ms, wait: 10.6s}, table_task: {total_time: 7m46.5s, num: 1408, concurrency: 730}		269.5 KB	N/A
20:52:58 [2021-05-27T20:52:58.202Z]         ├─IndexRangeScan_36(Build)	5.06	17183318	cop[tikv]	table:l3, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:45.2s, loops:18381, cop_task: {num: 2765, max: 752.3ms, min: 810.1µs, avg: 163.4ms, p95: 342.8ms, max_proc_keys: 17973, p95_proc_keys: 13713, tot_proc: 5m29.2s, tot_wait: 1m39.8s, rpc_num: 2765, rpc_time: 7m31.7s, copr_cache: disabled}, tikv_task:{proc max:174ms, min:0s, p80:76ms, p95:118ms, iters:29035, tasks:2765}, scan_detail: {total_process_keys: 17183318, total_keys: 20546331, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17183318, block: {cache_hit_count: 23553898, 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:58 [2021-05-27T20:52:58.202Z]         └─Selection_38(Probe)	4.05	12022749	cop[tikv]		time:5m56.2s, loops:13771, cop_task: {num: 10158, max: 568.7ms, min: 387.9µs, avg: 165.8ms, p95: 330ms, max_proc_keys: 9150, p95_proc_keys: 4017, tot_proc: 19m36.5s, tot_wait: 7m12s, rpc_num: 10158, rpc_time: 28m3.6s, copr_cache: disabled}, tikv_task:{proc max:213ms, min:0s, p80:77ms, p95:116ms, iters:60403, tasks:10158}, scan_detail: {total_process_keys: 17183318, total_keys: 18128893, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5525527, block: {cache_hit_count: 98289132, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:52:58 [2021-05-27T20:52:58.202Z]           └─TableRowIDScan_37	5.06	17183318	cop[tikv]	table:l3	tikv_task:{proc max:210ms, min:0s, p80:76ms, p95:115ms, iters:60403, tasks:10158}	keep order:false	N/A	N/A
20:52:58 [2021-05-27T20:52:58.202Z] + sync
20:52:58 [2021-05-27T20:52:58.202Z] + /usr/bin/echo 3
20:54:19 [2021-05-27T20:54:19.594Z] 
20:54:19 [2021-05-27T20:54:19.594Z] queries/21.sql
20:54:19 [2021-05-27T20:54:19.594Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:54:19 [2021-05-27T20:54:19.594Z] Projection_26	100.00	100	root		time:1m19.4s, loops:2, Concurrency:OFF	tpch50.supplier.s_name, Column#72	4.37 KB	N/A
20:54:19 [2021-05-27T20:54:19.594Z] └─TopN_29	100.00	100	root		time:1m19.4s, loops:2	Column#72:desc, tpch50.supplier.s_name, offset:0, count:100	58.3 KB	N/A
20:54:19 [2021-05-27T20:54:19.594Z]   └─HashAgg_34	12800.00	20057	root		time:1m19.4s, loops:21, partial_worker:{wall_time:1m19.357264821s, concurrency:5, task_num:198, tot_wait:6m36.517564199s, tot_exec:253.000012ms, tot_time:6m36.784159624s, max:1m19.357239358s, p95:1m19.357239358s}, final_worker:{wall_time:1m19.368837013s, concurrency:5, task_num:25, tot_wait:6m36.782482438s, tot_exec:61.298718ms, tot_time:6m36.843792678s, max:1m19.36881695s, p95:1m19.36881695s}	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:19 [2021-05-27T20:54:19.594Z]     └─IndexHashJoin_42	7828961.66	198698	root		time:1m19.4s, loops:199, inner:{total:2m14.6s, concurrency:5, task:147, construct:5.9s, fetch:1m51.9s, build:1.22s, join:16.8s}	anti semi join, inner:IndexLookUp_39, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey)	641.1 MB	N/A
20:54:19 [2021-05-27T20:54:19.594Z]       ├─IndexHashJoin_83(Build)	9786202.08	3542799	root		time:1m18.9s, loops:3464, inner:{total:2m24.4s, concurrency:5, task:152, construct:7.7s, fetch:1m59.3s, build:1.26s, join:17.4s}	semi join, inner:IndexLookUp_80, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey), ne(tpch50.lineitem.l_suppkey, tpch50.supplier.s_suppkey)	555.9 MB	N/A
20:54:19 [2021-05-27T20:54:19.594Z]       │ ├─IndexJoin_99(Build)	12232752.60	3675878	root		time:1m18.4s, loops:3595, inner:{total:2m0.9s, concurrency:5, task:305, construct:15.4s, fetch:1m43.7s, build:1.77s}, probe:5.14s	inner join, inner:TableReader_95, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.orders.o_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.orders.o_orderkey)	582.0 MB	N/A
20:54:19 [2021-05-27T20:54:19.594Z]       │ │ ├─HashJoin_107(Build)	12232752.60	7609895	root		time:1m17.8s, loops:7436, build_hash_table:{total:1.06s, fetch:1.05s, build:6.35ms}, probe:{concurrency:5, total:6m31.2s, max:1m18.2s, probe:1m1.2s, fetch:5m30s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.lineitem.l_suppkey)]	703.1 KB	0 Bytes
20:54:19 [2021-05-27T20:54:19.594Z]       │ │ │ ├─HashJoin_120(Build)	20000.00	20058	root		time:1.06s, loops:21, build_hash_table:{total:159.3µs, fetch:154µs, build:5.22µs}, probe:{concurrency:5, total:5.29s, max:1.06s, probe:61.3ms, fetch:5.23s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:54:19 [2021-05-27T20:54:19.594Z]       │ │ │ │ ├─TableReader_125(Build)	1.00	1	root		time:41.2µs, loops:2, cop_task: {num: 1, max: 1.48ms, proc_keys: 25, rpc_num: 1, rpc_time: 1.44ms, copr_cache: disabled}	data:Selection_124	240 Bytes	N/A
20:54:19 [2021-05-27T20:54:19.594Z]       │ │ │ │ │ └─Selection_124	1.00	1	cop[tikv]		tikv_task:{time:0s, loops:1}, scan_detail: {total_process_keys: 25, total_keys: 26, rocksdb: {delete_skipped_count: 0, key_skipped_count: 46, block: {cache_hit_count: 17, read_count: 1, read_byte: 23.8 KB}}}	eq(tpch50.nation.n_name, "EGYPT")	N/A	N/A
20:54:19 [2021-05-27T20:54:19.594Z]       │ │ │ │ │   └─TableFullScan_123	25.00	25	cop[tikv]	table:nation	tikv_task:{time:0s, loops:1}	keep order:false	N/A	N/A
20:54:19 [2021-05-27T20:54:19.594Z]       │ │ │ │ └─TableReader_122(Probe)	500000.00	500000	root		time:1.04s, loops:490, cop_task: {num: 1, max: 1.05s, proc_keys: 500000, tot_proc: 1.01s, rpc_num: 1, rpc_time: 1.05s, copr_cache: disabled}	data:TableFullScan_121	20.0 MB	N/A
20:54:19 [2021-05-27T20:54:19.594Z]       │ │ │ │   └─TableFullScan_121	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:949ms, 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:19 [2021-05-27T20:54:19.594Z]       │ │ │ └─TableReader_128(Probe)	240004648.80	189670348	root		time:1m5.4s, loops:184597, cop_task: {num: 761, max: 2.7s, min: 270.6ms, avg: 1.5s, p95: 1.95s, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 17m50.6s, tot_wait: 57.6s, rpc_num: 761, rpc_time: 19m2.3s, copr_cache: disabled}	data:Selection_127	109.4 MB	N/A
20:54:19 [2021-05-27T20:54:19.594Z]       │ │ │   └─Selection_127	240004648.80	189670348	cop[tikv]		tikv_task:{proc max:1.31s, min:258ms, 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: 10450, read_count: 1114198, read_byte: 23.6 GB}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:54:19 [2021-05-27T20:54:19.594Z]       │ │ │     └─TableFullScan_126	300005811.00	300005811	cop[tikv]	table:l1	tikv_task:{proc max:1.23s, min:241ms, p80:1.08s, p95:1.13s, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:54:19 [2021-05-27T20:54:19.594Z]       │ │ └─TableReader_95(Probe)	0.49	3496157	root		time:1m34.6s, loops:3875, cop_task: {num: 5231, max: 525.7ms, min: 745.5µs, avg: 171.1ms, p95: 318.4ms, max_proc_keys: 3698, p95_proc_keys: 1952, tot_proc: 10m40.2s, tot_wait: 3m29.7s, rpc_num: 5231, rpc_time: 14m55.1s, copr_cache: disabled}	data:Selection_94	N/A	N/A
20:54:19 [2021-05-27T20:54:19.594Z]       │ │   └─Selection_94	0.49	3496157	cop[tikv]		tikv_task:{proc max:133ms, min:0s, p80:68ms, p95:80ms, iters:30173, tasks:5231}, scan_detail: {total_process_keys: 7236238, total_keys: 7795523, rocksdb: {delete_skipped_count: 0, key_skipped_count: 1778471, block: {cache_hit_count: 54008051, read_count: 216220, read_byte: 4.17 GB}}}	eq(tpch50.orders.o_orderstatus, "F")	N/A	N/A
20:54:19 [2021-05-27T20:54:19.594Z]       │ │     └─TableRangeScan_93	1.00	7236238	cop[tikv]	table:orders	tikv_task:{proc max:133ms, min:0s, p80:68ms, p95:79ms, iters:30173, tasks:5231}	range: decided by [tpch50.lineitem.l_orderkey], keep order:false	N/A	N/A
20:54:19 [2021-05-27T20:54:19.594Z]       │ └─IndexLookUp_80(Probe)	4.05	17316463	root		time:1m54s, loops:17131, index_task: {total_time: 1m2.6s, fetch_handle: 54.3s, build: 3.5ms, wait: 8.3s}, table_task: {total_time: 8m10.2s, num: 1458, concurrency: 760}		19.2 KB	N/A
20:54:19 [2021-05-27T20:54:19.594Z]       │   ├─IndexRangeScan_78(Build)	4.05	17316463	cop[tikv]	table:l2, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:52s, loops:18594, cop_task: {num: 2967, max: 840.9ms, min: 488.4µs, avg: 181.7ms, p95: 359.7ms, max_proc_keys: 13975, p95_proc_keys: 8754, tot_proc: 6m44.6s, tot_wait: 1m49.4s, rpc_num: 2967, rpc_time: 8m59s, copr_cache: disabled}, tikv_task:{proc max:170ms, min:0s, p80:94ms, p95:107ms, iters:30086, tasks:2967}, scan_detail: {total_process_keys: 17316463, total_keys: 20812568, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17316463, block: {cache_hit_count: 24259976, read_count: 225687, read_byte: 2.00 GB}}}	range: decided by [eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey)], keep order:false	N/A	N/A
20:54:19 [2021-05-27T20:54:19.594Z]       │   └─TableRowIDScan_79(Probe)	4.05	17316463	cop[tikv]	table:l2	time:6m2.6s, loops:20985, cop_task: {num: 7742, max: 709.9ms, min: 461.3µs, avg: 171.1ms, p95: 342.1ms, max_proc_keys: 12685, p95_proc_keys: 4834, tot_proc: 15m49.7s, tot_wait: 5m18.1s, rpc_num: 7742, rpc_time: 22m4s, copr_cache: disabled}, tikv_task:{proc max:232ms, min:0s, p80:103ms, p95:137ms, iters:49798, tasks:7742}, scan_detail: {total_process_keys: 17316463, total_keys: 18288319, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5624700, block: {cache_hit_count: 99019784, read_count: 1114, read_byte: 396.0 MB}}}	keep order:false	N/A	N/A
20:54:19 [2021-05-27T20:54:19.594Z]       └─IndexLookUp_39(Probe)	4.05	12022815	root		time:1m47.2s, loops:11945, index_task: {total_time: 57.2s, fetch_handle: 46.9s, build: 3.19ms, wait: 10.2s}, table_task: {total_time: 7m40.1s, num: 1410, concurrency: 735}		257.4 KB	N/A
20:54:19 [2021-05-27T20:54:19.594Z]         ├─IndexRangeScan_36(Build)	5.06	17183395	cop[tikv]	table:l3, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:44.6s, loops:18367, cop_task: {num: 2754, max: 733.4ms, min: 700.3µs, avg: 159.2ms, p95: 348ms, max_proc_keys: 18841, p95_proc_keys: 13514, tot_proc: 5m22.9s, tot_wait: 1m32.5s, rpc_num: 2754, rpc_time: 7m18.5s, copr_cache: disabled}, tikv_task:{proc max:165ms, min:0s, p80:76ms, p95:117ms, iters:29039, tasks:2754}, scan_detail: {total_process_keys: 17183395, total_keys: 20546425, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17183395, block: {cache_hit_count: 23554017, 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:19 [2021-05-27T20:54:19.594Z]         └─Selection_38(Probe)	4.05	12022815	cop[tikv]		time:5m48.8s, loops:13779, cop_task: {num: 10145, max: 612.9ms, min: 549.5µs, avg: 163.3ms, p95: 333.2ms, max_proc_keys: 7233, p95_proc_keys: 4014, tot_proc: 19m22.1s, tot_wait: 6m59s, rpc_num: 10145, rpc_time: 27m36.1s, copr_cache: disabled}, tikv_task:{proc max:212ms, min:0s, p80:76ms, p95:115ms, iters:60393, tasks:10145}, scan_detail: {total_process_keys: 17183395, total_keys: 18130100, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5530069, block: {cache_hit_count: 98288861, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:54:19 [2021-05-27T20:54:19.594Z]           └─TableRowIDScan_37	5.06	17183395	cop[tikv]	table:l3	tikv_task:{proc max:210ms, min:0s, p80:75ms, p95:114ms, iters:60393, tasks:10145}	keep order:false	N/A	N/A
20:54:19 [2021-05-27T20:54:19.594Z] + sync
20:54:19 [2021-05-27T20:54:19.594Z] + /usr/bin/echo 3
20:55:55 [2021-05-27T20:55:55.980Z] 
20:55:55 [2021-05-27T20:55:55.980Z] queries/21.sql
20:55:55 [2021-05-27T20:55:55.980Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:55:55 [2021-05-27T20:55:55.980Z] Projection_26	100.00	100	root		time:1m19.2s, loops:2, Concurrency:OFF	tpch50.supplier.s_name, Column#72	4.37 KB	N/A
20:55:55 [2021-05-27T20:55:55.980Z] └─TopN_29	100.00	100	root		time:1m19.2s, loops:2	Column#72:desc, tpch50.supplier.s_name, offset:0, count:100	58.3 KB	N/A
20:55:55 [2021-05-27T20:55:55.980Z]   └─HashAgg_34	12800.00	20057	root		time:1m19.2s, loops:21, partial_worker:{wall_time:1m19.226197967s, concurrency:5, task_num:197, tot_wait:6m35.864299883s, tot_exec:252.29368ms, tot_time:6m36.129147505s, max:1m19.226175437s, p95:1m19.226175437s}, final_worker:{wall_time:1m19.241964426s, concurrency:5, task_num:25, tot_wait:6m36.128483283s, tot_exec:69.839882ms, tot_time:6m36.198336932s, max:1m19.241946714s, p95:1m19.241946714s}	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:55 [2021-05-27T20:55:55.980Z]     └─IndexHashJoin_42	7828961.66	198698	root		time:1m19.2s, loops:198, inner:{total:2m17.6s, concurrency:5, task:147, construct:5.95s, fetch:1m54.6s, build:1.17s, 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:55 [2021-05-27T20:55:55.980Z]       ├─IndexHashJoin_83(Build)	9786202.08	3542799	root		time:1m18.7s, loops:3463, inner:{total:2m25.6s, concurrency:5, task:152, construct:7.43s, fetch:2m0.6s, build:1.29s, join:17.5s}	semi join, inner:IndexLookUp_80, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey), ne(tpch50.lineitem.l_suppkey, tpch50.supplier.s_suppkey)	555.9 MB	N/A
20:55:55 [2021-05-27T20:55:55.980Z]       │ ├─IndexJoin_99(Build)	12232752.60	3675878	root		time:1m18.2s, loops:3595, inner:{total:2m5.9s, concurrency:5, task:305, construct:15.8s, fetch:1m48.3s, build:1.86s}, probe:5.18s	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:55 [2021-05-27T20:55:55.980Z]       │ │ ├─HashJoin_107(Build)	12232752.60	7609895	root		time:1m17.4s, loops:7436, build_hash_table:{total:1.06s, fetch:1.05s, build:7.11ms}, probe:{concurrency:5, total:6m29.8s, max:1m18s, probe:1m2.8s, fetch:5m27s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.lineitem.l_suppkey)]	747.3 KB	0 Bytes
20:55:55 [2021-05-27T20:55:55.980Z]       │ │ │ ├─HashJoin_120(Build)	20000.00	20058	root		time:1.06s, loops:23, build_hash_table:{total:200.9µs, fetch:194.5µs, build:6.39µs}, probe:{concurrency:5, total:5.3s, max:1.06s, probe:65.5ms, fetch:5.23s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:55:55 [2021-05-27T20:55:55.980Z]       │ │ │ │ ├─TableReader_125(Build)	1.00	1	root		time:66.5µs, loops:2, cop_task: {num: 1, max: 1.42ms, proc_keys: 25, tot_proc: 1ms, rpc_num: 1, rpc_time: 1.39ms, copr_cache: disabled}	data:Selection_124	248 Bytes	N/A
20:55:55 [2021-05-27T20:55:55.980Z]       │ │ │ │ │ └─Selection_124	1.00	1	cop[tikv]		tikv_task:{time:1ms, loops:1}, scan_detail: {total_process_keys: 25, total_keys: 26, rocksdb: {delete_skipped_count: 0, key_skipped_count: 46, block: {cache_hit_count: 17, read_count: 1, read_byte: 23.8 KB}}}	eq(tpch50.nation.n_name, "EGYPT")	N/A	N/A
20:55:55 [2021-05-27T20:55:55.980Z]       │ │ │ │ │   └─TableFullScan_123	25.00	25	cop[tikv]	table:nation	tikv_task:{time:1ms, loops:1}	keep order:false	N/A	N/A
20:55:55 [2021-05-27T20:55:55.980Z]       │ │ │ │ └─TableReader_122(Probe)	500000.00	500000	root		time:1.05s, loops:490, cop_task: {num: 1, max: 1.05s, proc_keys: 500000, tot_proc: 1s, rpc_num: 1, rpc_time: 1.05s, copr_cache: disabled}	data:TableFullScan_121	20.0 MB	N/A
20:55:55 [2021-05-27T20:55:55.980Z]       │ │ │ │   └─TableFullScan_121	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:935ms, 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:55 [2021-05-27T20:55:55.980Z]       │ │ │ └─TableReader_128(Probe)	240004648.80	189670348	root		time:1m4.9s, loops:184597, cop_task: {num: 761, max: 2.68s, min: 408.1ms, avg: 1.5s, p95: 1.98s, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 17m46.6s, tot_wait: 58.5s, rpc_num: 761, rpc_time: 18m59.8s, copr_cache: disabled}	data:Selection_127	109.4 MB	N/A
20:55:55 [2021-05-27T20:55:55.980Z]       │ │ │   └─Selection_127	240004648.80	189670348	cop[tikv]		tikv_task:{proc max:1.33s, min:388ms, 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: 10451, read_count: 1114197, read_byte: 23.6 GB}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:55:55 [2021-05-27T20:55:55.981Z]       │ │ │     └─TableFullScan_126	300005811.00	300005811	cop[tikv]	table:l1	tikv_task:{proc max:1.24s, min:358ms, p80:1.08s, p95:1.12s, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:55:55 [2021-05-27T20:55:55.981Z]       │ │ └─TableReader_95(Probe)	0.49	3496176	root		time:1m39.3s, loops:3875, cop_task: {num: 5273, max: 552.9ms, min: 1.1ms, avg: 174.2ms, p95: 328.3ms, max_proc_keys: 4897, p95_proc_keys: 1962, tot_proc: 10m56.2s, tot_wait: 3m34.1s, rpc_num: 5273, rpc_time: 15m18.6s, copr_cache: disabled}	data:Selection_94	N/A	N/A
20:55:55 [2021-05-27T20:55:55.981Z]       │ │   └─Selection_94	0.49	3496176	cop[tikv]		tikv_task:{proc max:185ms, min:0s, p80:69ms, p95:81ms, iters:30282, tasks:5273}, scan_detail: {total_process_keys: 7236266, total_keys: 7795489, rocksdb: {delete_skipped_count: 0, key_skipped_count: 1778379, block: {cache_hit_count: 54006074, read_count: 218057, read_byte: 4.21 GB}}}	eq(tpch50.orders.o_orderstatus, "F")	N/A	N/A
20:55:55 [2021-05-27T20:55:55.981Z]       │ │     └─TableRangeScan_93	1.00	7236266	cop[tikv]	table:orders	tikv_task:{proc max:183ms, min:0s, p80:68ms, p95:81ms, iters:30282, tasks:5273}	range: decided by [tpch50.lineitem.l_orderkey], keep order:false	N/A	N/A
20:55:55 [2021-05-27T20:55:55.981Z]       │ └─IndexLookUp_80(Probe)	4.05	17316484	root		time:1m55.4s, loops:17129, index_task: {total_time: 1m3.6s, fetch_handle: 54.9s, build: 2.85ms, wait: 8.67s}, table_task: {total_time: 8m18.2s, num: 1458, concurrency: 760}		18.9 KB	N/A
20:55:55 [2021-05-27T20:55:55.981Z]       │   ├─IndexRangeScan_78(Build)	4.05	17316484	cop[tikv]	table:l2, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:52.7s, loops:18621, cop_task: {num: 3018, max: 683.6ms, min: 682.9µs, avg: 182.5ms, p95: 357.4ms, max_proc_keys: 15894, p95_proc_keys: 8742, tot_proc: 6m45.6s, tot_wait: 1m59.5s, rpc_num: 3018, rpc_time: 9m10.5s, copr_cache: disabled}, tikv_task:{proc max:201ms, min:0s, p80:94ms, p95:109ms, iters:30247, tasks:3018}, scan_detail: {total_process_keys: 17316484, total_keys: 20812591, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17316484, block: {cache_hit_count: 24259994, 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:55:55 [2021-05-27T20:55:55.981Z]       │   └─TableRowIDScan_79(Probe)	4.05	17316484	cop[tikv]	table:l2	time:6m5.5s, loops:21041, cop_task: {num: 7758, max: 609.9ms, min: 466.6µs, avg: 171.2ms, p95: 340.7ms, max_proc_keys: 10575, p95_proc_keys: 4882, tot_proc: 15m55.1s, tot_wait: 5m16.7s, rpc_num: 7758, rpc_time: 22m7.9s, copr_cache: disabled}, tikv_task:{proc max:254ms, min:0s, p80:102ms, p95:138ms, iters:49767, tasks:7758}, scan_detail: {total_process_keys: 17316484, total_keys: 18290791, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5633117, block: {cache_hit_count: 99017725, read_count: 1105, read_byte: 382.8 MB}}}	keep order:false	N/A	N/A
20:55:55 [2021-05-27T20:55:55.981Z]       └─IndexLookUp_39(Probe)	4.05	12022853	root		time:1m49.8s, loops:11950, index_task: {total_time: 58.4s, fetch_handle: 48.9s, build: 3.86ms, wait: 9.54s}, table_task: {total_time: 7m52.8s, num: 1411, concurrency: 735}		275.0 KB	N/A
20:55:55 [2021-05-27T20:55:55.981Z]         ├─IndexRangeScan_36(Build)	5.06	17183447	cop[tikv]	table:l3, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:46.5s, loops:18372, cop_task: {num: 2816, max: 675ms, min: 1.17ms, avg: 165.5ms, p95: 345.5ms, max_proc_keys: 17823, p95_proc_keys: 13632, tot_proc: 5m38.5s, tot_wait: 1m43.8s, rpc_num: 2816, rpc_time: 7m45.8s, copr_cache: disabled}, tikv_task:{proc max:179ms, min:0s, p80:76ms, p95:117ms, iters:29261, tasks:2816}, scan_detail: {total_process_keys: 17183447, total_keys: 20546483, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17183447, block: {cache_hit_count: 23554058, read_count: 0, read_byte: 0 Bytes}}}	range: decided by [eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey)], keep order:false	N/A	N/A
20:55:55 [2021-05-27T20:55:55.981Z]         └─Selection_38(Probe)	4.05	12022853	cop[tikv]		time:5m59.4s, loops:13764, cop_task: {num: 10151, max: 607.5ms, min: 461.6µs, avg: 166.9ms, p95: 333.7ms, max_proc_keys: 7845, p95_proc_keys: 4015, tot_proc: 19m36.3s, tot_wait: 7m22.9s, rpc_num: 10151, rpc_time: 28m13.5s, copr_cache: disabled}, tikv_task:{proc max:215ms, min:0s, p80:76ms, p95:115ms, iters:60350, tasks:10151}, scan_detail: {total_process_keys: 17183447, total_keys: 18130853, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5531874, block: {cache_hit_count: 98290351, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:55:55 [2021-05-27T20:55:55.981Z]           └─TableRowIDScan_37	5.06	17183447	cop[tikv]	table:l3	tikv_task:{proc max:214ms, min:0s, p80:75ms, p95:114ms, iters:60350, tasks:10151}	keep order:false	N/A	N/A
20:55:55 [2021-05-27T20:55:55.981Z] + sync
20:55:55 [2021-05-27T20:55:55.981Z] + /usr/bin/echo 3
20:57:17 [2021-05-27T20:57:17.432Z] 
20:57:17 [2021-05-27T20:57:17.432Z] queries/21.sql
20:57:17 [2021-05-27T20:57:17.432Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:57:17 [2021-05-27T20:57:17.432Z] Projection_26	100.00	100	root		time:1m19.6s, loops:2, Concurrency:OFF	tpch50.supplier.s_name, Column#72	4.37 KB	N/A
20:57:17 [2021-05-27T20:57:17.432Z] └─TopN_29	100.00	100	root		time:1m19.6s, loops:2	Column#72:desc, tpch50.supplier.s_name, offset:0, count:100	58.3 KB	N/A
20:57:17 [2021-05-27T20:57:17.432Z]   └─HashAgg_34	12800.00	20057	root		time:1m19.6s, loops:21, partial_worker:{wall_time:1m19.575307024s, concurrency:5, task_num:198, tot_wait:6m37.598681263s, tot_exec:261.973399ms, tot_time:6m37.874629038s, max:1m19.575272622s, p95:1m19.575272622s}, final_worker:{wall_time:1m19.586706196s, concurrency:5, task_num:25, tot_wait:6m37.872647541s, tot_exec:60.46375ms, tot_time:6m37.933123881s, max:1m19.586670894s, p95:1m19.586670894s}	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:17 [2021-05-27T20:57:17.432Z]     └─IndexHashJoin_42	7828961.66	198698	root		time:1m19.6s, loops:199, inner:{total:2m17.8s, concurrency:5, task:147, construct:6.14s, fetch:1m55s, build:1.2s, join:16.6s}	anti semi join, inner:IndexLookUp_39, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey)	641.0 MB	N/A
20:57:17 [2021-05-27T20:57:17.432Z]       ├─IndexHashJoin_83(Build)	9786202.08	3542799	root		time:1m19s, loops:3463, inner:{total:2m26.7s, concurrency:5, task:152, construct:7.62s, fetch:2m1.5s, build:1.35s, 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:17 [2021-05-27T20:57:17.432Z]       │ ├─IndexJoin_99(Build)	12232752.60	3675878	root		time:1m18.5s, loops:3595, inner:{total:2m4.6s, concurrency:5, task:305, construct:15.7s, fetch:1m47.1s, build:1.8s}, probe:5.15s	inner join, inner:TableReader_95, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.orders.o_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.orders.o_orderkey)	581.9 MB	N/A
20:57:17 [2021-05-27T20:57:17.432Z]       │ │ ├─HashJoin_107(Build)	12232752.60	7609895	root		time:1m18s, loops:7436, build_hash_table:{total:1.11s, fetch:1.1s, build:6.2ms}, probe:{concurrency:5, total:6m32.4s, max:1m18.5s, probe:1m2.6s, fetch:5m29.8s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.lineitem.l_suppkey)]	722.8 KB	0 Bytes
20:57:17 [2021-05-27T20:57:17.432Z]       │ │ │ ├─HashJoin_120(Build)	20000.00	20058	root		time:1.1s, loops:22, build_hash_table:{total:131.5µs, fetch:126.2µs, build:5.31µs}, probe:{concurrency:5, total:5.52s, max:1.1s, probe:70.6ms, fetch:5.45s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:57:17 [2021-05-27T20:57:17.432Z]       │ │ │ │ ├─TableReader_125(Build)	1.00	1	root		time:38.6µs, loops:2, cop_task: {num: 1, max: 936.8µs, proc_keys: 25, rpc_num: 1, rpc_time: 913µs, copr_cache: disabled}	data:Selection_124	234 Bytes	N/A
20:57:17 [2021-05-27T20:57:17.432Z]       │ │ │ │ │ └─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:57:17 [2021-05-27T20:57:17.432Z]       │ │ │ │ │   └─TableFullScan_123	25.00	25	cop[tikv]	table:nation	tikv_task:{time:0s, loops:1}	keep order:false	N/A	N/A
20:57:17 [2021-05-27T20:57:17.432Z]       │ │ │ │ └─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.05s, rpc_num: 1, rpc_time: 1.09s, copr_cache: disabled}	data:TableFullScan_121	20.0 MB	N/A
20:57:17 [2021-05-27T20:57:17.432Z]       │ │ │ │   └─TableFullScan_121	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:979ms, loops:493}, scan_detail: {total_process_keys: 500000, total_keys: 500001, rocksdb: {delete_skipped_count: 0, key_skipped_count: 999999, block: {cache_hit_count: 14, read_count: 1678, read_byte: 104.5 MB}}}	keep order:false	N/A	N/A
20:57:17 [2021-05-27T20:57:17.432Z]       │ │ │ └─TableReader_128(Probe)	240004648.80	189670348	root		time:1m5.4s, loops:184598, cop_task: {num: 761, max: 3.21s, min: 350ms, avg: 1.51s, p95: 1.98s, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 17m50.6s, tot_wait: 1m0.5s, rpc_num: 761, rpc_time: 19m5.5s, copr_cache: disabled}	data:Selection_127	109.4 MB	N/A
20:57:17 [2021-05-27T20:57:17.432Z]       │ │ │   └─Selection_127	240004648.80	189670348	cop[tikv]		tikv_task:{proc max:1.32s, min:335ms, 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: 10457, read_count: 1114191, read_byte: 23.6 GB}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:57:17 [2021-05-27T20:57:17.432Z]       │ │ │     └─TableFullScan_126	300005811.00	300005811	cop[tikv]	table:l1	tikv_task:{proc max:1.25s, min:320ms, p80:1.07s, p95:1.11s, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:57:17 [2021-05-27T20:57:17.432Z]       │ │ └─TableReader_95(Probe)	0.49	3496173	root		time:1m38.3s, loops:3875, cop_task: {num: 5245, max: 556.9ms, min: 1.2ms, avg: 177.5ms, p95: 341.2ms, max_proc_keys: 3768, p95_proc_keys: 1958, tot_proc: 11m1.8s, tot_wait: 3m40.1s, rpc_num: 5245, rpc_time: 15m30.7s, copr_cache: disabled}	data:Selection_94	N/A	N/A
20:57:17 [2021-05-27T20:57:17.432Z]       │ │   └─Selection_94	0.49	3496173	cop[tikv]		tikv_task:{proc max:144ms, min:0s, p80:68ms, p95:81ms, iters:30166, tasks:5245}, scan_detail: {total_process_keys: 7236276, total_keys: 7795468, rocksdb: {delete_skipped_count: 0, key_skipped_count: 1778246, block: {cache_hit_count: 54006588, read_count: 218226, read_byte: 4.21 GB}}}	eq(tpch50.orders.o_orderstatus, "F")	N/A	N/A
20:57:17 [2021-05-27T20:57:17.432Z]       │ │     └─TableRangeScan_93	1.00	7236276	cop[tikv]	table:orders	tikv_task:{proc max:143ms, min:0s, p80:68ms, p95:81ms, iters:30166, tasks:5245}	range: decided by [tpch50.lineitem.l_orderkey], keep order:false	N/A	N/A
20:57:17 [2021-05-27T20:57:17.432Z]       │ └─IndexLookUp_80(Probe)	4.05	17316513	root		time:1m56.3s, loops:17130, index_task: {total_time: 1m3.4s, fetch_handle: 54.5s, build: 3.07ms, wait: 8.9s}, table_task: {total_time: 8m22.2s, num: 1458, concurrency: 760}		18.9 KB	N/A
20:57:17 [2021-05-27T20:57:17.432Z]       │   ├─IndexRangeScan_78(Build)	4.05	17316513	cop[tikv]	table:l2, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:52.2s, loops:18640, cop_task: {num: 2998, max: 751.4ms, min: 533.9µs, avg: 181.3ms, p95: 370.4ms, max_proc_keys: 13370, p95_proc_keys: 8769, tot_proc: 6m44.9s, tot_wait: 1m53.7s, rpc_num: 2998, rpc_time: 9m3.4s, copr_cache: disabled}, tikv_task:{proc max:165ms, min:0s, p80:95ms, p95:109ms, iters:30168, tasks:2998}, scan_detail: {total_process_keys: 17316513, total_keys: 20812626, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17316513, block: {cache_hit_count: 24260034, read_count: 225685, read_byte: 2.00 GB}}}	range: decided by [eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey)], keep order:false	N/A	N/A
20:57:17 [2021-05-27T20:57:17.432Z]       │   └─TableRowIDScan_79(Probe)	4.05	17316513	cop[tikv]	table:l2	time:6m13.5s, loops:21032, cop_task: {num: 7836, max: 601ms, min: 709µs, avg: 176.9ms, p95: 358.8ms, max_proc_keys: 12685, p95_proc_keys: 4864, tot_proc: 16m29.4s, tot_wait: 5m39s, rpc_num: 7836, rpc_time: 23m5.9s, copr_cache: disabled}, tikv_task:{proc max:308ms, min:0s, p80:102ms, p95:139ms, iters:50022, tasks:7836}, scan_detail: {total_process_keys: 17316513, total_keys: 18290245, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5631816, block: {cache_hit_count: 99016105, read_count: 1109, read_byte: 389.3 MB}}}	keep order:false	N/A	N/A
20:57:17 [2021-05-27T20:57:17.432Z]       └─IndexLookUp_39(Probe)	4.05	12022855	root		time:1m50.2s, loops:11949, index_task: {total_time: 59.9s, fetch_handle: 49.8s, build: 3.39ms, wait: 10.1s}, table_task: {total_time: 7m55.9s, num: 1410, concurrency: 735}		218.5 KB	N/A
20:57:17 [2021-05-27T20:57:17.432Z]         ├─IndexRangeScan_36(Build)	5.06	17183455	cop[tikv]	table:l3, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:47.4s, loops:18341, cop_task: {num: 2771, max: 725ms, min: 587µs, avg: 166.1ms, p95: 357ms, max_proc_keys: 20948, p95_proc_keys: 13828, tot_proc: 5m42.6s, tot_wait: 1m34.9s, rpc_num: 2771, rpc_time: 7m40.3s, copr_cache: disabled}, tikv_task:{proc max:191ms, min:0s, p80:76ms, p95:120ms, iters:29020, tasks:2771}, scan_detail: {total_process_keys: 17183455, total_keys: 20546493, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17183455, block: {cache_hit_count: 23554074, 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:17 [2021-05-27T20:57:17.432Z]         └─Selection_38(Probe)	4.05	12022855	cop[tikv]		time:6m6.3s, loops:13790, cop_task: {num: 10225, max: 583.8ms, min: 710.7µs, avg: 171.1ms, p95: 347.6ms, max_proc_keys: 6829, p95_proc_keys: 3976, tot_proc: 20m24.3s, tot_wait: 7m27.8s, rpc_num: 10225, rpc_time: 29m9.5s, copr_cache: disabled}, tikv_task:{proc max:217ms, min:0s, p80:75ms, p95:114ms, iters:60498, tasks:10225}, scan_detail: {total_process_keys: 17183455, total_keys: 18129318, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5527555, block: {cache_hit_count: 98288164, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:57:17 [2021-05-27T20:57:17.432Z]           └─TableRowIDScan_37	5.06	17183455	cop[tikv]	table:l3	tikv_task:{proc max:215ms, min:0s, p80:75ms, p95:113ms, iters:60498, tasks:10225}	keep order:false	N/A	N/A
20:57:17 [2021-05-27T20:57:17.432Z] + tiup cluster stop benchbot -y
20:57:17 [2021-05-27T20:57:17.432Z] Starting component `cluster`: /home/tidb/.tiup/components/cluster/v1.4.4/tiup-cluster stop benchbot -y
20:57:21 [2021-05-27T20:57:21.602Z] + rm -rf '/data1/tidb-deploy/*/log/*'
20:57:21 [2021-05-27T20:57:21.602Z] + rm -rf /data1/jenkins/deploy/data/tikv-20160
20:57:25 [2021-05-27T20:57:25.768Z] + rm -rf /data1/jenkins/deploy/data/pd-2379
20:57:25 [2021-05-27T20:57:25.768Z] + rm -rf /data1/jenkins/restore_data/tpch50/data/last_tikv.toml
20:57:25 [2021-05-27T20:57:25.768Z] + cp -R /data1/jenkins/restore_data/tpch50/data /data1/jenkins/deploy/data/tikv-20160
20:59:17 [2021-05-27T20:59:17.150Z] + cp -R /data1/jenkins/restore_data/tpch50/data.pd /data1/jenkins/deploy/data/pd-2379
20:59:17 [2021-05-27T20:59:17.150Z] + '[' -n '' ']'
20:59:17 [2021-05-27T20:59:17.150Z] + tiup cluster start benchbot --wait-timeout=300
20:59:17 [2021-05-27T20:59:17.150Z] Starting component `cluster`: /home/tidb/.tiup/components/cluster/v1.4.4/tiup-cluster start benchbot --wait-timeout=300
20:59:39 [2021-05-27T20:59:39.033Z] + sync
20:59:39 [2021-05-27T20:59:39.033Z] + /usr/bin/echo 3
21:00:17 [2021-05-27T21:00:17.697Z] + sync
21:00:17 [2021-05-27T21:00:17.697Z] + /usr/bin/echo 3
21:00:44 [2021-05-27T21:00:44.190Z] + sync
21:00:44 [2021-05-27T21:00:44.190Z] + /usr/bin/echo 3
21:01:16 [2021-05-27T21:01:16.217Z] 
21:01:16 [2021-05-27T21:01:16.217Z] queries/22.sql
21:01:16 [2021-05-27T21:01:16.217Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
21:01:16 [2021-05-27T21:01:16.217Z] Sort_39	1600000.00	4	root		time:26.6s, loops:2	Column#27	9.48 KB	0 Bytes
21:01:16 [2021-05-27T21:01:16.218Z] └─Projection_41	1600000.00	4	root		time:26.6s, loops:5, Concurrency:5	Column#27, Column#28, Column#29	23.7 KB	N/A
21:01:16 [2021-05-27T21:01:16.218Z]   └─HashAgg_42	1600000.00	4	root		time:26.6s, loops:5, partial_worker:{wall_time:26.628823474s, concurrency:5, task_num:180, tot_wait:2m13.094697889s, tot_exec:48.59405ms, tot_time:2m13.143402945s, max:26.62879742s, p95:26.62879742s}, final_worker:{wall_time:26.628856424s, concurrency:5, task_num:20, tot_wait:2m13.143865602s, tot_exec:178.98µs, tot_time:2m13.144053605s, max:26.628823409s, p95:26.628823409s}	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:16 [2021-05-27T21:01:16.218Z]     └─Projection_51	1600000.00	181704	root		time:26.6s, 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:16 [2021-05-27T21:01:16.218Z]       └─HashJoin_43	1600000.00	181704	root		time:26.6s, loops:181, build_hash_table:{total:25.3s, fetch:1.07s, build:24.2s}, probe:{concurrency:5, total:2m13.1s, max:26.6s, probe:5.43s, fetch:2m7.7s}	anti semi join, equal:[eq(tpch50.customer.c_custkey, tpch50.orders.o_custkey)]	590.2 MB	0 Bytes
21:01:16 [2021-05-27T21:01:16.218Z]         ├─TableReader_49(Build)	75000000.00	75000000	root		time:1.09s, loops:73364, cop_task: {num: 153, max: 959.8ms, min: 289ms, avg: 614.9ms, p95: 880.9ms, max_proc_keys: 723875, p95_proc_keys: 553332, tot_proc: 1m33.2s, tot_wait: 45ms, rpc_num: 153, rpc_time: 1m34.1s, copr_cache: disabled}	data:TableFullScan_48	56.0 MB	N/A
21:01:16 [2021-05-27T21:01:16.218Z]         │ └─TableFullScan_48	75000000.00	75000000	cop[tikv]	table:orders	tikv_task:{proc max:928ms, min:270ms, p80:623ms, p95:848ms, 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: 3021, read_count: 219932, read_byte: 4.30 GB}}}	keep order:false	N/A	N/A
21:01:16 [2021-05-27T21:01:16.218Z]         └─Selection_47(Probe)	2000000.00	545246	root		time:1.33s, loops:534	in(substring(tpch50.customer.c_phone, 1, 2), "20", "40", "22", "30", "39", "42", "21")	94.6 KB	N/A
21:01:16 [2021-05-27T21:01:16.218Z]           └─TableReader_46	2000000.00	3407619	root		time:503.1ms, loops:3319, cop_task: {num: 18, max: 1.06s, min: 436.2ms, avg: 758.9ms, p95: 1.06s, max_proc_keys: 582617, p95_proc_keys: 582617, tot_proc: 13.2s, tot_wait: 6ms, rpc_num: 18, rpc_time: 13.7s, copr_cache: disabled}	data:Selection_45	192.5 MB	N/A
21:01:16 [2021-05-27T21:01:16.218Z]             └─Selection_45	2000000.00	3407619	cop[tikv]		tikv_task:{proc max:983ms, min:405ms, p80:837ms, p95:983ms, 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:16 [2021-05-27T21:01:16.218Z]               └─TableFullScan_44	7500000.00	7500000	cop[tikv]	table:customer	tikv_task:{proc max:903ms, min:373ms, p80:770ms, p95:903ms, iters:7404, tasks:18}	keep order:false	N/A	N/A
21:01:16 [2021-05-27T21:01:16.218Z] 
21:01:16 [2021-05-27T21:01:16.218Z] queries/22.sql
21:01:16 [2021-05-27T21:01:16.218Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
21:01:16 [2021-05-27T21:01:16.218Z] Sort_39	2186432.06	4	root		time:26.4s, loops:2	Column#27	9.48 KB	0 Bytes
21:01:16 [2021-05-27T21:01:16.218Z] └─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:16 [2021-05-27T21:01:16.218Z]   └─HashAgg_42	2186432.06	4	root		time:26.4s, loops:5, partial_worker:{wall_time:26.449484813s, concurrency:5, task_num:181, tot_wait:2m12.193481977s, tot_exec:53.201181ms, tot_time:2m12.246786936s, max:26.449399648s, p95:26.449399648s}, final_worker:{wall_time:26.449529254s, concurrency:5, task_num:20, tot_wait:2m12.246787769s, tot_exec:306.292µs, tot_time:2m12.247102051s, max:26.44944544s, p95:26.44944544s}	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:16 [2021-05-27T21:01:16.218Z]     └─Projection_51	2186432.06	181704	root		time:26.4s, loops:182, Concurrency:5	tpch50.customer.c_acctbal, substring(tpch50.customer.c_phone, 1, 2)->Column#32, substring(tpch50.customer.c_phone, 1, 2)->Column#33	703.6 KB	N/A
21:01:16 [2021-05-27T21:01:16.218Z]       └─HashJoin_43	2186432.06	181704	root		time:26.4s, loops:182, build_hash_table:{total:25.1s, fetch:925.7ms, build:24.1s}, probe:{concurrency:5, total:2m12.2s, max:26.4s, probe:5.67s, fetch:2m6.6s}	anti semi join, equal:[eq(tpch50.customer.c_custkey, tpch50.orders.o_custkey)]	590.2 MB	0 Bytes
21:01:16 [2021-05-27T21:01:16.218Z]         ├─TableReader_49(Build)	75000000.00	75000000	root		time:961.7ms, loops:73364, cop_task: {num: 153, max: 1.24s, min: 285.3ms, avg: 558.1ms, p95: 941ms, max_proc_keys: 723875, p95_proc_keys: 553332, tot_proc: 1m24.7s, tot_wait: 30ms, rpc_num: 153, rpc_time: 1m25.4s, copr_cache: disabled}	data:TableFullScan_48	57.8 MB	N/A
21:01:16 [2021-05-27T21:01:16.218Z]         │ └─TableFullScan_48	75000000.00	75000000	cop[tikv]	table:orders	tikv_task:{proc max:1.21s, min:275ms, p80:596ms, p95:894ms, 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:16 [2021-05-27T21:01:16.218Z]         └─Selection_47(Probe)	2733040.07	545246	root		time:1.51s, loops:534	in(substring(tpch50.customer.c_phone, 1, 2), "20", "40", "22", "30", "39", "42", "21")	94.6 KB	N/A
21:01:16 [2021-05-27T21:01:16.218Z]           └─TableReader_46	2733040.07	3407619	root		time:628.9ms, loops:3319, cop_task: {num: 18, max: 1.3s, min: 525.3ms, avg: 913.5ms, p95: 1.3s, max_proc_keys: 582617, p95_proc_keys: 582617, tot_proc: 16s, tot_wait: 6ms, rpc_num: 18, rpc_time: 16.4s, copr_cache: disabled}	data:Selection_45	192.5 MB	N/A
21:01:16 [2021-05-27T21:01:16.218Z]             └─Selection_45	2733040.07	3407619	cop[tikv]		tikv_task:{proc max:1.24s, min:488ms, p80:1.05s, p95:1.24s, 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:16 [2021-05-27T21:01:16.218Z]               └─TableFullScan_44	7500000.00	7500000	cop[tikv]	table:customer	tikv_task:{proc max:1.15s, min:444ms, p80:975ms, p95:1.15s, iters:7404, tasks:18}	keep order:false	N/A	N/A
21:01:16 [2021-05-27T21:01:16.218Z] 
21:01:16 [2021-05-27T21:01:16.218Z] queries/22.sql
21:01:16 [2021-05-27T21:01:16.218Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
21:01:16 [2021-05-27T21:01:16.218Z] Sort_39	2186432.06	4	root		time:26s, loops:2	Column#27	9.48 KB	0 Bytes
21:01:16 [2021-05-27T21:01:16.218Z] └─Projection_41	2186432.06	4	root		time:26s, loops:5, Concurrency:5	Column#27, Column#28, Column#29	23.7 KB	N/A
21:01:16 [2021-05-27T21:01:16.218Z]   └─HashAgg_42	2186432.06	4	root		time:26s, loops:5, partial_worker:{wall_time:26.040197412s, concurrency:5, task_num:179, tot_wait:2m10.150600573s, tot_exec:49.108915ms, tot_time:2m10.199831316s, max:26.040156566s, p95:26.040156566s}, final_worker:{wall_time:26.040215177s, concurrency:5, task_num:20, tot_wait:2m10.200744259s, tot_exec:170.43µs, tot_time:2m10.200922944s, max:26.040190626s, p95:26.040190626s}	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:16 [2021-05-27T21:01:16.218Z]     └─Projection_51	2186432.06	181704	root		time:26s, 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:01:16 [2021-05-27T21:01:16.218Z]       └─HashJoin_43	2186432.06	181704	root		time:26s, loops:180, build_hash_table:{total:24.6s, fetch:892.8ms, build:23.7s}, probe:{concurrency:5, total:2m10.2s, max:26s, probe:5.8s, fetch:2m4.4s}	anti semi join, equal:[eq(tpch50.customer.c_custkey, tpch50.orders.o_custkey)]	590.2 MB	0 Bytes
21:01:16 [2021-05-27T21:01:16.218Z]         ├─TableReader_49(Build)	75000000.00	75000000	root		time:918.4ms, loops:73364, cop_task: {num: 153, max: 941.7ms, min: 246.7ms, avg: 517.9ms, p95: 883.4ms, max_proc_keys: 723875, p95_proc_keys: 553332, tot_proc: 1m18.5s, tot_wait: 39ms, rpc_num: 153, rpc_time: 1m19.2s, copr_cache: disabled}	data:TableFullScan_48	57.8 MB	N/A
21:01:16 [2021-05-27T21:01:16.218Z]         │ └─TableFullScan_48	75000000.00	75000000	cop[tikv]	table:orders	tikv_task:{proc max:914ms, min:238ms, p80:525ms, p95:859ms, 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:16 [2021-05-27T21:01:16.218Z]         └─Selection_47(Probe)	2733040.07	545246	root		time:1.45s, loops:534	in(substring(tpch50.customer.c_phone, 1, 2), "20", "40", "22", "30", "39", "42", "21")	94.6 KB	N/A
21:01:16 [2021-05-27T21:01:16.218Z]           └─TableReader_46	2733040.07	3407619	root		time:599.7ms, loops:3319, cop_task: {num: 18, max: 1.2s, min: 474.6ms, avg: 824.2ms, p95: 1.2s, max_proc_keys: 582617, p95_proc_keys: 582617, tot_proc: 14.4s, tot_wait: 1ms, rpc_num: 18, rpc_time: 14.8s, copr_cache: disabled}	data:Selection_45	192.5 MB	N/A
21:01:16 [2021-05-27T21:01:16.218Z]             └─Selection_45	2733040.07	3407619	cop[tikv]		tikv_task:{proc max:1.14s, min:442ms, p80:911ms, p95:1.14s, iters:7404, tasks:18}, scan_detail: {total_process_keys: 7500000, total_keys: 7500018, rocksdb: {delete_skipped_count: 0, key_skipped_count: 14999982, block: {cache_hit_count: 28451, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.customer.c_acctbal, 5000.602894)	N/A	N/A
21:01:16 [2021-05-27T21:01:16.218Z]               └─TableFullScan_44	7500000.00	7500000	cop[tikv]	table:customer	tikv_task:{proc max:1.06s, min:406ms, p80:842ms, p95:1.06s, iters:7404, tasks:18}	keep order:false	N/A	N/A
21:01:16 [2021-05-27T21:01:16.218Z] + sync
21:01:16 [2021-05-27T21:01:16.218Z] + /usr/bin/echo 3
21:01:48 [2021-05-27T21:01:48.241Z] + sync
21:01:48 [2021-05-27T21:01:48.241Z] + /usr/bin/echo 3
21:02:14 [2021-05-27T21:02:14.906Z] + sync
21:02:14 [2021-05-27T21:02:14.906Z] + /usr/bin/echo 3
21:02:46 [2021-05-27T21:02:46.935Z] 
21:02:46 [2021-05-27T21:02:46.935Z] queries/22.sql
21:02:46 [2021-05-27T21:02:46.935Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
21:02:46 [2021-05-27T21:02:46.935Z] Sort_39	2186432.06	4	root		time:26.6s, loops:2	Column#27	9.48 KB	0 Bytes
21:02:46 [2021-05-27T21:02:46.935Z] └─Projection_41	2186432.06	4	root		time:26.6s, loops:5, Concurrency:5	Column#27, Column#28, Column#29	23.7 KB	N/A
21:02:46 [2021-05-27T21:02:46.935Z]   └─HashAgg_42	2186432.06	4	root		time:26.6s, loops:5, partial_worker:{wall_time:26.575011735s, concurrency:5, task_num:180, tot_wait:2m12.825805095s, tot_exec:48.43172ms, tot_time:2m12.87434513s, max:26.574967239s, p95:26.574967239s}, final_worker:{wall_time:26.575015691s, concurrency:5, task_num:20, tot_wait:2m12.87473748s, tot_exec:227.884µs, tot_time:2m12.874973432s, max:26.575002767s, p95:26.575002767s}	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:46 [2021-05-27T21:02:46.935Z]     └─Projection_51	2186432.06	181704	root		time:26.6s, 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:46 [2021-05-27T21:02:46.935Z]       └─HashJoin_43	2186432.06	181704	root		time:26.6s, loops:181, build_hash_table:{total:25.2s, fetch:997.1ms, build:24.2s}, probe:{concurrency:5, total:2m12.9s, max:26.6s, probe:5.51s, fetch:2m7.3s}	anti semi join, equal:[eq(tpch50.customer.c_custkey, tpch50.orders.o_custkey)]	590.2 MB	0 Bytes
21:02:46 [2021-05-27T21:02:46.935Z]         ├─TableReader_49(Build)	75000000.00	75000000	root		time:1.04s, loops:73364, cop_task: {num: 153, max: 948.3ms, min: 211.6ms, avg: 525.7ms, p95: 855.9ms, max_proc_keys: 723875, p95_proc_keys: 553332, tot_proc: 1m19.7s, tot_wait: 23ms, rpc_num: 153, rpc_time: 1m20.4s, copr_cache: disabled}	data:TableFullScan_48	57.8 MB	N/A
21:02:46 [2021-05-27T21:02:46.935Z]         │ └─TableFullScan_48	75000000.00	75000000	cop[tikv]	table:orders	tikv_task:{proc max:916ms, min:204ms, p80:526ms, p95:832ms, 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:46 [2021-05-27T21:02:46.935Z]         └─Selection_47(Probe)	2733040.07	545246	root		time:1.54s, loops:534	in(substring(tpch50.customer.c_phone, 1, 2), "20", "40", "22", "30", "39", "42", "21")	94.6 KB	N/A
21:02:46 [2021-05-27T21:02:46.935Z]           └─TableReader_46	2733040.07	3407619	root		time:703.4ms, loops:3319, cop_task: {num: 18, max: 1.21s, min: 531.7ms, avg: 903.8ms, p95: 1.21s, max_proc_keys: 582617, p95_proc_keys: 582617, tot_proc: 15.8s, tot_wait: 6ms, rpc_num: 18, rpc_time: 16.3s, copr_cache: disabled}	data:Selection_45	192.5 MB	N/A
21:02:46 [2021-05-27T21:02:46.935Z]             └─Selection_45	2733040.07	3407619	cop[tikv]		tikv_task:{proc max:1.13s, min:482ms, p80:985ms, p95:1.13s, iters:7404, tasks:18}, scan_detail: {total_process_keys: 7500000, total_keys: 7500018, rocksdb: {delete_skipped_count: 0, key_skipped_count: 14999982, block: {cache_hit_count: 28451, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.customer.c_acctbal, 5000.602894)	N/A	N/A
21:02:46 [2021-05-27T21:02:46.935Z]               └─TableFullScan_44	7500000.00	7500000	cop[tikv]	table:customer	tikv_task:{proc max:1.03s, min:438ms, p80:913ms, p95:1.03s, iters:7404, tasks:18}	keep order:false	N/A	N/A
21:02:46 [2021-05-27T21:02:46.935Z] 
21:02:46 [2021-05-27T21:02:46.935Z] queries/22.sql
21:02:46 [2021-05-27T21:02:46.935Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
21:02:46 [2021-05-27T21:02:46.935Z] Sort_39	2186432.06	4	root		time:25.8s, loops:2	Column#27	9.48 KB	0 Bytes
21:02:46 [2021-05-27T21:02:46.935Z] └─Projection_41	2186432.06	4	root		time:25.8s, loops:5, Concurrency:5	Column#27, Column#28, Column#29	23.7 KB	N/A
21:02:46 [2021-05-27T21:02:46.935Z]   └─HashAgg_42	2186432.06	4	root		time:25.8s, loops:5, partial_worker:{wall_time:25.785973454s, concurrency:5, task_num:180, tot_wait:2m8.858530235s, tot_exec:70.528721ms, tot_time:2m8.929172731s, max:25.78591091s, p95:25.78591091s}, final_worker:{wall_time:25.78598562s, concurrency:5, task_num:20, tot_wait:2m8.92940681s, tot_exec:232.597µs, tot_time:2m8.929646551s, max:25.785941371s, p95:25.785941371s}	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:46 [2021-05-27T21:02:46.935Z]     └─Projection_51	2186432.06	181704	root		time:25.8s, loops:181, Concurrency:5	tpch50.customer.c_acctbal, substring(tpch50.customer.c_phone, 1, 2)->Column#32, substring(tpch50.customer.c_phone, 1, 2)->Column#33	703.6 KB	N/A
21:02:46 [2021-05-27T21:02:46.935Z]       └─HashJoin_43	2186432.06	181704	root		time:25.8s, loops:181, build_hash_table:{total:24.2s, fetch:890.1ms, build:23.3s}, probe:{concurrency:5, total:2m8.9s, max:25.8s, probe:6.31s, fetch:2m2.6s}	anti semi join, equal:[eq(tpch50.customer.c_custkey, tpch50.orders.o_custkey)]	590.2 MB	0 Bytes
21:02:46 [2021-05-27T21:02:46.936Z]         ├─TableReader_49(Build)	75000000.00	75000000	root		time:910.6ms, loops:73364, cop_task: {num: 153, max: 956.4ms, min: 230.1ms, avg: 521.2ms, p95: 814.4ms, max_proc_keys: 723875, p95_proc_keys: 553332, tot_proc: 1m19s, tot_wait: 31ms, rpc_num: 153, rpc_time: 1m19.7s, copr_cache: disabled}	data:TableFullScan_48	54.1 MB	N/A
21:02:46 [2021-05-27T21:02:46.936Z]         │ └─TableFullScan_48	75000000.00	75000000	cop[tikv]	table:orders	tikv_task:{proc max:926ms, min:220ms, p80:534ms, p95:789ms, iters:73975, tasks:153}, scan_detail: {total_process_keys: 75000000, total_keys: 75000153, rocksdb: {delete_skipped_count: 0, key_skipped_count: 149999847, block: {cache_hit_count: 220923, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
21:02:46 [2021-05-27T21:02:46.936Z]         └─Selection_47(Probe)	2733040.07	545246	root		time:1.58s, loops:534	in(substring(tpch50.customer.c_phone, 1, 2), "20", "40", "22", "30", "39", "42", "21")	94.6 KB	N/A
21:02:46 [2021-05-27T21:02:46.936Z]           └─TableReader_46	2733040.07	3407619	root		time:607.4ms, loops:3319, cop_task: {num: 18, max: 1.2s, min: 380.7ms, avg: 896ms, p95: 1.2s, max_proc_keys: 582617, p95_proc_keys: 582617, tot_proc: 15.7s, tot_wait: 1ms, rpc_num: 18, rpc_time: 16.1s, copr_cache: disabled}	data:Selection_45	192.5 MB	N/A
21:02:46 [2021-05-27T21:02:46.936Z]             └─Selection_45	2733040.07	3407619	cop[tikv]		tikv_task:{proc max:1.13s, min:355ms, p80:964ms, p95:1.13s, iters:7404, tasks:18}, scan_detail: {total_process_keys: 7500000, total_keys: 7500018, rocksdb: {delete_skipped_count: 0, key_skipped_count: 14999982, block: {cache_hit_count: 28451, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.customer.c_acctbal, 5000.602894)	N/A	N/A
21:02:46 [2021-05-27T21:02:46.936Z]               └─TableFullScan_44	7500000.00	7500000	cop[tikv]	table:customer	tikv_task:{proc max:1.03s, min:327ms, p80:889ms, p95:1.03s, iters:7404, tasks:18}	keep order:false	N/A	N/A
21:02:46 [2021-05-27T21:02:46.936Z] 
21:02:46 [2021-05-27T21:02:46.936Z] queries/22.sql
21:02:46 [2021-05-27T21:02:46.936Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
21:02:46 [2021-05-27T21:02:46.936Z] Sort_39	2186432.06	4	root		time:26.3s, loops:2	Column#27	9.48 KB	0 Bytes
21:02:46 [2021-05-27T21:02:46.936Z] └─Projection_41	2186432.06	4	root		time:26.3s, loops:5, Concurrency:5	Column#27, Column#28, Column#29	23.7 KB	N/A
21:02:46 [2021-05-27T21:02:46.936Z]   └─HashAgg_42	2186432.06	4	root		time:26.3s, loops:5, partial_worker:{wall_time:26.314078716s, concurrency:5, task_num:180, tot_wait:2m11.517485564s, tot_exec:51.445297ms, tot_time:2m11.569044109s, max:26.314050131s, p95:26.314050131s}, final_worker:{wall_time:26.314104624s, concurrency:5, task_num:20, tot_wait:2m11.569959212s, tot_exec:260.883µs, tot_time:2m11.570227889s, max:26.314079885s, p95:26.314079885s}	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:46 [2021-05-27T21:02:46.936Z]     └─Projection_51	2186432.06	181704	root		time:26.3s, loops:181, Concurrency:5	tpch50.customer.c_acctbal, substring(tpch50.customer.c_phone, 1, 2)->Column#32, substring(tpch50.customer.c_phone, 1, 2)->Column#33	703.6 KB	N/A
21:02:46 [2021-05-27T21:02:46.936Z]       └─HashJoin_43	2186432.06	181704	root		time:26.3s, loops:181, build_hash_table:{total:24.9s, fetch:962.7ms, build:23.9s}, probe:{concurrency:5, total:2m11.5s, max:26.3s, probe:5.83s, fetch:2m5.7s}	anti semi join, equal:[eq(tpch50.customer.c_custkey, tpch50.orders.o_custkey)]	590.2 MB	0 Bytes
21:02:46 [2021-05-27T21:02:46.936Z]         ├─TableReader_49(Build)	75000000.00	75000000	root		time:999.7ms, loops:73364, cop_task: {num: 153, max: 1.01s, min: 253.8ms, avg: 517.1ms, p95: 836.8ms, max_proc_keys: 723875, p95_proc_keys: 553332, tot_proc: 1m18.4s, tot_wait: 39ms, rpc_num: 153, rpc_time: 1m19.1s, copr_cache: disabled}	data:TableFullScan_48	57.8 MB	N/A
21:02:46 [2021-05-27T21:02:46.936Z]         │ └─TableFullScan_48	75000000.00	75000000	cop[tikv]	table:orders	tikv_task:{proc max:979ms, min:237ms, p80:526ms, p95:814ms, 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:46 [2021-05-27T21:02:46.936Z]         └─Selection_47(Probe)	2733040.07	545246	root		time:1.59s, loops:534	in(substring(tpch50.customer.c_phone, 1, 2), "20", "40", "22", "30", "39", "42", "21")	94.6 KB	N/A
21:02:46 [2021-05-27T21:02:46.936Z]           └─TableReader_46	2733040.07	3407619	root		time:683.8ms, loops:3319, cop_task: {num: 18, max: 1.14s, min: 511.5ms, avg: 847.9ms, p95: 1.14s, max_proc_keys: 582617, p95_proc_keys: 582617, tot_proc: 14.9s, tot_wait: 1ms, rpc_num: 18, rpc_time: 15.3s, copr_cache: disabled}	data:Selection_45	192.5 MB	N/A
21:02:46 [2021-05-27T21:02:46.936Z]             └─Selection_45	2733040.07	3407619	cop[tikv]		tikv_task:{proc max:1.06s, min:466ms, p80:943ms, p95:1.06s, iters:7404, tasks:18}, scan_detail: {total_process_keys: 7500000, total_keys: 7500018, rocksdb: {delete_skipped_count: 0, key_skipped_count: 14999982, block: {cache_hit_count: 28451, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.customer.c_acctbal, 5000.602894)	N/A	N/A
21:02:46 [2021-05-27T21:02:46.936Z]               └─TableFullScan_44	7500000.00	7500000	cop[tikv]	table:customer	tikv_task:{proc max:965ms, min:424ms, p80:865ms, p95:965ms, iters:7404, tasks:18}	keep order:false	N/A	N/A
21:02:46 [2021-05-27T21:02:46.936Z] + sync
21:02:46 [2021-05-27T21:02:46.936Z] + /usr/bin/echo 3
21:03:13 [2021-05-27T21:03:13.432Z] 
21:03:13 [2021-05-27T21:03:13.432Z] queries/22.sql
21:03:13 [2021-05-27T21:03:13.432Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
21:03:13 [2021-05-27T21:03:13.432Z] Sort_39	2186432.06	4	root		time:25.3s, loops:2	Column#27	9.48 KB	0 Bytes
21:03:13 [2021-05-27T21:03:13.432Z] └─Projection_41	2186432.06	4	root		time:25.3s, loops:5, Concurrency:5	Column#27, Column#28, Column#29	23.7 KB	N/A
21:03:13 [2021-05-27T21:03:13.432Z]   └─HashAgg_42	2186432.06	4	root		time:25.3s, loops:5, partial_worker:{wall_time:25.283564037s, concurrency:5, task_num:181, tot_wait:2m6.35903254s, tot_exec:57.373814ms, tot_time:2m6.416599301s, max:25.283423707s, p95:25.283423707s}, final_worker:{wall_time:25.283574231s, concurrency:5, task_num:20, tot_wait:2m6.416706959s, tot_exec:544.328µs, tot_time:2m6.417259081s, max:25.283459003s, p95:25.283459003s}	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:13 [2021-05-27T21:03:13.432Z]     └─Projection_51	2186432.06	181704	root		time:25.3s, loops:182, Concurrency:5	tpch50.customer.c_acctbal, substring(tpch50.customer.c_phone, 1, 2)->Column#32, substring(tpch50.customer.c_phone, 1, 2)->Column#33	703.6 KB	N/A
21:03:13 [2021-05-27T21:03:13.432Z]       └─HashJoin_43	2186432.06	181704	root		time:25.3s, loops:182, build_hash_table:{total:23.7s, fetch:926.7ms, build:22.8s}, probe:{concurrency:5, total:2m6.4s, max:25.3s, probe:6.03s, fetch:2m0.4s}	anti semi join, equal:[eq(tpch50.customer.c_custkey, tpch50.orders.o_custkey)]	590.2 MB	0 Bytes
21:03:13 [2021-05-27T21:03:13.432Z]         ├─TableReader_49(Build)	75000000.00	75000000	root		time:906.9ms, loops:73364, cop_task: {num: 153, max: 999.7ms, min: 242.4ms, avg: 516.7ms, p95: 855.7ms, max_proc_keys: 723875, p95_proc_keys: 553332, tot_proc: 1m18s, tot_wait: 50ms, rpc_num: 153, rpc_time: 1m19s, copr_cache: disabled}	data:TableFullScan_48	57.8 MB	N/A
21:03:13 [2021-05-27T21:03:13.432Z]         │ └─TableFullScan_48	75000000.00	75000000	cop[tikv]	table:orders	tikv_task:{proc max:960ms, min:233ms, p80:521ms, p95:818ms, 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:13 [2021-05-27T21:03:13.432Z]         └─Selection_47(Probe)	2733040.07	545246	root		time:1.68s, loops:534	in(substring(tpch50.customer.c_phone, 1, 2), "20", "40", "22", "30", "39", "42", "21")	94.6 KB	N/A
21:03:13 [2021-05-27T21:03:13.432Z]           └─TableReader_46	2733040.07	3407619	root		time:688.6ms, loops:3319, cop_task: {num: 18, max: 1.22s, min: 484.2ms, avg: 884.8ms, p95: 1.22s, max_proc_keys: 582617, p95_proc_keys: 582617, tot_proc: 15.4s, tot_wait: 3ms, rpc_num: 18, rpc_time: 15.9s, copr_cache: disabled}	data:Selection_45	192.5 MB	N/A
21:03:13 [2021-05-27T21:03:13.432Z]             └─Selection_45	2733040.07	3407619	cop[tikv]		tikv_task:{proc max:1.16s, min:463ms, p80:926ms, p95:1.16s, iters:7404, tasks:18}, scan_detail: {total_process_keys: 7500000, total_keys: 7500018, rocksdb: {delete_skipped_count: 0, key_skipped_count: 14999982, block: {cache_hit_count: 28451, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.customer.c_acctbal, 5000.602894)	N/A	N/A
21:03:13 [2021-05-27T21:03:13.432Z]               └─TableFullScan_44	7500000.00	7500000	cop[tikv]	table:customer	tikv_task:{proc max:1.07s, min:419ms, p80:862ms, p95:1.07s, iters:7404, tasks:18}	keep order:false	N/A	N/A
21:03:13 [2021-05-27T21:03:13.432Z] 
21:03:13 [2021-05-27T21:03:13.688Z] + tiup cluster stop benchbot
21:03:14 [2021-05-27T21:03:14.615Z] Starting component `cluster`: /home/tidb/.tiup/components/cluster/v1.4.4/tiup-cluster stop benchbot
21:03:15 [2021-05-27T21:03:15.176Z] + [ 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:15 [2021-05-27T21:03:15.176Z] + [Parallel] - UserSSH: user=tidb, host=172.16.5.86
21:03:15 [2021-05-27T21:03:15.176Z] + [Parallel] - UserSSH: user=tidb, host=172.16.5.86
21:03:15 [2021-05-27T21:03:15.176Z] + [Parallel] - UserSSH: user=tidb, host=172.16.5.86
21:03:15 [2021-05-27T21:03:15.176Z] + [Parallel] - UserSSH: user=tidb, host=172.16.5.86
21:03:15 [2021-05-27T21:03:15.176Z] + [Parallel] - UserSSH: user=tidb, host=172.16.5.86
21:03:15 [2021-05-27T21:03:15.176Z] + [ Serial ] - StopCluster
21:03:15 [2021-05-27T21:03:15.176Z] Stopping component grafana
21:03:15 [2021-05-27T21:03:15.176Z] 	Stopping instance 172.16.5.86
21:03:16 [2021-05-27T21:03:16.104Z] 	Stop grafana 172.16.5.86:3000 success
21:03:16 [2021-05-27T21:03:16.104Z] Stopping component prometheus
21:03:16 [2021-05-27T21:03:16.104Z] 	Stopping instance 172.16.5.86
21:03:16 [2021-05-27T21:03:16.359Z] 	Stop prometheus 172.16.5.86:9090 success
21:03:16 [2021-05-27T21:03:16.359Z] Stopping component tidb
21:03:16 [2021-05-27T21:03:16.359Z] 	Stopping instance 172.16.5.86
21:03:19 [2021-05-27T21:03:19.622Z] 	Stop tidb 172.16.5.86:4000 success
21:03:19 [2021-05-27T21:03:19.622Z] Stopping component tikv
21:03:19 [2021-05-27T21:03:19.622Z] 	Stopping instance 172.16.5.86
21:03:22 [2021-05-27T21:03:22.905Z] 	Stop tikv 172.16.5.86:20160 success
21:03:22 [2021-05-27T21:03:22.905Z] Stopping component pd
21:03:22 [2021-05-27T21:03:22.905Z] 	Stopping instance 172.16.5.86
21:03:22 [2021-05-27T21:03:22.905Z] 	Stop pd 172.16.5.86:2379 success
21:03:22 [2021-05-27T21:03:22.905Z] Stopping component node_exporter
21:03:23 [2021-05-27T21:03:23.466Z] Stopping component blackbox_exporter
21:03:23 [2021-05-27T21:03:23.466Z] Stopped cluster `benchbot` successfully
21:03:23 [2021-05-27T21:03:23.728Z] [Pipeline] sh
21:03:24 [2021-05-27T21:03:24.013Z] + cat bench_result
21:03:24 [2021-05-27T21:03:24.018Z] [Pipeline] }
21:03:24 [2021-05-27T21:03:24.021Z] [Pipeline] // dir
21:03:24 [2021-05-27T21:03:24.023Z] [Pipeline] }
21:03:24 [2021-05-27T21:03:24.024Z] [Pipeline] // stage
21:03:24 [2021-05-27T21:03:24.026Z] [Pipeline] }
21:03:24 [2021-05-27T21:03:24.028Z] [Pipeline] // node
21:03:24 [2021-05-27T21:03:24.031Z] [Pipeline] }
21:03:24 [2021-05-27T21:03:24.032Z] [Pipeline] // catchError
21:03:24 [2021-05-27T21:03:24.037Z] [Pipeline] stage
21:03:24 [2021-05-27T21:03:24.040Z] [Pipeline] { (Summary)
21:03:24 [2021-05-27T21:03:24.068Z] sh: line 1: 109609 Terminated              sleep 3
21:03:24 [2021-05-27T21:03:24.054Z] [Pipeline] slackSend
21:03:24 [2021-05-27T21:03:24.055Z] 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:24 [2021-05-27T21:03:24.082Z] sh: line 1: 109668 Terminated              sleep 3
21:03:25 [2021-05-27T21:03:25.182Z] [Pipeline] }
21:03:25 [2021-05-27T21:03:25.184Z] [Pipeline] // stage
21:03:25 [2021-05-27T21:03:25.187Z] [Pipeline] End of Pipeline
21:03:25 [2021-05-27T21:03:25.208Z] Finished: SUCCESS