SuccessConsole Output

Skipping 1,193 KB.. Full Log
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:39:03 [2021-06-03T20:39:03.084Z]         └─HashJoin_59	9711455.06	634004	root		time:37.7s, loops:625, build_hash_table:{total:2.4s, fetch:2.16s, build:234.7ms}, probe:{concurrency:5, total:3m8.3s, max:37.7s, probe:15.1s, fetch:2m53.2s}	left outer join, equal:[eq(tpch50.partsupp.ps_partkey, tpch50.lineitem.l_partkey) eq(tpch50.partsupp.ps_suppkey, tpch50.lineitem.l_suppkey)]	10.4 MB	0 Bytes
20:39:03 [2021-06-03T20:39:03.084Z]           ├─IndexHashJoin_67(Build)	321865.05	435528	root		time:2.34s, loops:430, inner:{total:2.68s, concurrency:5, task:12, construct:149.1ms, fetch:2.18s, build:32.5ms, join:356ms}	inner join, inner:IndexLookUp_64, outer key:tpch50.part.p_partkey, inner key:tpch50.partsupp.ps_partkey, equal cond:eq(tpch50.part.p_partkey, tpch50.partsupp.ps_partkey)	20.0 MB	N/A
20:39:03 [2021-06-03T20:39:03.084Z]           │ ├─TableReader_96(Build)	80007.93	108882	root		time:1.99s, loops:112, cop_task: {num: 20, max: 1.51s, min: 650ms, avg: 1.09s, p95: 1.51s, max_proc_keys: 686055, p95_proc_keys: 686055, tot_proc: 21.7s, tot_wait: 6ms, rpc_num: 20, rpc_time: 21.7s, copr_cache: disabled}	data:Selection_95	725.8 KB	N/A
20:39:03 [2021-06-03T20:39:03.084Z]           │ │ └─Selection_95	80007.93	108882	cop[tikv]		tikv_task:{proc max:1.46s, min:645ms, p80:1.32s, p95:1.46s, iters:9859, tasks:20}, scan_detail: {total_process_keys: 10000000, total_keys: 10000020, rocksdb: {delete_skipped_count: 0, key_skipped_count: 19999980, block: {cache_hit_count: 31499, read_count: 0, read_byte: 0 Bytes}}}	like(tpch50.part.p_name, "green%", 92)	N/A	N/A
20:39:03 [2021-06-03T20:39:03.084Z]           │ │   └─TableFullScan_94	10000000.00	10000000	cop[tikv]	table:part	tikv_task:{proc max:1.36s, min:608ms, p80:1.25s, p95:1.36s, iters:9859, tasks:20}	keep order:false	N/A	N/A
20:39:03 [2021-06-03T20:39:03.084Z]           │ └─IndexLookUp_64(Probe)	4.02	435528	root		time:2.06s, loops:447, index_task: {total_time: 1.25s, fetch_handle: 1.25s, build: 99.4µs, wait: 275.3µs}, table_task: {total_time: 8.08s, num: 56, concurrency: 60}		20.5 KB	N/A
20:39:03 [2021-06-03T20:39:03.084Z]           │   ├─IndexRangeScan_62(Build)	4.02	435528	cop[tikv]	table:partsupp, index:PRIMARY(PS_PARTKEY, PS_SUPPKEY)	time:1.21s, loops:478, cop_task: {num: 59, max: 185.4ms, min: 5.28ms, avg: 86.5ms, p95: 180.6ms, max_proc_keys: 15288, p95_proc_keys: 15048, tot_proc: 4.7s, tot_wait: 42ms, rpc_num: 59, rpc_time: 5.1s, copr_cache: disabled}, tikv_task:{proc max:180ms, min:4ms, p80:135ms, p95:169ms, iters:692, tasks:59}, scan_detail: {total_process_keys: 435528, total_keys: 544410, rocksdb: {delete_skipped_count: 0, key_skipped_count: 435528, block: {cache_hit_count: 980292, read_count: 0, read_byte: 0 Bytes}}}	range: decided by [eq(tpch50.partsupp.ps_partkey, tpch50.part.p_partkey)], keep order:false	N/A	N/A
20:39:03 [2021-06-03T20:39:03.084Z]           │   └─TableRowIDScan_63(Probe)	4.02	435528	cop[tikv]	table:partsupp	time:2.5s, loops:503, cop_task: {num: 1410, max: 62.8ms, min: 458.1µs, avg: 18.4ms, p95: 38.4ms, max_proc_keys: 976, p95_proc_keys: 600, tot_proc: 19s, tot_wait: 4.96s, rpc_num: 1410, rpc_time: 26s, copr_cache: disabled}, tikv_task:{proc max:44ms, min:0s, p80:17ms, p95:25ms, iters:5245, tasks:1410}, scan_detail: {total_process_keys: 435528, total_keys: 473499, rocksdb: {delete_skipped_count: 0, key_skipped_count: 194043, block: {cache_hit_count: 3644169, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:39:03 [2021-06-03T20:39:03.084Z]           └─TableReader_101(Probe)	46310896.67	45504356	root		time:33.2s, loops:44290, cop_task: {num: 761, max: 1.21s, min: 322.1ms, avg: 704.6ms, p95: 861.7ms, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 8m53.1s, tot_wait: 141ms, rpc_num: 761, rpc_time: 8m56.2s, copr_cache: disabled}	data:Selection_100	52.6 MB	N/A
20:39:03 [2021-06-03T20:39:03.084Z]             └─Selection_100	46310896.67	45504356	cop[tikv]		tikv_task:{proc max:1.15s, min:315ms, p80:750ms, p95:844ms, iters:296606, tasks:761}, scan_detail: {total_process_keys: 300005811, total_keys: 300006572, rocksdb: {delete_skipped_count: 0, key_skipped_count: 600010861, block: {cache_hit_count: 1124648, read_count: 0, read_byte: 0 Bytes}}}	ge(tpch50.lineitem.l_shipdate, 1993-01-01 00:00:00.000000), lt(tpch50.lineitem.l_shipdate, 1994-01-01)	N/A	N/A
20:39:03 [2021-06-03T20:39:03.084Z]               └─TableFullScan_99	300005811.00	300005811	cop[tikv]	table:lineitem	tikv_task:{proc max:1.11s, min:301ms, p80:721ms, p95:813ms, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:39:03 [2021-06-03T20:39:03.084Z] + sync
20:39:03 [2021-06-03T20:39:03.084Z] + /usr/bin/echo 3
20:39:42 [2021-06-03T20:39:42.770Z] + sync
20:39:42 [2021-06-03T20:39:42.770Z] + /usr/bin/echo 3
20:40:29 [2021-06-03T20:40:29.420Z] 
20:40:29 [2021-06-03T20:40:29.420Z] queries/20.sql
20:40:29 [2021-06-03T20:40:29.420Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:40:29 [2021-06-03T20:40:29.420Z] Sort_30	20000.00	8982	root		time:38.5s, loops:10	tpch50.supplier.s_name	607.7 KB	0 Bytes
20:40:29 [2021-06-03T20:40:29.420Z] └─HashJoin_35	20000.00	8982	root		time:38.5s, loops:11, build_hash_table:{total:1.28s, fetch:1.27s, build:10.1ms}, probe:{concurrency:5, total:3m12.4s, max:38.5s, probe:49.5ms, fetch:3m12.4s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.partsupp.ps_suppkey)]	1.50 MB	0 Bytes
20:40:29 [2021-06-03T20:40:29.420Z]   ├─HashJoin_48(Build)	20000.00	19972	root		time:1.27s, loops:23, build_hash_table:{total:166.3µs, fetch:159.1µs, build:7.16µs}, probe:{concurrency:5, total:6.37s, max:1.27s, probe:87.7ms, fetch:6.28s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:40:29 [2021-06-03T20:40:29.420Z]   │ ├─TableReader_53(Build)	1.00	1	root		time:29.3µs, loops:2, cop_task: {num: 1, max: 940.3µs, proc_keys: 25, rpc_num: 1, rpc_time: 926.1µs, copr_cache: disabled}	data:Selection_52	240 Bytes	N/A
20:40:29 [2021-06-03T20:40:29.420Z]   │ │ └─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:29 [2021-06-03T20:40:29.420Z]   │ │   └─TableFullScan_51	25.00	25	cop[tikv]	table:nation	tikv_task:{time:0s, loops:1}	keep order:false	N/A	N/A
20:40:29 [2021-06-03T20:40:29.420Z]   │ └─TableReader_50(Probe)	500000.00	500000	root		time:1.26s, loops:490, cop_task: {num: 1, max: 1.26s, proc_keys: 500000, tot_proc: 1.18s, rpc_num: 1, rpc_time: 1.26s, copr_cache: disabled}	data:TableFullScan_49	35.8 MB	N/A
20:40:29 [2021-06-03T20:40:29.420Z]   │   └─TableFullScan_49	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:994ms, 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:29 [2021-06-03T20:40:29.420Z]   └─HashAgg_54(Probe)	257492.04	223999	root		time:38.5s, loops:222, partial_worker:{wall_time:38.412964484s, concurrency:5, task_num:289, tot_wait:3m11.823162032s, tot_exec:202.616983ms, tot_time:3m12.060356295s, max:38.412918904s, p95:38.412918904s}, final_worker:{wall_time:38.486178737s, concurrency:5, task_num:25, tot_wait:3m12.050742989s, tot_exec:352.623705ms, tot_time:3m12.403380316s, max:38.486121073s, p95:38.486121073s}	group by:tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_suppkey)->tpch50.partsupp.ps_suppkey	61.4 MB	N/A
20:40:29 [2021-06-03T20:40:29.420Z]     └─Selection_55	257492.04	295898	root		time:38.4s, loops:290	gt(cast(tpch50.partsupp.ps_availqty, decimal(20,0) BINARY), mul(0.5, Column#44))	59.2 KB	N/A
20:40:29 [2021-06-03T20:40:29.420Z]       └─HashAgg_56	321865.05	435528	root		time:38.3s, loops:430, partial_worker:{wall_time:38.062440912s, concurrency:5, task_num:624, tot_wait:3m8.96723782s, tot_exec:1.194994455s, tot_time:3m10.292502884s, max:38.062373146s, p95:38.062373146s}, final_worker:{wall_time:38.403595065s, concurrency:5, task_num:25, tot_wait:3m10.276364216s, tot_exec:1.703276302s, tot_time:3m11.979657786s, max:38.403550283s, p95:38.403550283s}	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:29 [2021-06-03T20:40:29.420Z]         └─HashJoin_59	9711455.06	634004	root		time:38s, loops:625, build_hash_table:{total:2.59s, fetch:2.4s, build:189.2ms}, probe:{concurrency:5, total:3m9.8s, max:38s, probe:14.8s, fetch:2m54.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:40:29 [2021-06-03T20:40:29.420Z]           ├─IndexHashJoin_67(Build)	321865.05	435528	root		time:2.55s, loops:429, inner:{total:2.85s, concurrency:5, task:12, construct:127.4ms, fetch:2.43s, build:25.5ms, join:298.9ms}	inner join, inner:IndexLookUp_64, outer key:tpch50.part.p_partkey, inner key:tpch50.partsupp.ps_partkey, equal cond:eq(tpch50.part.p_partkey, tpch50.partsupp.ps_partkey)	20.0 MB	N/A
20:40:29 [2021-06-03T20:40:29.420Z]           │ ├─TableReader_96(Build)	80007.93	108882	root		time:2.13s, loops:112, cop_task: {num: 20, max: 1.54s, min: 663.4ms, avg: 1.07s, p95: 1.54s, max_proc_keys: 686055, p95_proc_keys: 686055, tot_proc: 21.2s, tot_wait: 26ms, rpc_num: 20, rpc_time: 21.3s, copr_cache: disabled}	data:Selection_95	660.2 KB	N/A
20:40:29 [2021-06-03T20:40:29.420Z]           │ │ └─Selection_95	80007.93	108882	cop[tikv]		tikv_task:{proc max:1.51s, min:658ms, p80:1.26s, p95:1.51s, iters:9859, tasks:20}, scan_detail: {total_process_keys: 10000000, total_keys: 10000020, rocksdb: {delete_skipped_count: 0, key_skipped_count: 19999980, block: {cache_hit_count: 31499, read_count: 0, read_byte: 0 Bytes}}}	like(tpch50.part.p_name, "green%", 92)	N/A	N/A
20:40:29 [2021-06-03T20:40:29.420Z]           │ │   └─TableFullScan_94	10000000.00	10000000	cop[tikv]	table:part	tikv_task:{proc max:1.4s, min:602ms, p80:1.17s, p95:1.4s, iters:9859, tasks:20}	keep order:false	N/A	N/A
20:40:29 [2021-06-03T20:40:29.420Z]           │ └─IndexLookUp_64(Probe)	4.02	435528	root		time:2.31s, loops:447, index_task: {total_time: 1.34s, fetch_handle: 1.34s, build: 104.4µs, wait: 272.5µs}, table_task: {total_time: 8.57s, num: 55, concurrency: 60}		20.7 KB	N/A
20:40:29 [2021-06-03T20:40:29.420Z]           │   ├─IndexRangeScan_62(Build)	4.02	435528	cop[tikv]	table:partsupp, index:PRIMARY(PS_PARTKEY, PS_SUPPKEY)	time:1.3s, loops:477, cop_task: {num: 58, max: 269.2ms, min: 3.66ms, avg: 92.5ms, p95: 171.3ms, max_proc_keys: 15288, p95_proc_keys: 15008, tot_proc: 4.91s, tot_wait: 64ms, rpc_num: 58, rpc_time: 5.36s, copr_cache: disabled}, tikv_task:{proc max:260ms, min:2ms, p80:145ms, p95:158ms, 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:40:29 [2021-06-03T20:40:29.420Z]           │   └─TableRowIDScan_63(Probe)	4.02	435528	cop[tikv]	table:partsupp	time:2.89s, loops:501, cop_task: {num: 1491, max: 99.8ms, min: 443.1µs, avg: 18.2ms, p95: 37.5ms, max_proc_keys: 956, p95_proc_keys: 504, tot_proc: 19.6s, tot_wait: 4.81s, rpc_num: 1491, rpc_time: 27.1s, copr_cache: disabled}, tikv_task:{proc max:46ms, min:0s, p80:16ms, p95:22ms, iters:5465, tasks:1491}, scan_detail: {total_process_keys: 435528, total_keys: 473501, rocksdb: {delete_skipped_count: 0, key_skipped_count: 194043, block: {cache_hit_count: 3644520, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:40:29 [2021-06-03T20:40:29.420Z]           └─TableReader_101(Probe)	46310896.67	45504356	root		time:33.3s, loops:44289, cop_task: {num: 761, max: 1.16s, min: 314.5ms, avg: 705ms, p95: 867.2ms, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 8m53.4s, tot_wait: 116ms, rpc_num: 761, rpc_time: 8m56.5s, copr_cache: disabled}	data:Selection_100	52.6 MB	N/A
20:40:29 [2021-06-03T20:40:29.420Z]             └─Selection_100	46310896.67	45504356	cop[tikv]		tikv_task:{proc max:1.13s, min:308ms, p80:757ms, p95:849ms, 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:29 [2021-06-03T20:40:29.420Z]               └─TableFullScan_99	300005811.00	300005811	cop[tikv]	table:lineitem	tikv_task:{proc max:1.09s, min:296ms, p80:726ms, p95:818ms, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:40:29 [2021-06-03T20:40:29.420Z] 
20:40:29 [2021-06-03T20:40:29.420Z] queries/20.sql
20:40:29 [2021-06-03T20:40:29.421Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:40:29 [2021-06-03T20:40:29.421Z] Sort_30	20000.00	8982	root		time:38.4s, loops:10	tpch50.supplier.s_name	614.3 KB	0 Bytes
20:40:29 [2021-06-03T20:40:29.421Z] └─HashJoin_35	20000.00	8982	root		time:38.4s, loops:11, build_hash_table:{total:1.34s, fetch:1.32s, build:18.6ms}, probe:{concurrency:5, total:3m12s, max:38.4s, probe:48.6ms, fetch:3m11.9s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.partsupp.ps_suppkey)]	1.53 MB	0 Bytes
20:40:29 [2021-06-03T20:40:29.421Z]   ├─HashJoin_48(Build)	20000.00	19972	root		time:1.33s, loops:24, build_hash_table:{total:143.5µs, fetch:138.8µs, build:4.72µs}, probe:{concurrency:5, total:6.69s, max:1.34s, probe:155ms, fetch:6.54s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:40:29 [2021-06-03T20:40:29.421Z]   │ ├─TableReader_53(Build)	1.00	1	root		time:37µs, loops:2, cop_task: {num: 1, max: 1.1ms, proc_keys: 25, tot_proc: 1ms, rpc_num: 1, rpc_time: 1.06ms, copr_cache: disabled}	data:Selection_52	244 Bytes	N/A
20:40:29 [2021-06-03T20:40:29.421Z]   │ │ └─Selection_52	1.00	1	cop[tikv]		tikv_task:{time:1ms, loops:1}, scan_detail: {total_process_keys: 25, total_keys: 26, rocksdb: {delete_skipped_count: 0, key_skipped_count: 46, block: {cache_hit_count: 18, read_count: 0, read_byte: 0 Bytes}}}	eq(tpch50.nation.n_name, "ALGERIA")	N/A	N/A
20:40:29 [2021-06-03T20:40:29.421Z]   │ │   └─TableFullScan_51	25.00	25	cop[tikv]	table:nation	tikv_task:{time:1ms, loops:1}	keep order:false	N/A	N/A
20:40:29 [2021-06-03T20:40:29.421Z]   │ └─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.24s, rpc_num: 1, rpc_time: 1.31s, copr_cache: disabled}	data:TableFullScan_49	35.8 MB	N/A
20:40:29 [2021-06-03T20:40:29.421Z]   │   └─TableFullScan_49	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:1.09s, loops:493}, scan_detail: {total_process_keys: 500000, total_keys: 500001, rocksdb: {delete_skipped_count: 0, key_skipped_count: 999999, block: {cache_hit_count: 1692, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:40:29 [2021-06-03T20:40:29.421Z]   └─HashAgg_54(Probe)	257492.04	223999	root		time:38.4s, loops:222, partial_worker:{wall_time:38.282332242s, concurrency:5, task_num:289, tot_wait:3m11.159866171s, tot_exec:202.358538ms, tot_time:3m11.397360028s, max:38.282059432s, p95:38.282059432s}, final_worker:{wall_time:38.396260637s, concurrency:5, task_num:25, tot_wait:3m11.385419865s, tot_exec:579.114746ms, tot_time:3m11.964550525s, max:38.396015598s, p95:38.396015598s}	group by:tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_suppkey)->tpch50.partsupp.ps_suppkey	61.4 MB	N/A
20:40:29 [2021-06-03T20:40:29.421Z]     └─Selection_55	257492.04	295898	root		time:38.3s, loops:290	gt(cast(tpch50.partsupp.ps_availqty, decimal(20,0) BINARY), mul(0.5, Column#44))	59.2 KB	N/A
20:40:29 [2021-06-03T20:40:29.421Z]       └─HashAgg_56	321865.05	435528	root		time:38.2s, loops:430, partial_worker:{wall_time:37.926844118s, concurrency:5, task_num:624, tot_wait:3m8.422952456s, tot_exec:1.074150714s, tot_time:3m9.612686737s, max:37.92674299s, p95:37.92674299s}, final_worker:{wall_time:38.270748695s, concurrency:5, task_num:25, tot_wait:3m9.604428426s, tot_exec:1.70557972s, tot_time:3m11.310022373s, max:38.270667589s, p95:38.270667589s}	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:29 [2021-06-03T20:40:29.421Z]         └─HashJoin_59	9711455.06	634004	root		time:37.8s, loops:625, build_hash_table:{total:2.43s, fetch:2.22s, build:206.8ms}, probe:{concurrency:5, total:3m9.2s, max:37.8s, probe:14.9s, fetch:2m54.4s}	left outer join, equal:[eq(tpch50.partsupp.ps_partkey, tpch50.lineitem.l_partkey) eq(tpch50.partsupp.ps_suppkey, tpch50.lineitem.l_suppkey)]	10.4 MB	0 Bytes
20:40:29 [2021-06-03T20:40:29.421Z]           ├─IndexHashJoin_67(Build)	321865.05	435528	root		time:2.38s, loops:430, inner:{total:2.56s, concurrency:5, task:12, construct:111.2ms, fetch:2.12s, build:23ms, join:326.3ms}	inner join, inner:IndexLookUp_64, outer key:tpch50.part.p_partkey, inner key:tpch50.partsupp.ps_partkey, equal cond:eq(tpch50.part.p_partkey, tpch50.partsupp.ps_partkey)	20.0 MB	N/A
20:40:29 [2021-06-03T20:40:29.421Z]           │ ├─TableReader_96(Build)	80007.93	108882	root		time:2.04s, loops:112, cop_task: {num: 20, max: 1.52s, min: 527.4ms, avg: 1.06s, p95: 1.52s, max_proc_keys: 686055, p95_proc_keys: 686055, tot_proc: 21.2s, tot_wait: 11ms, rpc_num: 20, rpc_time: 21.2s, copr_cache: disabled}	data:Selection_95	680.6 KB	N/A
20:40:29 [2021-06-03T20:40:29.421Z]           │ │ └─Selection_95	80007.93	108882	cop[tikv]		tikv_task:{proc max:1.5s, min:524ms, p80:1.21s, p95:1.5s, iters:9859, tasks:20}, scan_detail: {total_process_keys: 10000000, total_keys: 10000020, rocksdb: {delete_skipped_count: 0, key_skipped_count: 19999980, block: {cache_hit_count: 31499, read_count: 0, read_byte: 0 Bytes}}}	like(tpch50.part.p_name, "green%", 92)	N/A	N/A
20:40:29 [2021-06-03T20:40:29.421Z]           │ │   └─TableFullScan_94	10000000.00	10000000	cop[tikv]	table:part	tikv_task:{proc max:1.4s, min:489ms, p80:1.11s, p95:1.4s, iters:9859, tasks:20}	keep order:false	N/A	N/A
20:40:29 [2021-06-03T20:40:29.421Z]           │ └─IndexLookUp_64(Probe)	4.02	435528	root		time:2.02s, loops:447, index_task: {total_time: 1.2s, fetch_handle: 1.2s, build: 113.7µs, wait: 311.2µs}, table_task: {total_time: 7.76s, num: 56, concurrency: 60}		20.5 KB	N/A
20:40:29 [2021-06-03T20:40:29.421Z]           │   ├─IndexRangeScan_62(Build)	4.02	435528	cop[tikv]	table:partsupp, index:PRIMARY(PS_PARTKEY, PS_SUPPKEY)	time:1.15s, loops:483, cop_task: {num: 61, max: 235ms, min: 4.49ms, avg: 91.1ms, p95: 182.1ms, max_proc_keys: 15288, p95_proc_keys: 14948, tot_proc: 5s, tot_wait: 206ms, rpc_num: 61, rpc_time: 5.56s, copr_cache: disabled}, tikv_task:{proc max:181ms, min:4ms, p80:137ms, p95:165ms, iters:701, tasks:61}, scan_detail: {total_process_keys: 435528, total_keys: 544410, rocksdb: {delete_skipped_count: 0, key_skipped_count: 435528, block: {cache_hit_count: 980292, read_count: 0, read_byte: 0 Bytes}}}	range: decided by [eq(tpch50.partsupp.ps_partkey, tpch50.part.p_partkey)], keep order:false	N/A	N/A
20:40:29 [2021-06-03T20:40:29.421Z]           │   └─TableRowIDScan_63(Probe)	4.02	435528	cop[tikv]	table:partsupp	time:2.55s, loops:508, cop_task: {num: 1436, max: 80.5ms, min: 425.9µs, avg: 17.7ms, p95: 36.3ms, max_proc_keys: 908, p95_proc_keys: 584, tot_proc: 18.9s, tot_wait: 4.49s, rpc_num: 1436, rpc_time: 25.4s, copr_cache: disabled}, tikv_task:{proc max:54ms, min:0s, p80:17ms, p95:24ms, iters:5342, tasks:1436}, scan_detail: {total_process_keys: 435528, total_keys: 473506, rocksdb: {delete_skipped_count: 0, key_skipped_count: 194072, block: {cache_hit_count: 3644237, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:40:29 [2021-06-03T20:40:29.421Z]           └─TableReader_101(Probe)	46310896.67	45504356	root		time:33.4s, loops:44289, cop_task: {num: 761, max: 1.16s, min: 334.9ms, avg: 705.8ms, p95: 852.4ms, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 8m54s, tot_wait: 140ms, rpc_num: 761, rpc_time: 8m57.1s, copr_cache: disabled}	data:Selection_100	52.6 MB	N/A
20:40:29 [2021-06-03T20:40:29.421Z]             └─Selection_100	46310896.67	45504356	cop[tikv]		tikv_task:{proc max:1.11s, min:326ms, p80:753ms, p95:831ms, iters:296606, tasks:761}, scan_detail: {total_process_keys: 300005811, total_keys: 300006572, rocksdb: {delete_skipped_count: 0, key_skipped_count: 600010861, block: {cache_hit_count: 1124648, read_count: 0, read_byte: 0 Bytes}}}	ge(tpch50.lineitem.l_shipdate, 1993-01-01 00:00:00.000000), lt(tpch50.lineitem.l_shipdate, 1994-01-01)	N/A	N/A
20:40:29 [2021-06-03T20:40:29.421Z]               └─TableFullScan_99	300005811.00	300005811	cop[tikv]	table:lineitem	tikv_task:{proc max:1.07s, min:307ms, p80:725ms, p95:802ms, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:40:29 [2021-06-03T20:40:29.421Z] + sync
20:40:29 [2021-06-03T20:40:29.421Z] + /usr/bin/echo 3
20:41:08 [2021-06-03T20:41:08.217Z] + sync
20:41:08 [2021-06-03T20:41:08.217Z] + /usr/bin/echo 3
20:41:46 [2021-06-03T20:41:46.873Z] 
20:41:46 [2021-06-03T20:41:46.873Z] queries/20.sql
20:41:46 [2021-06-03T20:41:46.873Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:41:46 [2021-06-03T20:41:46.873Z] Sort_30	20000.00	8982	root		time:38.1s, loops:10	tpch50.supplier.s_name	598.0 KB	0 Bytes
20:41:46 [2021-06-03T20:41:46.873Z] └─HashJoin_35	20000.00	8982	root		time:38.1s, loops:11, build_hash_table:{total:1.22s, fetch:1.21s, build:7.83ms}, probe:{concurrency:5, total:3m10.3s, max:38.1s, probe:51ms, fetch:3m10.3s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.partsupp.ps_suppkey)]	1.50 MB	0 Bytes
20:41:46 [2021-06-03T20:41:46.873Z]   ├─HashJoin_48(Build)	20000.00	19972	root		time:1.21s, loops:23, build_hash_table:{total:160µs, fetch:155.1µs, build:4.89µs}, probe:{concurrency:5, total:6.07s, max:1.21s, probe:82.7ms, fetch:5.99s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:41:46 [2021-06-03T20:41:46.873Z]   │ ├─TableReader_53(Build)	1.00	1	root		time:36.1µs, loops:2, cop_task: {num: 1, max: 1.45ms, proc_keys: 25, rpc_num: 1, rpc_time: 1.43ms, copr_cache: disabled}	data:Selection_52	240 Bytes	N/A
20:41:46 [2021-06-03T20:41:46.873Z]   │ │ └─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:46 [2021-06-03T20:41:46.873Z]   │ │   └─TableFullScan_51	25.00	25	cop[tikv]	table:nation	tikv_task:{time:0s, loops:1}	keep order:false	N/A	N/A
20:41:46 [2021-06-03T20:41:46.873Z]   │ └─TableReader_50(Probe)	500000.00	500000	root		time:1.2s, loops:490, cop_task: {num: 1, max: 1.2s, proc_keys: 500000, tot_proc: 1.12s, rpc_num: 1, rpc_time: 1.2s, copr_cache: disabled}	data:TableFullScan_49	35.8 MB	N/A
20:41:46 [2021-06-03T20:41:46.873Z]   │   └─TableFullScan_49	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:997ms, 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:46 [2021-06-03T20:41:46.873Z]   └─HashAgg_54(Probe)	257492.04	223999	root		time:38.1s, loops:222, partial_worker:{wall_time:37.958070156s, concurrency:5, task_num:289, tot_wait:3m9.558687241s, tot_exec:189.701107ms, tot_time:3m9.783426526s, max:37.957780839s, p95:37.957780839s}, final_worker:{wall_time:38.064269773s, concurrency:5, task_num:25, tot_wait:3m9.776549167s, tot_exec:534.480708ms, tot_time:3m10.31104594s, max:38.063982906s, p95:38.063982906s}	group by:tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_suppkey)->tpch50.partsupp.ps_suppkey	61.4 MB	N/A
20:41:46 [2021-06-03T20:41:46.873Z]     └─Selection_55	257492.04	295898	root		time:37.9s, loops:290	gt(cast(tpch50.partsupp.ps_availqty, decimal(20,0) BINARY), mul(0.5, Column#44))	59.2 KB	N/A
20:41:46 [2021-06-03T20:41:46.873Z]       └─HashAgg_56	321865.05	435528	root		time:37.9s, loops:430, partial_worker:{wall_time:37.613621068s, concurrency:5, task_num:624, tot_wait:3m6.852100959s, tot_exec:1.079085282s, tot_time:3m8.047859043s, max:37.613516984s, p95:37.613516984s}, final_worker:{wall_time:37.948224775s, concurrency:5, task_num:25, tot_wait:3m8.038351088s, tot_exec:1.656532579s, tot_time:3m9.694898941s, max:37.948100898s, p95:37.948100898s}	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:46 [2021-06-03T20:41:46.873Z]         └─HashJoin_59	9711455.06	634004	root		time:37.5s, loops:625, build_hash_table:{total:2.56s, fetch:2.35s, build:206.6ms}, probe:{concurrency:5, total:3m7.7s, max:37.5s, probe:14.8s, fetch:2m52.8s}	left outer join, equal:[eq(tpch50.partsupp.ps_partkey, tpch50.lineitem.l_partkey) eq(tpch50.partsupp.ps_suppkey, tpch50.lineitem.l_suppkey)]	10.4 MB	0 Bytes
20:41:46 [2021-06-03T20:41:46.873Z]           ├─IndexHashJoin_67(Build)	321865.05	435528	root		time:2.52s, loops:430, inner:{total:2.6s, concurrency:5, task:12, construct:128.8ms, fetch:2.14s, build:22.9ms, join:332.8ms}	inner join, inner:IndexLookUp_64, outer key:tpch50.part.p_partkey, inner key:tpch50.partsupp.ps_partkey, equal cond:eq(tpch50.part.p_partkey, tpch50.partsupp.ps_partkey)	19.9 MB	N/A
20:41:46 [2021-06-03T20:41:46.873Z]           │ ├─TableReader_96(Build)	80007.93	108882	root		time:2.17s, loops:112, cop_task: {num: 20, max: 1.53s, min: 649.9ms, avg: 1.11s, p95: 1.53s, max_proc_keys: 686055, p95_proc_keys: 686055, tot_proc: 22.2s, tot_wait: 8ms, rpc_num: 20, rpc_time: 22.2s, copr_cache: disabled}	data:Selection_95	665.9 KB	N/A
20:41:46 [2021-06-03T20:41:46.873Z]           │ │ └─Selection_95	80007.93	108882	cop[tikv]		tikv_task:{proc max:1.47s, min:647ms, p80:1.24s, p95:1.47s, iters:9859, tasks:20}, scan_detail: {total_process_keys: 10000000, total_keys: 10000020, rocksdb: {delete_skipped_count: 0, key_skipped_count: 19999980, block: {cache_hit_count: 31499, read_count: 0, read_byte: 0 Bytes}}}	like(tpch50.part.p_name, "green%", 92)	N/A	N/A
20:41:46 [2021-06-03T20:41:46.873Z]           │ │   └─TableFullScan_94	10000000.00	10000000	cop[tikv]	table:part	tikv_task:{proc max:1.38s, min:603ms, p80:1.16s, p95:1.38s, iters:9859, tasks:20}	keep order:false	N/A	N/A
20:41:46 [2021-06-03T20:41:46.873Z]           │ └─IndexLookUp_64(Probe)	4.02	435528	root		time:2.02s, loops:447, index_task: {total_time: 1.19s, fetch_handle: 1.19s, build: 117µs, wait: 283.5µs}, table_task: {total_time: 7.85s, num: 56, concurrency: 60}		20.7 KB	N/A
20:41:46 [2021-06-03T20:41:46.873Z]           │   ├─IndexRangeScan_62(Build)	4.02	435528	cop[tikv]	table:partsupp, index:PRIMARY(PS_PARTKEY, PS_SUPPKEY)	time:1.15s, loops:478, cop_task: {num: 60, max: 213.8ms, min: 5.49ms, avg: 89ms, p95: 172.5ms, max_proc_keys: 15288, p95_proc_keys: 15008, tot_proc: 4.88s, tot_wait: 77ms, rpc_num: 60, rpc_time: 5.34s, copr_cache: disabled}, tikv_task:{proc max:196ms, min:5ms, p80:135ms, p95:162ms, iters:695, 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:46 [2021-06-03T20:41:46.873Z]           │   └─TableRowIDScan_63(Probe)	4.02	435528	cop[tikv]	table:partsupp	time:2.6s, loops:504, cop_task: {num: 1337, max: 93.4ms, min: 415µs, avg: 19ms, p95: 42.4ms, max_proc_keys: 1028, p95_proc_keys: 664, tot_proc: 19.1s, tot_wait: 4.09s, rpc_num: 1337, rpc_time: 25.4s, copr_cache: disabled}, tikv_task:{proc max:45ms, min:0s, p80:19ms, p95:28ms, iters:5044, tasks:1337}, scan_detail: {total_process_keys: 435528, total_keys: 473530, rocksdb: {delete_skipped_count: 0, key_skipped_count: 194140, block: {cache_hit_count: 3643508, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:41:46 [2021-06-03T20:41:46.873Z]           └─TableReader_101(Probe)	46310896.67	45504356	root		time:32.8s, loops:44289, cop_task: {num: 761, max: 1.19s, min: 264.2ms, avg: 699ms, p95: 846.7ms, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 8m48.7s, tot_wait: 126ms, rpc_num: 761, rpc_time: 8m51.9s, copr_cache: disabled}	data:Selection_100	52.6 MB	N/A
20:41:46 [2021-06-03T20:41:46.873Z]             └─Selection_100	46310896.67	45504356	cop[tikv]		tikv_task:{proc max:1.13s, min:257ms, p80:741ms, p95:831ms, iters:296606, tasks:761}, scan_detail: {total_process_keys: 300005811, total_keys: 300006572, rocksdb: {delete_skipped_count: 0, key_skipped_count: 600010861, block: {cache_hit_count: 1124648, read_count: 0, read_byte: 0 Bytes}}}	ge(tpch50.lineitem.l_shipdate, 1993-01-01 00:00:00.000000), lt(tpch50.lineitem.l_shipdate, 1994-01-01)	N/A	N/A
20:41:46 [2021-06-03T20:41:46.873Z]               └─TableFullScan_99	300005811.00	300005811	cop[tikv]	table:lineitem	tikv_task:{proc max:1.08s, min:239ms, p80:709ms, p95:801ms, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:41:46 [2021-06-03T20:41:46.873Z] 
20:41:46 [2021-06-03T20:41:46.874Z] queries/20.sql
20:41:46 [2021-06-03T20:41:46.874Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:41:46 [2021-06-03T20:41:46.874Z] Sort_30	20000.00	8982	root		time:37.9s, loops:10	tpch50.supplier.s_name	614.3 KB	0 Bytes
20:41:46 [2021-06-03T20:41:46.874Z] └─HashJoin_35	20000.00	8982	root		time:37.9s, loops:11, build_hash_table:{total:1.33s, fetch:1.32s, build:8.96ms}, probe:{concurrency:5, total:3m9.5s, max:37.9s, probe:48.4ms, fetch:3m9.5s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.partsupp.ps_suppkey)]	1.51 MB	0 Bytes
20:41:46 [2021-06-03T20:41:46.874Z]   ├─HashJoin_48(Build)	20000.00	19972	root		time:1.33s, loops:23, build_hash_table:{total:186.5µs, fetch:178.3µs, build:8.23µs}, probe:{concurrency:5, total:6.65s, max:1.33s, probe:92.5ms, fetch:6.56s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:41:46 [2021-06-03T20:41:46.874Z]   │ ├─TableReader_53(Build)	1.00	1	root		time:56.1µs, loops:2, cop_task: {num: 1, max: 966.3µs, proc_keys: 25, rpc_num: 1, rpc_time: 946µs, copr_cache: disabled}	data:Selection_52	236 Bytes	N/A
20:41:46 [2021-06-03T20:41:46.874Z]   │ │ └─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:46 [2021-06-03T20:41:46.874Z]   │ │   └─TableFullScan_51	25.00	25	cop[tikv]	table:nation	tikv_task:{time:0s, loops:1}	keep order:false	N/A	N/A
20:41:46 [2021-06-03T20:41:46.874Z]   │ └─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.24s, tot_wait: 3ms, rpc_num: 1, rpc_time: 1.31s, copr_cache: disabled}	data:TableFullScan_49	35.8 MB	N/A
20:41:46 [2021-06-03T20:41:46.874Z]   │   └─TableFullScan_49	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:1.12s, 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:46 [2021-06-03T20:41:46.874Z]   └─HashAgg_54(Probe)	257492.04	223999	root		time:37.9s, loops:222, partial_worker:{wall_time:37.838876593s, concurrency:5, task_num:289, tot_wait:3m8.914919009s, tot_exec:237.070271ms, tot_time:3m9.186976318s, max:37.838851208s, p95:37.838851208s}, final_worker:{wall_time:37.904046897s, concurrency:5, task_num:25, tot_wait:3m9.180323476s, tot_exec:321.942762ms, tot_time:3m9.502279072s, max:37.904022089s, p95:37.904022089s}	group by:tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_suppkey)->tpch50.partsupp.ps_suppkey	61.4 MB	N/A
20:41:46 [2021-06-03T20:41:46.874Z]     └─Selection_55	257492.04	295898	root		time:37.8s, loops:290	gt(cast(tpch50.partsupp.ps_availqty, decimal(20,0) BINARY), mul(0.5, Column#44))	59.2 KB	N/A
20:41:46 [2021-06-03T20:41:46.874Z]       └─HashAgg_56	321865.05	435528	root		time:37.7s, loops:430, partial_worker:{wall_time:37.463332955s, concurrency:5, task_num:622, tot_wait:3m6.049763539s, tot_exec:1.068976373s, tot_time:3m7.249941676s, max:37.463294611s, p95:37.463294611s}, final_worker:{wall_time:37.829342596s, concurrency:5, task_num:25, tot_wait:3m7.220123358s, tot_exec:1.89605929s, tot_time:3m9.116198642s, max:37.829314617s, p95:37.829314617s}	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:46 [2021-06-03T20:41:46.874Z]         └─HashJoin_59	9711455.06	634004	root		time:37.4s, loops:623, build_hash_table:{total:2.38s, fetch:2.15s, build:230.9ms}, probe:{concurrency:5, total:3m6.9s, max:37.4s, probe:14.6s, fetch:2m52.3s}	left outer join, equal:[eq(tpch50.partsupp.ps_partkey, tpch50.lineitem.l_partkey) eq(tpch50.partsupp.ps_suppkey, tpch50.lineitem.l_suppkey)]	10.4 MB	0 Bytes
20:41:46 [2021-06-03T20:41:46.874Z]           ├─IndexHashJoin_67(Build)	321865.05	435528	root		time:2.32s, loops:429, inner:{total:2.55s, concurrency:5, task:12, construct:141.4ms, fetch:2.05s, build:27.7ms, join:358.7ms}	inner join, inner:IndexLookUp_64, outer key:tpch50.part.p_partkey, inner key:tpch50.partsupp.ps_partkey, equal cond:eq(tpch50.part.p_partkey, tpch50.partsupp.ps_partkey)	19.9 MB	N/A
20:41:46 [2021-06-03T20:41:46.874Z]           │ ├─TableReader_96(Build)	80007.93	108882	root		time:1.96s, loops:112, cop_task: {num: 20, max: 1.43s, min: 583.7ms, avg: 1.05s, p95: 1.43s, max_proc_keys: 686055, p95_proc_keys: 686055, tot_proc: 20.9s, tot_wait: 21ms, rpc_num: 20, rpc_time: 20.9s, copr_cache: disabled}	data:Selection_95	725.8 KB	N/A
20:41:46 [2021-06-03T20:41:46.874Z]           │ │ └─Selection_95	80007.93	108882	cop[tikv]		tikv_task:{proc max:1.4s, min:576ms, p80:1.16s, p95:1.4s, iters:9859, tasks:20}, scan_detail: {total_process_keys: 10000000, total_keys: 10000020, rocksdb: {delete_skipped_count: 0, key_skipped_count: 19999980, block: {cache_hit_count: 31499, read_count: 0, read_byte: 0 Bytes}}}	like(tpch50.part.p_name, "green%", 92)	N/A	N/A
20:41:46 [2021-06-03T20:41:46.874Z]           │ │   └─TableFullScan_94	10000000.00	10000000	cop[tikv]	table:part	tikv_task:{proc max:1.3s, min:532ms, p80:1.07s, p95:1.3s, iters:9859, tasks:20}	keep order:false	N/A	N/A
20:41:46 [2021-06-03T20:41:46.874Z]           │ └─IndexLookUp_64(Probe)	4.02	435528	root		time:1.93s, loops:447, index_task: {total_time: 1.13s, fetch_handle: 1.13s, build: 107.4µs, wait: 266.6µs}, table_task: {total_time: 7.77s, num: 57, concurrency: 60}		20.5 KB	N/A
20:41:46 [2021-06-03T20:41:46.874Z]           │   ├─IndexRangeScan_62(Build)	4.02	435528	cop[tikv]	table:partsupp, index:PRIMARY(PS_PARTKEY, PS_SUPPKEY)	time:1.09s, loops:483, cop_task: {num: 59, max: 254.2ms, min: 4.89ms, avg: 85ms, p95: 179.6ms, max_proc_keys: 15288, p95_proc_keys: 15008, tot_proc: 4.62s, tot_wait: 44ms, rpc_num: 59, rpc_time: 5.02s, copr_cache: disabled}, tikv_task:{proc max:243ms, min:4ms, p80:137ms, p95:166ms, iters:692, tasks:59}, scan_detail: {total_process_keys: 435528, total_keys: 544410, rocksdb: {delete_skipped_count: 0, key_skipped_count: 435528, block: {cache_hit_count: 980292, read_count: 0, read_byte: 0 Bytes}}}	range: decided by [eq(tpch50.partsupp.ps_partkey, tpch50.part.p_partkey)], keep order:false	N/A	N/A
20:41:46 [2021-06-03T20:41:46.874Z]           │   └─TableRowIDScan_63(Probe)	4.02	435528	cop[tikv]	table:partsupp	time:2.54s, loops:507, cop_task: {num: 1424, max: 69.8ms, min: 412.5µs, avg: 18.1ms, p95: 36.1ms, max_proc_keys: 1028, p95_proc_keys: 592, tot_proc: 18.7s, tot_wait: 4.97s, rpc_num: 1424, rpc_time: 25.8s, copr_cache: disabled}, tikv_task:{proc max:40ms, min:0s, p80:17ms, p95:23ms, iters:5293, tasks:1424}, scan_detail: {total_process_keys: 435528, total_keys: 473506, rocksdb: {delete_skipped_count: 0, key_skipped_count: 194076, block: {cache_hit_count: 3643916, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:41:46 [2021-06-03T20:41:46.874Z]           └─TableReader_101(Probe)	46310896.67	45504356	root		time:33.1s, loops:44289, cop_task: {num: 761, max: 1.12s, min: 392.8ms, avg: 697.9ms, p95: 836.7ms, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 8m48.1s, tot_wait: 100ms, rpc_num: 761, rpc_time: 8m51.1s, copr_cache: disabled}	data:Selection_100	52.6 MB	N/A
20:41:46 [2021-06-03T20:41:46.874Z]             └─Selection_100	46310896.67	45504356	cop[tikv]		tikv_task:{proc max:1.07s, min:385ms, p80:740ms, p95:810ms, 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:46 [2021-06-03T20:41:46.874Z]               └─TableFullScan_99	300005811.00	300005811	cop[tikv]	table:lineitem	tikv_task:{proc max:1.03s, min:366ms, p80:706ms, p95:778ms, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:41:46 [2021-06-03T20:41:46.874Z] + sync
20:41:46 [2021-06-03T20:41:46.874Z] + /usr/bin/echo 3
20:42:33 [2021-06-03T20:42:33.489Z] + tiup cluster stop benchbot -y
20:42:33 [2021-06-03T20:42:33.489Z] Starting component `cluster`: /home/tidb/.tiup/components/cluster/v1.4.4/tiup-cluster stop benchbot -y
20:42:41 [2021-06-03T20:42:41.571Z] + rm -rf '/data1/tidb-deploy/*/log/*'
20:42:41 [2021-06-03T20:42:41.571Z] + rm -rf /data1/jenkins/deploy/data/tikv-20160
20:42:43 [2021-06-03T20:42:43.457Z] + rm -rf /data1/jenkins/deploy/data/pd-2379
20:42:43 [2021-06-03T20:42:43.457Z] + rm -rf /data1/jenkins/restore_data/tpch50/data/last_tikv.toml
20:42:43 [2021-06-03T20:42:43.457Z] + cp -R /data1/jenkins/restore_data/tpch50/data /data1/jenkins/deploy/data/tikv-20160
20:44:34 [2021-06-03T20:44:34.838Z] + cp -R /data1/jenkins/restore_data/tpch50/data.pd /data1/jenkins/deploy/data/pd-2379
20:44:34 [2021-06-03T20:44:34.838Z] + '[' -n '' ']'
20:44:34 [2021-06-03T20:44:34.838Z] + tiup cluster start benchbot --wait-timeout=300
20:44:34 [2021-06-03T20:44:34.838Z] Starting component `cluster`: /home/tidb/.tiup/components/cluster/v1.4.4/tiup-cluster start benchbot --wait-timeout=300
20:44:52 [2021-06-03T20:44:52.876Z] + sync
20:44:52 [2021-06-03T20:44:52.876Z] + /usr/bin/echo 3
20:46:29 [2021-06-03T20:46:29.255Z] 
20:46:29 [2021-06-03T20:46:29.255Z] queries/20.sql
20:46:29 [2021-06-03T20:46:29.255Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:46:29 [2021-06-03T20:46:29.255Z] Sort_30	20000.00	8982	root		time:37.7s, loops:10	tpch50.supplier.s_name	614.3 KB	0 Bytes
20:46:29 [2021-06-03T20:46:29.255Z] └─HashJoin_35	20000.00	8982	root		time:37.7s, loops:11, build_hash_table:{total:959ms, fetch:948.6ms, build:10.4ms}, probe:{concurrency:5, total:3m8.6s, max:37.7s, probe:48.2ms, fetch:3m8.5s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.partsupp.ps_suppkey)]	1.50 MB	0 Bytes
20:46:29 [2021-06-03T20:46:29.255Z]   ├─HashJoin_48(Build)	20000.00	19972	root		time:955.2ms, loops:23, build_hash_table:{total:162.6µs, fetch:156.3µs, build:6.26µs}, probe:{concurrency:5, total:4.79s, max:957.1ms, probe:113ms, fetch:4.67s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:46:29 [2021-06-03T20:46:29.255Z]   │ ├─TableReader_53(Build)	1.00	1	root		time:65.3µs, loops:2, cop_task: {num: 1, max: 1.07ms, proc_keys: 25, rpc_num: 1, rpc_time: 1.05ms, copr_cache: disabled}	data:Selection_52	236 Bytes	N/A
20:46:29 [2021-06-03T20:46:29.255Z]   │ │ └─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-06-03T20:46:29.255Z]   │ │   └─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-06-03T20:46:29.255Z]   │ └─TableReader_50(Probe)	500000.00	500000	root		time:934ms, loops:490, cop_task: {num: 1, max: 934.1ms, proc_keys: 500000, tot_proc: 856ms, rpc_num: 1, rpc_time: 934.1ms, copr_cache: disabled}	data:TableFullScan_49	35.8 MB	N/A
20:46:29 [2021-06-03T20:46:29.255Z]   │   └─TableFullScan_49	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:720ms, 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-06-03T20:46:29.255Z]   └─HashAgg_54(Probe)	257492.04	223999	root		time:37.7s, loops:222, partial_worker:{wall_time:37.652309457s, concurrency:5, task_num:289, tot_wait:3m7.848227166s, tot_exec:367.129072ms, tot_time:3m8.251332071s, max:37.652182092s, p95:37.652182092s}, final_worker:{wall_time:37.716778538s, concurrency:5, task_num:25, tot_wait:3m8.240981022s, tot_exec:329.976215ms, tot_time:3m8.570970135s, max:37.71665493s, p95:37.71665493s}	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-06-03T20:46:29.255Z]     └─Selection_55	257492.04	295898	root		time:37.6s, 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-06-03T20:46:29.256Z]       └─HashAgg_56	321865.05	435528	root		time:37.5s, loops:430, partial_worker:{wall_time:37.273031509s, concurrency:5, task_num:625, tot_wait:3m5.078859697s, tot_exec:1.063624244s, tot_time:3m6.31706202s, max:37.273002743s, p95:37.273002743s}, final_worker:{wall_time:37.640318852s, concurrency:5, task_num:25, tot_wait:3m6.23691807s, tot_exec:1.952060312s, tot_time:3m8.188994449s, max:37.640307947s, p95:37.640307947s}	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-06-03T20:46:29.256Z]         └─HashJoin_59	9711455.06	634004	root		time:37.2s, loops:626, build_hash_table:{total:2.33s, fetch:2.14s, build:190.4ms}, probe:{concurrency:5, total:3m5.9s, max:37.2s, probe:14.4s, fetch:2m51.5s}	left outer join, equal:[eq(tpch50.partsupp.ps_partkey, tpch50.lineitem.l_partkey) eq(tpch50.partsupp.ps_suppkey, tpch50.lineitem.l_suppkey)]	10.4 MB	0 Bytes
20:46:29 [2021-06-03T20:46:29.256Z]           ├─IndexHashJoin_67(Build)	321865.05	435528	root		time:2.31s, loops:430, inner:{total:2.53s, concurrency:5, task:12, construct:130ms, fetch:2.09s, build:27ms, join:306.8ms}	inner join, inner:IndexLookUp_64, outer key:tpch50.part.p_partkey, inner key:tpch50.partsupp.ps_partkey, equal cond:eq(tpch50.part.p_partkey, tpch50.partsupp.ps_partkey)	19.9 MB	N/A
20:46:29 [2021-06-03T20:46:29.256Z]           │ ├─TableReader_96(Build)	80007.93	108882	root		time:1.91s, loops:112, cop_task: {num: 20, max: 1.46s, min: 621.8ms, avg: 1.04s, p95: 1.46s, max_proc_keys: 686055, p95_proc_keys: 686055, tot_proc: 20.8s, tot_wait: 16ms, rpc_num: 20, rpc_time: 20.9s, copr_cache: disabled}	data:Selection_95	680.6 KB	N/A
20:46:29 [2021-06-03T20:46:29.256Z]           │ │ └─Selection_95	80007.93	108882	cop[tikv]		tikv_task:{proc max:1.4s, min:616ms, p80:1.2s, p95:1.4s, iters:9859, tasks:20}, scan_detail: {total_process_keys: 10000000, total_keys: 10000020, rocksdb: {delete_skipped_count: 0, key_skipped_count: 19999980, block: {cache_hit_count: 31499, read_count: 0, read_byte: 0 Bytes}}}	like(tpch50.part.p_name, "green%", 92)	N/A	N/A
20:46:29 [2021-06-03T20:46:29.256Z]           │ │   └─TableFullScan_94	10000000.00	10000000	cop[tikv]	table:part	tikv_task:{proc max:1.29s, min:567ms, p80:1.13s, p95:1.29s, iters:9859, tasks:20}	keep order:false	N/A	N/A
20:46:29 [2021-06-03T20:46:29.256Z]           │ └─IndexLookUp_64(Probe)	4.02	435528	root		time:1.98s, loops:447, index_task: {total_time: 1.17s, fetch_handle: 1.17s, build: 112.3µs, wait: 293.7µs}, table_task: {total_time: 7.88s, num: 56, concurrency: 60}		20.5 KB	N/A
20:46:29 [2021-06-03T20:46:29.256Z]           │   ├─IndexRangeScan_62(Build)	4.02	435528	cop[tikv]	table:partsupp, index:PRIMARY(PS_PARTKEY, PS_SUPPKEY)	time:1.13s, loops:485, cop_task: {num: 60, max: 208.7ms, min: 5.15ms, avg: 94.4ms, p95: 202.3ms, max_proc_keys: 15288, p95_proc_keys: 14948, tot_proc: 5.01s, tot_wait: 243ms, rpc_num: 60, rpc_time: 5.66s, copr_cache: disabled}, tikv_task:{proc max:187ms, min:4ms, p80:140ms, p95:156ms, iters:697, tasks:60}, scan_detail: {total_process_keys: 435528, total_keys: 544410, rocksdb: {delete_skipped_count: 0, key_skipped_count: 435528, block: {cache_hit_count: 980292, read_count: 0, read_byte: 0 Bytes}}}	range: decided by [eq(tpch50.partsupp.ps_partkey, tpch50.part.p_partkey)], keep order:false	N/A	N/A
20:46:29 [2021-06-03T20:46:29.256Z]           │   └─TableRowIDScan_63(Probe)	4.02	435528	cop[tikv]	table:partsupp	time:2.59s, loops:504, cop_task: {num: 1404, max: 65.5ms, min: 569.7µs, avg: 19ms, p95: 37.9ms, max_proc_keys: 976, p95_proc_keys: 624, tot_proc: 19.2s, tot_wait: 5.59s, rpc_num: 1404, rpc_time: 26.7s, copr_cache: disabled}, tikv_task:{proc max:47ms, min:0s, p80:17ms, p95:25ms, iters:5231, tasks:1404}, scan_detail: {total_process_keys: 435528, total_keys: 473513, rocksdb: {delete_skipped_count: 0, key_skipped_count: 194093, block: {cache_hit_count: 3644019, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:46:29 [2021-06-03T20:46:29.256Z]           └─TableReader_101(Probe)	46310896.67	45504356	root		time:32.9s, loops:44289, cop_task: {num: 761, max: 1.14s, min: 350ms, avg: 695ms, p95: 850.9ms, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 8m45.9s, tot_wait: 130ms, rpc_num: 761, rpc_time: 8m48.9s, copr_cache: disabled}	data:Selection_100	52.6 MB	N/A
20:46:29 [2021-06-03T20:46:29.256Z]             └─Selection_100	46310896.67	45504356	cop[tikv]		tikv_task:{proc max:1.1s, min:340ms, p80:740ms, p95:832ms, iters:296606, tasks:761}, scan_detail: {total_process_keys: 300005811, total_keys: 300006572, rocksdb: {delete_skipped_count: 0, key_skipped_count: 600010861, block: {cache_hit_count: 1124648, read_count: 0, read_byte: 0 Bytes}}}	ge(tpch50.lineitem.l_shipdate, 1993-01-01 00:00:00.000000), lt(tpch50.lineitem.l_shipdate, 1994-01-01)	N/A	N/A
20:46:29 [2021-06-03T20:46:29.256Z]               └─TableFullScan_99	300005811.00	300005811	cop[tikv]	table:lineitem	tikv_task:{proc max:1.08s, min:325ms, p80:710ms, p95:804ms, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:46:29 [2021-06-03T20:46:29.256Z] 
20:46:29 [2021-06-03T20:46:29.256Z] queries/21.sql
20:46:29 [2021-06-03T20:46:29.256Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:46:29 [2021-06-03T20:46:29.256Z] Projection_26	100.00	100	root		time:1m21s, loops:2, Concurrency:OFF	tpch50.supplier.s_name, Column#72	4.62 KB	N/A
20:46:29 [2021-06-03T20:46:29.256Z] └─TopN_29	100.00	100	root		time:1m21s, loops:2	Column#72:desc, tpch50.supplier.s_name, offset:0, count:100	58.4 KB	N/A
20:46:29 [2021-06-03T20:46:29.256Z]   └─HashAgg_34	12800.00	20057	root		time:1m21s, loops:21, partial_worker:{wall_time:1m20.988928752s, concurrency:5, task_num:196, tot_wait:6m44.652690113s, tot_exec:275.400846ms, tot_time:6m44.941796376s, max:1m20.988884809s, p95:1m20.988884809s}, final_worker:{wall_time:1m21.004255084s, concurrency:5, task_num:25, tot_wait:6m44.939614641s, tot_exec:71.51849ms, tot_time:6m45.011169348s, max:1m21.004214861s, p95:1m21.004214861s}	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-06-03T20:46:29.256Z]     └─IndexHashJoin_42	7828961.66	198698	root		time:1m21s, loops:197, inner:{total:2m22s, concurrency:5, task:146, construct:6.36s, fetch:1m58.2s, build:1.16s, join:17.4s}	anti semi join, inner:IndexLookUp_39, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey)	641.0 MB	N/A
20:46:29 [2021-06-03T20:46:29.256Z]       ├─IndexHashJoin_83(Build)	9786202.08	3542799	root		time:1m20.4s, loops:3463, inner:{total:2m31.3s, concurrency:5, task:152, construct:7.79s, fetch:2m5.6s, build:1.27s, join:17.9s}	semi join, inner:IndexLookUp_80, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey), ne(tpch50.lineitem.l_suppkey, tpch50.supplier.s_suppkey)	555.9 MB	N/A
20:46:29 [2021-06-03T20:46:29.256Z]       │ ├─IndexJoin_99(Build)	12232752.60	3675878	root		time:1m20s, loops:3595, inner:{total:2m9.1s, concurrency:5, task:305, construct:16.6s, fetch:1m50.6s, build:1.88s}, probe:5.32s	inner join, inner:TableReader_95, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.orders.o_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.orders.o_orderkey)	575.4 MB	N/A
20:46:29 [2021-06-03T20:46:29.256Z]       │ │ ├─HashJoin_107(Build)	12232752.60	7609895	root		time:1m19.4s, loops:7436, build_hash_table:{total:839.3ms, fetch:831ms, build:8.3ms}, probe:{concurrency:5, total:6m39.1s, max:1m19.8s, probe:59.9s, fetch:5m39.2s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.lineitem.l_suppkey)]	757.3 KB	0 Bytes
20:46:29 [2021-06-03T20:46:29.256Z]       │ │ │ ├─HashJoin_120(Build)	20000.00	20058	root		time:836.6ms, loops:23, build_hash_table:{total:439.7µs, fetch:224.9µs, build:214.8µs}, probe:{concurrency:5, total:4.19s, max:838ms, probe:70.9ms, fetch:4.12s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:46:29 [2021-06-03T20:46:29.256Z]       │ │ │ │ ├─TableReader_125(Build)	1.00	1	root		time:80.5µs, loops:2, cop_task: {num: 1, max: 1.08ms, proc_keys: 25, rpc_num: 1, rpc_time: 1.06ms, copr_cache: disabled}	data:Selection_124	234 Bytes	N/A
20:46:29 [2021-06-03T20:46:29.256Z]       │ │ │ │ │ └─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-06-03T20:46:29.256Z]       │ │ │ │ │   └─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-06-03T20:46:29.256Z]       │ │ │ │ └─TableReader_122(Probe)	500000.00	500000	root		time:823.3ms, loops:490, cop_task: {num: 1, max: 939.6ms, proc_keys: 500000, tot_proc: 909ms, rpc_num: 1, rpc_time: 939.5ms, copr_cache: disabled}	data:TableFullScan_121	20.0 MB	N/A
20:46:29 [2021-06-03T20:46:29.256Z]       │ │ │ │   └─TableFullScan_121	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:861ms, 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-06-03T20:46:29.256Z]       │ │ │ └─TableReader_128(Probe)	240004648.80	189670348	root		time:1m7.6s, loops:184597, cop_task: {num: 761, max: 2.47s, min: 262.2ms, avg: 1.54s, p95: 2.02s, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 18m14.7s, tot_wait: 1m1.1s, rpc_num: 761, rpc_time: 19m28.7s, copr_cache: disabled}	data:Selection_127	91.6 MB	N/A
20:46:29 [2021-06-03T20:46:29.256Z]       │ │ │   └─Selection_127	240004648.80	189670348	cop[tikv]		tikv_task:{proc max:1.38s, min:250ms, p80:1.19s, p95:1.24s, 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: 18682, read_count: 1131782, read_byte: 23.9 GB}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:46:29 [2021-06-03T20:46:29.256Z]       │ │ │     └─TableFullScan_126	300005811.00	300005811	cop[tikv]	table:l1	tikv_task:{proc max:1.3s, min:237ms, p80:1.12s, p95:1.17s, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:46:29 [2021-06-03T20:46:29.256Z]       │ │ └─TableReader_95(Probe)	0.49	3496195	root		time:1m41.4s, loops:3875, cop_task: {num: 5282, max: 514.2ms, min: 1.14ms, avg: 180ms, p95: 340.8ms, max_proc_keys: 3948, p95_proc_keys: 1966, tot_proc: 11m18.5s, tot_wait: 3m52.3s, rpc_num: 5282, rpc_time: 15m50.7s, copr_cache: disabled}	data:Selection_94	N/A	N/A
20:46:29 [2021-06-03T20:46:29.256Z]       │ │   └─Selection_94	0.49	3496195	cop[tikv]		tikv_task:{proc max:178ms, min:0s, p80:70ms, p95:83ms, iters:30242, tasks:5282}, scan_detail: {total_process_keys: 7236289, total_keys: 7795531, rocksdb: {delete_skipped_count: 0, key_skipped_count: 1778382, block: {cache_hit_count: 54007235, read_count: 220246, read_byte: 4.83 GB}}}	eq(tpch50.orders.o_orderstatus, "F")	N/A	N/A
20:46:29 [2021-06-03T20:46:29.256Z]       │ │     └─TableRangeScan_93	1.00	7236289	cop[tikv]	table:orders	tikv_task:{proc max:178ms, min:0s, p80:70ms, p95:83ms, iters:30242, tasks:5282}	range: decided by [tpch50.lineitem.l_orderkey], keep order:false	N/A	N/A
20:46:29 [2021-06-03T20:46:29.256Z]       │ └─IndexLookUp_80(Probe)	4.05	17316411	root		time:1m59.9s, loops:17128, index_task: {total_time: 1m6s, fetch_handle: 57.3s, build: 3.27ms, wait: 8.69s}, table_task: {total_time: 8m35.2s, num: 1458, concurrency: 760}		19.1 KB	N/A
20:46:29 [2021-06-03T20:46:29.256Z]       │   ├─IndexRangeScan_78(Build)	4.05	17316411	cop[tikv]	table:l2, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:54.9s, loops:18645, cop_task: {num: 2991, max: 821.6ms, min: 642µs, avg: 190.1ms, p95: 388.6ms, max_proc_keys: 13229, p95_proc_keys: 8784, tot_proc: 7m7s, tot_wait: 2m1.4s, rpc_num: 2991, rpc_time: 9m28.5s, copr_cache: disabled}, tikv_task:{proc max:159ms, min:0s, p80:99ms, p95:115ms, iters:30051, tasks:2991}, scan_detail: {total_process_keys: 17316411, total_keys: 20812506, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17316411, block: {cache_hit_count: 24260140, read_count: 226868, read_byte: 2.40 GB}}}	range: decided by [eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey)], keep order:false	N/A	N/A
20:46:29 [2021-06-03T20:46:29.256Z]       │   └─TableRowIDScan_79(Probe)	4.05	17316411	cop[tikv]	table:l2	time:6m21.8s, loops:20998, cop_task: {num: 7802, max: 727.5ms, min: 421.4µs, avg: 179ms, p95: 365.4ms, max_proc_keys: 12919, p95_proc_keys: 4801, tot_proc: 16m46.3s, tot_wait: 5m40.1s, rpc_num: 7802, rpc_time: 23m16.2s, copr_cache: disabled}, tikv_task:{proc max:254ms, min:0s, p80:104ms, p95:140ms, iters:49900, tasks:7802}, scan_detail: {total_process_keys: 17316411, total_keys: 18288784, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5626887, block: {cache_hit_count: 99019263, read_count: 5, read_byte: 36.7 KB}}}	keep order:false	N/A	N/A
20:46:29 [2021-06-03T20:46:29.256Z]       └─IndexLookUp_39(Probe)	4.05	12022796	root		time:1m53.1s, loops:11949, index_task: {total_time: 1m2.2s, fetch_handle: 52.4s, build: 3.27ms, wait: 9.77s}, table_task: {total_time: 8m8.4s, num: 1408, concurrency: 730}		216.6 KB	N/A
20:46:29 [2021-06-03T20:46:29.256Z]         ├─IndexRangeScan_36(Build)	5.06	17183374	cop[tikv]	table:l3, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:50.1s, loops:18403, cop_task: {num: 2744, max: 790.7ms, min: 490.1µs, avg: 173.2ms, p95: 375ms, max_proc_keys: 20554, p95_proc_keys: 13335, tot_proc: 5m55.7s, tot_wait: 1m39.1s, rpc_num: 2744, rpc_time: 7m55.3s, copr_cache: disabled}, tikv_task:{proc max:211ms, min:0s, p80:80ms, p95:118ms, iters:28929, tasks:2744}, scan_detail: {total_process_keys: 17183374, total_keys: 20546399, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17183374, block: {cache_hit_count: 23553981, read_count: 0, read_byte: 0 Bytes}}}	range: decided by [eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey)], keep order:false	N/A	N/A
20:46:29 [2021-06-03T20:46:29.256Z]         └─Selection_38(Probe)	4.05	12022796	cop[tikv]		time:6m15.3s, loops:13769, cop_task: {num: 10331, max: 700.8ms, min: 392.7µs, avg: 173.5ms, p95: 353.6ms, max_proc_keys: 8173, p95_proc_keys: 3915, tot_proc: 20m59.4s, tot_wait: 7m47.7s, rpc_num: 10331, rpc_time: 29m52s, copr_cache: disabled}, tikv_task:{proc max:216ms, min:0s, p80:75ms, p95:114ms, iters:60988, tasks:10331}, scan_detail: {total_process_keys: 17183374, total_keys: 18128807, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5526601, block: {cache_hit_count: 98287181, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:46:29 [2021-06-03T20:46:29.256Z]           └─TableRowIDScan_37	5.06	17183374	cop[tikv]	table:l3	tikv_task:{proc max:214ms, min:0s, p80:74ms, p95:114ms, iters:60988, tasks:10331}	keep order:false	N/A	N/A
20:46:29 [2021-06-03T20:46:29.256Z] + sync
20:46:29 [2021-06-03T20:46:29.256Z] + /usr/bin/echo 3
20:47:50 [2021-06-03T20:47:50.640Z] 
20:47:50 [2021-06-03T20:47:50.640Z] queries/21.sql
20:47:50 [2021-06-03T20:47:50.640Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:47:50 [2021-06-03T20:47:50.640Z] Projection_26	100.00	100	root		time:1m19.7s, loops:2, Concurrency:OFF	tpch50.supplier.s_name, Column#72	4.62 KB	N/A
20:47:50 [2021-06-03T20:47:50.640Z] └─TopN_29	100.00	100	root		time:1m19.7s, loops:2	Column#72:desc, tpch50.supplier.s_name, offset:0, count:100	55.9 KB	N/A
20:47:50 [2021-06-03T20:47:50.640Z]   └─HashAgg_34	12800.00	20057	root		time:1m19.7s, loops:21, partial_worker:{wall_time:1m19.659396611s, concurrency:5, task_num:197, tot_wait:6m38.004782572s, tot_exec:278.569035ms, tot_time:6m38.295828935s, max:1m19.659364335s, p95:1m19.659364335s}, final_worker:{wall_time:1m19.674050652s, concurrency:5, task_num:25, tot_wait:6m38.295216913s, tot_exec:66.338757ms, tot_time:6m38.361569001s, max:1m19.674019218s, p95:1m19.674019218s}	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:50 [2021-06-03T20:47:50.640Z]     └─IndexHashJoin_42	7828961.66	198698	root		time:1m19.7s, loops:198, inner:{total:2m20.6s, concurrency:5, task:147, construct:6.5s, fetch:1m57.3s, build:1.2s, join:16.8s}	anti semi join, inner:IndexLookUp_39, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey)	641.0 MB	N/A
20:47:50 [2021-06-03T20:47:50.640Z]       ├─IndexHashJoin_83(Build)	9786202.08	3542799	root		time:1m19.1s, loops:3463, inner:{total:2m29.1s, concurrency:5, task:152, construct:7.8s, fetch:2m3.5s, build:1.18s, 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:47:50 [2021-06-03T20:47:50.640Z]       │ ├─IndexJoin_99(Build)	12232752.60	3675878	root		time:1m18.5s, loops:3595, inner:{total:2m9.7s, concurrency:5, task:305, construct:16.5s, fetch:1m51.3s, build:1.91s}, probe:5.35s	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:50 [2021-06-03T20:47:50.640Z]       │ │ ├─HashJoin_107(Build)	12232752.60	7609895	root		time:1m18s, loops:7436, build_hash_table:{total:1.14s, fetch:1.13s, build:7.22ms}, probe:{concurrency:5, total:6m31.6s, max:1m18.3s, probe:1m2.1s, fetch:5m29.6s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.lineitem.l_suppkey)]	757.3 KB	0 Bytes
20:47:50 [2021-06-03T20:47:50.640Z]       │ │ │ ├─HashJoin_120(Build)	20000.00	20058	root		time:1.14s, loops:23, build_hash_table:{total:169.7µs, fetch:162.8µs, build:6.93µs}, probe:{concurrency:5, total:5.69s, max:1.14s, probe:60.3ms, fetch:5.63s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:47:50 [2021-06-03T20:47:50.640Z]       │ │ │ │ ├─TableReader_125(Build)	1.00	1	root		time:59.3µs, loops:2, cop_task: {num: 1, max: 1.22ms, proc_keys: 25, tot_proc: 1ms, rpc_num: 1, rpc_time: 1.21ms, copr_cache: disabled}	data:Selection_124	248 Bytes	N/A
20:47:50 [2021-06-03T20:47:50.640Z]       │ │ │ │ │ └─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:50 [2021-06-03T20:47:50.640Z]       │ │ │ │ │   └─TableFullScan_123	25.00	25	cop[tikv]	table:nation	tikv_task:{time:1ms, loops:1}	keep order:false	N/A	N/A
20:47:50 [2021-06-03T20:47:50.640Z]       │ │ │ │ └─TableReader_122(Probe)	500000.00	500000	root		time:1.12s, loops:490, cop_task: {num: 1, max: 1.13s, proc_keys: 500000, tot_proc: 1.09s, rpc_num: 1, rpc_time: 1.13s, copr_cache: disabled}	data:TableFullScan_121	20.0 MB	N/A
20:47:50 [2021-06-03T20:47:50.640Z]       │ │ │ │   └─TableFullScan_121	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:1.04s, loops:493}, scan_detail: {total_process_keys: 500000, total_keys: 500001, rocksdb: {delete_skipped_count: 0, key_skipped_count: 999999, block: {cache_hit_count: 13, read_count: 1679, read_byte: 104.5 MB}}}	keep order:false	N/A	N/A
20:47:50 [2021-06-03T20:47:50.640Z]       │ │ │ └─TableReader_128(Probe)	240004648.80	189670348	root		time:1m5.2s, loops:184596, cop_task: {num: 761, max: 2.66s, min: 264.5ms, avg: 1.5s, p95: 1.99s, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 17m50.6s, tot_wait: 1m0.7s, rpc_num: 761, rpc_time: 19m4.2s, copr_cache: disabled}	data:Selection_127	109.4 MB	N/A
20:47:50 [2021-06-03T20:47:50.640Z]       │ │ │   └─Selection_127	240004648.80	189670348	cop[tikv]		tikv_task:{proc max:1.28s, min:252ms, p80:1.15s, p95:1.2s, iters:296606, tasks:761}, scan_detail: {total_process_keys: 300005811, total_keys: 300006572, rocksdb: {delete_skipped_count: 0, key_skipped_count: 600010861, block: {cache_hit_count: 10454, read_count: 1114194, read_byte: 23.6 GB}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:47:50 [2021-06-03T20:47:50.640Z]       │ │ │     └─TableFullScan_126	300005811.00	300005811	cop[tikv]	table:l1	tikv_task:{proc max:1.2s, min:232ms, p80:1.07s, p95:1.12s, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:47:50 [2021-06-03T20:47:50.640Z]       │ │ └─TableReader_95(Probe)	0.49	3496173	root		time:1m42s, loops:3875, cop_task: {num: 5290, max: 586.3ms, min: 737.8µs, avg: 180ms, p95: 347.1ms, max_proc_keys: 4609, p95_proc_keys: 1965, tot_proc: 11m26.6s, tot_wait: 3m46.4s, rpc_num: 5290, rpc_time: 15m52.3s, copr_cache: disabled}	data:Selection_94	N/A	N/A
20:47:50 [2021-06-03T20:47:50.640Z]       │ │   └─Selection_94	0.49	3496173	cop[tikv]		tikv_task:{proc max:199ms, min:0s, p80:68ms, p95:82ms, iters:30335, tasks:5290}, scan_detail: {total_process_keys: 7236274, total_keys: 7795501, rocksdb: {delete_skipped_count: 0, key_skipped_count: 1778333, block: {cache_hit_count: 54006644, read_count: 218241, read_byte: 4.21 GB}}}	eq(tpch50.orders.o_orderstatus, "F")	N/A	N/A
20:47:50 [2021-06-03T20:47:50.640Z]       │ │     └─TableRangeScan_93	1.00	7236274	cop[tikv]	table:orders	tikv_task:{proc max:197ms, min:0s, p80:68ms, p95:81ms, iters:30335, tasks:5290}	range: decided by [tpch50.lineitem.l_orderkey], keep order:false	N/A	N/A
20:47:50 [2021-06-03T20:47:50.640Z]       │ └─IndexLookUp_80(Probe)	4.05	17316470	root		time:1m58.1s, loops:17136, index_task: {total_time: 1m5.2s, fetch_handle: 56.9s, build: 3.38ms, wait: 8.32s}, table_task: {total_time: 8m33.8s, num: 1458, concurrency: 760}		19.1 KB	N/A
20:47:50 [2021-06-03T20:47:50.640Z]       │   ├─IndexRangeScan_78(Build)	4.05	17316470	cop[tikv]	table:l2, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:54.5s, loops:18636, cop_task: {num: 3063, max: 688.7ms, min: 556µs, avg: 186.4ms, p95: 382.5ms, max_proc_keys: 15661, p95_proc_keys: 8746, tot_proc: 7m9.8s, tot_wait: 2m1.4s, rpc_num: 3063, rpc_time: 9m30.8s, copr_cache: disabled}, tikv_task:{proc max:211ms, min:0s, p80:95ms, p95:110ms, iters:30419, tasks:3063}, scan_detail: {total_process_keys: 17316470, total_keys: 20812576, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17316470, block: {cache_hit_count: 24259991, read_count: 225678, read_byte: 2.00 GB}}}	range: decided by [eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey)], keep order:false	N/A	N/A
20:47:50 [2021-06-03T20:47:50.640Z]       │   └─TableRowIDScan_79(Probe)	4.05	17316470	cop[tikv]	table:l2	time:6m21s, loops:20984, cop_task: {num: 7833, max: 746.8ms, min: 412.7µs, avg: 178.9ms, p95: 362ms, max_proc_keys: 10116, p95_proc_keys: 4845, tot_proc: 16m43.3s, tot_wait: 5m48.2s, rpc_num: 7833, rpc_time: 23m21s, copr_cache: disabled}, tikv_task:{proc max:226ms, min:0s, p80:104ms, p95:138ms, iters:50002, tasks:7833}, scan_detail: {total_process_keys: 17316470, total_keys: 18288334, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5622992, block: {cache_hit_count: 99027037, read_count: 1106, read_byte: 392.4 MB}}}	keep order:false	N/A	N/A
20:47:50 [2021-06-03T20:47:50.640Z]       └─IndexLookUp_39(Probe)	4.05	12022821	root		time:1m52.2s, loops:11954, index_task: {total_time: 1m2s, fetch_handle: 51.9s, build: 3.14ms, wait: 10.2s}, table_task: {total_time: 8m6.8s, num: 1410, concurrency: 735}		278.3 KB	N/A
20:47:50 [2021-06-03T20:47:50.641Z]         ├─IndexRangeScan_36(Build)	5.06	17183420	cop[tikv]	table:l3, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:49.4s, loops:18385, cop_task: {num: 2815, max: 762.4ms, min: 598.1µs, avg: 169.1ms, p95: 369.5ms, max_proc_keys: 19277, p95_proc_keys: 13596, tot_proc: 5m54.7s, tot_wait: 1m41.2s, rpc_num: 2815, rpc_time: 7m56.1s, copr_cache: disabled}, tikv_task:{proc max:180ms, min:0s, p80:79ms, p95:119ms, iters:29234, tasks:2815}, scan_detail: {total_process_keys: 17183420, total_keys: 20546452, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17183420, block: {cache_hit_count: 23554030, read_count: 0, read_byte: 0 Bytes}}}	range: decided by [eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey)], keep order:false	N/A	N/A
20:47:50 [2021-06-03T20:47:50.641Z]         └─Selection_38(Probe)	4.05	12022821	cop[tikv]		time:6m14.4s, loops:13782, cop_task: {num: 10282, max: 652.2ms, min: 445.7µs, avg: 175.9ms, p95: 353.5ms, max_proc_keys: 8086, p95_proc_keys: 3919, tot_proc: 21m2.1s, tot_wait: 8m1.6s, rpc_num: 10282, rpc_time: 30m8.1s, copr_cache: disabled}, tikv_task:{proc max:209ms, min:0s, p80:76ms, p95:114ms, iters:60802, tasks:10282}, scan_detail: {total_process_keys: 17183420, total_keys: 18128559, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5524353, block: {cache_hit_count: 98291657, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:47:50 [2021-06-03T20:47:50.641Z]           └─TableRowIDScan_37	5.06	17183420	cop[tikv]	table:l3	tikv_task:{proc max:208ms, min:0s, p80:75ms, p95:113ms, iters:60802, tasks:10282}	keep order:false	N/A	N/A
20:47:50 [2021-06-03T20:47:50.641Z] + sync
20:47:50 [2021-06-03T20:47:50.641Z] + /usr/bin/echo 3
20:49:12 [2021-06-03T20:49:12.019Z] 
20:49:12 [2021-06-03T20:49:12.019Z] queries/21.sql
20:49:12 [2021-06-03T20:49:12.019Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:49:12 [2021-06-03T20:49:12.019Z] Projection_26	100.00	100	root		time:1m20s, loops:2, Concurrency:OFF	tpch50.supplier.s_name, Column#72	4.62 KB	N/A
20:49:12 [2021-06-03T20:49:12.019Z] └─TopN_29	100.00	100	root		time:1m20s, loops:2	Column#72:desc, tpch50.supplier.s_name, offset:0, count:100	58.4 KB	N/A
20:49:12 [2021-06-03T20:49:12.019Z]   └─HashAgg_34	12800.00	20057	root		time:1m20s, loops:21, partial_worker:{wall_time:1m19.946816773s, concurrency:5, task_num:197, tot_wait:6m39.460053295s, tot_exec:259.115059ms, tot_time:6m39.730848091s, max:1m19.946789022s, p95:1m19.946789022s}, final_worker:{wall_time:1m19.959369823s, concurrency:5, task_num:25, tot_wait:6m39.729702485s, tot_exec:65.550279ms, tot_time:6m39.79526551s, max:1m19.959344908s, p95:1m19.959344908s}	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:12 [2021-06-03T20:49:12.019Z]     └─IndexHashJoin_42	7828961.66	198698	root		time:1m19.9s, loops:198, inner:{total:2m19s, concurrency:5, task:146, construct:6.17s, fetch:1m55.9s, build:1.14s, join:16.9s}	anti semi join, inner:IndexLookUp_39, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey)	641.0 MB	N/A
20:49:12 [2021-06-03T20:49:12.019Z]       ├─IndexHashJoin_83(Build)	9786202.08	3542799	root		time:1m19.4s, loops:3462, inner:{total:2m27.4s, concurrency:5, task:152, construct:7.77s, fetch:2m1.9s, build:1.22s, join:17.7s}	semi join, inner:IndexLookUp_80, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey), ne(tpch50.lineitem.l_suppkey, tpch50.supplier.s_suppkey)	555.9 MB	N/A
20:49:12 [2021-06-03T20:49:12.019Z]       │ ├─IndexJoin_99(Build)	12232752.60	3675878	root		time:1m19s, loops:3595, inner:{total:2m7s, concurrency:5, task:305, construct:15.9s, fetch:1m49.2s, build:1.85s}, probe:5.11s	inner join, inner:TableReader_95, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.orders.o_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.orders.o_orderkey)	575.3 MB	N/A
20:49:12 [2021-06-03T20:49:12.019Z]       │ │ ├─HashJoin_107(Build)	12232752.60	7609895	root		time:1m18.4s, loops:7436, build_hash_table:{total:1.09s, fetch:1.08s, build:6.06ms}, probe:{concurrency:5, total:6m33.7s, max:1m18.7s, probe:1m1.6s, fetch:5m32.2s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.lineitem.l_suppkey)]	737.6 KB	0 Bytes
20:49:12 [2021-06-03T20:49:12.019Z]       │ │ │ ├─HashJoin_120(Build)	20000.00	20058	root		time:1.08s, loops:22, build_hash_table:{total:199.7µs, fetch:191.4µs, build:8.22µs}, probe:{concurrency:5, total:5.43s, max:1.09s, probe:64.7ms, fetch:5.36s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:49:12 [2021-06-03T20:49:12.019Z]       │ │ │ │ ├─TableReader_125(Build)	1.00	1	root		time:41.5µs, loops:2, cop_task: {num: 1, max: 1.31ms, proc_keys: 25, tot_proc: 1ms, rpc_num: 1, rpc_time: 1.29ms, copr_cache: disabled}	data:Selection_124	248 Bytes	N/A
20:49:12 [2021-06-03T20:49:12.019Z]       │ │ │ │ │ └─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:12 [2021-06-03T20:49:12.019Z]       │ │ │ │ │   └─TableFullScan_123	25.00	25	cop[tikv]	table:nation	tikv_task:{time:1ms, loops:1}	keep order:false	N/A	N/A
20:49:12 [2021-06-03T20:49:12.019Z]       │ │ │ │ └─TableReader_122(Probe)	500000.00	500000	root		time:1.07s, loops:490, cop_task: {num: 1, max: 1.07s, proc_keys: 500000, tot_proc: 1.04s, rpc_num: 1, rpc_time: 1.07s, copr_cache: disabled}	data:TableFullScan_121	20.0 MB	N/A
20:49:12 [2021-06-03T20:49:12.019Z]       │ │ │ │   └─TableFullScan_121	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:985ms, loops:493}, scan_detail: {total_process_keys: 500000, total_keys: 500001, rocksdb: {delete_skipped_count: 0, key_skipped_count: 999999, block: {cache_hit_count: 13, read_count: 1679, read_byte: 104.5 MB}}}	keep order:false	N/A	N/A
20:49:12 [2021-06-03T20:49:12.019Z]       │ │ │ └─TableReader_128(Probe)	240004648.80	189670348	root		time:1m5.9s, loops:184596, cop_task: {num: 761, max: 2.49s, min: 310.9ms, avg: 1.51s, p95: 1.95s, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 17m54.8s, tot_wait: 59.6s, rpc_num: 761, rpc_time: 19m7.3s, copr_cache: disabled}	data:Selection_127	109.4 MB	N/A
20:49:12 [2021-06-03T20:49:12.019Z]       │ │ │   └─Selection_127	240004648.80	189670348	cop[tikv]		tikv_task:{proc max:1.26s, min:291ms, p80:1.16s, p95:1.21s, iters:296606, tasks:761}, scan_detail: {total_process_keys: 300005811, total_keys: 300006572, rocksdb: {delete_skipped_count: 0, key_skipped_count: 600010861, block: {cache_hit_count: 10458, read_count: 1114190, read_byte: 23.6 GB}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:49:12 [2021-06-03T20:49:12.019Z]       │ │ │     └─TableFullScan_126	300005811.00	300005811	cop[tikv]	table:l1	tikv_task:{proc max:1.18s, min:267ms, p80:1.09s, p95:1.13s, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:49:12 [2021-06-03T20:49:12.019Z]       │ │ └─TableReader_95(Probe)	0.49	3496179	root		time:1m40.4s, loops:3875, cop_task: {num: 5264, max: 532.8ms, min: 533µs, avg: 178.3ms, p95: 339ms, max_proc_keys: 3540, p95_proc_keys: 1951, tot_proc: 11m17.1s, tot_wait: 3m43.3s, rpc_num: 5264, rpc_time: 15m38.5s, copr_cache: disabled}	data:Selection_94	N/A	N/A
20:49:12 [2021-06-03T20:49:12.019Z]       │ │   └─Selection_94	0.49	3496179	cop[tikv]		tikv_task:{proc max:143ms, min:0s, p80:68ms, p95:81ms, iters:30247, tasks:5264}, scan_detail: {total_process_keys: 7236276, total_keys: 7795453, rocksdb: {delete_skipped_count: 0, key_skipped_count: 1778205, block: {cache_hit_count: 54006460, read_count: 218173, read_byte: 4.21 GB}}}	eq(tpch50.orders.o_orderstatus, "F")	N/A	N/A
20:49:12 [2021-06-03T20:49:12.019Z]       │ │     └─TableRangeScan_93	1.00	7236276	cop[tikv]	table:orders	tikv_task:{proc max:142ms, min:0s, p80:68ms, p95:80ms, iters:30247, tasks:5264}	range: decided by [tpch50.lineitem.l_orderkey], keep order:false	N/A	N/A
20:49:12 [2021-06-03T20:49:12.019Z]       │ └─IndexLookUp_80(Probe)	4.05	17316493	root		time:1m56.5s, loops:17129, index_task: {total_time: 1m4.7s, fetch_handle: 56.7s, build: 3.21ms, wait: 8.02s}, table_task: {total_time: 8m20.3s, num: 1458, concurrency: 760}		19.1 KB	N/A
20:49:12 [2021-06-03T20:49:12.019Z]       │   ├─IndexRangeScan_78(Build)	4.05	17316493	cop[tikv]	table:l2, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:54.4s, loops:18631, cop_task: {num: 2999, max: 680.4ms, min: 510.2µs, avg: 184ms, p95: 365.3ms, max_proc_keys: 13466, p95_proc_keys: 8759, tot_proc: 6m57s, tot_wait: 1m54.5s, rpc_num: 2999, rpc_time: 9m11.8s, copr_cache: disabled}, tikv_task:{proc max:204ms, min:0s, p80:96ms, p95:110ms, iters:30171, tasks:2999}, scan_detail: {total_process_keys: 17316493, total_keys: 20812603, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17316493, block: {cache_hit_count: 24260021, read_count: 225676, read_byte: 2.00 GB}}}	range: decided by [eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey)], keep order:false	N/A	N/A
20:49:12 [2021-06-03T20:49:12.019Z]       │   └─TableRowIDScan_79(Probe)	4.05	17316493	cop[tikv]	table:l2	time:6m9.7s, loops:20992, cop_task: {num: 7789, max: 609.6ms, min: 490.7µs, avg: 173.9ms, p95: 347.3ms, max_proc_keys: 12685, p95_proc_keys: 4834, tot_proc: 16m10s, tot_wait: 5m35.7s, rpc_num: 7789, rpc_time: 22m34.4s, copr_cache: disabled}, tikv_task:{proc max:267ms, min:0s, p80:103ms, p95:137ms, iters:49862, tasks:7789}, scan_detail: {total_process_keys: 17316493, total_keys: 18289891, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5627574, block: {cache_hit_count: 99030898, read_count: 1111, read_byte: 390.8 MB}}}	keep order:false	N/A	N/A
20:49:12 [2021-06-03T20:49:12.019Z]       └─IndexLookUp_39(Probe)	4.05	12022773	root		time:1m51s, loops:11947, index_task: {total_time: 1m0.1s, fetch_handle: 50.3s, build: 3.1ms, wait: 9.76s}, table_task: {total_time: 7m57.6s, num: 1408, concurrency: 730}		224.3 KB	N/A
20:49:12 [2021-06-03T20:49:12.019Z]         ├─IndexRangeScan_36(Build)	5.06	17183370	cop[tikv]	table:l3, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:48s, loops:18367, cop_task: {num: 2758, max: 794.3ms, min: 1.19ms, avg: 168.5ms, p95: 369.4ms, max_proc_keys: 19262, p95_proc_keys: 13771, tot_proc: 5m47.9s, tot_wait: 1m37.4s, rpc_num: 2758, rpc_time: 7m44.7s, copr_cache: disabled}, tikv_task:{proc max:186ms, min:0s, p80:79ms, p95:123ms, iters:29001, tasks:2758}, scan_detail: {total_process_keys: 17183370, total_keys: 20546393, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17183370, block: {cache_hit_count: 23553967, 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:12 [2021-06-03T20:49:12.019Z]         └─Selection_38(Probe)	4.05	12022773	cop[tikv]		time:6m4.7s, loops:13773, cop_task: {num: 10237, max: 556.2ms, min: 415µs, avg: 170.6ms, p95: 342.7ms, max_proc_keys: 6911, p95_proc_keys: 3952, tot_proc: 20m32.5s, tot_wait: 7m32s, rpc_num: 10237, rpc_time: 29m6.6s, copr_cache: disabled}, tikv_task:{proc max:218ms, min:0s, p80:75ms, p95:114ms, iters:60751, tasks:10237}, scan_detail: {total_process_keys: 17183370, total_keys: 18128741, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5525061, block: {cache_hit_count: 98290922, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:49:12 [2021-06-03T20:49:12.019Z]           └─TableRowIDScan_37	5.06	17183370	cop[tikv]	table:l3	tikv_task:{proc max:215ms, min:0s, p80:75ms, p95:113ms, iters:60751, tasks:10237}	keep order:false	N/A	N/A
20:49:12 [2021-06-03T20:49:12.019Z] + sync
20:49:12 [2021-06-03T20:49:12.019Z] + /usr/bin/echo 3
20:50:48 [2021-06-03T20:50:48.402Z] 
20:50:48 [2021-06-03T20:50:48.402Z] queries/21.sql
20:50:48 [2021-06-03T20:50:48.402Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:50:48 [2021-06-03T20:50:48.402Z] Projection_26	100.00	100	root		time:1m20s, loops:2, Concurrency:OFF	tpch50.supplier.s_name, Column#72	4.62 KB	N/A
20:50:48 [2021-06-03T20:50:48.402Z] └─TopN_29	100.00	100	root		time:1m20s, loops:2	Column#72:desc, tpch50.supplier.s_name, offset:0, count:100	58.4 KB	N/A
20:50:48 [2021-06-03T20:50:48.402Z]   └─HashAgg_34	12800.00	20057	root		time:1m20s, loops:21, partial_worker:{wall_time:1m20.009566985s, concurrency:5, task_num:197, tot_wait:6m39.747798533s, tot_exec:286.795331ms, tot_time:6m40.046546478s, max:1m20.009540655s, p95:1m20.009540655s}, final_worker:{wall_time:1m20.021717967s, concurrency:5, task_num:25, tot_wait:6m40.045042939s, tot_exec:63.063373ms, tot_time:6m40.108118213s, max:1m20.021701323s, p95:1m20.021701323s}	group by:tpch50.supplier.s_name, funcs:count(1)->Column#72, funcs:firstrow(tpch50.supplier.s_name)->tpch50.supplier.s_name	17.2 MB	N/A
20:50:48 [2021-06-03T20:50:48.402Z]     └─IndexHashJoin_42	7828961.66	198698	root		time:1m20s, loops:198, inner:{total:2m20.2s, concurrency:5, task:146, construct:6.43s, fetch:1m57.1s, build:1.16s, join:16.6s}	anti semi join, inner:IndexLookUp_39, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey)	641.0 MB	N/A
20:50:48 [2021-06-03T20:50:48.402Z]       ├─IndexHashJoin_83(Build)	9786202.08	3542799	root		time:1m19.5s, loops:3462, inner:{total:2m28.5s, concurrency:5, task:152, construct:7.62s, fetch:2m3.1s, build:1.17s, join:17.8s}	semi join, inner:IndexLookUp_80, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey), ne(tpch50.lineitem.l_suppkey, tpch50.supplier.s_suppkey)	555.9 MB	N/A
20:50:48 [2021-06-03T20:50:48.402Z]       │ ├─IndexJoin_99(Build)	12232752.60	3675878	root		time:1m18.9s, loops:3595, inner:{total:2m8.6s, concurrency:5, task:305, construct:16s, fetch:1m50.8s, build:1.88s}, probe:5.19s	inner join, inner:TableReader_95, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.orders.o_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.orders.o_orderkey)	575.3 MB	N/A
20:50:48 [2021-06-03T20:50:48.402Z]       │ │ ├─HashJoin_107(Build)	12232752.60	7609895	root		time:1m18.5s, loops:7437, build_hash_table:{total:1.07s, fetch:1.06s, build:6.71ms}, probe:{concurrency:5, total:6m34s, max:1m18.8s, probe:1m0.6s, fetch:5m33.4s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.lineitem.l_suppkey)]	737.6 KB	0 Bytes
20:50:48 [2021-06-03T20:50:48.402Z]       │ │ │ ├─HashJoin_120(Build)	20000.00	20058	root		time:1.06s, loops:22, build_hash_table:{total:200µs, fetch:193µs, build:6.96µs}, probe:{concurrency:5, total:5.33s, max:1.07s, probe:65.9ms, fetch:5.26s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:50:48 [2021-06-03T20:50:48.402Z]       │ │ │ │ ├─TableReader_125(Build)	1.00	1	root		time:73µs, loops:2, cop_task: {num: 1, max: 1.18ms, proc_keys: 25, rpc_num: 1, rpc_time: 1.14ms, copr_cache: disabled}	data:Selection_124	240 Bytes	N/A
20:50:48 [2021-06-03T20:50:48.402Z]       │ │ │ │ │ └─Selection_124	1.00	1	cop[tikv]		tikv_task:{time:0s, loops:1}, scan_detail: {total_process_keys: 25, total_keys: 26, rocksdb: {delete_skipped_count: 0, key_skipped_count: 46, block: {cache_hit_count: 17, read_count: 1, read_byte: 23.8 KB}}}	eq(tpch50.nation.n_name, "EGYPT")	N/A	N/A
20:50:48 [2021-06-03T20:50:48.402Z]       │ │ │ │ │   └─TableFullScan_123	25.00	25	cop[tikv]	table:nation	tikv_task:{time:0s, loops:1}	keep order:false	N/A	N/A
20:50:48 [2021-06-03T20:50:48.402Z]       │ │ │ │ └─TableReader_122(Probe)	500000.00	500000	root		time:1.05s, loops:490, cop_task: {num: 1, max: 1.05s, proc_keys: 500000, tot_proc: 1.03s, tot_wait: 1ms, rpc_num: 1, rpc_time: 1.05s, copr_cache: disabled}	data:TableFullScan_121	20.0 MB	N/A
20:50:48 [2021-06-03T20:50:48.402Z]       │ │ │ │   └─TableFullScan_121	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:971ms, loops:493}, scan_detail: {total_process_keys: 500000, total_keys: 500001, rocksdb: {delete_skipped_count: 0, key_skipped_count: 999999, block: {cache_hit_count: 13, read_count: 1679, read_byte: 104.5 MB}}}	keep order:false	N/A	N/A
20:50:48 [2021-06-03T20:50:48.402Z]       │ │ │ └─TableReader_128(Probe)	240004648.80	189670348	root		time:1m6.1s, loops:184596, cop_task: {num: 761, max: 3.16s, min: 294.3ms, avg: 1.51s, p95: 2.03s, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 17m57.4s, tot_wait: 1m0.4s, rpc_num: 761, rpc_time: 19m10.9s, copr_cache: disabled}	data:Selection_127	109.4 MB	N/A
20:50:48 [2021-06-03T20:50:48.402Z]       │ │ │   └─Selection_127	240004648.80	189670348	cop[tikv]		tikv_task:{proc max:1.3s, min:286ms, p80:1.15s, p95:1.2s, iters:296606, tasks:761}, scan_detail: {total_process_keys: 300005811, total_keys: 300006572, rocksdb: {delete_skipped_count: 0, key_skipped_count: 600010861, block: {cache_hit_count: 10454, read_count: 1114194, read_byte: 23.6 GB}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:50:48 [2021-06-03T20:50:48.402Z]       │ │ │     └─TableFullScan_126	300005811.00	300005811	cop[tikv]	table:l1	tikv_task:{proc max:1.24s, min:269ms, p80:1.08s, p95:1.12s, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:50:48 [2021-06-03T20:50:48.402Z]       │ │ └─TableReader_95(Probe)	0.49	3496178	root		time:1m41.9s, loops:3875, cop_task: {num: 5315, max: 635.6ms, min: 811µs, avg: 178ms, p95: 343.2ms, max_proc_keys: 3943, p95_proc_keys: 1954, tot_proc: 11m16.5s, tot_wait: 3m51.1s, rpc_num: 5315, rpc_time: 15m46s, copr_cache: disabled}	data:Selection_94	N/A	N/A
20:50:48 [2021-06-03T20:50:48.402Z]       │ │   └─Selection_94	0.49	3496178	cop[tikv]		tikv_task:{proc max:160ms, min:0s, p80:68ms, p95:81ms, iters:30413, tasks:5315}, scan_detail: {total_process_keys: 7236292, total_keys: 7795514, rocksdb: {delete_skipped_count: 0, key_skipped_count: 1778342, block: {cache_hit_count: 54006505, read_count: 218202, read_byte: 4.21 GB}}}	eq(tpch50.orders.o_orderstatus, "F")	N/A	N/A
20:50:48 [2021-06-03T20:50:48.402Z]       │ │     └─TableRangeScan_93	1.00	7236292	cop[tikv]	table:orders	tikv_task:{proc max:159ms, min:0s, p80:68ms, p95:81ms, iters:30413, tasks:5315}	range: decided by [tpch50.lineitem.l_orderkey], keep order:false	N/A	N/A
20:50:48 [2021-06-03T20:50:48.402Z]       │ └─IndexLookUp_80(Probe)	4.05	17316424	root		time:1m57.7s, loops:17131, index_task: {total_time: 1m5.3s, fetch_handle: 57.5s, build: 3.14ms, wait: 7.76s}, table_task: {total_time: 8m30.9s, num: 1458, concurrency: 760}		18.8 KB	N/A
20:50:48 [2021-06-03T20:50:48.402Z]       │   ├─IndexRangeScan_78(Build)	4.05	17316424	cop[tikv]	table:l2, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:55.1s, loops:18623, cop_task: {num: 3036, max: 738.8ms, min: 584.5µs, avg: 185.1ms, p95: 383.2ms, max_proc_keys: 13898, p95_proc_keys: 8776, tot_proc: 7m4.6s, tot_wait: 1m56.5s, rpc_num: 3036, rpc_time: 9m22s, copr_cache: disabled}, tikv_task:{proc max:198ms, min:0s, p80:95ms, p95:110ms, iters:30322, tasks:3036}, scan_detail: {total_process_keys: 17316424, total_keys: 20812523, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17316424, block: {cache_hit_count: 24259940, read_count: 225680, read_byte: 2.00 GB}}}	range: decided by [eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey)], keep order:false	N/A	N/A
20:50:48 [2021-06-03T20:50:48.402Z]       │   └─TableRowIDScan_79(Probe)	4.05	17316424	cop[tikv]	table:l2	time:6m21.4s, loops:21037, cop_task: {num: 7815, max: 646.2ms, min: 438.2µs, avg: 179.5ms, p95: 363.3ms, max_proc_keys: 12685, p95_proc_keys: 4862, tot_proc: 16m49.8s, tot_wait: 5m42.6s, rpc_num: 7815, rpc_time: 23m22.8s, copr_cache: disabled}, tikv_task:{proc max:271ms, min:0s, p80:104ms, p95:139ms, iters:49978, tasks:7815}, scan_detail: {total_process_keys: 17316424, total_keys: 18288461, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5626979, block: {cache_hit_count: 99014992, read_count: 1100, read_byte: 383.5 MB}}}	keep order:false	N/A	N/A
20:50:48 [2021-06-03T20:50:48.402Z]       └─IndexLookUp_39(Probe)	4.05	12022779	root		time:1m52s, loops:11944, index_task: {total_time: 1m0.1s, fetch_handle: 50s, build: 3.77ms, wait: 10.1s}, table_task: {total_time: 8m5.7s, num: 1408, concurrency: 730}		266.3 KB	N/A
20:50:48 [2021-06-03T20:50:48.402Z]         ├─IndexRangeScan_36(Build)	5.06	17183372	cop[tikv]	table:l3, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:47.6s, loops:18347, cop_task: {num: 2824, max: 849.4ms, min: 874.9µs, avg: 165.8ms, p95: 359.9ms, max_proc_keys: 20815, p95_proc_keys: 13473, tot_proc: 5m51.4s, tot_wait: 1m36.4s, rpc_num: 2824, rpc_time: 7m48.2s, copr_cache: disabled}, tikv_task:{proc max:186ms, min:0s, p80:78ms, p95:118ms, iters:29254, tasks:2824}, scan_detail: {total_process_keys: 17183372, total_keys: 20546395, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17183372, block: {cache_hit_count: 23553967, read_count: 0, read_byte: 0 Bytes}}}	range: decided by [eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey)], keep order:false	N/A	N/A
20:50:48 [2021-06-03T20:50:48.403Z]         └─Selection_38(Probe)	4.05	12022779	cop[tikv]		time:6m14.8s, loops:13767, cop_task: {num: 10236, max: 707.5ms, min: 421.4µs, avg: 174.8ms, p95: 353.5ms, max_proc_keys: 8495, p95_proc_keys: 3990, tot_proc: 20m54.3s, tot_wait: 7m48.2s, rpc_num: 10236, rpc_time: 29m48.8s, copr_cache: disabled}, tikv_task:{proc max:257ms, min:0s, p80:75ms, p95:115ms, iters:60673, tasks:10236}, scan_detail: {total_process_keys: 17183372, total_keys: 18129895, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5529621, block: {cache_hit_count: 98286996, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:50:48 [2021-06-03T20:50:48.403Z]           └─TableRowIDScan_37	5.06	17183372	cop[tikv]	table:l3	tikv_task:{proc max:256ms, min:0s, p80:75ms, p95:114ms, iters:60673, tasks:10236}	keep order:false	N/A	N/A
20:50:48 [2021-06-03T20:50:48.403Z] + sync
20:50:48 [2021-06-03T20:50:48.403Z] + /usr/bin/echo 3
20:52:09 [2021-06-03T20:52:09.784Z] 
20:52:09 [2021-06-03T20:52:09.784Z] queries/21.sql
20:52:09 [2021-06-03T20:52:09.784Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:52:09 [2021-06-03T20:52:09.784Z] 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:52:09 [2021-06-03T20:52:09.784Z] └─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:52:09 [2021-06-03T20:52:09.784Z]   └─HashAgg_34	12800.00	20057	root		time:1m19.9s, loops:21, partial_worker:{wall_time:1m19.921963085s, concurrency:5, task_num:197, tot_wait:6m39.369400549s, tot_exec:227.488611ms, tot_time:6m39.608940335s, max:1m19.921946216s, p95:1m19.921946216s}, final_worker:{wall_time:1m19.934328178s, concurrency:5, task_num:25, tot_wait:6m39.608571783s, tot_exec:62.414565ms, tot_time:6m39.670999549s, max:1m19.934315795s, p95:1m19.934315795s}	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:09 [2021-06-03T20:52:09.784Z]     └─IndexHashJoin_42	7828961.66	198698	root		time:1m19.9s, loops:198, inner:{total:2m21s, concurrency:5, task:146, construct:6.37s, fetch:1m58.8s, 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:52:09 [2021-06-03T20:52:09.784Z]       ├─IndexHashJoin_83(Build)	9786202.08	3542799	root		time:1m19.4s, loops:3463, inner:{total:2m32s, concurrency:5, task:152, construct:7.39s, fetch:2m6.8s, build:1.29s, join:17.8s}	semi join, inner:IndexLookUp_80, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey), ne(tpch50.lineitem.l_suppkey, tpch50.supplier.s_suppkey)	555.9 MB	N/A
20:52:09 [2021-06-03T20:52:09.784Z]       │ ├─IndexJoin_99(Build)	12232752.60	3675878	root		time:1m18.8s, loops:3595, inner:{total:2m8.6s, concurrency:5, task:305, construct:15.9s, fetch:1m50.7s, build:1.94s}, probe:5.23s	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:52:09 [2021-06-03T20:52:09.784Z]       │ │ ├─HashJoin_107(Build)	12232752.60	7609895	root		time:1m18.4s, loops:7435, build_hash_table:{total:1.07s, fetch:1.06s, build:6.47ms}, probe:{concurrency:5, total:6m33.4s, max:1m18.7s, probe:1m1.1s, fetch:5m32.3s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.lineitem.l_suppkey)]	737.6 KB	0 Bytes
20:52:09 [2021-06-03T20:52:09.784Z]       │ │ │ ├─HashJoin_120(Build)	20000.00	20058	root		time:1.07s, loops:22, build_hash_table:{total:247µs, fetch:239.7µs, build:7.26µs}, probe:{concurrency:5, total:5.34s, max:1.07s, probe:61.2ms, fetch:5.27s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:52:09 [2021-06-03T20:52:09.784Z]       │ │ │ │ ├─TableReader_125(Build)	1.00	1	root		time:56.5µs, loops:2, cop_task: {num: 1, max: 1.38ms, proc_keys: 25, tot_proc: 1ms, rpc_num: 1, rpc_time: 1.36ms, copr_cache: disabled}	data:Selection_124	248 Bytes	N/A
20:52:09 [2021-06-03T20:52:09.784Z]       │ │ │ │ │ └─Selection_124	1.00	1	cop[tikv]		tikv_task:{time:1ms, loops:1}, scan_detail: {total_process_keys: 25, total_keys: 26, rocksdb: {delete_skipped_count: 0, key_skipped_count: 46, block: {cache_hit_count: 17, read_count: 1, read_byte: 23.8 KB}}}	eq(tpch50.nation.n_name, "EGYPT")	N/A	N/A
20:52:09 [2021-06-03T20:52:09.784Z]       │ │ │ │ │   └─TableFullScan_123	25.00	25	cop[tikv]	table:nation	tikv_task:{time:1ms, loops:1}	keep order:false	N/A	N/A
20:52:09 [2021-06-03T20:52:09.784Z]       │ │ │ │ └─TableReader_122(Probe)	500000.00	500000	root		time:1.05s, loops:490, cop_task: {num: 1, max: 1.06s, proc_keys: 500000, tot_proc: 1.03s, rpc_num: 1, rpc_time: 1.06s, copr_cache: disabled}	data:TableFullScan_121	20.0 MB	N/A
20:52:09 [2021-06-03T20:52:09.784Z]       │ │ │ │   └─TableFullScan_121	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:965ms, loops:493}, scan_detail: {total_process_keys: 500000, total_keys: 500001, rocksdb: {delete_skipped_count: 0, key_skipped_count: 999999, block: {cache_hit_count: 13, read_count: 1679, read_byte: 104.5 MB}}}	keep order:false	N/A	N/A
20:52:09 [2021-06-03T20:52:09.784Z]       │ │ │ └─TableReader_128(Probe)	240004648.80	189670348	root		time:1m6.1s, loops:184597, cop_task: {num: 761, max: 3.03s, min: 402.1ms, avg: 1.51s, p95: 1.98s, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 17m52.4s, tot_wait: 1m3s, rpc_num: 761, rpc_time: 19m8.8s, copr_cache: disabled}	data:Selection_127	109.4 MB	N/A
20:52:09 [2021-06-03T20:52:09.784Z]       │ │ │   └─Selection_127	240004648.80	189670348	cop[tikv]		tikv_task:{proc max:1.28s, min:385ms, p80:1.16s, p95:1.2s, iters:296606, tasks:761}, scan_detail: {total_process_keys: 300005811, total_keys: 300006572, rocksdb: {delete_skipped_count: 0, key_skipped_count: 600010861, block: {cache_hit_count: 10455, read_count: 1114193, read_byte: 23.6 GB}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:52:09 [2021-06-03T20:52:09.784Z]       │ │ │     └─TableFullScan_126	300005811.00	300005811	cop[tikv]	table:l1	tikv_task:{proc max:1.2s, min:362ms, p80:1.08s, p95:1.12s, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:52:09 [2021-06-03T20:52:09.784Z]       │ │ └─TableReader_95(Probe)	0.49	3496184	root		time:1m41.9s, loops:3875, cop_task: {num: 5321, max: 620.3ms, min: 560.7µs, avg: 179.5ms, p95: 341.2ms, max_proc_keys: 3707, p95_proc_keys: 1961, tot_proc: 11m24.4s, tot_wait: 3m53.7s, rpc_num: 5321, rpc_time: 15m55s, copr_cache: disabled}	data:Selection_94	N/A	N/A
20:52:09 [2021-06-03T20:52:09.784Z]       │ │   └─Selection_94	0.49	3496184	cop[tikv]		tikv_task:{proc max:152ms, min:0s, p80:68ms, p95:81ms, iters:30416, tasks:5321}, scan_detail: {total_process_keys: 7236282, total_keys: 7795530, rocksdb: {delete_skipped_count: 0, key_skipped_count: 1778456, block: {cache_hit_count: 54006848, read_count: 218236, read_byte: 4.21 GB}}}	eq(tpch50.orders.o_orderstatus, "F")	N/A	N/A
20:52:09 [2021-06-03T20:52:09.784Z]       │ │     └─TableRangeScan_93	1.00	7236282	cop[tikv]	table:orders	tikv_task:{proc max:152ms, min:0s, p80:68ms, p95:81ms, iters:30416, tasks:5321}	range: decided by [tpch50.lineitem.l_orderkey], keep order:false	N/A	N/A
20:52:09 [2021-06-03T20:52:09.784Z]       │ └─IndexLookUp_80(Probe)	4.05	17316421	root		time:2m1.5s, loops:17128, index_task: {total_time: 1m5.5s, fetch_handle: 57s, build: 3.17ms, wait: 8.51s}, table_task: {total_time: 8m42.5s, num: 1458, concurrency: 760}		19.2 KB	N/A
20:52:09 [2021-06-03T20:52:09.784Z]       │   ├─IndexRangeScan_78(Build)	4.05	17316421	cop[tikv]	table:l2, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:54.7s, loops:18650, cop_task: {num: 3007, max: 674.3ms, min: 317.2µs, avg: 189.7ms, p95: 385.5ms, max_proc_keys: 12162, p95_proc_keys: 8747, tot_proc: 7m8.7s, tot_wait: 2m2.2s, rpc_num: 3007, rpc_time: 9m30.3s, copr_cache: disabled}, tikv_task:{proc max:175ms, min:0s, p80:96ms, p95:110ms, iters:30240, tasks:3007}, scan_detail: {total_process_keys: 17316421, total_keys: 20812521, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17316421, block: {cache_hit_count: 24259947, read_count: 225680, read_byte: 2.00 GB}}}	range: decided by [eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey)], keep order:false	N/A	N/A
20:52:09 [2021-06-03T20:52:09.784Z]       │   └─TableRowIDScan_79(Probe)	4.05	17316421	cop[tikv]	table:l2	time:6m32.2s, loops:21004, cop_task: {num: 7851, max: 676.5ms, min: 1.29ms, avg: 183.3ms, p95: 368.6ms, max_proc_keys: 13318, p95_proc_keys: 4838, tot_proc: 17m15.1s, tot_wait: 5m56s, rpc_num: 7851, rpc_time: 23m59.2s, copr_cache: disabled}, tikv_task:{proc max:272ms, min:0s, p80:103ms, p95:139ms, iters:50063, tasks:7851}, scan_detail: {total_process_keys: 17316421, total_keys: 18289265, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5629564, block: {cache_hit_count: 99016381, read_count: 1102, read_byte: 384.7 MB}}}	keep order:false	N/A	N/A
20:52:09 [2021-06-03T20:52:09.784Z]       └─IndexLookUp_39(Probe)	4.05	12022764	root		time:1m53.9s, loops:11947, index_task: {total_time: 1m2s, fetch_handle: 53.2s, build: 6.54ms, wait: 8.84s}, table_task: {total_time: 8m14.6s, num: 1408, concurrency: 730}		224.3 KB	N/A
20:52:09 [2021-06-03T20:52:09.784Z]         ├─IndexRangeScan_36(Build)	5.06	17183353	cop[tikv]	table:l3, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:50.9s, loops:18351, cop_task: {num: 2779, max: 740.1ms, min: 660.4µs, avg: 173.4ms, p95: 388.5ms, max_proc_keys: 17685, p95_proc_keys: 13804, tot_proc: 6m3.4s, tot_wait: 1m38.9s, rpc_num: 2779, rpc_time: 8m1.9s, copr_cache: disabled}, tikv_task:{proc max:184ms, min:0s, p80:80ms, p95:124ms, iters:29067, tasks:2779}, scan_detail: {total_process_keys: 17183353, total_keys: 20546375, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17183353, block: {cache_hit_count: 23553960, read_count: 0, read_byte: 0 Bytes}}}	range: decided by [eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey)], keep order:false	N/A	N/A
20:52:09 [2021-06-03T20:52:09.784Z]         └─Selection_38(Probe)	4.05	12022764	cop[tikv]		time:6m22.2s, loops:13769, cop_task: {num: 10306, max: 668.7ms, min: 436.2µs, avg: 179.2ms, p95: 358.4ms, max_proc_keys: 6986, p95_proc_keys: 3912, tot_proc: 21m34.2s, tot_wait: 8m7.9s, rpc_num: 10306, rpc_time: 30m46.7s, copr_cache: disabled}, tikv_task:{proc max:221ms, min:0s, p80:74ms, p95:113ms, iters:61002, tasks:10306}, scan_detail: {total_process_keys: 17183353, total_keys: 18129191, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5527848, block: {cache_hit_count: 98287924, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:52:09 [2021-06-03T20:52:09.784Z]           └─TableRowIDScan_37	5.06	17183353	cop[tikv]	table:l3	tikv_task:{proc max:220ms, min:0s, p80:74ms, p95:112ms, iters:61002, tasks:10306}	keep order:false	N/A	N/A
20:52:09 [2021-06-03T20:52:09.784Z] + sync
20:52:09 [2021-06-03T20:52:09.784Z] + /usr/bin/echo 3
20:53:31 [2021-06-03T20:53:31.167Z] 
20:53:31 [2021-06-03T20:53:31.167Z] queries/21.sql
20:53:31 [2021-06-03T20:53:31.167Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:53:31 [2021-06-03T20:53:31.167Z] Projection_26	100.00	100	root		time:1m19.8s, loops:2, Concurrency:OFF	tpch50.supplier.s_name, Column#72	4.62 KB	N/A
20:53:31 [2021-06-03T20:53:31.167Z] └─TopN_29	100.00	100	root		time:1m19.8s, loops:2	Column#72:desc, tpch50.supplier.s_name, offset:0, count:100	58.4 KB	N/A
20:53:31 [2021-06-03T20:53:31.167Z]   └─HashAgg_34	12800.00	20057	root		time:1m19.8s, loops:21, partial_worker:{wall_time:1m19.816340751s, concurrency:5, task_num:198, tot_wait:6m38.806783822s, tot_exec:260.793416ms, tot_time:6m39.079419128s, max:1m19.816314s, p95:1m19.816314s}, final_worker:{wall_time:1m19.828523736s, concurrency:5, task_num:25, tot_wait:6m39.077822546s, tot_exec:64.145999ms, tot_time:6m39.141987167s, max:1m19.828513157s, p95:1m19.828513157s}	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:31 [2021-06-03T20:53:31.167Z]     └─IndexHashJoin_42	7828961.66	198698	root		time:1m19.8s, loops:199, inner:{total:2m20.6s, concurrency:5, task:146, construct:6.49s, fetch:1m57.7s, build:1.27s, join:16.4s}	anti semi join, inner:IndexLookUp_39, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey)	641.0 MB	N/A
20:53:31 [2021-06-03T20:53:31.167Z]       ├─IndexHashJoin_83(Build)	9786202.08	3542799	root		time:1m19.2s, loops:3464, inner:{total:2m30.1s, concurrency:5, task:152, construct:7.8s, fetch:2m4.4s, build:1.22s, join:17.9s}	semi join, inner:IndexLookUp_80, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey), ne(tpch50.lineitem.l_suppkey, tpch50.supplier.s_suppkey)	555.9 MB	N/A
20:53:31 [2021-06-03T20:53:31.167Z]       │ ├─IndexJoin_99(Build)	12232752.60	3675878	root		time:1m18.7s, loops:3595, inner:{total:2m7.2s, concurrency:5, task:305, construct:15.6s, fetch:1m49.8s, build:1.81s}, probe:5.01s	inner join, inner:TableReader_95, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.orders.o_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.orders.o_orderkey)	575.5 MB	N/A
20:53:31 [2021-06-03T20:53:31.167Z]       │ │ ├─HashJoin_107(Build)	12232752.60	7609895	root		time:1m18.3s, loops:7436, build_hash_table:{total:1.08s, fetch:1.08s, build:6.86ms}, probe:{concurrency:5, total:6m33s, max:1m18.6s, probe:59.7s, fetch:5m33.2s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.lineitem.l_suppkey)]	757.3 KB	0 Bytes
20:53:31 [2021-06-03T20:53:31.167Z]       │ │ │ ├─HashJoin_120(Build)	20000.00	20058	root		time:1.08s, loops:23, build_hash_table:{total:270.2µs, fetch:261.7µs, build:8.48µs}, probe:{concurrency:5, total:5.41s, max:1.08s, probe:63.1ms, fetch:5.35s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:53:31 [2021-06-03T20:53:31.167Z]       │ │ │ │ ├─TableReader_125(Build)	1.00	1	root		time:86.4µs, loops:2, cop_task: {num: 1, max: 1.59ms, proc_keys: 25, rpc_num: 1, rpc_time: 1.58ms, copr_cache: disabled}	data:Selection_124	240 Bytes	N/A
20:53:31 [2021-06-03T20:53:31.167Z]       │ │ │ │ │ └─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:31 [2021-06-03T20:53:31.167Z]       │ │ │ │ │   └─TableFullScan_123	25.00	25	cop[tikv]	table:nation	tikv_task:{time:0s, loops:1}	keep order:false	N/A	N/A
20:53:31 [2021-06-03T20:53:31.167Z]       │ │ │ │ └─TableReader_122(Probe)	500000.00	500000	root		time:1.07s, loops:490, cop_task: {num: 1, max: 1.07s, proc_keys: 500000, tot_proc: 1.04s, rpc_num: 1, rpc_time: 1.07s, copr_cache: disabled}	data:TableFullScan_121	20.0 MB	N/A
20:53:31 [2021-06-03T20:53:31.167Z]       │ │ │ │   └─TableFullScan_121	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:996ms, 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:31 [2021-06-03T20:53:31.167Z]       │ │ │ └─TableReader_128(Probe)	240004648.80	189670348	root		time:1m6s, loops:184596, cop_task: {num: 761, max: 2.5s, min: 313.9ms, avg: 1.51s, p95: 2.01s, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 17m54.1s, tot_wait: 1m1.7s, rpc_num: 761, rpc_time: 19m9s, copr_cache: disabled}	data:Selection_127	109.4 MB	N/A
20:53:31 [2021-06-03T20:53:31.167Z]       │ │ │   └─Selection_127	240004648.80	189670348	cop[tikv]		tikv_task:{proc max:1.3s, min:300ms, p80:1.16s, p95:1.2s, iters:296606, tasks:761}, scan_detail: {total_process_keys: 300005811, total_keys: 300006572, rocksdb: {delete_skipped_count: 0, key_skipped_count: 600010861, block: {cache_hit_count: 10456, read_count: 1114192, read_byte: 23.6 GB}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:53:31 [2021-06-03T20:53:31.167Z]       │ │ │     └─TableFullScan_126	300005811.00	300005811	cop[tikv]	table:l1	tikv_task:{proc max:1.21s, min:279ms, p80:1.08s, p95:1.12s, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:53:31 [2021-06-03T20:53:31.167Z]       │ │ └─TableReader_95(Probe)	0.49	3496162	root		time:1m41.2s, loops:3875, cop_task: {num: 5292, max: 607.2ms, min: 1.94ms, avg: 180.7ms, p95: 350ms, max_proc_keys: 3808, p95_proc_keys: 1947, tot_proc: 11m24.3s, tot_wait: 3m53.8s, rpc_num: 5292, rpc_time: 15m56.4s, copr_cache: disabled}	data:Selection_94	N/A	N/A
20:53:31 [2021-06-03T20:53:31.167Z]       │ │   └─Selection_94	0.49	3496162	cop[tikv]		tikv_task:{proc max:144ms, min:0s, p80:68ms, p95:81ms, iters:30299, tasks:5292}, scan_detail: {total_process_keys: 7236246, total_keys: 7795467, rocksdb: {delete_skipped_count: 0, key_skipped_count: 1778335, block: {cache_hit_count: 54006295, read_count: 218210, read_byte: 4.21 GB}}}	eq(tpch50.orders.o_orderstatus, "F")	N/A	N/A
20:53:31 [2021-06-03T20:53:31.167Z]       │ │     └─TableRangeScan_93	1.00	7236246	cop[tikv]	table:orders	tikv_task:{proc max:144ms, min:0s, p80:68ms, p95:80ms, iters:30299, tasks:5292}	range: decided by [tpch50.lineitem.l_orderkey], keep order:false	N/A	N/A
20:53:31 [2021-06-03T20:53:31.167Z]       │ └─IndexLookUp_80(Probe)	4.05	17316464	root		time:1m59.1s, loops:17131, index_task: {total_time: 1m6.1s, fetch_handle: 57.4s, build: 3.49ms, wait: 8.75s}, table_task: {total_time: 8m33.3s, num: 1458, concurrency: 760}		18.8 KB	N/A
20:53:31 [2021-06-03T20:53:31.167Z]       │   ├─IndexRangeScan_78(Build)	4.05	17316464	cop[tikv]	table:l2, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:55.2s, loops:18614, cop_task: {num: 3018, max: 772.7ms, min: 478.6µs, avg: 188.9ms, p95: 381.2ms, max_proc_keys: 13064, p95_proc_keys: 8766, tot_proc: 7m8s, tot_wait: 2m2s, rpc_num: 3018, rpc_time: 9m29.9s, copr_cache: disabled}, tikv_task:{proc max:164ms, min:0s, p80:96ms, p95:111ms, iters:30191, tasks:3018}, scan_detail: {total_process_keys: 17316464, total_keys: 20812570, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17316464, block: {cache_hit_count: 24259979, read_count: 225690, read_byte: 2.00 GB}}}	range: decided by [eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey)], keep order:false	N/A	N/A
20:53:31 [2021-06-03T20:53:31.167Z]       │   └─TableRowIDScan_79(Probe)	4.05	17316464	cop[tikv]	table:l2	time:6m20.4s, loops:21028, cop_task: {num: 7815, max: 792.9ms, min: 551.7µs, avg: 178.8ms, p95: 353.2ms, max_proc_keys: 12919, p95_proc_keys: 4841, tot_proc: 16m41.3s, tot_wait: 5m45.3s, rpc_num: 7815, rpc_time: 23m16.9s, copr_cache: disabled}, tikv_task:{proc max:278ms, min:0s, p80:103ms, p95:138ms, iters:49996, tasks:7815}, scan_detail: {total_process_keys: 17316464, total_keys: 18291000, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5635106, block: {cache_hit_count: 99015441, read_count: 1118, read_byte: 408.7 MB}}}	keep order:false	N/A	N/A
20:53:31 [2021-06-03T20:53:31.167Z]       └─IndexLookUp_39(Probe)	4.05	12022770	root		time:1m52.7s, loops:11951, index_task: {total_time: 59.6s, fetch_handle: 49.3s, build: 3.15ms, wait: 10.3s}, table_task: {total_time: 8m6.9s, num: 1408, concurrency: 730}		266.1 KB	N/A
20:53:31 [2021-06-03T20:53:31.167Z]         ├─IndexRangeScan_36(Build)	5.06	17183351	cop[tikv]	table:l3, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:47.1s, loops:18354, cop_task: {num: 2778, max: 607.3ms, min: 522.4µs, avg: 170.7ms, p95: 353.5ms, max_proc_keys: 17807, p95_proc_keys: 13828, tot_proc: 5m51.5s, tot_wait: 1m43s, rpc_num: 2778, rpc_time: 7m54.1s, copr_cache: disabled}, tikv_task:{proc max:202ms, min:0s, p80:79ms, p95:125ms, iters:29020, tasks:2778}, scan_detail: {total_process_keys: 17183351, total_keys: 20546373, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17183351, block: {cache_hit_count: 23553960, 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:31 [2021-06-03T20:53:31.167Z]         └─Selection_38(Probe)	4.05	12022770	cop[tikv]		time:6m13.6s, loops:13759, cop_task: {num: 10285, max: 674.4ms, min: 399.3µs, avg: 174.1ms, p95: 356ms, max_proc_keys: 6974, p95_proc_keys: 3985, tot_proc: 20m56.9s, tot_wait: 7m44.8s, rpc_num: 10285, rpc_time: 29m50.1s, copr_cache: disabled}, tikv_task:{proc max:216ms, min:0s, p80:75ms, p95:115ms, iters:60878, tasks:10285}, scan_detail: {total_process_keys: 17183351, total_keys: 18129744, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5529897, block: {cache_hit_count: 98288394, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:53:31 [2021-06-03T20:53:31.168Z]           └─TableRowIDScan_37	5.06	17183351	cop[tikv]	table:l3	tikv_task:{proc max:215ms, min:0s, p80:75ms, p95:114ms, iters:60878, tasks:10285}	keep order:false	N/A	N/A
20:53:31 [2021-06-03T20:53:31.168Z] + sync
20:53:31 [2021-06-03T20:53:31.168Z] + /usr/bin/echo 3
20:54:52 [2021-06-03T20:54:52.603Z] 
20:54:52 [2021-06-03T20:54:52.603Z] queries/21.sql
20:54:52 [2021-06-03T20:54:52.603Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:54:52 [2021-06-03T20:54:52.603Z] Projection_26	100.00	100	root		time:1m20s, loops:2, Concurrency:OFF	tpch50.supplier.s_name, Column#72	4.62 KB	N/A
20:54:52 [2021-06-03T20:54:52.603Z] └─TopN_29	100.00	100	root		time:1m20s, loops:2	Column#72:desc, tpch50.supplier.s_name, offset:0, count:100	55.9 KB	N/A
20:54:52 [2021-06-03T20:54:52.603Z]   └─HashAgg_34	12800.00	20057	root		time:1m20s, loops:21, partial_worker:{wall_time:1m19.993622567s, concurrency:5, task_num:198, tot_wait:6m39.70632827s, tot_exec:245.76103ms, tot_time:6m39.965928237s, max:1m19.993595837s, p95:1m19.993595837s}, final_worker:{wall_time:1m20.006375033s, concurrency:5, task_num:25, tot_wait:6m39.963111309s, tot_exec:64.754149ms, tot_time:6m40.027878693s, max:1m20.006345052s, p95:1m20.006345052s}	group by:tpch50.supplier.s_name, funcs:count(1)->Column#72, funcs:firstrow(tpch50.supplier.s_name)->tpch50.supplier.s_name	17.2 MB	N/A
20:54:52 [2021-06-03T20:54:52.603Z]     └─IndexHashJoin_42	7828961.66	198698	root		time:1m20s, loops:199, inner:{total:2m17.4s, concurrency:5, task:146, construct:6.17s, fetch:1m54.2s, build:1.17s, join:17s}	anti semi join, inner:IndexLookUp_39, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey)	641.1 MB	N/A
20:54:52 [2021-06-03T20:54:52.603Z]       ├─IndexHashJoin_83(Build)	9786202.08	3542799	root		time:1m19.5s, loops:3463, inner:{total:2m25.9s, concurrency:5, task:152, construct:7.65s, fetch:2m0.6s, build:1.25s, join:17.7s}	semi join, inner:IndexLookUp_80, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey), ne(tpch50.lineitem.l_suppkey, tpch50.supplier.s_suppkey)	555.9 MB	N/A
20:54:52 [2021-06-03T20:54:52.603Z]       │ ├─IndexJoin_99(Build)	12232752.60	3675878	root		time:1m18.9s, loops:3595, inner:{total:2m5s, concurrency:5, task:305, construct:15.9s, fetch:1m47.2s, build:1.95s}, probe:5.24s	inner join, inner:TableReader_95, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.orders.o_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.orders.o_orderkey)	575.3 MB	N/A
20:54:52 [2021-06-03T20:54:52.603Z]       │ │ ├─HashJoin_107(Build)	12232752.60	7609895	root		time:1m18.4s, loops:7436, build_hash_table:{total:1.04s, fetch:1.04s, build:6.04ms}, probe:{concurrency:5, total:6m33.9s, max:1m18.8s, probe:1m0.5s, fetch:5m33.5s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.lineitem.l_suppkey)]	762.0 KB	0 Bytes
20:54:52 [2021-06-03T20:54:52.603Z]       │ │ │ ├─HashJoin_120(Build)	20000.00	20058	root		time:1.04s, loops:23, build_hash_table:{total:118µs, fetch:112.9µs, build:5.1µs}, probe:{concurrency:5, total:5.22s, max:1.04s, probe:64.9ms, fetch:5.15s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:54:52 [2021-06-03T20:54:52.603Z]       │ │ │ │ ├─TableReader_125(Build)	1.00	1	root		time:60µs, loops:2, cop_task: {num: 1, max: 1.75ms, proc_keys: 25, rpc_num: 1, rpc_time: 1.71ms, copr_cache: disabled}	data:Selection_124	234 Bytes	N/A
20:54:52 [2021-06-03T20:54:52.603Z]       │ │ │ │ │ └─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:54:52 [2021-06-03T20:54:52.603Z]       │ │ │ │ │   └─TableFullScan_123	25.00	25	cop[tikv]	table:nation	tikv_task:{time:0s, loops:1}	keep order:false	N/A	N/A
20:54:52 [2021-06-03T20:54:52.603Z]       │ │ │ │ └─TableReader_122(Probe)	500000.00	500000	root		time:1.03s, loops:490, cop_task: {num: 1, max: 1.03s, proc_keys: 500000, tot_proc: 994ms, rpc_num: 1, rpc_time: 1.03s, copr_cache: disabled}	data:TableFullScan_121	20.0 MB	N/A
20:54:52 [2021-06-03T20:54:52.603Z]       │ │ │ │   └─TableFullScan_121	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:937ms, 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:54:52 [2021-06-03T20:54:52.603Z]       │ │ │ └─TableReader_128(Probe)	240004648.80	189670348	root		time:1m6.2s, loops:184598, cop_task: {num: 761, max: 2.57s, min: 321.6ms, avg: 1.51s, p95: 1.99s, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 17m59.6s, tot_wait: 58.8s, rpc_num: 761, rpc_time: 19m11.2s, copr_cache: disabled}	data:Selection_127	109.4 MB	N/A
20:54:52 [2021-06-03T20:54:52.603Z]       │ │ │   └─Selection_127	240004648.80	189670348	cop[tikv]		tikv_task:{proc max:1.28s, min:298ms, p80:1.16s, p95:1.2s, iters:296606, tasks:761}, scan_detail: {total_process_keys: 300005811, total_keys: 300006572, rocksdb: {delete_skipped_count: 0, key_skipped_count: 600010861, block: {cache_hit_count: 10456, read_count: 1114192, read_byte: 23.6 GB}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:54:52 [2021-06-03T20:54:52.603Z]       │ │ │     └─TableFullScan_126	300005811.00	300005811	cop[tikv]	table:l1	tikv_task:{proc max:1.2s, min:282ms, p80:1.08s, p95:1.13s, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:54:52 [2021-06-03T20:54:52.603Z]       │ │ └─TableReader_95(Probe)	0.49	3496168	root		time:1m38.4s, loops:3875, cop_task: {num: 5301, max: 556.7ms, min: 1.19ms, avg: 172.5ms, p95: 332.7ms, max_proc_keys: 3430, p95_proc_keys: 1951, tot_proc: 11m1.5s, tot_wait: 3m33.9s, rpc_num: 5301, rpc_time: 15m14.2s, copr_cache: disabled}	data:Selection_94	N/A	N/A
20:54:52 [2021-06-03T20:54:52.603Z]       │ │   └─Selection_94	0.49	3496168	cop[tikv]		tikv_task:{proc max:135ms, min:0s, p80:68ms, p95:80ms, iters:30349, tasks:5301}, scan_detail: {total_process_keys: 7236276, total_keys: 7795508, rocksdb: {delete_skipped_count: 0, key_skipped_count: 1778404, block: {cache_hit_count: 54006610, read_count: 218237, read_byte: 4.21 GB}}}	eq(tpch50.orders.o_orderstatus, "F")	N/A	N/A
20:54:52 [2021-06-03T20:54:52.603Z]       │ │     └─TableRangeScan_93	1.00	7236276	cop[tikv]	table:orders	tikv_task:{proc max:134ms, min:0s, p80:68ms, p95:80ms, iters:30349, tasks:5301}	range: decided by [tpch50.lineitem.l_orderkey], keep order:false	N/A	N/A
20:54:52 [2021-06-03T20:54:52.603Z]       │ └─IndexLookUp_80(Probe)	4.05	17316429	root		time:1m55.4s, loops:17131, index_task: {total_time: 1m4.3s, fetch_handle: 56.9s, build: 3.11ms, wait: 7.45s}, table_task: {total_time: 8m16.2s, num: 1458, concurrency: 760}		19.2 KB	N/A
20:54:52 [2021-06-03T20:54:52.603Z]       │   ├─IndexRangeScan_78(Build)	4.05	17316429	cop[tikv]	table:l2, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:54.6s, loops:18618, cop_task: {num: 3030, max: 668.5ms, min: 474.8µs, avg: 185.5ms, p95: 374.1ms, max_proc_keys: 13565, p95_proc_keys: 8725, tot_proc: 7m1.6s, tot_wait: 1m59.7s, rpc_num: 3030, rpc_time: 9m22.1s, copr_cache: disabled}, tikv_task:{proc max:177ms, min:0s, p80:96ms, p95:111ms, iters:30326, tasks:3030}, scan_detail: {total_process_keys: 17316429, total_keys: 20812526, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17316429, block: {cache_hit_count: 24259930, read_count: 225676, read_byte: 2.00 GB}}}	range: decided by [eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey)], keep order:false	N/A	N/A
20:54:52 [2021-06-03T20:54:52.603Z]       │   └─TableRowIDScan_79(Probe)	4.05	17316429	cop[tikv]	table:l2	time:6m5.2s, loops:21019, cop_task: {num: 7793, max: 586.9ms, min: 385µs, avg: 171.1ms, p95: 342.4ms, max_proc_keys: 12685, p95_proc_keys: 4864, tot_proc: 16m3.4s, tot_wait: 5m20.1s, rpc_num: 7793, rpc_time: 22m13s, copr_cache: disabled}, tikv_task:{proc max:252ms, min:0s, p80:105ms, p95:138ms, iters:49833, tasks:7793}, scan_detail: {total_process_keys: 17316429, total_keys: 18290078, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5630203, block: {cache_hit_count: 99020861, read_count: 1114, read_byte: 395.2 MB}}}	keep order:false	N/A	N/A
20:54:52 [2021-06-03T20:54:52.603Z]       └─IndexLookUp_39(Probe)	4.05	12022766	root		time:1m49.7s, loops:11949, index_task: {total_time: 58.9s, fetch_handle: 48.5s, build: 3.09ms, wait: 10.4s}, table_task: {total_time: 7m53s, num: 1408, concurrency: 730}		262.7 KB	N/A
20:54:52 [2021-06-03T20:54:52.603Z]         ├─IndexRangeScan_36(Build)	5.06	17183368	cop[tikv]	table:l3, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:46.3s, loops:18374, cop_task: {num: 2801, max: 697.3ms, min: 1.29ms, avg: 164.7ms, p95: 359.4ms, max_proc_keys: 18744, p95_proc_keys: 13389, tot_proc: 5m42.5s, tot_wait: 1m38.7s, rpc_num: 2801, rpc_time: 7m41.2s, copr_cache: disabled}, tikv_task:{proc max:175ms, min:0s, p80:79ms, p95:117ms, iters:29197, tasks:2801}, scan_detail: {total_process_keys: 17183368, total_keys: 20546389, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17183368, block: {cache_hit_count: 23553953, read_count: 0, read_byte: 0 Bytes}}}	range: decided by [eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey)], keep order:false	N/A	N/A
20:54:52 [2021-06-03T20:54:52.603Z]         └─Selection_38(Probe)	4.05	12022766	cop[tikv]		time:6m2.2s, loops:13758, cop_task: {num: 10231, max: 591.2ms, min: 550.1µs, avg: 169ms, p95: 341.9ms, max_proc_keys: 6947, p95_proc_keys: 4029, tot_proc: 20m16.1s, tot_wait: 7m27.6s, rpc_num: 10231, rpc_time: 28m48.8s, copr_cache: disabled}, tikv_task:{proc max:200ms, min:0s, p80:76ms, p95:116ms, iters:60547, tasks:10231}, scan_detail: {total_process_keys: 17183368, total_keys: 18129389, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5527763, block: {cache_hit_count: 98286220, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:54:52 [2021-06-03T20:54:52.603Z]           └─TableRowIDScan_37	5.06	17183368	cop[tikv]	table:l3	tikv_task:{proc max:199ms, min:0s, p80:75ms, p95:115ms, iters:60547, tasks:10231}	keep order:false	N/A	N/A
20:54:52 [2021-06-03T20:54:52.603Z] + tiup cluster stop benchbot -y
20:54:52 [2021-06-03T20:54:52.603Z] Starting component `cluster`: /home/tidb/.tiup/components/cluster/v1.4.4/tiup-cluster stop benchbot -y
20:55:02 [2021-06-03T20:55:02.676Z] + rm -rf '/data1/tidb-deploy/*/log/*'
20:55:02 [2021-06-03T20:55:02.676Z] + rm -rf /data1/jenkins/deploy/data/tikv-20160
20:55:06 [2021-06-03T20:55:06.073Z] + rm -rf /data1/jenkins/deploy/data/pd-2379
20:55:06 [2021-06-03T20:55:06.073Z] + rm -rf /data1/jenkins/restore_data/tpch50/data/last_tikv.toml
20:55:06 [2021-06-03T20:55:06.073Z] + cp -R /data1/jenkins/restore_data/tpch50/data /data1/jenkins/deploy/data/tikv-20160
20:56:57 [2021-06-03T20:56:57.581Z] + cp -R /data1/jenkins/restore_data/tpch50/data.pd /data1/jenkins/deploy/data/pd-2379
20:56:57 [2021-06-03T20:56:57.581Z] + '[' -n '' ']'
20:56:57 [2021-06-03T20:56:57.581Z] + tiup cluster start benchbot --wait-timeout=300
20:56:57 [2021-06-03T20:56:57.581Z] Starting component `cluster`: /home/tidb/.tiup/components/cluster/v1.4.4/tiup-cluster start benchbot --wait-timeout=300
20:57:24 [2021-06-03T20:57:24.072Z] + sync
20:57:24 [2021-06-03T20:57:24.072Z] + /usr/bin/echo 3
20:57:56 [2021-06-03T20:57:56.098Z] + sync
20:57:56 [2021-06-03T20:57:56.098Z] + /usr/bin/echo 3
20:58:28 [2021-06-03T20:58:28.122Z] + sync
20:58:28 [2021-06-03T20:58:28.122Z] + /usr/bin/echo 3
20:58:54 [2021-06-03T20:58:54.620Z] 
20:58:54 [2021-06-03T20:58:54.620Z] queries/22.sql
20:58:54 [2021-06-03T20:58:54.620Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:58:54 [2021-06-03T20:58:54.620Z] Sort_39	1600000.00	4	root		time:25.2s, loops:2	Column#27	9.48 KB	0 Bytes
20:58:54 [2021-06-03T20:58:54.620Z] └─Projection_41	1600000.00	4	root		time:25.2s, loops:5, Concurrency:5	Column#27, Column#28, Column#29	23.7 KB	N/A
20:58:54 [2021-06-03T20:58:54.620Z]   └─HashAgg_42	1600000.00	4	root		time:25.2s, loops:5, partial_worker:{wall_time:25.185354522s, concurrency:5, task_num:180, tot_wait:2m5.871619501s, tot_exec:54.563621ms, tot_time:2m5.926327181s, max:25.185326124s, p95:25.185326124s}, final_worker:{wall_time:25.185418358s, concurrency:5, task_num:20, tot_wait:2m5.926351949s, tot_exec:376.343µs, tot_time:2m5.926751312s, max:25.185359061s, p95:25.185359061s}	group by:Column#33, funcs:count(1)->Column#28, funcs:sum(Column#31)->Column#29, funcs:firstrow(Column#32)->Column#27	857.7 KB	N/A
20:58:54 [2021-06-03T20:58:54.620Z]     └─Projection_51	1600000.00	181704	root		time:25.2s, loops:181, Concurrency:5	tpch50.customer.c_acctbal, substring(tpch50.customer.c_phone, 1, 2)->Column#32, substring(tpch50.customer.c_phone, 1, 2)->Column#33	693.6 KB	N/A
20:58:54 [2021-06-03T20:58:54.620Z]       └─HashJoin_43	1600000.00	181704	root		time:25.2s, loops:181, build_hash_table:{total:23.7s, fetch:1.05s, build:22.7s}, probe:{concurrency:5, total:2m5.9s, max:25.2s, probe:5.81s, fetch:2m0.1s}	anti semi join, equal:[eq(tpch50.customer.c_custkey, tpch50.orders.o_custkey)]	590.2 MB	0 Bytes
20:58:54 [2021-06-03T20:58:54.620Z]         ├─TableReader_49(Build)	75000000.00	75000000	root		time:1.05s, loops:73364, cop_task: {num: 153, max: 986.7ms, min: 284.8ms, avg: 573.3ms, p95: 855.7ms, max_proc_keys: 723875, p95_proc_keys: 553332, tot_proc: 1m26.9s, tot_wait: 31ms, rpc_num: 153, rpc_time: 1m27.7s, copr_cache: disabled}	data:TableFullScan_48	57.8 MB	N/A
20:58:54 [2021-06-03T20:58:54.620Z]         │ └─TableFullScan_48	75000000.00	75000000	cop[tikv]	table:orders	tikv_task:{proc max:949ms, min:270ms, p80:567ms, 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: 3018, read_count: 219935, read_byte: 4.29 GB}}}	keep order:false	N/A	N/A
20:58:54 [2021-06-03T20:58:54.620Z]         └─Selection_47(Probe)	2000000.00	545246	root		time:1.53s, loops:534	in(substring(tpch50.customer.c_phone, 1, 2), "20", "40", "22", "30", "39", "42", "21")	94.6 KB	N/A
20:58:54 [2021-06-03T20:58:54.620Z]           └─TableReader_46	2000000.00	3407619	root		time:635.7ms, loops:3319, cop_task: {num: 18, max: 1.01s, min: 501.8ms, avg: 750.6ms, p95: 1.01s, 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:58:54 [2021-06-03T20:58:54.620Z]             └─Selection_45	2000000.00	3407619	cop[tikv]		tikv_task:{proc max:936ms, min:475ms, p80:800ms, p95:936ms, iters:7404, tasks:18}, scan_detail: {total_process_keys: 7500000, total_keys: 7500018, rocksdb: {delete_skipped_count: 0, key_skipped_count: 14999982, block: {cache_hit_count: 28451, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.customer.c_acctbal, 5000.602894)	N/A	N/A
20:58:54 [2021-06-03T20:58:54.620Z]               └─TableFullScan_44	7500000.00	7500000	cop[tikv]	table:customer	tikv_task:{proc max:847ms, min:431ms, p80:730ms, p95:847ms, iters:7404, tasks:18}	keep order:false	N/A	N/A
20:58:54 [2021-06-03T20:58:54.620Z] 
20:58:54 [2021-06-03T20:58:54.620Z] queries/22.sql
20:58:54 [2021-06-03T20:58:54.620Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:58:54 [2021-06-03T20:58:54.620Z] Sort_39	2186432.06	4	root		time:24.8s, loops:2	Column#27	9.48 KB	0 Bytes
20:58:54 [2021-06-03T20:58:54.620Z] └─Projection_41	2186432.06	4	root		time:24.8s, loops:5, Concurrency:5	Column#27, Column#28, Column#29	23.7 KB	N/A
20:58:54 [2021-06-03T20:58:54.620Z]   └─HashAgg_42	2186432.06	4	root		time:24.8s, loops:5, partial_worker:{wall_time:24.795062217s, concurrency:5, task_num:180, tot_wait:2m3.922629982s, tot_exec:51.65621ms, tot_time:2m3.974402536s, max:24.79503211s, p95:24.79503211s}, final_worker:{wall_time:24.795118935s, concurrency:5, task_num:20, tot_wait:2m3.975035745s, tot_exec:277.4µs, tot_time:2m3.975323686s, max:24.795092718s, p95:24.795092718s}	group by:Column#33, funcs:count(1)->Column#28, funcs:sum(Column#31)->Column#29, funcs:firstrow(Column#32)->Column#27	857.7 KB	N/A
20:58:54 [2021-06-03T20:58:54.620Z]     └─Projection_51	2186432.06	181704	root		time:24.8s, loops:181, Concurrency:5	tpch50.customer.c_acctbal, substring(tpch50.customer.c_phone, 1, 2)->Column#32, substring(tpch50.customer.c_phone, 1, 2)->Column#33	693.6 KB	N/A
20:58:54 [2021-06-03T20:58:54.620Z]       └─HashJoin_43	2186432.06	181704	root		time:24.8s, loops:181, build_hash_table:{total:23.4s, fetch:897.6ms, build:22.5s}, probe:{concurrency:5, total:2m4s, max:24.8s, probe:5.59s, fetch:1m58.4s}	anti semi join, equal:[eq(tpch50.customer.c_custkey, tpch50.orders.o_custkey)]	590.2 MB	0 Bytes
20:58:54 [2021-06-03T20:58:54.620Z]         ├─TableReader_49(Build)	75000000.00	75000000	root		time:897.4ms, loops:73364, cop_task: {num: 153, max: 1.24s, min: 219.9ms, avg: 528.7ms, p95: 1.05s, max_proc_keys: 723875, p95_proc_keys: 553332, tot_proc: 1m20.1s, tot_wait: 40ms, rpc_num: 153, rpc_time: 1m20.9s, copr_cache: disabled}	data:TableFullScan_48	57.8 MB	N/A
20:58:54 [2021-06-03T20:58:54.620Z]         │ └─TableFullScan_48	75000000.00	75000000	cop[tikv]	table:orders	tikv_task:{proc max:1.21s, min:209ms, p80:536ms, p95:988ms, iters:73975, tasks:153}, scan_detail: {total_process_keys: 75000000, total_keys: 75000153, rocksdb: {delete_skipped_count: 0, key_skipped_count: 149999847, block: {cache_hit_count: 220923, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:58:54 [2021-06-03T20:58:54.620Z]         └─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:58:54 [2021-06-03T20:58:54.620Z]           └─TableReader_46	2733040.07	3407619	root		time:659.9ms, loops:3319, cop_task: {num: 18, max: 1.33s, min: 464ms, avg: 914.1ms, p95: 1.33s, max_proc_keys: 582617, p95_proc_keys: 582617, tot_proc: 16s, rpc_num: 18, rpc_time: 16.5s, copr_cache: disabled}	data:Selection_45	192.5 MB	N/A
20:58:54 [2021-06-03T20:58:54.620Z]             └─Selection_45	2733040.07	3407619	cop[tikv]		tikv_task:{proc max:1.25s, min:432ms, p80:1.01s, p95:1.25s, iters:7404, tasks:18}, scan_detail: {total_process_keys: 7500000, total_keys: 7500018, rocksdb: {delete_skipped_count: 0, key_skipped_count: 14999982, block: {cache_hit_count: 28451, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.customer.c_acctbal, 5000.602894)	N/A	N/A
20:58:54 [2021-06-03T20:58:54.620Z]               └─TableFullScan_44	7500000.00	7500000	cop[tikv]	table:customer	tikv_task:{proc max:1.13s, min:386ms, p80:924ms, p95:1.13s, iters:7404, tasks:18}	keep order:false	N/A	N/A
20:58:54 [2021-06-03T20:58:54.620Z] 
20:58:54 [2021-06-03T20:58:54.620Z] queries/22.sql
20:58:54 [2021-06-03T20:58:54.620Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:58:54 [2021-06-03T20:58:54.620Z] Sort_39	2186432.06	4	root		time:25.5s, loops:2	Column#27	9.48 KB	0 Bytes
20:58:54 [2021-06-03T20:58:54.620Z] └─Projection_41	2186432.06	4	root		time:25.5s, loops:5, Concurrency:5	Column#27, Column#28, Column#29	23.7 KB	N/A
20:58:54 [2021-06-03T20:58:54.620Z]   └─HashAgg_42	2186432.06	4	root		time:25.5s, loops:5, partial_worker:{wall_time:25.484699388s, concurrency:5, task_num:180, tot_wait:2m7.373575806s, tot_exec:48.814208ms, tot_time:2m7.422488597s, max:25.48465358s, p95:25.48465358s}, final_worker:{wall_time:25.484716061s, concurrency:5, task_num:20, tot_wait:2m7.423118738s, tot_exec:260.934µs, tot_time:2m7.423387982s, max:25.484681905s, p95:25.484681905s}	group by:Column#33, funcs:count(1)->Column#28, funcs:sum(Column#31)->Column#29, funcs:firstrow(Column#32)->Column#27	857.7 KB	N/A
20:58:54 [2021-06-03T20:58:54.620Z]     └─Projection_51	2186432.06	181704	root		time:25.5s, loops:181, Concurrency:5	tpch50.customer.c_acctbal, substring(tpch50.customer.c_phone, 1, 2)->Column#32, substring(tpch50.customer.c_phone, 1, 2)->Column#33	693.6 KB	N/A
20:58:54 [2021-06-03T20:58:54.620Z]       └─HashJoin_43	2186432.06	181704	root		time:25.5s, loops:181, build_hash_table:{total:24.1s, fetch:880ms, build:23.2s}, probe:{concurrency:5, total:2m7.4s, max:25.5s, probe:5.58s, fetch:2m1.8s}	anti semi join, equal:[eq(tpch50.customer.c_custkey, tpch50.orders.o_custkey)]	590.2 MB	0 Bytes
20:58:54 [2021-06-03T20:58:54.620Z]         ├─TableReader_49(Build)	75000000.00	75000000	root		time:889.1ms, loops:73364, cop_task: {num: 153, max: 986.1ms, min: 204.8ms, avg: 480.1ms, p95: 866.9ms, max_proc_keys: 723875, p95_proc_keys: 553332, tot_proc: 1m12.6s, tot_wait: 58ms, rpc_num: 153, rpc_time: 1m13.4s, copr_cache: disabled}	data:TableFullScan_48	57.8 MB	N/A
20:58:54 [2021-06-03T20:58:54.620Z]         │ └─TableFullScan_48	75000000.00	75000000	cop[tikv]	table:orders	tikv_task:{proc max:931ms, min:196ms, p80:476ms, 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
20:58:54 [2021-06-03T20:58:54.620Z]         └─Selection_47(Probe)	2733040.07	545246	root		time:1.49s, loops:534	in(substring(tpch50.customer.c_phone, 1, 2), "20", "40", "22", "30", "39", "42", "21")	94.6 KB	N/A
20:58:54 [2021-06-03T20:58:54.620Z]           └─TableReader_46	2733040.07	3407619	root		time:674.6ms, loops:3319, cop_task: {num: 18, max: 1.17s, min: 481.6ms, avg: 798.4ms, p95: 1.17s, max_proc_keys: 582617, p95_proc_keys: 582617, tot_proc: 14s, tot_wait: 5ms, rpc_num: 18, rpc_time: 14.4s, copr_cache: disabled}	data:Selection_45	192.5 MB	N/A
20:58:54 [2021-06-03T20:58:54.620Z]             └─Selection_45	2733040.07	3407619	cop[tikv]		tikv_task:{proc max:1.11s, min:444ms, p80:908ms, p95:1.11s, iters:7404, tasks:18}, scan_detail: {total_process_keys: 7500000, total_keys: 7500018, rocksdb: {delete_skipped_count: 0, key_skipped_count: 14999982, block: {cache_hit_count: 28451, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.customer.c_acctbal, 5000.602894)	N/A	N/A
20:58:54 [2021-06-03T20:58:54.620Z]               └─TableFullScan_44	7500000.00	7500000	cop[tikv]	table:customer	tikv_task:{proc max:1.02s, min:393ms, p80:840ms, p95:1.02s, iters:7404, tasks:18}	keep order:false	N/A	N/A
20:58:54 [2021-06-03T20:58:54.620Z] + sync
20:58:54 [2021-06-03T20:58:54.620Z] + /usr/bin/echo 3
20:59:21 [2021-06-03T20:59:21.114Z] + sync
20:59:21 [2021-06-03T20:59:21.114Z] + /usr/bin/echo 3
20:59:53 [2021-06-03T20:59:53.134Z] + sync
20:59:53 [2021-06-03T20:59:53.134Z] + /usr/bin/echo 3
21:00:19 [2021-06-03T21:00:19.618Z] 
21:00:19 [2021-06-03T21:00:19.618Z] queries/22.sql
21:00:19 [2021-06-03T21:00:19.618Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
21:00:19 [2021-06-03T21:00:19.618Z] Sort_39	2186432.06	4	root		time:25.1s, loops:2	Column#27	9.48 KB	0 Bytes
21:00:19 [2021-06-03T21:00:19.618Z] └─Projection_41	2186432.06	4	root		time:25.1s, loops:5, Concurrency:5	Column#27, Column#28, Column#29	23.7 KB	N/A
21:00:19 [2021-06-03T21:00:19.618Z]   └─HashAgg_42	2186432.06	4	root		time:25.1s, loops:5, partial_worker:{wall_time:25.07518074s, concurrency:5, task_num:180, tot_wait:2m5.324010338s, tot_exec:50.953379ms, tot_time:2m5.375052714s, max:25.075152287s, p95:25.075152287s}, final_worker:{wall_time:25.07519148s, concurrency:5, task_num:20, tot_wait:2m5.375592001s, tot_exec:233.871µs, tot_time:2m5.375834377s, max:25.075172494s, p95:25.075172494s}	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:19 [2021-06-03T21:00:19.618Z]     └─Projection_51	2186432.06	181704	root		time:25.1s, loops:181, Concurrency:5	tpch50.customer.c_acctbal, substring(tpch50.customer.c_phone, 1, 2)->Column#32, substring(tpch50.customer.c_phone, 1, 2)->Column#33	693.6 KB	N/A
21:00:19 [2021-06-03T21:00:19.618Z]       └─HashJoin_43	2186432.06	181704	root		time:25.1s, loops:181, build_hash_table:{total:23.8s, fetch:909.8ms, build:22.9s}, probe:{concurrency:5, total:2m5.4s, max:25.1s, probe:4.88s, fetch:2m0.5s}	anti semi join, equal:[eq(tpch50.customer.c_custkey, tpch50.orders.o_custkey)]	590.2 MB	0 Bytes
21:00:19 [2021-06-03T21:00:19.618Z]         ├─TableReader_49(Build)	75000000.00	75000000	root		time:927.6ms, loops:73364, cop_task: {num: 153, max: 965.2ms, min: 245.5ms, avg: 495.2ms, p95: 862.3ms, max_proc_keys: 723875, p95_proc_keys: 553332, tot_proc: 1m15s, tot_wait: 31ms, rpc_num: 153, rpc_time: 1m15.8s, copr_cache: disabled}	data:TableFullScan_48	57.8 MB	N/A
21:00:19 [2021-06-03T21:00:19.618Z]         │ └─TableFullScan_48	75000000.00	75000000	cop[tikv]	table:orders	tikv_task:{proc max:933ms, min:235ms, p80:505ms, p95:838ms, iters:73975, tasks:153}, scan_detail: {total_process_keys: 75000000, total_keys: 75000153, rocksdb: {delete_skipped_count: 0, key_skipped_count: 149999847, block: {cache_hit_count: 220923, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
21:00:19 [2021-06-03T21:00:19.618Z]         └─Selection_47(Probe)	2733040.07	545246	root		time:1.65s, loops:534	in(substring(tpch50.customer.c_phone, 1, 2), "20", "40", "22", "30", "39", "42", "21")	94.6 KB	N/A
21:00:19 [2021-06-03T21:00:19.618Z]           └─TableReader_46	2733040.07	3407619	root		time:829.2ms, loops:3319, cop_task: {num: 18, max: 1.23s, min: 500.8ms, avg: 872.5ms, p95: 1.23s, max_proc_keys: 582617, p95_proc_keys: 582617, tot_proc: 15.2s, rpc_num: 18, rpc_time: 15.7s, copr_cache: disabled}	data:Selection_45	192.5 MB	N/A
21:00:19 [2021-06-03T21:00:19.618Z]             └─Selection_45	2733040.07	3407619	cop[tikv]		tikv_task:{proc max:1.15s, min:451ms, p80:1.03s, p95:1.15s, iters:7404, tasks:18}, scan_detail: {total_process_keys: 7500000, total_keys: 7500018, rocksdb: {delete_skipped_count: 0, key_skipped_count: 14999982, block: {cache_hit_count: 28451, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.customer.c_acctbal, 5000.602894)	N/A	N/A
21:00:19 [2021-06-03T21:00:19.618Z]               └─TableFullScan_44	7500000.00	7500000	cop[tikv]	table:customer	tikv_task:{proc max:1.06s, min:407ms, p80:946ms, p95:1.06s, iters:7404, tasks:18}	keep order:false	N/A	N/A
21:00:19 [2021-06-03T21:00:19.618Z] 
21:00:19 [2021-06-03T21:00:19.618Z] queries/22.sql
21:00:19 [2021-06-03T21:00:19.618Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
21:00:19 [2021-06-03T21:00:19.618Z] Sort_39	2186432.06	4	root		time:24.4s, loops:2	Column#27	9.48 KB	0 Bytes
21:00:19 [2021-06-03T21:00:19.618Z] └─Projection_41	2186432.06	4	root		time:24.4s, loops:5, Concurrency:5	Column#27, Column#28, Column#29	23.7 KB	N/A
21:00:19 [2021-06-03T21:00:19.618Z]   └─HashAgg_42	2186432.06	4	root		time:24.4s, loops:5, partial_worker:{wall_time:24.432966183s, concurrency:5, task_num:180, tot_wait:2m2.115010807s, tot_exec:48.376676ms, tot_time:2m2.163486228s, max:24.432846833s, p95:24.432846833s}, final_worker:{wall_time:24.433008292s, concurrency:5, task_num:20, tot_wait:2m2.164189457s, tot_exec:260.062µs, tot_time:2m2.164457256s, max:24.432901702s, p95:24.432901702s}	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:19 [2021-06-03T21:00:19.618Z]     └─Projection_51	2186432.06	181704	root		time:24.4s, loops:181, Concurrency:5	tpch50.customer.c_acctbal, substring(tpch50.customer.c_phone, 1, 2)->Column#32, substring(tpch50.customer.c_phone, 1, 2)->Column#33	693.6 KB	N/A
21:00:19 [2021-06-03T21:00:19.618Z]       └─HashJoin_43	2186432.06	181704	root		time:24.4s, loops:181, build_hash_table:{total:23.1s, fetch:910ms, build:22.2s}, probe:{concurrency:5, total:2m2.1s, max:24.4s, probe:5.32s, fetch:1m56.8s}	anti semi join, equal:[eq(tpch50.customer.c_custkey, tpch50.orders.o_custkey)]	590.2 MB	0 Bytes
21:00:19 [2021-06-03T21:00:19.618Z]         ├─TableReader_49(Build)	75000000.00	75000000	root		time:902.4ms, loops:73364, cop_task: {num: 153, max: 950.8ms, min: 201.3ms, avg: 492.7ms, p95: 876.8ms, max_proc_keys: 723875, p95_proc_keys: 553332, tot_proc: 1m14.7s, tot_wait: 34ms, rpc_num: 153, rpc_time: 1m15.4s, copr_cache: disabled}	data:TableFullScan_48	54.1 MB	N/A
21:00:19 [2021-06-03T21:00:19.618Z]         │ └─TableFullScan_48	75000000.00	75000000	cop[tikv]	table:orders	tikv_task:{proc max:918ms, min:191ms, p80:517ms, p95:849ms, 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:19 [2021-06-03T21:00:19.618Z]         └─Selection_47(Probe)	2733040.07	545246	root		time:1.33s, loops:534	in(substring(tpch50.customer.c_phone, 1, 2), "20", "40", "22", "30", "39", "42", "21")	94.6 KB	N/A
21:00:19 [2021-06-03T21:00:19.618Z]           └─TableReader_46	2733040.07	3407619	root		time:569.9ms, loops:3319, cop_task: {num: 18, max: 1.18s, min: 459.8ms, avg: 831.4ms, p95: 1.18s, max_proc_keys: 582617, p95_proc_keys: 582617, tot_proc: 14.6s, tot_wait: 3ms, rpc_num: 18, rpc_time: 15s, copr_cache: disabled}	data:Selection_45	192.5 MB	N/A
21:00:19 [2021-06-03T21:00:19.618Z]             └─Selection_45	2733040.07	3407619	cop[tikv]		tikv_task:{proc max:1.12s, min:434ms, p80:934ms, p95:1.12s, iters:7404, tasks:18}, scan_detail: {total_process_keys: 7500000, total_keys: 7500018, rocksdb: {delete_skipped_count: 0, key_skipped_count: 14999982, block: {cache_hit_count: 28451, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.customer.c_acctbal, 5000.602894)	N/A	N/A
21:00:19 [2021-06-03T21:00:19.618Z]               └─TableFullScan_44	7500000.00	7500000	cop[tikv]	table:customer	tikv_task:{proc max:1.02s, min:398ms, p80:852ms, p95:1.02s, iters:7404, tasks:18}	keep order:false	N/A	N/A
21:00:19 [2021-06-03T21:00:19.618Z] 
21:00:19 [2021-06-03T21:00:19.618Z] queries/22.sql
21:00:19 [2021-06-03T21:00:19.618Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
21:00:19 [2021-06-03T21:00:19.618Z] Sort_39	2186432.06	4	root		time:25.8s, loops:2	Column#27	9.48 KB	0 Bytes
21:00:19 [2021-06-03T21:00:19.618Z] └─Projection_41	2186432.06	4	root		time:25.8s, loops:5, Concurrency:5	Column#27, Column#28, Column#29	23.7 KB	N/A
21:00:19 [2021-06-03T21:00:19.618Z]   └─HashAgg_42	2186432.06	4	root		time:25.8s, loops:5, partial_worker:{wall_time:25.777445572s, concurrency:5, task_num:181, tot_wait:2m8.83147753s, tot_exec:55.208963ms, tot_time:2m8.886790473s, max:25.77741203s, p95:25.77741203s}, final_worker:{wall_time:25.777480687s, concurrency:5, task_num:20, tot_wait:2m8.887014524s, tot_exec:256.336µs, tot_time:2m8.887283473s, max:25.777462705s, p95:25.777462705s}	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:19 [2021-06-03T21:00:19.618Z]     └─Projection_51	2186432.06	181704	root		time:25.8s, loops:182, Concurrency:5	tpch50.customer.c_acctbal, substring(tpch50.customer.c_phone, 1, 2)->Column#32, substring(tpch50.customer.c_phone, 1, 2)->Column#33	693.6 KB	N/A
21:00:19 [2021-06-03T21:00:19.619Z]       └─HashJoin_43	2186432.06	181704	root		time:25.8s, loops:182, build_hash_table:{total:24.3s, fetch:911.6ms, build:23.4s}, probe:{concurrency:5, total:2m8.8s, max:25.8s, probe:5.51s, fetch:2m3.3s}	anti semi join, equal:[eq(tpch50.customer.c_custkey, tpch50.orders.o_custkey)]	590.2 MB	0 Bytes
21:00:19 [2021-06-03T21:00:19.619Z]         ├─TableReader_49(Build)	75000000.00	75000000	root		time:937.3ms, loops:73364, cop_task: {num: 153, max: 940.8ms, min: 259ms, avg: 494.2ms, p95: 863.3ms, max_proc_keys: 723875, p95_proc_keys: 553332, tot_proc: 1m14.9s, tot_wait: 30ms, rpc_num: 153, rpc_time: 1m15.6s, copr_cache: disabled}	data:TableFullScan_48	57.8 MB	N/A
21:00:19 [2021-06-03T21:00:19.619Z]         │ └─TableFullScan_48	75000000.00	75000000	cop[tikv]	table:orders	tikv_task:{proc max:909ms, min:247ms, p80:500ms, p95:840ms, iters:73975, tasks:153}, scan_detail: {total_process_keys: 75000000, total_keys: 75000153, rocksdb: {delete_skipped_count: 0, key_skipped_count: 149999847, block: {cache_hit_count: 220923, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
21:00:19 [2021-06-03T21:00:19.619Z]         └─Selection_47(Probe)	2733040.07	545246	root		time:1.55s, loops:534	in(substring(tpch50.customer.c_phone, 1, 2), "20", "40", "22", "30", "39", "42", "21")	94.6 KB	N/A
21:00:19 [2021-06-03T21:00:19.619Z]           └─TableReader_46	2733040.07	3407619	root		time:634.5ms, loops:3319, cop_task: {num: 18, max: 1.21s, min: 473.6ms, avg: 842.3ms, p95: 1.21s, max_proc_keys: 582617, p95_proc_keys: 582617, tot_proc: 14.7s, rpc_num: 18, rpc_time: 15.2s, copr_cache: disabled}	data:Selection_45	192.5 MB	N/A
21:00:19 [2021-06-03T21:00:19.619Z]             └─Selection_45	2733040.07	3407619	cop[tikv]		tikv_task:{proc max:1.14s, min:449ms, p80:936ms, p95:1.14s, iters:7404, tasks:18}, scan_detail: {total_process_keys: 7500000, total_keys: 7500018, rocksdb: {delete_skipped_count: 0, key_skipped_count: 14999982, block: {cache_hit_count: 28451, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.customer.c_acctbal, 5000.602894)	N/A	N/A
21:00:19 [2021-06-03T21:00:19.619Z]               └─TableFullScan_44	7500000.00	7500000	cop[tikv]	table:customer	tikv_task:{proc max:1.03s, min:410ms, p80:844ms, p95:1.03s, iters:7404, tasks:18}	keep order:false	N/A	N/A
21:00:19 [2021-06-03T21:00:19.619Z] + sync
21:00:19 [2021-06-03T21:00:19.619Z] + /usr/bin/echo 3
21:00:51 [2021-06-03T21:00:51.632Z] 
21:00:51 [2021-06-03T21:00:51.632Z] queries/22.sql
21:00:51 [2021-06-03T21:00:51.632Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
21:00:51 [2021-06-03T21:00:51.632Z] Sort_39	2186432.06	4	root		time:24.1s, loops:2	Column#27	9.48 KB	0 Bytes
21:00:51 [2021-06-03T21:00:51.632Z] └─Projection_41	2186432.06	4	root		time:24.1s, loops:5, Concurrency:5	Column#27, Column#28, Column#29	23.7 KB	N/A
21:00:51 [2021-06-03T21:00:51.632Z]   └─HashAgg_42	2186432.06	4	root		time:24.1s, loops:5, partial_worker:{wall_time:24.127083079s, concurrency:5, task_num:180, tot_wait:2m0.58411834s, tot_exec:50.897666ms, tot_time:2m0.635130833s, max:24.12705437s, p95:24.12705437s}, final_worker:{wall_time:24.127165878s, concurrency:5, task_num:20, tot_wait:2m0.635220548s, tot_exec:203.06µs, tot_time:2m0.635431992s, max:24.127138471s, p95:24.127138471s}	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:51 [2021-06-03T21:00:51.632Z]     └─Projection_51	2186432.06	181704	root		time:24.1s, loops:181, Concurrency:5	tpch50.customer.c_acctbal, substring(tpch50.customer.c_phone, 1, 2)->Column#32, substring(tpch50.customer.c_phone, 1, 2)->Column#33	693.6 KB	N/A
21:00:51 [2021-06-03T21:00:51.632Z]       └─HashJoin_43	2186432.06	181704	root		time:24.1s, loops:181, build_hash_table:{total:22.9s, fetch:1.06s, build:21.9s}, probe:{concurrency:5, total:2m0.6s, max:24.1s, probe:4.84s, fetch:1m55.8s}	anti semi join, equal:[eq(tpch50.customer.c_custkey, tpch50.orders.o_custkey)]	590.2 MB	0 Bytes
21:00:51 [2021-06-03T21:00:51.632Z]         ├─TableReader_49(Build)	75000000.00	75000000	root		time:1.06s, loops:73364, cop_task: {num: 153, max: 1.06s, min: 272.6ms, avg: 496.6ms, p95: 898.3ms, max_proc_keys: 723875, p95_proc_keys: 553332, tot_proc: 1m15.2s, tot_wait: 34ms, rpc_num: 153, rpc_time: 1m16s, copr_cache: disabled}	data:TableFullScan_48	57.8 MB	N/A
21:00:51 [2021-06-03T21:00:51.632Z]         │ └─TableFullScan_48	75000000.00	75000000	cop[tikv]	table:orders	tikv_task:{proc max:1.04s, min:259ms, p80:498ms, p95:867ms, 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:51 [2021-06-03T21:00:51.632Z]         └─Selection_47(Probe)	2733040.07	545246	root		time:1.43s, loops:534	in(substring(tpch50.customer.c_phone, 1, 2), "20", "40", "22", "30", "39", "42", "21")	94.6 KB	N/A
21:00:51 [2021-06-03T21:00:51.632Z]           └─TableReader_46	2733040.07	3407619	root		time:643.7ms, loops:3319, cop_task: {num: 18, max: 1.23s, min: 486ms, avg: 843ms, p95: 1.23s, max_proc_keys: 582617, p95_proc_keys: 582617, tot_proc: 14.7s, tot_wait: 2ms, rpc_num: 18, rpc_time: 15.2s, copr_cache: disabled}	data:Selection_45	192.5 MB	N/A
21:00:51 [2021-06-03T21:00:51.632Z]             └─Selection_45	2733040.07	3407619	cop[tikv]		tikv_task:{proc max:1.17s, min:443ms, p80:966ms, p95:1.17s, 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:51 [2021-06-03T21:00:51.632Z]               └─TableFullScan_44	7500000.00	7500000	cop[tikv]	table:customer	tikv_task:{proc max:1.06s, min:397ms, p80:883ms, p95:1.06s, iters:7404, tasks:18}	keep order:false	N/A	N/A
21:00:51 [2021-06-03T21:00:51.632Z] 
21:00:51 [2021-06-03T21:00:51.632Z] + tiup cluster stop benchbot
21:00:51 [2021-06-03T21:00:51.632Z] Starting component `cluster`: /home/tidb/.tiup/components/cluster/v1.4.4/tiup-cluster stop benchbot
21:00:51 [2021-06-03T21:00:51.632Z] + [ Serial ] - SSHKeySet: privateKey=/home/tidb/.tiup/storage/cluster/clusters/benchbot/ssh/id_rsa, publicKey=/home/tidb/.tiup/storage/cluster/clusters/benchbot/ssh/id_rsa.pub
21:00:51 [2021-06-03T21:00:51.632Z] + [Parallel] - UserSSH: user=tidb, host=172.16.5.86
21:00:51 [2021-06-03T21:00:51.632Z] + [Parallel] - UserSSH: user=tidb, host=172.16.5.86
21:00:51 [2021-06-03T21:00:51.632Z] + [Parallel] - UserSSH: user=tidb, host=172.16.5.86
21:00:51 [2021-06-03T21:00:51.632Z] + [Parallel] - UserSSH: user=tidb, host=172.16.5.86
21:00:51 [2021-06-03T21:00:51.632Z] + [Parallel] - UserSSH: user=tidb, host=172.16.5.86
21:00:51 [2021-06-03T21:00:51.632Z] + [ Serial ] - StopCluster
21:00:51 [2021-06-03T21:00:51.632Z] Stopping component grafana
21:00:51 [2021-06-03T21:00:51.632Z] 	Stopping instance 172.16.5.86
21:00:51 [2021-06-03T21:00:51.632Z] 	Stop grafana 172.16.5.86:3000 success
21:00:51 [2021-06-03T21:00:51.632Z] Stopping component prometheus
21:00:51 [2021-06-03T21:00:51.632Z] 	Stopping instance 172.16.5.86
21:00:51 [2021-06-03T21:00:51.632Z] 	Stop prometheus 172.16.5.86:9090 success
21:00:51 [2021-06-03T21:00:51.632Z] Stopping component tidb
21:00:51 [2021-06-03T21:00:51.632Z] 	Stopping instance 172.16.5.86
21:00:54 [2021-06-03T21:00:54.145Z] 	Stop tidb 172.16.5.86:4000 success
21:00:54 [2021-06-03T21:00:54.145Z] Stopping component tikv
21:00:54 [2021-06-03T21:00:54.145Z] 	Stopping instance 172.16.5.86
21:00:58 [2021-06-03T21:00:58.312Z] 	Stop tikv 172.16.5.86:20160 success
21:00:58 [2021-06-03T21:00:58.312Z] Stopping component pd
21:00:58 [2021-06-03T21:00:58.312Z] 	Stopping instance 172.16.5.86
21:00:58 [2021-06-03T21:00:58.312Z] 	Stop pd 172.16.5.86:2379 success
21:00:58 [2021-06-03T21:00:58.312Z] Stopping component node_exporter
21:00:58 [2021-06-03T21:00:58.312Z] Stopping component blackbox_exporter
21:00:58 [2021-06-03T21:00:58.312Z] Stopped cluster `benchbot` successfully
21:00:58 [2021-06-03T21:00:58.576Z] [Pipeline] sh
21:00:58 [2021-06-03T21:00:58.853Z] + cat bench_result
21:00:58 [2021-06-03T21:00:58.859Z] [Pipeline] }
21:00:58 [2021-06-03T21:00:58.862Z] [Pipeline] // dir
21:00:58 [2021-06-03T21:00:58.864Z] [Pipeline] }
21:00:58 [2021-06-03T21:00:58.866Z] [Pipeline] // stage
21:00:58 [2021-06-03T21:00:58.868Z] [Pipeline] }
21:00:58 [2021-06-03T21:00:58.873Z] [Pipeline] // node
21:00:58 [2021-06-03T21:00:58.877Z] [Pipeline] }
21:00:58 [2021-06-03T21:00:58.879Z] [Pipeline] // catchError
21:00:58 [2021-06-03T21:00:58.885Z] [Pipeline] stage
21:00:58 [2021-06-03T21:00:58.889Z] [Pipeline] { (Summary)
21:00:58 [2021-06-03T21:00:58.905Z] [Pipeline] slackSend
21:00:58 [2021-06-03T21:00:58.906Z] Slack Send Pipeline step running, values are - baseUrl: <empty>, teamDomain: pingcap, channel: #daily_bench, color: good, botUser: false, tokenCredentialId: slack-pingcap-token, iconEmoji <empty>, username <empty>
21:00:59 [2021-06-03T21:00:59.554Z] sh: line 1: 154528 Terminated              sleep 3
21:00:59 [2021-06-03T21:00:59.571Z] sh: line 1: 154571 Terminated              sleep 3
21:00:59 [2021-06-03T21:00:59.651Z] [Pipeline] }
21:00:59 [2021-06-03T21:00:59.653Z] [Pipeline] // stage
21:00:59 [2021-06-03T21:00:59.656Z] [Pipeline] End of Pipeline
21:00:59 [2021-06-03T21:00:59.677Z] Finished: SUCCESS