SuccessConsole Output

Skipping 1,193 KB.. Full Log
vailqty, funcs:sum(tpch50.lineitem.l_quantity)->Column#44	194.5 MB	N/A
20:37:43 [2021-06-06T20:37:43.202Z]         └─HashJoin_59	9711455.06	634004	root		time:37.3s, loops:625, build_hash_table:{total:2.39s, fetch:2.12s, build:264.8ms}, probe:{concurrency:5, total:3m6.4s, max:37.3s, probe:15.4s, fetch:2m50.9s}	left outer join, equal:[eq(tpch50.partsupp.ps_partkey, tpch50.lineitem.l_partkey) eq(tpch50.partsupp.ps_suppkey, tpch50.lineitem.l_suppkey)]	10.4 MB	0 Bytes
20:37:43 [2021-06-06T20:37:43.202Z]           ├─IndexHashJoin_67(Build)	321865.05	435528	root		time:2.3s, loops:430, inner:{total:2.67s, concurrency:5, task:12, construct:123.7ms, fetch:2.19s, build:26.4ms, join:363.1ms}	inner join, inner:IndexLookUp_64, outer key:tpch50.part.p_partkey, inner key:tpch50.partsupp.ps_partkey, equal cond:eq(tpch50.part.p_partkey, tpch50.partsupp.ps_partkey)	20.0 MB	N/A
20:37:43 [2021-06-06T20:37:43.202Z]           │ ├─TableReader_96(Build)	80007.93	108882	root		time:1.96s, loops:112, cop_task: {num: 20, max: 1.46s, min: 556.6ms, avg: 1.07s, p95: 1.46s, max_proc_keys: 686055, p95_proc_keys: 686055, tot_proc: 21.3s, tot_wait: 7ms, rpc_num: 20, rpc_time: 21.3s, copr_cache: disabled}	data:Selection_95	660.2 KB	N/A
20:37:43 [2021-06-06T20:37:43.202Z]           │ │ └─Selection_95	80007.93	108882	cop[tikv]		tikv_task:{proc max:1.42s, min:552ms, p80:1.35s, p95:1.42s, 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:37:43 [2021-06-06T20:37:43.203Z]           │ │   └─TableFullScan_94	10000000.00	10000000	cop[tikv]	table:part	tikv_task:{proc max:1.32s, min:519ms, p80:1.26s, p95:1.32s, iters:9859, tasks:20}	keep order:false	N/A	N/A
20:37:43 [2021-06-06T20:37:43.203Z]           │ └─IndexLookUp_64(Probe)	4.02	435528	root		time:2.05s, loops:447, index_task: {total_time: 1.22s, fetch_handle: 1.22s, build: 100.1µs, wait: 275.8µs}, table_task: {total_time: 7.89s, num: 56, concurrency: 60}		20.5 KB	N/A
20:37:43 [2021-06-06T20:37:43.203Z]           │   ├─IndexRangeScan_62(Build)	4.02	435528	cop[tikv]	table:partsupp, index:PRIMARY(PS_PARTKEY, PS_SUPPKEY)	time:1.18s, loops:481, cop_task: {num: 60, max: 208.7ms, min: 5.3ms, avg: 88.2ms, p95: 183.3ms, max_proc_keys: 15288, p95_proc_keys: 15008, tot_proc: 4.88s, tot_wait: 55ms, rpc_num: 60, rpc_time: 5.29s, copr_cache: disabled}, tikv_task:{proc max:194ms, min:4ms, p80:139ms, p95:173ms, iters:698, tasks:60}, scan_detail: {total_process_keys: 435528, total_keys: 544410, rocksdb: {delete_skipped_count: 0, key_skipped_count: 435528, block: {cache_hit_count: 980292, read_count: 0, read_byte: 0 Bytes}}}	range: decided by [eq(tpch50.partsupp.ps_partkey, tpch50.part.p_partkey)], keep order:false	N/A	N/A
20:37:43 [2021-06-06T20:37:43.203Z]           │   └─TableRowIDScan_63(Probe)	4.02	435528	cop[tikv]	table:partsupp	time:2.51s, loops:505, cop_task: {num: 1445, max: 55.6ms, min: 968.4µs, avg: 17.7ms, p95: 34.3ms, max_proc_keys: 992, p95_proc_keys: 548, tot_proc: 18.8s, tot_wait: 4.86s, rpc_num: 1445, rpc_time: 25.5s, copr_cache: disabled}, tikv_task:{proc max:45ms, min:0s, p80:17ms, p95:23ms, iters:5353, tasks:1445}, scan_detail: {total_process_keys: 435528, total_keys: 473501, rocksdb: {delete_skipped_count: 0, key_skipped_count: 194063, block: {cache_hit_count: 3644309, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:37:43 [2021-06-06T20:37:43.203Z]           └─TableReader_101(Probe)	46310896.67	45504356	root		time:32.8s, loops:44290, cop_task: {num: 761, max: 1.17s, min: 390.9ms, avg: 696ms, p95: 846.1ms, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 8m46.4s, tot_wait: 126ms, rpc_num: 761, rpc_time: 8m49.6s, copr_cache: disabled}	data:Selection_100	52.6 MB	N/A
20:37:43 [2021-06-06T20:37:43.203Z]             └─Selection_100	46310896.67	45504356	cop[tikv]		tikv_task:{proc max:1.13s, min:378ms, p80:742ms, p95:827ms, 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:37:43 [2021-06-06T20:37:43.203Z]               └─TableFullScan_99	300005811.00	300005811	cop[tikv]	table:lineitem	tikv_task:{proc max:1.08s, min:358ms, p80:711ms, p95:794ms, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:37:43 [2021-06-06T20:37:43.203Z] + sync
20:37:43 [2021-06-06T20:37:43.203Z] + /usr/bin/echo 3
20:38:29 [2021-06-06T20:38:29.798Z] + sync
20:38:29 [2021-06-06T20:38:29.798Z] + /usr/bin/echo 3
20:39:08 [2021-06-06T20:39:08.441Z] 
20:39:08 [2021-06-06T20:39:08.441Z] queries/20.sql
20:39:08 [2021-06-06T20:39:08.441Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:39:08 [2021-06-06T20:39:08.441Z] Sort_30	20000.00	8982	root		time:37.6s, loops:10	tpch50.supplier.s_name	608.0 KB	0 Bytes
20:39:08 [2021-06-06T20:39:08.441Z] └─HashJoin_35	20000.00	8982	root		time:37.6s, loops:12, build_hash_table:{total:1.23s, fetch:1.22s, build:9.65ms}, probe:{concurrency:5, total:3m8s, max:37.6s, probe:49.7ms, fetch:3m7.9s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.partsupp.ps_suppkey)]	1.54 MB	0 Bytes
20:39:08 [2021-06-06T20:39:08.441Z]   ├─HashJoin_48(Build)	20000.00	19972	root		time:1.22s, loops:24, build_hash_table:{total:132µs, fetch:126.8µs, build:5.26µs}, probe:{concurrency:5, total:6.12s, max:1.22s, probe:97.9ms, fetch:6.02s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:39:08 [2021-06-06T20:39:08.441Z]   │ ├─TableReader_53(Build)	1.00	1	root		time:35.6µs, loops:2, cop_task: {num: 1, max: 1.13ms, proc_keys: 25, rpc_num: 1, rpc_time: 1.12ms, copr_cache: disabled}	data:Selection_52	240 Bytes	N/A
20:39:08 [2021-06-06T20:39:08.441Z]   │ │ └─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:39:08 [2021-06-06T20:39:08.441Z]   │ │   └─TableFullScan_51	25.00	25	cop[tikv]	table:nation	tikv_task:{time:0s, loops:1}	keep order:false	N/A	N/A
20:39:08 [2021-06-06T20:39:08.441Z]   │ └─TableReader_50(Probe)	500000.00	500000	root		time:1.2s, loops:490, cop_task: {num: 1, max: 1.2s, proc_keys: 500000, tot_proc: 1.12s, rpc_num: 1, rpc_time: 1.2s, copr_cache: disabled}	data:TableFullScan_49	35.8 MB	N/A
20:39:08 [2021-06-06T20:39:08.441Z]   │   └─TableFullScan_49	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:946ms, 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:39:08 [2021-06-06T20:39:08.441Z]   └─HashAgg_54(Probe)	257492.04	223999	root		time:37.6s, loops:222, partial_worker:{wall_time:37.51336891s, concurrency:5, task_num:289, tot_wait:3m7.160220981s, tot_exec:259.799171ms, tot_time:3m7.551289228s, max:37.513115932s, p95:37.513115932s}, final_worker:{wall_time:37.591645337s, concurrency:5, task_num:25, tot_wait:3m7.542830531s, tot_exec:406.255508ms, tot_time:3m7.949101541s, max:37.591406893s, p95:37.591406893s}	group by:tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_suppkey)->tpch50.partsupp.ps_suppkey	61.4 MB	N/A
20:39:08 [2021-06-06T20:39:08.441Z]     └─Selection_55	257492.04	295898	root		time:37.5s, loops:290	gt(cast(tpch50.partsupp.ps_availqty, decimal(20,0) BINARY), mul(0.5, Column#44))	59.2 KB	N/A
20:39:08 [2021-06-06T20:39:08.441Z]       └─HashAgg_56	321865.05	435528	root		time:37.4s, loops:430, partial_worker:{wall_time:37.128165538s, concurrency:5, task_num:625, tot_wait:3m4.453449809s, tot_exec:1.061301779s, tot_time:3m5.628628007s, max:37.128085003s, p95:37.128085003s}, final_worker:{wall_time:37.4786002s, concurrency:5, task_num:25, tot_wait:3m5.606284546s, tot_exec:1.746469728s, tot_time:3m7.352769874s, max:37.478521173s, p95:37.478521173s}	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:39:08 [2021-06-06T20:39:08.441Z]         └─HashJoin_59	9711455.06	634004	root		time:37.1s, loops:626, build_hash_table:{total:2.45s, fetch:2.2s, build:249.8ms}, probe:{concurrency:5, total:3m5.3s, max:37.1s, probe:15.3s, fetch:2m50s}	left outer join, equal:[eq(tpch50.partsupp.ps_partkey, tpch50.lineitem.l_partkey) eq(tpch50.partsupp.ps_suppkey, tpch50.lineitem.l_suppkey)]	10.4 MB	0 Bytes
20:39:08 [2021-06-06T20:39:08.441Z]           ├─IndexHashJoin_67(Build)	321865.05	435528	root		time:2.38s, loops:430, inner:{total:2.98s, concurrency:5, task:12, construct:123.2ms, fetch:2.49s, build:27.6ms, join:367.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)	19.9 MB	N/A
20:39:08 [2021-06-06T20:39:08.441Z]           │ ├─TableReader_96(Build)	80007.93	108882	root		time:2.01s, loops:112, cop_task: {num: 20, max: 1.47s, min: 615.1ms, avg: 1.06s, p95: 1.47s, max_proc_keys: 686055, p95_proc_keys: 686055, tot_proc: 21.2s, tot_wait: 21ms, rpc_num: 20, rpc_time: 21.2s, copr_cache: disabled}	data:Selection_95	665.9 KB	N/A
20:39:08 [2021-06-06T20:39:08.441Z]           │ │ └─Selection_95	80007.93	108882	cop[tikv]		tikv_task:{proc max:1.43s, min:613ms, p80:1.22s, p95:1.43s, iters:9859, tasks:20}, scan_detail: {total_process_keys: 10000000, total_keys: 10000020, rocksdb: {delete_skipped_count: 0, key_skipped_count: 19999980, block: {cache_hit_count: 31499, read_count: 0, read_byte: 0 Bytes}}}	like(tpch50.part.p_name, "green%", 92)	N/A	N/A
20:39:08 [2021-06-06T20:39:08.441Z]           │ │   └─TableFullScan_94	10000000.00	10000000	cop[tikv]	table:part	tikv_task:{proc max:1.33s, min:559ms, p80:1.14s, p95:1.33s, iters:9859, tasks:20}	keep order:false	N/A	N/A
20:39:08 [2021-06-06T20:39:08.441Z]           │ └─IndexLookUp_64(Probe)	4.02	435528	root		time:2.37s, loops:447, index_task: {total_time: 1.35s, fetch_handle: 1.35s, build: 112.2µs, wait: 367.3µs}, table_task: {total_time: 9.02s, num: 55, concurrency: 60}		19.6 KB	N/A
20:39:08 [2021-06-06T20:39:08.441Z]           │   ├─IndexRangeScan_62(Build)	4.02	435528	cop[tikv]	table:partsupp, index:PRIMARY(PS_PARTKEY, PS_SUPPKEY)	time:1.31s, loops:479, cop_task: {num: 58, max: 245.6ms, min: 4.81ms, avg: 98.7ms, p95: 207.5ms, max_proc_keys: 15288, p95_proc_keys: 15008, tot_proc: 5.28s, tot_wait: 73ms, rpc_num: 58, rpc_time: 5.72s, copr_cache: disabled}, tikv_task:{proc max:225ms, min:4ms, p80:160ms, p95:194ms, iters:688, tasks:58}, scan_detail: {total_process_keys: 435528, total_keys: 544410, rocksdb: {delete_skipped_count: 0, key_skipped_count: 435528, block: {cache_hit_count: 980292, read_count: 0, read_byte: 0 Bytes}}}	range: decided by [eq(tpch50.partsupp.ps_partkey, tpch50.part.p_partkey)], keep order:false	N/A	N/A
20:39:08 [2021-06-06T20:39:08.441Z]           │   └─TableRowIDScan_63(Probe)	4.02	435528	cop[tikv]	table:partsupp	time:2.96s, loops:505, cop_task: {num: 1432, max: 105.1ms, min: 350.1µs, avg: 19.1ms, p95: 45.6ms, max_proc_keys: 1100, p95_proc_keys: 584, tot_proc: 20s, tot_wait: 5.03s, rpc_num: 1432, rpc_time: 27.3s, copr_cache: disabled}, tikv_task:{proc max:47ms, min:0s, p80:17ms, p95:24ms, iters:5299, tasks:1432}, scan_detail: {total_process_keys: 435528, total_keys: 473512, rocksdb: {delete_skipped_count: 0, key_skipped_count: 194114, block: {cache_hit_count: 3643953, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:39:08 [2021-06-06T20:39:08.441Z]           └─TableReader_101(Probe)	46310896.67	45504356	root		time:32.6s, loops:44289, cop_task: {num: 761, max: 1.18s, min: 408.6ms, avg: 688.5ms, p95: 851ms, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 8m40.7s, tot_wait: 138ms, rpc_num: 761, rpc_time: 8m43.9s, copr_cache: disabled}	data:Selection_100	52.6 MB	N/A
20:39:08 [2021-06-06T20:39:08.441Z]             └─Selection_100	46310896.67	45504356	cop[tikv]		tikv_task:{proc max:1.12s, min:398ms, p80:737ms, p95:833ms, iters:296606, tasks:761}, scan_detail: {total_process_keys: 300005811, total_keys: 300006572, rocksdb: {delete_skipped_count: 0, key_skipped_count: 600010861, block: {cache_hit_count: 1124648, read_count: 0, read_byte: 0 Bytes}}}	ge(tpch50.lineitem.l_shipdate, 1993-01-01 00:00:00.000000), lt(tpch50.lineitem.l_shipdate, 1994-01-01)	N/A	N/A
20:39:08 [2021-06-06T20:39:08.441Z]               └─TableFullScan_99	300005811.00	300005811	cop[tikv]	table:lineitem	tikv_task:{proc max:1.07s, min:380ms, p80:705ms, p95:802ms, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:39:08 [2021-06-06T20:39:08.441Z] 
20:39:08 [2021-06-06T20:39:08.441Z] queries/20.sql
20:39:08 [2021-06-06T20:39:08.441Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:39:08 [2021-06-06T20:39:08.441Z] Sort_30	20000.00	8982	root		time:37.5s, loops:10	tpch50.supplier.s_name	620.9 KB	0 Bytes
20:39:08 [2021-06-06T20:39:08.441Z] └─HashJoin_35	20000.00	8982	root		time:37.5s, loops:11, build_hash_table:{total:1.34s, fetch:1.33s, build:10.3ms}, probe:{concurrency:5, total:3m7.3s, max:37.5s, probe:47ms, fetch:3m7.3s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.partsupp.ps_suppkey)]	1.48 MB	0 Bytes
20:39:08 [2021-06-06T20:39:08.441Z]   ├─HashJoin_48(Build)	20000.00	19972	root		time:1.33s, loops:22, build_hash_table:{total:163.5µs, fetch:157.4µs, build:6.06µs}, probe:{concurrency:5, total:6.69s, max:1.34s, probe:101ms, fetch:6.58s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:39:08 [2021-06-06T20:39:08.441Z]   │ ├─TableReader_53(Build)	1.00	1	root		time:34.8µs, loops:2, cop_task: {num: 1, max: 2.14ms, proc_keys: 25, tot_proc: 2ms, rpc_num: 1, rpc_time: 2.11ms, copr_cache: disabled}	data:Selection_52	244 Bytes	N/A
20:39:08 [2021-06-06T20:39:08.441Z]   │ │ └─Selection_52	1.00	1	cop[tikv]		tikv_task:{time:2ms, loops:1}, scan_detail: {total_process_keys: 25, total_keys: 26, rocksdb: {delete_skipped_count: 0, key_skipped_count: 46, block: {cache_hit_count: 18, read_count: 0, read_byte: 0 Bytes}}}	eq(tpch50.nation.n_name, "ALGERIA")	N/A	N/A
20:39:08 [2021-06-06T20:39:08.441Z]   │ │   └─TableFullScan_51	25.00	25	cop[tikv]	table:nation	tikv_task:{time:2ms, loops:1}	keep order:false	N/A	N/A
20:39:08 [2021-06-06T20:39:08.441Z]   │ └─TableReader_50(Probe)	500000.00	500000	root		time:1.32s, loops:490, cop_task: {num: 1, max: 1.32s, proc_keys: 500000, tot_proc: 1.23s, rpc_num: 1, rpc_time: 1.32s, copr_cache: disabled}	data:TableFullScan_49	35.8 MB	N/A
20:39:08 [2021-06-06T20:39:08.441Z]   │   └─TableFullScan_49	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:1.08s, 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:39:08 [2021-06-06T20:39:08.442Z]   └─HashAgg_54(Probe)	257492.04	223999	root		time:37.5s, loops:222, partial_worker:{wall_time:37.398520527s, concurrency:5, task_num:289, tot_wait:3m6.671381631s, tot_exec:280.954018ms, tot_time:3m6.989922551s, max:37.398490952s, p95:37.398490952s}, final_worker:{wall_time:37.465545683s, concurrency:5, task_num:25, tot_wait:3m6.987416113s, tot_exec:331.036269ms, tot_time:3m7.318483106s, max:37.465502291s, p95:37.465502291s}	group by:tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_suppkey)->tpch50.partsupp.ps_suppkey	61.4 MB	N/A
20:39:08 [2021-06-06T20:39:08.442Z]     └─Selection_55	257492.04	295898	root		time:37.4s, loops:290	gt(cast(tpch50.partsupp.ps_availqty, decimal(20,0) BINARY), mul(0.5, Column#44))	59.2 KB	N/A
20:39:08 [2021-06-06T20:39:08.442Z]       └─HashAgg_56	321865.05	435528	root		time:37.3s, loops:430, partial_worker:{wall_time:37.046163186s, concurrency:5, task_num:625, tot_wait:3m3.871964304s, tot_exec:1.104918512s, tot_time:3m5.168331641s, max:37.046052852s, p95:37.046052852s}, final_worker:{wall_time:37.389370857s, concurrency:5, task_num:25, tot_wait:3m5.05380376s, tot_exec:1.868506243s, tot_time:3m6.922327519s, max:37.389263979s, p95:37.389263979s}	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:39:08 [2021-06-06T20:39:08.442Z]         └─HashJoin_59	9711455.06	634004	root		time:36.9s, loops:626, build_hash_table:{total:2.52s, fetch:2.31s, build:209.2ms}, probe:{concurrency:5, total:3m4.7s, max:36.9s, probe:15.2s, fetch:2m49.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:39:08 [2021-06-06T20:39:08.442Z]           ├─IndexHashJoin_67(Build)	321865.05	435528	root		time:2.5s, loops:430, inner:{total:2.48s, concurrency:5, task:12, construct:132.7ms, fetch:2.02s, build:27.8ms, join:323.6ms}	inner join, inner:IndexLookUp_64, outer key:tpch50.part.p_partkey, inner key:tpch50.partsupp.ps_partkey, equal cond:eq(tpch50.part.p_partkey, tpch50.partsupp.ps_partkey)	19.9 MB	N/A
20:39:08 [2021-06-06T20:39:08.442Z]           │ ├─TableReader_96(Build)	80007.93	108882	root		time:2.12s, loops:112, cop_task: {num: 20, max: 1.45s, min: 725.7ms, avg: 1.07s, p95: 1.45s, max_proc_keys: 686055, p95_proc_keys: 686055, tot_proc: 21.3s, tot_wait: 8ms, rpc_num: 20, rpc_time: 21.4s, copr_cache: disabled}	data:Selection_95	725.8 KB	N/A
20:39:08 [2021-06-06T20:39:08.442Z]           │ │ └─Selection_95	80007.93	108882	cop[tikv]		tikv_task:{proc max:1.43s, min:716ms, p80:1.2s, p95:1.43s, iters:9859, tasks:20}, scan_detail: {total_process_keys: 10000000, total_keys: 10000020, rocksdb: {delete_skipped_count: 0, key_skipped_count: 19999980, block: {cache_hit_count: 31499, read_count: 0, read_byte: 0 Bytes}}}	like(tpch50.part.p_name, "green%", 92)	N/A	N/A
20:39:08 [2021-06-06T20:39:08.442Z]           │ │   └─TableFullScan_94	10000000.00	10000000	cop[tikv]	table:part	tikv_task:{proc max:1.32s, min:684ms, p80:1.11s, p95:1.32s, iters:9859, tasks:20}	keep order:false	N/A	N/A
20:39:08 [2021-06-06T20:39:08.442Z]           │ └─IndexLookUp_64(Probe)	4.02	435528	root		time:1.91s, loops:447, index_task: {total_time: 1.07s, fetch_handle: 1.06s, build: 97.6µs, wait: 272µs}, table_task: {total_time: 7.54s, num: 57, concurrency: 60}		19.4 KB	N/A
20:39:08 [2021-06-06T20:39:08.442Z]           │   ├─IndexRangeScan_62(Build)	4.02	435528	cop[tikv]	table:partsupp, index:PRIMARY(PS_PARTKEY, PS_SUPPKEY)	time:1.03s, loops:483, cop_task: {num: 58, max: 207.8ms, min: 4.8ms, avg: 89.7ms, p95: 172.1ms, max_proc_keys: 15288, p95_proc_keys: 15008, tot_proc: 4.64s, tot_wait: 221ms, rpc_num: 58, rpc_time: 5.2s, copr_cache: disabled}, tikv_task:{proc max:174ms, min:3ms, p80:133ms, p95:160ms, iters:688, tasks:58}, scan_detail: {total_process_keys: 435528, total_keys: 544410, rocksdb: {delete_skipped_count: 0, key_skipped_count: 435528, block: {cache_hit_count: 980292, read_count: 0, read_byte: 0 Bytes}}}	range: decided by [eq(tpch50.partsupp.ps_partkey, tpch50.part.p_partkey)], keep order:false	N/A	N/A
20:39:08 [2021-06-06T20:39:08.442Z]           │   └─TableRowIDScan_63(Probe)	4.02	435528	cop[tikv]	table:partsupp	time:2.72s, loops:506, cop_task: {num: 1487, max: 80.7ms, min: 517.7µs, avg: 18.2ms, p95: 38.4ms, max_proc_keys: 892, p95_proc_keys: 516, tot_proc: 20.1s, tot_wait: 5.13s, rpc_num: 1487, rpc_time: 27.1s, copr_cache: disabled}, tikv_task:{proc max:42ms, min:0s, p80:17ms, p95:23ms, iters:5461, tasks:1487}, scan_detail: {total_process_keys: 435528, total_keys: 473497, rocksdb: {delete_skipped_count: 0, key_skipped_count: 194019, block: {cache_hit_count: 3644450, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:39:08 [2021-06-06T20:39:08.442Z]           └─TableReader_101(Probe)	46310896.67	45504356	root		time:32.3s, loops:44289, cop_task: {num: 761, max: 1.21s, min: 324.9ms, avg: 684.2ms, p95: 848.1ms, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 8m37.4s, tot_wait: 111ms, rpc_num: 761, rpc_time: 8m40.7s, copr_cache: disabled}	data:Selection_100	52.6 MB	N/A
20:39:08 [2021-06-06T20:39:08.442Z]             └─Selection_100	46310896.67	45504356	cop[tikv]		tikv_task:{proc max:1.16s, min:317ms, p80:727ms, p95:830ms, iters:296606, tasks:761}, scan_detail: {total_process_keys: 300005811, total_keys: 300006572, rocksdb: {delete_skipped_count: 0, key_skipped_count: 600010861, block: {cache_hit_count: 1124648, read_count: 0, read_byte: 0 Bytes}}}	ge(tpch50.lineitem.l_shipdate, 1993-01-01 00:00:00.000000), lt(tpch50.lineitem.l_shipdate, 1994-01-01)	N/A	N/A
20:39:08 [2021-06-06T20:39:08.442Z]               └─TableFullScan_99	300005811.00	300005811	cop[tikv]	table:lineitem	tikv_task:{proc max:1.1s, min:300ms, p80:697ms, p95:793ms, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:39:08 [2021-06-06T20:39:08.442Z] + sync
20:39:08 [2021-06-06T20:39:08.442Z] + /usr/bin/echo 3
20:39:47 [2021-06-06T20:39:47.196Z] + sync
20:39:47 [2021-06-06T20:39:47.196Z] + /usr/bin/echo 3
20:40:25 [2021-06-06T20:40:25.841Z] 
20:40:25 [2021-06-06T20:40:25.841Z] queries/20.sql
20:40:25 [2021-06-06T20:40:25.841Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:40:25 [2021-06-06T20:40:25.841Z] Sort_30	20000.00	8982	root		time:37.1s, loops:10	tpch50.supplier.s_name	614.3 KB	0 Bytes
20:40:25 [2021-06-06T20:40:25.841Z] └─HashJoin_35	20000.00	8982	root		time:37.1s, loops:11, build_hash_table:{total:1.3s, fetch:1.29s, build:11.4ms}, probe:{concurrency:5, total:3m5.4s, max:37.1s, probe:48.6ms, fetch:3m5.3s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.partsupp.ps_suppkey)]	1.49 MB	0 Bytes
20:40:25 [2021-06-06T20:40:25.842Z]   ├─HashJoin_48(Build)	20000.00	19972	root		time:1.3s, loops:23, build_hash_table:{total:130.4µs, fetch:125.1µs, build:5.3µs}, probe:{concurrency:5, total:6.5s, max:1.3s, probe:123.8ms, fetch:6.38s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:40:25 [2021-06-06T20:40:25.842Z]   │ ├─TableReader_53(Build)	1.00	1	root		time:38.6µs, loops:2, cop_task: {num: 1, max: 913.4µs, proc_keys: 25, rpc_num: 1, rpc_time: 892.2µs, copr_cache: disabled}	data:Selection_52	236 Bytes	N/A
20:40:25 [2021-06-06T20:40:25.842Z]   │ │ └─Selection_52	1.00	1	cop[tikv]		tikv_task:{time:0s, loops:1}, scan_detail: {total_process_keys: 25, total_keys: 26, rocksdb: {delete_skipped_count: 0, key_skipped_count: 46, block: {cache_hit_count: 18, read_count: 0, read_byte: 0 Bytes}}}	eq(tpch50.nation.n_name, "ALGERIA")	N/A	N/A
20:40:25 [2021-06-06T20:40:25.842Z]   │ │   └─TableFullScan_51	25.00	25	cop[tikv]	table:nation	tikv_task:{time:0s, loops:1}	keep order:false	N/A	N/A
20:40:25 [2021-06-06T20:40:25.842Z]   │ └─TableReader_50(Probe)	500000.00	500000	root		time:1.27s, loops:490, cop_task: {num: 1, max: 1.27s, proc_keys: 500000, tot_proc: 1.2s, rpc_num: 1, rpc_time: 1.27s, copr_cache: disabled}	data:TableFullScan_49	35.8 MB	N/A
20:40:25 [2021-06-06T20:40:25.842Z]   │   └─TableFullScan_49	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:1.07s, loops:493}, scan_detail: {total_process_keys: 500000, total_keys: 500001, rocksdb: {delete_skipped_count: 0, key_skipped_count: 999999, block: {cache_hit_count: 1692, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:40:25 [2021-06-06T20:40:25.842Z]   └─HashAgg_54(Probe)	257492.04	223999	root		time:37.1s, loops:222, partial_worker:{wall_time:37.01172025s, concurrency:5, task_num:289, tot_wait:3m4.776853333s, tot_exec:219.572989ms, tot_time:3m5.039713952s, max:37.011639472s, p95:37.011639472s}, final_worker:{wall_time:37.07286887s, concurrency:5, task_num:25, tot_wait:3m5.021691768s, tot_exec:332.307715ms, tot_time:3m5.35401136s, max:37.072713994s, p95:37.072713994s}	group by:tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_suppkey)->tpch50.partsupp.ps_suppkey	61.4 MB	N/A
20:40:25 [2021-06-06T20:40:25.842Z]     └─Selection_55	257492.04	295898	root		time:37s, loops:290	gt(cast(tpch50.partsupp.ps_availqty, decimal(20,0) BINARY), mul(0.5, Column#44))	59.2 KB	N/A
20:40:25 [2021-06-06T20:40:25.842Z]       └─HashAgg_56	321865.05	435528	root		time:36.9s, loops:430, partial_worker:{wall_time:36.648820045s, concurrency:5, task_num:625, tot_wait:3m1.90444921s, tot_exec:1.204306593s, tot_time:3m3.224979964s, max:36.648605113s, p95:36.648605113s}, final_worker:{wall_time:36.99590241s, concurrency:5, task_num:25, tot_wait:3m3.210477697s, tot_exec:1.732904949s, tot_time:3m4.943399447s, max:36.995702758s, p95:36.995702758s}	group by:tpch50.partsupp.ps_partkey, tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_suppkey)->tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_availqty)->tpch50.partsupp.ps_availqty, funcs:sum(tpch50.lineitem.l_quantity)->Column#44	194.5 MB	N/A
20:40:25 [2021-06-06T20:40:25.842Z]         └─HashJoin_59	9711455.06	634004	root		time:36.5s, loops:626, build_hash_table:{total:2.44s, fetch:2.21s, build:233.7ms}, probe:{concurrency:5, total:3m2.7s, max:36.5s, probe:15.2s, fetch:2m47.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:40:25 [2021-06-06T20:40:25.842Z]           ├─IndexHashJoin_67(Build)	321865.05	435528	root		time:2.4s, loops:429, inner:{total:2.9s, concurrency:5, task:12, construct:134.3ms, fetch:2.42s, build:32.5ms, join:349.7ms}	inner join, inner:IndexLookUp_64, outer key:tpch50.part.p_partkey, inner key:tpch50.partsupp.ps_partkey, equal cond:eq(tpch50.part.p_partkey, tpch50.partsupp.ps_partkey)	19.9 MB	N/A
20:40:25 [2021-06-06T20:40:25.842Z]           │ ├─TableReader_96(Build)	80007.93	108882	root		time:2.03s, loops:112, cop_task: {num: 20, max: 1.42s, min: 502.1ms, avg: 1.07s, p95: 1.42s, max_proc_keys: 686055, p95_proc_keys: 686055, tot_proc: 21.3s, tot_wait: 29ms, rpc_num: 20, rpc_time: 21.4s, copr_cache: disabled}	data:Selection_95	725.8 KB	N/A
20:40:25 [2021-06-06T20:40:25.842Z]           │ │ └─Selection_95	80007.93	108882	cop[tikv]		tikv_task:{proc max:1.41s, min:500ms, p80:1.27s, p95:1.41s, iters:9859, tasks:20}, scan_detail: {total_process_keys: 10000000, total_keys: 10000020, rocksdb: {delete_skipped_count: 0, key_skipped_count: 19999980, block: {cache_hit_count: 31499, read_count: 0, read_byte: 0 Bytes}}}	like(tpch50.part.p_name, "green%", 92)	N/A	N/A
20:40:25 [2021-06-06T20:40:25.842Z]           │ │   └─TableFullScan_94	10000000.00	10000000	cop[tikv]	table:part	tikv_task:{proc max:1.31s, min:451ms, p80:1.19s, p95:1.31s, iters:9859, tasks:20}	keep order:false	N/A	N/A
20:40:25 [2021-06-06T20:40:25.842Z]           │ └─IndexLookUp_64(Probe)	4.02	435528	root		time:2.31s, loops:447, index_task: {total_time: 1.28s, fetch_handle: 1.28s, build: 100.5µs, wait: 291.9µs}, table_task: {total_time: 8.4s, num: 56, concurrency: 60}		20.7 KB	N/A
20:40:25 [2021-06-06T20:40:25.842Z]           │   ├─IndexRangeScan_62(Build)	4.02	435528	cop[tikv]	table:partsupp, index:PRIMARY(PS_PARTKEY, PS_SUPPKEY)	time:1.23s, loops:478, cop_task: {num: 59, max: 263.8ms, min: 5.47ms, avg: 91.9ms, p95: 179.3ms, max_proc_keys: 15288, p95_proc_keys: 15008, tot_proc: 4.94s, tot_wait: 63ms, rpc_num: 59, rpc_time: 5.42s, copr_cache: disabled}, tikv_task:{proc max:255ms, min:5ms, p80:140ms, p95:169ms, iters:692, tasks:59}, scan_detail: {total_process_keys: 435528, total_keys: 544410, rocksdb: {delete_skipped_count: 0, key_skipped_count: 435528, block: {cache_hit_count: 980292, read_count: 0, read_byte: 0 Bytes}}}	range: decided by [eq(tpch50.partsupp.ps_partkey, tpch50.part.p_partkey)], keep order:false	N/A	N/A
20:40:25 [2021-06-06T20:40:25.842Z]           │   └─TableRowIDScan_63(Probe)	4.02	435528	cop[tikv]	table:partsupp	time:2.85s, loops:506, cop_task: {num: 1448, max: 91.1ms, min: 455.2µs, avg: 18.7ms, p95: 41.7ms, max_proc_keys: 972, p95_proc_keys: 548, tot_proc: 20s, tot_wait: 5.35s, rpc_num: 1448, rpc_time: 27.1s, copr_cache: disabled}, tikv_task:{proc max:48ms, min:0s, p80:17ms, p95:24ms, iters:5351, tasks:1448}, scan_detail: {total_process_keys: 435528, total_keys: 473504, rocksdb: {delete_skipped_count: 0, key_skipped_count: 194068, block: {cache_hit_count: 3644185, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:40:25 [2021-06-06T20:40:25.842Z]           └─TableReader_101(Probe)	46310896.67	45504356	root		time:32s, loops:44290, cop_task: {num: 761, max: 1.17s, min: 377.9ms, avg: 682.1ms, p95: 834.7ms, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 8m35.9s, tot_wait: 120ms, rpc_num: 761, rpc_time: 8m39.1s, copr_cache: disabled}	data:Selection_100	52.6 MB	N/A
20:40:25 [2021-06-06T20:40:25.842Z]             └─Selection_100	46310896.67	45504356	cop[tikv]		tikv_task:{proc max:1.15s, min:365ms, p80:723ms, p95:817ms, iters:296606, tasks:761}, scan_detail: {total_process_keys: 300005811, total_keys: 300006572, rocksdb: {delete_skipped_count: 0, key_skipped_count: 600010861, block: {cache_hit_count: 1124648, read_count: 0, read_byte: 0 Bytes}}}	ge(tpch50.lineitem.l_shipdate, 1993-01-01 00:00:00.000000), lt(tpch50.lineitem.l_shipdate, 1994-01-01)	N/A	N/A
20:40:25 [2021-06-06T20:40:25.842Z]               └─TableFullScan_99	300005811.00	300005811	cop[tikv]	table:lineitem	tikv_task:{proc max:1.09s, min:349ms, p80:693ms, p95:782ms, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:40:25 [2021-06-06T20:40:25.842Z] 
20:40:25 [2021-06-06T20:40:25.842Z] queries/20.sql
20:40:25 [2021-06-06T20:40:25.842Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:40:25 [2021-06-06T20:40:25.842Z] Sort_30	20000.00	8982	root		time:37.8s, loops:10	tpch50.supplier.s_name	616.9 KB	0 Bytes
20:40:25 [2021-06-06T20:40:25.842Z] └─HashJoin_35	20000.00	8982	root		time:37.8s, loops:11, build_hash_table:{total:1.42s, fetch:1.41s, build:9.67ms}, probe:{concurrency:5, total:3m9.1s, max:37.8s, probe:47.4ms, fetch:3m9.1s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.partsupp.ps_suppkey)]	1.51 MB	0 Bytes
20:40:25 [2021-06-06T20:40:25.842Z]   ├─HashJoin_48(Build)	20000.00	19972	root		time:1.41s, loops:23, build_hash_table:{total:206.5µs, fetch:199.4µs, build:7.1µs}, probe:{concurrency:5, total:7.07s, max:1.41s, probe:115.2ms, fetch:6.96s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:40:25 [2021-06-06T20:40:25.842Z]   │ ├─TableReader_53(Build)	1.00	1	root		time:43.8µs, loops:2, cop_task: {num: 1, max: 998.1µs, proc_keys: 25, tot_proc: 1ms, rpc_num: 1, rpc_time: 983.8µs, copr_cache: disabled}	data:Selection_52	244 Bytes	N/A
20:40:25 [2021-06-06T20:40:25.842Z]   │ │ └─Selection_52	1.00	1	cop[tikv]		tikv_task:{time:1ms, loops:1}, scan_detail: {total_process_keys: 25, total_keys: 26, rocksdb: {delete_skipped_count: 0, key_skipped_count: 46, block: {cache_hit_count: 18, read_count: 0, read_byte: 0 Bytes}}}	eq(tpch50.nation.n_name, "ALGERIA")	N/A	N/A
20:40:25 [2021-06-06T20:40:25.842Z]   │ │   └─TableFullScan_51	25.00	25	cop[tikv]	table:nation	tikv_task:{time:1ms, loops:1}	keep order:false	N/A	N/A
20:40:25 [2021-06-06T20:40:25.842Z]   │ └─TableReader_50(Probe)	500000.00	500000	root		time:1.39s, loops:490, cop_task: {num: 1, max: 1.39s, proc_keys: 500000, tot_proc: 1.32s, rpc_num: 1, rpc_time: 1.39s, copr_cache: disabled}	data:TableFullScan_49	35.8 MB	N/A
20:40:25 [2021-06-06T20:40:25.842Z]   │   └─TableFullScan_49	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:1.17s, loops:493}, scan_detail: {total_process_keys: 500000, total_keys: 500001, rocksdb: {delete_skipped_count: 0, key_skipped_count: 999999, block: {cache_hit_count: 1692, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:40:25 [2021-06-06T20:40:25.842Z]   └─HashAgg_54(Probe)	257492.04	223999	root		time:37.8s, loops:222, partial_worker:{wall_time:37.754880229s, concurrency:5, task_num:289, tot_wait:3m8.528815167s, tot_exec:199.442363ms, tot_time:3m8.766287373s, max:37.754476173s, p95:37.754476173s}, final_worker:{wall_time:37.829096873s, concurrency:5, task_num:25, tot_wait:3m8.76420518s, tot_exec:335.858556ms, tot_time:3m9.1000761s, max:37.828693514s, p95:37.828693514s}	group by:tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_suppkey)->tpch50.partsupp.ps_suppkey	61.4 MB	N/A
20:40:25 [2021-06-06T20:40:25.842Z]     └─Selection_55	257492.04	295898	root		time:37.7s, loops:290	gt(cast(tpch50.partsupp.ps_availqty, decimal(20,0) BINARY), mul(0.5, Column#44))	59.2 KB	N/A
20:40:25 [2021-06-06T20:40:25.842Z]       └─HashAgg_56	321865.05	435528	root		time:37.6s, loops:430, partial_worker:{wall_time:37.417968152s, concurrency:5, task_num:626, tot_wait:3m5.689204079s, tot_exec:1.238363437s, tot_time:3m7.049890307s, max:37.41784486s, p95:37.41784486s}, final_worker:{wall_time:37.744596163s, concurrency:5, task_num:25, tot_wait:3m7.009848545s, tot_exec:1.647961898s, tot_time:3m8.657825772s, max:37.744479405s, p95:37.744479405s}	group by:tpch50.partsupp.ps_partkey, tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_suppkey)->tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_availqty)->tpch50.partsupp.ps_availqty, funcs:sum(tpch50.lineitem.l_quantity)->Column#44	194.5 MB	N/A
20:40:25 [2021-06-06T20:40:25.842Z]         └─HashJoin_59	9711455.06	634004	root		time:37.3s, loops:627, build_hash_table:{total:2.53s, fetch:2.32s, build:215.8ms}, probe:{concurrency:5, total:3m6.6s, max:37.3s, probe:15.3s, fetch:2m51.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:40:25 [2021-06-06T20:40:25.842Z]           ├─IndexHashJoin_67(Build)	321865.05	435528	root		time:2.48s, loops:430, inner:{total:2.6s, concurrency:5, task:12, construct:123.2ms, fetch:2.15s, build:27.8ms, join:325.2ms}	inner join, inner:IndexLookUp_64, outer key:tpch50.part.p_partkey, inner key:tpch50.partsupp.ps_partkey, equal cond:eq(tpch50.part.p_partkey, tpch50.partsupp.ps_partkey)	19.9 MB	N/A
20:40:25 [2021-06-06T20:40:25.842Z]           │ ├─TableReader_96(Build)	80007.93	108882	root		time:2.14s, loops:112, cop_task: {num: 20, max: 1.44s, min: 581.7ms, avg: 1.08s, p95: 1.44s, max_proc_keys: 686055, p95_proc_keys: 686055, tot_proc: 21.6s, tot_wait: 3ms, rpc_num: 20, rpc_time: 21.7s, copr_cache: disabled}	data:Selection_95	725.8 KB	N/A
20:40:25 [2021-06-06T20:40:25.842Z]           │ │ └─Selection_95	80007.93	108882	cop[tikv]		tikv_task:{proc max:1.37s, min:579ms, p80:1.26s, 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:40:25 [2021-06-06T20:40:25.842Z]           │ │   └─TableFullScan_94	10000000.00	10000000	cop[tikv]	table:part	tikv_task:{proc max:1.28s, min:533ms, p80:1.17s, p95:1.28s, iters:9859, tasks:20}	keep order:false	N/A	N/A
20:40:25 [2021-06-06T20:40:25.842Z]           │ └─IndexLookUp_64(Probe)	4.02	435528	root		time:2.04s, loops:447, index_task: {total_time: 1.07s, fetch_handle: 1.07s, build: 97.6µs, wait: 267µs}, table_task: {total_time: 7.83s, num: 57, concurrency: 60}		19.4 KB	N/A
20:40:25 [2021-06-06T20:40:25.842Z]           │   ├─IndexRangeScan_62(Build)	4.02	435528	cop[tikv]	table:partsupp, index:PRIMARY(PS_PARTKEY, PS_SUPPKEY)	time:1.03s, loops:487, cop_task: {num: 60, max: 177.7ms, min: 3.78ms, avg: 85.9ms, p95: 161.3ms, max_proc_keys: 15288, p95_proc_keys: 15008, tot_proc: 4.72s, tot_wait: 48ms, rpc_num: 60, rpc_time: 5.16s, copr_cache: disabled}, tikv_task:{proc max:160ms, min:3ms, p80:130ms, p95:144ms, iters:698, tasks:60}, scan_detail: {total_process_keys: 435528, total_keys: 544410, rocksdb: {delete_skipped_count: 0, key_skipped_count: 435528, block: {cache_hit_count: 980292, read_count: 0, read_byte: 0 Bytes}}}	range: decided by [eq(tpch50.partsupp.ps_partkey, tpch50.part.p_partkey)], keep order:false	N/A	N/A
20:40:25 [2021-06-06T20:40:25.842Z]           │   └─TableRowIDScan_63(Probe)	4.02	435528	cop[tikv]	table:partsupp	time:2.88s, loops:508, cop_task: {num: 1434, max: 96.4ms, min: 457.4µs, avg: 19.7ms, p95: 40.2ms, max_proc_keys: 1008, p95_proc_keys: 592, tot_proc: 20s, tot_wait: 5.77s, rpc_num: 1434, rpc_time: 28.3s, copr_cache: disabled}, tikv_task:{proc max:50ms, min:0s, p80:17ms, p95:24ms, iters:5318, tasks:1434}, scan_detail: {total_process_keys: 435528, total_keys: 473507, rocksdb: {delete_skipped_count: 0, key_skipped_count: 194059, block: {cache_hit_count: 3644169, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:40:25 [2021-06-06T20:40:25.842Z]           └─TableReader_101(Probe)	46310896.67	45504356	root		time:32.7s, loops:44290, cop_task: {num: 761, max: 1.14s, min: 339.6ms, avg: 693.3ms, p95: 845.3ms, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 8m44.3s, tot_wait: 146ms, rpc_num: 761, rpc_time: 8m47.6s, copr_cache: disabled}	data:Selection_100	52.6 MB	N/A
20:40:25 [2021-06-06T20:40:25.842Z]             └─Selection_100	46310896.67	45504356	cop[tikv]		tikv_task:{proc max:1.11s, min:331ms, p80:733ms, p95:826ms, iters:296606, tasks:761}, scan_detail: {total_process_keys: 300005811, total_keys: 300006572, rocksdb: {delete_skipped_count: 0, key_skipped_count: 600010861, block: {cache_hit_count: 1124648, read_count: 0, read_byte: 0 Bytes}}}	ge(tpch50.lineitem.l_shipdate, 1993-01-01 00:00:00.000000), lt(tpch50.lineitem.l_shipdate, 1994-01-01)	N/A	N/A
20:40:25 [2021-06-06T20:40:25.843Z]               └─TableFullScan_99	300005811.00	300005811	cop[tikv]	table:lineitem	tikv_task:{proc max:1.07s, min:308ms, p80:703ms, p95:794ms, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:40:25 [2021-06-06T20:40:25.843Z] + sync
20:40:25 [2021-06-06T20:40:25.843Z] + /usr/bin/echo 3
20:41:12 [2021-06-06T20:41:12.445Z] + tiup cluster stop benchbot -y
20:41:12 [2021-06-06T20:41:12.445Z] Starting component `cluster`: /home/tidb/.tiup/components/cluster/v1.4.4/tiup-cluster stop benchbot -y
20:41:22 [2021-06-06T20:41:22.375Z] + rm -rf '/data1/tidb-deploy/*/log/*'
20:41:22 [2021-06-06T20:41:22.375Z] + rm -rf /data1/jenkins/deploy/data/tikv-20160
20:41:24 [2021-06-06T20:41:24.315Z] + rm -rf /data1/jenkins/deploy/data/pd-2379
20:41:24 [2021-06-06T20:41:24.315Z] + rm -rf /data1/jenkins/restore_data/tpch50/data/last_tikv.toml
20:41:24 [2021-06-06T20:41:24.315Z] + cp -R /data1/jenkins/restore_data/tpch50/data /data1/jenkins/deploy/data/tikv-20160
20:43:15 [2021-06-06T20:43:15.671Z] + cp -R /data1/jenkins/restore_data/tpch50/data.pd /data1/jenkins/deploy/data/pd-2379
20:43:15 [2021-06-06T20:43:15.671Z] + '[' -n '' ']'
20:43:15 [2021-06-06T20:43:15.671Z] + tiup cluster start benchbot --wait-timeout=300
20:43:15 [2021-06-06T20:43:15.671Z] Starting component `cluster`: /home/tidb/.tiup/components/cluster/v1.4.4/tiup-cluster start benchbot --wait-timeout=300
20:43:42 [2021-06-06T20:43:42.153Z] + sync
20:43:42 [2021-06-06T20:43:42.153Z] + /usr/bin/echo 3
20:45:18 [2021-06-06T20:45:18.517Z] 
20:45:18 [2021-06-06T20:45:18.517Z] queries/20.sql
20:45:18 [2021-06-06T20:45:18.517Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:45:18 [2021-06-06T20:45:18.517Z] Sort_30	20000.00	8982	root		time:37.7s, loops:10	tpch50.supplier.s_name	607.7 KB	0 Bytes
20:45:18 [2021-06-06T20:45:18.517Z] └─HashJoin_35	20000.00	8982	root		time:37.6s, loops:11, build_hash_table:{total:1.45s, fetch:1.45s, build:8.87ms}, probe:{concurrency:5, total:3m8.2s, max:37.6s, probe:49ms, fetch:3m8.2s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.partsupp.ps_suppkey)]	1.48 MB	0 Bytes
20:45:18 [2021-06-06T20:45:18.517Z]   ├─HashJoin_48(Build)	20000.00	19972	root		time:1.45s, loops:22, build_hash_table:{total:128.1µs, fetch:122.9µs, build:5.22µs}, probe:{concurrency:5, total:7.26s, max:1.45s, probe:102.6ms, fetch:7.16s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:45:18 [2021-06-06T20:45:18.517Z]   │ ├─TableReader_53(Build)	1.00	1	root		time:31.8µs, loops:2, cop_task: {num: 1, max: 827.8µs, proc_keys: 25, rpc_num: 1, rpc_time: 814.8µs, copr_cache: disabled}	data:Selection_52	236 Bytes	N/A
20:45:18 [2021-06-06T20:45:18.517Z]   │ │ └─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:45:18 [2021-06-06T20:45:18.517Z]   │ │   └─TableFullScan_51	25.00	25	cop[tikv]	table:nation	tikv_task:{time:0s, loops:1}	keep order:false	N/A	N/A
20:45:18 [2021-06-06T20:45:18.517Z]   │ └─TableReader_50(Probe)	500000.00	500000	root		time:1.43s, loops:490, cop_task: {num: 1, max: 1.43s, proc_keys: 500000, tot_proc: 1.34s, rpc_num: 1, rpc_time: 1.43s, copr_cache: disabled}	data:TableFullScan_49	35.8 MB	N/A
20:45:18 [2021-06-06T20:45:18.517Z]   │   └─TableFullScan_49	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:1.2s, 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:45:18 [2021-06-06T20:45:18.517Z]   └─HashAgg_54(Probe)	257492.04	223999	root		time:37.6s, loops:222, partial_worker:{wall_time:37.53554507s, concurrency:5, task_num:289, tot_wait:3m7.43144607s, tot_exec:197.395165ms, tot_time:3m7.666379249s, max:37.535391805s, p95:37.535391805s}, final_worker:{wall_time:37.646391126s, concurrency:5, task_num:25, tot_wait:3m7.659535198s, tot_exec:558.315386ms, tot_time:3m8.217868845s, max:37.646294526s, p95:37.646294526s}	group by:tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_suppkey)->tpch50.partsupp.ps_suppkey	61.4 MB	N/A
20:45:18 [2021-06-06T20:45:18.517Z]     └─Selection_55	257492.04	295898	root		time:37.5s, loops:290	gt(cast(tpch50.partsupp.ps_availqty, decimal(20,0) BINARY), mul(0.5, Column#44))	59.2 KB	N/A
20:45:18 [2021-06-06T20:45:18.517Z]       └─HashAgg_56	321865.05	435528	root		time:37.4s, loops:430, partial_worker:{wall_time:37.188773244s, concurrency:5, task_num:625, tot_wait:3m4.695546542s, tot_exec:1.107906895s, tot_time:3m5.919887832s, max:37.188653645s, p95:37.188653645s}, final_worker:{wall_time:37.523912336s, concurrency:5, task_num:25, tot_wait:3m5.8778441s, tot_exec:1.691950241s, tot_time:3m7.569810743s, max:37.523609239s, p95:37.523609239s}	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:45:18 [2021-06-06T20:45:18.517Z]         └─HashJoin_59	9711455.06	634004	root		time:37.1s, loops:626, build_hash_table:{total:2.42s, fetch:2.19s, build:231.7ms}, probe:{concurrency:5, total:3m5.5s, max:37.1s, probe:15.2s, fetch:2m50.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:45:18 [2021-06-06T20:45:18.517Z]           ├─IndexHashJoin_67(Build)	321865.05	435528	root		time:2.36s, loops:430, inner:{total:2.76s, concurrency:5, task:12, construct:136.7ms, fetch:2.27s, build:27.5ms, join:352.5ms}	inner join, inner:IndexLookUp_64, outer key:tpch50.part.p_partkey, inner key:tpch50.partsupp.ps_partkey, equal cond:eq(tpch50.part.p_partkey, tpch50.partsupp.ps_partkey)	19.9 MB	N/A
20:45:18 [2021-06-06T20:45:18.517Z]           │ ├─TableReader_96(Build)	80007.93	108882	root		time:1.91s, loops:112, cop_task: {num: 20, max: 1.64s, min: 508.4ms, avg: 1.06s, p95: 1.64s, max_proc_keys: 686055, p95_proc_keys: 686055, tot_proc: 21.2s, tot_wait: 4ms, rpc_num: 20, rpc_time: 21.2s, copr_cache: disabled}	data:Selection_95	680.6 KB	N/A
20:45:18 [2021-06-06T20:45:18.517Z]           │ │ └─Selection_95	80007.93	108882	cop[tikv]		tikv_task:{proc max:1.62s, min:502ms, p80:1.28s, p95:1.62s, 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:45:18 [2021-06-06T20:45:18.517Z]           │ │   └─TableFullScan_94	10000000.00	10000000	cop[tikv]	table:part	tikv_task:{proc max:1.52s, min:464ms, p80:1.2s, p95:1.52s, iters:9859, tasks:20}	keep order:false	N/A	N/A
20:45:18 [2021-06-06T20:45:18.517Z]           │ └─IndexLookUp_64(Probe)	4.02	435528	root		time:2.14s, loops:447, index_task: {total_time: 1.28s, fetch_handle: 1.28s, build: 100.9µs, wait: 316.1µs}, table_task: {total_time: 8.25s, num: 56, concurrency: 60}		20.7 KB	N/A
20:45:18 [2021-06-06T20:45:18.517Z]           │   ├─IndexRangeScan_62(Build)	4.02	435528	cop[tikv]	table:partsupp, index:PRIMARY(PS_PARTKEY, PS_SUPPKEY)	time:1.24s, loops:484, cop_task: {num: 59, max: 332.8ms, min: 5.05ms, avg: 98.7ms, p95: 209.2ms, max_proc_keys: 15288, p95_proc_keys: 15008, tot_proc: 5.47s, tot_wait: 21ms, rpc_num: 59, rpc_time: 5.83s, copr_cache: disabled}, tikv_task:{proc max:318ms, min:3ms, p80:156ms, p95:203ms, 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:45:18 [2021-06-06T20:45:18.518Z]           │   └─TableRowIDScan_63(Probe)	4.02	435528	cop[tikv]	table:partsupp	time:2.63s, loops:504, cop_task: {num: 1447, max: 95ms, min: 492.4µs, avg: 18.7ms, p95: 42.9ms, max_proc_keys: 1028, p95_proc_keys: 588, tot_proc: 19.5s, tot_wait: 4.57s, rpc_num: 1447, rpc_time: 27.1s, copr_cache: disabled}, tikv_task:{proc max:48ms, min:0s, p80:17ms, p95:24ms, iters:5339, tasks:1447}, scan_detail: {total_process_keys: 435528, total_keys: 473494, rocksdb: {delete_skipped_count: 0, key_skipped_count: 194044, block: {cache_hit_count: 3644262, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:45:18 [2021-06-06T20:45:18.518Z]           └─TableReader_101(Probe)	46310896.67	45504356	root		time:32.6s, loops:44290, cop_task: {num: 761, max: 1.16s, min: 313.5ms, avg: 692.1ms, p95: 833.3ms, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 8m43.5s, tot_wait: 153ms, rpc_num: 761, rpc_time: 8m46.7s, copr_cache: disabled}	data:Selection_100	52.6 MB	N/A
20:45:18 [2021-06-06T20:45:18.518Z]             └─Selection_100	46310896.67	45504356	cop[tikv]		tikv_task:{proc max:1.12s, min:307ms, p80:740ms, p95:816ms, iters:296606, tasks:761}, scan_detail: {total_process_keys: 300005811, total_keys: 300006572, rocksdb: {delete_skipped_count: 0, key_skipped_count: 600010861, block: {cache_hit_count: 1124648, read_count: 0, read_byte: 0 Bytes}}}	ge(tpch50.lineitem.l_shipdate, 1993-01-01 00:00:00.000000), lt(tpch50.lineitem.l_shipdate, 1994-01-01)	N/A	N/A
20:45:18 [2021-06-06T20:45:18.518Z]               └─TableFullScan_99	300005811.00	300005811	cop[tikv]	table:lineitem	tikv_task:{proc max:1.07s, min:291ms, p80:709ms, p95:782ms, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:45:18 [2021-06-06T20:45:18.518Z] 
20:45:18 [2021-06-06T20:45:18.518Z] queries/21.sql
20:45:18 [2021-06-06T20:45:18.518Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:45:18 [2021-06-06T20:45:18.518Z] Projection_26	100.00	100	root		time:1m20.8s, loops:2, Concurrency:OFF	tpch50.supplier.s_name, Column#72	4.62 KB	N/A
20:45:18 [2021-06-06T20:45:18.518Z] └─TopN_29	100.00	100	root		time:1m20.8s, loops:2	Column#72:desc, tpch50.supplier.s_name, offset:0, count:100	58.4 KB	N/A
20:45:18 [2021-06-06T20:45:18.518Z]   └─HashAgg_34	12800.00	20057	root		time:1m20.8s, loops:21, partial_worker:{wall_time:1m20.822242036s, concurrency:5, task_num:197, tot_wait:6m43.826003963s, tot_exec:271.086622ms, tot_time:6m44.108533721s, max:1m20.822207521s, p95:1m20.822207521s}, final_worker:{wall_time:1m20.83466196s, concurrency:5, task_num:25, tot_wait:6m44.10720299s, tot_exec:65.127863ms, tot_time:6m44.172356454s, max:1m20.834630795s, p95:1m20.834630795s}	group by:tpch50.supplier.s_name, funcs:count(1)->Column#72, funcs:firstrow(tpch50.supplier.s_name)->tpch50.supplier.s_name	17.2 MB	N/A
20:45:18 [2021-06-06T20:45:18.518Z]     └─IndexHashJoin_42	7828961.66	198698	root		time:1m20.8s, loops:198, inner:{total:2m17.9s, concurrency:5, task:146, construct:6.45s, fetch:1m54.6s, build:1.13s, 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:45:18 [2021-06-06T20:45:18.518Z]       ├─IndexHashJoin_83(Build)	9786202.08	3542799	root		time:1m20.2s, loops:3464, inner:{total:2m26.8s, concurrency:5, task:152, construct:8.13s, fetch:2m0.5s, build:1.23s, join:18.2s}	semi join, inner:IndexLookUp_80, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey), ne(tpch50.lineitem.l_suppkey, tpch50.supplier.s_suppkey)	555.9 MB	N/A
20:45:18 [2021-06-06T20:45:18.518Z]       │ ├─IndexJoin_99(Build)	12232752.60	3675878	root		time:1m19.6s, loops:3595, inner:{total:2m7.9s, concurrency:5, task:305, construct:17s, fetch:1m49.1s, build:1.86s}, 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)	575.4 MB	N/A
20:45:18 [2021-06-06T20:45:18.518Z]       │ │ ├─HashJoin_107(Build)	12232752.60	7609895	root		time:1m19s, loops:7437, build_hash_table:{total:824.5ms, fetch:815.3ms, build:9.15ms}, probe:{concurrency:5, total:6m37.6s, max:1m19.5s, probe:1m4.1s, fetch:5m33.5s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.lineitem.l_suppkey)]	754.5 KB	0 Bytes
20:45:18 [2021-06-06T20:45:18.518Z]       │ │ │ ├─HashJoin_120(Build)	20000.00	20058	root		time:821.6ms, loops:23, build_hash_table:{total:327.1µs, fetch:155.5µs, build:171.6µs}, probe:{concurrency:5, total:4.11s, max:823.2ms, probe:82.3ms, fetch:4.03s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:45:18 [2021-06-06T20:45:18.518Z]       │ │ │ │ ├─TableReader_125(Build)	1.00	1	root		time:47.1µs, loops:2, cop_task: {num: 1, max: 765.6µs, proc_keys: 25, tot_proc: 1ms, rpc_num: 1, rpc_time: 754.3µs, copr_cache: disabled}	data:Selection_124	242 Bytes	N/A
20:45:18 [2021-06-06T20:45:18.518Z]       │ │ │ │ │ └─Selection_124	1.00	1	cop[tikv]		tikv_task:{time:1ms, loops:1}, scan_detail: {total_process_keys: 25, total_keys: 26, rocksdb: {delete_skipped_count: 0, key_skipped_count: 46, block: {cache_hit_count: 18, read_count: 0, read_byte: 0 Bytes}}}	eq(tpch50.nation.n_name, "EGYPT")	N/A	N/A
20:45:18 [2021-06-06T20:45:18.518Z]       │ │ │ │ │   └─TableFullScan_123	25.00	25	cop[tikv]	table:nation	tikv_task:{time:1ms, loops:1}	keep order:false	N/A	N/A
20:45:18 [2021-06-06T20:45:18.518Z]       │ │ │ │ └─TableReader_122(Probe)	500000.00	500000	root		time:805.9ms, loops:490, cop_task: {num: 1, max: 926.9ms, proc_keys: 500000, tot_proc: 894ms, rpc_num: 1, rpc_time: 926.9ms, copr_cache: disabled}	data:TableFullScan_121	20.0 MB	N/A
20:45:18 [2021-06-06T20:45:18.518Z]       │ │ │ │   └─TableFullScan_121	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:840ms, 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:45:18 [2021-06-06T20:45:18.518Z]       │ │ │ └─TableReader_128(Probe)	240004648.80	189670348	root		time:1m6.6s, loops:184597, cop_task: {num: 761, max: 2.71s, min: 296ms, avg: 1.53s, p95: 1.98s, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 18m12.9s, tot_wait: 56.8s, rpc_num: 761, rpc_time: 19m23.3s, copr_cache: disabled}	data:Selection_127	91.6 MB	N/A
20:45:18 [2021-06-06T20:45:18.518Z]       │ │ │   └─Selection_127	240004648.80	189670348	cop[tikv]		tikv_task:{proc max:1.36s, min:280ms, p80:1.21s, p95:1.25s, iters:296606, tasks:761}, scan_detail: {total_process_keys: 300005811, total_keys: 300006572, rocksdb: {delete_skipped_count: 0, key_skipped_count: 600010861, block: {cache_hit_count: 18668, read_count: 1131783, read_byte: 23.9 GB}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:45:18 [2021-06-06T20:45:18.518Z]       │ │ │     └─TableFullScan_126	300005811.00	300005811	cop[tikv]	table:l1	tikv_task:{proc max:1.27s, min:270ms, p80:1.12s, p95:1.17s, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:45:18 [2021-06-06T20:45:18.518Z]       │ │ └─TableReader_95(Probe)	0.49	3496180	root		time:1m39.6s, loops:3875, cop_task: {num: 5241, max: 605ms, min: 3.85ms, avg: 180.4ms, p95: 342.7ms, max_proc_keys: 3364, p95_proc_keys: 1959, tot_proc: 11m13.3s, tot_wait: 3m50.7s, rpc_num: 5241, rpc_time: 15m45.6s, copr_cache: disabled}	data:Selection_94	N/A	N/A
20:45:18 [2021-06-06T20:45:18.518Z]       │ │   └─Selection_94	0.49	3496180	cop[tikv]		tikv_task:{proc max:150ms, min:0s, p80:69ms, p95:83ms, iters:30203, tasks:5241}, scan_detail: {total_process_keys: 7236291, total_keys: 7795491, rocksdb: {delete_skipped_count: 0, key_skipped_count: 1778290, block: {cache_hit_count: 54006828, read_count: 220034, read_byte: 4.66 GB}}}	eq(tpch50.orders.o_orderstatus, "F")	N/A	N/A
20:45:18 [2021-06-06T20:45:18.518Z]       │ │     └─TableRangeScan_93	1.00	7236291	cop[tikv]	table:orders	tikv_task:{proc max:150ms, min:0s, p80:69ms, p95:82ms, iters:30203, tasks:5241}	range: decided by [tpch50.lineitem.l_orderkey], keep order:false	N/A	N/A
20:45:18 [2021-06-06T20:45:18.518Z]       │ └─IndexLookUp_80(Probe)	4.05	17316364	root		time:1m54.7s, loops:17130, index_task: {total_time: 1m4.6s, fetch_handle: 55s, build: 3.6ms, wait: 9.52s}, table_task: {total_time: 8m18.1s, num: 1458, concurrency: 760}		17.2 KB	N/A
20:45:18 [2021-06-06T20:45:18.518Z]       │   ├─IndexRangeScan_78(Build)	4.05	17316364	cop[tikv]	table:l2, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:52.9s, loops:18635, cop_task: {num: 2970, max: 733.2ms, min: 691.3µs, avg: 182.7ms, p95: 372.7ms, max_proc_keys: 13089, p95_proc_keys: 8834, tot_proc: 6m53.6s, tot_wait: 1m47.9s, rpc_num: 2970, rpc_time: 9m2.5s, copr_cache: disabled}, tikv_task:{proc max:181ms, min:0s, p80:98ms, p95:115ms, iters:30038, tasks:2970}, scan_detail: {total_process_keys: 17316364, total_keys: 20812451, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17316364, block: {cache_hit_count: 24260089, read_count: 226863, 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:45:18 [2021-06-06T20:45:18.518Z]       │   └─TableRowIDScan_79(Probe)	4.05	17316364	cop[tikv]	table:l2	time:6m5.3s, loops:21024, cop_task: {num: 7792, max: 606.7ms, min: 562.5µs, avg: 173.4ms, p95: 347.9ms, max_proc_keys: 9730, p95_proc_keys: 4854, tot_proc: 16m12s, tot_wait: 5m28.2s, rpc_num: 7792, rpc_time: 22m31.3s, copr_cache: disabled}, tikv_task:{proc max:288ms, min:0s, p80:103ms, p95:138ms, iters:50016, tasks:7792}, scan_detail: {total_process_keys: 17316364, total_keys: 18289250, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5630196, block: {cache_hit_count: 99016372, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:45:18 [2021-06-06T20:45:18.518Z]       └─IndexLookUp_39(Probe)	4.05	12022730	root		time:1m49.6s, loops:11942, index_task: {total_time: 58.6s, fetch_handle: 47s, build: 3.55ms, wait: 11.6s}, table_task: {total_time: 7m51.4s, num: 1408, concurrency: 730}		206.7 KB	N/A
20:45:18 [2021-06-06T20:45:18.518Z]         ├─IndexRangeScan_36(Build)	5.06	17183307	cop[tikv]	table:l3, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:44.8s, loops:18338, cop_task: {num: 2750, max: 801.1ms, min: 1.08ms, avg: 159.6ms, p95: 352.9ms, max_proc_keys: 18366, p95_proc_keys: 13526, tot_proc: 5m30s, tot_wait: 1m27.3s, rpc_num: 2750, rpc_time: 7m18.7s, copr_cache: disabled}, tikv_task:{proc max:237ms, min:0s, p80:77ms, p95:118ms, iters:28927, tasks:2750}, scan_detail: {total_process_keys: 17183307, total_keys: 20546320, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17183307, block: {cache_hit_count: 23553897, 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:45:18 [2021-06-06T20:45:18.518Z]         └─Selection_38(Probe)	4.05	12022730	cop[tikv]		time:6m4.8s, loops:13775, cop_task: {num: 10196, max: 613.2ms, min: 450.2µs, avg: 170.3ms, p95: 349.4ms, max_proc_keys: 6954, p95_proc_keys: 3957, tot_proc: 20m20.3s, tot_wait: 7m29.5s, rpc_num: 10196, rpc_time: 28m56.5s, copr_cache: disabled}, tikv_task:{proc max:238ms, min:0s, p80:76ms, p95:114ms, iters:60650, tasks:10196}, scan_detail: {total_process_keys: 17183307, total_keys: 18130116, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5530561, block: {cache_hit_count: 98289236, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:45:18 [2021-06-06T20:45:18.518Z]           └─TableRowIDScan_37	5.06	17183307	cop[tikv]	table:l3	tikv_task:{proc max:237ms, min:0s, p80:75ms, p95:113ms, iters:60650, tasks:10196}	keep order:false	N/A	N/A
20:45:18 [2021-06-06T20:45:18.518Z] + sync
20:45:18 [2021-06-06T20:45:18.518Z] + /usr/bin/echo 3
20:46:39 [2021-06-06T20:46:39.877Z] 
20:46:39 [2021-06-06T20:46:39.877Z] queries/21.sql
20:46:39 [2021-06-06T20:46:39.877Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:46:39 [2021-06-06T20:46:39.877Z] Projection_26	100.00	100	root		time:1m19.1s, loops:2, Concurrency:OFF	tpch50.supplier.s_name, Column#72	4.62 KB	N/A
20:46:39 [2021-06-06T20:46:39.877Z] └─TopN_29	100.00	100	root		time:1m19.1s, loops:2	Column#72:desc, tpch50.supplier.s_name, offset:0, count:100	58.4 KB	N/A
20:46:39 [2021-06-06T20:46:39.877Z]   └─HashAgg_34	12800.00	20057	root		time:1m19.1s, loops:21, partial_worker:{wall_time:1m19.073587062s, concurrency:5, task_num:197, tot_wait:6m35.025642646s, tot_exec:273.178739ms, tot_time:6m35.353755535s, max:1m19.073557122s, p95:1m19.073557122s}, final_worker:{wall_time:1m19.083910191s, concurrency:5, task_num:25, tot_wait:6m35.339704494s, tot_exec:77.285769ms, tot_time:6m35.417002498s, max:1m19.083870853s, p95:1m19.083870853s}	group by:tpch50.supplier.s_name, funcs:count(1)->Column#72, funcs:firstrow(tpch50.supplier.s_name)->tpch50.supplier.s_name	17.2 MB	N/A
20:46:39 [2021-06-06T20:46:39.877Z]     └─IndexHashJoin_42	7828961.66	198698	root		time:1m19.1s, loops:198, inner:{total:2m15s, concurrency:5, task:147, construct:6.56s, fetch:1m51.8s, build:1.22s, 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:46:39 [2021-06-06T20:46:39.877Z]       ├─IndexHashJoin_83(Build)	9786202.08	3542799	root		time:1m18.5s, loops:3463, inner:{total:2m24.1s, concurrency:5, task:152, construct:7.95s, fetch:1m57.7s, build:1.17s, join:18.5s}	semi join, inner:IndexLookUp_80, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey), ne(tpch50.lineitem.l_suppkey, tpch50.supplier.s_suppkey)	555.9 MB	N/A
20:46:39 [2021-06-06T20:46:39.877Z]       │ ├─IndexJoin_99(Build)	12232752.60	3675878	root		time:1m18.1s, loops:3595, inner:{total:2m2.8s, concurrency:5, task:305, construct:16.7s, fetch:1m44.1s, build:1.96s}, probe:5.16s	inner join, inner:TableReader_95, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.orders.o_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.orders.o_orderkey)	575.4 MB	N/A
20:46:39 [2021-06-06T20:46:39.877Z]       │ │ ├─HashJoin_107(Build)	12232752.60	7609895	root		time:1m17.6s, loops:7436, build_hash_table:{total:930.6ms, fetch:924.9ms, build:5.78ms}, probe:{concurrency:5, total:6m29.8s, max:1m18s, probe:1m2s, fetch:5m27.9s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.lineitem.l_suppkey)]	762.0 KB	0 Bytes
20:46:39 [2021-06-06T20:46:39.877Z]       │ │ │ ├─HashJoin_120(Build)	20000.00	20058	root		time:927.8ms, loops:23, build_hash_table:{total:142.2µs, fetch:136.9µs, build:5.32µs}, probe:{concurrency:5, total:4.64s, max:929ms, probe:59.2ms, fetch:4.59s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:46:39 [2021-06-06T20:46:39.877Z]       │ │ │ │ ├─TableReader_125(Build)	1.00	1	root		time:45.6µs, loops:2, cop_task: {num: 1, max: 1.28ms, proc_keys: 25, rpc_num: 1, rpc_time: 1.25ms, copr_cache: disabled}	data:Selection_124	240 Bytes	N/A
20:46:39 [2021-06-06T20:46:39.877Z]       │ │ │ │ │ └─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:46:39 [2021-06-06T20:46:39.877Z]       │ │ │ │ │   └─TableFullScan_123	25.00	25	cop[tikv]	table:nation	tikv_task:{time:0s, loops:1}	keep order:false	N/A	N/A
20:46:39 [2021-06-06T20:46:39.877Z]       │ │ │ │ └─TableReader_122(Probe)	500000.00	500000	root		time:916.9ms, loops:490, cop_task: {num: 1, max: 917.8ms, proc_keys: 500000, tot_proc: 877ms, tot_wait: 1ms, rpc_num: 1, rpc_time: 917.8ms, copr_cache: disabled}	data:TableFullScan_121	20.0 MB	N/A
20:46:39 [2021-06-06T20:46:39.877Z]       │ │ │ │   └─TableFullScan_121	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:819ms, 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:46:39 [2021-06-06T20:46:39.877Z]       │ │ │ └─TableReader_128(Probe)	240004648.80	189670348	root		time:1m5s, loops:184598, cop_task: {num: 761, max: 2.56s, min: 241.7ms, avg: 1.5s, p95: 1.94s, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 17m44.8s, tot_wait: 59.7s, rpc_num: 761, rpc_time: 18m57.9s, copr_cache: disabled}	data:Selection_127	101.7 MB	N/A
20:46:39 [2021-06-06T20:46:39.877Z]       │ │ │   └─Selection_127	240004648.80	189670348	cop[tikv]		tikv_task:{proc max:1.31s, min:228ms, p80:1.16s, p95:1.21s, iters:296606, tasks:761}, scan_detail: {total_process_keys: 300005811, total_keys: 300006572, rocksdb: {delete_skipped_count: 0, key_skipped_count: 600010861, block: {cache_hit_count: 10456, read_count: 1114192, read_byte: 23.6 GB}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:46:39 [2021-06-06T20:46:39.877Z]       │ │ │     └─TableFullScan_126	300005811.00	300005811	cop[tikv]	table:l1	tikv_task:{proc max:1.22s, min:212ms, p80:1.08s, p95:1.13s, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:46:39 [2021-06-06T20:46:39.877Z]       │ │ └─TableReader_95(Probe)	0.49	3496173	root		time:1m35.1s, loops:3875, cop_task: {num: 5263, max: 553.4ms, min: 782.3µs, avg: 170.4ms, p95: 324.2ms, max_proc_keys: 3471, p95_proc_keys: 1963, tot_proc: 10m46.2s, tot_wait: 3m31.1s, rpc_num: 5263, rpc_time: 14m56.9s, copr_cache: disabled}	data:Selection_94	N/A	N/A
20:46:39 [2021-06-06T20:46:39.877Z]       │ │   └─Selection_94	0.49	3496173	cop[tikv]		tikv_task:{proc max:136ms, min:0s, p80:68ms, p95:80ms, iters:30251, tasks:5263}, scan_detail: {total_process_keys: 7236262, total_keys: 7795461, rocksdb: {delete_skipped_count: 0, key_skipped_count: 1778297, block: {cache_hit_count: 54006457, read_count: 218104, read_byte: 4.21 GB}}}	eq(tpch50.orders.o_orderstatus, "F")	N/A	N/A
20:46:39 [2021-06-06T20:46:39.877Z]       │ │     └─TableRangeScan_93	1.00	7236262	cop[tikv]	table:orders	tikv_task:{proc max:135ms, min:0s, p80:67ms, p95:80ms, iters:30251, tasks:5263}	range: decided by [tpch50.lineitem.l_orderkey], keep order:false	N/A	N/A
20:46:39 [2021-06-06T20:46:39.877Z]       │ └─IndexLookUp_80(Probe)	4.05	17316374	root		time:1m52.3s, loops:17127, index_task: {total_time: 1m2.1s, fetch_handle: 54.7s, build: 3.53ms, wait: 7.39s}, table_task: {total_time: 8m3.9s, num: 1458, concurrency: 760}		19.1 KB	N/A
20:46:39 [2021-06-06T20:46:39.877Z]       │   ├─IndexRangeScan_78(Build)	4.05	17316374	cop[tikv]	table:l2, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:52.4s, loops:18625, cop_task: {num: 2953, max: 817.8ms, min: 436.2µs, avg: 180.5ms, p95: 360.9ms, max_proc_keys: 12800, p95_proc_keys: 8778, tot_proc: 6m39.4s, tot_wait: 1m53s, rpc_num: 2953, rpc_time: 8m52.9s, copr_cache: disabled}, tikv_task:{proc max:183ms, min:0s, p80:92ms, p95:108ms, iters:29938, tasks:2953}, scan_detail: {total_process_keys: 17316374, total_keys: 20812463, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17316374, block: {cache_hit_count: 24259869, 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:46:39 [2021-06-06T20:46:39.877Z]       │   └─TableRowIDScan_79(Probe)	4.05	17316374	cop[tikv]	table:l2	time:5m56.9s, loops:20989, cop_task: {num: 7810, max: 608.8ms, min: 563.3µs, avg: 167.5ms, p95: 338ms, max_proc_keys: 11690, p95_proc_keys: 4835, tot_proc: 15m37.2s, tot_wait: 5m18.9s, rpc_num: 7810, rpc_time: 21m47.7s, copr_cache: disabled}, tikv_task:{proc max:255ms, min:0s, p80:102ms, p95:136ms, iters:49981, tasks:7810}, scan_detail: {total_process_keys: 17316374, total_keys: 18288874, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5624636, block: {cache_hit_count: 99026382, read_count: 1109, read_byte: 389.8 MB}}}	keep order:false	N/A	N/A
20:46:39 [2021-06-06T20:46:39.877Z]       └─IndexLookUp_39(Probe)	4.05	12022748	root		time:1m46.8s, loops:11950, index_task: {total_time: 56s, fetch_handle: 46s, build: 4.19ms, wait: 9.96s}, table_task: {total_time: 7m41.7s, num: 1410, concurrency: 735}		215.1 KB	N/A
20:46:39 [2021-06-06T20:46:39.877Z]         ├─IndexRangeScan_36(Build)	5.06	17183331	cop[tikv]	table:l3, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:43.8s, loops:18347, cop_task: {num: 2767, max: 685.3ms, min: 2.45ms, avg: 159.4ms, p95: 354.4ms, max_proc_keys: 17744, p95_proc_keys: 13523, tot_proc: 5m27.7s, tot_wait: 1m32.6s, rpc_num: 2767, rpc_time: 7m21s, copr_cache: disabled}, tikv_task:{proc max:179ms, min:0s, p80:77ms, p95:117ms, iters:29000, tasks:2767}, scan_detail: {total_process_keys: 17183331, total_keys: 20546347, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17183331, 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:46:39 [2021-06-06T20:46:39.877Z]         └─Selection_38(Probe)	4.05	12022748	cop[tikv]		time:5m56s, loops:13788, cop_task: {num: 10194, max: 592.4ms, min: 620.6µs, avg: 165.9ms, p95: 335.9ms, max_proc_keys: 7342, p95_proc_keys: 3926, tot_proc: 19m46s, tot_wait: 7m19.9s, rpc_num: 10194, rpc_time: 28m11.1s, copr_cache: disabled}, tikv_task:{proc max:256ms, min:0s, p80:75ms, p95:113ms, iters:60540, tasks:10194}, scan_detail: {total_process_keys: 17183331, total_keys: 18128313, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5525728, block: {cache_hit_count: 98285673, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:46:39 [2021-06-06T20:46:39.877Z]           └─TableRowIDScan_37	5.06	17183331	cop[tikv]	table:l3	tikv_task:{proc max:252ms, min:0s, p80:74ms, p95:112ms, iters:60540, tasks:10194}	keep order:false	N/A	N/A
20:46:39 [2021-06-06T20:46:39.877Z] + sync
20:46:39 [2021-06-06T20:46:39.877Z] + /usr/bin/echo 3
20:48:01 [2021-06-06T20:48:01.280Z] 
20:48:01 [2021-06-06T20:48:01.280Z] queries/21.sql
20:48:01 [2021-06-06T20:48:01.280Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:48:01 [2021-06-06T20:48:01.280Z] Projection_26	100.00	100	root		time:1m19.4s, loops:2, Concurrency:OFF	tpch50.supplier.s_name, Column#72	4.62 KB	N/A
20:48:01 [2021-06-06T20:48:01.280Z] └─TopN_29	100.00	100	root		time:1m19.4s, loops:2	Column#72:desc, tpch50.supplier.s_name, offset:0, count:100	58.4 KB	N/A
20:48:01 [2021-06-06T20:48:01.280Z]   └─HashAgg_34	12800.00	20057	root		time:1m19.4s, loops:21, partial_worker:{wall_time:1m19.412911098s, concurrency:5, task_num:197, tot_wait:6m36.784261376s, tot_exec:267.068087ms, tot_time:6m37.063039615s, max:1m19.412885374s, p95:1m19.412885374s}, final_worker:{wall_time:1m19.42484257s, concurrency:5, task_num:25, tot_wait:6m37.061906581s, tot_exec:61.654112ms, tot_time:6m37.123572787s, max:1m19.424819547s, p95:1m19.424819547s}	group by:tpch50.supplier.s_name, funcs:count(1)->Column#72, funcs:firstrow(tpch50.supplier.s_name)->tpch50.supplier.s_name	17.2 MB	N/A
20:48:01 [2021-06-06T20:48:01.280Z]     └─IndexHashJoin_42	7828961.66	198698	root		time:1m19.4s, loops:198, inner:{total:2m16.3s, concurrency:5, task:146, construct:6.14s, fetch:1m53.4s, build:1.2s, 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.1 MB	N/A
20:48:01 [2021-06-06T20:48:01.280Z]       ├─IndexHashJoin_83(Build)	9786202.08	3542799	root		time:1m18.9s, loops:3463, inner:{total:2m25.2s, concurrency:5, task:152, construct:7.68s, fetch:1m59.5s, build:1.26s, join:18s}	semi join, inner:IndexLookUp_80, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey), ne(tpch50.lineitem.l_suppkey, tpch50.supplier.s_suppkey)	555.9 MB	N/A
20:48:01 [2021-06-06T20:48:01.280Z]       │ ├─IndexJoin_99(Build)	12232752.60	3675878	root		time:1m18.3s, loops:3595, inner:{total:2m2.2s, concurrency:5, task:305, construct:15.9s, fetch:1m44.5s, build:1.84s}, probe:5.02s	inner join, inner:TableReader_95, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.orders.o_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.orders.o_orderkey)	575.3 MB	N/A
20:48:01 [2021-06-06T20:48:01.280Z]       │ │ ├─HashJoin_107(Build)	12232752.60	7609895	root		time:1m17.9s, loops:7436, build_hash_table:{total:1.03s, fetch:1.02s, build:6.54ms}, probe:{concurrency:5, total:6m31.2s, max:1m18.2s, probe:1m2s, fetch:5m29.1s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.lineitem.l_suppkey)]	737.6 KB	0 Bytes
20:48:01 [2021-06-06T20:48:01.280Z]       │ │ │ ├─HashJoin_120(Build)	20000.00	20058	root		time:1.03s, loops:22, build_hash_table:{total:244.9µs, fetch:236.7µs, build:8.16µs}, probe:{concurrency:5, total:5.15s, max:1.03s, probe:69.2ms, fetch:5.08s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:48:01 [2021-06-06T20:48:01.280Z]       │ │ │ │ ├─TableReader_125(Build)	1.00	1	root		time:59.1µs, loops:2, cop_task: {num: 1, max: 1.29ms, proc_keys: 25, tot_proc: 1ms, rpc_num: 1, rpc_time: 1.24ms, copr_cache: disabled}	data:Selection_124	248 Bytes	N/A
20:48:01 [2021-06-06T20:48:01.280Z]       │ │ │ │ │ └─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:48:01 [2021-06-06T20:48:01.280Z]       │ │ │ │ │   └─TableFullScan_123	25.00	25	cop[tikv]	table:nation	tikv_task:{time:1ms, loops:1}	keep order:false	N/A	N/A
20:48:01 [2021-06-06T20:48:01.280Z]       │ │ │ │ └─TableReader_122(Probe)	500000.00	500000	root		time:1.02s, loops:490, cop_task: {num: 1, max: 1.02s, proc_keys: 500000, tot_proc: 981ms, rpc_num: 1, rpc_time: 1.02s, copr_cache: disabled}	data:TableFullScan_121	20.0 MB	N/A
20:48:01 [2021-06-06T20:48:01.280Z]       │ │ │ │   └─TableFullScan_121	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:929ms, 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:48:01 [2021-06-06T20:48:01.281Z]       │ │ │ └─TableReader_128(Probe)	240004648.80	189670348	root		time:1m5.3s, loops:184596, cop_task: {num: 761, max: 2.71s, min: 273.8ms, avg: 1.5s, p95: 1.95s, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 17m53.3s, tot_wait: 55.7s, rpc_num: 761, rpc_time: 19m2.7s, copr_cache: disabled}	data:Selection_127	109.4 MB	N/A
20:48:01 [2021-06-06T20:48:01.281Z]       │ │ │   └─Selection_127	240004648.80	189670348	cop[tikv]		tikv_task:{proc max:1.3s, min:256ms, p80:1.16s, p95:1.22s, iters:296606, tasks:761}, scan_detail: {total_process_keys: 300005811, total_keys: 300006572, rocksdb: {delete_skipped_count: 0, key_skipped_count: 600010861, block: {cache_hit_count: 10452, read_count: 1114196, read_byte: 23.6 GB}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:48:01 [2021-06-06T20:48:01.281Z]       │ │ │     └─TableFullScan_126	300005811.00	300005811	cop[tikv]	table:l1	tikv_task:{proc max:1.21s, min:236ms, p80:1.08s, p95:1.13s, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:48:01 [2021-06-06T20:48:01.281Z]       │ │ └─TableReader_95(Probe)	0.49	3496195	root		time:1m35.8s, loops:3875, cop_task: {num: 5288, max: 531.7ms, min: 2.17ms, avg: 169.4ms, p95: 329.2ms, max_proc_keys: 3625, p95_proc_keys: 1946, tot_proc: 10m44.3s, tot_wait: 3m32.8s, rpc_num: 5288, rpc_time: 14m55.8s, copr_cache: disabled}	data:Selection_94	N/A	N/A
20:48:01 [2021-06-06T20:48:01.281Z]       │ │   └─Selection_94	0.49	3496195	cop[tikv]		tikv_task:{proc max:137ms, min:0s, p80:68ms, p95:80ms, iters:30278, tasks:5288}, scan_detail: {total_process_keys: 7236319, total_keys: 7795600, rocksdb: {delete_skipped_count: 0, key_skipped_count: 1778481, block: {cache_hit_count: 54006934, read_count: 218243, read_byte: 4.21 GB}}}	eq(tpch50.orders.o_orderstatus, "F")	N/A	N/A
20:48:01 [2021-06-06T20:48:01.281Z]       │ │     └─TableRangeScan_93	1.00	7236319	cop[tikv]	table:orders	tikv_task:{proc max:136ms, min:0s, p80:67ms, p95:80ms, iters:30278, tasks:5288}	range: decided by [tpch50.lineitem.l_orderkey], keep order:false	N/A	N/A
20:48:01 [2021-06-06T20:48:01.281Z]       │ └─IndexLookUp_80(Probe)	4.05	17316517	root		time:1m54.2s, loops:17128, index_task: {total_time: 1m4s, fetch_handle: 55.5s, build: 4.42ms, wait: 8.47s}, table_task: {total_time: 8m11.1s, num: 1458, concurrency: 760}		19.0 KB	N/A
20:48:01 [2021-06-06T20:48:01.281Z]       │   ├─IndexRangeScan_78(Build)	4.05	17316517	cop[tikv]	table:l2, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:53.3s, loops:18616, cop_task: {num: 3018, max: 686ms, min: 589.4µs, avg: 181.8ms, p95: 366.1ms, max_proc_keys: 12510, p95_proc_keys: 8754, tot_proc: 6m53.4s, tot_wait: 1m54.6s, rpc_num: 3018, rpc_time: 9m8.7s, copr_cache: disabled}, tikv_task:{proc max:173ms, min:0s, p80:93ms, p95:109ms, iters:30243, tasks:3018}, scan_detail: {total_process_keys: 17316517, total_keys: 20812630, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17316517, block: {cache_hit_count: 24260041, read_count: 225677, read_byte: 2.00 GB}}}	range: decided by [eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey)], keep order:false	N/A	N/A
20:48:01 [2021-06-06T20:48:01.281Z]       │   └─TableRowIDScan_79(Probe)	4.05	17316517	cop[tikv]	table:l2	time:6m1.9s, loops:20980, cop_task: {num: 7821, max: 790.3ms, min: 504.3µs, avg: 169.8ms, p95: 346.9ms, max_proc_keys: 11690, p95_proc_keys: 4898, tot_proc: 15m56.5s, tot_wait: 5m22.5s, rpc_num: 7821, rpc_time: 22m7.7s, copr_cache: disabled}, tikv_task:{proc max:258ms, min:0s, p80:102ms, p95:138ms, iters:50023, tasks:7821}, scan_detail: {total_process_keys: 17316517, total_keys: 18288745, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5622692, block: {cache_hit_count: 99031520, read_count: 1116, read_byte: 399.8 MB}}}	keep order:false	N/A	N/A
20:48:01 [2021-06-06T20:48:01.281Z]       └─IndexLookUp_39(Probe)	4.05	12022834	root		time:1m48.7s, loops:11948, index_task: {total_time: 58.1s, fetch_handle: 47.5s, build: 4.31ms, wait: 10.6s}, table_task: {total_time: 7m47.9s, num: 1408, concurrency: 730}		223.0 KB	N/A
20:48:01 [2021-06-06T20:48:01.281Z]         ├─IndexRangeScan_36(Build)	5.06	17183434	cop[tikv]	table:l3, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:45.4s, loops:18343, cop_task: {num: 2790, max: 757ms, min: 697.7µs, avg: 160.7ms, p95: 348.7ms, max_proc_keys: 19135, p95_proc_keys: 13702, tot_proc: 5m31.6s, tot_wait: 1m37s, rpc_num: 2790, rpc_time: 7m28.2s, copr_cache: disabled}, tikv_task:{proc max:180ms, min:0s, p80:75ms, p95:117ms, iters:29134, tasks:2790}, scan_detail: {total_process_keys: 17183434, total_keys: 20546468, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17183434, block: {cache_hit_count: 23554044, 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:01 [2021-06-06T20:48:01.281Z]         └─Selection_38(Probe)	4.05	12022834	cop[tikv]		time:6m0.1s, loops:13780, cop_task: {num: 10154, max: 649.7ms, min: 640µs, avg: 168.8ms, p95: 345.8ms, max_proc_keys: 7733, p95_proc_keys: 4033, tot_proc: 20m2.7s, tot_wait: 7m25.5s, rpc_num: 10154, rpc_time: 28m33.5s, copr_cache: disabled}, tikv_task:{proc max:239ms, min:0s, p80:75ms, p95:115ms, iters:60334, tasks:10154}, scan_detail: {total_process_keys: 17183434, total_keys: 18129993, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5528707, block: {cache_hit_count: 98292665, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:48:01 [2021-06-06T20:48:01.281Z]           └─TableRowIDScan_37	5.06	17183434	cop[tikv]	table:l3	tikv_task:{proc max:237ms, min:0s, p80:75ms, p95:114ms, iters:60334, tasks:10154}	keep order:false	N/A	N/A
20:48:01 [2021-06-06T20:48:01.281Z] + sync
20:48:01 [2021-06-06T20:48:01.281Z] + /usr/bin/echo 3
20:49:22 [2021-06-06T20:49:22.640Z] 
20:49:22 [2021-06-06T20:49:22.640Z] queries/21.sql
20:49:22 [2021-06-06T20:49:22.640Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:49:22 [2021-06-06T20:49:22.640Z] Projection_26	100.00	100	root		time:1m19.5s, loops:2, Concurrency:OFF	tpch50.supplier.s_name, Column#72	4.62 KB	N/A
20:49:22 [2021-06-06T20:49:22.640Z] └─TopN_29	100.00	100	root		time:1m19.5s, loops:2	Column#72:desc, tpch50.supplier.s_name, offset:0, count:100	55.9 KB	N/A
20:49:22 [2021-06-06T20:49:22.640Z]   └─HashAgg_34	12800.00	20057	root		time:1m19.5s, loops:21, partial_worker:{wall_time:1m19.484265565s, concurrency:5, task_num:198, tot_wait:6m37.161134532s, tot_exec:247.141397ms, tot_time:6m37.419978055s, max:1m19.48422701s, p95:1m19.48422701s}, final_worker:{wall_time:1m19.49998417s, concurrency:5, task_num:25, tot_wait:6m37.419038141s, tot_exec:70.145929ms, tot_time:6m37.489196809s, max:1m19.499948359s, p95:1m19.499948359s}	group by:tpch50.supplier.s_name, funcs:count(1)->Column#72, funcs:firstrow(tpch50.supplier.s_name)->tpch50.supplier.s_name	17.2 MB	N/A
20:49:22 [2021-06-06T20:49:22.640Z]     └─IndexHashJoin_42	7828961.66	198698	root		time:1m19.5s, loops:199, inner:{total:2m17.8s, concurrency:5, task:146, construct:6.21s, fetch:1m54.8s, build:1.11s, 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:49:22 [2021-06-06T20:49:22.640Z]       ├─IndexHashJoin_83(Build)	9786202.08	3542799	root		time:1m19s, loops:3462, inner:{total:2m28.6s, concurrency:5, task:152, construct:7.55s, fetch:2m3.7s, build:1.25s, join:17.4s}	semi join, inner:IndexLookUp_80, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey), ne(tpch50.lineitem.l_suppkey, tpch50.supplier.s_suppkey)	555.9 MB	N/A
20:49:22 [2021-06-06T20:49:22.640Z]       │ ├─IndexJoin_99(Build)	12232752.60	3675878	root		time:1m18.4s, loops:3595, inner:{total:2m7.2s, concurrency:5, task:305, construct:16.3s, fetch:1m49s, build:1.85s}, probe:5.16s	inner join, inner:TableReader_95, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.orders.o_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.orders.o_orderkey)	575.4 MB	N/A
20:49:22 [2021-06-06T20:49:22.640Z]       │ │ ├─HashJoin_107(Build)	12232752.60	7609895	root		time:1m17.9s, loops:7438, build_hash_table:{total:1.11s, fetch:1.11s, build:6.06ms}, probe:{concurrency:5, total:6m31.5s, max:1m18.3s, probe:1m2s, fetch:5m29.4s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.lineitem.l_suppkey)]	732.8 KB	0 Bytes
20:49:22 [2021-06-06T20:49:22.640Z]       │ │ │ ├─HashJoin_120(Build)	20000.00	20058	root		time:1.11s, loops:22, build_hash_table:{total:2.04ms, fetch:2.03ms, build:8.01µs}, probe:{concurrency:5, total:5.56s, max:1.11s, probe:56.5ms, fetch:5.5s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:49:22 [2021-06-06T20:49:22.640Z]       │ │ │ │ ├─TableReader_125(Build)	1.00	1	root		time:55.1µs, loops:2, cop_task: {num: 1, max: 1.24ms, proc_keys: 25, tot_proc: 1ms, rpc_num: 1, rpc_time: 1.22ms, copr_cache: disabled}	data:Selection_124	248 Bytes	N/A
20:49:22 [2021-06-06T20:49:22.640Z]       │ │ │ │ │ └─Selection_124	1.00	1	cop[tikv]		tikv_task:{time:1ms, loops:1}, scan_detail: {total_process_keys: 25, total_keys: 26, rocksdb: {delete_skipped_count: 0, key_skipped_count: 46, block: {cache_hit_count: 17, read_count: 1, read_byte: 23.8 KB}}}	eq(tpch50.nation.n_name, "EGYPT")	N/A	N/A
20:49:22 [2021-06-06T20:49:22.640Z]       │ │ │ │ │   └─TableFullScan_123	25.00	25	cop[tikv]	table:nation	tikv_task:{time:1ms, loops:1}	keep order:false	N/A	N/A
20:49:22 [2021-06-06T20:49:22.640Z]       │ │ │ │ └─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.07s, rpc_num: 1, rpc_time: 1.1s, copr_cache: disabled}	data:TableFullScan_121	20.0 MB	N/A
20:49:22 [2021-06-06T20:49:22.640Z]       │ │ │ │   └─TableFullScan_121	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:996ms, loops:493}, scan_detail: {total_process_keys: 500000, total_keys: 500001, rocksdb: {delete_skipped_count: 0, key_skipped_count: 999999, block: {cache_hit_count: 13, read_count: 1679, read_byte: 104.5 MB}}}	keep order:false	N/A	N/A
20:49:22 [2021-06-06T20:49:22.640Z]       │ │ │ └─TableReader_128(Probe)	240004648.80	189670348	root		time:1m5.3s, loops:184598, cop_task: {num: 761, max: 2.52s, min: 363.9ms, avg: 1.5s, p95: 1.98s, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 17m47.7s, tot_wait: 1m0.6s, rpc_num: 761, rpc_time: 19m1.6s, copr_cache: disabled}	data:Selection_127	109.4 MB	N/A
20:49:22 [2021-06-06T20:49:22.640Z]       │ │ │   └─Selection_127	240004648.80	189670348	cop[tikv]		tikv_task:{proc max:1.28s, min:352ms, p80:1.17s, 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: 10451, read_count: 1114197, read_byte: 23.6 GB}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:49:22 [2021-06-06T20:49:22.640Z]       │ │ │     └─TableFullScan_126	300005811.00	300005811	cop[tikv]	table:l1	tikv_task:{proc max:1.19s, min:328ms, p80:1.08s, p95:1.12s, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:49:22 [2021-06-06T20:49:22.640Z]       │ │ └─TableReader_95(Probe)	0.49	3496180	root		time:1m40.2s, loops:3875, cop_task: {num: 5256, max: 522.4ms, min: 1.13ms, avg: 177ms, p95: 341.1ms, max_proc_keys: 3474, p95_proc_keys: 1972, tot_proc: 11m2.8s, tot_wait: 3m47.4s, rpc_num: 5256, rpc_time: 15m30.1s, copr_cache: disabled}	data:Selection_94	N/A	N/A
20:49:22 [2021-06-06T20:49:22.640Z]       │ │   └─Selection_94	0.49	3496180	cop[tikv]		tikv_task:{proc max:130ms, min:0s, p80:68ms, p95:79ms, iters:30210, tasks:5256}, scan_detail: {total_process_keys: 7236299, total_keys: 7795546, rocksdb: {delete_skipped_count: 0, key_skipped_count: 1778405, block: {cache_hit_count: 54008565, read_count: 216380, read_byte: 4.17 GB}}}	eq(tpch50.orders.o_orderstatus, "F")	N/A	N/A
20:49:22 [2021-06-06T20:49:22.640Z]       │ │     └─TableRangeScan_93	1.00	7236299	cop[tikv]	table:orders	tikv_task:{proc max:130ms, min:0s, p80:67ms, p95:79ms, iters:30210, tasks:5256}	range: decided by [tpch50.lineitem.l_orderkey], keep order:false	N/A	N/A
20:49:22 [2021-06-06T20:49:22.640Z]       │ └─IndexLookUp_80(Probe)	4.05	17316415	root		time:1m58.2s, loops:17127, index_task: {total_time: 1m6.1s, fetch_handle: 56.8s, build: 3.37ms, wait: 9.27s}, table_task: {total_time: 8m25.9s, num: 1458, concurrency: 760}		19.0 KB	N/A
20:49:22 [2021-06-06T20:49:22.640Z]       │   ├─IndexRangeScan_78(Build)	4.05	17316415	cop[tikv]	table:l2, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:54.6s, loops:18650, cop_task: {num: 2979, max: 736.5ms, min: 827.9µs, avg: 186.4ms, p95: 380.1ms, max_proc_keys: 11676, p95_proc_keys: 8788, tot_proc: 6m56.4s, tot_wait: 1m57.3s, rpc_num: 2979, rpc_time: 9m15.2s, copr_cache: disabled}, tikv_task:{proc max:174ms, min:0s, p80:93ms, p95:109ms, iters:30103, tasks:2979}, scan_detail: {total_process_keys: 17316415, total_keys: 20812512, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17316415, block: {cache_hit_count: 24259911, read_count: 225696, 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:22 [2021-06-06T20:49:22.640Z]       │   └─TableRowIDScan_79(Probe)	4.05	17316415	cop[tikv]	table:l2	time:6m15.1s, loops:20989, cop_task: {num: 7771, max: 617.1ms, min: 460.6µs, avg: 176.2ms, p95: 352ms, max_proc_keys: 11834, p95_proc_keys: 4822, tot_proc: 16m20s, tot_wait: 5m39.5s, rpc_num: 7771, rpc_time: 22m48.7s, copr_cache: disabled}, tikv_task:{proc max:279ms, min:0s, p80:102ms, p95:137ms, iters:49851, tasks:7771}, scan_detail: {total_process_keys: 17316415, total_keys: 18288716, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5629531, block: {cache_hit_count: 99009788, read_count: 1126, read_byte: 405.5 MB}}}	keep order:false	N/A	N/A
20:49:22 [2021-06-06T20:49:22.640Z]       └─IndexLookUp_39(Probe)	4.05	12022773	root		time:1m50.1s, loops:11946, index_task: {total_time: 58.6s, fetch_handle: 48.3s, build: 4.11ms, wait: 10.3s}, table_task: {total_time: 7m58.7s, num: 1408, concurrency: 730}		218.1 KB	N/A
20:49:22 [2021-06-06T20:49:22.640Z]         ├─IndexRangeScan_36(Build)	5.06	17183361	cop[tikv]	table:l3, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:45.8s, loops:18336, cop_task: {num: 2769, max: 774.2ms, min: 667.6µs, avg: 162.4ms, p95: 348.3ms, max_proc_keys: 19785, p95_proc_keys: 13781, tot_proc: 5m32.3s, tot_wait: 1m37.4s, rpc_num: 2769, rpc_time: 7m29.5s, copr_cache: disabled}, tikv_task:{proc max:179ms, min:0s, p80:77ms, p95:117ms, iters:29041, tasks:2769}, scan_detail: {total_process_keys: 17183361, total_keys: 20546383, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17183361, block: {cache_hit_count: 23553961, 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:22 [2021-06-06T20:49:22.640Z]         └─Selection_38(Probe)	4.05	12022773	cop[tikv]		time:6m7.9s, loops:13785, cop_task: {num: 10341, max: 743.8ms, min: 359.8µs, avg: 171.6ms, p95: 348.7ms, max_proc_keys: 7809, p95_proc_keys: 3900, tot_proc: 20m48.5s, tot_wait: 7m40.6s, rpc_num: 10341, rpc_time: 29m34.4s, copr_cache: disabled}, tikv_task:{proc max:254ms, min:0s, p80:73ms, p95:112ms, iters:61148, tasks:10341}, scan_detail: {total_process_keys: 17183361, total_keys: 18128160, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5522791, block: {cache_hit_count: 98293886, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:49:22 [2021-06-06T20:49:22.640Z]           └─TableRowIDScan_37	5.06	17183361	cop[tikv]	table:l3	tikv_task:{proc max:248ms, min:0s, p80:72ms, p95:111ms, iters:61148, tasks:10341}	keep order:false	N/A	N/A
20:49:22 [2021-06-06T20:49:22.640Z] + sync
20:49:22 [2021-06-06T20:49:22.640Z] + /usr/bin/echo 3
20:50:59 [2021-06-06T20:50:59.017Z] 
20:50:59 [2021-06-06T20:50:59.017Z] queries/21.sql
20:50:59 [2021-06-06T20:50:59.017Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:50:59 [2021-06-06T20:50:59.017Z] Projection_26	100.00	100	root		time:1m19.3s, loops:2, Concurrency:OFF	tpch50.supplier.s_name, Column#72	4.62 KB	N/A
20:50:59 [2021-06-06T20:50:59.017Z] └─TopN_29	100.00	100	root		time:1m19.3s, loops:2	Column#72:desc, tpch50.supplier.s_name, offset:0, count:100	58.4 KB	N/A
20:50:59 [2021-06-06T20:50:59.017Z]   └─HashAgg_34	12800.00	20057	root		time:1m19.3s, loops:21, partial_worker:{wall_time:1m19.277731936s, concurrency:5, task_num:196, tot_wait:6m36.126712103s, tot_exec:246.411467ms, tot_time:6m36.38615252s, max:1m19.277695308s, p95:1m19.277695308s}, final_worker:{wall_time:1m19.289457478s, concurrency:5, task_num:25, tot_wait:6m36.384471288s, tot_exec:61.855727ms, tot_time:6m36.446339451s, max:1m19.289424023s, p95:1m19.289424023s}	group by:tpch50.supplier.s_name, funcs:count(1)->Column#72, funcs:firstrow(tpch50.supplier.s_name)->tpch50.supplier.s_name	17.2 MB	N/A
20:50:59 [2021-06-06T20:50:59.017Z]     └─IndexHashJoin_42	7828961.66	198698	root		time:1m19.3s, loops:197, inner:{total:2m17.9s, concurrency:5, task:147, construct:6.68s, fetch:1m54.8s, build:1.25s, join:16.4s}	anti semi join, inner:IndexLookUp_39, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey)	641.1 MB	N/A
20:50:59 [2021-06-06T20:50:59.017Z]       ├─IndexHashJoin_83(Build)	9786202.08	3542799	root		time:1m18.6s, loops:3464, inner:{total:2m26.6s, concurrency:5, task:152, construct:7.93s, fetch:2m0.6s, build:1.23s, join:18.1s}	semi join, inner:IndexLookUp_80, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey), ne(tpch50.lineitem.l_suppkey, tpch50.supplier.s_suppkey)	555.9 MB	N/A
20:50:59 [2021-06-06T20:50:59.017Z]       │ ├─IndexJoin_99(Build)	12232752.60	3675878	root		time:1m18.1s, loops:3595, inner:{total:2m4.6s, concurrency:5, task:305, construct:16.2s, fetch:1m46.5s, build:1.9s}, probe:5.12s	inner join, inner:TableReader_95, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.orders.o_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.orders.o_orderkey)	575.5 MB	N/A
20:50:59 [2021-06-06T20:50:59.017Z]       │ │ ├─HashJoin_107(Build)	12232752.60	7609895	root		time:1m17.8s, loops:7437, build_hash_table:{total:1.01s, fetch:1.01s, build:6.48ms}, probe:{concurrency:5, total:6m30.4s, max:1m18.1s, probe:1m1.9s, fetch:5m28.5s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.lineitem.l_suppkey)]	737.6 KB	0 Bytes
20:50:59 [2021-06-06T20:50:59.017Z]       │ │ │ ├─HashJoin_120(Build)	20000.00	20058	root		time:1.01s, loops:22, build_hash_table:{total:195.1µs, fetch:189.1µs, build:5.98µs}, probe:{concurrency:5, total:5.05s, max:1.01s, probe:70.4ms, fetch:4.98s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:50:59 [2021-06-06T20:50:59.017Z]       │ │ │ │ ├─TableReader_125(Build)	1.00	1	root		time:48.6µs, loops:2, cop_task: {num: 1, max: 1.46ms, proc_keys: 25, tot_proc: 1ms, rpc_num: 1, rpc_time: 1.44ms, copr_cache: disabled}	data:Selection_124	248 Bytes	N/A
20:50:59 [2021-06-06T20:50:59.017Z]       │ │ │ │ │ └─Selection_124	1.00	1	cop[tikv]		tikv_task:{time:1ms, loops:1}, scan_detail: {total_process_keys: 25, total_keys: 26, rocksdb: {delete_skipped_count: 0, key_skipped_count: 46, block: {cache_hit_count: 17, read_count: 1, read_byte: 23.8 KB}}}	eq(tpch50.nation.n_name, "EGYPT")	N/A	N/A
20:50:59 [2021-06-06T20:50:59.017Z]       │ │ │ │ │   └─TableFullScan_123	25.00	25	cop[tikv]	table:nation	tikv_task:{time:1ms, loops:1}	keep order:false	N/A	N/A
20:50:59 [2021-06-06T20:50:59.017Z]       │ │ │ │ └─TableReader_122(Probe)	500000.00	500000	root		time:996.8ms, loops:490, cop_task: {num: 1, max: 996.8ms, proc_keys: 500000, tot_proc: 960ms, rpc_num: 1, rpc_time: 996.8ms, copr_cache: disabled}	data:TableFullScan_121	20.0 MB	N/A
20:50:59 [2021-06-06T20:50:59.017Z]       │ │ │ │   └─TableFullScan_121	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:892ms, loops:493}, scan_detail: {total_process_keys: 500000, total_keys: 500001, rocksdb: {delete_skipped_count: 0, key_skipped_count: 999999, block: {cache_hit_count: 13, read_count: 1679, read_byte: 104.5 MB}}}	keep order:false	N/A	N/A
20:50:59 [2021-06-06T20:50:59.017Z]       │ │ │ └─TableReader_128(Probe)	240004648.80	189670348	root		time:1m5.2s, loops:184596, cop_task: {num: 761, max: 2.68s, min: 263.3ms, avg: 1.5s, p95: 1.94s, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 17m49.8s, tot_wait: 59.1s, rpc_num: 761, rpc_time: 19m2s, copr_cache: disabled}	data:Selection_127	109.4 MB	N/A
20:50:59 [2021-06-06T20:50:59.017Z]       │ │ │   └─Selection_127	240004648.80	189670348	cop[tikv]		tikv_task:{proc max:1.29s, min:245ms, 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: 10460, read_count: 1114188, read_byte: 23.6 GB}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:50:59 [2021-06-06T20:50:59.018Z]       │ │ │     └─TableFullScan_126	300005811.00	300005811	cop[tikv]	table:l1	tikv_task:{proc max:1.2s, min:234ms, p80:1.08s, p95:1.12s, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:50:59 [2021-06-06T20:50:59.018Z]       │ │ └─TableReader_95(Probe)	0.49	3496172	root		time:1m37.8s, loops:3875, cop_task: {num: 5292, max: 566.3ms, min: 1.38ms, avg: 174.5ms, p95: 336ms, max_proc_keys: 3595, p95_proc_keys: 1968, tot_proc: 11m5.3s, tot_wait: 3m39.3s, rpc_num: 5292, rpc_time: 15m23.5s, copr_cache: disabled}	data:Selection_94	N/A	N/A
20:50:59 [2021-06-06T20:50:59.018Z]       │ │   └─Selection_94	0.49	3496172	cop[tikv]		tikv_task:{proc max:130ms, min:0s, p80:67ms, p95:79ms, iters:30273, tasks:5292}, scan_detail: {total_process_keys: 7236240, total_keys: 7795482, rocksdb: {delete_skipped_count: 0, key_skipped_count: 1778392, block: {cache_hit_count: 54006326, read_count: 217993, read_byte: 4.21 GB}}}	eq(tpch50.orders.o_orderstatus, "F")	N/A	N/A
20:50:59 [2021-06-06T20:50:59.018Z]       │ │     └─TableRangeScan_93	1.00	7236240	cop[tikv]	table:orders	tikv_task:{proc max:130ms, min:0s, p80:67ms, p95:79ms, iters:30273, tasks:5292}	range: decided by [tpch50.lineitem.l_orderkey], keep order:false	N/A	N/A
20:50:59 [2021-06-06T20:50:59.018Z]       │ └─IndexLookUp_80(Probe)	4.05	17316551	root		time:1m55s, loops:17132, index_task: {total_time: 1m2.9s, fetch_handle: 54.1s, build: 3.53ms, wait: 8.82s}, table_task: {total_time: 8m15.3s, num: 1458, concurrency: 760}		18.9 KB	N/A
20:50:59 [2021-06-06T20:50:59.018Z]       │   ├─IndexRangeScan_78(Build)	4.05	17316551	cop[tikv]	table:l2, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:51.9s, loops:18589, cop_task: {num: 2994, max: 630.5ms, min: 483.8µs, avg: 182ms, p95: 368.5ms, max_proc_keys: 13471, p95_proc_keys: 8766, tot_proc: 6m50.1s, tot_wait: 1m53.9s, rpc_num: 2994, rpc_time: 9m4.8s, copr_cache: disabled}, tikv_task:{proc max:170ms, min:0s, p80:94ms, p95:109ms, iters:30105, tasks:2994}, scan_detail: {total_process_keys: 17316551, total_keys: 20812672, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17316551, block: {cache_hit_count: 24260091, read_count: 225683, read_byte: 2.00 GB}}}	range: decided by [eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey)], keep order:false	N/A	N/A
20:50:59 [2021-06-06T20:50:59.018Z]       │   └─TableRowIDScan_79(Probe)	4.05	17316551	cop[tikv]	table:l2	time:6m7.5s, loops:21029, cop_task: {num: 7801, max: 565.7ms, min: 617.4µs, avg: 171.8ms, p95: 344.1ms, max_proc_keys: 13138, p95_proc_keys: 4836, tot_proc: 16m2.1s, tot_wait: 5m29.4s, rpc_num: 7801, rpc_time: 22m20.3s, copr_cache: disabled}, tikv_task:{proc max:279ms, min:0s, p80:102ms, p95:136ms, iters:49960, tasks:7801}, scan_detail: {total_process_keys: 17316551, total_keys: 18290431, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5633214, block: {cache_hit_count: 99015876, read_count: 1112, read_byte: 393.0 MB}}}	keep order:false	N/A	N/A
20:50:59 [2021-06-06T20:50:59.018Z]       └─IndexLookUp_39(Probe)	4.05	12022867	root		time:1m49.9s, loops:11952, index_task: {total_time: 58.8s, fetch_handle: 49.7s, build: 14.1ms, wait: 9.11s}, table_task: {total_time: 7m52.2s, num: 1410, concurrency: 735}		267.2 KB	N/A
20:50:59 [2021-06-06T20:50:59.018Z]         ├─IndexRangeScan_36(Build)	5.06	17183483	cop[tikv]	table:l3, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:47.3s, loops:18351, cop_task: {num: 2820, max: 745.9ms, min: 423µs, avg: 165.2ms, p95: 354.2ms, max_proc_keys: 19994, p95_proc_keys: 13788, tot_proc: 5m43.3s, tot_wait: 1m42.9s, rpc_num: 2820, rpc_time: 7m45.8s, copr_cache: disabled}, tikv_task:{proc max:193ms, min:0s, p80:75ms, p95:115ms, iters:29167, tasks:2820}, scan_detail: {total_process_keys: 17183483, total_keys: 20546527, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17183483, 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:50:59 [2021-06-06T20:50:59.018Z]         └─Selection_38(Probe)	4.05	12022867	cop[tikv]		time:6m1.3s, loops:13771, cop_task: {num: 10184, max: 605.5ms, min: 525.4µs, avg: 166.8ms, p95: 338.5ms, max_proc_keys: 6893, p95_proc_keys: 3966, tot_proc: 19m47.9s, tot_wait: 7m27.6s, rpc_num: 10184, rpc_time: 28m19s, copr_cache: disabled}, tikv_task:{proc max:216ms, min:0s, p80:76ms, p95:114ms, iters:60561, tasks:10184}, scan_detail: {total_process_keys: 17183483, total_keys: 18128283, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5523826, block: {cache_hit_count: 98289310, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:50:59 [2021-06-06T20:50:59.018Z]           └─TableRowIDScan_37	5.06	17183483	cop[tikv]	table:l3	tikv_task:{proc max:216ms, min:0s, p80:75ms, p95:113ms, iters:60561, tasks:10184}	keep order:false	N/A	N/A
20:50:59 [2021-06-06T20:50:59.018Z] + sync
20:50:59 [2021-06-06T20:50:59.018Z] + /usr/bin/echo 3
20:52:20 [2021-06-06T20:52:20.388Z] 
20:52:20 [2021-06-06T20:52:20.389Z] queries/21.sql
20:52:20 [2021-06-06T20:52:20.389Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:52:20 [2021-06-06T20:52:20.389Z] Projection_26	100.00	100	root		time:1m19.3s, loops:2, Concurrency:OFF	tpch50.supplier.s_name, Column#72	4.62 KB	N/A
20:52:20 [2021-06-06T20:52:20.389Z] └─TopN_29	100.00	100	root		time:1m19.3s, loops:2	Column#72:desc, tpch50.supplier.s_name, offset:0, count:100	55.9 KB	N/A
20:52:20 [2021-06-06T20:52:20.389Z]   └─HashAgg_34	12800.00	20057	root		time:1m19.3s, loops:21, partial_worker:{wall_time:1m19.311705609s, concurrency:5, task_num:197, tot_wait:6m36.267166595s, tot_exec:277.50103ms, tot_time:6m36.557390325s, max:1m19.311680253s, p95:1m19.311680253s}, final_worker:{wall_time:1m19.327613118s, concurrency:5, task_num:25, tot_wait:6m36.556939499s, tot_exec:72.215962ms, tot_time:6m36.629167531s, max:1m19.327600075s, p95:1m19.327600075s}	group by:tpch50.supplier.s_name, funcs:count(1)->Column#72, funcs:firstrow(tpch50.supplier.s_name)->tpch50.supplier.s_name	17.2 MB	N/A
20:52:20 [2021-06-06T20:52:20.389Z]     └─IndexHashJoin_42	7828961.66	198698	root		time:1m19.3s, loops:198, inner:{total:2m17.8s, concurrency:5, task:146, construct:6.51s, fetch:1m55s, build:1.32s, join:16.3s}	anti semi join, inner:IndexLookUp_39, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey)	641.0 MB	N/A
20:52:20 [2021-06-06T20:52:20.389Z]       ├─IndexHashJoin_83(Build)	9786202.08	3542799	root		time:1m18.8s, loops:3463, inner:{total:2m23.2s, concurrency:5, task:152, construct:7.4s, fetch:1m58s, build:1.16s, join:17.7s}	semi join, inner:IndexLookUp_80, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey), ne(tpch50.lineitem.l_suppkey, tpch50.supplier.s_suppkey)	555.9 MB	N/A
20:52:20 [2021-06-06T20:52:20.389Z]       │ ├─IndexJoin_99(Build)	12232752.60	3675878	root		time:1m18.3s, loops:3595, inner:{total:2m6s, concurrency:5, task:305, construct:16.2s, fetch:1m47.9s, build:1.9s}, probe:4.99s	inner join, inner:TableReader_95, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.orders.o_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.orders.o_orderkey)	575.3 MB	N/A
20:52:20 [2021-06-06T20:52:20.389Z]       │ │ ├─HashJoin_107(Build)	12232752.60	7609895	root		time:1m17.9s, loops:7436, build_hash_table:{total:1.05s, fetch:1.04s, build:6.65ms}, probe:{concurrency:5, total:6m30.9s, max:1m18.2s, probe:1m0.1s, fetch:5m30.8s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.lineitem.l_suppkey)]	757.3 KB	0 Bytes
20:52:20 [2021-06-06T20:52:20.389Z]       │ │ │ ├─HashJoin_120(Build)	20000.00	20058	root		time:1.05s, loops:23, build_hash_table:{total:173µs, fetch:166.8µs, build:6.18µs}, probe:{concurrency:5, total:5.24s, max:1.05s, probe:68.8ms, fetch:5.17s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:52:20 [2021-06-06T20:52:20.389Z]       │ │ │ │ ├─TableReader_125(Build)	1.00	1	root		time:42.8µ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:52:20 [2021-06-06T20:52:20.389Z]       │ │ │ │ │ └─Selection_124	1.00	1	cop[tikv]		tikv_task:{time:1ms, loops:1}, scan_detail: {total_process_keys: 25, total_keys: 26, rocksdb: {delete_skipped_count: 0, key_skipped_count: 46, block: {cache_hit_count: 17, read_count: 1, read_byte: 23.8 KB}}}	eq(tpch50.nation.n_name, "EGYPT")	N/A	N/A
20:52:20 [2021-06-06T20:52:20.389Z]       │ │ │ │ │   └─TableFullScan_123	25.00	25	cop[tikv]	table:nation	tikv_task:{time:1ms, loops:1}	keep order:false	N/A	N/A
20:52:20 [2021-06-06T20:52:20.389Z]       │ │ │ │ └─TableReader_122(Probe)	500000.00	500000	root		time:1.03s, loops:490, cop_task: {num: 1, max: 1.04s, proc_keys: 500000, tot_proc: 1.01s, rpc_num: 1, rpc_time: 1.04s, copr_cache: disabled}	data:TableFullScan_121	20.0 MB	N/A
20:52:20 [2021-06-06T20:52:20.389Z]       │ │ │ │   └─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:52:20 [2021-06-06T20:52:20.389Z]       │ │ │ └─TableReader_128(Probe)	240004648.80	189670348	root		time:1m5.7s, loops:184597, cop_task: {num: 761, max: 2.51s, min: 345ms, avg: 1.5s, p95: 1.95s, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 17m49.3s, tot_wait: 59.1s, rpc_num: 761, rpc_time: 19m1.4s, copr_cache: disabled}	data:Selection_127	109.4 MB	N/A
20:52:20 [2021-06-06T20:52:20.389Z]       │ │ │   └─Selection_127	240004648.80	189670348	cop[tikv]		tikv_task:{proc max:1.31s, min:331ms, p80:1.17s, p95:1.21s, iters:296606, tasks:761}, scan_detail: {total_process_keys: 300005811, total_keys: 300006572, rocksdb: {delete_skipped_count: 0, key_skipped_count: 600010861, block: {cache_hit_count: 10458, read_count: 1114190, read_byte: 23.6 GB}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:52:20 [2021-06-06T20:52:20.389Z]       │ │ │     └─TableFullScan_126	300005811.00	300005811	cop[tikv]	table:l1	tikv_task:{proc max:1.22s, min:312ms, p80:1.08s, p95:1.12s, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:52:20 [2021-06-06T20:52:20.389Z]       │ │ └─TableReader_95(Probe)	0.49	3496187	root		time:1m39.1s, loops:3875, cop_task: {num: 5246, max: 565.2ms, min: 1.82ms, avg: 175.6ms, p95: 337ms, max_proc_keys: 3770, p95_proc_keys: 1961, tot_proc: 11m6.1s, tot_wait: 3m36.8s, rpc_num: 5246, rpc_time: 15m21.2s, copr_cache: disabled}	data:Selection_94	N/A	N/A
20:52:20 [2021-06-06T20:52:20.389Z]       │ │   └─Selection_94	0.49	3496187	cop[tikv]		tikv_task:{proc max:161ms, min:0s, p80:68ms, p95:81ms, iters:30187, tasks:5246}, scan_detail: {total_process_keys: 7236273, total_keys: 7795514, rocksdb: {delete_skipped_count: 0, key_skipped_count: 1778447, block: {cache_hit_count: 54006328, read_count: 218181, read_byte: 4.21 GB}}}	eq(tpch50.orders.o_orderstatus, "F")	N/A	N/A
20:52:20 [2021-06-06T20:52:20.389Z]       │ │     └─TableRangeScan_93	1.00	7236273	cop[tikv]	table:orders	tikv_task:{proc max:161ms, min:0s, p80:67ms, p95:80ms, iters:30187, tasks:5246}	range: decided by [tpch50.lineitem.l_orderkey], keep order:false	N/A	N/A
20:52:20 [2021-06-06T20:52:20.389Z]       │ └─IndexLookUp_80(Probe)	4.05	17316407	root		time:1m53s, loops:17129, index_task: {total_time: 1m2.2s, fetch_handle: 53.8s, build: 3.41ms, wait: 8.41s}, table_task: {total_time: 8m9.8s, num: 1458, concurrency: 760}		19.1 KB	N/A
20:52:20 [2021-06-06T20:52:20.389Z]       │   ├─IndexRangeScan_78(Build)	4.05	17316407	cop[tikv]	table:l2, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:51.6s, loops:18658, cop_task: {num: 2981, max: 622.5ms, min: 451.6µs, avg: 180.4ms, p95: 360.8ms, max_proc_keys: 12489, p95_proc_keys: 8742, tot_proc: 6m41.9s, tot_wait: 1m54.6s, rpc_num: 2981, rpc_time: 8m57.8s, copr_cache: disabled}, tikv_task:{proc max:174ms, min:0s, p80:94ms, p95:109ms, iters:30142, tasks:2981}, scan_detail: {total_process_keys: 17316407, total_keys: 20812503, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17316407, block: {cache_hit_count: 24259921, 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:52:20 [2021-06-06T20:52:20.389Z]       │   └─TableRowIDScan_79(Probe)	4.05	17316407	cop[tikv]	table:l2	time:6m2.1s, loops:21018, cop_task: {num: 7821, max: 646.5ms, min: 487.2µs, avg: 169.7ms, p95: 349.6ms, max_proc_keys: 12685, p95_proc_keys: 4843, tot_proc: 15m55.1s, tot_wait: 5m21s, rpc_num: 7821, rpc_time: 22m6.9s, copr_cache: disabled}, tikv_task:{proc max:210ms, min:0s, p80:101ms, p95:136ms, iters:49981, tasks:7821}, scan_detail: {total_process_keys: 17316407, total_keys: 18289164, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5627619, block: {cache_hit_count: 99021378, read_count: 1114, read_byte: 385.3 MB}}}	keep order:false	N/A	N/A
20:52:20 [2021-06-06T20:52:20.389Z]       └─IndexLookUp_39(Probe)	4.05	12022746	root		time:1m50.2s, loops:11953, index_task: {total_time: 58.3s, fetch_handle: 48.6s, build: 3.4ms, wait: 9.67s}, table_task: {total_time: 7m53.1s, num: 1408, concurrency: 730}		216.6 KB	N/A
20:52:20 [2021-06-06T20:52:20.389Z]         ├─IndexRangeScan_36(Build)	5.06	17183320	cop[tikv]	table:l3, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:46.4s, loops:18342, cop_task: {num: 2761, max: 734.8ms, min: 701µs, avg: 163.2ms, p95: 348.4ms, max_proc_keys: 20314, p95_proc_keys: 13621, tot_proc: 5m36s, tot_wait: 1m35s, rpc_num: 2761, rpc_time: 7m30.4s, copr_cache: disabled}, tikv_task:{proc max:222ms, min:0s, p80:77ms, p95:117ms, iters:29024, tasks:2761}, scan_detail: {total_process_keys: 17183320, total_keys: 20546336, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17183320, 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:20 [2021-06-06T20:52:20.389Z]         └─Selection_38(Probe)	4.05	12022746	cop[tikv]		time:6m4.4s, loops:13770, cop_task: {num: 10301, max: 708.7ms, min: 1.35ms, avg: 168.2ms, p95: 341.6ms, max_proc_keys: 6973, p95_proc_keys: 3907, tot_proc: 20m12.6s, tot_wait: 7m33.5s, rpc_num: 10301, rpc_time: 28m52s, copr_cache: disabled}, tikv_task:{proc max:201ms, min:0s, p80:74ms, p95:112ms, iters:60892, tasks:10301}, scan_detail: {total_process_keys: 17183320, total_keys: 18127904, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5524028, block: {cache_hit_count: 98284927, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:52:20 [2021-06-06T20:52:20.389Z]           └─TableRowIDScan_37	5.06	17183320	cop[tikv]	table:l3	tikv_task:{proc max:199ms, min:0s, p80:73ms, p95:111ms, iters:60892, tasks:10301}	keep order:false	N/A	N/A
20:52:20 [2021-06-06T20:52:20.389Z] + sync
20:52:20 [2021-06-06T20:52:20.389Z] + /usr/bin/echo 3
20:53:41 [2021-06-06T20:53:41.760Z] 
20:53:41 [2021-06-06T20:53:41.760Z] queries/21.sql
20:53:41 [2021-06-06T20:53:41.760Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:53:41 [2021-06-06T20:53:41.760Z] Projection_26	100.00	100	root		time:1m19.7s, loops:2, Concurrency:OFF	tpch50.supplier.s_name, Column#72	4.62 KB	N/A
20:53:41 [2021-06-06T20:53:41.760Z] └─TopN_29	100.00	100	root		time:1m19.7s, loops:2	Column#72:desc, tpch50.supplier.s_name, offset:0, count:100	58.4 KB	N/A
20:53:41 [2021-06-06T20:53:41.760Z]   └─HashAgg_34	12800.00	20057	root		time:1m19.7s, loops:21, partial_worker:{wall_time:1m19.731364996s, concurrency:5, task_num:198, tot_wait:6m38.393895744s, tot_exec:250.56731ms, tot_time:6m38.655969298s, max:1m19.731302969s, p95:1m19.731302969s}, final_worker:{wall_time:1m19.74747914s, concurrency:5, task_num:25, tot_wait:6m38.65560618s, tot_exec:69.821591ms, tot_time:6m38.725440277s, max:1m19.747438009s, p95:1m19.747438009s}	group by:tpch50.supplier.s_name, funcs:count(1)->Column#72, funcs:firstrow(tpch50.supplier.s_name)->tpch50.supplier.s_name	17.2 MB	N/A
20:53:41 [2021-06-06T20:53:41.760Z]     └─IndexHashJoin_42	7828961.66	198698	root		time:1m19.7s, loops:199, inner:{total:2m13.3s, concurrency:5, task:146, construct:6.16s, fetch:1m50.9s, build:1.15s, join:16.2s}	anti semi join, inner:IndexLookUp_39, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey)	641.1 MB	N/A
20:53:41 [2021-06-06T20:53:41.760Z]       ├─IndexHashJoin_83(Build)	9786202.08	3542799	root		time:1m19.2s, loops:3463, inner:{total:2m24.2s, concurrency:5, task:152, construct:7.5s, fetch:1m59.3s, build:1.27s, join:17.4s}	semi join, inner:IndexLookUp_80, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey), ne(tpch50.lineitem.l_suppkey, tpch50.supplier.s_suppkey)	555.9 MB	N/A
20:53:41 [2021-06-06T20:53:41.760Z]       │ ├─IndexJoin_99(Build)	12232752.60	3675878	root		time:1m18.7s, loops:3595, inner:{total:2m4.3s, concurrency:5, task:305, construct:16.5s, fetch:1m45.9s, build:1.87s}, probe:5.12s	inner join, inner:TableReader_95, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.orders.o_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.orders.o_orderkey)	575.5 MB	N/A
20:53:41 [2021-06-06T20:53:41.760Z]       │ │ ├─HashJoin_107(Build)	12232752.60	7609895	root		time:1m18.2s, loops:7435, build_hash_table:{total:1.08s, fetch:1.08s, build:5.89ms}, probe:{concurrency:5, total:6m33.1s, max:1m18.6s, probe:1m2.1s, fetch:5m31s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.lineitem.l_suppkey)]	757.3 KB	0 Bytes
20:53:41 [2021-06-06T20:53:41.760Z]       │ │ │ ├─HashJoin_120(Build)	20000.00	20058	root		time:1.08s, loops:23, build_hash_table:{total:220.7µs, fetch:215.2µs, build:5.43µs}, probe:{concurrency:5, total:5.4s, max:1.08s, probe:64.1ms, fetch:5.34s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:53:41 [2021-06-06T20:53:41.760Z]       │ │ │ │ ├─TableReader_125(Build)	1.00	1	root		time:43.4µs, loops:2, cop_task: {num: 1, max: 1.32ms, proc_keys: 25, rpc_num: 1, rpc_time: 1.28ms, copr_cache: disabled}	data:Selection_124	244 Bytes	N/A
20:53:41 [2021-06-06T20:53:41.760Z]       │ │ │ │ │ └─Selection_124	1.00	1	cop[tikv]		tikv_task:{time:0s, loops:1}, scan_detail: {total_process_keys: 25, total_keys: 26, rocksdb: {delete_skipped_count: 0, key_skipped_count: 46, block: {cache_hit_count: 17, read_count: 1, read_byte: 23.8 KB}}}	eq(tpch50.nation.n_name, "EGYPT")	N/A	N/A
20:53:41 [2021-06-06T20:53:41.760Z]       │ │ │ │ │   └─TableFullScan_123	25.00	25	cop[tikv]	table:nation	tikv_task:{time:0s, loops:1}	keep order:false	N/A	N/A
20:53:41 [2021-06-06T20:53:41.760Z]       │ │ │ │ └─TableReader_122(Probe)	500000.00	500000	root		time:1.07s, loops:490, cop_task: {num: 1, max: 1.07s, proc_keys: 500000, tot_proc: 1.03s, rpc_num: 1, rpc_time: 1.07s, copr_cache: disabled}	data:TableFullScan_121	20.0 MB	N/A
20:53:41 [2021-06-06T20:53:41.760Z]       │ │ │ │   └─TableFullScan_121	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:962ms, loops:493}, scan_detail: {total_process_keys: 500000, total_keys: 500001, rocksdb: {delete_skipped_count: 0, key_skipped_count: 999999, block: {cache_hit_count: 13, read_count: 1679, read_byte: 104.5 MB}}}	keep order:false	N/A	N/A
20:53:41 [2021-06-06T20:53:41.760Z]       │ │ │ └─TableReader_128(Probe)	240004648.80	189670348	root		time:1m5.6s, loops:184596, cop_task: {num: 761, max: 2.35s, min: 308.7ms, avg: 1.5s, p95: 1.91s, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 17m52.7s, tot_wait: 58.8s, rpc_num: 761, rpc_time: 19m5.1s, copr_cache: disabled}	data:Selection_127	109.4 MB	N/A
20:53:41 [2021-06-06T20:53:41.760Z]       │ │ │   └─Selection_127	240004648.80	189670348	cop[tikv]		tikv_task:{proc max:1.29s, min:295ms, p80:1.17s, 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: 10457, read_count: 1114191, read_byte: 23.6 GB}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:53:41 [2021-06-06T20:53:41.760Z]       │ │ │     └─TableFullScan_126	300005811.00	300005811	cop[tikv]	table:l1	tikv_task:{proc max:1.21s, min:279ms, p80:1.08s, p95:1.13s, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:53:41 [2021-06-06T20:53:41.760Z]       │ │ └─TableReader_95(Probe)	0.49	3496191	root		time:1m37s, loops:3875, cop_task: {num: 5240, max: 522.6ms, min: 667.1µs, avg: 174.6ms, p95: 326.4ms, max_proc_keys: 3869, p95_proc_keys: 1983, tot_proc: 11m3.3s, tot_wait: 3m34.2s, rpc_num: 5240, rpc_time: 15m14.9s, copr_cache: disabled}	data:Selection_94	N/A	N/A
20:53:41 [2021-06-06T20:53:41.760Z]       │ │   └─Selection_94	0.49	3496191	cop[tikv]		tikv_task:{proc max:169ms, min:0s, p80:68ms, p95:81ms, iters:30187, tasks:5240}, scan_detail: {total_process_keys: 7236271, total_keys: 7795476, rocksdb: {delete_skipped_count: 0, key_skipped_count: 1778263, block: {cache_hit_count: 54006847, read_count: 218171, read_byte: 4.21 GB}}}	eq(tpch50.orders.o_orderstatus, "F")	N/A	N/A
20:53:41 [2021-06-06T20:53:41.760Z]       │ │     └─TableRangeScan_93	1.00	7236271	cop[tikv]	table:orders	tikv_task:{proc max:169ms, min:0s, p80:67ms, p95:80ms, iters:30187, tasks:5240}	range: decided by [tpch50.lineitem.l_orderkey], keep order:false	N/A	N/A
20:53:41 [2021-06-06T20:53:41.760Z]       │ └─IndexLookUp_80(Probe)	4.05	17316426	root		time:1m53.8s, loops:17128, index_task: {total_time: 1m1.9s, fetch_handle: 53.1s, build: 3.5ms, wait: 8.84s}, table_task: {total_time: 8m9.7s, num: 1458, concurrency: 760}		19.2 KB	N/A
20:53:41 [2021-06-06T20:53:41.760Z]       │   ├─IndexRangeScan_78(Build)	4.05	17316426	cop[tikv]	table:l2, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:50.8s, loops:18624, cop_task: {num: 2981, max: 658ms, min: 453.6µs, avg: 174ms, p95: 349ms, max_proc_keys: 13411, p95_proc_keys: 8764, tot_proc: 6m31.2s, tot_wait: 1m47.1s, rpc_num: 2981, rpc_time: 8m38.7s, copr_cache: disabled}, tikv_task:{proc max:156ms, min:0s, p80:94ms, p95:109ms, iters:30142, tasks:2981}, scan_detail: {total_process_keys: 17316426, total_keys: 20812526, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17316426, block: {cache_hit_count: 24259942, read_count: 225685, read_byte: 2.00 GB}}}	range: decided by [eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey)], keep order:false	N/A	N/A
20:53:41 [2021-06-06T20:53:41.760Z]       │   └─TableRowIDScan_79(Probe)	4.05	17316426	cop[tikv]	table:l2	time:6m5.8s, loops:21026, cop_task: {num: 7803, max: 648.1ms, min: 534.8µs, avg: 171.5ms, p95: 350.5ms, max_proc_keys: 12919, p95_proc_keys: 4837, tot_proc: 16m4.4s, tot_wait: 5m23.7s, rpc_num: 7803, rpc_time: 22m18.3s, copr_cache: disabled}, tikv_task:{proc max:263ms, min:0s, p80:103ms, p95:138ms, iters:49871, tasks:7803}, scan_detail: {total_process_keys: 17316426, total_keys: 18289092, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5627370, block: {cache_hit_count: 99021481, read_count: 1117, read_byte: 398.0 MB}}}	keep order:false	N/A	N/A
20:53:41 [2021-06-06T20:53:41.760Z]       └─IndexLookUp_39(Probe)	4.05	12022769	root		time:1m46.2s, loops:11944, index_task: {total_time: 57.5s, fetch_handle: 47.8s, build: 3.49ms, wait: 9.7s}, table_task: {total_time: 7m40s, num: 1408, concurrency: 730}		274.8 KB	N/A
20:53:41 [2021-06-06T20:53:41.760Z]         ├─IndexRangeScan_36(Build)	5.06	17183355	cop[tikv]	table:l3, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:45.6s, loops:18366, cop_task: {num: 2732, max: 639.8ms, min: 825.4µs, avg: 161.8ms, p95: 359.4ms, max_proc_keys: 17823, p95_proc_keys: 13893, tot_proc: 5m29.5s, tot_wait: 1m32.6s, rpc_num: 2732, rpc_time: 7m22.1s, copr_cache: disabled}, tikv_task:{proc max:177ms, min:0s, p80:78ms, p95:119ms, iters:28914, tasks:2732}, scan_detail: {total_process_keys: 17183355, total_keys: 20546378, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17183355, 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:53:41 [2021-06-06T20:53:41.760Z]         └─Selection_38(Probe)	4.05	12022769	cop[tikv]		time:5m53.8s, loops:13770, cop_task: {num: 10224, max: 637.3ms, min: 462.4µs, avg: 163.6ms, p95: 329.8ms, max_proc_keys: 7073, p95_proc_keys: 3991, tot_proc: 19m32.3s, tot_wait: 7m14.9s, rpc_num: 10224, rpc_time: 27m52.9s, copr_cache: disabled}, tikv_task:{proc max:272ms, min:0s, p80:75ms, p95:114ms, iters:60639, tasks:10224}, scan_detail: {total_process_keys: 17183355, total_keys: 18128442, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5526103, block: {cache_hit_count: 98285724, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:53:41 [2021-06-06T20:53:41.760Z]           └─TableRowIDScan_37	5.06	17183355	cop[tikv]	table:l3	tikv_task:{proc max:270ms, min:0s, p80:74ms, p95:114ms, iters:60639, tasks:10224}	keep order:false	N/A	N/A
20:53:41 [2021-06-06T20:53:41.760Z] + tiup cluster stop benchbot -y
20:53:41 [2021-06-06T20:53:41.760Z] Starting component `cluster`: /home/tidb/.tiup/components/cluster/v1.4.4/tiup-cluster stop benchbot -y
20:53:49 [2021-06-06T20:53:49.836Z] + rm -rf '/data1/tidb-deploy/*/log/*'
20:53:49 [2021-06-06T20:53:49.836Z] + rm -rf /data1/jenkins/deploy/data/tikv-20160
20:53:53 [2021-06-06T20:53:53.095Z] + rm -rf /data1/jenkins/deploy/data/pd-2379
20:53:53 [2021-06-06T20:53:53.095Z] + rm -rf /data1/jenkins/restore_data/tpch50/data/last_tikv.toml
20:53:53 [2021-06-06T20:53:53.095Z] + cp -R /data1/jenkins/restore_data/tpch50/data /data1/jenkins/deploy/data/tikv-20160
20:55:44 [2021-06-06T20:55:44.455Z] + cp -R /data1/jenkins/restore_data/tpch50/data.pd /data1/jenkins/deploy/data/pd-2379
20:55:44 [2021-06-06T20:55:44.455Z] + '[' -n '' ']'
20:55:44 [2021-06-06T20:55:44.455Z] + tiup cluster start benchbot --wait-timeout=300
20:55:44 [2021-06-06T20:55:44.455Z] Starting component `cluster`: /home/tidb/.tiup/components/cluster/v1.4.4/tiup-cluster start benchbot --wait-timeout=300
20:56:06 [2021-06-06T20:56:06.388Z] + sync
20:56:06 [2021-06-06T20:56:06.388Z] + /usr/bin/echo 3
20:56:45 [2021-06-06T20:56:45.029Z] + sync
20:56:45 [2021-06-06T20:56:45.029Z] + /usr/bin/echo 3
20:57:11 [2021-06-06T20:57:11.504Z] + sync
20:57:11 [2021-06-06T20:57:11.504Z] + /usr/bin/echo 3
20:57:43 [2021-06-06T20:57:43.516Z] 
20:57:43 [2021-06-06T20:57:43.516Z] queries/22.sql
20:57:43 [2021-06-06T20:57:43.516Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:57:43 [2021-06-06T20:57:43.516Z] Sort_39	1600000.00	4	root		time:25.6s, loops:2	Column#27	9.48 KB	0 Bytes
20:57:43 [2021-06-06T20:57:43.516Z] └─Projection_41	1600000.00	4	root		time:25.6s, loops:5, Concurrency:5	Column#27, Column#28, Column#29	23.7 KB	N/A
20:57:43 [2021-06-06T20:57:43.516Z]   └─HashAgg_42	1600000.00	4	root		time:25.6s, loops:5, partial_worker:{wall_time:25.582286008s, concurrency:5, task_num:180, tot_wait:2m7.853645728s, tot_exec:56.402434ms, tot_time:2m7.910174916s, max:25.582171722s, p95:25.582171722s}, final_worker:{wall_time:25.582303755s, concurrency:5, task_num:20, tot_wait:2m7.91053689s, tot_exec:433.545µs, tot_time:2m7.910978852s, max:25.58220364s, p95:25.58220364s}	group by:Column#33, funcs:count(1)->Column#28, funcs:sum(Column#31)->Column#29, funcs:firstrow(Column#32)->Column#27	857.7 KB	N/A
20:57:43 [2021-06-06T20:57:43.516Z]     └─Projection_51	1600000.00	181704	root		time:25.6s, loops:181, Concurrency:5	tpch50.customer.c_acctbal, substring(tpch50.customer.c_phone, 1, 2)->Column#32, substring(tpch50.customer.c_phone, 1, 2)->Column#33	693.6 KB	N/A
20:57:43 [2021-06-06T20:57:43.516Z]       └─HashJoin_43	1600000.00	181704	root		time:25.6s, loops:181, build_hash_table:{total:23.9s, fetch:1.05s, build:22.8s}, probe:{concurrency:5, total:2m7.9s, max:25.6s, probe:6.68s, fetch:2m1.2s}	anti semi join, equal:[eq(tpch50.customer.c_custkey, tpch50.orders.o_custkey)]	590.2 MB	0 Bytes
20:57:43 [2021-06-06T20:57:43.516Z]         ├─TableReader_49(Build)	75000000.00	75000000	root		time:1.04s, loops:73364, cop_task: {num: 153, max: 989.1ms, min: 276.2ms, avg: 580.4ms, p95: 864.5ms, max_proc_keys: 723875, p95_proc_keys: 553332, tot_proc: 1m28s, tot_wait: 37ms, rpc_num: 153, rpc_time: 1m28.8s, copr_cache: disabled}	data:TableFullScan_48	54.1 MB	N/A
20:57:43 [2021-06-06T20:57:43.516Z]         │ └─TableFullScan_48	75000000.00	75000000	cop[tikv]	table:orders	tikv_task:{proc max:962ms, min:263ms, p80:584ms, p95:822ms, 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: 3026, read_count: 219939, read_byte: 4.30 GB}}}	keep order:false	N/A	N/A
20:57:43 [2021-06-06T20:57:43.516Z]         └─Selection_47(Probe)	2000000.00	545246	root		time:1.53s, loops:534	in(substring(tpch50.customer.c_phone, 1, 2), "20", "40", "22", "30", "39", "42", "21")	94.6 KB	N/A
20:57:43 [2021-06-06T20:57:43.516Z]           └─TableReader_46	2000000.00	3407619	root		time:600.1ms, loops:3319, cop_task: {num: 18, max: 1.15s, min: 365.5ms, avg: 763.4ms, p95: 1.15s, max_proc_keys: 582617, p95_proc_keys: 582617, tot_proc: 13.3s, tot_wait: 2ms, rpc_num: 18, rpc_time: 13.7s, copr_cache: disabled}	data:Selection_45	192.5 MB	N/A
20:57:43 [2021-06-06T20:57:43.516Z]             └─Selection_45	2000000.00	3407619	cop[tikv]		tikv_task:{proc max:1.07s, min:337ms, p80:826ms, 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
20:57:43 [2021-06-06T20:57:43.517Z]               └─TableFullScan_44	7500000.00	7500000	cop[tikv]	table:customer	tikv_task:{proc max:965ms, min:304ms, p80:743ms, p95:965ms, iters:7404, tasks:18}	keep order:false	N/A	N/A
20:57:43 [2021-06-06T20:57:43.517Z] 
20:57:43 [2021-06-06T20:57:43.517Z] queries/22.sql
20:57:43 [2021-06-06T20:57:43.517Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:57:43 [2021-06-06T20:57:43.517Z] Sort_39	2186432.06	4	root		time:27s, loops:2	Column#27	9.48 KB	0 Bytes
20:57:43 [2021-06-06T20:57:43.517Z] └─Projection_41	2186432.06	4	root		time:27s, loops:5, Concurrency:5	Column#27, Column#28, Column#29	23.7 KB	N/A
20:57:43 [2021-06-06T20:57:43.517Z]   └─HashAgg_42	2186432.06	4	root		time:27s, loops:5, partial_worker:{wall_time:26.978881116s, concurrency:5, task_num:180, tot_wait:2m14.840384456s, tot_exec:52.80702ms, tot_time:2m14.893362775s, max:26.978746564s, p95:26.978746564s}, final_worker:{wall_time:26.978857582s, concurrency:5, task_num:20, tot_wait:2m14.893652579s, tot_exec:301.691µs, tot_time:2m14.893975759s, max:26.978807991s, p95:26.978807991s}	group by:Column#33, funcs:count(1)->Column#28, funcs:sum(Column#31)->Column#29, funcs:firstrow(Column#32)->Column#27	857.7 KB	N/A
20:57:43 [2021-06-06T20:57:43.517Z]     └─Projection_51	2186432.06	181704	root		time:27s, loops:181, Concurrency:5	tpch50.customer.c_acctbal, substring(tpch50.customer.c_phone, 1, 2)->Column#32, substring(tpch50.customer.c_phone, 1, 2)->Column#33	693.6 KB	N/A
20:57:43 [2021-06-06T20:57:43.517Z]       └─HashJoin_43	2186432.06	181704	root		time:27s, loops:181, build_hash_table:{total:25.5s, fetch:1.06s, build:24.4s}, probe:{concurrency:5, total:2m14.9s, max:27s, probe:6.13s, fetch:2m8.7s}	anti semi join, equal:[eq(tpch50.customer.c_custkey, tpch50.orders.o_custkey)]	590.2 MB	0 Bytes
20:57:43 [2021-06-06T20:57:43.517Z]         ├─TableReader_49(Build)	75000000.00	75000000	root		time:1.08s, loops:73364, cop_task: {num: 153, max: 1.29s, min: 264.9ms, avg: 569.9ms, p95: 1.14s, max_proc_keys: 723875, p95_proc_keys: 553332, tot_proc: 1m26.4s, tot_wait: 34ms, rpc_num: 153, rpc_time: 1m27.2s, copr_cache: disabled}	data:TableFullScan_48	54.1 MB	N/A
20:57:43 [2021-06-06T20:57:43.517Z]         │ └─TableFullScan_48	75000000.00	75000000	cop[tikv]	table:orders	tikv_task:{proc max:1.27s, min:253ms, p80:623ms, p95:1.11s, iters:73975, tasks:153}, scan_detail: {total_process_keys: 75000000, total_keys: 75000153, rocksdb: {delete_skipped_count: 0, key_skipped_count: 149999847, block: {cache_hit_count: 220923, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:57:43 [2021-06-06T20:57:43.517Z]         └─Selection_47(Probe)	2733040.07	545246	root		time:1.69s, loops:534	in(substring(tpch50.customer.c_phone, 1, 2), "20", "40", "22", "30", "39", "42", "21")	94.6 KB	N/A
20:57:43 [2021-06-06T20:57:43.517Z]           └─TableReader_46	2733040.07	3407619	root		time:842.1ms, loops:3319, cop_task: {num: 18, max: 1.41s, min: 526.2ms, avg: 960.8ms, p95: 1.41s, max_proc_keys: 582617, p95_proc_keys: 582617, tot_proc: 16.8s, tot_wait: 2ms, rpc_num: 18, rpc_time: 17.3s, copr_cache: disabled}	data:Selection_45	192.5 MB	N/A
20:57:43 [2021-06-06T20:57:43.517Z]             └─Selection_45	2733040.07	3407619	cop[tikv]		tikv_task:{proc max:1.35s, min:477ms, p80:1.12s, p95:1.35s, iters:7404, tasks:18}, scan_detail: {total_process_keys: 7500000, total_keys: 7500018, rocksdb: {delete_skipped_count: 0, key_skipped_count: 14999982, block: {cache_hit_count: 28451, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.customer.c_acctbal, 5000.602894)	N/A	N/A
20:57:43 [2021-06-06T20:57:43.517Z]               └─TableFullScan_44	7500000.00	7500000	cop[tikv]	table:customer	tikv_task:{proc max:1.25s, min:432ms, p80:1.04s, p95:1.25s, iters:7404, tasks:18}	keep order:false	N/A	N/A
20:57:43 [2021-06-06T20:57:43.517Z] 
20:57:43 [2021-06-06T20:57:43.517Z] queries/22.sql
20:57:43 [2021-06-06T20:57:43.517Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:57:43 [2021-06-06T20:57:43.517Z] Sort_39	2186432.06	4	root		time:26.1s, loops:2	Column#27	9.48 KB	0 Bytes
20:57:43 [2021-06-06T20:57:43.517Z] └─Projection_41	2186432.06	4	root		time:26.1s, loops:5, Concurrency:5	Column#27, Column#28, Column#29	23.7 KB	N/A
20:57:43 [2021-06-06T20:57:43.517Z]   └─HashAgg_42	2186432.06	4	root		time:26.1s, loops:5, partial_worker:{wall_time:26.142303636s, concurrency:5, task_num:180, tot_wait:2m10.659205287s, tot_exec:51.494764ms, tot_time:2m10.710832389s, max:26.142273138s, p95:26.142273138s}, final_worker:{wall_time:26.14231057s, concurrency:5, task_num:20, tot_wait:2m10.711232432s, tot_exec:210.617µs, tot_time:2m10.711451359s, max:26.14229345s, p95:26.14229345s}	group by:Column#33, funcs:count(1)->Column#28, funcs:sum(Column#31)->Column#29, funcs:firstrow(Column#32)->Column#27	857.7 KB	N/A
20:57:43 [2021-06-06T20:57:43.517Z]     └─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	693.6 KB	N/A
20:57:43 [2021-06-06T20:57:43.517Z]       └─HashJoin_43	2186432.06	181704	root		time:26.1s, loops:181, build_hash_table:{total:24.7s, fetch:787.9ms, build:23.9s}, probe:{concurrency:5, total:2m10.7s, max:26.1s, probe:5.91s, fetch:2m4.8s}	anti semi join, equal:[eq(tpch50.customer.c_custkey, tpch50.orders.o_custkey)]	590.2 MB	0 Bytes
20:57:43 [2021-06-06T20:57:43.517Z]         ├─TableReader_49(Build)	75000000.00	75000000	root		time:827.4ms, loops:73364, cop_task: {num: 153, max: 1s, min: 239.8ms, avg: 494.5ms, p95: 894.1ms, max_proc_keys: 723875, p95_proc_keys: 553332, tot_proc: 1m14.9s, tot_wait: 45ms, rpc_num: 153, rpc_time: 1m15.6s, copr_cache: disabled}	data:TableFullScan_48	57.8 MB	N/A
20:57:43 [2021-06-06T20:57:43.517Z]         │ └─TableFullScan_48	75000000.00	75000000	cop[tikv]	table:orders	tikv_task:{proc max:973ms, min:217ms, p80:495ms, p95:858ms, iters:73975, tasks:153}, scan_detail: {total_process_keys: 75000000, total_keys: 75000153, rocksdb: {delete_skipped_count: 0, key_skipped_count: 149999847, block: {cache_hit_count: 220923, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:57:43 [2021-06-06T20:57:43.517Z]         └─Selection_47(Probe)	2733040.07	545246	root		time:1.42s, loops:534	in(substring(tpch50.customer.c_phone, 1, 2), "20", "40", "22", "30", "39", "42", "21")	94.6 KB	N/A
20:57:43 [2021-06-06T20:57:43.517Z]           └─TableReader_46	2733040.07	3407619	root		time:571.8ms, loops:3319, cop_task: {num: 18, max: 1.21s, min: 447.5ms, avg: 836.9ms, p95: 1.21s, max_proc_keys: 582617, p95_proc_keys: 582617, tot_proc: 14.7s, tot_wait: 2ms, rpc_num: 18, rpc_time: 15.1s, copr_cache: disabled}	data:Selection_45	192.5 MB	N/A
20:57:43 [2021-06-06T20:57:43.517Z]             └─Selection_45	2733040.07	3407619	cop[tikv]		tikv_task:{proc max:1.14s, min:417ms, p80:970ms, p95:1.14s, iters:7404, tasks:18}, scan_detail: {total_process_keys: 7500000, total_keys: 7500018, rocksdb: {delete_skipped_count: 0, key_skipped_count: 14999982, block: {cache_hit_count: 28451, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.customer.c_acctbal, 5000.602894)	N/A	N/A
20:57:43 [2021-06-06T20:57:43.517Z]               └─TableFullScan_44	7500000.00	7500000	cop[tikv]	table:customer	tikv_task:{proc max:1.05s, min:377ms, p80:894ms, p95:1.05s, iters:7404, tasks:18}	keep order:false	N/A	N/A
20:57:43 [2021-06-06T20:57:43.517Z] + sync
20:57:43 [2021-06-06T20:57:43.517Z] + /usr/bin/echo 3
20:58:10 [2021-06-06T20:58:10.008Z] + sync
20:58:10 [2021-06-06T20:58:10.008Z] + /usr/bin/echo 3
20:58:42 [2021-06-06T20:58:42.027Z] + sync
20:58:42 [2021-06-06T20:58:42.027Z] + /usr/bin/echo 3
20:59:08 [2021-06-06T20:59:08.519Z] 
20:59:08 [2021-06-06T20:59:08.519Z] queries/22.sql
20:59:08 [2021-06-06T20:59:08.519Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:59:08 [2021-06-06T20:59:08.519Z] Sort_39	2186432.06	4	root		time:25.7s, loops:2	Column#27	9.48 KB	0 Bytes
20:59:08 [2021-06-06T20:59:08.519Z] └─Projection_41	2186432.06	4	root		time:25.7s, loops:5, Concurrency:5	Column#27, Column#28, Column#29	23.7 KB	N/A
20:59:08 [2021-06-06T20:59:08.519Z]   └─HashAgg_42	2186432.06	4	root		time:25.7s, loops:5, partial_worker:{wall_time:25.678302008s, concurrency:5, task_num:180, tot_wait:2m8.330719669s, tot_exec:59.56853ms, tot_time:2m8.390430857s, max:25.678274324s, p95:25.678274324s}, final_worker:{wall_time:25.678323085s, concurrency:5, task_num:20, tot_wait:2m8.391275529s, tot_exec:239.915µs, tot_time:2m8.391524619s, max:25.67830826s, p95:25.67830826s}	group by:Column#33, funcs:count(1)->Column#28, funcs:sum(Column#31)->Column#29, funcs:firstrow(Column#32)->Column#27	857.7 KB	N/A
20:59:08 [2021-06-06T20:59:08.519Z]     └─Projection_51	2186432.06	181704	root		time:25.7s, loops:181, Concurrency:5	tpch50.customer.c_acctbal, substring(tpch50.customer.c_phone, 1, 2)->Column#32, substring(tpch50.customer.c_phone, 1, 2)->Column#33	693.6 KB	N/A
20:59:08 [2021-06-06T20:59:08.519Z]       └─HashJoin_43	2186432.06	181704	root		time:25.7s, loops:181, build_hash_table:{total:24.2s, fetch:872ms, build:23.3s}, probe:{concurrency:5, total:2m8.4s, max:25.7s, probe:5.84s, fetch:2m2.5s}	anti semi join, equal:[eq(tpch50.customer.c_custkey, tpch50.orders.o_custkey)]	590.2 MB	0 Bytes
20:59:08 [2021-06-06T20:59:08.519Z]         ├─TableReader_49(Build)	75000000.00	75000000	root		time:889.6ms, loops:73364, cop_task: {num: 153, max: 1.03s, min: 205.1ms, avg: 504.5ms, p95: 945.4ms, max_proc_keys: 723875, p95_proc_keys: 553332, tot_proc: 1m16.2s, tot_wait: 38ms, rpc_num: 153, rpc_time: 1m17.2s, copr_cache: disabled}	data:TableFullScan_48	57.8 MB	N/A
20:59:08 [2021-06-06T20:59:08.519Z]         │ └─TableFullScan_48	75000000.00	75000000	cop[tikv]	table:orders	tikv_task:{proc max:995ms, min:196ms, p80:492ms, p95:893ms, iters:73975, tasks:153}, scan_detail: {total_process_keys: 75000000, total_keys: 75000153, rocksdb: {delete_skipped_count: 0, key_skipped_count: 149999847, block: {cache_hit_count: 220923, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:59:08 [2021-06-06T20:59:08.519Z]         └─Selection_47(Probe)	2733040.07	545246	root		time:1.66s, loops:534	in(substring(tpch50.customer.c_phone, 1, 2), "20", "40", "22", "30", "39", "42", "21")	94.6 KB	N/A
20:59:08 [2021-06-06T20:59:08.519Z]           └─TableReader_46	2733040.07	3407619	root		time:760.7ms, loops:3319, cop_task: {num: 18, max: 1.29s, min: 507.4ms, avg: 905.6ms, p95: 1.29s, max_proc_keys: 582617, p95_proc_keys: 582617, tot_proc: 15.8s, tot_wait: 7ms, rpc_num: 18, rpc_time: 16.3s, copr_cache: disabled}	data:Selection_45	192.5 MB	N/A
20:59:08 [2021-06-06T20:59:08.519Z]             └─Selection_45	2733040.07	3407619	cop[tikv]		tikv_task:{proc max:1.21s, min:447ms, p80:1.08s, p95:1.21s, iters:7404, tasks:18}, scan_detail: {total_process_keys: 7500000, total_keys: 7500018, rocksdb: {delete_skipped_count: 0, key_skipped_count: 14999982, block: {cache_hit_count: 28451, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.customer.c_acctbal, 5000.602894)	N/A	N/A
20:59:08 [2021-06-06T20:59:08.519Z]               └─TableFullScan_44	7500000.00	7500000	cop[tikv]	table:customer	tikv_task:{proc max:1.12s, min:405ms, p80:998ms, p95:1.12s, iters:7404, tasks:18}	keep order:false	N/A	N/A
20:59:08 [2021-06-06T20:59:08.519Z] 
20:59:08 [2021-06-06T20:59:08.519Z] queries/22.sql
20:59:08 [2021-06-06T20:59:08.519Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:59:08 [2021-06-06T20:59:08.519Z] Sort_39	2186432.06	4	root		time:24.7s, loops:2	Column#27	9.48 KB	0 Bytes
20:59:08 [2021-06-06T20:59:08.519Z] └─Projection_41	2186432.06	4	root		time:24.7s, loops:5, Concurrency:5	Column#27, Column#28, Column#29	23.7 KB	N/A
20:59:08 [2021-06-06T20:59:08.519Z]   └─HashAgg_42	2186432.06	4	root		time:24.7s, loops:5, partial_worker:{wall_time:24.732841437s, concurrency:5, task_num:180, tot_wait:2m3.607769243s, tot_exec:55.789336ms, tot_time:2m3.663699087s, max:24.732787527s, p95:24.732787527s}, final_worker:{wall_time:24.732839771s, concurrency:5, task_num:20, tot_wait:2m3.663828125s, tot_exec:194.037µs, tot_time:2m3.664030185s, max:24.732813668s, p95:24.732813668s}	group by:Column#33, funcs:count(1)->Column#28, funcs:sum(Column#31)->Column#29, funcs:firstrow(Column#32)->Column#27	857.7 KB	N/A
20:59:08 [2021-06-06T20:59:08.519Z]     └─Projection_51	2186432.06	181704	root		time:24.7s, loops:181, Concurrency:5	tpch50.customer.c_acctbal, substring(tpch50.customer.c_phone, 1, 2)->Column#32, substring(tpch50.customer.c_phone, 1, 2)->Column#33	693.6 KB	N/A
20:59:08 [2021-06-06T20:59:08.519Z]       └─HashJoin_43	2186432.06	181704	root		time:24.7s, loops:181, build_hash_table:{total:23.3s, fetch:1.05s, build:22.3s}, probe:{concurrency:5, total:2m3.6s, max:24.7s, probe:5.53s, fetch:1m58.1s}	anti semi join, equal:[eq(tpch50.customer.c_custkey, tpch50.orders.o_custkey)]	590.2 MB	0 Bytes
20:59:08 [2021-06-06T20:59:08.519Z]         ├─TableReader_49(Build)	75000000.00	75000000	root		time:1.05s, loops:73364, cop_task: {num: 153, max: 1.07s, min: 207ms, avg: 509.3ms, p95: 927.9ms, max_proc_keys: 723875, p95_proc_keys: 553332, tot_proc: 1m17.2s, tot_wait: 47ms, rpc_num: 153, rpc_time: 1m17.9s, copr_cache: disabled}	data:TableFullScan_48	54.1 MB	N/A
20:59:08 [2021-06-06T20:59:08.519Z]         │ └─TableFullScan_48	75000000.00	75000000	cop[tikv]	table:orders	tikv_task:{proc max:1.04s, min:199ms, p80:511ms, p95:896ms, iters:73975, tasks:153}, scan_detail: {total_process_keys: 75000000, total_keys: 75000153, rocksdb: {delete_skipped_count: 0, key_skipped_count: 149999847, block: {cache_hit_count: 220923, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:59:08 [2021-06-06T20:59:08.519Z]         └─Selection_47(Probe)	2733040.07	545246	root		time:1.65s, loops:534	in(substring(tpch50.customer.c_phone, 1, 2), "20", "40", "22", "30", "39", "42", "21")	94.6 KB	N/A
20:59:08 [2021-06-06T20:59:08.519Z]           └─TableReader_46	2733040.07	3407619	root		time:739.7ms, loops:3319, cop_task: {num: 18, max: 1.21s, min: 549.1ms, avg: 873.1ms, p95: 1.21s, max_proc_keys: 582617, p95_proc_keys: 582617, tot_proc: 15.2s, tot_wait: 1ms, rpc_num: 18, rpc_time: 15.7s, copr_cache: disabled}	data:Selection_45	192.5 MB	N/A
20:59:08 [2021-06-06T20:59:08.519Z]             └─Selection_45	2733040.07	3407619	cop[tikv]		tikv_task:{proc max:1.12s, min:510ms, p80:1.05s, p95:1.12s, iters:7404, tasks:18}, scan_detail: {total_process_keys: 7500000, total_keys: 7500018, rocksdb: {delete_skipped_count: 0, key_skipped_count: 14999982, block: {cache_hit_count: 28451, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.customer.c_acctbal, 5000.602894)	N/A	N/A
20:59:08 [2021-06-06T20:59:08.519Z]               └─TableFullScan_44	7500000.00	7500000	cop[tikv]	table:customer	tikv_task:{proc max:1.03s, min:454ms, p80:961ms, p95:1.03s, iters:7404, tasks:18}	keep order:false	N/A	N/A
20:59:08 [2021-06-06T20:59:08.519Z] 
20:59:08 [2021-06-06T20:59:08.519Z] queries/22.sql
20:59:08 [2021-06-06T20:59:08.519Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:59:08 [2021-06-06T20:59:08.519Z] Sort_39	2186432.06	4	root		time:24.3s, loops:2	Column#27	9.48 KB	0 Bytes
20:59:08 [2021-06-06T20:59:08.519Z] └─Projection_41	2186432.06	4	root		time:24.3s, loops:5, Concurrency:5	Column#27, Column#28, Column#29	23.7 KB	N/A
20:59:08 [2021-06-06T20:59:08.519Z]   └─HashAgg_42	2186432.06	4	root		time:24.3s, loops:5, partial_worker:{wall_time:24.335104672s, concurrency:5, task_num:181, tot_wait:2m1.623659906s, tot_exec:51.321299ms, tot_time:2m1.675099271s, max:24.335088686s, p95:24.335088686s}, final_worker:{wall_time:24.335122759s, concurrency:5, task_num:20, tot_wait:2m1.675246332s, tot_exec:271.446µs, tot_time:2m1.675541514s, max:24.33511319s, p95:24.33511319s}	group by:Column#33, funcs:count(1)->Column#28, funcs:sum(Column#31)->Column#29, funcs:firstrow(Column#32)->Column#27	857.7 KB	N/A
20:59:08 [2021-06-06T20:59:08.519Z]     └─Projection_51	2186432.06	181704	root		time:24.3s, loops:182, Concurrency:5	tpch50.customer.c_acctbal, substring(tpch50.customer.c_phone, 1, 2)->Column#32, substring(tpch50.customer.c_phone, 1, 2)->Column#33	693.6 KB	N/A
20:59:08 [2021-06-06T20:59:08.519Z]       └─HashJoin_43	2186432.06	181704	root		time:24.3s, loops:182, build_hash_table:{total:23.1s, fetch:899.1ms, build:22.2s}, probe:{concurrency:5, total:2m1.7s, max:24.3s, probe:4.95s, fetch:1m56.7s}	anti semi join, equal:[eq(tpch50.customer.c_custkey, tpch50.orders.o_custkey)]	590.2 MB	0 Bytes
20:59:08 [2021-06-06T20:59:08.519Z]         ├─TableReader_49(Build)	75000000.00	75000000	root		time:890.7ms, loops:73364, cop_task: {num: 153, max: 953ms, min: 236.3ms, avg: 496.7ms, p95: 839.8ms, max_proc_keys: 723875, p95_proc_keys: 553332, tot_proc: 1m15.3s, tot_wait: 31ms, rpc_num: 153, rpc_time: 1m16s, copr_cache: disabled}	data:TableFullScan_48	57.8 MB	N/A
20:59:08 [2021-06-06T20:59:08.519Z]         │ └─TableFullScan_48	75000000.00	75000000	cop[tikv]	table:orders	tikv_task:{proc max:911ms, min:227ms, p80:533ms, p95:814ms, iters:73975, tasks:153}, scan_detail: {total_process_keys: 75000000, total_keys: 75000153, rocksdb: {delete_skipped_count: 0, key_skipped_count: 149999847, block: {cache_hit_count: 220923, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:59:08 [2021-06-06T20:59:08.519Z]         └─Selection_47(Probe)	2733040.07	545246	root		time:1.36s, loops:534	in(substring(tpch50.customer.c_phone, 1, 2), "20", "40", "22", "30", "39", "42", "21")	94.6 KB	N/A
20:59:08 [2021-06-06T20:59:08.519Z]           └─TableReader_46	2733040.07	3407619	root		time:553.8ms, loops:3319, cop_task: {num: 18, max: 1.13s, min: 430ms, avg: 851ms, p95: 1.13s, max_proc_keys: 582617, p95_proc_keys: 582617, tot_proc: 14.8s, rpc_num: 18, rpc_time: 15.3s, copr_cache: disabled}	data:Selection_45	192.5 MB	N/A
20:59:08 [2021-06-06T20:59:08.519Z]             └─Selection_45	2733040.07	3407619	cop[tikv]		tikv_task:{proc max:1.05s, min:404ms, p80:975ms, p95:1.05s, iters:7404, tasks:18}, scan_detail: {total_process_keys: 7500000, total_keys: 7500018, rocksdb: {delete_skipped_count: 0, key_skipped_count: 14999982, block: {cache_hit_count: 28451, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.customer.c_acctbal, 5000.602894)	N/A	N/A
20:59:08 [2021-06-06T20:59:08.519Z]               └─TableFullScan_44	7500000.00	7500000	cop[tikv]	table:customer	tikv_task:{proc max:954ms, min:384ms, p80:898ms, p95:954ms, iters:7404, tasks:18}	keep order:false	N/A	N/A
20:59:08 [2021-06-06T20:59:08.519Z] + sync
20:59:08 [2021-06-06T20:59:08.519Z] + /usr/bin/echo 3
20:59:40 [2021-06-06T20:59:40.735Z] 
20:59:40 [2021-06-06T20:59:40.735Z] queries/22.sql
20:59:40 [2021-06-06T20:59:40.735Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:59:40 [2021-06-06T20:59:40.735Z] Sort_39	2186432.06	4	root		time:23.9s, loops:2	Column#27	9.48 KB	0 Bytes
20:59:40 [2021-06-06T20:59:40.735Z] └─Projection_41	2186432.06	4	root		time:23.9s, loops:5, Concurrency:5	Column#27, Column#28, Column#29	23.7 KB	N/A
20:59:40 [2021-06-06T20:59:40.735Z]   └─HashAgg_42	2186432.06	4	root		time:23.9s, loops:5, partial_worker:{wall_time:23.937845272s, concurrency:5, task_num:180, tot_wait:1m59.637987603s, tot_exec:49.978325ms, tot_time:1m59.688118824s, max:23.937818575s, p95:23.937818575s}, final_worker:{wall_time:23.937863559s, concurrency:5, task_num:20, tot_wait:1m59.688978805s, tot_exec:242.132µs, tot_time:1m59.689229384s, max:23.937849404s, p95:23.937849404s}	group by:Column#33, funcs:count(1)->Column#28, funcs:sum(Column#31)->Column#29, funcs:firstrow(Column#32)->Column#27	857.7 KB	N/A
20:59:40 [2021-06-06T20:59:40.735Z]     └─Projection_51	2186432.06	181704	root		time:23.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	693.6 KB	N/A
20:59:40 [2021-06-06T20:59:40.735Z]       └─HashJoin_43	2186432.06	181704	root		time:23.9s, loops:181, build_hash_table:{total:22.7s, fetch:971.6ms, build:21.8s}, probe:{concurrency:5, total:1m59.7s, max:23.9s, probe:4.86s, fetch:1m54.8s}	anti semi join, equal:[eq(tpch50.customer.c_custkey, tpch50.orders.o_custkey)]	590.2 MB	0 Bytes
20:59:40 [2021-06-06T20:59:40.735Z]         ├─TableReader_49(Build)	75000000.00	75000000	root		time:940.6ms, loops:73364, cop_task: {num: 153, max: 954.3ms, min: 247.7ms, avg: 492.8ms, p95: 814.6ms, max_proc_keys: 723875, p95_proc_keys: 553332, tot_proc: 1m14.7s, tot_wait: 33ms, rpc_num: 153, rpc_time: 1m15.4s, copr_cache: disabled}	data:TableFullScan_48	57.8 MB	N/A
20:59:40 [2021-06-06T20:59:40.735Z]         │ └─TableFullScan_48	75000000.00	75000000	cop[tikv]	table:orders	tikv_task:{proc max:916ms, min:234ms, p80:487ms, p95:785ms, iters:73975, tasks:153}, scan_detail: {total_process_keys: 75000000, total_keys: 75000153, rocksdb: {delete_skipped_count: 0, key_skipped_count: 149999847, block: {cache_hit_count: 220923, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:59:40 [2021-06-06T20:59:40.735Z]         └─Selection_47(Probe)	2733040.07	545246	root		time:1.37s, loops:534	in(substring(tpch50.customer.c_phone, 1, 2), "20", "40", "22", "30", "39", "42", "21")	94.6 KB	N/A
20:59:40 [2021-06-06T20:59:40.735Z]           └─TableReader_46	2733040.07	3407619	root		time:567.3ms, loops:3319, cop_task: {num: 18, max: 1.22s, min: 463ms, avg: 888.6ms, p95: 1.22s, max_proc_keys: 582617, p95_proc_keys: 582617, tot_proc: 15.6s, tot_wait: 8ms, rpc_num: 18, rpc_time: 16s, copr_cache: disabled}	data:Selection_45	192.5 MB	N/A
20:59:40 [2021-06-06T20:59:40.735Z]             └─Selection_45	2733040.07	3407619	cop[tikv]		tikv_task:{proc max:1.13s, min:433ms, p80:992ms, 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
20:59:40 [2021-06-06T20:59:40.735Z]               └─TableFullScan_44	7500000.00	7500000	cop[tikv]	table:customer	tikv_task:{proc max:1.05s, min:387ms, p80:914ms, p95:1.05s, iters:7404, tasks:18}	keep order:false	N/A	N/A
20:59:40 [2021-06-06T20:59:40.735Z] 
20:59:40 [2021-06-06T20:59:40.735Z] + tiup cluster stop benchbot
20:59:40 [2021-06-06T20:59:40.735Z] Starting component `cluster`: /home/tidb/.tiup/components/cluster/v1.4.4/tiup-cluster stop benchbot
20:59:40 [2021-06-06T20:59:40.735Z] + [ 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
20:59:40 [2021-06-06T20:59:40.735Z] + [Parallel] - UserSSH: user=tidb, host=172.16.5.86
20:59:40 [2021-06-06T20:59:40.735Z] + [Parallel] - UserSSH: user=tidb, host=172.16.5.86
20:59:40 [2021-06-06T20:59:40.735Z] + [Parallel] - UserSSH: user=tidb, host=172.16.5.86
20:59:40 [2021-06-06T20:59:40.735Z] + [Parallel] - UserSSH: user=tidb, host=172.16.5.86
20:59:40 [2021-06-06T20:59:40.735Z] + [Parallel] - UserSSH: user=tidb, host=172.16.5.86
20:59:40 [2021-06-06T20:59:40.735Z] + [ Serial ] - StopCluster
20:59:40 [2021-06-06T20:59:40.735Z] Stopping component grafana
20:59:40 [2021-06-06T20:59:40.735Z] 	Stopping instance 172.16.5.86
20:59:40 [2021-06-06T20:59:40.735Z] 	Stop grafana 172.16.5.86:3000 success
20:59:40 [2021-06-06T20:59:40.735Z] Stopping component prometheus
20:59:40 [2021-06-06T20:59:40.735Z] 	Stopping instance 172.16.5.86
20:59:40 [2021-06-06T20:59:40.735Z] 	Stop prometheus 172.16.5.86:9090 success
20:59:40 [2021-06-06T20:59:40.735Z] Stopping component tidb
20:59:40 [2021-06-06T20:59:40.735Z] 	Stopping instance 172.16.5.86
20:59:42 [2021-06-06T20:59:42.094Z] 	Stop tidb 172.16.5.86:4000 success
20:59:42 [2021-06-06T20:59:42.094Z] Stopping component tikv
20:59:42 [2021-06-06T20:59:42.094Z] 	Stopping instance 172.16.5.86
20:59:46 [2021-06-06T20:59:46.251Z] 	Stop tikv 172.16.5.86:20160 success
20:59:46 [2021-06-06T20:59:46.251Z] Stopping component pd
20:59:46 [2021-06-06T20:59:46.251Z] 	Stopping instance 172.16.5.86
20:59:46 [2021-06-06T20:59:46.251Z] 	Stop pd 172.16.5.86:2379 success
20:59:46 [2021-06-06T20:59:46.251Z] Stopping component node_exporter
20:59:46 [2021-06-06T20:59:46.251Z] Stopping component blackbox_exporter
20:59:46 [2021-06-06T20:59:46.251Z] Stopped cluster `benchbot` successfully
20:59:46 [2021-06-06T20:59:46.258Z] [Pipeline] sh
20:59:46 [2021-06-06T20:59:46.535Z] + cat bench_result
20:59:46 [2021-06-06T20:59:46.540Z] [Pipeline] }
20:59:46 [2021-06-06T20:59:46.542Z] [Pipeline] // dir
20:59:46 [2021-06-06T20:59:46.544Z] [Pipeline] }
20:59:46 [2021-06-06T20:59:46.545Z] [Pipeline] // stage
20:59:46 [2021-06-06T20:59:46.547Z] [Pipeline] }
20:59:46 [2021-06-06T20:59:46.549Z] [Pipeline] // node
20:59:46 [2021-06-06T20:59:46.553Z] [Pipeline] }
20:59:46 [2021-06-06T20:59:46.555Z] [Pipeline] // catchError
20:59:46 [2021-06-06T20:59:46.560Z] [Pipeline] stage
20:59:46 [2021-06-06T20:59:46.565Z] [Pipeline] { (Summary)
20:59:46 [2021-06-06T20:59:46.599Z] sh: line 1:  2106 Terminated              sleep 3
20:59:46 [2021-06-06T20:59:46.577Z] [Pipeline] slackSend
20:59:46 [2021-06-06T20:59:46.578Z] 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>
20:59:46 [2021-06-06T20:59:46.613Z] sh: line 1:  2168 Terminated              sleep 3
20:59:47 [2021-06-06T20:59:47.257Z] [Pipeline] }
20:59:47 [2021-06-06T20:59:47.259Z] [Pipeline] // stage
20:59:47 [2021-06-06T20:59:47.398Z] [Pipeline] End of Pipeline
20:59:47 [2021-06-06T20:59:47.414Z] Finished: SUCCESS