SuccessConsole Output

Skipping 1,193 KB.. Full Log
uantity)->Column#44	194.5 MB	N/A
20:41:04 [2021-05-29T20:41:04.790Z]         └─HashJoin_59	9711455.06	634004	root		time:45.3s, loops:625, build_hash_table:{total:3.21s, fetch:2.99s, build:215ms}, probe:{concurrency:5, total:3m46.6s, max:45.3s, probe:14.6s, fetch:3m32s}	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:04 [2021-05-29T20:41:04.790Z]           ├─IndexHashJoin_67(Build)	321865.05	435528	root		time:3.18s, loops:430, inner:{total:3.48s, concurrency:5, task:12, construct:109.8ms, fetch:3.04s, build:31.2ms, join:330.1ms}	inner join, inner:IndexLookUp_64, outer key:tpch50.part.p_partkey, inner key:tpch50.partsupp.ps_partkey, equal cond:eq(tpch50.part.p_partkey, tpch50.partsupp.ps_partkey)	20.4 MB	N/A
20:41:04 [2021-05-29T20:41:04.790Z]           │ ├─TableReader_96(Build)	80007.93	108882	root		time:2.7s, loops:112, cop_task: {num: 20, max: 1.73s, min: 750.3ms, avg: 1.39s, p95: 1.73s, max_proc_keys: 686055, p95_proc_keys: 686055, tot_proc: 27.7s, tot_wait: 14ms, rpc_num: 20, rpc_time: 27.8s, copr_cache: disabled}	data:Selection_95	680.6 KB	N/A
20:41:04 [2021-05-29T20:41:04.790Z]           │ │ └─Selection_95	80007.93	108882	cop[tikv]		tikv_task:{proc max:1.71s, min:745ms, p80:1.63s, p95:1.71s, 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:04 [2021-05-29T20:41:04.790Z]           │ │   └─TableFullScan_94	10000000.00	10000000	cop[tikv]	table:part	tikv_task:{proc max:1.61s, min:689ms, p80:1.52s, p95:1.61s, iters:9859, tasks:20}	keep order:false	N/A	N/A
20:41:04 [2021-05-29T20:41:04.790Z]           │ └─IndexLookUp_64(Probe)	4.02	435528	root		time:2.96s, loops:447, index_task: {total_time: 1.85s, fetch_handle: 1.85s, build: 102.2µs, wait: 285.6µs}, table_task: {total_time: 11.8s, num: 56, concurrency: 60}		20.5 KB	N/A
20:41:04 [2021-05-29T20:41:04.791Z]           │   ├─IndexRangeScan_62(Build)	4.02	435528	cop[tikv]	table:partsupp, index:PRIMARY(PS_PARTKEY, PS_SUPPKEY)	time:1.81s, loops:482, cop_task: {num: 59, max: 361.5ms, min: 5.63ms, avg: 132.2ms, p95: 287.5ms, max_proc_keys: 15288, p95_proc_keys: 15008, tot_proc: 7.09s, tot_wait: 56ms, rpc_num: 59, rpc_time: 7.8s, copr_cache: disabled}, tikv_task:{proc max:342ms, min:5ms, p80:206ms, p95:261ms, iters:695, tasks:59}, scan_detail: {total_process_keys: 435528, total_keys: 544410, rocksdb: {delete_skipped_count: 0, key_skipped_count: 435528, block: {cache_hit_count: 980292, read_count: 0, read_byte: 0 Bytes}}}	range: decided by [eq(tpch50.partsupp.ps_partkey, tpch50.part.p_partkey)], keep order:false	N/A	N/A
20:41:04 [2021-05-29T20:41:04.791Z]           │   └─TableRowIDScan_63(Probe)	4.02	435528	cop[tikv]	table:partsupp	time:3.84s, loops:504, cop_task: {num: 1406, max: 117.1ms, min: 533.9µs, avg: 27.2ms, p95: 58.3ms, max_proc_keys: 1236, p95_proc_keys: 624, tot_proc: 29.1s, tot_wait: 7.15s, rpc_num: 1406, rpc_time: 38.2s, copr_cache: disabled}, tikv_task:{proc max:93ms, min:0s, p80:26ms, p95:39ms, iters:5233, tasks:1406}, scan_detail: {total_process_keys: 435528, total_keys: 473508, rocksdb: {delete_skipped_count: 0, key_skipped_count: 194090, block: {cache_hit_count: 3643752, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:41:04 [2021-05-29T20:41:04.791Z]           └─TableReader_101(Probe)	46310896.67	45504356	root		time:40.3s, loops:44290, cop_task: {num: 761, max: 1.38s, min: 371.5ms, avg: 841.4ms, p95: 1.14s, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 10m36.9s, tot_wait: 133ms, rpc_num: 761, rpc_time: 10m40.3s, copr_cache: disabled}	data:Selection_100	52.6 MB	N/A
20:41:04 [2021-05-29T20:41:04.791Z]             └─Selection_100	46310896.67	45504356	cop[tikv]		tikv_task:{proc max:1.32s, min:364ms, p80:952ms, p95:1.1s, 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:04 [2021-05-29T20:41:04.791Z]               └─TableFullScan_99	300005811.00	300005811	cop[tikv]	table:lineitem	tikv_task:{proc max:1.28s, min:338ms, p80:920ms, p95:1.07s, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:41:04 [2021-05-29T20:41:04.791Z] + sync
20:41:04 [2021-05-29T20:41:04.791Z] + /usr/bin/echo 3
20:41:51 [2021-05-29T20:41:51.490Z] + sync
20:41:51 [2021-05-29T20:41:51.490Z] + /usr/bin/echo 3
20:42:30 [2021-05-29T20:42:30.149Z] 
20:42:30 [2021-05-29T20:42:30.149Z] queries/20.sql
20:42:30 [2021-05-29T20:42:30.149Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:42:30 [2021-05-29T20:42:30.149Z] Sort_30	20000.00	8982	root		time:40.4s, loops:10	tpch50.supplier.s_name	633.0 KB	0 Bytes
20:42:30 [2021-05-29T20:42:30.149Z] └─HashJoin_35	20000.00	8982	root		time:40.4s, loops:11, build_hash_table:{total:1.74s, fetch:1.72s, build:13.5ms}, probe:{concurrency:5, total:3m22.2s, max:40.4s, probe:45.2ms, fetch:3m22.1s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.partsupp.ps_suppkey)]	1.53 MB	0 Bytes
20:42:30 [2021-05-29T20:42:30.149Z]   ├─HashJoin_48(Build)	20000.00	19972	root		time:1.73s, loops:23, build_hash_table:{total:145.6µs, fetch:140.6µs, build:4.99µs}, probe:{concurrency:5, total:8.66s, max:1.73s, probe:124.9ms, fetch:8.54s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:42:30 [2021-05-29T20:42:30.149Z]   │ ├─TableReader_53(Build)	1.00	1	root		time:37.6µs, loops:2, cop_task: {num: 1, max: 1.13ms, proc_keys: 25, rpc_num: 1, rpc_time: 1.08ms, copr_cache: disabled}	data:Selection_52	236 Bytes	N/A
20:42:30 [2021-05-29T20:42:30.149Z]   │ │ └─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:30 [2021-05-29T20:42:30.149Z]   │ │   └─TableFullScan_51	25.00	25	cop[tikv]	table:nation	tikv_task:{time:0s, loops:1}	keep order:false	N/A	N/A
20:42:30 [2021-05-29T20:42:30.149Z]   │ └─TableReader_50(Probe)	500000.00	500000	root		time:1.71s, loops:490, cop_task: {num: 1, max: 1.71s, proc_keys: 500000, tot_proc: 1.65s, rpc_num: 1, rpc_time: 1.71s, copr_cache: disabled}	data:TableFullScan_49	35.8 MB	N/A
20:42:30 [2021-05-29T20:42:30.149Z]   │   └─TableFullScan_49	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:1.49s, 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:30 [2021-05-29T20:42:30.149Z]   └─HashAgg_54(Probe)	257492.04	223999	root		time:40.4s, loops:222, partial_worker:{wall_time:40.361033886s, concurrency:5, task_num:289, tot_wait:3m21.526852833s, tot_exec:237.800027ms, tot_time:3m21.799592829s, max:40.360918342s, p95:40.360918342s}, final_worker:{wall_time:40.430001686s, concurrency:5, task_num:25, tot_wait:3m21.791893359s, tot_exec:341.996353ms, tot_time:3m22.133920242s, max:40.42988167s, p95:40.42988167s}	group by:tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_suppkey)->tpch50.partsupp.ps_suppkey	61.4 MB	N/A
20:42:30 [2021-05-29T20:42:30.149Z]     └─Selection_55	257492.04	295898	root		time:40.3s, loops:290	gt(cast(tpch50.partsupp.ps_availqty, decimal(20,0) BINARY), mul(0.5, Column#44))	59.2 KB	N/A
20:42:30 [2021-05-29T20:42:30.149Z]       └─HashAgg_56	321865.05	435528	root		time:40.2s, loops:430, partial_worker:{wall_time:40.023399302s, concurrency:5, task_num:624, tot_wait:3m18.793449556s, tot_exec:1.205109274s, tot_time:3m20.102412448s, max:40.023255295s, p95:40.023255295s}, final_worker:{wall_time:40.350846895s, concurrency:5, task_num:25, tot_wait:3m20.09202983s, tot_exec:1.581283606s, tot_time:3m21.673331988s, max:40.350664594s, p95:40.350664594s}	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:30 [2021-05-29T20:42:30.149Z]         └─HashJoin_59	9711455.06	634004	root		time:39.9s, loops:625, build_hash_table:{total:2.83s, fetch:2.63s, build:201.6ms}, probe:{concurrency:5, total:3m19.6s, max:39.9s, probe:14.1s, fetch:3m5.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:42:30 [2021-05-29T20:42:30.149Z]           ├─IndexHashJoin_67(Build)	321865.05	435528	root		time:2.81s, loops:429, inner:{total:3.29s, concurrency:5, task:12, construct:140.8ms, fetch:2.82s, build:31.6ms, join:330.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.6 MB	N/A
20:42:30 [2021-05-29T20:42:30.149Z]           │ ├─TableReader_96(Build)	80007.93	108882	root		time:2.33s, loops:112, cop_task: {num: 20, max: 1.69s, min: 799.8ms, avg: 1.28s, p95: 1.69s, max_proc_keys: 686055, p95_proc_keys: 686055, tot_proc: 25.5s, tot_wait: 30ms, rpc_num: 20, rpc_time: 25.5s, copr_cache: disabled}	data:Selection_95	725.8 KB	N/A
20:42:30 [2021-05-29T20:42:30.149Z]           │ │ └─Selection_95	80007.93	108882	cop[tikv]		tikv_task:{proc max:1.64s, min:794ms, p80:1.44s, p95:1.64s, 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:30 [2021-05-29T20:42:30.149Z]           │ │   └─TableFullScan_94	10000000.00	10000000	cop[tikv]	table:part	tikv_task:{proc max:1.52s, min:750ms, p80:1.33s, p95:1.52s, iters:9859, tasks:20}	keep order:false	N/A	N/A
20:42:30 [2021-05-29T20:42:30.149Z]           │ └─IndexLookUp_64(Probe)	4.02	435528	root		time:2.69s, loops:447, index_task: {total_time: 1.65s, fetch_handle: 1.65s, build: 93.3µs, wait: 261µs}, table_task: {total_time: 10.5s, num: 55, concurrency: 60}		20.7 KB	N/A
20:42:30 [2021-05-29T20:42:30.149Z]           │   ├─IndexRangeScan_62(Build)	4.02	435528	cop[tikv]	table:partsupp, index:PRIMARY(PS_PARTKEY, PS_SUPPKEY)	time:1.6s, loops:476, cop_task: {num: 59, max: 349.8ms, min: 7.14ms, avg: 114.4ms, p95: 291.7ms, max_proc_keys: 15288, p95_proc_keys: 15048, tot_proc: 6.11s, tot_wait: 212ms, rpc_num: 59, rpc_time: 6.75s, copr_cache: disabled}, tikv_task:{proc max:335ms, min:5ms, p80:162ms, p95:253ms, iters:691, tasks:59}, scan_detail: {total_process_keys: 435528, total_keys: 544410, rocksdb: {delete_skipped_count: 0, key_skipped_count: 435528, block: {cache_hit_count: 980292, read_count: 0, read_byte: 0 Bytes}}}	range: decided by [eq(tpch50.partsupp.ps_partkey, tpch50.part.p_partkey)], keep order:false	N/A	N/A
20:42:30 [2021-05-29T20:42:30.149Z]           │   └─TableRowIDScan_63(Probe)	4.02	435528	cop[tikv]	table:partsupp	time:3.43s, loops:504, cop_task: {num: 1345, max: 100.3ms, min: 1.16ms, avg: 24.4ms, p95: 56.7ms, max_proc_keys: 1028, p95_proc_keys: 656, tot_proc: 24.9s, tot_wait: 5.74s, rpc_num: 1345, rpc_time: 32.8s, copr_cache: disabled}, tikv_task:{proc max:63ms, min:0s, p80:23ms, p95:35ms, iters:5074, tasks:1345}, scan_detail: {total_process_keys: 435528, total_keys: 473528, rocksdb: {delete_skipped_count: 0, key_skipped_count: 194164, block: {cache_hit_count: 3643353, read_count: 1, read_byte: 26.2 KB}}}	keep order:false	N/A	N/A
20:42:30 [2021-05-29T20:42:30.149Z]           └─TableReader_101(Probe)	46310896.67	45504356	root		time:35.2s, loops:44290, cop_task: {num: 761, max: 1.35s, min: 340.7ms, avg: 743.4ms, p95: 925ms, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 9m22.6s, tot_wait: 145ms, rpc_num: 761, rpc_time: 9m25.7s, copr_cache: disabled}	data:Selection_100	52.6 MB	N/A
20:42:30 [2021-05-29T20:42:30.149Z]             └─Selection_100	46310896.67	45504356	cop[tikv]		tikv_task:{proc max:1.29s, min:327ms, p80:790ms, p95:908ms, 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:30 [2021-05-29T20:42:30.149Z]               └─TableFullScan_99	300005811.00	300005811	cop[tikv]	table:lineitem	tikv_task:{proc max:1.25s, min:310ms, p80:755ms, p95:868ms, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:42:30 [2021-05-29T20:42:30.149Z] 
20:42:30 [2021-05-29T20:42:30.149Z] queries/20.sql
20:42:30 [2021-05-29T20:42:30.149Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:42:30 [2021-05-29T20:42:30.149Z] Sort_30	20000.00	8982	root		time:39.7s, loops:10	tpch50.supplier.s_name	627.7 KB	0 Bytes
20:42:30 [2021-05-29T20:42:30.149Z] └─HashJoin_35	20000.00	8982	root		time:39.7s, loops:11, build_hash_table:{total:1.36s, fetch:1.35s, build:11.6ms}, probe:{concurrency:5, total:3m18.3s, max:39.7s, probe:49.5ms, fetch:3m18.2s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.partsupp.ps_suppkey)]	1.50 MB	0 Bytes
20:42:30 [2021-05-29T20:42:30.149Z]   ├─HashJoin_48(Build)	20000.00	19972	root		time:1.36s, loops:23, build_hash_table:{total:225.8µs, fetch:217.4µs, build:8.44µs}, probe:{concurrency:5, total:6.81s, max:1.36s, probe:122.5ms, fetch:6.68s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:42:30 [2021-05-29T20:42:30.149Z]   │ ├─TableReader_53(Build)	1.00	1	root		time:66µs, loops:2, cop_task: {num: 1, max: 1.08ms, proc_keys: 25, rpc_num: 1, rpc_time: 1.04ms, copr_cache: disabled}	data:Selection_52	236 Bytes	N/A
20:42:30 [2021-05-29T20:42:30.149Z]   │ │ └─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:30 [2021-05-29T20:42:30.149Z]   │ │   └─TableFullScan_51	25.00	25	cop[tikv]	table:nation	tikv_task:{time:0s, loops:1}	keep order:false	N/A	N/A
20:42:30 [2021-05-29T20:42:30.149Z]   │ └─TableReader_50(Probe)	500000.00	500000	root		time:1.34s, loops:490, cop_task: {num: 1, max: 1.34s, proc_keys: 500000, tot_proc: 1.25s, rpc_num: 1, rpc_time: 1.34s, copr_cache: disabled}	data:TableFullScan_49	35.8 MB	N/A
20:42:30 [2021-05-29T20:42:30.149Z]   │   └─TableFullScan_49	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:1.13s, 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:30 [2021-05-29T20:42:30.149Z]   └─HashAgg_54(Probe)	257492.04	223999	root		time:39.7s, loops:222, partial_worker:{wall_time:39.556339664s, concurrency:5, task_num:289, tot_wait:3m17.517090233s, tot_exec:198.105122ms, tot_time:3m17.764206977s, max:39.555921214s, p95:39.555921214s}, final_worker:{wall_time:39.656574011s, concurrency:5, task_num:25, tot_wait:3m17.754052987s, tot_exec:515.172048ms, tot_time:3m18.269243876s, max:39.656169121s, p95:39.656169121s}	group by:tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_suppkey)->tpch50.partsupp.ps_suppkey	61.4 MB	N/A
20:42:30 [2021-05-29T20:42:30.149Z]     └─Selection_55	257492.04	295898	root		time:39.5s, loops:290	gt(cast(tpch50.partsupp.ps_availqty, decimal(20,0) BINARY), mul(0.5, Column#44))	59.2 KB	N/A
20:42:30 [2021-05-29T20:42:30.149Z]       └─HashAgg_56	321865.05	435528	root		time:39.4s, loops:430, partial_worker:{wall_time:39.202366417s, concurrency:5, task_num:625, tot_wait:3m14.843109396s, tot_exec:1.03909276s, tot_time:3m15.989728654s, max:39.202264105s, p95:39.202264105s}, final_worker:{wall_time:39.541811947s, concurrency:5, task_num:25, tot_wait:3m15.967374698s, tot_exec:1.711558447s, tot_time:3m17.67894931s, max:39.541705783s, p95:39.541705783s}	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:30 [2021-05-29T20:42:30.149Z]         └─HashJoin_59	9711455.06	634004	root		time:39.1s, loops:626, build_hash_table:{total:2.62s, fetch:2.4s, build:217ms}, probe:{concurrency:5, total:3m15.6s, max:39.1s, probe:14.4s, fetch:3m1.3s}	left outer join, equal:[eq(tpch50.partsupp.ps_partkey, tpch50.lineitem.l_partkey) eq(tpch50.partsupp.ps_suppkey, tpch50.lineitem.l_suppkey)]	10.4 MB	0 Bytes
20:42:30 [2021-05-29T20:42:30.149Z]           ├─IndexHashJoin_67(Build)	321865.05	435528	root		time:2.57s, loops:429, inner:{total:2.76s, concurrency:5, task:12, construct:116.7ms, fetch:2.31s, build:27.8ms, join:333.6ms}	inner join, inner:IndexLookUp_64, outer key:tpch50.part.p_partkey, inner key:tpch50.partsupp.ps_partkey, equal cond:eq(tpch50.part.p_partkey, tpch50.partsupp.ps_partkey)	20.6 MB	N/A
20:42:30 [2021-05-29T20:42:30.149Z]           │ ├─TableReader_96(Build)	80007.93	108882	root		time:2.22s, loops:112, cop_task: {num: 20, max: 1.48s, min: 460.2ms, avg: 1.09s, p95: 1.48s, max_proc_keys: 686055, p95_proc_keys: 686055, tot_proc: 21.7s, tot_wait: 17ms, rpc_num: 20, rpc_time: 21.7s, copr_cache: disabled}	data:Selection_95	725.8 KB	N/A
20:42:30 [2021-05-29T20:42:30.149Z]           │ │ └─Selection_95	80007.93	108882	cop[tikv]		tikv_task:{proc max:1.47s, min:457ms, p80:1.24s, p95:1.47s, iters:9859, tasks:20}, scan_detail: {total_process_keys: 10000000, total_keys: 10000020, rocksdb: {delete_skipped_count: 0, key_skipped_count: 19999980, block: {cache_hit_count: 31499, read_count: 0, read_byte: 0 Bytes}}}	like(tpch50.part.p_name, "green%", 92)	N/A	N/A
20:42:30 [2021-05-29T20:42:30.149Z]           │ │   └─TableFullScan_94	10000000.00	10000000	cop[tikv]	table:part	tikv_task:{proc max:1.36s, min:423ms, p80:1.16s, p95:1.36s, iters:9859, tasks:20}	keep order:false	N/A	N/A
20:42:30 [2021-05-29T20:42:30.149Z]           │ └─IndexLookUp_64(Probe)	4.02	435528	root		time:2.19s, loops:447, index_task: {total_time: 1.28s, fetch_handle: 1.28s, build: 84.8µs, wait: 258.8µs}, table_task: {total_time: 8.43s, num: 56, concurrency: 60}		20.5 KB	N/A
20:42:30 [2021-05-29T20:42:30.150Z]           │   ├─IndexRangeScan_62(Build)	4.02	435528	cop[tikv]	table:partsupp, index:PRIMARY(PS_PARTKEY, PS_SUPPKEY)	time:1.23s, loops:478, cop_task: {num: 55, max: 243.7ms, min: 3.87ms, avg: 100.1ms, p95: 224.2ms, max_proc_keys: 15288, p95_proc_keys: 15008, tot_proc: 4.94s, tot_wait: 47ms, rpc_num: 55, rpc_time: 5.5s, copr_cache: disabled}, tikv_task:{proc max:229ms, min:3ms, p80:140ms, p95:213ms, iters:675, tasks:55}, 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:30 [2021-05-29T20:42:30.150Z]           │   └─TableRowIDScan_63(Probe)	4.02	435528	cop[tikv]	table:partsupp	time:2.8s, loops:507, cop_task: {num: 1348, max: 84.1ms, min: 531µs, avg: 20.5ms, p95: 43.8ms, max_proc_keys: 1088, p95_proc_keys: 648, tot_proc: 19.4s, tot_wait: 5.5s, rpc_num: 1348, rpc_time: 27.6s, copr_cache: disabled}, tikv_task:{proc max:49ms, min:0s, p80:18ms, p95:27ms, iters:5074, tasks:1348}, scan_detail: {total_process_keys: 435528, total_keys: 473525, rocksdb: {delete_skipped_count: 0, key_skipped_count: 194135, block: {cache_hit_count: 3643684, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:42:30 [2021-05-29T20:42:30.150Z]           └─TableReader_101(Probe)	46310896.67	45504356	root		time:34.6s, loops:44290, cop_task: {num: 761, max: 1.23s, min: 393.2ms, avg: 728.5ms, p95: 864.9ms, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 9m11.2s, tot_wait: 123ms, rpc_num: 761, rpc_time: 9m14.3s, copr_cache: disabled}	data:Selection_100	52.6 MB	N/A
20:42:30 [2021-05-29T20:42:30.150Z]             └─Selection_100	46310896.67	45504356	cop[tikv]		tikv_task:{proc max:1.2s, min:383ms, p80:774ms, p95:851ms, 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:30 [2021-05-29T20:42:30.150Z]               └─TableFullScan_99	300005811.00	300005811	cop[tikv]	table:lineitem	tikv_task:{proc max:1.15s, min:363ms, p80:742ms, p95:815ms, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:42:30 [2021-05-29T20:42:30.150Z] + sync
20:42:30 [2021-05-29T20:42:30.150Z] + /usr/bin/echo 3
20:43:16 [2021-05-29T20:43:16.911Z] + sync
20:43:16 [2021-05-29T20:43:16.911Z] + /usr/bin/echo 3
20:43:55 [2021-05-29T20:43:55.576Z] 
20:43:55 [2021-05-29T20:43:55.576Z] queries/20.sql
20:43:55 [2021-05-29T20:43:55.576Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:43:55 [2021-05-29T20:43:55.576Z] Sort_30	20000.00	8982	root		time:39.3s, loops:10	tpch50.supplier.s_name	628.3 KB	0 Bytes
20:43:55 [2021-05-29T20:43:55.576Z] └─HashJoin_35	20000.00	8982	root		time:39.3s, loops:11, build_hash_table:{total:1.56s, fetch:1.55s, build:10.4ms}, probe:{concurrency:5, total:3m16.3s, max:39.3s, probe:51.7ms, fetch:3m16.2s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.partsupp.ps_suppkey)]	1.52 MB	0 Bytes
20:43:55 [2021-05-29T20:43:55.576Z]   ├─HashJoin_48(Build)	20000.00	19972	root		time:1.56s, loops:23, build_hash_table:{total:140.5µs, fetch:136.2µs, build:4.37µs}, probe:{concurrency:5, total:7.79s, max:1.56s, probe:101.7ms, fetch:7.69s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:43:55 [2021-05-29T20:43:55.576Z]   │ ├─TableReader_53(Build)	1.00	1	root		time:35.6µs, loops:2, cop_task: {num: 1, max: 997.9µs, proc_keys: 25, rpc_num: 1, rpc_time: 952.4µs, copr_cache: disabled}	data:Selection_52	236 Bytes	N/A
20:43:55 [2021-05-29T20:43:55.576Z]   │ │ └─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:43:55 [2021-05-29T20:43:55.576Z]   │ │   └─TableFullScan_51	25.00	25	cop[tikv]	table:nation	tikv_task:{time:0s, loops:1}	keep order:false	N/A	N/A
20:43:55 [2021-05-29T20:43:55.576Z]   │ └─TableReader_50(Probe)	500000.00	500000	root		time:1.54s, loops:490, cop_task: {num: 1, max: 1.54s, proc_keys: 500000, tot_proc: 1.47s, rpc_num: 1, rpc_time: 1.54s, copr_cache: disabled}	data:TableFullScan_49	35.8 MB	N/A
20:43:55 [2021-05-29T20:43:55.576Z]   │   └─TableFullScan_49	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:1.24s, 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:43:55 [2021-05-29T20:43:55.576Z]   └─HashAgg_54(Probe)	257492.04	223999	root		time:39.2s, loops:222, partial_worker:{wall_time:39.137829582s, concurrency:5, task_num:289, tot_wait:3m15.436428378s, tot_exec:201.063712ms, tot_time:3m15.683410563s, max:39.137743808s, p95:39.137743808s}, final_worker:{wall_time:39.250407668s, concurrency:5, task_num:25, tot_wait:3m15.679031573s, tot_exec:552.526729ms, tot_time:3m16.231581461s, max:39.250328779s, p95:39.250328779s}	group by:tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_suppkey)->tpch50.partsupp.ps_suppkey	61.4 MB	N/A
20:43:55 [2021-05-29T20:43:55.576Z]     └─Selection_55	257492.04	295898	root		time:39.1s, loops:290	gt(cast(tpch50.partsupp.ps_availqty, decimal(20,0) BINARY), mul(0.5, Column#44))	59.2 KB	N/A
20:43:55 [2021-05-29T20:43:55.576Z]       └─HashAgg_56	321865.05	435528	root		time:39s, loops:430, partial_worker:{wall_time:38.76752142s, concurrency:5, task_num:624, tot_wait:3m12.62889943s, tot_exec:1.085161456s, tot_time:3m13.827082231s, max:38.767360397s, p95:38.767360397s}, final_worker:{wall_time:39.125141039s, concurrency:5, task_num:25, tot_wait:3m13.806188288s, tot_exec:1.768081943s, tot_time:3m15.574287244s, max:39.124983707s, p95:39.124983707s}	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:43:55 [2021-05-29T20:43:55.576Z]         └─HashJoin_59	9711455.06	634004	root		time:38.7s, loops:625, build_hash_table:{total:2.4s, fetch:2.18s, build:222.5ms}, probe:{concurrency:5, total:3m13.5s, max:38.7s, probe:14s, fetch:2m59.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:43:55 [2021-05-29T20:43:55.576Z]           ├─IndexHashJoin_67(Build)	321865.05	435528	root		time:2.34s, loops:430, inner:{total:2.7s, concurrency:5, task:12, construct:107ms, fetch:2.25s, build:27.7ms, join:350.4ms}	inner join, inner:IndexLookUp_64, outer key:tpch50.part.p_partkey, inner key:tpch50.partsupp.ps_partkey, equal cond:eq(tpch50.part.p_partkey, tpch50.partsupp.ps_partkey)	20.5 MB	N/A
20:43:55 [2021-05-29T20:43:55.576Z]           │ ├─TableReader_96(Build)	80007.93	108882	root		time:2.01s, loops:112, cop_task: {num: 20, max: 1.54s, min: 627.6ms, avg: 1.09s, p95: 1.54s, max_proc_keys: 686055, p95_proc_keys: 686055, tot_proc: 21.7s, tot_wait: 43ms, rpc_num: 20, rpc_time: 21.7s, copr_cache: disabled}	data:Selection_95	725.8 KB	N/A
20:43:55 [2021-05-29T20:43:55.576Z]           │ │ └─Selection_95	80007.93	108882	cop[tikv]		tikv_task:{proc max:1.52s, min:622ms, p80:1.26s, p95:1.52s, 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:43:55 [2021-05-29T20:43:55.576Z]           │ │   └─TableFullScan_94	10000000.00	10000000	cop[tikv]	table:part	tikv_task:{proc max:1.44s, min:574ms, p80:1.19s, p95:1.44s, iters:9859, tasks:20}	keep order:false	N/A	N/A
20:43:55 [2021-05-29T20:43:55.576Z]           │ └─IndexLookUp_64(Probe)	4.02	435528	root		time:2.15s, loops:447, index_task: {total_time: 1.27s, fetch_handle: 1.27s, build: 92.5µs, wait: 290.4µs}, table_task: {total_time: 8.23s, num: 55, concurrency: 60}		20.7 KB	N/A
20:43:55 [2021-05-29T20:43:55.576Z]           │   ├─IndexRangeScan_62(Build)	4.02	435528	cop[tikv]	table:partsupp, index:PRIMARY(PS_PARTKEY, PS_SUPPKEY)	time:1.23s, loops:480, cop_task: {num: 62, max: 247.9ms, min: 4.65ms, avg: 90.9ms, p95: 182.8ms, max_proc_keys: 15288, p95_proc_keys: 14948, tot_proc: 4.92s, tot_wait: 299ms, rpc_num: 62, rpc_time: 5.63s, copr_cache: disabled}, tikv_task:{proc max:202ms, min:4ms, p80:133ms, p95:153ms, iters:705, tasks:62}, scan_detail: {total_process_keys: 435528, total_keys: 544410, rocksdb: {delete_skipped_count: 0, key_skipped_count: 435528, block: {cache_hit_count: 980292, read_count: 0, read_byte: 0 Bytes}}}	range: decided by [eq(tpch50.partsupp.ps_partkey, tpch50.part.p_partkey)], keep order:false	N/A	N/A
20:43:55 [2021-05-29T20:43:55.576Z]           │   └─TableRowIDScan_63(Probe)	4.02	435528	cop[tikv]	table:partsupp	time:2.8s, loops:500, cop_task: {num: 1472, max: 102.3ms, min: 473.6µs, avg: 18.4ms, p95: 36.5ms, max_proc_keys: 916, p95_proc_keys: 524, tot_proc: 19.5s, tot_wait: 5.54s, rpc_num: 1472, rpc_time: 27.1s, copr_cache: disabled}, tikv_task:{proc max:42ms, min:0s, p80:16ms, p95:23ms, iters:5414, tasks:1472}, scan_detail: {total_process_keys: 435528, total_keys: 473497, rocksdb: {delete_skipped_count: 0, key_skipped_count: 194041, block: {cache_hit_count: 3644488, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:43:55 [2021-05-29T20:43:55.576Z]           └─TableReader_101(Probe)	46310896.67	45504356	root		time:34.3s, loops:44290, cop_task: {num: 761, max: 1.17s, min: 261.4ms, avg: 722.9ms, p95: 861.4ms, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 9m6.9s, tot_wait: 138ms, rpc_num: 761, rpc_time: 9m10.1s, copr_cache: disabled}	data:Selection_100	52.6 MB	N/A
20:43:55 [2021-05-29T20:43:55.576Z]             └─Selection_100	46310896.67	45504356	cop[tikv]		tikv_task:{proc max:1.14s, min:250ms, p80:767ms, p95:841ms, 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:43:55 [2021-05-29T20:43:55.576Z]               └─TableFullScan_99	300005811.00	300005811	cop[tikv]	table:lineitem	tikv_task:{proc max:1.07s, min:228ms, p80:735ms, p95:805ms, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:43:55 [2021-05-29T20:43:55.576Z] 
20:43:55 [2021-05-29T20:43:55.576Z] queries/20.sql
20:43:55 [2021-05-29T20:43:55.576Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:43:55 [2021-05-29T20:43:55.576Z] Sort_30	20000.00	8982	root		time:38.4s, loops:10	tpch50.supplier.s_name	634.3 KB	0 Bytes
20:43:55 [2021-05-29T20:43:55.576Z] └─HashJoin_35	20000.00	8982	root		time:38.4s, loops:11, build_hash_table:{total:1.39s, fetch:1.38s, build:11.1ms}, probe:{concurrency:5, total:3m12.2s, max:38.4s, probe:47.2ms, fetch:3m12.1s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.partsupp.ps_suppkey)]	1.51 MB	0 Bytes
20:43:55 [2021-05-29T20:43:55.576Z]   ├─HashJoin_48(Build)	20000.00	19972	root		time:1.38s, loops:23, build_hash_table:{total:195.2µs, fetch:188.8µs, build:6.39µs}, probe:{concurrency:5, total:6.93s, max:1.39s, probe:113.8ms, fetch:6.81s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:43:55 [2021-05-29T20:43:55.576Z]   │ ├─TableReader_53(Build)	1.00	1	root		time:52.2µs, loops:2, cop_task: {num: 1, max: 732.1µs, proc_keys: 25, tot_proc: 1ms, rpc_num: 1, rpc_time: 698.5µs, copr_cache: disabled}	data:Selection_52	244 Bytes	N/A
20:43:55 [2021-05-29T20:43:55.576Z]   │ │ └─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:43:55 [2021-05-29T20:43:55.576Z]   │ │   └─TableFullScan_51	25.00	25	cop[tikv]	table:nation	tikv_task:{time:1ms, loops:1}	keep order:false	N/A	N/A
20:43:55 [2021-05-29T20:43:55.576Z]   │ └─TableReader_50(Probe)	500000.00	500000	root		time:1.36s, loops:490, cop_task: {num: 1, max: 1.36s, proc_keys: 500000, tot_proc: 1.28s, rpc_num: 1, rpc_time: 1.36s, copr_cache: disabled}	data:TableFullScan_49	35.8 MB	N/A
20:43:55 [2021-05-29T20:43:55.576Z]   │   └─TableFullScan_49	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:1.1s, loops:493}, scan_detail: {total_process_keys: 500000, total_keys: 500001, rocksdb: {delete_skipped_count: 0, key_skipped_count: 999999, block: {cache_hit_count: 1692, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:43:55 [2021-05-29T20:43:55.576Z]   └─HashAgg_54(Probe)	257492.04	223999	root		time:38.4s, loops:222, partial_worker:{wall_time:38.352921387s, concurrency:5, task_num:289, tot_wait:3m11.485207612s, tot_exec:228.266089ms, tot_time:3m11.753174396s, max:38.352558068s, p95:38.352558068s}, final_worker:{wall_time:38.431358532s, concurrency:5, task_num:25, tot_wait:3m11.744684251s, tot_exec:355.345387ms, tot_time:3m12.100048637s, max:38.430995117s, p95:38.430995117s}	group by:tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_suppkey)->tpch50.partsupp.ps_suppkey	61.4 MB	N/A
20:43:55 [2021-05-29T20:43:55.576Z]     └─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:43:55 [2021-05-29T20:43:55.576Z]       └─HashAgg_56	321865.05	435528	root		time:38.2s, loops:430, partial_worker:{wall_time:37.967463269s, concurrency:5, task_num:623, tot_wait:3m8.548370857s, tot_exec:1.0545215s, tot_time:3m9.819161791s, max:37.967345231s, p95:37.967345231s}, final_worker:{wall_time:38.340658406s, concurrency:5, task_num:25, tot_wait:3m9.789038397s, tot_exec:1.894947645s, tot_time:3m11.684001446s, max:38.34054668s, p95:38.34054668s}	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:43:55 [2021-05-29T20:43:55.576Z]         └─HashJoin_59	9711455.06	634004	root		time:37.9s, loops:624, build_hash_table:{total:2.46s, fetch:2.26s, build:198.9ms}, probe:{concurrency:5, total:3m9.3s, max:37.9s, probe:13.7s, fetch:2m55.6s}	left outer join, equal:[eq(tpch50.partsupp.ps_partkey, tpch50.lineitem.l_partkey) eq(tpch50.partsupp.ps_suppkey, tpch50.lineitem.l_suppkey)]	10.4 MB	0 Bytes
20:43:55 [2021-05-29T20:43:55.576Z]           ├─IndexHashJoin_67(Build)	321865.05	435528	root		time:2.43s, loops:430, inner:{total:2.49s, concurrency:5, task:12, construct:122.6ms, fetch:2.05s, build:28.5ms, join:314.2ms}	inner join, inner:IndexLookUp_64, outer key:tpch50.part.p_partkey, inner key:tpch50.partsupp.ps_partkey, equal cond:eq(tpch50.part.p_partkey, tpch50.partsupp.ps_partkey)	20.5 MB	N/A
20:43:55 [2021-05-29T20:43:55.576Z]           │ ├─TableReader_96(Build)	80007.93	108882	root		time:2.08s, loops:112, cop_task: {num: 20, max: 1.39s, min: 708.6ms, avg: 1.08s, p95: 1.39s, max_proc_keys: 686055, p95_proc_keys: 686055, tot_proc: 21.6s, tot_wait: 15ms, rpc_num: 20, rpc_time: 21.7s, copr_cache: disabled}	data:Selection_95	680.6 KB	N/A
20:43:55 [2021-05-29T20:43:55.576Z]           │ │ └─Selection_95	80007.93	108882	cop[tikv]		tikv_task:{proc max:1.34s, min:703ms, p80:1.26s, p95:1.34s, iters:9859, tasks:20}, scan_detail: {total_process_keys: 10000000, total_keys: 10000020, rocksdb: {delete_skipped_count: 0, key_skipped_count: 19999980, block: {cache_hit_count: 31499, read_count: 0, read_byte: 0 Bytes}}}	like(tpch50.part.p_name, "green%", 92)	N/A	N/A
20:43:55 [2021-05-29T20:43:55.576Z]           │ │   └─TableFullScan_94	10000000.00	10000000	cop[tikv]	table:part	tikv_task:{proc max:1.24s, min:656ms, p80:1.15s, p95:1.24s, iters:9859, tasks:20}	keep order:false	N/A	N/A
20:43:55 [2021-05-29T20:43:55.576Z]           │ └─IndexLookUp_64(Probe)	4.02	435528	root		time:1.94s, loops:447, index_task: {total_time: 1.14s, fetch_handle: 1.14s, build: 89.2µs, wait: 268.9µs}, table_task: {total_time: 7.69s, num: 56, concurrency: 60}		20.5 KB	N/A
20:43:55 [2021-05-29T20:43:55.576Z]           │   ├─IndexRangeScan_62(Build)	4.02	435528	cop[tikv]	table:partsupp, index:PRIMARY(PS_PARTKEY, PS_SUPPKEY)	time:1.09s, loops:481, cop_task: {num: 58, max: 184.2ms, min: 4.57ms, avg: 88.3ms, p95: 168.6ms, max_proc_keys: 15288, p95_proc_keys: 15008, tot_proc: 4.63s, tot_wait: 48ms, rpc_num: 58, rpc_time: 5.12s, copr_cache: disabled}, tikv_task:{proc max:161ms, min:4ms, p80:135ms, p95:160ms, iters:689, tasks:58}, scan_detail: {total_process_keys: 435528, total_keys: 544410, rocksdb: {delete_skipped_count: 0, key_skipped_count: 435528, block: {cache_hit_count: 980292, read_count: 0, read_byte: 0 Bytes}}}	range: decided by [eq(tpch50.partsupp.ps_partkey, tpch50.part.p_partkey)], keep order:false	N/A	N/A
20:43:55 [2021-05-29T20:43:55.576Z]           │   └─TableRowIDScan_63(Probe)	4.02	435528	cop[tikv]	table:partsupp	time:2.5s, loops:504, cop_task: {num: 1482, max: 84ms, min: 527.3µs, avg: 17.8ms, p95: 36.2ms, max_proc_keys: 932, p95_proc_keys: 516, tot_proc: 19.3s, tot_wait: 4.42s, rpc_num: 1482, rpc_time: 26.3s, copr_cache: disabled}, tikv_task:{proc max:42ms, min:0s, p80:16ms, p95:22ms, iters:5426, tasks:1482}, scan_detail: {total_process_keys: 435528, total_keys: 473494, rocksdb: {delete_skipped_count: 0, key_skipped_count: 194036, block: {cache_hit_count: 3644502, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:43:55 [2021-05-29T20:43:55.576Z]           └─TableReader_101(Probe)	46310896.67	45504356	root		time:33.5s, loops:44290, cop_task: {num: 761, max: 1.15s, min: 296.1ms, avg: 708.3ms, p95: 857ms, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 8m55.9s, tot_wait: 125ms, rpc_num: 761, rpc_time: 8m59s, copr_cache: disabled}	data:Selection_100	52.6 MB	N/A
20:43:55 [2021-05-29T20:43:55.576Z]             └─Selection_100	46310896.67	45504356	cop[tikv]		tikv_task:{proc max:1.1s, min:284ms, p80:755ms, p95:838ms, iters:296606, tasks:761}, scan_detail: {total_process_keys: 300005811, total_keys: 300006572, rocksdb: {delete_skipped_count: 0, key_skipped_count: 600010861, block: {cache_hit_count: 1124648, read_count: 0, read_byte: 0 Bytes}}}	ge(tpch50.lineitem.l_shipdate, 1993-01-01 00:00:00.000000), lt(tpch50.lineitem.l_shipdate, 1994-01-01)	N/A	N/A
20:43:55 [2021-05-29T20:43:55.576Z]               └─TableFullScan_99	300005811.00	300005811	cop[tikv]	table:lineitem	tikv_task:{proc max:1.06s, min:274ms, p80:722ms, p95:806ms, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:43:55 [2021-05-29T20:43:55.576Z] + sync
20:43:55 [2021-05-29T20:43:55.576Z] + /usr/bin/echo 3
20:44:42 [2021-05-29T20:44:42.202Z] + tiup cluster stop benchbot -y
20:44:42 [2021-05-29T20:44:42.202Z] Starting component `cluster`: /home/tidb/.tiup/components/cluster/v1.4.4/tiup-cluster stop benchbot -y
20:45:02 [2021-05-29T20:45:02.838Z] + rm -rf '/data1/tidb-deploy/*/log/*'
20:45:02 [2021-05-29T20:45:02.838Z] + rm -rf /data1/jenkins/deploy/data/tikv-20160
20:45:02 [2021-05-29T20:45:02.838Z] + rm -rf /data1/jenkins/deploy/data/pd-2379
20:45:02 [2021-05-29T20:45:02.838Z] + rm -rf /data1/jenkins/restore_data/tpch50/data/last_tikv.toml
20:45:02 [2021-05-29T20:45:02.838Z] + cp -R /data1/jenkins/restore_data/tpch50/data /data1/jenkins/deploy/data/tikv-20160
20:46:39 [2021-05-29T20:46:39.230Z] + cp -R /data1/jenkins/restore_data/tpch50/data.pd /data1/jenkins/deploy/data/pd-2379
20:46:39 [2021-05-29T20:46:39.230Z] + '[' -n '' ']'
20:46:39 [2021-05-29T20:46:39.230Z] + tiup cluster start benchbot --wait-timeout=300
20:46:39 [2021-05-29T20:46:39.230Z] Starting component `cluster`: /home/tidb/.tiup/components/cluster/v1.4.4/tiup-cluster start benchbot --wait-timeout=300
20:47:01 [2021-05-29T20:47:01.135Z] + sync
20:47:01 [2021-05-29T20:47:01.135Z] + /usr/bin/echo 3
20:48:37 [2021-05-29T20:48:37.895Z] 
20:48:37 [2021-05-29T20:48:37.895Z] queries/20.sql
20:48:37 [2021-05-29T20:48:37.895Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:48:37 [2021-05-29T20:48:37.895Z] Sort_30	20000.00	8982	root		time:38.8s, loops:10	tpch50.supplier.s_name	634.3 KB	0 Bytes
20:48:37 [2021-05-29T20:48:37.895Z] └─HashJoin_35	20000.00	8982	root		time:38.8s, loops:11, build_hash_table:{total:1.34s, fetch:1.32s, build:14.2ms}, probe:{concurrency:5, total:3m13.9s, max:38.8s, probe:49.6ms, fetch:3m13.9s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.partsupp.ps_suppkey)]	1.51 MB	0 Bytes
20:48:37 [2021-05-29T20:48:37.895Z]   ├─HashJoin_48(Build)	20000.00	19972	root		time:1.33s, loops:23, build_hash_table:{total:277.3µs, fetch:270.7µs, build:6.66µs}, probe:{concurrency:5, total:6.67s, max:1.33s, probe:107.6ms, fetch:6.56s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:48:37 [2021-05-29T20:48:37.895Z]   │ ├─TableReader_53(Build)	1.00	1	root		time:63.8µs, loops:2, cop_task: {num: 1, max: 1.12ms, proc_keys: 25, tot_proc: 1ms, rpc_num: 1, rpc_time: 1.06ms, copr_cache: disabled}	data:Selection_52	244 Bytes	N/A
20:48:37 [2021-05-29T20:48:37.895Z]   │ │ └─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:48:37 [2021-05-29T20:48:37.895Z]   │ │   └─TableFullScan_51	25.00	25	cop[tikv]	table:nation	tikv_task:{time:1ms, loops:1}	keep order:false	N/A	N/A
20:48:37 [2021-05-29T20:48:37.895Z]   │ └─TableReader_50(Probe)	500000.00	500000	root		time:1.31s, loops:490, cop_task: {num: 1, max: 1.31s, proc_keys: 500000, tot_proc: 1.23s, rpc_num: 1, rpc_time: 1.31s, copr_cache: disabled}	data:TableFullScan_49	35.8 MB	N/A
20:48:37 [2021-05-29T20:48:37.895Z]   │   └─TableFullScan_49	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:1.09s, loops:493}, scan_detail: {total_process_keys: 500000, total_keys: 500001, rocksdb: {delete_skipped_count: 0, key_skipped_count: 999999, block: {cache_hit_count: 1692, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:48:37 [2021-05-29T20:48:37.895Z]   └─HashAgg_54(Probe)	257492.04	223999	root		time:38.8s, loops:222, partial_worker:{wall_time:38.672868309s, concurrency:5, task_num:289, tot_wait:3m13.121942241s, tot_exec:201.053915ms, tot_time:3m13.360552686s, max:38.672829868s, p95:38.672829868s}, final_worker:{wall_time:38.786534136s, concurrency:5, task_num:25, tot_wait:3m13.355337019s, tot_exec:554.544039ms, tot_time:3m13.90989746s, max:38.786505566s, p95:38.786505566s}	group by:tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_suppkey)->tpch50.partsupp.ps_suppkey	61.4 MB	N/A
20:48:37 [2021-05-29T20:48:37.895Z]     └─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:48:37 [2021-05-29T20:48:37.896Z]       └─HashAgg_56	321865.05	435528	root		time:38.6s, loops:430, partial_worker:{wall_time:38.350658832s, concurrency:5, task_num:623, tot_wait:3m10.512552776s, tot_exec:1.043140558s, tot_time:3m11.694678803s, max:38.350594159s, p95:38.350594159s}, final_worker:{wall_time:38.661999757s, concurrency:5, task_num:25, tot_wait:3m11.615539557s, tot_exec:1.672366466s, tot_time:3m13.287922637s, max:38.661965231s, p95:38.661965231s}	group by:tpch50.partsupp.ps_partkey, tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_suppkey)->tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_availqty)->tpch50.partsupp.ps_availqty, funcs:sum(tpch50.lineitem.l_quantity)->Column#44	194.5 MB	N/A
20:48:37 [2021-05-29T20:48:37.896Z]         └─HashJoin_59	9711455.06	634004	root		time:38.3s, loops:624, build_hash_table:{total:2.56s, fetch:2.37s, build:195.2ms}, probe:{concurrency:5, total:3m11.3s, max:38.3s, probe:13.6s, fetch:2m57.7s}	left outer join, equal:[eq(tpch50.partsupp.ps_partkey, tpch50.lineitem.l_partkey) eq(tpch50.partsupp.ps_suppkey, tpch50.lineitem.l_suppkey)]	10.4 MB	0 Bytes
20:48:37 [2021-05-29T20:48:37.896Z]           ├─IndexHashJoin_67(Build)	321865.05	435528	root		time:2.53s, loops:430, inner:{total:2.67s, concurrency:5, task:12, construct:117.3ms, fetch:2.23s, build:33.1ms, join:313.9ms}	inner join, inner:IndexLookUp_64, outer key:tpch50.part.p_partkey, inner key:tpch50.partsupp.ps_partkey, equal cond:eq(tpch50.part.p_partkey, tpch50.partsupp.ps_partkey)	20.5 MB	N/A
20:48:37 [2021-05-29T20:48:37.896Z]           │ ├─TableReader_96(Build)	80007.93	108882	root		time:2.18s, loops:112, cop_task: {num: 20, max: 1.38s, min: 609.6ms, avg: 1.08s, p95: 1.38s, max_proc_keys: 686055, p95_proc_keys: 686055, tot_proc: 21.6s, tot_wait: 22ms, rpc_num: 20, rpc_time: 21.6s, copr_cache: disabled}	data:Selection_95	725.8 KB	N/A
20:48:37 [2021-05-29T20:48:37.896Z]           │ │ └─Selection_95	80007.93	108882	cop[tikv]		tikv_task:{proc max:1.37s, min:606ms, p80:1.32s, p95:1.37s, iters:9859, tasks:20}, scan_detail: {total_process_keys: 10000000, total_keys: 10000020, rocksdb: {delete_skipped_count: 0, key_skipped_count: 19999980, block: {cache_hit_count: 31499, read_count: 0, read_byte: 0 Bytes}}}	like(tpch50.part.p_name, "green%", 92)	N/A	N/A
20:48:37 [2021-05-29T20:48:37.896Z]           │ │   └─TableFullScan_94	10000000.00	10000000	cop[tikv]	table:part	tikv_task:{proc max:1.28s, min:563ms, p80:1.22s, p95:1.28s, iters:9859, tasks:20}	keep order:false	N/A	N/A
20:48:37 [2021-05-29T20:48:37.896Z]           │ └─IndexLookUp_64(Probe)	4.02	435528	root		time:2.15s, loops:447, index_task: {total_time: 1.18s, fetch_handle: 1.18s, build: 77.3µs, wait: 247.9µs}, table_task: {total_time: 8.14s, num: 55, concurrency: 60}		20.7 KB	N/A
20:48:37 [2021-05-29T20:48:37.896Z]           │   ├─IndexRangeScan_62(Build)	4.02	435528	cop[tikv]	table:partsupp, index:PRIMARY(PS_PARTKEY, PS_SUPPKEY)	time:1.14s, loops:474, cop_task: {num: 59, max: 238ms, min: 4.97ms, avg: 89.6ms, p95: 190.9ms, max_proc_keys: 15288, p95_proc_keys: 15048, tot_proc: 4.78s, tot_wait: 46ms, rpc_num: 59, rpc_time: 5.29s, copr_cache: disabled}, tikv_task:{proc max:221ms, min:4ms, p80:135ms, p95:174ms, 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:48:37 [2021-05-29T20:48:37.896Z]           │   └─TableRowIDScan_63(Probe)	4.02	435528	cop[tikv]	table:partsupp	time:2.78s, loops:502, cop_task: {num: 1378, max: 105.8ms, min: 934.8µs, avg: 20.2ms, p95: 42.8ms, max_proc_keys: 1028, p95_proc_keys: 624, tot_proc: 19.9s, tot_wait: 5.55s, rpc_num: 1378, rpc_time: 27.8s, copr_cache: disabled}, tikv_task:{proc max:52ms, min:0s, p80:18ms, p95:28ms, iters:5184, tasks:1378}, scan_detail: {total_process_keys: 435528, total_keys: 473512, rocksdb: {delete_skipped_count: 0, key_skipped_count: 194112, block: {cache_hit_count: 3643706, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:48:37 [2021-05-29T20:48:37.896Z]           └─TableReader_101(Probe)	46310896.67	45504356	root		time:33.9s, loops:44289, cop_task: {num: 761, max: 1.15s, min: 372.9ms, avg: 712.5ms, p95: 883.7ms, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 8m59.1s, tot_wait: 133ms, rpc_num: 761, rpc_time: 9m2.2s, copr_cache: disabled}	data:Selection_100	52.6 MB	N/A
20:48:37 [2021-05-29T20:48:37.896Z]             └─Selection_100	46310896.67	45504356	cop[tikv]		tikv_task:{proc max:1.11s, min:366ms, p80:762ms, p95:863ms, iters:296606, tasks:761}, scan_detail: {total_process_keys: 300005811, total_keys: 300006572, rocksdb: {delete_skipped_count: 0, key_skipped_count: 600010861, block: {cache_hit_count: 1124648, read_count: 0, read_byte: 0 Bytes}}}	ge(tpch50.lineitem.l_shipdate, 1993-01-01 00:00:00.000000), lt(tpch50.lineitem.l_shipdate, 1994-01-01)	N/A	N/A
20:48:37 [2021-05-29T20:48:37.896Z]               └─TableFullScan_99	300005811.00	300005811	cop[tikv]	table:lineitem	tikv_task:{proc max:1.06s, min:344ms, p80:731ms, p95:832ms, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:48:37 [2021-05-29T20:48:37.896Z] 
20:48:37 [2021-05-29T20:48:37.896Z] queries/21.sql
20:48:37 [2021-05-29T20:48:37.896Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:48:37 [2021-05-29T20:48:37.896Z] Projection_26	100.00	100	root		time:1m21.1s, loops:2, Concurrency:OFF	tpch50.supplier.s_name, Column#72	4.37 KB	N/A
20:48:37 [2021-05-29T20:48:37.896Z] └─TopN_29	100.00	100	root		time:1m21.1s, loops:2	Column#72:desc, tpch50.supplier.s_name, offset:0, count:100	58.3 KB	N/A
20:48:37 [2021-05-29T20:48:37.896Z]   └─HashAgg_34	12800.00	20057	root		time:1m21.1s, loops:21, partial_worker:{wall_time:1m21.053152633s, concurrency:5, task_num:198, tot_wait:6m44.969158036s, tot_exec:278.587095ms, tot_time:6m45.26319143s, max:1m21.053134998s, p95:1m21.053134998s}, final_worker:{wall_time:1m21.066250625s, concurrency:5, task_num:25, tot_wait:6m45.260051823s, tot_exec:70.219187ms, tot_time:6m45.330285225s, max:1m21.066179874s, p95:1m21.066179874s}	group by:tpch50.supplier.s_name, funcs:count(1)->Column#72, funcs:firstrow(tpch50.supplier.s_name)->tpch50.supplier.s_name	17.3 MB	N/A
20:48:37 [2021-05-29T20:48:37.896Z]     └─IndexHashJoin_42	7828961.66	198698	root		time:1m21s, loops:199, inner:{total:2m18.1s, concurrency:5, task:147, construct:6.38s, fetch:1m54.1s, build:1.21s, join:17.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:48:37 [2021-05-29T20:48:37.896Z]       ├─IndexHashJoin_83(Build)	9786202.08	3542799	root		time:1m20.5s, loops:3464, inner:{total:2m27.9s, concurrency:5, task:152, construct:8.06s, fetch:2m1.2s, build:1.3s, join:18.7s}	semi join, inner:IndexLookUp_80, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey), ne(tpch50.lineitem.l_suppkey, tpch50.supplier.s_suppkey)	555.9 MB	N/A
20:48:37 [2021-05-29T20:48:37.896Z]       │ ├─IndexJoin_99(Build)	12232752.60	3675878	root		time:1m20s, loops:3595, inner:{total:2m6.5s, concurrency:5, task:305, construct:16.1s, fetch:1m48.5s, build:1.84s}, probe:5.25s	inner join, inner:TableReader_95, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.orders.o_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.orders.o_orderkey)	581.9 MB	N/A
20:48:37 [2021-05-29T20:48:37.896Z]       │ │ ├─HashJoin_107(Build)	12232752.60	7609895	root		time:1m19.4s, loops:7437, build_hash_table:{total:817.1ms, fetch:807.2ms, build:9.81ms}, probe:{concurrency:5, total:6m40s, max:1m20s, probe:1m3.8s, fetch:5m36.2s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.lineitem.l_suppkey)]	742.5 KB	0 Bytes
20:48:37 [2021-05-29T20:48:37.896Z]       │ │ │ ├─HashJoin_120(Build)	20000.00	20058	root		time:813.1ms, loops:23, build_hash_table:{total:889.9µs, fetch:706.9µs, build:183µs}, probe:{concurrency:5, total:4.07s, max:814.1ms, probe:81.9ms, fetch:3.99s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:48:37 [2021-05-29T20:48:37.896Z]       │ │ │ │ ├─TableReader_125(Build)	1.00	1	root		time:617.1µs, loops:2, cop_task: {num: 1, max: 872.4µs, proc_keys: 25, rpc_num: 1, rpc_time: 857.3µs, copr_cache: disabled}	data:Selection_124	234 Bytes	N/A
20:48:37 [2021-05-29T20:48:37.896Z]       │ │ │ │ │ └─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:48:37 [2021-05-29T20:48:37.896Z]       │ │ │ │ │   └─TableFullScan_123	25.00	25	cop[tikv]	table:nation	tikv_task:{time:0s, loops:1}	keep order:false	N/A	N/A
20:48:37 [2021-05-29T20:48:37.896Z]       │ │ │ │ └─TableReader_122(Probe)	500000.00	500000	root		time:797.3ms, loops:490, cop_task: {num: 1, max: 904.6ms, proc_keys: 500000, tot_proc: 876ms, rpc_num: 1, rpc_time: 904.2ms, copr_cache: disabled}	data:TableFullScan_121	20.0 MB	N/A
20:48:37 [2021-05-29T20:48:37.896Z]       │ │ │ │   └─TableFullScan_121	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:828ms, loops:493}, scan_detail: {total_process_keys: 500000, total_keys: 500001, rocksdb: {delete_skipped_count: 0, key_skipped_count: 999999, block: {cache_hit_count: 15, read_count: 1689, read_byte: 108.5 MB}}}	keep order:false	N/A	N/A
20:48:37 [2021-05-29T20:48:37.896Z]       │ │ │ └─TableReader_128(Probe)	240004648.80	189670348	root		time:1m7.2s, loops:184597, cop_task: {num: 761, max: 2.73s, min: 297.1ms, avg: 1.53s, p95: 2.02s, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 18m12.6s, tot_wait: 59.6s, rpc_num: 761, rpc_time: 19m26.2s, copr_cache: disabled}	data:Selection_127	91.6 MB	N/A
20:48:37 [2021-05-29T20:48:37.896Z]       │ │ │   └─Selection_127	240004648.80	189670348	cop[tikv]		tikv_task:{proc max:1.38s, min:277ms, p80:1.19s, p95:1.24s, iters:296606, tasks:761}, scan_detail: {total_process_keys: 300005811, total_keys: 300006572, rocksdb: {delete_skipped_count: 0, key_skipped_count: 600010861, block: {cache_hit_count: 18690, read_count: 1131785, read_byte: 23.9 GB}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:48:37 [2021-05-29T20:48:37.896Z]       │ │ │     └─TableFullScan_126	300005811.00	300005811	cop[tikv]	table:l1	tikv_task:{proc max:1.3s, min:260ms, p80:1.11s, p95:1.16s, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:48:37 [2021-05-29T20:48:37.896Z]       │ │ └─TableReader_95(Probe)	0.49	3496186	root		time:1m39.2s, loops:3875, cop_task: {num: 5247, max: 646.7ms, min: 1.06ms, avg: 179.1ms, p95: 336.2ms, max_proc_keys: 3553, p95_proc_keys: 1953, tot_proc: 11m4.5s, tot_wait: 3m48.7s, rpc_num: 5247, rpc_time: 15m39.6s, copr_cache: disabled}	data:Selection_94	N/A	N/A
20:48:37 [2021-05-29T20:48:37.896Z]       │ │   └─Selection_94	0.49	3496186	cop[tikv]		tikv_task:{proc max:146ms, min:0s, p80:70ms, p95:84ms, iters:30186, tasks:5247}, scan_detail: {total_process_keys: 7236296, total_keys: 7795527, rocksdb: {delete_skipped_count: 0, key_skipped_count: 1778391, block: {cache_hit_count: 54006605, read_count: 219934, read_byte: 4.61 GB}}}	eq(tpch50.orders.o_orderstatus, "F")	N/A	N/A
20:48:37 [2021-05-29T20:48:37.896Z]       │ │     └─TableRangeScan_93	1.00	7236296	cop[tikv]	table:orders	tikv_task:{proc max:145ms, min:0s, p80:70ms, p95:83ms, iters:30186, tasks:5247}	range: decided by [tpch50.lineitem.l_orderkey], keep order:false	N/A	N/A
20:48:37 [2021-05-29T20:48:37.896Z]       │ └─IndexLookUp_80(Probe)	4.05	17316447	root		time:1m55.7s, loops:17136, index_task: {total_time: 1m4.3s, fetch_handle: 57.2s, build: 3.02ms, wait: 7.09s}, table_task: {total_time: 8m18.4s, num: 1458, concurrency: 760}		19.0 KB	N/A
20:48:37 [2021-05-29T20:48:37.896Z]       │   ├─IndexRangeScan_78(Build)	4.05	17316447	cop[tikv]	table:l2, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:54.9s, loops:18615, cop_task: {num: 2991, max: 700.1ms, min: 1.13ms, avg: 187.2ms, p95: 373.2ms, max_proc_keys: 14545, p95_proc_keys: 8740, tot_proc: 6m57.5s, tot_wait: 1m59.1s, rpc_num: 2991, rpc_time: 9m19.8s, copr_cache: disabled}, tikv_task:{proc max:174ms, min:0s, p80:97ms, p95:113ms, iters:30136, tasks:2991}, scan_detail: {total_process_keys: 17316447, total_keys: 20812547, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17316447, block: {cache_hit_count: 24260174, read_count: 226869, read_byte: 2.40 GB}}}	range: decided by [eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey)], keep order:false	N/A	N/A
20:48:37 [2021-05-29T20:48:37.896Z]       │   └─TableRowIDScan_79(Probe)	4.05	17316447	cop[tikv]	table:l2	time:6m3.8s, loops:21027, cop_task: {num: 7793, max: 736.4ms, min: 476.1µs, avg: 171.7ms, p95: 347.3ms, max_proc_keys: 10573, p95_proc_keys: 4825, tot_proc: 15m57.3s, tot_wait: 5m22.8s, rpc_num: 7793, rpc_time: 22m17.5s, copr_cache: disabled}, tikv_task:{proc max:265ms, min:0s, p80:105ms, p95:141ms, iters:50022, tasks:7793}, scan_detail: {total_process_keys: 17316447, total_keys: 18286860, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5619373, block: {cache_hit_count: 99022293, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:48:37 [2021-05-29T20:48:37.896Z]       └─IndexLookUp_39(Probe)	4.05	12022786	root		time:1m49.2s, loops:11947, index_task: {total_time: 59.2s, fetch_handle: 49.8s, build: 3.04ms, wait: 9.47s}, table_task: {total_time: 7m51s, num: 1410, concurrency: 735}		216.0 KB	N/A
20:48:37 [2021-05-29T20:48:37.897Z]         ├─IndexRangeScan_36(Build)	5.06	17183389	cop[tikv]	table:l3, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:47.4s, loops:18356, cop_task: {num: 2774, max: 899.2ms, min: 440.8µs, avg: 163.7ms, p95: 354.2ms, max_proc_keys: 18550, p95_proc_keys: 13334, tot_proc: 5m33s, tot_wait: 1m38s, rpc_num: 2774, rpc_time: 7m34.1s, copr_cache: disabled}, tikv_task:{proc max:234ms, min:0s, p80:76ms, p95:117ms, iters:29050, tasks:2774}, scan_detail: {total_process_keys: 17183389, total_keys: 20546414, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17183389, 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:48:37 [2021-05-29T20:48:37.897Z]         └─Selection_38(Probe)	4.05	12022786	cop[tikv]		time:5m59.6s, loops:13775, cop_task: {num: 10250, max: 790.2ms, min: 501.6µs, avg: 168.7ms, p95: 344.9ms, max_proc_keys: 7468, p95_proc_keys: 3919, tot_proc: 20m2.9s, tot_wait: 7m30.8s, rpc_num: 10250, rpc_time: 28m49.2s, copr_cache: disabled}, tikv_task:{proc max:238ms, min:0s, p80:75ms, p95:115ms, iters:60834, tasks:10250}, scan_detail: {total_process_keys: 17183389, total_keys: 18128859, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5526668, block: {cache_hit_count: 98288570, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:48:37 [2021-05-29T20:48:37.897Z]           └─TableRowIDScan_37	5.06	17183389	cop[tikv]	table:l3	tikv_task:{proc max:238ms, min:0s, p80:75ms, p95:114ms, iters:60834, tasks:10250}	keep order:false	N/A	N/A
20:48:37 [2021-05-29T20:48:37.897Z] + sync
20:48:37 [2021-05-29T20:48:37.897Z] + /usr/bin/echo 3
20:49:59 [2021-05-29T20:49:59.361Z] 
20:49:59 [2021-05-29T20:49:59.361Z] queries/21.sql
20:49:59 [2021-05-29T20:49:59.361Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:49:59 [2021-05-29T20:49:59.361Z] Projection_26	100.00	100	root		time:1m20s, loops:2, Concurrency:OFF	tpch50.supplier.s_name, Column#72	4.37 KB	N/A
20:49:59 [2021-05-29T20:49:59.361Z] └─TopN_29	100.00	100	root		time:1m20s, loops:2	Column#72:desc, tpch50.supplier.s_name, offset:0, count:100	58.3 KB	N/A
20:49:59 [2021-05-29T20:49:59.361Z]   └─HashAgg_34	12800.00	20057	root		time:1m20s, loops:21, partial_worker:{wall_time:1m19.9985382s, concurrency:5, task_num:197, tot_wait:6m39.692594169s, tot_exec:284.756531ms, tot_time:6m39.9913259s, max:1m19.998490033s, p95:1m19.998490033s}, final_worker:{wall_time:1m20.013154905s, concurrency:5, task_num:25, tot_wait:6m39.990698015s, tot_exec:73.71412ms, tot_time:6m40.064424018s, max:1m20.01311414s, p95:1m20.01311414s}	group by:tpch50.supplier.s_name, funcs:count(1)->Column#72, funcs:firstrow(tpch50.supplier.s_name)->tpch50.supplier.s_name	17.3 MB	N/A
20:49:59 [2021-05-29T20:49:59.361Z]     └─IndexHashJoin_42	7828961.66	198698	root		time:1m20s, loops:198, inner:{total:2m22.5s, concurrency:5, task:146, construct:6.49s, fetch:1m58.3s, build:1.27s, join:17.7s}	anti semi join, inner:IndexLookUp_39, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey)	641.1 MB	N/A
20:49:59 [2021-05-29T20:49:59.361Z]       ├─IndexHashJoin_83(Build)	9786202.08	3542799	root		time:1m19.4s, loops:3463, inner:{total:2m29.4s, concurrency:5, task:152, construct:7.9s, fetch:2m2.8s, build:1.27s, join:18.7s}	semi join, inner:IndexLookUp_80, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey), ne(tpch50.lineitem.l_suppkey, tpch50.supplier.s_suppkey)	555.9 MB	N/A
20:49:59 [2021-05-29T20:49:59.361Z]       │ ├─IndexJoin_99(Build)	12232752.60	3675878	root		time:1m18.9s, loops:3595, inner:{total:2m6s, concurrency:5, task:305, construct:16.3s, fetch:1m47.8s, build:1.84s}, probe:5.3s	inner join, inner:TableReader_95, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.orders.o_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.orders.o_orderkey)	582.2 MB	N/A
20:49:59 [2021-05-29T20:49:59.361Z]       │ │ ├─HashJoin_107(Build)	12232752.60	7609895	root		time:1m18.3s, loops:7437, build_hash_table:{total:1.06s, fetch:1.05s, build:7.51ms}, probe:{concurrency:5, total:6m34.1s, max:1m18.8s, probe:1m2.6s, fetch:5m31.5s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.lineitem.l_suppkey)]	722.8 KB	0 Bytes
20:49:59 [2021-05-29T20:49:59.361Z]       │ │ │ ├─HashJoin_120(Build)	20000.00	20058	root		time:1.05s, loops:22, build_hash_table:{total:192.5µs, fetch:184.5µs, build:8.03µs}, probe:{concurrency:5, total:5.27s, max:1.05s, probe:68.7ms, fetch:5.2s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:49:59 [2021-05-29T20:49:59.361Z]       │ │ │ │ ├─TableReader_125(Build)	1.00	1	root		time:62µs, loops:2, cop_task: {num: 1, max: 1.46ms, proc_keys: 25, rpc_num: 1, rpc_time: 1.42ms, copr_cache: disabled}	data:Selection_124	244 Bytes	N/A
20:49:59 [2021-05-29T20:49:59.361Z]       │ │ │ │ │ └─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:49:59 [2021-05-29T20:49:59.361Z]       │ │ │ │ │   └─TableFullScan_123	25.00	25	cop[tikv]	table:nation	tikv_task:{time:0s, loops:1}	keep order:false	N/A	N/A
20:49:59 [2021-05-29T20:49:59.361Z]       │ │ │ │ └─TableReader_122(Probe)	500000.00	500000	root		time:1.04s, loops:490, cop_task: {num: 1, max: 1.04s, proc_keys: 500000, tot_proc: 1s, tot_wait: 4ms, rpc_num: 1, rpc_time: 1.04s, copr_cache: disabled}	data:TableFullScan_121	20.0 MB	N/A
20:49:59 [2021-05-29T20:49:59.361Z]       │ │ │ │   └─TableFullScan_121	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:941ms, loops:493}, scan_detail: {total_process_keys: 500000, total_keys: 500001, rocksdb: {delete_skipped_count: 0, key_skipped_count: 999999, block: {cache_hit_count: 13, read_count: 1679, read_byte: 104.5 MB}}}	keep order:false	N/A	N/A
20:49:59 [2021-05-29T20:49:59.361Z]       │ │ │ └─TableReader_128(Probe)	240004648.80	189670348	root		time:1m5.9s, loops:184597, cop_task: {num: 761, max: 2.43s, min: 252.1ms, avg: 1.51s, p95: 1.98s, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 17m55.5s, tot_wait: 57.5s, rpc_num: 761, rpc_time: 19m7.2s, copr_cache: disabled}	data:Selection_127	109.4 MB	N/A
20:49:59 [2021-05-29T20:49:59.362Z]       │ │ │   └─Selection_127	240004648.80	189670348	cop[tikv]		tikv_task:{proc max:1.35s, min:233ms, p80:1.16s, p95:1.21s, iters:296606, tasks:761}, scan_detail: {total_process_keys: 300005811, total_keys: 300006572, rocksdb: {delete_skipped_count: 0, key_skipped_count: 600010861, block: {cache_hit_count: 10452, read_count: 1114196, read_byte: 23.6 GB}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:49:59 [2021-05-29T20:49:59.362Z]       │ │ │     └─TableFullScan_126	300005811.00	300005811	cop[tikv]	table:l1	tikv_task:{proc max:1.26s, min:221ms, p80:1.08s, p95:1.14s, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:49:59 [2021-05-29T20:49:59.362Z]       │ │ └─TableReader_95(Probe)	0.49	3496190	root		time:1m38.6s, loops:3875, cop_task: {num: 5282, max: 555.1ms, min: 1.11ms, avg: 174.5ms, p95: 325.7ms, max_proc_keys: 3633, p95_proc_keys: 1956, tot_proc: 10m56.7s, tot_wait: 3m37.8s, rpc_num: 5282, rpc_time: 15m21.7s, copr_cache: disabled}	data:Selection_94	N/A	N/A
20:49:59 [2021-05-29T20:49:59.362Z]       │ │   └─Selection_94	0.49	3496190	cop[tikv]		tikv_task:{proc max:152ms, min:0s, p80:69ms, p95:83ms, iters:30306, tasks:5282}, scan_detail: {total_process_keys: 7236278, total_keys: 7795538, rocksdb: {delete_skipped_count: 0, key_skipped_count: 1778432, block: {cache_hit_count: 54008351, read_count: 216275, read_byte: 4.18 GB}}}	eq(tpch50.orders.o_orderstatus, "F")	N/A	N/A
20:49:59 [2021-05-29T20:49:59.362Z]       │ │     └─TableRangeScan_93	1.00	7236278	cop[tikv]	table:orders	tikv_task:{proc max:152ms, min:0s, p80:68ms, p95:82ms, iters:30306, tasks:5282}	range: decided by [tpch50.lineitem.l_orderkey], keep order:false	N/A	N/A
20:49:59 [2021-05-29T20:49:59.362Z]       │ └─IndexLookUp_80(Probe)	4.05	17316565	root		time:1m57.3s, loops:17130, index_task: {total_time: 1m5.2s, fetch_handle: 57s, build: 2.98ms, wait: 8.17s}, table_task: {total_time: 8m26.2s, num: 1458, concurrency: 760}		19.2 KB	N/A
20:49:59 [2021-05-29T20:49:59.362Z]       │   ├─IndexRangeScan_78(Build)	4.05	17316565	cop[tikv]	table:l2, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:54.7s, loops:18629, cop_task: {num: 3020, max: 871.3ms, min: 705.1µs, avg: 186.1ms, p95: 375.3ms, max_proc_keys: 13053, p95_proc_keys: 8716, tot_proc: 6m57.2s, tot_wait: 2m0s, rpc_num: 3020, rpc_time: 9m22s, copr_cache: disabled}, tikv_task:{proc max:174ms, min:0s, p80:95ms, p95:110ms, iters:30209, tasks:3020}, scan_detail: {total_process_keys: 17316565, total_keys: 20812687, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17316565, block: {cache_hit_count: 24260090, read_count: 225692, read_byte: 2.00 GB}}}	range: decided by [eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey)], keep order:false	N/A	N/A
20:49:59 [2021-05-29T20:49:59.362Z]       │   └─TableRowIDScan_79(Probe)	4.05	17316565	cop[tikv]	table:l2	time:6m14.4s, loops:20995, cop_task: {num: 7801, max: 619.2ms, min: 472µs, avg: 175.5ms, p95: 353.4ms, max_proc_keys: 9655, p95_proc_keys: 4847, tot_proc: 16m17.4s, tot_wait: 5m32.6s, rpc_num: 7801, rpc_time: 22m48.8s, copr_cache: disabled}, tikv_task:{proc max:241ms, min:0s, p80:104ms, p95:139ms, iters:49930, tasks:7801}, scan_detail: {total_process_keys: 17316565, total_keys: 18289563, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5629924, block: {cache_hit_count: 99018788, read_count: 1120, read_byte: 397.2 MB}}}	keep order:false	N/A	N/A
20:49:59 [2021-05-29T20:49:59.362Z]       └─IndexLookUp_39(Probe)	4.05	12022850	root		time:1m53.3s, loops:11945, index_task: {total_time: 59.9s, fetch_handle: 49.7s, build: 3ms, wait: 10.2s}, table_task: {total_time: 8m8.1s, num: 1408, concurrency: 730}		267.1 KB	N/A
20:49:59 [2021-05-29T20:49:59.362Z]         ├─IndexRangeScan_36(Build)	5.06	17183478	cop[tikv]	table:l3, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:47.3s, loops:18373, cop_task: {num: 2780, max: 778.9ms, min: 471.5µs, avg: 169.3ms, p95: 364.1ms, max_proc_keys: 19219, p95_proc_keys: 13866, tot_proc: 5m45.9s, tot_wait: 1m40.9s, rpc_num: 2780, rpc_time: 7m50.7s, copr_cache: disabled}, tikv_task:{proc max:184ms, min:0s, p80:77ms, p95:119ms, iters:29048, tasks:2780}, scan_detail: {total_process_keys: 17183478, total_keys: 20546519, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17183478, block: {cache_hit_count: 23554093, 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:59 [2021-05-29T20:49:59.362Z]         └─Selection_38(Probe)	4.05	12022850	cop[tikv]		time:6m12.2s, loops:13785, cop_task: {num: 10193, max: 650.9ms, min: 434µs, avg: 172.3ms, p95: 349.1ms, max_proc_keys: 8346, p95_proc_keys: 3986, tot_proc: 20m26.7s, tot_wait: 7m33.4s, rpc_num: 10193, rpc_time: 29m16.2s, copr_cache: disabled}, tikv_task:{proc max:224ms, min:0s, p80:76ms, p95:116ms, iters:60509, tasks:10193}, scan_detail: {total_process_keys: 17183478, total_keys: 18129326, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5527742, block: {cache_hit_count: 98288160, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:49:59 [2021-05-29T20:49:59.362Z]           └─TableRowIDScan_37	5.06	17183478	cop[tikv]	table:l3	tikv_task:{proc max:224ms, min:0s, p80:76ms, p95:115ms, iters:60509, tasks:10193}	keep order:false	N/A	N/A
20:49:59 [2021-05-29T20:49:59.362Z] + sync
20:49:59 [2021-05-29T20:49:59.362Z] + /usr/bin/echo 3
20:51:20 [2021-05-29T20:51:20.743Z] 
20:51:20 [2021-05-29T20:51:20.743Z] queries/21.sql
20:51:20 [2021-05-29T20:51:20.743Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:51:20 [2021-05-29T20:51:20.743Z] Projection_26	100.00	100	root		time:1m19.8s, loops:2, Concurrency:OFF	tpch50.supplier.s_name, Column#72	4.37 KB	N/A
20:51:20 [2021-05-29T20:51:20.743Z] └─TopN_29	100.00	100	root		time:1m19.8s, loops:2	Column#72:desc, tpch50.supplier.s_name, offset:0, count:100	58.3 KB	N/A
20:51:20 [2021-05-29T20:51:20.743Z]   └─HashAgg_34	12800.00	20057	root		time:1m19.8s, loops:21, partial_worker:{wall_time:1m19.766386804s, concurrency:5, task_num:197, tot_wait:6m38.570379393s, tot_exec:247.447504ms, tot_time:6m38.830494603s, max:1m19.766349422s, p95:1m19.766349422s}, final_worker:{wall_time:1m19.779677222s, concurrency:5, task_num:25, tot_wait:6m38.829425039s, tot_exec:63.913721ms, tot_time:6m38.893351463s, max:1m19.779618282s, p95:1m19.779618282s}	group by:tpch50.supplier.s_name, funcs:count(1)->Column#72, funcs:firstrow(tpch50.supplier.s_name)->tpch50.supplier.s_name	17.3 MB	N/A
20:51:20 [2021-05-29T20:51:20.743Z]     └─IndexHashJoin_42	7828961.66	198698	root		time:1m19.8s, loops:198, inner:{total:2m18.9s, concurrency:5, task:146, construct:6.23s, fetch:1m55.8s, build:1.21s, join:16.9s}	anti semi join, inner:IndexLookUp_39, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey)	641.1 MB	N/A
20:51:20 [2021-05-29T20:51:20.743Z]       ├─IndexHashJoin_83(Build)	9786202.08	3542799	root		time:1m19.2s, loops:3463, inner:{total:2m27.5s, concurrency:5, task:152, construct:7.72s, fetch:2m1.8s, build:1.24s, join:18s}	semi join, inner:IndexLookUp_80, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey), ne(tpch50.lineitem.l_suppkey, tpch50.supplier.s_suppkey)	555.9 MB	N/A
20:51:20 [2021-05-29T20:51:20.743Z]       │ ├─IndexJoin_99(Build)	12232752.60	3675878	root		time:1m18.6s, loops:3595, inner:{total:2m5.5s, concurrency:5, task:305, construct:15.6s, fetch:1m48.1s, build:1.81s}, probe:5.21s	inner join, inner:TableReader_95, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.orders.o_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.orders.o_orderkey)	582.0 MB	N/A
20:51:20 [2021-05-29T20:51:20.743Z]       │ │ ├─HashJoin_107(Build)	12232752.60	7609895	root		time:1m18s, loops:7437, build_hash_table:{total:1.11s, fetch:1.11s, build:6.57ms}, probe:{concurrency:5, total:6m32.6s, max:1m18.5s, probe:1m1.5s, fetch:5m31.2s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.lineitem.l_suppkey)]	727.6 KB	0 Bytes
20:51:20 [2021-05-29T20:51:20.743Z]       │ │ │ ├─HashJoin_120(Build)	20000.00	20058	root		time:1.11s, loops:22, build_hash_table:{total:185.5µs, fetch:179.2µs, build:6.39µs}, probe:{concurrency:5, total:5.55s, max:1.11s, probe:68.9ms, fetch:5.48s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:51:20 [2021-05-29T20:51:20.743Z]       │ │ │ │ ├─TableReader_125(Build)	1.00	1	root		time:41.9µs, loops:2, cop_task: {num: 1, max: 1.3ms, proc_keys: 25, rpc_num: 1, rpc_time: 1.28ms, copr_cache: disabled}	data:Selection_124	240 Bytes	N/A
20:51:20 [2021-05-29T20:51:20.743Z]       │ │ │ │ │ └─Selection_124	1.00	1	cop[tikv]		tikv_task:{time:0s, loops:1}, scan_detail: {total_process_keys: 25, total_keys: 26, rocksdb: {delete_skipped_count: 0, key_skipped_count: 46, block: {cache_hit_count: 17, read_count: 1, read_byte: 23.8 KB}}}	eq(tpch50.nation.n_name, "EGYPT")	N/A	N/A
20:51:20 [2021-05-29T20:51:20.743Z]       │ │ │ │ │   └─TableFullScan_123	25.00	25	cop[tikv]	table:nation	tikv_task:{time:0s, loops:1}	keep order:false	N/A	N/A
20:51:20 [2021-05-29T20:51:20.743Z]       │ │ │ │ └─TableReader_122(Probe)	500000.00	500000	root		time:1.1s, loops:490, cop_task: {num: 1, max: 1.1s, proc_keys: 500000, tot_proc: 1.06s, rpc_num: 1, rpc_time: 1.1s, copr_cache: disabled}	data:TableFullScan_121	20.0 MB	N/A
20:51:20 [2021-05-29T20:51:20.743Z]       │ │ │ │   └─TableFullScan_121	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:1s, loops:493}, scan_detail: {total_process_keys: 500000, total_keys: 500001, rocksdb: {delete_skipped_count: 0, key_skipped_count: 999999, block: {cache_hit_count: 13, read_count: 1679, read_byte: 104.5 MB}}}	keep order:false	N/A	N/A
20:51:20 [2021-05-29T20:51:20.743Z]       │ │ │ └─TableReader_128(Probe)	240004648.80	189670348	root		time:1m5.7s, loops:184596, cop_task: {num: 761, max: 2.67s, min: 312.8ms, avg: 1.51s, p95: 1.95s, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 17m52.3s, tot_wait: 1m0.8s, rpc_num: 761, rpc_time: 19m7.5s, copr_cache: disabled}	data:Selection_127	109.4 MB	N/A
20:51:20 [2021-05-29T20:51:20.743Z]       │ │ │   └─Selection_127	240004648.80	189670348	cop[tikv]		tikv_task:{proc max:1.3s, min:297ms, p80:1.15s, p95:1.2s, iters:296606, tasks:761}, scan_detail: {total_process_keys: 300005811, total_keys: 300006572, rocksdb: {delete_skipped_count: 0, key_skipped_count: 600010861, block: {cache_hit_count: 10453, read_count: 1114195, read_byte: 23.6 GB}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:51:20 [2021-05-29T20:51:20.743Z]       │ │ │     └─TableFullScan_126	300005811.00	300005811	cop[tikv]	table:l1	tikv_task:{proc max:1.22s, min:281ms, p80:1.08s, p95:1.12s, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:51:20 [2021-05-29T20:51:20.743Z]       │ │ └─TableReader_95(Probe)	0.49	3496177	root		time:1m39s, loops:3875, cop_task: {num: 5300, max: 564.7ms, min: 1.48ms, avg: 175.7ms, p95: 340ms, max_proc_keys: 3479, p95_proc_keys: 1955, tot_proc: 11m1.6s, tot_wait: 3m42.5s, rpc_num: 5300, rpc_time: 15m31.1s, copr_cache: disabled}	data:Selection_94	N/A	N/A
20:51:20 [2021-05-29T20:51:20.743Z]       │ │   └─Selection_94	0.49	3496177	cop[tikv]		tikv_task:{proc max:159ms, min:0s, p80:68ms, p95:82ms, iters:30363, tasks:5300}, scan_detail: {total_process_keys: 7236268, total_keys: 7795456, rocksdb: {delete_skipped_count: 0, key_skipped_count: 1778186, block: {cache_hit_count: 54007003, read_count: 218056, read_byte: 4.21 GB}}}	eq(tpch50.orders.o_orderstatus, "F")	N/A	N/A
20:51:20 [2021-05-29T20:51:20.743Z]       │ │     └─TableRangeScan_93	1.00	7236268	cop[tikv]	table:orders	tikv_task:{proc max:158ms, min:0s, p80:68ms, p95:82ms, iters:30363, tasks:5300}	range: decided by [tpch50.lineitem.l_orderkey], keep order:false	N/A	N/A
20:51:20 [2021-05-29T20:51:20.743Z]       │ └─IndexLookUp_80(Probe)	4.05	17316510	root		time:1m56.3s, loops:17129, index_task: {total_time: 1m3.5s, fetch_handle: 54.7s, build: 3.19ms, wait: 8.82s}, table_task: {total_time: 8m23.8s, num: 1458, concurrency: 760}		19.1 KB	N/A
20:51:20 [2021-05-29T20:51:20.743Z]       │   ├─IndexRangeScan_78(Build)	4.05	17316510	cop[tikv]	table:l2, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:52.3s, loops:18667, cop_task: {num: 3009, max: 802.5ms, min: 486.1µs, avg: 183ms, p95: 365.6ms, max_proc_keys: 12536, p95_proc_keys: 8762, tot_proc: 6m48.8s, tot_wait: 1m57.1s, rpc_num: 3009, rpc_time: 9m10.5s, copr_cache: disabled}, tikv_task:{proc max:148ms, min:0s, p80:94ms, p95:110ms, iters:30191, tasks:3009}, scan_detail: {total_process_keys: 17316510, total_keys: 20812623, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17316510, block: {cache_hit_count: 24260028, read_count: 225691, 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:20 [2021-05-29T20:51:20.743Z]       │   └─TableRowIDScan_79(Probe)	4.05	17316510	cop[tikv]	table:l2	time:6m13s, loops:20986, cop_task: {num: 7813, max: 675.8ms, min: 500.2µs, avg: 175.8ms, p95: 362.3ms, max_proc_keys: 13328, p95_proc_keys: 4868, tot_proc: 16m24.4s, tot_wait: 5m31.3s, rpc_num: 7813, rpc_time: 22m53.2s, copr_cache: disabled}, tikv_task:{proc max:252ms, min:0s, p80:103ms, p95:138ms, iters:49980, tasks:7813}, scan_detail: {total_process_keys: 17316510, total_keys: 18289081, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5626833, block: {cache_hit_count: 99021205, read_count: 1110, read_byte: 389.1 MB}}}	keep order:false	N/A	N/A
20:51:20 [2021-05-29T20:51:20.744Z]       └─IndexLookUp_39(Probe)	4.05	12022843	root		time:1m50.8s, loops:11948, index_task: {total_time: 59.2s, fetch_handle: 50.2s, build: 6.1ms, wait: 8.92s}, table_task: {total_time: 8m0.3s, num: 1408, concurrency: 730}		210.3 KB	N/A
20:51:20 [2021-05-29T20:51:20.744Z]         ├─IndexRangeScan_36(Build)	5.06	17183442	cop[tikv]	table:l3, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:47.9s, loops:18364, cop_task: {num: 2789, max: 790.8ms, min: 553.8µs, avg: 166.4ms, p95: 367.7ms, max_proc_keys: 17969, p95_proc_keys: 13716, tot_proc: 5m42.3s, tot_wait: 1m37.5s, rpc_num: 2789, rpc_time: 7m44s, copr_cache: disabled}, tikv_task:{proc max:175ms, min:0s, p80:76ms, p95:118ms, iters:29130, tasks:2789}, scan_detail: {total_process_keys: 17183442, total_keys: 20546480, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17183442, block: {cache_hit_count: 23554073, 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:20 [2021-05-29T20:51:20.744Z]         └─Selection_38(Probe)	4.05	12022843	cop[tikv]		time:6m10.5s, loops:13783, cop_task: {num: 10171, max: 703.1ms, min: 441.4µs, avg: 171.8ms, p95: 349.9ms, max_proc_keys: 7472, p95_proc_keys: 3992, tot_proc: 20m21.2s, tot_wait: 7m31.1s, rpc_num: 10171, rpc_time: 29m7.5s, copr_cache: disabled}, tikv_task:{proc max:237ms, min:0s, p80:76ms, p95:115ms, iters:60341, tasks:10171}, scan_detail: {total_process_keys: 17183442, total_keys: 18130128, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5530590, block: {cache_hit_count: 98286045, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:51:20 [2021-05-29T20:51:20.744Z]           └─TableRowIDScan_37	5.06	17183442	cop[tikv]	table:l3	tikv_task:{proc max:236ms, min:0s, p80:75ms, p95:114ms, iters:60341, tasks:10171}	keep order:false	N/A	N/A
20:51:20 [2021-05-29T20:51:20.744Z] + sync
20:51:20 [2021-05-29T20:51:20.744Z] + /usr/bin/echo 3
20:52:47 [2021-05-29T20:52:47.699Z] 
20:52:47 [2021-05-29T20:52:47.699Z] queries/21.sql
20:52:47 [2021-05-29T20:52:47.699Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:52:47 [2021-05-29T20:52:47.699Z] Projection_26	100.00	100	root		time:1m19.6s, loops:2, Concurrency:OFF	tpch50.supplier.s_name, Column#72	4.37 KB	N/A
20:52:47 [2021-05-29T20:52:47.699Z] └─TopN_29	100.00	100	root		time:1m19.6s, loops:2	Column#72:desc, tpch50.supplier.s_name, offset:0, count:100	58.3 KB	N/A
20:52:47 [2021-05-29T20:52:47.699Z]   └─HashAgg_34	12800.00	20057	root		time:1m19.6s, loops:21, partial_worker:{wall_time:1m19.548687443s, concurrency:5, task_num:196, tot_wait:6m37.433107321s, tot_exec:293.614525ms, tot_time:6m37.740851905s, max:1m19.54866141s, p95:1m19.54866141s}, final_worker:{wall_time:1m19.560159115s, concurrency:5, task_num:25, tot_wait:6m37.738951689s, tot_exec:61.309081ms, tot_time:6m37.800273917s, max:1m19.560146405s, p95:1m19.560146405s}	group by:tpch50.supplier.s_name, funcs:count(1)->Column#72, funcs:firstrow(tpch50.supplier.s_name)->tpch50.supplier.s_name	17.3 MB	N/A
20:52:47 [2021-05-29T20:52:47.699Z]     └─IndexHashJoin_42	7828961.66	198698	root		time:1m19.5s, loops:197, inner:{total:2m19.1s, concurrency:5, task:147, construct:5.95s, fetch:1m56.5s, build:1.19s, join:16.7s}	anti semi join, inner:IndexLookUp_39, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey)	641.0 MB	N/A
20:52:47 [2021-05-29T20:52:47.699Z]       ├─IndexHashJoin_83(Build)	9786202.08	3542799	root		time:1m19.1s, loops:3464, inner:{total:2m27.5s, concurrency:5, task:152, construct:7.42s, fetch:2m2.2s, build:1.27s, join:17.9s}	semi join, inner:IndexLookUp_80, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey), ne(tpch50.lineitem.l_suppkey, tpch50.supplier.s_suppkey)	555.9 MB	N/A
20:52:47 [2021-05-29T20:52:47.699Z]       │ ├─IndexJoin_99(Build)	12232752.60	3675878	root		time:1m18.5s, loops:3595, inner:{total:2m1.3s, concurrency:5, task:305, construct:15.5s, fetch:1m43.9s, build:1.86s}, 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)	581.8 MB	N/A
20:52:47 [2021-05-29T20:52:47.699Z]       │ │ ├─HashJoin_107(Build)	12232752.60	7609895	root		time:1m17.9s, loops:7435, build_hash_table:{total:987ms, fetch:980.4ms, build:6.6ms}, probe:{concurrency:5, total:6m31.9s, max:1m18.4s, probe:1m2.4s, fetch:5m29.5s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.lineitem.l_suppkey)]	727.6 KB	0 Bytes
20:52:47 [2021-05-29T20:52:47.699Z]       │ │ │ ├─HashJoin_120(Build)	20000.00	20058	root		time:983.2ms, loops:22, build_hash_table:{total:210.2µs, fetch:203.2µs, build:7.01µs}, probe:{concurrency:5, total:4.93s, max:985.3ms, probe:62.9ms, fetch:4.86s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:52:47 [2021-05-29T20:52:47.699Z]       │ │ │ │ ├─TableReader_125(Build)	1.00	1	root		time:80.2µs, loops:2, cop_task: {num: 1, max: 1.34ms, proc_keys: 25, tot_proc: 1ms, rpc_num: 1, rpc_time: 1.32ms, copr_cache: disabled}	data:Selection_124	248 Bytes	N/A
20:52:47 [2021-05-29T20:52:47.699Z]       │ │ │ │ │ └─Selection_124	1.00	1	cop[tikv]		tikv_task:{time:1ms, loops:1}, scan_detail: {total_process_keys: 25, total_keys: 26, rocksdb: {delete_skipped_count: 0, key_skipped_count: 46, block: {cache_hit_count: 17, read_count: 1, read_byte: 23.8 KB}}}	eq(tpch50.nation.n_name, "EGYPT")	N/A	N/A
20:52:47 [2021-05-29T20:52:47.699Z]       │ │ │ │ │   └─TableFullScan_123	25.00	25	cop[tikv]	table:nation	tikv_task:{time:1ms, loops:1}	keep order:false	N/A	N/A
20:52:47 [2021-05-29T20:52:47.699Z]       │ │ │ │ └─TableReader_122(Probe)	500000.00	500000	root		time:972.4ms, loops:490, cop_task: {num: 1, max: 973.3ms, proc_keys: 500000, tot_proc: 936ms, rpc_num: 1, rpc_time: 973.2ms, copr_cache: disabled}	data:TableFullScan_121	20.0 MB	N/A
20:52:47 [2021-05-29T20:52:47.699Z]       │ │ │ │   └─TableFullScan_121	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:889ms, loops:493}, scan_detail: {total_process_keys: 500000, total_keys: 500001, rocksdb: {delete_skipped_count: 0, key_skipped_count: 999999, block: {cache_hit_count: 13, read_count: 1679, read_byte: 104.5 MB}}}	keep order:false	N/A	N/A
20:52:47 [2021-05-29T20:52:47.700Z]       │ │ │ └─TableReader_128(Probe)	240004648.80	189670348	root		time:1m5.4s, loops:184597, cop_task: {num: 761, max: 2.93s, min: 249.6ms, avg: 1.5s, p95: 1.99s, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 17m49.9s, tot_wait: 58.8s, rpc_num: 761, rpc_time: 19m3.4s, copr_cache: disabled}	data:Selection_127	109.4 MB	N/A
20:52:47 [2021-05-29T20:52:47.700Z]       │ │ │   └─Selection_127	240004648.80	189670348	cop[tikv]		tikv_task:{proc max:1.32s, min:233ms, 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: 10461, read_count: 1114187, read_byte: 23.6 GB}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:52:47 [2021-05-29T20:52:47.700Z]       │ │ │     └─TableFullScan_126	300005811.00	300005811	cop[tikv]	table:l1	tikv_task:{proc max:1.23s, min:223ms, p80:1.07s, p95:1.11s, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:52:47 [2021-05-29T20:52:47.700Z]       │ │ └─TableReader_95(Probe)	0.49	3496182	root		time:1m35.3s, loops:3875, cop_task: {num: 5283, max: 475.1ms, min: 965.9µs, avg: 171ms, p95: 325.3ms, max_proc_keys: 4135, p95_proc_keys: 1967, tot_proc: 10m39s, tot_wait: 3m36.5s, rpc_num: 5283, rpc_time: 15m3.4s, copr_cache: disabled}	data:Selection_94	N/A	N/A
20:52:47 [2021-05-29T20:52:47.700Z]       │ │   └─Selection_94	0.49	3496182	cop[tikv]		tikv_task:{proc max:159ms, min:0s, p80:68ms, p95:81ms, iters:30278, tasks:5283}, scan_detail: {total_process_keys: 7236309, total_keys: 7795503, rocksdb: {delete_skipped_count: 0, key_skipped_count: 1778274, block: {cache_hit_count: 54006905, read_count: 218247, read_byte: 4.21 GB}}}	eq(tpch50.orders.o_orderstatus, "F")	N/A	N/A
20:52:47 [2021-05-29T20:52:47.700Z]       │ │     └─TableRangeScan_93	1.00	7236309	cop[tikv]	table:orders	tikv_task:{proc max:159ms, min:0s, p80:68ms, p95:81ms, iters:30278, tasks:5283}	range: decided by [tpch50.lineitem.l_orderkey], keep order:false	N/A	N/A
20:52:47 [2021-05-29T20:52:47.700Z]       │ └─IndexLookUp_80(Probe)	4.05	17316440	root		time:1m56.9s, loops:17126, index_task: {total_time: 1m5.1s, fetch_handle: 56.3s, build: 5.42ms, wait: 8.76s}, table_task: {total_time: 8m26s, num: 1458, concurrency: 760}		18.9 KB	N/A
20:52:47 [2021-05-29T20:52:47.700Z]       │   ├─IndexRangeScan_78(Build)	4.05	17316440	cop[tikv]	table:l2, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:54s, loops:18646, cop_task: {num: 2999, max: 748ms, min: 505.3µs, avg: 186.8ms, p95: 374.8ms, max_proc_keys: 14145, p95_proc_keys: 8806, tot_proc: 6m57.4s, tot_wait: 1m58.8s, rpc_num: 2999, rpc_time: 9m20.1s, copr_cache: disabled}, tikv_task:{proc max:186ms, min:0s, p80:94ms, p95:110ms, iters:30142, tasks:2999}, scan_detail: {total_process_keys: 17316440, total_keys: 20812539, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17316440, block: {cache_hit_count: 24259940, read_count: 225680, read_byte: 2.00 GB}}}	range: decided by [eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey)], keep order:false	N/A	N/A
20:52:47 [2021-05-29T20:52:47.700Z]       │   └─TableRowIDScan_79(Probe)	4.05	17316440	cop[tikv]	table:l2	time:6m16.8s, loops:20946, cop_task: {num: 7848, max: 637.2ms, min: 467.1µs, avg: 176.7ms, p95: 354.5ms, max_proc_keys: 13064, p95_proc_keys: 4809, tot_proc: 16m23.3s, tot_wait: 5m42.9s, rpc_num: 7848, rpc_time: 23m6.2s, copr_cache: disabled}, tikv_task:{proc max:373ms, min:0s, p80:103ms, p95:138ms, iters:49886, tasks:7848}, scan_detail: {total_process_keys: 17316440, total_keys: 18288632, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5625858, block: {cache_hit_count: 99021922, read_count: 1111, read_byte: 383.9 MB}}}	keep order:false	N/A	N/A
20:52:47 [2021-05-29T20:52:47.700Z]       └─IndexLookUp_39(Probe)	4.05	12022752	root		time:1m51.7s, loops:11943, index_task: {total_time: 59.7s, fetch_handle: 48.5s, build: 3.7ms, wait: 11.2s}, table_task: {total_time: 8m1.7s, num: 1410, concurrency: 735}		219.5 KB	N/A
20:52:47 [2021-05-29T20:52:47.700Z]         ├─IndexRangeScan_36(Build)	5.06	17183329	cop[tikv]	table:l3, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:46.1s, loops:18349, cop_task: {num: 2761, max: 741.9ms, min: 534.2µs, avg: 164.5ms, p95: 360ms, max_proc_keys: 21027, p95_proc_keys: 14096, tot_proc: 5m33.8s, tot_wait: 1m36.7s, rpc_num: 2761, rpc_time: 7m34s, copr_cache: disabled}, tikv_task:{proc max:192ms, min:0s, p80:77ms, p95:121ms, iters:28993, tasks:2761}, scan_detail: {total_process_keys: 17183329, total_keys: 20546345, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17183329, block: {cache_hit_count: 23553918, read_count: 0, read_byte: 0 Bytes}}}	range: decided by [eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey)], keep order:false	N/A	N/A
20:52:47 [2021-05-29T20:52:47.700Z]         └─Selection_38(Probe)	4.05	12022752	cop[tikv]		time:6m10.4s, loops:13788, cop_task: {num: 10296, max: 669.3ms, min: 470.9µs, avg: 172.3ms, p95: 347.2ms, max_proc_keys: 6901, p95_proc_keys: 3945, tot_proc: 20m35.5s, tot_wait: 7m39.8s, rpc_num: 10296, rpc_time: 29m33.2s, copr_cache: disabled}, tikv_task:{proc max:205ms, min:0s, p80:75ms, p95:114ms, iters:60791, tasks:10296}, scan_detail: {total_process_keys: 17183329, total_keys: 18128367, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5521962, block: {cache_hit_count: 98296256, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:52:47 [2021-05-29T20:52:47.700Z]           └─TableRowIDScan_37	5.06	17183329	cop[tikv]	table:l3	tikv_task:{proc max:204ms, min:0s, p80:74ms, p95:113ms, iters:60791, tasks:10296}	keep order:false	N/A	N/A
20:52:47 [2021-05-29T20:52:47.700Z] + sync
20:52:47 [2021-05-29T20:52:47.700Z] + /usr/bin/echo 3
20:54:09 [2021-05-29T20:54:09.086Z] 
20:54:09 [2021-05-29T20:54:09.086Z] queries/21.sql
20:54:09 [2021-05-29T20:54:09.086Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:54:09 [2021-05-29T20:54:09.086Z] Projection_26	100.00	100	root		time:1m19.4s, loops:2, Concurrency:OFF	tpch50.supplier.s_name, Column#72	4.37 KB	N/A
20:54:09 [2021-05-29T20:54:09.086Z] └─TopN_29	100.00	100	root		time:1m19.4s, loops:2	Column#72:desc, tpch50.supplier.s_name, offset:0, count:100	58.3 KB	N/A
20:54:09 [2021-05-29T20:54:09.086Z]   └─HashAgg_34	12800.00	20057	root		time:1m19.4s, loops:21, partial_worker:{wall_time:1m19.413851216s, concurrency:5, task_num:197, tot_wait:6m36.807209047s, tot_exec:244.653838ms, tot_time:6m37.065342969s, max:1m19.413810437s, p95:1m19.413810437s}, final_worker:{wall_time:1m19.439045895s, concurrency:5, task_num:25, tot_wait:6m37.062797951s, tot_exec:113.861099ms, tot_time:6m37.176680672s, max:1m19.439006236s, p95:1m19.439006236s}	group by:tpch50.supplier.s_name, funcs:count(1)->Column#72, funcs:firstrow(tpch50.supplier.s_name)->tpch50.supplier.s_name	17.3 MB	N/A
20:54:09 [2021-05-29T20:54:09.086Z]     └─IndexHashJoin_42	7828961.66	198698	root		time:1m19.4s, loops:198, inner:{total:2m16.9s, concurrency:5, task:147, construct:6.07s, fetch:1m54.1s, build:1.22s, join:16.8s}	anti semi join, inner:IndexLookUp_39, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey)	641.1 MB	N/A
20:54:09 [2021-05-29T20:54:09.086Z]       ├─IndexHashJoin_83(Build)	9786202.08	3542799	root		time:1m18.8s, loops:3464, inner:{total:2m26.2s, concurrency:5, task:152, construct:7.32s, fetch:2m1.6s, build:1.23s, join:17.3s}	semi join, inner:IndexLookUp_80, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey), ne(tpch50.lineitem.l_suppkey, tpch50.supplier.s_suppkey)	555.9 MB	N/A
20:54:09 [2021-05-29T20:54:09.086Z]       │ ├─IndexJoin_99(Build)	12232752.60	3675878	root		time:1m18.3s, loops:3595, inner:{total:2m2.6s, concurrency:5, task:305, construct:15s, fetch:1m45.7s, build:1.87s}, probe:5.04s	inner join, inner:TableReader_95, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.orders.o_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.orders.o_orderkey)	582.2 MB	N/A
20:54:09 [2021-05-29T20:54:09.086Z]       │ │ ├─HashJoin_107(Build)	12232752.60	7609895	root		time:1m17.7s, loops:7436, build_hash_table:{total:1.03s, fetch:1.02s, build:5.93ms}, probe:{concurrency:5, total:6m30.6s, max:1m18.1s, probe:1m1.5s, fetch:5m29.1s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.lineitem.l_suppkey)]	771.7 KB	0 Bytes
20:54:09 [2021-05-29T20:54:09.086Z]       │ │ │ ├─HashJoin_120(Build)	20000.00	20058	root		time:1.03s, loops:24, build_hash_table:{total:273.5µs, fetch:268.4µs, build:5.07µs}, probe:{concurrency:5, total:5.13s, max:1.03s, probe:60.1ms, fetch:5.07s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:54:09 [2021-05-29T20:54:09.086Z]       │ │ │ │ ├─TableReader_125(Build)	1.00	1	root		time:54.1µs, loops:2, cop_task: {num: 1, max: 1.4ms, proc_keys: 25, rpc_num: 1, rpc_time: 1.37ms, copr_cache: disabled}	data:Selection_124	240 Bytes	N/A
20:54:09 [2021-05-29T20:54:09.086Z]       │ │ │ │ │ └─Selection_124	1.00	1	cop[tikv]		tikv_task:{time:0s, loops:1}, scan_detail: {total_process_keys: 25, total_keys: 26, rocksdb: {delete_skipped_count: 0, key_skipped_count: 46, block: {cache_hit_count: 17, read_count: 1, read_byte: 23.8 KB}}}	eq(tpch50.nation.n_name, "EGYPT")	N/A	N/A
20:54:09 [2021-05-29T20:54:09.086Z]       │ │ │ │ │   └─TableFullScan_123	25.00	25	cop[tikv]	table:nation	tikv_task:{time:0s, loops:1}	keep order:false	N/A	N/A
20:54:09 [2021-05-29T20:54:09.086Z]       │ │ │ │ └─TableReader_122(Probe)	500000.00	500000	root		time:1.01s, loops:490, cop_task: {num: 1, max: 1.02s, proc_keys: 500000, tot_proc: 978ms, tot_wait: 1ms, rpc_num: 1, rpc_time: 1.02s, copr_cache: disabled}	data:TableFullScan_121	20.0 MB	N/A
20:54:09 [2021-05-29T20:54:09.086Z]       │ │ │ │   └─TableFullScan_121	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:921ms, 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:09 [2021-05-29T20:54:09.086Z]       │ │ │ └─TableReader_128(Probe)	240004648.80	189670348	root		time:1m5.3s, loops:184595, cop_task: {num: 761, max: 2.48s, min: 248ms, avg: 1.5s, p95: 2s, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 17m51s, tot_wait: 58.7s, rpc_num: 761, rpc_time: 19m4.3s, copr_cache: disabled}	data:Selection_127	109.4 MB	N/A
20:54:09 [2021-05-29T20:54:09.086Z]       │ │ │   └─Selection_127	240004648.80	189670348	cop[tikv]		tikv_task:{proc max:1.29s, min:232ms, p80:1.16s, 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:54:09 [2021-05-29T20:54:09.086Z]       │ │ │     └─TableFullScan_126	300005811.00	300005811	cop[tikv]	table:l1	tikv_task:{proc max:1.21s, min:216ms, p80:1.08s, p95:1.11s, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:54:09 [2021-05-29T20:54:09.086Z]       │ │ └─TableReader_95(Probe)	0.49	3496186	root		time:1m37.1s, loops:3875, cop_task: {num: 5239, max: 553.5ms, min: 2ms, avg: 174.4ms, p95: 324.8ms, max_proc_keys: 3707, p95_proc_keys: 1971, tot_proc: 10m51.1s, tot_wait: 3m35s, rpc_num: 5239, rpc_time: 15m13.5s, copr_cache: disabled}	data:Selection_94	N/A	N/A
20:54:09 [2021-05-29T20:54:09.086Z]       │ │   └─Selection_94	0.49	3496186	cop[tikv]		tikv_task:{proc max:163ms, min:0s, p80:68ms, p95:82ms, iters:30233, tasks:5239}, scan_detail: {total_process_keys: 7236282, total_keys: 7795541, rocksdb: {delete_skipped_count: 0, key_skipped_count: 1778417, block: {cache_hit_count: 54006396, read_count: 218143, read_byte: 4.21 GB}}}	eq(tpch50.orders.o_orderstatus, "F")	N/A	N/A
20:54:09 [2021-05-29T20:54:09.086Z]       │ │     └─TableRangeScan_93	1.00	7236282	cop[tikv]	table:orders	tikv_task:{proc max:163ms, min:0s, p80:68ms, p95:82ms, iters:30233, tasks:5239}	range: decided by [tpch50.lineitem.l_orderkey], keep order:false	N/A	N/A
20:54:09 [2021-05-29T20:54:09.086Z]       │ └─IndexLookUp_80(Probe)	4.05	17316586	root		time:1m56.2s, loops:17130, index_task: {total_time: 1m4.4s, fetch_handle: 55.7s, build: 3.12ms, wait: 8.67s}, table_task: {total_time: 8m20.3s, num: 1458, concurrency: 760}		18.8 KB	N/A
20:54:09 [2021-05-29T20:54:09.086Z]       │   ├─IndexRangeScan_78(Build)	4.05	17316586	cop[tikv]	table:l2, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:53.3s, loops:18607, cop_task: {num: 2986, max: 599ms, min: 440.4µs, avg: 186.2ms, p95: 371.8ms, max_proc_keys: 15497, p95_proc_keys: 8743, tot_proc: 6m56s, tot_wait: 1m56.3s, rpc_num: 2986, rpc_time: 9m15.8s, copr_cache: disabled}, tikv_task:{proc max:205ms, min:0s, p80:93ms, p95:108ms, iters:30178, tasks:2986}, scan_detail: {total_process_keys: 17316586, total_keys: 20812708, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17316586, block: {cache_hit_count: 24260103, read_count: 225678, read_byte: 2.00 GB}}}	range: decided by [eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey)], keep order:false	N/A	N/A
20:54:09 [2021-05-29T20:54:09.086Z]       │   └─TableRowIDScan_79(Probe)	4.05	17316586	cop[tikv]	table:l2	time:6m12.1s, loops:21008, cop_task: {num: 7813, max: 645.1ms, min: 525.1µs, avg: 174.7ms, p95: 349.9ms, max_proc_keys: 13101, p95_proc_keys: 4881, tot_proc: 16m11.1s, tot_wait: 5m37.1s, rpc_num: 7813, rpc_time: 22m44.8s, copr_cache: disabled}, tikv_task:{proc max:259ms, min:0s, p80:103ms, p95:139ms, iters:50003, tasks:7813}, scan_detail: {total_process_keys: 17316586, total_keys: 18290008, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5631658, block: {cache_hit_count: 99016275, read_count: 1109, read_byte: 390.1 MB}}}	keep order:false	N/A	N/A
20:54:09 [2021-05-29T20:54:09.086Z]       └─IndexLookUp_39(Probe)	4.05	12022903	root		time:1m49.4s, loops:11948, index_task: {total_time: 58.2s, fetch_handle: 49.5s, build: 2.7ms, wait: 8.65s}, table_task: {total_time: 7m51s, num: 1410, concurrency: 735}		221.4 KB	N/A
20:54:09 [2021-05-29T20:54:09.086Z]         ├─IndexRangeScan_36(Build)	5.06	17183506	cop[tikv]	table:l3, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:47.2s, loops:18339, cop_task: {num: 2780, max: 684.4ms, min: 797.7µs, avg: 162.3ms, p95: 345.7ms, max_proc_keys: 19422, p95_proc_keys: 13734, tot_proc: 5m30.9s, tot_wait: 1m36.2s, rpc_num: 2780, rpc_time: 7m31s, copr_cache: disabled}, tikv_task:{proc max:174ms, min:0s, p80:78ms, p95:117ms, iters:29136, tasks:2780}, scan_detail: {total_process_keys: 17183506, total_keys: 20546550, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17183506, block: {cache_hit_count: 23554114, 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:09 [2021-05-29T20:54:09.086Z]         └─Selection_38(Probe)	4.05	12022903	cop[tikv]		time:6m1s, loops:13761, cop_task: {num: 10281, max: 733.9ms, min: 537.3µs, avg: 168.2ms, p95: 340.3ms, max_proc_keys: 7175, p95_proc_keys: 3962, tot_proc: 20m7.2s, tot_wait: 7m25.3s, rpc_num: 10281, rpc_time: 28m48.7s, copr_cache: disabled}, tikv_task:{proc max:279ms, min:0s, p80:74ms, p95:113ms, iters:61023, tasks:10281}, scan_detail: {total_process_keys: 17183506, total_keys: 18127919, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5521875, block: {cache_hit_count: 98294554, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:54:09 [2021-05-29T20:54:09.086Z]           └─TableRowIDScan_37	5.06	17183506	cop[tikv]	table:l3	tikv_task:{proc max:277ms, min:0s, p80:74ms, p95:112ms, iters:61023, tasks:10281}	keep order:false	N/A	N/A
20:54:09 [2021-05-29T20:54:09.086Z] + sync
20:54:09 [2021-05-29T20:54:09.086Z] + /usr/bin/echo 3
20:55:30 [2021-05-29T20:55:30.456Z] 
20:55:30 [2021-05-29T20:55:30.456Z] queries/21.sql
20:55:30 [2021-05-29T20:55:30.456Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:55:30 [2021-05-29T20:55:30.456Z] Projection_26	100.00	100	root		time:1m19.6s, loops:2, Concurrency:OFF	tpch50.supplier.s_name, Column#72	4.37 KB	N/A
20:55:30 [2021-05-29T20:55:30.456Z] └─TopN_29	100.00	100	root		time:1m19.6s, loops:2	Column#72:desc, tpch50.supplier.s_name, offset:0, count:100	58.3 KB	N/A
20:55:30 [2021-05-29T20:55:30.456Z]   └─HashAgg_34	12800.00	20057	root		time:1m19.6s, loops:21, partial_worker:{wall_time:1m19.568074238s, concurrency:5, task_num:196, tot_wait:6m37.587209702s, tot_exec:235.751858ms, tot_time:6m37.836298132s, max:1m19.568045427s, p95:1m19.568045427s}, final_worker:{wall_time:1m19.582346002s, concurrency:5, task_num:25, tot_wait:6m37.833484729s, tot_exec:68.032277ms, tot_time:6m37.901529465s, max:1m19.582320833s, p95:1m19.582320833s}	group by:tpch50.supplier.s_name, funcs:count(1)->Column#72, funcs:firstrow(tpch50.supplier.s_name)->tpch50.supplier.s_name	17.3 MB	N/A
20:55:30 [2021-05-29T20:55:30.456Z]     └─IndexHashJoin_42	7828961.66	198698	root		time:1m19.6s, loops:197, inner:{total:2m17.5s, concurrency:5, task:147, construct:6.09s, fetch:1m54.4s, build:1.21s, join:16.9s}	anti semi join, inner:IndexLookUp_39, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey)	641.0 MB	N/A
20:55:30 [2021-05-29T20:55:30.456Z]       ├─IndexHashJoin_83(Build)	9786202.08	3542799	root		time:1m19s, loops:3464, inner:{total:2m24.2s, concurrency:5, task:152, construct:7.09s, fetch:1m59.4s, build:1.16s, join:17.6s}	semi join, inner:IndexLookUp_80, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey), ne(tpch50.lineitem.l_suppkey, tpch50.supplier.s_suppkey)	555.9 MB	N/A
20:55:30 [2021-05-29T20:55:30.456Z]       │ ├─IndexJoin_99(Build)	12232752.60	3675878	root		time:1m18.4s, loops:3595, inner:{total:2m5.4s, concurrency:5, task:305, construct:15.3s, fetch:1m48.4s, build:1.75s}, probe:4.88s	inner join, inner:TableReader_95, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.orders.o_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.orders.o_orderkey)	581.8 MB	N/A
20:55:30 [2021-05-29T20:55:30.456Z]       │ │ ├─HashJoin_107(Build)	12232752.60	7609895	root		time:1m17.9s, loops:7436, build_hash_table:{total:1.05s, fetch:1.04s, build:7.66ms}, probe:{concurrency:5, total:6m31.2s, max:1m18.2s, probe:1m1.7s, fetch:5m29.5s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.lineitem.l_suppkey)]	752.0 KB	0 Bytes
20:55:30 [2021-05-29T20:55:30.456Z]       │ │ │ ├─HashJoin_120(Build)	20000.00	20058	root		time:1.05s, loops:23, build_hash_table:{total:211.6µs, fetch:203.6µs, build:8.05µs}, probe:{concurrency:5, total:5.25s, max:1.05s, probe:67.9ms, fetch:5.18s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:55:30 [2021-05-29T20:55:30.456Z]       │ │ │ │ ├─TableReader_125(Build)	1.00	1	root		time:61.1µs, loops:2, cop_task: {num: 1, max: 1.33ms, proc_keys: 25, tot_proc: 1ms, rpc_num: 1, rpc_time: 1.3ms, copr_cache: disabled}	data:Selection_124	248 Bytes	N/A
20:55:30 [2021-05-29T20:55:30.456Z]       │ │ │ │ │ └─Selection_124	1.00	1	cop[tikv]		tikv_task:{time:1ms, loops:1}, scan_detail: {total_process_keys: 25, total_keys: 26, rocksdb: {delete_skipped_count: 0, key_skipped_count: 46, block: {cache_hit_count: 17, read_count: 1, read_byte: 23.8 KB}}}	eq(tpch50.nation.n_name, "EGYPT")	N/A	N/A
20:55:30 [2021-05-29T20:55:30.456Z]       │ │ │ │ │   └─TableFullScan_123	25.00	25	cop[tikv]	table:nation	tikv_task:{time:1ms, loops:1}	keep order:false	N/A	N/A
20:55:30 [2021-05-29T20:55:30.456Z]       │ │ │ │ └─TableReader_122(Probe)	500000.00	500000	root		time:1.04s, loops:490, cop_task: {num: 1, max: 1.04s, proc_keys: 500000, tot_proc: 1s, rpc_num: 1, rpc_time: 1.04s, copr_cache: disabled}	data:TableFullScan_121	20.0 MB	N/A
20:55:30 [2021-05-29T20:55:30.456Z]       │ │ │ │   └─TableFullScan_121	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:936ms, loops:493}, scan_detail: {total_process_keys: 500000, total_keys: 500001, rocksdb: {delete_skipped_count: 0, key_skipped_count: 999999, block: {cache_hit_count: 13, read_count: 1679, read_byte: 104.5 MB}}}	keep order:false	N/A	N/A
20:55:30 [2021-05-29T20:55:30.456Z]       │ │ │ └─TableReader_128(Probe)	240004648.80	189670348	root		time:1m5.4s, loops:184597, cop_task: {num: 761, max: 2.66s, min: 294.6ms, avg: 1.51s, p95: 1.98s, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 17m52s, tot_wait: 59.2s, rpc_num: 761, rpc_time: 19m6.1s, copr_cache: disabled}	data:Selection_127	109.4 MB	N/A
20:55:30 [2021-05-29T20:55:30.456Z]       │ │ │   └─Selection_127	240004648.80	189670348	cop[tikv]		tikv_task:{proc max:1.41s, min:281ms, 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: 10452, read_count: 1114196, read_byte: 23.6 GB}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:55:30 [2021-05-29T20:55:30.456Z]       │ │ │     └─TableFullScan_126	300005811.00	300005811	cop[tikv]	table:l1	tikv_task:{proc max:1.32s, min:268ms, p80:1.07s, p95:1.12s, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:55:30 [2021-05-29T20:55:30.456Z]       │ │ └─TableReader_95(Probe)	0.49	3496169	root		time:1m39.5s, loops:3875, cop_task: {num: 5277, max: 510.8ms, min: 2.54ms, avg: 176.7ms, p95: 334.3ms, max_proc_keys: 4366, p95_proc_keys: 1964, tot_proc: 11m3.7s, tot_wait: 3m39.7s, rpc_num: 5277, rpc_time: 15m32s, copr_cache: disabled}	data:Selection_94	N/A	N/A
20:55:30 [2021-05-29T20:55:30.456Z]       │ │   └─Selection_94	0.49	3496169	cop[tikv]		tikv_task:{proc max:181ms, min:0s, p80:68ms, p95:81ms, iters:30303, tasks:5277}, scan_detail: {total_process_keys: 7236330, total_keys: 7795576, rocksdb: {delete_skipped_count: 0, key_skipped_count: 1778438, block: {cache_hit_count: 54006822, read_count: 218164, read_byte: 4.21 GB}}}	eq(tpch50.orders.o_orderstatus, "F")	N/A	N/A
20:55:30 [2021-05-29T20:55:30.456Z]       │ │     └─TableRangeScan_93	1.00	7236330	cop[tikv]	table:orders	tikv_task:{proc max:180ms, min:0s, p80:68ms, p95:81ms, iters:30303, tasks:5277}	range: decided by [tpch50.lineitem.l_orderkey], keep order:false	N/A	N/A
20:55:30 [2021-05-29T20:55:30.456Z]       │ └─IndexLookUp_80(Probe)	4.05	17316449	root		time:1m54.3s, loops:17129, index_task: {total_time: 1m1.7s, fetch_handle: 53.2s, build: 4.92ms, wait: 8.56s}, table_task: {total_time: 8m15.4s, num: 1458, concurrency: 760}		19.0 KB	N/A
20:55:30 [2021-05-29T20:55:30.456Z]       │   ├─IndexRangeScan_78(Build)	4.05	17316449	cop[tikv]	table:l2, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:50.9s, loops:18671, cop_task: {num: 2984, max: 741.4ms, min: 566.2µs, avg: 179.9ms, p95: 352.8ms, max_proc_keys: 11350, p95_proc_keys: 8801, tot_proc: 6m41.3s, tot_wait: 1m50.3s, rpc_num: 2984, rpc_time: 8m56.6s, copr_cache: disabled}, tikv_task:{proc max:148ms, min:0s, p80:95ms, p95:111ms, iters:30108, tasks:2984}, scan_detail: {total_process_keys: 17316449, total_keys: 20812550, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17316449, block: {cache_hit_count: 24259955, 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:55:30 [2021-05-29T20:55:30.457Z]       │   └─TableRowIDScan_79(Probe)	4.05	17316449	cop[tikv]	table:l2	time:6m7s, loops:20963, cop_task: {num: 7822, max: 650ms, min: 430.9µs, avg: 171.3ms, p95: 344.9ms, max_proc_keys: 9347, p95_proc_keys: 4881, tot_proc: 16m4s, tot_wait: 5m18.7s, rpc_num: 7822, rpc_time: 22m19.8s, copr_cache: disabled}, tikv_task:{proc max:270ms, min:0s, p80:103ms, p95:138ms, iters:50003, tasks:7822}, scan_detail: {total_process_keys: 17316449, total_keys: 18290253, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5631916, block: {cache_hit_count: 99019846, read_count: 1113, read_byte: 393.1 MB}}}	keep order:false	N/A	N/A
20:55:30 [2021-05-29T20:55:30.457Z]       └─IndexLookUp_39(Probe)	4.05	12022792	root		time:1m49.6s, loops:11951, index_task: {total_time: 59.2s, fetch_handle: 48.9s, build: 2.72ms, wait: 10.3s}, table_task: {total_time: 7m53.5s, num: 1410, concurrency: 735}		221.1 KB	N/A
20:55:30 [2021-05-29T20:55:30.457Z]         ├─IndexRangeScan_36(Build)	5.06	17183385	cop[tikv]	table:l3, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:46.4s, loops:18386, cop_task: {num: 2779, max: 792.1ms, min: 807.9µs, avg: 165.8ms, p95: 352.7ms, max_proc_keys: 21085, p95_proc_keys: 13570, tot_proc: 5m37.5s, tot_wait: 1m37.6s, rpc_num: 2779, rpc_time: 7m40.8s, copr_cache: disabled}, tikv_task:{proc max:175ms, min:0s, p80:77ms, p95:116ms, iters:29116, tasks:2779}, scan_detail: {total_process_keys: 17183385, total_keys: 20546409, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17183385, block: {cache_hit_count: 23553975, read_count: 0, read_byte: 0 Bytes}}}	range: decided by [eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey)], keep order:false	N/A	N/A
20:55:30 [2021-05-29T20:55:30.457Z]         └─Selection_38(Probe)	4.05	12022792	cop[tikv]		time:6m2s, loops:13752, cop_task: {num: 10198, max: 610.2ms, min: 449.1µs, avg: 167.3ms, p95: 335.9ms, max_proc_keys: 6739, p95_proc_keys: 4009, tot_proc: 19m50.8s, tot_wait: 7m19s, rpc_num: 10198, rpc_time: 28m25.8s, copr_cache: disabled}, tikv_task:{proc max:221ms, min:0s, p80:77ms, p95:115ms, iters:60406, tasks:10198}, scan_detail: {total_process_keys: 17183385, total_keys: 18129801, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5528580, block: {cache_hit_count: 98289169, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:55:30 [2021-05-29T20:55:30.457Z]           └─TableRowIDScan_37	5.06	17183385	cop[tikv]	table:l3	tikv_task:{proc max:220ms, min:0s, p80:76ms, p95:114ms, iters:60406, tasks:10198}	keep order:false	N/A	N/A
20:55:30 [2021-05-29T20:55:30.457Z] + sync
20:55:30 [2021-05-29T20:55:30.457Z] + /usr/bin/echo 3
20:57:06 [2021-05-29T20:57:06.978Z] 
20:57:06 [2021-05-29T20:57:06.978Z] queries/21.sql
20:57:06 [2021-05-29T20:57:06.978Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:57:06 [2021-05-29T20:57:06.978Z] Projection_26	100.00	100	root		time:1m19.8s, loops:2, Concurrency:OFF	tpch50.supplier.s_name, Column#72	4.37 KB	N/A
20:57:06 [2021-05-29T20:57:06.978Z] └─TopN_29	100.00	100	root		time:1m19.8s, loops:2	Column#72:desc, tpch50.supplier.s_name, offset:0, count:100	58.3 KB	N/A
20:57:06 [2021-05-29T20:57:06.978Z]   └─HashAgg_34	12800.00	20057	root		time:1m19.8s, loops:21, partial_worker:{wall_time:1m19.750443869s, concurrency:5, task_num:196, tot_wait:6m38.469751251s, tot_exec:264.793947ms, tot_time:6m38.74867993s, max:1m19.750416793s, p95:1m19.750416793s}, final_worker:{wall_time:1m19.761708388s, concurrency:5, task_num:25, tot_wait:6m38.74642429s, tot_exec:61.507945ms, tot_time:6m38.807951539s, max:1m19.761686303s, p95:1m19.761686303s}	group by:tpch50.supplier.s_name, funcs:count(1)->Column#72, funcs:firstrow(tpch50.supplier.s_name)->tpch50.supplier.s_name	17.3 MB	N/A
20:57:06 [2021-05-29T20:57:06.978Z]     └─IndexHashJoin_42	7828961.66	198698	root		time:1m19.7s, loops:197, inner:{total:2m21.9s, concurrency:5, task:147, construct:6.1s, fetch:1m58.9s, 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.0 MB	N/A
20:57:06 [2021-05-29T20:57:06.978Z]       ├─IndexHashJoin_83(Build)	9786202.08	3542799	root		time:1m19.2s, loops:3463, inner:{total:2m29.1s, concurrency:5, task:152, construct:7.45s, fetch:2m3.3s, build:1.35s, join:18.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:57:06 [2021-05-29T20:57:06.979Z]       │ ├─IndexJoin_99(Build)	12232752.60	3675878	root		time:1m18.7s, loops:3595, inner:{total:2m6.8s, concurrency:5, task:305, construct:16s, fetch:1m49s, build:1.84s}, probe:4.97s	inner join, inner:TableReader_95, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.orders.o_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.orders.o_orderkey)	582.0 MB	N/A
20:57:06 [2021-05-29T20:57:06.979Z]       │ │ ├─HashJoin_107(Build)	12232752.60	7609895	root		time:1m18.1s, loops:7436, build_hash_table:{total:1.11s, fetch:1.1s, build:6.08ms}, probe:{concurrency:5, total:6m33s, max:1m18.6s, probe:1m2.2s, fetch:5m30.8s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.lineitem.l_suppkey)]	752.0 KB	0 Bytes
20:57:06 [2021-05-29T20:57:06.979Z]       │ │ │ ├─HashJoin_120(Build)	20000.00	20058	root		time:1.11s, loops:23, build_hash_table:{total:158.1µs, fetch:152.9µs, build:5.15µs}, probe:{concurrency:5, total:5.54s, max:1.11s, probe:59.5ms, fetch:5.48s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:57:06 [2021-05-29T20:57:06.979Z]       │ │ │ │ ├─TableReader_125(Build)	1.00	1	root		time:51.3µs, loops:2, cop_task: {num: 1, max: 1.42ms, proc_keys: 25, tot_proc: 2ms, rpc_num: 1, rpc_time: 1.39ms, copr_cache: disabled}	data:Selection_124	248 Bytes	N/A
20:57:06 [2021-05-29T20:57:06.979Z]       │ │ │ │ │ └─Selection_124	1.00	1	cop[tikv]		tikv_task:{time:2ms, loops:1}, scan_detail: {total_process_keys: 25, total_keys: 26, rocksdb: {delete_skipped_count: 0, key_skipped_count: 46, block: {cache_hit_count: 17, read_count: 1, read_byte: 23.8 KB}}}	eq(tpch50.nation.n_name, "EGYPT")	N/A	N/A
20:57:06 [2021-05-29T20:57:06.979Z]       │ │ │ │ │   └─TableFullScan_123	25.00	25	cop[tikv]	table:nation	tikv_task:{time:2ms, loops:1}	keep order:false	N/A	N/A
20:57:06 [2021-05-29T20:57:06.979Z]       │ │ │ │ └─TableReader_122(Probe)	500000.00	500000	root		time:1.1s, loops:490, cop_task: {num: 1, max: 1.1s, proc_keys: 500000, tot_proc: 1.06s, rpc_num: 1, rpc_time: 1.1s, copr_cache: disabled}	data:TableFullScan_121	20.0 MB	N/A
20:57:06 [2021-05-29T20:57:06.979Z]       │ │ │ │   └─TableFullScan_121	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:997ms, loops:493}, scan_detail: {total_process_keys: 500000, total_keys: 500001, rocksdb: {delete_skipped_count: 0, key_skipped_count: 999999, block: {cache_hit_count: 13, read_count: 1679, read_byte: 104.5 MB}}}	keep order:false	N/A	N/A
20:57:06 [2021-05-29T20:57:06.979Z]       │ │ │ └─TableReader_128(Probe)	240004648.80	189670348	root		time:1m5.6s, loops:184598, cop_task: {num: 761, max: 2.59s, min: 276.7ms, avg: 1.51s, p95: 1.99s, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 17m51.1s, tot_wait: 1m1s, rpc_num: 761, rpc_time: 19m6.5s, copr_cache: disabled}	data:Selection_127	109.4 MB	N/A
20:57:06 [2021-05-29T20:57:06.979Z]       │ │ │   └─Selection_127	240004648.80	189670348	cop[tikv]		tikv_task:{proc max:1.35s, min:264ms, p80:1.16s, p95:1.2s, iters:296606, tasks:761}, scan_detail: {total_process_keys: 300005811, total_keys: 300006572, rocksdb: {delete_skipped_count: 0, key_skipped_count: 600010861, block: {cache_hit_count: 10455, read_count: 1114193, read_byte: 23.6 GB}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:57:06 [2021-05-29T20:57:06.979Z]       │ │ │     └─TableFullScan_126	300005811.00	300005811	cop[tikv]	table:l1	tikv_task:{proc max:1.25s, min:250ms, p80:1.07s, p95:1.12s, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:57:06 [2021-05-29T20:57:06.979Z]       │ │ └─TableReader_95(Probe)	0.49	3496165	root		time:1m40.2s, loops:3875, cop_task: {num: 5260, max: 597.5ms, min: 900.4µs, avg: 178.7ms, p95: 343.7ms, max_proc_keys: 3546, p95_proc_keys: 1957, tot_proc: 11m9.8s, tot_wait: 3m43.2s, rpc_num: 5260, rpc_time: 15m39.6s, copr_cache: disabled}	data:Selection_94	N/A	N/A
20:57:06 [2021-05-29T20:57:06.979Z]       │ │   └─Selection_94	0.49	3496165	cop[tikv]		tikv_task:{proc max:137ms, min:0s, p80:68ms, p95:80ms, iters:30246, tasks:5260}, scan_detail: {total_process_keys: 7236256, total_keys: 7795454, rocksdb: {delete_skipped_count: 0, key_skipped_count: 1778268, block: {cache_hit_count: 54008055, read_count: 216297, read_byte: 4.17 GB}}}	eq(tpch50.orders.o_orderstatus, "F")	N/A	N/A
20:57:06 [2021-05-29T20:57:06.979Z]       │ │     └─TableRangeScan_93	1.00	7236256	cop[tikv]	table:orders	tikv_task:{proc max:137ms, min:0s, p80:67ms, p95:79ms, iters:30246, tasks:5260}	range: decided by [tpch50.lineitem.l_orderkey], keep order:false	N/A	N/A
20:57:06 [2021-05-29T20:57:06.979Z]       │ └─IndexLookUp_80(Probe)	4.05	17316453	root		time:1m57.8s, loops:17125, index_task: {total_time: 1m4.6s, fetch_handle: 56s, build: 2.81ms, wait: 8.56s}, table_task: {total_time: 8m23.7s, num: 1458, concurrency: 760}		19.3 KB	N/A
20:57:06 [2021-05-29T20:57:06.979Z]       │   ├─IndexRangeScan_78(Build)	4.05	17316453	cop[tikv]	table:l2, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:53.8s, loops:18612, cop_task: {num: 2965, max: 728.5ms, min: 631.9µs, avg: 185.5ms, p95: 375ms, max_proc_keys: 12517, p95_proc_keys: 8742, tot_proc: 6m48.6s, tot_wait: 1m56.4s, rpc_num: 2965, rpc_time: 9m9.9s, copr_cache: disabled}, tikv_task:{proc max:163ms, min:0s, p80:95ms, p95:110ms, iters:30045, tasks:2965}, scan_detail: {total_process_keys: 17316453, total_keys: 20812555, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17316453, block: {cache_hit_count: 24259960, 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:57:06 [2021-05-29T20:57:06.979Z]       │   └─TableRowIDScan_79(Probe)	4.05	17316453	cop[tikv]	table:l2	time:6m13.1s, loops:21010, cop_task: {num: 7862, max: 703.1ms, min: 430.8µs, avg: 176.4ms, p95: 358.5ms, max_proc_keys: 11094, p95_proc_keys: 4858, tot_proc: 16m24.8s, tot_wait: 5m42.7s, rpc_num: 7862, rpc_time: 23m6.8s, copr_cache: disabled}, tikv_task:{proc max:209ms, min:0s, p80:102ms, p95:139ms, iters:50151, tasks:7862}, scan_detail: {total_process_keys: 17316453, total_keys: 18288063, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5622042, block: {cache_hit_count: 99029718, read_count: 1101, read_byte: 379.6 MB}}}	keep order:false	N/A	N/A
20:57:06 [2021-05-29T20:57:06.979Z]       └─IndexLookUp_39(Probe)	4.05	12022775	root		time:1m54.1s, loops:11949, index_task: {total_time: 1m1.7s, fetch_handle: 50.3s, build: 2.69ms, wait: 11.4s}, table_task: {total_time: 8m9.5s, num: 1410, concurrency: 735}		220.8 KB	N/A
20:57:06 [2021-05-29T20:57:06.979Z]         ├─IndexRangeScan_36(Build)	5.06	17183366	cop[tikv]	table:l3, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:47.9s, loops:18375, cop_task: {num: 2770, max: 704.2ms, min: 774µs, avg: 173.7ms, p95: 372.7ms, max_proc_keys: 19236, p95_proc_keys: 13683, tot_proc: 5m55.3s, tot_wait: 1m42.1s, rpc_num: 2770, rpc_time: 8m1.1s, copr_cache: disabled}, tikv_task:{proc max:202ms, min:0s, p80:77ms, p95:119ms, iters:29065, tasks:2770}, scan_detail: {total_process_keys: 17183366, total_keys: 20546389, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17183366, 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:57:06 [2021-05-29T20:57:06.979Z]         └─Selection_38(Probe)	4.05	12022775	cop[tikv]		time:6m15.4s, loops:13753, cop_task: {num: 10203, max: 667.1ms, min: 471.7µs, avg: 174.4ms, p95: 354.9ms, max_proc_keys: 7208, p95_proc_keys: 3981, tot_proc: 20m38.4s, tot_wait: 7m43.9s, rpc_num: 10203, rpc_time: 29m38.7s, copr_cache: disabled}, tikv_task:{proc max:210ms, min:0s, p80:76ms, p95:116ms, iters:60633, tasks:10203}, scan_detail: {total_process_keys: 17183366, total_keys: 18129030, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5526992, block: {cache_hit_count: 98288312, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:57:06 [2021-05-29T20:57:06.979Z]           └─TableRowIDScan_37	5.06	17183366	cop[tikv]	table:l3	tikv_task:{proc max:210ms, min:0s, p80:75ms, p95:115ms, iters:60633, tasks:10203}	keep order:false	N/A	N/A
20:57:06 [2021-05-29T20:57:06.979Z] + tiup cluster stop benchbot -y
20:57:06 [2021-05-29T20:57:06.979Z] Starting component `cluster`: /home/tidb/.tiup/components/cluster/v1.4.4/tiup-cluster stop benchbot -y
20:57:09 [2021-05-29T20:57:09.492Z] + rm -rf '/data1/tidb-deploy/*/log/*'
20:57:09 [2021-05-29T20:57:09.492Z] + rm -rf /data1/jenkins/deploy/data/tikv-20160
20:57:13 [2021-05-29T20:57:13.659Z] + rm -rf /data1/jenkins/deploy/data/pd-2379
20:57:13 [2021-05-29T20:57:13.659Z] + rm -rf /data1/jenkins/restore_data/tpch50/data/last_tikv.toml
20:57:13 [2021-05-29T20:57:13.659Z] + cp -R /data1/jenkins/restore_data/tpch50/data /data1/jenkins/deploy/data/tikv-20160
20:58:50 [2021-05-29T20:58:50.193Z] + cp -R /data1/jenkins/restore_data/tpch50/data.pd /data1/jenkins/deploy/data/pd-2379
20:58:50 [2021-05-29T20:58:50.193Z] + '[' -n '' ']'
20:58:50 [2021-05-29T20:58:50.193Z] + tiup cluster start benchbot --wait-timeout=300
20:58:50 [2021-05-29T20:58:50.193Z] Starting component `cluster`: /home/tidb/.tiup/components/cluster/v1.4.4/tiup-cluster start benchbot --wait-timeout=300
20:59:22 [2021-05-29T20:59:22.297Z] + sync
20:59:22 [2021-05-29T20:59:22.297Z] + /usr/bin/echo 3
21:00:00 [2021-05-29T21:00:00.953Z] + sync
21:00:00 [2021-05-29T21:00:00.953Z] + /usr/bin/echo 3
21:00:27 [2021-05-29T21:00:27.447Z] + sync
21:00:27 [2021-05-29T21:00:27.447Z] + /usr/bin/echo 3
21:00:59 [2021-05-29T21:00:59.479Z] 
21:00:59 [2021-05-29T21:00:59.479Z] queries/22.sql
21:00:59 [2021-05-29T21:00:59.479Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
21:00:59 [2021-05-29T21:00:59.479Z] Sort_39	1600000.00	4	root		time:26.8s, loops:2	Column#27	9.48 KB	0 Bytes
21:00:59 [2021-05-29T21:00:59.479Z] └─Projection_41	1600000.00	4	root		time:26.8s, loops:5, Concurrency:5	Column#27, Column#28, Column#29	23.7 KB	N/A
21:00:59 [2021-05-29T21:00:59.479Z]   └─HashAgg_42	1600000.00	4	root		time:26.8s, loops:5, partial_worker:{wall_time:26.780499583s, concurrency:5, task_num:179, tot_wait:2m13.850651553s, tot_exec:51.121804ms, tot_time:2m13.901934271s, max:26.780450245s, p95:26.780450245s}, final_worker:{wall_time:26.780544761s, concurrency:5, task_num:20, tot_wait:2m13.902137173s, tot_exec:257.752µs, tot_time:2m13.902403579s, max:26.7804958s, p95:26.7804958s}	group by:Column#33, funcs:count(1)->Column#28, funcs:sum(Column#31)->Column#29, funcs:firstrow(Column#32)->Column#27	857.7 KB	N/A
21:00:59 [2021-05-29T21:00:59.479Z]     └─Projection_51	1600000.00	181704	root		time:26.8s, loops:180, Concurrency:5	tpch50.customer.c_acctbal, substring(tpch50.customer.c_phone, 1, 2)->Column#32, substring(tpch50.customer.c_phone, 1, 2)->Column#33	703.6 KB	N/A
21:00:59 [2021-05-29T21:00:59.479Z]       └─HashJoin_43	1600000.00	181704	root		time:26.8s, loops:180, build_hash_table:{total:25.4s, fetch:1.02s, build:24.4s}, probe:{concurrency:5, total:2m13.9s, max:26.8s, probe:5.42s, fetch:2m8.5s}	anti semi join, equal:[eq(tpch50.customer.c_custkey, tpch50.orders.o_custkey)]	590.2 MB	0 Bytes
21:00:59 [2021-05-29T21:00:59.479Z]         ├─TableReader_49(Build)	75000000.00	75000000	root		time:1.05s, loops:73364, cop_task: {num: 153, max: 951.5ms, min: 253.6ms, avg: 581.5ms, p95: 863.1ms, max_proc_keys: 723875, p95_proc_keys: 553332, tot_proc: 1m28.1s, tot_wait: 43ms, rpc_num: 153, rpc_time: 1m29s, copr_cache: disabled}	data:TableFullScan_48	57.8 MB	N/A
21:00:59 [2021-05-29T21:00:59.479Z]         │ └─TableFullScan_48	75000000.00	75000000	cop[tikv]	table:orders	tikv_task:{proc max:915ms, min:242ms, p80:578ms, p95:831ms, 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: 3041, read_count: 219912, read_byte: 4.30 GB}}}	keep order:false	N/A	N/A
21:00:59 [2021-05-29T21:00:59.479Z]         └─Selection_47(Probe)	2000000.00	545246	root		time:1.46s, loops:534	in(substring(tpch50.customer.c_phone, 1, 2), "20", "40", "22", "30", "39", "42", "21")	94.6 KB	N/A
21:00:59 [2021-05-29T21:00:59.479Z]           └─TableReader_46	2000000.00	3407619	root		time:572ms, loops:3319, cop_task: {num: 18, max: 1.02s, min: 494.7ms, avg: 765.2ms, p95: 1.02s, max_proc_keys: 582617, p95_proc_keys: 582617, tot_proc: 13.3s, rpc_num: 18, rpc_time: 13.8s, copr_cache: disabled}	data:Selection_45	192.5 MB	N/A
21:00:59 [2021-05-29T21:00:59.479Z]             └─Selection_45	2000000.00	3407619	cop[tikv]		tikv_task:{proc max:945ms, min:463ms, p80:882ms, p95:945ms, iters:7404, tasks:18}, scan_detail: {total_process_keys: 7500000, total_keys: 7500018, rocksdb: {delete_skipped_count: 0, key_skipped_count: 14999982, block: {cache_hit_count: 28451, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.customer.c_acctbal, 5000.602894)	N/A	N/A
21:00:59 [2021-05-29T21:00:59.479Z]               └─TableFullScan_44	7500000.00	7500000	cop[tikv]	table:customer	tikv_task:{proc max:865ms, min:417ms, p80:808ms, p95:865ms, iters:7404, tasks:18}	keep order:false	N/A	N/A
21:00:59 [2021-05-29T21:00:59.479Z] 
21:00:59 [2021-05-29T21:00:59.479Z] queries/22.sql
21:00:59 [2021-05-29T21:00:59.479Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
21:00:59 [2021-05-29T21:00:59.479Z] Sort_39	2186432.06	4	root		time:26.1s, loops:2	Column#27	9.48 KB	0 Bytes
21:00:59 [2021-05-29T21:00:59.479Z] └─Projection_41	2186432.06	4	root		time:26.1s, loops:5, Concurrency:5	Column#27, Column#28, Column#29	23.7 KB	N/A
21:00:59 [2021-05-29T21:00:59.479Z]   └─HashAgg_42	2186432.06	4	root		time:26.1s, loops:5, partial_worker:{wall_time:26.070653788s, concurrency:5, task_num:180, tot_wait:2m10.303950031s, tot_exec:47.629014ms, tot_time:2m10.351670487s, max:26.070615666s, p95:26.070615666s}, final_worker:{wall_time:26.070717344s, concurrency:5, task_num:20, tot_wait:2m10.353153258s, tot_exec:217.701µs, tot_time:2m10.353379638s, max:26.070701224s, p95:26.070701224s}	group by:Column#33, funcs:count(1)->Column#28, funcs:sum(Column#31)->Column#29, funcs:firstrow(Column#32)->Column#27	857.7 KB	N/A
21:00:59 [2021-05-29T21:00:59.479Z]     └─Projection_51	2186432.06	181704	root		time:26.1s, loops:181, Concurrency:5	tpch50.customer.c_acctbal, substring(tpch50.customer.c_phone, 1, 2)->Column#32, substring(tpch50.customer.c_phone, 1, 2)->Column#33	703.6 KB	N/A
21:00:59 [2021-05-29T21:00:59.479Z]       └─HashJoin_43	2186432.06	181704	root		time:26.1s, loops:181, build_hash_table:{total:24.8s, fetch:929ms, build:23.8s}, probe:{concurrency:5, total:2m10.3s, max:26.1s, probe:5.37s, fetch:2m5s}	anti semi join, equal:[eq(tpch50.customer.c_custkey, tpch50.orders.o_custkey)]	590.2 MB	0 Bytes
21:00:59 [2021-05-29T21:00:59.479Z]         ├─TableReader_49(Build)	75000000.00	75000000	root		time:954.3ms, loops:73364, cop_task: {num: 153, max: 1.13s, min: 203.7ms, avg: 528.9ms, p95: 919.7ms, max_proc_keys: 723875, p95_proc_keys: 553332, tot_proc: 1m20.2s, tot_wait: 37ms, rpc_num: 153, rpc_time: 1m20.9s, copr_cache: disabled}	data:TableFullScan_48	57.8 MB	N/A
21:00:59 [2021-05-29T21:00:59.479Z]         │ └─TableFullScan_48	75000000.00	75000000	cop[tikv]	table:orders	tikv_task:{proc max:1.09s, min:195ms, p80:583ms, p95:884ms, iters:73975, tasks:153}, scan_detail: {total_process_keys: 75000000, total_keys: 75000153, rocksdb: {delete_skipped_count: 0, key_skipped_count: 149999847, block: {cache_hit_count: 220923, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
21:00:59 [2021-05-29T21:00:59.479Z]         └─Selection_47(Probe)	2733040.07	545246	root		time:1.34s, loops:534	in(substring(tpch50.customer.c_phone, 1, 2), "20", "40", "22", "30", "39", "42", "21")	94.6 KB	N/A
21:00:59 [2021-05-29T21:00:59.479Z]           └─TableReader_46	2733040.07	3407619	root		time:511.8ms, loops:3319, cop_task: {num: 18, max: 1.19s, min: 394.1ms, avg: 867.1ms, p95: 1.19s, max_proc_keys: 582617, p95_proc_keys: 582617, tot_proc: 15.1s, rpc_num: 18, rpc_time: 15.6s, copr_cache: disabled}	data:Selection_45	192.5 MB	N/A
21:00:59 [2021-05-29T21:00:59.479Z]             └─Selection_45	2733040.07	3407619	cop[tikv]		tikv_task:{proc max:1.11s, min:353ms, p80:954ms, 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:00:59 [2021-05-29T21:00:59.479Z]               └─TableFullScan_44	7500000.00	7500000	cop[tikv]	table:customer	tikv_task:{proc max:1.02s, min:322ms, p80:870ms, p95:1.02s, iters:7404, tasks:18}	keep order:false	N/A	N/A
21:00:59 [2021-05-29T21:00:59.479Z] 
21:00:59 [2021-05-29T21:00:59.479Z] queries/22.sql
21:00:59 [2021-05-29T21:00:59.479Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
21:00:59 [2021-05-29T21:00:59.479Z] Sort_39	2186432.06	4	root		time:26.9s, loops:2	Column#27	9.48 KB	0 Bytes
21:00:59 [2021-05-29T21:00:59.479Z] └─Projection_41	2186432.06	4	root		time:26.9s, loops:5, Concurrency:5	Column#27, Column#28, Column#29	23.7 KB	N/A
21:00:59 [2021-05-29T21:00:59.479Z]   └─HashAgg_42	2186432.06	4	root		time:26.9s, loops:5, partial_worker:{wall_time:26.863692422s, concurrency:5, task_num:180, tot_wait:2m14.261872636s, tot_exec:56.101322ms, tot_time:2m14.318113167s, max:26.863674748s, p95:26.863674748s}, final_worker:{wall_time:26.863721835s, concurrency:5, task_num:20, tot_wait:2m14.31824738s, tot_exec:177.319µs, tot_time:2m14.318431779s, max:26.863699531s, p95:26.863699531s}	group by:Column#33, funcs:count(1)->Column#28, funcs:sum(Column#31)->Column#29, funcs:firstrow(Column#32)->Column#27	857.7 KB	N/A
21:00:59 [2021-05-29T21:00:59.479Z]     └─Projection_51	2186432.06	181704	root		time:26.9s, loops:181, Concurrency:5	tpch50.customer.c_acctbal, substring(tpch50.customer.c_phone, 1, 2)->Column#32, substring(tpch50.customer.c_phone, 1, 2)->Column#33	703.6 KB	N/A
21:00:59 [2021-05-29T21:00:59.479Z]       └─HashJoin_43	2186432.06	181704	root		time:26.9s, loops:181, build_hash_table:{total:25.3s, fetch:1.01s, build:24.3s}, probe:{concurrency:5, total:2m14.3s, max:26.9s, probe:6.36s, fetch:2m7.9s}	anti semi join, equal:[eq(tpch50.customer.c_custkey, tpch50.orders.o_custkey)]	590.2 MB	0 Bytes
21:00:59 [2021-05-29T21:00:59.479Z]         ├─TableReader_49(Build)	75000000.00	75000000	root		time:1.04s, loops:73364, cop_task: {num: 153, max: 994.4ms, min: 203.5ms, avg: 498.1ms, p95: 840.6ms, max_proc_keys: 723875, p95_proc_keys: 553332, tot_proc: 1m15.4s, tot_wait: 42ms, rpc_num: 153, rpc_time: 1m16.2s, copr_cache: disabled}	data:TableFullScan_48	57.8 MB	N/A
21:00:59 [2021-05-29T21:00:59.479Z]         │ └─TableFullScan_48	75000000.00	75000000	cop[tikv]	table:orders	tikv_task:{proc max:920ms, min:192ms, p80:483ms, p95:805ms, iters:73975, tasks:153}, scan_detail: {total_process_keys: 75000000, total_keys: 75000153, rocksdb: {delete_skipped_count: 0, key_skipped_count: 149999847, block: {cache_hit_count: 220923, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
21:00:59 [2021-05-29T21:00:59.479Z]         └─Selection_47(Probe)	2733040.07	545246	root		time:1.51s, loops:534	in(substring(tpch50.customer.c_phone, 1, 2), "20", "40", "22", "30", "39", "42", "21")	94.6 KB	N/A
21:00:59 [2021-05-29T21:00:59.479Z]           └─TableReader_46	2733040.07	3407619	root		time:561.2ms, loops:3319, cop_task: {num: 18, max: 1.11s, min: 433.9ms, avg: 843.9ms, p95: 1.11s, max_proc_keys: 582617, p95_proc_keys: 582617, tot_proc: 14.7s, rpc_num: 18, rpc_time: 15.2s, copr_cache: disabled}	data:Selection_45	192.5 MB	N/A
21:00:59 [2021-05-29T21:00:59.479Z]             └─Selection_45	2733040.07	3407619	cop[tikv]		tikv_task:{proc max:1.04s, min:410ms, p80:959ms, p95:1.04s, iters:7404, tasks:18}, scan_detail: {total_process_keys: 7500000, total_keys: 7500018, rocksdb: {delete_skipped_count: 0, key_skipped_count: 14999982, block: {cache_hit_count: 28451, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.customer.c_acctbal, 5000.602894)	N/A	N/A
21:00:59 [2021-05-29T21:00:59.479Z]               └─TableFullScan_44	7500000.00	7500000	cop[tikv]	table:customer	tikv_task:{proc max:954ms, min:376ms, p80:898ms, p95:954ms, iters:7404, tasks:18}	keep order:false	N/A	N/A
21:00:59 [2021-05-29T21:00:59.479Z] + sync
21:00:59 [2021-05-29T21:00:59.479Z] + /usr/bin/echo 3
21:01:31 [2021-05-29T21:01:31.508Z] + sync
21:01:31 [2021-05-29T21:01:31.508Z] + /usr/bin/echo 3
21:01:58 [2021-05-29T21:01:58.169Z] + sync
21:01:58 [2021-05-29T21:01:58.169Z] + /usr/bin/echo 3
21:02:30 [2021-05-29T21:02:30.184Z] 
21:02:30 [2021-05-29T21:02:30.184Z] queries/22.sql
21:02:30 [2021-05-29T21:02:30.184Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
21:02:30 [2021-05-29T21:02:30.184Z] Sort_39	2186432.06	4	root		time:27.1s, loops:2	Column#27	9.48 KB	0 Bytes
21:02:30 [2021-05-29T21:02:30.184Z] └─Projection_41	2186432.06	4	root		time:27.1s, loops:5, Concurrency:5	Column#27, Column#28, Column#29	23.7 KB	N/A
21:02:30 [2021-05-29T21:02:30.184Z]   └─HashAgg_42	2186432.06	4	root		time:27.1s, loops:5, partial_worker:{wall_time:27.070059456s, concurrency:5, task_num:179, tot_wait:2m15.298595607s, tot_exec:51.059005ms, tot_time:2m15.349808037s, max:27.070034795s, p95:27.070034795s}, final_worker:{wall_time:27.070076404s, concurrency:5, task_num:20, tot_wait:2m15.349827881s, tot_exec:301.412µs, tot_time:2m15.350138182s, max:27.070034412s, p95:27.070034412s}	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:30 [2021-05-29T21:02:30.184Z]     └─Projection_51	2186432.06	181704	root		time:27.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	703.6 KB	N/A
21:02:30 [2021-05-29T21:02:30.184Z]       └─HashJoin_43	2186432.06	181704	root		time:27.1s, loops:180, build_hash_table:{total:25.7s, fetch:1.02s, build:24.6s}, probe:{concurrency:5, total:2m15.3s, max:27.1s, probe:5.8s, fetch:2m9.5s}	anti semi join, equal:[eq(tpch50.customer.c_custkey, tpch50.orders.o_custkey)]	590.2 MB	0 Bytes
21:02:30 [2021-05-29T21:02:30.184Z]         ├─TableReader_49(Build)	75000000.00	75000000	root		time:1.04s, loops:73364, cop_task: {num: 153, max: 1.06s, min: 225ms, avg: 494.1ms, p95: 891.2ms, max_proc_keys: 723875, p95_proc_keys: 553332, tot_proc: 1m14.8s, tot_wait: 42ms, rpc_num: 153, rpc_time: 1m15.6s, copr_cache: disabled}	data:TableFullScan_48	57.8 MB	N/A
21:02:30 [2021-05-29T21:02:30.184Z]         │ └─TableFullScan_48	75000000.00	75000000	cop[tikv]	table:orders	tikv_task:{proc max:1.02s, min:215ms, p80:478ms, p95:853ms, 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:30 [2021-05-29T21:02:30.184Z]         └─Selection_47(Probe)	2733040.07	545246	root		time:1.54s, loops:534	in(substring(tpch50.customer.c_phone, 1, 2), "20", "40", "22", "30", "39", "42", "21")	94.6 KB	N/A
21:02:30 [2021-05-29T21:02:30.184Z]           └─TableReader_46	2733040.07	3407619	root		time:667.9ms, loops:3319, cop_task: {num: 18, max: 1.26s, min: 502.3ms, avg: 865.9ms, p95: 1.26s, max_proc_keys: 582617, p95_proc_keys: 582617, tot_proc: 15.1s, tot_wait: 1ms, rpc_num: 18, rpc_time: 15.6s, copr_cache: disabled}	data:Selection_45	192.5 MB	N/A
21:02:30 [2021-05-29T21:02:30.184Z]             └─Selection_45	2733040.07	3407619	cop[tikv]		tikv_task:{proc max:1.17s, min:453ms, p80:970ms, p95:1.17s, iters:7404, tasks:18}, scan_detail: {total_process_keys: 7500000, total_keys: 7500018, rocksdb: {delete_skipped_count: 0, key_skipped_count: 14999982, block: {cache_hit_count: 28451, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.customer.c_acctbal, 5000.602894)	N/A	N/A
21:02:30 [2021-05-29T21:02:30.184Z]               └─TableFullScan_44	7500000.00	7500000	cop[tikv]	table:customer	tikv_task:{proc max:1.09s, min:409ms, p80:905ms, p95:1.09s, iters:7404, tasks:18}	keep order:false	N/A	N/A
21:02:30 [2021-05-29T21:02:30.184Z] 
21:02:30 [2021-05-29T21:02:30.184Z] queries/22.sql
21:02:30 [2021-05-29T21:02:30.184Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
21:02:30 [2021-05-29T21:02:30.184Z] Sort_39	2186432.06	4	root		time:26.2s, loops:2	Column#27	9.48 KB	0 Bytes
21:02:30 [2021-05-29T21:02:30.184Z] └─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:02:30 [2021-05-29T21:02:30.184Z]   └─HashAgg_42	2186432.06	4	root		time:26.2s, loops:5, partial_worker:{wall_time:26.234087411s, concurrency:5, task_num:180, tot_wait:2m11.120334756s, tot_exec:48.953921ms, tot_time:2m11.169398721s, max:26.234040265s, p95:26.234040265s}, final_worker:{wall_time:26.234094366s, concurrency:5, task_num:20, tot_wait:2m11.170106818s, tot_exec:216.108µs, tot_time:2m11.170331329s, max:26.234071389s, p95:26.234071389s}	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:30 [2021-05-29T21:02:30.184Z]     └─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	703.6 KB	N/A
21:02:30 [2021-05-29T21:02:30.184Z]       └─HashJoin_43	2186432.06	181704	root		time:26.2s, loops:181, build_hash_table:{total:24.9s, fetch:1.01s, build:23.9s}, probe:{concurrency:5, total:2m11.1s, max:26.2s, probe:5.54s, fetch:2m5.6s}	anti semi join, equal:[eq(tpch50.customer.c_custkey, tpch50.orders.o_custkey)]	590.2 MB	0 Bytes
21:02:30 [2021-05-29T21:02:30.184Z]         ├─TableReader_49(Build)	75000000.00	75000000	root		time:1.04s, loops:73364, cop_task: {num: 153, max: 877ms, min: 201.8ms, avg: 479.1ms, p95: 807ms, max_proc_keys: 723875, p95_proc_keys: 553332, tot_proc: 1m12.6s, tot_wait: 47ms, rpc_num: 153, rpc_time: 1m13.3s, copr_cache: disabled}	data:TableFullScan_48	57.8 MB	N/A
21:02:30 [2021-05-29T21:02:30.184Z]         │ └─TableFullScan_48	75000000.00	75000000	cop[tikv]	table:orders	tikv_task:{proc max:851ms, min:192ms, p80:467ms, p95:789ms, iters:73975, tasks:153}, scan_detail: {total_process_keys: 75000000, total_keys: 75000153, rocksdb: {delete_skipped_count: 0, key_skipped_count: 149999847, block: {cache_hit_count: 220923, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
21:02:30 [2021-05-29T21:02:30.184Z]         └─Selection_47(Probe)	2733040.07	545246	root		time:1.42s, loops:534	in(substring(tpch50.customer.c_phone, 1, 2), "20", "40", "22", "30", "39", "42", "21")	94.6 KB	N/A
21:02:30 [2021-05-29T21:02:30.184Z]           └─TableReader_46	2733040.07	3407619	root		time:552.9ms, loops:3319, cop_task: {num: 18, max: 1.14s, min: 464.7ms, avg: 811ms, p95: 1.14s, max_proc_keys: 582617, p95_proc_keys: 582617, tot_proc: 14.2s, tot_wait: 12ms, rpc_num: 18, rpc_time: 14.6s, copr_cache: disabled}	data:Selection_45	192.5 MB	N/A
21:02:30 [2021-05-29T21:02:30.184Z]             └─Selection_45	2733040.07	3407619	cop[tikv]		tikv_task:{proc max:1.06s, min:429ms, p80:919ms, 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:30 [2021-05-29T21:02:30.184Z]               └─TableFullScan_44	7500000.00	7500000	cop[tikv]	table:customer	tikv_task:{proc max:972ms, min:395ms, p80:839ms, p95:972ms, iters:7404, tasks:18}	keep order:false	N/A	N/A
21:02:30 [2021-05-29T21:02:30.184Z] 
21:02:30 [2021-05-29T21:02:30.184Z] queries/22.sql
21:02:30 [2021-05-29T21:02:30.184Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
21:02:30 [2021-05-29T21:02:30.184Z] Sort_39	2186432.06	4	root		time:26.5s, loops:2	Column#27	9.48 KB	0 Bytes
21:02:30 [2021-05-29T21:02:30.184Z] └─Projection_41	2186432.06	4	root		time:26.5s, loops:5, Concurrency:5	Column#27, Column#28, Column#29	23.7 KB	N/A
21:02:30 [2021-05-29T21:02:30.184Z]   └─HashAgg_42	2186432.06	4	root		time:26.5s, loops:5, partial_worker:{wall_time:26.453587409s, concurrency:5, task_num:180, tot_wait:2m12.211734025s, tot_exec:55.66692ms, tot_time:2m12.267509834s, max:26.453553448s, p95:26.453553448s}, final_worker:{wall_time:26.453642262s, concurrency:5, task_num:20, tot_wait:2m12.267626354s, tot_exec:232.994µs, tot_time:2m12.267868264s, max:26.453590381s, p95:26.453590381s}	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:30 [2021-05-29T21:02:30.184Z]     └─Projection_51	2186432.06	181704	root		time:26.5s, loops:181, Concurrency:5	tpch50.customer.c_acctbal, substring(tpch50.customer.c_phone, 1, 2)->Column#32, substring(tpch50.customer.c_phone, 1, 2)->Column#33	703.6 KB	N/A
21:02:30 [2021-05-29T21:02:30.184Z]       └─HashJoin_43	2186432.06	181704	root		time:26.5s, loops:181, build_hash_table:{total:24.9s, fetch:823.2ms, build:24.1s}, probe:{concurrency:5, total:2m12.3s, max:26.5s, probe:6.08s, fetch:2m6.2s}	anti semi join, equal:[eq(tpch50.customer.c_custkey, tpch50.orders.o_custkey)]	590.2 MB	0 Bytes
21:02:30 [2021-05-29T21:02:30.184Z]         ├─TableReader_49(Build)	75000000.00	75000000	root		time:837.8ms, loops:73364, cop_task: {num: 153, max: 1.06s, min: 225.2ms, avg: 491.8ms, p95: 896.4ms, max_proc_keys: 723875, p95_proc_keys: 553332, tot_proc: 1m14.4s, tot_wait: 47ms, rpc_num: 153, rpc_time: 1m15.2s, copr_cache: disabled}	data:TableFullScan_48	57.8 MB	N/A
21:02:30 [2021-05-29T21:02:30.184Z]         │ └─TableFullScan_48	75000000.00	75000000	cop[tikv]	table:orders	tikv_task:{proc max:1.01s, min:216ms, p80:469ms, p95:851ms, 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:30 [2021-05-29T21:02:30.184Z]         └─Selection_47(Probe)	2733040.07	545246	root		time:1.73s, loops:534	in(substring(tpch50.customer.c_phone, 1, 2), "20", "40", "22", "30", "39", "42", "21")	94.6 KB	N/A
21:02:30 [2021-05-29T21:02:30.184Z]           └─TableReader_46	2733040.07	3407619	root		time:772.7ms, loops:3319, cop_task: {num: 18, max: 1.2s, min: 591.3ms, avg: 930.3ms, p95: 1.2s, max_proc_keys: 582617, p95_proc_keys: 582617, tot_proc: 16.3s, tot_wait: 1ms, rpc_num: 18, rpc_time: 16.7s, copr_cache: disabled}	data:Selection_45	192.5 MB	N/A
21:02:30 [2021-05-29T21:02:30.184Z]             └─Selection_45	2733040.07	3407619	cop[tikv]		tikv_task:{proc max:1.13s, min:541ms, p80:1.02s, p95:1.13s, iters:7404, tasks:18}, scan_detail: {total_process_keys: 7500000, total_keys: 7500018, rocksdb: {delete_skipped_count: 0, key_skipped_count: 14999982, block: {cache_hit_count: 28451, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.customer.c_acctbal, 5000.602894)	N/A	N/A
21:02:30 [2021-05-29T21:02:30.184Z]               └─TableFullScan_44	7500000.00	7500000	cop[tikv]	table:customer	tikv_task:{proc max:1.01s, min:490ms, p80:952ms, p95:1.01s, iters:7404, tasks:18}	keep order:false	N/A	N/A
21:02:30 [2021-05-29T21:02:30.184Z] + sync
21:02:30 [2021-05-29T21:02:30.184Z] + /usr/bin/echo 3
21:03:02 [2021-05-29T21:03:02.212Z] 
21:03:02 [2021-05-29T21:03:02.212Z] queries/22.sql
21:03:02 [2021-05-29T21:03:02.212Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
21:03:02 [2021-05-29T21:03:02.212Z] Sort_39	2186432.06	4	root		time:26.8s, loops:2	Column#27	9.48 KB	0 Bytes
21:03:02 [2021-05-29T21:03:02.212Z] └─Projection_41	2186432.06	4	root		time:26.8s, loops:5, Concurrency:5	Column#27, Column#28, Column#29	23.7 KB	N/A
21:03:02 [2021-05-29T21:03:02.212Z]   └─HashAgg_42	2186432.06	4	root		time:26.8s, loops:5, partial_worker:{wall_time:26.764750262s, concurrency:5, task_num:179, tot_wait:2m13.771708817s, tot_exec:50.83368ms, tot_time:2m13.822623202s, max:26.764664477s, p95:26.764664477s}, final_worker:{wall_time:26.764751555s, concurrency:5, task_num:20, tot_wait:2m13.823302045s, tot_exec:259.382µs, tot_time:2m13.823568929s, max:26.76471781s, p95:26.76471781s}	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:02 [2021-05-29T21:03:02.212Z]     └─Projection_51	2186432.06	181704	root		time:26.8s, loops:180, Concurrency:5	tpch50.customer.c_acctbal, substring(tpch50.customer.c_phone, 1, 2)->Column#32, substring(tpch50.customer.c_phone, 1, 2)->Column#33	703.6 KB	N/A
21:03:02 [2021-05-29T21:03:02.212Z]       └─HashJoin_43	2186432.06	181704	root		time:26.8s, loops:180, build_hash_table:{total:25.3s, fetch:777.9ms, build:24.5s}, probe:{concurrency:5, total:2m13.8s, max:26.8s, probe:6.14s, fetch:2m7.7s}	anti semi join, equal:[eq(tpch50.customer.c_custkey, tpch50.orders.o_custkey)]	590.2 MB	0 Bytes
21:03:02 [2021-05-29T21:03:02.212Z]         ├─TableReader_49(Build)	75000000.00	75000000	root		time:816.8ms, loops:73364, cop_task: {num: 153, max: 962.5ms, min: 224.2ms, avg: 477.6ms, p95: 837.1ms, max_proc_keys: 723875, p95_proc_keys: 553332, tot_proc: 1m12.3s, tot_wait: 44ms, rpc_num: 153, rpc_time: 1m13.1s, copr_cache: disabled}	data:TableFullScan_48	57.8 MB	N/A
21:03:02 [2021-05-29T21:03:02.212Z]         │ └─TableFullScan_48	75000000.00	75000000	cop[tikv]	table:orders	tikv_task:{proc max:932ms, min:214ms, p80:463ms, p95:811ms, 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:02 [2021-05-29T21:03:02.212Z]         └─Selection_47(Probe)	2733040.07	545246	root		time:1.64s, loops:534	in(substring(tpch50.customer.c_phone, 1, 2), "20", "40", "22", "30", "39", "42", "21")	94.6 KB	N/A
21:03:02 [2021-05-29T21:03:02.212Z]           └─TableReader_46	2733040.07	3407619	root		time:759.3ms, loops:3319, cop_task: {num: 18, max: 1.14s, min: 482.7ms, avg: 839.3ms, p95: 1.14s, max_proc_keys: 582617, p95_proc_keys: 582617, tot_proc: 14.7s, tot_wait: 11ms, rpc_num: 18, rpc_time: 15.1s, copr_cache: disabled}	data:Selection_45	192.5 MB	N/A
21:03:02 [2021-05-29T21:03:02.212Z]             └─Selection_45	2733040.07	3407619	cop[tikv]		tikv_task:{proc max:1.07s, min:438ms, p80:951ms, p95:1.07s, 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:02 [2021-05-29T21:03:02.212Z]               └─TableFullScan_44	7500000.00	7500000	cop[tikv]	table:customer	tikv_task:{proc max:985ms, min:395ms, p80:886ms, p95:985ms, iters:7404, tasks:18}	keep order:false	N/A	N/A
21:03:02 [2021-05-29T21:03:02.212Z] 
21:03:02 [2021-05-29T21:03:02.212Z] + tiup cluster stop benchbot
21:03:02 [2021-05-29T21:03:02.212Z] Starting component `cluster`: /home/tidb/.tiup/components/cluster/v1.4.4/tiup-cluster stop benchbot
21:03:02 [2021-05-29T21:03:02.212Z] + [ 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:02 [2021-05-29T21:03:02.213Z] + [Parallel] - UserSSH: user=tidb, host=172.16.5.86
21:03:02 [2021-05-29T21:03:02.213Z] + [Parallel] - UserSSH: user=tidb, host=172.16.5.86
21:03:02 [2021-05-29T21:03:02.213Z] + [Parallel] - UserSSH: user=tidb, host=172.16.5.86
21:03:02 [2021-05-29T21:03:02.213Z] + [Parallel] - UserSSH: user=tidb, host=172.16.5.86
21:03:02 [2021-05-29T21:03:02.213Z] + [Parallel] - UserSSH: user=tidb, host=172.16.5.86
21:03:02 [2021-05-29T21:03:02.213Z] + [ Serial ] - StopCluster
21:03:02 [2021-05-29T21:03:02.213Z] Stopping component grafana
21:03:02 [2021-05-29T21:03:02.213Z] 	Stopping instance 172.16.5.86
21:03:02 [2021-05-29T21:03:02.468Z] 	Stop grafana 172.16.5.86:3000 success
21:03:02 [2021-05-29T21:03:02.468Z] Stopping component prometheus
21:03:02 [2021-05-29T21:03:02.468Z] 	Stopping instance 172.16.5.86
21:03:02 [2021-05-29T21:03:02.468Z] 	Stop prometheus 172.16.5.86:9090 success
21:03:02 [2021-05-29T21:03:02.468Z] Stopping component tidb
21:03:02 [2021-05-29T21:03:02.468Z] 	Stopping instance 172.16.5.86
21:03:05 [2021-05-29T21:03:05.734Z] 	Stop tidb 172.16.5.86:4000 success
21:03:05 [2021-05-29T21:03:05.734Z] Stopping component tikv
21:03:05 [2021-05-29T21:03:05.734Z] 	Stopping instance 172.16.5.86
21:03:09 [2021-05-29T21:03:09.897Z] 	Stop tikv 172.16.5.86:20160 success
21:03:09 [2021-05-29T21:03:09.897Z] Stopping component pd
21:03:09 [2021-05-29T21:03:09.897Z] 	Stopping instance 172.16.5.86
21:03:09 [2021-05-29T21:03:09.897Z] 	Stop pd 172.16.5.86:2379 success
21:03:09 [2021-05-29T21:03:09.897Z] Stopping component node_exporter
21:03:09 [2021-05-29T21:03:09.897Z] Stopping component blackbox_exporter
21:03:10 [2021-05-29T21:03:10.153Z] Stopped cluster `benchbot` successfully
21:03:10 [2021-05-29T21:03:10.161Z] [Pipeline] sh
21:03:10 [2021-05-29T21:03:10.444Z] + cat bench_result
21:03:10 [2021-05-29T21:03:10.450Z] [Pipeline] }
21:03:10 [2021-05-29T21:03:10.453Z] [Pipeline] // dir
21:03:10 [2021-05-29T21:03:10.455Z] [Pipeline] }
21:03:10 [2021-05-29T21:03:10.456Z] [Pipeline] // stage
21:03:10 [2021-05-29T21:03:10.458Z] [Pipeline] }
21:03:10 [2021-05-29T21:03:10.461Z] [Pipeline] // node
21:03:10 [2021-05-29T21:03:10.463Z] [Pipeline] }
21:03:10 [2021-05-29T21:03:10.465Z] [Pipeline] // catchError
21:03:10 [2021-05-29T21:03:10.471Z] [Pipeline] stage
21:03:10 [2021-05-29T21:03:10.474Z] [Pipeline] { (Summary)
21:03:10 [2021-05-29T21:03:10.486Z] [Pipeline] slackSend
21:03:10 [2021-05-29T21:03:10.487Z] 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:10 [2021-05-29T21:03:10.517Z] sh: line 1: 10680 Terminated              sleep 3
21:03:10 [2021-05-29T21:03:10.561Z] sh: line 1: 10819 Terminated              sleep 3
21:03:11 [2021-05-29T21:03:11.208Z] [Pipeline] }
21:03:11 [2021-05-29T21:03:11.211Z] [Pipeline] // stage
21:03:11 [2021-05-29T21:03:11.213Z] [Pipeline] End of Pipeline
21:03:11 [2021-05-29T21:03:11.230Z] Finished: SUCCESS