SuccessConsole Output

Skipping 1,192 KB.. Full Log
uncs:sum(tpch50.lineitem.l_quantity)->Column#44	194.5 MB	N/A
20:38:54 [2021-05-31T20:38:54.808Z]         └─HashJoin_59	9711455.06	634004	root		time:43s, loops:625, build_hash_table:{total:3.28s, fetch:3.06s, build:212.9ms}, probe:{concurrency:5, total:3m34.8s, max:43s, probe:13.9s, fetch:3m20.9s}	left outer join, equal:[eq(tpch50.partsupp.ps_partkey, tpch50.lineitem.l_partkey) eq(tpch50.partsupp.ps_suppkey, tpch50.lineitem.l_suppkey)]	10.4 MB	0 Bytes
20:38:54 [2021-05-31T20:38:54.809Z]           ├─IndexHashJoin_67(Build)	321865.05	435528	root		time:3.24s, loops:430, inner:{total:3.71s, concurrency:5, task:12, construct:156.3ms, fetch:3.22s, build:30.5ms, join:336.2ms}	inner join, inner:IndexLookUp_64, outer key:tpch50.part.p_partkey, inner key:tpch50.partsupp.ps_partkey, equal cond:eq(tpch50.part.p_partkey, tpch50.partsupp.ps_partkey)	19.9 MB	N/A
20:38:54 [2021-05-31T20:38:54.809Z]           │ ├─TableReader_96(Build)	80007.93	108882	root		time:2.77s, loops:112, cop_task: {num: 20, max: 1.94s, min: 604.5ms, avg: 1.39s, p95: 1.94s, max_proc_keys: 686055, p95_proc_keys: 686055, tot_proc: 27.8s, tot_wait: 16ms, rpc_num: 20, rpc_time: 27.8s, copr_cache: disabled}	data:Selection_95	709.0 KB	N/A
20:38:54 [2021-05-31T20:38:54.809Z]           │ │ └─Selection_95	80007.93	108882	cop[tikv]		tikv_task:{proc max:1.92s, min:602ms, p80:1.76s, p95:1.92s, iters:9859, tasks:20}, scan_detail: {total_process_keys: 10000000, total_keys: 10000020, rocksdb: {delete_skipped_count: 0, key_skipped_count: 19999980, block: {cache_hit_count: 31499, read_count: 0, read_byte: 0 Bytes}}}	like(tpch50.part.p_name, "green%", 92)	N/A	N/A
20:38:54 [2021-05-31T20:38:54.809Z]           │ │   └─TableFullScan_94	10000000.00	10000000	cop[tikv]	table:part	tikv_task:{proc max:1.78s, min:553ms, p80:1.64s, p95:1.78s, iters:9859, tasks:20}	keep order:false	N/A	N/A
20:38:54 [2021-05-31T20:38:54.809Z]           │ └─IndexLookUp_64(Probe)	4.02	435528	root		time:3.08s, loops:447, index_task: {total_time: 1.83s, fetch_handle: 1.83s, build: 91µs, wait: 252.6µs}, table_task: {total_time: 11.7s, num: 57, concurrency: 60}		20.5 KB	N/A
20:38:54 [2021-05-31T20:38:54.809Z]           │   ├─IndexRangeScan_62(Build)	4.02	435528	cop[tikv]	table:partsupp, index:PRIMARY(PS_PARTKEY, PS_SUPPKEY)	time:1.8s, loops:480, cop_task: {num: 58, max: 358.5ms, min: 4.86ms, avg: 134.8ms, p95: 311.4ms, max_proc_keys: 15288, p95_proc_keys: 15008, tot_proc: 7.28s, tot_wait: 122ms, rpc_num: 58, rpc_time: 7.82s, copr_cache: disabled}, tikv_task:{proc max:348ms, min:3ms, p80:209ms, p95:294ms, iters:688, tasks:58}, scan_detail: {total_process_keys: 435528, total_keys: 544410, rocksdb: {delete_skipped_count: 0, key_skipped_count: 435528, block: {cache_hit_count: 980292, read_count: 0, read_byte: 0 Bytes}}}	range: decided by [eq(tpch50.partsupp.ps_partkey, tpch50.part.p_partkey)], keep order:false	N/A	N/A
20:38:54 [2021-05-31T20:38:54.809Z]           │   └─TableRowIDScan_63(Probe)	4.02	435528	cop[tikv]	table:partsupp	time:3.94s, loops:507, cop_task: {num: 1426, max: 147.7ms, min: 964.6µs, avg: 26ms, p95: 55.4ms, max_proc_keys: 1248, p95_proc_keys: 588, tot_proc: 28.3s, tot_wait: 6.64s, rpc_num: 1426, rpc_time: 37.1s, copr_cache: disabled}, tikv_task:{proc max:120ms, min:0s, p80:24ms, p95:39ms, iters:5291, tasks:1426}, scan_detail: {total_process_keys: 435528, total_keys: 473503, rocksdb: {delete_skipped_count: 0, key_skipped_count: 194065, block: {cache_hit_count: 3644006, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:38:54 [2021-05-31T20:38:54.809Z]           └─TableReader_101(Probe)	46310896.67	45504356	root		time:37.9s, loops:44290, cop_task: {num: 761, max: 1.63s, min: 382ms, avg: 797.3ms, p95: 1.08s, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 10m3.4s, tot_wait: 143ms, rpc_num: 761, rpc_time: 10m6.8s, copr_cache: disabled}	data:Selection_100	52.6 MB	N/A
20:38:54 [2021-05-31T20:38:54.809Z]             └─Selection_100	46310896.67	45504356	cop[tikv]		tikv_task:{proc max:1.59s, min:372ms, p80:854ms, p95:1.06s, iters:296606, tasks:761}, scan_detail: {total_process_keys: 300005811, total_keys: 300006572, rocksdb: {delete_skipped_count: 0, key_skipped_count: 600010861, block: {cache_hit_count: 1124648, read_count: 0, read_byte: 0 Bytes}}}	ge(tpch50.lineitem.l_shipdate, 1993-01-01 00:00:00.000000), lt(tpch50.lineitem.l_shipdate, 1994-01-01)	N/A	N/A
20:38:54 [2021-05-31T20:38:54.809Z]               └─TableFullScan_99	300005811.00	300005811	cop[tikv]	table:lineitem	tikv_task:{proc max:1.55s, min:352ms, p80:824ms, p95:1.02s, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:38:54 [2021-05-31T20:38:54.809Z] + sync
20:38:54 [2021-05-31T20:38:54.809Z] + /usr/bin/echo 3
20:39:30 [2021-05-31T20:39:30.840Z] + sync
20:39:30 [2021-05-31T20:39:30.840Z] + /usr/bin/echo 3
20:40:25 [2021-05-31T20:40:25.313Z] 
20:40:25 [2021-05-31T20:40:25.313Z] queries/20.sql
20:40:25 [2021-05-31T20:40:25.313Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:40:25 [2021-05-31T20:40:25.313Z] Sort_30	20000.00	8982	root		time:42.5s, loops:10	tpch50.supplier.s_name	614.3 KB	0 Bytes
20:40:25 [2021-05-31T20:40:25.313Z] └─HashJoin_35	20000.00	8982	root		time:42.5s, loops:11, build_hash_table:{total:1.54s, fetch:1.53s, build:5.81ms}, probe:{concurrency:5, total:3m32.6s, max:42.5s, probe:44.9ms, fetch:3m32.6s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.partsupp.ps_suppkey)]	1.48 MB	0 Bytes
20:40:25 [2021-05-31T20:40:25.313Z]   ├─HashJoin_48(Build)	20000.00	19972	root		time:1.54s, loops:22, build_hash_table:{total:239.1µs, fetch:231.8µs, build:7.32µs}, probe:{concurrency:5, total:7.69s, max:1.54s, probe:75ms, fetch:7.61s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:40:25 [2021-05-31T20:40:25.313Z]   │ ├─TableReader_53(Build)	1.00	1	root		time:67µs, loops:2, cop_task: {num: 1, max: 2.42ms, proc_keys: 25, tot_proc: 2ms, rpc_num: 1, rpc_time: 2.39ms, copr_cache: disabled}	data:Selection_52	244 Bytes	N/A
20:40:25 [2021-05-31T20:40:25.313Z]   │ │ └─Selection_52	1.00	1	cop[tikv]		tikv_task:{time:2ms, loops:1}, scan_detail: {total_process_keys: 25, total_keys: 26, rocksdb: {delete_skipped_count: 0, key_skipped_count: 46, block: {cache_hit_count: 18, read_count: 0, read_byte: 0 Bytes}}}	eq(tpch50.nation.n_name, "ALGERIA")	N/A	N/A
20:40:25 [2021-05-31T20:40:25.313Z]   │ │   └─TableFullScan_51	25.00	25	cop[tikv]	table:nation	tikv_task:{time:2ms, loops:1}	keep order:false	N/A	N/A
20:40:25 [2021-05-31T20:40:25.313Z]   │ └─TableReader_50(Probe)	500000.00	500000	root		time:1.52s, loops:490, cop_task: {num: 1, max: 1.52s, proc_keys: 500000, tot_proc: 1.44s, rpc_num: 1, rpc_time: 1.52s, copr_cache: disabled}	data:TableFullScan_49	35.8 MB	N/A
20:40:25 [2021-05-31T20:40:25.313Z]   │   └─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:40:25 [2021-05-31T20:40:25.313Z]   └─HashAgg_54(Probe)	257492.04	223999	root		time:42.5s, loops:222, partial_worker:{wall_time:42.40993814s, concurrency:5, task_num:289, tot_wait:3m31.809623939s, tot_exec:191.064835ms, tot_time:3m32.03829574s, max:42.409872601s, p95:42.409872601s}, final_worker:{wall_time:42.529855993s, concurrency:5, task_num:25, tot_wait:3m32.030330527s, tot_exec:570.76473ms, tot_time:3m32.601112767s, max:42.529821334s, p95:42.529821334s}	group by:tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_suppkey)->tpch50.partsupp.ps_suppkey	61.4 MB	N/A
20:40:25 [2021-05-31T20:40:25.313Z]     └─Selection_55	257492.04	295898	root		time:42.4s, loops:290	gt(cast(tpch50.partsupp.ps_availqty, decimal(20,0) BINARY), mul(0.5, Column#44))	59.2 KB	N/A
20:40:25 [2021-05-31T20:40:25.313Z]       └─HashAgg_56	321865.05	435528	root		time:42.3s, loops:430, partial_worker:{wall_time:42.054278629s, concurrency:5, task_num:625, tot_wait:3m29.074960477s, tot_exec:1.06129653s, tot_time:3m30.261957614s, max:42.054226022s, p95:42.054226022s}, final_worker:{wall_time:42.399128996s, concurrency:5, task_num:25, tot_wait:3m30.252402338s, tot_exec:1.71280297s, tot_time:3m31.965226064s, max:42.399077215s, p95:42.399077215s}	group by:tpch50.partsupp.ps_partkey, tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_suppkey)->tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_availqty)->tpch50.partsupp.ps_availqty, funcs:sum(tpch50.lineitem.l_quantity)->Column#44	194.5 MB	N/A
20:40:25 [2021-05-31T20:40:25.313Z]         └─HashJoin_59	9711455.06	634004	root		time:42s, loops:626, build_hash_table:{total:2.85s, fetch:2.64s, build:207.4ms}, probe:{concurrency:5, total:3m29.9s, max:42s, probe:14.8s, fetch:3m15.1s}	left outer join, equal:[eq(tpch50.partsupp.ps_partkey, tpch50.lineitem.l_partkey) eq(tpch50.partsupp.ps_suppkey, tpch50.lineitem.l_suppkey)]	10.4 MB	0 Bytes
20:40:25 [2021-05-31T20:40:25.313Z]           ├─IndexHashJoin_67(Build)	321865.05	435528	root		time:2.82s, loops:430, inner:{total:3.42s, concurrency:5, task:12, construct:141.4ms, fetch:2.94s, build:27.3ms, join:341.5ms}	inner join, inner:IndexLookUp_64, outer key:tpch50.part.p_partkey, inner key:tpch50.partsupp.ps_partkey, equal cond:eq(tpch50.part.p_partkey, tpch50.partsupp.ps_partkey)	20.0 MB	N/A
20:40:25 [2021-05-31T20:40:25.313Z]           │ ├─TableReader_96(Build)	80007.93	108882	root		time:2.32s, loops:112, cop_task: {num: 20, max: 1.81s, min: 756.4ms, avg: 1.28s, p95: 1.81s, max_proc_keys: 686055, p95_proc_keys: 686055, tot_proc: 25.6s, tot_wait: 15ms, rpc_num: 20, rpc_time: 25.7s, copr_cache: disabled}	data:Selection_95	725.8 KB	N/A
20:40:25 [2021-05-31T20:40:25.313Z]           │ │ └─Selection_95	80007.93	108882	cop[tikv]		tikv_task:{proc max:1.75s, min:749ms, p80:1.48s, p95:1.75s, iters:9859, tasks:20}, scan_detail: {total_process_keys: 10000000, total_keys: 10000020, rocksdb: {delete_skipped_count: 0, key_skipped_count: 19999980, block: {cache_hit_count: 31499, read_count: 0, read_byte: 0 Bytes}}}	like(tpch50.part.p_name, "green%", 92)	N/A	N/A
20:40:25 [2021-05-31T20:40:25.313Z]           │ │   └─TableFullScan_94	10000000.00	10000000	cop[tikv]	table:part	tikv_task:{proc max:1.65s, min:701ms, p80:1.37s, p95:1.65s, iters:9859, tasks:20}	keep order:false	N/A	N/A
20:40:25 [2021-05-31T20:40:25.313Z]           │ └─IndexLookUp_64(Probe)	4.02	435528	root		time:2.81s, loops:447, index_task: {total_time: 1.82s, fetch_handle: 1.82s, build: 89.1µs, wait: 306.8µs}, table_task: {total_time: 11.2s, num: 56, concurrency: 60}		20.5 KB	N/A
20:40:25 [2021-05-31T20:40:25.313Z]           │   ├─IndexRangeScan_62(Build)	4.02	435528	cop[tikv]	table:partsupp, index:PRIMARY(PS_PARTKEY, PS_SUPPKEY)	time:1.77s, loops:482, cop_task: {num: 58, max: 348.2ms, min: 9.15ms, avg: 117.7ms, p95: 260.3ms, max_proc_keys: 15288, p95_proc_keys: 15008, tot_proc: 6.2s, tot_wait: 174ms, rpc_num: 58, rpc_time: 6.82s, copr_cache: disabled}, tikv_task:{proc max:341ms, min:8ms, p80:164ms, p95:243ms, 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:40:25 [2021-05-31T20:40:25.313Z]           │   └─TableRowIDScan_63(Probe)	4.02	435528	cop[tikv]	table:partsupp	time:3.6s, loops:504, cop_task: {num: 1350, max: 97.5ms, min: 520.8µs, avg: 25.1ms, p95: 57.6ms, max_proc_keys: 1028, p95_proc_keys: 656, tot_proc: 25.4s, tot_wait: 5.82s, rpc_num: 1350, rpc_time: 33.9s, copr_cache: disabled}, tikv_task:{proc max:65ms, min:0s, p80:24ms, p95:36ms, iters:5083, tasks:1350}, scan_detail: {total_process_keys: 435528, total_keys: 473526, rocksdb: {delete_skipped_count: 0, key_skipped_count: 194168, block: {cache_hit_count: 3643540, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:40:25 [2021-05-31T20:40:25.313Z]           └─TableReader_101(Probe)	46310896.67	45504356	root		time:37.3s, loops:44289, cop_task: {num: 761, max: 1.4s, min: 531.8ms, avg: 783.9ms, p95: 1.04s, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 9m53.1s, tot_wait: 153ms, rpc_num: 761, rpc_time: 9m56.5s, copr_cache: disabled}	data:Selection_100	52.6 MB	N/A
20:40:25 [2021-05-31T20:40:25.313Z]             └─Selection_100	46310896.67	45504356	cop[tikv]		tikv_task:{proc max:1.33s, min:517ms, p80:850ms, p95:1.02s, iters:296606, tasks:761}, scan_detail: {total_process_keys: 300005811, total_keys: 300006572, rocksdb: {delete_skipped_count: 0, key_skipped_count: 600010861, block: {cache_hit_count: 1124648, read_count: 0, read_byte: 0 Bytes}}}	ge(tpch50.lineitem.l_shipdate, 1993-01-01 00:00:00.000000), lt(tpch50.lineitem.l_shipdate, 1994-01-01)	N/A	N/A
20:40:25 [2021-05-31T20:40:25.313Z]               └─TableFullScan_99	300005811.00	300005811	cop[tikv]	table:lineitem	tikv_task:{proc max:1.28s, min:482ms, p80:817ms, p95:985ms, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:40:25 [2021-05-31T20:40:25.313Z] 
20:40:25 [2021-05-31T20:40:25.313Z] queries/20.sql
20:40:25 [2021-05-31T20:40:25.313Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:40:25 [2021-05-31T20:40:25.313Z] Sort_30	20000.00	8982	root		time:41s, loops:10	tpch50.supplier.s_name	616.9 KB	0 Bytes
20:40:25 [2021-05-31T20:40:25.313Z] └─HashJoin_35	20000.00	8982	root		time:41s, loops:11, build_hash_table:{total:1.45s, fetch:1.44s, build:8.15ms}, probe:{concurrency:5, total:3m25s, max:41s, probe:49.5ms, fetch:3m25s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.partsupp.ps_suppkey)]	1.51 MB	0 Bytes
20:40:25 [2021-05-31T20:40:25.313Z]   ├─HashJoin_48(Build)	20000.00	19972	root		time:1.45s, loops:23, build_hash_table:{total:121.7µs, fetch:117µs, build:4.67µs}, probe:{concurrency:5, total:7.24s, max:1.45s, probe:82.4ms, fetch:7.15s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:40:25 [2021-05-31T20:40:25.313Z]   │ ├─TableReader_53(Build)	1.00	1	root		time:33.8µs, loops:2, cop_task: {num: 1, max: 1.19ms, proc_keys: 25, rpc_num: 1, rpc_time: 1.17ms, copr_cache: disabled}	data:Selection_52	236 Bytes	N/A
20:40:25 [2021-05-31T20:40:25.313Z]   │ │ └─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:40:25 [2021-05-31T20:40:25.314Z]   │ │   └─TableFullScan_51	25.00	25	cop[tikv]	table:nation	tikv_task:{time:0s, loops:1}	keep order:false	N/A	N/A
20:40:25 [2021-05-31T20:40:25.314Z]   │ └─TableReader_50(Probe)	500000.00	500000	root		time:1.43s, loops:490, cop_task: {num: 1, max: 1.43s, proc_keys: 500000, tot_proc: 1.35s, rpc_num: 1, rpc_time: 1.43s, copr_cache: disabled}	data:TableFullScan_49	35.8 MB	N/A
20:40:25 [2021-05-31T20:40:25.314Z]   │   └─TableFullScan_49	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:1.17s, loops:493}, scan_detail: {total_process_keys: 500000, total_keys: 500001, rocksdb: {delete_skipped_count: 0, key_skipped_count: 999999, block: {cache_hit_count: 1692, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:40:25 [2021-05-31T20:40:25.314Z]   └─HashAgg_54(Probe)	257492.04	223999	root		time:41s, loops:222, partial_worker:{wall_time:40.930296131s, concurrency:5, task_num:289, tot_wait:3m24.190174093s, tot_exec:296.282561ms, tot_time:3m24.611293457s, max:40.930228016s, p95:40.930228016s}, final_worker:{wall_time:41.000106305s, concurrency:5, task_num:25, tot_wait:3m24.58849887s, tot_exec:368.759078ms, tot_time:3m24.957271799s, max:41.000034008s, p95:41.000034008s}	group by:tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_suppkey)->tpch50.partsupp.ps_suppkey	61.4 MB	N/A
20:40:25 [2021-05-31T20:40:25.314Z]     └─Selection_55	257492.04	295898	root		time:40.9s, loops:290	gt(cast(tpch50.partsupp.ps_availqty, decimal(20,0) BINARY), mul(0.5, Column#44))	59.2 KB	N/A
20:40:25 [2021-05-31T20:40:25.314Z]       └─HashAgg_56	321865.05	435528	root		time:40.8s, loops:430, partial_worker:{wall_time:40.567486856s, concurrency:5, task_num:623, tot_wait:3m21.567614513s, tot_exec:1.048151419s, tot_time:3m22.779465729s, max:40.567432166s, p95:40.567432166s}, final_worker:{wall_time:40.888784397s, concurrency:5, task_num:25, tot_wait:3m22.660201744s, tot_exec:1.677894413s, tot_time:3m24.338114625s, max:40.888729849s, p95:40.888729849s}	group by:tpch50.partsupp.ps_partkey, tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_suppkey)->tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_availqty)->tpch50.partsupp.ps_availqty, funcs:sum(tpch50.lineitem.l_quantity)->Column#44	194.5 MB	N/A
20:40:25 [2021-05-31T20:40:25.314Z]         └─HashJoin_59	9711455.06	634004	root		time:40.5s, loops:624, build_hash_table:{total:2.78s, fetch:2.58s, build:201.8ms}, probe:{concurrency:5, total:3m22.4s, max:40.5s, probe:14.8s, fetch:3m7.6s}	left outer join, equal:[eq(tpch50.partsupp.ps_partkey, tpch50.lineitem.l_partkey) eq(tpch50.partsupp.ps_suppkey, tpch50.lineitem.l_suppkey)]	10.4 MB	0 Bytes
20:40:25 [2021-05-31T20:40:25.314Z]           ├─IndexHashJoin_67(Build)	321865.05	435528	root		time:2.74s, loops:430, inner:{total:2.93s, concurrency:5, task:12, construct:105.7ms, fetch:2.51s, build:27.5ms, join:319.5ms}	inner join, inner:IndexLookUp_64, outer key:tpch50.part.p_partkey, inner key:tpch50.partsupp.ps_partkey, equal cond:eq(tpch50.part.p_partkey, tpch50.partsupp.ps_partkey)	19.9 MB	N/A
20:40:25 [2021-05-31T20:40:25.314Z]           │ ├─TableReader_96(Build)	80007.93	108882	root		time:2.35s, loops:112, cop_task: {num: 20, max: 1.67s, min: 645.5ms, avg: 1.19s, p95: 1.67s, max_proc_keys: 686055, p95_proc_keys: 686055, tot_proc: 23.7s, tot_wait: 28ms, rpc_num: 20, rpc_time: 23.8s, copr_cache: disabled}	data:Selection_95	725.8 KB	N/A
20:40:25 [2021-05-31T20:40:25.314Z]           │ │ └─Selection_95	80007.93	108882	cop[tikv]		tikv_task:{proc max:1.63s, min:638ms, p80:1.36s, p95:1.63s, iters:9859, tasks:20}, scan_detail: {total_process_keys: 10000000, total_keys: 10000020, rocksdb: {delete_skipped_count: 0, key_skipped_count: 19999980, block: {cache_hit_count: 31499, read_count: 0, read_byte: 0 Bytes}}}	like(tpch50.part.p_name, "green%", 92)	N/A	N/A
20:40:25 [2021-05-31T20:40:25.314Z]           │ │   └─TableFullScan_94	10000000.00	10000000	cop[tikv]	table:part	tikv_task:{proc max:1.52s, min:597ms, p80:1.27s, p95:1.52s, iters:9859, tasks:20}	keep order:false	N/A	N/A
20:40:25 [2021-05-31T20:40:25.314Z]           │ └─IndexLookUp_64(Probe)	4.02	435528	root		time:2.4s, loops:447, index_task: {total_time: 1.52s, fetch_handle: 1.52s, build: 105.8µs, wait: 293.2µs}, table_task: {total_time: 9.17s, num: 56, concurrency: 60}		20.5 KB	N/A
20:40:25 [2021-05-31T20:40:25.314Z]           │   ├─IndexRangeScan_62(Build)	4.02	435528	cop[tikv]	table:partsupp, index:PRIMARY(PS_PARTKEY, PS_SUPPKEY)	time:1.48s, loops:483, cop_task: {num: 61, max: 278.1ms, min: 5.39ms, avg: 99.1ms, p95: 212.9ms, max_proc_keys: 15288, p95_proc_keys: 14948, tot_proc: 5.57s, tot_wait: 124ms, rpc_num: 61, rpc_time: 6.04s, copr_cache: disabled}, tikv_task:{proc max:269ms, min:4ms, p80:139ms, p95:201ms, iters:703, 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:40:25 [2021-05-31T20:40:25.314Z]           │   └─TableRowIDScan_63(Probe)	4.02	435528	cop[tikv]	table:partsupp	time:2.87s, loops:505, cop_task: {num: 1473, max: 106.9ms, min: 516.4µs, avg: 19.5ms, p95: 41.6ms, max_proc_keys: 1056, p95_proc_keys: 540, tot_proc: 21.1s, tot_wait: 4.45s, rpc_num: 1473, rpc_time: 28.7s, copr_cache: disabled}, tikv_task:{proc max:51ms, min:0s, p80:18ms, p95:25ms, iters:5412, tasks:1473}, scan_detail: {total_process_keys: 435528, total_keys: 473492, rocksdb: {delete_skipped_count: 0, key_skipped_count: 194006, block: {cache_hit_count: 3644520, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:40:25 [2021-05-31T20:40:25.314Z]           └─TableReader_101(Probe)	46310896.67	45504356	root		time:35.7s, loops:44290, cop_task: {num: 761, max: 1.22s, min: 371.4ms, avg: 752.3ms, p95: 947.2ms, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 9m29.2s, tot_wait: 133ms, rpc_num: 761, rpc_time: 9m32.5s, copr_cache: disabled}	data:Selection_100	52.6 MB	N/A
20:40:25 [2021-05-31T20:40:25.314Z]             └─Selection_100	46310896.67	45504356	cop[tikv]		tikv_task:{proc max:1.17s, min:362ms, p80:807ms, p95:924ms, iters:296606, tasks:761}, scan_detail: {total_process_keys: 300005811, total_keys: 300006572, rocksdb: {delete_skipped_count: 0, key_skipped_count: 600010861, block: {cache_hit_count: 1124648, read_count: 0, read_byte: 0 Bytes}}}	ge(tpch50.lineitem.l_shipdate, 1993-01-01 00:00:00.000000), lt(tpch50.lineitem.l_shipdate, 1994-01-01)	N/A	N/A
20:40:25 [2021-05-31T20:40:25.314Z]               └─TableFullScan_99	300005811.00	300005811	cop[tikv]	table:lineitem	tikv_task:{proc max:1.13s, min:348ms, p80:774ms, p95:893ms, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:40:25 [2021-05-31T20:40:25.314Z] + sync
20:40:25 [2021-05-31T20:40:25.314Z] + /usr/bin/echo 3
20:41:03 [2021-05-31T20:41:03.818Z] + sync
20:41:03 [2021-05-31T20:41:03.818Z] + /usr/bin/echo 3
20:41:42 [2021-05-31T20:41:42.087Z] 
20:41:42 [2021-05-31T20:41:42.087Z] queries/20.sql
20:41:42 [2021-05-31T20:41:42.087Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:41:42 [2021-05-31T20:41:42.087Z] Sort_30	20000.00	8982	root		time:39s, loops:10	tpch50.supplier.s_name	620.9 KB	0 Bytes
20:41:42 [2021-05-31T20:41:42.087Z] └─HashJoin_35	20000.00	8982	root		time:39s, loops:11, build_hash_table:{total:1.17s, fetch:1.16s, build:9.45ms}, probe:{concurrency:5, total:3m14.8s, max:39s, probe:51.1ms, fetch:3m14.8s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.partsupp.ps_suppkey)]	1.47 MB	0 Bytes
20:41:42 [2021-05-31T20:41:42.087Z]   ├─HashJoin_48(Build)	20000.00	19972	root		time:1.16s, loops:22, build_hash_table:{total:259.5µs, fetch:252.7µs, build:6.84µs}, probe:{concurrency:5, total:5.81s, max:1.16s, probe:97.7ms, fetch:5.72s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:41:42 [2021-05-31T20:41:42.087Z]   │ ├─TableReader_53(Build)	1.00	1	root		time:57.6µs, loops:2, cop_task: {num: 1, max: 1.19ms, proc_keys: 25, rpc_num: 1, rpc_time: 1.16ms, copr_cache: disabled}	data:Selection_52	236 Bytes	N/A
20:41:42 [2021-05-31T20:41:42.087Z]   │ │ └─Selection_52	1.00	1	cop[tikv]		tikv_task:{time:0s, loops:1}, scan_detail: {total_process_keys: 25, total_keys: 26, rocksdb: {delete_skipped_count: 0, key_skipped_count: 46, block: {cache_hit_count: 18, read_count: 0, read_byte: 0 Bytes}}}	eq(tpch50.nation.n_name, "ALGERIA")	N/A	N/A
20:41:42 [2021-05-31T20:41:42.087Z]   │ │   └─TableFullScan_51	25.00	25	cop[tikv]	table:nation	tikv_task:{time:0s, loops:1}	keep order:false	N/A	N/A
20:41:42 [2021-05-31T20:41:42.087Z]   │ └─TableReader_50(Probe)	500000.00	500000	root		time:1.14s, loops:490, cop_task: {num: 1, max: 1.14s, proc_keys: 500000, tot_proc: 1.06s, rpc_num: 1, rpc_time: 1.14s, copr_cache: disabled}	data:TableFullScan_49	35.8 MB	N/A
20:41:42 [2021-05-31T20:41:42.087Z]   │   └─TableFullScan_49	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:931ms, loops:493}, scan_detail: {total_process_keys: 500000, total_keys: 500001, rocksdb: {delete_skipped_count: 0, key_skipped_count: 999999, block: {cache_hit_count: 1692, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:41:42 [2021-05-31T20:41:42.087Z]   └─HashAgg_54(Probe)	257492.04	223999	root		time:39s, loops:222, partial_worker:{wall_time:38.894215235s, concurrency:5, task_num:289, tot_wait:3m14.218587624s, tot_exec:210.049299ms, tot_time:3m14.463657493s, max:38.894095815s, p95:38.894095815s}, final_worker:{wall_time:38.965082472s, concurrency:5, task_num:25, tot_wait:3m14.458681854s, tot_exec:360.587275ms, tot_time:3m14.819280128s, max:38.964962973s, p95:38.964962973s}	group by:tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_suppkey)->tpch50.partsupp.ps_suppkey	61.4 MB	N/A
20:41:42 [2021-05-31T20:41:42.087Z]     └─Selection_55	257492.04	295898	root		time:38.9s, loops:290	gt(cast(tpch50.partsupp.ps_availqty, decimal(20,0) BINARY), mul(0.5, Column#44))	59.2 KB	N/A
20:41:42 [2021-05-31T20:41:42.087Z]       └─HashAgg_56	321865.05	435528	root		time:38.8s, loops:430, partial_worker:{wall_time:38.538611676s, concurrency:5, task_num:623, tot_wait:3m11.357123835s, tot_exec:1.186882341s, tot_time:3m12.660673217s, max:38.538347112s, p95:38.538347112s}, final_worker:{wall_time:38.884694148s, concurrency:5, task_num:25, tot_wait:3m12.634797667s, tot_exec:1.69706079s, tot_time:3m14.331875107s, max:38.884432752s, p95:38.884432752s}	group by:tpch50.partsupp.ps_partkey, tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_suppkey)->tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_availqty)->tpch50.partsupp.ps_availqty, funcs:sum(tpch50.lineitem.l_quantity)->Column#44	194.5 MB	N/A
20:41:42 [2021-05-31T20:41:42.087Z]         └─HashJoin_59	9711455.06	634004	root		time:38.4s, loops:624, build_hash_table:{total:2.45s, fetch:2.24s, build:210.6ms}, probe:{concurrency:5, total:3m12.2s, max:38.4s, probe:14.6s, fetch:2m57.6s}	left outer join, equal:[eq(tpch50.partsupp.ps_partkey, tpch50.lineitem.l_partkey) eq(tpch50.partsupp.ps_suppkey, tpch50.lineitem.l_suppkey)]	10.4 MB	0 Bytes
20:41:42 [2021-05-31T20:41:42.087Z]           ├─IndexHashJoin_67(Build)	321865.05	435528	root		time:2.4s, loops:430, inner:{total:2.56s, concurrency:5, task:12, construct:126.5ms, fetch:2.11s, build:27.7ms, join:322.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)	19.9 MB	N/A
20:41:42 [2021-05-31T20:41:42.087Z]           │ ├─TableReader_96(Build)	80007.93	108882	root		time:2.07s, loops:112, cop_task: {num: 20, max: 1.29s, min: 589.3ms, avg: 1.04s, p95: 1.29s, max_proc_keys: 686055, p95_proc_keys: 686055, tot_proc: 20.8s, rpc_num: 20, rpc_time: 20.8s, copr_cache: disabled}	data:Selection_95	660.2 KB	N/A
20:41:42 [2021-05-31T20:41:42.087Z]           │ │ └─Selection_95	80007.93	108882	cop[tikv]		tikv_task:{proc max:1.26s, min:584ms, p80:1.2s, p95:1.26s, 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:42 [2021-05-31T20:41:42.087Z]           │ │   └─TableFullScan_94	10000000.00	10000000	cop[tikv]	table:part	tikv_task:{proc max:1.17s, min:536ms, p80:1.1s, p95:1.17s, iters:9859, tasks:20}	keep order:false	N/A	N/A
20:41:42 [2021-05-31T20:41:42.087Z]           │ └─IndexLookUp_64(Probe)	4.02	435528	root		time:1.99s, loops:447, index_task: {total_time: 1.18s, fetch_handle: 1.18s, build: 103.5µs, wait: 280.8µs}, table_task: {total_time: 7.94s, num: 56, concurrency: 60}		19.4 KB	N/A
20:41:42 [2021-05-31T20:41:42.087Z]           │   ├─IndexRangeScan_62(Build)	4.02	435528	cop[tikv]	table:partsupp, index:PRIMARY(PS_PARTKEY, PS_SUPPKEY)	time:1.13s, loops:477, cop_task: {num: 58, max: 206.9ms, min: 4.39ms, avg: 88.6ms, p95: 183.1ms, max_proc_keys: 15288, p95_proc_keys: 15048, tot_proc: 4.71s, tot_wait: 80ms, rpc_num: 58, rpc_time: 5.14s, copr_cache: disabled}, tikv_task:{proc max:186ms, min:4ms, p80:133ms, p95:166ms, iters:688, tasks:58}, scan_detail: {total_process_keys: 435528, total_keys: 544410, rocksdb: {delete_skipped_count: 0, key_skipped_count: 435528, block: {cache_hit_count: 980292, read_count: 0, read_byte: 0 Bytes}}}	range: decided by [eq(tpch50.partsupp.ps_partkey, tpch50.part.p_partkey)], keep order:false	N/A	N/A
20:41:42 [2021-05-31T20:41:42.087Z]           │   └─TableRowIDScan_63(Probe)	4.02	435528	cop[tikv]	table:partsupp	time:2.74s, loops:504, cop_task: {num: 1400, max: 103.6ms, min: 525.2µs, avg: 19.2ms, p95: 43.6ms, max_proc_keys: 1104, p95_proc_keys: 624, tot_proc: 19.3s, tot_wait: 4.14s, rpc_num: 1400, rpc_time: 26.8s, copr_cache: disabled}, tikv_task:{proc max:49ms, min:0s, p80:17ms, p95:28ms, iters:5229, tasks:1400}, scan_detail: {total_process_keys: 435528, total_keys: 473528, rocksdb: {delete_skipped_count: 0, key_skipped_count: 194158, block: {cache_hit_count: 3643669, read_count: 1, read_byte: 26.9 KB}}}	keep order:false	N/A	N/A
20:41:42 [2021-05-31T20:41:42.087Z]           └─TableReader_101(Probe)	46310896.67	45504356	root		time:34s, loops:44290, cop_task: {num: 761, max: 1.08s, min: 320.8ms, avg: 717.4ms, p95: 878.9ms, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 9m2.8s, tot_wait: 125ms, rpc_num: 761, rpc_time: 9m5.9s, copr_cache: disabled}	data:Selection_100	52.6 MB	N/A
20:41:42 [2021-05-31T20:41:42.088Z]             └─Selection_100	46310896.67	45504356	cop[tikv]		tikv_task:{proc max:1.03s, min:302ms, p80:770ms, p95:856ms, 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:42 [2021-05-31T20:41:42.088Z]               └─TableFullScan_99	300005811.00	300005811	cop[tikv]	table:lineitem	tikv_task:{proc max:992ms, min:291ms, p80:739ms, p95:828ms, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:41:42 [2021-05-31T20:41:42.088Z] 
20:41:42 [2021-05-31T20:41:42.088Z] queries/20.sql
20:41:42 [2021-05-31T20:41:42.088Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:41:42 [2021-05-31T20:41:42.088Z] Sort_30	20000.00	8982	root		time:37.3s, loops:10	tpch50.supplier.s_name	614.3 KB	0 Bytes
20:41:42 [2021-05-31T20:41:42.088Z] └─HashJoin_35	20000.00	8982	root		time:37.2s, loops:11, build_hash_table:{total:1.14s, fetch:1.13s, build:8.91ms}, probe:{concurrency:5, total:3m6.2s, max:37.2s, probe:51.4ms, fetch:3m6.1s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.partsupp.ps_suppkey)]	1.52 MB	0 Bytes
20:41:42 [2021-05-31T20:41:42.088Z]   ├─HashJoin_48(Build)	20000.00	19972	root		time:1.14s, loops:23, build_hash_table:{total:223.5µs, fetch:216.1µs, build:7.32µs}, probe:{concurrency:5, total:5.68s, max:1.14s, probe:105.3ms, fetch:5.57s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:41:42 [2021-05-31T20:41:42.088Z]   │ ├─TableReader_53(Build)	1.00	1	root		time:57.9µs, loops:2, cop_task: {num: 1, max: 1.06ms, proc_keys: 25, tot_proc: 1ms, rpc_num: 1, rpc_time: 1.02ms, copr_cache: disabled}	data:Selection_52	242 Bytes	N/A
20:41:42 [2021-05-31T20:41:42.088Z]   │ │ └─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:41:42 [2021-05-31T20:41:42.088Z]   │ │   └─TableFullScan_51	25.00	25	cop[tikv]	table:nation	tikv_task:{time:0s, loops:1}	keep order:false	N/A	N/A
20:41:42 [2021-05-31T20:41:42.088Z]   │ └─TableReader_50(Probe)	500000.00	500000	root		time:1.11s, loops:490, cop_task: {num: 1, max: 1.11s, proc_keys: 500000, tot_proc: 1.02s, rpc_num: 1, rpc_time: 1.11s, copr_cache: disabled}	data:TableFullScan_49	35.8 MB	N/A
20:41:42 [2021-05-31T20:41:42.088Z]   │   └─TableFullScan_49	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:877ms, loops:493}, scan_detail: {total_process_keys: 500000, total_keys: 500001, rocksdb: {delete_skipped_count: 0, key_skipped_count: 999999, block: {cache_hit_count: 1692, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:41:42 [2021-05-31T20:41:42.088Z]   └─HashAgg_54(Probe)	257492.04	223999	root		time:37.2s, loops:222, partial_worker:{wall_time:37.173579716s, concurrency:5, task_num:289, tot_wait:3m5.605265357s, tot_exec:216.709926ms, tot_time:3m5.860584891s, max:37.173512992s, p95:37.173512992s}, final_worker:{wall_time:37.23903043s, concurrency:5, task_num:25, tot_wait:3m5.852852704s, tot_exec:318.963711ms, tot_time:3m6.171828048s, max:37.238975113s, p95:37.238975113s}	group by:tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_suppkey)->tpch50.partsupp.ps_suppkey	61.4 MB	N/A
20:41:42 [2021-05-31T20:41:42.088Z]     └─Selection_55	257492.04	295898	root		time:37.2s, loops:290	gt(cast(tpch50.partsupp.ps_availqty, decimal(20,0) BINARY), mul(0.5, Column#44))	59.2 KB	N/A
20:41:42 [2021-05-31T20:41:42.088Z]       └─HashAgg_56	321865.05	435528	root		time:37.1s, loops:430, partial_worker:{wall_time:36.823027006s, concurrency:5, task_num:624, tot_wait:3m2.831158073s, tot_exec:1.15177324s, tot_time:3m4.0986235s, max:36.822984169s, p95:36.822984169s}, final_worker:{wall_time:37.162117141s, concurrency:5, task_num:25, tot_wait:3m4.081220188s, tot_exec:1.684109157s, tot_time:3m5.765345337s, max:37.162081028s, p95:37.162081028s}	group by:tpch50.partsupp.ps_partkey, tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_suppkey)->tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_availqty)->tpch50.partsupp.ps_availqty, funcs:sum(tpch50.lineitem.l_quantity)->Column#44	194.5 MB	N/A
20:41:42 [2021-05-31T20:41:42.088Z]         └─HashJoin_59	9711455.06	634004	root		time:36.7s, loops:625, build_hash_table:{total:2.44s, fetch:2.22s, build:215.2ms}, probe:{concurrency:5, total:3m3.6s, max:36.7s, probe:14.6s, fetch:2m49s}	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:42 [2021-05-31T20:41:42.088Z]           ├─IndexHashJoin_67(Build)	321865.05	435528	root		time:2.4s, loops:430, inner:{total:2.88s, concurrency:5, task:12, construct:176.4ms, fetch:2.37s, build:29.6ms, join:332ms}	inner join, inner:IndexLookUp_64, outer key:tpch50.part.p_partkey, inner key:tpch50.partsupp.ps_partkey, equal cond:eq(tpch50.part.p_partkey, tpch50.partsupp.ps_partkey)	20.0 MB	N/A
20:41:42 [2021-05-31T20:41:42.088Z]           │ ├─TableReader_96(Build)	80007.93	108882	root		time:2.03s, loops:112, cop_task: {num: 20, max: 1.51s, min: 585.5ms, avg: 1.04s, p95: 1.51s, max_proc_keys: 686055, p95_proc_keys: 686055, tot_proc: 20.5s, tot_wait: 81ms, rpc_num: 20, rpc_time: 20.7s, copr_cache: disabled}	data:Selection_95	725.8 KB	N/A
20:41:42 [2021-05-31T20:41:42.088Z]           │ │ └─Selection_95	80007.93	108882	cop[tikv]		tikv_task:{proc max:1.45s, min:580ms, p80:1.21s, p95:1.45s, iters:9859, tasks:20}, scan_detail: {total_process_keys: 10000000, total_keys: 10000020, rocksdb: {delete_skipped_count: 0, key_skipped_count: 19999980, block: {cache_hit_count: 31499, read_count: 0, read_byte: 0 Bytes}}}	like(tpch50.part.p_name, "green%", 92)	N/A	N/A
20:41:42 [2021-05-31T20:41:42.088Z]           │ │   └─TableFullScan_94	10000000.00	10000000	cop[tikv]	table:part	tikv_task:{proc max:1.36s, min:533ms, p80:1.14s, p95:1.36s, iters:9859, tasks:20}	keep order:false	N/A	N/A
20:41:42 [2021-05-31T20:41:42.088Z]           │ └─IndexLookUp_64(Probe)	4.02	435528	root		time:2.26s, loops:447, index_task: {total_time: 1.25s, fetch_handle: 1.25s, build: 94.5µs, wait: 286.5µs}, table_task: {total_time: 8.86s, num: 56, concurrency: 60}		20.5 KB	N/A
20:41:42 [2021-05-31T20:41:42.088Z]           │   ├─IndexRangeScan_62(Build)	4.02	435528	cop[tikv]	table:partsupp, index:PRIMARY(PS_PARTKEY, PS_SUPPKEY)	time:1.21s, loops:483, cop_task: {num: 60, max: 225.4ms, min: 5.02ms, avg: 96.1ms, p95: 182.1ms, max_proc_keys: 15288, p95_proc_keys: 15008, tot_proc: 5.02s, tot_wait: 226ms, rpc_num: 60, rpc_time: 5.76s, copr_cache: disabled}, tikv_task:{proc max:217ms, min:3ms, p80:132ms, p95:160ms, iters:698, tasks:60}, scan_detail: {total_process_keys: 435528, total_keys: 544410, rocksdb: {delete_skipped_count: 0, key_skipped_count: 435528, block: {cache_hit_count: 980292, read_count: 0, read_byte: 0 Bytes}}}	range: decided by [eq(tpch50.partsupp.ps_partkey, tpch50.part.p_partkey)], keep order:false	N/A	N/A
20:41:42 [2021-05-31T20:41:42.088Z]           │   └─TableRowIDScan_63(Probe)	4.02	435528	cop[tikv]	table:partsupp	time:3.76s, loops:504, cop_task: {num: 1374, max: 129.9ms, min: 438.6µs, avg: 25.8ms, p95: 72.1ms, max_proc_keys: 1028, p95_proc_keys: 640, tot_proc: 23.7s, tot_wait: 8.96s, rpc_num: 1374, rpc_time: 35.5s, copr_cache: disabled}, tikv_task:{proc max:44ms, min:0s, p80:18ms, p95:26ms, iters:5136, tasks:1374}, scan_detail: {total_process_keys: 435528, total_keys: 473532, rocksdb: {delete_skipped_count: 0, key_skipped_count: 194172, block: {cache_hit_count: 3643474, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:41:42 [2021-05-31T20:41:42.088Z]           └─TableReader_101(Probe)	46310896.67	45504356	root		time:32.2s, loops:44290, cop_task: {num: 761, max: 1.15s, min: 294ms, avg: 684.3ms, p95: 851.7ms, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 8m37.4s, tot_wait: 147ms, rpc_num: 761, rpc_time: 8m40.7s, copr_cache: disabled}	data:Selection_100	52.6 MB	N/A
20:41:42 [2021-05-31T20:41:42.088Z]             └─Selection_100	46310896.67	45504356	cop[tikv]		tikv_task:{proc max:1.04s, min:288ms, p80:727ms, p95:833ms, iters:296606, tasks:761}, scan_detail: {total_process_keys: 300005811, total_keys: 300006572, rocksdb: {delete_skipped_count: 0, key_skipped_count: 600010861, block: {cache_hit_count: 1124648, read_count: 0, read_byte: 0 Bytes}}}	ge(tpch50.lineitem.l_shipdate, 1993-01-01 00:00:00.000000), lt(tpch50.lineitem.l_shipdate, 1994-01-01)	N/A	N/A
20:41:42 [2021-05-31T20:41:42.088Z]               └─TableFullScan_99	300005811.00	300005811	cop[tikv]	table:lineitem	tikv_task:{proc max:987ms, min:278ms, p80:694ms, p95:799ms, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:41:42 [2021-05-31T20:41:42.088Z] + sync
20:41:42 [2021-05-31T20:41:42.088Z] + /usr/bin/echo 3
20:42:20 [2021-05-31T20:42:20.266Z] + tiup cluster stop benchbot -y
20:42:20 [2021-05-31T20:42:20.266Z] Starting component `cluster`: /home/tidb/.tiup/components/cluster/v1.4.4/tiup-cluster stop benchbot -y
20:42:40 [2021-05-31T20:42:40.107Z] + rm -rf '/data1/tidb-deploy/*/log/*'
20:42:40 [2021-05-31T20:42:40.107Z] + rm -rf /data1/jenkins/deploy/data/tikv-20160
20:42:40 [2021-05-31T20:42:40.107Z] + rm -rf /data1/jenkins/deploy/data/pd-2379
20:42:40 [2021-05-31T20:42:40.107Z] + rm -rf /data1/jenkins/restore_data/tpch50/data/last_tikv.toml
20:42:40 [2021-05-31T20:42:40.107Z] + cp -R /data1/jenkins/restore_data/tpch50/data /data1/jenkins/deploy/data/tikv-20160
20:44:33 [2021-05-31T20:44:33.494Z] + cp -R /data1/jenkins/restore_data/tpch50/data.pd /data1/jenkins/deploy/data/pd-2379
20:44:33 [2021-05-31T20:44:33.494Z] + '[' -n '' ']'
20:44:33 [2021-05-31T20:44:33.494Z] + tiup cluster start benchbot --wait-timeout=300
20:44:33 [2021-05-31T20:44:33.494Z] Starting component `cluster`: /home/tidb/.tiup/components/cluster/v1.4.4/tiup-cluster start benchbot --wait-timeout=300
20:44:56 [2021-05-31T20:44:56.243Z] + sync
20:44:56 [2021-05-31T20:44:56.243Z] + /usr/bin/echo 3
20:46:29 [2021-05-31T20:46:29.757Z] 
20:46:29 [2021-05-31T20:46:29.757Z] queries/20.sql
20:46:29 [2021-05-31T20:46:29.757Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:46:29 [2021-05-31T20:46:29.758Z] Sort_30	20000.00	8982	root		time:37.1s, loops:10	tpch50.supplier.s_name	610.3 KB	0 Bytes
20:46:29 [2021-05-31T20:46:29.758Z] └─HashJoin_35	20000.00	8982	root		time:37.1s, loops:11, build_hash_table:{total:1.33s, fetch:1.32s, build:9.52ms}, probe:{concurrency:5, total:3m5.6s, max:37.1s, probe:45.8ms, fetch:3m5.6s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.partsupp.ps_suppkey)]	1.47 MB	0 Bytes
20:46:29 [2021-05-31T20:46:29.758Z]   ├─HashJoin_48(Build)	20000.00	19972	root		time:1.33s, loops:22, build_hash_table:{total:5.96ms, fetch:5.95ms, build:7.81µs}, probe:{concurrency:5, total:6.65s, max:1.33s, probe:103.5ms, fetch:6.54s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:46:29 [2021-05-31T20:46:29.758Z]   │ ├─TableReader_53(Build)	1.00	1	root		time:5.76ms, loops:2, cop_task: {num: 1, max: 9.31ms, proc_keys: 25, rpc_num: 1, rpc_time: 9.29ms, copr_cache: disabled}	data:Selection_52	240 Bytes	N/A
20:46:29 [2021-05-31T20:46:29.758Z]   │ │ └─Selection_52	1.00	1	cop[tikv]		tikv_task:{time:0s, loops:1}, scan_detail: {total_process_keys: 25, total_keys: 26, rocksdb: {delete_skipped_count: 0, key_skipped_count: 46, block: {cache_hit_count: 18, read_count: 0, read_byte: 0 Bytes}}}	eq(tpch50.nation.n_name, "ALGERIA")	N/A	N/A
20:46:29 [2021-05-31T20:46:29.758Z]   │ │   └─TableFullScan_51	25.00	25	cop[tikv]	table:nation	tikv_task:{time:0s, loops:1}	keep order:false	N/A	N/A
20:46:29 [2021-05-31T20:46:29.758Z]   │ └─TableReader_50(Probe)	500000.00	500000	root		time:1.31s, loops:490, cop_task: {num: 1, max: 1.31s, proc_keys: 500000, tot_proc: 1.25s, tot_wait: 1ms, rpc_num: 1, rpc_time: 1.31s, copr_cache: disabled}	data:TableFullScan_49	35.8 MB	N/A
20:46:29 [2021-05-31T20:46:29.758Z]   │   └─TableFullScan_49	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:1.1s, loops:493}, scan_detail: {total_process_keys: 500000, total_keys: 500001, rocksdb: {delete_skipped_count: 0, key_skipped_count: 999999, block: {cache_hit_count: 1692, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:46:29 [2021-05-31T20:46:29.758Z]   └─HashAgg_54(Probe)	257492.04	223999	root		time:37.1s, loops:222, partial_worker:{wall_time:37.012937141s, concurrency:5, task_num:289, tot_wait:3m4.81587677s, tot_exec:209.004354ms, tot_time:3m5.060098693s, max:37.012858217s, p95:37.012858217s}, final_worker:{wall_time:37.12529739s, concurrency:5, task_num:25, tot_wait:3m5.056763527s, tot_exec:560.689302ms, tot_time:3m5.617467865s, max:37.125221326s, p95:37.125221326s}	group by:tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_suppkey)->tpch50.partsupp.ps_suppkey	61.4 MB	N/A
20:46:29 [2021-05-31T20:46:29.758Z]     └─Selection_55	257492.04	295898	root		time:37s, loops:290	gt(cast(tpch50.partsupp.ps_availqty, decimal(20,0) BINARY), mul(0.5, Column#44))	59.2 KB	N/A
20:46:29 [2021-05-31T20:46:29.758Z]       └─HashAgg_56	321865.05	435528	root		time:36.9s, loops:430, partial_worker:{wall_time:36.66312745s, concurrency:5, task_num:624, tot_wait:3m2.111687845s, tot_exec:1.059680029s, tot_time:3m3.295387816s, max:36.663050334s, p95:36.663050334s}, final_worker:{wall_time:37.003689021s, concurrency:5, task_num:25, tot_wait:3m3.248793053s, tot_exec:1.717532989s, tot_time:3m4.966343614s, max:37.003567711s, p95:37.003567711s}	group by:tpch50.partsupp.ps_partkey, tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_suppkey)->tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_availqty)->tpch50.partsupp.ps_availqty, funcs:sum(tpch50.lineitem.l_quantity)->Column#44	194.5 MB	N/A
20:46:29 [2021-05-31T20:46:29.758Z]         └─HashJoin_59	9711455.06	634004	root		time:36.6s, loops:625, build_hash_table:{total:2.52s, fetch:2.32s, build:203.6ms}, probe:{concurrency:5, total:3m2.9s, max:36.6s, probe:15.3s, fetch:2m47.6s}	left outer join, equal:[eq(tpch50.partsupp.ps_partkey, tpch50.lineitem.l_partkey) eq(tpch50.partsupp.ps_suppkey, tpch50.lineitem.l_suppkey)]	10.4 MB	0 Bytes
20:46:29 [2021-05-31T20:46:29.758Z]           ├─IndexHashJoin_67(Build)	321865.05	435528	root		time:2.5s, loops:430, inner:{total:2.68s, concurrency:5, task:12, construct:139.3ms, fetch:2.22s, build:30.6ms, join:317ms}	inner join, inner:IndexLookUp_64, outer key:tpch50.part.p_partkey, inner key:tpch50.partsupp.ps_partkey, equal cond:eq(tpch50.part.p_partkey, tpch50.partsupp.ps_partkey)	19.9 MB	N/A
20:46:29 [2021-05-31T20:46:29.758Z]           │ ├─TableReader_96(Build)	80007.93	108882	root		time:2.05s, loops:112, cop_task: {num: 20, max: 1.56s, min: 684.2ms, avg: 1.1s, p95: 1.56s, max_proc_keys: 686055, p95_proc_keys: 686055, tot_proc: 22.1s, tot_wait: 8ms, rpc_num: 20, rpc_time: 22.1s, copr_cache: disabled}	data:Selection_95	680.6 KB	N/A
20:46:29 [2021-05-31T20:46:29.758Z]           │ │ └─Selection_95	80007.93	108882	cop[tikv]		tikv_task:{proc max:1.53s, min:680ms, p80:1.26s, p95:1.53s, iters:9859, tasks:20}, scan_detail: {total_process_keys: 10000000, total_keys: 10000020, rocksdb: {delete_skipped_count: 0, key_skipped_count: 19999980, block: {cache_hit_count: 31499, read_count: 0, read_byte: 0 Bytes}}}	like(tpch50.part.p_name, "green%", 92)	N/A	N/A
20:46:29 [2021-05-31T20:46:29.758Z]           │ │   └─TableFullScan_94	10000000.00	10000000	cop[tikv]	table:part	tikv_task:{proc max:1.43s, min:636ms, p80:1.17s, p95:1.43s, iters:9859, tasks:20}	keep order:false	N/A	N/A
20:46:29 [2021-05-31T20:46:29.758Z]           │ └─IndexLookUp_64(Probe)	4.02	435528	root		time:2.1s, loops:447, index_task: {total_time: 1.23s, fetch_handle: 1.23s, build: 100.3µs, wait: 294.2µs}, table_task: {total_time: 8.35s, num: 56, concurrency: 60}		20.5 KB	N/A
20:46:29 [2021-05-31T20:46:29.758Z]           │   ├─IndexRangeScan_62(Build)	4.02	435528	cop[tikv]	table:partsupp, index:PRIMARY(PS_PARTKEY, PS_SUPPKEY)	time:1.19s, loops:485, cop_task: {num: 60, max: 221ms, min: 4.75ms, avg: 96.6ms, p95: 211ms, max_proc_keys: 15288, p95_proc_keys: 15048, tot_proc: 5.25s, tot_wait: 217ms, rpc_num: 60, rpc_time: 5.79s, copr_cache: disabled}, tikv_task:{proc max:191ms, min:4ms, p80:146ms, p95:176ms, iters:698, tasks:60}, scan_detail: {total_process_keys: 435528, total_keys: 544410, rocksdb: {delete_skipped_count: 0, key_skipped_count: 435528, block: {cache_hit_count: 980292, read_count: 0, read_byte: 0 Bytes}}}	range: decided by [eq(tpch50.partsupp.ps_partkey, tpch50.part.p_partkey)], keep order:false	N/A	N/A
20:46:29 [2021-05-31T20:46:29.758Z]           │   └─TableRowIDScan_63(Probe)	4.02	435528	cop[tikv]	table:partsupp	time:2.87s, loops:504, cop_task: {num: 1400, max: 81.2ms, min: 902.8µs, avg: 20.9ms, p95: 42.9ms, max_proc_keys: 976, p95_proc_keys: 604, tot_proc: 20.8s, tot_wait: 6.16s, rpc_num: 1400, rpc_time: 29.2s, copr_cache: disabled}, tikv_task:{proc max:52ms, min:0s, p80:18ms, p95:26ms, iters:5230, tasks:1400}, scan_detail: {total_process_keys: 435528, total_keys: 473511, rocksdb: {delete_skipped_count: 0, key_skipped_count: 194087, block: {cache_hit_count: 3644051, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:46:29 [2021-05-31T20:46:29.758Z]           └─TableReader_101(Probe)	46310896.67	45504356	root		time:32s, loops:44289, cop_task: {num: 761, max: 1.19s, min: 354.7ms, avg: 679.4ms, p95: 820.6ms, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 8m33.9s, tot_wait: 115ms, rpc_num: 761, rpc_time: 8m37s, copr_cache: disabled}	data:Selection_100	52.6 MB	N/A
20:46:29 [2021-05-31T20:46:29.758Z]             └─Selection_100	46310896.67	45504356	cop[tikv]		tikv_task:{proc max:1.13s, min:345ms, p80:731ms, p95:804ms, iters:296606, tasks:761}, scan_detail: {total_process_keys: 300005811, total_keys: 300006572, rocksdb: {delete_skipped_count: 0, key_skipped_count: 600010861, block: {cache_hit_count: 1124648, read_count: 0, read_byte: 0 Bytes}}}	ge(tpch50.lineitem.l_shipdate, 1993-01-01 00:00:00.000000), lt(tpch50.lineitem.l_shipdate, 1994-01-01)	N/A	N/A
20:46:29 [2021-05-31T20:46:29.758Z]               └─TableFullScan_99	300005811.00	300005811	cop[tikv]	table:lineitem	tikv_task:{proc max:1.07s, min:334ms, p80:699ms, p95:775ms, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:46:29 [2021-05-31T20:46:29.758Z] 
20:46:29 [2021-05-31T20:46:29.758Z] queries/21.sql
20:46:29 [2021-05-31T20:46:29.758Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:46:29 [2021-05-31T20:46:29.758Z] Projection_26	100.00	100	root		time:1m22.3s, loops:2, Concurrency:OFF	tpch50.supplier.s_name, Column#72	4.62 KB	N/A
20:46:29 [2021-05-31T20:46:29.758Z] └─TopN_29	100.00	100	root		time:1m22.3s, loops:2	Column#72:desc, tpch50.supplier.s_name, offset:0, count:100	55.9 KB	N/A
20:46:29 [2021-05-31T20:46:29.758Z]   └─HashAgg_34	12800.00	20057	root		time:1m22.3s, loops:21, partial_worker:{wall_time:1m22.273996792s, concurrency:5, task_num:197, tot_wait:6m51.092564202s, tot_exec:261.186907ms, tot_time:6m51.36620454s, max:1m22.273940285s, p95:1m22.273940285s}, final_worker:{wall_time:1m22.286626795s, concurrency:5, task_num:25, tot_wait:6m51.364681001s, tot_exec:64.028729ms, tot_time:6m51.428719977s, max:1m22.286564659s, p95:1m22.286564659s}	group by:tpch50.supplier.s_name, funcs:count(1)->Column#72, funcs:firstrow(tpch50.supplier.s_name)->tpch50.supplier.s_name	17.2 MB	N/A
20:46:29 [2021-05-31T20:46:29.758Z]     └─IndexHashJoin_42	7828961.66	198698	root		time:1m22.3s, loops:198, inner:{total:2m20.6s, concurrency:5, task:147, construct:6.46s, fetch:1m58.4s, build:1.17s, join:15.8s}	anti semi join, inner:IndexLookUp_39, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey)	641.1 MB	N/A
20:46:29 [2021-05-31T20:46:29.758Z]       ├─IndexHashJoin_83(Build)	9786202.08	3542799	root		time:1m21.8s, loops:3464, inner:{total:2m29s, concurrency:5, task:152, construct:7.62s, fetch:2m4.1s, build:1.24s, join:17.3s}	semi join, inner:IndexLookUp_80, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey), ne(tpch50.lineitem.l_suppkey, tpch50.supplier.s_suppkey)	555.9 MB	N/A
20:46:29 [2021-05-31T20:46:29.758Z]       │ ├─IndexJoin_99(Build)	12232752.60	3675878	root		time:1m21.1s, loops:3595, inner:{total:2m8.5s, concurrency:5, task:305, construct:16.3s, fetch:1m50.3s, build:1.91s}, probe:5.16s	inner join, inner:TableReader_95, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.orders.o_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.orders.o_orderkey)	575.4 MB	N/A
20:46:29 [2021-05-31T20:46:29.758Z]       │ │ ├─HashJoin_107(Build)	12232752.60	7609895	root		time:1m20.4s, loops:7436, build_hash_table:{total:955.6ms, fetch:947ms, build:8.61ms}, probe:{concurrency:5, total:6m44.7s, max:1m20.9s, probe:1m1.3s, fetch:5m43.4s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.lineitem.l_suppkey)]	757.3 KB	0 Bytes
20:46:29 [2021-05-31T20:46:29.758Z]       │ │ │ ├─HashJoin_120(Build)	20000.00	20058	root		time:952.5ms, loops:23, build_hash_table:{total:697.8µs, fetch:255.8µs, build:442.1µs}, probe:{concurrency:5, total:4.77s, max:953.5ms, probe:83.8ms, fetch:4.68s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:46:29 [2021-05-31T20:46:29.758Z]       │ │ │ │ ├─TableReader_125(Build)	1.00	1	root		time:101.8µs, loops:2, cop_task: {num: 1, max: 945µs, proc_keys: 25, rpc_num: 1, rpc_time: 932.8µs, copr_cache: disabled}	data:Selection_124	234 Bytes	N/A
20:46:29 [2021-05-31T20:46:29.758Z]       │ │ │ │ │ └─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:46:29 [2021-05-31T20:46:29.758Z]       │ │ │ │ │   └─TableFullScan_123	25.00	25	cop[tikv]	table:nation	tikv_task:{time:0s, loops:1}	keep order:false	N/A	N/A
20:46:29 [2021-05-31T20:46:29.758Z]       │ │ │ │ └─TableReader_122(Probe)	500000.00	500000	root		time:936.7ms, 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:46:29 [2021-05-31T20:46:29.758Z]       │ │ │ │   └─TableFullScan_121	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:938ms, loops:493}, scan_detail: {total_process_keys: 500000, total_keys: 500001, rocksdb: {delete_skipped_count: 0, key_skipped_count: 999999, block: {cache_hit_count: 15, read_count: 1689, read_byte: 108.5 MB}}}	keep order:false	N/A	N/A
20:46:29 [2021-05-31T20:46:29.758Z]       │ │ │ └─TableReader_128(Probe)	240004648.80	189670348	root		time:1m8.5s, loops:184598, cop_task: {num: 761, max: 2.89s, min: 354.1ms, avg: 1.56s, p95: 2.07s, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 18m31s, tot_wait: 1m1.4s, rpc_num: 761, rpc_time: 19m45.7s, copr_cache: disabled}	data:Selection_127	99.2 MB	N/A
20:46:29 [2021-05-31T20:46:29.758Z]       │ │ │   └─Selection_127	240004648.80	189670348	cop[tikv]		tikv_task:{proc max:1.45s, min:339ms, p80:1.22s, p95:1.3s, 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: 18675, read_count: 1131789, read_byte: 23.9 GB}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:46:29 [2021-05-31T20:46:29.758Z]       │ │ │     └─TableFullScan_126	300005811.00	300005811	cop[tikv]	table:l1	tikv_task:{proc max:1.38s, min:323ms, p80:1.14s, p95:1.22s, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:46:29 [2021-05-31T20:46:29.758Z]       │ │ └─TableReader_95(Probe)	0.49	3496155	root		time:1m41.2s, loops:3875, cop_task: {num: 5268, max: 606ms, min: 1.12ms, avg: 179.7ms, p95: 349.3ms, max_proc_keys: 4412, p95_proc_keys: 1961, tot_proc: 11m19.6s, tot_wait: 3m46.8s, rpc_num: 5268, rpc_time: 15m46.7s, copr_cache: disabled}	data:Selection_94	N/A	N/A
20:46:29 [2021-05-31T20:46:29.758Z]       │ │   └─Selection_94	0.49	3496155	cop[tikv]		tikv_task:{proc max:191ms, min:0s, p80:71ms, p95:84ms, iters:30295, tasks:5268}, scan_detail: {total_process_keys: 7236273, total_keys: 7795511, rocksdb: {delete_skipped_count: 0, key_skipped_count: 1778396, block: {cache_hit_count: 54006938, read_count: 220076, read_byte: 4.68 GB}}}	eq(tpch50.orders.o_orderstatus, "F")	N/A	N/A
20:46:29 [2021-05-31T20:46:29.758Z]       │ │     └─TableRangeScan_93	1.00	7236273	cop[tikv]	table:orders	tikv_task:{proc max:190ms, min:0s, p80:70ms, p95:83ms, iters:30295, tasks:5268}	range: decided by [tpch50.lineitem.l_orderkey], keep order:false	N/A	N/A
20:46:29 [2021-05-31T20:46:29.758Z]       │ └─IndexLookUp_80(Probe)	4.05	17316432	root		time:1m58.7s, loops:17133, index_task: {total_time: 1m6.5s, fetch_handle: 57.8s, build: 3.25ms, wait: 8.62s}, table_task: {total_time: 8m35.1s, num: 1458, concurrency: 760}		28.2 KB	N/A
20:46:29 [2021-05-31T20:46:29.759Z]       │   ├─IndexRangeScan_78(Build)	4.05	17316432	cop[tikv]	table:l2, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:55.5s, loops:18618, cop_task: {num: 2981, max: 739.7ms, min: 833.7µs, avg: 190.3ms, p95: 378.3ms, max_proc_keys: 10743, p95_proc_keys: 8751, tot_proc: 7m6s, tot_wait: 2m0.4s, rpc_num: 2981, rpc_time: 9m27.3s, copr_cache: disabled}, tikv_task:{proc max:173ms, min:0s, p80:100ms, p95:117ms, iters:30084, tasks:2981}, scan_detail: {total_process_keys: 17316432, total_keys: 20812531, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17316432, block: {cache_hit_count: 24260154, read_count: 226914, read_byte: 2.41 GB}}}	range: decided by [eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey)], keep order:false	N/A	N/A
20:46:29 [2021-05-31T20:46:29.759Z]       │   └─TableRowIDScan_79(Probe)	4.05	17316432	cop[tikv]	table:l2	time:6m17.5s, loops:21054, cop_task: {num: 7824, max: 680.7ms, min: 402.9µs, avg: 177.7ms, p95: 369.7ms, max_proc_keys: 11024, p95_proc_keys: 4851, tot_proc: 16m37.5s, tot_wait: 5m42.3s, rpc_num: 7824, rpc_time: 23m10.4s, copr_cache: disabled}, tikv_task:{proc max:268ms, min:0s, p80:105ms, p95:141ms, iters:49884, tasks:7824}, scan_detail: {total_process_keys: 17316432, total_keys: 18288285, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5623003, block: {cache_hit_count: 99024265, read_count: 5, read_byte: 36.7 KB}}}	keep order:false	N/A	N/A
20:46:29 [2021-05-31T20:46:29.759Z]       └─IndexLookUp_39(Probe)	4.05	12022818	root		time:1m53.5s, loops:11949, index_task: {total_time: 1m0.7s, fetch_handle: 48.7s, build: 4.09ms, wait: 12s}, table_task: {total_time: 8m10.3s, num: 1410, concurrency: 735}		219.9 KB	N/A
20:46:29 [2021-05-31T20:46:29.759Z]         ├─IndexRangeScan_36(Build)	5.06	17183420	cop[tikv]	table:l3, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:46.4s, loops:18345, cop_task: {num: 2735, max: 850.6ms, min: 313.5µs, avg: 166.8ms, p95: 366.8ms, max_proc_keys: 22153, p95_proc_keys: 13563, tot_proc: 5m43.7s, tot_wait: 1m31.5s, rpc_num: 2735, rpc_time: 7m36s, copr_cache: disabled}, tikv_task:{proc max:211ms, min:0s, p80:82ms, p95:122ms, iters:28909, tasks:2735}, scan_detail: {total_process_keys: 17183420, total_keys: 20546451, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17183420, 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:46:29 [2021-05-31T20:46:29.759Z]         └─Selection_38(Probe)	4.05	12022818	cop[tikv]		time:6m21.6s, loops:13783, cop_task: {num: 10306, max: 669.4ms, min: 356.8µs, avg: 178.1ms, p95: 368.9ms, max_proc_keys: 7195, p95_proc_keys: 3937, tot_proc: 21m25.8s, tot_wait: 8m2.9s, rpc_num: 10306, rpc_time: 30m35.3s, copr_cache: disabled}, tikv_task:{proc max:231ms, min:0s, p80:76ms, p95:116ms, iters:60965, tasks:10306}, scan_detail: {total_process_keys: 17183420, total_keys: 18127232, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5519956, block: {cache_hit_count: 98293889, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:46:29 [2021-05-31T20:46:29.759Z]           └─TableRowIDScan_37	5.06	17183420	cop[tikv]	table:l3	tikv_task:{proc max:230ms, min:0s, p80:75ms, p95:115ms, iters:60965, tasks:10306}	keep order:false	N/A	N/A
20:46:29 [2021-05-31T20:46:29.759Z] + sync
20:46:29 [2021-05-31T20:46:29.759Z] + /usr/bin/echo 3
20:47:58 [2021-05-31T20:47:58.150Z] 
20:47:58 [2021-05-31T20:47:58.150Z] queries/21.sql
20:47:58 [2021-05-31T20:47:58.150Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:47:58 [2021-05-31T20:47:58.150Z] Projection_26	100.00	100	root		time:1m27.4s, loops:2, Concurrency:OFF	tpch50.supplier.s_name, Column#72	4.62 KB	N/A
20:47:58 [2021-05-31T20:47:58.150Z] └─TopN_29	100.00	100	root		time:1m27.4s, loops:2	Column#72:desc, tpch50.supplier.s_name, offset:0, count:100	58.4 KB	N/A
20:47:58 [2021-05-31T20:47:58.150Z]   └─HashAgg_34	12800.00	20057	root		time:1m27.4s, loops:21, partial_worker:{wall_time:1m27.428498305s, concurrency:5, task_num:197, tot_wait:7m16.849706612s, tot_exec:278.426814ms, tot_time:7m17.140415714s, max:1m27.428467006s, p95:1m27.428467006s}, final_worker:{wall_time:1m27.44124131s, concurrency:5, task_num:25, tot_wait:7m17.138602431s, tot_exec:66.784944ms, tot_time:7m17.205399461s, max:1m27.441209836s, p95:1m27.441209836s}	group by:tpch50.supplier.s_name, funcs:count(1)->Column#72, funcs:firstrow(tpch50.supplier.s_name)->tpch50.supplier.s_name	17.2 MB	N/A
20:47:58 [2021-05-31T20:47:58.150Z]     └─IndexHashJoin_42	7828961.66	198698	root		time:1m27.4s, loops:198, inner:{total:2m22.6s, concurrency:5, task:147, construct:6.48s, fetch:1m59.5s, build:1.15s, join:16.6s}	anti semi join, inner:IndexLookUp_39, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey)	641.1 MB	N/A
20:47:58 [2021-05-31T20:47:58.150Z]       ├─IndexHashJoin_83(Build)	9786202.08	3542799	root		time:1m26.9s, loops:3464, inner:{total:2m31.2s, concurrency:5, task:152, construct:7.85s, fetch:2m5.7s, build:1.21s, join:17.6s}	semi join, inner:IndexLookUp_80, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey), ne(tpch50.lineitem.l_suppkey, tpch50.supplier.s_suppkey)	555.9 MB	N/A
20:47:58 [2021-05-31T20:47:58.150Z]       │ ├─IndexJoin_99(Build)	12232752.60	3675878	root		time:1m26.2s, loops:3595, inner:{total:2m10.9s, concurrency:5, task:305, construct:16.6s, fetch:1m52.4s, build:1.86s}, 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)	575.3 MB	N/A
20:47:58 [2021-05-31T20:47:58.150Z]       │ │ ├─HashJoin_107(Build)	12232752.60	7609895	root		time:1m25.7s, loops:7437, build_hash_table:{total:1.17s, fetch:1.16s, build:7.62ms}, probe:{concurrency:5, total:7m10.3s, max:1m26.1s, probe:59.4s, fetch:6m11s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.lineitem.l_suppkey)]	737.6 KB	0 Bytes
20:47:58 [2021-05-31T20:47:58.151Z]       │ │ │ ├─HashJoin_120(Build)	20000.00	20058	root		time:1.17s, loops:22, build_hash_table:{total:223.4µs, fetch:216.2µs, build:7.2µs}, probe:{concurrency:5, total:5.85s, max:1.17s, probe:66.1ms, fetch:5.79s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:47:58 [2021-05-31T20:47:58.151Z]       │ │ │ │ ├─TableReader_125(Build)	1.00	1	root		time:65.1µs, loops:2, cop_task: {num: 1, max: 1.63ms, proc_keys: 25, tot_proc: 1ms, tot_wait: 1ms, rpc_num: 1, rpc_time: 1.6ms, copr_cache: disabled}	data:Selection_124	252 Bytes	N/A
20:47:58 [2021-05-31T20:47:58.151Z]       │ │ │ │ │ └─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:47:58 [2021-05-31T20:47:58.151Z]       │ │ │ │ │   └─TableFullScan_123	25.00	25	cop[tikv]	table:nation	tikv_task:{time:1ms, loops:1}	keep order:false	N/A	N/A
20:47:58 [2021-05-31T20:47:58.151Z]       │ │ │ │ └─TableReader_122(Probe)	500000.00	500000	root		time:1.16s, loops:490, cop_task: {num: 1, max: 1.16s, proc_keys: 500000, tot_proc: 1.13s, rpc_num: 1, rpc_time: 1.16s, copr_cache: disabled}	data:TableFullScan_121	20.0 MB	N/A
20:47:58 [2021-05-31T20:47:58.151Z]       │ │ │ │   └─TableFullScan_121	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:1.06s, loops:493}, scan_detail: {total_process_keys: 500000, total_keys: 500001, rocksdb: {delete_skipped_count: 0, key_skipped_count: 999999, block: {cache_hit_count: 13, read_count: 1679, read_byte: 104.5 MB}}}	keep order:false	N/A	N/A
20:47:58 [2021-05-31T20:47:58.151Z]       │ │ │ └─TableReader_128(Probe)	240004648.80	189670348	root		time:1m13.6s, loops:184596, cop_task: {num: 761, max: 2.85s, min: 277.7ms, avg: 1.66s, p95: 2.13s, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 19m48.7s, tot_wait: 1m1s, rpc_num: 761, rpc_time: 21m3.6s, copr_cache: disabled}	data:Selection_127	109.4 MB	N/A
20:47:58 [2021-05-31T20:47:58.151Z]       │ │ │   └─Selection_127	240004648.80	189670348	cop[tikv]		tikv_task:{proc max:1.59s, min:269ms, p80:1.32s, p95:1.39s, iters:296606, tasks:761}, scan_detail: {total_process_keys: 300005811, total_keys: 300006572, rocksdb: {delete_skipped_count: 0, key_skipped_count: 600010861, block: {cache_hit_count: 10456, read_count: 1114192, read_byte: 23.6 GB}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:47:58 [2021-05-31T20:47:58.151Z]       │ │ │     └─TableFullScan_126	300005811.00	300005811	cop[tikv]	table:l1	tikv_task:{proc max:1.48s, min:248ms, p80:1.24s, p95:1.31s, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:47:58 [2021-05-31T20:47:58.151Z]       │ │ └─TableReader_95(Probe)	0.49	3496203	root		time:1m43.3s, loops:3875, cop_task: {num: 5277, max: 615.6ms, min: 1.7ms, avg: 187.3ms, p95: 354.3ms, max_proc_keys: 3671, p95_proc_keys: 1965, tot_proc: 11m51.7s, tot_wait: 3m54.9s, rpc_num: 5277, rpc_time: 16m28.5s, copr_cache: disabled}	data:Selection_94	N/A	N/A
20:47:58 [2021-05-31T20:47:58.151Z]       │ │   └─Selection_94	0.49	3496203	cop[tikv]		tikv_task:{proc max:143ms, min:0s, p80:76ms, p95:90ms, iters:30226, tasks:5277}, scan_detail: {total_process_keys: 7236319, total_keys: 7795559, rocksdb: {delete_skipped_count: 0, key_skipped_count: 1778422, block: {cache_hit_count: 54006933, read_count: 218218, read_byte: 4.21 GB}}}	eq(tpch50.orders.o_orderstatus, "F")	N/A	N/A
20:47:58 [2021-05-31T20:47:58.151Z]       │ │     └─TableRangeScan_93	1.00	7236319	cop[tikv]	table:orders	tikv_task:{proc max:142ms, min:0s, p80:76ms, p95:90ms, iters:30226, tasks:5277}	range: decided by [tpch50.lineitem.l_orderkey], keep order:false	N/A	N/A
20:47:58 [2021-05-31T20:47:58.151Z]       │ └─IndexLookUp_80(Probe)	4.05	17316379	root		time:2m0.3s, loops:17135, index_task: {total_time: 1m6.7s, fetch_handle: 58.3s, build: 4.07ms, wait: 8.35s}, table_task: {total_time: 8m42s, num: 1458, concurrency: 760}		19.2 KB	N/A
20:47:58 [2021-05-31T20:47:58.151Z]       │   ├─IndexRangeScan_78(Build)	4.05	17316379	cop[tikv]	table:l2, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:56s, loops:18636, cop_task: {num: 2994, max: 663.4ms, min: 631.3µs, avg: 192ms, p95: 390.7ms, max_proc_keys: 13290, p95_proc_keys: 8765, tot_proc: 7m20.4s, tot_wait: 1m52.5s, rpc_num: 2994, rpc_time: 9m34.9s, copr_cache: disabled}, tikv_task:{proc max:190ms, min:0s, p80:108ms, p95:125ms, iters:30113, tasks:2994}, scan_detail: {total_process_keys: 17316379, total_keys: 20812469, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17316379, block: {cache_hit_count: 24259869, read_count: 225689, read_byte: 2.00 GB}}}	range: decided by [eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey)], keep order:false	N/A	N/A
20:47:58 [2021-05-31T20:47:58.151Z]       │   └─TableRowIDScan_79(Probe)	4.05	17316379	cop[tikv]	table:l2	time:6m29.3s, loops:21017, cop_task: {num: 7840, max: 707.8ms, min: 982.9µs, avg: 182.6ms, p95: 365.6ms, max_proc_keys: 12645, p95_proc_keys: 4796, tot_proc: 17m18.9s, tot_wait: 5m40.3s, rpc_num: 7840, rpc_time: 23m51.7s, copr_cache: disabled}, tikv_task:{proc max:275ms, min:0s, p80:111ms, p95:147ms, iters:50046, tasks:7840}, scan_detail: {total_process_keys: 17316379, total_keys: 18287224, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5621747, block: {cache_hit_count: 99019976, read_count: 1121, read_byte: 401.6 MB}}}	keep order:false	N/A	N/A
20:47:58 [2021-05-31T20:47:58.151Z]       └─IndexLookUp_39(Probe)	4.05	12022774	root		time:1m54.6s, loops:11948, index_task: {total_time: 1m1.8s, fetch_handle: 52.2s, build: 3.43ms, wait: 9.6s}, table_task: {total_time: 8m14.4s, num: 1410, concurrency: 735}		267.9 KB	N/A
20:47:58 [2021-05-31T20:47:58.151Z]         ├─IndexRangeScan_36(Build)	5.06	17183369	cop[tikv]	table:l3, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:49.8s, loops:18345, cop_task: {num: 2794, max: 726ms, min: 662.6µs, avg: 170.5ms, p95: 373.8ms, max_proc_keys: 17990, p95_proc_keys: 13637, tot_proc: 5m58.3s, tot_wait: 1m37.5s, rpc_num: 2794, rpc_time: 7m56.3s, copr_cache: disabled}, tikv_task:{proc max:194ms, min:0s, p80:82ms, p95:129ms, iters:29080, tasks:2794}, scan_detail: {total_process_keys: 17183369, total_keys: 20546392, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17183369, block: {cache_hit_count: 23553968, read_count: 0, read_byte: 0 Bytes}}}	range: decided by [eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey)], keep order:false	N/A	N/A
20:47:58 [2021-05-31T20:47:58.151Z]         └─Selection_38(Probe)	4.05	12022774	cop[tikv]		time:6m20.2s, loops:13793, cop_task: {num: 10179, max: 635.6ms, min: 426.2µs, avg: 176.8ms, p95: 361.7ms, max_proc_keys: 7036, p95_proc_keys: 3990, tot_proc: 21m15.5s, tot_wait: 7m36.1s, rpc_num: 10179, rpc_time: 29m59.3s, copr_cache: disabled}, tikv_task:{proc max:232ms, min:0s, p80:82ms, p95:123ms, iters:60528, tasks:10179}, scan_detail: {total_process_keys: 17183369, total_keys: 18129660, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5526821, block: {cache_hit_count: 98292803, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:47:58 [2021-05-31T20:47:58.151Z]           └─TableRowIDScan_37	5.06	17183369	cop[tikv]	table:l3	tikv_task:{proc max:232ms, min:0s, p80:81ms, p95:122ms, iters:60528, tasks:10179}	keep order:false	N/A	N/A
20:47:58 [2021-05-31T20:47:58.151Z] + sync
20:47:58 [2021-05-31T20:47:58.151Z] + /usr/bin/echo 3
20:49:26 [2021-05-31T20:49:26.020Z] 
20:49:26 [2021-05-31T20:49:26.020Z] queries/21.sql
20:49:26 [2021-05-31T20:49:26.020Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:49:26 [2021-05-31T20:49:26.020Z] Projection_26	100.00	100	root		time:1m21.2s, loops:2, Concurrency:OFF	tpch50.supplier.s_name, Column#72	4.62 KB	N/A
20:49:26 [2021-05-31T20:49:26.020Z] └─TopN_29	100.00	100	root		time:1m21.2s, loops:2	Column#72:desc, tpch50.supplier.s_name, offset:0, count:100	58.4 KB	N/A
20:49:26 [2021-05-31T20:49:26.020Z]   └─HashAgg_34	12800.00	20057	root		time:1m21.2s, loops:21, partial_worker:{wall_time:1m21.208497895s, concurrency:5, task_num:197, tot_wait:6m45.738899415s, tot_exec:287.262068ms, tot_time:6m46.039844626s, max:1m21.208467718s, p95:1m21.208467718s}, final_worker:{wall_time:1m21.221582091s, concurrency:5, task_num:25, tot_wait:6m46.037641617s, tot_exec:69.109244ms, tot_time:6m46.10676203s, max:1m21.221568571s, p95:1m21.221568571s}	group by:tpch50.supplier.s_name, funcs:count(1)->Column#72, funcs:firstrow(tpch50.supplier.s_name)->tpch50.supplier.s_name	17.2 MB	N/A
20:49:26 [2021-05-31T20:49:26.020Z]     └─IndexHashJoin_42	7828961.66	198698	root		time:1m21.2s, loops:198, inner:{total:2m19.8s, concurrency:5, task:147, construct:6.56s, fetch:1m56.1s, build:1.19s, join:17.1s}	anti semi join, inner:IndexLookUp_39, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey)	641.0 MB	N/A
20:49:26 [2021-05-31T20:49:26.020Z]       ├─IndexHashJoin_83(Build)	9786202.08	3542799	root		time:1m20.7s, loops:3464, inner:{total:2m28.3s, concurrency:5, task:152, construct:8s, fetch:2m2s, build:1.23s, join:18.3s}	semi join, inner:IndexLookUp_80, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey), ne(tpch50.lineitem.l_suppkey, tpch50.supplier.s_suppkey)	555.9 MB	N/A
20:49:26 [2021-05-31T20:49:26.020Z]       │ ├─IndexJoin_99(Build)	12232752.60	3675878	root		time:1m20.1s, loops:3595, inner:{total:2m8.2s, concurrency:5, task:305, construct:16.6s, fetch:1m49.7s, build:1.89s}, 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)	575.4 MB	N/A
20:49:26 [2021-05-31T20:49:26.020Z]       │ │ ├─HashJoin_107(Build)	12232752.60	7609895	root		time:1m19.6s, loops:7436, build_hash_table:{total:1.03s, fetch:1.02s, build:6.59ms}, probe:{concurrency:5, total:6m39.6s, max:1m19.9s, probe:1m2.1s, fetch:5m37.5s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.lineitem.l_suppkey)]	757.3 KB	0 Bytes
20:49:26 [2021-05-31T20:49:26.020Z]       │ │ │ ├─HashJoin_120(Build)	20000.00	20058	root		time:1.02s, loops:23, build_hash_table:{total:146.8µs, fetch:139.5µs, build:7.26µs}, probe:{concurrency:5, total:5.12s, max:1.02s, probe:59.6ms, fetch:5.06s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:49:26 [2021-05-31T20:49:26.020Z]       │ │ │ │ ├─TableReader_125(Build)	1.00	1	root		time:38.4µs, loops:2, cop_task: {num: 1, max: 1.36ms, proc_keys: 25, tot_proc: 1ms, rpc_num: 1, rpc_time: 1.32ms, copr_cache: disabled}	data:Selection_124	248 Bytes	N/A
20:49:26 [2021-05-31T20:49:26.020Z]       │ │ │ │ │ └─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:49:26 [2021-05-31T20:49:26.020Z]       │ │ │ │ │   └─TableFullScan_123	25.00	25	cop[tikv]	table:nation	tikv_task:{time:1ms, loops:1}	keep order:false	N/A	N/A
20:49:26 [2021-05-31T20:49:26.020Z]       │ │ │ │ └─TableReader_122(Probe)	500000.00	500000	root		time:1.01s, loops:490, cop_task: {num: 1, max: 1.01s, proc_keys: 500000, tot_proc: 984ms, rpc_num: 1, rpc_time: 1.01s, copr_cache: disabled}	data:TableFullScan_121	20.0 MB	N/A
20:49:26 [2021-05-31T20:49:26.020Z]       │ │ │ │   └─TableFullScan_121	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:931ms, 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:49:26 [2021-05-31T20:49:26.020Z]       │ │ │ └─TableReader_128(Probe)	240004648.80	189670348	root		time:1m7.1s, loops:184596, cop_task: {num: 761, max: 2.85s, min: 288.1ms, avg: 1.53s, p95: 1.99s, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 18m13s, tot_wait: 1m0.5s, rpc_num: 761, rpc_time: 19m26.7s, copr_cache: disabled}	data:Selection_127	109.4 MB	N/A
20:49:26 [2021-05-31T20:49:26.020Z]       │ │ │   └─Selection_127	240004648.80	189670348	cop[tikv]		tikv_task:{proc max:1.35s, min:275ms, p80:1.2s, 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: 10465, read_count: 1114183, read_byte: 23.6 GB}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:49:26 [2021-05-31T20:49:26.020Z]       │ │ │     └─TableFullScan_126	300005811.00	300005811	cop[tikv]	table:l1	tikv_task:{proc max:1.28s, min:261ms, p80:1.12s, p95:1.17s, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:49:26 [2021-05-31T20:49:26.020Z]       │ │ └─TableReader_95(Probe)	0.49	3496163	root		time:1m40.8s, loops:3875, cop_task: {num: 5247, max: 571.8ms, min: 1.32ms, avg: 179.3ms, p95: 338.2ms, max_proc_keys: 3588, p95_proc_keys: 1960, tot_proc: 11m17.1s, tot_wait: 3m42.1s, rpc_num: 5247, rpc_time: 15m40.9s, copr_cache: disabled}	data:Selection_94	N/A	N/A
20:49:26 [2021-05-31T20:49:26.020Z]       │ │   └─Selection_94	0.49	3496163	cop[tikv]		tikv_task:{proc max:159ms, min:0s, p80:70ms, p95:84ms, iters:30167, tasks:5247}, scan_detail: {total_process_keys: 7236263, total_keys: 7795516, rocksdb: {delete_skipped_count: 0, key_skipped_count: 1778433, block: {cache_hit_count: 54006154, read_count: 218244, read_byte: 4.21 GB}}}	eq(tpch50.orders.o_orderstatus, "F")	N/A	N/A
20:49:26 [2021-05-31T20:49:26.020Z]       │ │     └─TableRangeScan_93	1.00	7236263	cop[tikv]	table:orders	tikv_task:{proc max:157ms, min:0s, p80:70ms, p95:83ms, iters:30167, tasks:5247}	range: decided by [tpch50.lineitem.l_orderkey], keep order:false	N/A	N/A
20:49:26 [2021-05-31T20:49:26.020Z]       │ └─IndexLookUp_80(Probe)	4.05	17316437	root		time:1m56.2s, loops:17128, index_task: {total_time: 1m3.2s, fetch_handle: 53.6s, build: 3.36ms, wait: 9.57s}, table_task: {total_time: 8m25s, num: 1458, concurrency: 760}		19.1 KB	N/A
20:49:26 [2021-05-31T20:49:26.020Z]       │   ├─IndexRangeScan_78(Build)	4.05	17316437	cop[tikv]	table:l2, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:51.3s, loops:18603, cop_task: {num: 2984, max: 602ms, min: 480.1µs, avg: 185.5ms, p95: 369.7ms, max_proc_keys: 11789, p95_proc_keys: 8775, tot_proc: 6m55.7s, tot_wait: 1m55.8s, rpc_num: 2984, rpc_time: 9m13.3s, copr_cache: disabled}, tikv_task:{proc max:159ms, min:0s, p80:98ms, p95:116ms, iters:30042, tasks:2984}, scan_detail: {total_process_keys: 17316437, total_keys: 20812536, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17316437, block: {cache_hit_count: 24259941, read_count: 225681, read_byte: 2.00 GB}}}	range: decided by [eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey)], keep order:false	N/A	N/A
20:49:26 [2021-05-31T20:49:26.020Z]       │   └─TableRowIDScan_79(Probe)	4.05	17316437	cop[tikv]	table:l2	time:6m15.6s, loops:20985, cop_task: {num: 7817, max: 623.7ms, min: 506µs, avg: 176.7ms, p95: 357.5ms, max_proc_keys: 12919, p95_proc_keys: 4828, tot_proc: 16m32.8s, tot_wait: 5m37.8s, rpc_num: 7817, rpc_time: 23m1.3s, copr_cache: disabled}, tikv_task:{proc max:239ms, min:0s, p80:105ms, p95:140ms, iters:50056, tasks:7817}, scan_detail: {total_process_keys: 17316437, total_keys: 18290704, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5633483, block: {cache_hit_count: 99018925, read_count: 1111, read_byte: 385.3 MB}}}	keep order:false	N/A	N/A
20:49:26 [2021-05-31T20:49:26.020Z]       └─IndexLookUp_39(Probe)	4.05	12022767	root		time:1m51s, loops:11954, index_task: {total_time: 1m0.2s, fetch_handle: 49.7s, build: 4.49ms, wait: 10.5s}, table_task: {total_time: 8m2s, num: 1410, concurrency: 735}		218.9 KB	N/A
20:49:26 [2021-05-31T20:49:26.020Z]         ├─IndexRangeScan_36(Build)	5.06	17183352	cop[tikv]	table:l3, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:47.2s, loops:18337, cop_task: {num: 2763, max: 862.3ms, min: 681µs, avg: 170.7ms, p95: 366.4ms, max_proc_keys: 17248, p95_proc_keys: 13730, tot_proc: 5m47s, tot_wait: 1m43.2s, rpc_num: 2763, rpc_time: 7m51.6s, copr_cache: disabled}, tikv_task:{proc max:180ms, min:0s, p80:78ms, p95:121ms, iters:28978, tasks:2763}, scan_detail: {total_process_keys: 17183352, total_keys: 20546371, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17183352, block: {cache_hit_count: 23553941, read_count: 0, read_byte: 0 Bytes}}}	range: decided by [eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey)], keep order:false	N/A	N/A
20:49:26 [2021-05-31T20:49:26.020Z]         └─Selection_38(Probe)	4.05	12022767	cop[tikv]		time:6m8.8s, loops:13779, cop_task: {num: 10188, max: 646.2ms, min: 417.2µs, avg: 171.5ms, p95: 341.1ms, max_proc_keys: 7626, p95_proc_keys: 3970, tot_proc: 20m29.7s, tot_wait: 7m30.7s, rpc_num: 10188, rpc_time: 29m7.4s, copr_cache: disabled}, tikv_task:{proc max:218ms, min:0s, p80:77ms, p95:118ms, iters:60459, tasks:10188}, scan_detail: {total_process_keys: 17183352, total_keys: 18130001, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5529611, block: {cache_hit_count: 98289266, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:49:26 [2021-05-31T20:49:26.020Z]           └─TableRowIDScan_37	5.06	17183352	cop[tikv]	table:l3	tikv_task:{proc max:216ms, min:0s, p80:76ms, p95:117ms, iters:60459, tasks:10188}	keep order:false	N/A	N/A
20:49:26 [2021-05-31T20:49:26.020Z] + sync
20:49:26 [2021-05-31T20:49:26.020Z] + /usr/bin/echo 3
20:51:02 [2021-05-31T20:51:02.996Z] 
20:51:02 [2021-05-31T20:51:02.996Z] queries/21.sql
20:51:02 [2021-05-31T20:51:02.996Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:51:02 [2021-05-31T20:51:02.996Z] Projection_26	100.00	100	root		time:1m21.2s, loops:2, Concurrency:OFF	tpch50.supplier.s_name, Column#72	4.62 KB	N/A
20:51:02 [2021-05-31T20:51:02.996Z] └─TopN_29	100.00	100	root		time:1m21.2s, loops:2	Column#72:desc, tpch50.supplier.s_name, offset:0, count:100	58.4 KB	N/A
20:51:02 [2021-05-31T20:51:02.996Z]   └─HashAgg_34	12800.00	20057	root		time:1m21.2s, loops:21, partial_worker:{wall_time:1m21.155764847s, concurrency:5, task_num:196, tot_wait:6m45.514284316s, tot_exec:250.735481ms, tot_time:6m45.777121233s, max:1m21.15574386s, p95:1m21.15574386s}, final_worker:{wall_time:1m21.169098582s, concurrency:5, task_num:25, tot_wait:6m45.776111076s, tot_exec:68.045225ms, tot_time:6m45.844167835s, max:1m21.169084322s, p95:1m21.169084322s}	group by:tpch50.supplier.s_name, funcs:count(1)->Column#72, funcs:firstrow(tpch50.supplier.s_name)->tpch50.supplier.s_name	17.2 MB	N/A
20:51:02 [2021-05-31T20:51:02.996Z]     └─IndexHashJoin_42	7828961.66	198698	root		time:1m21.2s, loops:197, inner:{total:2m19.8s, concurrency:5, task:146, construct:6.59s, fetch:1m56.8s, build:1.25s, join:16.4s}	anti semi join, inner:IndexLookUp_39, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey)	641.1 MB	N/A
20:51:02 [2021-05-31T20:51:02.996Z]       ├─IndexHashJoin_83(Build)	9786202.08	3542799	root		time:1m20.6s, loops:3463, inner:{total:2m25.7s, concurrency:5, task:152, construct:7.97s, fetch:1m59.9s, build:1.23s, join:17.8s}	semi join, inner:IndexLookUp_80, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey), ne(tpch50.lineitem.l_suppkey, tpch50.supplier.s_suppkey)	555.9 MB	N/A
20:51:02 [2021-05-31T20:51:02.996Z]       │ ├─IndexJoin_99(Build)	12232752.60	3675878	root		time:1m20.1s, loops:3595, inner:{total:2m5.2s, concurrency:5, task:305, construct:16.7s, fetch:1m46.6s, build:1.91s}, probe:5.08s	inner join, inner:TableReader_95, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.orders.o_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.orders.o_orderkey)	575.4 MB	N/A
20:51:02 [2021-05-31T20:51:02.997Z]       │ │ ├─HashJoin_107(Build)	12232752.60	7609895	root		time:1m19.6s, loops:7435, build_hash_table:{total:1.05s, fetch:1.05s, build:6.68ms}, probe:{concurrency:5, total:6m39.9s, max:1m20s, probe:1m1.6s, fetch:5m38.3s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.lineitem.l_suppkey)]	762.0 KB	0 Bytes
20:51:02 [2021-05-31T20:51:02.997Z]       │ │ │ ├─HashJoin_120(Build)	20000.00	20058	root		time:1.05s, loops:23, build_hash_table:{total:171µs, fetch:165.8µs, build:5.19µs}, probe:{concurrency:5, total:5.26s, max:1.05s, probe:61.9ms, fetch:5.2s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:51:02 [2021-05-31T20:51:02.997Z]       │ │ │ │ ├─TableReader_125(Build)	1.00	1	root		time:40.7µs, loops:2, cop_task: {num: 1, max: 1.24ms, proc_keys: 25, rpc_num: 1, rpc_time: 1.21ms, copr_cache: disabled}	data:Selection_124	240 Bytes	N/A
20:51:02 [2021-05-31T20:51:02.997Z]       │ │ │ │ │ └─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:02 [2021-05-31T20:51:02.997Z]       │ │ │ │ │   └─TableFullScan_123	25.00	25	cop[tikv]	table:nation	tikv_task:{time:0s, loops:1}	keep order:false	N/A	N/A
20:51:02 [2021-05-31T20:51:02.997Z]       │ │ │ │ └─TableReader_122(Probe)	500000.00	500000	root		time:1.04s, loops:490, cop_task: {num: 1, max: 1.04s, proc_keys: 500000, tot_proc: 1.01s, rpc_num: 1, rpc_time: 1.04s, copr_cache: disabled}	data:TableFullScan_121	20.0 MB	N/A
20:51:02 [2021-05-31T20:51:02.997Z]       │ │ │ │   └─TableFullScan_121	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:940ms, loops:493}, scan_detail: {total_process_keys: 500000, total_keys: 500001, rocksdb: {delete_skipped_count: 0, key_skipped_count: 999999, block: {cache_hit_count: 13, read_count: 1679, read_byte: 104.5 MB}}}	keep order:false	N/A	N/A
20:51:02 [2021-05-31T20:51:02.997Z]       │ │ │ └─TableReader_128(Probe)	240004648.80	189670348	root		time:1m7.1s, loops:184597, cop_task: {num: 761, max: 2.62s, min: 257.1ms, avg: 1.54s, p95: 2.03s, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 18m17.5s, tot_wait: 58.9s, rpc_num: 761, rpc_time: 19m29.7s, copr_cache: disabled}	data:Selection_127	109.4 MB	N/A
20:51:02 [2021-05-31T20:51:02.997Z]       │ │ │   └─Selection_127	240004648.80	189670348	cop[tikv]		tikv_task:{proc max:1.48s, min:245ms, p80:1.19s, p95:1.27s, iters:296606, tasks:761}, scan_detail: {total_process_keys: 300005811, total_keys: 300006572, rocksdb: {delete_skipped_count: 0, key_skipped_count: 600010861, block: {cache_hit_count: 10458, read_count: 1114190, read_byte: 23.6 GB}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:51:02 [2021-05-31T20:51:02.997Z]       │ │ │     └─TableFullScan_126	300005811.00	300005811	cop[tikv]	table:l1	tikv_task:{proc max:1.39s, min:233ms, p80:1.11s, p95:1.19s, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:51:02 [2021-05-31T20:51:02.997Z]       │ │ └─TableReader_95(Probe)	0.49	3496180	root		time:1m37.2s, loops:3875, cop_task: {num: 5273, max: 557.4ms, min: 2.03ms, avg: 173.2ms, p95: 335.6ms, max_proc_keys: 3372, p95_proc_keys: 1961, tot_proc: 10m56.7s, tot_wait: 3m36.6s, rpc_num: 5273, rpc_time: 15m13.1s, copr_cache: disabled}	data:Selection_94	N/A	N/A
20:51:02 [2021-05-31T20:51:02.997Z]       │ │   └─Selection_94	0.49	3496180	cop[tikv]		tikv_task:{proc max:141ms, min:0s, p80:70ms, p95:83ms, iters:30204, tasks:5273}, scan_detail: {total_process_keys: 7236268, total_keys: 7795489, rocksdb: {delete_skipped_count: 0, key_skipped_count: 1778347, block: {cache_hit_count: 54006200, read_count: 218255, read_byte: 4.21 GB}}}	eq(tpch50.orders.o_orderstatus, "F")	N/A	N/A
20:51:02 [2021-05-31T20:51:02.997Z]       │ │     └─TableRangeScan_93	1.00	7236268	cop[tikv]	table:orders	tikv_task:{proc max:138ms, min:0s, p80:69ms, p95:82ms, iters:30204, tasks:5273}	range: decided by [tpch50.lineitem.l_orderkey], keep order:false	N/A	N/A
20:51:02 [2021-05-31T20:51:02.997Z]       │ └─IndexLookUp_80(Probe)	4.05	17316448	root		time:1m54.2s, loops:17123, index_task: {total_time: 1m3.7s, fetch_handle: 56.1s, build: 3.34ms, wait: 7.62s}, table_task: {total_time: 8m13.4s, num: 1458, concurrency: 760}		19.3 KB	N/A
20:51:02 [2021-05-31T20:51:02.997Z]       │   ├─IndexRangeScan_78(Build)	4.05	17316448	cop[tikv]	table:l2, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:53.8s, loops:18607, cop_task: {num: 2981, max: 693.2ms, min: 366.2µs, avg: 182.5ms, p95: 368.9ms, max_proc_keys: 13004, p95_proc_keys: 8742, tot_proc: 6m52.7s, tot_wait: 1m49.7s, rpc_num: 2981, rpc_time: 9m3.9s, copr_cache: disabled}, tikv_task:{proc max:146ms, min:0s, p80:97ms, p95:113ms, iters:30037, tasks:2981}, scan_detail: {total_process_keys: 17316448, total_keys: 20812550, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17316448, block: {cache_hit_count: 24259952, read_count: 225689, read_byte: 2.00 GB}}}	range: decided by [eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey)], keep order:false	N/A	N/A
20:51:03 [2021-05-31T20:51:03.002Z]       │   └─TableRowIDScan_79(Probe)	4.05	17316448	cop[tikv]	table:l2	time:6m5.3s, loops:21021, cop_task: {num: 7823, max: 863.5ms, min: 439µs, avg: 173.5ms, p95: 351.7ms, max_proc_keys: 13852, p95_proc_keys: 4840, tot_proc: 16m16.7s, tot_wait: 5m30s, rpc_num: 7823, rpc_time: 22m37.2s, copr_cache: disabled}, tikv_task:{proc max:250ms, min:0s, p80:103ms, p95:139ms, iters:50064, tasks:7823}, scan_detail: {total_process_keys: 17316448, total_keys: 18290068, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5632610, block: {cache_hit_count: 99014120, read_count: 1118, read_byte: 399.7 MB}}}	keep order:false	N/A	N/A
20:51:03 [2021-05-31T20:51:03.002Z]       └─IndexLookUp_39(Probe)	4.05	12022808	root		time:1m51.9s, loops:11949, index_task: {total_time: 1m0.8s, fetch_handle: 48.8s, build: 3.5ms, wait: 11.9s}, table_task: {total_time: 8m0.1s, num: 1408, concurrency: 730}		219.1 KB	N/A
20:51:03 [2021-05-31T20:51:03.002Z]         ├─IndexRangeScan_36(Build)	5.06	17183398	cop[tikv]	table:l3, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:46.5s, loops:18332, cop_task: {num: 2756, max: 715.2ms, min: 2.04ms, avg: 162.9ms, p95: 346.5ms, max_proc_keys: 18266, p95_proc_keys: 13645, tot_proc: 5m36.2s, tot_wait: 1m32.6s, rpc_num: 2756, rpc_time: 7m28.8s, copr_cache: disabled}, tikv_task:{proc max:178ms, min:0s, p80:80ms, p95:121ms, iters:28958, tasks:2756}, scan_detail: {total_process_keys: 17183398, total_keys: 20546427, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17183398, block: {cache_hit_count: 23554009, 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:03 [2021-05-31T20:51:03.002Z]         └─Selection_38(Probe)	4.05	12022808	cop[tikv]		time:6m10.6s, loops:13763, cop_task: {num: 10270, max: 717.2ms, min: 450.8µs, avg: 172.5ms, p95: 349.7ms, max_proc_keys: 6647, p95_proc_keys: 3908, tot_proc: 20m47.3s, tot_wait: 7m39s, rpc_num: 10270, rpc_time: 29m31.8s, copr_cache: disabled}, tikv_task:{proc max:241ms, min:0s, p80:77ms, p95:113ms, iters:60880, tasks:10270}, scan_detail: {total_process_keys: 17183398, total_keys: 18127949, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5521351, block: {cache_hit_count: 98295465, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:51:03 [2021-05-31T20:51:03.002Z]           └─TableRowIDScan_37	5.06	17183398	cop[tikv]	table:l3	tikv_task:{proc max:239ms, min:0s, p80:76ms, p95:113ms, iters:60880, tasks:10270}	keep order:false	N/A	N/A
20:51:03 [2021-05-31T20:51:03.002Z] + sync
20:51:03 [2021-05-31T20:51:03.002Z] + /usr/bin/echo 3
20:52:20 [2021-05-31T20:52:20.623Z] 
20:52:20 [2021-05-31T20:52:20.623Z] queries/21.sql
20:52:20 [2021-05-31T20:52:20.623Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:52:20 [2021-05-31T20:52:20.623Z] Projection_26	100.00	100	root		time:1m19.6s, loops:2, Concurrency:OFF	tpch50.supplier.s_name, Column#72	4.62 KB	N/A
20:52:20 [2021-05-31T20:52:20.623Z] └─TopN_29	100.00	100	root		time:1m19.6s, loops:2	Column#72:desc, tpch50.supplier.s_name, offset:0, count:100	58.4 KB	N/A
20:52:20 [2021-05-31T20:52:20.623Z]   └─HashAgg_34	12800.00	20057	root		time:1m19.6s, loops:21, partial_worker:{wall_time:1m19.56603934s, concurrency:5, task_num:197, tot_wait:6m37.537059584s, tot_exec:279.518778ms, tot_time:6m37.829054371s, max:1m19.56599835s, p95:1m19.56599835s}, final_worker:{wall_time:1m19.579131639s, concurrency:5, task_num:25, tot_wait:6m37.828330611s, tot_exec:66.242046ms, tot_time:6m37.89458608s, max:1m19.579106155s, p95:1m19.579106155s}	group by:tpch50.supplier.s_name, funcs:count(1)->Column#72, funcs:firstrow(tpch50.supplier.s_name)->tpch50.supplier.s_name	17.2 MB	N/A
20:52:20 [2021-05-31T20:52:20.623Z]     └─IndexHashJoin_42	7828961.66	198698	root		time:1m19.6s, loops:198, inner:{total:2m17.6s, concurrency:5, task:147, construct:6.7s, fetch:1m54.4s, build:1.21s, join:16.5s}	anti semi join, inner:IndexLookUp_39, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey)	641.1 MB	N/A
20:52:20 [2021-05-31T20:52:20.623Z]       ├─IndexHashJoin_83(Build)	9786202.08	3542799	root		time:1m19s, loops:3464, inner:{total:2m28.1s, concurrency:5, task:152, construct:7.81s, fetch:2m2s, build:1.2s, join:18.3s}	semi join, inner:IndexLookUp_80, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey), ne(tpch50.lineitem.l_suppkey, tpch50.supplier.s_suppkey)	555.9 MB	N/A
20:52:20 [2021-05-31T20:52:20.623Z]       │ ├─IndexJoin_99(Build)	12232752.60	3675878	root		time:1m18.6s, loops:3595, inner:{total:2m4.2s, concurrency:5, task:305, construct:16.7s, fetch:1m45.7s, build:1.9s}, probe:5.27s	inner join, inner:TableReader_95, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.orders.o_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.orders.o_orderkey)	575.3 MB	N/A
20:52:20 [2021-05-31T20:52:20.623Z]       │ │ ├─HashJoin_107(Build)	12232752.60	7609895	root		time:1m18.1s, loops:7436, build_hash_table:{total:979ms, fetch:972.4ms, build:6.62ms}, probe:{concurrency:5, total:6m32.1s, max:1m18.4s, probe:1m2s, fetch:5m30.2s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.lineitem.l_suppkey)]	732.8 KB	0 Bytes
20:52:20 [2021-05-31T20:52:20.623Z]       │ │ │ ├─HashJoin_120(Build)	20000.00	20058	root		time:975.6ms, loops:22, build_hash_table:{total:143µs, fetch:134.6µs, build:8.4µs}, probe:{concurrency:5, total:4.89s, max:977.2ms, probe:62.6ms, fetch:4.82s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:52:20 [2021-05-31T20:52:20.623Z]       │ │ │ │ ├─TableReader_125(Build)	1.00	1	root		time:43.8µs, loops:2, cop_task: {num: 1, max: 1.29ms, proc_keys: 25, tot_proc: 1ms, rpc_num: 1, rpc_time: 1.28ms, copr_cache: disabled}	data:Selection_124	248 Bytes	N/A
20:52:20 [2021-05-31T20:52:20.623Z]       │ │ │ │ │ └─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:20 [2021-05-31T20:52:20.623Z]       │ │ │ │ │   └─TableFullScan_123	25.00	25	cop[tikv]	table:nation	tikv_task:{time:1ms, loops:1}	keep order:false	N/A	N/A
20:52:20 [2021-05-31T20:52:20.623Z]       │ │ │ │ └─TableReader_122(Probe)	500000.00	500000	root		time:964.4ms, loops:490, cop_task: {num: 1, max: 965.2ms, proc_keys: 500000, tot_proc: 931ms, rpc_num: 1, rpc_time: 965.1ms, copr_cache: disabled}	data:TableFullScan_121	20.0 MB	N/A
20:52:20 [2021-05-31T20:52:20.623Z]       │ │ │ │   └─TableFullScan_121	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:876ms, 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:20 [2021-05-31T20:52:20.623Z]       │ │ │ └─TableReader_128(Probe)	240004648.80	189670348	root		time:1m5.6s, loops:184597, cop_task: {num: 761, max: 2.54s, min: 243ms, avg: 1.5s, p95: 1.98s, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 17m51.5s, tot_wait: 59.5s, rpc_num: 761, rpc_time: 19m4.2s, copr_cache: disabled}	data:Selection_127	106.9 MB	N/A
20:52:20 [2021-05-31T20:52:20.623Z]       │ │ │   └─Selection_127	240004648.80	189670348	cop[tikv]		tikv_task:{proc max:1.32s, min:228ms, p80:1.16s, p95:1.21s, iters:296606, tasks:761}, scan_detail: {total_process_keys: 300005811, total_keys: 300006572, rocksdb: {delete_skipped_count: 0, key_skipped_count: 600010861, block: {cache_hit_count: 10453, read_count: 1114195, read_byte: 23.6 GB}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:52:20 [2021-05-31T20:52:20.623Z]       │ │ │     └─TableFullScan_126	300005811.00	300005811	cop[tikv]	table:l1	tikv_task:{proc max:1.25s, min:218ms, p80:1.08s, p95:1.13s, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:52:20 [2021-05-31T20:52:20.623Z]       │ │ └─TableReader_95(Probe)	0.49	3496191	root		time:1m36.5s, loops:3875, cop_task: {num: 5253, max: 555.1ms, min: 643.2µs, avg: 174.6ms, p95: 323.3ms, max_proc_keys: 3859, p95_proc_keys: 1950, tot_proc: 10m57s, tot_wait: 3m41.5s, rpc_num: 5253, rpc_time: 15m16.9s, copr_cache: disabled}	data:Selection_94	N/A	N/A
20:52:20 [2021-05-31T20:52:20.623Z]       │ │   └─Selection_94	0.49	3496191	cop[tikv]		tikv_task:{proc max:138ms, min:0s, p80:68ms, p95:81ms, iters:30222, tasks:5253}, scan_detail: {total_process_keys: 7236291, total_keys: 7795483, rocksdb: {delete_skipped_count: 0, key_skipped_count: 1778260, block: {cache_hit_count: 54006803, read_count: 217653, read_byte: 4.20 GB}}}	eq(tpch50.orders.o_orderstatus, "F")	N/A	N/A
20:52:20 [2021-05-31T20:52:20.623Z]       │ │     └─TableRangeScan_93	1.00	7236291	cop[tikv]	table:orders	tikv_task:{proc max:136ms, min:0s, p80:68ms, p95:81ms, iters:30222, tasks:5253}	range: decided by [tpch50.lineitem.l_orderkey], keep order:false	N/A	N/A
20:52:20 [2021-05-31T20:52:20.623Z]       │ └─IndexLookUp_80(Probe)	4.05	17316505	root		time:1m56.2s, loops:17127, index_task: {total_time: 1m4.8s, fetch_handle: 57s, build: 3.44ms, wait: 7.76s}, table_task: {total_time: 8m22.7s, num: 1458, concurrency: 760}		19.2 KB	N/A
20:52:20 [2021-05-31T20:52:20.623Z]       │   ├─IndexRangeScan_78(Build)	4.05	17316505	cop[tikv]	table:l2, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:54.7s, loops:18623, cop_task: {num: 2988, max: 765.6ms, min: 518.6µs, avg: 183.7ms, p95: 381ms, max_proc_keys: 13386, p95_proc_keys: 8729, tot_proc: 6m54.2s, tot_wait: 1m52.9s, rpc_num: 2988, rpc_time: 9m8.9s, copr_cache: disabled}, tikv_task:{proc max:188ms, min:0s, p80:94ms, p95:109ms, iters:30128, tasks:2988}, scan_detail: {total_process_keys: 17316505, total_keys: 20812614, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17316505, block: {cache_hit_count: 24260009, read_count: 225681, read_byte: 2.00 GB}}}	range: decided by [eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey)], keep order:false	N/A	N/A
20:52:20 [2021-05-31T20:52:20.623Z]       │   └─TableRowIDScan_79(Probe)	4.05	17316505	cop[tikv]	table:l2	time:6m12.6s, loops:20989, cop_task: {num: 7780, max: 629.2ms, min: 645.4µs, avg: 175.3ms, p95: 354.1ms, max_proc_keys: 12684, p95_proc_keys: 4873, tot_proc: 16m21s, tot_wait: 5m34.3s, rpc_num: 7780, rpc_time: 22m43.9s, copr_cache: disabled}, tikv_task:{proc max:267ms, min:0s, p80:103ms, p95:139ms, iters:49853, tasks:7780}, scan_detail: {total_process_keys: 17316505, total_keys: 18289581, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5629582, block: {cache_hit_count: 99015491, read_count: 1114, read_byte: 398.7 MB}}}	keep order:false	N/A	N/A
20:52:20 [2021-05-31T20:52:20.623Z]       └─IndexLookUp_39(Probe)	4.05	12022793	root		time:1m49.5s, loops:11945, index_task: {total_time: 59.7s, fetch_handle: 49.5s, build: 3.26ms, wait: 10.1s}, table_task: {total_time: 7m52.7s, num: 1410, concurrency: 735}		224.2 KB	N/A
20:52:20 [2021-05-31T20:52:20.623Z]         ├─IndexRangeScan_36(Build)	5.06	17183367	cop[tikv]	table:l3, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:47.2s, loops:18347, cop_task: {num: 2769, max: 716.2ms, min: 612.4µs, avg: 166.9ms, p95: 357.1ms, max_proc_keys: 23103, p95_proc_keys: 13833, tot_proc: 5m41.9s, tot_wait: 1m39.5s, rpc_num: 2769, rpc_time: 7m42.1s, copr_cache: disabled}, tikv_task:{proc max:194ms, min:0s, p80:78ms, p95:120ms, iters:29038, tasks:2769}, scan_detail: {total_process_keys: 17183367, total_keys: 20546387, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17183367, block: {cache_hit_count: 23553946, read_count: 0, read_byte: 0 Bytes}}}	range: decided by [eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey)], keep order:false	N/A	N/A
20:52:20 [2021-05-31T20:52:20.623Z]         └─Selection_38(Probe)	4.05	12022793	cop[tikv]		time:6m1.3s, loops:13800, cop_task: {num: 10354, max: 607.5ms, min: 428.8µs, avg: 167.8ms, p95: 335.1ms, max_proc_keys: 7028, p95_proc_keys: 3870, tot_proc: 20m12.9s, tot_wait: 7m40.5s, rpc_num: 10354, rpc_time: 28m57.5s, copr_cache: disabled}, tikv_task:{proc max:228ms, min:0s, p80:74ms, p95:110ms, iters:61272, tasks:10354}, scan_detail: {total_process_keys: 17183367, total_keys: 18126614, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5517055, block: {cache_hit_count: 98296985, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:52:20 [2021-05-31T20:52:20.623Z]           └─TableRowIDScan_37	5.06	17183367	cop[tikv]	table:l3	tikv_task:{proc max:226ms, min:0s, p80:74ms, p95:109ms, iters:61272, tasks:10354}	keep order:false	N/A	N/A
20:52:20 [2021-05-31T20:52:20.623Z] + sync
20:52:20 [2021-05-31T20:52:20.623Z] + /usr/bin/echo 3
20:53:40 [2021-05-31T20:53:40.186Z] 
20:53:40 [2021-05-31T20:53:40.186Z] queries/21.sql
20:53:40 [2021-05-31T20:53:40.186Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:53:40 [2021-05-31T20:53:40.186Z] Projection_26	100.00	100	root		time:1m19.6s, loops:2, Concurrency:OFF	tpch50.supplier.s_name, Column#72	4.62 KB	N/A
20:53:40 [2021-05-31T20:53:40.186Z] └─TopN_29	100.00	100	root		time:1m19.6s, loops:2	Column#72:desc, tpch50.supplier.s_name, offset:0, count:100	58.4 KB	N/A
20:53:40 [2021-05-31T20:53:40.186Z]   └─HashAgg_34	12800.00	20057	root		time:1m19.6s, loops:21, partial_worker:{wall_time:1m19.604585278s, concurrency:5, task_num:198, tot_wait:6m37.744627317s, tot_exec:262.273065ms, tot_time:6m38.020498021s, max:1m19.60454646s, p95:1m19.60454646s}, final_worker:{wall_time:1m19.617322235s, concurrency:5, task_num:25, tot_wait:6m38.019478605s, tot_exec:66.312064ms, tot_time:6m38.085802214s, max:1m19.61729111s, p95:1m19.61729111s}	group by:tpch50.supplier.s_name, funcs:count(1)->Column#72, funcs:firstrow(tpch50.supplier.s_name)->tpch50.supplier.s_name	17.2 MB	N/A
20:53:40 [2021-05-31T20:53:40.186Z]     └─IndexHashJoin_42	7828961.66	198698	root		time:1m19.6s, loops:199, inner:{total:2m16.8s, concurrency:5, task:146, construct:6.67s, fetch:1m53.5s, build:1.19s, join:16.6s}	anti semi join, inner:IndexLookUp_39, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey)	641.1 MB	N/A
20:53:40 [2021-05-31T20:53:40.186Z]       ├─IndexHashJoin_83(Build)	9786202.08	3542799	root		time:1m19.1s, loops:3462, inner:{total:2m26.8s, concurrency:5, task:152, construct:8.14s, fetch:2m0.4s, build:1.28s, 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:53:40 [2021-05-31T20:53:40.186Z]       │ ├─IndexJoin_99(Build)	12232752.60	3675878	root		time:1m18.5s, loops:3595, inner:{total:2m5.9s, concurrency:5, task:305, construct:16.7s, fetch:1m47.3s, build:1.86s}, probe:5.14s	inner join, inner:TableReader_95, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.orders.o_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.orders.o_orderkey)	575.3 MB	N/A
20:53:40 [2021-05-31T20:53:40.186Z]       │ │ ├─HashJoin_107(Build)	12232752.60	7609895	root		time:1m18s, loops:7435, build_hash_table:{total:996.4ms, fetch:990.1ms, build:6.23ms}, probe:{concurrency:5, total:6m31.9s, max:1m18.4s, probe:1m1s, fetch:5m30.9s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.lineitem.l_suppkey)]	762.0 KB	0 Bytes
20:53:40 [2021-05-31T20:53:40.186Z]       │ │ │ ├─HashJoin_120(Build)	20000.00	20058	root		time:992.4ms, loops:23, build_hash_table:{total:214.9µs, fetch:207.3µs, build:7.6µs}, probe:{concurrency:5, total:4.97s, max:994.5ms, probe:61ms, fetch:4.91s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:53:40 [2021-05-31T20:53:40.186Z]       │ │ │ │ ├─TableReader_125(Build)	1.00	1	root		time:58.3µs, loops:2, cop_task: {num: 1, max: 1.45ms, proc_keys: 25, rpc_num: 1, rpc_time: 1.42ms, copr_cache: disabled}	data:Selection_124	244 Bytes	N/A
20:53:40 [2021-05-31T20:53:40.186Z]       │ │ │ │ │ └─Selection_124	1.00	1	cop[tikv]		tikv_task:{time:0s, loops:1}, scan_detail: {total_process_keys: 25, total_keys: 26, rocksdb: {delete_skipped_count: 0, key_skipped_count: 46, block: {cache_hit_count: 17, read_count: 1, read_byte: 23.8 KB}}}	eq(tpch50.nation.n_name, "EGYPT")	N/A	N/A
20:53:40 [2021-05-31T20:53:40.186Z]       │ │ │ │ │   └─TableFullScan_123	25.00	25	cop[tikv]	table:nation	tikv_task:{time:0s, loops:1}	keep order:false	N/A	N/A
20:53:40 [2021-05-31T20:53:40.186Z]       │ │ │ │ └─TableReader_122(Probe)	500000.00	500000	root		time:982.1ms, loops:490, cop_task: {num: 1, max: 982.9ms, proc_keys: 500000, tot_proc: 949ms, rpc_num: 1, rpc_time: 982.9ms, copr_cache: disabled}	data:TableFullScan_121	20.0 MB	N/A
20:53:40 [2021-05-31T20:53:40.186Z]       │ │ │ │   └─TableFullScan_121	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:896ms, loops:493}, scan_detail: {total_process_keys: 500000, total_keys: 500001, rocksdb: {delete_skipped_count: 0, key_skipped_count: 999999, block: {cache_hit_count: 13, read_count: 1679, read_byte: 104.5 MB}}}	keep order:false	N/A	N/A
20:53:40 [2021-05-31T20:53:40.186Z]       │ │ │ └─TableReader_128(Probe)	240004648.80	189670348	root		time:1m5.8s, loops:184598, cop_task: {num: 761, max: 2.74s, min: 323.5ms, avg: 1.51s, p95: 1.94s, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 17m53.6s, tot_wait: 59.1s, rpc_num: 761, rpc_time: 19m6s, copr_cache: disabled}	data:Selection_127	109.4 MB	N/A
20:53:40 [2021-05-31T20:53:40.186Z]       │ │ │   └─Selection_127	240004648.80	189670348	cop[tikv]		tikv_task:{proc max:1.32s, min:308ms, p80:1.16s, p95:1.21s, iters:296606, tasks:761}, scan_detail: {total_process_keys: 300005811, total_keys: 300006572, rocksdb: {delete_skipped_count: 0, key_skipped_count: 600010861, block: {cache_hit_count: 10453, read_count: 1114195, read_byte: 23.6 GB}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:53:40 [2021-05-31T20:53:40.186Z]       │ │ │     └─TableFullScan_126	300005811.00	300005811	cop[tikv]	table:l1	tikv_task:{proc max:1.22s, min:282ms, p80:1.08s, p95:1.13s, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:53:40 [2021-05-31T20:53:40.186Z]       │ │ └─TableReader_95(Probe)	0.49	3496170	root		time:1m38.1s, loops:3875, cop_task: {num: 5281, max: 648.7ms, min: 718.3µs, avg: 175.2ms, p95: 332.1ms, max_proc_keys: 3597, p95_proc_keys: 1962, tot_proc: 10m59.8s, tot_wait: 3m45.5s, rpc_num: 5281, rpc_time: 15m25.1s, copr_cache: disabled}	data:Selection_94	N/A	N/A
20:53:40 [2021-05-31T20:53:40.186Z]       │ │   └─Selection_94	0.49	3496170	cop[tikv]		tikv_task:{proc max:140ms, min:0s, p80:68ms, p95:81ms, iters:30309, tasks:5281}, scan_detail: {total_process_keys: 7236267, total_keys: 7795525, rocksdb: {delete_skipped_count: 0, key_skipped_count: 1778426, block: {cache_hit_count: 54006390, read_count: 218228, read_byte: 4.21 GB}}}	eq(tpch50.orders.o_orderstatus, "F")	N/A	N/A
20:53:40 [2021-05-31T20:53:40.186Z]       │ │     └─TableRangeScan_93	1.00	7236267	cop[tikv]	table:orders	tikv_task:{proc max:139ms, min:0s, p80:67ms, p95:81ms, iters:30309, tasks:5281}	range: decided by [tpch50.lineitem.l_orderkey], keep order:false	N/A	N/A
20:53:40 [2021-05-31T20:53:40.186Z]       │ └─IndexLookUp_80(Probe)	4.05	17316445	root		time:1m55s, loops:17133, index_task: {total_time: 1m3.4s, fetch_handle: 55.9s, build: 3.35ms, wait: 7.53s}, table_task: {total_time: 8m18.5s, num: 1458, concurrency: 760}		19.2 KB	N/A
20:53:40 [2021-05-31T20:53:40.186Z]       │   ├─IndexRangeScan_78(Build)	4.05	17316445	cop[tikv]	table:l2, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:53.5s, loops:18608, cop_task: {num: 3008, max: 679.8ms, min: 496.8µs, avg: 180.7ms, p95: 355.9ms, max_proc_keys: 13055, p95_proc_keys: 8697, tot_proc: 6m49.2s, tot_wait: 1m52.6s, rpc_num: 3008, rpc_time: 9m3.3s, copr_cache: disabled}, tikv_task:{proc max:181ms, min:0s, p80:95ms, p95:111ms, iters:30190, tasks:3008}, scan_detail: {total_process_keys: 17316445, total_keys: 20812546, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17316445, block: {cache_hit_count: 24259947, 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:53:40 [2021-05-31T20:53:40.186Z]       │   └─TableRowIDScan_79(Probe)	4.05	17316445	cop[tikv]	table:l2	time:6m8.9s, loops:21070, cop_task: {num: 7824, max: 606.8ms, min: 518.1µs, avg: 173.4ms, p95: 355ms, max_proc_keys: 10024, p95_proc_keys: 4856, tot_proc: 16m12.3s, tot_wait: 5m33.9s, rpc_num: 7824, rpc_time: 22m36.8s, copr_cache: disabled}, tikv_task:{proc max:254ms, min:0s, p80:103ms, p95:137ms, iters:49856, tasks:7824}, scan_detail: {total_process_keys: 17316445, total_keys: 18290042, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5633689, block: {cache_hit_count: 99009022, read_count: 1110, read_byte: 394.2 MB}}}	keep order:false	N/A	N/A
20:53:40 [2021-05-31T20:53:40.186Z]       └─IndexLookUp_39(Probe)	4.05	12022822	root		time:1m48.4s, loops:11938, index_task: {total_time: 59.3s, fetch_handle: 47.9s, build: 5.91ms, wait: 11.4s}, table_task: {total_time: 7m53.6s, num: 1408, concurrency: 730}		213.0 KB	N/A
20:53:40 [2021-05-31T20:53:40.186Z]         ├─IndexRangeScan_36(Build)	5.06	17183430	cop[tikv]	table:l3, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:45.5s, loops:18377, cop_task: {num: 2796, max: 738.7ms, min: 767.1µs, avg: 163.4ms, p95: 353.5ms, max_proc_keys: 18093, p95_proc_keys: 13572, tot_proc: 5m38.3s, tot_wait: 1m38.7s, rpc_num: 2796, rpc_time: 7m36.7s, copr_cache: disabled}, tikv_task:{proc max:184ms, min:0s, p80:77ms, p95:118ms, iters:29192, tasks:2796}, scan_detail: {total_process_keys: 17183430, total_keys: 20546465, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17183430, block: {cache_hit_count: 23554051, read_count: 0, read_byte: 0 Bytes}}}	range: decided by [eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey)], keep order:false	N/A	N/A
20:53:40 [2021-05-31T20:53:40.186Z]         └─Selection_38(Probe)	4.05	12022822	cop[tikv]		time:6m3.6s, loops:13767, cop_task: {num: 10276, max: 695.8ms, min: 341.4µs, avg: 169.3ms, p95: 347.4ms, max_proc_keys: 7267, p95_proc_keys: 3943, tot_proc: 20m17.2s, tot_wait: 7m36.1s, rpc_num: 10276, rpc_time: 28m59.5s, copr_cache: disabled}, tikv_task:{proc max:210ms, min:0s, p80:75ms, p95:114ms, iters:60653, tasks:10276}, scan_detail: {total_process_keys: 17183430, total_keys: 18128104, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5521692, block: {cache_hit_count: 98293177, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:53:40 [2021-05-31T20:53:40.186Z]           └─TableRowIDScan_37	5.06	17183430	cop[tikv]	table:l3	tikv_task:{proc max:208ms, min:0s, p80:74ms, p95:113ms, iters:60653, tasks:10276}	keep order:false	N/A	N/A
20:53:40 [2021-05-31T20:53:40.186Z] + sync
20:53:40 [2021-05-31T20:53:40.186Z] + /usr/bin/echo 3
20:55:01 [2021-05-31T20:55:01.691Z] 
20:55:01 [2021-05-31T20:55:01.691Z] queries/21.sql
20:55:01 [2021-05-31T20:55:01.691Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:55:01 [2021-05-31T20:55:01.691Z] Projection_26	100.00	100	root		time:1m19.9s, loops:2, Concurrency:OFF	tpch50.supplier.s_name, Column#72	4.62 KB	N/A
20:55:01 [2021-05-31T20:55:01.691Z] └─TopN_29	100.00	100	root		time:1m19.9s, loops:2	Column#72:desc, tpch50.supplier.s_name, offset:0, count:100	58.4 KB	N/A
20:55:01 [2021-05-31T20:55:01.691Z]   └─HashAgg_34	12800.00	20057	root		time:1m19.9s, loops:21, partial_worker:{wall_time:1m19.87052836s, concurrency:5, task_num:197, tot_wait:6m39.066634729s, tot_exec:268.449311ms, tot_time:6m39.348326794s, max:1m19.870490501s, p95:1m19.870490501s}, final_worker:{wall_time:1m19.88611828s, concurrency:5, task_num:25, tot_wait:6m39.346152805s, tot_exec:75.068767ms, tot_time:6m39.421234362s, max:1m19.886090563s, p95:1m19.886090563s}	group by:tpch50.supplier.s_name, funcs:count(1)->Column#72, funcs:firstrow(tpch50.supplier.s_name)->tpch50.supplier.s_name	17.2 MB	N/A
20:55:01 [2021-05-31T20:55:01.691Z]     └─IndexHashJoin_42	7828961.66	198698	root		time:1m19.9s, loops:198, inner:{total:2m17.9s, concurrency:5, task:146, construct:6.64s, fetch:1m54.2s, build:1.14s, 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:01 [2021-05-31T20:55:01.691Z]       ├─IndexHashJoin_83(Build)	9786202.08	3542799	root		time:1m19.3s, loops:3462, inner:{total:2m27.8s, concurrency:5, task:152, construct:8.1s, fetch:2m1.9s, build:1.32s, 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:55:01 [2021-05-31T20:55:01.691Z]       │ ├─IndexJoin_99(Build)	12232752.60	3675878	root		time:1m18.8s, loops:3595, inner:{total:2m5.1s, concurrency:5, task:305, construct:16.8s, fetch:1m46.3s, build:1.9s}, probe:5.48s	inner join, inner:TableReader_95, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.orders.o_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.orders.o_orderkey)	575.3 MB	N/A
20:55:01 [2021-05-31T20:55:01.691Z]       │ │ ├─HashJoin_107(Build)	12232752.60	7609895	root		time:1m18.2s, loops:7436, build_hash_table:{total:1.09s, fetch:1.08s, build:5.75ms}, probe:{concurrency:5, total:6m33.5s, max:1m18.7s, probe:1m2.1s, fetch:5m31.5s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.lineitem.l_suppkey)]	713.1 KB	0 Bytes
20:55:01 [2021-05-31T20:55:01.691Z]       │ │ │ ├─HashJoin_120(Build)	20000.00	20058	root		time:1.08s, loops:21, build_hash_table:{total:193.7µs, fetch:186.1µs, build:7.65µs}, probe:{concurrency:5, total:5.43s, max:1.09s, probe:57.4ms, fetch:5.37s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:55:01 [2021-05-31T20:55:01.691Z]       │ │ │ │ ├─TableReader_125(Build)	1.00	1	root		time:54.2µs, loops:2, cop_task: {num: 1, max: 1.49ms, proc_keys: 25, tot_proc: 1ms, rpc_num: 1, rpc_time: 1.45ms, copr_cache: disabled}	data:Selection_124	248 Bytes	N/A
20:55:01 [2021-05-31T20:55:01.691Z]       │ │ │ │ │ └─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:01 [2021-05-31T20:55:01.691Z]       │ │ │ │ │   └─TableFullScan_123	25.00	25	cop[tikv]	table:nation	tikv_task:{time:1ms, loops:1}	keep order:false	N/A	N/A
20:55:01 [2021-05-31T20:55:01.691Z]       │ │ │ │ └─TableReader_122(Probe)	500000.00	500000	root		time:1.07s, loops:490, cop_task: {num: 1, max: 1.07s, proc_keys: 500000, tot_proc: 1.05s, rpc_num: 1, rpc_time: 1.07s, copr_cache: disabled}	data:TableFullScan_121	20.0 MB	N/A
20:55:01 [2021-05-31T20:55:01.691Z]       │ │ │ │   └─TableFullScan_121	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:984ms, 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:01 [2021-05-31T20:55:01.691Z]       │ │ │ └─TableReader_128(Probe)	240004648.80	189670348	root		time:1m5.8s, loops:184598, cop_task: {num: 761, max: 2.64s, min: 269.2ms, avg: 1.51s, p95: 2.03s, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 17m59.4s, tot_wait: 54.9s, rpc_num: 761, rpc_time: 19m7.9s, copr_cache: disabled}	data:Selection_127	109.4 MB	N/A
20:55:01 [2021-05-31T20:55:01.691Z]       │ │ │   └─Selection_127	240004648.80	189670348	cop[tikv]		tikv_task:{proc max:1.32s, min:259ms, p80:1.17s, p95:1.22s, iters:296606, tasks:761}, scan_detail: {total_process_keys: 300005811, total_keys: 300006572, rocksdb: {delete_skipped_count: 0, key_skipped_count: 600010861, block: {cache_hit_count: 10462, read_count: 1114186, read_byte: 23.6 GB}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:55:01 [2021-05-31T20:55:01.691Z]       │ │ │     └─TableFullScan_126	300005811.00	300005811	cop[tikv]	table:l1	tikv_task:{proc max:1.24s, min:241ms, p80:1.09s, p95:1.13s, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:55:01 [2021-05-31T20:55:01.691Z]       │ │ └─TableReader_95(Probe)	0.49	3496187	root		time:1m37s, loops:3875, cop_task: {num: 5229, max: 508.3ms, min: 1.58ms, avg: 174ms, p95: 328.3ms, max_proc_keys: 2969, p95_proc_keys: 1974, tot_proc: 10m57.6s, tot_wait: 3m32s, rpc_num: 5229, rpc_time: 15m9.6s, copr_cache: disabled}	data:Selection_94	N/A	N/A
20:55:01 [2021-05-31T20:55:01.691Z]       │ │   └─Selection_94	0.49	3496187	cop[tikv]		tikv_task:{proc max:142ms, min:0s, p80:68ms, p95:81ms, iters:30155, tasks:5229}, scan_detail: {total_process_keys: 7236276, total_keys: 7795494, rocksdb: {delete_skipped_count: 0, key_skipped_count: 1778360, block: {cache_hit_count: 54005932, read_count: 218193, read_byte: 4.21 GB}}}	eq(tpch50.orders.o_orderstatus, "F")	N/A	N/A
20:55:01 [2021-05-31T20:55:01.691Z]       │ │     └─TableRangeScan_93	1.00	7236276	cop[tikv]	table:orders	tikv_task:{proc max:141ms, min:0s, p80:68ms, p95:81ms, iters:30155, tasks:5229}	range: decided by [tpch50.lineitem.l_orderkey], keep order:false	N/A	N/A
20:55:01 [2021-05-31T20:55:01.691Z]       │ └─IndexLookUp_80(Probe)	4.05	17316386	root		time:1m56.3s, loops:17133, index_task: {total_time: 1m3.2s, fetch_handle: 55s, build: 4.56ms, wait: 8.2s}, table_task: {total_time: 8m14.3s, num: 1458, concurrency: 760}		19.2 KB	N/A
20:55:01 [2021-05-31T20:55:01.691Z]       │   ├─IndexRangeScan_78(Build)	4.05	17316386	cop[tikv]	table:l2, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:52.7s, loops:18623, cop_task: {num: 3004, max: 640.3ms, min: 429.5µs, avg: 185.1ms, p95: 361ms, max_proc_keys: 12541, p95_proc_keys: 8692, tot_proc: 6m52s, tot_wait: 2m2.4s, rpc_num: 3004, rpc_time: 9m16s, copr_cache: disabled}, tikv_task:{proc max:164ms, min:0s, p80:94ms, p95:109ms, iters:30200, tasks:3004}, scan_detail: {total_process_keys: 17316386, total_keys: 20812478, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17316386, block: {cache_hit_count: 24259885, read_count: 225686, read_byte: 2.00 GB}}}	range: decided by [eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey)], keep order:false	N/A	N/A
20:55:01 [2021-05-31T20:55:01.691Z]       │   └─TableRowIDScan_79(Probe)	4.05	17316386	cop[tikv]	table:l2	time:6m3.4s, loops:21036, cop_task: {num: 7793, max: 592.8ms, min: 816.9µs, avg: 170.1ms, p95: 338.6ms, max_proc_keys: 10154, p95_proc_keys: 4871, tot_proc: 15m55.1s, tot_wait: 5m19.1s, rpc_num: 7793, rpc_time: 22m5.2s, copr_cache: disabled}, tikv_task:{proc max:335ms, min:0s, p80:103ms, p95:139ms, iters:49908, tasks:7793}, scan_detail: {total_process_keys: 17316386, total_keys: 18288580, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5624916, block: {cache_hit_count: 99026546, read_count: 1111, read_byte: 397.6 MB}}}	keep order:false	N/A	N/A
20:55:01 [2021-05-31T20:55:01.691Z]       └─IndexLookUp_39(Probe)	4.05	12022721	root		time:1m49.1s, loops:11950, index_task: {total_time: 58.4s, fetch_handle: 48.8s, build: 6.31ms, wait: 9.62s}, table_task: {total_time: 7m51.9s, num: 1408, concurrency: 730}		268.7 KB	N/A
20:55:01 [2021-05-31T20:55:01.691Z]         ├─IndexRangeScan_36(Build)	5.06	17183287	cop[tikv]	table:l3, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:46.3s, loops:18378, cop_task: {num: 2791, max: 620.9ms, min: 1.16ms, avg: 162.6ms, p95: 337.3ms, max_proc_keys: 18590, p95_proc_keys: 13440, tot_proc: 5m36.7s, tot_wait: 1m36.5s, rpc_num: 2791, rpc_time: 7m33.6s, copr_cache: disabled}, tikv_task:{proc max:192ms, min:0s, p80:77ms, p95:117ms, iters:29128, tasks:2791}, scan_detail: {total_process_keys: 17183287, total_keys: 20546297, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17183287, block: {cache_hit_count: 23553876, read_count: 0, read_byte: 0 Bytes}}}	range: decided by [eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey)], keep order:false	N/A	N/A
20:55:01 [2021-05-31T20:55:01.691Z]         └─Selection_38(Probe)	4.05	12022721	cop[tikv]		time:6m3.2s, loops:13768, cop_task: {num: 10125, max: 567.2ms, min: 423.2µs, avg: 167.6ms, p95: 335.1ms, max_proc_keys: 7334, p95_proc_keys: 3948, tot_proc: 19m53.3s, tot_wait: 7m18.1s, rpc_num: 10125, rpc_time: 28m16.5s, copr_cache: disabled}, tikv_task:{proc max:220ms, min:0s, p80:76ms, p95:114ms, iters:60253, tasks:10125}, scan_detail: {total_process_keys: 17183287, total_keys: 18129086, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5527921, block: {cache_hit_count: 98285045, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:55:01 [2021-05-31T20:55:01.691Z]           └─TableRowIDScan_37	5.06	17183287	cop[tikv]	table:l3	tikv_task:{proc max:219ms, min:0s, p80:75ms, p95:113ms, iters:60253, tasks:10125}	keep order:false	N/A	N/A
20:55:01 [2021-05-31T20:55:01.691Z] + tiup cluster stop benchbot -y
20:55:01 [2021-05-31T20:55:01.691Z] Starting component `cluster`: /home/tidb/.tiup/components/cluster/v1.4.4/tiup-cluster stop benchbot -y
20:55:21 [2021-05-31T20:55:21.113Z] + rm -rf '/data1/tidb-deploy/*/log/*'
20:55:21 [2021-05-31T20:55:21.113Z] + rm -rf /data1/jenkins/deploy/data/tikv-20160
20:55:21 [2021-05-31T20:55:21.113Z] + rm -rf /data1/jenkins/deploy/data/pd-2379
20:55:21 [2021-05-31T20:55:21.113Z] + rm -rf /data1/jenkins/restore_data/tpch50/data/last_tikv.toml
20:55:21 [2021-05-31T20:55:21.113Z] + cp -R /data1/jenkins/restore_data/tpch50/data /data1/jenkins/deploy/data/tikv-20160
20:57:13 [2021-05-31T20:57:13.849Z] + cp -R /data1/jenkins/restore_data/tpch50/data.pd /data1/jenkins/deploy/data/pd-2379
20:57:13 [2021-05-31T20:57:13.850Z] + '[' -n '' ']'
20:57:13 [2021-05-31T20:57:13.850Z] + tiup cluster start benchbot --wait-timeout=300
20:57:13 [2021-05-31T20:57:13.850Z] Starting component `cluster`: /home/tidb/.tiup/components/cluster/v1.4.4/tiup-cluster start benchbot --wait-timeout=300
20:57:32 [2021-05-31T20:57:32.436Z] + sync
20:57:32 [2021-05-31T20:57:32.436Z] + /usr/bin/echo 3
20:58:11 [2021-05-31T20:58:11.173Z] + sync
20:58:11 [2021-05-31T20:58:11.173Z] + /usr/bin/echo 3
20:58:42 [2021-05-31T20:58:42.348Z] + sync
20:58:42 [2021-05-31T20:58:42.348Z] + /usr/bin/echo 3
20:59:08 [2021-05-31T20:59:08.343Z] 
20:59:08 [2021-05-31T20:59:08.343Z] queries/22.sql
20:59:08 [2021-05-31T20:59:08.343Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:59:08 [2021-05-31T20:59:08.343Z] Sort_39	1600000.00	4	root		time:26.3s, loops:2	Column#27	9.48 KB	0 Bytes
20:59:08 [2021-05-31T20:59:08.343Z] └─Projection_41	1600000.00	4	root		time:26.3s, loops:5, Concurrency:5	Column#27, Column#28, Column#29	23.7 KB	N/A
20:59:08 [2021-05-31T20:59:08.343Z]   └─HashAgg_42	1600000.00	4	root		time:26.3s, loops:5, partial_worker:{wall_time:26.267175029s, concurrency:5, task_num:180, tot_wait:2m11.284739768s, tot_exec:50.002199ms, tot_time:2m11.334925794s, max:26.267124507s, p95:26.267124507s}, final_worker:{wall_time:26.267206303s, concurrency:5, task_num:20, tot_wait:2m11.335413279s, tot_exec:338.229µs, tot_time:2m11.33576048s, max:26.267166256s, p95:26.267166256s}	group by:Column#33, funcs:count(1)->Column#28, funcs:sum(Column#31)->Column#29, funcs:firstrow(Column#32)->Column#27	857.7 KB	N/A
20:59:08 [2021-05-31T20:59:08.343Z]     └─Projection_51	1600000.00	181704	root		time:26.3s, loops:181, Concurrency:5	tpch50.customer.c_acctbal, substring(tpch50.customer.c_phone, 1, 2)->Column#32, substring(tpch50.customer.c_phone, 1, 2)->Column#33	693.6 KB	N/A
20:59:08 [2021-05-31T20:59:08.343Z]       └─HashJoin_43	1600000.00	181704	root		time:26.3s, loops:181, build_hash_table:{total:24.8s, fetch:1.09s, build:23.7s}, probe:{concurrency:5, total:2m11.3s, max:26.3s, probe:6.15s, fetch:2m5.1s}	anti semi join, equal:[eq(tpch50.customer.c_custkey, tpch50.orders.o_custkey)]	590.2 MB	0 Bytes
20:59:08 [2021-05-31T20:59:08.343Z]         ├─TableReader_49(Build)	75000000.00	75000000	root		time:1.1s, loops:73364, cop_task: {num: 153, max: 954.7ms, min: 274.2ms, avg: 584.2ms, p95: 865.7ms, max_proc_keys: 723875, p95_proc_keys: 553332, tot_proc: 1m28.5s, tot_wait: 28ms, rpc_num: 153, rpc_time: 1m29.4s, copr_cache: disabled}	data:TableFullScan_48	57.8 MB	N/A
20:59:08 [2021-05-31T20:59:08.343Z]         │ └─TableFullScan_48	75000000.00	75000000	cop[tikv]	table:orders	tikv_task:{proc max:925ms, min:267ms, p80:596ms, p95:830ms, 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: 3035, read_count: 219918, read_byte: 4.30 GB}}}	keep order:false	N/A	N/A
20:59:08 [2021-05-31T20:59:08.343Z]         └─Selection_47(Probe)	2000000.00	545246	root		time:1.34s, loops:534	in(substring(tpch50.customer.c_phone, 1, 2), "20", "40", "22", "30", "39", "42", "21")	94.6 KB	N/A
20:59:08 [2021-05-31T20:59:08.343Z]           └─TableReader_46	2000000.00	3407619	root		time:550.9ms, loops:3319, cop_task: {num: 18, max: 1.06s, min: 468.5ms, avg: 752.7ms, p95: 1.06s, max_proc_keys: 582617, p95_proc_keys: 582617, tot_proc: 13.1s, rpc_num: 18, rpc_time: 13.5s, copr_cache: disabled}	data:Selection_45	192.5 MB	N/A
20:59:08 [2021-05-31T20:59:08.343Z]             └─Selection_45	2000000.00	3407619	cop[tikv]		tikv_task:{proc max:990ms, min:440ms, p80:835ms, p95:990ms, iters:7404, tasks:18}, scan_detail: {total_process_keys: 7500000, total_keys: 7500018, rocksdb: {delete_skipped_count: 0, key_skipped_count: 14999982, block: {cache_hit_count: 28451, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.customer.c_acctbal, 5000.602894)	N/A	N/A
20:59:08 [2021-05-31T20:59:08.343Z]               └─TableFullScan_44	7500000.00	7500000	cop[tikv]	table:customer	tikv_task:{proc max:887ms, min:397ms, p80:749ms, p95:887ms, iters:7404, tasks:18}	keep order:false	N/A	N/A
20:59:08 [2021-05-31T20:59:08.343Z] 
20:59:08 [2021-05-31T20:59:08.343Z] queries/22.sql
20:59:08 [2021-05-31T20:59:08.343Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:59:08 [2021-05-31T20:59:08.343Z] Sort_39	2186432.06	4	root		time:26.3s, loops:2	Column#27	9.48 KB	0 Bytes
20:59:08 [2021-05-31T20:59:08.343Z] └─Projection_41	2186432.06	4	root		time:26.3s, loops:5, Concurrency:5	Column#27, Column#28, Column#29	23.7 KB	N/A
20:59:08 [2021-05-31T20:59:08.343Z]   └─HashAgg_42	2186432.06	4	root		time:26.3s, loops:5, partial_worker:{wall_time:26.302978073s, concurrency:5, task_num:180, tot_wait:2m11.463995621s, tot_exec:49.812199ms, tot_time:2m11.513939453s, max:26.302913032s, p95:26.302913032s}, final_worker:{wall_time:26.303028634s, concurrency:5, task_num:20, tot_wait:2m11.514633012s, tot_exec:264.263µs, tot_time:2m11.514904646s, max:26.30299858s, p95:26.30299858s}	group by:Column#33, funcs:count(1)->Column#28, funcs:sum(Column#31)->Column#29, funcs:firstrow(Column#32)->Column#27	857.7 KB	N/A
20:59:08 [2021-05-31T20:59:08.343Z]     └─Projection_51	2186432.06	181704	root		time:26.3s, loops:181, Concurrency:5	tpch50.customer.c_acctbal, substring(tpch50.customer.c_phone, 1, 2)->Column#32, substring(tpch50.customer.c_phone, 1, 2)->Column#33	693.6 KB	N/A
20:59:08 [2021-05-31T20:59:08.343Z]       └─HashJoin_43	2186432.06	181704	root		time:26.3s, loops:181, build_hash_table:{total:24.9s, fetch:947.1ms, build:23.9s}, probe:{concurrency:5, total:2m11.5s, max:26.3s, probe:6.07s, fetch:2m5.4s}	anti semi join, equal:[eq(tpch50.customer.c_custkey, tpch50.orders.o_custkey)]	590.2 MB	0 Bytes
20:59:08 [2021-05-31T20:59:08.343Z]         ├─TableReader_49(Build)	75000000.00	75000000	root		time:967.9ms, loops:73364, cop_task: {num: 153, max: 953.8ms, min: 193.8ms, avg: 491ms, p95: 759ms, max_proc_keys: 723875, p95_proc_keys: 553332, tot_proc: 1m14.4s, tot_wait: 36ms, rpc_num: 153, rpc_time: 1m15.1s, copr_cache: disabled}	data:TableFullScan_48	57.8 MB	N/A
20:59:08 [2021-05-31T20:59:08.343Z]         │ └─TableFullScan_48	75000000.00	75000000	cop[tikv]	table:orders	tikv_task:{proc max:922ms, min:183ms, p80:501ms, p95:733ms, iters:73975, tasks:153}, scan_detail: {total_process_keys: 75000000, total_keys: 75000153, rocksdb: {delete_skipped_count: 0, key_skipped_count: 149999847, block: {cache_hit_count: 220923, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:59:08 [2021-05-31T20:59:08.343Z]         └─Selection_47(Probe)	2733040.07	545246	root		time:1.42s, loops:534	in(substring(tpch50.customer.c_phone, 1, 2), "20", "40", "22", "30", "39", "42", "21")	94.6 KB	N/A
20:59:08 [2021-05-31T20:59:08.343Z]           └─TableReader_46	2733040.07	3407619	root		time:620.8ms, loops:3319, cop_task: {num: 18, max: 1.09s, min: 494.4ms, avg: 789.4ms, p95: 1.09s, max_proc_keys: 582617, p95_proc_keys: 582617, tot_proc: 13.8s, rpc_num: 18, rpc_time: 14.2s, copr_cache: disabled}	data:Selection_45	192.5 MB	N/A
20:59:08 [2021-05-31T20:59:08.343Z]             └─Selection_45	2733040.07	3407619	cop[tikv]		tikv_task:{proc max:1.01s, min:450ms, p80:897ms, p95:1.01s, iters:7404, tasks:18}, scan_detail: {total_process_keys: 7500000, total_keys: 7500018, rocksdb: {delete_skipped_count: 0, key_skipped_count: 14999982, block: {cache_hit_count: 28451, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.customer.c_acctbal, 5000.602894)	N/A	N/A
20:59:08 [2021-05-31T20:59:08.343Z]               └─TableFullScan_44	7500000.00	7500000	cop[tikv]	table:customer	tikv_task:{proc max:912ms, min:402ms, p80:818ms, p95:912ms, iters:7404, tasks:18}	keep order:false	N/A	N/A
20:59:08 [2021-05-31T20:59:08.343Z] 
20:59:08 [2021-05-31T20:59:08.343Z] queries/22.sql
20:59:08 [2021-05-31T20:59:08.343Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:59:08 [2021-05-31T20:59:08.343Z] Sort_39	2186432.06	4	root		time:25.3s, loops:2	Column#27	9.48 KB	0 Bytes
20:59:08 [2021-05-31T20:59:08.343Z] └─Projection_41	2186432.06	4	root		time:25.3s, loops:5, Concurrency:5	Column#27, Column#28, Column#29	23.7 KB	N/A
20:59:08 [2021-05-31T20:59:08.343Z]   └─HashAgg_42	2186432.06	4	root		time:25.3s, loops:5, partial_worker:{wall_time:25.269568551s, concurrency:5, task_num:180, tot_wait:2m6.296702717s, tot_exec:50.473756ms, tot_time:2m6.34730692s, max:25.269535939s, p95:25.269535939s}, final_worker:{wall_time:25.269590952s, concurrency:5, task_num:20, tot_wait:2m6.347505353s, tot_exec:256.094µs, tot_time:2m6.347769323s, max:25.269565192s, p95:25.269565192s}	group by:Column#33, funcs:count(1)->Column#28, funcs:sum(Column#31)->Column#29, funcs:firstrow(Column#32)->Column#27	857.7 KB	N/A
20:59:08 [2021-05-31T20:59:08.343Z]     └─Projection_51	2186432.06	181704	root		time:25.3s, loops:181, Concurrency:5	tpch50.customer.c_acctbal, substring(tpch50.customer.c_phone, 1, 2)->Column#32, substring(tpch50.customer.c_phone, 1, 2)->Column#33	693.6 KB	N/A
20:59:08 [2021-05-31T20:59:08.343Z]       └─HashJoin_43	2186432.06	181704	root		time:25.3s, loops:181, build_hash_table:{total:23.9s, fetch:864.6ms, build:23s}, probe:{concurrency:5, total:2m6.3s, max:25.3s, probe:5.81s, fetch:2m0.5s}	anti semi join, equal:[eq(tpch50.customer.c_custkey, tpch50.orders.o_custkey)]	590.2 MB	0 Bytes
20:59:08 [2021-05-31T20:59:08.343Z]         ├─TableReader_49(Build)	75000000.00	75000000	root		time:887.8ms, loops:73364, cop_task: {num: 153, max: 997.2ms, min: 209.7ms, avg: 488.2ms, p95: 806.4ms, max_proc_keys: 723875, p95_proc_keys: 553332, tot_proc: 1m14s, tot_wait: 33ms, rpc_num: 153, rpc_time: 1m14.7s, copr_cache: disabled}	data:TableFullScan_48	57.8 MB	N/A
20:59:08 [2021-05-31T20:59:08.343Z]         │ └─TableFullScan_48	75000000.00	75000000	cop[tikv]	table:orders	tikv_task:{proc max:972ms, min:197ms, p80:506ms, p95:779ms, iters:73975, tasks:153}, scan_detail: {total_process_keys: 75000000, total_keys: 75000153, rocksdb: {delete_skipped_count: 0, key_skipped_count: 149999847, block: {cache_hit_count: 220923, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:59:08 [2021-05-31T20:59:08.344Z]         └─Selection_47(Probe)	2733040.07	545246	root		time:1.48s, loops:534	in(substring(tpch50.customer.c_phone, 1, 2), "20", "40", "22", "30", "39", "42", "21")	94.6 KB	N/A
20:59:08 [2021-05-31T20:59:08.344Z]           └─TableReader_46	2733040.07	3407619	root		time:661.7ms, loops:3319, cop_task: {num: 18, max: 1.09s, min: 523.2ms, avg: 858.7ms, p95: 1.09s, max_proc_keys: 582617, p95_proc_keys: 582617, tot_proc: 15s, tot_wait: 1ms, rpc_num: 18, rpc_time: 15.5s, copr_cache: disabled}	data:Selection_45	192.5 MB	N/A
20:59:08 [2021-05-31T20:59:08.344Z]             └─Selection_45	2733040.07	3407619	cop[tikv]		tikv_task:{proc max:1.02s, min:481ms, p80:1s, p95:1.02s, iters:7404, tasks:18}, scan_detail: {total_process_keys: 7500000, total_keys: 7500018, rocksdb: {delete_skipped_count: 0, key_skipped_count: 14999982, block: {cache_hit_count: 28451, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.customer.c_acctbal, 5000.602894)	N/A	N/A
20:59:08 [2021-05-31T20:59:08.344Z]               └─TableFullScan_44	7500000.00	7500000	cop[tikv]	table:customer	tikv_task:{proc max:936ms, min:434ms, p80:915ms, p95:936ms, iters:7404, tasks:18}	keep order:false	N/A	N/A
20:59:08 [2021-05-31T20:59:08.344Z] + sync
20:59:08 [2021-05-31T20:59:08.344Z] + /usr/bin/echo 3
20:59:38 [2021-05-31T20:59:38.842Z] + sync
20:59:38 [2021-05-31T20:59:38.842Z] + /usr/bin/echo 3
21:00:15 [2021-05-31T21:00:15.303Z] + sync
21:00:15 [2021-05-31T21:00:15.303Z] + /usr/bin/echo 3
21:00:32 [2021-05-31T21:00:32.550Z] 
21:00:32 [2021-05-31T21:00:32.550Z] queries/22.sql
21:00:32 [2021-05-31T21:00:32.550Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
21:00:32 [2021-05-31T21:00:32.550Z] Sort_39	2186432.06	4	root		time:26.2s, loops:2	Column#27	9.48 KB	0 Bytes
21:00:32 [2021-05-31T21:00:32.550Z] └─Projection_41	2186432.06	4	root		time:26.2s, loops:5, Concurrency:5	Column#27, Column#28, Column#29	23.7 KB	N/A
21:00:32 [2021-05-31T21:00:32.550Z]   └─HashAgg_42	2186432.06	4	root		time:26.2s, loops:5, partial_worker:{wall_time:26.174775647s, concurrency:5, task_num:179, tot_wait:2m10.81706389s, tot_exec:56.337738ms, tot_time:2m10.873543246s, max:26.174753051s, p95:26.174753051s}, final_worker:{wall_time:26.174831812s, concurrency:5, task_num:20, tot_wait:2m10.873694072s, tot_exec:191.432µs, tot_time:2m10.873891389s, max:26.174791184s, p95:26.174791184s}	group by:Column#33, funcs:count(1)->Column#28, funcs:sum(Column#31)->Column#29, funcs:firstrow(Column#32)->Column#27	857.7 KB	N/A
21:00:32 [2021-05-31T21:00:32.550Z]     └─Projection_51	2186432.06	181704	root		time:26.2s, loops:180, Concurrency:5	tpch50.customer.c_acctbal, substring(tpch50.customer.c_phone, 1, 2)->Column#32, substring(tpch50.customer.c_phone, 1, 2)->Column#33	693.6 KB	N/A
21:00:32 [2021-05-31T21:00:32.550Z]       └─HashJoin_43	2186432.06	181704	root		time:26.2s, loops:180, build_hash_table:{total:24.7s, fetch:899.5ms, build:23.8s}, probe:{concurrency:5, total:2m10.9s, max:26.2s, probe:6.06s, fetch:2m4.8s}	anti semi join, equal:[eq(tpch50.customer.c_custkey, tpch50.orders.o_custkey)]	590.2 MB	0 Bytes
21:00:32 [2021-05-31T21:00:32.550Z]         ├─TableReader_49(Build)	75000000.00	75000000	root		time:915.4ms, loops:73364, cop_task: {num: 153, max: 993.8ms, min: 204.9ms, avg: 487.1ms, p95: 837.2ms, max_proc_keys: 723875, p95_proc_keys: 553332, tot_proc: 1m13.8s, tot_wait: 57ms, rpc_num: 153, rpc_time: 1m14.5s, copr_cache: disabled}	data:TableFullScan_48	57.8 MB	N/A
21:00:32 [2021-05-31T21:00:32.550Z]         │ └─TableFullScan_48	75000000.00	75000000	cop[tikv]	table:orders	tikv_task:{proc max:945ms, min:198ms, p80:493ms, p95:812ms, iters:73975, tasks:153}, scan_detail: {total_process_keys: 75000000, total_keys: 75000153, rocksdb: {delete_skipped_count: 0, key_skipped_count: 149999847, block: {cache_hit_count: 220923, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
21:00:32 [2021-05-31T21:00:32.550Z]         └─Selection_47(Probe)	2733040.07	545246	root		time:1.66s, loops:534	in(substring(tpch50.customer.c_phone, 1, 2), "20", "40", "22", "30", "39", "42", "21")	94.6 KB	N/A
21:00:32 [2021-05-31T21:00:32.550Z]           └─TableReader_46	2733040.07	3407619	root		time:746.6ms, loops:3319, cop_task: {num: 18, max: 1.27s, min: 554.2ms, avg: 881.8ms, p95: 1.27s, max_proc_keys: 582617, p95_proc_keys: 582617, tot_proc: 15.5s, rpc_num: 18, rpc_time: 15.9s, copr_cache: disabled}	data:Selection_45	192.5 MB	N/A
21:00:32 [2021-05-31T21:00:32.550Z]             └─Selection_45	2733040.07	3407619	cop[tikv]		tikv_task:{proc max:1.2s, min:513ms, p80:1.01s, p95:1.2s, iters:7404, tasks:18}, scan_detail: {total_process_keys: 7500000, total_keys: 7500018, rocksdb: {delete_skipped_count: 0, key_skipped_count: 14999982, block: {cache_hit_count: 28451, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.customer.c_acctbal, 5000.602894)	N/A	N/A
21:00:32 [2021-05-31T21:00:32.550Z]               └─TableFullScan_44	7500000.00	7500000	cop[tikv]	table:customer	tikv_task:{proc max:1.1s, min:460ms, p80:916ms, p95:1.1s, iters:7404, tasks:18}	keep order:false	N/A	N/A
21:00:32 [2021-05-31T21:00:32.550Z] 
21:00:32 [2021-05-31T21:00:32.550Z] queries/22.sql
21:00:32 [2021-05-31T21:00:32.550Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
21:00:32 [2021-05-31T21:00:32.550Z] Sort_39	2186432.06	4	root		time:24.6s, loops:2	Column#27	9.48 KB	0 Bytes
21:00:32 [2021-05-31T21:00:32.550Z] └─Projection_41	2186432.06	4	root		time:24.6s, loops:5, Concurrency:5	Column#27, Column#28, Column#29	23.7 KB	N/A
21:00:32 [2021-05-31T21:00:32.550Z]   └─HashAgg_42	2186432.06	4	root		time:24.6s, loops:5, partial_worker:{wall_time:24.572358148s, concurrency:5, task_num:180, tot_wait:2m2.811067132s, tot_exec:49.237644ms, tot_time:2m2.860449329s, max:24.572289953s, p95:24.572289953s}, final_worker:{wall_time:24.572333333s, concurrency:5, task_num:20, tot_wait:2m2.861255559s, tot_exec:268.145µs, tot_time:2m2.861547585s, max:24.572313313s, p95:24.572313313s}	group by:Column#33, funcs:count(1)->Column#28, funcs:sum(Column#31)->Column#29, funcs:firstrow(Column#32)->Column#27	857.7 KB	N/A
21:00:32 [2021-05-31T21:00:32.550Z]     └─Projection_51	2186432.06	181704	root		time:24.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	693.6 KB	N/A
21:00:32 [2021-05-31T21:00:32.550Z]       └─HashJoin_43	2186432.06	181704	root		time:24.6s, loops:181, build_hash_table:{total:23.2s, fetch:850.2ms, build:22.4s}, probe:{concurrency:5, total:2m2.8s, max:24.6s, probe:5.5s, fetch:1m57.3s}	anti semi join, equal:[eq(tpch50.customer.c_custkey, tpch50.orders.o_custkey)]	590.2 MB	0 Bytes
21:00:32 [2021-05-31T21:00:32.550Z]         ├─TableReader_49(Build)	75000000.00	75000000	root		time:844.1ms, loops:73364, cop_task: {num: 153, max: 1.06s, min: 211.6ms, avg: 500.6ms, p95: 889.6ms, max_proc_keys: 723875, p95_proc_keys: 553332, tot_proc: 1m15.8s, tot_wait: 38ms, rpc_num: 153, rpc_time: 1m16.6s, copr_cache: disabled}	data:TableFullScan_48	57.8 MB	N/A
21:00:32 [2021-05-31T21:00:32.550Z]         │ └─TableFullScan_48	75000000.00	75000000	cop[tikv]	table:orders	tikv_task:{proc max:1.04s, min:201ms, p80:505ms, p95:857ms, iters:73975, tasks:153}, scan_detail: {total_process_keys: 75000000, total_keys: 75000153, rocksdb: {delete_skipped_count: 0, key_skipped_count: 149999847, block: {cache_hit_count: 220923, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
21:00:32 [2021-05-31T21:00:32.550Z]         └─Selection_47(Probe)	2733040.07	545246	root		time:1.48s, loops:534	in(substring(tpch50.customer.c_phone, 1, 2), "20", "40", "22", "30", "39", "42", "21")	94.6 KB	N/A
21:00:32 [2021-05-31T21:00:32.550Z]           └─TableReader_46	2733040.07	3407619	root		time:665.5ms, loops:3319, cop_task: {num: 18, max: 1.29s, min: 488.8ms, avg: 898.7ms, p95: 1.29s, max_proc_keys: 582617, p95_proc_keys: 582617, tot_proc: 15.8s, tot_wait: 2ms, rpc_num: 18, rpc_time: 16.2s, copr_cache: disabled}	data:Selection_45	192.5 MB	N/A
21:00:32 [2021-05-31T21:00:32.550Z]             └─Selection_45	2733040.07	3407619	cop[tikv]		tikv_task:{proc max:1.2s, min:432ms, p80:1.04s, p95:1.2s, iters:7404, tasks:18}, scan_detail: {total_process_keys: 7500000, total_keys: 7500018, rocksdb: {delete_skipped_count: 0, key_skipped_count: 14999982, block: {cache_hit_count: 28451, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.customer.c_acctbal, 5000.602894)	N/A	N/A
21:00:32 [2021-05-31T21:00:32.550Z]               └─TableFullScan_44	7500000.00	7500000	cop[tikv]	table:customer	tikv_task:{proc max:1.1s, min:392ms, p80:963ms, p95:1.1s, iters:7404, tasks:18}	keep order:false	N/A	N/A
21:00:32 [2021-05-31T21:00:32.550Z] 
21:00:32 [2021-05-31T21:00:32.550Z] queries/22.sql
21:00:32 [2021-05-31T21:00:32.550Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
21:00:32 [2021-05-31T21:00:32.550Z] Sort_39	2186432.06	4	root		time:24.7s, loops:2	Column#27	9.48 KB	0 Bytes
21:00:32 [2021-05-31T21:00:32.550Z] └─Projection_41	2186432.06	4	root		time:24.7s, loops:5, Concurrency:5	Column#27, Column#28, Column#29	23.7 KB	N/A
21:00:32 [2021-05-31T21:00:32.550Z]   └─HashAgg_42	2186432.06	4	root		time:24.7s, loops:5, partial_worker:{wall_time:24.660011296s, concurrency:5, task_num:180, tot_wait:2m3.243015467s, tot_exec:55.874529ms, tot_time:2m3.299013576s, max:24.659978098s, p95:24.659978098s}, final_worker:{wall_time:24.660036014s, concurrency:5, task_num:20, tot_wait:2m3.29987698s, tot_exec:190.662µs, tot_time:2m3.300086403s, max:24.660024305s, p95:24.660024305s}	group by:Column#33, funcs:count(1)->Column#28, funcs:sum(Column#31)->Column#29, funcs:firstrow(Column#32)->Column#27	857.7 KB	N/A
21:00:32 [2021-05-31T21:00:32.550Z]     └─Projection_51	2186432.06	181704	root		time:24.7s, loops:181, Concurrency:5	tpch50.customer.c_acctbal, substring(tpch50.customer.c_phone, 1, 2)->Column#32, substring(tpch50.customer.c_phone, 1, 2)->Column#33	693.6 KB	N/A
21:00:32 [2021-05-31T21:00:32.550Z]       └─HashJoin_43	2186432.06	181704	root		time:24.7s, loops:181, build_hash_table:{total:23.1s, fetch:956.4ms, build:22.2s}, probe:{concurrency:5, total:2m3.3s, max:24.7s, probe:6.13s, fetch:1m57.2s}	anti semi join, equal:[eq(tpch50.customer.c_custkey, tpch50.orders.o_custkey)]	590.2 MB	0 Bytes
21:00:32 [2021-05-31T21:00:32.550Z]         ├─TableReader_49(Build)	75000000.00	75000000	root		time:959.9ms, loops:73364, cop_task: {num: 153, max: 959.7ms, min: 195.8ms, avg: 490.3ms, p95: 873.7ms, max_proc_keys: 723875, p95_proc_keys: 553332, tot_proc: 1m14.1s, tot_wait: 31ms, rpc_num: 153, rpc_time: 1m15s, copr_cache: disabled}	data:TableFullScan_48	57.8 MB	N/A
21:00:32 [2021-05-31T21:00:32.550Z]         │ └─TableFullScan_48	75000000.00	75000000	cop[tikv]	table:orders	tikv_task:{proc max:917ms, min:186ms, p80:492ms, p95:829ms, iters:73975, tasks:153}, scan_detail: {total_process_keys: 75000000, total_keys: 75000153, rocksdb: {delete_skipped_count: 0, key_skipped_count: 149999847, block: {cache_hit_count: 220923, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
21:00:32 [2021-05-31T21:00:32.550Z]         └─Selection_47(Probe)	2733040.07	545246	root		time:1.63s, loops:534	in(substring(tpch50.customer.c_phone, 1, 2), "20", "40", "22", "30", "39", "42", "21")	94.6 KB	N/A
21:00:32 [2021-05-31T21:00:32.550Z]           └─TableReader_46	2733040.07	3407619	root		time:734.3ms, loops:3319, cop_task: {num: 18, max: 1.24s, min: 540.1ms, avg: 830.6ms, p95: 1.24s, max_proc_keys: 582617, p95_proc_keys: 582617, tot_proc: 14.3s, tot_wait: 1ms, rpc_num: 18, rpc_time: 14.9s, copr_cache: disabled}	data:Selection_45	192.5 MB	N/A
21:00:32 [2021-05-31T21:00:32.550Z]             └─Selection_45	2733040.07	3407619	cop[tikv]		tikv_task:{proc max:1.16s, min:501ms, p80:934ms, 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:00:32 [2021-05-31T21:00:32.550Z]               └─TableFullScan_44	7500000.00	7500000	cop[tikv]	table:customer	tikv_task:{proc max:1.08s, min:454ms, p80:860ms, p95:1.08s, iters:7404, tasks:18}	keep order:false	N/A	N/A
21:00:32 [2021-05-31T21:00:32.550Z] + sync
21:00:32 [2021-05-31T21:00:32.550Z] + /usr/bin/echo 3
21:01:09 [2021-05-31T21:01:09.553Z] 
21:01:09 [2021-05-31T21:01:09.553Z] queries/22.sql
21:01:09 [2021-05-31T21:01:09.553Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
21:01:09 [2021-05-31T21:01:09.553Z] Sort_39	2186432.06	4	root		time:25.6s, loops:2	Column#27	9.48 KB	0 Bytes
21:01:09 [2021-05-31T21:01:09.553Z] └─Projection_41	2186432.06	4	root		time:25.6s, loops:5, Concurrency:5	Column#27, Column#28, Column#29	23.7 KB	N/A
21:01:09 [2021-05-31T21:01:09.553Z]   └─HashAgg_42	2186432.06	4	root		time:25.6s, loops:5, partial_worker:{wall_time:25.601332105s, concurrency:5, task_num:180, tot_wait:2m7.956077714s, tot_exec:50.082882ms, tot_time:2m8.006272611s, max:25.601294217s, p95:25.601294217s}, final_worker:{wall_time:25.601364986s, concurrency:5, task_num:20, tot_wait:2m8.00626752s, tot_exec:120.373µs, tot_time:2m8.006394838s, max:25.601291206s, p95:25.601291206s}	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:09 [2021-05-31T21:01:09.553Z]     └─Projection_51	2186432.06	181704	root		time:25.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	693.6 KB	N/A
21:01:09 [2021-05-31T21:01:09.553Z]       └─HashJoin_43	2186432.06	181704	root		time:25.6s, loops:181, build_hash_table:{total:24.2s, fetch:1.02s, build:23.2s}, probe:{concurrency:5, total:2m8s, max:25.6s, probe:5.66s, fetch:2m2.3s}	anti semi join, equal:[eq(tpch50.customer.c_custkey, tpch50.orders.o_custkey)]	590.2 MB	0 Bytes
21:01:09 [2021-05-31T21:01:09.553Z]         ├─TableReader_49(Build)	75000000.00	75000000	root		time:1.03s, loops:73364, cop_task: {num: 153, max: 1.04s, min: 226.9ms, avg: 487.8ms, p95: 841ms, max_proc_keys: 723875, p95_proc_keys: 553332, tot_proc: 1m13.9s, tot_wait: 37ms, rpc_num: 153, rpc_time: 1m14.6s, copr_cache: disabled}	data:TableFullScan_48	57.8 MB	N/A
21:01:09 [2021-05-31T21:01:09.553Z]         │ └─TableFullScan_48	75000000.00	75000000	cop[tikv]	table:orders	tikv_task:{proc max:1.01s, min:217ms, p80:497ms, p95:816ms, 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:09 [2021-05-31T21:01:09.553Z]         └─Selection_47(Probe)	2733040.07	545246	root		time:1.37s, loops:534	in(substring(tpch50.customer.c_phone, 1, 2), "20", "40", "22", "30", "39", "42", "21")	94.6 KB	N/A
21:01:09 [2021-05-31T21:01:09.553Z]           └─TableReader_46	2733040.07	3407619	root		time:566.9ms, loops:3319, cop_task: {num: 18, max: 1.21s, min: 445.9ms, avg: 849ms, p95: 1.21s, max_proc_keys: 582617, p95_proc_keys: 582617, tot_proc: 14.9s, tot_wait: 1ms, rpc_num: 18, rpc_time: 15.3s, copr_cache: disabled}	data:Selection_45	192.5 MB	N/A
21:01:09 [2021-05-31T21:01:09.553Z]             └─Selection_45	2733040.07	3407619	cop[tikv]		tikv_task:{proc max:1.13s, min:415ms, p80:914ms, 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:01:09 [2021-05-31T21:01:09.553Z]               └─TableFullScan_44	7500000.00	7500000	cop[tikv]	table:customer	tikv_task:{proc max:1.04s, min:382ms, p80:843ms, p95:1.04s, iters:7404, tasks:18}	keep order:false	N/A	N/A
21:01:09 [2021-05-31T21:01:09.553Z] 
21:01:09 [2021-05-31T21:01:09.553Z] + tiup cluster stop benchbot
21:01:09 [2021-05-31T21:01:09.553Z] Starting component `cluster`: /home/tidb/.tiup/components/cluster/v1.4.4/tiup-cluster stop benchbot
21:01:09 [2021-05-31T21:01:09.553Z] + [ 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:01:09 [2021-05-31T21:01:09.553Z] + [Parallel] - UserSSH: user=tidb, host=172.16.5.86
21:01:09 [2021-05-31T21:01:09.553Z] + [Parallel] - UserSSH: user=tidb, host=172.16.5.86
21:01:09 [2021-05-31T21:01:09.553Z] + [Parallel] - UserSSH: user=tidb, host=172.16.5.86
21:01:09 [2021-05-31T21:01:09.553Z] + [Parallel] - UserSSH: user=tidb, host=172.16.5.86
21:01:09 [2021-05-31T21:01:09.553Z] + [Parallel] - UserSSH: user=tidb, host=172.16.5.86
21:01:09 [2021-05-31T21:01:09.553Z] + [ Serial ] - StopCluster
21:01:09 [2021-05-31T21:01:09.553Z] Stopping component grafana
21:01:09 [2021-05-31T21:01:09.553Z] 	Stopping instance 172.16.5.86
21:01:09 [2021-05-31T21:01:09.553Z] 	Stop grafana 172.16.5.86:3000 success
21:01:09 [2021-05-31T21:01:09.553Z] Stopping component prometheus
21:01:09 [2021-05-31T21:01:09.553Z] 	Stopping instance 172.16.5.86
21:01:09 [2021-05-31T21:01:09.553Z] 	Stop prometheus 172.16.5.86:9090 success
21:01:09 [2021-05-31T21:01:09.553Z] Stopping component tidb
21:01:09 [2021-05-31T21:01:09.553Z] 	Stopping instance 172.16.5.86
21:01:09 [2021-05-31T21:01:09.553Z] 	Stop tidb 172.16.5.86:4000 success
21:01:09 [2021-05-31T21:01:09.553Z] Stopping component tikv
21:01:09 [2021-05-31T21:01:09.553Z] 	Stopping instance 172.16.5.86
21:01:12 [2021-05-31T21:01:12.868Z] 	Stop tikv 172.16.5.86:20160 success
21:01:12 [2021-05-31T21:01:12.868Z] Stopping component pd
21:01:12 [2021-05-31T21:01:12.868Z] 	Stopping instance 172.16.5.86
21:01:12 [2021-05-31T21:01:12.868Z] 	Stop pd 172.16.5.86:2379 success
21:01:12 [2021-05-31T21:01:12.868Z] Stopping component node_exporter
21:01:13 [2021-05-31T21:01:13.429Z] Stopping component blackbox_exporter
21:01:13 [2021-05-31T21:01:13.429Z] Stopped cluster `benchbot` successfully
21:01:13 [2021-05-31T21:01:13.696Z] [Pipeline] sh
21:01:13 [2021-05-31T21:01:13.991Z] + cat bench_result
21:01:13 [2021-05-31T21:01:13.998Z] [Pipeline] }
21:01:14 [2021-05-31T21:01:14.001Z] [Pipeline] // dir
21:01:14 [2021-05-31T21:01:14.003Z] [Pipeline] }
21:01:14 [2021-05-31T21:01:14.009Z] [Pipeline] // stage
21:01:14 [2021-05-31T21:01:14.012Z] [Pipeline] }
21:01:14 [2021-05-31T21:01:14.019Z] [Pipeline] // node
21:01:14 [2021-05-31T21:01:14.023Z] [Pipeline] }
21:01:14 [2021-05-31T21:01:14.025Z] [Pipeline] // catchError
21:01:14 [2021-05-31T21:01:14.031Z] [Pipeline] stage
21:01:14 [2021-05-31T21:01:14.034Z] [Pipeline] { (Summary)
21:01:14 [2021-05-31T21:01:14.067Z] sh: line 1: 107556 Terminated              sleep 3
21:01:14 [2021-05-31T21:01:14.053Z] [Pipeline] slackSend
21:01:14 [2021-05-31T21:01:14.053Z] 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:01:14 [2021-05-31T21:01:14.083Z] sh: line 1: 107417 Terminated              sleep 3
21:01:14 [2021-05-31T21:01:14.646Z] [Pipeline] }
21:01:14 [2021-05-31T21:01:14.649Z] [Pipeline] // stage
21:01:14 [2021-05-31T21:01:14.652Z] [Pipeline] End of Pipeline
21:01:14 [2021-05-31T21:01:14.674Z] Finished: SUCCESS