SuccessConsole Output

Skipping 1,193 KB.. Full Log
.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:38:06 [2021-06-05T20:38:06.180Z]         └─HashJoin_59	9711455.06	634004	root		time:37.1s, loops:626, build_hash_table:{total:2.43s, fetch:2.23s, build:205.5ms}, probe:{concurrency:5, total:3m5.5s, max:37.1s, probe:15.1s, fetch:2m50.4s}	left outer join, equal:[eq(tpch50.partsupp.ps_partkey, tpch50.lineitem.l_partkey) eq(tpch50.partsupp.ps_suppkey, tpch50.lineitem.l_suppkey)]	10.4 MB	0 Bytes
20:38:06 [2021-06-05T20:38:06.180Z]           ├─IndexHashJoin_67(Build)	321865.05	435528	root		time:2.4s, loops:430, inner:{total:2.7s, concurrency:5, task:12, construct:147.4ms, fetch:2.23s, build:29.3ms, join:327.8ms}	inner join, inner:IndexLookUp_64, outer key:tpch50.part.p_partkey, inner key:tpch50.partsupp.ps_partkey, equal cond:eq(tpch50.part.p_partkey, tpch50.partsupp.ps_partkey)	20.0 MB	N/A
20:38:06 [2021-06-05T20:38:06.180Z]           │ ├─TableReader_96(Build)	80007.93	108882	root		time:2.05s, loops:112, cop_task: {num: 20, max: 1.5s, min: 649.9ms, avg: 1.09s, p95: 1.5s, max_proc_keys: 686055, p95_proc_keys: 686055, tot_proc: 21.7s, tot_wait: 13ms, rpc_num: 20, rpc_time: 21.7s, copr_cache: disabled}	data:Selection_95	680.6 KB	N/A
20:38:06 [2021-06-05T20:38:06.180Z]           │ │ └─Selection_95	80007.93	108882	cop[tikv]		tikv_task:{proc max:1.45s, min:648ms, p80:1.29s, p95:1.45s, iters:9859, tasks:20}, scan_detail: {total_process_keys: 10000000, total_keys: 10000020, rocksdb: {delete_skipped_count: 0, key_skipped_count: 19999980, block: {cache_hit_count: 31499, read_count: 0, read_byte: 0 Bytes}}}	like(tpch50.part.p_name, "green%", 92)	N/A	N/A
20:38:06 [2021-06-05T20:38:06.180Z]           │ │   └─TableFullScan_94	10000000.00	10000000	cop[tikv]	table:part	tikv_task:{proc max:1.34s, min:599ms, p80:1.21s, p95:1.34s, iters:9859, tasks:20}	keep order:false	N/A	N/A
20:38:06 [2021-06-05T20:38:06.180Z]           │ └─IndexLookUp_64(Probe)	4.02	435528	root		time:2.11s, loops:447, index_task: {total_time: 1.18s, fetch_handle: 1.18s, build: 108.5µs, wait: 276.3µs}, table_task: {total_time: 7.8s, num: 55, concurrency: 60}		20.7 KB	N/A
20:38:06 [2021-06-05T20:38:06.180Z]           │   ├─IndexRangeScan_62(Build)	4.02	435528	cop[tikv]	table:partsupp, index:PRIMARY(PS_PARTKEY, PS_SUPPKEY)	time:1.14s, loops:480, cop_task: {num: 58, max: 195.8ms, min: 4.45ms, avg: 84.8ms, p95: 169.1ms, max_proc_keys: 15288, p95_proc_keys: 15008, tot_proc: 4.55s, tot_wait: 45ms, rpc_num: 58, rpc_time: 4.92s, copr_cache: disabled}, tikv_task:{proc max:187ms, min:3ms, p80:130ms, p95:157ms, iters:688, tasks:58}, scan_detail: {total_process_keys: 435528, total_keys: 544410, rocksdb: {delete_skipped_count: 0, key_skipped_count: 435528, block: {cache_hit_count: 980292, read_count: 0, read_byte: 0 Bytes}}}	range: decided by [eq(tpch50.partsupp.ps_partkey, tpch50.part.p_partkey)], keep order:false	N/A	N/A
20:38:06 [2021-06-05T20:38:06.180Z]           │   └─TableRowIDScan_63(Probe)	4.02	435528	cop[tikv]	table:partsupp	time:2.53s, loops:503, cop_task: {num: 1443, max: 80.5ms, min: 400.3µs, avg: 17ms, p95: 38.1ms, max_proc_keys: 1028, p95_proc_keys: 560, tot_proc: 18.2s, tot_wait: 4s, rpc_num: 1443, rpc_time: 24.6s, copr_cache: disabled}, tikv_task:{proc max:44ms, min:0s, p80:16ms, p95:23ms, iters:5346, tasks:1443}, scan_detail: {total_process_keys: 435528, total_keys: 473503, rocksdb: {delete_skipped_count: 0, key_skipped_count: 194053, block: {cache_hit_count: 3644271, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:38:06 [2021-06-05T20:38:06.180Z]           └─TableReader_101(Probe)	46310896.67	45504356	root		time:32.6s, loops:44290, cop_task: {num: 761, max: 1.13s, min: 363ms, avg: 691.5ms, p95: 839.9ms, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 8m43s, tot_wait: 126ms, rpc_num: 761, rpc_time: 8m46.2s, copr_cache: disabled}	data:Selection_100	52.6 MB	N/A
20:38:06 [2021-06-05T20:38:06.180Z]             └─Selection_100	46310896.67	45504356	cop[tikv]		tikv_task:{proc max:1.09s, min:352ms, p80:742ms, p95:818ms, iters:296606, tasks:761}, scan_detail: {total_process_keys: 300005811, total_keys: 300006572, rocksdb: {delete_skipped_count: 0, key_skipped_count: 600010861, block: {cache_hit_count: 1124648, read_count: 0, read_byte: 0 Bytes}}}	ge(tpch50.lineitem.l_shipdate, 1993-01-01 00:00:00.000000), lt(tpch50.lineitem.l_shipdate, 1994-01-01)	N/A	N/A
20:38:06 [2021-06-05T20:38:06.180Z]               └─TableFullScan_99	300005811.00	300005811	cop[tikv]	table:lineitem	tikv_task:{proc max:1.04s, min:330ms, p80:713ms, p95:784ms, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:38:06 [2021-06-05T20:38:06.180Z] + sync
20:38:06 [2021-06-05T20:38:06.180Z] + /usr/bin/echo 3
20:38:44 [2021-06-05T20:38:44.826Z] + sync
20:38:44 [2021-06-05T20:38:44.826Z] + /usr/bin/echo 3
20:39:31 [2021-06-05T20:39:31.418Z] 
20:39:31 [2021-06-05T20:39:31.418Z] queries/20.sql
20:39:31 [2021-06-05T20:39:31.418Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:39:31 [2021-06-05T20:39:31.418Z] Sort_30	20000.00	8982	root		time:37s, loops:10	tpch50.supplier.s_name	603.4 KB	0 Bytes
20:39:31 [2021-06-05T20:39:31.418Z] └─HashJoin_35	20000.00	8982	root		time:37s, loops:11, build_hash_table:{total:1.33s, fetch:1.32s, build:9.79ms}, probe:{concurrency:5, total:3m5s, max:37s, probe:72ms, fetch:3m4.9s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.partsupp.ps_suppkey)]	1.46 MB	0 Bytes
20:39:31 [2021-06-05T20:39:31.418Z]   ├─HashJoin_48(Build)	20000.00	19972	root		time:1.33s, loops:22, build_hash_table:{total:146.1µs, fetch:140.8µs, build:5.33µs}, probe:{concurrency:5, total:6.65s, max:1.33s, probe:102.5ms, fetch:6.55s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:39:31 [2021-06-05T20:39:31.418Z]   │ ├─TableReader_53(Build)	1.00	1	root		time:38.8µs, loops:2, cop_task: {num: 1, max: 1.09ms, proc_keys: 25, rpc_num: 1, rpc_time: 1.06ms, copr_cache: disabled}	data:Selection_52	236 Bytes	N/A
20:39:31 [2021-06-05T20:39:31.418Z]   │ │ └─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:31 [2021-06-05T20:39:31.418Z]   │ │   └─TableFullScan_51	25.00	25	cop[tikv]	table:nation	tikv_task:{time:0s, loops:1}	keep order:false	N/A	N/A
20:39:31 [2021-06-05T20:39:31.418Z]   │ └─TableReader_50(Probe)	500000.00	500000	root		time:1.31s, loops:490, cop_task: {num: 1, max: 1.31s, proc_keys: 500000, tot_proc: 1.24s, rpc_num: 1, rpc_time: 1.31s, copr_cache: disabled}	data:TableFullScan_49	35.8 MB	N/A
20:39:31 [2021-06-05T20:39:31.418Z]   │   └─TableFullScan_49	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:1.11s, 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:31 [2021-06-05T20:39:31.418Z]   └─HashAgg_54(Probe)	257492.04	223999	root		time:37s, loops:222, partial_worker:{wall_time:36.916200893s, concurrency:5, task_num:289, tot_wait:3m4.302252356s, tot_exec:215.209391ms, tot_time:3m4.569128587s, max:36.916095998s, p95:36.916095998s}, final_worker:{wall_time:36.998306599s, concurrency:5, task_num:25, tot_wait:3m4.558381827s, tot_exec:393.687233ms, tot_time:3m4.95208204s, max:36.998148757s, p95:36.998148757s}	group by:tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_suppkey)->tpch50.partsupp.ps_suppkey	61.4 MB	N/A
20:39:31 [2021-06-05T20:39:31.418Z]     └─Selection_55	257492.04	295898	root		time:36.9s, loops:290	gt(cast(tpch50.partsupp.ps_availqty, decimal(20,0) BINARY), mul(0.5, Column#44))	59.2 KB	N/A
20:39:31 [2021-06-05T20:39:31.418Z]       └─HashAgg_56	321865.05	435528	root		time:36.8s, loops:430, partial_worker:{wall_time:36.562005066s, concurrency:5, task_num:624, tot_wait:3m1.579846432s, tot_exec:1.09635392s, tot_time:3m2.791453683s, max:36.561803554s, p95:36.561803554s}, final_worker:{wall_time:36.902423755s, concurrency:5, task_num:25, tot_wait:3m2.740270467s, tot_exec:1.717403675s, tot_time:3m4.457697833s, max:36.902190815s, p95:36.902190815s}	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:31 [2021-06-05T20:39:31.418Z]         └─HashJoin_59	9711455.06	634004	root		time:36.5s, loops:625, build_hash_table:{total:2.48s, fetch:2.25s, build:232.7ms}, probe:{concurrency:5, total:3m2.4s, max:36.5s, probe:15s, fetch:2m47.4s}	left outer join, equal:[eq(tpch50.partsupp.ps_partkey, tpch50.lineitem.l_partkey) eq(tpch50.partsupp.ps_suppkey, tpch50.lineitem.l_suppkey)]	10.4 MB	0 Bytes
20:39:31 [2021-06-05T20:39:31.418Z]           ├─IndexHashJoin_67(Build)	321865.05	435528	root		time:2.41s, loops:429, inner:{total:2.56s, concurrency:5, task:12, construct:147ms, fetch:2.06s, build:33.9ms, join:350.3ms}	inner join, inner:IndexLookUp_64, outer key:tpch50.part.p_partkey, inner key:tpch50.partsupp.ps_partkey, equal cond:eq(tpch50.part.p_partkey, tpch50.partsupp.ps_partkey)	19.9 MB	N/A
20:39:31 [2021-06-05T20:39:31.418Z]           │ ├─TableReader_96(Build)	80007.93	108882	root		time:2.1s, loops:112, cop_task: {num: 20, max: 1.51s, min: 623.7ms, avg: 1.07s, p95: 1.51s, max_proc_keys: 686055, p95_proc_keys: 686055, tot_proc: 21.4s, tot_wait: 6ms, rpc_num: 20, rpc_time: 21.4s, copr_cache: disabled}	data:Selection_95	680.6 KB	N/A
20:39:31 [2021-06-05T20:39:31.418Z]           │ │ └─Selection_95	80007.93	108882	cop[tikv]		tikv_task:{proc max:1.48s, min:621ms, p80:1.24s, p95:1.48s, 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:31 [2021-06-05T20:39:31.418Z]           │ │   └─TableFullScan_94	10000000.00	10000000	cop[tikv]	table:part	tikv_task:{proc max:1.37s, min:581ms, p80:1.16s, p95:1.37s, iters:9859, tasks:20}	keep order:false	N/A	N/A
20:39:31 [2021-06-05T20:39:31.419Z]           │ └─IndexLookUp_64(Probe)	4.02	435528	root		time:1.96s, loops:447, index_task: {total_time: 1.18s, fetch_handle: 1.18s, build: 102.2µs, wait: 329.9µs}, table_task: {total_time: 7.74s, num: 56, concurrency: 60}		20.5 KB	N/A
20:39:31 [2021-06-05T20:39:31.419Z]           │   ├─IndexRangeScan_62(Build)	4.02	435528	cop[tikv]	table:partsupp, index:PRIMARY(PS_PARTKEY, PS_SUPPKEY)	time:1.14s, loops:479, cop_task: {num: 58, max: 200.6ms, min: 4.84ms, avg: 87.3ms, p95: 181.2ms, max_proc_keys: 15288, p95_proc_keys: 15008, tot_proc: 4.68s, tot_wait: 57ms, rpc_num: 58, rpc_time: 5.06s, copr_cache: disabled}, tikv_task:{proc max:187ms, min:4ms, p80:141ms, p95:165ms, iters:689, tasks:58}, scan_detail: {total_process_keys: 435528, total_keys: 544410, rocksdb: {delete_skipped_count: 0, key_skipped_count: 435528, block: {cache_hit_count: 980292, read_count: 0, read_byte: 0 Bytes}}}	range: decided by [eq(tpch50.partsupp.ps_partkey, tpch50.part.p_partkey)], keep order:false	N/A	N/A
20:39:31 [2021-06-05T20:39:31.419Z]           │   └─TableRowIDScan_63(Probe)	4.02	435528	cop[tikv]	table:partsupp	time:2.42s, loops:503, cop_task: {num: 1427, max: 77.4ms, min: 365.9µs, avg: 17ms, p95: 36ms, max_proc_keys: 976, p95_proc_keys: 584, tot_proc: 18.3s, tot_wait: 3.78s, rpc_num: 1427, rpc_time: 24.2s, copr_cache: disabled}, tikv_task:{proc max:52ms, min:0s, p80:16ms, p95:25ms, iters:5285, tasks:1427}, scan_detail: {total_process_keys: 435528, total_keys: 473517, rocksdb: {delete_skipped_count: 0, key_skipped_count: 194093, block: {cache_hit_count: 3644102, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:39:31 [2021-06-05T20:39:31.419Z]           └─TableReader_101(Probe)	46310896.67	45504356	root		time:32s, loops:44289, cop_task: {num: 761, max: 1.15s, min: 376.6ms, avg: 677.8ms, p95: 812.5ms, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 8m32.6s, tot_wait: 139ms, rpc_num: 761, rpc_time: 8m35.8s, copr_cache: disabled}	data:Selection_100	52.6 MB	N/A
20:39:31 [2021-06-05T20:39:31.419Z]             └─Selection_100	46310896.67	45504356	cop[tikv]		tikv_task:{proc max:1.12s, min:364ms, p80:721ms, p95:795ms, 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:31 [2021-06-05T20:39:31.419Z]               └─TableFullScan_99	300005811.00	300005811	cop[tikv]	table:lineitem	tikv_task:{proc max:1.06s, min:348ms, p80:692ms, p95:764ms, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:39:31 [2021-06-05T20:39:31.419Z] 
20:39:31 [2021-06-05T20:39:31.419Z] queries/20.sql
20:39:31 [2021-06-05T20:39:31.419Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:39:31 [2021-06-05T20:39:31.419Z] Sort_30	20000.00	8982	root		time:38.1s, loops:10	tpch50.supplier.s_name	614.3 KB	0 Bytes
20:39:31 [2021-06-05T20:39:31.419Z] └─HashJoin_35	20000.00	8982	root		time:38.1s, loops:11, build_hash_table:{total:1.17s, fetch:1.16s, build:9.34ms}, probe:{concurrency:5, total:3m10.7s, max:38.1s, probe:46.5ms, fetch:3m10.6s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.partsupp.ps_suppkey)]	1.47 MB	0 Bytes
20:39:31 [2021-06-05T20:39:31.419Z]   ├─HashJoin_48(Build)	20000.00	19972	root		time:1.16s, loops:22, build_hash_table:{total:195.3µs, fetch:188.4µs, build:6.87µs}, probe:{concurrency:5, total:5.84s, max:1.17s, probe:87.5ms, fetch:5.75s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:39:31 [2021-06-05T20:39:31.419Z]   │ ├─TableReader_53(Build)	1.00	1	root		time:55.3µs, loops:2, cop_task: {num: 1, max: 918.8µs, proc_keys: 25, tot_proc: 1ms, rpc_num: 1, rpc_time: 904.7µs, copr_cache: disabled}	data:Selection_52	244 Bytes	N/A
20:39:31 [2021-06-05T20:39:31.419Z]   │ │ └─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:39:31 [2021-06-05T20:39:31.419Z]   │ │   └─TableFullScan_51	25.00	25	cop[tikv]	table:nation	tikv_task:{time:1ms, loops:1}	keep order:false	N/A	N/A
20:39:31 [2021-06-05T20:39:31.419Z]   │ └─TableReader_50(Probe)	500000.00	500000	root		time:1.15s, loops:490, cop_task: {num: 1, max: 1.15s, proc_keys: 500000, tot_proc: 1.08s, rpc_num: 1, rpc_time: 1.15s, copr_cache: disabled}	data:TableFullScan_49	35.8 MB	N/A
20:39:31 [2021-06-05T20:39:31.419Z]   │   └─TableFullScan_49	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:953ms, 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:31 [2021-06-05T20:39:31.419Z]   └─HashAgg_54(Probe)	257492.04	223999	root		time:38.1s, loops:222, partial_worker:{wall_time:38.068072873s, concurrency:5, task_num:289, tot_wait:3m10.09020604s, tot_exec:195.263648ms, tot_time:3m10.327022029s, max:38.068040602s, p95:38.068040602s}, final_worker:{wall_time:38.129884964s, concurrency:5, task_num:25, tot_wait:3m10.32057301s, tot_exec:322.39898ms, tot_time:3m10.64298467s, max:38.129869869s, p95:38.129869869s}	group by:tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_suppkey)->tpch50.partsupp.ps_suppkey	61.4 MB	N/A
20:39:31 [2021-06-05T20:39:31.419Z]     └─Selection_55	257492.04	295898	root		time:38.1s, loops:290	gt(cast(tpch50.partsupp.ps_availqty, decimal(20,0) BINARY), mul(0.5, Column#44))	59.2 KB	N/A
20:39:31 [2021-06-05T20:39:31.419Z]       └─HashAgg_56	321865.05	435528	root		time:38s, loops:430, partial_worker:{wall_time:37.717630647s, concurrency:5, task_num:624, tot_wait:3m7.181401238s, tot_exec:1.258494913s, tot_time:3m8.558950828s, max:37.717529304s, p95:37.717529304s}, final_worker:{wall_time:38.056229375s, concurrency:5, task_num:25, tot_wait:3m8.515161965s, tot_exec:1.723627414s, tot_time:3m10.23880602s, max:38.056168704s, p95:38.056168704s}	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:31 [2021-06-05T20:39:31.419Z]         └─HashJoin_59	9711455.06	634004	root		time:37.6s, loops:625, build_hash_table:{total:2.46s, fetch:2.25s, build:214.2ms}, probe:{concurrency:5, total:3m8s, max:37.6s, probe:15.2s, fetch:2m52.7s}	left outer join, equal:[eq(tpch50.partsupp.ps_partkey, tpch50.lineitem.l_partkey) eq(tpch50.partsupp.ps_suppkey, tpch50.lineitem.l_suppkey)]	10.4 MB	0 Bytes
20:39:31 [2021-06-05T20:39:31.419Z]           ├─IndexHashJoin_67(Build)	321865.05	435528	root		time:2.42s, loops:430, inner:{total:2.65s, concurrency:5, task:12, construct:106.6ms, fetch:2.23s, build:25.2ms, join:312.4ms}	inner join, inner:IndexLookUp_64, outer key:tpch50.part.p_partkey, inner key:tpch50.partsupp.ps_partkey, equal cond:eq(tpch50.part.p_partkey, tpch50.partsupp.ps_partkey)	20.0 MB	N/A
20:39:31 [2021-06-05T20:39:31.419Z]           │ ├─TableReader_96(Build)	80007.93	108882	root		time:2.08s, loops:112, cop_task: {num: 20, max: 1.47s, min: 604.7ms, avg: 1.07s, p95: 1.47s, max_proc_keys: 686055, p95_proc_keys: 686055, tot_proc: 21.4s, tot_wait: 36ms, rpc_num: 20, rpc_time: 21.5s, copr_cache: disabled}	data:Selection_95	665.9 KB	N/A
20:39:31 [2021-06-05T20:39:31.419Z]           │ │ └─Selection_95	80007.93	108882	cop[tikv]		tikv_task:{proc max:1.44s, min:598ms, p80:1.25s, p95:1.44s, 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:31 [2021-06-05T20:39:31.419Z]           │ │   └─TableFullScan_94	10000000.00	10000000	cop[tikv]	table:part	tikv_task:{proc max:1.33s, min:550ms, p80:1.16s, p95:1.33s, iters:9859, tasks:20}	keep order:false	N/A	N/A
20:39:31 [2021-06-05T20:39:31.419Z]           │ └─IndexLookUp_64(Probe)	4.02	435528	root		time:2.13s, loops:447, index_task: {total_time: 1.16s, fetch_handle: 1.16s, build: 79.4µs, wait: 283µs}, table_task: {total_time: 8.18s, num: 55, concurrency: 60}		20.7 KB	N/A
20:39:31 [2021-06-05T20:39:31.419Z]           │   ├─IndexRangeScan_62(Build)	4.02	435528	cop[tikv]	table:partsupp, index:PRIMARY(PS_PARTKEY, PS_SUPPKEY)	time:1.12s, loops:476, cop_task: {num: 60, max: 190.1ms, min: 4.8ms, avg: 89.3ms, p95: 181.5ms, max_proc_keys: 15288, p95_proc_keys: 15008, tot_proc: 4.77s, tot_wait: 173ms, rpc_num: 60, rpc_time: 5.36s, copr_cache: disabled}, tikv_task:{proc max:166ms, min:4ms, p80:136ms, p95:157ms, iters:696, tasks:60}, scan_detail: {total_process_keys: 435528, total_keys: 544410, rocksdb: {delete_skipped_count: 0, key_skipped_count: 435528, block: {cache_hit_count: 980292, read_count: 0, read_byte: 0 Bytes}}}	range: decided by [eq(tpch50.partsupp.ps_partkey, tpch50.part.p_partkey)], keep order:false	N/A	N/A
20:39:31 [2021-06-05T20:39:31.419Z]           │   └─TableRowIDScan_63(Probe)	4.02	435528	cop[tikv]	table:partsupp	time:2.97s, loops:501, cop_task: {num: 1445, max: 89.6ms, min: 379.7µs, avg: 20.3ms, p95: 45.3ms, max_proc_keys: 1292, p95_proc_keys: 572, tot_proc: 20.7s, tot_wait: 6.7s, rpc_num: 1445, rpc_time: 29.4s, copr_cache: disabled}, tikv_task:{proc max:62ms, min:0s, p80:17ms, p95:24ms, iters:5346, tasks:1445}, scan_detail: {total_process_keys: 435528, total_keys: 473509, rocksdb: {delete_skipped_count: 0, key_skipped_count: 194091, block: {cache_hit_count: 3644175, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:39:31 [2021-06-05T20:39:31.419Z]           └─TableReader_101(Probe)	46310896.67	45504356	root		time:33.1s, loops:44290, cop_task: {num: 761, max: 1.17s, min: 391.3ms, avg: 696.8ms, p95: 859.7ms, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 8m47s, tot_wait: 117ms, rpc_num: 761, rpc_time: 8m50.2s, copr_cache: disabled}	data:Selection_100	52.6 MB	N/A
20:39:31 [2021-06-05T20:39:31.419Z]             └─Selection_100	46310896.67	45504356	cop[tikv]		tikv_task:{proc max:1.15s, min:383ms, p80:748ms, p95:840ms, 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:31 [2021-06-05T20:39:31.419Z]               └─TableFullScan_99	300005811.00	300005811	cop[tikv]	table:lineitem	tikv_task:{proc max:1.1s, min:361ms, p80:718ms, p95:811ms, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:39:31 [2021-06-05T20:39:31.419Z] + sync
20:39:31 [2021-06-05T20:39:31.419Z] + /usr/bin/echo 3
20:40:10 [2021-06-05T20:40:10.061Z] + sync
20:40:10 [2021-06-05T20:40:10.061Z] + /usr/bin/echo 3
20:40:48 [2021-06-05T20:40:48.744Z] 
20:40:48 [2021-06-05T20:40:48.744Z] queries/20.sql
20:40:48 [2021-06-05T20:40:48.744Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:40:48 [2021-06-05T20:40:48.744Z] Sort_30	20000.00	8982	root		time:37.7s, loops:10	tpch50.supplier.s_name	614.3 KB	0 Bytes
20:40:48 [2021-06-05T20:40:48.744Z] └─HashJoin_35	20000.00	8982	root		time:37.6s, loops:11, build_hash_table:{total:1.21s, fetch:1.2s, build:8.78ms}, probe:{concurrency:5, total:3m8.2s, max:37.6s, probe:49.6ms, fetch:3m8.2s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.partsupp.ps_suppkey)]	1.51 MB	0 Bytes
20:40:48 [2021-06-05T20:40:48.744Z]   ├─HashJoin_48(Build)	20000.00	19972	root		time:1.21s, loops:23, build_hash_table:{total:154.6µs, fetch:148.9µs, build:5.68µs}, probe:{concurrency:5, total:6.03s, max:1.21s, probe:92.6ms, fetch:5.94s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:40:48 [2021-06-05T20:40:48.744Z]   │ ├─TableReader_53(Build)	1.00	1	root		time:34.6µs, loops:2, cop_task: {num: 1, max: 975µs, proc_keys: 25, rpc_num: 1, rpc_time: 951.8µs, copr_cache: disabled}	data:Selection_52	240 Bytes	N/A
20:40:48 [2021-06-05T20:40:48.744Z]   │ │ └─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:48 [2021-06-05T20:40:48.744Z]   │ │   └─TableFullScan_51	25.00	25	cop[tikv]	table:nation	tikv_task:{time:0s, loops:1}	keep order:false	N/A	N/A
20:40:48 [2021-06-05T20:40:48.744Z]   │ └─TableReader_50(Probe)	500000.00	500000	root		time:1.19s, loops:490, cop_task: {num: 1, max: 1.19s, proc_keys: 500000, tot_proc: 1.13s, rpc_num: 1, rpc_time: 1.19s, copr_cache: disabled}	data:TableFullScan_49	35.8 MB	N/A
20:40:48 [2021-06-05T20:40:48.744Z]   │   └─TableFullScan_49	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:944ms, 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:48 [2021-06-05T20:40:48.744Z]   └─HashAgg_54(Probe)	257492.04	223999	root		time:37.6s, loops:222, partial_worker:{wall_time:37.577107322s, concurrency:5, task_num:289, tot_wait:3m7.635874938s, tot_exec:205.746077ms, tot_time:3m7.879190122s, max:37.576992625s, p95:37.576992625s}, final_worker:{wall_time:37.643582164s, concurrency:5, task_num:25, tot_wait:3m7.876187687s, tot_exec:323.609225ms, tot_time:3m8.199809401s, max:37.643501147s, p95:37.643501147s}	group by:tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_suppkey)->tpch50.partsupp.ps_suppkey	61.4 MB	N/A
20:40:48 [2021-06-05T20:40:48.744Z]     └─Selection_55	257492.04	295898	root		time:37.6s, loops:290	gt(cast(tpch50.partsupp.ps_availqty, decimal(20,0) BINARY), mul(0.5, Column#44))	59.2 KB	N/A
20:40:48 [2021-06-05T20:40:48.744Z]       └─HashAgg_56	321865.05	435528	root		time:37.4s, loops:430, partial_worker:{wall_time:37.234077925s, concurrency:5, task_num:626, tot_wait:3m4.841908255s, tot_exec:1.166335997s, tot_time:3m6.13032566s, max:37.23393176s, p95:37.23393176s}, final_worker:{wall_time:37.567217485s, concurrency:5, task_num:25, tot_wait:3m6.073170109s, tot_exec:1.704371309s, tot_time:3m7.777555825s, max:37.567084257s, p95:37.567084257s}	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:48 [2021-06-05T20:40:48.744Z]         └─HashJoin_59	9711455.06	634004	root		time:37.1s, loops:627, build_hash_table:{total:2.41s, fetch:2.19s, build:221.4ms}, probe:{concurrency:5, total:3m5.6s, max:37.1s, probe:14.8s, fetch:2m50.8s}	left outer join, equal:[eq(tpch50.partsupp.ps_partkey, tpch50.lineitem.l_partkey) eq(tpch50.partsupp.ps_suppkey, tpch50.lineitem.l_suppkey)]	10.4 MB	0 Bytes
20:40:48 [2021-06-05T20:40:48.744Z]           ├─IndexHashJoin_67(Build)	321865.05	435528	root		time:2.37s, loops:430, inner:{total:2.6s, concurrency:5, task:12, construct:112ms, fetch:2.14s, build:24.2ms, join:340.3ms}	inner join, inner:IndexLookUp_64, outer key:tpch50.part.p_partkey, inner key:tpch50.partsupp.ps_partkey, equal cond:eq(tpch50.part.p_partkey, tpch50.partsupp.ps_partkey)	19.9 MB	N/A
20:40:48 [2021-06-05T20:40:48.744Z]           │ ├─TableReader_96(Build)	80007.93	108882	root		time:2.03s, loops:112, cop_task: {num: 20, max: 1.49s, min: 382.7ms, avg: 1.07s, p95: 1.49s, max_proc_keys: 686055, p95_proc_keys: 686055, tot_proc: 21.4s, tot_wait: 7ms, rpc_num: 20, rpc_time: 21.5s, copr_cache: disabled}	data:Selection_95	709.0 KB	N/A
20:40:48 [2021-06-05T20:40:48.744Z]           │ │ └─Selection_95	80007.93	108882	cop[tikv]		tikv_task:{proc max:1.46s, min:378ms, p80:1.26s, p95:1.46s, iters:9859, tasks:20}, scan_detail: {total_process_keys: 10000000, total_keys: 10000020, rocksdb: {delete_skipped_count: 0, key_skipped_count: 19999980, block: {cache_hit_count: 31499, read_count: 0, read_byte: 0 Bytes}}}	like(tpch50.part.p_name, "green%", 92)	N/A	N/A
20:40:48 [2021-06-05T20:40:48.744Z]           │ │   └─TableFullScan_94	10000000.00	10000000	cop[tikv]	table:part	tikv_task:{proc max:1.37s, min:349ms, p80:1.18s, p95:1.37s, iters:9859, tasks:20}	keep order:false	N/A	N/A
20:40:48 [2021-06-05T20:40:48.744Z]           │ └─IndexLookUp_64(Probe)	4.02	435528	root		time:2.01s, loops:447, index_task: {total_time: 1.18s, fetch_handle: 1.18s, build: 91.2µs, wait: 278.3µs}, table_task: {total_time: 7.89s, num: 56, concurrency: 60}		19.4 KB	N/A
20:40:48 [2021-06-05T20:40:48.744Z]           │   ├─IndexRangeScan_62(Build)	4.02	435528	cop[tikv]	table:partsupp, index:PRIMARY(PS_PARTKEY, PS_SUPPKEY)	time:1.14s, loops:479, cop_task: {num: 58, max: 201.5ms, min: 6.96ms, avg: 92.7ms, p95: 180.5ms, max_proc_keys: 15288, p95_proc_keys: 15048, tot_proc: 4.87s, tot_wait: 119ms, rpc_num: 58, rpc_time: 5.37s, copr_cache: disabled}, tikv_task:{proc max:176ms, min:6ms, p80:135ms, p95:156ms, iters:688, tasks:58}, scan_detail: {total_process_keys: 435528, total_keys: 544410, rocksdb: {delete_skipped_count: 0, key_skipped_count: 435528, block: {cache_hit_count: 980292, read_count: 0, read_byte: 0 Bytes}}}	range: decided by [eq(tpch50.partsupp.ps_partkey, tpch50.part.p_partkey)], keep order:false	N/A	N/A
20:40:48 [2021-06-05T20:40:48.744Z]           │   └─TableRowIDScan_63(Probe)	4.02	435528	cop[tikv]	table:partsupp	time:2.53s, loops:507, cop_task: {num: 1389, max: 66.3ms, min: 896.3µs, avg: 18.5ms, p95: 39.6ms, max_proc_keys: 1100, p95_proc_keys: 628, tot_proc: 18.9s, tot_wait: 5.23s, rpc_num: 1389, rpc_time: 25.7s, copr_cache: disabled}, tikv_task:{proc max:50ms, min:0s, p80:17ms, p95:25ms, iters:5199, tasks:1389}, scan_detail: {total_process_keys: 435528, total_keys: 473511, rocksdb: {delete_skipped_count: 0, key_skipped_count: 194093, block: {cache_hit_count: 3643798, read_count: 1, read_byte: 26.8 KB}}}	keep order:false	N/A	N/A
20:40:48 [2021-06-05T20:40:48.744Z]           └─TableReader_101(Probe)	46310896.67	45504356	root		time:32.6s, loops:44289, cop_task: {num: 761, max: 1.08s, min: 260.7ms, avg: 691.9ms, p95: 845.4ms, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 8m43.3s, tot_wait: 128ms, rpc_num: 761, rpc_time: 8m46.5s, copr_cache: disabled}	data:Selection_100	52.6 MB	N/A
20:40:48 [2021-06-05T20:40:48.744Z]             └─Selection_100	46310896.67	45504356	cop[tikv]		tikv_task:{proc max:1.06s, min:249ms, p80:741ms, p95:832ms, iters:296606, tasks:761}, scan_detail: {total_process_keys: 300005811, total_keys: 300006572, rocksdb: {delete_skipped_count: 0, key_skipped_count: 600010861, block: {cache_hit_count: 1124648, read_count: 0, read_byte: 0 Bytes}}}	ge(tpch50.lineitem.l_shipdate, 1993-01-01 00:00:00.000000), lt(tpch50.lineitem.l_shipdate, 1994-01-01)	N/A	N/A
20:40:48 [2021-06-05T20:40:48.744Z]               └─TableFullScan_99	300005811.00	300005811	cop[tikv]	table:lineitem	tikv_task:{proc max:1.03s, min:238ms, p80:709ms, p95:797ms, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:40:48 [2021-06-05T20:40:48.744Z] 
20:40:48 [2021-06-05T20:40:48.744Z] queries/20.sql
20:40:48 [2021-06-05T20:40:48.744Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:40:48 [2021-06-05T20:40:48.744Z] Sort_30	20000.00	8982	root		time:37.3s, loops:10	tpch50.supplier.s_name	616.9 KB	0 Bytes
20:40:48 [2021-06-05T20:40:48.744Z] └─HashJoin_35	20000.00	8982	root		time:37.3s, loops:11, build_hash_table:{total:1.39s, fetch:1.38s, build:9.97ms}, probe:{concurrency:5, total:3m6.4s, max:37.3s, probe:46.1ms, fetch:3m6.4s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.partsupp.ps_suppkey)]	1.48 MB	0 Bytes
20:40:48 [2021-06-05T20:40:48.744Z]   ├─HashJoin_48(Build)	20000.00	19972	root		time:1.39s, loops:22, build_hash_table:{total:206µs, fetch:199.2µs, build:6.79µs}, probe:{concurrency:5, total:6.95s, max:1.39s, probe:90.9ms, fetch:6.86s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:40:48 [2021-06-05T20:40:48.744Z]   │ ├─TableReader_53(Build)	1.00	1	root		time:55.7µs, loops:2, cop_task: {num: 1, max: 1.05ms, proc_keys: 25, rpc_num: 1, rpc_time: 1.02ms, copr_cache: disabled}	data:Selection_52	240 Bytes	N/A
20:40:48 [2021-06-05T20:40:48.744Z]   │ │ └─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:48 [2021-06-05T20:40:48.744Z]   │ │   └─TableFullScan_51	25.00	25	cop[tikv]	table:nation	tikv_task:{time:0s, loops:1}	keep order:false	N/A	N/A
20:40:48 [2021-06-05T20:40:48.744Z]   │ └─TableReader_50(Probe)	500000.00	500000	root		time:1.37s, loops:490, cop_task: {num: 1, max: 1.37s, proc_keys: 500000, tot_proc: 1.31s, rpc_num: 1, rpc_time: 1.37s, copr_cache: disabled}	data:TableFullScan_49	35.8 MB	N/A
20:40:48 [2021-06-05T20:40:48.744Z]   │   └─TableFullScan_49	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:1.16s, 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:48 [2021-06-05T20:40:48.744Z]   └─HashAgg_54(Probe)	257492.04	223999	root		time:37.3s, loops:222, partial_worker:{wall_time:37.181004085s, concurrency:5, task_num:289, tot_wait:3m5.682388835s, tot_exec:184.519899ms, tot_time:3m5.901423954s, max:37.180905327s, p95:37.180905327s}, final_worker:{wall_time:37.28826776s, concurrency:5, task_num:25, tot_wait:3m5.898902505s, tot_exec:535.266953ms, tot_time:3m6.434186052s, max:37.288115164s, p95:37.288115164s}	group by:tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_suppkey)->tpch50.partsupp.ps_suppkey	61.4 MB	N/A
20:40:48 [2021-06-05T20:40:48.744Z]     └─Selection_55	257492.04	295898	root		time:37.2s, loops:290	gt(cast(tpch50.partsupp.ps_availqty, decimal(20,0) BINARY), mul(0.5, Column#44))	59.2 KB	N/A
20:40:48 [2021-06-05T20:40:48.744Z]       └─HashAgg_56	321865.05	435528	root		time:37.1s, loops:430, partial_worker:{wall_time:36.842211148s, concurrency:5, task_num:625, tot_wait:3m3.025991749s, tot_exec:1.050933923s, tot_time:3m4.185868696s, max:36.84199726s, p95:36.84199726s}, final_worker:{wall_time:37.172253973s, concurrency:5, task_num:25, tot_wait:3m4.137445738s, tot_exec:1.696761285s, tot_time:3m5.8342257s, max:37.171983695s, p95:37.171983695s}	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:48 [2021-06-05T20:40:48.744Z]         └─HashJoin_59	9711455.06	634004	root		time:36.8s, loops:626, build_hash_table:{total:2.5s, fetch:2.3s, build:199.4ms}, probe:{concurrency:5, total:3m3.8s, max:36.8s, probe:14.5s, fetch:2m49.4s}	left outer join, equal:[eq(tpch50.partsupp.ps_partkey, tpch50.lineitem.l_partkey) eq(tpch50.partsupp.ps_suppkey, tpch50.lineitem.l_suppkey)]	10.4 MB	0 Bytes
20:40:48 [2021-06-05T20:40:48.744Z]           ├─IndexHashJoin_67(Build)	321865.05	435528	root		time:2.47s, loops:430, inner:{total:2.66s, concurrency:5, task:12, construct:141.5ms, fetch:2.2s, build:28.2ms, join:316ms}	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:48 [2021-06-05T20:40:48.744Z]           │ ├─TableReader_96(Build)	80007.93	108882	root		time:2.08s, loops:112, cop_task: {num: 20, max: 1.45s, min: 666.1ms, avg: 1.09s, p95: 1.45s, max_proc_keys: 686055, p95_proc_keys: 686055, tot_proc: 21.8s, tot_wait: 12ms, rpc_num: 20, rpc_time: 21.8s, copr_cache: disabled}	data:Selection_95	725.8 KB	N/A
20:40:48 [2021-06-05T20:40:48.744Z]           │ │ └─Selection_95	80007.93	108882	cop[tikv]		tikv_task:{proc max:1.44s, min:662ms, p80:1.32s, p95:1.44s, 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:48 [2021-06-05T20:40:48.744Z]           │ │   └─TableFullScan_94	10000000.00	10000000	cop[tikv]	table:part	tikv_task:{proc max:1.33s, min:613ms, p80:1.24s, p95:1.33s, iters:9859, tasks:20}	keep order:false	N/A	N/A
20:40:48 [2021-06-05T20:40:48.744Z]           │ └─IndexLookUp_64(Probe)	4.02	435528	root		time:2.07s, loops:447, index_task: {total_time: 1.19s, fetch_handle: 1.19s, build: 79.9µs, wait: 266.6µs}, table_task: {total_time: 7.82s, num: 55, concurrency: 60}		20.7 KB	N/A
20:40:48 [2021-06-05T20:40:48.745Z]           │   ├─IndexRangeScan_62(Build)	4.02	435528	cop[tikv]	table:partsupp, index:PRIMARY(PS_PARTKEY, PS_SUPPKEY)	time:1.15s, loops:479, cop_task: {num: 61, max: 193.3ms, min: 4.64ms, avg: 84.1ms, p95: 174.5ms, max_proc_keys: 15288, p95_proc_keys: 14948, tot_proc: 4.71s, tot_wait: 60ms, rpc_num: 61, rpc_time: 5.13s, copr_cache: disabled}, tikv_task:{proc max:182ms, min:4ms, p80:127ms, p95:162ms, iters:700, tasks:61}, scan_detail: {total_process_keys: 435528, total_keys: 544410, rocksdb: {delete_skipped_count: 0, key_skipped_count: 435528, block: {cache_hit_count: 980292, read_count: 0, read_byte: 0 Bytes}}}	range: decided by [eq(tpch50.partsupp.ps_partkey, tpch50.part.p_partkey)], keep order:false	N/A	N/A
20:40:48 [2021-06-05T20:40:48.745Z]           │   └─TableRowIDScan_63(Probe)	4.02	435528	cop[tikv]	table:partsupp	time:2.45s, loops:503, cop_task: {num: 1476, max: 81ms, min: 567.1µs, avg: 16.6ms, p95: 32.4ms, max_proc_keys: 972, p95_proc_keys: 536, tot_proc: 18s, tot_wait: 4.08s, rpc_num: 1476, rpc_time: 24.5s, copr_cache: disabled}, tikv_task:{proc max:39ms, min:0s, p80:16ms, p95:22ms, iters:5443, tasks:1476}, scan_detail: {total_process_keys: 435528, total_keys: 473495, rocksdb: {delete_skipped_count: 0, key_skipped_count: 194027, block: {cache_hit_count: 3644484, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:40:48 [2021-06-05T20:40:48.745Z]           └─TableReader_101(Probe)	46310896.67	45504356	root		time:32.2s, loops:44290, cop_task: {num: 761, max: 1.16s, min: 249.3ms, avg: 681.6ms, p95: 829.1ms, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 8m35.5s, tot_wait: 122ms, rpc_num: 761, rpc_time: 8m38.6s, copr_cache: disabled}	data:Selection_100	52.6 MB	N/A
20:40:48 [2021-06-05T20:40:48.745Z]             └─Selection_100	46310896.67	45504356	cop[tikv]		tikv_task:{proc max:1.1s, min:244ms, p80:730ms, p95:813ms, 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:48 [2021-06-05T20:40:48.745Z]               └─TableFullScan_99	300005811.00	300005811	cop[tikv]	table:lineitem	tikv_task:{proc max:1.05s, min:232ms, p80:698ms, p95:782ms, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:40:48 [2021-06-05T20:40:48.745Z] + sync
20:40:48 [2021-06-05T20:40:48.745Z] + /usr/bin/echo 3
20:41:35 [2021-06-05T20:41:35.339Z] + tiup cluster stop benchbot -y
20:41:35 [2021-06-05T20:41:35.339Z] Starting component `cluster`: /home/tidb/.tiup/components/cluster/v1.4.4/tiup-cluster stop benchbot -y
20:41:43 [2021-06-05T20:41:43.411Z] + rm -rf '/data1/tidb-deploy/*/log/*'
20:41:43 [2021-06-05T20:41:43.411Z] + rm -rf /data1/jenkins/deploy/data/tikv-20160
20:41:46 [2021-06-05T20:41:46.671Z] + rm -rf /data1/jenkins/deploy/data/pd-2379
20:41:46 [2021-06-05T20:41:46.671Z] + rm -rf /data1/jenkins/restore_data/tpch50/data/last_tikv.toml
20:41:46 [2021-06-05T20:41:46.671Z] + cp -R /data1/jenkins/restore_data/tpch50/data /data1/jenkins/deploy/data/tikv-20160
20:43:23 [2021-06-05T20:43:23.291Z] + cp -R /data1/jenkins/restore_data/tpch50/data.pd /data1/jenkins/deploy/data/pd-2379
20:43:23 [2021-06-05T20:43:23.291Z] + '[' -n '' ']'
20:43:23 [2021-06-05T20:43:23.291Z] + tiup cluster start benchbot --wait-timeout=300
20:43:23 [2021-06-05T20:43:23.291Z] Starting component `cluster`: /home/tidb/.tiup/components/cluster/v1.4.4/tiup-cluster start benchbot --wait-timeout=300
20:43:55 [2021-06-05T20:43:55.442Z] + sync
20:43:55 [2021-06-05T20:43:55.442Z] + /usr/bin/echo 3
20:45:31 [2021-06-05T20:45:31.908Z] 
20:45:31 [2021-06-05T20:45:31.908Z] queries/20.sql
20:45:31 [2021-06-05T20:45:31.908Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:45:31 [2021-06-05T20:45:31.908Z] Sort_30	20000.00	8982	root		time:37.7s, loops:10	tpch50.supplier.s_name	616.9 KB	0 Bytes
20:45:31 [2021-06-05T20:45:31.908Z] └─HashJoin_35	20000.00	8982	root		time:37.7s, loops:11, build_hash_table:{total:1.41s, fetch:1.4s, build:13.3ms}, probe:{concurrency:5, total:3m8.4s, max:37.7s, probe:49.3ms, fetch:3m8.3s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.partsupp.ps_suppkey)]	1.50 MB	0 Bytes
20:45:31 [2021-06-05T20:45:31.908Z]   ├─HashJoin_48(Build)	20000.00	19972	root		time:1.41s, loops:23, build_hash_table:{total:136.6µs, fetch:131.4µs, build:5.22µs}, probe:{concurrency:5, total:7.04s, max:1.41s, probe:117.6ms, fetch:6.93s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:45:31 [2021-06-05T20:45:31.908Z]   │ ├─TableReader_53(Build)	1.00	1	root		time:38.7µs, loops:2, cop_task: {num: 1, max: 958.4µs, proc_keys: 25, rpc_num: 1, rpc_time: 940.5µs, copr_cache: disabled}	data:Selection_52	236 Bytes	N/A
20:45:31 [2021-06-05T20:45:31.908Z]   │ │ └─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:31 [2021-06-05T20:45:31.908Z]   │ │   └─TableFullScan_51	25.00	25	cop[tikv]	table:nation	tikv_task:{time:0s, loops:1}	keep order:false	N/A	N/A
20:45:31 [2021-06-05T20:45:31.908Z]   │ └─TableReader_50(Probe)	500000.00	500000	root		time:1.38s, loops:490, cop_task: {num: 1, max: 1.38s, proc_keys: 500000, tot_proc: 1.31s, rpc_num: 1, rpc_time: 1.38s, copr_cache: disabled}	data:TableFullScan_49	35.8 MB	N/A
20:45:31 [2021-06-05T20:45:31.908Z]   │   └─TableFullScan_49	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:1.15s, loops:493}, scan_detail: {total_process_keys: 500000, total_keys: 500001, rocksdb: {delete_skipped_count: 0, key_skipped_count: 999999, block: {cache_hit_count: 1692, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:45:31 [2021-06-05T20:45:31.908Z]   └─HashAgg_54(Probe)	257492.04	223999	root		time:37.7s, loops:222, partial_worker:{wall_time:37.576203872s, concurrency:5, task_num:289, tot_wait:3m7.580121881s, tot_exec:197.126781ms, tot_time:3m7.825832439s, max:37.576166845s, p95:37.576166845s}, final_worker:{wall_time:37.674247133s, concurrency:5, task_num:25, tot_wait:3m7.805683414s, tot_exec:561.36012ms, tot_time:3m8.367061221s, max:37.674201274s, p95:37.674201274s}	group by:tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_suppkey)->tpch50.partsupp.ps_suppkey	61.4 MB	N/A
20:45:31 [2021-06-05T20:45:31.908Z]     └─Selection_55	257492.04	295898	root		time:37.6s, loops:290	gt(cast(tpch50.partsupp.ps_availqty, decimal(20,0) BINARY), mul(0.5, Column#44))	59.2 KB	N/A
20:45:31 [2021-06-05T20:45:31.908Z]       └─HashAgg_56	321865.05	435528	root		time:37.5s, loops:430, partial_worker:{wall_time:37.20870314s, concurrency:5, task_num:623, tot_wait:3m4.868634047s, tot_exec:1.041808705s, tot_time:3m6.033532975s, max:37.208681969s, p95:37.208681969s}, final_worker:{wall_time:37.552926379s, concurrency:5, task_num:25, tot_wait:3m6.019864339s, tot_exec:1.727379962s, tot_time:3m7.74726066s, max:37.552911481s, p95:37.552911481s}	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:31 [2021-06-05T20:45:31.908Z]         └─HashJoin_59	9711455.06	634004	root		time:37.1s, loops:624, build_hash_table:{total:2.32s, fetch:2.11s, build:212.5ms}, probe:{concurrency:5, total:3m5.7s, max:37.1s, probe:14.4s, 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:45:31 [2021-06-05T20:45:31.908Z]           ├─IndexHashJoin_67(Build)	321865.05	435528	root		time:2.29s, loops:430, inner:{total:2.63s, concurrency:5, task:12, construct:169ms, fetch:2.13s, build:33.9ms, join:329.9ms}	inner join, inner:IndexLookUp_64, outer key:tpch50.part.p_partkey, inner key:tpch50.partsupp.ps_partkey, equal cond:eq(tpch50.part.p_partkey, tpch50.partsupp.ps_partkey)	19.9 MB	N/A
20:45:31 [2021-06-05T20:45:31.908Z]           │ ├─TableReader_96(Build)	80007.93	108882	root		time:1.9s, loops:112, cop_task: {num: 20, max: 1.47s, min: 625.8ms, avg: 1.08s, p95: 1.47s, max_proc_keys: 686055, p95_proc_keys: 686055, tot_proc: 21.4s, tot_wait: 17ms, rpc_num: 20, rpc_time: 21.5s, copr_cache: disabled}	data:Selection_95	725.8 KB	N/A
20:45:31 [2021-06-05T20:45:31.908Z]           │ │ └─Selection_95	80007.93	108882	cop[tikv]		tikv_task:{proc max:1.42s, min:621ms, p80:1.24s, 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:45:31 [2021-06-05T20:45:31.908Z]           │ │   └─TableFullScan_94	10000000.00	10000000	cop[tikv]	table:part	tikv_task:{proc max:1.33s, min:577ms, p80:1.14s, p95:1.33s, iters:9859, tasks:20}	keep order:false	N/A	N/A
20:45:31 [2021-06-05T20:45:31.908Z]           │ └─IndexLookUp_64(Probe)	4.02	435528	root		time:2.01s, loops:447, index_task: {total_time: 1.17s, fetch_handle: 1.17s, build: 81.2µs, wait: 266.4µs}, table_task: {total_time: 7.95s, num: 55, concurrency: 60}		20.7 KB	N/A
20:45:31 [2021-06-05T20:45:31.908Z]           │   ├─IndexRangeScan_62(Build)	4.02	435528	cop[tikv]	table:partsupp, index:PRIMARY(PS_PARTKEY, PS_SUPPKEY)	time:1.13s, loops:478, cop_task: {num: 59, max: 207.6ms, min: 7.03ms, avg: 82.5ms, p95: 165.7ms, max_proc_keys: 15048, p95_proc_keys: 14948, tot_proc: 4.49s, tot_wait: 35ms, rpc_num: 59, rpc_time: 4.87s, copr_cache: disabled}, tikv_task:{proc max:191ms, min:4ms, p80:133ms, p95:159ms, iters:694, 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:31 [2021-06-05T20:45:31.908Z]           │   └─TableRowIDScan_63(Probe)	4.02	435528	cop[tikv]	table:partsupp	time:2.69s, loops:501, cop_task: {num: 1421, max: 79.2ms, min: 1.01ms, avg: 18.9ms, p95: 42ms, max_proc_keys: 1028, p95_proc_keys: 584, tot_proc: 19.6s, tot_wait: 4.75s, rpc_num: 1421, rpc_time: 26.9s, copr_cache: disabled}, tikv_task:{proc max:52ms, min:0s, p80:17ms, p95:25ms, iters:5289, tasks:1421}, scan_detail: {total_process_keys: 435528, total_keys: 473496, rocksdb: {delete_skipped_count: 0, key_skipped_count: 194034, block: {cache_hit_count: 3644220, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:45:31 [2021-06-05T20:45:31.908Z]           └─TableReader_101(Probe)	46310896.67	45504356	root		time:32.8s, loops:44290, cop_task: {num: 761, max: 1.23s, min: 274.8ms, avg: 694.8ms, p95: 820.2ms, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 8m45.6s, tot_wait: 127ms, rpc_num: 761, rpc_time: 8m48.7s, copr_cache: disabled}	data:Selection_100	52.6 MB	N/A
20:45:31 [2021-06-05T20:45:31.908Z]             └─Selection_100	46310896.67	45504356	cop[tikv]		tikv_task:{proc max:1.18s, min:263ms, p80:736ms, p95:802ms, 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:31 [2021-06-05T20:45:31.908Z]               └─TableFullScan_99	300005811.00	300005811	cop[tikv]	table:lineitem	tikv_task:{proc max:1.14s, min:248ms, p80:707ms, p95:775ms, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:45:31 [2021-06-05T20:45:31.908Z] 
20:45:31 [2021-06-05T20:45:31.908Z] queries/21.sql
20:45:31 [2021-06-05T20:45:31.908Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:45:31 [2021-06-05T20:45:31.908Z] Projection_26	100.00	100	root		time:1m21.6s, loops:2, Concurrency:OFF	tpch50.supplier.s_name, Column#72	4.62 KB	N/A
20:45:31 [2021-06-05T20:45:31.908Z] └─TopN_29	100.00	100	root		time:1m21.6s, loops:2	Column#72:desc, tpch50.supplier.s_name, offset:0, count:100	55.9 KB	N/A
20:45:31 [2021-06-05T20:45:31.908Z]   └─HashAgg_34	12800.00	20057	root		time:1m21.6s, loops:21, partial_worker:{wall_time:1m21.572083685s, concurrency:5, task_num:198, tot_wait:6m47.560656212s, tot_exec:284.955844ms, tot_time:6m47.857916405s, max:1m21.572057559s, p95:1m21.572057559s}, final_worker:{wall_time:1m21.58758634s, concurrency:5, task_num:25, tot_wait:6m47.856075542s, tot_exec:76.400981ms, tot_time:6m47.932488136s, max:1m21.587557632s, p95:1m21.587557632s}	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:31 [2021-06-05T20:45:31.908Z]     └─IndexHashJoin_42	7828961.66	198698	root		time:1m21.6s, loops:199, inner:{total:2m17.2s, concurrency:5, task:146, construct:6.41s, fetch:1m53.7s, build:1.21s, join:17s}	anti semi join, inner:IndexLookUp_39, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey)	641.0 MB	N/A
20:45:31 [2021-06-05T20:45:31.908Z]       ├─IndexHashJoin_83(Build)	9786202.08	3542799	root		time:1m21s, loops:3463, inner:{total:2m27.8s, concurrency:5, task:152, construct:8.12s, fetch:2m1.7s, build:1.25s, 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:45:31 [2021-06-05T20:45:31.908Z]       │ ├─IndexJoin_99(Build)	12232752.60	3675878	root		time:1m20.5s, loops:3595, inner:{total:2m5.4s, concurrency:5, task:305, construct:16.8s, fetch:1m46.7s, build:1.9s}, probe:5.36s	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:45:31 [2021-06-05T20:45:31.908Z]       │ │ ├─HashJoin_107(Build)	12232752.60	7609895	root		time:1m19.9s, loops:7437, build_hash_table:{total:820ms, fetch:805.9ms, build:14.2ms}, probe:{concurrency:5, total:6m42s, max:1m20.4s, probe:1m2.2s, fetch:5m39.9s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.lineitem.l_suppkey)]	737.6 KB	0 Bytes
20:45:31 [2021-06-05T20:45:31.909Z]       │ │ │ ├─HashJoin_120(Build)	20000.00	20058	root		time:816.6ms, loops:22, build_hash_table:{total:642.6µs, fetch:427µs, build:215.6µs}, probe:{concurrency:5, total:4.09s, max:818.2ms, probe:95.7ms, fetch:3.99s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:45:31 [2021-06-05T20:45:31.909Z]       │ │ │ │ ├─TableReader_125(Build)	1.00	1	root		time:49.9µs, loops:2, cop_task: {num: 1, max: 870.2µs, proc_keys: 25, rpc_num: 1, rpc_time: 859.9µs, copr_cache: disabled}	data:Selection_124	234 Bytes	N/A
20:45:31 [2021-06-05T20:45:31.909Z]       │ │ │ │ │ └─Selection_124	1.00	1	cop[tikv]		tikv_task:{time:0s, loops:1}, scan_detail: {total_process_keys: 25, total_keys: 26, rocksdb: {delete_skipped_count: 0, key_skipped_count: 46, block: {cache_hit_count: 18, read_count: 0, read_byte: 0 Bytes}}}	eq(tpch50.nation.n_name, "EGYPT")	N/A	N/A
20:45:31 [2021-06-05T20:45:31.909Z]       │ │ │ │ │   └─TableFullScan_123	25.00	25	cop[tikv]	table:nation	tikv_task:{time:0s, loops:1}	keep order:false	N/A	N/A
20:45:31 [2021-06-05T20:45:31.909Z]       │ │ │ │ └─TableReader_122(Probe)	500000.00	500000	root		time:798.4ms, loops:490, cop_task: {num: 1, max: 914ms, proc_keys: 500000, tot_proc: 884ms, rpc_num: 1, rpc_time: 914ms, copr_cache: disabled}	data:TableFullScan_121	20.0 MB	N/A
20:45:31 [2021-06-05T20:45:31.909Z]       │ │ │ │   └─TableFullScan_121	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:828ms, loops:493}, scan_detail: {total_process_keys: 500000, total_keys: 500001, rocksdb: {delete_skipped_count: 0, key_skipped_count: 999999, block: {cache_hit_count: 15, read_count: 1689, read_byte: 108.5 MB}}}	keep order:false	N/A	N/A
20:45:31 [2021-06-05T20:45:31.909Z]       │ │ │ └─TableReader_128(Probe)	240004648.80	189670348	root		time:1m7.8s, loops:184596, cop_task: {num: 761, max: 3.12s, min: 289.8ms, avg: 1.55s, p95: 1.98s, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 18m26.3s, tot_wait: 56.6s, rpc_num: 761, rpc_time: 19m36.1s, copr_cache: disabled}	data:Selection_127	91.6 MB	N/A
20:45:31 [2021-06-05T20:45:31.909Z]       │ │ │   └─Selection_127	240004648.80	189670348	cop[tikv]		tikv_task:{proc max:1.4s, min:277ms, p80:1.22s, p95:1.27s, iters:296606, tasks:761}, scan_detail: {total_process_keys: 300005811, total_keys: 300006572, rocksdb: {delete_skipped_count: 0, key_skipped_count: 600010861, block: {cache_hit_count: 18680, read_count: 1131779, read_byte: 23.9 GB}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:45:31 [2021-06-05T20:45:31.909Z]       │ │ │     └─TableFullScan_126	300005811.00	300005811	cop[tikv]	table:l1	tikv_task:{proc max:1.31s, min:260ms, p80:1.13s, p95:1.18s, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:45:31 [2021-06-05T20:45:31.909Z]       │ │ └─TableReader_95(Probe)	0.49	3496174	root		time:1m37.6s, loops:3875, cop_task: {num: 5252, max: 535.9ms, min: 3.77ms, avg: 174.1ms, p95: 328.8ms, max_proc_keys: 3744, p95_proc_keys: 1963, tot_proc: 10m58.5s, tot_wait: 3m35.5s, rpc_num: 5252, rpc_time: 15m14.5s, copr_cache: disabled}	data:Selection_94	N/A	N/A
20:45:31 [2021-06-05T20:45:31.909Z]       │ │   └─Selection_94	0.49	3496174	cop[tikv]		tikv_task:{proc max:158ms, min:0s, p80:70ms, p95:83ms, iters:30231, tasks:5252}, scan_detail: {total_process_keys: 7236268, total_keys: 7795511, rocksdb: {delete_skipped_count: 0, key_skipped_count: 1778373, block: {cache_hit_count: 54006598, read_count: 220204, read_byte: 4.72 GB}}}	eq(tpch50.orders.o_orderstatus, "F")	N/A	N/A
20:45:31 [2021-06-05T20:45:31.909Z]       │ │     └─TableRangeScan_93	1.00	7236268	cop[tikv]	table:orders	tikv_task:{proc max:158ms, min:0s, p80:70ms, p95:83ms, iters:30231, tasks:5252}	range: decided by [tpch50.lineitem.l_orderkey], keep order:false	N/A	N/A
20:45:31 [2021-06-05T20:45:31.909Z]       │ └─IndexLookUp_80(Probe)	4.05	17316504	root		time:1m55.8s, loops:17126, index_task: {total_time: 1m3.9s, fetch_handle: 56.3s, build: 3.17ms, wait: 7.55s}, table_task: {total_time: 8m13.7s, num: 1458, concurrency: 760}		19 KB	N/A
20:45:31 [2021-06-05T20:45:31.909Z]       │   ├─IndexRangeScan_78(Build)	4.05	17316504	cop[tikv]	table:l2, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:54.1s, loops:18612, cop_task: {num: 2972, max: 697.9ms, min: 723.6µs, avg: 186.6ms, p95: 368.5ms, max_proc_keys: 13816, p95_proc_keys: 8815, tot_proc: 6m56.7s, tot_wait: 1m57.6s, rpc_num: 2972, rpc_time: 9m14.6s, copr_cache: disabled}, tikv_task:{proc max:178ms, min:0s, p80:98ms, p95:114ms, iters:30084, tasks:2972}, scan_detail: {total_process_keys: 17316504, total_keys: 20812617, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17316504, block: {cache_hit_count: 24260273, read_count: 226873, read_byte: 2.39 GB}}}	range: decided by [eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey)], keep order:false	N/A	N/A
20:45:31 [2021-06-05T20:45:31.909Z]       │   └─TableRowIDScan_79(Probe)	4.05	17316504	cop[tikv]	table:l2	time:6m1.9s, loops:21023, cop_task: {num: 7788, max: 575.6ms, min: 380µs, avg: 170.7ms, p95: 339.7ms, max_proc_keys: 14117, p95_proc_keys: 4853, tot_proc: 15m50.9s, tot_wait: 5m28.9s, rpc_num: 7788, rpc_time: 22m9.5s, copr_cache: disabled}, tikv_task:{proc max:268ms, min:0s, p80:104ms, p95:139ms, iters:50001, tasks:7788}, scan_detail: {total_process_keys: 17316504, total_keys: 18288976, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5625430, block: {cache_hit_count: 99023858, read_count: 4, read_byte: 69.9 KB}}}	keep order:false	N/A	N/A
20:45:31 [2021-06-05T20:45:31.909Z]       └─IndexLookUp_39(Probe)	4.05	12022812	root		time:1m49s, loops:11953, index_task: {total_time: 58.5s, fetch_handle: 48.7s, build: 3.21ms, wait: 9.75s}, table_task: {total_time: 7m46.7s, num: 1408, concurrency: 730}		224.8 KB	N/A
20:45:31 [2021-06-05T20:45:31.909Z]         ├─IndexRangeScan_36(Build)	5.06	17183426	cop[tikv]	table:l3, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:46.4s, loops:18356, cop_task: {num: 2751, max: 718.5ms, min: 576.8µs, avg: 162.5ms, p95: 353.6ms, max_proc_keys: 23296, p95_proc_keys: 13614, tot_proc: 5m35.1s, tot_wait: 1m32.8s, rpc_num: 2751, rpc_time: 7m26.9s, copr_cache: disabled}, tikv_task:{proc max:196ms, min:0s, p80:77ms, p95:119ms, iters:28944, tasks:2751}, scan_detail: {total_process_keys: 17183426, total_keys: 20546460, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17183426, 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:45:31 [2021-06-05T20:45:31.909Z]         └─Selection_38(Probe)	4.05	12022812	cop[tikv]		time:5m55.7s, loops:13768, cop_task: {num: 10204, max: 580.8ms, min: 540µs, avg: 165.9ms, p95: 335.8ms, max_proc_keys: 7711, p95_proc_keys: 3958, tot_proc: 19m51.7s, tot_wait: 7m14.9s, rpc_num: 10204, rpc_time: 28m12.1s, copr_cache: disabled}, tikv_task:{proc max:241ms, min:0s, p80:77ms, p95:117ms, iters:60568, tasks:10204}, scan_detail: {total_process_keys: 17183426, total_keys: 18130117, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5530535, block: {cache_hit_count: 98286242, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:45:31 [2021-06-05T20:45:31.909Z]           └─TableRowIDScan_37	5.06	17183426	cop[tikv]	table:l3	tikv_task:{proc max:240ms, min:0s, p80:76ms, p95:116ms, iters:60568, tasks:10204}	keep order:false	N/A	N/A
20:45:31 [2021-06-05T20:45:31.909Z] + sync
20:45:31 [2021-06-05T20:45:31.909Z] + /usr/bin/echo 3
20:46:53 [2021-06-05T20:46:53.270Z] 
20:46:53 [2021-06-05T20:46:53.270Z] queries/21.sql
20:46:53 [2021-06-05T20:46:53.270Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:46:53 [2021-06-05T20:46:53.270Z] Projection_26	100.00	100	root		time:1m20.4s, loops:2, Concurrency:OFF	tpch50.supplier.s_name, Column#72	4.62 KB	N/A
20:46:53 [2021-06-05T20:46:53.270Z] └─TopN_29	100.00	100	root		time:1m20.4s, loops:2	Column#72:desc, tpch50.supplier.s_name, offset:0, count:100	58.4 KB	N/A
20:46:53 [2021-06-05T20:46:53.270Z]   └─HashAgg_34	12800.00	20057	root		time:1m20.4s, loops:21, partial_worker:{wall_time:1m20.359789588s, concurrency:5, task_num:197, tot_wait:6m41.495091631s, tot_exec:284.740039ms, tot_time:6m41.795414116s, max:1m20.359766583s, p95:1m20.359766583s}, final_worker:{wall_time:1m20.37599659s, concurrency:5, task_num:25, tot_wait:6m41.793001177s, tot_exec:79.409546ms, tot_time:6m41.872423623s, max:1m20.375981012s, p95:1m20.375981012s}	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:53 [2021-06-05T20:46:53.270Z]     └─IndexHashJoin_42	7828961.66	198698	root		time:1m20.4s, loops:198, inner:{total:2m17.3s, concurrency:5, task:146, construct:6.41s, fetch:1m54s, build:1.15s, 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:46:53 [2021-06-05T20:46:53.270Z]       ├─IndexHashJoin_83(Build)	9786202.08	3542799	root		time:1m19.8s, loops:3463, inner:{total:2m26.5s, concurrency:5, task:152, construct:7.98s, fetch:2m0.3s, build:1.22s, 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)	556.0 MB	N/A
20:46:53 [2021-06-05T20:46:53.270Z]       │ ├─IndexJoin_99(Build)	12232752.60	3675878	root		time:1m19.3s, loops:3595, inner:{total:2m5.4s, concurrency:5, task:305, construct:16.5s, fetch:1m47s, build:1.91s}, probe:5.39s	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:46:53 [2021-06-05T20:46:53.270Z]       │ │ ├─HashJoin_107(Build)	12232752.60	7609895	root		time:1m18.9s, loops:7436, build_hash_table:{total:1s, fetch:996.9ms, build:7.26ms}, probe:{concurrency:5, total:6m36.1s, max:1m19.2s, probe:1m2.8s, fetch:5m33.3s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.lineitem.l_suppkey)]	754.0 KB	0 Bytes
20:46:53 [2021-06-05T20:46:53.270Z]       │ │ │ ├─HashJoin_120(Build)	20000.00	20058	root		time:1s, loops:23, build_hash_table:{total:229.3µs, fetch:224.5µs, build:4.78µs}, probe:{concurrency:5, total:5.01s, max:1s, probe:70.4ms, fetch:4.94s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:46:53 [2021-06-05T20:46:53.270Z]       │ │ │ │ ├─TableReader_125(Build)	1.00	1	root		time:43.6µs, loops:2, cop_task: {num: 1, max: 1.16ms, proc_keys: 25, rpc_num: 1, rpc_time: 1.14ms, copr_cache: disabled}	data:Selection_124	244 Bytes	N/A
20:46:53 [2021-06-05T20:46:53.270Z]       │ │ │ │ │ └─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:53 [2021-06-05T20:46:53.270Z]       │ │ │ │ │   └─TableFullScan_123	25.00	25	cop[tikv]	table:nation	tikv_task:{time:0s, loops:1}	keep order:false	N/A	N/A
20:46:53 [2021-06-05T20:46:53.270Z]       │ │ │ │ └─TableReader_122(Probe)	500000.00	500000	root		time:988.1ms, loops:490, cop_task: {num: 1, max: 988.7ms, proc_keys: 500000, tot_proc: 950ms, tot_wait: 1ms, rpc_num: 1, rpc_time: 988.6ms, copr_cache: disabled}	data:TableFullScan_121	20.0 MB	N/A
20:46:53 [2021-06-05T20:46:53.270Z]       │ │ │ │   └─TableFullScan_121	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:898ms, loops:493}, scan_detail: {total_process_keys: 500000, total_keys: 500001, rocksdb: {delete_skipped_count: 0, key_skipped_count: 999999, block: {cache_hit_count: 14, read_count: 1678, read_byte: 104.5 MB}}}	keep order:false	N/A	N/A
20:46:53 [2021-06-05T20:46:53.270Z]       │ │ │ └─TableReader_128(Probe)	240004648.80	189670348	root		time:1m6.3s, loops:184594, cop_task: {num: 761, max: 2.66s, min: 277.9ms, avg: 1.52s, p95: 1.95s, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 18m3.3s, tot_wait: 1m0.8s, rpc_num: 761, rpc_time: 19m17.2s, copr_cache: disabled}	data:Selection_127	101.7 MB	N/A
20:46:53 [2021-06-05T20:46:53.270Z]       │ │ │   └─Selection_127	240004648.80	189670348	cop[tikv]		tikv_task:{proc max:1.33s, min:266ms, p80:1.18s, p95:1.23s, iters:296606, tasks:761}, scan_detail: {total_process_keys: 300005811, total_keys: 300006572, rocksdb: {delete_skipped_count: 0, key_skipped_count: 600010861, block: {cache_hit_count: 10454, read_count: 1114194, read_byte: 23.6 GB}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:46:53 [2021-06-05T20:46:53.270Z]       │ │ │     └─TableFullScan_126	300005811.00	300005811	cop[tikv]	table:l1	tikv_task:{proc max:1.24s, min:254ms, p80:1.09s, p95:1.14s, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:46:53 [2021-06-05T20:46:53.270Z]       │ │ └─TableReader_95(Probe)	0.49	3496173	root		time:1m37.6s, loops:3875, cop_task: {num: 5230, max: 528.9ms, min: 1.95ms, avg: 177.3ms, p95: 333.1ms, max_proc_keys: 4604, p95_proc_keys: 1967, tot_proc: 11m8.2s, tot_wait: 3m38.8s, rpc_num: 5230, rpc_time: 15m27.3s, copr_cache: disabled}	data:Selection_94	N/A	N/A
20:46:53 [2021-06-05T20:46:53.270Z]       │ │   └─Selection_94	0.49	3496173	cop[tikv]		tikv_task:{proc max:180ms, min:0s, p80:69ms, p95:82ms, iters:30140, tasks:5230}, scan_detail: {total_process_keys: 7236275, total_keys: 7795528, rocksdb: {delete_skipped_count: 0, key_skipped_count: 1778415, block: {cache_hit_count: 54006289, read_count: 218192, read_byte: 4.21 GB}}}	eq(tpch50.orders.o_orderstatus, "F")	N/A	N/A
20:46:53 [2021-06-05T20:46:53.270Z]       │ │     └─TableRangeScan_93	1.00	7236275	cop[tikv]	table:orders	tikv_task:{proc max:180ms, min:0s, p80:68ms, p95:81ms, iters:30140, tasks:5230}	range: decided by [tpch50.lineitem.l_orderkey], keep order:false	N/A	N/A
20:46:53 [2021-06-05T20:46:53.270Z]       │ └─IndexLookUp_80(Probe)	4.05	17316434	root		time:1m54.6s, loops:17133, index_task: {total_time: 1m3.1s, fetch_handle: 54.9s, build: 4.13ms, wait: 8.2s}, table_task: {total_time: 8m15.6s, num: 1458, concurrency: 760}		19.2 KB	N/A
20:46:53 [2021-06-05T20:46:53.270Z]       │   ├─IndexRangeScan_78(Build)	4.05	17316434	cop[tikv]	table:l2, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:52.6s, loops:18630, cop_task: {num: 2991, max: 725.3ms, min: 647.8µs, avg: 181.2ms, p95: 366.5ms, max_proc_keys: 15422, p95_proc_keys: 8740, tot_proc: 6m48.6s, tot_wait: 1m51.2s, rpc_num: 2991, rpc_time: 9m1.8s, copr_cache: disabled}, tikv_task:{proc max:169ms, min:0s, p80:95ms, p95:111ms, iters:30061, tasks:2991}, scan_detail: {total_process_keys: 17316434, total_keys: 20812533, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17316434, block: {cache_hit_count: 24259938, read_count: 225682, 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:53 [2021-06-05T20:46:53.270Z]       │   └─TableRowIDScan_79(Probe)	4.05	17316434	cop[tikv]	table:l2	time:6m4.6s, loops:21018, cop_task: {num: 7803, max: 557ms, min: 492µs, avg: 171.7ms, p95: 348ms, max_proc_keys: 10633, p95_proc_keys: 4829, tot_proc: 16m3.8s, tot_wait: 5m25.4s, rpc_num: 7803, rpc_time: 22m19.7s, copr_cache: disabled}, tikv_task:{proc max:238ms, min:0s, p80:103ms, p95:138ms, iters:49978, tasks:7803}, scan_detail: {total_process_keys: 17316434, total_keys: 18290061, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5630901, block: {cache_hit_count: 99018122, read_count: 1123, read_byte: 404.7 MB}}}	keep order:false	N/A	N/A
20:46:53 [2021-06-05T20:46:53.270Z]       └─IndexLookUp_39(Probe)	4.05	12022741	root		time:1m49s, loops:11944, index_task: {total_time: 58.8s, fetch_handle: 47.5s, build: 3.16ms, wait: 11.2s}, table_task: {total_time: 7m51.3s, num: 1408, concurrency: 730}		216.7 KB	N/A
20:46:53 [2021-06-05T20:46:53.270Z]         ├─IndexRangeScan_36(Build)	5.06	17183316	cop[tikv]	table:l3, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:45.1s, loops:18347, cop_task: {num: 2767, max: 701.5ms, min: 517.2µs, avg: 159.1ms, p95: 355.3ms, max_proc_keys: 17902, p95_proc_keys: 13826, tot_proc: 5m28.6s, tot_wait: 1m30.8s, rpc_num: 2767, rpc_time: 7m20.2s, copr_cache: disabled}, tikv_task:{proc max:177ms, min:0s, p80:78ms, p95:120ms, iters:28983, tasks:2767}, scan_detail: {total_process_keys: 17183316, total_keys: 20546330, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17183316, block: {cache_hit_count: 23553904, 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:53 [2021-06-05T20:46:53.270Z]         └─Selection_38(Probe)	4.05	12022741	cop[tikv]		time:6m3.9s, loops:13776, cop_task: {num: 10215, max: 614.5ms, min: 475.3µs, avg: 170.3ms, p95: 342.4ms, max_proc_keys: 7921, p95_proc_keys: 3978, tot_proc: 20m24.9s, tot_wait: 7m27.6s, rpc_num: 10215, rpc_time: 28m58.9s, copr_cache: disabled}, tikv_task:{proc max:220ms, min:0s, p80:76ms, p95:114ms, iters:60598, tasks:10215}, scan_detail: {total_process_keys: 17183316, total_keys: 18128847, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5526051, block: {cache_hit_count: 98290036, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:46:53 [2021-06-05T20:46:53.270Z]           └─TableRowIDScan_37	5.06	17183316	cop[tikv]	table:l3	tikv_task:{proc max:218ms, min:0s, p80:76ms, p95:113ms, iters:60598, tasks:10215}	keep order:false	N/A	N/A
20:46:53 [2021-06-05T20:46:53.270Z] + sync
20:46:53 [2021-06-05T20:46:53.270Z] + /usr/bin/echo 3
20:48:14 [2021-06-05T20:48:14.627Z] 
20:48:14 [2021-06-05T20:48:14.628Z] queries/21.sql
20:48:14 [2021-06-05T20:48:14.628Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:48:14 [2021-06-05T20:48:14.628Z] Projection_26	100.00	100	root		time:1m20.6s, loops:2, Concurrency:OFF	tpch50.supplier.s_name, Column#72	4.62 KB	N/A
20:48:14 [2021-06-05T20:48:14.628Z] └─TopN_29	100.00	100	root		time:1m20.6s, loops:2	Column#72:desc, tpch50.supplier.s_name, offset:0, count:100	58.4 KB	N/A
20:48:14 [2021-06-05T20:48:14.628Z]   └─HashAgg_34	12800.00	20057	root		time:1m20.6s, loops:21, partial_worker:{wall_time:1m20.588161212s, concurrency:5, task_num:198, tot_wait:6m42.659296454s, tot_exec:265.492584ms, tot_time:6m42.939336138s, max:1m20.588136949s, p95:1m20.588136949s}, final_worker:{wall_time:1m20.604750683s, concurrency:5, task_num:25, tot_wait:6m42.938257993s, tot_exec:79.815078ms, tot_time:6m43.018085484s, max:1m20.604719643s, p95:1m20.604719643s}	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:14 [2021-06-05T20:48:14.628Z]     └─IndexHashJoin_42	7828961.66	198698	root		time:1m20.6s, loops:199, inner:{total:2m17.1s, concurrency:5, task:147, construct:6.61s, fetch:1m53.9s, build:1.18s, join:16.6s}	anti semi join, inner:IndexLookUp_39, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey)	641.1 MB	N/A
20:48:14 [2021-06-05T20:48:14.628Z]       ├─IndexHashJoin_83(Build)	9786202.08	3542799	root		time:1m20.1s, loops:3464, inner:{total:2m25s, concurrency:5, task:152, construct:7.92s, fetch:1m58.8s, build:1.23s, join:18.3s}	semi join, inner:IndexLookUp_80, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey), ne(tpch50.lineitem.l_suppkey, tpch50.supplier.s_suppkey)	555.9 MB	N/A
20:48:14 [2021-06-05T20:48:14.628Z]       │ ├─IndexJoin_99(Build)	12232752.60	3675878	root		time:1m19.4s, loops:3595, inner:{total:2m4.5s, concurrency:5, task:305, construct:16.6s, fetch:1m46s, build:1.83s}, probe:5.35s	inner join, inner:TableReader_95, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.orders.o_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.orders.o_orderkey)	575.4 MB	N/A
20:48:14 [2021-06-05T20:48:14.628Z]       │ │ ├─HashJoin_107(Build)	12232752.60	7609895	root		time:1m18.8s, loops:7436, build_hash_table:{total:1.13s, fetch:1.12s, build:6.74ms}, probe:{concurrency:5, total:6m35.9s, max:1m19.2s, probe:1m2.1s, fetch:5m33.7s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.lineitem.l_suppkey)]	732.8 KB	0 Bytes
20:48:14 [2021-06-05T20:48:14.628Z]       │ │ │ ├─HashJoin_120(Build)	20000.00	20058	root		time:1.13s, loops:22, build_hash_table:{total:148.4µs, fetch:143.4µs, build:5.06µs}, probe:{concurrency:5, total:5.65s, max:1.13s, probe:65.3ms, fetch:5.58s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:48:14 [2021-06-05T20:48:14.628Z]       │ │ │ │ ├─TableReader_125(Build)	1.00	1	root		time:45.8µs, loops:2, cop_task: {num: 1, max: 1.4ms, proc_keys: 25, tot_proc: 1ms, rpc_num: 1, rpc_time: 1.36ms, copr_cache: disabled}	data:Selection_124	248 Bytes	N/A
20:48:14 [2021-06-05T20:48:14.628Z]       │ │ │ │ │ └─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:14 [2021-06-05T20:48:14.628Z]       │ │ │ │ │   └─TableFullScan_123	25.00	25	cop[tikv]	table:nation	tikv_task:{time:1ms, loops:1}	keep order:false	N/A	N/A
20:48:14 [2021-06-05T20:48:14.628Z]       │ │ │ │ └─TableReader_122(Probe)	500000.00	500000	root		time:1.12s, loops:490, cop_task: {num: 1, max: 1.12s, proc_keys: 500000, tot_proc: 1.08s, rpc_num: 1, rpc_time: 1.12s, copr_cache: disabled}	data:TableFullScan_121	20.0 MB	N/A
20:48:14 [2021-06-05T20:48:14.628Z]       │ │ │ │   └─TableFullScan_121	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:1.02s, 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:14 [2021-06-05T20:48:14.628Z]       │ │ │ └─TableReader_128(Probe)	240004648.80	189670348	root		time:1m6.3s, loops:184598, cop_task: {num: 761, max: 2.53s, min: 289.4ms, avg: 1.52s, p95: 1.96s, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 18m7.4s, tot_wait: 57.1s, rpc_num: 761, rpc_time: 19m17.9s, copr_cache: disabled}	data:Selection_127	109.4 MB	N/A
20:48:14 [2021-06-05T20:48:14.628Z]       │ │ │   └─Selection_127	240004648.80	189670348	cop[tikv]		tikv_task:{proc max:1.36s, min:275ms, p80:1.19s, p95:1.24s, iters:296606, tasks:761}, scan_detail: {total_process_keys: 300005811, total_keys: 300006572, rocksdb: {delete_skipped_count: 0, key_skipped_count: 600010861, block: {cache_hit_count: 10453, read_count: 1114195, read_byte: 23.6 GB}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:48:14 [2021-06-05T20:48:14.628Z]       │ │ │     └─TableFullScan_126	300005811.00	300005811	cop[tikv]	table:l1	tikv_task:{proc max:1.29s, min:259ms, p80:1.1s, p95:1.15s, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:48:14 [2021-06-05T20:48:14.628Z]       │ │ └─TableReader_95(Probe)	0.49	3496182	root		time:1m37.1s, loops:3875, cop_task: {num: 5284, max: 571.2ms, min: 1.73ms, avg: 170.6ms, p95: 320.9ms, max_proc_keys: 3521, p95_proc_keys: 1955, tot_proc: 10m48.2s, tot_wait: 3m34.5s, rpc_num: 5284, rpc_time: 15m1.1s, copr_cache: disabled}	data:Selection_94	N/A	N/A
20:48:14 [2021-06-05T20:48:14.628Z]       │ │   └─Selection_94	0.49	3496182	cop[tikv]		tikv_task:{proc max:148ms, min:0s, p80:69ms, p95:81ms, iters:30295, tasks:5284}, scan_detail: {total_process_keys: 7236286, total_keys: 7795445, rocksdb: {delete_skipped_count: 0, key_skipped_count: 1778141, block: {cache_hit_count: 54006559, read_count: 218206, read_byte: 4.21 GB}}}	eq(tpch50.orders.o_orderstatus, "F")	N/A	N/A
20:48:14 [2021-06-05T20:48:14.628Z]       │ │     └─TableRangeScan_93	1.00	7236286	cop[tikv]	table:orders	tikv_task:{proc max:148ms, min:0s, p80:68ms, p95:81ms, iters:30295, tasks:5284}	range: decided by [tpch50.lineitem.l_orderkey], keep order:false	N/A	N/A
20:48:14 [2021-06-05T20:48:14.628Z]       │ └─IndexLookUp_80(Probe)	4.05	17316445	root		time:1m53s, loops:17135, index_task: {total_time: 1m2.6s, fetch_handle: 54.9s, build: 3.81ms, wait: 7.73s}, table_task: {total_time: 8m8.7s, num: 1458, concurrency: 760}		19.2 KB	N/A
20:48:14 [2021-06-05T20:48:14.628Z]       │   ├─IndexRangeScan_78(Build)	4.05	17316445	cop[tikv]	table:l2, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:52.6s, loops:18624, cop_task: {num: 3008, max: 696.4ms, min: 547.3µs, avg: 181.7ms, p95: 371.2ms, max_proc_keys: 13616, p95_proc_keys: 8774, tot_proc: 6m52.8s, tot_wait: 1m53.3s, rpc_num: 3008, rpc_time: 9m6.6s, copr_cache: disabled}, tikv_task:{proc max:188ms, min:0s, p80:95ms, p95:109ms, iters:30215, tasks:3008}, scan_detail: {total_process_keys: 17316445, total_keys: 20812547, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17316445, block: {cache_hit_count: 24259964, 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:14 [2021-06-05T20:48:14.628Z]       │   └─TableRowIDScan_79(Probe)	4.05	17316445	cop[tikv]	table:l2	time:6m0.2s, loops:20977, cop_task: {num: 7817, max: 594.3ms, min: 457.7µs, avg: 168.8ms, p95: 336.4ms, max_proc_keys: 10012, p95_proc_keys: 4815, tot_proc: 15m49s, tot_wait: 5m20.3s, rpc_num: 7817, rpc_time: 21m59.1s, copr_cache: disabled}, tikv_task:{proc max:260ms, min:0s, p80:104ms, p95:138ms, iters:49894, tasks:7817}, scan_detail: {total_process_keys: 17316445, total_keys: 18288950, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5626211, block: {cache_hit_count: 99023414, read_count: 1108, read_byte: 390.2 MB}}}	keep order:false	N/A	N/A
20:48:14 [2021-06-05T20:48:14.628Z]       └─IndexLookUp_39(Probe)	4.05	12022804	root		time:1m48.9s, loops:11945, index_task: {total_time: 57.8s, fetch_handle: 48.2s, build: 3.72ms, wait: 9.64s}, table_task: {total_time: 7m49.3s, num: 1410, concurrency: 735}		222.5 KB	N/A
20:48:14 [2021-06-05T20:48:14.628Z]         ├─IndexRangeScan_36(Build)	5.06	17183389	cop[tikv]	table:l3, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:45.9s, loops:18328, cop_task: {num: 2776, max: 633.7ms, min: 929.6µs, avg: 162.8ms, p95: 346.1ms, max_proc_keys: 20031, p95_proc_keys: 13530, tot_proc: 5m33.3s, tot_wait: 1m39.5s, rpc_num: 2776, rpc_time: 7m32s, copr_cache: disabled}, tikv_task:{proc max:194ms, min:0s, p80:78ms, p95:119ms, iters:29065, tasks:2776}, scan_detail: {total_process_keys: 17183389, total_keys: 20546416, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17183389, block: {cache_hit_count: 23553995, 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:14 [2021-06-05T20:48:14.628Z]         └─Selection_38(Probe)	4.05	12022804	cop[tikv]		time:5m59.4s, loops:13770, cop_task: {num: 10170, max: 521.2ms, min: 418.2µs, avg: 166.2ms, p95: 335.3ms, max_proc_keys: 7626, p95_proc_keys: 3989, tot_proc: 19m49.8s, tot_wait: 7m17.3s, rpc_num: 10170, rpc_time: 28m10s, copr_cache: disabled}, tikv_task:{proc max:236ms, min:0s, p80:77ms, p95:115ms, iters:60222, tasks:10170}, scan_detail: {total_process_keys: 17183389, total_keys: 18129315, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5526266, block: {cache_hit_count: 98289848, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:48:14 [2021-06-05T20:48:14.628Z]           └─TableRowIDScan_37	5.06	17183389	cop[tikv]	table:l3	tikv_task:{proc max:236ms, min:0s, p80:76ms, p95:114ms, iters:60222, tasks:10170}	keep order:false	N/A	N/A
20:48:14 [2021-06-05T20:48:14.628Z] + sync
20:48:14 [2021-06-05T20:48:14.628Z] + /usr/bin/echo 3
20:49:35 [2021-06-05T20:49:35.986Z] 
20:49:35 [2021-06-05T20:49:35.986Z] queries/21.sql
20:49:35 [2021-06-05T20:49:35.986Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:49:35 [2021-06-05T20:49:35.986Z] Projection_26	100.00	100	root		time:1m20.5s, loops:2, Concurrency:OFF	tpch50.supplier.s_name, Column#72	4.62 KB	N/A
20:49:35 [2021-06-05T20:49:35.986Z] └─TopN_29	100.00	100	root		time:1m20.5s, loops:2	Column#72:desc, tpch50.supplier.s_name, offset:0, count:100	58.4 KB	N/A
20:49:35 [2021-06-05T20:49:35.986Z]   └─HashAgg_34	12800.00	20057	root		time:1m20.5s, loops:21, partial_worker:{wall_time:1m20.489504137s, concurrency:5, task_num:197, tot_wait:6m42.167275075s, tot_exec:267.919082ms, tot_time:6m42.44675132s, max:1m20.489481425s, p95:1m20.489481425s}, final_worker:{wall_time:1m20.502777202s, concurrency:5, task_num:25, tot_wait:6m42.446348454s, tot_exec:67.037846ms, tot_time:6m42.513397818s, max:1m20.502756866s, p95:1m20.502756866s}	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:35 [2021-06-05T20:49:35.986Z]     └─IndexHashJoin_42	7828961.66	198698	root		time:1m20.5s, loops:198, inner:{total:2m14.9s, concurrency:5, task:146, construct:6.42s, fetch:1m51.8s, build:1.21s, 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:49:35 [2021-06-05T20:49:35.986Z]       ├─IndexHashJoin_83(Build)	9786202.08	3542799	root		time:1m20s, loops:3463, inner:{total:2m23.7s, concurrency:5, task:152, construct:8.04s, fetch:1m57.9s, build:1.35s, join:17.7s}	semi join, inner:IndexLookUp_80, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey), ne(tpch50.lineitem.l_suppkey, tpch50.supplier.s_suppkey)	555.9 MB	N/A
20:49:35 [2021-06-05T20:49:35.986Z]       │ ├─IndexJoin_99(Build)	12232752.60	3675878	root		time:1m19.3s, loops:3595, inner:{total:2m3.7s, concurrency:5, task:305, construct:16.6s, fetch:1m45.2s, build:1.88s}, probe:5.34s	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:35 [2021-06-05T20:49:35.986Z]       │ │ ├─HashJoin_107(Build)	12232752.60	7609895	root		time:1m18.9s, loops:7437, build_hash_table:{total:1.2s, fetch:1.19s, build:7.66ms}, probe:{concurrency:5, total:6m36.2s, max:1m19.2s, probe:1m1.7s, fetch:5m34.5s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.lineitem.l_suppkey)]	776.5 KB	0 Bytes
20:49:35 [2021-06-05T20:49:35.986Z]       │ │ │ ├─HashJoin_120(Build)	20000.00	20058	root		time:1.2s, loops:24, build_hash_table:{total:255.8µs, fetch:249.6µs, build:6.16µs}, probe:{concurrency:5, total:5.98s, max:1.2s, probe:70.4ms, fetch:5.91s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:49:35 [2021-06-05T20:49:35.986Z]       │ │ │ │ ├─TableReader_125(Build)	1.00	1	root		time:78.7µs, loops:2, cop_task: {num: 1, max: 1.23ms, proc_keys: 25, tot_proc: 1ms, rpc_num: 1, rpc_time: 1.19ms, copr_cache: disabled}	data:Selection_124	248 Bytes	N/A
20:49:35 [2021-06-05T20:49:35.986Z]       │ │ │ │ │ └─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:35 [2021-06-05T20:49:35.986Z]       │ │ │ │ │   └─TableFullScan_123	25.00	25	cop[tikv]	table:nation	tikv_task:{time:1ms, loops:1}	keep order:false	N/A	N/A
20:49:35 [2021-06-05T20:49:35.986Z]       │ │ │ │ └─TableReader_122(Probe)	500000.00	500000	root		time:1.18s, loops:490, cop_task: {num: 1, max: 1.18s, proc_keys: 500000, tot_proc: 1.16s, rpc_num: 1, rpc_time: 1.18s, copr_cache: disabled}	data:TableFullScan_121	20.0 MB	N/A
20:49:35 [2021-06-05T20:49:35.986Z]       │ │ │ │   └─TableFullScan_121	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:1.09s, loops:493}, scan_detail: {total_process_keys: 500000, total_keys: 500001, rocksdb: {delete_skipped_count: 0, key_skipped_count: 999999, block: {cache_hit_count: 13, read_count: 1679, read_byte: 104.5 MB}}}	keep order:false	N/A	N/A
20:49:35 [2021-06-05T20:49:35.986Z]       │ │ │ └─TableReader_128(Probe)	240004648.80	189670348	root		time:1m6.2s, loops:184596, cop_task: {num: 761, max: 2.56s, min: 255.9ms, avg: 1.52s, p95: 2s, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 18m6.3s, tot_wait: 57.1s, rpc_num: 761, rpc_time: 19m16.5s, copr_cache: disabled}	data:Selection_127	109.4 MB	N/A
20:49:35 [2021-06-05T20:49:35.986Z]       │ │ │   └─Selection_127	240004648.80	189670348	cop[tikv]		tikv_task:{proc max:1.32s, min:245ms, p80:1.18s, 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: 10453, read_count: 1114195, read_byte: 23.6 GB}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:49:35 [2021-06-05T20:49:35.986Z]       │ │ │     └─TableFullScan_126	300005811.00	300005811	cop[tikv]	table:l1	tikv_task:{proc max:1.23s, min:238ms, p80:1.1s, p95:1.13s, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:49:35 [2021-06-05T20:49:35.986Z]       │ │ └─TableReader_95(Probe)	0.49	3496185	root		time:1m36.8s, loops:3875, cop_task: {num: 5306, max: 518.8ms, min: 918.2µs, avg: 169.8ms, p95: 320.5ms, max_proc_keys: 3760, p95_proc_keys: 1959, tot_proc: 10m50.4s, tot_wait: 3m31.8s, rpc_num: 5306, rpc_time: 15m1.1s, copr_cache: disabled}	data:Selection_94	N/A	N/A
20:49:35 [2021-06-05T20:49:35.986Z]       │ │   └─Selection_94	0.49	3496185	cop[tikv]		tikv_task:{proc max:160ms, min:0s, p80:68ms, p95:81ms, iters:30339, tasks:5306}, scan_detail: {total_process_keys: 7236316, total_keys: 7795527, rocksdb: {delete_skipped_count: 0, key_skipped_count: 1778297, block: {cache_hit_count: 54006661, read_count: 218255, read_byte: 4.21 GB}}}	eq(tpch50.orders.o_orderstatus, "F")	N/A	N/A
20:49:35 [2021-06-05T20:49:35.986Z]       │ │     └─TableRangeScan_93	1.00	7236316	cop[tikv]	table:orders	tikv_task:{proc max:159ms, min:0s, p80:68ms, p95:81ms, iters:30339, tasks:5306}	range: decided by [tpch50.lineitem.l_orderkey], keep order:false	N/A	N/A
20:49:35 [2021-06-05T20:49:35.986Z]       │ └─IndexLookUp_80(Probe)	4.05	17316426	root		time:1m52.4s, loops:17131, index_task: {total_time: 1m1.1s, fetch_handle: 53.6s, build: 2.97ms, wait: 7.58s}, table_task: {total_time: 8m7.1s, num: 1458, concurrency: 760}		17.1 KB	N/A
20:49:35 [2021-06-05T20:49:35.986Z]       │   ├─IndexRangeScan_78(Build)	4.05	17316426	cop[tikv]	table:l2, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:51.4s, loops:18617, cop_task: {num: 2997, max: 620.6ms, min: 492.7µs, avg: 177.9ms, p95: 353.9ms, max_proc_keys: 14234, p95_proc_keys: 8707, tot_proc: 6m42.3s, tot_wait: 1m50.1s, rpc_num: 2997, rpc_time: 8m53.1s, copr_cache: disabled}, tikv_task:{proc max:176ms, min:0s, p80:95ms, p95:110ms, iters:30078, tasks:2997}, scan_detail: {total_process_keys: 17316426, total_keys: 20812522, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17316426, block: {cache_hit_count: 24259904, read_count: 225695, 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:35 [2021-06-05T20:49:35.986Z]       │   └─TableRowIDScan_79(Probe)	4.05	17316426	cop[tikv]	table:l2	time:6m0.3s, loops:21019, cop_task: {num: 7854, max: 713.1ms, min: 349.5µs, avg: 168.8ms, p95: 341.5ms, max_proc_keys: 10503, p95_proc_keys: 4844, tot_proc: 15m57.1s, tot_wait: 5m18.4s, rpc_num: 7854, rpc_time: 22m5.9s, copr_cache: disabled}, tikv_task:{proc max:263ms, min:0s, p80:103ms, p95:138ms, iters:50100, tasks:7854}, scan_detail: {total_process_keys: 17316426, total_keys: 18289121, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5626259, block: {cache_hit_count: 99024954, read_count: 1126, read_byte: 407.1 MB}}}	keep order:false	N/A	N/A
20:49:35 [2021-06-05T20:49:35.986Z]       └─IndexLookUp_39(Probe)	4.05	12022774	root		time:1m47.1s, loops:11950, index_task: {total_time: 57s, fetch_handle: 46.9s, build: 2.95ms, wait: 10.1s}, table_task: {total_time: 7m43.3s, num: 1408, concurrency: 730}		275.9 KB	N/A
20:49:35 [2021-06-05T20:49:35.986Z]         ├─IndexRangeScan_36(Build)	5.06	17183373	cop[tikv]	table:l3, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:44.6s, loops:18379, cop_task: {num: 2757, max: 611.6ms, min: 616.7µs, avg: 160.7ms, p95: 349.4ms, max_proc_keys: 17795, p95_proc_keys: 13450, tot_proc: 5m30.8s, tot_wait: 1m32.4s, rpc_num: 2757, rpc_time: 7m23s, copr_cache: disabled}, tikv_task:{proc max:183ms, min:0s, p80:79ms, p95:119ms, iters:28922, tasks:2757}, scan_detail: {total_process_keys: 17183373, total_keys: 20546395, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17183373, block: {cache_hit_count: 23553960, read_count: 0, read_byte: 0 Bytes}}}	range: decided by [eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey)], keep order:false	N/A	N/A
20:49:35 [2021-06-05T20:49:35.986Z]         └─Selection_38(Probe)	4.05	12022774	cop[tikv]		time:5m56.6s, loops:13751, cop_task: {num: 10153, max: 595.4ms, min: 468.7µs, avg: 165.7ms, p95: 331.7ms, max_proc_keys: 7042, p95_proc_keys: 3988, tot_proc: 19m43.3s, tot_wait: 7m13.4s, rpc_num: 10153, rpc_time: 28m2s, copr_cache: disabled}, tikv_task:{proc max:251ms, min:0s, p80:76ms, p95:116ms, iters:60233, tasks:10153}, scan_detail: {total_process_keys: 17183373, total_keys: 18129300, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5525413, block: {cache_hit_count: 98293690, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:49:35 [2021-06-05T20:49:35.986Z]           └─TableRowIDScan_37	5.06	17183373	cop[tikv]	table:l3	tikv_task:{proc max:248ms, min:0s, p80:76ms, p95:115ms, iters:60233, tasks:10153}	keep order:false	N/A	N/A
20:49:35 [2021-06-05T20:49:35.986Z] + sync
20:49:35 [2021-06-05T20:49:35.986Z] + /usr/bin/echo 3
20:51:12 [2021-06-05T20:51:12.355Z] 
20:51:12 [2021-06-05T20:51:12.355Z] queries/21.sql
20:51:12 [2021-06-05T20:51:12.355Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:51:12 [2021-06-05T20:51:12.355Z] Projection_26	100.00	100	root		time:1m20.7s, loops:2, Concurrency:OFF	tpch50.supplier.s_name, Column#72	4.62 KB	N/A
20:51:12 [2021-06-05T20:51:12.355Z] └─TopN_29	100.00	100	root		time:1m20.7s, loops:2	Column#72:desc, tpch50.supplier.s_name, offset:0, count:100	55.9 KB	N/A
20:51:12 [2021-06-05T20:51:12.355Z]   └─HashAgg_34	12800.00	20057	root		time:1m20.7s, loops:21, partial_worker:{wall_time:1m20.639934144s, concurrency:5, task_num:197, tot_wait:6m42.938189449s, tot_exec:246.780557ms, tot_time:6m43.198004948s, max:1m20.639904232s, p95:1m20.639904232s}, final_worker:{wall_time:1m20.655392726s, concurrency:5, task_num:25, tot_wait:6m43.196712316s, tot_exec:72.30056ms, tot_time:6m43.269025588s, max:1m20.655370358s, p95:1m20.655370358s}	group by:tpch50.supplier.s_name, funcs:count(1)->Column#72, funcs:firstrow(tpch50.supplier.s_name)->tpch50.supplier.s_name	17.2 MB	N/A
20:51:12 [2021-06-05T20:51:12.355Z]     └─IndexHashJoin_42	7828961.66	198698	root		time:1m20.6s, loops:198, inner:{total:2m18.7s, concurrency:5, task:147, construct:6.21s, fetch:1m56.1s, build:1.24s, join:16.4s}	anti semi join, inner:IndexLookUp_39, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey)	641.1 MB	N/A
20:51:12 [2021-06-05T20:51:12.355Z]       ├─IndexHashJoin_83(Build)	9786202.08	3542799	root		time:1m20.1s, loops:3464, inner:{total:2m26.3s, concurrency:5, task:152, construct:7.62s, fetch:2m1s, build:1.26s, 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:51:12 [2021-06-05T20:51:12.355Z]       │ ├─IndexJoin_99(Build)	12232752.60	3675878	root		time:1m19.5s, loops:3595, inner:{total:2m4s, concurrency:5, task:305, construct:16.3s, fetch:1m45.9s, build:1.82s}, probe:5.33s	inner join, inner:TableReader_95, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.orders.o_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.orders.o_orderkey)	575.3 MB	N/A
20:51:12 [2021-06-05T20:51:12.355Z]       │ │ ├─HashJoin_107(Build)	12232752.60	7609895	root		time:1m19s, loops:7436, build_hash_table:{total:1.12s, fetch:1.11s, build:7.58ms}, probe:{concurrency:5, total:6m36.6s, max:1m19.3s, probe:1m1.1s, fetch:5m35.5s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.lineitem.l_suppkey)]	737.6 KB	0 Bytes
20:51:12 [2021-06-05T20:51:12.355Z]       │ │ │ ├─HashJoin_120(Build)	20000.00	20058	root		time:1.12s, loops:22, build_hash_table:{total:302.8µs, fetch:296.4µs, build:6.34µs}, probe:{concurrency:5, total:5.59s, max:1.12s, probe:69.3ms, fetch:5.52s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:51:12 [2021-06-05T20:51:12.355Z]       │ │ │ │ ├─TableReader_125(Build)	1.00	1	root		time:68.6µs, loops:2, cop_task: {num: 1, max: 1.35ms, proc_keys: 25, rpc_num: 1, rpc_time: 1.31ms, copr_cache: disabled}	data:Selection_124	244 Bytes	N/A
20:51:12 [2021-06-05T20:51:12.355Z]       │ │ │ │ │ └─Selection_124	1.00	1	cop[tikv]		tikv_task:{time:0s, loops:1}, scan_detail: {total_process_keys: 25, total_keys: 26, rocksdb: {delete_skipped_count: 0, key_skipped_count: 46, block: {cache_hit_count: 17, read_count: 1, read_byte: 23.8 KB}}}	eq(tpch50.nation.n_name, "EGYPT")	N/A	N/A
20:51:12 [2021-06-05T20:51:12.355Z]       │ │ │ │ │   └─TableFullScan_123	25.00	25	cop[tikv]	table:nation	tikv_task:{time:0s, loops:1}	keep order:false	N/A	N/A
20:51:12 [2021-06-05T20:51:12.355Z]       │ │ │ │ └─TableReader_122(Probe)	500000.00	500000	root		time:1.1s, loops:490, cop_task: {num: 1, max: 1.11s, proc_keys: 500000, tot_proc: 1.07s, tot_wait: 1ms, rpc_num: 1, rpc_time: 1.11s, copr_cache: disabled}	data:TableFullScan_121	20.0 MB	N/A
20:51:12 [2021-06-05T20:51:12.355Z]       │ │ │ │   └─TableFullScan_121	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:1.01s, loops:493}, scan_detail: {total_process_keys: 500000, total_keys: 500001, rocksdb: {delete_skipped_count: 0, key_skipped_count: 999999, block: {cache_hit_count: 13, read_count: 1679, read_byte: 104.5 MB}}}	keep order:false	N/A	N/A
20:51:12 [2021-06-05T20:51:12.355Z]       │ │ │ └─TableReader_128(Probe)	240004648.80	189670348	root		time:1m6.5s, loops:184598, cop_task: {num: 761, max: 2.84s, min: 282ms, avg: 1.53s, p95: 1.99s, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 18m9.4s, tot_wait: 58.5s, rpc_num: 761, rpc_time: 19m21.1s, copr_cache: disabled}	data:Selection_127	109.4 MB	N/A
20:51:12 [2021-06-05T20:51:12.355Z]       │ │ │   └─Selection_127	240004648.80	189670348	cop[tikv]		tikv_task:{proc max:1.33s, min:260ms, p80:1.19s, p95:1.23s, 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:51:12 [2021-06-05T20:51:12.355Z]       │ │ │     └─TableFullScan_126	300005811.00	300005811	cop[tikv]	table:l1	tikv_task:{proc max:1.23s, min:250ms, p80:1.1s, p95:1.14s, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:51:12 [2021-06-05T20:51:12.355Z]       │ │ └─TableReader_95(Probe)	0.49	3496175	root		time:1m37.2s, loops:3875, cop_task: {num: 5288, max: 533.8ms, min: 1.52ms, avg: 174.8ms, p95: 332.4ms, max_proc_keys: 4483, p95_proc_keys: 1955, tot_proc: 11m4.7s, tot_wait: 3m39.5s, rpc_num: 5288, rpc_time: 15m24s, copr_cache: disabled}	data:Selection_94	N/A	N/A
20:51:12 [2021-06-05T20:51:12.355Z]       │ │   └─Selection_94	0.49	3496175	cop[tikv]		tikv_task:{proc max:210ms, min:0s, p80:68ms, p95:81ms, iters:30278, tasks:5288}, scan_detail: {total_process_keys: 7236289, total_keys: 7795514, rocksdb: {delete_skipped_count: 0, key_skipped_count: 1778367, block: {cache_hit_count: 54007068, read_count: 217731, read_byte: 4.20 GB}}}	eq(tpch50.orders.o_orderstatus, "F")	N/A	N/A
20:51:12 [2021-06-05T20:51:12.355Z]       │ │     └─TableRangeScan_93	1.00	7236289	cop[tikv]	table:orders	tikv_task:{proc max:209ms, min:0s, p80:68ms, p95:80ms, iters:30278, tasks:5288}	range: decided by [tpch50.lineitem.l_orderkey], keep order:false	N/A	N/A
20:51:12 [2021-06-05T20:51:12.355Z]       │ └─IndexLookUp_80(Probe)	4.05	17316500	root		time:1m55.6s, loops:17127, index_task: {total_time: 1m3.6s, fetch_handle: 55.1s, build: 17.7ms, wait: 8.47s}, table_task: {total_time: 8m18.9s, num: 1458, concurrency: 760}		19.0 KB	N/A
20:51:12 [2021-06-05T20:51:12.355Z]       │   ├─IndexRangeScan_78(Build)	4.05	17316500	cop[tikv]	table:l2, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:52.8s, loops:18601, cop_task: {num: 3026, max: 663.5ms, min: 471.3µs, avg: 179.2ms, p95: 367.6ms, max_proc_keys: 10873, p95_proc_keys: 8768, tot_proc: 6m52.4s, tot_wait: 1m49.6s, rpc_num: 3026, rpc_time: 9m2.3s, copr_cache: disabled}, tikv_task:{proc max:165ms, min:0s, p80:95ms, p95:111ms, iters:30181, tasks:3026}, scan_detail: {total_process_keys: 17316500, total_keys: 20812609, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17316500, block: {cache_hit_count: 24260007, 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:51:12 [2021-06-05T20:51:12.355Z]       │   └─TableRowIDScan_79(Probe)	4.05	17316500	cop[tikv]	table:l2	time:6m11.9s, loops:21023, cop_task: {num: 7805, max: 618.1ms, min: 662.2µs, avg: 174.1ms, p95: 357.6ms, max_proc_keys: 9863, p95_proc_keys: 4865, tot_proc: 16m20.1s, tot_wait: 5m28.5s, rpc_num: 7805, rpc_time: 22m38.7s, copr_cache: disabled}, tikv_task:{proc max:268ms, min:0s, p80:105ms, p95:139ms, iters:49885, tasks:7805}, scan_detail: {total_process_keys: 17316500, total_keys: 18289094, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5627980, block: {cache_hit_count: 99018836, read_count: 1119, read_byte: 400.8 MB}}}	keep order:false	N/A	N/A
20:51:12 [2021-06-05T20:51:12.355Z]       └─IndexLookUp_39(Probe)	4.05	12022801	root		time:1m51.2s, loops:11945, index_task: {total_time: 1m0.2s, fetch_handle: 49.5s, build: 2.9ms, wait: 10.7s}, table_task: {total_time: 7m59.9s, num: 1410, concurrency: 735}		218.2 KB	N/A
20:51:12 [2021-06-05T20:51:12.355Z]         ├─IndexRangeScan_36(Build)	5.06	17183418	cop[tikv]	table:l3, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:47.1s, loops:18329, cop_task: {num: 2793, max: 767ms, min: 1.23ms, avg: 165.3ms, p95: 359.6ms, max_proc_keys: 17650, p95_proc_keys: 13632, tot_proc: 5m43.9s, tot_wait: 1m37.1s, rpc_num: 2793, rpc_time: 7m41.6s, copr_cache: disabled}, tikv_task:{proc max:172ms, min:0s, p80:77ms, p95:119ms, iters:29082, tasks:2793}, scan_detail: {total_process_keys: 17183418, total_keys: 20546449, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17183418, block: {cache_hit_count: 23554023, read_count: 0, read_byte: 0 Bytes}}}	range: decided by [eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey)], keep order:false	N/A	N/A
20:51:12 [2021-06-05T20:51:12.355Z]         └─Selection_38(Probe)	4.05	12022801	cop[tikv]		time:6m8.9s, loops:13782, cop_task: {num: 10203, max: 679.6ms, min: 710µs, avg: 174ms, p95: 351.2ms, max_proc_keys: 7752, p95_proc_keys: 3916, tot_proc: 20m53.7s, tot_wait: 7m36.4s, rpc_num: 10203, rpc_time: 29m35s, copr_cache: disabled}, tikv_task:{proc max:234ms, min:0s, p80:76ms, p95:115ms, iters:60602, tasks:10203}, scan_detail: {total_process_keys: 17183418, total_keys: 18129651, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5527229, block: {cache_hit_count: 98294793, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:51:12 [2021-06-05T20:51:12.355Z]           └─TableRowIDScan_37	5.06	17183418	cop[tikv]	table:l3	tikv_task:{proc max:234ms, min:0s, p80:75ms, p95:114ms, iters:60602, tasks:10203}	keep order:false	N/A	N/A
20:51:12 [2021-06-05T20:51:12.355Z] + sync
20:51:12 [2021-06-05T20:51:12.355Z] + /usr/bin/echo 3
20:52:33 [2021-06-05T20:52:33.725Z] 
20:52:33 [2021-06-05T20:52:33.725Z] queries/21.sql
20:52:33 [2021-06-05T20:52:33.725Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:52:33 [2021-06-05T20:52:33.725Z] Projection_26	100.00	100	root		time:1m20.5s, loops:2, Concurrency:OFF	tpch50.supplier.s_name, Column#72	4.62 KB	N/A
20:52:33 [2021-06-05T20:52:33.725Z] └─TopN_29	100.00	100	root		time:1m20.5s, loops:2	Column#72:desc, tpch50.supplier.s_name, offset:0, count:100	58.4 KB	N/A
20:52:33 [2021-06-05T20:52:33.725Z]   └─HashAgg_34	12800.00	20057	root		time:1m20.5s, loops:21, partial_worker:{wall_time:1m20.47399257s, concurrency:5, task_num:197, tot_wait:6m42.073104604s, tot_exec:281.454404ms, tot_time:6m42.368422922s, max:1m20.473968191s, p95:1m20.473968191s}, final_worker:{wall_time:1m20.489489456s, concurrency:5, task_num:25, tot_wait:6m42.366131909s, tot_exec:73.702319ms, tot_time:6m42.439845397s, max:1m20.489470342s, p95:1m20.489470342s}	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:33 [2021-06-05T20:52:33.725Z]     └─IndexHashJoin_42	7828961.66	198698	root		time:1m20.5s, loops:198, inner:{total:2m16.4s, concurrency:5, task:147, construct:6.33s, fetch:1m53.9s, build:1.22s, 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.0 MB	N/A
20:52:33 [2021-06-05T20:52:33.725Z]       ├─IndexHashJoin_83(Build)	9786202.08	3542799	root		time:1m20s, loops:3463, inner:{total:2m25.4s, concurrency:5, task:152, construct:7.54s, fetch:2m0.4s, build:1.33s, join:17.5s}	semi join, inner:IndexLookUp_80, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey), ne(tpch50.lineitem.l_suppkey, tpch50.supplier.s_suppkey)	555.9 MB	N/A
20:52:33 [2021-06-05T20:52:33.725Z]       │ ├─IndexJoin_99(Build)	12232752.60	3675878	root		time:1m19.4s, loops:3595, inner:{total:2m5s, concurrency:5, task:305, construct:15.9s, fetch:1m47.3s, build:1.83s}, probe:5.32s	inner join, inner:TableReader_95, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.orders.o_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.orders.o_orderkey)	575.4 MB	N/A
20:52:33 [2021-06-05T20:52:33.725Z]       │ │ ├─HashJoin_107(Build)	12232752.60	7609895	root		time:1m18.9s, loops:7436, build_hash_table:{total:1.02s, fetch:1.01s, build:6.31ms}, probe:{concurrency:5, total:6m36.2s, max:1m19.2s, probe:1m1.8s, fetch:5m34.4s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.lineitem.l_suppkey)]	732.8 KB	0 Bytes
20:52:33 [2021-06-05T20:52:33.725Z]       │ │ │ ├─HashJoin_120(Build)	20000.00	20058	root		time:1.01s, loops:22, build_hash_table:{total:201µs, fetch:194.2µs, build:6.79µs}, probe:{concurrency:5, total:5.07s, max:1.01s, probe:59.4ms, fetch:5.01s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:52:33 [2021-06-05T20:52:33.725Z]       │ │ │ │ ├─TableReader_125(Build)	1.00	1	root		time:50.9µs, loops:2, cop_task: {num: 1, max: 1.27ms, proc_keys: 25, tot_proc: 1ms, rpc_num: 1, rpc_time: 1.25ms, copr_cache: disabled}	data:Selection_124	248 Bytes	N/A
20:52:33 [2021-06-05T20:52:33.725Z]       │ │ │ │ │ └─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:33 [2021-06-05T20:52:33.725Z]       │ │ │ │ │   └─TableFullScan_123	25.00	25	cop[tikv]	table:nation	tikv_task:{time:1ms, loops:1}	keep order:false	N/A	N/A
20:52:33 [2021-06-05T20:52:33.725Z]       │ │ │ │ └─TableReader_122(Probe)	500000.00	500000	root		time:1s, loops:490, cop_task: {num: 1, max: 1s, proc_keys: 500000, tot_proc: 970ms, rpc_num: 1, rpc_time: 1s, copr_cache: disabled}	data:TableFullScan_121	20.0 MB	N/A
20:52:33 [2021-06-05T20:52:33.725Z]       │ │ │ │   └─TableFullScan_121	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:905ms, 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:33 [2021-06-05T20:52:33.725Z]       │ │ │ └─TableReader_128(Probe)	240004648.80	189670348	root		time:1m6.3s, loops:184597, cop_task: {num: 761, max: 2.89s, min: 262.9ms, avg: 1.52s, p95: 1.95s, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 18m5.8s, tot_wait: 59.1s, rpc_num: 761, rpc_time: 19m18.1s, copr_cache: disabled}	data:Selection_127	109.4 MB	N/A
20:52:33 [2021-06-05T20:52:33.725Z]       │ │ │   └─Selection_127	240004648.80	189670348	cop[tikv]		tikv_task:{proc max:1.33s, min:249ms, p80:1.18s, p95:1.23s, iters:296606, tasks:761}, scan_detail: {total_process_keys: 300005811, total_keys: 300006572, rocksdb: {delete_skipped_count: 0, key_skipped_count: 600010861, block: {cache_hit_count: 10450, read_count: 1114198, read_byte: 23.6 GB}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:52:33 [2021-06-05T20:52:33.725Z]       │ │ │     └─TableFullScan_126	300005811.00	300005811	cop[tikv]	table:l1	tikv_task:{proc max:1.25s, min:240ms, p80:1.1s, p95:1.14s, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:52:33 [2021-06-05T20:52:33.725Z]       │ │ └─TableReader_95(Probe)	0.49	3496204	root		time:1m38.7s, loops:3875, cop_task: {num: 5255, max: 505.7ms, min: 1.9ms, avg: 175ms, p95: 340.1ms, max_proc_keys: 3278, p95_proc_keys: 1970, tot_proc: 11m3.9s, tot_wait: 3m36.9s, rpc_num: 5255, rpc_time: 15m19.7s, copr_cache: disabled}	data:Selection_94	N/A	N/A
20:52:33 [2021-06-05T20:52:33.725Z]       │ │   └─Selection_94	0.49	3496204	cop[tikv]		tikv_task:{proc max:130ms, min:0s, p80:69ms, p95:82ms, iters:30196, tasks:5255}, scan_detail: {total_process_keys: 7236290, total_keys: 7795531, rocksdb: {delete_skipped_count: 0, key_skipped_count: 1778421, block: {cache_hit_count: 54006471, read_count: 218235, read_byte: 4.21 GB}}}	eq(tpch50.orders.o_orderstatus, "F")	N/A	N/A
20:52:33 [2021-06-05T20:52:33.725Z]       │ │     └─TableRangeScan_93	1.00	7236290	cop[tikv]	table:orders	tikv_task:{proc max:130ms, min:0s, p80:68ms, p95:81ms, iters:30196, tasks:5255}	range: decided by [tpch50.lineitem.l_orderkey], keep order:false	N/A	N/A
20:52:33 [2021-06-05T20:52:33.725Z]       │ └─IndexLookUp_80(Probe)	4.05	17316584	root		time:1m55.2s, loops:17132, index_task: {total_time: 1m4.3s, fetch_handle: 55.3s, build: 2.88ms, wait: 9.05s}, table_task: {total_time: 8m17.4s, num: 1458, concurrency: 760}		18.9 KB	N/A
20:52:33 [2021-06-05T20:52:33.725Z]       │   ├─IndexRangeScan_78(Build)	4.05	17316584	cop[tikv]	table:l2, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:53s, loops:18621, cop_task: {num: 2970, max: 752.2ms, min: 439.8µs, avg: 185.3ms, p95: 366.5ms, max_proc_keys: 13211, p95_proc_keys: 8796, tot_proc: 6m51.5s, tot_wait: 1m58s, rpc_num: 2970, rpc_time: 9m10.2s, copr_cache: disabled}, tikv_task:{proc max:169ms, min:0s, p80:96ms, p95:111ms, iters:30031, tasks:2970}, scan_detail: {total_process_keys: 17316584, total_keys: 20812707, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17316584, block: {cache_hit_count: 24260110, read_count: 225679, read_byte: 2.00 GB}}}	range: decided by [eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey)], keep order:false	N/A	N/A
20:52:33 [2021-06-05T20:52:33.725Z]       │   └─TableRowIDScan_79(Probe)	4.05	17316584	cop[tikv]	table:l2	time:6m7.1s, loops:21005, cop_task: {num: 7822, max: 594.5ms, min: 494.7µs, avg: 172.1ms, p95: 350.1ms, max_proc_keys: 9389, p95_proc_keys: 4829, tot_proc: 16m7.9s, tot_wait: 5m28.1s, rpc_num: 7822, rpc_time: 22m26s, copr_cache: disabled}, tikv_task:{proc max:250ms, min:0s, p80:103ms, p95:137ms, iters:49974, tasks:7822}, scan_detail: {total_process_keys: 17316584, total_keys: 18288694, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5625786, block: {cache_hit_count: 99019825, read_count: 1108, read_byte: 385.2 MB}}}	keep order:false	N/A	N/A
20:52:33 [2021-06-05T20:52:33.725Z]       └─IndexLookUp_39(Probe)	4.05	12022868	root		time:1m49.1s, loops:11944, index_task: {total_time: 58.2s, fetch_handle: 47.5s, build: 2.87ms, wait: 10.7s}, table_task: {total_time: 7m52.8s, num: 1410, concurrency: 735}		212.9 KB	N/A
20:52:33 [2021-06-05T20:52:33.725Z]         ├─IndexRangeScan_36(Build)	5.06	17183480	cop[tikv]	table:l3, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:45.3s, loops:18353, cop_task: {num: 2745, max: 705.8ms, min: 938.3µs, avg: 163.2ms, p95: 347.7ms, max_proc_keys: 17902, p95_proc_keys: 13659, tot_proc: 5m36.4s, tot_wait: 1m31.2s, rpc_num: 2745, rpc_time: 7m27.8s, copr_cache: disabled}, tikv_task:{proc max:172ms, min:0s, p80:78ms, p95:120ms, iters:28930, tasks:2745}, scan_detail: {total_process_keys: 17183480, total_keys: 20546522, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17183480, block: {cache_hit_count: 23554101, 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:33 [2021-06-05T20:52:33.725Z]         └─Selection_38(Probe)	4.05	12022868	cop[tikv]		time:6m5.4s, loops:13777, cop_task: {num: 10268, max: 636.2ms, min: 371.7µs, avg: 169.9ms, p95: 346ms, max_proc_keys: 8164, p95_proc_keys: 3973, tot_proc: 20m23.8s, tot_wait: 7m35.9s, rpc_num: 10268, rpc_time: 29m4.3s, copr_cache: disabled}, tikv_task:{proc max:241ms, min:0s, p80:75ms, p95:113ms, iters:60763, tasks:10268}, scan_detail: {total_process_keys: 17183480, total_keys: 18129433, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5527755, block: {cache_hit_count: 98288624, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:52:33 [2021-06-05T20:52:33.725Z]           └─TableRowIDScan_37	5.06	17183480	cop[tikv]	table:l3	tikv_task:{proc max:239ms, min:0s, p80:74ms, p95:112ms, iters:60763, tasks:10268}	keep order:false	N/A	N/A
20:52:33 [2021-06-05T20:52:33.725Z] + sync
20:52:33 [2021-06-05T20:52:33.725Z] + /usr/bin/echo 3
20:53:55 [2021-06-05T20:53:55.104Z] 
20:53:55 [2021-06-05T20:53:55.104Z] queries/21.sql
20:53:55 [2021-06-05T20:53:55.104Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:53:55 [2021-06-05T20:53:55.104Z] Projection_26	100.00	100	root		time:1m20.5s, loops:2, Concurrency:OFF	tpch50.supplier.s_name, Column#72	4.62 KB	N/A
20:53:55 [2021-06-05T20:53:55.104Z] └─TopN_29	100.00	100	root		time:1m20.5s, loops:2	Column#72:desc, tpch50.supplier.s_name, offset:0, count:100	58.4 KB	N/A
20:53:55 [2021-06-05T20:53:55.104Z]   └─HashAgg_34	12800.00	20057	root		time:1m20.5s, loops:21, partial_worker:{wall_time:1m20.531910248s, concurrency:5, task_num:197, tot_wait:6m42.3996755s, tot_exec:247.178117ms, tot_time:6m42.658353762s, max:1m20.53187393s, p95:1m20.53187393s}, final_worker:{wall_time:1m20.544891872s, concurrency:5, task_num:25, tot_wait:6m42.657446376s, tot_exec:66.104747ms, tot_time:6m42.723563185s, max:1m20.544822072s, p95:1m20.544822072s}	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:55 [2021-06-05T20:53:55.104Z]     └─IndexHashJoin_42	7828961.66	198698	root		time:1m20.5s, loops:198, inner:{total:2m13.6s, concurrency:5, task:146, construct:6.22s, fetch:1m50.8s, build:1.23s, join:16.6s}	anti semi join, inner:IndexLookUp_39, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey)	641.0 MB	N/A
20:53:55 [2021-06-05T20:53:55.104Z]       ├─IndexHashJoin_83(Build)	9786202.08	3542799	root		time:1m20s, loops:3463, inner:{total:2m23.5s, concurrency:5, task:152, construct:7.29s, fetch:1m58.8s, build:1.22s, 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:55 [2021-06-05T20:53:55.104Z]       │ ├─IndexJoin_99(Build)	12232752.60	3675878	root		time:1m19.4s, loops:3595, inner:{total:2m3.1s, concurrency:5, task:305, construct:16.6s, fetch:1m44.5s, build:1.95s}, probe:5.18s	inner join, inner:TableReader_95, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.orders.o_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.orders.o_orderkey)	575.5 MB	N/A
20:53:55 [2021-06-05T20:53:55.104Z]       │ │ ├─HashJoin_107(Build)	12232752.60	7609895	root		time:1m18.9s, loops:7436, build_hash_table:{total:946.7ms, fetch:939.2ms, build:7.46ms}, probe:{concurrency:5, total:6m36.5s, max:1m19.3s, probe:1m1.8s, fetch:5m34.7s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.lineitem.l_suppkey)]	732.8 KB	0 Bytes
20:53:55 [2021-06-05T20:53:55.104Z]       │ │ │ ├─HashJoin_120(Build)	20000.00	20058	root		time:944.2ms, loops:22, build_hash_table:{total:174.7µs, fetch:169.6µs, build:5.08µs}, probe:{concurrency:5, total:4.73s, max:945.1ms, probe:66.6ms, fetch:4.66s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:53:55 [2021-06-05T20:53:55.104Z]       │ │ │ │ ├─TableReader_125(Build)	1.00	1	root		time:54.8µs, loops:2, cop_task: {num: 1, max: 1.19ms, proc_keys: 25, rpc_num: 1, rpc_time: 1.15ms, copr_cache: disabled}	data:Selection_124	244 Bytes	N/A
20:53:55 [2021-06-05T20:53:55.104Z]       │ │ │ │ │ └─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:55 [2021-06-05T20:53:55.104Z]       │ │ │ │ │   └─TableFullScan_123	25.00	25	cop[tikv]	table:nation	tikv_task:{time:0s, loops:1}	keep order:false	N/A	N/A
20:53:55 [2021-06-05T20:53:55.104Z]       │ │ │ │ └─TableReader_122(Probe)	500000.00	500000	root		time:931.6ms, loops:490, cop_task: {num: 1, max: 932.3ms, proc_keys: 500000, tot_proc: 900ms, tot_wait: 1ms, rpc_num: 1, rpc_time: 932.2ms, copr_cache: disabled}	data:TableFullScan_121	20.0 MB	N/A
20:53:55 [2021-06-05T20:53:55.104Z]       │ │ │ │   └─TableFullScan_121	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:843ms, 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:55 [2021-06-05T20:53:55.104Z]       │ │ │ └─TableReader_128(Probe)	240004648.80	189670348	root		time:1m6.5s, loops:184597, cop_task: {num: 761, max: 2.68s, min: 296.4ms, avg: 1.52s, p95: 1.98s, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 18m10s, tot_wait: 56.8s, rpc_num: 761, rpc_time: 19m19.9s, copr_cache: disabled}	data:Selection_127	109.4 MB	N/A
20:53:55 [2021-06-05T20:53:55.104Z]       │ │ │   └─Selection_127	240004648.80	189670348	cop[tikv]		tikv_task:{proc max:1.37s, min:278ms, p80:1.19s, p95:1.23s, 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: 10448, read_count: 1114200, read_byte: 23.6 GB}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:53:55 [2021-06-05T20:53:55.104Z]       │ │ │     └─TableFullScan_126	300005811.00	300005811	cop[tikv]	table:l1	tikv_task:{proc max:1.28s, min:261ms, p80:1.1s, p95:1.14s, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:53:55 [2021-06-05T20:53:55.104Z]       │ │ └─TableReader_95(Probe)	0.49	3496171	root		time:1m35.6s, loops:3875, cop_task: {num: 5249, max: 561.6ms, min: 1.5ms, avg: 172.8ms, p95: 331.8ms, max_proc_keys: 3845, p95_proc_keys: 1946, tot_proc: 10m54.3s, tot_wait: 3m32.9s, rpc_num: 5249, rpc_time: 15m6.9s, copr_cache: disabled}	data:Selection_94	N/A	N/A
20:53:55 [2021-06-05T20:53:55.104Z]       │ │   └─Selection_94	0.49	3496171	cop[tikv]		tikv_task:{proc max:171ms, min:0s, p80:68ms, p95:81ms, iters:30181, tasks:5249}, scan_detail: {total_process_keys: 7236267, total_keys: 7795498, rocksdb: {delete_skipped_count: 0, key_skipped_count: 1778343, block: {cache_hit_count: 54005978, read_count: 218215, read_byte: 4.21 GB}}}	eq(tpch50.orders.o_orderstatus, "F")	N/A	N/A
20:53:55 [2021-06-05T20:53:55.104Z]       │ │     └─TableRangeScan_93	1.00	7236267	cop[tikv]	table:orders	tikv_task:{proc max:171ms, min:0s, p80:68ms, p95:81ms, iters:30181, tasks:5249}	range: decided by [tpch50.lineitem.l_orderkey], keep order:false	N/A	N/A
20:53:55 [2021-06-05T20:53:55.104Z]       │ └─IndexLookUp_80(Probe)	4.05	17316380	root		time:1m53.3s, loops:17129, index_task: {total_time: 1m2.6s, fetch_handle: 54.2s, build: 3.17ms, wait: 8.41s}, table_task: {total_time: 8m6.4s, num: 1458, concurrency: 760}		18.9 KB	N/A
20:53:55 [2021-06-05T20:53:55.104Z]       │   ├─IndexRangeScan_78(Build)	4.05	17316380	cop[tikv]	table:l2, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:52s, loops:18641, cop_task: {num: 2984, max: 712.4ms, min: 388.3µs, avg: 179.2ms, p95: 367.4ms, max_proc_keys: 12891, p95_proc_keys: 8751, tot_proc: 6m45.9s, tot_wait: 1m47.1s, rpc_num: 2984, rpc_time: 8m54.8s, copr_cache: disabled}, tikv_task:{proc max:169ms, min:0s, p80:95ms, p95:111ms, iters:30097, tasks:2984}, scan_detail: {total_process_keys: 17316380, total_keys: 20812470, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17316380, block: {cache_hit_count: 24259878, read_count: 225679, read_byte: 2.00 GB}}}	range: decided by [eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey)], keep order:false	N/A	N/A
20:53:55 [2021-06-05T20:53:55.104Z]       │   └─TableRowIDScan_79(Probe)	4.05	17316380	cop[tikv]	table:l2	time:6m0.4s, loops:20983, cop_task: {num: 7771, max: 617.5ms, min: 510.1µs, avg: 169.8ms, p95: 345.6ms, max_proc_keys: 12656, p95_proc_keys: 4869, tot_proc: 15m55.6s, tot_wait: 5m13.2s, rpc_num: 7771, rpc_time: 21m59.4s, copr_cache: disabled}, tikv_task:{proc max:265ms, min:0s, p80:104ms, p95:138ms, iters:49930, tasks:7771}, scan_detail: {total_process_keys: 17316380, total_keys: 18289978, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5630298, block: {cache_hit_count: 99018880, read_count: 1104, read_byte: 394.4 MB}}}	keep order:false	N/A	N/A
20:53:55 [2021-06-05T20:53:55.104Z]       └─IndexLookUp_39(Probe)	4.05	12022726	root		time:1m46.1s, loops:11947, index_task: {total_time: 57.8s, fetch_handle: 48.3s, build: 4.53ms, wait: 9.52s}, table_task: {total_time: 7m40.8s, num: 1408, concurrency: 730}		266.5 KB	N/A
20:53:55 [2021-06-05T20:53:55.104Z]         ├─IndexRangeScan_36(Build)	5.06	17183293	cop[tikv]	table:l3, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:45.9s, loops:18370, cop_task: {num: 2765, max: 747.4ms, min: 619µs, avg: 161.4ms, p95: 347.7ms, max_proc_keys: 22268, p95_proc_keys: 13584, tot_proc: 5m33.1s, tot_wait: 1m34s, rpc_num: 2765, rpc_time: 7m26.3s, copr_cache: disabled}, tikv_task:{proc max:201ms, min:0s, p80:77ms, p95:119ms, iters:29023, tasks:2765}, scan_detail: {total_process_keys: 17183293, total_keys: 20546303, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17183293, block: {cache_hit_count: 23553877, 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:55 [2021-06-05T20:53:55.104Z]         └─Selection_38(Probe)	4.05	12022726	cop[tikv]		time:5m51.8s, loops:13772, cop_task: {num: 10249, max: 735.8ms, min: 436.7µs, avg: 165.4ms, p95: 334.8ms, max_proc_keys: 8382, p95_proc_keys: 3947, tot_proc: 19m51.6s, tot_wait: 7m17.6s, rpc_num: 10249, rpc_time: 28m14.7s, copr_cache: disabled}, tikv_task:{proc max:228ms, min:0s, p80:76ms, p95:114ms, iters:60840, tasks:10249}, scan_detail: {total_process_keys: 17183293, total_keys: 18128033, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5521876, block: {cache_hit_count: 98296025, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:53:55 [2021-06-05T20:53:55.104Z]           └─TableRowIDScan_37	5.06	17183293	cop[tikv]	table:l3	tikv_task:{proc max:226ms, min:0s, p80:75ms, p95:113ms, iters:60840, tasks:10249}	keep order:false	N/A	N/A
20:53:55 [2021-06-05T20:53:55.104Z] + tiup cluster stop benchbot -y
20:53:55 [2021-06-05T20:53:55.104Z] Starting component `cluster`: /home/tidb/.tiup/components/cluster/v1.4.4/tiup-cluster stop benchbot -y
20:54:05 [2021-06-05T20:54:05.027Z] + rm -rf '/data1/tidb-deploy/*/log/*'
20:54:05 [2021-06-05T20:54:05.027Z] + rm -rf /data1/jenkins/deploy/data/tikv-20160
20:54:08 [2021-06-05T20:54:08.287Z] + rm -rf /data1/jenkins/deploy/data/pd-2379
20:54:08 [2021-06-05T20:54:08.287Z] + rm -rf /data1/jenkins/restore_data/tpch50/data/last_tikv.toml
20:54:08 [2021-06-05T20:54:08.287Z] + cp -R /data1/jenkins/restore_data/tpch50/data /data1/jenkins/deploy/data/tikv-20160
20:55:44 [2021-06-05T20:55:44.806Z] + cp -R /data1/jenkins/restore_data/tpch50/data.pd /data1/jenkins/deploy/data/pd-2379
20:55:44 [2021-06-05T20:55:44.806Z] + '[' -n '' ']'
20:55:44 [2021-06-05T20:55:44.806Z] + tiup cluster start benchbot --wait-timeout=300
20:55:44 [2021-06-05T20:55:44.806Z] Starting component `cluster`: /home/tidb/.tiup/components/cluster/v1.4.4/tiup-cluster start benchbot --wait-timeout=300
20:56:11 [2021-06-05T20:56:11.284Z] + sync
20:56:11 [2021-06-05T20:56:11.284Z] + /usr/bin/echo 3
20:56:49 [2021-06-05T20:56:49.970Z] + sync
20:56:49 [2021-06-05T20:56:49.970Z] + /usr/bin/echo 3
20:57:21 [2021-06-05T20:57:21.981Z] + sync
20:57:21 [2021-06-05T20:57:21.981Z] + /usr/bin/echo 3
20:57:48 [2021-06-05T20:57:48.461Z] 
20:57:48 [2021-06-05T20:57:48.461Z] queries/22.sql
20:57:48 [2021-06-05T20:57:48.461Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:57:48 [2021-06-05T20:57:48.461Z] Sort_39	1600000.00	4	root		time:26.5s, loops:2	Column#27	9.48 KB	0 Bytes
20:57:48 [2021-06-05T20:57:48.461Z] └─Projection_41	1600000.00	4	root		time:26.5s, loops:5, Concurrency:5	Column#27, Column#28, Column#29	23.7 KB	N/A
20:57:48 [2021-06-05T20:57:48.461Z]   └─HashAgg_42	1600000.00	4	root		time:26.5s, loops:5, partial_worker:{wall_time:26.536767833s, concurrency:5, task_num:180, tot_wait:2m12.634624694s, tot_exec:47.766901ms, tot_time:2m12.682530862s, max:26.536656887s, p95:26.536656887s}, final_worker:{wall_time:26.536800748s, concurrency:5, task_num:20, tot_wait:2m12.683309921s, tot_exec:196.205µs, tot_time:2m12.683527992s, max:26.536734781s, p95:26.536734781s}	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:48 [2021-06-05T20:57:48.461Z]     └─Projection_51	1600000.00	181704	root		time:26.5s, loops:181, Concurrency:5	tpch50.customer.c_acctbal, substring(tpch50.customer.c_phone, 1, 2)->Column#32, substring(tpch50.customer.c_phone, 1, 2)->Column#33	693.6 KB	N/A
20:57:48 [2021-06-05T20:57:48.461Z]       └─HashJoin_43	1600000.00	181704	root		time:26.5s, loops:181, build_hash_table:{total:25.3s, fetch:1.04s, build:24.2s}, probe:{concurrency:5, total:2m12.7s, max:26.5s, probe:5.15s, fetch:2m7.5s}	anti semi join, equal:[eq(tpch50.customer.c_custkey, tpch50.orders.o_custkey)]	590.2 MB	0 Bytes
20:57:48 [2021-06-05T20:57:48.461Z]         ├─TableReader_49(Build)	75000000.00	75000000	root		time:1.06s, loops:73364, cop_task: {num: 153, max: 989.4ms, min: 281.9ms, avg: 601.6ms, p95: 881.3ms, max_proc_keys: 723875, p95_proc_keys: 553332, tot_proc: 1m31.2s, tot_wait: 39ms, rpc_num: 153, rpc_time: 1m32s, copr_cache: disabled}	data:TableFullScan_48	57.8 MB	N/A
20:57:48 [2021-06-05T20:57:48.461Z]         │ └─TableFullScan_48	75000000.00	75000000	cop[tikv]	table:orders	tikv_task:{proc max:951ms, min:272ms, p80:593ms, p95:848ms, 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: 3022, read_count: 219899, read_byte: 4.29 GB}}}	keep order:false	N/A	N/A
20:57:48 [2021-06-05T20:57:48.461Z]         └─Selection_47(Probe)	2000000.00	545246	root		time:1.31s, loops:534	in(substring(tpch50.customer.c_phone, 1, 2), "20", "40", "22", "30", "39", "42", "21")	94.6 KB	N/A
20:57:48 [2021-06-05T20:57:48.461Z]           └─TableReader_46	2000000.00	3407619	root		time:466.4ms, loops:3319, cop_task: {num: 18, max: 1.21s, min: 386.7ms, avg: 823.6ms, p95: 1.21s, max_proc_keys: 582617, p95_proc_keys: 582617, tot_proc: 14.4s, tot_wait: 2ms, rpc_num: 18, rpc_time: 14.8s, copr_cache: disabled}	data:Selection_45	192.5 MB	N/A
20:57:48 [2021-06-05T20:57:48.461Z]             └─Selection_45	2000000.00	3407619	cop[tikv]		tikv_task:{proc max:1.15s, min:358ms, p80:901ms, p95:1.15s, iters:7404, tasks:18}, scan_detail: {total_process_keys: 7500000, total_keys: 7500018, rocksdb: {delete_skipped_count: 0, key_skipped_count: 14999982, block: {cache_hit_count: 28451, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.customer.c_acctbal, 5000.602894)	N/A	N/A
20:57:48 [2021-06-05T20:57:48.461Z]               └─TableFullScan_44	7500000.00	7500000	cop[tikv]	table:customer	tikv_task:{proc max:1.08s, min:322ms, p80:821ms, p95:1.08s, iters:7404, tasks:18}	keep order:false	N/A	N/A
20:57:48 [2021-06-05T20:57:48.461Z] 
20:57:48 [2021-06-05T20:57:48.461Z] queries/22.sql
20:57:48 [2021-06-05T20:57:48.461Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:57:48 [2021-06-05T20:57:48.461Z] Sort_39	2186432.06	4	root		time:26.2s, loops:2	Column#27	9.48 KB	0 Bytes
20:57:48 [2021-06-05T20:57:48.461Z] └─Projection_41	2186432.06	4	root		time:26.2s, loops:5, Concurrency:5	Column#27, Column#28, Column#29	23.7 KB	N/A
20:57:48 [2021-06-05T20:57:48.461Z]   └─HashAgg_42	2186432.06	4	root		time:26.2s, loops:5, partial_worker:{wall_time:26.223063489s, concurrency:5, task_num:180, tot_wait:2m11.068880048s, tot_exec:45.391915ms, tot_time:2m11.114380973s, max:26.222938021s, p95:26.222938021s}, final_worker:{wall_time:26.223108549s, concurrency:5, task_num:20, tot_wait:2m11.114657806s, tot_exec:139.558µs, tot_time:2m11.114804619s, max:26.222976645s, p95:26.222976645s}	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:48 [2021-06-05T20:57:48.461Z]     └─Projection_51	2186432.06	181704	root		time:26.2s, loops:181, Concurrency:5	tpch50.customer.c_acctbal, substring(tpch50.customer.c_phone, 1, 2)->Column#32, substring(tpch50.customer.c_phone, 1, 2)->Column#33	693.6 KB	N/A
20:57:48 [2021-06-05T20:57:48.461Z]       └─HashJoin_43	2186432.06	181704	root		time:26.2s, loops:181, build_hash_table:{total:24.9s, fetch:948.6ms, build:23.9s}, probe:{concurrency:5, total:2m11.1s, max:26.2s, probe:5.57s, fetch:2m5.5s}	anti semi join, equal:[eq(tpch50.customer.c_custkey, tpch50.orders.o_custkey)]	590.2 MB	0 Bytes
20:57:48 [2021-06-05T20:57:48.461Z]         ├─TableReader_49(Build)	75000000.00	75000000	root		time:986.3ms, loops:73364, cop_task: {num: 153, max: 1.2s, min: 269.7ms, avg: 539.6ms, p95: 864.5ms, max_proc_keys: 723875, p95_proc_keys: 553332, tot_proc: 1m21.8s, tot_wait: 28ms, rpc_num: 153, rpc_time: 1m22.6s, copr_cache: disabled}	data:TableFullScan_48	57.8 MB	N/A
20:57:48 [2021-06-05T20:57:48.461Z]         │ └─TableFullScan_48	75000000.00	75000000	cop[tikv]	table:orders	tikv_task:{proc max:1.17s, min:255ms, p80:550ms, p95:835ms, 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:48 [2021-06-05T20:57:48.461Z]         └─Selection_47(Probe)	2733040.07	545246	root		time:1.45s, loops:534	in(substring(tpch50.customer.c_phone, 1, 2), "20", "40", "22", "30", "39", "42", "21")	94.6 KB	N/A
20:57:48 [2021-06-05T20:57:48.461Z]           └─TableReader_46	2733040.07	3407619	root		time:687.2ms, loops:3319, cop_task: {num: 18, max: 1.34s, min: 526.4ms, avg: 912ms, p95: 1.34s, max_proc_keys: 582617, p95_proc_keys: 582617, tot_proc: 16s, rpc_num: 18, rpc_time: 16.4s, copr_cache: disabled}	data:Selection_45	192.5 MB	N/A
20:57:48 [2021-06-05T20:57:48.461Z]             └─Selection_45	2733040.07	3407619	cop[tikv]		tikv_task:{proc max:1.27s, min:475ms, p80:1.07s, p95:1.27s, 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:48 [2021-06-05T20:57:48.461Z]               └─TableFullScan_44	7500000.00	7500000	cop[tikv]	table:customer	tikv_task:{proc max:1.18s, min:435ms, p80:958ms, p95:1.18s, iters:7404, tasks:18}	keep order:false	N/A	N/A
20:57:48 [2021-06-05T20:57:48.461Z] 
20:57:48 [2021-06-05T20:57:48.461Z] queries/22.sql
20:57:48 [2021-06-05T20:57:48.461Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:57:48 [2021-06-05T20:57:48.461Z] Sort_39	2186432.06	4	root		time:25.7s, loops:2	Column#27	9.48 KB	0 Bytes
20:57:48 [2021-06-05T20:57:48.461Z] └─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:57:48 [2021-06-05T20:57:48.461Z]   └─HashAgg_42	2186432.06	4	root		time:25.7s, loops:5, partial_worker:{wall_time:25.693270432s, concurrency:5, task_num:180, tot_wait:2m8.413370794s, tot_exec:51.960539ms, tot_time:2m8.465448817s, max:25.693238066s, p95:25.693238066s}, final_worker:{wall_time:25.693303843s, concurrency:5, task_num:20, tot_wait:2m8.466173462s, tot_exec:194.199µs, tot_time:2m8.466375026s, max:25.693286173s, p95:25.693286173s}	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:48 [2021-06-05T20:57:48.461Z]     └─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:57:48 [2021-06-05T20:57:48.461Z]       └─HashJoin_43	2186432.06	181704	root		time:25.7s, loops:181, build_hash_table:{total:24.3s, fetch:929ms, build:23.4s}, probe:{concurrency:5, total:2m8.5s, max:25.7s, probe:5.51s, fetch:2m2.9s}	anti semi join, equal:[eq(tpch50.customer.c_custkey, tpch50.orders.o_custkey)]	590.2 MB	0 Bytes
20:57:48 [2021-06-05T20:57:48.462Z]         ├─TableReader_49(Build)	75000000.00	75000000	root		time:962.8ms, loops:73364, cop_task: {num: 153, max: 1s, min: 277.4ms, avg: 506.9ms, p95: 824.3ms, max_proc_keys: 723875, p95_proc_keys: 553332, tot_proc: 1m16.9s, tot_wait: 32ms, rpc_num: 153, rpc_time: 1m17.6s, copr_cache: disabled}	data:TableFullScan_48	54.1 MB	N/A
20:57:48 [2021-06-05T20:57:48.462Z]         │ └─TableFullScan_48	75000000.00	75000000	cop[tikv]	table:orders	tikv_task:{proc max:990ms, min:267ms, p80:519ms, p95:786ms, 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:48 [2021-06-05T20:57:48.462Z]         └─Selection_47(Probe)	2733040.07	545246	root		time:1.38s, loops:534	in(substring(tpch50.customer.c_phone, 1, 2), "20", "40", "22", "30", "39", "42", "21")	94.6 KB	N/A
20:57:48 [2021-06-05T20:57:48.462Z]           └─TableReader_46	2733040.07	3407619	root		time:523.1ms, loops:3319, cop_task: {num: 18, max: 1.27s, min: 387.8ms, avg: 902.8ms, p95: 1.27s, max_proc_keys: 582617, p95_proc_keys: 582617, tot_proc: 15.9s, tot_wait: 3ms, rpc_num: 18, rpc_time: 16.2s, copr_cache: disabled}	data:Selection_45	192.5 MB	N/A
20:57:48 [2021-06-05T20:57:48.462Z]             └─Selection_45	2733040.07	3407619	cop[tikv]		tikv_task:{proc max:1.19s, min:364ms, p80:1s, p95:1.19s, 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:48 [2021-06-05T20:57:48.462Z]               └─TableFullScan_44	7500000.00	7500000	cop[tikv]	table:customer	tikv_task:{proc max:1.1s, min:327ms, p80:929ms, p95:1.1s, iters:7404, tasks:18}	keep order:false	N/A	N/A
20:57:48 [2021-06-05T20:57:48.462Z] + sync
20:57:48 [2021-06-05T20:57:48.462Z] + /usr/bin/echo 3
20:58:20 [2021-06-05T20:58:20.474Z] + sync
20:58:20 [2021-06-05T20:58:20.474Z] + /usr/bin/echo 3
20:58:46 [2021-06-05T20:58:46.952Z] + sync
20:58:46 [2021-06-05T20:58:46.952Z] + /usr/bin/echo 3
20:59:13 [2021-06-05T20:59:13.434Z] 
20:59:13 [2021-06-05T20:59:13.434Z] queries/22.sql
20:59:13 [2021-06-05T20:59:13.434Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:59:13 [2021-06-05T20:59:13.434Z] Sort_39	2186432.06	4	root		time:25.9s, loops:2	Column#27	9.48 KB	0 Bytes
20:59:13 [2021-06-05T20:59:13.434Z] └─Projection_41	2186432.06	4	root		time:25.9s, loops:5, Concurrency:5	Column#27, Column#28, Column#29	23.7 KB	N/A
20:59:13 [2021-06-05T20:59:13.434Z]   └─HashAgg_42	2186432.06	4	root		time:25.9s, loops:5, partial_worker:{wall_time:25.938921866s, concurrency:5, task_num:180, tot_wait:2m9.643656983s, tot_exec:50.540091ms, tot_time:2m9.694313658s, max:25.938874407s, p95:25.938874407s}, final_worker:{wall_time:25.938936803s, concurrency:5, task_num:20, tot_wait:2m9.694272503s, tot_exec:134.24µs, tot_time:2m9.694413622s, max:25.938892094s, p95:25.938892094s}	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:13 [2021-06-05T20:59:13.434Z]     └─Projection_51	2186432.06	181704	root		time:25.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:13 [2021-06-05T20:59:13.434Z]       └─HashJoin_43	2186432.06	181704	root		time:25.9s, loops:181, build_hash_table:{total:24.6s, fetch:846.2ms, build:23.8s}, probe:{concurrency:5, total:2m9.7s, max:25.9s, probe:5.27s, fetch:2m4.4s}	anti semi join, equal:[eq(tpch50.customer.c_custkey, tpch50.orders.o_custkey)]	590.2 MB	0 Bytes
20:59:13 [2021-06-05T20:59:13.434Z]         ├─TableReader_49(Build)	75000000.00	75000000	root		time:864.1ms, loops:73364, cop_task: {num: 153, max: 990.9ms, min: 221.9ms, avg: 514.4ms, p95: 831.1ms, max_proc_keys: 723875, p95_proc_keys: 553332, tot_proc: 1m17.7s, tot_wait: 35ms, rpc_num: 153, rpc_time: 1m18.7s, copr_cache: disabled}	data:TableFullScan_48	57.8 MB	N/A
20:59:13 [2021-06-05T20:59:13.434Z]         │ └─TableFullScan_48	75000000.00	75000000	cop[tikv]	table:orders	tikv_task:{proc max:948ms, min:208ms, p80:513ms, p95:809ms, 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:13 [2021-06-05T20:59:13.434Z]         └─Selection_47(Probe)	2733040.07	545246	root		time:1.5s, loops:534	in(substring(tpch50.customer.c_phone, 1, 2), "20", "40", "22", "30", "39", "42", "21")	94.6 KB	N/A
20:59:13 [2021-06-05T20:59:13.434Z]           └─TableReader_46	2733040.07	3407619	root		time:700.8ms, loops:3319, cop_task: {num: 18, max: 1.29s, min: 544.1ms, avg: 928.6ms, p95: 1.29s, max_proc_keys: 582617, p95_proc_keys: 582617, tot_proc: 16.3s, tot_wait: 10ms, rpc_num: 18, rpc_time: 16.7s, copr_cache: disabled}	data:Selection_45	192.5 MB	N/A
20:59:13 [2021-06-05T20:59:13.434Z]             └─Selection_45	2733040.07	3407619	cop[tikv]		tikv_task:{proc max:1.21s, min:494ms, p80:1.02s, 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:13 [2021-06-05T20:59:13.434Z]               └─TableFullScan_44	7500000.00	7500000	cop[tikv]	table:customer	tikv_task:{proc max:1.12s, min:443ms, p80:917ms, p95:1.12s, iters:7404, tasks:18}	keep order:false	N/A	N/A
20:59:13 [2021-06-05T20:59:13.434Z] 
20:59:13 [2021-06-05T20:59:13.434Z] queries/22.sql
20:59:13 [2021-06-05T20:59:13.434Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:59:13 [2021-06-05T20:59:13.434Z] Sort_39	2186432.06	4	root		time:24.7s, loops:2	Column#27	9.48 KB	0 Bytes
20:59:13 [2021-06-05T20:59:13.434Z] └─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:13 [2021-06-05T20:59:13.434Z]   └─HashAgg_42	2186432.06	4	root		time:24.7s, loops:5, partial_worker:{wall_time:24.686268833s, concurrency:5, task_num:180, tot_wait:2m3.372877224s, tot_exec:57.500444ms, tot_time:2m3.430528091s, max:24.686189395s, p95:24.686189395s}, final_worker:{wall_time:24.686265241s, concurrency:5, task_num:20, tot_wait:2m3.430772232s, tot_exec:260.705µs, tot_time:2m3.431041069s, max:24.686213223s, p95:24.686213223s}	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:13 [2021-06-05T20:59:13.434Z]     └─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:13 [2021-06-05T20:59:13.434Z]       └─HashJoin_43	2186432.06	181704	root		time:24.7s, loops:181, build_hash_table:{total:23.2s, fetch:918.1ms, build:22.3s}, probe:{concurrency:5, total:2m3.4s, max:24.7s, probe:5.91s, fetch:1m57.5s}	anti semi join, equal:[eq(tpch50.customer.c_custkey, tpch50.orders.o_custkey)]	590.2 MB	0 Bytes
20:59:13 [2021-06-05T20:59:13.434Z]         ├─TableReader_49(Build)	75000000.00	75000000	root		time:921.7ms, loops:73364, cop_task: {num: 153, max: 929.1ms, min: 201.8ms, avg: 511.3ms, p95: 784.6ms, max_proc_keys: 723875, p95_proc_keys: 553332, tot_proc: 1m17.5s, tot_wait: 39ms, rpc_num: 153, rpc_time: 1m18.2s, copr_cache: disabled}	data:TableFullScan_48	57.8 MB	N/A
20:59:13 [2021-06-05T20:59:13.434Z]         │ └─TableFullScan_48	75000000.00	75000000	cop[tikv]	table:orders	tikv_task:{proc max:908ms, min:194ms, p80:526ms, p95:757ms, 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:13 [2021-06-05T20:59:13.434Z]         └─Selection_47(Probe)	2733040.07	545246	root		time:1.56s, loops:534	in(substring(tpch50.customer.c_phone, 1, 2), "20", "40", "22", "30", "39", "42", "21")	94.6 KB	N/A
20:59:13 [2021-06-05T20:59:13.434Z]           └─TableReader_46	2733040.07	3407619	root		time:653ms, loops:3319, cop_task: {num: 18, max: 1.3s, min: 515.2ms, avg: 908.6ms, p95: 1.3s, max_proc_keys: 582617, p95_proc_keys: 582617, tot_proc: 15.8s, tot_wait: 5ms, rpc_num: 18, rpc_time: 16.4s, copr_cache: disabled}	data:Selection_45	192.5 MB	N/A
20:59:13 [2021-06-05T20:59:13.434Z]             └─Selection_45	2733040.07	3407619	cop[tikv]		tikv_task:{proc max:1.23s, min:486ms, p80:988ms, p95:1.23s, 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:13 [2021-06-05T20:59:13.434Z]               └─TableFullScan_44	7500000.00	7500000	cop[tikv]	table:customer	tikv_task:{proc max:1.12s, min:441ms, p80:932ms, p95:1.12s, iters:7404, tasks:18}	keep order:false	N/A	N/A
20:59:13 [2021-06-05T20:59:13.434Z] 
20:59:13 [2021-06-05T20:59:13.434Z] queries/22.sql
20:59:13 [2021-06-05T20:59:13.434Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:59:13 [2021-06-05T20:59:13.434Z] Sort_39	2186432.06	4	root		time:24.2s, loops:2	Column#27	9.48 KB	0 Bytes
20:59:13 [2021-06-05T20:59:13.434Z] └─Projection_41	2186432.06	4	root		time:24.2s, loops:5, Concurrency:5	Column#27, Column#28, Column#29	23.7 KB	N/A
20:59:13 [2021-06-05T20:59:13.434Z]   └─HashAgg_42	2186432.06	4	root		time:24.2s, loops:5, partial_worker:{wall_time:24.236420247s, concurrency:5, task_num:179, tot_wait:2m1.1306948s, tot_exec:50.277871ms, tot_time:2m1.1810774s, max:24.236335322s, p95:24.236335322s}, final_worker:{wall_time:24.236528825s, concurrency:5, task_num:20, tot_wait:2m1.181773012s, tot_exec:165.909µs, tot_time:2m1.181945508s, max:24.236408289s, p95:24.236408289s}	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:13 [2021-06-05T20:59:13.434Z]     └─Projection_51	2186432.06	181704	root		time:24.2s, loops:180, Concurrency:5	tpch50.customer.c_acctbal, substring(tpch50.customer.c_phone, 1, 2)->Column#32, substring(tpch50.customer.c_phone, 1, 2)->Column#33	693.6 KB	N/A
20:59:13 [2021-06-05T20:59:13.434Z]       └─HashJoin_43	2186432.06	181704	root		time:24.2s, loops:180, build_hash_table:{total:22.9s, fetch:769.3ms, build:22.2s}, probe:{concurrency:5, total:2m1.2s, max:24.2s, probe:5.21s, fetch:1m56s}	anti semi join, equal:[eq(tpch50.customer.c_custkey, tpch50.orders.o_custkey)]	590.2 MB	0 Bytes
20:59:13 [2021-06-05T20:59:13.434Z]         ├─TableReader_49(Build)	75000000.00	75000000	root		time:772.2ms, loops:73364, cop_task: {num: 153, max: 985.2ms, min: 198.5ms, avg: 516.6ms, p95: 852.2ms, max_proc_keys: 723875, p95_proc_keys: 553332, tot_proc: 1m18.2s, tot_wait: 32ms, rpc_num: 153, rpc_time: 1m19s, copr_cache: disabled}	data:TableFullScan_48	57.8 MB	N/A
20:59:13 [2021-06-05T20:59:13.434Z]         │ └─TableFullScan_48	75000000.00	75000000	cop[tikv]	table:orders	tikv_task:{proc max:958ms, min:184ms, p80:527ms, p95:824ms, 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:13 [2021-06-05T20:59:13.434Z]         └─Selection_47(Probe)	2733040.07	545246	root		time:1.58s, loops:534	in(substring(tpch50.customer.c_phone, 1, 2), "20", "40", "22", "30", "39", "42", "21")	92.6 KB	N/A
20:59:13 [2021-06-05T20:59:13.434Z]           └─TableReader_46	2733040.07	3407619	root		time:758.5ms, loops:3319, cop_task: {num: 18, max: 1.26s, min: 538.4ms, avg: 897.1ms, p95: 1.26s, max_proc_keys: 582617, p95_proc_keys: 582617, tot_proc: 15.7s, tot_wait: 1ms, rpc_num: 18, rpc_time: 16.1s, copr_cache: disabled}	data:Selection_45	192.5 MB	N/A
20:59:13 [2021-06-05T20:59:13.434Z]             └─Selection_45	2733040.07	3407619	cop[tikv]		tikv_task:{proc max:1.19s, min:500ms, p80:1.03s, p95:1.19s, 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:13 [2021-06-05T20:59:13.434Z]               └─TableFullScan_44	7500000.00	7500000	cop[tikv]	table:customer	tikv_task:{proc max:1.09s, min:461ms, p80:941ms, p95:1.09s, iters:7404, tasks:18}	keep order:false	N/A	N/A
20:59:13 [2021-06-05T20:59:13.434Z] + sync
20:59:13 [2021-06-05T20:59:13.434Z] + /usr/bin/echo 3
20:59:45 [2021-06-05T20:59:45.444Z] 
20:59:45 [2021-06-05T20:59:45.444Z] queries/22.sql
20:59:45 [2021-06-05T20:59:45.444Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:59:45 [2021-06-05T20:59:45.444Z] Sort_39	2186432.06	4	root		time:24.8s, loops:2	Column#27	9.48 KB	0 Bytes
20:59:45 [2021-06-05T20:59:45.444Z] └─Projection_41	2186432.06	4	root		time:24.8s, loops:5, Concurrency:5	Column#27, Column#28, Column#29	23.7 KB	N/A
20:59:45 [2021-06-05T20:59:45.444Z]   └─HashAgg_42	2186432.06	4	root		time:24.8s, loops:5, partial_worker:{wall_time:24.799283698s, concurrency:5, task_num:180, tot_wait:2m3.947040538s, tot_exec:48.433483ms, tot_time:2m3.995608217s, max:24.799206126s, p95:24.799206126s}, final_worker:{wall_time:24.799340135s, concurrency:5, task_num:20, tot_wait:2m3.996111923s, tot_exec:197.982µs, tot_time:2m3.99631716s, max:24.799282872s, p95:24.799282872s}	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:45 [2021-06-05T20:59:45.444Z]     └─Projection_51	2186432.06	181704	root		time:24.8s, loops:181, Concurrency:5	tpch50.customer.c_acctbal, substring(tpch50.customer.c_phone, 1, 2)->Column#32, substring(tpch50.customer.c_phone, 1, 2)->Column#33	693.6 KB	N/A
20:59:45 [2021-06-05T20:59:45.444Z]       └─HashJoin_43	2186432.06	181704	root		time:24.8s, loops:181, build_hash_table:{total:23.5s, fetch:870.4ms, build:22.6s}, probe:{concurrency:5, total:2m4s, max:24.8s, probe:5.31s, fetch:1m58.7s}	anti semi join, equal:[eq(tpch50.customer.c_custkey, tpch50.orders.o_custkey)]	590.2 MB	0 Bytes
20:59:45 [2021-06-05T20:59:45.444Z]         ├─TableReader_49(Build)	75000000.00	75000000	root		time:893.3ms, loops:73364, cop_task: {num: 153, max: 1s, min: 211.3ms, avg: 510.8ms, p95: 884.5ms, max_proc_keys: 723875, p95_proc_keys: 553332, tot_proc: 1m17.4s, tot_wait: 34ms, rpc_num: 153, rpc_time: 1m18.1s, copr_cache: disabled}	data:TableFullScan_48	54.1 MB	N/A
20:59:45 [2021-06-05T20:59:45.445Z]         │ └─TableFullScan_48	75000000.00	75000000	cop[tikv]	table:orders	tikv_task:{proc max:954ms, min:202ms, p80:506ms, p95:853ms, iters:73975, tasks:153}, scan_detail: {total_process_keys: 75000000, total_keys: 75000153, rocksdb: {delete_skipped_count: 0, key_skipped_count: 149999847, block: {cache_hit_count: 220923, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:59:45 [2021-06-05T20:59:45.445Z]         └─Selection_47(Probe)	2733040.07	545246	root		time:1.32s, loops:534	in(substring(tpch50.customer.c_phone, 1, 2), "20", "40", "22", "30", "39", "42", "21")	94.6 KB	N/A
20:59:45 [2021-06-05T20:59:45.445Z]           └─TableReader_46	2733040.07	3407619	root		time:554.7ms, loops:3319, cop_task: {num: 18, max: 1.22s, min: 450.9ms, avg: 875.4ms, p95: 1.22s, max_proc_keys: 582617, p95_proc_keys: 582617, tot_proc: 15.3s, tot_wait: 2ms, rpc_num: 18, rpc_time: 15.8s, copr_cache: disabled}	data:Selection_45	192.5 MB	N/A
20:59:45 [2021-06-05T20:59:45.445Z]             └─Selection_45	2733040.07	3407619	cop[tikv]		tikv_task:{proc max:1.15s, min:419ms, p80:994ms, p95:1.15s, iters:7404, tasks:18}, scan_detail: {total_process_keys: 7500000, total_keys: 7500018, rocksdb: {delete_skipped_count: 0, key_skipped_count: 14999982, block: {cache_hit_count: 28451, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.customer.c_acctbal, 5000.602894)	N/A	N/A
20:59:45 [2021-06-05T20:59:45.445Z]               └─TableFullScan_44	7500000.00	7500000	cop[tikv]	table:customer	tikv_task:{proc max:1.05s, min:392ms, p80:918ms, p95:1.05s, iters:7404, tasks:18}	keep order:false	N/A	N/A
20:59:45 [2021-06-05T20:59:45.445Z] 
20:59:45 [2021-06-05T20:59:45.445Z] + tiup cluster stop benchbot
20:59:45 [2021-06-05T20:59:45.445Z] Starting component `cluster`: /home/tidb/.tiup/components/cluster/v1.4.4/tiup-cluster stop benchbot
20:59:45 [2021-06-05T20:59:45.445Z] + [ 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:45 [2021-06-05T20:59:45.445Z] + [Parallel] - UserSSH: user=tidb, host=172.16.5.86
20:59:45 [2021-06-05T20:59:45.445Z] + [Parallel] - UserSSH: user=tidb, host=172.16.5.86
20:59:45 [2021-06-05T20:59:45.445Z] + [Parallel] - UserSSH: user=tidb, host=172.16.5.86
20:59:45 [2021-06-05T20:59:45.445Z] + [Parallel] - UserSSH: user=tidb, host=172.16.5.86
20:59:45 [2021-06-05T20:59:45.445Z] + [Parallel] - UserSSH: user=tidb, host=172.16.5.86
20:59:45 [2021-06-05T20:59:45.445Z] + [ Serial ] - StopCluster
20:59:45 [2021-06-05T20:59:45.445Z] Stopping component grafana
20:59:45 [2021-06-05T20:59:45.445Z] 	Stopping instance 172.16.5.86
20:59:46 [2021-06-05T20:59:46.368Z] 	Stop grafana 172.16.5.86:3000 success
20:59:46 [2021-06-05T20:59:46.368Z] Stopping component prometheus
20:59:46 [2021-06-05T20:59:46.368Z] 	Stopping instance 172.16.5.86
20:59:46 [2021-06-05T20:59:46.623Z] 	Stop prometheus 172.16.5.86:9090 success
20:59:46 [2021-06-05T20:59:46.623Z] Stopping component tidb
20:59:46 [2021-06-05T20:59:46.623Z] 	Stopping instance 172.16.5.86
20:59:49 [2021-06-05T20:59:49.878Z] 	Stop tidb 172.16.5.86:4000 success
20:59:49 [2021-06-05T20:59:49.878Z] Stopping component tikv
20:59:49 [2021-06-05T20:59:49.878Z] 	Stopping instance 172.16.5.86
20:59:54 [2021-06-05T20:59:54.034Z] 	Stop tikv 172.16.5.86:20160 success
20:59:54 [2021-06-05T20:59:54.034Z] Stopping component pd
20:59:54 [2021-06-05T20:59:54.034Z] 	Stopping instance 172.16.5.86
20:59:54 [2021-06-05T20:59:54.034Z] 	Stop pd 172.16.5.86:2379 success
20:59:54 [2021-06-05T20:59:54.034Z] Stopping component node_exporter
20:59:54 [2021-06-05T20:59:54.034Z] Stopping component blackbox_exporter
20:59:54 [2021-06-05T20:59:54.034Z] Stopped cluster `benchbot` successfully
20:59:54 [2021-06-05T20:59:54.294Z] [Pipeline] sh
20:59:54 [2021-06-05T20:59:54.570Z] + cat bench_result
20:59:54 [2021-06-05T20:59:54.575Z] [Pipeline] }
20:59:54 [2021-06-05T20:59:54.577Z] [Pipeline] // dir
20:59:54 [2021-06-05T20:59:54.579Z] [Pipeline] }
20:59:54 [2021-06-05T20:59:54.580Z] [Pipeline] // stage
20:59:54 [2021-06-05T20:59:54.582Z] [Pipeline] }
20:59:54 [2021-06-05T20:59:54.584Z] [Pipeline] // node
20:59:54 [2021-06-05T20:59:54.587Z] [Pipeline] }
20:59:54 [2021-06-05T20:59:54.588Z] [Pipeline] // catchError
20:59:54 [2021-06-05T20:59:54.592Z] [Pipeline] stage
20:59:54 [2021-06-05T20:59:54.595Z] [Pipeline] { (Summary)
20:59:54 [2021-06-05T20:59:54.609Z] [Pipeline] slackSend
20:59:54 [2021-06-05T20:59:54.610Z] 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:54 [2021-06-05T20:59:54.636Z] sh: line 1: 53012 Terminated              sleep 3
20:59:55 [2021-06-05T20:59:55.594Z] [Pipeline] }
20:59:55 [2021-06-05T20:59:55.596Z] [Pipeline] // stage
20:59:55 [2021-06-05T20:59:55.597Z] [Pipeline] End of Pipeline
20:59:55 [2021-06-05T20:59:55.612Z] Finished: SUCCESS