SuccessConsole Output

Skipping 1,194 KB.. Full Log
Join_59	9711455.06	634004	root		time:37.7s, loops:625, build_hash_table:{total:2.45s, fetch:2.24s, build:211ms}, probe:{concurrency:5, total:3m8.6s, max:37.7s, probe:15.3s, fetch:2m53.3s}	left outer join, equal:[eq(tpch50.partsupp.ps_partkey, tpch50.lineitem.l_partkey) eq(tpch50.partsupp.ps_suppkey, tpch50.lineitem.l_suppkey)]	10.4 MB	0 Bytes
20:44:04 [2021-05-25T20:44:04.008Z]           ├─IndexHashJoin_67(Build)	321865.05	435528	root		time:2.4s, loops:430, inner:{total:2.59s, concurrency:5, task:12, construct:157.8ms, fetch:2.1s, build:30.6ms, join:335.3ms}	inner join, inner:IndexLookUp_64, outer key:tpch50.part.p_partkey, inner key:tpch50.partsupp.ps_partkey, equal cond:eq(tpch50.part.p_partkey, tpch50.partsupp.ps_partkey)	20.4 MB	N/A
20:44:04 [2021-05-25T20:44:04.008Z]           │ ├─TableReader_96(Build)	80007.93	108882	root		time:2.03s, loops:112, cop_task: {num: 20, max: 1.56s, min: 588.3ms, avg: 1.09s, p95: 1.56s, max_proc_keys: 686055, p95_proc_keys: 686055, tot_proc: 21.7s, tot_wait: 8ms, rpc_num: 20, rpc_time: 21.7s, copr_cache: disabled}	data:Selection_95	725.8 KB	N/A
20:44:04 [2021-05-25T20:44:04.008Z]           │ │ └─Selection_95	80007.93	108882	cop[tikv]		tikv_task:{proc max:1.52s, min:586ms, p80:1.25s, p95:1.52s, iters:9859, tasks:20}, scan_detail: {total_process_keys: 10000000, total_keys: 10000020, rocksdb: {delete_skipped_count: 0, key_skipped_count: 19999980, block: {cache_hit_count: 31499, read_count: 0, read_byte: 0 Bytes}}}	like(tpch50.part.p_name, "green%", 92)	N/A	N/A
20:44:04 [2021-05-25T20:44:04.008Z]           │ │   └─TableFullScan_94	10000000.00	10000000	cop[tikv]	table:part	tikv_task:{proc max:1.41s, min:528ms, p80:1.17s, p95:1.41s, iters:9859, tasks:20}	keep order:false	N/A	N/A
20:44:04 [2021-05-25T20:44:04.008Z]           │ └─IndexLookUp_64(Probe)	4.02	435528	root		time:2s, loops:447, index_task: {total_time: 1.14s, fetch_handle: 1.14s, build: 97.4µs, wait: 275.1µs}, table_task: {total_time: 7.66s, num: 55, concurrency: 60}		20.7 KB	N/A
20:44:04 [2021-05-25T20:44:04.008Z]           │   ├─IndexRangeScan_62(Build)	4.02	435528	cop[tikv]	table:partsupp, index:PRIMARY(PS_PARTKEY, PS_SUPPKEY)	time:1.1s, loops:482, cop_task: {num: 58, max: 187.7ms, min: 3.59ms, avg: 91ms, p95: 175.6ms, max_proc_keys: 15288, p95_proc_keys: 15008, tot_proc: 4.72s, tot_wait: 102ms, rpc_num: 58, rpc_time: 5.28s, copr_cache: disabled}, tikv_task:{proc max:167ms, min:2ms, p80:142ms, p95:162ms, iters:688, tasks:58}, scan_detail: {total_process_keys: 435528, total_keys: 544410, rocksdb: {delete_skipped_count: 0, key_skipped_count: 435528, block: {cache_hit_count: 980292, read_count: 0, read_byte: 0 Bytes}}}	range: decided by [eq(tpch50.partsupp.ps_partkey, tpch50.part.p_partkey)], keep order:false	N/A	N/A
20:44:04 [2021-05-25T20:44:04.008Z]           │   └─TableRowIDScan_63(Probe)	4.02	435528	cop[tikv]	table:partsupp	time:2.46s, loops:504, cop_task: {num: 1437, max: 88.9ms, min: 499.9µs, avg: 17.6ms, p95: 35.7ms, max_proc_keys: 996, p95_proc_keys: 576, tot_proc: 18.6s, tot_wait: 4.01s, rpc_num: 1437, rpc_time: 25.2s, copr_cache: disabled}, tikv_task:{proc max:42ms, min:0s, p80:17ms, p95:25ms, iters:5310, tasks:1437}, scan_detail: {total_process_keys: 435528, total_keys: 473510, rocksdb: {delete_skipped_count: 0, key_skipped_count: 194094, block: {cache_hit_count: 3644101, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:44:04 [2021-05-25T20:44:04.008Z]           └─TableReader_101(Probe)	46310896.67	45504356	root		time:33.2s, loops:44289, cop_task: {num: 761, max: 1.14s, min: 397.4ms, avg: 704.5ms, p95: 849.3ms, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 8m52.9s, tot_wait: 129ms, rpc_num: 761, rpc_time: 8m56.1s, copr_cache: disabled}	data:Selection_100	52.6 MB	N/A
20:44:04 [2021-05-25T20:44:04.008Z]             └─Selection_100	46310896.67	45504356	cop[tikv]		tikv_task:{proc max:1.08s, min:389ms, p80:746ms, p95:830ms, iters:296606, tasks:761}, scan_detail: {total_process_keys: 300005811, total_keys: 300006572, rocksdb: {delete_skipped_count: 0, key_skipped_count: 600010861, block: {cache_hit_count: 1124648, read_count: 0, read_byte: 0 Bytes}}}	ge(tpch50.lineitem.l_shipdate, 1993-01-01 00:00:00.000000), lt(tpch50.lineitem.l_shipdate, 1994-01-01)	N/A	N/A
20:44:04 [2021-05-25T20:44:04.008Z]               └─TableFullScan_99	300005811.00	300005811	cop[tikv]	table:lineitem	tikv_task:{proc max:1.04s, min:370ms, p80:717ms, p95:797ms, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:44:04 [2021-05-25T20:44:04.008Z] + sync
20:44:04 [2021-05-25T20:44:04.008Z] + /usr/bin/echo 3
20:44:50 [2021-05-25T20:44:50.728Z] + sync
20:44:50 [2021-05-25T20:44:50.728Z] + /usr/bin/echo 3
20:45:29 [2021-05-25T20:45:29.382Z] 
20:45:29 [2021-05-25T20:45:29.382Z] queries/20.sql
20:45:29 [2021-05-25T20:45:29.382Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:45:29 [2021-05-25T20:45:29.382Z] Sort_30	20000.00	8982	root		time:38.1s, loops:10	tpch50.supplier.s_name	643.8 KB	0 Bytes
20:45:29 [2021-05-25T20:45:29.382Z] └─HashJoin_35	20000.00	8982	root		time:38.1s, loops:11, build_hash_table:{total:1.32s, fetch:1.31s, build:10.2ms}, probe:{concurrency:5, total:3m10.3s, max:38.1s, probe:49.2ms, fetch:3m10.3s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.partsupp.ps_suppkey)]	1.49 MB	0 Bytes
20:45:29 [2021-05-25T20:45:29.382Z]   ├─HashJoin_48(Build)	20000.00	19972	root		time:1.32s, loops:22, build_hash_table:{total:208.5µs, fetch:201.5µs, build:7µs}, probe:{concurrency:5, total:6.6s, max:1.32s, probe:101.5ms, fetch:6.5s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:45:29 [2021-05-25T20:45:29.382Z]   │ ├─TableReader_53(Build)	1.00	1	root		time:59.2µs, loops:2, cop_task: {num: 1, max: 5.73ms, proc_keys: 25, rpc_num: 1, rpc_time: 5.67ms, copr_cache: disabled}	data:Selection_52	240 Bytes	N/A
20:45:29 [2021-05-25T20:45:29.382Z]   │ │ └─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:29 [2021-05-25T20:45:29.382Z]   │ │   └─TableFullScan_51	25.00	25	cop[tikv]	table:nation	tikv_task:{time:0s, loops:1}	keep order:false	N/A	N/A
20:45:29 [2021-05-25T20:45:29.382Z]   │ └─TableReader_50(Probe)	500000.00	500000	root		time:1.3s, loops:490, cop_task: {num: 1, max: 1.31s, proc_keys: 500000, tot_proc: 1.24s, tot_wait: 1ms, rpc_num: 1, rpc_time: 1.31s, copr_cache: disabled}	data:TableFullScan_49	35.8 MB	N/A
20:45:29 [2021-05-25T20:45:29.382Z]   │   └─TableFullScan_49	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:1.05s, 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:29 [2021-05-25T20:45:29.382Z]   └─HashAgg_54(Probe)	257492.04	223999	root		time:38.1s, loops:222, partial_worker:{wall_time:37.949514678s, concurrency:5, task_num:289, tot_wait:3m9.507750915s, tot_exec:197.195554ms, tot_time:3m9.742128539s, max:37.949288544s, p95:37.949288544s}, final_worker:{wall_time:38.064001658s, concurrency:5, task_num:25, tot_wait:3m9.737771999s, tot_exec:557.036413ms, tot_time:3m10.294826575s, max:38.063779466s, p95:38.063779466s}	group by:tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_suppkey)->tpch50.partsupp.ps_suppkey	61.4 MB	N/A
20:45:29 [2021-05-25T20:45:29.382Z]     └─Selection_55	257492.04	295898	root		time:37.9s, loops:290	gt(cast(tpch50.partsupp.ps_availqty, decimal(20,0) BINARY), mul(0.5, Column#44))	59.2 KB	N/A
20:45:29 [2021-05-25T20:45:29.382Z]       └─HashAgg_56	321865.05	435528	root		time:37.8s, loops:430, partial_worker:{wall_time:37.584287024s, concurrency:5, task_num:626, tot_wait:3m6.658769204s, tot_exec:1.090332391s, tot_time:3m7.896832464s, max:37.58393439s, p95:37.58393439s}, final_worker:{wall_time:37.938839158s, concurrency:5, task_num:25, tot_wait:3m7.876241711s, tot_exec:1.77230966s, tot_time:3m9.648568813s, max:37.938475312s, p95:37.938475312s}	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:29 [2021-05-25T20:45:29.382Z]         └─HashJoin_59	9711455.06	634004	root		time:37.5s, loops:627, build_hash_table:{total:2.57s, fetch:2.36s, build:209.7ms}, probe:{concurrency:5, total:3m7.5s, max:37.5s, probe:15.1s, fetch:2m52.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:45:29 [2021-05-25T20:45:29.382Z]           ├─IndexHashJoin_67(Build)	321865.05	435528	root		time:2.53s, loops:430, inner:{total:2.64s, concurrency:5, task:12, construct:131.7ms, fetch:2.18s, build:28.8ms, join:325.3ms}	inner join, inner:IndexLookUp_64, outer key:tpch50.part.p_partkey, inner key:tpch50.partsupp.ps_partkey, equal cond:eq(tpch50.part.p_partkey, tpch50.partsupp.ps_partkey)	20.4 MB	N/A
20:45:29 [2021-05-25T20:45:29.382Z]           │ ├─TableReader_96(Build)	80007.93	108882	root		time:2.18s, loops:112, cop_task: {num: 20, max: 1.56s, min: 670.6ms, avg: 1.12s, p95: 1.56s, max_proc_keys: 686055, p95_proc_keys: 686055, tot_proc: 22.4s, tot_wait: 8ms, rpc_num: 20, rpc_time: 22.5s, copr_cache: disabled}	data:Selection_95	680.6 KB	N/A
20:45:29 [2021-05-25T20:45:29.382Z]           │ │ └─Selection_95	80007.93	108882	cop[tikv]		tikv_task:{proc max:1.53s, min:666ms, p80:1.21s, p95:1.53s, 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:29 [2021-05-25T20:45:29.382Z]           │ │   └─TableFullScan_94	10000000.00	10000000	cop[tikv]	table:part	tikv_task:{proc max:1.44s, min:613ms, p80:1.12s, p95:1.44s, iters:9859, tasks:20}	keep order:false	N/A	N/A
20:45:29 [2021-05-25T20:45:29.382Z]           │ └─IndexLookUp_64(Probe)	4.02	435528	root		time:2.05s, loops:447, index_task: {total_time: 1.1s, fetch_handle: 1.1s, build: 95.6µs, wait: 267.4µs}, table_task: {total_time: 8.15s, num: 56, concurrency: 60}		20.7 KB	N/A
20:45:29 [2021-05-25T20:45:29.382Z]           │   ├─IndexRangeScan_62(Build)	4.02	435528	cop[tikv]	table:partsupp, index:PRIMARY(PS_PARTKEY, PS_SUPPKEY)	time:1.06s, loops:480, cop_task: {num: 60, max: 175.9ms, min: 7.2ms, avg: 89.8ms, p95: 173.1ms, max_proc_keys: 15288, p95_proc_keys: 15048, tot_proc: 4.87s, tot_wait: 60ms, rpc_num: 60, rpc_time: 5.39s, copr_cache: disabled}, tikv_task:{proc max:160ms, min:4ms, p80:141ms, p95:154ms, 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:45:29 [2021-05-25T20:45:29.382Z]           │   └─TableRowIDScan_63(Probe)	4.02	435528	cop[tikv]	table:partsupp	time:2.98s, loops:503, cop_task: {num: 1422, max: 85.5ms, min: 672.5µs, avg: 21.3ms, p95: 48.5ms, max_proc_keys: 1040, p95_proc_keys: 608, tot_proc: 21.6s, tot_wait: 6.94s, rpc_num: 1422, rpc_time: 30.3s, copr_cache: disabled}, tikv_task:{proc max:54ms, min:0s, p80:18ms, p95:26ms, iters:5274, tasks:1422}, scan_detail: {total_process_keys: 435528, total_keys: 473517, rocksdb: {delete_skipped_count: 0, key_skipped_count: 194099, block: {cache_hit_count: 3644064, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:45:29 [2021-05-25T20:45:29.382Z]           └─TableReader_101(Probe)	46310896.67	45504356	root		time:32.8s, loops:44289, cop_task: {num: 761, max: 1.28s, min: 341.7ms, avg: 696.9ms, p95: 831.2ms, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 8m47.2s, tot_wait: 124ms, rpc_num: 761, rpc_time: 8m50.3s, copr_cache: disabled}	data:Selection_100	52.6 MB	N/A
20:45:29 [2021-05-25T20:45:29.383Z]             └─Selection_100	46310896.67	45504356	cop[tikv]		tikv_task:{proc max:1.23s, min:326ms, p80:737ms, p95:812ms, 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:29 [2021-05-25T20:45:29.383Z]               └─TableFullScan_99	300005811.00	300005811	cop[tikv]	table:lineitem	tikv_task:{proc max:1.19s, min:316ms, p80:707ms, p95:781ms, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:45:29 [2021-05-25T20:45:29.383Z] 
20:45:29 [2021-05-25T20:45:29.383Z] queries/20.sql
20:45:29 [2021-05-25T20:45:29.383Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:45:29 [2021-05-25T20:45:29.383Z] Sort_30	20000.00	8982	root		time:39.4s, loops:10	tpch50.supplier.s_name	640.4 KB	0 Bytes
20:45:29 [2021-05-25T20:45:29.383Z] └─HashJoin_35	20000.00	8982	root		time:39.4s, loops:11, build_hash_table:{total:1.48s, fetch:1.47s, build:9.61ms}, probe:{concurrency:5, total:3m16.9s, max:39.4s, probe:47.8ms, fetch:3m16.8s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.partsupp.ps_suppkey)]	1.49 MB	0 Bytes
20:45:29 [2021-05-25T20:45:29.383Z]   ├─HashJoin_48(Build)	20000.00	19972	root		time:1.47s, loops:22, build_hash_table:{total:259.9µs, fetch:251.6µs, build:8.31µs}, probe:{concurrency:5, total:7.37s, max:1.47s, probe:108.1ms, fetch:7.26s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:45:29 [2021-05-25T20:45:29.383Z]   │ ├─TableReader_53(Build)	1.00	1	root		time:78.7µs, loops:2, cop_task: {num: 1, max: 837.7µs, proc_keys: 25, tot_proc: 1ms, rpc_num: 1, rpc_time: 793.5µs, copr_cache: disabled}	data:Selection_52	244 Bytes	N/A
20:45:29 [2021-05-25T20:45:29.383Z]   │ │ └─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:45:29 [2021-05-25T20:45:29.383Z]   │ │   └─TableFullScan_51	25.00	25	cop[tikv]	table:nation	tikv_task:{time:1ms, loops:1}	keep order:false	N/A	N/A
20:45:29 [2021-05-25T20:45:29.383Z]   │ └─TableReader_50(Probe)	500000.00	500000	root		time:1.45s, loops:490, cop_task: {num: 1, max: 1.45s, proc_keys: 500000, tot_proc: 1.37s, tot_wait: 1ms, rpc_num: 1, rpc_time: 1.45s, copr_cache: disabled}	data:TableFullScan_49	35.8 MB	N/A
20:45:29 [2021-05-25T20:45:29.383Z]   │   └─TableFullScan_49	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:1.19s, 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:29 [2021-05-25T20:45:29.383Z]   └─HashAgg_54(Probe)	257492.04	223999	root		time:39.4s, loops:222, partial_worker:{wall_time:39.290594619s, concurrency:5, task_num:289, tot_wait:3m16.068254907s, tot_exec:327.534122ms, tot_time:3m16.433874684s, max:39.290505708s, p95:39.290505708s}, final_worker:{wall_time:39.374389361s, concurrency:5, task_num:25, tot_wait:3m16.425507674s, tot_exec:389.290676ms, tot_time:3m16.814813089s, max:39.374286888s, p95:39.374286888s}	group by:tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_suppkey)->tpch50.partsupp.ps_suppkey	58.7 MB	N/A
20:45:29 [2021-05-25T20:45:29.383Z]     └─Selection_55	257492.04	295898	root		time:39.3s, loops:290	gt(cast(tpch50.partsupp.ps_availqty, decimal(20,0) BINARY), mul(0.5, Column#44))	59.2 KB	N/A
20:45:29 [2021-05-25T20:45:29.383Z]       └─HashAgg_56	321865.05	435528	root		time:39.1s, loops:430, partial_worker:{wall_time:38.915796077s, concurrency:5, task_num:625, tot_wait:3m13.247666302s, tot_exec:1.084988523s, tot_time:3m14.494099988s, max:38.915620653s, p95:38.915620653s}, final_worker:{wall_time:39.2781358s, concurrency:5, task_num:25, tot_wait:3m14.451227698s, tot_exec:1.893028998s, tot_time:3m16.344271633s, max:39.277914247s, p95:39.277914247s}	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:29 [2021-05-25T20:45:29.383Z]         └─HashJoin_59	9711455.06	634004	root		time:38.8s, loops:626, build_hash_table:{total:2.52s, fetch:2.29s, build:224.6ms}, probe:{concurrency:5, total:3m14s, max:38.8s, probe:14.4s, fetch:2m59.6s}	left outer join, equal:[eq(tpch50.partsupp.ps_partkey, tpch50.lineitem.l_partkey) eq(tpch50.partsupp.ps_suppkey, tpch50.lineitem.l_suppkey)]	10.4 MB	0 Bytes
20:45:29 [2021-05-25T20:45:29.383Z]           ├─IndexHashJoin_67(Build)	321865.05	435528	root		time:2.48s, loops:430, inner:{total:2.64s, concurrency:5, task:12, construct:124.9ms, fetch:2.16s, build:37.2ms, join:354.1ms}	inner join, inner:IndexLookUp_64, outer key:tpch50.part.p_partkey, inner key:tpch50.partsupp.ps_partkey, equal cond:eq(tpch50.part.p_partkey, tpch50.partsupp.ps_partkey)	20.5 MB	N/A
20:45:29 [2021-05-25T20:45:29.383Z]           │ ├─TableReader_96(Build)	80007.93	108882	root		time:2.12s, loops:112, cop_task: {num: 20, max: 1.49s, min: 578.3ms, avg: 1.05s, p95: 1.49s, max_proc_keys: 686055, p95_proc_keys: 686055, tot_proc: 20.9s, tot_wait: 10ms, rpc_num: 20, rpc_time: 20.9s, copr_cache: disabled}	data:Selection_95	725.8 KB	N/A
20:45:29 [2021-05-25T20:45:29.383Z]           │ │ └─Selection_95	80007.93	108882	cop[tikv]		tikv_task:{proc max:1.45s, min:576ms, p80:1.22s, 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:45:29 [2021-05-25T20:45:29.383Z]           │ │   └─TableFullScan_94	10000000.00	10000000	cop[tikv]	table:part	tikv_task:{proc max:1.34s, min:542ms, p80:1.12s, p95:1.34s, iters:9859, tasks:20}	keep order:false	N/A	N/A
20:45:29 [2021-05-25T20:45:29.383Z]           │ └─IndexLookUp_64(Probe)	4.02	435528	root		time:2.06s, loops:447, index_task: {total_time: 1.21s, fetch_handle: 1.21s, build: 94µs, wait: 261.4µs}, table_task: {total_time: 8.02s, num: 56, concurrency: 60}		20.5 KB	N/A
20:45:29 [2021-05-25T20:45:29.383Z]           │   ├─IndexRangeScan_62(Build)	4.02	435528	cop[tikv]	table:partsupp, index:PRIMARY(PS_PARTKEY, PS_SUPPKEY)	time:1.17s, loops:481, cop_task: {num: 59, max: 212.7ms, min: 4.65ms, avg: 91.9ms, p95: 186.8ms, max_proc_keys: 15288, p95_proc_keys: 15008, tot_proc: 4.88s, tot_wait: 128ms, rpc_num: 59, rpc_time: 5.42s, copr_cache: disabled}, tikv_task:{proc max:205ms, min:3ms, p80:144ms, p95:175ms, iters:693, tasks:59}, scan_detail: {total_process_keys: 435528, total_keys: 544410, rocksdb: {delete_skipped_count: 0, key_skipped_count: 435528, block: {cache_hit_count: 980292, read_count: 0, read_byte: 0 Bytes}}}	range: decided by [eq(tpch50.partsupp.ps_partkey, tpch50.part.p_partkey)], keep order:false	N/A	N/A
20:45:29 [2021-05-25T20:45:29.383Z]           │   └─TableRowIDScan_63(Probe)	4.02	435528	cop[tikv]	table:partsupp	time:2.58s, loops:503, cop_task: {num: 1408, max: 99.4ms, min: 473.5µs, avg: 18.3ms, p95: 37.6ms, max_proc_keys: 976, p95_proc_keys: 604, tot_proc: 18.7s, tot_wait: 4.23s, rpc_num: 1408, rpc_time: 25.7s, copr_cache: disabled}, tikv_task:{proc max:53ms, min:0s, p80:17ms, p95:25ms, iters:5251, tasks:1408}, scan_detail: {total_process_keys: 435528, total_keys: 473523, rocksdb: {delete_skipped_count: 0, key_skipped_count: 194117, block: {cache_hit_count: 3643938, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:45:29 [2021-05-25T20:45:29.383Z]           └─TableReader_101(Probe)	46310896.67	45504356	root		time:34.4s, loops:44289, cop_task: {num: 761, max: 1.14s, min: 395.7ms, avg: 722.4ms, p95: 868.9ms, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 9m6.6s, tot_wait: 133ms, rpc_num: 761, rpc_time: 9m9.7s, copr_cache: disabled}	data:Selection_100	52.6 MB	N/A
20:45:29 [2021-05-25T20:45:29.383Z]             └─Selection_100	46310896.67	45504356	cop[tikv]		tikv_task:{proc max:1.11s, min:385ms, p80:772ms, p95:848ms, 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:29 [2021-05-25T20:45:29.383Z]               └─TableFullScan_99	300005811.00	300005811	cop[tikv]	table:lineitem	tikv_task:{proc max:1.05s, min:372ms, p80:740ms, p95:817ms, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:45:29 [2021-05-25T20:45:29.383Z] + sync
20:45:29 [2021-05-25T20:45:29.383Z] + /usr/bin/echo 3
20:46:08 [2021-05-25T20:46:08.037Z] + sync
20:46:08 [2021-05-25T20:46:08.037Z] + /usr/bin/echo 3
20:46:54 [2021-05-25T20:46:54.647Z] 
20:46:54 [2021-05-25T20:46:54.647Z] queries/20.sql
20:46:54 [2021-05-25T20:46:54.647Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:46:54 [2021-05-25T20:46:54.647Z] Sort_30	20000.00	8982	root		time:37.8s, loops:10	tpch50.supplier.s_name	643.8 KB	0 Bytes
20:46:54 [2021-05-25T20:46:54.647Z] └─HashJoin_35	20000.00	8982	root		time:37.8s, loops:11, build_hash_table:{total:1.33s, fetch:1.32s, build:11.2ms}, probe:{concurrency:5, total:3m8.9s, max:37.8s, probe:51.1ms, fetch:3m8.8s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.partsupp.ps_suppkey)]	1.49 MB	0 Bytes
20:46:54 [2021-05-25T20:46:54.647Z]   ├─HashJoin_48(Build)	20000.00	19972	root		time:1.32s, loops:22, build_hash_table:{total:170.5µs, fetch:164.3µs, build:6.26µs}, probe:{concurrency:5, total:6.63s, max:1.33s, probe:118.8ms, fetch:6.51s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:46:54 [2021-05-25T20:46:54.647Z]   │ ├─TableReader_53(Build)	1.00	1	root		time:47.2µs, loops:2, cop_task: {num: 1, max: 1.05ms, proc_keys: 25, tot_proc: 1ms, rpc_num: 1, rpc_time: 1.01ms, copr_cache: disabled}	data:Selection_52	244 Bytes	N/A
20:46:54 [2021-05-25T20:46:54.647Z]   │ │ └─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:46:54 [2021-05-25T20:46:54.647Z]   │ │   └─TableFullScan_51	25.00	25	cop[tikv]	table:nation	tikv_task:{time:1ms, loops:1}	keep order:false	N/A	N/A
20:46:54 [2021-05-25T20:46:54.647Z]   │ └─TableReader_50(Probe)	500000.00	500000	root		time:1.3s, loops:490, cop_task: {num: 1, max: 1.3s, proc_keys: 500000, tot_proc: 1.22s, rpc_num: 1, rpc_time: 1.3s, copr_cache: disabled}	data:TableFullScan_49	35.8 MB	N/A
20:46:54 [2021-05-25T20:46:54.647Z]   │   └─TableFullScan_49	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:1.06s, loops:493}, scan_detail: {total_process_keys: 500000, total_keys: 500001, rocksdb: {delete_skipped_count: 0, key_skipped_count: 999999, block: {cache_hit_count: 1692, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:46:54 [2021-05-25T20:46:54.647Z]   └─HashAgg_54(Probe)	257492.04	223999	root		time:37.8s, loops:222, partial_worker:{wall_time:37.691867658s, concurrency:5, task_num:289, tot_wait:3m8.203036657s, tot_exec:205.345408ms, tot_time:3m8.4511516s, max:37.691838529s, p95:37.691838529s}, final_worker:{wall_time:37.769933042s, concurrency:5, task_num:25, tot_wait:3m8.443509259s, tot_exec:349.506454ms, tot_time:3m8.793029331s, max:37.769903112s, p95:37.769903112s}	group by:tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_suppkey)->tpch50.partsupp.ps_suppkey	61.4 MB	N/A
20:46:54 [2021-05-25T20:46:54.647Z]     └─Selection_55	257492.04	295898	root		time:37.7s, loops:290	gt(cast(tpch50.partsupp.ps_availqty, decimal(20,0) BINARY), mul(0.5, Column#44))	59.2 KB	N/A
20:46:54 [2021-05-25T20:46:54.647Z]       └─HashAgg_56	321865.05	435528	root		time:37.6s, loops:430, partial_worker:{wall_time:37.325465891s, concurrency:5, task_num:623, tot_wait:3m5.306946525s, tot_exec:1.151987062s, tot_time:3m6.596964109s, max:37.325417378s, p95:37.325417378s}, final_worker:{wall_time:37.680238436s, concurrency:5, task_num:25, tot_wait:3m6.579216762s, tot_exec:1.794090561s, tot_time:3m8.373321622s, max:37.680205454s, p95:37.680205454s}	group by:tpch50.partsupp.ps_partkey, tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_suppkey)->tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_availqty)->tpch50.partsupp.ps_availqty, funcs:sum(tpch50.lineitem.l_quantity)->Column#44	194.5 MB	N/A
20:46:54 [2021-05-25T20:46:54.647Z]         └─HashJoin_59	9711455.06	634004	root		time:37.2s, loops:624, build_hash_table:{total:2.51s, fetch:2.3s, build:215.7ms}, probe:{concurrency:5, total:3m6.1s, max:37.2s, probe:14.5s, fetch:2m51.5s}	left outer join, equal:[eq(tpch50.partsupp.ps_partkey, tpch50.lineitem.l_partkey) eq(tpch50.partsupp.ps_suppkey, tpch50.lineitem.l_suppkey)]	10.4 MB	0 Bytes
20:46:54 [2021-05-25T20:46:54.647Z]           ├─IndexHashJoin_67(Build)	321865.05	435528	root		time:2.47s, loops:430, inner:{total:2.72s, concurrency:5, task:12, construct:138.3ms, fetch:2.26s, build:28.1ms, join:325.1ms}	inner join, inner:IndexLookUp_64, outer key:tpch50.part.p_partkey, inner key:tpch50.partsupp.ps_partkey, equal cond:eq(tpch50.part.p_partkey, tpch50.partsupp.ps_partkey)	20.5 MB	N/A
20:46:54 [2021-05-25T20:46:54.647Z]           │ ├─TableReader_96(Build)	80007.93	108882	root		time:2.12s, loops:112, cop_task: {num: 20, max: 1.43s, min: 629.7ms, avg: 1.07s, p95: 1.43s, max_proc_keys: 686055, p95_proc_keys: 686055, tot_proc: 21.3s, tot_wait: 23ms, rpc_num: 20, rpc_time: 21.4s, copr_cache: disabled}	data:Selection_95	680.6 KB	N/A
20:46:54 [2021-05-25T20:46:54.647Z]           │ │ └─Selection_95	80007.93	108882	cop[tikv]		tikv_task:{proc max:1.39s, min:624ms, p80:1.25s, p95:1.39s, iters:9859, tasks:20}, scan_detail: {total_process_keys: 10000000, total_keys: 10000020, rocksdb: {delete_skipped_count: 0, key_skipped_count: 19999980, block: {cache_hit_count: 31499, read_count: 0, read_byte: 0 Bytes}}}	like(tpch50.part.p_name, "green%", 92)	N/A	N/A
20:46:54 [2021-05-25T20:46:54.647Z]           │ │   └─TableFullScan_94	10000000.00	10000000	cop[tikv]	table:part	tikv_task:{proc max:1.28s, min:579ms, p80:1.14s, p95:1.28s, iters:9859, tasks:20}	keep order:false	N/A	N/A
20:46:54 [2021-05-25T20:46:54.647Z]           │ └─IndexLookUp_64(Probe)	4.02	435528	root		time:2.15s, loops:447, index_task: {total_time: 1.28s, fetch_handle: 1.28s, build: 102.7µs, wait: 308µs}, table_task: {total_time: 8.39s, num: 56, concurrency: 60}		20.5 KB	N/A
20:46:54 [2021-05-25T20:46:54.647Z]           │   ├─IndexRangeScan_62(Build)	4.02	435528	cop[tikv]	table:partsupp, index:PRIMARY(PS_PARTKEY, PS_SUPPKEY)	time:1.24s, loops:481, cop_task: {num: 58, max: 229.8ms, min: 5.69ms, avg: 95.9ms, p95: 200ms, max_proc_keys: 15288, p95_proc_keys: 15008, tot_proc: 5.01s, tot_wait: 183ms, rpc_num: 58, rpc_time: 5.56s, copr_cache: disabled}, tikv_task:{proc max:198ms, min:3ms, p80:139ms, p95:177ms, 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:46:54 [2021-05-25T20:46:54.647Z]           │   └─TableRowIDScan_63(Probe)	4.02	435528	cop[tikv]	table:partsupp	time:2.61s, loops:507, cop_task: {num: 1414, max: 62.8ms, min: 594.4µs, avg: 18.4ms, p95: 38.4ms, max_proc_keys: 1152, p95_proc_keys: 620, tot_proc: 19.4s, tot_wait: 4.7s, rpc_num: 1414, rpc_time: 26s, copr_cache: disabled}, tikv_task:{proc max:56ms, min:0s, p80:17ms, p95:26ms, iters:5254, tasks:1414}, scan_detail: {total_process_keys: 435528, total_keys: 473520, rocksdb: {delete_skipped_count: 0, key_skipped_count: 194142, block: {cache_hit_count: 3643886, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:46:54 [2021-05-25T20:46:54.647Z]           └─TableReader_101(Probe)	46310896.67	45504356	root		time:32.6s, loops:44290, cop_task: {num: 761, max: 1.18s, min: 257.7ms, avg: 691.5ms, p95: 843.5ms, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 8m43.1s, tot_wait: 118ms, rpc_num: 761, rpc_time: 8m46.2s, copr_cache: disabled}	data:Selection_100	52.6 MB	N/A
20:46:54 [2021-05-25T20:46:54.647Z]             └─Selection_100	46310896.67	45504356	cop[tikv]		tikv_task:{proc max:1.11s, min:245ms, p80:735ms, p95:827ms, iters:296606, tasks:761}, scan_detail: {total_process_keys: 300005811, total_keys: 300006572, rocksdb: {delete_skipped_count: 0, key_skipped_count: 600010861, block: {cache_hit_count: 1124648, read_count: 0, read_byte: 0 Bytes}}}	ge(tpch50.lineitem.l_shipdate, 1993-01-01 00:00:00.000000), lt(tpch50.lineitem.l_shipdate, 1994-01-01)	N/A	N/A
20:46:54 [2021-05-25T20:46:54.647Z]               └─TableFullScan_99	300005811.00	300005811	cop[tikv]	table:lineitem	tikv_task:{proc max:1.05s, min:232ms, p80:704ms, p95:794ms, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:46:54 [2021-05-25T20:46:54.647Z] 
20:46:54 [2021-05-25T20:46:54.647Z] queries/20.sql
20:46:54 [2021-05-25T20:46:54.647Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:46:54 [2021-05-25T20:46:54.647Z] Sort_30	20000.00	8982	root		time:38.9s, loops:10	tpch50.supplier.s_name	643.8 KB	0 Bytes
20:46:54 [2021-05-25T20:46:54.647Z] └─HashJoin_35	20000.00	8982	root		time:38.9s, loops:11, build_hash_table:{total:1.34s, fetch:1.33s, build:10.4ms}, probe:{concurrency:5, total:3m14.3s, max:38.9s, probe:58.1ms, fetch:3m14.3s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.partsupp.ps_suppkey)]	1.49 MB	0 Bytes
20:46:54 [2021-05-25T20:46:54.647Z]   ├─HashJoin_48(Build)	20000.00	19972	root		time:1.33s, loops:22, build_hash_table:{total:167.4µs, fetch:161.6µs, build:5.83µs}, probe:{concurrency:5, total:6.67s, max:1.33s, probe:141.8ms, fetch:6.53s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:46:54 [2021-05-25T20:46:54.647Z]   │ ├─TableReader_53(Build)	1.00	1	root		time:45.2µs, loops:2, cop_task: {num: 1, max: 1ms, proc_keys: 25, tot_proc: 1ms, rpc_num: 1, rpc_time: 943.4µs, copr_cache: disabled}	data:Selection_52	244 Bytes	N/A
20:46:54 [2021-05-25T20:46:54.647Z]   │ │ └─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:46:54 [2021-05-25T20:46:54.647Z]   │ │   └─TableFullScan_51	25.00	25	cop[tikv]	table:nation	tikv_task:{time:1ms, loops:1}	keep order:false	N/A	N/A
20:46:54 [2021-05-25T20:46:54.647Z]   │ └─TableReader_50(Probe)	500000.00	500000	root		time:1.31s, loops:490, cop_task: {num: 1, max: 1.3s, proc_keys: 500000, tot_proc: 1.22s, rpc_num: 1, rpc_time: 1.3s, copr_cache: disabled}	data:TableFullScan_49	35.8 MB	N/A
20:46:54 [2021-05-25T20:46:54.647Z]   │   └─TableFullScan_49	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:1.07s, loops:493}, scan_detail: {total_process_keys: 500000, total_keys: 500001, rocksdb: {delete_skipped_count: 0, key_skipped_count: 999999, block: {cache_hit_count: 1692, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:46:54 [2021-05-25T20:46:54.647Z]   └─HashAgg_54(Probe)	257492.04	223999	root		time:38.9s, loops:222, partial_worker:{wall_time:38.800380297s, concurrency:5, task_num:289, tot_wait:3m13.751510801s, tot_exec:212.667664ms, tot_time:3m13.99774987s, max:38.800289175s, p95:38.800289175s}, final_worker:{wall_time:38.869285212s, concurrency:5, task_num:25, tot_wait:3m13.99008468s, tot_exec:349.099225ms, tot_time:3m14.339196458s, max:38.869191071s, p95:38.869191071s}	group by:tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_suppkey)->tpch50.partsupp.ps_suppkey	61.4 MB	N/A
20:46:54 [2021-05-25T20:46:54.647Z]     └─Selection_55	257492.04	295898	root		time:38.8s, loops:290	gt(cast(tpch50.partsupp.ps_availqty, decimal(20,0) BINARY), mul(0.5, Column#44))	59.2 KB	N/A
20:46:54 [2021-05-25T20:46:54.648Z]       └─HashAgg_56	321865.05	435528	root		time:38.7s, loops:430, partial_worker:{wall_time:38.424108583s, concurrency:5, task_num:623, tot_wait:3m10.736121352s, tot_exec:1.239478363s, tot_time:3m12.098837914s, max:38.42395309s, p95:38.42395309s}, final_worker:{wall_time:38.790628813s, concurrency:5, task_num:25, tot_wait:3m12.078420151s, tot_exec:1.851943757s, tot_time:3m13.930379163s, max:38.790497394s, p95:38.790497394s}	group by:tpch50.partsupp.ps_partkey, tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_suppkey)->tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_availqty)->tpch50.partsupp.ps_availqty, funcs:sum(tpch50.lineitem.l_quantity)->Column#44	194.5 MB	N/A
20:46:54 [2021-05-25T20:46:54.648Z]         └─HashJoin_59	9711455.06	634004	root		time:38.3s, loops:624, build_hash_table:{total:2.39s, fetch:2.17s, build:213ms}, probe:{concurrency:5, total:3m11.5s, max:38.3s, probe:14.7s, fetch:2m56.9s}	left outer join, equal:[eq(tpch50.partsupp.ps_partkey, tpch50.lineitem.l_partkey) eq(tpch50.partsupp.ps_suppkey, tpch50.lineitem.l_suppkey)]	10.4 MB	0 Bytes
20:46:54 [2021-05-25T20:46:54.648Z]           ├─IndexHashJoin_67(Build)	321865.05	435528	root		time:2.34s, loops:430, inner:{total:2.69s, concurrency:5, task:12, construct:103.7ms, fetch:2.27s, build:28.8ms, join:322.1ms}	inner join, inner:IndexLookUp_64, outer key:tpch50.part.p_partkey, inner key:tpch50.partsupp.ps_partkey, equal cond:eq(tpch50.part.p_partkey, tpch50.partsupp.ps_partkey)	20.5 MB	N/A
20:46:54 [2021-05-25T20:46:54.648Z]           │ ├─TableReader_96(Build)	80007.93	108882	root		time:1.95s, loops:112, cop_task: {num: 20, max: 1.51s, min: 627.8ms, avg: 1.05s, p95: 1.51s, max_proc_keys: 686055, p95_proc_keys: 686055, tot_proc: 21s, tot_wait: 23ms, rpc_num: 20, rpc_time: 21.1s, copr_cache: disabled}	data:Selection_95	725.8 KB	N/A
20:46:54 [2021-05-25T20:46:54.648Z]           │ │ └─Selection_95	80007.93	108882	cop[tikv]		tikv_task:{proc max:1.5s, min:624ms, p80:1.25s, p95:1.5s, iters:9859, tasks:20}, scan_detail: {total_process_keys: 10000000, total_keys: 10000020, rocksdb: {delete_skipped_count: 0, key_skipped_count: 19999980, block: {cache_hit_count: 31499, read_count: 0, read_byte: 0 Bytes}}}	like(tpch50.part.p_name, "green%", 92)	N/A	N/A
20:46:54 [2021-05-25T20:46:54.648Z]           │ │   └─TableFullScan_94	10000000.00	10000000	cop[tikv]	table:part	tikv_task:{proc max:1.37s, min:571ms, p80:1.16s, p95:1.37s, iters:9859, tasks:20}	keep order:false	N/A	N/A
20:46:54 [2021-05-25T20:46:54.648Z]           │ └─IndexLookUp_64(Probe)	4.02	435528	root		time:2.16s, loops:447, index_task: {total_time: 1.18s, fetch_handle: 1.18s, build: 87.6µs, wait: 314.6µs}, table_task: {total_time: 8.25s, num: 56, concurrency: 60}		19.4 KB	N/A
20:46:54 [2021-05-25T20:46:54.648Z]           │   ├─IndexRangeScan_62(Build)	4.02	435528	cop[tikv]	table:partsupp, index:PRIMARY(PS_PARTKEY, PS_SUPPKEY)	time:1.13s, loops:480, cop_task: {num: 60, max: 203.6ms, min: 5.29ms, avg: 90.7ms, p95: 188.9ms, max_proc_keys: 15288, p95_proc_keys: 15008, tot_proc: 5.02s, tot_wait: 84ms, rpc_num: 60, rpc_time: 5.44s, copr_cache: disabled}, tikv_task:{proc max:193ms, min:4ms, p80:140ms, p95:179ms, iters:697, tasks:60}, scan_detail: {total_process_keys: 435528, total_keys: 544410, rocksdb: {delete_skipped_count: 0, key_skipped_count: 435528, block: {cache_hit_count: 980292, read_count: 0, read_byte: 0 Bytes}}}	range: decided by [eq(tpch50.partsupp.ps_partkey, tpch50.part.p_partkey)], keep order:false	N/A	N/A
20:46:54 [2021-05-25T20:46:54.648Z]           │   └─TableRowIDScan_63(Probe)	4.02	435528	cop[tikv]	table:partsupp	time:2.98s, loops:505, cop_task: {num: 1459, max: 104ms, min: 408.5µs, avg: 18.9ms, p95: 47.6ms, max_proc_keys: 996, p95_proc_keys: 548, tot_proc: 19.3s, tot_wait: 5.71s, rpc_num: 1459, rpc_time: 27.6s, copr_cache: disabled}, tikv_task:{proc max:37ms, min:0s, p80:16ms, p95:22ms, iters:5379, tasks:1459}, scan_detail: {total_process_keys: 435528, total_keys: 473504, rocksdb: {delete_skipped_count: 0, key_skipped_count: 194070, block: {cache_hit_count: 3644304, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:46:54 [2021-05-25T20:46:54.648Z]           └─TableReader_101(Probe)	46310896.67	45504356	root		time:33.9s, loops:44289, cop_task: {num: 761, max: 1.16s, min: 393.4ms, avg: 714.9ms, p95: 856.8ms, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 9m0.9s, tot_wait: 116ms, rpc_num: 761, rpc_time: 9m4s, copr_cache: disabled}	data:Selection_100	52.6 MB	N/A
20:46:54 [2021-05-25T20:46:54.648Z]             └─Selection_100	46310896.67	45504356	cop[tikv]		tikv_task:{proc max:1.13s, min:377ms, p80:763ms, p95:839ms, iters:296606, tasks:761}, scan_detail: {total_process_keys: 300005811, total_keys: 300006572, rocksdb: {delete_skipped_count: 0, key_skipped_count: 600010861, block: {cache_hit_count: 1124648, read_count: 0, read_byte: 0 Bytes}}}	ge(tpch50.lineitem.l_shipdate, 1993-01-01 00:00:00.000000), lt(tpch50.lineitem.l_shipdate, 1994-01-01)	N/A	N/A
20:46:54 [2021-05-25T20:46:54.648Z]               └─TableFullScan_99	300005811.00	300005811	cop[tikv]	table:lineitem	tikv_task:{proc max:1.07s, min:356ms, p80:732ms, p95:807ms, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:46:54 [2021-05-25T20:46:54.648Z] + sync
20:46:54 [2021-05-25T20:46:54.648Z] + /usr/bin/echo 3
20:47:33 [2021-05-25T20:47:33.302Z] + tiup cluster stop benchbot -y
20:47:33 [2021-05-25T20:47:33.556Z] Starting component `cluster`: /home/tidb/.tiup/components/cluster/v1.4.3/tiup-cluster stop benchbot -y
20:47:48 [2021-05-25T20:47:48.462Z] + rm -rf '/data1/tidb-deploy/*/log/*'
20:47:48 [2021-05-25T20:47:48.462Z] + rm -rf /data1/jenkins/deploy/data/tikv-20160
20:47:49 [2021-05-25T20:47:49.826Z] + rm -rf /data1/jenkins/deploy/data/pd-2379
20:47:49 [2021-05-25T20:47:49.826Z] + rm -rf /data1/jenkins/restore_data/tpch50/data/last_tikv.toml
20:47:49 [2021-05-25T20:47:49.826Z] + cp -R /data1/jenkins/restore_data/tpch50/data /data1/jenkins/deploy/data/tikv-20160
20:49:56 [2021-05-25T20:49:56.435Z] + cp -R /data1/jenkins/restore_data/tpch50/data.pd /data1/jenkins/deploy/data/pd-2379
20:49:56 [2021-05-25T20:49:56.435Z] + '[' -n '' ']'
20:49:56 [2021-05-25T20:49:56.435Z] + tiup cluster start benchbot --wait-timeout=300
20:49:56 [2021-05-25T20:49:56.435Z] Starting component `cluster`: /home/tidb/.tiup/components/cluster/v1.4.3/tiup-cluster start benchbot --wait-timeout=300
20:50:28 [2021-05-25T20:50:28.445Z] + sync
20:50:28 [2021-05-25T20:50:28.445Z] + /usr/bin/echo 3
20:52:04 [2021-05-25T20:52:04.819Z] 
20:52:04 [2021-05-25T20:52:04.819Z] queries/20.sql
20:52:04 [2021-05-25T20:52:04.819Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:52:04 [2021-05-25T20:52:04.819Z] Sort_30	20000.00	8982	root		time:39.5s, loops:10	tpch50.supplier.s_name	623.5 KB	0 Bytes
20:52:04 [2021-05-25T20:52:04.819Z] └─HashJoin_35	20000.00	8982	root		time:39.5s, loops:11, build_hash_table:{total:1.07s, fetch:1.04s, build:26.9ms}, probe:{concurrency:5, total:3m17.5s, max:39.5s, probe:49.5ms, fetch:3m17.4s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.partsupp.ps_suppkey)]	1.50 MB	0 Bytes
20:52:04 [2021-05-25T20:52:04.819Z]   ├─HashJoin_48(Build)	20000.00	19972	root		time:1.04s, loops:22, build_hash_table:{total:241.5µs, fetch:233.9µs, build:7.53µs}, probe:{concurrency:5, total:5.31s, max:1.06s, probe:180.7ms, fetch:5.13s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:52:04 [2021-05-25T20:52:04.819Z]   │ ├─TableReader_53(Build)	1.00	1	root		time:68.9µs, loops:2, cop_task: {num: 1, max: 1.05ms, proc_keys: 25, tot_proc: 1ms, rpc_num: 1, rpc_time: 1ms, copr_cache: disabled}	data:Selection_52	244 Bytes	N/A
20:52:04 [2021-05-25T20:52:04.819Z]   │ │ └─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:52:04 [2021-05-25T20:52:04.819Z]   │ │   └─TableFullScan_51	25.00	25	cop[tikv]	table:nation	tikv_task:{time:1ms, loops:1}	keep order:false	N/A	N/A
20:52:04 [2021-05-25T20:52:04.819Z]   │ └─TableReader_50(Probe)	500000.00	500000	root		time:1.02s, loops:490, cop_task: {num: 1, max: 1.02s, proc_keys: 500000, tot_proc: 943ms, rpc_num: 1, rpc_time: 1.02s, copr_cache: disabled}	data:TableFullScan_49	35.8 MB	N/A
20:52:04 [2021-05-25T20:52:04.819Z]   │   └─TableFullScan_49	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:801ms, 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:52:04 [2021-05-25T20:52:04.819Z]   └─HashAgg_54(Probe)	257492.04	223999	root		time:39.5s, loops:222, partial_worker:{wall_time:39.383653719s, concurrency:5, task_num:289, tot_wait:3m16.661773474s, tot_exec:207.188114ms, tot_time:3m16.910138677s, max:39.383585061s, p95:39.383585061s}, final_worker:{wall_time:39.497438917s, concurrency:5, task_num:25, tot_wait:3m16.902373774s, tot_exec:567.312993ms, tot_time:3m17.469704097s, max:39.497376578s, p95:39.497376578s}	group by:tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_suppkey)->tpch50.partsupp.ps_suppkey	61.4 MB	N/A
20:52:04 [2021-05-25T20:52:04.819Z]     └─Selection_55	257492.04	295898	root		time:39.4s, loops:290	gt(cast(tpch50.partsupp.ps_availqty, decimal(20,0) BINARY), mul(0.5, Column#44))	59.2 KB	N/A
20:52:04 [2021-05-25T20:52:04.820Z]       └─HashAgg_56	321865.05	435528	root		time:39.3s, loops:430, partial_worker:{wall_time:39.01723436s, concurrency:5, task_num:626, tot_wait:3m13.938713774s, tot_exec:1.008478522s, tot_time:3m15.067518224s, max:39.017186731s, p95:39.017186731s}, final_worker:{wall_time:39.371310782s, concurrency:5, task_num:25, tot_wait:3m15.015170118s, tot_exec:1.779108437s, tot_time:3m16.794296606s, max:39.371280902s, p95:39.371280902s}	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:52:04 [2021-05-25T20:52:04.820Z]         └─HashJoin_59	9711455.06	634004	root		time:38.9s, loops:627, build_hash_table:{total:2.63s, fetch:2.4s, build:225.7ms}, probe:{concurrency:5, total:3m14.7s, max:38.9s, probe:14.4s, fetch:3m0.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:52:04 [2021-05-25T20:52:04.820Z]           ├─IndexHashJoin_67(Build)	321865.05	435528	root		time:2.59s, loops:429, inner:{total:2.46s, concurrency:5, task:12, construct:103.9ms, fetch:2.03s, build:32.6ms, join:325.2ms}	inner join, inner:IndexLookUp_64, outer key:tpch50.part.p_partkey, inner key:tpch50.partsupp.ps_partkey, equal cond:eq(tpch50.part.p_partkey, tpch50.partsupp.ps_partkey)	20.5 MB	N/A
20:52:04 [2021-05-25T20:52:04.820Z]           │ ├─TableReader_96(Build)	80007.93	108882	root		time:2.24s, loops:112, cop_task: {num: 20, max: 1.52s, min: 648.8ms, avg: 1.11s, p95: 1.52s, max_proc_keys: 686055, p95_proc_keys: 686055, tot_proc: 22.1s, tot_wait: 6ms, rpc_num: 20, rpc_time: 22.2s, copr_cache: disabled}	data:Selection_95	657.9 KB	N/A
20:52:04 [2021-05-25T20:52:04.820Z]           │ │ └─Selection_95	80007.93	108882	cop[tikv]		tikv_task:{proc max:1.51s, min:646ms, p80:1.37s, p95:1.51s, iters:9859, tasks:20}, scan_detail: {total_process_keys: 10000000, total_keys: 10000020, rocksdb: {delete_skipped_count: 0, key_skipped_count: 19999980, block: {cache_hit_count: 31499, read_count: 0, read_byte: 0 Bytes}}}	like(tpch50.part.p_name, "green%", 92)	N/A	N/A
20:52:04 [2021-05-25T20:52:04.820Z]           │ │   └─TableFullScan_94	10000000.00	10000000	cop[tikv]	table:part	tikv_task:{proc max:1.4s, min:598ms, p80:1.27s, p95:1.4s, iters:9859, tasks:20}	keep order:false	N/A	N/A
20:52:04 [2021-05-25T20:52:04.820Z]           │ └─IndexLookUp_64(Probe)	4.02	435528	root		time:1.93s, loops:447, index_task: {total_time: 1.21s, fetch_handle: 1.21s, build: 89.9µs, wait: 255.8µs}, table_task: {total_time: 7.73s, num: 56, concurrency: 60}		20.5 KB	N/A
20:52:04 [2021-05-25T20:52:04.820Z]           │   ├─IndexRangeScan_62(Build)	4.02	435528	cop[tikv]	table:partsupp, index:PRIMARY(PS_PARTKEY, PS_SUPPKEY)	time:1.17s, loops:484, cop_task: {num: 61, max: 205.7ms, min: 8.33ms, avg: 85.2ms, p95: 183.3ms, max_proc_keys: 15288, p95_proc_keys: 14948, tot_proc: 4.79s, tot_wait: 12ms, rpc_num: 61, rpc_time: 5.2s, copr_cache: disabled}, tikv_task:{proc max:194ms, min:3ms, p80:136ms, p95:169ms, iters:702, 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:52:04 [2021-05-25T20:52:04.820Z]           │   └─TableRowIDScan_63(Probe)	4.02	435528	cop[tikv]	table:partsupp	time:2.36s, loops:505, cop_task: {num: 1427, max: 63.9ms, min: 332.7µs, avg: 17.4ms, p95: 35.1ms, max_proc_keys: 952, p95_proc_keys: 612, tot_proc: 19s, tot_wait: 3.93s, rpc_num: 1427, rpc_time: 24.9s, copr_cache: disabled}, tikv_task:{proc max:45ms, min:0s, p80:17ms, p95:25ms, iters:5297, tasks:1427}, scan_detail: {total_process_keys: 435528, total_keys: 473510, rocksdb: {delete_skipped_count: 0, key_skipped_count: 194068, block: {cache_hit_count: 3644215, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:52:04 [2021-05-25T20:52:04.820Z]           └─TableReader_101(Probe)	46310896.67	45504356	root		time:34.3s, loops:44289, cop_task: {num: 761, max: 1.09s, min: 354.7ms, avg: 724ms, p95: 878.3ms, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 9m7.9s, tot_wait: 108ms, rpc_num: 761, rpc_time: 9m10.9s, copr_cache: disabled}	data:Selection_100	52.6 MB	N/A
20:52:04 [2021-05-25T20:52:04.820Z]             └─Selection_100	46310896.67	45504356	cop[tikv]		tikv_task:{proc max:1.07s, min:342ms, p80:768ms, p95:852ms, 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:52:04 [2021-05-25T20:52:04.820Z]               └─TableFullScan_99	300005811.00	300005811	cop[tikv]	table:lineitem	tikv_task:{proc max:1.04s, min:324ms, p80:733ms, p95:817ms, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:52:04 [2021-05-25T20:52:04.820Z] 
20:52:04 [2021-05-25T20:52:04.820Z] queries/21.sql
20:52:04 [2021-05-25T20:52:04.820Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:52:04 [2021-05-25T20:52:04.820Z] Projection_26	100.00	100	root		time:1m23.3s, loops:2, Concurrency:OFF	tpch50.supplier.s_name, Column#72	4.37 KB	N/A
20:52:04 [2021-05-25T20:52:04.820Z] └─TopN_29	100.00	100	root		time:1m23.3s, loops:2	Column#72:desc, tpch50.supplier.s_name, offset:0, count:100	58.3 KB	N/A
20:52:04 [2021-05-25T20:52:04.820Z]   └─HashAgg_34	12800.00	20057	root		time:1m23.3s, loops:21, partial_worker:{wall_time:1m23.332885525s, concurrency:5, task_num:198, tot_wait:6m56.347013896s, tot_exec:302.697626ms, tot_time:6m56.663253155s, max:1m23.332860444s, p95:1m23.332860444s}, final_worker:{wall_time:1m23.34777208s, concurrency:5, task_num:25, tot_wait:6m56.662619412s, tot_exec:70.370795ms, tot_time:6m56.733009817s, max:1m23.347751116s, p95:1m23.347751116s}	group by:tpch50.supplier.s_name, funcs:count(1)->Column#72, funcs:firstrow(tpch50.supplier.s_name)->tpch50.supplier.s_name	17.3 MB	N/A
20:52:04 [2021-05-25T20:52:04.820Z]     └─IndexHashJoin_42	7828961.66	198698	root		time:1m23.3s, loops:199, inner:{total:2m24.3s, concurrency:5, task:146, construct:6.33s, fetch:2m0.1s, build:1.24s, join:17.9s}	anti semi join, inner:IndexLookUp_39, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey)	641.0 MB	N/A
20:52:04 [2021-05-25T20:52:04.820Z]       ├─IndexHashJoin_83(Build)	9786202.08	3542799	root		time:1m22.7s, loops:3463, inner:{total:2m33.4s, concurrency:5, task:152, construct:7.73s, fetch:2m7.2s, build:1.22s, join:18.4s}	semi join, inner:IndexLookUp_80, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey), ne(tpch50.lineitem.l_suppkey, tpch50.supplier.s_suppkey)	555.9 MB	N/A
20:52:04 [2021-05-25T20:52:04.820Z]       │ ├─IndexJoin_99(Build)	12232752.60	3675878	root		time:1m22s, loops:3595, inner:{total:2m11.8s, concurrency:5, task:305, construct:16.1s, fetch:1m53.8s, build:1.85s}, probe:5.4s	inner join, inner:TableReader_95, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.orders.o_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.orders.o_orderkey)	581.8 MB	N/A
20:52:04 [2021-05-25T20:52:04.820Z]       │ │ ├─HashJoin_107(Build)	12232752.60	7609895	root		time:1m21.3s, loops:7436, build_hash_table:{total:944.5ms, fetch:936.9ms, build:7.57ms}, probe:{concurrency:5, total:6m49.6s, max:1m21.9s, probe:1m2.8s, fetch:5m46.8s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.lineitem.l_suppkey)]	752.0 KB	0 Bytes
20:52:04 [2021-05-25T20:52:04.820Z]       │ │ │ ├─HashJoin_120(Build)	20000.00	20058	root		time:940.7ms, loops:23, build_hash_table:{total:432.9µs, fetch:204.2µs, build:228.7µs}, probe:{concurrency:5, total:4.71s, max:941.7ms, probe:65.2ms, fetch:4.64s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:52:04 [2021-05-25T20:52:04.820Z]       │ │ │ │ ├─TableReader_125(Build)	1.00	1	root		time:63.6µs, loops:2, cop_task: {num: 1, max: 864.2µs, proc_keys: 25, rpc_num: 1, rpc_time: 844.6µs, copr_cache: disabled}	data:Selection_124	234 Bytes	N/A
20:52:04 [2021-05-25T20:52:04.820Z]       │ │ │ │ │ └─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:52:04 [2021-05-25T20:52:04.820Z]       │ │ │ │ │   └─TableFullScan_123	25.00	25	cop[tikv]	table:nation	tikv_task:{time:0s, loops:1}	keep order:false	N/A	N/A
20:52:04 [2021-05-25T20:52:04.820Z]       │ │ │ │ └─TableReader_122(Probe)	500000.00	500000	root		time:928.6ms, loops:490, cop_task: {num: 1, max: 1.05s, proc_keys: 500000, tot_proc: 1.02s, rpc_num: 1, rpc_time: 1.05s, copr_cache: disabled}	data:TableFullScan_121	20.0 MB	N/A
20:52:04 [2021-05-25T20:52:04.820Z]       │ │ │ │   └─TableFullScan_121	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:965ms, loops:493}, scan_detail: {total_process_keys: 500000, total_keys: 500001, rocksdb: {delete_skipped_count: 0, key_skipped_count: 999999, block: {cache_hit_count: 15, read_count: 1689, read_byte: 108.5 MB}}}	keep order:false	N/A	N/A
20:52:04 [2021-05-25T20:52:04.820Z]       │ │ │ └─TableReader_128(Probe)	240004648.80	189670348	root		time:1m9.2s, loops:184595, cop_task: {num: 761, max: 2.79s, min: 278ms, avg: 1.57s, p95: 2.04s, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 18m40.5s, tot_wait: 1m3.7s, rpc_num: 761, rpc_time: 19m58.5s, copr_cache: disabled}	data:Selection_127	109.4 MB	N/A
20:52:04 [2021-05-25T20:52:04.820Z]       │ │ │   └─Selection_127	240004648.80	189670348	cop[tikv]		tikv_task:{proc max:1.4s, min:265ms, 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: 18668, read_count: 1131804, read_byte: 23.9 GB}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:52:04 [2021-05-25T20:52:04.820Z]       │ │ │     └─TableFullScan_126	300005811.00	300005811	cop[tikv]	table:l1	tikv_task:{proc max:1.3s, min:249ms, p80:1.13s, p95:1.18s, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:52:04 [2021-05-25T20:52:04.820Z]       │ │ └─TableReader_95(Probe)	0.49	3496189	root		time:1m44.7s, loops:3875, cop_task: {num: 5293, max: 567.4ms, min: 3.27ms, avg: 187.6ms, p95: 354.1ms, max_proc_keys: 4563, p95_proc_keys: 1964, tot_proc: 11m45.8s, tot_wait: 3m57.2s, rpc_num: 5293, rpc_time: 16m32.5s, copr_cache: disabled}	data:Selection_94	N/A	N/A
20:52:04 [2021-05-25T20:52:04.820Z]       │ │   └─Selection_94	0.49	3496189	cop[tikv]		tikv_task:{proc max:190ms, min:0s, p80:72ms, p95:85ms, iters:30284, tasks:5293}, scan_detail: {total_process_keys: 7236283, total_keys: 7795458, rocksdb: {delete_skipped_count: 0, key_skipped_count: 1778229, block: {cache_hit_count: 54007196, read_count: 220276, read_byte: 4.84 GB}}}	eq(tpch50.orders.o_orderstatus, "F")	N/A	N/A
20:52:04 [2021-05-25T20:52:04.820Z]       │ │     └─TableRangeScan_93	1.00	7236283	cop[tikv]	table:orders	tikv_task:{proc max:190ms, min:0s, p80:72ms, p95:85ms, iters:30284, tasks:5293}	range: decided by [tpch50.lineitem.l_orderkey], keep order:false	N/A	N/A
20:52:04 [2021-05-25T20:52:04.820Z]       │ └─IndexLookUp_80(Probe)	4.05	17316393	root		time:2m1.5s, loops:17124, index_task: {total_time: 1m6.7s, fetch_handle: 57.8s, build: 3.13ms, wait: 8.87s}, table_task: {total_time: 8m45.2s, num: 1458, concurrency: 760}		18.9 KB	N/A
20:52:04 [2021-05-25T20:52:04.820Z]       │   ├─IndexRangeScan_78(Build)	4.05	17316393	cop[tikv]	table:l2, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:55.5s, loops:18592, cop_task: {num: 3040, max: 771.5ms, min: 743.8µs, avg: 193ms, p95: 386ms, max_proc_keys: 14844, p95_proc_keys: 8768, tot_proc: 7m21.9s, tot_wait: 1m59.3s, rpc_num: 3040, rpc_time: 9m46.6s, copr_cache: disabled}, tikv_task:{proc max:199ms, min:0s, p80:103ms, p95:119ms, iters:30264, tasks:3040}, scan_detail: {total_process_keys: 17316393, total_keys: 20812486, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17316393, block: {cache_hit_count: 24260102, read_count: 226908, read_byte: 2.40 GB}}}	range: decided by [eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey)], keep order:false	N/A	N/A
20:52:04 [2021-05-25T20:52:04.820Z]       │   └─TableRowIDScan_79(Probe)	4.05	17316393	cop[tikv]	table:l2	time:6m27.6s, loops:21013, cop_task: {num: 7784, max: 641.1ms, min: 529.5µs, avg: 182ms, p95: 363.6ms, max_proc_keys: 11392, p95_proc_keys: 4826, tot_proc: 16m55.3s, tot_wait: 5m41.1s, rpc_num: 7784, rpc_time: 23m36.1s, copr_cache: disabled}, tikv_task:{proc max:272ms, min:0s, p80:107ms, p95:145ms, iters:49888, tasks:7784}, scan_detail: {total_process_keys: 17316393, total_keys: 18290063, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5632468, block: {cache_hit_count: 99015423, read_count: 5, read_byte: 36.7 KB}}}	keep order:false	N/A	N/A
20:52:04 [2021-05-25T20:52:04.820Z]       └─IndexLookUp_39(Probe)	4.05	12022757	root		time:1m55.1s, loops:11949, index_task: {total_time: 1m2.6s, fetch_handle: 54.7s, build: 4.1ms, wait: 7.92s}, table_task: {total_time: 8m14s, num: 1408, concurrency: 730}		216.7 KB	N/A
20:52:04 [2021-05-25T20:52:04.820Z]         ├─IndexRangeScan_36(Build)	5.06	17183335	cop[tikv]	table:l3, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:52.3s, loops:18360, cop_task: {num: 2829, max: 744.7ms, min: 2.57ms, avg: 172.9ms, p95: 379.7ms, max_proc_keys: 21359, p95_proc_keys: 13600, tot_proc: 6m0.7s, tot_wait: 1m44.5s, rpc_num: 2829, rpc_time: 8m9.1s, copr_cache: disabled}, tikv_task:{proc max:197ms, min:0s, p80:82ms, p95:126ms, iters:29261, tasks:2829}, scan_detail: {total_process_keys: 17183335, total_keys: 20546352, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17183335, block: {cache_hit_count: 23553925, 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:04 [2021-05-25T20:52:04.820Z]         └─Selection_38(Probe)	4.05	12022757	cop[tikv]		time:6m14.3s, loops:13774, cop_task: {num: 10241, max: 776.8ms, min: 585.2µs, avg: 174.5ms, p95: 357ms, max_proc_keys: 8014, p95_proc_keys: 3957, tot_proc: 20m50.1s, tot_wait: 7m35.9s, rpc_num: 10241, rpc_time: 29m46.7s, copr_cache: disabled}, tikv_task:{proc max:227ms, min:0s, p80:78ms, p95:118ms, iters:60644, tasks:10241}, scan_detail: {total_process_keys: 17183335, total_keys: 18128607, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5524746, block: {cache_hit_count: 98291143, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:52:04 [2021-05-25T20:52:04.820Z]           └─TableRowIDScan_37	5.06	17183335	cop[tikv]	table:l3	tikv_task:{proc max:224ms, min:0s, p80:78ms, p95:117ms, iters:60644, tasks:10241}	keep order:false	N/A	N/A
20:52:04 [2021-05-25T20:52:04.820Z] + sync
20:52:04 [2021-05-25T20:52:04.820Z] + /usr/bin/echo 3
20:53:26 [2021-05-25T20:53:26.352Z] 
20:53:26 [2021-05-25T20:53:26.352Z] queries/21.sql
20:53:26 [2021-05-25T20:53:26.353Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:53:26 [2021-05-25T20:53:26.353Z] Projection_26	100.00	100	root		time:1m22.3s, loops:2, Concurrency:OFF	tpch50.supplier.s_name, Column#72	4.37 KB	N/A
20:53:26 [2021-05-25T20:53:26.353Z] └─TopN_29	100.00	100	root		time:1m22.3s, loops:2	Column#72:desc, tpch50.supplier.s_name, offset:0, count:100	58.3 KB	N/A
20:53:26 [2021-05-25T20:53:26.353Z]   └─HashAgg_34	12800.00	20057	root		time:1m22.3s, loops:21, partial_worker:{wall_time:1m22.304578335s, concurrency:5, task_num:197, tot_wait:6m51.189939865s, tot_exec:307.15083ms, tot_time:6m51.515513105s, max:1m22.304534847s, p95:1m22.304534847s}, final_worker:{wall_time:1m22.317466495s, concurrency:5, task_num:25, tot_wait:6m51.512015809s, tot_exec:73.636459ms, tot_time:6m51.585666581s, max:1m22.317449605s, p95:1m22.317449605s}	group by:tpch50.supplier.s_name, funcs:count(1)->Column#72, funcs:firstrow(tpch50.supplier.s_name)->tpch50.supplier.s_name	17.3 MB	N/A
20:53:26 [2021-05-25T20:53:26.353Z]     └─IndexHashJoin_42	7828961.66	198698	root		time:1m22.3s, loops:198, inner:{total:2m23.3s, concurrency:5, task:146, construct:6.37s, fetch:1m59.6s, build:1.24s, join:17.3s}	anti semi join, inner:IndexLookUp_39, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey)	641.0 MB	N/A
20:53:26 [2021-05-25T20:53:26.353Z]       ├─IndexHashJoin_83(Build)	9786202.08	3542799	root		time:1m21.7s, loops:3462, inner:{total:2m32.2s, concurrency:5, task:152, construct:7.69s, fetch:2m6s, build:1.27s, join:18.6s}	semi join, inner:IndexLookUp_80, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey), ne(tpch50.lineitem.l_suppkey, tpch50.supplier.s_suppkey)	555.9 MB	N/A
20:53:26 [2021-05-25T20:53:26.353Z]       │ ├─IndexJoin_99(Build)	12232752.60	3675878	root		time:1m21.2s, loops:3595, inner:{total:2m11.6s, concurrency:5, task:305, construct:16.4s, fetch:1m53.2s, build:1.95s}, probe:5.29s	inner join, inner:TableReader_95, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.orders.o_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.orders.o_orderkey)	582.0 MB	N/A
20:53:26 [2021-05-25T20:53:26.353Z]       │ │ ├─HashJoin_107(Build)	12232752.60	7609895	root		time:1m20.7s, loops:7435, build_hash_table:{total:1.07s, fetch:1.06s, build:9.09ms}, probe:{concurrency:5, total:6m45.9s, max:1m21.2s, probe:1m2.7s, fetch:5m43.2s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.lineitem.l_suppkey)]	722.8 KB	0 Bytes
20:53:26 [2021-05-25T20:53:26.353Z]       │ │ │ ├─HashJoin_120(Build)	20000.00	20058	root		time:1.06s, loops:22, build_hash_table:{total:435.2µs, fetch:429.2µs, build:5.96µs}, probe:{concurrency:5, total:5.33s, max:1.07s, probe:75.1ms, fetch:5.25s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:53:26 [2021-05-25T20:53:26.353Z]       │ │ │ │ ├─TableReader_125(Build)	1.00	1	root		time:44.6µs, loops:2, cop_task: {num: 1, max: 1.26ms, proc_keys: 25, rpc_num: 1, rpc_time: 1.24ms, copr_cache: disabled}	data:Selection_124	244 Bytes	N/A
20:53:26 [2021-05-25T20:53:26.353Z]       │ │ │ │ │ └─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:26 [2021-05-25T20:53:26.353Z]       │ │ │ │ │   └─TableFullScan_123	25.00	25	cop[tikv]	table:nation	tikv_task:{time:0s, loops:1}	keep order:false	N/A	N/A
20:53:26 [2021-05-25T20:53:26.353Z]       │ │ │ │ └─TableReader_122(Probe)	500000.00	500000	root		time:1.05s, loops:490, cop_task: {num: 1, max: 1.05s, proc_keys: 500000, tot_proc: 1.02s, tot_wait: 1ms, rpc_num: 1, rpc_time: 1.05s, copr_cache: disabled}	data:TableFullScan_121	20.0 MB	N/A
20:53:26 [2021-05-25T20:53:26.353Z]       │ │ │ │   └─TableFullScan_121	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: 13, read_count: 1679, read_byte: 104.5 MB}}}	keep order:false	N/A	N/A
20:53:26 [2021-05-25T20:53:26.353Z]       │ │ │ └─TableReader_128(Probe)	240004648.80	189670348	root		time:1m8.3s, loops:184595, cop_task: {num: 761, max: 2.75s, min: 287.9ms, avg: 1.55s, p95: 2.04s, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 18m26s, tot_wait: 1m1.5s, rpc_num: 761, rpc_time: 19m42.1s, copr_cache: disabled}	data:Selection_127	109.4 MB	N/A
20:53:26 [2021-05-25T20:53:26.353Z]       │ │ │   └─Selection_127	240004648.80	189670348	cop[tikv]		tikv_task:{proc max:1.3s, min:271ms, 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: 10454, read_count: 1114194, read_byte: 23.6 GB}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:53:26 [2021-05-25T20:53:26.353Z]       │ │ │     └─TableFullScan_126	300005811.00	300005811	cop[tikv]	table:l1	tikv_task:{proc max:1.22s, min:264ms, p80:1.1s, p95:1.14s, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:53:26 [2021-05-25T20:53:26.353Z]       │ │ └─TableReader_95(Probe)	0.49	3496177	root		time:1m43.8s, loops:3875, cop_task: {num: 5301, max: 540ms, min: 2.23ms, avg: 183.5ms, p95: 352.5ms, max_proc_keys: 3704, p95_proc_keys: 1959, tot_proc: 11m33.1s, tot_wait: 3m50.1s, rpc_num: 5301, rpc_time: 16m12.5s, copr_cache: disabled}	data:Selection_94	N/A	N/A
20:53:26 [2021-05-25T20:53:26.353Z]       │ │   └─Selection_94	0.49	3496177	cop[tikv]		tikv_task:{proc max:129ms, min:0s, p80:71ms, p95:83ms, iters:30330, tasks:5301}, scan_detail: {total_process_keys: 7236261, total_keys: 7795468, rocksdb: {delete_skipped_count: 0, key_skipped_count: 1778273, block: {cache_hit_count: 54006580, read_count: 218300, read_byte: 4.22 GB}}}	eq(tpch50.orders.o_orderstatus, "F")	N/A	N/A
20:53:26 [2021-05-25T20:53:26.353Z]       │ │     └─TableRangeScan_93	1.00	7236261	cop[tikv]	table:orders	tikv_task:{proc max:129ms, min:0s, p80:70ms, p95:83ms, iters:30330, tasks:5301}	range: decided by [tpch50.lineitem.l_orderkey], keep order:false	N/A	N/A
20:53:26 [2021-05-25T20:53:26.353Z]       │ └─IndexLookUp_80(Probe)	4.05	17316519	root		time:2m0.4s, loops:17126, index_task: {total_time: 1m8.2s, fetch_handle: 1m0s, build: 3.84ms, wait: 8.23s}, table_task: {total_time: 8m39.8s, num: 1458, concurrency: 760}		19.2 KB	N/A
20:53:26 [2021-05-25T20:53:26.353Z]       │   ├─IndexRangeScan_78(Build)	4.05	17316519	cop[tikv]	table:l2, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:57.6s, loops:18615, cop_task: {num: 3034, max: 738.8ms, min: 620.5µs, avg: 191.7ms, p95: 393.7ms, max_proc_keys: 13766, p95_proc_keys: 8761, tot_proc: 7m15.2s, tot_wait: 2m1.2s, rpc_num: 3034, rpc_time: 9m41.6s, copr_cache: disabled}, tikv_task:{proc max:180ms, min:0s, p80:99ms, p95:116ms, iters:30250, tasks:3034}, scan_detail: {total_process_keys: 17316519, total_keys: 20812634, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17316519, block: {cache_hit_count: 24260054, read_count: 225678, read_byte: 2.00 GB}}}	range: decided by [eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey)], keep order:false	N/A	N/A
20:53:26 [2021-05-25T20:53:26.353Z]       │   └─TableRowIDScan_79(Probe)	4.05	17316519	cop[tikv]	table:l2	time:6m23.2s, loops:20955, cop_task: {num: 7785, max: 639.1ms, min: 572.5µs, avg: 180.5ms, p95: 363.4ms, max_proc_keys: 12685, p95_proc_keys: 4802, tot_proc: 16m43.9s, tot_wait: 5m41.7s, rpc_num: 7785, rpc_time: 23m24.8s, copr_cache: disabled}, tikv_task:{proc max:246ms, min:0s, p80:107ms, p95:141ms, iters:49810, tasks:7785}, scan_detail: {total_process_keys: 17316519, total_keys: 18289405, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5626252, block: {cache_hit_count: 99029022, read_count: 1115, read_byte: 393.9 MB}}}	keep order:false	N/A	N/A
20:53:26 [2021-05-25T20:53:26.353Z]       └─IndexLookUp_39(Probe)	4.05	12022825	root		time:1m54.6s, loops:11941, index_task: {total_time: 1m2.3s, fetch_handle: 49.8s, build: 3.1ms, wait: 12.5s}, table_task: {total_time: 8m15.1s, num: 1408, concurrency: 730}		210.3 KB	N/A
20:53:26 [2021-05-25T20:53:26.353Z]         ├─IndexRangeScan_36(Build)	5.06	17183422	cop[tikv]	table:l3, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:47.5s, loops:18357, cop_task: {num: 2813, max: 767.1ms, min: 882.6µs, avg: 170ms, p95: 363.1ms, max_proc_keys: 21486, p95_proc_keys: 13443, tot_proc: 5m55.8s, tot_wait: 1m37.6s, rpc_num: 2813, rpc_time: 7m58.1s, copr_cache: disabled}, tikv_task:{proc max:198ms, min:0s, p80:81ms, p95:122ms, iters:29188, tasks:2813}, scan_detail: {total_process_keys: 17183422, total_keys: 20546454, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17183422, block: {cache_hit_count: 23554030, read_count: 0, read_byte: 0 Bytes}}}	range: decided by [eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey)], keep order:false	N/A	N/A
20:53:26 [2021-05-25T20:53:26.353Z]         └─Selection_38(Probe)	4.05	12022825	cop[tikv]		time:6m22.9s, loops:13777, cop_task: {num: 10164, max: 613.4ms, min: 702µs, avg: 177.4ms, p95: 356.6ms, max_proc_keys: 7580, p95_proc_keys: 3978, tot_proc: 21m1.9s, tot_wait: 7m42.5s, rpc_num: 10164, rpc_time: 30m2.6s, copr_cache: disabled}, tikv_task:{proc max:264ms, min:0s, p80:79ms, p95:118ms, iters:60339, tasks:10164}, scan_detail: {total_process_keys: 17183422, total_keys: 18129286, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5525876, block: {cache_hit_count: 98294207, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:53:26 [2021-05-25T20:53:26.353Z]           └─TableRowIDScan_37	5.06	17183422	cop[tikv]	table:l3	tikv_task:{proc max:261ms, min:0s, p80:78ms, p95:117ms, iters:60339, tasks:10164}	keep order:false	N/A	N/A
20:53:26 [2021-05-25T20:53:26.353Z] + sync
20:53:26 [2021-05-25T20:53:26.353Z] + /usr/bin/echo 3
20:55:02 [2021-05-25T20:55:02.735Z] 
20:55:02 [2021-05-25T20:55:02.735Z] queries/21.sql
20:55:02 [2021-05-25T20:55:02.735Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:55:02 [2021-05-25T20:55:02.735Z] Projection_26	100.00	100	root		time:1m22.4s, loops:2, Concurrency:OFF	tpch50.supplier.s_name, Column#72	4.37 KB	N/A
20:55:02 [2021-05-25T20:55:02.735Z] └─TopN_29	100.00	100	root		time:1m22.4s, loops:2	Column#72:desc, tpch50.supplier.s_name, offset:0, count:100	55.0 KB	N/A
20:55:02 [2021-05-25T20:55:02.735Z]   └─HashAgg_34	12800.00	20057	root		time:1m22.4s, loops:21, partial_worker:{wall_time:1m22.342219976s, concurrency:5, task_num:195, tot_wait:6m51.409107167s, tot_exec:287.614641ms, tot_time:6m51.710254389s, max:1m22.342194984s, p95:1m22.342194984s}, final_worker:{wall_time:1m22.358787418s, concurrency:5, task_num:25, tot_wait:6m51.70954395s, tot_exec:75.805437ms, tot_time:6m51.785375675s, max:1m22.358767792s, p95:1m22.358767792s}	group by:tpch50.supplier.s_name, funcs:count(1)->Column#72, funcs:firstrow(tpch50.supplier.s_name)->tpch50.supplier.s_name	17.3 MB	N/A
20:55:02 [2021-05-25T20:55:02.735Z]     └─IndexHashJoin_42	7828961.66	198698	root		time:1m22.3s, loops:196, inner:{total:2m23.9s, concurrency:5, task:147, construct:6.41s, fetch:2m0s, build:1.28s, join:17.5s}	anti semi join, inner:IndexLookUp_39, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey)	641.0 MB	N/A
20:55:02 [2021-05-25T20:55:02.735Z]       ├─IndexHashJoin_83(Build)	9786202.08	3542799	root		time:1m21.7s, loops:3464, inner:{total:2m34.2s, concurrency:5, task:152, construct:7.77s, fetch:2m8.3s, build:1.26s, join:18.1s}	semi join, inner:IndexLookUp_80, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey), ne(tpch50.lineitem.l_suppkey, tpch50.supplier.s_suppkey)	555.9 MB	N/A
20:55:02 [2021-05-25T20:55:02.735Z]       │ ├─IndexJoin_99(Build)	12232752.60	3675878	root		time:1m21.1s, loops:3595, inner:{total:2m9.4s, concurrency:5, task:305, construct:16s, fetch:1m51.6s, 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)	582.0 MB	N/A
20:55:02 [2021-05-25T20:55:02.736Z]       │ │ ├─HashJoin_107(Build)	12232752.60	7609895	root		time:1m20.5s, loops:7436, build_hash_table:{total:1.07s, fetch:1.07s, build:6.35ms}, probe:{concurrency:5, total:6m44.7s, max:1m20.9s, probe:1m2.2s, fetch:5m42.5s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.lineitem.l_suppkey)]	727.6 KB	0 Bytes
20:55:02 [2021-05-25T20:55:02.736Z]       │ │ │ ├─HashJoin_120(Build)	20000.00	20058	root		time:1.07s, loops:22, build_hash_table:{total:241.6µs, fetch:234.1µs, build:7.55µs}, probe:{concurrency:5, total:5.36s, max:1.07s, probe:59.4ms, fetch:5.3s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:55:02 [2021-05-25T20:55:02.736Z]       │ │ │ │ ├─TableReader_125(Build)	1.00	1	root		time:62.5µs, loops:2, cop_task: {num: 1, max: 1.58ms, proc_keys: 25, tot_proc: 1ms, tot_wait: 1ms, rpc_num: 1, rpc_time: 1.53ms, copr_cache: disabled}	data:Selection_124	252 Bytes	N/A
20:55:02 [2021-05-25T20:55:02.736Z]       │ │ │ │ │ └─Selection_124	1.00	1	cop[tikv]		tikv_task:{time:1ms, loops:1}, scan_detail: {total_process_keys: 25, total_keys: 26, rocksdb: {delete_skipped_count: 0, key_skipped_count: 46, block: {cache_hit_count: 17, read_count: 1, read_byte: 23.8 KB}}}	eq(tpch50.nation.n_name, "EGYPT")	N/A	N/A
20:55:02 [2021-05-25T20:55:02.736Z]       │ │ │ │ │   └─TableFullScan_123	25.00	25	cop[tikv]	table:nation	tikv_task:{time:1ms, loops:1}	keep order:false	N/A	N/A
20:55:02 [2021-05-25T20:55:02.736Z]       │ │ │ │ └─TableReader_122(Probe)	500000.00	500000	root		time:1.06s, loops:490, cop_task: {num: 1, max: 1.06s, proc_keys: 500000, tot_proc: 1.03s, tot_wait: 1ms, rpc_num: 1, rpc_time: 1.06s, copr_cache: disabled}	data:TableFullScan_121	20.0 MB	N/A
20:55:02 [2021-05-25T20:55:02.736Z]       │ │ │ │   └─TableFullScan_121	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:964ms, loops:493}, scan_detail: {total_process_keys: 500000, total_keys: 500001, rocksdb: {delete_skipped_count: 0, key_skipped_count: 999999, block: {cache_hit_count: 13, read_count: 1679, read_byte: 104.5 MB}}}	keep order:false	N/A	N/A
20:55:02 [2021-05-25T20:55:02.736Z]       │ │ │ └─TableReader_128(Probe)	240004648.80	189670348	root		time:1m8.1s, loops:184597, cop_task: {num: 761, max: 2.71s, min: 346.6ms, avg: 1.56s, p95: 2.08s, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 18m29.6s, tot_wait: 1m2.1s, rpc_num: 761, rpc_time: 19m46.4s, copr_cache: disabled}	data:Selection_127	109.4 MB	N/A
20:55:02 [2021-05-25T20:55:02.736Z]       │ │ │   └─Selection_127	240004648.80	189670348	cop[tikv]		tikv_task:{proc max:1.33s, min:333ms, 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: 10461, read_count: 1114187, read_byte: 23.6 GB}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:55:02 [2021-05-25T20:55:02.736Z]       │ │ │     └─TableFullScan_126	300005811.00	300005811	cop[tikv]	table:l1	tikv_task:{proc max:1.25s, min:304ms, p80:1.11s, p95:1.15s, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:55:02 [2021-05-25T20:55:02.736Z]       │ │ └─TableReader_95(Probe)	0.49	3496188	root		time:1m42.4s, loops:3875, cop_task: {num: 5282, max: 543.4ms, min: 692.1µs, avg: 182.5ms, p95: 340.7ms, max_proc_keys: 4448, p95_proc_keys: 1967, tot_proc: 11m26.6s, tot_wait: 3m49.9s, rpc_num: 5282, rpc_time: 16m3.7s, copr_cache: disabled}	data:Selection_94	N/A	N/A
20:55:02 [2021-05-25T20:55:02.736Z]       │ │   └─Selection_94	0.49	3496188	cop[tikv]		tikv_task:{proc max:199ms, min:0s, p80:71ms, p95:84ms, iters:30349, tasks:5282}, scan_detail: {total_process_keys: 7236281, total_keys: 7795442, rocksdb: {delete_skipped_count: 0, key_skipped_count: 1778127, block: {cache_hit_count: 54006891, read_count: 218170, read_byte: 4.21 GB}}}	eq(tpch50.orders.o_orderstatus, "F")	N/A	N/A
20:55:02 [2021-05-25T20:55:02.736Z]       │ │     └─TableRangeScan_93	1.00	7236281	cop[tikv]	table:orders	tikv_task:{proc max:197ms, min:0s, p80:71ms, p95:84ms, iters:30349, tasks:5282}	range: decided by [tpch50.lineitem.l_orderkey], keep order:false	N/A	N/A
20:55:02 [2021-05-25T20:55:02.736Z]       │ └─IndexLookUp_80(Probe)	4.05	17316485	root		time:2m2.9s, loops:17128, index_task: {total_time: 1m8.8s, fetch_handle: 59.8s, build: 3.07ms, wait: 9s}, table_task: {total_time: 8m48.5s, num: 1458, concurrency: 760}		19.1 KB	N/A
20:55:02 [2021-05-25T20:55:02.736Z]       │   ├─IndexRangeScan_78(Build)	4.05	17316485	cop[tikv]	table:l2, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:57.5s, loops:18638, cop_task: {num: 3035, max: 719.3ms, min: 447.5µs, avg: 195.2ms, p95: 380.4ms, max_proc_keys: 11334, p95_proc_keys: 8790, tot_proc: 7m23.7s, tot_wait: 2m2.8s, rpc_num: 3035, rpc_time: 9m52.5s, copr_cache: disabled}, tikv_task:{proc max:187ms, min:0s, p80:99ms, p95:115ms, iters:30346, tasks:3035}, scan_detail: {total_process_keys: 17316485, total_keys: 20812593, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17316485, block: {cache_hit_count: 24260010, read_count: 225673, read_byte: 2.00 GB}}}	range: decided by [eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey)], keep order:false	N/A	N/A
20:55:02 [2021-05-25T20:55:02.736Z]       │   └─TableRowIDScan_79(Probe)	4.05	17316485	cop[tikv]	table:l2	time:6m30.2s, loops:20991, cop_task: {num: 7840, max: 648.4ms, min: 1.3ms, avg: 183.7ms, p95: 367.5ms, max_proc_keys: 11604, p95_proc_keys: 4840, tot_proc: 17m11.9s, tot_wait: 5m48.5s, rpc_num: 7840, rpc_time: 24m0s, copr_cache: disabled}, tikv_task:{proc max:259ms, min:0s, p80:106ms, p95:143ms, iters:49943, tasks:7840}, scan_detail: {total_process_keys: 17316485, total_keys: 18289958, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5629001, block: {cache_hit_count: 99025296, read_count: 1112, read_byte: 390.6 MB}}}	keep order:false	N/A	N/A
20:55:02 [2021-05-25T20:55:02.736Z]       └─IndexLookUp_39(Probe)	4.05	12022820	root		time:1m55.2s, loops:11947, index_task: {total_time: 1m1.4s, fetch_handle: 51.1s, build: 4.65ms, wait: 10.3s}, table_task: {total_time: 8m18.1s, num: 1410, concurrency: 735}		229.7 KB	N/A
20:55:02 [2021-05-25T20:55:02.736Z]         ├─IndexRangeScan_36(Build)	5.06	17183408	cop[tikv]	table:l3, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:48.8s, loops:18415, cop_task: {num: 2824, max: 820.2ms, min: 406.2µs, avg: 171ms, p95: 367ms, max_proc_keys: 18216, p95_proc_keys: 13402, tot_proc: 5m58.5s, tot_wait: 1m41.4s, rpc_num: 2824, rpc_time: 8m2.9s, copr_cache: disabled}, tikv_task:{proc max:189ms, min:0s, p80:81ms, p95:122ms, iters:29319, tasks:2824}, scan_detail: {total_process_keys: 17183408, total_keys: 20546439, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17183408, 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:55:02 [2021-05-25T20:55:02.736Z]         └─Selection_38(Probe)	4.05	12022820	cop[tikv]		time:6m24s, loops:13762, cop_task: {num: 10224, max: 687.4ms, min: 695.5µs, avg: 178.8ms, p95: 355.5ms, max_proc_keys: 7954, p95_proc_keys: 4016, tot_proc: 21m23.6s, tot_wait: 7m45.2s, rpc_num: 10224, rpc_time: 30m27.6s, copr_cache: disabled}, tikv_task:{proc max:252ms, min:0s, p80:79ms, p95:119ms, iters:60529, tasks:10224}, scan_detail: {total_process_keys: 17183408, total_keys: 18129136, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5526274, block: {cache_hit_count: 98289955, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:55:02 [2021-05-25T20:55:02.736Z]           └─TableRowIDScan_37	5.06	17183408	cop[tikv]	table:l3	tikv_task:{proc max:252ms, min:0s, p80:78ms, p95:119ms, iters:60529, tasks:10224}	keep order:false	N/A	N/A
20:55:02 [2021-05-25T20:55:02.736Z] + sync
20:55:02 [2021-05-25T20:55:02.736Z] + /usr/bin/echo 3
20:56:24 [2021-05-25T20:56:24.109Z] 
20:56:24 [2021-05-25T20:56:24.109Z] queries/21.sql
20:56:24 [2021-05-25T20:56:24.109Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:56:24 [2021-05-25T20:56:24.109Z] Projection_26	100.00	100	root		time:1m22.3s, loops:2, Concurrency:OFF	tpch50.supplier.s_name, Column#72	4.37 KB	N/A
20:56:24 [2021-05-25T20:56:24.109Z] └─TopN_29	100.00	100	root		time:1m22.3s, loops:2	Column#72:desc, tpch50.supplier.s_name, offset:0, count:100	58.3 KB	N/A
20:56:24 [2021-05-25T20:56:24.109Z]   └─HashAgg_34	12800.00	20057	root		time:1m22.3s, loops:21, partial_worker:{wall_time:1m22.303484739s, concurrency:5, task_num:197, tot_wait:6m51.215842645s, tot_exec:286.404289ms, tot_time:6m51.515749588s, max:1m22.303457242s, p95:1m22.303457242s}, final_worker:{wall_time:1m22.316830816s, concurrency:5, task_num:25, tot_wait:6m51.514941046s, tot_exec:65.18618ms, tot_time:6m51.580140211s, max:1m22.316812241s, p95:1m22.316812241s}	group by:tpch50.supplier.s_name, funcs:count(1)->Column#72, funcs:firstrow(tpch50.supplier.s_name)->tpch50.supplier.s_name	17.3 MB	N/A
20:56:24 [2021-05-25T20:56:24.109Z]     └─IndexHashJoin_42	7828961.66	198698	root		time:1m22.3s, loops:198, inner:{total:2m23.4s, concurrency:5, task:146, construct:6.28s, fetch:2m0.4s, build:1.21s, join:16.8s}	anti semi join, inner:IndexLookUp_39, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey)	641.1 MB	N/A
20:56:24 [2021-05-25T20:56:24.109Z]       ├─IndexHashJoin_83(Build)	9786202.08	3542799	root		time:1m21.8s, loops:3463, inner:{total:2m33.1s, concurrency:5, task:152, construct:7.86s, fetch:2m7.3s, build:1.26s, join:18s}	semi join, inner:IndexLookUp_80, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey), ne(tpch50.lineitem.l_suppkey, tpch50.supplier.s_suppkey)	555.9 MB	N/A
20:56:24 [2021-05-25T20:56:24.109Z]       │ ├─IndexJoin_99(Build)	12232752.60	3675878	root		time:1m21.2s, loops:3595, inner:{total:2m10s, concurrency:5, task:305, construct:16.2s, fetch:1m51.9s, build:1.95s}, probe:5.25s	inner join, inner:TableReader_95, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.orders.o_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.orders.o_orderkey)	581.8 MB	N/A
20:56:24 [2021-05-25T20:56:24.109Z]       │ │ ├─HashJoin_107(Build)	12232752.60	7609895	root		time:1m20.6s, loops:7437, build_hash_table:{total:979.5ms, fetch:972.7ms, build:6.81ms}, probe:{concurrency:5, total:6m45.6s, max:1m21.1s, probe:1m2.8s, fetch:5m42.9s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.lineitem.l_suppkey)]	727.6 KB	0 Bytes
20:56:24 [2021-05-25T20:56:24.109Z]       │ │ │ ├─HashJoin_120(Build)	20000.00	20058	root		time:976.4ms, loops:22, build_hash_table:{total:203.6µs, fetch:195.9µs, build:7.67µs}, probe:{concurrency:5, total:4.89s, max:977.6ms, probe:61.5ms, fetch:4.83s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:56:24 [2021-05-25T20:56:24.110Z]       │ │ │ │ ├─TableReader_125(Build)	1.00	1	root		time:55µs, loops:2, cop_task: {num: 1, max: 1.2ms, proc_keys: 25, tot_proc: 1ms, rpc_num: 1, rpc_time: 1.12ms, copr_cache: disabled}	data:Selection_124	238 Bytes	N/A
20:56:24 [2021-05-25T20:56:24.110Z]       │ │ │ │ │ └─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:56:24 [2021-05-25T20:56:24.110Z]       │ │ │ │ │   └─TableFullScan_123	25.00	25	cop[tikv]	table:nation	tikv_task:{time:0s, loops:1}	keep order:false	N/A	N/A
20:56:24 [2021-05-25T20:56:24.110Z]       │ │ │ │ └─TableReader_122(Probe)	500000.00	500000	root		time:965.1ms, loops:490, cop_task: {num: 1, max: 965.9ms, proc_keys: 500000, tot_proc: 927ms, rpc_num: 1, rpc_time: 965.8ms, copr_cache: disabled}	data:TableFullScan_121	20.0 MB	N/A
20:56:24 [2021-05-25T20:56:24.110Z]       │ │ │ │   └─TableFullScan_121	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:869ms, 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:56:24 [2021-05-25T20:56:24.110Z]       │ │ │ └─TableReader_128(Probe)	240004648.80	189670348	root		time:1m8.2s, loops:184598, cop_task: {num: 761, max: 2.53s, min: 262.1ms, avg: 1.56s, p95: 2.03s, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 18m27.9s, tot_wait: 1m1.2s, rpc_num: 761, rpc_time: 19m43.6s, copr_cache: disabled}	data:Selection_127	109.4 MB	N/A
20:56:24 [2021-05-25T20:56:24.110Z]       │ │ │   └─Selection_127	240004648.80	189670348	cop[tikv]		tikv_task:{proc max:1.4s, min:247ms, 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:56:24 [2021-05-25T20:56:24.110Z]       │ │ │     └─TableFullScan_126	300005811.00	300005811	cop[tikv]	table:l1	tikv_task:{proc max:1.31s, min:228ms, p80:1.11s, p95:1.15s, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:56:24 [2021-05-25T20:56:24.110Z]       │ │ └─TableReader_95(Probe)	0.49	3496192	root		time:1m43.1s, loops:3875, cop_task: {num: 5283, max: 577.6ms, min: 2.88ms, avg: 183.4ms, p95: 345.7ms, max_proc_keys: 3575, p95_proc_keys: 1961, tot_proc: 11m30.4s, tot_wait: 3m51.2s, rpc_num: 5283, rpc_time: 16m8.6s, copr_cache: disabled}	data:Selection_94	N/A	N/A
20:56:24 [2021-05-25T20:56:24.110Z]       │ │   └─Selection_94	0.49	3496192	cop[tikv]		tikv_task:{proc max:147ms, min:0s, p80:71ms, p95:84ms, iters:30323, tasks:5283}, scan_detail: {total_process_keys: 7236273, total_keys: 7795465, rocksdb: {delete_skipped_count: 0, key_skipped_count: 1778248, block: {cache_hit_count: 54006293, read_count: 218203, read_byte: 4.21 GB}}}	eq(tpch50.orders.o_orderstatus, "F")	N/A	N/A
20:56:24 [2021-05-25T20:56:24.110Z]       │ │     └─TableRangeScan_93	1.00	7236273	cop[tikv]	table:orders	tikv_task:{proc max:147ms, min:0s, p80:71ms, p95:84ms, iters:30323, tasks:5283}	range: decided by [tpch50.lineitem.l_orderkey], keep order:false	N/A	N/A
20:56:24 [2021-05-25T20:56:24.110Z]       │ └─IndexLookUp_80(Probe)	4.05	17316426	root		time:2m1.7s, loops:17130, index_task: {total_time: 1m6.6s, fetch_handle: 58.1s, build: 3.9ms, wait: 8.5s}, table_task: {total_time: 8m44.7s, num: 1458, concurrency: 760}		18.9 KB	N/A
20:56:24 [2021-05-25T20:56:24.110Z]       │   ├─IndexRangeScan_78(Build)	4.05	17316426	cop[tikv]	table:l2, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:55.9s, loops:18615, cop_task: {num: 3002, max: 669.3ms, min: 705.2µs, avg: 191.6ms, p95: 377ms, max_proc_keys: 14121, p95_proc_keys: 8749, tot_proc: 7m11.4s, tot_wait: 1m59s, rpc_num: 3002, rpc_time: 9m35.2s, copr_cache: disabled}, tikv_task:{proc max:187ms, min:0s, p80:100ms, p95:116ms, iters:30142, tasks:3002}, scan_detail: {total_process_keys: 17316426, total_keys: 20812524, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17316426, block: {cache_hit_count: 24259931, read_count: 225683, read_byte: 2.00 GB}}}	range: decided by [eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey)], keep order:false	N/A	N/A
20:56:24 [2021-05-25T20:56:24.110Z]       │   └─TableRowIDScan_79(Probe)	4.05	17316426	cop[tikv]	table:l2	time:6m32s, loops:20963, cop_task: {num: 7782, max: 661.1ms, min: 448.5µs, avg: 183.5ms, p95: 371.3ms, max_proc_keys: 12685, p95_proc_keys: 4838, tot_proc: 17m10.1s, tot_wait: 5m38.7s, rpc_num: 7782, rpc_time: 23m47.5s, copr_cache: disabled}, tikv_task:{proc max:317ms, min:0s, p80:107ms, p95:141ms, iters:49907, tasks:7782}, scan_detail: {total_process_keys: 17316426, total_keys: 18290167, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5631369, block: {cache_hit_count: 99019292, read_count: 1106, read_byte: 386.7 MB}}}	keep order:false	N/A	N/A
20:56:24 [2021-05-25T20:56:24.110Z]       └─IndexLookUp_39(Probe)	4.05	12022766	root		time:1m55.3s, loops:11946, index_task: {total_time: 1m1.6s, fetch_handle: 51.5s, build: 3.11ms, wait: 10.2s}, table_task: {total_time: 8m15.9s, num: 1408, concurrency: 730}		215.3 KB	N/A
20:56:24 [2021-05-25T20:56:24.110Z]         ├─IndexRangeScan_36(Build)	5.06	17183360	cop[tikv]	table:l3, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:49.3s, loops:18344, cop_task: {num: 2796, max: 719.6ms, min: 605.6µs, avg: 172.1ms, p95: 366.7ms, max_proc_keys: 17881, p95_proc_keys: 13544, tot_proc: 5m59.6s, tot_wait: 1m39s, rpc_num: 2796, rpc_time: 8m1.1s, copr_cache: disabled}, tikv_task:{proc max:190ms, min:0s, p80:82ms, p95:124ms, iters:29121, tasks:2796}, scan_detail: {total_process_keys: 17183360, total_keys: 20546383, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17183360, block: {cache_hit_count: 23553968, read_count: 0, read_byte: 0 Bytes}}}	range: decided by [eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey)], keep order:false	N/A	N/A
20:56:24 [2021-05-25T20:56:24.110Z]         └─Selection_38(Probe)	4.05	12022766	cop[tikv]		time:6m22s, loops:13775, cop_task: {num: 10098, max: 592.1ms, min: 464µs, avg: 177.8ms, p95: 353.7ms, max_proc_keys: 6981, p95_proc_keys: 4033, tot_proc: 20m57.9s, tot_wait: 7m40.4s, rpc_num: 10098, rpc_time: 29m55.1s, copr_cache: disabled}, tikv_task:{proc max:217ms, min:0s, p80:78ms, p95:119ms, iters:60246, tasks:10098}, scan_detail: {total_process_keys: 17183360, total_keys: 18129957, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5528231, block: {cache_hit_count: 98290935, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:56:24 [2021-05-25T20:56:24.110Z]           └─TableRowIDScan_37	5.06	17183360	cop[tikv]	table:l3	tikv_task:{proc max:216ms, min:0s, p80:77ms, p95:118ms, iters:60246, tasks:10098}	keep order:false	N/A	N/A
20:56:24 [2021-05-25T20:56:24.110Z] + sync
20:56:24 [2021-05-25T20:56:24.110Z] + /usr/bin/echo 3
20:57:45 [2021-05-25T20:57:45.491Z] 
20:57:45 [2021-05-25T20:57:45.491Z] queries/21.sql
20:57:45 [2021-05-25T20:57:45.491Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:57:45 [2021-05-25T20:57:45.491Z] Projection_26	100.00	100	root		time:1m22.6s, loops:2, Concurrency:OFF	tpch50.supplier.s_name, Column#72	4.37 KB	N/A
20:57:45 [2021-05-25T20:57:45.491Z] └─TopN_29	100.00	100	root		time:1m22.6s, loops:2	Column#72:desc, tpch50.supplier.s_name, offset:0, count:100	58.3 KB	N/A
20:57:45 [2021-05-25T20:57:45.491Z]   └─HashAgg_34	12800.00	20057	root		time:1m22.6s, loops:21, partial_worker:{wall_time:1m22.588974797s, concurrency:5, task_num:197, tot_wait:6m52.662424886s, tot_exec:267.820091ms, tot_time:6m52.943592332s, max:1m22.588959178s, p95:1m22.588959178s}, final_worker:{wall_time:1m22.603724606s, concurrency:5, task_num:25, tot_wait:6m52.942907128s, tot_exec:67.386483ms, tot_time:6m53.010307005s, max:1m22.603714135s, p95:1m22.603714135s}	group by:tpch50.supplier.s_name, funcs:count(1)->Column#72, funcs:firstrow(tpch50.supplier.s_name)->tpch50.supplier.s_name	17.3 MB	N/A
20:57:45 [2021-05-25T20:57:45.491Z]     └─IndexHashJoin_42	7828961.66	198698	root		time:1m22.6s, loops:198, inner:{total:2m21s, concurrency:5, task:146, construct:6.16s, fetch:1m57.6s, build:1.27s, join:17.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:57:45 [2021-05-25T20:57:45.491Z]       ├─IndexHashJoin_83(Build)	9786202.08	3542799	root		time:1m22.1s, loops:3463, inner:{total:2m29.7s, concurrency:5, task:152, construct:7.38s, fetch:2m4.2s, build:1.23s, join:18.1s}	semi join, inner:IndexLookUp_80, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey), ne(tpch50.lineitem.l_suppkey, tpch50.supplier.s_suppkey)	555.9 MB	N/A
20:57:45 [2021-05-25T20:57:45.491Z]       │ ├─IndexJoin_99(Build)	12232752.60	3675878	root		time:1m21.4s, loops:3595, inner:{total:2m9.3s, concurrency:5, task:305, construct:16.1s, fetch:1m51.3s, build:1.84s}, probe:5.1s	inner join, inner:TableReader_95, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.orders.o_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.orders.o_orderkey)	582.1 MB	N/A
20:57:45 [2021-05-25T20:57:45.491Z]       │ │ ├─HashJoin_107(Build)	12232752.60	7609895	root		time:1m20.9s, loops:7437, build_hash_table:{total:1.1s, fetch:1.1s, build:5.99ms}, probe:{concurrency:5, total:6m46.8s, max:1m21.4s, probe:1m2.5s, fetch:5m44.4s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.lineitem.l_suppkey)]	722.8 KB	0 Bytes
20:57:45 [2021-05-25T20:57:45.491Z]       │ │ │ ├─HashJoin_120(Build)	20000.00	20058	root		time:1.1s, loops:22, build_hash_table:{total:176.5µs, fetch:170.1µs, build:6.38µs}, probe:{concurrency:5, total:5.51s, max:1.1s, probe:59ms, fetch:5.45s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:57:45 [2021-05-25T20:57:45.491Z]       │ │ │ │ ├─TableReader_125(Build)	1.00	1	root		time:53.2µs, loops:2, cop_task: {num: 1, max: 1.47ms, proc_keys: 25, tot_proc: 1ms, rpc_num: 1, rpc_time: 1.45ms, copr_cache: disabled}	data:Selection_124	248 Bytes	N/A
20:57:45 [2021-05-25T20:57:45.491Z]       │ │ │ │ │ └─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:57:45 [2021-05-25T20:57:45.491Z]       │ │ │ │ │   └─TableFullScan_123	25.00	25	cop[tikv]	table:nation	tikv_task:{time:1ms, loops:1}	keep order:false	N/A	N/A
20:57:45 [2021-05-25T20:57:45.491Z]       │ │ │ │ └─TableReader_122(Probe)	500000.00	500000	root		time:1.09s, loops:490, cop_task: {num: 1, max: 1.09s, proc_keys: 500000, tot_proc: 1.06s, rpc_num: 1, rpc_time: 1.09s, copr_cache: disabled}	data:TableFullScan_121	20.0 MB	N/A
20:57:45 [2021-05-25T20:57:45.491Z]       │ │ │ │   └─TableFullScan_121	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:989ms, loops:493}, scan_detail: {total_process_keys: 500000, total_keys: 500001, rocksdb: {delete_skipped_count: 0, key_skipped_count: 999999, block: {cache_hit_count: 13, read_count: 1679, read_byte: 104.5 MB}}}	keep order:false	N/A	N/A
20:57:45 [2021-05-25T20:57:45.491Z]       │ │ │ └─TableReader_128(Probe)	240004648.80	189670348	root		time:1m8.4s, loops:184598, cop_task: {num: 761, max: 2.38s, min: 319.3ms, avg: 1.56s, p95: 2.05s, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 18m32.2s, tot_wait: 1m1.1s, rpc_num: 761, rpc_time: 19m47.8s, copr_cache: disabled}	data:Selection_127	109.4 MB	N/A
20:57:45 [2021-05-25T20:57:45.491Z]       │ │ │   └─Selection_127	240004648.80	189670348	cop[tikv]		tikv_task:{proc max:1.32s, min:303ms, 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: 10454, read_count: 1114194, read_byte: 23.6 GB}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:57:45 [2021-05-25T20:57:45.491Z]       │ │ │     └─TableFullScan_126	300005811.00	300005811	cop[tikv]	table:l1	tikv_task:{proc max:1.24s, min:280ms, p80:1.11s, p95:1.15s, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:57:45 [2021-05-25T20:57:45.491Z]       │ │ └─TableReader_95(Probe)	0.49	3496170	root		time:1m42.4s, loops:3875, cop_task: {num: 5283, max: 583.2ms, min: 1.14ms, avg: 183.1ms, p95: 342.7ms, max_proc_keys: 4078, p95_proc_keys: 1971, tot_proc: 11m25.7s, tot_wait: 3m49.2s, rpc_num: 5283, rpc_time: 16m7s, copr_cache: disabled}	data:Selection_94	N/A	N/A
20:57:45 [2021-05-25T20:57:45.491Z]       │ │   └─Selection_94	0.49	3496170	cop[tikv]		tikv_task:{proc max:171ms, min:0s, p80:71ms, p95:85ms, iters:30305, tasks:5283}, scan_detail: {total_process_keys: 7236264, total_keys: 7795523, rocksdb: {delete_skipped_count: 0, key_skipped_count: 1778423, block: {cache_hit_count: 54006594, read_count: 218242, read_byte: 4.21 GB}}}	eq(tpch50.orders.o_orderstatus, "F")	N/A	N/A
20:57:45 [2021-05-25T20:57:45.491Z]       │ │     └─TableRangeScan_93	1.00	7236264	cop[tikv]	table:orders	tikv_task:{proc max:170ms, min:0s, p80:71ms, p95:85ms, iters:30305, tasks:5283}	range: decided by [tpch50.lineitem.l_orderkey], keep order:false	N/A	N/A
20:57:45 [2021-05-25T20:57:45.491Z]       │ └─IndexLookUp_80(Probe)	4.05	17316442	root		time:1m58.8s, loops:17128, index_task: {total_time: 1m5.2s, fetch_handle: 56.3s, build: 3.09ms, wait: 8.84s}, table_task: {total_time: 8m31.6s, num: 1458, concurrency: 760}		19.1 KB	N/A
20:57:45 [2021-05-25T20:57:45.491Z]       │   ├─IndexRangeScan_78(Build)	4.05	17316442	cop[tikv]	table:l2, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:54.1s, loops:18632, cop_task: {num: 2995, max: 704.5ms, min: 477.3µs, avg: 189.2ms, p95: 368.8ms, max_proc_keys: 15582, p95_proc_keys: 8686, tot_proc: 7m4.4s, tot_wait: 1m55.5s, rpc_num: 2995, rpc_time: 9m26.7s, copr_cache: disabled}, tikv_task:{proc max:207ms, min:0s, p80:100ms, p95:114ms, iters:30162, tasks:2995}, scan_detail: {total_process_keys: 17316442, total_keys: 20812540, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17316442, block: {cache_hit_count: 24259927, read_count: 225686, read_byte: 2.00 GB}}}	range: decided by [eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey)], keep order:false	N/A	N/A
20:57:45 [2021-05-25T20:57:45.491Z]       │   └─TableRowIDScan_79(Probe)	4.05	17316442	cop[tikv]	table:l2	time:6m18.5s, loops:21004, cop_task: {num: 7788, max: 642.7ms, min: 1.1ms, avg: 177.9ms, p95: 354.7ms, max_proc_keys: 10448, p95_proc_keys: 4873, tot_proc: 16m34.8s, tot_wait: 5m29.8s, rpc_num: 7788, rpc_time: 23m4.9s, copr_cache: disabled}, tikv_task:{proc max:291ms, min:0s, p80:107ms, p95:142ms, iters:49900, tasks:7788}, scan_detail: {total_process_keys: 17316442, total_keys: 18290382, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5631480, block: {cache_hit_count: 99022491, read_count: 1106, read_byte: 388.3 MB}}}	keep order:false	N/A	N/A
20:57:45 [2021-05-25T20:57:45.491Z]       └─IndexLookUp_39(Probe)	4.05	12022788	root		time:1m52.7s, loops:11948, index_task: {total_time: 1m1.2s, fetch_handle: 51s, build: 3.1ms, wait: 10.2s}, table_task: {total_time: 8m7.9s, num: 1408, concurrency: 730}		224.8 KB	N/A
20:57:45 [2021-05-25T20:57:45.491Z]         ├─IndexRangeScan_36(Build)	5.06	17183396	cop[tikv]	table:l3, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:48.6s, loops:18408, cop_task: {num: 2796, max: 723.1ms, min: 1.11ms, avg: 169.9ms, p95: 360.6ms, max_proc_keys: 19256, p95_proc_keys: 13322, tot_proc: 5m51.8s, tot_wait: 1m38.9s, rpc_num: 2796, rpc_time: 7m54.9s, copr_cache: disabled}, tikv_task:{proc max:177ms, min:0s, p80:81ms, p95:125ms, iters:29142, tasks:2796}, scan_detail: {total_process_keys: 17183396, total_keys: 20546419, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17183396, block: {cache_hit_count: 23553967, read_count: 0, read_byte: 0 Bytes}}}	range: decided by [eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey)], keep order:false	N/A	N/A
20:57:45 [2021-05-25T20:57:45.491Z]         └─Selection_38(Probe)	4.05	12022788	cop[tikv]		time:6m14.2s, loops:13748, cop_task: {num: 10169, max: 700.1ms, min: 464.2µs, avg: 175.7ms, p95: 351.1ms, max_proc_keys: 8014, p95_proc_keys: 3973, tot_proc: 20m47.4s, tot_wait: 7m39.1s, rpc_num: 10169, rpc_time: 29m46.6s, copr_cache: disabled}, tikv_task:{proc max:200ms, min:0s, p80:78ms, p95:117ms, iters:60414, tasks:10169}, scan_detail: {total_process_keys: 17183396, total_keys: 18129218, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5524578, block: {cache_hit_count: 98294964, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:57:45 [2021-05-25T20:57:45.491Z]           └─TableRowIDScan_37	5.06	17183396	cop[tikv]	table:l3	tikv_task:{proc max:200ms, min:0s, p80:77ms, p95:116ms, iters:60414, tasks:10169}	keep order:false	N/A	N/A
20:57:45 [2021-05-25T20:57:45.491Z] + sync
20:57:45 [2021-05-25T20:57:45.491Z] + /usr/bin/echo 3
20:59:21 [2021-05-25T20:59:21.858Z] 
20:59:21 [2021-05-25T20:59:21.858Z] queries/21.sql
20:59:21 [2021-05-25T20:59:21.858Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:59:21 [2021-05-25T20:59:21.858Z] Projection_26	100.00	100	root		time:1m22.5s, loops:2, Concurrency:OFF	tpch50.supplier.s_name, Column#72	4.37 KB	N/A
20:59:21 [2021-05-25T20:59:21.858Z] └─TopN_29	100.00	100	root		time:1m22.5s, loops:2	Column#72:desc, tpch50.supplier.s_name, offset:0, count:100	58.3 KB	N/A
20:59:21 [2021-05-25T20:59:21.858Z]   └─HashAgg_34	12800.00	20057	root		time:1m22.5s, loops:21, partial_worker:{wall_time:1m22.479863953s, concurrency:5, task_num:196, tot_wait:6m52.107799308s, tot_exec:274.905824ms, tot_time:6m52.397534689s, max:1m22.479834716s, p95:1m22.479834716s}, final_worker:{wall_time:1m22.491833527s, concurrency:5, task_num:25, tot_wait:6m52.396195559s, tot_exec:62.415878ms, tot_time:6m52.458623803s, max:1m22.491813721s, p95:1m22.491813721s}	group by:tpch50.supplier.s_name, funcs:count(1)->Column#72, funcs:firstrow(tpch50.supplier.s_name)->tpch50.supplier.s_name	17.3 MB	N/A
20:59:21 [2021-05-25T20:59:21.858Z]     └─IndexHashJoin_42	7828961.66	198698	root		time:1m22.5s, loops:197, inner:{total:2m24.2s, concurrency:5, task:146, construct:6.49s, fetch:2m0.8s, build:1.22s, join:16.9s}	anti semi join, inner:IndexLookUp_39, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey)	641.0 MB	N/A
20:59:21 [2021-05-25T20:59:21.858Z]       ├─IndexHashJoin_83(Build)	9786202.08	3542799	root		time:1m21.9s, loops:3462, inner:{total:2m32.2s, concurrency:5, task:152, construct:7.53s, fetch:2m6.2s, build:1.24s, join:18.5s}	semi join, inner:IndexLookUp_80, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey), ne(tpch50.lineitem.l_suppkey, tpch50.supplier.s_suppkey)	555.9 MB	N/A
20:59:21 [2021-05-25T20:59:21.858Z]       │ ├─IndexJoin_99(Build)	12232752.60	3675878	root		time:1m21.3s, loops:3595, inner:{total:2m9.8s, concurrency:5, task:305, construct:16s, fetch:1m52s, build:1.77s}, probe:5.23s	inner join, inner:TableReader_95, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.orders.o_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.orders.o_orderkey)	582.0 MB	N/A
20:59:21 [2021-05-25T20:59:21.858Z]       │ │ ├─HashJoin_107(Build)	12232752.60	7609895	root		time:1m20.7s, loops:7436, build_hash_table:{total:1.04s, fetch:1.03s, build:7.95ms}, probe:{concurrency:5, total:6m46s, max:1m21.2s, probe:1m2.5s, fetch:5m43.5s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.lineitem.l_suppkey)]	747.3 KB	0 Bytes
20:59:21 [2021-05-25T20:59:21.858Z]       │ │ │ ├─HashJoin_120(Build)	20000.00	20058	root		time:1.03s, loops:23, build_hash_table:{total:161.2µs, fetch:155.7µs, build:5.49µs}, probe:{concurrency:5, total:5.18s, max:1.04s, probe:99ms, fetch:5.08s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:59:21 [2021-05-25T20:59:21.858Z]       │ │ │ │ ├─TableReader_125(Build)	1.00	1	root		time:44.4µs, loops:2, cop_task: {num: 1, max: 1.32ms, proc_keys: 25, rpc_num: 1, rpc_time: 1.26ms, copr_cache: disabled}	data:Selection_124	244 Bytes	N/A
20:59:21 [2021-05-25T20:59:21.858Z]       │ │ │ │ │ └─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:59:21 [2021-05-25T20:59:21.858Z]       │ │ │ │ │   └─TableFullScan_123	25.00	25	cop[tikv]	table:nation	tikv_task:{time:0s, loops:1}	keep order:false	N/A	N/A
20:59:21 [2021-05-25T20:59:21.858Z]       │ │ │ │ └─TableReader_122(Probe)	500000.00	500000	root		time:1.02s, loops:490, cop_task: {num: 1, max: 1.02s, proc_keys: 500000, tot_proc: 977ms, tot_wait: 1ms, rpc_num: 1, rpc_time: 1.02s, copr_cache: disabled}	data:TableFullScan_121	20.0 MB	N/A
20:59:21 [2021-05-25T20:59:21.858Z]       │ │ │ │   └─TableFullScan_121	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:912ms, loops:493}, scan_detail: {total_process_keys: 500000, total_keys: 500001, rocksdb: {delete_skipped_count: 0, key_skipped_count: 999999, block: {cache_hit_count: 13, read_count: 1679, read_byte: 104.5 MB}}}	keep order:false	N/A	N/A
20:59:21 [2021-05-25T20:59:21.858Z]       │ │ │ └─TableReader_128(Probe)	240004648.80	189670348	root		time:1m8.4s, loops:184597, cop_task: {num: 761, max: 2.85s, min: 340.8ms, avg: 1.56s, p95: 2.01s, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 18m30.2s, tot_wait: 1m1.4s, rpc_num: 761, rpc_time: 19m46.3s, copr_cache: disabled}	data:Selection_127	109.4 MB	N/A
20:59:21 [2021-05-25T20:59:21.858Z]       │ │ │   └─Selection_127	240004648.80	189670348	cop[tikv]		tikv_task:{proc max:1.34s, min:326ms, 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: 10454, read_count: 1114194, read_byte: 23.6 GB}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:59:21 [2021-05-25T20:59:21.858Z]       │ │ │     └─TableFullScan_126	300005811.00	300005811	cop[tikv]	table:l1	tikv_task:{proc max:1.26s, min:309ms, p80:1.11s, p95:1.15s, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:59:21 [2021-05-25T20:59:21.858Z]       │ │ └─TableReader_95(Probe)	0.49	3496206	root		time:1m43.4s, loops:3875, cop_task: {num: 5259, max: 559.3ms, min: 789.1µs, avg: 185.1ms, p95: 350.7ms, max_proc_keys: 3466, p95_proc_keys: 1959, tot_proc: 11m31.8s, tot_wait: 3m51.1s, rpc_num: 5259, rpc_time: 16m13.1s, copr_cache: disabled}	data:Selection_94	N/A	N/A
20:59:21 [2021-05-25T20:59:21.858Z]       │ │   └─Selection_94	0.49	3496206	cop[tikv]		tikv_task:{proc max:174ms, min:0s, p80:71ms, p95:84ms, iters:30177, tasks:5259}, scan_detail: {total_process_keys: 7236301, total_keys: 7795490, rocksdb: {delete_skipped_count: 0, key_skipped_count: 1778169, block: {cache_hit_count: 54006753, read_count: 218211, read_byte: 4.21 GB}}}	eq(tpch50.orders.o_orderstatus, "F")	N/A	N/A
20:59:21 [2021-05-25T20:59:21.858Z]       │ │     └─TableRangeScan_93	1.00	7236301	cop[tikv]	table:orders	tikv_task:{proc max:173ms, min:0s, p80:71ms, p95:84ms, iters:30177, tasks:5259}	range: decided by [tpch50.lineitem.l_orderkey], keep order:false	N/A	N/A
20:59:21 [2021-05-25T20:59:21.858Z]       │ └─IndexLookUp_80(Probe)	4.05	17316442	root		time:2m0.6s, loops:17131, index_task: {total_time: 1m6.5s, fetch_handle: 57.7s, build: 8.4ms, wait: 8.73s}, table_task: {total_time: 8m39.4s, num: 1458, concurrency: 760}		19.2 KB	N/A
20:59:21 [2021-05-25T20:59:21.858Z]       │   ├─IndexRangeScan_78(Build)	4.05	17316442	cop[tikv]	table:l2, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:55.4s, loops:18647, cop_task: {num: 2998, max: 720.9ms, min: 485.9µs, avg: 190.4ms, p95: 388.5ms, max_proc_keys: 12931, p95_proc_keys: 8747, tot_proc: 7m9s, tot_wait: 1m56.6s, rpc_num: 2998, rpc_time: 9m30.8s, copr_cache: disabled}, tikv_task:{proc max:184ms, min:0s, p80:100ms, p95:115ms, iters:30182, tasks:2998}, scan_detail: {total_process_keys: 17316442, total_keys: 20812543, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17316442, block: {cache_hit_count: 24259954, read_count: 225680, read_byte: 2.00 GB}}}	range: decided by [eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey)], keep order:false	N/A	N/A
20:59:21 [2021-05-25T20:59:21.858Z]       │   └─TableRowIDScan_79(Probe)	4.05	17316442	cop[tikv]	table:l2	time:6m26.6s, loops:21014, cop_task: {num: 7755, max: 587.4ms, min: 453.5µs, avg: 183.2ms, p95: 368.9ms, max_proc_keys: 12821, p95_proc_keys: 4842, tot_proc: 16m58s, tot_wait: 5m44.6s, rpc_num: 7755, rpc_time: 23m40.6s, copr_cache: disabled}, tikv_task:{proc max:264ms, min:0s, p80:107ms, p95:142ms, iters:49899, tasks:7755}, scan_detail: {total_process_keys: 17316442, total_keys: 18289240, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5628946, block: {cache_hit_count: 99017525, read_count: 1112, read_byte: 389.4 MB}}}	keep order:false	N/A	N/A
20:59:21 [2021-05-25T20:59:21.858Z]       └─IndexLookUp_39(Probe)	4.05	12022795	root		time:1m55.8s, loops:11948, index_task: {total_time: 1m2.1s, fetch_handle: 51.4s, build: 3.1ms, wait: 10.7s}, table_task: {total_time: 8m18.8s, num: 1408, concurrency: 730}		215.7 KB	N/A
20:59:21 [2021-05-25T20:59:21.858Z]         ├─IndexRangeScan_36(Build)	5.06	17183370	cop[tikv]	table:l3, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:49.1s, loops:18352, cop_task: {num: 2773, max: 853.5ms, min: 659.6µs, avg: 176.5ms, p95: 378.4ms, max_proc_keys: 18854, p95_proc_keys: 13468, tot_proc: 6m3.9s, tot_wait: 1m40.2s, rpc_num: 2773, rpc_time: 8m9.5s, copr_cache: disabled}, tikv_task:{proc max:182ms, min:0s, p80:82ms, p95:124ms, iters:29067, tasks:2773}, scan_detail: {total_process_keys: 17183370, total_keys: 20546394, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17183370, block: {cache_hit_count: 23553974, 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:59:21 [2021-05-25T20:59:21.858Z]         └─Selection_38(Probe)	4.05	12022795	cop[tikv]		time:6m23.2s, loops:13792, cop_task: {num: 10164, max: 751ms, min: 513.8µs, avg: 179.1ms, p95: 361ms, max_proc_keys: 7604, p95_proc_keys: 4003, tot_proc: 21m12.8s, tot_wait: 7m47.5s, rpc_num: 10164, rpc_time: 30m20.2s, copr_cache: disabled}, tikv_task:{proc max:225ms, min:0s, p80:79ms, p95:118ms, iters:60390, tasks:10164}, scan_detail: {total_process_keys: 17183370, total_keys: 18129865, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5529797, block: {cache_hit_count: 98285844, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:59:21 [2021-05-25T20:59:21.858Z]           └─TableRowIDScan_37	5.06	17183370	cop[tikv]	table:l3	tikv_task:{proc max:221ms, min:0s, p80:78ms, p95:117ms, iters:60390, tasks:10164}	keep order:false	N/A	N/A
20:59:21 [2021-05-25T20:59:21.858Z] + sync
20:59:21 [2021-05-25T20:59:21.858Z] + /usr/bin/echo 3
21:00:43 [2021-05-25T21:00:43.236Z] 
21:00:43 [2021-05-25T21:00:43.236Z] queries/21.sql
21:00:43 [2021-05-25T21:00:43.236Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
21:00:43 [2021-05-25T21:00:43.236Z] Projection_26	100.00	100	root		time:1m22.5s, loops:2, Concurrency:OFF	tpch50.supplier.s_name, Column#72	4.37 KB	N/A
21:00:43 [2021-05-25T21:00:43.236Z] └─TopN_29	100.00	100	root		time:1m22.5s, loops:2	Column#72:desc, tpch50.supplier.s_name, offset:0, count:100	58.3 KB	N/A
21:00:43 [2021-05-25T21:00:43.236Z]   └─HashAgg_34	12800.00	20057	root		time:1m22.5s, loops:21, partial_worker:{wall_time:1m22.444456388s, concurrency:5, task_num:197, tot_wait:6m51.953239846s, tot_exec:253.498261ms, tot_time:6m52.220004388s, max:1m22.444404895s, p95:1m22.444404895s}, final_worker:{wall_time:1m22.45698761s, concurrency:5, task_num:25, tot_wait:6m52.218925467s, tot_exec:64.982004ms, tot_time:6m52.283920102s, max:1m22.456950893s, p95:1m22.456950893s}	group by:tpch50.supplier.s_name, funcs:count(1)->Column#72, funcs:firstrow(tpch50.supplier.s_name)->tpch50.supplier.s_name	17.3 MB	N/A
21:00:43 [2021-05-25T21:00:43.236Z]     └─IndexHashJoin_42	7828961.66	198698	root		time:1m22.4s, loops:198, inner:{total:2m22s, concurrency:5, task:147, construct:6.12s, fetch:1m58.7s, build:1.17s, join:17.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
21:00:43 [2021-05-25T21:00:43.236Z]       ├─IndexHashJoin_83(Build)	9786202.08	3542799	root		time:1m21.9s, loops:3464, inner:{total:2m30.9s, concurrency:5, task:152, construct:7.69s, fetch:2m5.2s, 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
21:00:43 [2021-05-25T21:00:43.236Z]       │ ├─IndexJoin_99(Build)	12232752.60	3675878	root		time:1m21.4s, loops:3595, inner:{total:2m9.8s, concurrency:5, task:305, construct:16s, fetch:1m52s, build:1.82s}, probe:5.17s	inner join, inner:TableReader_95, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.orders.o_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.orders.o_orderkey)	581.9 MB	N/A
21:00:43 [2021-05-25T21:00:43.236Z]       │ │ ├─HashJoin_107(Build)	12232752.60	7609895	root		time:1m20.7s, loops:7436, build_hash_table:{total:1.06s, fetch:1.06s, build:6.12ms}, probe:{concurrency:5, total:6m46.5s, max:1m21.3s, probe:1m2.5s, fetch:5m43.9s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.lineitem.l_suppkey)]	752.0 KB	0 Bytes
21:00:43 [2021-05-25T21:00:43.236Z]       │ │ │ ├─HashJoin_120(Build)	20000.00	20058	root		time:1.06s, loops:23, build_hash_table:{total:231.9µs, fetch:223.5µs, build:8.32µs}, probe:{concurrency:5, total:5.3s, max:1.06s, probe:66.6ms, fetch:5.24s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
21:00:43 [2021-05-25T21:00:43.236Z]       │ │ │ │ ├─TableReader_125(Build)	1.00	1	root		time:47µs, loops:2, cop_task: {num: 1, max: 1.26ms, proc_keys: 25, tot_proc: 1ms, rpc_num: 1, rpc_time: 1.21ms, copr_cache: disabled}	data:Selection_124	248 Bytes	N/A
21:00:43 [2021-05-25T21:00:43.236Z]       │ │ │ │ │ └─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
21:00:43 [2021-05-25T21:00:43.236Z]       │ │ │ │ │   └─TableFullScan_123	25.00	25	cop[tikv]	table:nation	tikv_task:{time:1ms, loops:1}	keep order:false	N/A	N/A
21:00:43 [2021-05-25T21:00:43.236Z]       │ │ │ │ └─TableReader_122(Probe)	500000.00	500000	root		time:1.05s, loops:490, cop_task: {num: 1, max: 1.05s, proc_keys: 500000, tot_proc: 1.01s, rpc_num: 1, rpc_time: 1.05s, copr_cache: disabled}	data:TableFullScan_121	20.0 MB	N/A
21:00:43 [2021-05-25T21:00:43.236Z]       │ │ │ │   └─TableFullScan_121	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:948ms, 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
21:00:43 [2021-05-25T21:00:43.236Z]       │ │ │ └─TableReader_128(Probe)	240004648.80	189670348	root		time:1m8.5s, loops:184596, cop_task: {num: 761, max: 2.92s, min: 322.3ms, avg: 1.56s, p95: 2.02s, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 18m36.2s, tot_wait: 56.9s, rpc_num: 761, rpc_time: 19m48.1s, copr_cache: disabled}	data:Selection_127	109.4 MB	N/A
21:00:43 [2021-05-25T21:00:43.236Z]       │ │ │   └─Selection_127	240004648.80	189670348	cop[tikv]		tikv_task:{proc max:1.35s, min:304ms, 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: 10451, read_count: 1114197, read_byte: 23.6 GB}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
21:00:43 [2021-05-25T21:00:43.236Z]       │ │ │     └─TableFullScan_126	300005811.00	300005811	cop[tikv]	table:l1	tikv_task:{proc max:1.27s, min:297ms, p80:1.11s, p95:1.16s, iters:296606, tasks:761}	keep order:false	N/A	N/A
21:00:43 [2021-05-25T21:00:43.236Z]       │ │ └─TableReader_95(Probe)	0.49	3496191	root		time:1m43.2s, loops:3875, cop_task: {num: 5242, max: 533.4ms, min: 1.32ms, avg: 183.3ms, p95: 342.7ms, max_proc_keys: 3518, p95_proc_keys: 1963, tot_proc: 11m31.3s, tot_wait: 3m40.5s, rpc_num: 5242, rpc_time: 16m0.8s, copr_cache: disabled}	data:Selection_94	N/A	N/A
21:00:43 [2021-05-25T21:00:43.236Z]       │ │   └─Selection_94	0.49	3496191	cop[tikv]		tikv_task:{proc max:149ms, min:0s, p80:71ms, p95:85ms, iters:30209, tasks:5242}, scan_detail: {total_process_keys: 7236294, total_keys: 7795473, rocksdb: {delete_skipped_count: 0, key_skipped_count: 1778133, block: {cache_hit_count: 54006730, read_count: 218188, read_byte: 4.21 GB}}}	eq(tpch50.orders.o_orderstatus, "F")	N/A	N/A
21:00:43 [2021-05-25T21:00:43.236Z]       │ │     └─TableRangeScan_93	1.00	7236294	cop[tikv]	table:orders	tikv_task:{proc max:149ms, min:0s, p80:70ms, p95:84ms, iters:30209, tasks:5242}	range: decided by [tpch50.lineitem.l_orderkey], keep order:false	N/A	N/A
21:00:43 [2021-05-25T21:00:43.237Z]       │ └─IndexLookUp_80(Probe)	4.05	17316438	root		time:1m59.7s, loops:17128, index_task: {total_time: 1m5.5s, fetch_handle: 57.1s, build: 3.59ms, wait: 8.37s}, table_task: {total_time: 8m36.1s, num: 1458, concurrency: 760}		18.9 KB	N/A
21:00:43 [2021-05-25T21:00:43.237Z]       │   ├─IndexRangeScan_78(Build)	4.05	17316438	cop[tikv]	table:l2, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:54.8s, loops:18636, cop_task: {num: 2980, max: 667.2ms, min: 427.4µs, avg: 192.8ms, p95: 384.5ms, max_proc_keys: 12531, p95_proc_keys: 8756, tot_proc: 7m11.9s, tot_wait: 1m57.9s, rpc_num: 2980, rpc_time: 9m34.4s, copr_cache: disabled}, tikv_task:{proc max:164ms, min:0s, p80:100ms, p95:117ms, iters:30114, tasks:2980}, scan_detail: {total_process_keys: 17316438, total_keys: 20812539, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17316438, block: {cache_hit_count: 24259951, read_count: 225684, read_byte: 2.00 GB}}}	range: decided by [eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey)], keep order:false	N/A	N/A
21:00:43 [2021-05-25T21:00:43.237Z]       │   └─TableRowIDScan_79(Probe)	4.05	17316438	cop[tikv]	table:l2	time:6m20.6s, loops:21039, cop_task: {num: 7804, max: 625ms, min: 482.8µs, avg: 179.7ms, p95: 361.8ms, max_proc_keys: 12488, p95_proc_keys: 4864, tot_proc: 16m48.5s, tot_wait: 5m33s, rpc_num: 7804, rpc_time: 23m22s, copr_cache: disabled}, tikv_task:{proc max:270ms, min:0s, p80:106ms, p95:141ms, iters:49942, tasks:7804}, scan_detail: {total_process_keys: 17316438, total_keys: 18290119, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5633245, block: {cache_hit_count: 99013065, read_count: 1111, read_byte: 400.2 MB}}}	keep order:false	N/A	N/A
21:00:43 [2021-05-25T21:00:43.237Z]       └─IndexLookUp_39(Probe)	4.05	12022750	root		time:1m53.9s, loops:11949, index_task: {total_time: 1m1.7s, fetch_handle: 51.5s, build: 3.22ms, wait: 10.2s}, table_task: {total_time: 8m8.3s, num: 1410, concurrency: 735}		216.8 KB	N/A
21:00:43 [2021-05-25T21:00:43.237Z]         ├─IndexRangeScan_36(Build)	5.06	17183344	cop[tikv]	table:l3, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:49.2s, loops:18384, cop_task: {num: 2778, max: 807.2ms, min: 520.1µs, avg: 173.5ms, p95: 372.9ms, max_proc_keys: 17249, p95_proc_keys: 13850, tot_proc: 5m58s, tot_wait: 1m39.3s, rpc_num: 2778, rpc_time: 8m1.8s, copr_cache: disabled}, tikv_task:{proc max:178ms, min:0s, p80:82ms, p95:124ms, iters:29059, tasks:2778}, scan_detail: {total_process_keys: 17183344, total_keys: 20546364, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17183344, block: {cache_hit_count: 23553947, 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
21:00:43 [2021-05-25T21:00:43.237Z]         └─Selection_38(Probe)	4.05	12022750	cop[tikv]		time:6m11.5s, loops:13769, cop_task: {num: 10171, max: 600ms, min: 458.8µs, avg: 174.1ms, p95: 347.5ms, max_proc_keys: 7224, p95_proc_keys: 3974, tot_proc: 20m36.9s, tot_wait: 7m34.7s, rpc_num: 10171, rpc_time: 29m30s, copr_cache: disabled}, tikv_task:{proc max:208ms, min:0s, p80:78ms, p95:118ms, iters:60404, tasks:10171}, scan_detail: {total_process_keys: 17183344, total_keys: 18129343, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5528331, block: {cache_hit_count: 98285763, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
21:00:43 [2021-05-25T21:00:43.237Z]           └─TableRowIDScan_37	5.06	17183344	cop[tikv]	table:l3	tikv_task:{proc max:207ms, min:0s, p80:77ms, p95:117ms, iters:60404, tasks:10171}	keep order:false	N/A	N/A
21:00:43 [2021-05-25T21:00:43.237Z] + tiup cluster stop benchbot -y
21:00:43 [2021-05-25T21:00:43.237Z] Starting component `cluster`: /home/tidb/.tiup/components/cluster/v1.4.3/tiup-cluster stop benchbot -y
21:00:53 [2021-05-25T21:00:53.172Z] + rm -rf '/data1/tidb-deploy/*/log/*'
21:00:53 [2021-05-25T21:00:53.172Z] + rm -rf /data1/jenkins/deploy/data/tikv-20160
21:00:57 [2021-05-25T21:00:57.333Z] + rm -rf /data1/jenkins/deploy/data/pd-2379
21:00:57 [2021-05-25T21:00:57.333Z] + rm -rf /data1/jenkins/restore_data/tpch50/data/last_tikv.toml
21:00:57 [2021-05-25T21:00:57.333Z] + cp -R /data1/jenkins/restore_data/tpch50/data /data1/jenkins/deploy/data/tikv-20160
21:02:48 [2021-05-25T21:02:48.910Z] + cp -R /data1/jenkins/restore_data/tpch50/data.pd /data1/jenkins/deploy/data/pd-2379
21:02:48 [2021-05-25T21:02:48.910Z] + '[' -n '' ']'
21:02:48 [2021-05-25T21:02:48.910Z] + tiup cluster start benchbot --wait-timeout=300
21:02:48 [2021-05-25T21:02:48.910Z] Starting component `cluster`: /home/tidb/.tiup/components/cluster/v1.4.3/tiup-cluster start benchbot --wait-timeout=300
21:03:15 [2021-05-25T21:03:15.486Z] + sync
21:03:15 [2021-05-25T21:03:15.486Z] + /usr/bin/echo 3
21:03:54 [2021-05-25T21:03:54.163Z] + sync
21:03:54 [2021-05-25T21:03:54.163Z] + /usr/bin/echo 3
21:04:20 [2021-05-25T21:04:20.650Z] + sync
21:04:20 [2021-05-25T21:04:20.650Z] + /usr/bin/echo 3
21:04:47 [2021-05-25T21:04:47.136Z] 
21:04:47 [2021-05-25T21:04:47.136Z] queries/22.sql
21:04:47 [2021-05-25T21:04:47.136Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
21:04:47 [2021-05-25T21:04:47.136Z] Sort_39	1600000.00	4	root		time:25.9s, loops:2	Column#27	9.48 KB	0 Bytes
21:04:47 [2021-05-25T21:04:47.136Z] └─Projection_41	1600000.00	4	root		time:25.9s, loops:5, Concurrency:5	Column#27, Column#28, Column#29	23.7 KB	N/A
21:04:47 [2021-05-25T21:04:47.136Z]   └─HashAgg_42	1600000.00	4	root		time:25.9s, loops:5, partial_worker:{wall_time:25.890312585s, concurrency:5, task_num:181, tot_wait:2m9.397120965s, tot_exec:53.82336ms, tot_time:2m9.45108245s, max:25.890246374s, p95:25.890246374s}, final_worker:{wall_time:25.890332821s, concurrency:5, task_num:20, tot_wait:2m9.451133646s, tot_exec:207.042µs, tot_time:2m9.451350227s, max:25.890289542s, p95:25.890289542s}	group by:Column#33, funcs:count(1)->Column#28, funcs:sum(Column#31)->Column#29, funcs:firstrow(Column#32)->Column#27	857.7 KB	N/A
21:04:47 [2021-05-25T21:04:47.136Z]     └─Projection_51	1600000.00	181704	root		time:25.9s, loops:182, Concurrency:5	tpch50.customer.c_acctbal, substring(tpch50.customer.c_phone, 1, 2)->Column#32, substring(tpch50.customer.c_phone, 1, 2)->Column#33	703.6 KB	N/A
21:04:47 [2021-05-25T21:04:47.136Z]       └─HashJoin_43	1600000.00	181704	root		time:25.9s, loops:182, build_hash_table:{total:24.4s, fetch:1.09s, build:23.3s}, probe:{concurrency:5, total:2m9.4s, max:25.9s, probe:6.12s, fetch:2m3.3s}	anti semi join, equal:[eq(tpch50.customer.c_custkey, tpch50.orders.o_custkey)]	590.2 MB	0 Bytes
21:04:47 [2021-05-25T21:04:47.136Z]         ├─TableReader_49(Build)	75000000.00	75000000	root		time:1.1s, loops:73364, cop_task: {num: 153, max: 1.06s, min: 277.4ms, avg: 615.7ms, p95: 949.5ms, max_proc_keys: 723875, p95_proc_keys: 553332, tot_proc: 1m33.4s, tot_wait: 46ms, rpc_num: 153, rpc_time: 1m34.2s, copr_cache: disabled}	data:TableFullScan_48	54.1 MB	N/A
21:04:47 [2021-05-25T21:04:47.136Z]         │ └─TableFullScan_48	75000000.00	75000000	cop[tikv]	table:orders	tikv_task:{proc max:1.02s, min:268ms, p80:621ms, p95:920ms, 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: 3020, read_count: 219937, read_byte: 4.30 GB}}}	keep order:false	N/A	N/A
21:04:47 [2021-05-25T21:04:47.136Z]         └─Selection_47(Probe)	2000000.00	545246	root		time:1.52s, loops:534	in(substring(tpch50.customer.c_phone, 1, 2), "20", "40", "22", "30", "39", "42", "21")	94.6 KB	N/A
21:04:47 [2021-05-25T21:04:47.136Z]           └─TableReader_46	2000000.00	3407619	root		time:594.1ms, loops:3319, cop_task: {num: 18, max: 1.24s, min: 416.7ms, avg: 876.8ms, p95: 1.24s, max_proc_keys: 582617, p95_proc_keys: 582617, tot_proc: 15.3s, tot_wait: 1ms, rpc_num: 18, rpc_time: 15.8s, copr_cache: disabled}	data:Selection_45	192.5 MB	N/A
21:04:47 [2021-05-25T21:04:47.136Z]             └─Selection_45	2000000.00	3407619	cop[tikv]		tikv_task:{proc max:1.15s, min:382ms, p80:1.05s, p95:1.15s, iters:7404, tasks:18}, scan_detail: {total_process_keys: 7500000, total_keys: 7500018, rocksdb: {delete_skipped_count: 0, key_skipped_count: 14999982, block: {cache_hit_count: 28451, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.customer.c_acctbal, 5000.602894)	N/A	N/A
21:04:47 [2021-05-25T21:04:47.136Z]               └─TableFullScan_44	7500000.00	7500000	cop[tikv]	table:customer	tikv_task:{proc max:1.06s, min:348ms, p80:959ms, p95:1.06s, iters:7404, tasks:18}	keep order:false	N/A	N/A
21:04:47 [2021-05-25T21:04:47.136Z] 
21:04:47 [2021-05-25T21:04:47.136Z] queries/22.sql
21:04:47 [2021-05-25T21:04:47.136Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
21:04:47 [2021-05-25T21:04:47.136Z] Sort_39	2186432.06	4	root		time:25.9s, loops:2	Column#27	9.48 KB	0 Bytes
21:04:47 [2021-05-25T21:04:47.136Z] └─Projection_41	2186432.06	4	root		time:25.9s, loops:5, Concurrency:5	Column#27, Column#28, Column#29	23.7 KB	N/A
21:04:47 [2021-05-25T21:04:47.136Z]   └─HashAgg_42	2186432.06	4	root		time:25.9s, loops:5, partial_worker:{wall_time:25.91845179s, concurrency:5, task_num:179, tot_wait:2m9.52961538s, tot_exec:60.746816ms, tot_time:2m9.590477191s, max:25.918287019s, p95:25.918287019s}, final_worker:{wall_time:25.91846793s, concurrency:5, task_num:20, tot_wait:2m9.591678215s, tot_exec:295.068µs, tot_time:2m9.591999426s, max:25.918425316s, p95:25.918425316s}	group by:Column#33, funcs:count(1)->Column#28, funcs:sum(Column#31)->Column#29, funcs:firstrow(Column#32)->Column#27	857.7 KB	N/A
21:04:47 [2021-05-25T21:04:47.136Z]     └─Projection_51	2186432.06	181704	root		time:25.9s, loops:180, Concurrency:5	tpch50.customer.c_acctbal, substring(tpch50.customer.c_phone, 1, 2)->Column#32, substring(tpch50.customer.c_phone, 1, 2)->Column#33	703.6 KB	N/A
21:04:47 [2021-05-25T21:04:47.136Z]       └─HashJoin_43	2186432.06	181704	root		time:25.9s, loops:180, build_hash_table:{total:24.4s, fetch:1.05s, build:23.3s}, probe:{concurrency:5, total:2m9.6s, max:25.9s, probe:5.95s, fetch:2m3.6s}	anti semi join, equal:[eq(tpch50.customer.c_custkey, tpch50.orders.o_custkey)]	590.2 MB	0 Bytes
21:04:47 [2021-05-25T21:04:47.136Z]         ├─TableReader_49(Build)	75000000.00	75000000	root		time:1.06s, loops:73364, cop_task: {num: 153, max: 1.27s, min: 241.1ms, avg: 525.9ms, p95: 981.4ms, max_proc_keys: 723875, p95_proc_keys: 553332, tot_proc: 1m19.7s, tot_wait: 22ms, rpc_num: 153, rpc_time: 1m20.5s, copr_cache: disabled}	data:TableFullScan_48	57.8 MB	N/A
21:04:47 [2021-05-25T21:04:47.136Z]         │ └─TableFullScan_48	75000000.00	75000000	cop[tikv]	table:orders	tikv_task:{proc max:1.24s, min:227ms, p80:511ms, p95:953ms, iters:73975, tasks:153}, scan_detail: {total_process_keys: 75000000, total_keys: 75000153, rocksdb: {delete_skipped_count: 0, key_skipped_count: 149999847, block: {cache_hit_count: 220923, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
21:04:47 [2021-05-25T21:04:47.136Z]         └─Selection_47(Probe)	2733040.07	545246	root		time:1.72s, loops:534	in(substring(tpch50.customer.c_phone, 1, 2), "20", "40", "22", "30", "39", "42", "21")	94.6 KB	N/A
21:04:47 [2021-05-25T21:04:47.136Z]           └─TableReader_46	2733040.07	3407619	root		time:713ms, loops:3319, cop_task: {num: 18, max: 1.37s, min: 500.2ms, avg: 961.8ms, p95: 1.37s, max_proc_keys: 582617, p95_proc_keys: 582617, tot_proc: 16.8s, tot_wait: 1ms, rpc_num: 18, rpc_time: 17.3s, copr_cache: disabled}	data:Selection_45	192.5 MB	N/A
21:04:47 [2021-05-25T21:04:47.137Z]             └─Selection_45	2733040.07	3407619	cop[tikv]		tikv_task:{proc max:1.28s, min:460ms, p80:1.03s, p95:1.28s, iters:7404, tasks:18}, scan_detail: {total_process_keys: 7500000, total_keys: 7500018, rocksdb: {delete_skipped_count: 0, key_skipped_count: 14999982, block: {cache_hit_count: 28451, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.customer.c_acctbal, 5000.602894)	N/A	N/A
21:04:47 [2021-05-25T21:04:47.137Z]               └─TableFullScan_44	7500000.00	7500000	cop[tikv]	table:customer	tikv_task:{proc max:1.14s, min:428ms, p80:959ms, p95:1.14s, iters:7404, tasks:18}	keep order:false	N/A	N/A
21:04:47 [2021-05-25T21:04:47.137Z] 
21:04:47 [2021-05-25T21:04:47.137Z] queries/22.sql
21:04:47 [2021-05-25T21:04:47.137Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
21:04:47 [2021-05-25T21:04:47.137Z] Sort_39	2186432.06	4	root		time:25.2s, loops:2	Column#27	9.48 KB	0 Bytes
21:04:47 [2021-05-25T21:04:47.137Z] └─Projection_41	2186432.06	4	root		time:25.2s, loops:5, Concurrency:5	Column#27, Column#28, Column#29	23.7 KB	N/A
21:04:47 [2021-05-25T21:04:47.137Z]   └─HashAgg_42	2186432.06	4	root		time:25.2s, loops:5, partial_worker:{wall_time:25.233610397s, concurrency:5, task_num:180, tot_wait:2m6.108813462s, tot_exec:57.570686ms, tot_time:2m6.166515358s, max:25.233546431s, p95:25.233546431s}, final_worker:{wall_time:25.233665437s, concurrency:5, task_num:20, tot_wait:2m6.167509469s, tot_exec:573.03µs, tot_time:2m6.168090528s, max:25.233625608s, p95:25.233625608s}	group by:Column#33, funcs:count(1)->Column#28, funcs:sum(Column#31)->Column#29, funcs:firstrow(Column#32)->Column#27	857.7 KB	N/A
21:04:47 [2021-05-25T21:04:47.137Z]     └─Projection_51	2186432.06	181704	root		time:25.2s, loops:181, Concurrency:5	tpch50.customer.c_acctbal, substring(tpch50.customer.c_phone, 1, 2)->Column#32, substring(tpch50.customer.c_phone, 1, 2)->Column#33	703.6 KB	N/A
21:04:47 [2021-05-25T21:04:47.137Z]       └─HashJoin_43	2186432.06	181704	root		time:25.2s, loops:181, build_hash_table:{total:23.6s, fetch:920.1ms, build:22.7s}, probe:{concurrency:5, total:2m6.1s, max:25.2s, probe:6.55s, fetch:1m59.6s}	anti semi join, equal:[eq(tpch50.customer.c_custkey, tpch50.orders.o_custkey)]	590.2 MB	0 Bytes
21:04:47 [2021-05-25T21:04:47.137Z]         ├─TableReader_49(Build)	75000000.00	75000000	root		time:936ms, loops:73364, cop_task: {num: 153, max: 946.1ms, min: 226.4ms, avg: 498.5ms, p95: 809.1ms, max_proc_keys: 723875, p95_proc_keys: 553332, tot_proc: 1m15.6s, tot_wait: 30ms, rpc_num: 153, rpc_time: 1m16.3s, copr_cache: disabled}	data:TableFullScan_48	57.8 MB	N/A
21:04:47 [2021-05-25T21:04:47.137Z]         │ └─TableFullScan_48	75000000.00	75000000	cop[tikv]	table:orders	tikv_task:{proc max:916ms, min:213ms, p80:501ms, p95:783ms, iters:73975, tasks:153}, scan_detail: {total_process_keys: 75000000, total_keys: 75000153, rocksdb: {delete_skipped_count: 0, key_skipped_count: 149999847, block: {cache_hit_count: 220923, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
21:04:47 [2021-05-25T21:04:47.137Z]         └─Selection_47(Probe)	2733040.07	545246	root		time:1.64s, loops:534	in(substring(tpch50.customer.c_phone, 1, 2), "20", "40", "22", "30", "39", "42", "21")	94.6 KB	N/A
21:04:47 [2021-05-25T21:04:47.137Z]           └─TableReader_46	2733040.07	3407619	root		time:706.5ms, loops:3319, cop_task: {num: 18, max: 1.19s, min: 495.2ms, avg: 846.6ms, p95: 1.19s, max_proc_keys: 582617, p95_proc_keys: 582617, tot_proc: 14.8s, tot_wait: 2ms, rpc_num: 18, rpc_time: 15.2s, copr_cache: disabled}	data:Selection_45	192.5 MB	N/A
21:04:47 [2021-05-25T21:04:47.137Z]             └─Selection_45	2733040.07	3407619	cop[tikv]		tikv_task:{proc max:1.1s, min:461ms, p80:925ms, p95:1.1s, iters:7404, tasks:18}, scan_detail: {total_process_keys: 7500000, total_keys: 7500018, rocksdb: {delete_skipped_count: 0, key_skipped_count: 14999982, block: {cache_hit_count: 28451, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.customer.c_acctbal, 5000.602894)	N/A	N/A
21:04:47 [2021-05-25T21:04:47.137Z]               └─TableFullScan_44	7500000.00	7500000	cop[tikv]	table:customer	tikv_task:{proc max:1s, min:421ms, p80:859ms, p95:1s, iters:7404, tasks:18}	keep order:false	N/A	N/A
21:04:47 [2021-05-25T21:04:47.137Z] + sync
21:04:47 [2021-05-25T21:04:47.137Z] + /usr/bin/echo 3
21:05:19 [2021-05-25T21:05:19.261Z] + sync
21:05:19 [2021-05-25T21:05:19.261Z] + /usr/bin/echo 3
21:05:45 [2021-05-25T21:05:45.749Z] + sync
21:05:45 [2021-05-25T21:05:45.749Z] + /usr/bin/echo 3
21:06:12 [2021-05-25T21:06:12.330Z] 
21:06:12 [2021-05-25T21:06:12.330Z] queries/22.sql
21:06:12 [2021-05-25T21:06:12.330Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
21:06:12 [2021-05-25T21:06:12.330Z] Sort_39	2186432.06	4	root		time:24.1s, loops:2	Column#27	9.48 KB	0 Bytes
21:06:12 [2021-05-25T21:06:12.330Z] └─Projection_41	2186432.06	4	root		time:24.1s, loops:5, Concurrency:5	Column#27, Column#28, Column#29	23.7 KB	N/A
21:06:12 [2021-05-25T21:06:12.330Z]   └─HashAgg_42	2186432.06	4	root		time:24.1s, loops:5, partial_worker:{wall_time:24.124162172s, concurrency:5, task_num:181, tot_wait:2m0.564481369s, tot_exec:55.207796ms, tot_time:2m0.619825841s, max:24.124077547s, p95:24.124077547s}, final_worker:{wall_time:24.124192737s, concurrency:5, task_num:20, tot_wait:2m0.620277633s, tot_exec:158.517µs, tot_time:2m0.620443584s, max:24.124129655s, p95:24.124129655s}	group by:Column#33, funcs:count(1)->Column#28, funcs:sum(Column#31)->Column#29, funcs:firstrow(Column#32)->Column#27	857.7 KB	N/A
21:06:12 [2021-05-25T21:06:12.330Z]     └─Projection_51	2186432.06	181704	root		time:24.1s, loops:182, Concurrency:5	tpch50.customer.c_acctbal, substring(tpch50.customer.c_phone, 1, 2)->Column#32, substring(tpch50.customer.c_phone, 1, 2)->Column#33	703.6 KB	N/A
21:06:12 [2021-05-25T21:06:12.330Z]       └─HashJoin_43	2186432.06	181704	root		time:24.1s, loops:182, build_hash_table:{total:22.7s, fetch:923.7ms, build:21.7s}, probe:{concurrency:5, total:2m0.6s, max:24.1s, probe:5.66s, fetch:1m54.9s}	anti semi join, equal:[eq(tpch50.customer.c_custkey, tpch50.orders.o_custkey)]	590.2 MB	0 Bytes
21:06:12 [2021-05-25T21:06:12.330Z]         ├─TableReader_49(Build)	75000000.00	75000000	root		time:906.8ms, loops:73364, cop_task: {num: 153, max: 1.13s, min: 220.8ms, avg: 515.4ms, p95: 912.3ms, max_proc_keys: 723875, p95_proc_keys: 553332, tot_proc: 1m18s, tot_wait: 32ms, rpc_num: 153, rpc_time: 1m18.9s, copr_cache: disabled}	data:TableFullScan_48	54.1 MB	N/A
21:06:12 [2021-05-25T21:06:12.330Z]         │ └─TableFullScan_48	75000000.00	75000000	cop[tikv]	table:orders	tikv_task:{proc max:1.09s, min:212ms, p80:518ms, p95:892ms, iters:73975, tasks:153}, scan_detail: {total_process_keys: 75000000, total_keys: 75000153, rocksdb: {delete_skipped_count: 0, key_skipped_count: 149999847, block: {cache_hit_count: 220923, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
21:06:12 [2021-05-25T21:06:12.330Z]         └─Selection_47(Probe)	2733040.07	545246	root		time:1.62s, loops:534	in(substring(tpch50.customer.c_phone, 1, 2), "20", "40", "22", "30", "39", "42", "21")	94.6 KB	N/A
21:06:12 [2021-05-25T21:06:12.330Z]           └─TableReader_46	2733040.07	3407619	root		time:655.4ms, loops:3319, cop_task: {num: 18, max: 1.27s, min: 539.1ms, avg: 942.6ms, p95: 1.27s, max_proc_keys: 582617, p95_proc_keys: 582617, tot_proc: 16.5s, tot_wait: 1ms, rpc_num: 18, rpc_time: 17s, copr_cache: disabled}	data:Selection_45	192.5 MB	N/A
21:06:12 [2021-05-25T21:06:12.330Z]             └─Selection_45	2733040.07	3407619	cop[tikv]		tikv_task:{proc max:1.19s, min:511ms, p80:1.02s, 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
21:06:12 [2021-05-25T21:06:12.330Z]               └─TableFullScan_44	7500000.00	7500000	cop[tikv]	table:customer	tikv_task:{proc max:1.1s, min:485ms, p80:933ms, p95:1.1s, iters:7404, tasks:18}	keep order:false	N/A	N/A
21:06:12 [2021-05-25T21:06:12.330Z] 
21:06:12 [2021-05-25T21:06:12.330Z] queries/22.sql
21:06:12 [2021-05-25T21:06:12.330Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
21:06:12 [2021-05-25T21:06:12.330Z] Sort_39	2186432.06	4	root		time:25.4s, loops:2	Column#27	9.48 KB	0 Bytes
21:06:12 [2021-05-25T21:06:12.331Z] └─Projection_41	2186432.06	4	root		time:25.4s, loops:5, Concurrency:5	Column#27, Column#28, Column#29	23.7 KB	N/A
21:06:12 [2021-05-25T21:06:12.331Z]   └─HashAgg_42	2186432.06	4	root		time:25.4s, loops:5, partial_worker:{wall_time:25.423599155s, concurrency:5, task_num:181, tot_wait:2m7.060028632s, tot_exec:56.820778ms, tot_time:2m7.116953644s, max:25.423430981s, p95:25.423430981s}, final_worker:{wall_time:25.423807241s, concurrency:5, task_num:20, tot_wait:2m7.118125937s, tot_exec:212.646µs, tot_time:2m7.118348003s, max:25.423719088s, p95:25.423719088s}	group by:Column#33, funcs:count(1)->Column#28, funcs:sum(Column#31)->Column#29, funcs:firstrow(Column#32)->Column#27	857.7 KB	N/A
21:06:12 [2021-05-25T21:06:12.331Z]     └─Projection_51	2186432.06	181704	root		time:25.4s, loops:182, Concurrency:5	tpch50.customer.c_acctbal, substring(tpch50.customer.c_phone, 1, 2)->Column#32, substring(tpch50.customer.c_phone, 1, 2)->Column#33	703.6 KB	N/A
21:06:12 [2021-05-25T21:06:12.331Z]       └─HashJoin_43	2186432.06	181704	root		time:25.4s, loops:182, build_hash_table:{total:23.9s, fetch:906.2ms, build:23s}, probe:{concurrency:5, total:2m7.1s, max:25.4s, probe:6.14s, fetch:2m0.9s}	anti semi join, equal:[eq(tpch50.customer.c_custkey, tpch50.orders.o_custkey)]	590.2 MB	0 Bytes
21:06:12 [2021-05-25T21:06:12.331Z]         ├─TableReader_49(Build)	75000000.00	75000000	root		time:912.3ms, loops:73364, cop_task: {num: 153, max: 1.02s, min: 222.7ms, avg: 501.2ms, p95: 793.7ms, max_proc_keys: 723875, p95_proc_keys: 553332, tot_proc: 1m15.9s, tot_wait: 35ms, rpc_num: 153, rpc_time: 1m16.7s, copr_cache: disabled}	data:TableFullScan_48	57.8 MB	N/A
21:06:12 [2021-05-25T21:06:12.331Z]         │ └─TableFullScan_48	75000000.00	75000000	cop[tikv]	table:orders	tikv_task:{proc max:976ms, min:205ms, p80:505ms, p95:769ms, iters:73975, tasks:153}, scan_detail: {total_process_keys: 75000000, total_keys: 75000153, rocksdb: {delete_skipped_count: 0, key_skipped_count: 149999847, block: {cache_hit_count: 220923, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
21:06:12 [2021-05-25T21:06:12.331Z]         └─Selection_47(Probe)	2733040.07	545246	root		time:1.53s, loops:534	in(substring(tpch50.customer.c_phone, 1, 2), "20", "40", "22", "30", "39", "42", "21")	94.6 KB	N/A
21:06:12 [2021-05-25T21:06:12.331Z]           └─TableReader_46	2733040.07	3407619	root		time:624.5ms, loops:3319, cop_task: {num: 18, max: 1.14s, min: 497ms, avg: 896ms, p95: 1.14s, max_proc_keys: 582617, p95_proc_keys: 582617, tot_proc: 15.7s, tot_wait: 8ms, rpc_num: 18, rpc_time: 16.1s, copr_cache: disabled}	data:Selection_45	192.5 MB	N/A
21:06:12 [2021-05-25T21:06:12.331Z]             └─Selection_45	2733040.07	3407619	cop[tikv]		tikv_task:{proc max:1.06s, min:465ms, p80:1s, p95:1.06s, iters:7404, tasks:18}, scan_detail: {total_process_keys: 7500000, total_keys: 7500018, rocksdb: {delete_skipped_count: 0, key_skipped_count: 14999982, block: {cache_hit_count: 28451, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.customer.c_acctbal, 5000.602894)	N/A	N/A
21:06:12 [2021-05-25T21:06:12.331Z]               └─TableFullScan_44	7500000.00	7500000	cop[tikv]	table:customer	tikv_task:{proc max:964ms, min:426ms, p80:931ms, p95:964ms, iters:7404, tasks:18}	keep order:false	N/A	N/A
21:06:12 [2021-05-25T21:06:12.331Z] 
21:06:12 [2021-05-25T21:06:12.331Z] queries/22.sql
21:06:12 [2021-05-25T21:06:12.331Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
21:06:12 [2021-05-25T21:06:12.331Z] Sort_39	2186432.06	4	root		time:24s, loops:2	Column#27	9.48 KB	0 Bytes
21:06:12 [2021-05-25T21:06:12.331Z] └─Projection_41	2186432.06	4	root		time:24s, loops:5, Concurrency:5	Column#27, Column#28, Column#29	23.7 KB	N/A
21:06:12 [2021-05-25T21:06:12.331Z]   └─HashAgg_42	2186432.06	4	root		time:24s, loops:5, partial_worker:{wall_time:23.975106514s, concurrency:5, task_num:180, tot_wait:1m59.823570497s, tot_exec:51.221734ms, tot_time:1m59.87492887s, max:23.975079504s, p95:23.975079504s}, final_worker:{wall_time:23.975138732s, concurrency:5, task_num:20, tot_wait:1m59.875331985s, tot_exec:236.892µs, tot_time:1m59.875577363s, max:23.975121173s, p95:23.975121173s}	group by:Column#33, funcs:count(1)->Column#28, funcs:sum(Column#31)->Column#29, funcs:firstrow(Column#32)->Column#27	857.7 KB	N/A
21:06:12 [2021-05-25T21:06:12.331Z]     └─Projection_51	2186432.06	181704	root		time:24s, loops:181, Concurrency:5	tpch50.customer.c_acctbal, substring(tpch50.customer.c_phone, 1, 2)->Column#32, substring(tpch50.customer.c_phone, 1, 2)->Column#33	703.6 KB	N/A
21:06:12 [2021-05-25T21:06:12.331Z]       └─HashJoin_43	2186432.06	181704	root		time:24s, loops:181, build_hash_table:{total:22.7s, fetch:919.4ms, build:21.7s}, probe:{concurrency:5, total:1m59.8s, max:24s, probe:5.16s, fetch:1m54.7s}	anti semi join, equal:[eq(tpch50.customer.c_custkey, tpch50.orders.o_custkey)]	590.2 MB	0 Bytes
21:06:12 [2021-05-25T21:06:12.331Z]         ├─TableReader_49(Build)	75000000.00	75000000	root		time:897.8ms, loops:73364, cop_task: {num: 153, max: 1.05s, min: 248.1ms, avg: 504ms, p95: 889.8ms, max_proc_keys: 723875, p95_proc_keys: 553332, tot_proc: 1m16.4s, tot_wait: 42ms, rpc_num: 153, rpc_time: 1m17.1s, copr_cache: disabled}	data:TableFullScan_48	57.8 MB	N/A
21:06:12 [2021-05-25T21:06:12.331Z]         │ └─TableFullScan_48	75000000.00	75000000	cop[tikv]	table:orders	tikv_task:{proc max:1s, min:236ms, p80:519ms, p95:867ms, iters:73975, tasks:153}, scan_detail: {total_process_keys: 75000000, total_keys: 75000153, rocksdb: {delete_skipped_count: 0, key_skipped_count: 149999847, block: {cache_hit_count: 220923, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
21:06:12 [2021-05-25T21:06:12.331Z]         └─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
21:06:12 [2021-05-25T21:06:12.331Z]           └─TableReader_46	2733040.07	3407619	root		time:648.2ms, loops:3319, cop_task: {num: 18, max: 1.3s, min: 525.6ms, avg: 890.1ms, p95: 1.3s, max_proc_keys: 582617, p95_proc_keys: 582617, tot_proc: 15.6s, tot_wait: 8ms, rpc_num: 18, rpc_time: 16s, copr_cache: disabled}	data:Selection_45	192.5 MB	N/A
21:06:12 [2021-05-25T21:06:12.331Z]             └─Selection_45	2733040.07	3407619	cop[tikv]		tikv_task:{proc max:1.21s, min:499ms, p80:1s, 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
21:06:12 [2021-05-25T21:06:12.331Z]               └─TableFullScan_44	7500000.00	7500000	cop[tikv]	table:customer	tikv_task:{proc max:1.1s, min:458ms, p80:920ms, p95:1.1s, iters:7404, tasks:18}	keep order:false	N/A	N/A
21:06:12 [2021-05-25T21:06:12.331Z] + sync
21:06:12 [2021-05-25T21:06:12.331Z] + /usr/bin/echo 3
21:06:44 [2021-05-25T21:06:44.352Z] 
21:06:44 [2021-05-25T21:06:44.352Z] queries/22.sql
21:06:44 [2021-05-25T21:06:44.352Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
21:06:44 [2021-05-25T21:06:44.352Z] Sort_39	2186432.06	4	root		time:24.3s, loops:2	Column#27	9.48 KB	0 Bytes
21:06:44 [2021-05-25T21:06:44.352Z] └─Projection_41	2186432.06	4	root		time:24.3s, loops:5, Concurrency:5	Column#27, Column#28, Column#29	23.7 KB	N/A
21:06:44 [2021-05-25T21:06:44.352Z]   └─HashAgg_42	2186432.06	4	root		time:24.3s, loops:5, partial_worker:{wall_time:24.26413513s, concurrency:5, task_num:179, tot_wait:2m1.265591595s, tot_exec:53.436848ms, tot_time:2m1.319202814s, max:24.263988084s, p95:24.263988084s}, final_worker:{wall_time:24.264174386s, concurrency:5, task_num:20, tot_wait:2m1.319775485s, tot_exec:229.867µs, tot_time:2m1.320015582s, max:24.264027605s, p95:24.264027605s}	group by:Column#33, funcs:count(1)->Column#28, funcs:sum(Column#31)->Column#29, funcs:firstrow(Column#32)->Column#27	857.7 KB	N/A
21:06:44 [2021-05-25T21:06:44.352Z]     └─Projection_51	2186432.06	181704	root		time:24.3s, loops:180, Concurrency:5	tpch50.customer.c_acctbal, substring(tpch50.customer.c_phone, 1, 2)->Column#32, substring(tpch50.customer.c_phone, 1, 2)->Column#33	703.6 KB	N/A
21:06:44 [2021-05-25T21:06:44.352Z]       └─HashJoin_43	2186432.06	181704	root		time:24.3s, loops:180, build_hash_table:{total:22.9s, fetch:927.2ms, build:22s}, probe:{concurrency:5, total:2m1.3s, max:24.3s, probe:5.44s, fetch:1m55.9s}	anti semi join, equal:[eq(tpch50.customer.c_custkey, tpch50.orders.o_custkey)]	590.2 MB	0 Bytes
21:06:44 [2021-05-25T21:06:44.352Z]         ├─TableReader_49(Build)	75000000.00	75000000	root		time:915.5ms, loops:73364, cop_task: {num: 153, max: 1.01s, min: 254.9ms, avg: 508.5ms, p95: 857.9ms, max_proc_keys: 723875, p95_proc_keys: 553332, tot_proc: 1m17.1s, tot_wait: 36ms, rpc_num: 153, rpc_time: 1m17.8s, copr_cache: disabled}	data:TableFullScan_48	57.8 MB	N/A
21:06:44 [2021-05-25T21:06:44.352Z]         │ └─TableFullScan_48	75000000.00	75000000	cop[tikv]	table:orders	tikv_task:{proc max:983ms, min:240ms, p80:509ms, p95:837ms, iters:73975, tasks:153}, scan_detail: {total_process_keys: 75000000, total_keys: 75000153, rocksdb: {delete_skipped_count: 0, key_skipped_count: 149999847, block: {cache_hit_count: 220923, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
21:06:44 [2021-05-25T21:06:44.352Z]         └─Selection_47(Probe)	2733040.07	545246	root		time:1.69s, loops:534	in(substring(tpch50.customer.c_phone, 1, 2), "20", "40", "22", "30", "39", "42", "21")	94.6 KB	N/A
21:06:44 [2021-05-25T21:06:44.352Z]           └─TableReader_46	2733040.07	3407619	root		time:736.5ms, loops:3319, cop_task: {num: 18, max: 1.21s, min: 470.1ms, avg: 873.4ms, p95: 1.21s, max_proc_keys: 582617, p95_proc_keys: 582617, tot_proc: 15.2s, rpc_num: 18, rpc_time: 15.7s, copr_cache: disabled}	data:Selection_45	192.5 MB	N/A
21:06:44 [2021-05-25T21:06:44.352Z]             └─Selection_45	2733040.07	3407619	cop[tikv]		tikv_task:{proc max:1.12s, min:423ms, p80:1.02s, p95:1.12s, iters:7404, tasks:18}, scan_detail: {total_process_keys: 7500000, total_keys: 7500018, rocksdb: {delete_skipped_count: 0, key_skipped_count: 14999982, block: {cache_hit_count: 28451, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.customer.c_acctbal, 5000.602894)	N/A	N/A
21:06:44 [2021-05-25T21:06:44.352Z]               └─TableFullScan_44	7500000.00	7500000	cop[tikv]	table:customer	tikv_task:{proc max:1.02s, min:372ms, p80:952ms, p95:1.02s, iters:7404, tasks:18}	keep order:false	N/A	N/A
21:06:44 [2021-05-25T21:06:44.352Z] 
21:06:44 [2021-05-25T21:06:44.352Z] + tiup cluster stop benchbot
21:06:44 [2021-05-25T21:06:44.352Z] Starting component `cluster`: /home/tidb/.tiup/components/cluster/v1.4.3/tiup-cluster stop benchbot
21:06:44 [2021-05-25T21:06:44.352Z] + [ Serial ] - SSHKeySet: privateKey=/home/tidb/.tiup/storage/cluster/clusters/benchbot/ssh/id_rsa, publicKey=/home/tidb/.tiup/storage/cluster/clusters/benchbot/ssh/id_rsa.pub
21:06:44 [2021-05-25T21:06:44.352Z] + [Parallel] - UserSSH: user=tidb, host=172.16.5.86
21:06:44 [2021-05-25T21:06:44.352Z] + [Parallel] - UserSSH: user=tidb, host=172.16.5.86
21:06:44 [2021-05-25T21:06:44.352Z] + [Parallel] - UserSSH: user=tidb, host=172.16.5.86
21:06:44 [2021-05-25T21:06:44.352Z] + [Parallel] - UserSSH: user=tidb, host=172.16.5.86
21:06:44 [2021-05-25T21:06:44.352Z] + [Parallel] - UserSSH: user=tidb, host=172.16.5.86
21:06:44 [2021-05-25T21:06:44.352Z] + [ Serial ] - StopCluster
21:06:44 [2021-05-25T21:06:44.352Z] Stopping component grafana
21:06:44 [2021-05-25T21:06:44.352Z] 	Stopping instance 172.16.5.86
21:06:44 [2021-05-25T21:06:44.352Z] 	Stop grafana 172.16.5.86:3000 success
21:06:44 [2021-05-25T21:06:44.352Z] Stopping component prometheus
21:06:44 [2021-05-25T21:06:44.352Z] 	Stopping instance 172.16.5.86
21:06:44 [2021-05-25T21:06:44.352Z] 	Stop prometheus 172.16.5.86:9090 success
21:06:44 [2021-05-25T21:06:44.352Z] Stopping component tidb
21:06:44 [2021-05-25T21:06:44.352Z] 	Stopping instance 172.16.5.86
21:06:47 [2021-05-25T21:06:47.615Z] 	Stop tidb 172.16.5.86:4000 success
21:06:47 [2021-05-25T21:06:47.615Z] Stopping component tikv
21:06:47 [2021-05-25T21:06:47.615Z] 	Stopping instance 172.16.5.86
21:06:50 [2021-05-25T21:06:50.936Z] 	Stop tikv 172.16.5.86:20160 success
21:06:50 [2021-05-25T21:06:50.936Z] Stopping component pd
21:06:50 [2021-05-25T21:06:50.936Z] 	Stopping instance 172.16.5.86
21:06:50 [2021-05-25T21:06:50.936Z] 	Stop pd 172.16.5.86:2379 success
21:06:50 [2021-05-25T21:06:50.936Z] Stopping component node_exporter
21:06:51 [2021-05-25T21:06:51.192Z] Stopping component blackbox_exporter
21:06:51 [2021-05-25T21:06:51.448Z] Stopped cluster `benchbot` successfully
21:06:51 [2021-05-25T21:06:51.711Z] [Pipeline] sh
21:06:51 [2021-05-25T21:06:51.988Z] + cat bench_result
21:06:51 [2021-05-25T21:06:51.993Z] [Pipeline] }
21:06:51 [2021-05-25T21:06:51.996Z] [Pipeline] // dir
21:06:51 [2021-05-25T21:06:51.998Z] [Pipeline] }
21:06:51 [2021-05-25T21:06:51.999Z] [Pipeline] // stage
21:06:52 [2021-05-25T21:06:52.001Z] [Pipeline] }
21:06:52 [2021-05-25T21:06:52.003Z] [Pipeline] // node
21:06:52 [2021-05-25T21:06:52.007Z] [Pipeline] }
21:06:52 [2021-05-25T21:06:52.009Z] [Pipeline] // catchError
21:06:52 [2021-05-25T21:06:52.015Z] [Pipeline] stage
21:06:52 [2021-05-25T21:06:52.019Z] [Pipeline] { (Summary)
21:06:52 [2021-05-25T21:06:52.048Z] sh: line 1: 10634 Terminated              sleep 3
21:06:52 [2021-05-25T21:06:52.035Z] [Pipeline] slackSend
21:06:52 [2021-05-25T21:06:52.036Z] Slack Send Pipeline step running, values are - baseUrl: <empty>, teamDomain: pingcap, channel: #daily_bench, color: good, botUser: false, tokenCredentialId: slack-pingcap-token, iconEmoji <empty>, username <empty>
21:06:52 [2021-05-25T21:06:52.061Z] sh: line 1: 10773 Terminated              sleep 3
21:06:53 [2021-05-25T21:06:53.206Z] [Pipeline] }
21:06:53 [2021-05-25T21:06:53.208Z] [Pipeline] // stage
21:06:53 [2021-05-25T21:06:53.210Z] [Pipeline] End of Pipeline
21:06:53 [2021-05-25T21:06:53.226Z] Finished: SUCCESS