SuccessConsole Output

Skipping 1,193 KB.. Full Log
->tpch50.partsupp.ps_availqty, funcs:sum(tpch50.lineitem.l_quantity)->Column#44	194.5 MB	N/A
20:41:22 [2021-06-08T20:41:22.937Z]         └─HashJoin_59	9711455.06	634004	root		time:43.8s, loops:625, build_hash_table:{total:3.05s, fetch:2.82s, build:224.1ms}, probe:{concurrency:5, total:3m39.1s, max:43.8s, probe:15.1s, fetch:3m24s}	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:22 [2021-06-08T20:41:22.937Z]           ├─IndexHashJoin_67(Build)	321865.05	435528	root		time:3s, loops:429, inner:{total:3.77s, concurrency:5, task:12, construct:121.1ms, fetch:3.3s, build:28.1ms, join:340.1ms}	inner join, inner:IndexLookUp_64, outer key:tpch50.part.p_partkey, inner key:tpch50.partsupp.ps_partkey, equal cond:eq(tpch50.part.p_partkey, tpch50.partsupp.ps_partkey)	20.0 MB	N/A
20:41:22 [2021-06-08T20:41:22.937Z]           │ ├─TableReader_96(Build)	80007.93	108882	root		time:2.42s, loops:112, cop_task: {num: 20, max: 1.93s, min: 768.8ms, avg: 1.3s, p95: 1.93s, max_proc_keys: 686055, p95_proc_keys: 686055, tot_proc: 25.9s, tot_wait: 2ms, rpc_num: 20, rpc_time: 25.9s, copr_cache: disabled}	data:Selection_95	725.8 KB	N/A
20:41:22 [2021-06-08T20:41:22.937Z]           │ │ └─Selection_95	80007.93	108882	cop[tikv]		tikv_task:{proc max:1.9s, min:764ms, p80:1.45s, p95:1.9s, 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:22 [2021-06-08T20:41:22.937Z]           │ │   └─TableFullScan_94	10000000.00	10000000	cop[tikv]	table:part	tikv_task:{proc max:1.76s, min:718ms, p80:1.35s, p95:1.76s, iters:9859, tasks:20}	keep order:false	N/A	N/A
20:41:22 [2021-06-08T20:41:22.937Z]           │ └─IndexLookUp_64(Probe)	4.02	435528	root		time:3.18s, loops:447, index_task: {total_time: 2.02s, fetch_handle: 2.02s, build: 101.8µs, wait: 286.2µs}, table_task: {total_time: 12.3s, num: 55, concurrency: 60}		20.7 KB	N/A
20:41:22 [2021-06-08T20:41:22.937Z]           │   ├─IndexRangeScan_62(Build)	4.02	435528	cop[tikv]	table:partsupp, index:PRIMARY(PS_PARTKEY, PS_SUPPKEY)	time:1.97s, loops:477, cop_task: {num: 60, max: 403.5ms, min: 6.66ms, avg: 135.9ms, p95: 317.3ms, max_proc_keys: 15288, p95_proc_keys: 15008, tot_proc: 7.69s, tot_wait: 53ms, rpc_num: 60, rpc_time: 8.15s, copr_cache: disabled}, tikv_task:{proc max:393ms, min:4ms, p80:212ms, p95:308ms, iters:696, 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:22 [2021-06-08T20:41:22.937Z]           │   └─TableRowIDScan_63(Probe)	4.02	435528	cop[tikv]	table:partsupp	time:3.99s, loops:504, cop_task: {num: 1469, max: 91.4ms, min: 1.53ms, avg: 26.3ms, p95: 58.7ms, max_proc_keys: 936, p95_proc_keys: 520, tot_proc: 29s, tot_wait: 7s, rpc_num: 1469, rpc_time: 38.7s, copr_cache: disabled}, tikv_task:{proc max:70ms, min:0s, p80:24ms, p95:35ms, iters:5403, tasks:1469}, scan_detail: {total_process_keys: 435528, total_keys: 473502, rocksdb: {delete_skipped_count: 0, key_skipped_count: 194038, block: {cache_hit_count: 3644418, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:41:22 [2021-06-08T20:41:22.937Z]           └─TableReader_101(Probe)	46310896.67	45504356	root		time:38.7s, loops:44289, cop_task: {num: 761, max: 1.39s, min: 378.5ms, avg: 813.6ms, p95: 1.1s, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 10m15.7s, tot_wait: 158ms, rpc_num: 761, rpc_time: 10m19.1s, copr_cache: disabled}	data:Selection_100	52.6 MB	N/A
20:41:22 [2021-06-08T20:41:22.937Z]             └─Selection_100	46310896.67	45504356	cop[tikv]		tikv_task:{proc max:1.32s, min:365ms, p80:876ms, p95:1.07s, 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:22 [2021-06-08T20:41:22.937Z]               └─TableFullScan_99	300005811.00	300005811	cop[tikv]	table:lineitem	tikv_task:{proc max:1.27s, min:350ms, p80:841ms, p95:1.04s, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:41:22 [2021-06-08T20:41:22.937Z] + sync
20:41:22 [2021-06-08T20:41:22.937Z] + /usr/bin/echo 3
20:42:09 [2021-06-08T20:42:09.561Z] + sync
20:42:09 [2021-06-08T20:42:09.561Z] + /usr/bin/echo 3
20:42:56 [2021-06-08T20:42:56.185Z] 
20:42:56 [2021-06-08T20:42:56.185Z] queries/20.sql
20:42:56 [2021-06-08T20:42:56.185Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:42:56 [2021-06-08T20:42:56.185Z] Sort_30	20000.00	8982	root		time:43.3s, loops:10	tpch50.supplier.s_name	614.3 KB	0 Bytes
20:42:56 [2021-06-08T20:42:56.185Z] └─HashJoin_35	20000.00	8982	root		time:43.3s, loops:11, build_hash_table:{total:1.44s, fetch:1.43s, build:11.8ms}, probe:{concurrency:5, total:3m36.7s, max:43.3s, probe:47ms, fetch:3m36.6s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.partsupp.ps_suppkey)]	1.54 MB	0 Bytes
20:42:56 [2021-06-08T20:42:56.185Z]   ├─HashJoin_48(Build)	20000.00	19972	root		time:1.43s, loops:24, build_hash_table:{total:310.5µs, fetch:301µs, build:9.56µs}, probe:{concurrency:5, total:7.19s, max:1.44s, probe:116.9ms, fetch:7.07s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:42:56 [2021-06-08T20:42:56.185Z]   │ ├─TableReader_53(Build)	1.00	1	root		time:99.4µs, loops:2, cop_task: {num: 1, max: 1.11ms, proc_keys: 25, rpc_num: 1, rpc_time: 1.09ms, copr_cache: disabled}	data:Selection_52	236 Bytes	N/A
20:42:56 [2021-06-08T20:42:56.185Z]   │ │ └─Selection_52	1.00	1	cop[tikv]		tikv_task:{time:0s, loops:1}, scan_detail: {total_process_keys: 25, total_keys: 26, rocksdb: {delete_skipped_count: 0, key_skipped_count: 46, block: {cache_hit_count: 18, read_count: 0, read_byte: 0 Bytes}}}	eq(tpch50.nation.n_name, "ALGERIA")	N/A	N/A
20:42:56 [2021-06-08T20:42:56.185Z]   │ │   └─TableFullScan_51	25.00	25	cop[tikv]	table:nation	tikv_task:{time:0s, loops:1}	keep order:false	N/A	N/A
20:42:56 [2021-06-08T20:42:56.185Z]   │ └─TableReader_50(Probe)	500000.00	500000	root		time:1.41s, loops:490, cop_task: {num: 1, max: 1.41s, proc_keys: 500000, tot_proc: 1.34s, rpc_num: 1, rpc_time: 1.41s, copr_cache: disabled}	data:TableFullScan_49	35.8 MB	N/A
20:42:56 [2021-06-08T20:42:56.185Z]   │   └─TableFullScan_49	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:1.18s, loops:493}, scan_detail: {total_process_keys: 500000, total_keys: 500001, rocksdb: {delete_skipped_count: 0, key_skipped_count: 999999, block: {cache_hit_count: 1692, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:42:56 [2021-06-08T20:42:56.185Z]   └─HashAgg_54(Probe)	257492.04	223999	root		time:43.3s, loops:222, partial_worker:{wall_time:43.231247118s, concurrency:5, task_num:289, tot_wait:3m35.882960956s, tot_exec:208.562829ms, tot_time:3m36.135403748s, max:43.231193252s, p95:43.231193252s}, final_worker:{wall_time:43.332941793s, concurrency:5, task_num:25, tot_wait:3m36.115745768s, tot_exec:543.32493ms, tot_time:3m36.659088341s, max:43.332925156s, p95:43.332925156s}	group by:tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_suppkey)->tpch50.partsupp.ps_suppkey	61.4 MB	N/A
20:42:56 [2021-06-08T20:42:56.185Z]     └─Selection_55	257492.04	295898	root		time:43.2s, loops:290	gt(cast(tpch50.partsupp.ps_availqty, decimal(20,0) BINARY), mul(0.5, Column#44))	59.2 KB	N/A
20:42:56 [2021-06-08T20:42:56.185Z]       └─HashAgg_56	321865.05	435528	root		time:43.1s, loops:430, partial_worker:{wall_time:42.861844521s, concurrency:5, task_num:624, tot_wait:3m33.081035822s, tot_exec:1.092890462s, tot_time:3m34.28813948s, max:42.861823241s, p95:42.861823241s}, final_worker:{wall_time:43.2155581s, concurrency:5, task_num:25, tot_wait:3m34.273929634s, tot_exec:1.787062151s, tot_time:3m36.061007759s, max:43.21554207s, p95:43.21554207s}	group by:tpch50.partsupp.ps_partkey, tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_suppkey)->tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_availqty)->tpch50.partsupp.ps_availqty, funcs:sum(tpch50.lineitem.l_quantity)->Column#44	194.5 MB	N/A
20:42:56 [2021-06-08T20:42:56.185Z]         └─HashJoin_59	9711455.06	634004	root		time:42.8s, loops:625, build_hash_table:{total:2.71s, fetch:2.51s, build:202.1ms}, probe:{concurrency:5, total:3m33.9s, max:42.8s, probe:15.2s, fetch:3m18.8s}	left outer join, equal:[eq(tpch50.partsupp.ps_partkey, tpch50.lineitem.l_partkey) eq(tpch50.partsupp.ps_suppkey, tpch50.lineitem.l_suppkey)]	10.4 MB	0 Bytes
20:42:56 [2021-06-08T20:42:56.185Z]           ├─IndexHashJoin_67(Build)	321865.05	435528	root		time:2.67s, loops:430, inner:{total:2.78s, concurrency:5, task:12, construct:120ms, fetch:2.33s, build:30.1ms, join:331.5ms}	inner join, inner:IndexLookUp_64, outer key:tpch50.part.p_partkey, inner key:tpch50.partsupp.ps_partkey, equal cond:eq(tpch50.part.p_partkey, tpch50.partsupp.ps_partkey)	19.9 MB	N/A
20:42:56 [2021-06-08T20:42:56.185Z]           │ ├─TableReader_96(Build)	80007.93	108882	root		time:2.28s, loops:112, cop_task: {num: 20, max: 1.54s, min: 580.1ms, avg: 1.17s, p95: 1.54s, max_proc_keys: 686055, p95_proc_keys: 686055, tot_proc: 23.3s, tot_wait: 8ms, rpc_num: 20, rpc_time: 23.4s, copr_cache: disabled}	data:Selection_95	680.6 KB	N/A
20:42:56 [2021-06-08T20:42:56.185Z]           │ │ └─Selection_95	80007.93	108882	cop[tikv]		tikv_task:{proc max:1.51s, min:577ms, p80:1.43s, 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:42:56 [2021-06-08T20:42:56.185Z]           │ │   └─TableFullScan_94	10000000.00	10000000	cop[tikv]	table:part	tikv_task:{proc max:1.43s, min:538ms, p80:1.33s, p95:1.43s, iters:9859, tasks:20}	keep order:false	N/A	N/A
20:42:56 [2021-06-08T20:42:56.185Z]           │ └─IndexLookUp_64(Probe)	4.02	435528	root		time:2.24s, loops:447, index_task: {total_time: 1.29s, fetch_handle: 1.29s, build: 101.3µs, wait: 264.4µs}, table_task: {total_time: 8.89s, num: 56, concurrency: 60}		20.5 KB	N/A
20:42:56 [2021-06-08T20:42:56.185Z]           │   ├─IndexRangeScan_62(Build)	4.02	435528	cop[tikv]	table:partsupp, index:PRIMARY(PS_PARTKEY, PS_SUPPKEY)	time:1.25s, loops:479, cop_task: {num: 57, max: 210ms, min: 4.83ms, avg: 101ms, p95: 199.6ms, max_proc_keys: 15288, p95_proc_keys: 15008, tot_proc: 5.41s, tot_wait: 45ms, rpc_num: 57, rpc_time: 5.75s, copr_cache: disabled}, tikv_task:{proc max:205ms, min:4ms, p80:155ms, p95:187ms, iters:685, tasks:57}, scan_detail: {total_process_keys: 435528, total_keys: 544410, rocksdb: {delete_skipped_count: 0, key_skipped_count: 435528, block: {cache_hit_count: 980292, read_count: 0, read_byte: 0 Bytes}}}	range: decided by [eq(tpch50.partsupp.ps_partkey, tpch50.part.p_partkey)], keep order:false	N/A	N/A
20:42:56 [2021-06-08T20:42:56.185Z]           │   └─TableRowIDScan_63(Probe)	4.02	435528	cop[tikv]	table:partsupp	time:3.25s, loops:502, cop_task: {num: 1358, max: 120ms, min: 903.5µs, avg: 24.4ms, p95: 50.5ms, max_proc_keys: 964, p95_proc_keys: 644, tot_proc: 25s, tot_wait: 6.07s, rpc_num: 1358, rpc_time: 33.1s, copr_cache: disabled}, tikv_task:{proc max:63ms, min:0s, p80:23ms, p95:35ms, iters:5118, tasks:1358}, scan_detail: {total_process_keys: 435528, total_keys: 473524, rocksdb: {delete_skipped_count: 0, key_skipped_count: 194138, block: {cache_hit_count: 3643744, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:42:56 [2021-06-08T20:42:56.185Z]           └─TableReader_101(Probe)	46310896.67	45504356	root		time:38s, loops:44289, cop_task: {num: 761, max: 1.28s, min: 338.9ms, avg: 797.4ms, p95: 1.07s, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 10m3.4s, tot_wait: 129ms, rpc_num: 761, rpc_time: 10m6.8s, copr_cache: disabled}	data:Selection_100	52.6 MB	N/A
20:42:56 [2021-06-08T20:42:56.185Z]             └─Selection_100	46310896.67	45504356	cop[tikv]		tikv_task:{proc max:1.24s, min:330ms, p80:865ms, p95:1.05s, iters:296606, tasks:761}, scan_detail: {total_process_keys: 300005811, total_keys: 300006572, rocksdb: {delete_skipped_count: 0, key_skipped_count: 600010861, block: {cache_hit_count: 1124648, read_count: 0, read_byte: 0 Bytes}}}	ge(tpch50.lineitem.l_shipdate, 1993-01-01 00:00:00.000000), lt(tpch50.lineitem.l_shipdate, 1994-01-01)	N/A	N/A
20:42:56 [2021-06-08T20:42:56.185Z]               └─TableFullScan_99	300005811.00	300005811	cop[tikv]	table:lineitem	tikv_task:{proc max:1.21s, min:319ms, p80:830ms, p95:1.01s, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:42:56 [2021-06-08T20:42:56.185Z] 
20:42:56 [2021-06-08T20:42:56.185Z] queries/20.sql
20:42:56 [2021-06-08T20:42:56.185Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:42:56 [2021-06-08T20:42:56.185Z] Sort_30	20000.00	8982	root		time:38.7s, loops:10	tpch50.supplier.s_name	614.3 KB	0 Bytes
20:42:56 [2021-06-08T20:42:56.185Z] └─HashJoin_35	20000.00	8982	root		time:38.7s, loops:11, build_hash_table:{total:1.46s, fetch:1.45s, build:9.8ms}, probe:{concurrency:5, total:3m13.7s, max:38.7s, probe:49.8ms, fetch:3m13.6s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.partsupp.ps_suppkey)]	1.49 MB	0 Bytes
20:42:56 [2021-06-08T20:42:56.185Z]   ├─HashJoin_48(Build)	20000.00	19972	root		time:1.46s, loops:23, build_hash_table:{total:139.2µs, fetch:133.8µs, build:5.39µs}, probe:{concurrency:5, total:7.31s, max:1.46s, probe:93.4ms, fetch:7.22s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:42:56 [2021-06-08T20:42:56.185Z]   │ ├─TableReader_53(Build)	1.00	1	root		time:39µs, loops:2, cop_task: {num: 1, max: 1.01ms, proc_keys: 25, rpc_num: 1, rpc_time: 992.4µs, copr_cache: disabled}	data:Selection_52	236 Bytes	N/A
20:42:56 [2021-06-08T20:42:56.185Z]   │ │ └─Selection_52	1.00	1	cop[tikv]		tikv_task:{time:0s, loops:1}, scan_detail: {total_process_keys: 25, total_keys: 26, rocksdb: {delete_skipped_count: 0, key_skipped_count: 46, block: {cache_hit_count: 18, read_count: 0, read_byte: 0 Bytes}}}	eq(tpch50.nation.n_name, "ALGERIA")	N/A	N/A
20:42:56 [2021-06-08T20:42:56.185Z]   │ │   └─TableFullScan_51	25.00	25	cop[tikv]	table:nation	tikv_task:{time:0s, loops:1}	keep order:false	N/A	N/A
20:42:56 [2021-06-08T20:42:56.185Z]   │ └─TableReader_50(Probe)	500000.00	500000	root		time:1.44s, loops:490, cop_task: {num: 1, max: 1.44s, proc_keys: 500000, tot_proc: 1.38s, rpc_num: 1, rpc_time: 1.44s, copr_cache: disabled}	data:TableFullScan_49	35.8 MB	N/A
20:42:56 [2021-06-08T20:42:56.185Z]   │   └─TableFullScan_49	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:1.22s, loops:493}, scan_detail: {total_process_keys: 500000, total_keys: 500001, rocksdb: {delete_skipped_count: 0, key_skipped_count: 999999, block: {cache_hit_count: 1692, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:42:56 [2021-06-08T20:42:56.185Z]   └─HashAgg_54(Probe)	257492.04	223999	root		time:38.7s, loops:222, partial_worker:{wall_time:38.675574058s, concurrency:5, task_num:289, tot_wait:3m13.121080339s, tot_exec:212.105079ms, tot_time:3m13.372016349s, max:38.675428806s, p95:38.675428806s}, final_worker:{wall_time:38.739603372s, concurrency:5, task_num:25, tot_wait:3m13.361147277s, tot_exec:325.629191ms, tot_time:3m13.686791605s, max:38.739562174s, p95:38.739562174s}	group by:tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_suppkey)->tpch50.partsupp.ps_suppkey	61.4 MB	N/A
20:42:56 [2021-06-08T20:42:56.185Z]     └─Selection_55	257492.04	295898	root		time:38.7s, loops:290	gt(cast(tpch50.partsupp.ps_availqty, decimal(20,0) BINARY), mul(0.5, Column#44))	59.2 KB	N/A
20:42:56 [2021-06-08T20:42:56.185Z]       └─HashAgg_56	321865.05	435528	root		time:38.6s, loops:430, partial_worker:{wall_time:38.314669714s, concurrency:5, task_num:625, tot_wait:3m10.270137921s, tot_exec:1.172626873s, tot_time:3m11.55485705s, max:38.314568059s, p95:38.314568059s}, final_worker:{wall_time:38.665489036s, concurrency:5, task_num:25, tot_wait:3m11.531120743s, tot_exec:1.730809414s, tot_time:3m13.261948578s, max:38.665423296s, p95:38.665423296s}	group by:tpch50.partsupp.ps_partkey, tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_suppkey)->tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_availqty)->tpch50.partsupp.ps_availqty, funcs:sum(tpch50.lineitem.l_quantity)->Column#44	194.5 MB	N/A
20:42:56 [2021-06-08T20:42:56.185Z]         └─HashJoin_59	9711455.06	634004	root		time:38.2s, loops:626, build_hash_table:{total:2.65s, fetch:2.45s, build:205.5ms}, probe:{concurrency:5, total:3m11.1s, max:38.2s, probe:14.9s, fetch:2m56.2s}	left outer join, equal:[eq(tpch50.partsupp.ps_partkey, tpch50.lineitem.l_partkey) eq(tpch50.partsupp.ps_suppkey, tpch50.lineitem.l_suppkey)]	10.4 MB	0 Bytes
20:42:56 [2021-06-08T20:42:56.185Z]           ├─IndexHashJoin_67(Build)	321865.05	435528	root		time:2.6s, loops:429, inner:{total:3.07s, concurrency:5, task:12, construct:153.6ms, fetch:2.6s, build:29.2ms, join:315.5ms}	inner join, inner:IndexLookUp_64, outer key:tpch50.part.p_partkey, inner key:tpch50.partsupp.ps_partkey, equal cond:eq(tpch50.part.p_partkey, tpch50.partsupp.ps_partkey)	20.0 MB	N/A
20:42:56 [2021-06-08T20:42:56.185Z]           │ ├─TableReader_96(Build)	80007.93	108882	root		time:2.26s, loops:112, cop_task: {num: 20, max: 1.6s, min: 632.4ms, avg: 1.17s, p95: 1.6s, max_proc_keys: 686055, p95_proc_keys: 686055, tot_proc: 23.3s, tot_wait: 11ms, rpc_num: 20, rpc_time: 23.4s, copr_cache: disabled}	data:Selection_95	680.6 KB	N/A
20:42:56 [2021-06-08T20:42:56.185Z]           │ │ └─Selection_95	80007.93	108882	cop[tikv]		tikv_task:{proc max:1.58s, min:627ms, p80:1.43s, p95:1.58s, iters:9859, tasks:20}, scan_detail: {total_process_keys: 10000000, total_keys: 10000020, rocksdb: {delete_skipped_count: 0, key_skipped_count: 19999980, block: {cache_hit_count: 31499, read_count: 0, read_byte: 0 Bytes}}}	like(tpch50.part.p_name, "green%", 92)	N/A	N/A
20:42:56 [2021-06-08T20:42:56.185Z]           │ │   └─TableFullScan_94	10000000.00	10000000	cop[tikv]	table:part	tikv_task:{proc max:1.48s, min:581ms, p80:1.34s, p95:1.48s, iters:9859, tasks:20}	keep order:false	N/A	N/A
20:42:56 [2021-06-08T20:42:56.185Z]           │ └─IndexLookUp_64(Probe)	4.02	435528	root		time:2.49s, loops:447, index_task: {total_time: 1.41s, fetch_handle: 1.41s, build: 93.7µs, wait: 272.4µs}, table_task: {total_time: 9.32s, num: 56, concurrency: 60}		20.6 KB	N/A
20:42:56 [2021-06-08T20:42:56.186Z]           │   ├─IndexRangeScan_62(Build)	4.02	435528	cop[tikv]	table:partsupp, index:PRIMARY(PS_PARTKEY, PS_SUPPKEY)	time:1.37s, loops:479, cop_task: {num: 60, max: 242.7ms, min: 3.44ms, avg: 98.5ms, p95: 236ms, max_proc_keys: 15048, p95_proc_keys: 14948, tot_proc: 5.28s, tot_wait: 83ms, rpc_num: 60, rpc_time: 5.91s, copr_cache: disabled}, tikv_task:{proc max:227ms, min:3ms, p80:143ms, p95:179ms, iters:696, tasks:60}, scan_detail: {total_process_keys: 435528, total_keys: 544410, rocksdb: {delete_skipped_count: 0, key_skipped_count: 435528, block: {cache_hit_count: 980292, read_count: 0, read_byte: 0 Bytes}}}	range: decided by [eq(tpch50.partsupp.ps_partkey, tpch50.part.p_partkey)], keep order:false	N/A	N/A
20:42:56 [2021-06-08T20:42:56.186Z]           │   └─TableRowIDScan_63(Probe)	4.02	435528	cop[tikv]	table:partsupp	time:3.13s, loops:503, cop_task: {num: 1362, max: 129.5ms, min: 747.5µs, avg: 21.7ms, p95: 53.1ms, max_proc_keys: 980, p95_proc_keys: 636, tot_proc: 21.6s, tot_wait: 5.71s, rpc_num: 1362, rpc_time: 29.5s, copr_cache: disabled}, tikv_task:{proc max:55ms, min:0s, p80:19ms, p95:28ms, iters:5117, tasks:1362}, scan_detail: {total_process_keys: 435528, total_keys: 473514, rocksdb: {delete_skipped_count: 0, key_skipped_count: 194102, block: {cache_hit_count: 3643677, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:42:56 [2021-06-08T20:42:56.186Z]           └─TableReader_101(Probe)	46310896.67	45504356	root		time:33.6s, loops:44289, cop_task: {num: 761, max: 1.19s, min: 392.6ms, avg: 710ms, p95: 864.6ms, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 8m57.2s, tot_wait: 129ms, rpc_num: 761, rpc_time: 9m0.3s, copr_cache: disabled}	data:Selection_100	52.6 MB	N/A
20:42:56 [2021-06-08T20:42:56.186Z]             └─Selection_100	46310896.67	45504356	cop[tikv]		tikv_task:{proc max:1.15s, min:384ms, p80:756ms, p95:846ms, iters:296606, tasks:761}, scan_detail: {total_process_keys: 300005811, total_keys: 300006572, rocksdb: {delete_skipped_count: 0, key_skipped_count: 600010861, block: {cache_hit_count: 1124648, read_count: 0, read_byte: 0 Bytes}}}	ge(tpch50.lineitem.l_shipdate, 1993-01-01 00:00:00.000000), lt(tpch50.lineitem.l_shipdate, 1994-01-01)	N/A	N/A
20:42:56 [2021-06-08T20:42:56.186Z]               └─TableFullScan_99	300005811.00	300005811	cop[tikv]	table:lineitem	tikv_task:{proc max:1.12s, min:368ms, p80:726ms, p95:820ms, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:42:56 [2021-06-08T20:42:56.186Z] + sync
20:42:56 [2021-06-08T20:42:56.186Z] + /usr/bin/echo 3
20:43:34 [2021-06-08T20:43:34.844Z] + sync
20:43:34 [2021-06-08T20:43:34.844Z] + /usr/bin/echo 3
20:44:13 [2021-06-08T20:44:13.641Z] 
20:44:13 [2021-06-08T20:44:13.641Z] queries/20.sql
20:44:13 [2021-06-08T20:44:13.641Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:44:13 [2021-06-08T20:44:13.641Z] Sort_30	20000.00	8982	root		time:38.6s, loops:10	tpch50.supplier.s_name	607.7 KB	0 Bytes
20:44:13 [2021-06-08T20:44:13.641Z] └─HashJoin_35	20000.00	8982	root		time:38.6s, loops:11, build_hash_table:{total:1.16s, fetch:1.15s, build:9.4ms}, probe:{concurrency:5, total:3m13.1s, max:38.6s, probe:46.6ms, fetch:3m13s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.partsupp.ps_suppkey)]	1.49 MB	0 Bytes
20:44:13 [2021-06-08T20:44:13.641Z]   ├─HashJoin_48(Build)	20000.00	19972	root		time:1.16s, loops:23, build_hash_table:{total:278.5µs, fetch:271.6µs, build:6.89µs}, probe:{concurrency:5, total:5.79s, max:1.16s, probe:111.3ms, fetch:5.68s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:44:13 [2021-06-08T20:44:13.641Z]   │ ├─TableReader_53(Build)	1.00	1	root		time:58.2µs, loops:2, cop_task: {num: 1, max: 1.03ms, proc_keys: 25, rpc_num: 1, rpc_time: 1.01ms, copr_cache: disabled}	data:Selection_52	236 Bytes	N/A
20:44:13 [2021-06-08T20:44:13.641Z]   │ │ └─Selection_52	1.00	1	cop[tikv]		tikv_task:{time:0s, loops:1}, scan_detail: {total_process_keys: 25, total_keys: 26, rocksdb: {delete_skipped_count: 0, key_skipped_count: 46, block: {cache_hit_count: 18, read_count: 0, read_byte: 0 Bytes}}}	eq(tpch50.nation.n_name, "ALGERIA")	N/A	N/A
20:44:13 [2021-06-08T20:44:13.641Z]   │ │   └─TableFullScan_51	25.00	25	cop[tikv]	table:nation	tikv_task:{time:0s, loops:1}	keep order:false	N/A	N/A
20:44:13 [2021-06-08T20:44:13.641Z]   │ └─TableReader_50(Probe)	500000.00	500000	root		time:1.14s, loops:490, cop_task: {num: 1, max: 1.14s, proc_keys: 500000, tot_proc: 1.07s, rpc_num: 1, rpc_time: 1.14s, copr_cache: disabled}	data:TableFullScan_49	35.8 MB	N/A
20:44:13 [2021-06-08T20:44:13.641Z]   │   └─TableFullScan_49	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:940ms, loops:493}, scan_detail: {total_process_keys: 500000, total_keys: 500001, rocksdb: {delete_skipped_count: 0, key_skipped_count: 999999, block: {cache_hit_count: 1692, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:44:13 [2021-06-08T20:44:13.641Z]   └─HashAgg_54(Probe)	257492.04	223999	root		time:38.6s, loops:222, partial_worker:{wall_time:38.49810788s, concurrency:5, task_num:289, tot_wait:3m12.249648105s, tot_exec:196.287831ms, tot_time:3m12.481848733s, max:38.497630925s, p95:38.497630925s}, final_worker:{wall_time:38.614542056s, concurrency:5, task_num:25, tot_wait:3m12.473156951s, tot_exec:574.250975ms, tot_time:3m13.047422644s, max:38.614064898s, p95:38.614064898s}	group by:tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_suppkey)->tpch50.partsupp.ps_suppkey	61.4 MB	N/A
20:44:13 [2021-06-08T20:44:13.641Z]     └─Selection_55	257492.04	295898	root		time:38.5s, loops:290	gt(cast(tpch50.partsupp.ps_availqty, decimal(20,0) BINARY), mul(0.5, Column#44))	59.2 KB	N/A
20:44:13 [2021-06-08T20:44:13.641Z]       └─HashAgg_56	321865.05	435528	root		time:38.4s, loops:430, partial_worker:{wall_time:38.142394087s, concurrency:5, task_num:625, tot_wait:3m9.534803367s, tot_exec:1.060327954s, tot_time:3m10.708077073s, max:38.142263555s, p95:38.142263555s}, final_worker:{wall_time:38.48704905s, concurrency:5, task_num:25, tot_wait:3m10.705387118s, tot_exec:1.712504533s, tot_time:3m12.417906949s, max:38.486886515s, p95:38.486886515s}	group by:tpch50.partsupp.ps_partkey, tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_suppkey)->tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_availqty)->tpch50.partsupp.ps_availqty, funcs:sum(tpch50.lineitem.l_quantity)->Column#44	194.5 MB	N/A
20:44:13 [2021-06-08T20:44:13.641Z]         └─HashJoin_59	9711455.06	634004	root		time:38.1s, loops:626, build_hash_table:{total:2.52s, fetch:2.33s, build:190.4ms}, probe:{concurrency:5, total:3m10.4s, max:38.1s, probe:15.1s, fetch:2m55.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:44:13 [2021-06-08T20:44:13.641Z]           ├─IndexHashJoin_67(Build)	321865.05	435528	root		time:2.49s, loops:430, inner:{total:2.55s, concurrency:5, task:12, construct:107.6ms, fetch:2.13s, build:27ms, join:309.6ms}	inner join, inner:IndexLookUp_64, outer key:tpch50.part.p_partkey, inner key:tpch50.partsupp.ps_partkey, equal cond:eq(tpch50.part.p_partkey, tpch50.partsupp.ps_partkey)	19.9 MB	N/A
20:44:13 [2021-06-08T20:44:13.641Z]           │ ├─TableReader_96(Build)	80007.93	108882	root		time:2.11s, loops:112, cop_task: {num: 20, max: 1.5s, min: 645ms, avg: 1.04s, p95: 1.5s, max_proc_keys: 686055, p95_proc_keys: 686055, tot_proc: 20.8s, tot_wait: 13ms, rpc_num: 20, rpc_time: 20.8s, copr_cache: disabled}	data:Selection_95	725.8 KB	N/A
20:44:13 [2021-06-08T20:44:13.641Z]           │ │ └─Selection_95	80007.93	108882	cop[tikv]		tikv_task:{proc max:1.46s, min:637ms, p80:1.22s, 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:44:13 [2021-06-08T20:44:13.641Z]           │ │   └─TableFullScan_94	10000000.00	10000000	cop[tikv]	table:part	tikv_task:{proc max:1.38s, min:584ms, p80:1.14s, p95:1.38s, iters:9859, tasks:20}	keep order:false	N/A	N/A
20:44:13 [2021-06-08T20:44:13.641Z]           │ └─IndexLookUp_64(Probe)	4.02	435528	root		time:2.03s, loops:447, index_task: {total_time: 1.31s, fetch_handle: 1.31s, build: 94.7µs, wait: 305.2µs}, table_task: {total_time: 8.07s, num: 55, concurrency: 60}		20.7 KB	N/A
20:44:13 [2021-06-08T20:44:13.641Z]           │   ├─IndexRangeScan_62(Build)	4.02	435528	cop[tikv]	table:partsupp, index:PRIMARY(PS_PARTKEY, PS_SUPPKEY)	time:1.27s, loops:480, cop_task: {num: 59, max: 236.2ms, min: 4.35ms, avg: 92.7ms, p95: 225.7ms, max_proc_keys: 15288, p95_proc_keys: 14960, tot_proc: 5.04s, tot_wait: 132ms, rpc_num: 59, rpc_time: 5.47s, copr_cache: disabled}, tikv_task:{proc max:229ms, min:3ms, p80:141ms, p95:206ms, iters:693, tasks:59}, scan_detail: {total_process_keys: 435528, total_keys: 544410, rocksdb: {delete_skipped_count: 0, key_skipped_count: 435528, block: {cache_hit_count: 980292, read_count: 0, read_byte: 0 Bytes}}}	range: decided by [eq(tpch50.partsupp.ps_partkey, tpch50.part.p_partkey)], keep order:false	N/A	N/A
20:44:13 [2021-06-08T20:44:13.641Z]           │   └─TableRowIDScan_63(Probe)	4.02	435528	cop[tikv]	table:partsupp	time:2.54s, loops:502, cop_task: {num: 1422, max: 94.9ms, min: 547.3µs, avg: 17.5ms, p95: 33.9ms, max_proc_keys: 976, p95_proc_keys: 600, tot_proc: 18.6s, tot_wait: 4.06s, rpc_num: 1422, rpc_time: 24.9s, copr_cache: disabled}, tikv_task:{proc max:48ms, min:0s, p80:17ms, p95:24ms, iters:5282, tasks:1422}, scan_detail: {total_process_keys: 435528, total_keys: 473508, rocksdb: {delete_skipped_count: 0, key_skipped_count: 194066, block: {cache_hit_count: 3644200, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:44:13 [2021-06-08T20:44:13.641Z]           └─TableReader_101(Probe)	46310896.67	45504356	root		time:33.5s, loops:44289, cop_task: {num: 761, max: 1.15s, min: 338.2ms, avg: 707.8ms, p95: 852.5ms, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 8m55.4s, tot_wait: 127ms, rpc_num: 761, rpc_time: 8m58.7s, copr_cache: disabled}	data:Selection_100	52.6 MB	N/A
20:44:13 [2021-06-08T20:44:13.641Z]             └─Selection_100	46310896.67	45504356	cop[tikv]		tikv_task:{proc max:1.11s, min:330ms, p80:753ms, p95:835ms, iters:296606, tasks:761}, scan_detail: {total_process_keys: 300005811, total_keys: 300006572, rocksdb: {delete_skipped_count: 0, key_skipped_count: 600010861, block: {cache_hit_count: 1124648, read_count: 0, read_byte: 0 Bytes}}}	ge(tpch50.lineitem.l_shipdate, 1993-01-01 00:00:00.000000), lt(tpch50.lineitem.l_shipdate, 1994-01-01)	N/A	N/A
20:44:13 [2021-06-08T20:44:13.641Z]               └─TableFullScan_99	300005811.00	300005811	cop[tikv]	table:lineitem	tikv_task:{proc max:1.08s, min:321ms, p80:723ms, p95:806ms, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:44:13 [2021-06-08T20:44:13.641Z] 
20:44:13 [2021-06-08T20:44:13.641Z] queries/20.sql
20:44:13 [2021-06-08T20:44:13.641Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:44:13 [2021-06-08T20:44:13.641Z] Sort_30	20000.00	8982	root		time:38.2s, loops:10	tpch50.supplier.s_name	607.7 KB	0 Bytes
20:44:13 [2021-06-08T20:44:13.641Z] └─HashJoin_35	20000.00	8982	root		time:38.2s, loops:11, build_hash_table:{total:1.4s, fetch:1.39s, build:10.6ms}, probe:{concurrency:5, total:3m10.9s, max:38.2s, probe:52.7ms, fetch:3m10.9s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.partsupp.ps_suppkey)]	1.54 MB	0 Bytes
20:44:13 [2021-06-08T20:44:13.641Z]   ├─HashJoin_48(Build)	20000.00	19972	root		time:1.4s, loops:24, build_hash_table:{total:132.4µs, fetch:125.9µs, build:6.44µs}, probe:{concurrency:5, total:7.01s, max:1.4s, probe:99.3ms, fetch:6.91s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:44:13 [2021-06-08T20:44:13.641Z]   │ ├─TableReader_53(Build)	1.00	1	root		time:31.5µs, loops:2, cop_task: {num: 1, max: 939.9µs, proc_keys: 25, rpc_num: 1, rpc_time: 903.7µs, copr_cache: disabled}	data:Selection_52	236 Bytes	N/A
20:44:13 [2021-06-08T20:44:13.642Z]   │ │ └─Selection_52	1.00	1	cop[tikv]		tikv_task:{time:0s, loops:1}, scan_detail: {total_process_keys: 25, total_keys: 26, rocksdb: {delete_skipped_count: 0, key_skipped_count: 46, block: {cache_hit_count: 18, read_count: 0, read_byte: 0 Bytes}}}	eq(tpch50.nation.n_name, "ALGERIA")	N/A	N/A
20:44:13 [2021-06-08T20:44:13.642Z]   │ │   └─TableFullScan_51	25.00	25	cop[tikv]	table:nation	tikv_task:{time:0s, loops:1}	keep order:false	N/A	N/A
20:44:13 [2021-06-08T20:44:13.642Z]   │ └─TableReader_50(Probe)	500000.00	500000	root		time:1.38s, loops:490, cop_task: {num: 1, max: 1.38s, proc_keys: 500000, tot_proc: 1.3s, rpc_num: 1, rpc_time: 1.38s, copr_cache: disabled}	data:TableFullScan_49	35.8 MB	N/A
20:44:13 [2021-06-08T20:44:13.642Z]   │   └─TableFullScan_49	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:1.15s, loops:493}, scan_detail: {total_process_keys: 500000, total_keys: 500001, rocksdb: {delete_skipped_count: 0, key_skipped_count: 999999, block: {cache_hit_count: 1692, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:44:13 [2021-06-08T20:44:13.642Z]   └─HashAgg_54(Probe)	257492.04	223999	root		time:38.2s, loops:222, partial_worker:{wall_time:38.113262026s, concurrency:5, task_num:289, tot_wait:3m10.119465613s, tot_exec:236.753134ms, tot_time:3m10.504295222s, max:38.112999669s, p95:38.112999669s}, final_worker:{wall_time:38.182403633s, concurrency:5, task_num:25, tot_wait:3m10.483930919s, tot_exec:400.977012ms, tot_time:3m10.884922875s, max:38.182147854s, p95:38.182147854s}	group by:tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_suppkey)->tpch50.partsupp.ps_suppkey	61.4 MB	N/A
20:44:13 [2021-06-08T20:44:13.642Z]     └─Selection_55	257492.04	295898	root		time:38.1s, loops:290	gt(cast(tpch50.partsupp.ps_availqty, decimal(20,0) BINARY), mul(0.5, Column#44))	59.2 KB	N/A
20:44:13 [2021-06-08T20:44:13.642Z]       └─HashAgg_56	321865.05	435528	root		time:38s, loops:430, partial_worker:{wall_time:37.729092272s, concurrency:5, task_num:625, tot_wait:3m7.358650653s, tot_exec:1.114308804s, tot_time:3m8.6054564s, max:37.728986395s, p95:37.728986395s}, final_worker:{wall_time:38.063461601s, concurrency:5, task_num:25, tot_wait:3m8.581058283s, tot_exec:1.680495329s, tot_time:3m10.261573805s, max:38.06335562s, p95:38.06335562s}	group by:tpch50.partsupp.ps_partkey, tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_suppkey)->tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_availqty)->tpch50.partsupp.ps_availqty, funcs:sum(tpch50.lineitem.l_quantity)->Column#44	194.5 MB	N/A
20:44:13 [2021-06-08T20:44:13.642Z]         └─HashJoin_59	9711455.06	634004	root		time:37.6s, loops:626, build_hash_table:{total:2.52s, fetch:2.32s, build:204.3ms}, probe:{concurrency:5, total:3m8.2s, max:37.6s, probe:15.2s, fetch:2m52.9s}	left outer join, equal:[eq(tpch50.partsupp.ps_partkey, tpch50.lineitem.l_partkey) eq(tpch50.partsupp.ps_suppkey, tpch50.lineitem.l_suppkey)]	10.4 MB	0 Bytes
20:44:13 [2021-06-08T20:44:13.642Z]           ├─IndexHashJoin_67(Build)	321865.05	435528	root		time:2.47s, loops:430, inner:{total:2.66s, concurrency:5, task:12, construct:113.8ms, fetch:2.23s, build:25.7ms, join:317.1ms}	inner join, inner:IndexLookUp_64, outer key:tpch50.part.p_partkey, inner key:tpch50.partsupp.ps_partkey, equal cond:eq(tpch50.part.p_partkey, tpch50.partsupp.ps_partkey)	19.9 MB	N/A
20:44:13 [2021-06-08T20:44:13.642Z]           │ ├─TableReader_96(Build)	80007.93	108882	root		time:2.14s, loops:112, cop_task: {num: 20, max: 1.43s, min: 650.5ms, avg: 1.08s, p95: 1.43s, max_proc_keys: 686055, p95_proc_keys: 686055, tot_proc: 21.5s, tot_wait: 23ms, rpc_num: 20, rpc_time: 21.5s, copr_cache: disabled}	data:Selection_95	725.8 KB	N/A
20:44:13 [2021-06-08T20:44:13.642Z]           │ │ └─Selection_95	80007.93	108882	cop[tikv]		tikv_task:{proc max:1.41s, min:645ms, p80:1.24s, p95:1.41s, iters:9859, tasks:20}, scan_detail: {total_process_keys: 10000000, total_keys: 10000020, rocksdb: {delete_skipped_count: 0, key_skipped_count: 19999980, block: {cache_hit_count: 31499, read_count: 0, read_byte: 0 Bytes}}}	like(tpch50.part.p_name, "green%", 92)	N/A	N/A
20:44:13 [2021-06-08T20:44:13.642Z]           │ │   └─TableFullScan_94	10000000.00	10000000	cop[tikv]	table:part	tikv_task:{proc max:1.31s, min:586ms, p80:1.16s, p95:1.31s, iters:9859, tasks:20}	keep order:false	N/A	N/A
20:44:13 [2021-06-08T20:44:13.642Z]           │ └─IndexLookUp_64(Probe)	4.02	435528	root		time:2.12s, loops:447, index_task: {total_time: 1.25s, fetch_handle: 1.25s, build: 96µs, wait: 297.1µs}, table_task: {total_time: 8.26s, num: 56, concurrency: 60}		20.7 KB	N/A
20:44:13 [2021-06-08T20:44:13.642Z]           │   ├─IndexRangeScan_62(Build)	4.02	435528	cop[tikv]	table:partsupp, index:PRIMARY(PS_PARTKEY, PS_SUPPKEY)	time:1.2s, loops:479, cop_task: {num: 58, max: 245.4ms, min: 5.78ms, avg: 90.9ms, p95: 190ms, max_proc_keys: 15288, p95_proc_keys: 14960, tot_proc: 4.92s, tot_wait: 40ms, rpc_num: 58, rpc_time: 5.27s, copr_cache: disabled}, tikv_task:{proc max:236ms, min:4ms, p80:140ms, p95:175ms, 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:44:13 [2021-06-08T20:44:13.642Z]           │   └─TableRowIDScan_63(Probe)	4.02	435528	cop[tikv]	table:partsupp	time:2.79s, loops:503, cop_task: {num: 1460, max: 98.5ms, min: 525.6µs, avg: 18.5ms, p95: 37.3ms, max_proc_keys: 1028, p95_proc_keys: 540, tot_proc: 18.6s, tot_wait: 5.1s, rpc_num: 1460, rpc_time: 27s, copr_cache: disabled}, tikv_task:{proc max:46ms, min:0s, p80:16ms, p95:23ms, iters:5390, tasks:1460}, scan_detail: {total_process_keys: 435528, total_keys: 473504, rocksdb: {delete_skipped_count: 0, key_skipped_count: 194078, block: {cache_hit_count: 3644362, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:44:13 [2021-06-08T20:44:13.642Z]           └─TableReader_101(Probe)	46310896.67	45504356	root		time:32.9s, loops:44289, cop_task: {num: 761, max: 1.2s, min: 286.6ms, avg: 700.5ms, p95: 849.1ms, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 8m49.9s, tot_wait: 137ms, rpc_num: 761, rpc_time: 8m53.1s, copr_cache: disabled}	data:Selection_100	52.6 MB	N/A
20:44:13 [2021-06-08T20:44:13.642Z]             └─Selection_100	46310896.67	45504356	cop[tikv]		tikv_task:{proc max:1.18s, min:277ms, p80:746ms, p95:826ms, iters:296606, tasks:761}, scan_detail: {total_process_keys: 300005811, total_keys: 300006572, rocksdb: {delete_skipped_count: 0, key_skipped_count: 600010861, block: {cache_hit_count: 1124648, read_count: 0, read_byte: 0 Bytes}}}	ge(tpch50.lineitem.l_shipdate, 1993-01-01 00:00:00.000000), lt(tpch50.lineitem.l_shipdate, 1994-01-01)	N/A	N/A
20:44:13 [2021-06-08T20:44:13.642Z]               └─TableFullScan_99	300005811.00	300005811	cop[tikv]	table:lineitem	tikv_task:{proc max:1.16s, min:267ms, p80:718ms, p95:795ms, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:44:13 [2021-06-08T20:44:13.642Z] + sync
20:44:13 [2021-06-08T20:44:13.642Z] + /usr/bin/echo 3
20:45:00 [2021-06-08T20:45:00.354Z] + tiup cluster stop benchbot -y
20:45:00 [2021-06-08T20:45:00.354Z] Starting component `cluster`: /home/tidb/.tiup/components/cluster/v1.4.4/tiup-cluster stop benchbot -y
20:45:10 [2021-06-08T20:45:10.290Z] + rm -rf '/data1/tidb-deploy/*/log/*'
20:45:10 [2021-06-08T20:45:10.290Z] + rm -rf /data1/jenkins/deploy/data/tikv-20160
20:45:12 [2021-06-08T20:45:12.177Z] + rm -rf /data1/jenkins/deploy/data/pd-2379
20:45:12 [2021-06-08T20:45:12.177Z] + rm -rf /data1/jenkins/restore_data/tpch50/data/last_tikv.toml
20:45:12 [2021-06-08T20:45:12.177Z] + cp -R /data1/jenkins/restore_data/tpch50/data /data1/jenkins/deploy/data/tikv-20160
20:47:03 [2021-06-08T20:47:03.545Z] + cp -R /data1/jenkins/restore_data/tpch50/data.pd /data1/jenkins/deploy/data/pd-2379
20:47:03 [2021-06-08T20:47:03.545Z] + '[' -n '' ']'
20:47:03 [2021-06-08T20:47:03.545Z] + tiup cluster start benchbot --wait-timeout=300
20:47:03 [2021-06-08T20:47:03.545Z] Starting component `cluster`: /home/tidb/.tiup/components/cluster/v1.4.4/tiup-cluster start benchbot --wait-timeout=300
20:47:25 [2021-06-08T20:47:25.430Z] + sync
20:47:25 [2021-06-08T20:47:25.430Z] + /usr/bin/echo 3
20:49:01 [2021-06-08T20:49:01.957Z] 
20:49:01 [2021-06-08T20:49:01.957Z] queries/20.sql
20:49:01 [2021-06-08T20:49:01.957Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:49:01 [2021-06-08T20:49:01.957Z] Sort_30	20000.00	8982	root		time:38.4s, loops:10	tpch50.supplier.s_name	614.3 KB	0 Bytes
20:49:01 [2021-06-08T20:49:01.957Z] └─HashJoin_35	20000.00	8982	root		time:38.4s, loops:11, build_hash_table:{total:1.28s, fetch:1.27s, build:8.85ms}, probe:{concurrency:5, total:3m12.2s, max:38.4s, probe:47.1ms, fetch:3m12.1s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.partsupp.ps_suppkey)]	1.51 MB	0 Bytes
20:49:01 [2021-06-08T20:49:01.957Z]   ├─HashJoin_48(Build)	20000.00	19972	root		time:1.27s, loops:23, build_hash_table:{total:216.4µs, fetch:210.3µs, build:6.16µs}, probe:{concurrency:5, total:6.37s, max:1.27s, probe:90.2ms, fetch:6.28s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:49:01 [2021-06-08T20:49:01.957Z]   │ ├─TableReader_53(Build)	1.00	1	root		time:55.8µs, loops:2, cop_task: {num: 1, max: 1.01ms, proc_keys: 25, tot_proc: 1ms, rpc_num: 1, rpc_time: 981.9µs, copr_cache: disabled}	data:Selection_52	244 Bytes	N/A
20:49:01 [2021-06-08T20:49:01.957Z]   │ │ └─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:49:01 [2021-06-08T20:49:01.957Z]   │ │   └─TableFullScan_51	25.00	25	cop[tikv]	table:nation	tikv_task:{time:1ms, loops:1}	keep order:false	N/A	N/A
20:49:01 [2021-06-08T20:49:01.957Z]   │ └─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:49:01 [2021-06-08T20:49:01.957Z]   │   └─TableFullScan_49	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:1.03s, loops:493}, scan_detail: {total_process_keys: 500000, total_keys: 500001, rocksdb: {delete_skipped_count: 0, key_skipped_count: 999999, block: {cache_hit_count: 1692, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:49:01 [2021-06-08T20:49:01.957Z]   └─HashAgg_54(Probe)	257492.04	223999	root		time:38.4s, loops:222, partial_worker:{wall_time:38.362895213s, concurrency:5, task_num:289, tot_wait:3m11.562959162s, tot_exec:199.517981ms, tot_time:3m11.803478472s, max:38.36244832s, p95:38.36244832s}, final_worker:{wall_time:38.436887245s, concurrency:5, task_num:25, tot_wait:3m11.79042996s, tot_exec:364.898389ms, tot_time:3m12.155342896s, max:38.436480392s, p95:38.436480392s}	group by:tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_suppkey)->tpch50.partsupp.ps_suppkey	61.4 MB	N/A
20:49:01 [2021-06-08T20:49:01.957Z]     └─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:49:01 [2021-06-08T20:49:01.957Z]       └─HashAgg_56	321865.05	435528	root		time:38.2s, loops:430, partial_worker:{wall_time:37.997950717s, concurrency:5, task_num:623, tot_wait:3m8.69280813s, tot_exec:1.162874821s, tot_time:3m9.971496319s, max:37.997819428s, p95:37.997819428s}, final_worker:{wall_time:38.349070942s, concurrency:5, task_num:25, tot_wait:3m9.930440041s, tot_exec:1.810201018s, tot_time:3m11.74065806s, max:38.348937015s, p95:38.348937015s}	group by:tpch50.partsupp.ps_partkey, tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_suppkey)->tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_availqty)->tpch50.partsupp.ps_availqty, funcs:sum(tpch50.lineitem.l_quantity)->Column#44	194.5 MB	N/A
20:49:01 [2021-06-08T20:49:01.957Z]         └─HashJoin_59	9711455.06	634004	root		time:37.9s, loops:624, build_hash_table:{total:2.36s, fetch:2.15s, build:206.7ms}, probe:{concurrency:5, total:3m9.5s, max:37.9s, probe:15s, fetch:2m54.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:49:01 [2021-06-08T20:49:01.957Z]           ├─IndexHashJoin_67(Build)	321865.05	435528	root		time:2.3s, loops:429, inner:{total:2.56s, concurrency:5, task:12, construct:134.7ms, fetch:2.11s, build:29.6ms, join:318.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)	19.9 MB	N/A
20:49:01 [2021-06-08T20:49:01.957Z]           │ ├─TableReader_96(Build)	80007.93	108882	root		time:1.99s, loops:112, cop_task: {num: 20, max: 1.52s, min: 550.6ms, avg: 1.09s, p95: 1.52s, 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	665.9 KB	N/A
20:49:01 [2021-06-08T20:49:01.957Z]           │ │ └─Selection_95	80007.93	108882	cop[tikv]		tikv_task:{proc max:1.5s, min:548ms, p80:1.36s, 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:49:01 [2021-06-08T20:49:01.957Z]           │ │   └─TableFullScan_94	10000000.00	10000000	cop[tikv]	table:part	tikv_task:{proc max:1.4s, min:505ms, p80:1.27s, p95:1.4s, iters:9859, tasks:20}	keep order:false	N/A	N/A
20:49:01 [2021-06-08T20:49:01.957Z]           │ └─IndexLookUp_64(Probe)	4.02	435528	root		time:2s, loops:447, index_task: {total_time: 1.16s, fetch_handle: 1.16s, build: 92.5µs, wait: 282.8µs}, table_task: {total_time: 7.59s, num: 56, concurrency: 60}		20.7 KB	N/A
20:49:01 [2021-06-08T20:49:01.957Z]           │   ├─IndexRangeScan_62(Build)	4.02	435528	cop[tikv]	table:partsupp, index:PRIMARY(PS_PARTKEY, PS_SUPPKEY)	time:1.12s, loops:482, cop_task: {num: 59, max: 191.9ms, min: 8.43ms, avg: 83.5ms, p95: 176.3ms, max_proc_keys: 15288, p95_proc_keys: 15008, tot_proc: 4.5s, tot_wait: 39ms, rpc_num: 59, rpc_time: 4.93s, copr_cache: disabled}, tikv_task:{proc max:176ms, min:7ms, p80:124ms, p95:161ms, 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:49:01 [2021-06-08T20:49:01.957Z]           │   └─TableRowIDScan_63(Probe)	4.02	435528	cop[tikv]	table:partsupp	time:2.48s, loops:505, cop_task: {num: 1422, max: 108.3ms, min: 459.7µs, avg: 17.3ms, p95: 35.7ms, max_proc_keys: 1080, p95_proc_keys: 588, tot_proc: 17.6s, tot_wait: 4.49s, rpc_num: 1422, rpc_time: 24.5s, copr_cache: disabled}, tikv_task:{proc max:43ms, min:0s, p80:16ms, p95:23ms, iters:5280, tasks:1422}, scan_detail: {total_process_keys: 435528, total_keys: 473502, rocksdb: {delete_skipped_count: 0, key_skipped_count: 194058, block: {cache_hit_count: 3644070, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:49:01 [2021-06-08T20:49:01.957Z]           └─TableReader_101(Probe)	46310896.67	45504356	root		time:33.5s, loops:44288, cop_task: {num: 761, max: 1.18s, min: 351.3ms, avg: 709.2ms, p95: 863.8ms, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 8m56.4s, tot_wait: 140ms, rpc_num: 761, rpc_time: 8m59.7s, copr_cache: disabled}	data:Selection_100	52.6 MB	N/A
20:49:01 [2021-06-08T20:49:01.957Z]             └─Selection_100	46310896.67	45504356	cop[tikv]		tikv_task:{proc max:1.15s, min:341ms, p80:759ms, 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:49:01 [2021-06-08T20:49:01.957Z]               └─TableFullScan_99	300005811.00	300005811	cop[tikv]	table:lineitem	tikv_task:{proc max:1.11s, min:324ms, p80:729ms, p95:814ms, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:49:01 [2021-06-08T20:49:01.957Z] 
20:49:01 [2021-06-08T20:49:01.957Z] queries/21.sql
20:49:01 [2021-06-08T20:49:01.957Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:49:01 [2021-06-08T20:49:01.957Z] Projection_26	100.00	100	root		time:1m21.1s, loops:2, Concurrency:OFF	tpch50.supplier.s_name, Column#72	4.62 KB	N/A
20:49:01 [2021-06-08T20:49:01.958Z] └─TopN_29	100.00	100	root		time:1m21.1s, loops:2	Column#72:desc, tpch50.supplier.s_name, offset:0, count:100	58.4 KB	N/A
20:49:01 [2021-06-08T20:49:01.958Z]   └─HashAgg_34	12800.00	20057	root		time:1m21.1s, loops:21, partial_worker:{wall_time:1m21.052566012s, concurrency:5, task_num:197, tot_wait:6m44.979134205s, tot_exec:269.308681ms, tot_time:6m45.260911018s, max:1m21.052536113s, p95:1m21.052536113s}, final_worker:{wall_time:1m21.066118316s, concurrency:5, task_num:25, tot_wait:6m45.259679535s, tot_exec:69.765551ms, tot_time:6m45.329457386s, max:1m21.066091831s, p95:1m21.066091831s}	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:01 [2021-06-08T20:49:01.958Z]     └─IndexHashJoin_42	7828961.66	198698	root		time:1m21s, loops:198, inner:{total:2m21.8s, concurrency:5, task:146, construct:6.68s, fetch:1m58.3s, build:1.29s, 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.2 MB	N/A
20:49:01 [2021-06-08T20:49:01.958Z]       ├─IndexHashJoin_83(Build)	9786202.08	3542799	root		time:1m20.5s, loops:3464, inner:{total:2m29.7s, concurrency:5, task:152, construct:8.02s, fetch:2m4s, 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:01 [2021-06-08T20:49:01.958Z]       │ ├─IndexJoin_99(Build)	12232752.60	3675878	root		time:1m20s, loops:3595, inner:{total:2m8.4s, concurrency:5, task:305, construct:16.9s, fetch:1m49.5s, build:1.96s}, probe:5.33s	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:01 [2021-06-08T20:49:01.958Z]       │ │ ├─HashJoin_107(Build)	12232752.60	7609895	root		time:1m19.5s, loops:7437, build_hash_table:{total:784.1ms, fetch:773.7ms, build:10.4ms}, probe:{concurrency:5, total:6m39.7s, max:1m19.9s, probe:1m1.2s, fetch:5m38.5s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.lineitem.l_suppkey)]	737.6 KB	0 Bytes
20:49:01 [2021-06-08T20:49:01.958Z]       │ │ │ ├─HashJoin_120(Build)	20000.00	20058	root		time:779.2ms, loops:22, build_hash_table:{total:502.1µs, fetch:157.2µs, build:344.9µs}, probe:{concurrency:5, total:3.91s, max:782.3ms, probe:87ms, fetch:3.82s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:49:01 [2021-06-08T20:49:01.958Z]       │ │ │ │ ├─TableReader_125(Build)	1.00	1	root		time:51.1µs, loops:2, cop_task: {num: 1, max: 797.5µs, proc_keys: 25, rpc_num: 1, rpc_time: 786.1µs, copr_cache: disabled}	data:Selection_124	234 Bytes	N/A
20:49:01 [2021-06-08T20:49:01.958Z]       │ │ │ │ │ └─Selection_124	1.00	1	cop[tikv]		tikv_task:{time:0s, loops:1}, scan_detail: {total_process_keys: 25, total_keys: 26, rocksdb: {delete_skipped_count: 0, key_skipped_count: 46, block: {cache_hit_count: 18, read_count: 0, read_byte: 0 Bytes}}}	eq(tpch50.nation.n_name, "EGYPT")	N/A	N/A
20:49:01 [2021-06-08T20:49:01.958Z]       │ │ │ │ │   └─TableFullScan_123	25.00	25	cop[tikv]	table:nation	tikv_task:{time:0s, loops:1}	keep order:false	N/A	N/A
20:49:01 [2021-06-08T20:49:01.958Z]       │ │ │ │ └─TableReader_122(Probe)	500000.00	500000	root		time:764.6ms, loops:490, cop_task: {num: 1, max: 881ms, proc_keys: 500000, tot_proc: 852ms, rpc_num: 1, rpc_time: 881ms, copr_cache: disabled}	data:TableFullScan_121	20.0 MB	N/A
20:49:01 [2021-06-08T20:49:01.958Z]       │ │ │ │   └─TableFullScan_121	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:795ms, loops:493}, scan_detail: {total_process_keys: 500000, total_keys: 500001, rocksdb: {delete_skipped_count: 0, key_skipped_count: 999999, block: {cache_hit_count: 15, read_count: 1689, read_byte: 108.5 MB}}}	keep order:false	N/A	N/A
20:49:01 [2021-06-08T20:49:01.958Z]       │ │ │ └─TableReader_128(Probe)	240004648.80	189670348	root		time:1m7.6s, loops:184596, cop_task: {num: 761, max: 2.53s, min: 261.6ms, avg: 1.53s, p95: 2.03s, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 18m14.7s, tot_wait: 59.5s, rpc_num: 761, rpc_time: 19m27.5s, copr_cache: disabled}	data:Selection_127	68.7 MB	N/A
20:49:01 [2021-06-08T20:49:01.958Z]       │ │ │   └─Selection_127	240004648.80	189670348	cop[tikv]		tikv_task:{proc max:1.33s, min:249ms, p80:1.19s, p95:1.25s, iters:296606, tasks:761}, scan_detail: {total_process_keys: 300005811, total_keys: 300006572, rocksdb: {delete_skipped_count: 0, key_skipped_count: 600010861, block: {cache_hit_count: 18691, read_count: 1131780, read_byte: 23.9 GB}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:49:01 [2021-06-08T20:49:01.958Z]       │ │ │     └─TableFullScan_126	300005811.00	300005811	cop[tikv]	table:l1	tikv_task:{proc max:1.25s, min:235ms, p80:1.11s, p95:1.18s, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:49:01 [2021-06-08T20:49:01.958Z]       │ │ └─TableReader_95(Probe)	0.49	3496163	root		time:1m40.2s, loops:3875, cop_task: {num: 5284, max: 530.8ms, min: 1.02ms, avg: 176.7ms, p95: 340ms, max_proc_keys: 3689, p95_proc_keys: 1948, tot_proc: 11m7.5s, tot_wait: 3m44.5s, rpc_num: 5284, rpc_time: 15m33.8s, copr_cache: disabled}	data:Selection_94	N/A	N/A
20:49:01 [2021-06-08T20:49:01.958Z]       │ │   └─Selection_94	0.49	3496163	cop[tikv]		tikv_task:{proc max:155ms, min:0s, p80:70ms, p95:82ms, iters:30302, tasks:5284}, scan_detail: {total_process_keys: 7236259, total_keys: 7795571, rocksdb: {delete_skipped_count: 0, key_skipped_count: 1778638, block: {cache_hit_count: 54006826, read_count: 219976, read_byte: 4.54 GB}}}	eq(tpch50.orders.o_orderstatus, "F")	N/A	N/A
20:49:01 [2021-06-08T20:49:01.958Z]       │ │     └─TableRangeScan_93	1.00	7236259	cop[tikv]	table:orders	tikv_task:{proc max:155ms, min:0s, p80:69ms, p95:82ms, iters:30302, tasks:5284}	range: decided by [tpch50.lineitem.l_orderkey], keep order:false	N/A	N/A
20:49:01 [2021-06-08T20:49:01.958Z]       │ └─IndexLookUp_80(Probe)	4.05	17316494	root		time:1m58.5s, loops:17132, index_task: {total_time: 1m5.3s, fetch_handle: 57.4s, build: 3.97ms, wait: 7.86s}, table_task: {total_time: 8m32.4s, num: 1458, concurrency: 760}		19.0 KB	N/A
20:49:01 [2021-06-08T20:49:01.958Z]       │   ├─IndexRangeScan_78(Build)	4.05	17316494	cop[tikv]	table:l2, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:55.1s, loops:18619, cop_task: {num: 3015, max: 773.9ms, min: 997µs, avg: 190.6ms, p95: 382.4ms, max_proc_keys: 13648, p95_proc_keys: 8795, tot_proc: 7m9.8s, tot_wait: 2m3.6s, rpc_num: 3015, rpc_time: 9m34.7s, copr_cache: disabled}, tikv_task:{proc max:173ms, min:0s, p80:98ms, p95:115ms, iters:30206, tasks:3015}, scan_detail: {total_process_keys: 17316494, total_keys: 20812603, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17316494, block: {cache_hit_count: 24260233, read_count: 226906, read_byte: 2.39 GB}}}	range: decided by [eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey)], keep order:false	N/A	N/A
20:49:01 [2021-06-08T20:49:01.958Z]       │   └─TableRowIDScan_79(Probe)	4.05	17316494	cop[tikv]	table:l2	time:6m17.6s, loops:20991, cop_task: {num: 7802, max: 675.4ms, min: 429.7µs, avg: 176.6ms, p95: 358.9ms, max_proc_keys: 12616, p95_proc_keys: 4820, tot_proc: 16m29.3s, tot_wait: 5m38.5s, rpc_num: 7802, rpc_time: 22m57.5s, copr_cache: disabled}, tikv_task:{proc max:292ms, min:0s, p80:105ms, p95:141ms, iters:49977, tasks:7802}, scan_detail: {total_process_keys: 17316494, total_keys: 18289622, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5628872, block: {cache_hit_count: 99020738, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:49:01 [2021-06-08T20:49:01.958Z]       └─IndexLookUp_39(Probe)	4.05	12022845	root		time:1m53.3s, loops:11945, index_task: {total_time: 1m2.1s, fetch_handle: 53.9s, build: 3.22ms, wait: 8.13s}, table_task: {total_time: 8m4.7s, num: 1408, concurrency: 730}		220.2 KB	N/A
20:49:01 [2021-06-08T20:49:01.958Z]         ├─IndexRangeScan_36(Build)	5.06	17183443	cop[tikv]	table:l3, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:51.6s, loops:18344, cop_task: {num: 2786, max: 720.3ms, min: 2.59ms, avg: 171ms, p95: 370.2ms, max_proc_keys: 18384, p95_proc_keys: 13725, tot_proc: 5m55.1s, tot_wait: 1m42.1s, rpc_num: 2786, rpc_time: 7m56.3s, copr_cache: disabled}, tikv_task:{proc max:187ms, min:0s, p80:77ms, p95:121ms, iters:29107, tasks:2786}, scan_detail: {total_process_keys: 17183443, total_keys: 20546478, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17183443, block: {cache_hit_count: 23554052, 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:01 [2021-06-08T20:49:01.958Z]         └─Selection_38(Probe)	4.05	12022845	cop[tikv]		time:6m9.7s, loops:13778, cop_task: {num: 10205, max: 621.6ms, min: 516.3µs, avg: 170.9ms, p95: 339.1ms, max_proc_keys: 7332, p95_proc_keys: 3988, tot_proc: 20m22.4s, tot_wait: 7m35.7s, rpc_num: 10205, rpc_time: 29m3.8s, copr_cache: disabled}, tikv_task:{proc max:216ms, min:0s, p80:76ms, p95:117ms, iters:60531, tasks:10205}, scan_detail: {total_process_keys: 17183443, total_keys: 18130011, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5528448, block: {cache_hit_count: 98293522, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:49:01 [2021-06-08T20:49:01.958Z]           └─TableRowIDScan_37	5.06	17183443	cop[tikv]	table:l3	tikv_task:{proc max:214ms, min:0s, p80:75ms, p95:116ms, iters:60531, tasks:10205}	keep order:false	N/A	N/A
20:49:01 [2021-06-08T20:49:01.958Z] + sync
20:49:01 [2021-06-08T20:49:01.958Z] + /usr/bin/echo 3
20:50:23 [2021-06-08T20:50:23.342Z] 
20:50:23 [2021-06-08T20:50:23.342Z] queries/21.sql
20:50:23 [2021-06-08T20:50:23.342Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:50:23 [2021-06-08T20:50:23.342Z] 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:50:23 [2021-06-08T20:50:23.342Z] └─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:50:23 [2021-06-08T20:50:23.342Z]   └─HashAgg_34	12800.00	20057	root		time:1m19.7s, loops:21, partial_worker:{wall_time:1m19.692124196s, concurrency:5, task_num:196, tot_wait:6m38.163829967s, tot_exec:282.273569ms, tot_time:6m38.459504631s, max:1m19.692099226s, p95:1m19.692099226s}, final_worker:{wall_time:1m19.704562564s, concurrency:5, task_num:25, tot_wait:6m38.459268885s, tot_exec:62.839174ms, tot_time:6m38.522119687s, max:1m19.70453588s, p95:1m19.70453588s}	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:23 [2021-06-08T20:50:23.342Z]     └─IndexHashJoin_42	7828961.66	198698	root		time:1m19.7s, loops:197, inner:{total:2m21.6s, concurrency:5, task:146, construct:6.75s, fetch:1m58.3s, build:1.13s, join:16.6s}	anti semi join, inner:IndexLookUp_39, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey)	641.1 MB	N/A
20:50:23 [2021-06-08T20:50:23.342Z]       ├─IndexHashJoin_83(Build)	9786202.08	3542799	root		time:1m19.2s, loops:3463, inner:{total:2m29.3s, concurrency:5, task:152, construct:7.91s, fetch:2m4s, build:1.28s, join:17.4s}	semi join, inner:IndexLookUp_80, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey), ne(tpch50.lineitem.l_suppkey, tpch50.supplier.s_suppkey)	555.9 MB	N/A
20:50:23 [2021-06-08T20:50:23.342Z]       │ ├─IndexJoin_99(Build)	12232752.60	3675878	root		time:1m18.6s, loops:3595, inner:{total:2m8.4s, concurrency:5, task:305, construct:16.6s, fetch:1m50s, build:1.8s}, probe:5.26s	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.6 MB	N/A
20:50:23 [2021-06-08T20:50:23.342Z]       │ │ ├─HashJoin_107(Build)	12232752.60	7609895	root		time:1m18.1s, loops:7436, build_hash_table:{total:1.16s, fetch:1.16s, build:5.57ms}, probe:{concurrency:5, total:6m31.9s, max:1m18.4s, probe:1m1.2s, fetch:5m30.7s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.lineitem.l_suppkey)]	732.8 KB	0 Bytes
20:50:23 [2021-06-08T20:50:23.342Z]       │ │ │ ├─HashJoin_120(Build)	20000.00	20058	root		time:1.16s, loops:22, build_hash_table:{total:195.6µs, fetch:190.1µs, build:5.47µs}, probe:{concurrency:5, total:5.8s, max:1.16s, probe:68.1ms, fetch:5.73s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:50:23 [2021-06-08T20:50:23.342Z]       │ │ │ │ ├─TableReader_125(Build)	1.00	1	root		time:43.1µs, loops:2, cop_task: {num: 1, max: 1.64ms, proc_keys: 25, tot_proc: 1ms, tot_wait: 1ms, rpc_num: 1, rpc_time: 1.63ms, copr_cache: disabled}	data:Selection_124	252 Bytes	N/A
20:50:23 [2021-06-08T20:50:23.342Z]       │ │ │ │ │ └─Selection_124	1.00	1	cop[tikv]		tikv_task:{time:1ms, loops:1}, scan_detail: {total_process_keys: 25, total_keys: 26, rocksdb: {delete_skipped_count: 0, key_skipped_count: 46, block: {cache_hit_count: 17, read_count: 1, read_byte: 23.8 KB}}}	eq(tpch50.nation.n_name, "EGYPT")	N/A	N/A
20:50:23 [2021-06-08T20:50:23.342Z]       │ │ │ │ │   └─TableFullScan_123	25.00	25	cop[tikv]	table:nation	tikv_task:{time:1ms, loops:1}	keep order:false	N/A	N/A
20:50:23 [2021-06-08T20:50:23.342Z]       │ │ │ │ └─TableReader_122(Probe)	500000.00	500000	root		time:1.15s, loops:490, cop_task: {num: 1, max: 1.15s, proc_keys: 500000, tot_proc: 1.12s, tot_wait: 1ms, rpc_num: 1, rpc_time: 1.15s, copr_cache: disabled}	data:TableFullScan_121	20.0 MB	N/A
20:50:23 [2021-06-08T20:50:23.342Z]       │ │ │ │   └─TableFullScan_121	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:1.06s, loops:493}, scan_detail: {total_process_keys: 500000, total_keys: 500001, rocksdb: {delete_skipped_count: 0, key_skipped_count: 999999, block: {cache_hit_count: 13, read_count: 1679, read_byte: 104.5 MB}}}	keep order:false	N/A	N/A
20:50:23 [2021-06-08T20:50:23.343Z]       │ │ │ └─TableReader_128(Probe)	240004648.80	189670348	root		time:1m5.6s, loops:184597, cop_task: {num: 761, max: 3.01s, min: 280ms, avg: 1.5s, p95: 1.96s, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 17m50.2s, tot_wait: 1m1.9s, rpc_num: 761, rpc_time: 19m5.2s, copr_cache: disabled}	data:Selection_127	109.4 MB	N/A
20:50:23 [2021-06-08T20:50:23.343Z]       │ │ │   └─Selection_127	240004648.80	189670348	cop[tikv]		tikv_task:{proc max:1.3s, min:265ms, p80:1.14s, p95:1.19s, iters:296606, tasks:761}, scan_detail: {total_process_keys: 300005811, total_keys: 300006572, rocksdb: {delete_skipped_count: 0, key_skipped_count: 600010861, block: {cache_hit_count: 10455, read_count: 1114193, read_byte: 23.6 GB}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:50:23 [2021-06-08T20:50:23.343Z]       │ │ │     └─TableFullScan_126	300005811.00	300005811	cop[tikv]	table:l1	tikv_task:{proc max:1.22s, min:254ms, p80:1.07s, p95:1.11s, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:50:23 [2021-06-08T20:50:23.343Z]       │ │ └─TableReader_95(Probe)	0.49	3496188	root		time:1m41.4s, loops:3875, cop_task: {num: 5285, max: 523.8ms, min: 498.4µs, avg: 181.3ms, p95: 340.4ms, max_proc_keys: 3484, p95_proc_keys: 1952, tot_proc: 11m27s, tot_wait: 3m53.3s, rpc_num: 5285, rpc_time: 15m57.9s, copr_cache: disabled}	data:Selection_94	N/A	N/A
20:50:23 [2021-06-08T20:50:23.343Z]       │ │   └─Selection_94	0.49	3496188	cop[tikv]		tikv_task:{proc max:134ms, min:0s, p80:68ms, p95:81ms, iters:30297, tasks:5285}, scan_detail: {total_process_keys: 7236284, total_keys: 7795517, rocksdb: {delete_skipped_count: 0, key_skipped_count: 1778393, block: {cache_hit_count: 54006228, read_count: 218205, read_byte: 4.21 GB}}}	eq(tpch50.orders.o_orderstatus, "F")	N/A	N/A
20:50:23 [2021-06-08T20:50:23.343Z]       │ │     └─TableRangeScan_93	1.00	7236284	cop[tikv]	table:orders	tikv_task:{proc max:134ms, min:0s, p80:68ms, p95:81ms, iters:30297, tasks:5285}	range: decided by [tpch50.lineitem.l_orderkey], keep order:false	N/A	N/A
20:50:23 [2021-06-08T20:50:23.343Z]       │ └─IndexLookUp_80(Probe)	4.05	17316485	root		time:1m58.4s, loops:17131, index_task: {total_time: 1m6.7s, fetch_handle: 59.1s, build: 3.5ms, wait: 7.61s}, table_task: {total_time: 8m29.5s, num: 1458, concurrency: 760}		19.1 KB	N/A
20:50:23 [2021-06-08T20:50:23.343Z]       │   ├─IndexRangeScan_78(Build)	4.05	17316485	cop[tikv]	table:l2, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:56.8s, loops:18595, cop_task: {num: 2995, max: 628.8ms, min: 390.4µs, avg: 192.7ms, p95: 389.6ms, max_proc_keys: 10683, p95_proc_keys: 8769, tot_proc: 7m13.2s, tot_wait: 2m3.6s, rpc_num: 2995, rpc_time: 9m37.1s, copr_cache: disabled}, tikv_task:{proc max:149ms, min:0s, p80:95ms, p95:110ms, iters:30117, tasks:2995}, scan_detail: {total_process_keys: 17316485, total_keys: 20812592, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17316485, block: {cache_hit_count: 24259988, read_count: 225688, 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:23 [2021-06-08T20:50:23.343Z]       │   └─TableRowIDScan_79(Probe)	4.05	17316485	cop[tikv]	table:l2	time:6m16.4s, loops:21000, cop_task: {num: 7794, max: 619.2ms, min: 420.7µs, avg: 177.8ms, p95: 357.4ms, max_proc_keys: 12685, p95_proc_keys: 4874, tot_proc: 16m36.2s, tot_wait: 5m41.1s, rpc_num: 7794, rpc_time: 23m5.4s, copr_cache: disabled}, tikv_task:{proc max:300ms, min:0s, p80:103ms, p95:139ms, iters:49899, tasks:7794}, scan_detail: {total_process_keys: 17316485, total_keys: 18288851, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5625070, block: {cache_hit_count: 99025884, read_count: 1099, read_byte: 382.7 MB}}}	keep order:false	N/A	N/A
20:50:23 [2021-06-08T20:50:23.343Z]       └─IndexLookUp_39(Probe)	4.05	12022797	root		time:1m53.3s, loops:11946, index_task: {total_time: 1m2.3s, fetch_handle: 50.5s, build: 3.49ms, wait: 11.9s}, table_task: {total_time: 8m11.8s, num: 1408, concurrency: 730}		269.1 KB	N/A
20:50:23 [2021-06-08T20:50:23.343Z]         ├─IndexRangeScan_36(Build)	5.06	17183427	cop[tikv]	table:l3, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:48.2s, loops:18343, cop_task: {num: 2771, max: 681.6ms, min: 528.5µs, avg: 171.3ms, p95: 365.7ms, max_proc_keys: 17676, p95_proc_keys: 13726, tot_proc: 5m53.3s, tot_wait: 1m42.8s, rpc_num: 2771, rpc_time: 7m54.7s, copr_cache: disabled}, tikv_task:{proc max:181ms, min:0s, p80:79ms, p95:118ms, iters:29041, tasks:2771}, scan_detail: {total_process_keys: 17183427, total_keys: 20546458, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17183427, block: {cache_hit_count: 23554023, read_count: 0, read_byte: 0 Bytes}}}	range: decided by [eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey)], keep order:false	N/A	N/A
20:50:23 [2021-06-08T20:50:23.343Z]         └─Selection_38(Probe)	4.05	12022797	cop[tikv]		time:6m19.2s, loops:13769, cop_task: {num: 10248, max: 613.8ms, min: 445.1µs, avg: 176.4ms, p95: 353ms, max_proc_keys: 7834, p95_proc_keys: 3929, tot_proc: 21m7.4s, tot_wait: 7m56.3s, rpc_num: 10248, rpc_time: 30m7.9s, copr_cache: disabled}, tikv_task:{proc max:230ms, min:0s, p80:76ms, p95:113ms, iters:60727, tasks:10248}, scan_detail: {total_process_keys: 17183427, total_keys: 18128770, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5525183, block: {cache_hit_count: 98291223, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:50:23 [2021-06-08T20:50:23.343Z]           └─TableRowIDScan_37	5.06	17183427	cop[tikv]	table:l3	tikv_task:{proc max:227ms, min:0s, p80:75ms, p95:112ms, iters:60727, tasks:10248}	keep order:false	N/A	N/A
20:50:23 [2021-06-08T20:50:23.343Z] + sync
20:50:23 [2021-06-08T20:50:23.343Z] + /usr/bin/echo 3
20:51:44 [2021-06-08T20:51:44.726Z] 
20:51:44 [2021-06-08T20:51:44.726Z] queries/21.sql
20:51:44 [2021-06-08T20:51:44.726Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:51:44 [2021-06-08T20:51:44.726Z] 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:51:44 [2021-06-08T20:51:44.726Z] └─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:51:44 [2021-06-08T20:51:44.726Z]   └─HashAgg_34	12800.00	20057	root		time:1m19.8s, loops:21, partial_worker:{wall_time:1m19.781639801s, concurrency:5, task_num:198, tot_wait:6m38.630061021s, tot_exec:263.874719ms, tot_time:6m38.905747549s, max:1m19.78161621s, p95:1m19.78161621s}, final_worker:{wall_time:1m19.79506475s, concurrency:5, task_num:25, tot_wait:6m38.90477824s, tot_exec:69.3303ms, tot_time:6m38.974120767s, max:1m19.795041496s, p95:1m19.795041496s}	group by:tpch50.supplier.s_name, funcs:count(1)->Column#72, funcs:firstrow(tpch50.supplier.s_name)->tpch50.supplier.s_name	17.2 MB	N/A
20:51:44 [2021-06-08T20:51:44.726Z]     └─IndexHashJoin_42	7828961.66	198698	root		time:1m19.8s, loops:199, inner:{total:2m18.1s, concurrency:5, task:146, construct:6.32s, fetch:1m55.2s, build:1.19s, join:16.6s}	anti semi join, inner:IndexLookUp_39, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey)	641.0 MB	N/A
20:51:44 [2021-06-08T20:51:44.726Z]       ├─IndexHashJoin_83(Build)	9786202.08	3542799	root		time:1m19.2s, loops:3463, inner:{total:2m26.6s, concurrency:5, task:152, construct:8.12s, fetch:2m1.2s, build:1.3s, join:17.2s}	semi join, inner:IndexLookUp_80, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey), ne(tpch50.lineitem.l_suppkey, tpch50.supplier.s_suppkey)	555.9 MB	N/A
20:51:44 [2021-06-08T20:51:44.726Z]       │ ├─IndexJoin_99(Build)	12232752.60	3675878	root		time:1m18.8s, loops:3595, inner:{total:2m7.8s, concurrency:5, task:305, construct:17s, fetch:1m48.8s, build:1.96s}, probe:5.43s	inner join, inner:TableReader_95, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.orders.o_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.orders.o_orderkey)	575.6 MB	N/A
20:51:44 [2021-06-08T20:51:44.726Z]       │ │ ├─HashJoin_107(Build)	12232752.60	7609895	root		time:1m18.2s, loops:7437, build_hash_table:{total:1.03s, fetch:1.02s, build:6.15ms}, probe:{concurrency:5, total:6m32.6s, max:1m18.5s, probe:1m2.2s, fetch:5m30.4s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.lineitem.l_suppkey)]	757.3 KB	0 Bytes
20:51:44 [2021-06-08T20:51:44.726Z]       │ │ │ ├─HashJoin_120(Build)	20000.00	20058	root		time:1.02s, loops:23, build_hash_table:{total:192.4µs, fetch:185.7µs, build:6.67µs}, probe:{concurrency:5, total:5.12s, max:1.02s, probe:63.2ms, fetch:5.06s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:51:44 [2021-06-08T20:51:44.726Z]       │ │ │ │ ├─TableReader_125(Build)	1.00	1	root		time:65µs, loops:2, cop_task: {num: 1, max: 1.35ms, proc_keys: 25, tot_proc: 1ms, rpc_num: 1, rpc_time: 1.32ms, copr_cache: disabled}	data:Selection_124	248 Bytes	N/A
20:51:44 [2021-06-08T20:51:44.726Z]       │ │ │ │ │ └─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:51:44 [2021-06-08T20:51:44.726Z]       │ │ │ │ │   └─TableFullScan_123	25.00	25	cop[tikv]	table:nation	tikv_task:{time:1ms, loops:1}	keep order:false	N/A	N/A
20:51:44 [2021-06-08T20:51:44.726Z]       │ │ │ │ └─TableReader_122(Probe)	500000.00	500000	root		time:1.01s, loops:490, cop_task: {num: 1, max: 1.01s, proc_keys: 500000, tot_proc: 982ms, rpc_num: 1, rpc_time: 1.01s, copr_cache: disabled}	data:TableFullScan_121	20.0 MB	N/A
20:51:44 [2021-06-08T20:51:44.726Z]       │ │ │ │   └─TableFullScan_121	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:931ms, loops:493}, scan_detail: {total_process_keys: 500000, total_keys: 500001, rocksdb: {delete_skipped_count: 0, key_skipped_count: 999999, block: {cache_hit_count: 13, read_count: 1679, read_byte: 104.5 MB}}}	keep order:false	N/A	N/A
20:51:44 [2021-06-08T20:51:44.727Z]       │ │ │ └─TableReader_128(Probe)	240004648.80	189670348	root		time:1m5.6s, loops:184596, cop_task: {num: 761, max: 2.32s, min: 297.2ms, avg: 1.5s, p95: 1.93s, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 17m50.5s, tot_wait: 1m1.2s, rpc_num: 761, rpc_time: 19m4.7s, copr_cache: disabled}	data:Selection_127	109.4 MB	N/A
20:51:44 [2021-06-08T20:51:44.727Z]       │ │ │   └─Selection_127	240004648.80	189670348	cop[tikv]		tikv_task:{proc max:1.32s, 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: 10453, read_count: 1114195, read_byte: 23.6 GB}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:51:44 [2021-06-08T20:51:44.727Z]       │ │ │     └─TableFullScan_126	300005811.00	300005811	cop[tikv]	table:l1	tikv_task:{proc max:1.25s, min:270ms, p80:1.07s, p95:1.12s, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:51:44 [2021-06-08T20:51:44.727Z]       │ │ └─TableReader_95(Probe)	0.49	3496173	root		time:1m39.7s, loops:3875, cop_task: {num: 5284, max: 575.1ms, min: 1.78ms, avg: 177.5ms, p95: 338.5ms, max_proc_keys: 3565, p95_proc_keys: 1962, tot_proc: 11m16.1s, tot_wait: 3m42.4s, rpc_num: 5284, rpc_time: 15m37.8s, copr_cache: disabled}	data:Selection_94	N/A	N/A
20:51:44 [2021-06-08T20:51:44.727Z]       │ │   └─Selection_94	0.49	3496173	cop[tikv]		tikv_task:{proc max:134ms, min:0s, p80:68ms, p95:81ms, iters:30258, tasks:5284}, scan_detail: {total_process_keys: 7236267, total_keys: 7795454, rocksdb: {delete_skipped_count: 0, key_skipped_count: 1778201, block: {cache_hit_count: 54006724, read_count: 218237, read_byte: 4.21 GB}}}	eq(tpch50.orders.o_orderstatus, "F")	N/A	N/A
20:51:44 [2021-06-08T20:51:44.727Z]       │ │     └─TableRangeScan_93	1.00	7236267	cop[tikv]	table:orders	tikv_task:{proc max:133ms, min:0s, p80:68ms, p95:80ms, iters:30258, tasks:5284}	range: decided by [tpch50.lineitem.l_orderkey], keep order:false	N/A	N/A
20:51:44 [2021-06-08T20:51:44.727Z]       │ └─IndexLookUp_80(Probe)	4.05	17316445	root		time:1m55.7s, loops:17125, index_task: {total_time: 1m4.5s, fetch_handle: 56.6s, build: 3.12ms, wait: 7.99s}, table_task: {total_time: 8m21.6s, num: 1458, concurrency: 760}		19.3 KB	N/A
20:51:44 [2021-06-08T20:51:44.727Z]       │   ├─IndexRangeScan_78(Build)	4.05	17316445	cop[tikv]	table:l2, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:54.2s, loops:18615, cop_task: {num: 2999, max: 647.2ms, min: 456.8µs, avg: 186ms, p95: 364.8ms, max_proc_keys: 12556, p95_proc_keys: 8738, tot_proc: 6m57.4s, tot_wait: 2m0s, rpc_num: 2999, rpc_time: 9m17.9s, copr_cache: disabled}, tikv_task:{proc max:165ms, min:0s, p80:95ms, p95:109ms, iters:30093, tasks:2999}, scan_detail: {total_process_keys: 17316445, total_keys: 20812545, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17316445, block: {cache_hit_count: 24259954, read_count: 225673, read_byte: 2.00 GB}}}	range: decided by [eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey)], keep order:false	N/A	N/A
20:51:44 [2021-06-08T20:51:44.727Z]       │   └─TableRowIDScan_79(Probe)	4.05	17316445	cop[tikv]	table:l2	time:6m9.6s, loops:21039, cop_task: {num: 7811, max: 611.9ms, min: 454.2µs, avg: 173.4ms, p95: 346.3ms, max_proc_keys: 12919, p95_proc_keys: 4865, tot_proc: 16m15.1s, tot_wait: 5m30.5s, rpc_num: 7811, rpc_time: 22m34.6s, copr_cache: disabled}, tikv_task:{proc max:261ms, min:0s, p80:103ms, p95:139ms, iters:49925, tasks:7811}, scan_detail: {total_process_keys: 17316445, total_keys: 18290604, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5632411, block: {cache_hit_count: 99017953, read_count: 1118, read_byte: 398.9 MB}}}	keep order:false	N/A	N/A
20:51:44 [2021-06-08T20:51:44.727Z]       └─IndexLookUp_39(Probe)	4.05	12022764	root		time:1m50.4s, loops:11942, index_task: {total_time: 59.9s, fetch_handle: 49.3s, build: 5.24ms, wait: 10.6s}, table_task: {total_time: 7m56.7s, num: 1408, concurrency: 730}		218.0 KB	N/A
20:51:44 [2021-06-08T20:51:44.727Z]         ├─IndexRangeScan_36(Build)	5.06	17183375	cop[tikv]	table:l3, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:46.9s, loops:18337, cop_task: {num: 2784, max: 681.1ms, min: 416.1µs, avg: 168.7ms, p95: 364ms, max_proc_keys: 18085, p95_proc_keys: 13505, tot_proc: 5m50.8s, tot_wait: 1m38.7s, rpc_num: 2784, rpc_time: 7m49.7s, copr_cache: disabled}, tikv_task:{proc max:178ms, min:0s, p80:78ms, p95:117ms, iters:29090, tasks:2784}, scan_detail: {total_process_keys: 17183375, total_keys: 20546398, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17183375, 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:51:44 [2021-06-08T20:51:44.727Z]         └─Selection_38(Probe)	4.05	12022764	cop[tikv]		time:6m4.4s, loops:13760, cop_task: {num: 10220, max: 638.2ms, min: 462.8µs, avg: 167.8ms, p95: 334.7ms, max_proc_keys: 7613, p95_proc_keys: 3959, tot_proc: 20m5.5s, tot_wait: 7m22.7s, rpc_num: 10220, rpc_time: 28m34.4s, copr_cache: disabled}, tikv_task:{proc max:228ms, min:0s, p80:76ms, p95:114ms, iters:60611, tasks:10220}, scan_detail: {total_process_keys: 17183375, total_keys: 18129002, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5528897, block: {cache_hit_count: 98282386, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:51:44 [2021-06-08T20:51:44.727Z]           └─TableRowIDScan_37	5.06	17183375	cop[tikv]	table:l3	tikv_task:{proc max:225ms, min:0s, p80:75ms, p95:114ms, iters:60611, tasks:10220}	keep order:false	N/A	N/A
20:51:44 [2021-06-08T20:51:44.727Z] + sync
20:51:44 [2021-06-08T20:51:44.727Z] + /usr/bin/echo 3
20:53:06 [2021-06-08T20:53:06.109Z] 
20:53:06 [2021-06-08T20:53:06.109Z] queries/21.sql
20:53:06 [2021-06-08T20:53:06.109Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:53:06 [2021-06-08T20:53:06.109Z] 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:53:06 [2021-06-08T20:53:06.109Z] └─TopN_29	100.00	100	root		time:1m19.7s, loops:2	Column#72:desc, tpch50.supplier.s_name, offset:0, count:100	58.4 KB	N/A
20:53:06 [2021-06-08T20:53:06.109Z]   └─HashAgg_34	12800.00	20057	root		time:1m19.7s, loops:21, partial_worker:{wall_time:1m19.654241117s, concurrency:5, task_num:197, tot_wait:6m38.003159768s, tot_exec:249.48542ms, tot_time:6m38.266147197s, max:1m19.654198037s, p95:1m19.654198037s}, final_worker:{wall_time:1m19.668410498s, concurrency:5, task_num:25, tot_wait:6m38.263238675s, tot_exec:70.153562ms, tot_time:6m38.333403668s, max:1m19.668374121s, p95:1m19.668374121s}	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:06 [2021-06-08T20:53:06.109Z]     └─IndexHashJoin_42	7828961.66	198698	root		time:1m19.6s, loops:198, inner:{total:2m17.9s, concurrency:5, task:146, construct:6.49s, fetch:1m55.1s, build:1.21s, join:16.3s}	anti semi join, inner:IndexLookUp_39, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey)	641.0 MB	N/A
20:53:06 [2021-06-08T20:53:06.109Z]       ├─IndexHashJoin_83(Build)	9786202.08	3542799	root		time:1m19.2s, loops:3463, inner:{total:2m26.1s, concurrency:5, task:152, construct:8.04s, fetch:2m1s, build:1.27s, join:17s}	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:06 [2021-06-08T20:53:06.109Z]       │ ├─IndexJoin_99(Build)	12232752.60	3675878	root		time:1m18.6s, loops:3595, inner:{total:2m6.3s, concurrency:5, task:305, construct:16.1s, fetch:1m48.3s, build:1.88s}, probe:5.06s	inner join, inner:TableReader_95, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.orders.o_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.orders.o_orderkey)	575.3 MB	N/A
20:53:06 [2021-06-08T20:53:06.109Z]       │ │ ├─HashJoin_107(Build)	12232752.60	7609895	root		time:1m18.1s, loops:7436, build_hash_table:{total:1.04s, fetch:1.04s, build:6.5ms}, probe:{concurrency:5, total:6m32.3s, max:1m18.5s, probe:1m0.8s, fetch:5m31.6s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.lineitem.l_suppkey)]	732.8 KB	0 Bytes
20:53:06 [2021-06-08T20:53:06.109Z]       │ │ │ ├─HashJoin_120(Build)	20000.00	20058	root		time:1.04s, loops:22, build_hash_table:{total:202.4µs, fetch:196.7µs, build:5.64µs}, probe:{concurrency:5, total:5.2s, max:1.04s, probe:65ms, fetch:5.13s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:53:06 [2021-06-08T20:53:06.109Z]       │ │ │ │ ├─TableReader_125(Build)	1.00	1	root		time:68.2µs, loops:2, cop_task: {num: 1, max: 1.52ms, proc_keys: 25, rpc_num: 1, rpc_time: 1.48ms, copr_cache: disabled}	data:Selection_124	240 Bytes	N/A
20:53:06 [2021-06-08T20:53:06.109Z]       │ │ │ │ │ └─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:06 [2021-06-08T20:53:06.109Z]       │ │ │ │ │   └─TableFullScan_123	25.00	25	cop[tikv]	table:nation	tikv_task:{time:0s, loops:1}	keep order:false	N/A	N/A
20:53:06 [2021-06-08T20:53:06.109Z]       │ │ │ │ └─TableReader_122(Probe)	500000.00	500000	root		time:1.03s, loops:490, cop_task: {num: 1, max: 1.03s, proc_keys: 500000, tot_proc: 997ms, rpc_num: 1, rpc_time: 1.03s, copr_cache: disabled}	data:TableFullScan_121	20.0 MB	N/A
20:53:06 [2021-06-08T20:53:06.109Z]       │ │ │ │   └─TableFullScan_121	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:938ms, loops:493}, scan_detail: {total_process_keys: 500000, total_keys: 500001, rocksdb: {delete_skipped_count: 0, key_skipped_count: 999999, block: {cache_hit_count: 13, read_count: 1679, read_byte: 104.5 MB}}}	keep order:false	N/A	N/A
20:53:06 [2021-06-08T20:53:06.109Z]       │ │ │ └─TableReader_128(Probe)	240004648.80	189670348	root		time:1m5.7s, loops:184596, cop_task: {num: 761, max: 2.57s, min: 266.8ms, avg: 1.51s, p95: 1.95s, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 17m53.9s, tot_wait: 59.5s, rpc_num: 761, rpc_time: 19m6.4s, copr_cache: disabled}	data:Selection_127	109.4 MB	N/A
20:53:06 [2021-06-08T20:53:06.109Z]       │ │ │   └─Selection_127	240004648.80	189670348	cop[tikv]		tikv_task:{proc max:1.26s, min:256ms, p80:1.15s, p95:1.19s, iters:296606, tasks:761}, scan_detail: {total_process_keys: 300005811, total_keys: 300006572, rocksdb: {delete_skipped_count: 0, key_skipped_count: 600010861, block: {cache_hit_count: 10450, read_count: 1114198, read_byte: 23.6 GB}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:53:06 [2021-06-08T20:53:06.109Z]       │ │ │     └─TableFullScan_126	300005811.00	300005811	cop[tikv]	table:l1	tikv_task:{proc max:1.19s, min:245ms, p80:1.06s, p95:1.11s, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:53:06 [2021-06-08T20:53:06.109Z]       │ │ └─TableReader_95(Probe)	0.49	3496187	root		time:1m39.7s, loops:3875, cop_task: {num: 5264, max: 503ms, min: 2.03ms, avg: 173.6ms, p95: 332.3ms, max_proc_keys: 3572, p95_proc_keys: 1978, tot_proc: 10m58.4s, tot_wait: 3m37s, rpc_num: 5264, rpc_time: 15m13.8s, copr_cache: disabled}	data:Selection_94	N/A	N/A
20:53:06 [2021-06-08T20:53:06.109Z]       │ │   └─Selection_94	0.49	3496187	cop[tikv]		tikv_task:{proc max:141ms, min:0s, p80:68ms, p95:81ms, iters:30266, tasks:5264}, scan_detail: {total_process_keys: 7236317, total_keys: 7795499, rocksdb: {delete_skipped_count: 0, key_skipped_count: 1778222, block: {cache_hit_count: 54006953, read_count: 218174, read_byte: 4.21 GB}}}	eq(tpch50.orders.o_orderstatus, "F")	N/A	N/A
20:53:06 [2021-06-08T20:53:06.109Z]       │ │     └─TableRangeScan_93	1.00	7236317	cop[tikv]	table:orders	tikv_task:{proc max:141ms, min:0s, p80:68ms, p95:81ms, iters:30266, tasks:5264}	range: decided by [tpch50.lineitem.l_orderkey], keep order:false	N/A	N/A
20:53:06 [2021-06-08T20:53:06.109Z]       │ └─IndexLookUp_80(Probe)	4.05	17316407	root		time:1m55.8s, loops:17133, index_task: {total_time: 1m4.5s, fetch_handle: 56s, build: 3.07ms, wait: 8.56s}, table_task: {total_time: 8m20.8s, num: 1458, concurrency: 760}		19.1 KB	N/A
20:53:06 [2021-06-08T20:53:06.109Z]       │   ├─IndexRangeScan_78(Build)	4.05	17316407	cop[tikv]	table:l2, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:53.7s, loops:18632, cop_task: {num: 2980, max: 626.7ms, min: 462.5µs, avg: 187.1ms, p95: 357.5ms, max_proc_keys: 14567, p95_proc_keys: 8770, tot_proc: 6m56.2s, tot_wait: 2m0.6s, rpc_num: 2980, rpc_time: 9m17.5s, copr_cache: disabled}, tikv_task:{proc max:161ms, min:0s, p80:95ms, p95:111ms, iters:30151, tasks:2980}, scan_detail: {total_process_keys: 17316407, total_keys: 20812502, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17316407, block: {cache_hit_count: 24259912, read_count: 225681, read_byte: 2.00 GB}}}	range: decided by [eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey)], keep order:false	N/A	N/A
20:53:06 [2021-06-08T20:53:06.109Z]       │   └─TableRowIDScan_79(Probe)	4.05	17316407	cop[tikv]	table:l2	time:6m9.8s, loops:21041, cop_task: {num: 7792, max: 618.8ms, min: 388.4µs, avg: 173ms, p95: 345.4ms, max_proc_keys: 9857, p95_proc_keys: 4885, tot_proc: 16m11.4s, tot_wait: 5m26.4s, rpc_num: 7792, rpc_time: 22m27.7s, copr_cache: disabled}, tikv_task:{proc max:289ms, min:0s, p80:103ms, p95:139ms, iters:49917, tasks:7792}, scan_detail: {total_process_keys: 17316407, total_keys: 18289381, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5628540, block: {cache_hit_count: 99018794, read_count: 1115, read_byte: 401.1 MB}}}	keep order:false	N/A	N/A
20:53:06 [2021-06-08T20:53:06.109Z]       └─IndexLookUp_39(Probe)	4.05	12022766	root		time:1m50.3s, loops:11952, index_task: {total_time: 58.9s, fetch_handle: 48.9s, build: 4.75ms, wait: 10s}, table_task: {total_time: 7m56.4s, num: 1408, concurrency: 730}		220.3 KB	N/A
20:53:06 [2021-06-08T20:53:06.109Z]         ├─IndexRangeScan_36(Build)	5.06	17183343	cop[tikv]	table:l3, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:46.5s, loops:18336, cop_task: {num: 2779, max: 665ms, min: 477.1µs, avg: 167.5ms, p95: 366.1ms, max_proc_keys: 17101, p95_proc_keys: 13529, tot_proc: 5m45s, tot_wait: 1m40.6s, rpc_num: 2779, rpc_time: 7m45.4s, copr_cache: disabled}, tikv_task:{proc max:169ms, min:0s, p80:78ms, p95:119ms, iters:29116, tasks:2779}, scan_detail: {total_process_keys: 17183343, total_keys: 20546361, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17183343, block: {cache_hit_count: 23553933, 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:06 [2021-06-08T20:53:06.109Z]         └─Selection_38(Probe)	4.05	12022766	cop[tikv]		time:6m6.7s, loops:13764, cop_task: {num: 10159, max: 601.5ms, min: 311.8µs, avg: 169.6ms, p95: 341.4ms, max_proc_keys: 6633, p95_proc_keys: 3956, tot_proc: 20m17.7s, tot_wait: 7m23.7s, rpc_num: 10159, rpc_time: 28m42.4s, copr_cache: disabled}, tikv_task:{proc max:217ms, min:0s, p80:76ms, p95:115ms, iters:60334, tasks:10159}, scan_detail: {total_process_keys: 17183343, total_keys: 18129714, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5528655, block: {cache_hit_count: 98288053, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:53:06 [2021-06-08T20:53:06.109Z]           └─TableRowIDScan_37	5.06	17183343	cop[tikv]	table:l3	tikv_task:{proc max:214ms, min:0s, p80:75ms, p95:114ms, iters:60334, tasks:10159}	keep order:false	N/A	N/A
20:53:06 [2021-06-08T20:53:06.109Z] + sync
20:53:06 [2021-06-08T20:53:06.109Z] + /usr/bin/echo 3
20:54:27 [2021-06-08T20:54:27.521Z] 
20:54:27 [2021-06-08T20:54:27.521Z] queries/21.sql
20:54:27 [2021-06-08T20:54:27.521Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:54:27 [2021-06-08T20:54:27.521Z] 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:54:27 [2021-06-08T20:54:27.521Z] └─TopN_29	100.00	100	root		time:1m19.7s, loops:2	Column#72:desc, tpch50.supplier.s_name, offset:0, count:100	58.4 KB	N/A
20:54:27 [2021-06-08T20:54:27.522Z]   └─HashAgg_34	12800.00	20057	root		time:1m19.7s, loops:21, partial_worker:{wall_time:1m19.643550262s, concurrency:5, task_num:197, tot_wait:6m37.926365106s, tot_exec:273.570015ms, tot_time:6m38.213784657s, max:1m19.643524757s, p95:1m19.643524757s}, final_worker:{wall_time:1m19.656207854s, concurrency:5, task_num:25, tot_wait:6m38.211856685s, tot_exec:65.90484ms, tot_time:6m38.277774356s, max:1m19.656189111s, p95:1m19.656189111s}	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:27 [2021-06-08T20:54:27.522Z]     └─IndexHashJoin_42	7828961.66	198698	root		time:1m19.6s, loops:198, inner:{total:2m18.3s, concurrency:5, task:146, construct:6.56s, fetch:1m55.1s, build:1.26s, 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:54:27 [2021-06-08T20:54:27.522Z]       ├─IndexHashJoin_83(Build)	9786202.08	3542799	root		time:1m19.1s, loops:3463, inner:{total:2m27.1s, concurrency:5, task:152, construct:7.99s, fetch:2m1.5s, build:1.23s, join:17.5s}	semi join, inner:IndexLookUp_80, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey), ne(tpch50.lineitem.l_suppkey, tpch50.supplier.s_suppkey)	555.9 MB	N/A
20:54:27 [2021-06-08T20:54:27.522Z]       │ ├─IndexJoin_99(Build)	12232752.60	3675878	root		time:1m18.5s, loops:3595, inner:{total:2m5.7s, concurrency:5, task:305, construct:16.4s, fetch:1m47.4s, build:1.89s}, 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:54:27 [2021-06-08T20:54:27.522Z]       │ │ ├─HashJoin_107(Build)	12232752.60	7609895	root		time:1m17.9s, loops:7436, build_hash_table:{total:1.01s, fetch:1.01s, build:6.93ms}, probe:{concurrency:5, total:6m31.6s, max:1m18.3s, probe:1m2.6s, fetch:5m29.1s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.lineitem.l_suppkey)]	757.3 KB	0 Bytes
20:54:27 [2021-06-08T20:54:27.522Z]       │ │ │ ├─HashJoin_120(Build)	20000.00	20058	root		time:1.01s, loops:23, build_hash_table:{total:141.9µs, fetch:136.7µs, build:5.18µs}, probe:{concurrency:5, total:5.06s, max:1.01s, probe:71.6ms, fetch:4.99s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:54:27 [2021-06-08T20:54:27.522Z]       │ │ │ │ ├─TableReader_125(Build)	1.00	1	root		time:40.1µs, loops:2, cop_task: {num: 1, max: 1.48ms, proc_keys: 25, tot_proc: 1ms, rpc_num: 1, rpc_time: 1.47ms, copr_cache: disabled}	data:Selection_124	248 Bytes	N/A
20:54:27 [2021-06-08T20:54:27.522Z]       │ │ │ │ │ └─Selection_124	1.00	1	cop[tikv]		tikv_task:{time:1ms, loops:1}, scan_detail: {total_process_keys: 25, total_keys: 26, rocksdb: {delete_skipped_count: 0, key_skipped_count: 46, block: {cache_hit_count: 17, read_count: 1, read_byte: 23.8 KB}}}	eq(tpch50.nation.n_name, "EGYPT")	N/A	N/A
20:54:27 [2021-06-08T20:54:27.522Z]       │ │ │ │ │   └─TableFullScan_123	25.00	25	cop[tikv]	table:nation	tikv_task:{time:1ms, loops:1}	keep order:false	N/A	N/A
20:54:27 [2021-06-08T20:54:27.522Z]       │ │ │ │ └─TableReader_122(Probe)	500000.00	500000	root		time:997.2ms, loops:490, cop_task: {num: 1, max: 997.7ms, proc_keys: 500000, tot_proc: 967ms, rpc_num: 1, rpc_time: 997.7ms, copr_cache: disabled}	data:TableFullScan_121	20.0 MB	N/A
20:54:27 [2021-06-08T20:54:27.522Z]       │ │ │ │   └─TableFullScan_121	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:912ms, loops:493}, scan_detail: {total_process_keys: 500000, total_keys: 500001, rocksdb: {delete_skipped_count: 0, key_skipped_count: 999999, block: {cache_hit_count: 13, read_count: 1679, read_byte: 104.5 MB}}}	keep order:false	N/A	N/A
20:54:27 [2021-06-08T20:54:27.522Z]       │ │ │ └─TableReader_128(Probe)	240004648.80	189670348	root		time:1m5.2s, loops:184598, cop_task: {num: 761, max: 3.13s, min: 277ms, avg: 1.5s, p95: 1.92s, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 17m51.6s, tot_wait: 1m0.4s, rpc_num: 761, rpc_time: 19m5.2s, copr_cache: disabled}	data:Selection_127	109.4 MB	N/A
20:54:27 [2021-06-08T20:54:27.522Z]       │ │ │   └─Selection_127	240004648.80	189670348	cop[tikv]		tikv_task:{proc max:1.3s, min:262ms, 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: 10454, read_count: 1114194, read_byte: 23.6 GB}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:54:27 [2021-06-08T20:54:27.522Z]       │ │ │     └─TableFullScan_126	300005811.00	300005811	cop[tikv]	table:l1	tikv_task:{proc max:1.23s, min:256ms, p80:1.07s, p95:1.12s, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:54:27 [2021-06-08T20:54:27.522Z]       │ │ └─TableReader_95(Probe)	0.49	3496174	root		time:1m38.9s, loops:3875, cop_task: {num: 5253, max: 532.8ms, min: 2.19ms, avg: 175.3ms, p95: 327.2ms, max_proc_keys: 3888, p95_proc_keys: 1954, tot_proc: 11m2s, tot_wait: 3m40.8s, rpc_num: 5253, rpc_time: 15m20.5s, copr_cache: disabled}	data:Selection_94	N/A	N/A
20:54:27 [2021-06-08T20:54:27.522Z]       │ │   └─Selection_94	0.49	3496174	cop[tikv]		tikv_task:{proc max:186ms, min:0s, p80:68ms, p95:81ms, iters:30197, tasks:5253}, scan_detail: {total_process_keys: 7236261, total_keys: 7795534, rocksdb: {delete_skipped_count: 0, key_skipped_count: 1778405, block: {cache_hit_count: 54006394, read_count: 218212, read_byte: 4.21 GB}}}	eq(tpch50.orders.o_orderstatus, "F")	N/A	N/A
20:54:27 [2021-06-08T20:54:27.522Z]       │ │     └─TableRangeScan_93	1.00	7236261	cop[tikv]	table:orders	tikv_task:{proc max:186ms, min:0s, p80:68ms, p95:81ms, iters:30197, tasks:5253}	range: decided by [tpch50.lineitem.l_orderkey], keep order:false	N/A	N/A
20:54:27 [2021-06-08T20:54:27.522Z]       │ └─IndexLookUp_80(Probe)	4.05	17316456	root		time:1m56.3s, loops:17129, index_task: {total_time: 1m3.6s, fetch_handle: 54.2s, build: 3ms, wait: 9.47s}, table_task: {total_time: 8m25.7s, num: 1458, concurrency: 760}		19.2 KB	N/A
20:54:27 [2021-06-08T20:54:27.522Z]       │   ├─IndexRangeScan_78(Build)	4.05	17316456	cop[tikv]	table:l2, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:51.9s, loops:18613, cop_task: {num: 2993, max: 617.3ms, min: 649.9µs, avg: 184.2ms, p95: 362.2ms, max_proc_keys: 15364, p95_proc_keys: 8670, tot_proc: 6m53.5s, tot_wait: 1m56.9s, rpc_num: 2993, rpc_time: 9m11.2s, copr_cache: disabled}, tikv_task:{proc max:185ms, min:0s, p80:95ms, p95:110ms, iters:30139, tasks:2993}, scan_detail: {total_process_keys: 17316456, total_keys: 20812560, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17316456, block: {cache_hit_count: 24259976, read_count: 225679, read_byte: 2.00 GB}}}	range: decided by [eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey)], keep order:false	N/A	N/A
20:54:27 [2021-06-08T20:54:27.522Z]       │   └─TableRowIDScan_79(Probe)	4.05	17316456	cop[tikv]	table:l2	time:6m16.6s, loops:21012, cop_task: {num: 7797, max: 646ms, min: 416.5µs, avg: 174.5ms, p95: 352.6ms, max_proc_keys: 10874, p95_proc_keys: 4868, tot_proc: 16m21.8s, tot_wait: 5m29.6s, rpc_num: 7797, rpc_time: 22m40.3s, copr_cache: disabled}, tikv_task:{proc max:255ms, min:0s, p80:104ms, p95:140ms, iters:49924, tasks:7797}, scan_detail: {total_process_keys: 17316456, total_keys: 18289183, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5627041, block: {cache_hit_count: 99024497, read_count: 1109, read_byte: 398.8 MB}}}	keep order:false	N/A	N/A
20:54:27 [2021-06-08T20:54:27.522Z]       └─IndexLookUp_39(Probe)	4.05	12022807	root		time:1m50.4s, loops:11947, index_task: {total_time: 59.8s, fetch_handle: 50.6s, build: 4.04ms, wait: 9.14s}, table_task: {total_time: 7m56.8s, num: 1408, concurrency: 730}		218.8 KB	N/A
20:54:27 [2021-06-08T20:54:27.522Z]         ├─IndexRangeScan_36(Build)	5.06	17183395	cop[tikv]	table:l3, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:48.2s, loops:18358, cop_task: {num: 2784, max: 665.4ms, min: 1.24ms, avg: 166.8ms, p95: 360ms, max_proc_keys: 18652, p95_proc_keys: 13598, tot_proc: 5m46.6s, tot_wait: 1m39.3s, rpc_num: 2784, rpc_time: 7m44.2s, copr_cache: disabled}, tikv_task:{proc max:174ms, min:0s, p80:78ms, p95:120ms, iters:29058, tasks:2784}, scan_detail: {total_process_keys: 17183395, total_keys: 20546423, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17183395, block: {cache_hit_count: 23554002, read_count: 0, read_byte: 0 Bytes}}}	range: decided by [eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey)], keep order:false	N/A	N/A
20:54:27 [2021-06-08T20:54:27.522Z]         └─Selection_38(Probe)	4.05	12022807	cop[tikv]		time:6m5.3s, loops:13785, cop_task: {num: 10165, max: 652.1ms, min: 409.6µs, avg: 167.9ms, p95: 338ms, max_proc_keys: 8014, p95_proc_keys: 3969, tot_proc: 19m59s, tot_wait: 7m22.8s, rpc_num: 10165, rpc_time: 28m26.2s, copr_cache: disabled}, tikv_task:{proc max:223ms, min:0s, p80:76ms, p95:115ms, iters:60410, tasks:10165}, scan_detail: {total_process_keys: 17183395, total_keys: 18128938, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5526719, block: {cache_hit_count: 98285863, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:54:27 [2021-06-08T20:54:27.522Z]           └─TableRowIDScan_37	5.06	17183395	cop[tikv]	table:l3	tikv_task:{proc max:221ms, min:0s, p80:76ms, p95:114ms, iters:60410, tasks:10165}	keep order:false	N/A	N/A
20:54:27 [2021-06-08T20:54:27.815Z] + sync
20:54:27 [2021-06-08T20:54:27.815Z] + /usr/bin/echo 3
20:56:04 [2021-06-08T20:56:04.511Z] 
20:56:04 [2021-06-08T20:56:04.511Z] queries/21.sql
20:56:04 [2021-06-08T20:56:04.511Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:56:04 [2021-06-08T20:56:04.511Z] 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:56:04 [2021-06-08T20:56:04.511Z] └─TopN_29	100.00	100	root		time:1m19.9s, loops:2	Column#72:desc, tpch50.supplier.s_name, offset:0, count:100	55.9 KB	N/A
20:56:04 [2021-06-08T20:56:04.511Z]   └─HashAgg_34	12800.00	20057	root		time:1m19.9s, loops:21, partial_worker:{wall_time:1m19.867213371s, concurrency:5, task_num:198, tot_wait:6m39.079175582s, tot_exec:244.693401ms, tot_time:6m39.33482173s, max:1m19.867193978s, p95:1m19.867193978s}, final_worker:{wall_time:1m19.883081817s, concurrency:5, task_num:25, tot_wait:6m39.334320016s, tot_exec:74.187888ms, tot_time:6m39.408522172s, max:1m19.883072303s, p95:1m19.883072303s}	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:56:04 [2021-06-08T20:56:04.511Z]     └─IndexHashJoin_42	7828961.66	198698	root		time:1m19.9s, loops:199, inner:{total:2m18.4s, concurrency:5, task:147, construct:6.49s, fetch:1m56s, build:1.19s, join:15.9s}	anti semi join, inner:IndexLookUp_39, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey)	641.1 MB	N/A
20:56:04 [2021-06-08T20:56:04.511Z]       ├─IndexHashJoin_83(Build)	9786202.08	3542799	root		time:1m19.3s, loops:3464, inner:{total:2m28.2s, concurrency:5, task:152, construct:7.77s, fetch:2m3.2s, build:1.18s, join:17.2s}	semi join, inner:IndexLookUp_80, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey), ne(tpch50.lineitem.l_suppkey, tpch50.supplier.s_suppkey)	555.9 MB	N/A
20:56:04 [2021-06-08T20:56:04.511Z]       │ ├─IndexJoin_99(Build)	12232752.60	3675878	root		time:1m18.7s, loops:3595, inner:{total:2m6.7s, concurrency:5, task:305, construct:16.2s, fetch:1m48.6s, build:1.89s}, probe:5.44s	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:56:04 [2021-06-08T20:56:04.511Z]       │ │ ├─HashJoin_107(Build)	12232752.60	7609895	root		time:1m18.2s, loops:7437, build_hash_table:{total:1.17s, fetch:1.16s, build:6.73ms}, probe:{concurrency:5, total:6m32.5s, max:1m18.5s, probe:1m2.2s, fetch:5m30.3s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.lineitem.l_suppkey)]	752.5 KB	0 Bytes
20:56:04 [2021-06-08T20:56:04.511Z]       │ │ │ ├─HashJoin_120(Build)	20000.00	20058	root		time:1.17s, loops:23, build_hash_table:{total:191.3µs, fetch:186.2µs, build:5.07µs}, probe:{concurrency:5, total:5.84s, max:1.17s, probe:68.7ms, fetch:5.77s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:56:04 [2021-06-08T20:56:04.511Z]       │ │ │ │ ├─TableReader_125(Build)	1.00	1	root		time:47.3µs, loops:2, cop_task: {num: 1, max: 1.32ms, proc_keys: 25, tot_proc: 1ms, rpc_num: 1, rpc_time: 1.29ms, copr_cache: disabled}	data:Selection_124	248 Bytes	N/A
20:56:04 [2021-06-08T20:56:04.511Z]       │ │ │ │ │ └─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:56:04 [2021-06-08T20:56:04.511Z]       │ │ │ │ │   └─TableFullScan_123	25.00	25	cop[tikv]	table:nation	tikv_task:{time:1ms, loops:1}	keep order:false	N/A	N/A
20:56:04 [2021-06-08T20:56:04.511Z]       │ │ │ │ └─TableReader_122(Probe)	500000.00	500000	root		time:1.15s, loops:490, cop_task: {num: 1, max: 1.16s, proc_keys: 500000, tot_proc: 1.12s, rpc_num: 1, rpc_time: 1.16s, copr_cache: disabled}	data:TableFullScan_121	20.0 MB	N/A
20:56:04 [2021-06-08T20:56:04.511Z]       │ │ │ │   └─TableFullScan_121	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:1.06s, loops:493}, scan_detail: {total_process_keys: 500000, total_keys: 500001, rocksdb: {delete_skipped_count: 0, key_skipped_count: 999999, block: {cache_hit_count: 13, read_count: 1679, read_byte: 104.5 MB}}}	keep order:false	N/A	N/A
20:56:04 [2021-06-08T20:56:04.511Z]       │ │ │ └─TableReader_128(Probe)	240004648.80	189670348	root		time:1m5.3s, loops:184596, cop_task: {num: 761, max: 2.67s, min: 262.6ms, avg: 1.51s, p95: 1.97s, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 17m55.1s, tot_wait: 1m0.7s, rpc_num: 761, rpc_time: 19m9.2s, copr_cache: disabled}	data:Selection_127	109.4 MB	N/A
20:56:04 [2021-06-08T20:56:04.511Z]       │ │ │   └─Selection_127	240004648.80	189670348	cop[tikv]		tikv_task:{proc max:1.34s, min:249ms, p80:1.15s, p95:1.19s, iters:296606, tasks:761}, scan_detail: {total_process_keys: 300005811, total_keys: 300006572, rocksdb: {delete_skipped_count: 0, key_skipped_count: 600010861, block: {cache_hit_count: 10453, read_count: 1114195, read_byte: 23.6 GB}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:56:04 [2021-06-08T20:56:04.511Z]       │ │ │     └─TableFullScan_126	300005811.00	300005811	cop[tikv]	table:l1	tikv_task:{proc max:1.26s, min:238ms, p80:1.07s, p95:1.11s, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:56:04 [2021-06-08T20:56:04.511Z]       │ │ └─TableReader_95(Probe)	0.49	3496181	root		time:1m39.8s, loops:3875, cop_task: {num: 5257, max: 610.3ms, min: 1.84ms, avg: 178.7ms, p95: 335.9ms, max_proc_keys: 4066, p95_proc_keys: 1963, tot_proc: 11m13.2s, tot_wait: 3m46.8s, rpc_num: 5257, rpc_time: 15m39.1s, copr_cache: disabled}	data:Selection_94	N/A	N/A
20:56:04 [2021-06-08T20:56:04.511Z]       │ │   └─Selection_94	0.49	3496181	cop[tikv]		tikv_task:{proc max:188ms, min:0s, p80:68ms, p95:82ms, iters:30169, tasks:5257}, scan_detail: {total_process_keys: 7236281, total_keys: 7795499, rocksdb: {delete_skipped_count: 0, key_skipped_count: 1778330, block: {cache_hit_count: 54005926, read_count: 218301, read_byte: 4.21 GB}}}	eq(tpch50.orders.o_orderstatus, "F")	N/A	N/A
20:56:04 [2021-06-08T20:56:04.511Z]       │ │     └─TableRangeScan_93	1.00	7236281	cop[tikv]	table:orders	tikv_task:{proc max:187ms, min:0s, p80:68ms, p95:81ms, iters:30169, tasks:5257}	range: decided by [tpch50.lineitem.l_orderkey], keep order:false	N/A	N/A
20:56:04 [2021-06-08T20:56:04.511Z]       │ └─IndexLookUp_80(Probe)	4.05	17316484	root		time:1m57.9s, loops:17129, index_task: {total_time: 1m5.7s, fetch_handle: 58.1s, build: 3.03ms, wait: 7.55s}, table_task: {total_time: 8m29.8s, num: 1458, concurrency: 760}		17.0 KB	N/A
20:56:04 [2021-06-08T20:56:04.511Z]       │   ├─IndexRangeScan_78(Build)	4.05	17316484	cop[tikv]	table:l2, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:55.8s, loops:18636, cop_task: {num: 3015, max: 770.6ms, min: 568.6µs, avg: 191ms, p95: 387.7ms, max_proc_keys: 12989, p95_proc_keys: 8762, tot_proc: 7m10.3s, tot_wait: 2m5.3s, rpc_num: 3015, rpc_time: 9m35.8s, copr_cache: disabled}, tikv_task:{proc max:173ms, min:0s, p80:95ms, p95:110ms, iters:30174, tasks:3015}, scan_detail: {total_process_keys: 17316484, total_keys: 20812588, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17316484, block: {cache_hit_count: 24259972, read_count: 225683, 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:56:04 [2021-06-08T20:56:04.511Z]       │   └─TableRowIDScan_79(Probe)	4.05	17316484	cop[tikv]	table:l2	time:6m15.4s, loops:20977, cop_task: {num: 7813, max: 958ms, min: 538.8µs, avg: 174.7ms, p95: 353ms, max_proc_keys: 10207, p95_proc_keys: 4890, tot_proc: 16m19.7s, tot_wait: 5m36.2s, rpc_num: 7813, rpc_time: 22m44.5s, copr_cache: disabled}, tikv_task:{proc max:263ms, min:0s, p80:103ms, p95:142ms, iters:49923, tasks:7813}, scan_detail: {total_process_keys: 17316484, total_keys: 18290325, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5632223, block: {cache_hit_count: 99018823, read_count: 1125, read_byte: 409.9 MB}}}	keep order:false	N/A	N/A
20:56:04 [2021-06-08T20:56:04.511Z]       └─IndexLookUp_39(Probe)	4.05	12022819	root		time:1m51.1s, loops:11943, index_task: {total_time: 58.8s, fetch_handle: 48.6s, build: 3.12ms, wait: 10.2s}, table_task: {total_time: 7m58.1s, num: 1410, concurrency: 735}		211.0 KB	N/A
20:56:04 [2021-06-08T20:56:04.511Z]         ├─IndexRangeScan_36(Build)	5.06	17183399	cop[tikv]	table:l3, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:46.2s, loops:18347, cop_task: {num: 2775, max: 696.1ms, min: 505.9µs, avg: 164.8ms, p95: 347.3ms, max_proc_keys: 17538, p95_proc_keys: 13915, tot_proc: 5m38.9s, tot_wait: 1m38.6s, rpc_num: 2775, rpc_time: 7m37.3s, copr_cache: disabled}, tikv_task:{proc max:196ms, min:0s, p80:79ms, p95:121ms, iters:29030, tasks:2775}, scan_detail: {total_process_keys: 17183399, total_keys: 20546424, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17183399, 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:56:04 [2021-06-08T20:56:04.511Z]         └─Selection_38(Probe)	4.05	12022819	cop[tikv]		time:6m6.3s, loops:13788, cop_task: {num: 10239, max: 718ms, min: 515.5µs, avg: 171.2ms, p95: 347.9ms, max_proc_keys: 7663, p95_proc_keys: 3955, tot_proc: 20m27.2s, tot_wait: 7m40.3s, rpc_num: 10239, rpc_time: 29m12.6s, copr_cache: disabled}, tikv_task:{proc max:234ms, min:0s, p80:75ms, p95:114ms, iters:60673, tasks:10239}, scan_detail: {total_process_keys: 17183399, total_keys: 18128686, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5525229, block: {cache_hit_count: 98287718, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:56:04 [2021-06-08T20:56:04.511Z]           └─TableRowIDScan_37	5.06	17183399	cop[tikv]	table:l3	tikv_task:{proc max:231ms, min:0s, p80:74ms, p95:113ms, iters:60673, tasks:10239}	keep order:false	N/A	N/A
20:56:04 [2021-06-08T20:56:04.511Z] + sync
20:56:04 [2021-06-08T20:56:04.511Z] + /usr/bin/echo 3
20:57:25 [2021-06-08T20:57:25.944Z] 
20:57:25 [2021-06-08T20:57:25.944Z] queries/21.sql
20:57:25 [2021-06-08T20:57:25.944Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:57:25 [2021-06-08T20:57:25.944Z] Projection_26	100.00	100	root		time:1m20.1s, loops:2, Concurrency:OFF	tpch50.supplier.s_name, Column#72	4.62 KB	N/A
20:57:25 [2021-06-08T20:57:25.944Z] └─TopN_29	100.00	100	root		time:1m20.1s, loops:2	Column#72:desc, tpch50.supplier.s_name, offset:0, count:100	58.4 KB	N/A
20:57:25 [2021-06-08T20:57:25.944Z]   └─HashAgg_34	12800.00	20057	root		time:1m20.1s, loops:21, partial_worker:{wall_time:1m20.103570175s, concurrency:5, task_num:195, tot_wait:6m40.272468567s, tot_exec:231.97647ms, tot_time:6m40.516755662s, max:1m20.103543393s, p95:1m20.103543393s}, final_worker:{wall_time:1m20.119600611s, concurrency:5, task_num:25, tot_wait:6m40.515259084s, tot_exec:74.777493ms, tot_time:6m40.590048137s, max:1m20.119579036s, p95:1m20.119579036s}	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:57:25 [2021-06-08T20:57:25.944Z]     └─IndexHashJoin_42	7828961.66	198698	root		time:1m20.1s, loops:196, inner:{total:2m17.7s, concurrency:5, task:146, construct:6.4s, fetch:1m55.4s, build:1.16s, join:16s}	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:57:25 [2021-06-08T20:57:25.944Z]       ├─IndexHashJoin_83(Build)	9786202.08	3542799	root		time:1m19.6s, loops:3463, inner:{total:2m27.4s, concurrency:5, task:152, construct:7.6s, fetch:2m2.7s, build:1.22s, join:17.1s}	semi join, inner:IndexLookUp_80, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey), ne(tpch50.lineitem.l_suppkey, tpch50.supplier.s_suppkey)	555.9 MB	N/A
20:57:25 [2021-06-08T20:57:25.944Z]       │ ├─IndexJoin_99(Build)	12232752.60	3675878	root		time:1m19s, loops:3595, inner:{total:2m6.3s, concurrency:5, task:305, construct:16.4s, fetch:1m48.1s, build:1.78s}, 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:57:25 [2021-06-08T20:57:25.944Z]       │ │ ├─HashJoin_107(Build)	12232752.60	7609895	root		time:1m18.3s, loops:7436, build_hash_table:{total:1.03s, fetch:1.03s, build:5.75ms}, probe:{concurrency:5, total:6m33.7s, max:1m18.7s, probe:1m1.8s, fetch:5m31.9s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.lineitem.l_suppkey)]	757.3 KB	0 Bytes
20:57:25 [2021-06-08T20:57:25.944Z]       │ │ │ ├─HashJoin_120(Build)	20000.00	20058	root		time:1.03s, loops:23, build_hash_table:{total:160µs, fetch:154.7µs, build:5.25µs}, probe:{concurrency:5, total:5.16s, max:1.03s, probe:60.4ms, fetch:5.09s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:57:25 [2021-06-08T20:57:25.944Z]       │ │ │ │ ├─TableReader_125(Build)	1.00	1	root		time:49.4µs, loops:2, cop_task: {num: 1, max: 1.41ms, proc_keys: 25, rpc_num: 1, rpc_time: 1.4ms, copr_cache: disabled}	data:Selection_124	240 Bytes	N/A
20:57:25 [2021-06-08T20:57:25.944Z]       │ │ │ │ │ └─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:57:25 [2021-06-08T20:57:25.944Z]       │ │ │ │ │   └─TableFullScan_123	25.00	25	cop[tikv]	table:nation	tikv_task:{time:0s, loops:1}	keep order:false	N/A	N/A
20:57:25 [2021-06-08T20:57:25.944Z]       │ │ │ │ └─TableReader_122(Probe)	500000.00	500000	root		time:1.02s, loops:490, cop_task: {num: 1, max: 1.02s, proc_keys: 500000, tot_proc: 988ms, rpc_num: 1, rpc_time: 1.02s, copr_cache: disabled}	data:TableFullScan_121	20.0 MB	N/A
20:57:25 [2021-06-08T20:57:25.944Z]       │ │ │ │   └─TableFullScan_121	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:943ms, loops:493}, scan_detail: {total_process_keys: 500000, total_keys: 500001, rocksdb: {delete_skipped_count: 0, key_skipped_count: 999999, block: {cache_hit_count: 13, read_count: 1679, read_byte: 104.5 MB}}}	keep order:false	N/A	N/A
20:57:25 [2021-06-08T20:57:25.944Z]       │ │ │ └─TableReader_128(Probe)	240004648.80	189670348	root		time:1m5.9s, loops:184598, cop_task: {num: 761, max: 2.9s, min: 291.7ms, avg: 1.51s, p95: 2s, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 18m1.4s, tot_wait: 57.3s, rpc_num: 761, rpc_time: 19m12.4s, copr_cache: disabled}	data:Selection_127	109.4 MB	N/A
20:57:25 [2021-06-08T20:57:25.944Z]       │ │ │   └─Selection_127	240004648.80	189670348	cop[tikv]		tikv_task:{proc max:1.29s, min:277ms, p80:1.15s, p95:1.2s, iters:296606, tasks:761}, scan_detail: {total_process_keys: 300005811, total_keys: 300006572, rocksdb: {delete_skipped_count: 0, key_skipped_count: 600010861, block: {cache_hit_count: 10451, read_count: 1114197, read_byte: 23.6 GB}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:57:25 [2021-06-08T20:57:25.944Z]       │ │ │     └─TableFullScan_126	300005811.00	300005811	cop[tikv]	table:l1	tikv_task:{proc max:1.21s, min:251ms, p80:1.07s, p95:1.12s, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:57:25 [2021-06-08T20:57:25.944Z]       │ │ └─TableReader_95(Probe)	0.49	3496190	root		time:1m39.2s, loops:3875, cop_task: {num: 5261, max: 587.1ms, min: 832.7µs, avg: 176.4ms, p95: 345.2ms, max_proc_keys: 3570, p95_proc_keys: 1968, tot_proc: 11m9.9s, tot_wait: 3m38.8s, rpc_num: 5261, rpc_time: 15m28s, copr_cache: disabled}	data:Selection_94	N/A	N/A
20:57:25 [2021-06-08T20:57:25.944Z]       │ │   └─Selection_94	0.49	3496190	cop[tikv]		tikv_task:{proc max:128ms, min:0s, p80:68ms, p95:81ms, iters:30245, tasks:5261}, scan_detail: {total_process_keys: 7236285, total_keys: 7795503, rocksdb: {delete_skipped_count: 0, key_skipped_count: 1778302, block: {cache_hit_count: 54006737, read_count: 217979, read_byte: 4.21 GB}}}	eq(tpch50.orders.o_orderstatus, "F")	N/A	N/A
20:57:25 [2021-06-08T20:57:25.944Z]       │ │     └─TableRangeScan_93	1.00	7236285	cop[tikv]	table:orders	tikv_task:{proc max:126ms, min:0s, p80:68ms, p95:80ms, iters:30245, tasks:5261}	range: decided by [tpch50.lineitem.l_orderkey], keep order:false	N/A	N/A
20:57:25 [2021-06-08T20:57:25.944Z]       │ └─IndexLookUp_80(Probe)	4.05	17316480	root		time:1m57.5s, loops:17134, index_task: {total_time: 1m5.5s, fetch_handle: 56.7s, build: 3.02ms, wait: 8.78s}, table_task: {total_time: 8m26.2s, num: 1458, concurrency: 760}		28.4 KB	N/A
20:57:25 [2021-06-08T20:57:25.944Z]       │   ├─IndexRangeScan_78(Build)	4.05	17316480	cop[tikv]	table:l2, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:54.4s, loops:18660, cop_task: {num: 2967, max: 726.2ms, min: 697.4µs, avg: 185ms, p95: 389.9ms, max_proc_keys: 12762, p95_proc_keys: 8765, tot_proc: 6m57.6s, tot_wait: 1m50.4s, rpc_num: 2967, rpc_time: 9m8.7s, copr_cache: disabled}, tikv_task:{proc max:178ms, min:0s, p80:96ms, p95:110ms, iters:30089, tasks:2967}, scan_detail: {total_process_keys: 17316480, total_keys: 20812585, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17316480, block: {cache_hit_count: 24259986, 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:57:25 [2021-06-08T20:57:25.944Z]       │   └─TableRowIDScan_79(Probe)	4.05	17316480	cop[tikv]	table:l2	time:6m17.2s, loops:21025, cop_task: {num: 7811, max: 617.8ms, min: 387.4µs, avg: 177.9ms, p95: 362.2ms, max_proc_keys: 12685, p95_proc_keys: 4829, tot_proc: 16m41.7s, tot_wait: 5m37s, rpc_num: 7811, rpc_time: 23m9.5s, copr_cache: disabled}, tikv_task:{proc max:261ms, min:0s, p80:103ms, p95:141ms, iters:49866, tasks:7811}, scan_detail: {total_process_keys: 17316480, total_keys: 18291152, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5635222, block: {cache_hit_count: 99013285, read_count: 1111, read_byte: 393.1 MB}}}	keep order:false	N/A	N/A
20:57:25 [2021-06-08T20:57:25.944Z]       └─IndexLookUp_39(Probe)	4.05	12022812	root		time:1m50.7s, loops:11945, index_task: {total_time: 59.4s, fetch_handle: 49.5s, build: 2.96ms, wait: 9.88s}, table_task: {total_time: 7m57.3s, num: 1408, concurrency: 730}		218.8 KB	N/A
20:57:25 [2021-06-08T20:57:25.944Z]         ├─IndexRangeScan_36(Build)	5.06	17183412	cop[tikv]	table:l3, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:47.2s, loops:18384, cop_task: {num: 2776, max: 747.1ms, min: 1.04ms, avg: 166.4ms, p95: 363.2ms, max_proc_keys: 22020, p95_proc_keys: 13610, tot_proc: 5m44.3s, tot_wait: 1m37.7s, rpc_num: 2776, rpc_time: 7m42s, copr_cache: disabled}, tikv_task:{proc max:197ms, min:0s, p80:78ms, p95:117ms, iters:29103, tasks:2776}, scan_detail: {total_process_keys: 17183412, total_keys: 20546440, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17183412, block: {cache_hit_count: 23554002, read_count: 0, read_byte: 0 Bytes}}}	range: decided by [eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey)], keep order:false	N/A	N/A
20:57:25 [2021-06-08T20:57:25.944Z]         └─Selection_38(Probe)	4.05	12022812	cop[tikv]		time:6m7.3s, loops:13752, cop_task: {num: 10228, max: 722.3ms, min: 383.1µs, avg: 171.4ms, p95: 355.3ms, max_proc_keys: 7428, p95_proc_keys: 3986, tot_proc: 20m30.6s, tot_wait: 7m39.1s, rpc_num: 10228, rpc_time: 29m12.4s, copr_cache: disabled}, tikv_task:{proc max:224ms, min:0s, p80:76ms, p95:116ms, iters:60423, tasks:10228}, scan_detail: {total_process_keys: 17183412, total_keys: 18129591, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5528533, block: {cache_hit_count: 98289428, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:57:25 [2021-06-08T20:57:25.944Z]           └─TableRowIDScan_37	5.06	17183412	cop[tikv]	table:l3	tikv_task:{proc max:223ms, min:0s, p80:76ms, p95:115ms, iters:60423, tasks:10228}	keep order:false	N/A	N/A
20:57:25 [2021-06-08T20:57:25.944Z] + tiup cluster stop benchbot -y
20:57:25 [2021-06-08T20:57:25.944Z] Starting component `cluster`: /home/tidb/.tiup/components/cluster/v1.4.4/tiup-cluster stop benchbot -y
20:57:31 [2021-06-08T20:57:31.187Z] + rm -rf '/data1/tidb-deploy/*/log/*'
20:57:31 [2021-06-08T20:57:31.187Z] + rm -rf /data1/jenkins/deploy/data/tikv-20160
20:57:36 [2021-06-08T20:57:36.428Z] + rm -rf /data1/jenkins/deploy/data/pd-2379
20:57:36 [2021-06-08T20:57:36.428Z] + rm -rf /data1/jenkins/restore_data/tpch50/data/last_tikv.toml
20:57:36 [2021-06-08T20:57:36.428Z] + cp -R /data1/jenkins/restore_data/tpch50/data /data1/jenkins/deploy/data/tikv-20160
20:59:27 [2021-06-08T20:59:27.838Z] + cp -R /data1/jenkins/restore_data/tpch50/data.pd /data1/jenkins/deploy/data/pd-2379
20:59:27 [2021-06-08T20:59:27.839Z] + '[' -n '' ']'
20:59:27 [2021-06-08T20:59:27.839Z] + tiup cluster start benchbot --wait-timeout=300
20:59:27 [2021-06-08T20:59:27.839Z] Starting component `cluster`: /home/tidb/.tiup/components/cluster/v1.4.4/tiup-cluster start benchbot --wait-timeout=300
20:59:49 [2021-06-08T20:59:49.723Z] + sync
20:59:49 [2021-06-08T20:59:49.723Z] + /usr/bin/echo 3
21:00:28 [2021-06-08T21:00:28.380Z] + sync
21:00:28 [2021-06-08T21:00:28.380Z] + /usr/bin/echo 3
21:00:54 [2021-06-08T21:00:54.915Z] + sync
21:00:54 [2021-06-08T21:00:54.915Z] + /usr/bin/echo 3
21:01:26 [2021-06-08T21:01:26.943Z] 
21:01:26 [2021-06-08T21:01:26.943Z] queries/22.sql
21:01:26 [2021-06-08T21:01:26.943Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
21:01:26 [2021-06-08T21:01:26.943Z] Sort_39	1600000.00	4	root		time:26.1s, loops:2	Column#27	9.48 KB	0 Bytes
21:01:26 [2021-06-08T21:01:26.943Z] └─Projection_41	1600000.00	4	root		time:26.1s, loops:5, Concurrency:5	Column#27, Column#28, Column#29	23.7 KB	N/A
21:01:26 [2021-06-08T21:01:26.943Z]   └─HashAgg_42	1600000.00	4	root		time:26.1s, loops:5, partial_worker:{wall_time:26.12894654s, concurrency:5, task_num:179, tot_wait:2m10.591561066s, tot_exec:51.74425ms, tot_time:2m10.64344408s, max:26.128874772s, p95:26.128874772s}, final_worker:{wall_time:26.128961745s, concurrency:5, task_num:20, tot_wait:2m10.644261602s, tot_exec:198.881µs, tot_time:2m10.644468167s, max:26.128898701s, p95:26.128898701s}	group by:Column#33, funcs:count(1)->Column#28, funcs:sum(Column#31)->Column#29, funcs:firstrow(Column#32)->Column#27	857.7 KB	N/A
21:01:26 [2021-06-08T21:01:26.943Z]     └─Projection_51	1600000.00	181704	root		time:26.1s, loops:180, Concurrency:5	tpch50.customer.c_acctbal, substring(tpch50.customer.c_phone, 1, 2)->Column#32, substring(tpch50.customer.c_phone, 1, 2)->Column#33	693.6 KB	N/A
21:01:26 [2021-06-08T21:01:26.943Z]       └─HashJoin_43	1600000.00	181704	root		time:26.1s, loops:180, build_hash_table:{total:24.5s, fetch:1.09s, build:23.4s}, probe:{concurrency:5, total:2m10.6s, max:26.1s, probe:6.67s, fetch:2m4s}	anti semi join, equal:[eq(tpch50.customer.c_custkey, tpch50.orders.o_custkey)]	590.2 MB	0 Bytes
21:01:26 [2021-06-08T21:01:26.943Z]         ├─TableReader_49(Build)	75000000.00	75000000	root		time:1.09s, loops:73364, cop_task: {num: 153, max: 961.7ms, min: 266.6ms, avg: 586.2ms, p95: 877.8ms, max_proc_keys: 723875, p95_proc_keys: 553332, tot_proc: 1m28.9s, tot_wait: 32ms, rpc_num: 153, rpc_time: 1m29.7s, copr_cache: disabled}	data:TableFullScan_48	57.8 MB	N/A
21:01:26 [2021-06-08T21:01:26.943Z]         │ └─TableFullScan_48	75000000.00	75000000	cop[tikv]	table:orders	tikv_task:{proc max:934ms, min:255ms, p80:607ms, p95:844ms, iters:73975, tasks:153}, scan_detail: {total_process_keys: 75000000, total_keys: 75000153, rocksdb: {delete_skipped_count: 0, key_skipped_count: 149999847, block: {cache_hit_count: 3032, read_count: 219921, read_byte: 4.30 GB}}}	keep order:false	N/A	N/A
21:01:26 [2021-06-08T21:01:26.943Z]         └─Selection_47(Probe)	2000000.00	545246	root		time:1.47s, loops:534	in(substring(tpch50.customer.c_phone, 1, 2), "20", "40", "22", "30", "39", "42", "21")	94.6 KB	N/A
21:01:26 [2021-06-08T21:01:26.943Z]           └─TableReader_46	2000000.00	3407619	root		time:653.8ms, loops:3319, cop_task: {num: 18, max: 1.03s, min: 481.1ms, avg: 735.4ms, p95: 1.03s, max_proc_keys: 582617, p95_proc_keys: 582617, tot_proc: 12.8s, tot_wait: 4ms, rpc_num: 18, rpc_time: 13.2s, copr_cache: disabled}	data:Selection_45	192.5 MB	N/A
21:01:26 [2021-06-08T21:01:26.943Z]             └─Selection_45	2000000.00	3407619	cop[tikv]		tikv_task:{proc max:967ms, min:450ms, p80:785ms, p95:967ms, iters:7404, tasks:18}, scan_detail: {total_process_keys: 7500000, total_keys: 7500018, rocksdb: {delete_skipped_count: 0, key_skipped_count: 14999982, block: {cache_hit_count: 28451, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.customer.c_acctbal, 5000.602894)	N/A	N/A
21:01:26 [2021-06-08T21:01:26.943Z]               └─TableFullScan_44	7500000.00	7500000	cop[tikv]	table:customer	tikv_task:{proc max:879ms, min:409ms, p80:714ms, p95:879ms, iters:7404, tasks:18}	keep order:false	N/A	N/A
21:01:26 [2021-06-08T21:01:26.943Z] 
21:01:26 [2021-06-08T21:01:26.943Z] queries/22.sql
21:01:26 [2021-06-08T21:01:26.943Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
21:01:26 [2021-06-08T21:01:26.943Z] Sort_39	2186432.06	4	root		time:26s, loops:2	Column#27	9.48 KB	0 Bytes
21:01:26 [2021-06-08T21:01:26.943Z] └─Projection_41	2186432.06	4	root		time:26s, loops:5, Concurrency:5	Column#27, Column#28, Column#29	23.7 KB	N/A
21:01:26 [2021-06-08T21:01:26.943Z]   └─HashAgg_42	2186432.06	4	root		time:26s, loops:5, partial_worker:{wall_time:26.003371919s, concurrency:5, task_num:181, tot_wait:2m9.965648711s, tot_exec:49.953822ms, tot_time:2m10.015730837s, max:26.003256592s, p95:26.003256592s}, final_worker:{wall_time:26.003388894s, concurrency:5, task_num:20, tot_wait:2m10.015910405s, tot_exec:209.29µs, tot_time:2m10.016125587s, max:26.003235566s, p95:26.003235566s}	group by:Column#33, funcs:count(1)->Column#28, funcs:sum(Column#31)->Column#29, funcs:firstrow(Column#32)->Column#27	857.7 KB	N/A
21:01:26 [2021-06-08T21:01:26.943Z]     └─Projection_51	2186432.06	181704	root		time:26s, 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:01:26 [2021-06-08T21:01:26.943Z]       └─HashJoin_43	2186432.06	181704	root		time:26s, loops:182, build_hash_table:{total:24.6s, fetch:914.5ms, build:23.7s}, probe:{concurrency:5, total:2m10s, max:26s, probe:5.58s, fetch:2m4.4s}	anti semi join, equal:[eq(tpch50.customer.c_custkey, tpch50.orders.o_custkey)]	590.2 MB	0 Bytes
21:01:26 [2021-06-08T21:01:26.943Z]         ├─TableReader_49(Build)	75000000.00	75000000	root		time:946.8ms, loops:73364, cop_task: {num: 153, max: 1.1s, min: 260.3ms, avg: 507ms, p95: 894.2ms, max_proc_keys: 723875, p95_proc_keys: 553332, tot_proc: 1m16.8s, tot_wait: 36ms, rpc_num: 153, rpc_time: 1m17.6s, copr_cache: disabled}	data:TableFullScan_48	57.8 MB	N/A
21:01:26 [2021-06-08T21:01:26.943Z]         │ └─TableFullScan_48	75000000.00	75000000	cop[tikv]	table:orders	tikv_task:{proc max:1.06s, min:250ms, p80:501ms, p95:865ms, iters:73975, tasks:153}, scan_detail: {total_process_keys: 75000000, total_keys: 75000153, rocksdb: {delete_skipped_count: 0, key_skipped_count: 149999847, block: {cache_hit_count: 220923, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
21:01:26 [2021-06-08T21:01:26.943Z]         └─Selection_47(Probe)	2733040.07	545246	root		time:1.48s, loops:534	in(substring(tpch50.customer.c_phone, 1, 2), "20", "40", "22", "30", "39", "42", "21")	94.6 KB	N/A
21:01:26 [2021-06-08T21:01:26.943Z]           └─TableReader_46	2733040.07	3407619	root		time:667.8ms, loops:3319, cop_task: {num: 18, max: 1.09s, min: 513.3ms, avg: 888.3ms, p95: 1.09s, max_proc_keys: 582617, p95_proc_keys: 582617, tot_proc: 15.4s, rpc_num: 18, rpc_time: 16s, copr_cache: disabled}	data:Selection_45	192.5 MB	N/A
21:01:26 [2021-06-08T21:01:26.943Z]             └─Selection_45	2733040.07	3407619	cop[tikv]		tikv_task:{proc max:1.02s, min:465ms, p80:1.01s, p95:1.02s, iters:7404, tasks:18}, scan_detail: {total_process_keys: 7500000, total_keys: 7500018, rocksdb: {delete_skipped_count: 0, key_skipped_count: 14999982, block: {cache_hit_count: 28451, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.customer.c_acctbal, 5000.602894)	N/A	N/A
21:01:26 [2021-06-08T21:01:26.943Z]               └─TableFullScan_44	7500000.00	7500000	cop[tikv]	table:customer	tikv_task:{proc max:946ms, min:421ms, p80:911ms, p95:946ms, iters:7404, tasks:18}	keep order:false	N/A	N/A
21:01:26 [2021-06-08T21:01:26.943Z] 
21:01:26 [2021-06-08T21:01:26.943Z] queries/22.sql
21:01:26 [2021-06-08T21:01:26.943Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
21:01:26 [2021-06-08T21:01:26.943Z] Sort_39	2186432.06	4	root		time:26.2s, loops:2	Column#27	9.48 KB	0 Bytes
21:01:26 [2021-06-08T21:01:26.943Z] └─Projection_41	2186432.06	4	root		time:26.2s, loops:5, Concurrency:5	Column#27, Column#28, Column#29	23.7 KB	N/A
21:01:26 [2021-06-08T21:01:26.943Z]   └─HashAgg_42	2186432.06	4	root		time:26.2s, loops:5, partial_worker:{wall_time:26.248501401s, concurrency:5, task_num:180, tot_wait:2m11.190709325s, tot_exec:50.567301ms, tot_time:2m11.241439661s, max:26.248470053s, p95:26.248470053s}, final_worker:{wall_time:26.248506852s, concurrency:5, task_num:20, tot_wait:2m11.242101865s, tot_exec:345.893µs, tot_time:2m11.242454722s, max:26.248495624s, p95:26.248495624s}	group by:Column#33, funcs:count(1)->Column#28, funcs:sum(Column#31)->Column#29, funcs:firstrow(Column#32)->Column#27	857.7 KB	N/A
21:01:26 [2021-06-08T21:01:26.943Z]     └─Projection_51	2186432.06	181704	root		time:26.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
21:01:26 [2021-06-08T21:01:26.944Z]       └─HashJoin_43	2186432.06	181704	root		time:26.2s, loops:181, build_hash_table:{total:24.8s, fetch:848.3ms, build:24s}, probe:{concurrency:5, total:2m11.2s, max:26.2s, probe:5.99s, fetch:2m5.2s}	anti semi join, equal:[eq(tpch50.customer.c_custkey, tpch50.orders.o_custkey)]	590.2 MB	0 Bytes
21:01:26 [2021-06-08T21:01:26.944Z]         ├─TableReader_49(Build)	75000000.00	75000000	root		time:885.7ms, loops:73364, cop_task: {num: 153, max: 971ms, min: 218.2ms, avg: 490.2ms, p95: 857.3ms, max_proc_keys: 723875, p95_proc_keys: 553332, tot_proc: 1m14.1s, tot_wait: 28ms, rpc_num: 153, rpc_time: 1m15s, copr_cache: disabled}	data:TableFullScan_48	57.8 MB	N/A
21:01:26 [2021-06-08T21:01:26.944Z]         │ └─TableFullScan_48	75000000.00	75000000	cop[tikv]	table:orders	tikv_task:{proc max:884ms, min:207ms, p80:495ms, p95:818ms, iters:73975, tasks:153}, scan_detail: {total_process_keys: 75000000, total_keys: 75000153, rocksdb: {delete_skipped_count: 0, key_skipped_count: 149999847, block: {cache_hit_count: 220923, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
21:01:26 [2021-06-08T21:01:26.944Z]         └─Selection_47(Probe)	2733040.07	545246	root		time:1.38s, loops:534	in(substring(tpch50.customer.c_phone, 1, 2), "20", "40", "22", "30", "39", "42", "21")	94.6 KB	N/A
21:01:26 [2021-06-08T21:01:26.944Z]           └─TableReader_46	2733040.07	3407619	root		time:568.5ms, loops:3319, cop_task: {num: 18, max: 1.19s, min: 436ms, avg: 847.3ms, p95: 1.19s, max_proc_keys: 582617, p95_proc_keys: 582617, tot_proc: 14.5s, tot_wait: 1ms, rpc_num: 18, rpc_time: 15.3s, copr_cache: disabled}	data:Selection_45	192.5 MB	N/A
21:01:26 [2021-06-08T21:01:26.944Z]             └─Selection_45	2733040.07	3407619	cop[tikv]		tikv_task:{proc max:1.12s, min:411ms, p80:953ms, 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:01:26 [2021-06-08T21:01:26.944Z]               └─TableFullScan_44	7500000.00	7500000	cop[tikv]	table:customer	tikv_task:{proc max:1.04s, min:381ms, p80:876ms, p95:1.04s, iters:7404, tasks:18}	keep order:false	N/A	N/A
21:01:26 [2021-06-08T21:01:26.944Z] + sync
21:01:26 [2021-06-08T21:01:26.944Z] + /usr/bin/echo 3
21:01:53 [2021-06-08T21:01:53.446Z] + sync
21:01:53 [2021-06-08T21:01:53.446Z] + /usr/bin/echo 3
21:02:25 [2021-06-08T21:02:25.471Z] + sync
21:02:25 [2021-06-08T21:02:25.471Z] + /usr/bin/echo 3
21:02:51 [2021-06-08T21:02:51.966Z] 
21:02:51 [2021-06-08T21:02:51.966Z] queries/22.sql
21:02:51 [2021-06-08T21:02:51.966Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
21:02:51 [2021-06-08T21:02:51.966Z] Sort_39	2186432.06	4	root		time:25.7s, loops:2	Column#27	9.48 KB	0 Bytes
21:02:51 [2021-06-08T21:02:51.966Z] └─Projection_41	2186432.06	4	root		time:25.7s, loops:5, Concurrency:5	Column#27, Column#28, Column#29	23.7 KB	N/A
21:02:51 [2021-06-08T21:02:51.966Z]   └─HashAgg_42	2186432.06	4	root		time:25.7s, loops:5, partial_worker:{wall_time:25.71741169s, concurrency:5, task_num:180, tot_wait:2m8.533519022s, tot_exec:52.704761ms, tot_time:2m8.586342077s, max:25.717339073s, p95:25.717339073s}, final_worker:{wall_time:25.717431124s, concurrency:5, task_num:20, tot_wait:2m8.586615653s, tot_exec:204.503µs, tot_time:2m8.586827947s, max:25.717375184s, p95:25.717375184s}	group by:Column#33, funcs:count(1)->Column#28, funcs:sum(Column#31)->Column#29, funcs:firstrow(Column#32)->Column#27	857.7 KB	N/A
21:02:51 [2021-06-08T21:02:51.966Z]     └─Projection_51	2186432.06	181704	root		time:25.7s, loops:181, Concurrency:5	tpch50.customer.c_acctbal, substring(tpch50.customer.c_phone, 1, 2)->Column#32, substring(tpch50.customer.c_phone, 1, 2)->Column#33	693.6 KB	N/A
21:02:51 [2021-06-08T21:02:51.966Z]       └─HashJoin_43	2186432.06	181704	root		time:25.7s, loops:181, build_hash_table:{total:24.4s, fetch:873.7ms, build:23.6s}, probe:{concurrency:5, total:2m8.6s, max:25.7s, probe:5.16s, fetch:2m3.4s}	anti semi join, equal:[eq(tpch50.customer.c_custkey, tpch50.orders.o_custkey)]	590.2 MB	0 Bytes
21:02:51 [2021-06-08T21:02:51.966Z]         ├─TableReader_49(Build)	75000000.00	75000000	root		time:916.7ms, loops:73364, cop_task: {num: 153, max: 890.9ms, min: 193.3ms, avg: 480.4ms, p95: 790.1ms, max_proc_keys: 723875, p95_proc_keys: 553332, tot_proc: 1m12.7s, tot_wait: 43ms, rpc_num: 153, rpc_time: 1m13.5s, copr_cache: disabled}	data:TableFullScan_48	57.8 MB	N/A
21:02:51 [2021-06-08T21:02:51.966Z]         │ └─TableFullScan_48	75000000.00	75000000	cop[tikv]	table:orders	tikv_task:{proc max:847ms, min:178ms, p80:488ms, p95:756ms, iters:73975, tasks:153}, scan_detail: {total_process_keys: 75000000, total_keys: 75000153, rocksdb: {delete_skipped_count: 0, key_skipped_count: 149999847, block: {cache_hit_count: 220923, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
21:02:51 [2021-06-08T21:02:51.966Z]         └─Selection_47(Probe)	2733040.07	545246	root		time:1.35s, loops:534	in(substring(tpch50.customer.c_phone, 1, 2), "20", "40", "22", "30", "39", "42", "21")	94.6 KB	N/A
21:02:51 [2021-06-08T21:02:51.966Z]           └─TableReader_46	2733040.07	3407619	root		time:508.6ms, loops:3319, cop_task: {num: 18, max: 1.15s, min: 375.9ms, avg: 824ms, p95: 1.15s, max_proc_keys: 582617, p95_proc_keys: 582617, tot_proc: 14.2s, rpc_num: 18, rpc_time: 14.8s, copr_cache: disabled}	data:Selection_45	192.5 MB	N/A
21:02:51 [2021-06-08T21:02:51.966Z]             └─Selection_45	2733040.07	3407619	cop[tikv]		tikv_task:{proc max:1.06s, min:348ms, p80:959ms, p95:1.06s, iters:7404, tasks:18}, scan_detail: {total_process_keys: 7500000, total_keys: 7500018, rocksdb: {delete_skipped_count: 0, key_skipped_count: 14999982, block: {cache_hit_count: 28451, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.customer.c_acctbal, 5000.602894)	N/A	N/A
21:02:51 [2021-06-08T21:02:51.966Z]               └─TableFullScan_44	7500000.00	7500000	cop[tikv]	table:customer	tikv_task:{proc max:972ms, min:318ms, p80:889ms, p95:972ms, iters:7404, tasks:18}	keep order:false	N/A	N/A
21:02:51 [2021-06-08T21:02:51.966Z] 
21:02:51 [2021-06-08T21:02:51.966Z] queries/22.sql
21:02:51 [2021-06-08T21:02:51.966Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
21:02:51 [2021-06-08T21:02:51.966Z] Sort_39	2186432.06	4	root		time:24.6s, loops:2	Column#27	9.48 KB	0 Bytes
21:02:51 [2021-06-08T21:02:51.966Z] └─Projection_41	2186432.06	4	root		time:24.6s, loops:5, Concurrency:5	Column#27, Column#28, Column#29	23.7 KB	N/A
21:02:51 [2021-06-08T21:02:51.966Z]   └─HashAgg_42	2186432.06	4	root		time:24.6s, loops:5, partial_worker:{wall_time:24.577713858s, concurrency:5, task_num:180, tot_wait:2m2.829577456s, tot_exec:58.271921ms, tot_time:2m2.887961564s, max:24.577635461s, p95:24.577635461s}, final_worker:{wall_time:24.577732364s, concurrency:5, task_num:20, tot_wait:2m2.888130002s, tot_exec:224.29µs, tot_time:2m2.888367046s, max:24.577680546s, p95:24.577680546s}	group by:Column#33, funcs:count(1)->Column#28, funcs:sum(Column#31)->Column#29, funcs:firstrow(Column#32)->Column#27	857.7 KB	N/A
21:02:51 [2021-06-08T21:02:51.966Z]     └─Projection_51	2186432.06	181704	root		time:24.6s, loops:181, Concurrency:5	tpch50.customer.c_acctbal, substring(tpch50.customer.c_phone, 1, 2)->Column#32, substring(tpch50.customer.c_phone, 1, 2)->Column#33	693.6 KB	N/A
21:02:51 [2021-06-08T21:02:51.966Z]       └─HashJoin_43	2186432.06	181704	root		time:24.6s, loops:181, build_hash_table:{total:23.1s, fetch:846.6ms, build:22.2s}, probe:{concurrency:5, total:2m2.9s, max:24.6s, probe:5.98s, fetch:1m56.9s}	anti semi join, equal:[eq(tpch50.customer.c_custkey, tpch50.orders.o_custkey)]	590.2 MB	0 Bytes
21:02:51 [2021-06-08T21:02:51.966Z]         ├─TableReader_49(Build)	75000000.00	75000000	root		time:836.2ms, loops:73364, cop_task: {num: 153, max: 961.5ms, min: 232ms, avg: 490.7ms, p95: 841.8ms, max_proc_keys: 723875, p95_proc_keys: 553332, tot_proc: 1m14.3s, tot_wait: 42ms, rpc_num: 153, rpc_time: 1m15.1s, copr_cache: disabled}	data:TableFullScan_48	57.8 MB	N/A
21:02:51 [2021-06-08T21:02:51.966Z]         │ └─TableFullScan_48	75000000.00	75000000	cop[tikv]	table:orders	tikv_task:{proc max:929ms, min:220ms, p80:501ms, p95:816ms, iters:73975, tasks:153}, scan_detail: {total_process_keys: 75000000, total_keys: 75000153, rocksdb: {delete_skipped_count: 0, key_skipped_count: 149999847, block: {cache_hit_count: 220923, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
21:02:51 [2021-06-08T21:02:51.966Z]         └─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:02:51 [2021-06-08T21:02:51.966Z]           └─TableReader_46	2733040.07	3407619	root		time:564.7ms, loops:3319, cop_task: {num: 18, max: 1.1s, min: 394.2ms, avg: 832.9ms, p95: 1.1s, max_proc_keys: 582617, p95_proc_keys: 582617, tot_proc: 14.5s, tot_wait: 1ms, rpc_num: 18, rpc_time: 15s, copr_cache: disabled}	data:Selection_45	192.5 MB	N/A
21:02:51 [2021-06-08T21:02:51.966Z]             └─Selection_45	2733040.07	3407619	cop[tikv]		tikv_task:{proc max:1.03s, min:366ms, p80:893ms, p95:1.03s, iters:7404, tasks:18}, scan_detail: {total_process_keys: 7500000, total_keys: 7500018, rocksdb: {delete_skipped_count: 0, key_skipped_count: 14999982, block: {cache_hit_count: 28451, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.customer.c_acctbal, 5000.602894)	N/A	N/A
21:02:51 [2021-06-08T21:02:51.966Z]               └─TableFullScan_44	7500000.00	7500000	cop[tikv]	table:customer	tikv_task:{proc max:930ms, min:343ms, p80:835ms, p95:930ms, iters:7404, tasks:18}	keep order:false	N/A	N/A
21:02:51 [2021-06-08T21:02:51.966Z] 
21:02:51 [2021-06-08T21:02:51.966Z] queries/22.sql
21:02:51 [2021-06-08T21:02:51.966Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
21:02:51 [2021-06-08T21:02:51.966Z] Sort_39	2186432.06	4	root		time:25.7s, loops:2	Column#27	9.48 KB	0 Bytes
21:02:51 [2021-06-08T21:02:51.966Z] └─Projection_41	2186432.06	4	root		time:25.7s, loops:5, Concurrency:5	Column#27, Column#28, Column#29	23.7 KB	N/A
21:02:51 [2021-06-08T21:02:51.967Z]   └─HashAgg_42	2186432.06	4	root		time:25.7s, loops:5, partial_worker:{wall_time:25.740646299s, concurrency:5, task_num:180, tot_wait:2m8.647189109s, tot_exec:55.666839ms, tot_time:2m8.702966697s, max:25.740623667s, p95:25.740623667s}, final_worker:{wall_time:25.740675652s, concurrency:5, task_num:20, tot_wait:2m8.702998336s, tot_exec:215.851µs, tot_time:2m8.703221763s, max:25.740657425s, p95:25.740657425s}	group by:Column#33, funcs:count(1)->Column#28, funcs:sum(Column#31)->Column#29, funcs:firstrow(Column#32)->Column#27	857.7 KB	N/A
21:02:51 [2021-06-08T21:02:51.967Z]     └─Projection_51	2186432.06	181704	root		time:25.7s, loops:181, Concurrency:5	tpch50.customer.c_acctbal, substring(tpch50.customer.c_phone, 1, 2)->Column#32, substring(tpch50.customer.c_phone, 1, 2)->Column#33	693.6 KB	N/A
21:02:51 [2021-06-08T21:02:51.967Z]       └─HashJoin_43	2186432.06	181704	root		time:25.7s, loops:181, build_hash_table:{total:24.3s, fetch:1.03s, build:23.3s}, probe:{concurrency:5, total:2m8.7s, max:25.7s, probe:5.81s, fetch:2m2.9s}	anti semi join, equal:[eq(tpch50.customer.c_custkey, tpch50.orders.o_custkey)]	590.2 MB	0 Bytes
21:02:51 [2021-06-08T21:02:51.967Z]         ├─TableReader_49(Build)	75000000.00	75000000	root		time:1.05s, loops:73364, cop_task: {num: 153, max: 1.08s, min: 224.6ms, avg: 505ms, p95: 921.4ms, max_proc_keys: 723875, p95_proc_keys: 553332, tot_proc: 1m16.5s, tot_wait: 44ms, rpc_num: 153, rpc_time: 1m17.3s, copr_cache: disabled}	data:TableFullScan_48	57.8 MB	N/A
21:02:51 [2021-06-08T21:02:51.967Z]         │ └─TableFullScan_48	75000000.00	75000000	cop[tikv]	table:orders	tikv_task:{proc max:1.06s, min:214ms, p80:501ms, p95:886ms, iters:73975, tasks:153}, scan_detail: {total_process_keys: 75000000, total_keys: 75000153, rocksdb: {delete_skipped_count: 0, key_skipped_count: 149999847, block: {cache_hit_count: 220923, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
21:02:51 [2021-06-08T21:02:51.967Z]         └─Selection_47(Probe)	2733040.07	545246	root		time:1.61s, loops:534	in(substring(tpch50.customer.c_phone, 1, 2), "20", "40", "22", "30", "39", "42", "21")	94.6 KB	N/A
21:02:51 [2021-06-08T21:02:51.967Z]           └─TableReader_46	2733040.07	3407619	root		time:767ms, loops:3319, cop_task: {num: 18, max: 1.16s, min: 478.2ms, avg: 881.5ms, p95: 1.16s, max_proc_keys: 582617, p95_proc_keys: 582617, tot_proc: 15.4s, tot_wait: 3ms, rpc_num: 18, rpc_time: 15.9s, copr_cache: disabled}	data:Selection_45	192.5 MB	N/A
21:02:51 [2021-06-08T21:02:51.967Z]             └─Selection_45	2733040.07	3407619	cop[tikv]		tikv_task:{proc max:1.09s, min:428ms, p80:1.04s, p95:1.09s, iters:7404, tasks:18}, scan_detail: {total_process_keys: 7500000, total_keys: 7500018, rocksdb: {delete_skipped_count: 0, key_skipped_count: 14999982, block: {cache_hit_count: 28451, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.customer.c_acctbal, 5000.602894)	N/A	N/A
21:02:51 [2021-06-08T21:02:51.967Z]               └─TableFullScan_44	7500000.00	7500000	cop[tikv]	table:customer	tikv_task:{proc max:1.01s, min:386ms, p80:941ms, p95:1.01s, iters:7404, tasks:18}	keep order:false	N/A	N/A
21:02:51 [2021-06-08T21:02:51.967Z] + sync
21:02:51 [2021-06-08T21:02:51.967Z] + /usr/bin/echo 3
21:03:23 [2021-06-08T21:03:23.990Z] 
21:03:23 [2021-06-08T21:03:23.990Z] queries/22.sql
21:03:23 [2021-06-08T21:03:23.990Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
21:03:23 [2021-06-08T21:03:23.990Z] Sort_39	2186432.06	4	root		time:25.1s, loops:2	Column#27	9.48 KB	0 Bytes
21:03:23 [2021-06-08T21:03:23.990Z] └─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:03:23 [2021-06-08T21:03:23.991Z]   └─HashAgg_42	2186432.06	4	root		time:25.1s, loops:5, partial_worker:{wall_time:25.139397595s, concurrency:5, task_num:180, tot_wait:2m5.644359013s, tot_exec:51.486869ms, tot_time:2m5.695955771s, max:25.13931698s, p95:25.13931698s}, final_worker:{wall_time:25.13942414s, concurrency:5, task_num:20, tot_wait:2m5.696503814s, tot_exec:204.013µs, tot_time:2m5.696714104s, max:25.139355652s, p95:25.139355652s}	group by:Column#33, funcs:count(1)->Column#28, funcs:sum(Column#31)->Column#29, funcs:firstrow(Column#32)->Column#27	857.7 KB	N/A
21:03:23 [2021-06-08T21:03:23.991Z]     └─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:03:23 [2021-06-08T21:03:23.991Z]       └─HashJoin_43	2186432.06	181704	root		time:25.1s, loops:181, build_hash_table:{total:23.8s, fetch:896.7ms, build:22.9s}, probe:{concurrency:5, total:2m5.7s, max:25.1s, probe:5.34s, fetch:2m0.4s}	anti semi join, equal:[eq(tpch50.customer.c_custkey, tpch50.orders.o_custkey)]	590.2 MB	0 Bytes
21:03:23 [2021-06-08T21:03:23.991Z]         ├─TableReader_49(Build)	75000000.00	75000000	root		time:883.8ms, loops:73364, cop_task: {num: 153, max: 932.2ms, min: 225.5ms, avg: 497.9ms, p95: 807.3ms, max_proc_keys: 723875, p95_proc_keys: 553332, tot_proc: 1m15.4s, tot_wait: 37ms, rpc_num: 153, rpc_time: 1m16.2s, copr_cache: disabled}	data:TableFullScan_48	57.8 MB	N/A
21:03:23 [2021-06-08T21:03:23.991Z]         │ └─TableFullScan_48	75000000.00	75000000	cop[tikv]	table:orders	tikv_task:{proc max:911ms, min:216ms, p80:502ms, p95:780ms, iters:73975, tasks:153}, scan_detail: {total_process_keys: 75000000, total_keys: 75000153, rocksdb: {delete_skipped_count: 0, key_skipped_count: 149999847, block: {cache_hit_count: 220923, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
21:03:23 [2021-06-08T21:03:23.991Z]         └─Selection_47(Probe)	2733040.07	545246	root		time:1.53s, loops:534	in(substring(tpch50.customer.c_phone, 1, 2), "20", "40", "22", "30", "39", "42", "21")	94.6 KB	N/A
21:03:23 [2021-06-08T21:03:23.991Z]           └─TableReader_46	2733040.07	3407619	root		time:685.3ms, loops:3319, cop_task: {num: 18, max: 1.18s, min: 531.5ms, avg: 817.3ms, p95: 1.18s, max_proc_keys: 582617, p95_proc_keys: 582617, tot_proc: 14.3s, rpc_num: 18, rpc_time: 14.7s, copr_cache: disabled}	data:Selection_45	192.5 MB	N/A
21:03:23 [2021-06-08T21:03:23.991Z]             └─Selection_45	2733040.07	3407619	cop[tikv]		tikv_task:{proc max:1.11s, min:488ms, p80:914ms, 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
21:03:23 [2021-06-08T21:03:23.991Z]               └─TableFullScan_44	7500000.00	7500000	cop[tikv]	table:customer	tikv_task:{proc max:1.02s, min:441ms, p80:833ms, p95:1.02s, iters:7404, tasks:18}	keep order:false	N/A	N/A
21:03:23 [2021-06-08T21:03:23.991Z] 
21:03:23 [2021-06-08T21:03:23.991Z] + tiup cluster stop benchbot
21:03:23 [2021-06-08T21:03:23.991Z] Starting component `cluster`: /home/tidb/.tiup/components/cluster/v1.4.4/tiup-cluster stop benchbot
21:03:23 [2021-06-08T21:03:23.991Z] + [ Serial ] - SSHKeySet: privateKey=/home/tidb/.tiup/storage/cluster/clusters/benchbot/ssh/id_rsa, publicKey=/home/tidb/.tiup/storage/cluster/clusters/benchbot/ssh/id_rsa.pub
21:03:23 [2021-06-08T21:03:23.991Z] + [Parallel] - UserSSH: user=tidb, host=172.16.5.86
21:03:23 [2021-06-08T21:03:23.991Z] + [Parallel] - UserSSH: user=tidb, host=172.16.5.86
21:03:23 [2021-06-08T21:03:23.991Z] + [Parallel] - UserSSH: user=tidb, host=172.16.5.86
21:03:23 [2021-06-08T21:03:23.991Z] + [Parallel] - UserSSH: user=tidb, host=172.16.5.86
21:03:23 [2021-06-08T21:03:23.991Z] + [Parallel] - UserSSH: user=tidb, host=172.16.5.86
21:03:23 [2021-06-08T21:03:23.991Z] + [ Serial ] - StopCluster
21:03:23 [2021-06-08T21:03:23.991Z] Stopping component grafana
21:03:23 [2021-06-08T21:03:23.991Z] 	Stopping instance 172.16.5.86
21:03:23 [2021-06-08T21:03:23.991Z] 	Stop grafana 172.16.5.86:3000 success
21:03:23 [2021-06-08T21:03:23.991Z] Stopping component prometheus
21:03:23 [2021-06-08T21:03:23.991Z] 	Stopping instance 172.16.5.86
21:03:23 [2021-06-08T21:03:23.991Z] 	Stop prometheus 172.16.5.86:9090 success
21:03:23 [2021-06-08T21:03:23.991Z] Stopping component tidb
21:03:23 [2021-06-08T21:03:23.991Z] 	Stopping instance 172.16.5.86
21:03:27 [2021-06-08T21:03:27.253Z] 	Stop tidb 172.16.5.86:4000 success
21:03:27 [2021-06-08T21:03:27.253Z] Stopping component tikv
21:03:27 [2021-06-08T21:03:27.253Z] 	Stopping instance 172.16.5.86
21:03:31 [2021-06-08T21:03:31.416Z] 	Stop tikv 172.16.5.86:20160 success
21:03:31 [2021-06-08T21:03:31.416Z] Stopping component pd
21:03:31 [2021-06-08T21:03:31.416Z] 	Stopping instance 172.16.5.86
21:03:31 [2021-06-08T21:03:31.416Z] 	Stop pd 172.16.5.86:2379 success
21:03:31 [2021-06-08T21:03:31.416Z] Stopping component node_exporter
21:03:31 [2021-06-08T21:03:31.416Z] Stopping component blackbox_exporter
21:03:31 [2021-06-08T21:03:31.416Z] Stopped cluster `benchbot` successfully
21:03:31 [2021-06-08T21:03:31.423Z] [Pipeline] sh
21:03:31 [2021-06-08T21:03:31.713Z] + cat bench_result
21:03:31 [2021-06-08T21:03:31.719Z] [Pipeline] }
21:03:31 [2021-06-08T21:03:31.722Z] [Pipeline] // dir
21:03:31 [2021-06-08T21:03:31.724Z] [Pipeline] }
21:03:31 [2021-06-08T21:03:31.726Z] [Pipeline] // stage
21:03:31 [2021-06-08T21:03:31.729Z] [Pipeline] }
21:03:31 [2021-06-08T21:03:31.732Z] [Pipeline] // node
21:03:31 [2021-06-08T21:03:31.735Z] [Pipeline] }
21:03:31 [2021-06-08T21:03:31.737Z] [Pipeline] // catchError
21:03:31 [2021-06-08T21:03:31.742Z] [Pipeline] stage
21:03:31 [2021-06-08T21:03:31.746Z] [Pipeline] { (Summary)
21:03:31 [2021-06-08T21:03:31.760Z] [Pipeline] slackSend
21:03:31 [2021-06-08T21:03:31.761Z] Slack Send Pipeline step running, values are - baseUrl: <empty>, teamDomain: pingcap, channel: #daily_bench, color: good, botUser: false, tokenCredentialId: slack-pingcap-token, iconEmoji <empty>, username <empty>
21:03:32 [2021-06-08T21:03:32.397Z] sh: line 1: 97466 Terminated              sleep 3
21:03:32 [2021-06-08T21:03:32.414Z] sh: line 1: 97612 Terminated              sleep 3
21:03:32 [2021-06-08T21:03:32.614Z] [Pipeline] }
21:03:32 [2021-06-08T21:03:32.617Z] [Pipeline] // stage
21:03:32 [2021-06-08T21:03:32.619Z] [Pipeline] End of Pipeline
21:03:32 [2021-06-08T21:03:32.639Z] Finished: SUCCESS