SuccessConsole Output

Skipping 1,193 KB.. Full Log
ineitem.l_quantity)->Column#44	194.5 MB	N/A
20:41:16 [2021-05-26T20:41:16.257Z]         └─HashJoin_59	9711455.06	634004	root		time:37.7s, loops:625, build_hash_table:{total:2.51s, fetch:2.28s, build:232.5ms}, probe:{concurrency:5, total:3m8.5s, max:37.7s, probe:14.5s, fetch:2m54s}	left outer join, equal:[eq(tpch50.partsupp.ps_partkey, tpch50.lineitem.l_partkey) eq(tpch50.partsupp.ps_suppkey, tpch50.lineitem.l_suppkey)]	10.4 MB	0 Bytes
20:41:16 [2021-05-26T20:41:16.257Z]           ├─IndexHashJoin_67(Build)	321865.05	435528	root		time:2.46s, loops:430, inner:{total:2.81s, concurrency:5, task:12, construct:141.9ms, fetch:2.29s, build:34.9ms, join:370.4ms}	inner join, inner:IndexLookUp_64, outer key:tpch50.part.p_partkey, inner key:tpch50.partsupp.ps_partkey, equal cond:eq(tpch50.part.p_partkey, tpch50.partsupp.ps_partkey)	20.5 MB	N/A
20:41:16 [2021-05-26T20:41:16.257Z]           │ ├─TableReader_96(Build)	80007.93	108882	root		time:2.11s, loops:112, cop_task: {num: 20, max: 1.45s, min: 624.7ms, avg: 1.08s, p95: 1.45s, max_proc_keys: 686055, p95_proc_keys: 686055, tot_proc: 21.4s, tot_wait: 39ms, rpc_num: 20, rpc_time: 21.5s, copr_cache: disabled}	data:Selection_95	725.8 KB	N/A
20:41:16 [2021-05-26T20:41:16.257Z]           │ │ └─Selection_95	80007.93	108882	cop[tikv]		tikv_task:{proc max:1.44s, min:623ms, p80:1.27s, p95:1.44s, iters:9859, tasks:20}, scan_detail: {total_process_keys: 10000000, total_keys: 10000020, rocksdb: {delete_skipped_count: 0, key_skipped_count: 19999980, block: {cache_hit_count: 31499, read_count: 0, read_byte: 0 Bytes}}}	like(tpch50.part.p_name, "green%", 92)	N/A	N/A
20:41:16 [2021-05-26T20:41:16.257Z]           │ │   └─TableFullScan_94	10000000.00	10000000	cop[tikv]	table:part	tikv_task:{proc max:1.33s, min:577ms, p80:1.18s, p95:1.33s, iters:9859, tasks:20}	keep order:false	N/A	N/A
20:41:16 [2021-05-26T20:41:16.257Z]           │ └─IndexLookUp_64(Probe)	4.02	435528	root		time:2.17s, loops:447, index_task: {total_time: 1.22s, fetch_handle: 1.22s, build: 101.3µs, wait: 266.6µs}, table_task: {total_time: 8.41s, num: 56, concurrency: 60}		19.4 KB	N/A
20:41:16 [2021-05-26T20:41:16.257Z]           │   ├─IndexRangeScan_62(Build)	4.02	435528	cop[tikv]	table:partsupp, index:PRIMARY(PS_PARTKEY, PS_SUPPKEY)	time:1.18s, loops:479, cop_task: {num: 59, max: 217.6ms, min: 5.57ms, avg: 91.2ms, p95: 199.5ms, max_proc_keys: 15288, p95_proc_keys: 15008, tot_proc: 4.76s, tot_wait: 229ms, rpc_num: 59, rpc_time: 5.38s, copr_cache: disabled}, tikv_task:{proc max:203ms, min:4ms, p80:142ms, p95:187ms, iters:692, tasks:59}, scan_detail: {total_process_keys: 435528, total_keys: 544410, rocksdb: {delete_skipped_count: 0, key_skipped_count: 435528, block: {cache_hit_count: 980292, read_count: 0, read_byte: 0 Bytes}}}	range: decided by [eq(tpch50.partsupp.ps_partkey, tpch50.part.p_partkey)], keep order:false	N/A	N/A
20:41:16 [2021-05-26T20:41:16.257Z]           │   └─TableRowIDScan_63(Probe)	4.02	435528	cop[tikv]	table:partsupp	time:2.88s, loops:505, cop_task: {num: 1437, max: 80.7ms, min: 437.1µs, avg: 19.3ms, p95: 44.7ms, max_proc_keys: 1236, p95_proc_keys: 564, tot_proc: 19.7s, tot_wait: 5.89s, rpc_num: 1437, rpc_time: 27.7s, copr_cache: disabled}, tikv_task:{proc max:59ms, min:0s, p80:16ms, p95:23ms, iters:5305, tasks:1437}, scan_detail: {total_process_keys: 435528, total_keys: 473503, rocksdb: {delete_skipped_count: 0, key_skipped_count: 194045, block: {cache_hit_count: 3644288, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:41:16 [2021-05-26T20:41:16.257Z]           └─TableReader_101(Probe)	46310896.67	45504356	root		time:33.3s, loops:44290, cop_task: {num: 761, max: 1.17s, min: 351.7ms, avg: 701.8ms, p95: 835.6ms, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 8m50.8s, tot_wait: 114ms, rpc_num: 761, rpc_time: 8m54s, copr_cache: disabled}	data:Selection_100	52.6 MB	N/A
20:41:16 [2021-05-26T20:41:16.257Z]             └─Selection_100	46310896.67	45504356	cop[tikv]		tikv_task:{proc max:1.08s, min:338ms, p80:750ms, p95:817ms, iters:296606, tasks:761}, scan_detail: {total_process_keys: 300005811, total_keys: 300006572, rocksdb: {delete_skipped_count: 0, key_skipped_count: 600010861, block: {cache_hit_count: 1124648, read_count: 0, read_byte: 0 Bytes}}}	ge(tpch50.lineitem.l_shipdate, 1993-01-01 00:00:00.000000), lt(tpch50.lineitem.l_shipdate, 1994-01-01)	N/A	N/A
20:41:16 [2021-05-26T20:41:16.257Z]               └─TableFullScan_99	300005811.00	300005811	cop[tikv]	table:lineitem	tikv_task:{proc max:1.04s, min:326ms, p80:717ms, p95:791ms, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:41:16 [2021-05-26T20:41:16.257Z] + sync
20:41:16 [2021-05-26T20:41:16.257Z] + /usr/bin/echo 3
20:41:54 [2021-05-26T20:41:54.915Z] + sync
20:41:54 [2021-05-26T20:41:54.915Z] + /usr/bin/echo 3
20:42:33 [2021-05-26T20:42:33.594Z] 
20:42:33 [2021-05-26T20:42:33.594Z] queries/20.sql
20:42:33 [2021-05-26T20:42:33.594Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:42:33 [2021-05-26T20:42:33.594Z] Sort_30	20000.00	8982	root		time:37.9s, loops:10	tpch50.supplier.s_name	637.7 KB	0 Bytes
20:42:33 [2021-05-26T20:42:33.594Z] └─HashJoin_35	20000.00	8982	root		time:37.9s, loops:11, build_hash_table:{total:1.39s, fetch:1.38s, build:12.3ms}, probe:{concurrency:5, total:3m9.3s, max:37.9s, probe:50.9ms, fetch:3m9.2s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.partsupp.ps_suppkey)]	1.50 MB	0 Bytes
20:42:33 [2021-05-26T20:42:33.594Z]   ├─HashJoin_48(Build)	20000.00	19972	root		time:1.38s, loops:22, build_hash_table:{total:142.6µs, fetch:136.9µs, build:5.68µs}, probe:{concurrency:5, total:6.93s, max:1.39s, probe:91.7ms, fetch:6.84s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:42:33 [2021-05-26T20:42:33.594Z]   │ ├─TableReader_53(Build)	1.00	1	root		time:43µs, loops:2, cop_task: {num: 1, max: 804.8µs, proc_keys: 25, rpc_num: 1, rpc_time: 769.7µs, copr_cache: disabled}	data:Selection_52	236 Bytes	N/A
20:42:33 [2021-05-26T20:42:33.594Z]   │ │ └─Selection_52	1.00	1	cop[tikv]		tikv_task:{time:0s, loops:1}, scan_detail: {total_process_keys: 25, total_keys: 26, rocksdb: {delete_skipped_count: 0, key_skipped_count: 46, block: {cache_hit_count: 18, read_count: 0, read_byte: 0 Bytes}}}	eq(tpch50.nation.n_name, "ALGERIA")	N/A	N/A
20:42:33 [2021-05-26T20:42:33.594Z]   │ │   └─TableFullScan_51	25.00	25	cop[tikv]	table:nation	tikv_task:{time:0s, loops:1}	keep order:false	N/A	N/A
20:42:33 [2021-05-26T20:42:33.594Z]   │ └─TableReader_50(Probe)	500000.00	500000	root		time:1.37s, loops:490, cop_task: {num: 1, max: 1.37s, proc_keys: 500000, tot_proc: 1.3s, tot_wait: 1ms, rpc_num: 1, rpc_time: 1.37s, copr_cache: disabled}	data:TableFullScan_49	35.8 MB	N/A
20:42:33 [2021-05-26T20:42:33.594Z]   │   └─TableFullScan_49	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:1.17s, loops:493}, scan_detail: {total_process_keys: 500000, total_keys: 500001, rocksdb: {delete_skipped_count: 0, key_skipped_count: 999999, block: {cache_hit_count: 1692, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:42:33 [2021-05-26T20:42:33.594Z]   └─HashAgg_54(Probe)	257492.04	223999	root		time:37.8s, loops:222, partial_worker:{wall_time:37.786615112s, concurrency:5, task_num:289, tot_wait:3m8.663207244s, tot_exec:215.940357ms, tot_time:3m8.920328189s, max:37.786537346s, p95:37.786537346s}, final_worker:{wall_time:37.853533686s, concurrency:5, task_num:25, tot_wait:3m8.907337492s, tot_exec:338.32866ms, tot_time:3m9.245680809s, max:37.853463278s, p95:37.853463278s}	group by:tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_suppkey)->tpch50.partsupp.ps_suppkey	61.4 MB	N/A
20:42:33 [2021-05-26T20:42:33.594Z]     └─Selection_55	257492.04	295898	root		time:37.8s, loops:290	gt(cast(tpch50.partsupp.ps_availqty, decimal(20,0) BINARY), mul(0.5, Column#44))	59.2 KB	N/A
20:42:33 [2021-05-26T20:42:33.594Z]       └─HashAgg_56	321865.05	435528	root		time:37.7s, loops:430, partial_worker:{wall_time:37.393845247s, concurrency:5, task_num:624, tot_wait:3m5.592365023s, tot_exec:1.241906197s, tot_time:3m6.955626842s, max:37.3936986s, p95:37.3936986s}, final_worker:{wall_time:37.774327465s, concurrency:5, task_num:25, tot_wait:3m6.942902468s, tot_exec:1.893777206s, tot_time:3m8.836696361s, max:37.774110281s, p95:37.774110281s}	group by:tpch50.partsupp.ps_partkey, tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_suppkey)->tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_availqty)->tpch50.partsupp.ps_availqty, funcs:sum(tpch50.lineitem.l_quantity)->Column#44	194.5 MB	N/A
20:42:33 [2021-05-26T20:42:33.594Z]         └─HashJoin_59	9711455.06	634004	root		time:37.3s, loops:625, build_hash_table:{total:2.48s, fetch:2.26s, build:211.7ms}, probe:{concurrency:5, total:3m6.4s, max:37.3s, probe:14.5s, fetch:2m51.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:42:33 [2021-05-26T20:42:33.594Z]           ├─IndexHashJoin_67(Build)	321865.05	435528	root		time:2.43s, loops:430, inner:{total:2.73s, concurrency:5, task:12, construct:122.5ms, fetch:2.28s, build:32.9ms, join:331.5ms}	inner join, inner:IndexLookUp_64, outer key:tpch50.part.p_partkey, inner key:tpch50.partsupp.ps_partkey, equal cond:eq(tpch50.part.p_partkey, tpch50.partsupp.ps_partkey)	20.5 MB	N/A
20:42:33 [2021-05-26T20:42:33.594Z]           │ ├─TableReader_96(Build)	80007.93	108882	root		time:2.07s, loops:112, cop_task: {num: 20, max: 1.37s, min: 586.5ms, avg: 1.09s, p95: 1.37s, max_proc_keys: 686055, p95_proc_keys: 686055, tot_proc: 21.6s, tot_wait: 7ms, rpc_num: 20, rpc_time: 21.7s, copr_cache: disabled}	data:Selection_95	725.8 KB	N/A
20:42:33 [2021-05-26T20:42:33.594Z]           │ │ └─Selection_95	80007.93	108882	cop[tikv]		tikv_task:{proc max:1.31s, min:581ms, p80:1.27s, p95:1.31s, iters:9859, tasks:20}, scan_detail: {total_process_keys: 10000000, total_keys: 10000020, rocksdb: {delete_skipped_count: 0, key_skipped_count: 19999980, block: {cache_hit_count: 31499, read_count: 0, read_byte: 0 Bytes}}}	like(tpch50.part.p_name, "green%", 92)	N/A	N/A
20:42:33 [2021-05-26T20:42:33.594Z]           │ │   └─TableFullScan_94	10000000.00	10000000	cop[tikv]	table:part	tikv_task:{proc max:1.22s, min:533ms, p80:1.17s, p95:1.22s, iters:9859, tasks:20}	keep order:false	N/A	N/A
20:42:33 [2021-05-26T20:42:33.594Z]           │ └─IndexLookUp_64(Probe)	4.02	435528	root		time:2.18s, loops:447, index_task: {total_time: 1.17s, fetch_handle: 1.17s, build: 92.1µs, wait: 272.1µs}, table_task: {total_time: 7.98s, num: 56, concurrency: 60}		20.5 KB	N/A
20:42:33 [2021-05-26T20:42:33.594Z]           │   ├─IndexRangeScan_62(Build)	4.02	435528	cop[tikv]	table:partsupp, index:PRIMARY(PS_PARTKEY, PS_SUPPKEY)	time:1.12s, loops:482, cop_task: {num: 60, max: 203.1ms, min: 3.91ms, avg: 90.3ms, p95: 192.6ms, max_proc_keys: 15288, p95_proc_keys: 14960, tot_proc: 4.77s, tot_wait: 202ms, rpc_num: 60, rpc_time: 5.42s, copr_cache: disabled}, tikv_task:{proc max:176ms, min:2ms, p80:137ms, p95:171ms, iters:698, tasks:60}, scan_detail: {total_process_keys: 435528, total_keys: 544410, rocksdb: {delete_skipped_count: 0, key_skipped_count: 435528, block: {cache_hit_count: 980292, read_count: 0, read_byte: 0 Bytes}}}	range: decided by [eq(tpch50.partsupp.ps_partkey, tpch50.part.p_partkey)], keep order:false	N/A	N/A
20:42:33 [2021-05-26T20:42:33.594Z]           │   └─TableRowIDScan_63(Probe)	4.02	435528	cop[tikv]	table:partsupp	time:2.74s, loops:505, cop_task: {num: 1407, max: 89.8ms, min: 374.6µs, avg: 18.8ms, p95: 39.7ms, max_proc_keys: 976, p95_proc_keys: 604, tot_proc: 19.3s, tot_wait: 4.89s, rpc_num: 1407, rpc_time: 26.4s, copr_cache: disabled}, tikv_task:{proc max:45ms, min:0s, p80:17ms, p95:25ms, iters:5236, tasks:1407}, scan_detail: {total_process_keys: 435528, total_keys: 473514, rocksdb: {delete_skipped_count: 0, key_skipped_count: 194096, block: {cache_hit_count: 3644015, read_count: 1, read_byte: 26.9 KB}}}	keep order:false	N/A	N/A
20:42:33 [2021-05-26T20:42:33.594Z]           └─TableReader_101(Probe)	46310896.67	45504356	root		time:32.9s, loops:44289, cop_task: {num: 761, max: 1.16s, min: 354.2ms, avg: 694.5ms, p95: 850.1ms, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 8m45.3s, tot_wait: 107ms, rpc_num: 761, rpc_time: 8m48.5s, copr_cache: disabled}	data:Selection_100	52.6 MB	N/A
20:42:33 [2021-05-26T20:42:33.594Z]             └─Selection_100	46310896.67	45504356	cop[tikv]		tikv_task:{proc max:1.13s, min:347ms, p80:739ms, p95:833ms, iters:296606, tasks:761}, scan_detail: {total_process_keys: 300005811, total_keys: 300006572, rocksdb: {delete_skipped_count: 0, key_skipped_count: 600010861, block: {cache_hit_count: 1124648, read_count: 0, read_byte: 0 Bytes}}}	ge(tpch50.lineitem.l_shipdate, 1993-01-01 00:00:00.000000), lt(tpch50.lineitem.l_shipdate, 1994-01-01)	N/A	N/A
20:42:33 [2021-05-26T20:42:33.594Z]               └─TableFullScan_99	300005811.00	300005811	cop[tikv]	table:lineitem	tikv_task:{proc max:1.07s, min:329ms, p80:711ms, p95:802ms, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:42:33 [2021-05-26T20:42:33.594Z] 
20:42:33 [2021-05-26T20:42:33.594Z] queries/20.sql
20:42:33 [2021-05-26T20:42:33.594Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:42:33 [2021-05-26T20:42:33.594Z] Sort_30	20000.00	8982	root		time:38.1s, loops:10	tpch50.supplier.s_name	623.5 KB	0 Bytes
20:42:33 [2021-05-26T20:42:33.595Z] └─HashJoin_35	20000.00	8982	root		time:38.1s, loops:11, build_hash_table:{total:1.39s, fetch:1.38s, build:15.9ms}, probe:{concurrency:5, total:3m10.5s, max:38.1s, probe:52.5ms, fetch:3m10.4s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.partsupp.ps_suppkey)]	1.60 MB	0 Bytes
20:42:33 [2021-05-26T20:42:33.595Z]   ├─HashJoin_48(Build)	20000.00	19972	root		time:1.38s, loops:25, build_hash_table:{total:201.9µs, fetch:195.1µs, build:6.8µs}, probe:{concurrency:5, total:6.92s, max:1.39s, probe:124.1ms, fetch:6.8s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:42:33 [2021-05-26T20:42:33.595Z]   │ ├─TableReader_53(Build)	1.00	1	root		time:59.1µs, loops:2, cop_task: {num: 1, max: 1.01ms, proc_keys: 25, tot_proc: 1ms, rpc_num: 1, rpc_time: 986.7µs, copr_cache: disabled}	data:Selection_52	244 Bytes	N/A
20:42:33 [2021-05-26T20:42:33.595Z]   │ │ └─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:42:33 [2021-05-26T20:42:33.595Z]   │ │   └─TableFullScan_51	25.00	25	cop[tikv]	table:nation	tikv_task:{time:1ms, loops:1}	keep order:false	N/A	N/A
20:42:33 [2021-05-26T20:42:33.595Z]   │ └─TableReader_50(Probe)	500000.00	500000	root		time:1.36s, loops:490, cop_task: {num: 1, max: 1.36s, proc_keys: 500000, tot_proc: 1.31s, rpc_num: 1, rpc_time: 1.36s, copr_cache: disabled}	data:TableFullScan_49	35.8 MB	N/A
20:42:33 [2021-05-26T20:42:33.595Z]   │   └─TableFullScan_49	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:1.11s, loops:493}, scan_detail: {total_process_keys: 500000, total_keys: 500001, rocksdb: {delete_skipped_count: 0, key_skipped_count: 999999, block: {cache_hit_count: 1692, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:42:33 [2021-05-26T20:42:33.595Z]   └─HashAgg_54(Probe)	257492.04	223999	root		time:38.1s, loops:222, partial_worker:{wall_time:38.021066704s, concurrency:5, task_num:289, tot_wait:3m9.684705085s, tot_exec:310.799428ms, tot_time:3m10.094629905s, max:38.020655917s, p95:38.020655917s}, final_worker:{wall_time:38.09396428s, concurrency:5, task_num:25, tot_wait:3m10.08772172s, tot_exec:374.088137ms, tot_time:3m10.461824069s, max:38.093548014s, p95:38.093548014s}	group by:tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_suppkey)->tpch50.partsupp.ps_suppkey	61.4 MB	N/A
20:42:33 [2021-05-26T20:42:33.595Z]     └─Selection_55	257492.04	295898	root		time:38s, loops:290	gt(cast(tpch50.partsupp.ps_availqty, decimal(20,0) BINARY), mul(0.5, Column#44))	59.2 KB	N/A
20:42:33 [2021-05-26T20:42:33.595Z]       └─HashAgg_56	321865.05	435528	root		time:37.9s, loops:430, partial_worker:{wall_time:37.619435235s, concurrency:5, task_num:624, tot_wait:3m6.875974094s, tot_exec:1.101103181s, tot_time:3m8.091113968s, max:37.619327255s, p95:37.619327255s}, final_worker:{wall_time:37.98981147s, concurrency:5, task_num:25, tot_wait:3m8.086114842s, tot_exec:1.760219121s, tot_time:3m9.846362513s, max:37.989511866s, p95:37.989511866s}	group by:tpch50.partsupp.ps_partkey, tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_suppkey)->tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_availqty)->tpch50.partsupp.ps_availqty, funcs:sum(tpch50.lineitem.l_quantity)->Column#44	194.5 MB	N/A
20:42:33 [2021-05-26T20:42:33.595Z]         └─HashJoin_59	9711455.06	634004	root		time:37.5s, loops:625, build_hash_table:{total:2.48s, fetch:2.27s, build:214.3ms}, probe:{concurrency:5, total:3m7.7s, max:37.5s, probe:14.6s, fetch:2m53.1s}	left outer join, equal:[eq(tpch50.partsupp.ps_partkey, tpch50.lineitem.l_partkey) eq(tpch50.partsupp.ps_suppkey, tpch50.lineitem.l_suppkey)]	10.4 MB	0 Bytes
20:42:33 [2021-05-26T20:42:33.595Z]           ├─IndexHashJoin_67(Build)	321865.05	435528	root		time:2.43s, loops:430, inner:{total:2.64s, concurrency:5, task:12, construct:121.7ms, fetch:2.16s, build:28.3ms, join:351ms}	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:42:33 [2021-05-26T20:42:33.595Z]           │ ├─TableReader_96(Build)	80007.93	108882	root		time:2.04s, loops:112, cop_task: {num: 20, max: 1.54s, min: 571.3ms, avg: 1.11s, p95: 1.54s, max_proc_keys: 686055, p95_proc_keys: 686055, tot_proc: 22.2s, tot_wait: 2ms, rpc_num: 20, rpc_time: 22.3s, copr_cache: disabled}	data:Selection_95	680.6 KB	N/A
20:42:33 [2021-05-26T20:42:33.595Z]           │ │ └─Selection_95	80007.93	108882	cop[tikv]		tikv_task:{proc max:1.52s, min:568ms, p80:1.29s, 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:42:33 [2021-05-26T20:42:33.595Z]           │ │   └─TableFullScan_94	10000000.00	10000000	cop[tikv]	table:part	tikv_task:{proc max:1.42s, min:514ms, p80:1.2s, p95:1.42s, iters:9859, tasks:20}	keep order:false	N/A	N/A
20:42:33 [2021-05-26T20:42:33.595Z]           │ └─IndexLookUp_64(Probe)	4.02	435528	root		time:2.07s, loops:447, index_task: {total_time: 1.26s, fetch_handle: 1.26s, build: 92µs, wait: 241.7µs}, table_task: {total_time: 8.04s, num: 56, concurrency: 60}		19.6 KB	N/A
20:42:33 [2021-05-26T20:42:33.595Z]           │   ├─IndexRangeScan_62(Build)	4.02	435528	cop[tikv]	table:partsupp, index:PRIMARY(PS_PARTKEY, PS_SUPPKEY)	time:1.21s, loops:481, cop_task: {num: 59, max: 226.3ms, min: 4.8ms, avg: 92.4ms, p95: 211.8ms, max_proc_keys: 15288, p95_proc_keys: 15008, tot_proc: 4.96s, tot_wait: 31ms, rpc_num: 59, rpc_time: 5.45s, copr_cache: disabled}, tikv_task:{proc max:203ms, min:4ms, p80:141ms, p95:188ms, iters:692, tasks:59}, scan_detail: {total_process_keys: 435528, total_keys: 544410, rocksdb: {delete_skipped_count: 0, key_skipped_count: 435528, block: {cache_hit_count: 980292, read_count: 0, read_byte: 0 Bytes}}}	range: decided by [eq(tpch50.partsupp.ps_partkey, tpch50.part.p_partkey)], keep order:false	N/A	N/A
20:42:33 [2021-05-26T20:42:33.595Z]           │   └─TableRowIDScan_63(Probe)	4.02	435528	cop[tikv]	table:partsupp	time:2.46s, loops:503, cop_task: {num: 1408, max: 61ms, min: 357.5µs, avg: 17.4ms, p95: 35.7ms, max_proc_keys: 1188, p95_proc_keys: 608, tot_proc: 18.2s, tot_wait: 3.79s, rpc_num: 1408, rpc_time: 24.4s, copr_cache: disabled}, tikv_task:{proc max:47ms, min:0s, p80:17ms, p95:24ms, iters:5238, tasks:1408}, scan_detail: {total_process_keys: 435528, total_keys: 473512, rocksdb: {delete_skipped_count: 0, key_skipped_count: 194088, block: {cache_hit_count: 3643960, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:42:33 [2021-05-26T20:42:33.595Z]           └─TableReader_101(Probe)	46310896.67	45504356	root		time:33s, loops:44288, cop_task: {num: 761, max: 1.18s, min: 271.5ms, avg: 699.7ms, p95: 858.3ms, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 8m49.3s, tot_wait: 122ms, rpc_num: 761, rpc_time: 8m52.5s, copr_cache: disabled}	data:Selection_100	52.6 MB	N/A
20:42:33 [2021-05-26T20:42:33.595Z]             └─Selection_100	46310896.67	45504356	cop[tikv]		tikv_task:{proc max:1.14s, min:257ms, p80:746ms, 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:42:33 [2021-05-26T20:42:33.595Z]               └─TableFullScan_99	300005811.00	300005811	cop[tikv]	table:lineitem	tikv_task:{proc max:1.09s, min:244ms, p80:715ms, p95:805ms, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:42:33 [2021-05-26T20:42:33.595Z] + sync
20:42:33 [2021-05-26T20:42:33.595Z] + /usr/bin/echo 3
20:43:20 [2021-05-26T20:43:20.418Z] + sync
20:43:20 [2021-05-26T20:43:20.418Z] + /usr/bin/echo 3
20:43:59 [2021-05-26T20:43:59.074Z] 
20:43:59 [2021-05-26T20:43:59.074Z] queries/20.sql
20:43:59 [2021-05-26T20:43:59.074Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:43:59 [2021-05-26T20:43:59.074Z] Sort_30	20000.00	8982	root		time:37.9s, loops:10	tpch50.supplier.s_name	638.4 KB	0 Bytes
20:43:59 [2021-05-26T20:43:59.074Z] └─HashJoin_35	20000.00	8982	root		time:37.9s, loops:11, build_hash_table:{total:1.42s, fetch:1.41s, build:11.9ms}, probe:{concurrency:5, total:3m9.5s, max:37.9s, probe:51.8ms, fetch:3m9.5s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.partsupp.ps_suppkey)]	1.56 MB	0 Bytes
20:43:59 [2021-05-26T20:43:59.074Z]   ├─HashJoin_48(Build)	20000.00	19972	root		time:1.42s, loops:24, build_hash_table:{total:140.6µs, fetch:134.8µs, build:5.81µs}, probe:{concurrency:5, total:7.11s, max:1.42s, probe:105.7ms, fetch:7s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:43:59 [2021-05-26T20:43:59.074Z]   │ ├─TableReader_53(Build)	1.00	1	root		time:41.2µs, loops:2, cop_task: {num: 1, max: 1.19ms, proc_keys: 25, tot_proc: 1ms, rpc_num: 1, rpc_time: 1.14ms, copr_cache: disabled}	data:Selection_52	244 Bytes	N/A
20:43:59 [2021-05-26T20:43:59.074Z]   │ │ └─Selection_52	1.00	1	cop[tikv]		tikv_task:{time:1ms, loops:1}, scan_detail: {total_process_keys: 25, total_keys: 26, rocksdb: {delete_skipped_count: 0, key_skipped_count: 46, block: {cache_hit_count: 18, read_count: 0, read_byte: 0 Bytes}}}	eq(tpch50.nation.n_name, "ALGERIA")	N/A	N/A
20:43:59 [2021-05-26T20:43:59.075Z]   │ │   └─TableFullScan_51	25.00	25	cop[tikv]	table:nation	tikv_task:{time:1ms, loops:1}	keep order:false	N/A	N/A
20:43:59 [2021-05-26T20:43:59.075Z]   │ └─TableReader_50(Probe)	500000.00	500000	root		time:1.4s, loops:490, cop_task: {num: 1, max: 1.4s, proc_keys: 500000, tot_proc: 1.32s, rpc_num: 1, rpc_time: 1.4s, copr_cache: disabled}	data:TableFullScan_49	35.8 MB	N/A
20:43:59 [2021-05-26T20:43:59.075Z]   │   └─TableFullScan_49	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:1.17s, loops:493}, scan_detail: {total_process_keys: 500000, total_keys: 500001, rocksdb: {delete_skipped_count: 0, key_skipped_count: 999999, block: {cache_hit_count: 1692, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:43:59 [2021-05-26T20:43:59.075Z]   └─HashAgg_54(Probe)	257492.04	223999	root		time:37.9s, loops:222, partial_worker:{wall_time:37.796816347s, concurrency:5, task_num:289, tot_wait:3m8.708406679s, tot_exec:210.664067ms, tot_time:3m8.962201105s, max:37.796538549s, p95:37.796538549s}, final_worker:{wall_time:37.905113805s, concurrency:5, task_num:25, tot_wait:3m8.94218868s, tot_exec:552.788901ms, tot_time:3m9.495041439s, max:37.904833371s, p95:37.904833371s}	group by:tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_suppkey)->tpch50.partsupp.ps_suppkey	61.4 MB	N/A
20:43:59 [2021-05-26T20:43:59.075Z]     └─Selection_55	257492.04	295898	root		time:37.8s, loops:290	gt(cast(tpch50.partsupp.ps_availqty, decimal(20,0) BINARY), mul(0.5, Column#44))	59.2 KB	N/A
20:43:59 [2021-05-26T20:43:59.075Z]       └─HashAgg_56	321865.05	435528	root		time:37.7s, loops:430, partial_worker:{wall_time:37.434215038s, concurrency:5, task_num:624, tot_wait:3m5.944381652s, tot_exec:1.098290383s, tot_time:3m7.161800729s, max:37.434119751s, p95:37.434119751s}, final_worker:{wall_time:37.781697472s, concurrency:5, task_num:25, tot_wait:3m7.145412281s, tot_exec:1.749010153s, tot_time:3m8.894440272s, max:37.781572376s, p95:37.781572376s}	group by:tpch50.partsupp.ps_partkey, tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_suppkey)->tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_availqty)->tpch50.partsupp.ps_availqty, funcs:sum(tpch50.lineitem.l_quantity)->Column#44	194.5 MB	N/A
20:43:59 [2021-05-26T20:43:59.075Z]         └─HashJoin_59	9711455.06	634004	root		time:37.4s, loops:625, build_hash_table:{total:2.61s, fetch:2.39s, build:218.4ms}, probe:{concurrency:5, total:3m6.8s, max:37.4s, probe:14.8s, fetch:2m52s}	left outer join, equal:[eq(tpch50.partsupp.ps_partkey, tpch50.lineitem.l_partkey) eq(tpch50.partsupp.ps_suppkey, tpch50.lineitem.l_suppkey)]	10.4 MB	0 Bytes
20:43:59 [2021-05-26T20:43:59.075Z]           ├─IndexHashJoin_67(Build)	321865.05	435528	root		time:2.57s, loops:430, inner:{total:2.67s, concurrency:5, task:12, construct:112.4ms, fetch:2.21s, build:33.1ms, join:342.4ms}	inner join, inner:IndexLookUp_64, outer key:tpch50.part.p_partkey, inner key:tpch50.partsupp.ps_partkey, equal cond:eq(tpch50.part.p_partkey, tpch50.partsupp.ps_partkey)	20.6 MB	N/A
20:43:59 [2021-05-26T20:43:59.075Z]           │ ├─TableReader_96(Build)	80007.93	108882	root		time:2.23s, loops:112, cop_task: {num: 20, max: 1.45s, min: 646.4ms, avg: 1.12s, p95: 1.45s, max_proc_keys: 686055, p95_proc_keys: 686055, tot_proc: 22.3s, tot_wait: 26ms, rpc_num: 20, rpc_time: 22.4s, copr_cache: disabled}	data:Selection_95	725.8 KB	N/A
20:43:59 [2021-05-26T20:43:59.075Z]           │ │ └─Selection_95	80007.93	108882	cop[tikv]		tikv_task:{proc max:1.44s, min:644ms, p80:1.29s, p95:1.44s, iters:9859, tasks:20}, scan_detail: {total_process_keys: 10000000, total_keys: 10000020, rocksdb: {delete_skipped_count: 0, key_skipped_count: 19999980, block: {cache_hit_count: 31499, read_count: 0, read_byte: 0 Bytes}}}	like(tpch50.part.p_name, "green%", 92)	N/A	N/A
20:43:59 [2021-05-26T20:43:59.075Z]           │ │   └─TableFullScan_94	10000000.00	10000000	cop[tikv]	table:part	tikv_task:{proc max:1.33s, min:602ms, p80:1.19s, p95:1.33s, iters:9859, tasks:20}	keep order:false	N/A	N/A
20:43:59 [2021-05-26T20:43:59.075Z]           │ └─IndexLookUp_64(Probe)	4.02	435528	root		time:2.11s, loops:447, index_task: {total_time: 1.29s, fetch_handle: 1.29s, build: 83.1µs, wait: 275µs}, table_task: {total_time: 8.42s, num: 56, concurrency: 60}		20.5 KB	N/A
20:43:59 [2021-05-26T20:43:59.075Z]           │   ├─IndexRangeScan_62(Build)	4.02	435528	cop[tikv]	table:partsupp, index:PRIMARY(PS_PARTKEY, PS_SUPPKEY)	time:1.24s, loops:482, cop_task: {num: 55, max: 249.8ms, min: 4.95ms, avg: 103.2ms, p95: 221.8ms, max_proc_keys: 15288, p95_proc_keys: 14948, tot_proc: 5.28s, tot_wait: 5ms, rpc_num: 55, rpc_time: 5.67s, copr_cache: disabled}, tikv_task:{proc max:224ms, min:4ms, p80:153ms, p95:211ms, iters:676, tasks:55}, scan_detail: {total_process_keys: 435528, total_keys: 544410, rocksdb: {delete_skipped_count: 0, key_skipped_count: 435528, block: {cache_hit_count: 980292, read_count: 0, read_byte: 0 Bytes}}}	range: decided by [eq(tpch50.partsupp.ps_partkey, tpch50.part.p_partkey)], keep order:false	N/A	N/A
20:43:59 [2021-05-26T20:43:59.075Z]           │   └─TableRowIDScan_63(Probe)	4.02	435528	cop[tikv]	table:partsupp	time:2.61s, loops:507, cop_task: {num: 1407, max: 64.3ms, min: 476.5µs, avg: 19ms, p95: 38.6ms, max_proc_keys: 1056, p95_proc_keys: 624, tot_proc: 19.5s, tot_wait: 5.1s, rpc_num: 1407, rpc_time: 26.8s, copr_cache: disabled}, tikv_task:{proc max:52ms, min:0s, p80:17ms, p95:26ms, iters:5252, tasks:1407}, scan_detail: {total_process_keys: 435528, total_keys: 473518, rocksdb: {delete_skipped_count: 0, key_skipped_count: 194096, block: {cache_hit_count: 3643842, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:43:59 [2021-05-26T20:43:59.075Z]           └─TableReader_101(Probe)	46310896.67	45504356	root		time:32.8s, loops:44290, cop_task: {num: 761, max: 1.13s, min: 393ms, avg: 694.4ms, p95: 829.4ms, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 8m45.2s, tot_wait: 114ms, rpc_num: 761, rpc_time: 8m48.4s, copr_cache: disabled}	data:Selection_100	52.6 MB	N/A
20:43:59 [2021-05-26T20:43:59.075Z]             └─Selection_100	46310896.67	45504356	cop[tikv]		tikv_task:{proc max:1.08s, min:376ms, p80:731ms, p95:810ms, iters:296606, tasks:761}, scan_detail: {total_process_keys: 300005811, total_keys: 300006572, rocksdb: {delete_skipped_count: 0, key_skipped_count: 600010861, block: {cache_hit_count: 1124648, read_count: 0, read_byte: 0 Bytes}}}	ge(tpch50.lineitem.l_shipdate, 1993-01-01 00:00:00.000000), lt(tpch50.lineitem.l_shipdate, 1994-01-01)	N/A	N/A
20:43:59 [2021-05-26T20:43:59.075Z]               └─TableFullScan_99	300005811.00	300005811	cop[tikv]	table:lineitem	tikv_task:{proc max:1.03s, min:361ms, p80:702ms, p95:780ms, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:43:59 [2021-05-26T20:43:59.075Z] 
20:43:59 [2021-05-26T20:43:59.075Z] queries/20.sql
20:43:59 [2021-05-26T20:43:59.075Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:43:59 [2021-05-26T20:43:59.075Z] Sort_30	20000.00	8982	root		time:38.2s, loops:10	tpch50.supplier.s_name	623.7 KB	0 Bytes
20:43:59 [2021-05-26T20:43:59.075Z] └─HashJoin_35	20000.00	8982	root		time:38.2s, loops:11, build_hash_table:{total:1.31s, fetch:1.3s, build:11.4ms}, probe:{concurrency:5, total:3m11.1s, max:38.2s, probe:47.9ms, fetch:3m11.1s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.partsupp.ps_suppkey)]	1.48 MB	0 Bytes
20:43:59 [2021-05-26T20:43:59.075Z]   ├─HashJoin_48(Build)	20000.00	19972	root		time:1.3s, loops:22, build_hash_table:{total:195.2µs, fetch:185.7µs, build:9.52µs}, probe:{concurrency:5, total:6.54s, max:1.31s, probe:116.4ms, fetch:6.42s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:43:59 [2021-05-26T20:43:59.075Z]   │ ├─TableReader_53(Build)	1.00	1	root		time:54.4µs, loops:2, cop_task: {num: 1, max: 979.9µs, proc_keys: 25, rpc_num: 1, rpc_time: 940.4µs, copr_cache: disabled}	data:Selection_52	240 Bytes	N/A
20:43:59 [2021-05-26T20:43:59.075Z]   │ │ └─Selection_52	1.00	1	cop[tikv]		tikv_task:{time:0s, loops:1}, scan_detail: {total_process_keys: 25, total_keys: 26, rocksdb: {delete_skipped_count: 0, key_skipped_count: 46, block: {cache_hit_count: 18, read_count: 0, read_byte: 0 Bytes}}}	eq(tpch50.nation.n_name, "ALGERIA")	N/A	N/A
20:43:59 [2021-05-26T20:43:59.075Z]   │ │   └─TableFullScan_51	25.00	25	cop[tikv]	table:nation	tikv_task:{time:0s, loops:1}	keep order:false	N/A	N/A
20:43:59 [2021-05-26T20:43:59.075Z]   │ └─TableReader_50(Probe)	500000.00	500000	root		time:1.28s, loops:490, cop_task: {num: 1, max: 1.29s, proc_keys: 500000, tot_proc: 1.21s, rpc_num: 1, rpc_time: 1.29s, copr_cache: disabled}	data:TableFullScan_49	35.8 MB	N/A
20:43:59 [2021-05-26T20:43:59.075Z]   │   └─TableFullScan_49	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:1.04s, loops:493}, scan_detail: {total_process_keys: 500000, total_keys: 500001, rocksdb: {delete_skipped_count: 0, key_skipped_count: 999999, block: {cache_hit_count: 1692, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:43:59 [2021-05-26T20:43:59.075Z]   └─HashAgg_54(Probe)	257492.04	223999	root		time:38.2s, loops:222, partial_worker:{wall_time:38.155107732s, concurrency:5, task_num:289, tot_wait:3m10.495010033s, tot_exec:218.934627ms, tot_time:3m10.76147599s, max:38.155025106s, p95:38.155025106s}, final_worker:{wall_time:38.223832923s, concurrency:5, task_num:25, tot_wait:3m10.748547002s, tot_exec:341.132679ms, tot_time:3m11.089693932s, max:38.22376462s, p95:38.22376462s}	group by:tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_suppkey)->tpch50.partsupp.ps_suppkey	61.4 MB	N/A
20:43:59 [2021-05-26T20:43:59.075Z]     └─Selection_55	257492.04	295898	root		time:38.1s, loops:290	gt(cast(tpch50.partsupp.ps_availqty, decimal(20,0) BINARY), mul(0.5, Column#44))	59.2 KB	N/A
20:43:59 [2021-05-26T20:43:59.075Z]       └─HashAgg_56	321865.05	435528	root		time:38s, loops:430, partial_worker:{wall_time:37.772585714s, concurrency:5, task_num:625, tot_wait:3m7.527453353s, tot_exec:1.214527151s, tot_time:3m8.854574909s, max:37.772454322s, p95:37.772454322s}, final_worker:{wall_time:38.141074608s, concurrency:5, task_num:25, tot_wait:3m8.841694761s, tot_exec:1.825356076s, tot_time:3m10.667068051s, max:38.140947235s, p95:38.140947235s}	group by:tpch50.partsupp.ps_partkey, tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_suppkey)->tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_availqty)->tpch50.partsupp.ps_availqty, funcs:sum(tpch50.lineitem.l_quantity)->Column#44	194.5 MB	N/A
20:43:59 [2021-05-26T20:43:59.075Z]         └─HashJoin_59	9711455.06	634004	root		time:37.7s, loops:626, build_hash_table:{total:2.73s, fetch:2.51s, build:224.2ms}, probe:{concurrency:5, total:3m8.4s, max:37.7s, probe:14.9s, fetch:2m53.5s}	left outer join, equal:[eq(tpch50.partsupp.ps_partkey, tpch50.lineitem.l_partkey) eq(tpch50.partsupp.ps_suppkey, tpch50.lineitem.l_suppkey)]	10.4 MB	0 Bytes
20:43:59 [2021-05-26T20:43:59.075Z]           ├─IndexHashJoin_67(Build)	321865.05	435528	root		time:2.68s, loops:429, inner:{total:3.08s, concurrency:5, task:12, construct:103.8ms, fetch:2.62s, build:29.8ms, join:352.4ms}	inner join, inner:IndexLookUp_64, outer key:tpch50.part.p_partkey, inner key:tpch50.partsupp.ps_partkey, equal cond:eq(tpch50.part.p_partkey, tpch50.partsupp.ps_partkey)	20.6 MB	N/A
20:43:59 [2021-05-26T20:43:59.075Z]           │ ├─TableReader_96(Build)	80007.93	108882	root		time:2.33s, loops:112, cop_task: {num: 20, max: 1.41s, min: 417.3ms, avg: 1.09s, p95: 1.41s, max_proc_keys: 686055, p95_proc_keys: 686055, tot_proc: 21.7s, tot_wait: 15ms, rpc_num: 20, rpc_time: 21.7s, copr_cache: disabled}	data:Selection_95	665.9 KB	N/A
20:43:59 [2021-05-26T20:43:59.075Z]           │ │ └─Selection_95	80007.93	108882	cop[tikv]		tikv_task:{proc max:1.4s, min:412ms, p80:1.21s, p95:1.4s, iters:9859, tasks:20}, scan_detail: {total_process_keys: 10000000, total_keys: 10000020, rocksdb: {delete_skipped_count: 0, key_skipped_count: 19999980, block: {cache_hit_count: 31499, read_count: 0, read_byte: 0 Bytes}}}	like(tpch50.part.p_name, "green%", 92)	N/A	N/A
20:43:59 [2021-05-26T20:43:59.075Z]           │ │   └─TableFullScan_94	10000000.00	10000000	cop[tikv]	table:part	tikv_task:{proc max:1.31s, min:369ms, p80:1.12s, p95:1.31s, iters:9859, tasks:20}	keep order:false	N/A	N/A
20:43:59 [2021-05-26T20:43:59.075Z]           │ └─IndexLookUp_64(Probe)	4.02	435528	root		time:2.53s, loops:447, index_task: {total_time: 1.41s, fetch_handle: 1.41s, build: 101.5µs, wait: 293.5µs}, table_task: {total_time: 9.54s, num: 56, concurrency: 60}		20.5 KB	N/A
20:43:59 [2021-05-26T20:43:59.075Z]           │   ├─IndexRangeScan_62(Build)	4.02	435528	cop[tikv]	table:partsupp, index:PRIMARY(PS_PARTKEY, PS_SUPPKEY)	time:1.36s, loops:475, cop_task: {num: 57, max: 258.9ms, min: 5.04ms, avg: 99.4ms, p95: 224.2ms, max_proc_keys: 15288, p95_proc_keys: 15048, tot_proc: 5.16s, tot_wait: 22ms, rpc_num: 57, rpc_time: 5.66s, copr_cache: disabled}, tikv_task:{proc max:235ms, min:4ms, p80:140ms, p95:210ms, iters:682, tasks:57}, scan_detail: {total_process_keys: 435528, total_keys: 544410, rocksdb: {delete_skipped_count: 0, key_skipped_count: 435528, block: {cache_hit_count: 980292, read_count: 0, read_byte: 0 Bytes}}}	range: decided by [eq(tpch50.partsupp.ps_partkey, tpch50.part.p_partkey)], keep order:false	N/A	N/A
20:43:59 [2021-05-26T20:43:59.075Z]           │   └─TableRowIDScan_63(Probe)	4.02	435528	cop[tikv]	table:partsupp	time:3.34s, loops:507, cop_task: {num: 1439, max: 78.7ms, min: 1.23ms, avg: 23ms, p95: 47.3ms, max_proc_keys: 984, p95_proc_keys: 588, tot_proc: 21.7s, tot_wait: 8.87s, rpc_num: 1439, rpc_time: 33s, copr_cache: disabled}, tikv_task:{proc max:42ms, min:0s, p80:17ms, p95:24ms, iters:5333, tasks:1439}, scan_detail: {total_process_keys: 435528, total_keys: 473503, rocksdb: {delete_skipped_count: 0, key_skipped_count: 194053, block: {cache_hit_count: 3644116, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:43:59 [2021-05-26T20:43:59.075Z]           └─TableReader_101(Probe)	46310896.67	45504356	root		time:32.9s, loops:44289, cop_task: {num: 761, max: 1.12s, min: 341.7ms, avg: 695.9ms, p95: 833.6ms, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 8m46.4s, tot_wait: 128ms, rpc_num: 761, rpc_time: 8m49.6s, copr_cache: disabled}	data:Selection_100	52.6 MB	N/A
20:43:59 [2021-05-26T20:43:59.075Z]             └─Selection_100	46310896.67	45504356	cop[tikv]		tikv_task:{proc max:1.08s, min:334ms, p80:738ms, p95:811ms, iters:296606, tasks:761}, scan_detail: {total_process_keys: 300005811, total_keys: 300006572, rocksdb: {delete_skipped_count: 0, key_skipped_count: 600010861, block: {cache_hit_count: 1124648, read_count: 0, read_byte: 0 Bytes}}}	ge(tpch50.lineitem.l_shipdate, 1993-01-01 00:00:00.000000), lt(tpch50.lineitem.l_shipdate, 1994-01-01)	N/A	N/A
20:43:59 [2021-05-26T20:43:59.075Z]               └─TableFullScan_99	300005811.00	300005811	cop[tikv]	table:lineitem	tikv_task:{proc max:1.03s, min:310ms, p80:706ms, p95:784ms, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:43:59 [2021-05-26T20:43:59.075Z] + sync
20:43:59 [2021-05-26T20:43:59.075Z] + /usr/bin/echo 3
20:44:41 [2021-05-26T20:44:41.914Z] + tiup cluster stop benchbot -y
20:44:41 [2021-05-26T20:44:41.914Z] Starting component `cluster`: /home/tidb/.tiup/components/cluster/v1.4.3/tiup-cluster stop benchbot -y
20:44:51 [2021-05-26T20:44:51.850Z] + rm -rf '/data1/tidb-deploy/*/log/*'
20:44:51 [2021-05-26T20:44:51.850Z] + rm -rf /data1/jenkins/deploy/data/tikv-20160
20:44:54 [2021-05-26T20:44:54.363Z] + rm -rf /data1/jenkins/deploy/data/pd-2379
20:44:54 [2021-05-26T20:44:54.363Z] + rm -rf /data1/jenkins/restore_data/tpch50/data/last_tikv.toml
20:44:54 [2021-05-26T20:44:54.363Z] + cp -R /data1/jenkins/restore_data/tpch50/data /data1/jenkins/deploy/data/tikv-20160
20:46:45 [2021-05-26T20:46:45.742Z] + cp -R /data1/jenkins/restore_data/tpch50/data.pd /data1/jenkins/deploy/data/pd-2379
20:46:45 [2021-05-26T20:46:45.742Z] + '[' -n '' ']'
20:46:45 [2021-05-26T20:46:45.742Z] + tiup cluster start benchbot --wait-timeout=300
20:46:45 [2021-05-26T20:46:45.742Z] Starting component `cluster`: /home/tidb/.tiup/components/cluster/v1.4.3/tiup-cluster start benchbot --wait-timeout=300
20:47:07 [2021-05-26T20:47:07.622Z] + sync
20:47:07 [2021-05-26T20:47:07.622Z] + /usr/bin/echo 3
20:48:44 [2021-05-26T20:48:44.001Z] 
20:48:44 [2021-05-26T20:48:44.001Z] queries/20.sql
20:48:44 [2021-05-26T20:48:44.001Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:48:44 [2021-05-26T20:48:44.001Z] Sort_30	20000.00	8982	root		time:38.1s, loops:10	tpch50.supplier.s_name	626.2 KB	0 Bytes
20:48:44 [2021-05-26T20:48:44.001Z] └─HashJoin_35	20000.00	8982	root		time:38.1s, loops:11, build_hash_table:{total:1.38s, fetch:1.37s, build:10.8ms}, probe:{concurrency:5, total:3m10.3s, max:38.1s, probe:62.8ms, fetch:3m10.2s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.partsupp.ps_suppkey)]	1.50 MB	0 Bytes
20:48:44 [2021-05-26T20:48:44.001Z]   ├─HashJoin_48(Build)	20000.00	19972	root		time:1.38s, loops:23, build_hash_table:{total:220.8µs, fetch:213.6µs, build:7.28µs}, probe:{concurrency:5, total:6.91s, max:1.38s, probe:101.2ms, fetch:6.81s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:48:44 [2021-05-26T20:48:44.001Z]   │ ├─TableReader_53(Build)	1.00	1	root		time:55.9µs, loops:2, cop_task: {num: 1, max: 885.1µs, proc_keys: 25, tot_proc: 1ms, rpc_num: 1, rpc_time: 849.8µs, copr_cache: disabled}	data:Selection_52	244 Bytes	N/A
20:48:44 [2021-05-26T20:48:44.001Z]   │ │ └─Selection_52	1.00	1	cop[tikv]		tikv_task:{time:1ms, loops:1}, scan_detail: {total_process_keys: 25, total_keys: 26, rocksdb: {delete_skipped_count: 0, key_skipped_count: 46, block: {cache_hit_count: 18, read_count: 0, read_byte: 0 Bytes}}}	eq(tpch50.nation.n_name, "ALGERIA")	N/A	N/A
20:48:44 [2021-05-26T20:48:44.001Z]   │ │   └─TableFullScan_51	25.00	25	cop[tikv]	table:nation	tikv_task:{time:1ms, loops:1}	keep order:false	N/A	N/A
20:48:44 [2021-05-26T20:48:44.001Z]   │ └─TableReader_50(Probe)	500000.00	500000	root		time:1.36s, loops:490, cop_task: {num: 1, max: 1.36s, proc_keys: 500000, tot_proc: 1.29s, rpc_num: 1, rpc_time: 1.36s, copr_cache: disabled}	data:TableFullScan_49	35.8 MB	N/A
20:48:44 [2021-05-26T20:48:44.001Z]   │   └─TableFullScan_49	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:1.12s, loops:493}, scan_detail: {total_process_keys: 500000, total_keys: 500001, rocksdb: {delete_skipped_count: 0, key_skipped_count: 999999, block: {cache_hit_count: 1692, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:48:44 [2021-05-26T20:48:44.001Z]   └─HashAgg_54(Probe)	257492.04	223999	root		time:38s, loops:222, partial_worker:{wall_time:37.939934063s, concurrency:5, task_num:289, tot_wait:3m9.474679226s, tot_exec:188.507204ms, tot_time:3m9.696689267s, max:37.939866059s, p95:37.939866059s}, final_worker:{wall_time:38.054013745s, concurrency:5, task_num:25, tot_wait:3m9.693864136s, tot_exec:560.889838ms, tot_time:3m10.254772424s, max:38.053964504s, p95:38.053964504s}	group by:tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_suppkey)->tpch50.partsupp.ps_suppkey	61.4 MB	N/A
20:48:44 [2021-05-26T20:48:44.001Z]     └─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:48:44 [2021-05-26T20:48:44.001Z]       └─HashAgg_56	321865.05	435528	root		time:37.8s, loops:430, partial_worker:{wall_time:37.583219458s, concurrency:5, task_num:625, tot_wait:3m6.653357978s, tot_exec:1.118439992s, tot_time:3m7.890188298s, max:37.58318677s, p95:37.58318677s}, final_worker:{wall_time:37.930515665s, concurrency:5, task_num:25, tot_wait:3m7.864366424s, tot_exec:1.768370187s, tot_time:3m9.632753873s, max:37.930489142s, p95:37.930489142s}	group by:tpch50.partsupp.ps_partkey, tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_suppkey)->tpch50.partsupp.ps_suppkey, funcs:firstrow(tpch50.partsupp.ps_availqty)->tpch50.partsupp.ps_availqty, funcs:sum(tpch50.lineitem.l_quantity)->Column#44	194.5 MB	N/A
20:48:44 [2021-05-26T20:48:44.001Z]         └─HashJoin_59	9711455.06	634004	root		time:37.5s, loops:626, build_hash_table:{total:2.55s, fetch:2.36s, build:191.4ms}, probe:{concurrency:5, total:3m7.5s, max:37.5s, probe:14.8s, fetch:2m52.7s}	left outer join, equal:[eq(tpch50.partsupp.ps_partkey, tpch50.lineitem.l_partkey) eq(tpch50.partsupp.ps_suppkey, tpch50.lineitem.l_suppkey)]	10.4 MB	0 Bytes
20:48:44 [2021-05-26T20:48:44.001Z]           ├─IndexHashJoin_67(Build)	321865.05	435528	root		time:2.5s, loops:430, inner:{total:2.84s, concurrency:5, task:12, construct:108.8ms, fetch:2.42s, build:26.4ms, join:307.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.5 MB	N/A
20:48:44 [2021-05-26T20:48:44.001Z]           │ ├─TableReader_96(Build)	80007.93	108882	root		time:2.16s, loops:112, cop_task: {num: 20, max: 1.44s, min: 552.8ms, avg: 1.08s, p95: 1.44s, max_proc_keys: 686055, p95_proc_keys: 686055, tot_proc: 21.6s, tot_wait: 3ms, rpc_num: 20, rpc_time: 21.6s, copr_cache: disabled}	data:Selection_95	725.8 KB	N/A
20:48:44 [2021-05-26T20:48:44.001Z]           │ │ └─Selection_95	80007.93	108882	cop[tikv]		tikv_task:{proc max:1.4s, min:548ms, p80:1.2s, p95:1.4s, iters:9859, tasks:20}, scan_detail: {total_process_keys: 10000000, total_keys: 10000020, rocksdb: {delete_skipped_count: 0, key_skipped_count: 19999980, block: {cache_hit_count: 31499, read_count: 0, read_byte: 0 Bytes}}}	like(tpch50.part.p_name, "green%", 92)	N/A	N/A
20:48:44 [2021-05-26T20:48:44.001Z]           │ │   └─TableFullScan_94	10000000.00	10000000	cop[tikv]	table:part	tikv_task:{proc max:1.28s, min:500ms, p80:1.1s, p95:1.28s, iters:9859, tasks:20}	keep order:false	N/A	N/A
20:48:44 [2021-05-26T20:48:44.001Z]           │ └─IndexLookUp_64(Probe)	4.02	435528	root		time:2.31s, loops:447, index_task: {total_time: 1.44s, fetch_handle: 1.44s, build: 94µs, wait: 269.7µs}, table_task: {total_time: 9.18s, num: 56, concurrency: 60}		20.5 KB	N/A
20:48:44 [2021-05-26T20:48:44.001Z]           │   ├─IndexRangeScan_62(Build)	4.02	435528	cop[tikv]	table:partsupp, index:PRIMARY(PS_PARTKEY, PS_SUPPKEY)	time:1.39s, loops:479, cop_task: {num: 58, max: 347.2ms, min: 6.03ms, avg: 100.6ms, p95: 209.7ms, max_proc_keys: 15288, p95_proc_keys: 15008, tot_proc: 5.2s, tot_wait: 23ms, rpc_num: 58, rpc_time: 5.83s, copr_cache: disabled}, tikv_task:{proc max:333ms, min:3ms, p80:147ms, p95:196ms, 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:48:44 [2021-05-26T20:48:44.001Z]           │   └─TableRowIDScan_63(Probe)	4.02	435528	cop[tikv]	table:partsupp	time:2.89s, loops:501, cop_task: {num: 1373, max: 88.9ms, min: 362.2µs, avg: 22.8ms, p95: 50ms, max_proc_keys: 976, p95_proc_keys: 636, tot_proc: 21.2s, tot_wait: 6.94s, rpc_num: 1373, rpc_time: 31.3s, copr_cache: disabled}, tikv_task:{proc max:43ms, min:0s, p80:18ms, p95:26ms, iters:5139, tasks:1373}, scan_detail: {total_process_keys: 435528, total_keys: 473521, rocksdb: {delete_skipped_count: 0, key_skipped_count: 194145, block: {cache_hit_count: 3643543, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:48:44 [2021-05-26T20:48:44.001Z]           └─TableReader_101(Probe)	46310896.67	45504356	root		time:32.9s, loops:44288, cop_task: {num: 761, max: 1.17s, min: 346.2ms, avg: 697ms, p95: 852.1ms, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 8m47.3s, tot_wait: 101ms, rpc_num: 761, rpc_time: 8m50.4s, copr_cache: disabled}	data:Selection_100	52.6 MB	N/A
20:48:44 [2021-05-26T20:48:44.001Z]             └─Selection_100	46310896.67	45504356	cop[tikv]		tikv_task:{proc max:1.14s, min:338ms, p80:741ms, p95:832ms, iters:296606, tasks:761}, scan_detail: {total_process_keys: 300005811, total_keys: 300006572, rocksdb: {delete_skipped_count: 0, key_skipped_count: 600010861, block: {cache_hit_count: 1124648, read_count: 0, read_byte: 0 Bytes}}}	ge(tpch50.lineitem.l_shipdate, 1993-01-01 00:00:00.000000), lt(tpch50.lineitem.l_shipdate, 1994-01-01)	N/A	N/A
20:48:44 [2021-05-26T20:48:44.001Z]               └─TableFullScan_99	300005811.00	300005811	cop[tikv]	table:lineitem	tikv_task:{proc max:1.11s, min:325ms, p80:709ms, p95:803ms, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:48:44 [2021-05-26T20:48:44.001Z] 
20:48:44 [2021-05-26T20:48:44.001Z] queries/21.sql
20:48:44 [2021-05-26T20:48:44.001Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:48:44 [2021-05-26T20:48:44.001Z] Projection_26	100.00	100	root		time:1m25s, loops:2, Concurrency:OFF	tpch50.supplier.s_name, Column#72	4.37 KB	N/A
20:48:44 [2021-05-26T20:48:44.001Z] └─TopN_29	100.00	100	root		time:1m25s, loops:2	Column#72:desc, tpch50.supplier.s_name, offset:0, count:100	58.3 KB	N/A
20:48:44 [2021-05-26T20:48:44.002Z]   └─HashAgg_34	12800.00	20057	root		time:1m25s, loops:21, partial_worker:{wall_time:1m24.980993402s, concurrency:5, task_num:197, tot_wait:7m4.628352294s, tot_exec:259.491225ms, tot_time:7m4.903304247s, max:1m24.980938401s, p95:1m24.980938401s}, final_worker:{wall_time:1m24.994760188s, concurrency:5, task_num:25, tot_wait:7m4.902011018s, tot_exec:70.677456ms, tot_time:7m4.972701634s, max:1m24.994723457s, p95:1m24.994723457s}	group by:tpch50.supplier.s_name, funcs:count(1)->Column#72, funcs:firstrow(tpch50.supplier.s_name)->tpch50.supplier.s_name	17.3 MB	N/A
20:48:44 [2021-05-26T20:48:44.002Z]     └─IndexHashJoin_42	7828961.66	198698	root		time:1m25s, loops:198, inner:{total:2m22.4s, concurrency:5, task:146, construct:6.56s, fetch:1m58.1s, build:1.16s, join:17.7s}	anti semi join, inner:IndexLookUp_39, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey)	641.1 MB	N/A
20:48:44 [2021-05-26T20:48:44.002Z]       ├─IndexHashJoin_83(Build)	9786202.08	3542799	root		time:1m24.4s, loops:3463, inner:{total:2m30.3s, concurrency:5, task:152, construct:7.87s, fetch:2m3.7s, build:1.25s, join:18.7s}	semi join, inner:IndexLookUp_80, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey), ne(tpch50.lineitem.l_suppkey, tpch50.supplier.s_suppkey)	555.9 MB	N/A
20:48:44 [2021-05-26T20:48:44.002Z]       │ ├─IndexJoin_99(Build)	12232752.60	3675878	root		time:1m23.9s, loops:3595, inner:{total:2m6.6s, concurrency:5, task:305, construct:16.5s, fetch:1m48.2s, build:1.84s}, probe:5.41s	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:48:44 [2021-05-26T20:48:44.002Z]       │ │ ├─HashJoin_107(Build)	12232752.60	7609895	root		time:1m23.3s, loops:7436, build_hash_table:{total:958.6ms, fetch:950.7ms, build:7.85ms}, probe:{concurrency:5, total:6m59.1s, max:1m23.8s, probe:1m4.3s, fetch:5m54.7s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.lineitem.l_suppkey)]	727.6 KB	0 Bytes
20:48:44 [2021-05-26T20:48:44.002Z]       │ │ │ ├─HashJoin_120(Build)	20000.00	20058	root		time:953.6ms, loops:22, build_hash_table:{total:400.5µs, fetch:191.4µs, build:209.1µs}, probe:{concurrency:5, total:4.78s, max:956.3ms, probe:65.6ms, fetch:4.72s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:48:44 [2021-05-26T20:48:44.002Z]       │ │ │ │ ├─TableReader_125(Build)	1.00	1	root		time:47µs, loops:2, cop_task: {num: 1, max: 859.3µs, proc_keys: 25, rpc_num: 1, rpc_time: 833.2µs, copr_cache: disabled}	data:Selection_124	234 Bytes	N/A
20:48:44 [2021-05-26T20:48:44.002Z]       │ │ │ │ │ └─Selection_124	1.00	1	cop[tikv]		tikv_task:{time:0s, loops:1}, scan_detail: {total_process_keys: 25, total_keys: 26, rocksdb: {delete_skipped_count: 0, key_skipped_count: 46, block: {cache_hit_count: 18, read_count: 0, read_byte: 0 Bytes}}}	eq(tpch50.nation.n_name, "EGYPT")	N/A	N/A
20:48:44 [2021-05-26T20:48:44.002Z]       │ │ │ │ │   └─TableFullScan_123	25.00	25	cop[tikv]	table:nation	tikv_task:{time:0s, loops:1}	keep order:false	N/A	N/A
20:48:44 [2021-05-26T20:48:44.002Z]       │ │ │ │ └─TableReader_122(Probe)	500000.00	500000	root		time:943ms, loops:490, cop_task: {num: 1, max: 1.06s, proc_keys: 500000, tot_proc: 1.03s, rpc_num: 1, rpc_time: 1.06s, copr_cache: disabled}	data:TableFullScan_121	20.0 MB	N/A
20:48:44 [2021-05-26T20:48:44.002Z]       │ │ │ │   └─TableFullScan_121	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:981ms, loops:493}, scan_detail: {total_process_keys: 500000, total_keys: 500001, rocksdb: {delete_skipped_count: 0, key_skipped_count: 999999, block: {cache_hit_count: 15, read_count: 1689, read_byte: 108.5 MB}}}	keep order:false	N/A	N/A
20:48:44 [2021-05-26T20:48:44.002Z]       │ │ │ └─TableReader_128(Probe)	240004648.80	189670348	root		time:1m10.7s, loops:184597, cop_task: {num: 761, max: 2.94s, min: 309.6ms, avg: 1.61s, p95: 2.09s, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 19m12.9s, tot_wait: 56.5s, rpc_num: 761, rpc_time: 20m23.7s, copr_cache: disabled}	data:Selection_127	109.4 MB	N/A
20:48:44 [2021-05-26T20:48:44.002Z]       │ │ │   └─Selection_127	240004648.80	189670348	cop[tikv]		tikv_task:{proc max:1.44s, min:294ms, p80:1.28s, p95:1.34s, 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: 18673, read_count: 1131798, read_byte: 23.9 GB}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:48:44 [2021-05-26T20:48:44.002Z]       │ │ │     └─TableFullScan_126	300005811.00	300005811	cop[tikv]	table:l1	tikv_task:{proc max:1.37s, min:276ms, p80:1.2s, p95:1.26s, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:48:44 [2021-05-26T20:48:44.002Z]       │ │ └─TableReader_95(Probe)	0.49	3496176	root		time:1m39s, loops:3875, cop_task: {num: 5238, max: 579.1ms, min: 2.06ms, avg: 179ms, p95: 339.6ms, max_proc_keys: 3568, p95_proc_keys: 1956, tot_proc: 11m13.8s, tot_wait: 3m34.3s, rpc_num: 5238, rpc_time: 15m37.3s, copr_cache: disabled}	data:Selection_94	N/A	N/A
20:48:44 [2021-05-26T20:48:44.002Z]       │ │   └─Selection_94	0.49	3496176	cop[tikv]		tikv_task:{proc max:156ms, min:0s, p80:72ms, p95:85ms, iters:30136, tasks:5238}, scan_detail: {total_process_keys: 7236272, total_keys: 7795481, rocksdb: {delete_skipped_count: 0, key_skipped_count: 1778317, block: {cache_hit_count: 54006630, read_count: 220136, read_byte: 4.60 GB}}}	eq(tpch50.orders.o_orderstatus, "F")	N/A	N/A
20:48:44 [2021-05-26T20:48:44.002Z]       │ │     └─TableRangeScan_93	1.00	7236272	cop[tikv]	table:orders	tikv_task:{proc max:156ms, min:0s, p80:72ms, p95:85ms, iters:30136, tasks:5238}	range: decided by [tpch50.lineitem.l_orderkey], keep order:false	N/A	N/A
20:48:44 [2021-05-26T20:48:44.002Z]       │ └─IndexLookUp_80(Probe)	4.05	17316584	root		time:1m58.2s, loops:17132, index_task: {total_time: 1m5.3s, fetch_handle: 57.8s, build: 3.2ms, wait: 7.48s}, table_task: {total_time: 8m26.5s, num: 1458, concurrency: 760}		19.4 KB	N/A
20:48:44 [2021-05-26T20:48:44.002Z]       │   ├─IndexRangeScan_78(Build)	4.05	17316584	cop[tikv]	table:l2, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:55.6s, loops:18618, cop_task: {num: 2988, max: 739.7ms, min: 675.2µs, avg: 189.3ms, p95: 373.1ms, max_proc_keys: 12508, p95_proc_keys: 8796, tot_proc: 7m6.6s, tot_wait: 1m53.5s, rpc_num: 2988, rpc_time: 9m25.5s, copr_cache: disabled}, tikv_task:{proc max:189ms, min:0s, p80:103ms, p95:120ms, iters:30120, tasks:2988}, scan_detail: {total_process_keys: 17316584, total_keys: 20812707, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17316584, block: {cache_hit_count: 24260331, read_count: 226865, read_byte: 2.40 GB}}}	range: decided by [eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey)], keep order:false	N/A	N/A
20:48:44 [2021-05-26T20:48:44.002Z]       │   └─TableRowIDScan_79(Probe)	4.05	17316584	cop[tikv]	table:l2	time:6m11.5s, loops:20979, cop_task: {num: 7773, max: 654.1ms, min: 479.2µs, avg: 175.3ms, p95: 356ms, max_proc_keys: 12919, p95_proc_keys: 4850, tot_proc: 16m16.4s, tot_wait: 5m26.8s, rpc_num: 7773, rpc_time: 22m42s, copr_cache: disabled}, tikv_task:{proc max:258ms, min:0s, p80:106ms, p95:142ms, iters:49935, tasks:7773}, scan_detail: {total_process_keys: 17316584, total_keys: 18289388, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5626402, block: {cache_hit_count: 99027627, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
20:48:44 [2021-05-26T20:48:44.002Z]       └─IndexLookUp_39(Probe)	4.05	12022883	root		time:1m53s, loops:11946, index_task: {total_time: 1m2.3s, fetch_handle: 54s, build: 4.42ms, wait: 8.32s}, table_task: {total_time: 8m6.5s, num: 1408, concurrency: 730}		218.3 KB	N/A
20:48:44 [2021-05-26T20:48:44.002Z]         ├─IndexRangeScan_36(Build)	5.06	17183516	cop[tikv]	table:l3, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:51.6s, loops:18377, cop_task: {num: 2789, max: 796.9ms, min: 550.1µs, avg: 175.6ms, p95: 383.9ms, max_proc_keys: 18129, p95_proc_keys: 13358, tot_proc: 6m8.9s, tot_wait: 1m37s, rpc_num: 2789, rpc_time: 8m9.7s, copr_cache: disabled}, tikv_task:{proc max:183ms, min:0s, p80:84ms, p95:124ms, iters:29146, tasks:2789}, scan_detail: {total_process_keys: 17183516, total_keys: 20546564, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17183516, block: {cache_hit_count: 23554142, read_count: 0, read_byte: 0 Bytes}}}	range: decided by [eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey)], keep order:false	N/A	N/A
20:48:44 [2021-05-26T20:48:44.002Z]         └─Selection_38(Probe)	4.05	12022883	cop[tikv]		time:6m10.5s, loops:13772, cop_task: {num: 10151, max: 655.1ms, min: 552.9µs, avg: 172.2ms, p95: 349.8ms, max_proc_keys: 6748, p95_proc_keys: 4004, tot_proc: 20m23.1s, tot_wait: 7m24.7s, rpc_num: 10151, rpc_time: 29m7.2s, copr_cache: disabled}, tikv_task:{proc max:327ms, min:0s, p80:78ms, p95:118ms, iters:60255, tasks:10151}, scan_detail: {total_process_keys: 17183516, total_keys: 18129573, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5528789, block: {cache_hit_count: 98285495, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:48:44 [2021-05-26T20:48:44.002Z]           └─TableRowIDScan_37	5.06	17183516	cop[tikv]	table:l3	tikv_task:{proc max:324ms, min:0s, p80:77ms, p95:117ms, iters:60255, tasks:10151}	keep order:false	N/A	N/A
20:48:44 [2021-05-26T20:48:44.002Z] + sync
20:48:44 [2021-05-26T20:48:44.002Z] + /usr/bin/echo 3
20:50:20 [2021-05-26T20:50:20.380Z] 
20:50:20 [2021-05-26T20:50:20.380Z] queries/21.sql
20:50:20 [2021-05-26T20:50:20.380Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:50:20 [2021-05-26T20:50:20.380Z] Projection_26	100.00	100	root		time:1m22.9s, loops:2, Concurrency:OFF	tpch50.supplier.s_name, Column#72	4.37 KB	N/A
20:50:20 [2021-05-26T20:50:20.380Z] └─TopN_29	100.00	100	root		time:1m22.9s, loops:2	Column#72:desc, tpch50.supplier.s_name, offset:0, count:100	58.3 KB	N/A
20:50:20 [2021-05-26T20:50:20.380Z]   └─HashAgg_34	12800.00	20057	root		time:1m22.9s, loops:21, partial_worker:{wall_time:1m22.875507645s, concurrency:5, task_num:196, tot_wait:6m54.082855171s, tot_exec:280.707043ms, tot_time:6m54.376627981s, max:1m22.875470044s, p95:1m22.875470044s}, final_worker:{wall_time:1m22.888153976s, concurrency:5, task_num:25, tot_wait:6m54.376267865s, tot_exec:63.623127ms, tot_time:6m54.439903568s, max:1m22.888128134s, p95:1m22.888128134s}	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:50:20 [2021-05-26T20:50:20.380Z]     └─IndexHashJoin_42	7828961.66	198698	root		time:1m22.9s, loops:197, inner:{total:2m20s, concurrency:5, task:147, construct:6.06s, fetch:1m56.8s, build:1.19s, join:17.1s}	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:50:20 [2021-05-26T20:50:20.380Z]       ├─IndexHashJoin_83(Build)	9786202.08	3542799	root		time:1m22.3s, loops:3463, inner:{total:2m27.4s, concurrency:5, task:152, construct:7.52s, fetch:2m1.4s, build:1.23s, 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:50:20 [2021-05-26T20:50:20.380Z]       │ ├─IndexJoin_99(Build)	12232752.60	3675878	root		time:1m21.6s, loops:3595, inner:{total:2m4.6s, concurrency:5, task:305, construct:16.1s, fetch:1m46.6s, build:1.91s}, probe:5.13s	inner join, inner:TableReader_95, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.orders.o_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.orders.o_orderkey)	581.9 MB	N/A
20:50:20 [2021-05-26T20:50:20.380Z]       │ │ ├─HashJoin_107(Build)	12232752.60	7609895	root		time:1m21.2s, loops:7437, build_hash_table:{total:1.13s, fetch:1.13s, build:6.15ms}, probe:{concurrency:5, total:6m48.2s, max:1m21.6s, probe:1m1.7s, fetch:5m46.5s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.lineitem.l_suppkey)]	727.6 KB	0 Bytes
20:50:20 [2021-05-26T20:50:20.380Z]       │ │ │ ├─HashJoin_120(Build)	20000.00	20058	root		time:1.13s, loops:22, build_hash_table:{total:259.8µs, fetch:252.9µs, build:6.91µs}, probe:{concurrency:5, total:5.65s, max:1.13s, probe:59.2ms, fetch:5.59s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:50:20 [2021-05-26T20:50:20.380Z]       │ │ │ │ ├─TableReader_125(Build)	1.00	1	root		time:56.7µs, loops:2, cop_task: {num: 1, max: 1.37ms, proc_keys: 25, tot_proc: 1ms, rpc_num: 1, rpc_time: 1.34ms, copr_cache: disabled}	data:Selection_124	248 Bytes	N/A
20:50:20 [2021-05-26T20:50:20.380Z]       │ │ │ │ │ └─Selection_124	1.00	1	cop[tikv]		tikv_task:{time:1ms, loops:1}, scan_detail: {total_process_keys: 25, total_keys: 26, rocksdb: {delete_skipped_count: 0, key_skipped_count: 46, block: {cache_hit_count: 17, read_count: 1, read_byte: 23.8 KB}}}	eq(tpch50.nation.n_name, "EGYPT")	N/A	N/A
20:50:20 [2021-05-26T20:50:20.380Z]       │ │ │ │ │   └─TableFullScan_123	25.00	25	cop[tikv]	table:nation	tikv_task:{time:1ms, loops:1}	keep order:false	N/A	N/A
20:50:20 [2021-05-26T20:50:20.380Z]       │ │ │ │ └─TableReader_122(Probe)	500000.00	500000	root		time:1.12s, loops:490, cop_task: {num: 1, max: 1.12s, proc_keys: 500000, tot_proc: 1.08s, rpc_num: 1, rpc_time: 1.12s, copr_cache: disabled}	data:TableFullScan_121	20.0 MB	N/A
20:50:20 [2021-05-26T20:50:20.380Z]       │ │ │ │   └─TableFullScan_121	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:1.01s, loops:493}, scan_detail: {total_process_keys: 500000, total_keys: 500001, rocksdb: {delete_skipped_count: 0, key_skipped_count: 999999, block: {cache_hit_count: 13, read_count: 1679, read_byte: 104.5 MB}}}	keep order:false	N/A	N/A
20:50:20 [2021-05-26T20:50:20.380Z]       │ │ │ └─TableReader_128(Probe)	240004648.80	189670348	root		time:1m8.8s, loops:184596, cop_task: {num: 761, max: 2.78s, min: 279.6ms, avg: 1.57s, p95: 2.03s, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 18m42.3s, tot_wait: 56.7s, rpc_num: 761, rpc_time: 19m53.6s, copr_cache: disabled}	data:Selection_127	109.4 MB	N/A
20:50:20 [2021-05-26T20:50:20.380Z]       │ │ │   └─Selection_127	240004648.80	189670348	cop[tikv]		tikv_task:{proc max:1.37s, min:266ms, p80:1.24s, p95:1.29s, 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:50:20 [2021-05-26T20:50:20.380Z]       │ │ │     └─TableFullScan_126	300005811.00	300005811	cop[tikv]	table:l1	tikv_task:{proc max:1.29s, min:255ms, p80:1.16s, p95:1.21s, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:50:20 [2021-05-26T20:50:20.380Z]       │ │ └─TableReader_95(Probe)	0.49	3496171	root		time:1m37.6s, loops:3875, cop_task: {num: 5269, max: 527.4ms, min: 1.65ms, avg: 175.7ms, p95: 338.6ms, max_proc_keys: 4705, p95_proc_keys: 1950, tot_proc: 10m59s, tot_wait: 3m37.1s, rpc_num: 5269, rpc_time: 15m25.7s, copr_cache: disabled}	data:Selection_94	N/A	N/A
20:50:20 [2021-05-26T20:50:20.380Z]       │ │   └─Selection_94	0.49	3496171	cop[tikv]		tikv_task:{proc max:166ms, min:0s, p80:69ms, p95:82ms, iters:30242, tasks:5269}, scan_detail: {total_process_keys: 7236259, total_keys: 7795478, rocksdb: {delete_skipped_count: 0, key_skipped_count: 1778303, block: {cache_hit_count: 54006214, read_count: 218299, read_byte: 4.22 GB}}}	eq(tpch50.orders.o_orderstatus, "F")	N/A	N/A
20:50:20 [2021-05-26T20:50:20.380Z]       │ │     └─TableRangeScan_93	1.00	7236259	cop[tikv]	table:orders	tikv_task:{proc max:165ms, min:0s, p80:69ms, p95:82ms, iters:30242, tasks:5269}	range: decided by [tpch50.lineitem.l_orderkey], keep order:false	N/A	N/A
20:50:20 [2021-05-26T20:50:20.380Z]       │ └─IndexLookUp_80(Probe)	4.05	17316455	root		time:1m55.9s, loops:17133, index_task: {total_time: 1m4.2s, fetch_handle: 56s, build: 3.02ms, wait: 8.15s}, table_task: {total_time: 8m21.2s, num: 1458, concurrency: 760}		19.0 KB	N/A
20:50:20 [2021-05-26T20:50:20.380Z]       │   ├─IndexRangeScan_78(Build)	4.05	17316455	cop[tikv]	table:l2, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:53.7s, loops:18624, cop_task: {num: 2997, max: 748.4ms, min: 477.3µs, avg: 184.4ms, p95: 376.7ms, max_proc_keys: 16125, p95_proc_keys: 8714, tot_proc: 6m55.2s, tot_wait: 1m52s, rpc_num: 2997, rpc_time: 9m12.6s, copr_cache: disabled}, tikv_task:{proc max:207ms, min:0s, p80:100ms, p95:116ms, iters:30106, tasks:2997}, scan_detail: {total_process_keys: 17316455, total_keys: 20812558, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17316455, block: {cache_hit_count: 24259968, read_count: 225681, read_byte: 2.00 GB}}}	range: decided by [eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey)], keep order:false	N/A	N/A
20:50:20 [2021-05-26T20:50:20.380Z]       │   └─TableRowIDScan_79(Probe)	4.05	17316455	cop[tikv]	table:l2	time:6m10.2s, loops:20984, cop_task: {num: 7768, max: 596.8ms, min: 591.1µs, avg: 174.1ms, p95: 351.5ms, max_proc_keys: 10626, p95_proc_keys: 4883, tot_proc: 16m7.3s, tot_wait: 5m24.2s, rpc_num: 7768, rpc_time: 22m32.3s, copr_cache: disabled}, tikv_task:{proc max:298ms, min:0s, p80:105ms, p95:140ms, iters:49888, tasks:7768}, scan_detail: {total_process_keys: 17316455, total_keys: 18290637, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5634730, block: {cache_hit_count: 99010878, read_count: 1110, read_byte: 394.6 MB}}}	keep order:false	N/A	N/A
20:50:20 [2021-05-26T20:50:20.380Z]       └─IndexLookUp_39(Probe)	4.05	12022811	root		time:1m51.8s, loops:11945, index_task: {total_time: 59s, fetch_handle: 49.5s, build: 3.02ms, wait: 9.53s}, table_task: {total_time: 8m0.4s, num: 1411, concurrency: 735}		212.2 KB	N/A
20:50:20 [2021-05-26T20:50:20.380Z]         ├─IndexRangeScan_36(Build)	5.06	17183397	cop[tikv]	table:l3, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:47.1s, loops:18355, cop_task: {num: 2772, max: 727.3ms, min: 505.9µs, avg: 168ms, p95: 360.8ms, max_proc_keys: 18290, p95_proc_keys: 13857, tot_proc: 5m47s, tot_wait: 1m34s, rpc_num: 2772, rpc_time: 7m45.7s, copr_cache: disabled}, tikv_task:{proc max:197ms, min:0s, p80:84ms, p95:129ms, iters:28999, tasks:2772}, scan_detail: {total_process_keys: 17183397, total_keys: 20546424, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17183397, block: {cache_hit_count: 23553996, read_count: 0, read_byte: 0 Bytes}}}	range: decided by [eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey)], keep order:false	N/A	N/A
20:50:20 [2021-05-26T20:50:20.380Z]         └─Selection_38(Probe)	4.05	12022811	cop[tikv]		time:6m6.5s, loops:13782, cop_task: {num: 10214, max: 574.7ms, min: 535µs, avg: 171.3ms, p95: 346.4ms, max_proc_keys: 8247, p95_proc_keys: 3918, tot_proc: 20m17.2s, tot_wait: 7m31.9s, rpc_num: 10214, rpc_time: 29m9.4s, copr_cache: disabled}, tikv_task:{proc max:214ms, min:0s, p80:76ms, p95:114ms, iters:60760, tasks:10214}, scan_detail: {total_process_keys: 17183397, total_keys: 18128399, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5524520, block: {cache_hit_count: 98290766, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:50:20 [2021-05-26T20:50:20.380Z]           └─TableRowIDScan_37	5.06	17183397	cop[tikv]	table:l3	tikv_task:{proc max:211ms, min:0s, p80:76ms, p95:114ms, iters:60760, tasks:10214}	keep order:false	N/A	N/A
20:50:20 [2021-05-26T20:50:20.380Z] + sync
20:50:20 [2021-05-26T20:50:20.380Z] + /usr/bin/echo 3
20:51:41 [2021-05-26T20:51:41.760Z] 
20:51:41 [2021-05-26T20:51:41.760Z] queries/21.sql
20:51:41 [2021-05-26T20:51:41.760Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:51:41 [2021-05-26T20:51:41.760Z] 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:51:41 [2021-05-26T20:51:41.761Z] └─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:51:41 [2021-05-26T20:51:41.761Z]   └─HashAgg_34	12800.00	20057	root		time:1m23.3s, loops:21, partial_worker:{wall_time:1m23.260334689s, concurrency:5, task_num:198, tot_wait:6m56.009905213s, tot_exec:255.441117ms, tot_time:6m56.282541872s, max:1m23.260313316s, p95:1m23.260313316s}, final_worker:{wall_time:1m23.282647492s, concurrency:5, task_num:25, tot_wait:6m56.277346574s, tot_exec:122.383132ms, tot_time:6m56.399744229s, max:1m23.282626387s, p95:1m23.282626387s}	group by:tpch50.supplier.s_name, funcs:count(1)->Column#72, funcs:firstrow(tpch50.supplier.s_name)->tpch50.supplier.s_name	17.3 MB	N/A
20:51:41 [2021-05-26T20:51:41.761Z]     └─IndexHashJoin_42	7828961.66	198698	root		time:1m23.3s, loops:199, inner:{total:2m17.1s, concurrency:5, task:146, construct:6.19s, fetch:1m54s, build:1.19s, join:16.9s}	anti semi join, inner:IndexLookUp_39, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey)	641.1 MB	N/A
20:51:41 [2021-05-26T20:51:41.761Z]       ├─IndexHashJoin_83(Build)	9786202.08	3542799	root		time:1m22.7s, loops:3463, inner:{total:2m24.3s, concurrency:5, task:152, construct:7.62s, fetch:1m58.6s, build:1.31s, join:18s}	semi join, inner:IndexLookUp_80, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey), ne(tpch50.lineitem.l_suppkey, tpch50.supplier.s_suppkey)	555.9 MB	N/A
20:51:41 [2021-05-26T20:51:41.761Z]       │ ├─IndexJoin_99(Build)	12232752.60	3675878	root		time:1m22.1s, loops:3595, inner:{total:2m4.5s, concurrency:5, task:305, construct:16.3s, fetch:1m46.4s, build:1.87s}, probe:5.15s	inner join, inner:TableReader_95, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.orders.o_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.orders.o_orderkey)	582.0 MB	N/A
20:51:41 [2021-05-26T20:51:41.761Z]       │ │ ├─HashJoin_107(Build)	12232752.60	7609895	root		time:1m21.5s, loops:7436, build_hash_table:{total:1.15s, fetch:1.14s, build:6.55ms}, probe:{concurrency:5, total:6m50.2s, max:1m22s, probe:1m3s, fetch:5m47.2s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.lineitem.l_suppkey)]	727.6 KB	0 Bytes
20:51:41 [2021-05-26T20:51:41.761Z]       │ │ │ ├─HashJoin_120(Build)	20000.00	20058	root		time:1.14s, loops:22, build_hash_table:{total:200.4µs, fetch:195.2µs, build:5.25µs}, probe:{concurrency:5, total:5.72s, max:1.14s, probe:59.1ms, fetch:5.66s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:51:41 [2021-05-26T20:51:41.761Z]       │ │ │ │ ├─TableReader_125(Build)	1.00	1	root		time:68.5µs, loops:2, cop_task: {num: 1, max: 1.41ms, proc_keys: 25, rpc_num: 1, rpc_time: 1.37ms, copr_cache: disabled}	data:Selection_124	240 Bytes	N/A
20:51:41 [2021-05-26T20:51:41.761Z]       │ │ │ │ │ └─Selection_124	1.00	1	cop[tikv]		tikv_task:{time:0s, loops:1}, scan_detail: {total_process_keys: 25, total_keys: 26, rocksdb: {delete_skipped_count: 0, key_skipped_count: 46, block: {cache_hit_count: 17, read_count: 1, read_byte: 23.8 KB}}}	eq(tpch50.nation.n_name, "EGYPT")	N/A	N/A
20:51:41 [2021-05-26T20:51:41.761Z]       │ │ │ │ │   └─TableFullScan_123	25.00	25	cop[tikv]	table:nation	tikv_task:{time:0s, loops:1}	keep order:false	N/A	N/A
20:51:41 [2021-05-26T20:51:41.761Z]       │ │ │ │ └─TableReader_122(Probe)	500000.00	500000	root		time:1.13s, loops:490, cop_task: {num: 1, max: 1.13s, proc_keys: 500000, tot_proc: 1.1s, rpc_num: 1, rpc_time: 1.13s, copr_cache: disabled}	data:TableFullScan_121	20.0 MB	N/A
20:51:41 [2021-05-26T20:51:41.761Z]       │ │ │ │   └─TableFullScan_121	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:1.02s, loops:493}, scan_detail: {total_process_keys: 500000, total_keys: 500001, rocksdb: {delete_skipped_count: 0, key_skipped_count: 999999, block: {cache_hit_count: 13, read_count: 1679, read_byte: 104.5 MB}}}	keep order:false	N/A	N/A
20:51:41 [2021-05-26T20:51:41.761Z]       │ │ │ └─TableReader_128(Probe)	240004648.80	189670348	root		time:1m8.8s, loops:184596, cop_task: {num: 761, max: 2.61s, min: 290.3ms, avg: 1.58s, p95: 2.02s, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 18m46.7s, tot_wait: 57.8s, rpc_num: 761, rpc_time: 19m58.9s, copr_cache: disabled}	data:Selection_127	109.4 MB	N/A
20:51:41 [2021-05-26T20:51:41.761Z]       │ │ │   └─Selection_127	240004648.80	189670348	cop[tikv]		tikv_task:{proc max:1.42s, min:278ms, p80:1.25s, p95:1.29s, iters:296606, tasks:761}, scan_detail: {total_process_keys: 300005811, total_keys: 300006572, rocksdb: {delete_skipped_count: 0, key_skipped_count: 600010861, block: {cache_hit_count: 10456, read_count: 1114192, read_byte: 23.6 GB}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:51:41 [2021-05-26T20:51:41.761Z]       │ │ │     └─TableFullScan_126	300005811.00	300005811	cop[tikv]	table:l1	tikv_task:{proc max:1.34s, min:261ms, p80:1.16s, p95:1.21s, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:51:41 [2021-05-26T20:51:41.761Z]       │ │ └─TableReader_95(Probe)	0.49	3496190	root		time:1m37.4s, loops:3875, cop_task: {num: 5252, max: 518.2ms, min: 1.44ms, avg: 174ms, p95: 332.9ms, max_proc_keys: 3932, p95_proc_keys: 1956, tot_proc: 10m51.2s, tot_wait: 3m33.9s, rpc_num: 5252, rpc_time: 15m13.8s, copr_cache: disabled}	data:Selection_94	N/A	N/A
20:51:41 [2021-05-26T20:51:41.761Z]       │ │   └─Selection_94	0.49	3496190	cop[tikv]		tikv_task:{proc max:161ms, min:0s, p80:70ms, p95:83ms, iters:30178, tasks:5252}, scan_detail: {total_process_keys: 7236301, total_keys: 7795559, rocksdb: {delete_skipped_count: 0, key_skipped_count: 1778420, block: {cache_hit_count: 54006736, read_count: 218257, read_byte: 4.21 GB}}}	eq(tpch50.orders.o_orderstatus, "F")	N/A	N/A
20:51:41 [2021-05-26T20:51:41.761Z]       │ │     └─TableRangeScan_93	1.00	7236301	cop[tikv]	table:orders	tikv_task:{proc max:161ms, min:0s, p80:69ms, p95:82ms, iters:30178, tasks:5252}	range: decided by [tpch50.lineitem.l_orderkey], keep order:false	N/A	N/A
20:51:41 [2021-05-26T20:51:41.761Z]       │ └─IndexLookUp_80(Probe)	4.05	17316465	root		time:1m53.2s, loops:17129, index_task: {total_time: 1m2.6s, fetch_handle: 53.7s, build: 3.11ms, wait: 8.96s}, table_task: {total_time: 8m11.7s, num: 1458, concurrency: 760}		19.2 KB	N/A
20:51:41 [2021-05-26T20:51:41.761Z]       │   ├─IndexRangeScan_78(Build)	4.05	17316465	cop[tikv]	table:l2, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:51.2s, loops:18629, cop_task: {num: 2973, max: 740.1ms, min: 479.7µs, avg: 182.5ms, p95: 359.3ms, max_proc_keys: 14438, p95_proc_keys: 8759, tot_proc: 6m49.4s, tot_wait: 1m47.5s, rpc_num: 2973, rpc_time: 9m2.6s, copr_cache: disabled}, tikv_task:{proc max:183ms, min:0s, p80:101ms, p95:116ms, iters:30095, tasks:2973}, scan_detail: {total_process_keys: 17316465, total_keys: 20812570, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17316465, block: {cache_hit_count: 24259984, 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:51:41 [2021-05-26T20:51:41.761Z]       │   └─TableRowIDScan_79(Probe)	4.05	17316465	cop[tikv]	table:l2	time:6m1.4s, loops:21002, cop_task: {num: 7758, max: 569.6ms, min: 423.3µs, avg: 172.2ms, p95: 341.6ms, max_proc_keys: 11834, p95_proc_keys: 4842, tot_proc: 15m55.2s, tot_wait: 5m20.3s, rpc_num: 7758, rpc_time: 22m15.8s, copr_cache: disabled}, tikv_task:{proc max:254ms, min:0s, p80:104ms, p95:140ms, iters:49872, tasks:7758}, scan_detail: {total_process_keys: 17316465, total_keys: 18289202, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5626095, block: {cache_hit_count: 99023400, read_count: 1112, read_byte: 396.9 MB}}}	keep order:false	N/A	N/A
20:51:41 [2021-05-26T20:51:41.761Z]       └─IndexLookUp_39(Probe)	4.05	12022792	root		time:1m49.2s, loops:11948, index_task: {total_time: 59.3s, fetch_handle: 47.6s, build: 3.15ms, wait: 11.7s}, table_task: {total_time: 7m52.7s, num: 1408, concurrency: 730}		267.2 KB	N/A
20:51:41 [2021-05-26T20:51:41.761Z]         ├─IndexRangeScan_36(Build)	5.06	17183374	cop[tikv]	table:l3, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:45.2s, loops:18329, cop_task: {num: 2760, max: 725.7ms, min: 1.01ms, avg: 162.9ms, p95: 350.5ms, max_proc_keys: 21124, p95_proc_keys: 13790, tot_proc: 5m36.9s, tot_wait: 1m27.1s, rpc_num: 2760, rpc_time: 7m29.6s, copr_cache: disabled}, tikv_task:{proc max:196ms, min:0s, p80:83ms, p95:128ms, iters:28991, tasks:2760}, scan_detail: {total_process_keys: 17183374, total_keys: 20546399, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17183374, block: {cache_hit_count: 23553981, read_count: 0, read_byte: 0 Bytes}}}	range: decided by [eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey)], keep order:false	N/A	N/A
20:51:41 [2021-05-26T20:51:41.761Z]         └─Selection_38(Probe)	4.05	12022792	cop[tikv]		time:6m0.4s, loops:13777, cop_task: {num: 10167, max: 582.1ms, min: 428µs, avg: 167.4ms, p95: 336.1ms, max_proc_keys: 6915, p95_proc_keys: 3971, tot_proc: 19m51.3s, tot_wait: 7m9.4s, rpc_num: 10167, rpc_time: 28m21.2s, copr_cache: disabled}, tikv_task:{proc max:209ms, min:0s, p80:77ms, p95:116ms, iters:60500, tasks:10167}, scan_detail: {total_process_keys: 17183374, total_keys: 18130017, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5527825, block: {cache_hit_count: 98292009, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:51:41 [2021-05-26T20:51:41.761Z]           └─TableRowIDScan_37	5.06	17183374	cop[tikv]	table:l3	tikv_task:{proc max:208ms, min:0s, p80:76ms, p95:116ms, iters:60500, tasks:10167}	keep order:false	N/A	N/A
20:51:41 [2021-05-26T20:51:41.761Z] + sync
20:51:41 [2021-05-26T20:51:41.761Z] + /usr/bin/echo 3
20:53:03 [2021-05-26T20:53:03.145Z] 
20:53:03 [2021-05-26T20:53:03.145Z] queries/21.sql
20:53:03 [2021-05-26T20:53:03.145Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:53:03 [2021-05-26T20:53:03.145Z] Projection_26	100.00	100	root		time:1m23.6s, loops:2, Concurrency:OFF	tpch50.supplier.s_name, Column#72	4.37 KB	N/A
20:53:03 [2021-05-26T20:53:03.145Z] └─TopN_29	100.00	100	root		time:1m23.6s, loops:2	Column#72:desc, tpch50.supplier.s_name, offset:0, count:100	58.3 KB	N/A
20:53:03 [2021-05-26T20:53:03.145Z]   └─HashAgg_34	12800.00	20057	root		time:1m23.6s, loops:21, partial_worker:{wall_time:1m23.54055845s, concurrency:5, task_num:195, tot_wait:6m57.43113203s, tot_exec:254.594346ms, tot_time:6m57.699810257s, max:1m23.540485989s, p95:1m23.540485989s}, final_worker:{wall_time:1m23.552461397s, concurrency:5, task_num:25, tot_wait:6m57.69873982s, tot_exec:61.407969ms, tot_time:6m57.76015982s, max:1m23.552406399s, p95:1m23.552406399s}	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:03 [2021-05-26T20:53:03.145Z]     └─IndexHashJoin_42	7828961.66	198698	root		time:1m23.5s, loops:196, inner:{total:2m22.4s, concurrency:5, task:146, construct:6.41s, fetch:1m58.5s, build:1.23s, 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.1 MB	N/A
20:53:03 [2021-05-26T20:53:03.145Z]       ├─IndexHashJoin_83(Build)	9786202.08	3542799	root		time:1m22.9s, loops:3463, inner:{total:2m29.6s, concurrency:5, task:152, construct:7.42s, fetch:2m4.1s, build:1.22s, 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:53:03 [2021-05-26T20:53:03.145Z]       │ ├─IndexJoin_99(Build)	12232752.60	3675878	root		time:1m22.5s, loops:3595, inner:{total:2m8.4s, concurrency:5, task:305, construct:16.3s, fetch:1m50.4s, build:1.78s}, probe:5.15s	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.3 MB	N/A
20:53:03 [2021-05-26T20:53:03.145Z]       │ │ ├─HashJoin_107(Build)	12232752.60	7609895	root		time:1m22s, loops:7436, build_hash_table:{total:1.17s, fetch:1.16s, build:7.52ms}, probe:{concurrency:5, total:6m52.5s, max:1m22.5s, probe:1m3s, fetch:5m49.5s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.lineitem.l_suppkey)]	747.3 KB	0 Bytes
20:53:03 [2021-05-26T20:53:03.145Z]       │ │ │ ├─HashJoin_120(Build)	20000.00	20058	root		time:1.17s, loops:23, build_hash_table:{total:211.4µs, fetch:204.4µs, build:7.08µs}, probe:{concurrency:5, total:5.83s, max:1.17s, probe:78.1ms, fetch:5.75s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:53:03 [2021-05-26T20:53:03.145Z]       │ │ │ │ ├─TableReader_125(Build)	1.00	1	root		time:70.2µs, loops:2, cop_task: {num: 1, max: 1.55ms, proc_keys: 25, tot_proc: 1ms, rpc_num: 1, rpc_time: 1.51ms, copr_cache: disabled}	data:Selection_124	244 Bytes	N/A
20:53:03 [2021-05-26T20:53:03.145Z]       │ │ │ │ │ └─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:03 [2021-05-26T20:53:03.145Z]       │ │ │ │ │   └─TableFullScan_123	25.00	25	cop[tikv]	table:nation	tikv_task:{time:0s, loops:1}	keep order:false	N/A	N/A
20:53:03 [2021-05-26T20:53:03.145Z]       │ │ │ │ └─TableReader_122(Probe)	500000.00	500000	root		time:1.15s, loops:490, cop_task: {num: 1, max: 1.15s, proc_keys: 500000, tot_proc: 1.11s, rpc_num: 1, rpc_time: 1.15s, copr_cache: disabled}	data:TableFullScan_121	20.0 MB	N/A
20:53:03 [2021-05-26T20:53:03.145Z]       │ │ │ │   └─TableFullScan_121	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:1.06s, loops:493}, scan_detail: {total_process_keys: 500000, total_keys: 500001, rocksdb: {delete_skipped_count: 0, key_skipped_count: 999999, block: {cache_hit_count: 13, read_count: 1679, read_byte: 104.5 MB}}}	keep order:false	N/A	N/A
20:53:03 [2021-05-26T20:53:03.145Z]       │ │ │ └─TableReader_128(Probe)	240004648.80	189670348	root		time:1m9.4s, loops:184598, cop_task: {num: 761, max: 2.95s, min: 341.2ms, avg: 1.58s, p95: 2.01s, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 18m47.1s, tot_wait: 58.5s, rpc_num: 761, rpc_time: 20m0.5s, copr_cache: disabled}	data:Selection_127	109.4 MB	N/A
20:53:03 [2021-05-26T20:53:03.145Z]       │ │ │   └─Selection_127	240004648.80	189670348	cop[tikv]		tikv_task:{proc max:1.38s, min:318ms, p80:1.25s, p95:1.29s, iters:296606, tasks:761}, scan_detail: {total_process_keys: 300005811, total_keys: 300006572, rocksdb: {delete_skipped_count: 0, key_skipped_count: 600010861, block: {cache_hit_count: 10452, read_count: 1114196, read_byte: 23.6 GB}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:53:03 [2021-05-26T20:53:03.145Z]       │ │ │     └─TableFullScan_126	300005811.00	300005811	cop[tikv]	table:l1	tikv_task:{proc max:1.29s, min:305ms, p80:1.16s, p95:1.21s, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:53:03 [2021-05-26T20:53:03.145Z]       │ │ └─TableReader_95(Probe)	0.49	3496177	root		time:1m41.2s, loops:3875, cop_task: {num: 5274, max: 603.8ms, min: 951.2µs, avg: 180.4ms, p95: 342.5ms, max_proc_keys: 3733, p95_proc_keys: 1958, tot_proc: 11m13.6s, tot_wait: 3m47.7s, rpc_num: 5274, rpc_time: 15m51.4s, copr_cache: disabled}	data:Selection_94	N/A	N/A
20:53:03 [2021-05-26T20:53:03.145Z]       │ │   └─Selection_94	0.49	3496177	cop[tikv]		tikv_task:{proc max:143ms, min:0s, p80:70ms, p95:82ms, iters:30226, tasks:5274}, scan_detail: {total_process_keys: 7236264, total_keys: 7795477, rocksdb: {delete_skipped_count: 0, key_skipped_count: 1778339, block: {cache_hit_count: 54005520, read_count: 218226, read_byte: 4.21 GB}}}	eq(tpch50.orders.o_orderstatus, "F")	N/A	N/A
20:53:03 [2021-05-26T20:53:03.145Z]       │ │     └─TableRangeScan_93	1.00	7236264	cop[tikv]	table:orders	tikv_task:{proc max:143ms, min:0s, p80:69ms, p95:82ms, iters:30226, tasks:5274}	range: decided by [tpch50.lineitem.l_orderkey], keep order:false	N/A	N/A
20:53:03 [2021-05-26T20:53:03.145Z]       │ └─IndexLookUp_80(Probe)	4.05	17316470	root		time:1m58.5s, loops:17130, index_task: {total_time: 1m5.8s, fetch_handle: 57s, build: 3.15ms, wait: 8.79s}, table_task: {total_time: 8m32.8s, num: 1458, concurrency: 760}		19.3 KB	N/A
20:53:03 [2021-05-26T20:53:03.145Z]       │   ├─IndexRangeScan_78(Build)	4.05	17316470	cop[tikv]	table:l2, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:54.9s, loops:18622, cop_task: {num: 2981, max: 709.6ms, min: 418.8µs, avg: 188.6ms, p95: 369.9ms, max_proc_keys: 13772, p95_proc_keys: 8758, tot_proc: 7m3.1s, tot_wait: 1m53s, rpc_num: 2981, rpc_time: 9m22.1s, copr_cache: disabled}, tikv_task:{proc max:178ms, min:0s, p80:101ms, p95:117ms, iters:30062, tasks:2981}, scan_detail: {total_process_keys: 17316470, total_keys: 20812574, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17316470, block: {cache_hit_count: 24259976, read_count: 225679, read_byte: 2.00 GB}}}	range: decided by [eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey)], keep order:false	N/A	N/A
20:53:03 [2021-05-26T20:53:03.145Z]       │   └─TableRowIDScan_79(Probe)	4.05	17316470	cop[tikv]	table:l2	time:6m18.6s, loops:21022, cop_task: {num: 7744, max: 818.4ms, min: 566.7µs, avg: 177.5ms, p95: 360.7ms, max_proc_keys: 12919, p95_proc_keys: 4856, tot_proc: 16m21.1s, tot_wait: 5m32.5s, rpc_num: 7744, rpc_time: 22m54s, copr_cache: disabled}, tikv_task:{proc max:300ms, min:0s, p80:105ms, p95:140ms, iters:49899, tasks:7744}, scan_detail: {total_process_keys: 17316470, total_keys: 18288300, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5624914, block: {cache_hit_count: 99019182, read_count: 1107, read_byte: 390.9 MB}}}	keep order:false	N/A	N/A
20:53:03 [2021-05-26T20:53:03.145Z]       └─IndexLookUp_39(Probe)	4.05	12022798	root		time:1m53.4s, loops:11946, index_task: {total_time: 1m1.4s, fetch_handle: 51.6s, build: 3.69ms, wait: 9.79s}, table_task: {total_time: 8m10.2s, num: 1408, concurrency: 730}		216.5 KB	N/A
20:53:03 [2021-05-26T20:53:03.145Z]         ├─IndexRangeScan_36(Build)	5.06	17183383	cop[tikv]	table:l3, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:49.3s, loops:18387, cop_task: {num: 2774, max: 1.06s, min: 718.7µs, avg: 172.2ms, p95: 376.1ms, max_proc_keys: 18806, p95_proc_keys: 13619, tot_proc: 5m57.6s, tot_wait: 1m33.9s, rpc_num: 2774, rpc_time: 7m57.6s, copr_cache: disabled}, tikv_task:{proc max:181ms, min:0s, p80:82ms, p95:128ms, iters:29054, tasks:2774}, scan_detail: {total_process_keys: 17183383, total_keys: 20546407, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17183383, 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:53:03 [2021-05-26T20:53:03.145Z]         └─Selection_38(Probe)	4.05	12022798	cop[tikv]		time:6m13.2s, loops:13780, cop_task: {num: 10141, max: 611.5ms, min: 506.8µs, avg: 174.1ms, p95: 354.3ms, max_proc_keys: 8347, p95_proc_keys: 4013, tot_proc: 20m33.5s, tot_wait: 7m31.7s, rpc_num: 10141, rpc_time: 29m25.3s, copr_cache: disabled}, tikv_task:{proc max:244ms, min:0s, p80:76ms, p95:118ms, iters:60445, tasks:10141}, scan_detail: {total_process_keys: 17183383, total_keys: 18129230, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5528449, block: {cache_hit_count: 98282876, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:53:03 [2021-05-26T20:53:03.145Z]           └─TableRowIDScan_37	5.06	17183383	cop[tikv]	table:l3	tikv_task:{proc max:243ms, min:0s, p80:75ms, p95:118ms, iters:60445, tasks:10141}	keep order:false	N/A	N/A
20:53:03 [2021-05-26T20:53:03.145Z] + sync
20:53:03 [2021-05-26T20:53:03.145Z] + /usr/bin/echo 3
20:54:39 [2021-05-26T20:54:39.705Z] 
20:54:39 [2021-05-26T20:54:39.705Z] queries/21.sql
20:54:39 [2021-05-26T20:54:39.705Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:54:39 [2021-05-26T20:54:39.705Z] Projection_26	100.00	100	root		time:1m23.4s, loops:2, Concurrency:OFF	tpch50.supplier.s_name, Column#72	4.37 KB	N/A
20:54:39 [2021-05-26T20:54:39.705Z] └─TopN_29	100.00	100	root		time:1m23.4s, loops:2	Column#72:desc, tpch50.supplier.s_name, offset:0, count:100	58.3 KB	N/A
20:54:39 [2021-05-26T20:54:39.705Z]   └─HashAgg_34	12800.00	20057	root		time:1m23.4s, loops:21, partial_worker:{wall_time:1m23.399330263s, concurrency:5, task_num:197, tot_wait:6m56.724955196s, tot_exec:256.951475ms, tot_time:6m56.994988774s, max:1m23.39930328s, p95:1m23.39930328s}, final_worker:{wall_time:1m23.412317748s, concurrency:5, task_num:25, tot_wait:6m56.994282512s, tot_exec:64.094765ms, tot_time:6m57.058390086s, max:1m23.412300952s, p95:1m23.412300952s}	group by:tpch50.supplier.s_name, funcs:count(1)->Column#72, funcs:firstrow(tpch50.supplier.s_name)->tpch50.supplier.s_name	17.3 MB	N/A
20:54:39 [2021-05-26T20:54:39.705Z]     └─IndexHashJoin_42	7828961.66	198698	root		time:1m23.4s, loops:198, inner:{total:2m15.5s, concurrency:5, task:147, construct:6.16s, fetch:1m52.5s, build:1.2s, 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.0 MB	N/A
20:54:39 [2021-05-26T20:54:39.705Z]       ├─IndexHashJoin_83(Build)	9786202.08	3542799	root		time:1m22.8s, loops:3463, inner:{total:2m25.8s, concurrency:5, task:152, construct:7.43s, fetch:2m0.6s, build:1.2s, join:17.8s}	semi join, inner:IndexLookUp_80, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey), ne(tpch50.lineitem.l_suppkey, tpch50.supplier.s_suppkey)	555.9 MB	N/A
20:54:39 [2021-05-26T20:54:39.706Z]       │ ├─IndexJoin_99(Build)	12232752.60	3675878	root		time:1m22.3s, loops:3595, inner:{total:2m3.3s, concurrency:5, task:305, construct:16.3s, fetch:1m45.1s, build:1.89s}, probe:5.05s	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:54:39 [2021-05-26T20:54:39.706Z]       │ │ ├─HashJoin_107(Build)	12232752.60	7609895	root		time:1m21.8s, loops:7436, build_hash_table:{total:1.07s, fetch:1.06s, build:6.15ms}, probe:{concurrency:5, total:6m50.9s, max:1m22.2s, probe:1m1.9s, fetch:5m49s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.lineitem.l_suppkey)]	727.6 KB	0 Bytes
20:54:39 [2021-05-26T20:54:39.706Z]       │ │ │ ├─HashJoin_120(Build)	20000.00	20058	root		time:1.07s, loops:22, build_hash_table:{total:238µs, fetch:231.6µs, build:6.37µs}, probe:{concurrency:5, total:5.34s, max:1.07s, probe:60.1ms, fetch:5.28s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:54:39 [2021-05-26T20:54:39.706Z]       │ │ │ │ ├─TableReader_125(Build)	1.00	1	root		time:57.8µs, loops:2, cop_task: {num: 1, max: 1.08ms, proc_keys: 25, tot_proc: 1ms, rpc_num: 1, rpc_time: 1.04ms, copr_cache: disabled}	data:Selection_124	240 Bytes	N/A
20:54:39 [2021-05-26T20:54:39.706Z]       │ │ │ │ │ └─Selection_124	1.00	1	cop[tikv]		tikv_task:{time:1ms, loops:1}, scan_detail: {total_process_keys: 25, total_keys: 26, rocksdb: {delete_skipped_count: 0, key_skipped_count: 46, block: {cache_hit_count: 18, read_count: 0, read_byte: 0 Bytes}}}	eq(tpch50.nation.n_name, "EGYPT")	N/A	N/A
20:54:39 [2021-05-26T20:54:39.706Z]       │ │ │ │ │   └─TableFullScan_123	25.00	25	cop[tikv]	table:nation	tikv_task:{time:0s, loops:1}	keep order:false	N/A	N/A
20:54:39 [2021-05-26T20:54:39.706Z]       │ │ │ │ └─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.02s, rpc_num: 1, rpc_time: 1.06s, copr_cache: disabled}	data:TableFullScan_121	20.0 MB	N/A
20:54:39 [2021-05-26T20:54:39.706Z]       │ │ │ │   └─TableFullScan_121	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:953ms, loops:493}, scan_detail: {total_process_keys: 500000, total_keys: 500001, rocksdb: {delete_skipped_count: 0, key_skipped_count: 999999, block: {cache_hit_count: 14, read_count: 1678, read_byte: 104.5 MB}}}	keep order:false	N/A	N/A
20:54:39 [2021-05-26T20:54:39.706Z]       │ │ │ └─TableReader_128(Probe)	240004648.80	189670348	root		time:1m9.4s, loops:184595, cop_task: {num: 761, max: 2.67s, min: 270.6ms, avg: 1.58s, p95: 2.02s, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 18m49.3s, tot_wait: 58.4s, rpc_num: 761, rpc_time: 20m2s, copr_cache: disabled}	data:Selection_127	109.4 MB	N/A
20:54:39 [2021-05-26T20:54:39.706Z]       │ │ │   └─Selection_127	240004648.80	189670348	cop[tikv]		tikv_task:{proc max:1.39s, min:255ms, p80:1.25s, p95:1.29s, iters:296606, tasks:761}, scan_detail: {total_process_keys: 300005811, total_keys: 300006572, rocksdb: {delete_skipped_count: 0, key_skipped_count: 600010861, block: {cache_hit_count: 10455, read_count: 1114193, read_byte: 23.6 GB}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:54:39 [2021-05-26T20:54:39.706Z]       │ │ │     └─TableFullScan_126	300005811.00	300005811	cop[tikv]	table:l1	tikv_task:{proc max:1.31s, min:240ms, p80:1.16s, p95:1.21s, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:54:39 [2021-05-26T20:54:39.706Z]       │ │ └─TableReader_95(Probe)	0.49	3496177	root		time:1m36.2s, loops:3875, cop_task: {num: 5271, max: 538.7ms, min: 1.54ms, avg: 173.7ms, p95: 334.4ms, max_proc_keys: 3468, p95_proc_keys: 1952, tot_proc: 10m51.4s, tot_wait: 3m36.9s, rpc_num: 5271, rpc_time: 15m15.3s, copr_cache: disabled}	data:Selection_94	N/A	N/A
20:54:39 [2021-05-26T20:54:39.706Z]       │ │   └─Selection_94	0.49	3496177	cop[tikv]		tikv_task:{proc max:162ms, min:0s, p80:70ms, p95:82ms, iters:30236, tasks:5271}, scan_detail: {total_process_keys: 7236295, total_keys: 7795492, rocksdb: {delete_skipped_count: 0, key_skipped_count: 1778231, block: {cache_hit_count: 54006158, read_count: 218206, read_byte: 4.21 GB}}}	eq(tpch50.orders.o_orderstatus, "F")	N/A	N/A
20:54:39 [2021-05-26T20:54:39.706Z]       │ │     └─TableRangeScan_93	1.00	7236295	cop[tikv]	table:orders	tikv_task:{proc max:161ms, min:0s, p80:69ms, p95:82ms, iters:30236, tasks:5271}	range: decided by [tpch50.lineitem.l_orderkey], keep order:false	N/A	N/A
20:54:39 [2021-05-26T20:54:39.706Z]       │ └─IndexLookUp_80(Probe)	4.05	17316434	root		time:1m55.2s, loops:17130, index_task: {total_time: 1m3.6s, fetch_handle: 53.3s, build: 3.78ms, wait: 10.2s}, table_task: {total_time: 8m16.7s, num: 1458, concurrency: 760}		19.2 KB	N/A
20:54:39 [2021-05-26T20:54:39.706Z]       │   ├─IndexRangeScan_78(Build)	4.05	17316434	cop[tikv]	table:l2, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:51s, loops:18635, cop_task: {num: 2958, max: 705.7ms, min: 441.3µs, avg: 178.9ms, p95: 361.6ms, max_proc_keys: 13502, p95_proc_keys: 8735, tot_proc: 6m41.7s, tot_wait: 1m43s, rpc_num: 2958, rpc_time: 8m49.1s, copr_cache: disabled}, tikv_task:{proc max:186ms, min:0s, p80:102ms, p95:118ms, iters:29986, tasks:2958}, scan_detail: {total_process_keys: 17316434, total_keys: 20812534, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17316434, block: {cache_hit_count: 24259939, read_count: 225688, read_byte: 2.00 GB}}}	range: decided by [eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey)], keep order:false	N/A	N/A
20:54:39 [2021-05-26T20:54:39.706Z]       │   └─TableRowIDScan_79(Probe)	4.05	17316434	cop[tikv]	table:l2	time:6m7.4s, loops:20998, cop_task: {num: 7797, max: 609ms, min: 488.3µs, avg: 173.1ms, p95: 354ms, max_proc_keys: 13412, p95_proc_keys: 4847, tot_proc: 16m9s, tot_wait: 5m22s, rpc_num: 7797, rpc_time: 22m29.1s, copr_cache: disabled}, tikv_task:{proc max:244ms, min:0s, p80:104ms, p95:140ms, iters:50000, tasks:7797}, scan_detail: {total_process_keys: 17316434, total_keys: 18289002, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5628484, block: {cache_hit_count: 99019676, read_count: 1110, read_byte: 393.0 MB}}}	keep order:false	N/A	N/A
20:54:39 [2021-05-26T20:54:39.706Z]       └─IndexLookUp_39(Probe)	4.05	12022754	root		time:1m47.7s, loops:11942, index_task: {total_time: 59.3s, fetch_handle: 49.6s, build: 3.03ms, wait: 9.71s}, table_task: {total_time: 7m48.4s, num: 1411, concurrency: 735}		218.9 KB	N/A
20:54:39 [2021-05-26T20:54:39.706Z]         ├─IndexRangeScan_36(Build)	5.06	17183341	cop[tikv]	table:l3, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:47.3s, loops:18380, cop_task: {num: 2748, max: 765.8ms, min: 888.7µs, avg: 163.6ms, p95: 348.4ms, max_proc_keys: 20912, p95_proc_keys: 13728, tot_proc: 5m37.7s, tot_wait: 1m26.8s, rpc_num: 2748, rpc_time: 7m29.6s, copr_cache: disabled}, tikv_task:{proc max:198ms, min:0s, p80:83ms, p95:129ms, iters:28953, tasks:2748}, scan_detail: {total_process_keys: 17183341, total_keys: 20546360, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17183341, block: {cache_hit_count: 23553939, read_count: 0, read_byte: 0 Bytes}}}	range: decided by [eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey)], keep order:false	N/A	N/A
20:54:39 [2021-05-26T20:54:39.706Z]         └─Selection_38(Probe)	4.05	12022754	cop[tikv]		time:5m57.6s, loops:13763, cop_task: {num: 10250, max: 577.9ms, min: 415.8µs, avg: 166.7ms, p95: 337.2ms, max_proc_keys: 6801, p95_proc_keys: 3951, tot_proc: 19m51.2s, tot_wait: 7m18.9s, rpc_num: 10250, rpc_time: 28m28.7s, copr_cache: disabled}, tikv_task:{proc max:213ms, min:0s, p80:77ms, p95:115ms, iters:60804, tasks:10250}, scan_detail: {total_process_keys: 17183341, total_keys: 18128860, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5526101, block: {cache_hit_count: 98289208, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:54:39 [2021-05-26T20:54:39.706Z]           └─TableRowIDScan_37	5.06	17183341	cop[tikv]	table:l3	tikv_task:{proc max:211ms, min:0s, p80:77ms, p95:114ms, iters:60804, tasks:10250}	keep order:false	N/A	N/A
20:54:39 [2021-05-26T20:54:39.706Z] + sync
20:54:39 [2021-05-26T20:54:39.706Z] + /usr/bin/echo 3
20:56:01 [2021-05-26T20:56:01.089Z] 
20:56:01 [2021-05-26T20:56:01.089Z] queries/21.sql
20:56:01 [2021-05-26T20:56:01.089Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:56:01 [2021-05-26T20:56:01.089Z] Projection_26	100.00	100	root		time:1m23.2s, loops:2, Concurrency:OFF	tpch50.supplier.s_name, Column#72	4.37 KB	N/A
20:56:01 [2021-05-26T20:56:01.089Z] └─TopN_29	100.00	100	root		time:1m23.2s, loops:2	Column#72:desc, tpch50.supplier.s_name, offset:0, count:100	55.0 KB	N/A
20:56:01 [2021-05-26T20:56:01.089Z]   └─HashAgg_34	12800.00	20057	root		time:1m23.2s, loops:21, partial_worker:{wall_time:1m23.189694s, concurrency:5, task_num:198, tot_wait:6m55.60381297s, tot_exec:326.661585ms, tot_time:6m55.944545526s, max:1m23.189661159s, p95:1m23.189661159s}, final_worker:{wall_time:1m23.201269915s, concurrency:5, task_num:25, tot_wait:6m55.942296679s, tot_exec:63.350591ms, tot_time:6m56.005658885s, max:1m23.201246248s, p95:1m23.201246248s}	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:01 [2021-05-26T20:56:01.089Z]     └─IndexHashJoin_42	7828961.66	198698	root		time:1m23.2s, loops:199, inner:{total:2m17.9s, concurrency:5, task:146, construct:5.98s, fetch:1m54.6s, build:1.19s, 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:56:01 [2021-05-26T20:56:01.089Z]       ├─IndexHashJoin_83(Build)	9786202.08	3542799	root		time:1m22.6s, loops:3463, inner:{total:2m25.2s, concurrency:5, task:152, construct:7.56s, fetch:2m0s, build:1.31s, join:17.7s}	semi join, inner:IndexLookUp_80, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey), ne(tpch50.lineitem.l_suppkey, tpch50.supplier.s_suppkey)	555.9 MB	N/A
20:56:01 [2021-05-26T20:56:01.089Z]       │ ├─IndexJoin_99(Build)	12232752.60	3675878	root		time:1m22s, loops:3595, inner:{total:2m5.7s, concurrency:5, task:305, construct:15.8s, fetch:1m48s, build:1.83s}, probe:5.31s	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.7 MB	N/A
20:56:01 [2021-05-26T20:56:01.089Z]       │ │ ├─HashJoin_107(Build)	12232752.60	7609895	root		time:1m21.3s, loops:7436, build_hash_table:{total:1s, fetch:996ms, build:7.67ms}, probe:{concurrency:5, total:6m48.7s, max:1m21.7s, probe:1m2.8s, fetch:5m45.9s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.lineitem.l_suppkey)]	752.0 KB	0 Bytes
20:56:01 [2021-05-26T20:56:01.089Z]       │ │ │ ├─HashJoin_120(Build)	20000.00	20058	root		time:1s, loops:23, build_hash_table:{total:177.9µs, fetch:172.7µs, build:5.25µs}, probe:{concurrency:5, total:5.01s, max:1s, probe:75.4ms, fetch:4.93s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:56:01 [2021-05-26T20:56:01.089Z]       │ │ │ │ ├─TableReader_125(Build)	1.00	1	root		time:38.6µs, loops:2, cop_task: {num: 1, max: 1.65ms, proc_keys: 25, tot_proc: 1ms, rpc_num: 1, rpc_time: 1.62ms, copr_cache: disabled}	data:Selection_124	248 Bytes	N/A
20:56:01 [2021-05-26T20:56:01.089Z]       │ │ │ │ │ └─Selection_124	1.00	1	cop[tikv]		tikv_task:{time:1ms, loops:1}, scan_detail: {total_process_keys: 25, total_keys: 26, rocksdb: {delete_skipped_count: 0, key_skipped_count: 46, block: {cache_hit_count: 17, read_count: 1, read_byte: 23.8 KB}}}	eq(tpch50.nation.n_name, "EGYPT")	N/A	N/A
20:56:01 [2021-05-26T20:56:01.089Z]       │ │ │ │ │   └─TableFullScan_123	25.00	25	cop[tikv]	table:nation	tikv_task:{time:1ms, loops:1}	keep order:false	N/A	N/A
20:56:01 [2021-05-26T20:56:01.089Z]       │ │ │ │ └─TableReader_122(Probe)	500000.00	500000	root		time:986.8ms, loops:490, cop_task: {num: 1, max: 987.5ms, proc_keys: 500000, tot_proc: 948ms, rpc_num: 1, rpc_time: 987.4ms, copr_cache: disabled}	data:TableFullScan_121	20.0 MB	N/A
20:56:01 [2021-05-26T20:56:01.089Z]       │ │ │ │   └─TableFullScan_121	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:885ms, loops:493}, scan_detail: {total_process_keys: 500000, total_keys: 500001, rocksdb: {delete_skipped_count: 0, key_skipped_count: 999999, block: {cache_hit_count: 13, read_count: 1679, read_byte: 104.5 MB}}}	keep order:false	N/A	N/A
20:56:01 [2021-05-26T20:56:01.089Z]       │ │ │ └─TableReader_128(Probe)	240004648.80	189670348	root		time:1m8.6s, loops:184597, cop_task: {num: 761, max: 2.57s, min: 286.8ms, avg: 1.57s, p95: 2s, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 18m45.3s, tot_wait: 57.7s, rpc_num: 761, rpc_time: 19m57.2s, copr_cache: disabled}	data:Selection_127	109.4 MB	N/A
20:56:01 [2021-05-26T20:56:01.089Z]       │ │ │   └─Selection_127	240004648.80	189670348	cop[tikv]		tikv_task:{proc max:1.36s, min:274ms, p80:1.24s, p95:1.29s, iters:296606, tasks:761}, scan_detail: {total_process_keys: 300005811, total_keys: 300006572, rocksdb: {delete_skipped_count: 0, key_skipped_count: 600010861, block: {cache_hit_count: 10457, read_count: 1114191, read_byte: 23.6 GB}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:56:01 [2021-05-26T20:56:01.089Z]       │ │ │     └─TableFullScan_126	300005811.00	300005811	cop[tikv]	table:l1	tikv_task:{proc max:1.26s, min:257ms, p80:1.16s, p95:1.2s, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:56:01 [2021-05-26T20:56:01.089Z]       │ │ └─TableReader_95(Probe)	0.49	3496189	root		time:1m39.3s, loops:3875, cop_task: {num: 5263, max: 526.6ms, min: 1.17ms, avg: 174.5ms, p95: 323.9ms, max_proc_keys: 4374, p95_proc_keys: 1961, tot_proc: 10m55.1s, tot_wait: 3m34.5s, rpc_num: 5263, rpc_time: 15m18.2s, copr_cache: disabled}	data:Selection_94	N/A	N/A
20:56:01 [2021-05-26T20:56:01.089Z]       │ │   └─Selection_94	0.49	3496189	cop[tikv]		tikv_task:{proc max:183ms, min:0s, p80:70ms, p95:84ms, iters:30253, tasks:5263}, scan_detail: {total_process_keys: 7236310, total_keys: 7795460, rocksdb: {delete_skipped_count: 0, key_skipped_count: 1778070, block: {cache_hit_count: 54006771, read_count: 218154, read_byte: 4.21 GB}}}	eq(tpch50.orders.o_orderstatus, "F")	N/A	N/A
20:56:01 [2021-05-26T20:56:01.089Z]       │ │     └─TableRangeScan_93	1.00	7236310	cop[tikv]	table:orders	tikv_task:{proc max:183ms, min:0s, p80:70ms, p95:84ms, iters:30253, tasks:5263}	range: decided by [tpch50.lineitem.l_orderkey], keep order:false	N/A	N/A
20:56:01 [2021-05-26T20:56:01.089Z]       │ └─IndexLookUp_80(Probe)	4.05	17316530	root		time:1m54.5s, loops:17132, index_task: {total_time: 1m3.5s, fetch_handle: 55.3s, build: 3.02ms, wait: 8.13s}, table_task: {total_time: 8m13s, num: 1458, concurrency: 760}		18.9 KB	N/A
20:56:01 [2021-05-26T20:56:01.089Z]       │   ├─IndexRangeScan_78(Build)	4.05	17316530	cop[tikv]	table:l2, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:53.1s, loops:18621, cop_task: {num: 2974, max: 792.5ms, min: 474.3µs, avg: 183.9ms, p95: 370.7ms, max_proc_keys: 15600, p95_proc_keys: 8833, tot_proc: 6m52.1s, tot_wait: 1m49.3s, rpc_num: 2974, rpc_time: 9m6.7s, copr_cache: disabled}, tikv_task:{proc max:214ms, min:0s, p80:100ms, p95:117ms, iters:30054, tasks:2974}, scan_detail: {total_process_keys: 17316530, total_keys: 20812644, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17316530, block: {cache_hit_count: 24260039, 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:56:01 [2021-05-26T20:56:01.089Z]       │   └─TableRowIDScan_79(Probe)	4.05	17316530	cop[tikv]	table:l2	time:6m2.5s, loops:21042, cop_task: {num: 7839, max: 650.8ms, min: 1.14ms, avg: 169.9ms, p95: 341.7ms, max_proc_keys: 9513, p95_proc_keys: 4841, tot_proc: 15m52.5s, tot_wait: 5m19.9s, rpc_num: 7839, rpc_time: 22m11.5s, copr_cache: disabled}, tikv_task:{proc max:309ms, min:0s, p80:104ms, p95:139ms, iters:50022, tasks:7839}, scan_detail: {total_process_keys: 17316530, total_keys: 18289693, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5629365, block: {cache_hit_count: 99019840, read_count: 1122, read_byte: 403.0 MB}}}	keep order:false	N/A	N/A
20:56:01 [2021-05-26T20:56:01.089Z]       └─IndexLookUp_39(Probe)	4.05	12022854	root		time:1m49.9s, loops:11942, index_task: {total_time: 59.4s, fetch_handle: 49.3s, build: 3.19ms, wait: 10.1s}, table_task: {total_time: 7m55.2s, num: 1408, concurrency: 730}		268.2 KB	N/A
20:56:01 [2021-05-26T20:56:01.089Z]         ├─IndexRangeScan_36(Build)	5.06	17183465	cop[tikv]	table:l3, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:46.8s, loops:18320, cop_task: {num: 2759, max: 665ms, min: 678.2µs, avg: 164.7ms, p95: 350.8ms, max_proc_keys: 19929, p95_proc_keys: 13702, tot_proc: 5m41.8s, tot_wait: 1m28.3s, rpc_num: 2759, rpc_time: 7m34.3s, copr_cache: disabled}, tikv_task:{proc max:198ms, min:0s, p80:84ms, p95:129ms, iters:28967, tasks:2759}, scan_detail: {total_process_keys: 17183465, total_keys: 20546503, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17183465, block: {cache_hit_count: 23554072, 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:01 [2021-05-26T20:56:01.090Z]         └─Selection_38(Probe)	4.05	12022854	cop[tikv]		time:6m4.6s, loops:13774, cop_task: {num: 10316, max: 654.5ms, min: 463.5µs, avg: 170.2ms, p95: 345.8ms, max_proc_keys: 7178, p95_proc_keys: 3932, tot_proc: 20m26s, tot_wait: 7m29.5s, rpc_num: 10316, rpc_time: 29m15.4s, copr_cache: disabled}, tikv_task:{proc max:231ms, min:0s, p80:76ms, p95:115ms, iters:60929, tasks:10316}, scan_detail: {total_process_keys: 17183465, total_keys: 18128879, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5524916, block: {cache_hit_count: 98293308, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:56:01 [2021-05-26T20:56:01.090Z]           └─TableRowIDScan_37	5.06	17183465	cop[tikv]	table:l3	tikv_task:{proc max:230ms, min:0s, p80:75ms, p95:114ms, iters:60929, tasks:10316}	keep order:false	N/A	N/A
20:56:01 [2021-05-26T20:56:01.090Z] + sync
20:56:01 [2021-05-26T20:56:01.090Z] + /usr/bin/echo 3
20:57:37 [2021-05-26T20:57:37.679Z] 
20:57:37 [2021-05-26T20:57:37.679Z] queries/21.sql
20:57:37 [2021-05-26T20:57:37.679Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
20:57:37 [2021-05-26T20:57:37.679Z] Projection_26	100.00	100	root		time:1m23.4s, loops:2, Concurrency:OFF	tpch50.supplier.s_name, Column#72	4.37 KB	N/A
20:57:37 [2021-05-26T20:57:37.679Z] └─TopN_29	100.00	100	root		time:1m23.4s, loops:2	Column#72:desc, tpch50.supplier.s_name, offset:0, count:100	58.3 KB	N/A
20:57:37 [2021-05-26T20:57:37.679Z]   └─HashAgg_34	12800.00	20057	root		time:1m23.4s, loops:21, partial_worker:{wall_time:1m23.383829867s, concurrency:5, task_num:197, tot_wait:6m56.659300075s, tot_exec:245.98468ms, tot_time:6m56.91788137s, max:1m23.383804325s, p95:1m23.383804325s}, final_worker:{wall_time:1m23.396085807s, concurrency:5, task_num:25, tot_wait:6m56.917187659s, tot_exec:62.490312ms, tot_time:6m56.979690872s, max:1m23.396069133s, p95:1m23.396069133s}	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:37 [2021-05-26T20:57:37.679Z]     └─IndexHashJoin_42	7828961.66	198698	root		time:1m23.4s, loops:198, inner:{total:2m16.1s, concurrency:5, task:146, construct:6.04s, fetch:1m52.9s, build:1.21s, 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:37 [2021-05-26T20:57:37.679Z]       ├─IndexHashJoin_83(Build)	9786202.08	3542799	root		time:1m22.8s, loops:3463, inner:{total:2m25.6s, concurrency:5, task:152, construct:7.71s, fetch:2m0s, build:1.23s, join:17.9s}	semi join, inner:IndexLookUp_80, outer key:tpch50.lineitem.l_orderkey, inner key:tpch50.lineitem.l_orderkey, equal cond:eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey), other cond:ne(tpch50.lineitem.l_suppkey, tpch50.lineitem.l_suppkey), ne(tpch50.lineitem.l_suppkey, tpch50.supplier.s_suppkey)	555.9 MB	N/A
20:57:37 [2021-05-26T20:57:37.679Z]       │ ├─IndexJoin_99(Build)	12232752.60	3675878	root		time:1m22.2s, loops:3595, inner:{total:2m2.8s, concurrency:5, task:305, construct:15.9s, fetch:1m45.1s, build:1.79s}, probe:5.13s	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.7 MB	N/A
20:57:37 [2021-05-26T20:57:37.679Z]       │ │ ├─HashJoin_107(Build)	12232752.60	7609895	root		time:1m21.6s, loops:7436, build_hash_table:{total:1.09s, fetch:1.08s, build:8.31ms}, probe:{concurrency:5, total:6m50.6s, max:1m22.1s, probe:1m4s, fetch:5m46.6s}	inner join, equal:[eq(tpch50.supplier.s_suppkey, tpch50.lineitem.l_suppkey)]	771.7 KB	0 Bytes
20:57:37 [2021-05-26T20:57:37.679Z]       │ │ │ ├─HashJoin_120(Build)	20000.00	20058	root		time:1.09s, loops:24, build_hash_table:{total:148.9µs, fetch:144.1µs, build:4.77µs}, probe:{concurrency:5, total:5.43s, max:1.09s, probe:76.3ms, fetch:5.36s}	inner join, equal:[eq(tpch50.nation.n_nationkey, tpch50.supplier.s_nationkey)]	24.5 KB	0 Bytes
20:57:37 [2021-05-26T20:57:37.679Z]       │ │ │ │ ├─TableReader_125(Build)	1.00	1	root		time:47µs, loops:2, cop_task: {num: 1, max: 1.18ms, proc_keys: 25, rpc_num: 1, rpc_time: 1.14ms, copr_cache: disabled}	data:Selection_124	240 Bytes	N/A
20:57:37 [2021-05-26T20:57:37.679Z]       │ │ │ │ │ └─Selection_124	1.00	1	cop[tikv]		tikv_task:{time:0s, loops:1}, scan_detail: {total_process_keys: 25, total_keys: 26, rocksdb: {delete_skipped_count: 0, key_skipped_count: 46, block: {cache_hit_count: 17, read_count: 1, read_byte: 23.8 KB}}}	eq(tpch50.nation.n_name, "EGYPT")	N/A	N/A
20:57:37 [2021-05-26T20:57:37.679Z]       │ │ │ │ │   └─TableFullScan_123	25.00	25	cop[tikv]	table:nation	tikv_task:{time:0s, loops:1}	keep order:false	N/A	N/A
20:57:37 [2021-05-26T20:57:37.679Z]       │ │ │ │ └─TableReader_122(Probe)	500000.00	500000	root		time:1.07s, loops:490, cop_task: {num: 1, max: 1.07s, proc_keys: 500000, tot_proc: 1.03s, rpc_num: 1, rpc_time: 1.07s, copr_cache: disabled}	data:TableFullScan_121	20.0 MB	N/A
20:57:37 [2021-05-26T20:57:37.679Z]       │ │ │ │   └─TableFullScan_121	500000.00	500000	cop[tikv]	table:supplier	tikv_task:{time:977ms, 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:37 [2021-05-26T20:57:37.679Z]       │ │ │ └─TableReader_128(Probe)	240004648.80	189670348	root		time:1m8.9s, loops:184596, cop_task: {num: 761, max: 3.08s, min: 373.9ms, avg: 1.58s, p95: 2.11s, max_proc_keys: 407374, p95_proc_keys: 396418, tot_proc: 18m53.6s, tot_wait: 53.7s, rpc_num: 761, rpc_time: 20m1.8s, copr_cache: disabled}	data:Selection_127	109.4 MB	N/A
20:57:37 [2021-05-26T20:57:37.680Z]       │ │ │   └─Selection_127	240004648.80	189670348	cop[tikv]		tikv_task:{proc max:1.38s, min:354ms, p80:1.24s, p95:1.3s, iters:296606, tasks:761}, scan_detail: {total_process_keys: 300005811, total_keys: 300006572, rocksdb: {delete_skipped_count: 0, key_skipped_count: 600010861, block: {cache_hit_count: 10455, read_count: 1114193, read_byte: 23.6 GB}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:57:37 [2021-05-26T20:57:37.680Z]       │ │ │     └─TableFullScan_126	300005811.00	300005811	cop[tikv]	table:l1	tikv_task:{proc max:1.29s, min:330ms, p80:1.16s, p95:1.22s, iters:296606, tasks:761}	keep order:false	N/A	N/A
20:57:37 [2021-05-26T20:57:37.680Z]       │ │ └─TableReader_95(Probe)	0.49	3496182	root		time:1m36.2s, loops:3875, cop_task: {num: 5303, max: 568.4ms, min: 1.2ms, avg: 171.5ms, p95: 333.1ms, max_proc_keys: 3837, p95_proc_keys: 1958, tot_proc: 10m46.3s, tot_wait: 3m34.9s, rpc_num: 5303, rpc_time: 15m9.4s, copr_cache: disabled}	data:Selection_94	N/A	N/A
20:57:37 [2021-05-26T20:57:37.680Z]       │ │   └─Selection_94	0.49	3496182	cop[tikv]		tikv_task:{proc max:136ms, min:0s, p80:70ms, p95:83ms, iters:30322, tasks:5303}, scan_detail: {total_process_keys: 7236291, total_keys: 7795540, rocksdb: {delete_skipped_count: 0, key_skipped_count: 1778457, block: {cache_hit_count: 54006816, read_count: 218248, read_byte: 4.21 GB}}}	eq(tpch50.orders.o_orderstatus, "F")	N/A	N/A
20:57:37 [2021-05-26T20:57:37.680Z]       │ │     └─TableRangeScan_93	1.00	7236291	cop[tikv]	table:orders	tikv_task:{proc max:135ms, min:0s, p80:69ms, p95:83ms, iters:30322, tasks:5303}	range: decided by [tpch50.lineitem.l_orderkey], keep order:false	N/A	N/A
20:57:37 [2021-05-26T20:57:37.680Z]       │ └─IndexLookUp_80(Probe)	4.05	17316513	root		time:1m54.7s, loops:17129, index_task: {total_time: 1m3.2s, fetch_handle: 55.4s, build: 2.92ms, wait: 7.78s}, table_task: {total_time: 8m16.6s, num: 1458, concurrency: 760}		19.1 KB	N/A
20:57:37 [2021-05-26T20:57:37.680Z]       │   ├─IndexRangeScan_78(Build)	4.05	17316513	cop[tikv]	table:l2, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:53.2s, loops:18624, cop_task: {num: 3010, max: 723.5ms, min: 556.2µs, avg: 181.3ms, p95: 368ms, max_proc_keys: 14780, p95_proc_keys: 8741, tot_proc: 6m53.8s, tot_wait: 1m45.8s, rpc_num: 3010, rpc_time: 9m5.6s, copr_cache: disabled}, tikv_task:{proc max:155ms, min:0s, p80:100ms, p95:117ms, iters:30171, tasks:3010}, scan_detail: {total_process_keys: 17316513, total_keys: 20812624, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17316513, block: {cache_hit_count: 24260025, read_count: 225681, read_byte: 2.00 GB}}}	range: decided by [eq(tpch50.lineitem.l_orderkey, tpch50.lineitem.l_orderkey)], keep order:false	N/A	N/A
20:57:37 [2021-05-26T20:57:37.680Z]       │   └─TableRowIDScan_79(Probe)	4.05	17316513	cop[tikv]	table:l2	time:6m6s, loops:21041, cop_task: {num: 7809, max: 667ms, min: 553.1µs, avg: 173ms, p95: 358.5ms, max_proc_keys: 10451, p95_proc_keys: 4819, tot_proc: 16m16.3s, tot_wait: 5m15.9s, rpc_num: 7809, rpc_time: 22m31s, copr_cache: disabled}, tikv_task:{proc max:254ms, min:0s, p80:104ms, p95:140ms, iters:50066, tasks:7809}, scan_detail: {total_process_keys: 17316513, total_keys: 18290229, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5631864, block: {cache_hit_count: 99016928, read_count: 1135, read_byte: 416.9 MB}}}	keep order:false	N/A	N/A
20:57:37 [2021-05-26T20:57:37.680Z]       └─IndexLookUp_39(Probe)	4.05	12022812	root		time:1m48s, loops:11952, index_task: {total_time: 58.1s, fetch_handle: 48.6s, build: 5.5ms, wait: 9.48s}, table_task: {total_time: 7m47.2s, num: 1408, concurrency: 730}		219.2 KB	N/A
20:57:37 [2021-05-26T20:57:37.680Z]         ├─IndexRangeScan_36(Build)	5.06	17183413	cop[tikv]	table:l3, index:PRIMARY(L_ORDERKEY, L_LINENUMBER)	time:46.2s, loops:18360, cop_task: {num: 2789, max: 791.6ms, min: 431.2µs, avg: 160.6ms, p95: 354.5ms, max_proc_keys: 18140, p95_proc_keys: 13795, tot_proc: 5m38.2s, tot_wait: 1m24.4s, rpc_num: 2789, rpc_time: 7m27.9s, copr_cache: disabled}, tikv_task:{proc max:186ms, min:0s, p80:84ms, p95:128ms, iters:29052, tasks:2789}, scan_detail: {total_process_keys: 17183413, total_keys: 20546442, rocksdb: {delete_skipped_count: 0, key_skipped_count: 17183413, block: {cache_hit_count: 23554011, 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:37 [2021-05-26T20:57:37.680Z]         └─Selection_38(Probe)	4.05	12022812	cop[tikv]		time:5m57.8s, loops:13772, cop_task: {num: 10218, max: 636ms, min: 454.5µs, avg: 166.8ms, p95: 345.3ms, max_proc_keys: 7024, p95_proc_keys: 3928, tot_proc: 19m49s, tot_wait: 7m13.8s, rpc_num: 10218, rpc_time: 28m24.1s, copr_cache: disabled}, tikv_task:{proc max:200ms, min:0s, p80:77ms, p95:115ms, iters:60607, tasks:10218}, scan_detail: {total_process_keys: 17183413, total_keys: 18129149, rocksdb: {delete_skipped_count: 0, key_skipped_count: 5527388, block: {cache_hit_count: 98286504, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.lineitem.l_receiptdate, tpch50.lineitem.l_commitdate)	N/A	N/A
20:57:37 [2021-05-26T20:57:37.680Z]           └─TableRowIDScan_37	5.06	17183413	cop[tikv]	table:l3	tikv_task:{proc max:198ms, min:0s, p80:77ms, p95:114ms, iters:60607, tasks:10218}	keep order:false	N/A	N/A
20:57:37 [2021-05-26T20:57:37.680Z] + tiup cluster stop benchbot -y
20:57:37 [2021-05-26T20:57:37.680Z] Starting component `cluster`: /home/tidb/.tiup/components/cluster/v1.4.3/tiup-cluster stop benchbot -y
20:57:41 [2021-05-26T20:57:41.015Z] + rm -rf '/data1/tidb-deploy/*/log/*'
20:57:41 [2021-05-26T20:57:41.015Z] + rm -rf /data1/jenkins/deploy/data/tikv-20160
20:57:44 [2021-05-26T20:57:44.403Z] + rm -rf /data1/jenkins/deploy/data/pd-2379
20:57:44 [2021-05-26T20:57:44.403Z] + rm -rf /data1/jenkins/restore_data/tpch50/data/last_tikv.toml
20:57:44 [2021-05-26T20:57:44.403Z] + cp -R /data1/jenkins/restore_data/tpch50/data /data1/jenkins/deploy/data/tikv-20160
20:59:23 [2021-05-26T20:59:23.105Z] + cp -R /data1/jenkins/restore_data/tpch50/data.pd /data1/jenkins/deploy/data/pd-2379
20:59:23 [2021-05-26T20:59:23.105Z] + '[' -n '' ']'
20:59:23 [2021-05-26T20:59:23.105Z] + tiup cluster start benchbot --wait-timeout=300
20:59:23 [2021-05-26T20:59:23.105Z] Starting component `cluster`: /home/tidb/.tiup/components/cluster/v1.4.3/tiup-cluster start benchbot --wait-timeout=300
20:59:55 [2021-05-26T20:59:55.372Z] + sync
20:59:55 [2021-05-26T20:59:55.372Z] + /usr/bin/echo 3
21:00:34 [2021-05-26T21:00:34.116Z] + sync
21:00:34 [2021-05-26T21:00:34.116Z] + /usr/bin/echo 3
21:01:00 [2021-05-26T21:01:00.613Z] + sync
21:01:00 [2021-05-26T21:01:00.613Z] + /usr/bin/echo 3
21:01:32 [2021-05-26T21:01:32.639Z] 
21:01:32 [2021-05-26T21:01:32.639Z] queries/22.sql
21:01:32 [2021-05-26T21:01:32.639Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
21:01:32 [2021-05-26T21:01:32.639Z] Sort_39	1600000.00	4	root		time:26.7s, loops:2	Column#27	9.48 KB	0 Bytes
21:01:32 [2021-05-26T21:01:32.639Z] └─Projection_41	1600000.00	4	root		time:26.7s, loops:5, Concurrency:5	Column#27, Column#28, Column#29	23.7 KB	N/A
21:01:32 [2021-05-26T21:01:32.639Z]   └─HashAgg_42	1600000.00	4	root		time:26.7s, loops:5, partial_worker:{wall_time:26.706514971s, concurrency:5, task_num:180, tot_wait:2m13.483650964s, tot_exec:47.925547ms, tot_time:2m13.531674265s, max:26.706430255s, p95:26.706430255s}, final_worker:{wall_time:26.706529652s, concurrency:5, task_num:20, tot_wait:2m13.532145909s, tot_exec:179.933µs, tot_time:2m13.532334437s, max:26.7065019s, p95:26.7065019s}	group by:Column#33, funcs:count(1)->Column#28, funcs:sum(Column#31)->Column#29, funcs:firstrow(Column#32)->Column#27	857.7 KB	N/A
21:01:32 [2021-05-26T21:01:32.640Z]     └─Projection_51	1600000.00	181704	root		time:26.7s, loops:181, Concurrency:5	tpch50.customer.c_acctbal, substring(tpch50.customer.c_phone, 1, 2)->Column#32, substring(tpch50.customer.c_phone, 1, 2)->Column#33	703.6 KB	N/A
21:01:32 [2021-05-26T21:01:32.640Z]       └─HashJoin_43	1600000.00	181704	root		time:26.7s, loops:181, build_hash_table:{total:25.4s, fetch:984ms, build:24.4s}, probe:{concurrency:5, total:2m13.5s, max:26.7s, probe:5.35s, fetch:2m8.2s}	anti semi join, equal:[eq(tpch50.customer.c_custkey, tpch50.orders.o_custkey)]	590.2 MB	0 Bytes
21:01:32 [2021-05-26T21:01:32.640Z]         ├─TableReader_49(Build)	75000000.00	75000000	root		time:1.03s, loops:73364, cop_task: {num: 153, max: 960.2ms, min: 273.8ms, avg: 589.2ms, p95: 884.5ms, max_proc_keys: 723875, p95_proc_keys: 553332, tot_proc: 1m29.3s, tot_wait: 46ms, rpc_num: 153, rpc_time: 1m30.1s, copr_cache: disabled}	data:TableFullScan_48	57.8 MB	N/A
21:01:32 [2021-05-26T21:01:32.640Z]         │ └─TableFullScan_48	75000000.00	75000000	cop[tikv]	table:orders	tikv_task:{proc max:937ms, min:261ms, p80:584ms, p95:857ms, 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: 3025, read_count: 219928, read_byte: 4.30 GB}}}	keep order:false	N/A	N/A
21:01:32 [2021-05-26T21:01:32.640Z]         └─Selection_47(Probe)	2000000.00	545246	root		time:1.28s, loops:534	in(substring(tpch50.customer.c_phone, 1, 2), "20", "40", "22", "30", "39", "42", "21")	94.6 KB	N/A
21:01:32 [2021-05-26T21:01:32.640Z]           └─TableReader_46	2000000.00	3407619	root		time:435.7ms, loops:3319, cop_task: {num: 18, max: 1.18s, min: 356ms, avg: 819.9ms, p95: 1.18s, max_proc_keys: 582617, p95_proc_keys: 582617, tot_proc: 14.3s, tot_wait: 5ms, rpc_num: 18, rpc_time: 14.8s, copr_cache: disabled}	data:Selection_45	192.5 MB	N/A
21:01:32 [2021-05-26T21:01:32.640Z]             └─Selection_45	2000000.00	3407619	cop[tikv]		tikv_task:{proc max:1.12s, min:334ms, p80:891ms, p95:1.12s, iters:7404, tasks:18}, scan_detail: {total_process_keys: 7500000, total_keys: 7500018, rocksdb: {delete_skipped_count: 0, key_skipped_count: 14999982, block: {cache_hit_count: 28451, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.customer.c_acctbal, 5000.602894)	N/A	N/A
21:01:32 [2021-05-26T21:01:32.640Z]               └─TableFullScan_44	7500000.00	7500000	cop[tikv]	table:customer	tikv_task:{proc max:1.01s, min:294ms, p80:815ms, p95:1.01s, iters:7404, tasks:18}	keep order:false	N/A	N/A
21:01:32 [2021-05-26T21:01:32.640Z] 
21:01:32 [2021-05-26T21:01:32.640Z] queries/22.sql
21:01:32 [2021-05-26T21:01:32.640Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
21:01:32 [2021-05-26T21:01:32.640Z] Sort_39	2186432.06	4	root		time:26.7s, loops:2	Column#27	9.48 KB	0 Bytes
21:01:32 [2021-05-26T21:01:32.640Z] └─Projection_41	2186432.06	4	root		time:26.7s, loops:5, Concurrency:5	Column#27, Column#28, Column#29	23.7 KB	N/A
21:01:32 [2021-05-26T21:01:32.640Z]   └─HashAgg_42	2186432.06	4	root		time:26.7s, loops:5, partial_worker:{wall_time:26.692958233s, concurrency:5, task_num:180, tot_wait:2m13.414855942s, tot_exec:48.682808ms, tot_time:2m13.463663815s, max:26.692811855s, p95:26.692811855s}, final_worker:{wall_time:26.692984202s, concurrency:5, task_num:20, tot_wait:2m13.463842561s, tot_exec:222.907µs, tot_time:2m13.464074955s, max:26.692832608s, p95:26.692832608s}	group by:Column#33, funcs:count(1)->Column#28, funcs:sum(Column#31)->Column#29, funcs:firstrow(Column#32)->Column#27	857.7 KB	N/A
21:01:32 [2021-05-26T21:01:32.640Z]     └─Projection_51	2186432.06	181704	root		time:26.7s, loops:181, Concurrency:5	tpch50.customer.c_acctbal, substring(tpch50.customer.c_phone, 1, 2)->Column#32, substring(tpch50.customer.c_phone, 1, 2)->Column#33	703.6 KB	N/A
21:01:32 [2021-05-26T21:01:32.640Z]       └─HashJoin_43	2186432.06	181704	root		time:26.7s, loops:181, build_hash_table:{total:25.2s, fetch:988ms, build:24.2s}, probe:{concurrency:5, total:2m13.4s, max:26.7s, probe:6.38s, fetch:2m7.1s}	anti semi join, equal:[eq(tpch50.customer.c_custkey, tpch50.orders.o_custkey)]	590.2 MB	0 Bytes
21:01:32 [2021-05-26T21:01:32.640Z]         ├─TableReader_49(Build)	75000000.00	75000000	root		time:1s, loops:73364, cop_task: {num: 153, max: 1.16s, min: 244.4ms, avg: 544.8ms, p95: 934.1ms, max_proc_keys: 723875, p95_proc_keys: 553332, tot_proc: 1m22.6s, tot_wait: 33ms, rpc_num: 153, rpc_time: 1m23.4s, copr_cache: disabled}	data:TableFullScan_48	57.8 MB	N/A
21:01:32 [2021-05-26T21:01:32.640Z]         │ └─TableFullScan_48	75000000.00	75000000	cop[tikv]	table:orders	tikv_task:{proc max:1.12s, min:233ms, p80:595ms, p95:904ms, iters:73975, tasks:153}, scan_detail: {total_process_keys: 75000000, total_keys: 75000153, rocksdb: {delete_skipped_count: 0, key_skipped_count: 149999847, block: {cache_hit_count: 220923, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
21:01:32 [2021-05-26T21:01:32.640Z]         └─Selection_47(Probe)	2733040.07	545246	root		time:1.38s, loops:534	in(substring(tpch50.customer.c_phone, 1, 2), "20", "40", "22", "30", "39", "42", "21")	94.6 KB	N/A
21:01:32 [2021-05-26T21:01:32.640Z]           └─TableReader_46	2733040.07	3407619	root		time:525.7ms, loops:3319, cop_task: {num: 18, max: 1.23s, min: 398.6ms, avg: 917.1ms, p95: 1.23s, max_proc_keys: 582617, p95_proc_keys: 582617, tot_proc: 16.1s, tot_wait: 1ms, rpc_num: 18, rpc_time: 16.5s, copr_cache: disabled}	data:Selection_45	192.5 MB	N/A
21:01:32 [2021-05-26T21:01:32.640Z]             └─Selection_45	2733040.07	3407619	cop[tikv]		tikv_task:{proc max:1.15s, min:346ms, 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:01:32 [2021-05-26T21:01:32.640Z]               └─TableFullScan_44	7500000.00	7500000	cop[tikv]	table:customer	tikv_task:{proc max:1.07s, min:321ms, p80:950ms, p95:1.07s, iters:7404, tasks:18}	keep order:false	N/A	N/A
21:01:32 [2021-05-26T21:01:32.640Z] 
21:01:32 [2021-05-26T21:01:32.640Z] queries/22.sql
21:01:32 [2021-05-26T21:01:32.640Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
21:01:32 [2021-05-26T21:01:32.640Z] Sort_39	2186432.06	4	root		time:26.2s, loops:2	Column#27	9.48 KB	0 Bytes
21:01:32 [2021-05-26T21:01:32.640Z] └─Projection_41	2186432.06	4	root		time:26.2s, loops:5, Concurrency:5	Column#27, Column#28, Column#29	23.7 KB	N/A
21:01:32 [2021-05-26T21:01:32.640Z]   └─HashAgg_42	2186432.06	4	root		time:26.2s, loops:5, partial_worker:{wall_time:26.213840961s, concurrency:5, task_num:180, tot_wait:2m11.019356538s, tot_exec:48.89131ms, tot_time:2m11.068355217s, max:26.21370566s, p95:26.21370566s}, final_worker:{wall_time:26.213881131s, concurrency:5, task_num:20, tot_wait:2m11.068625928s, tot_exec:230.231µs, tot_time:2m11.068866826s, max:26.213811748s, p95:26.213811748s}	group by:Column#33, funcs:count(1)->Column#28, funcs:sum(Column#31)->Column#29, funcs:firstrow(Column#32)->Column#27	857.7 KB	N/A
21:01:32 [2021-05-26T21:01:32.640Z]     └─Projection_51	2186432.06	181704	root		time:26.2s, loops:181, Concurrency:5	tpch50.customer.c_acctbal, substring(tpch50.customer.c_phone, 1, 2)->Column#32, substring(tpch50.customer.c_phone, 1, 2)->Column#33	703.6 KB	N/A
21:01:32 [2021-05-26T21:01:32.640Z]       └─HashJoin_43	2186432.06	181704	root		time:26.2s, loops:181, build_hash_table:{total:24.8s, fetch:970.9ms, build:23.9s}, probe:{concurrency:5, total:2m11s, max:26.2s, probe:5.7s, fetch:2m5.3s}	anti semi join, equal:[eq(tpch50.customer.c_custkey, tpch50.orders.o_custkey)]	590.2 MB	0 Bytes
21:01:32 [2021-05-26T21:01:32.640Z]         ├─TableReader_49(Build)	75000000.00	75000000	root		time:998.6ms, loops:73364, cop_task: {num: 153, max: 948.2ms, min: 207ms, avg: 490.4ms, p95: 820.6ms, max_proc_keys: 723875, p95_proc_keys: 553332, tot_proc: 1m14.3s, tot_wait: 43ms, rpc_num: 153, rpc_time: 1m15s, copr_cache: disabled}	data:TableFullScan_48	57.8 MB	N/A
21:01:32 [2021-05-26T21:01:32.640Z]         │ └─TableFullScan_48	75000000.00	75000000	cop[tikv]	table:orders	tikv_task:{proc max:918ms, min:197ms, p80:502ms, p95:788ms, iters:73975, tasks:153}, scan_detail: {total_process_keys: 75000000, total_keys: 75000153, rocksdb: {delete_skipped_count: 0, key_skipped_count: 149999847, block: {cache_hit_count: 220923, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
21:01:32 [2021-05-26T21:01:32.640Z]         └─Selection_47(Probe)	2733040.07	545246	root		time:1.42s, loops:534	in(substring(tpch50.customer.c_phone, 1, 2), "20", "40", "22", "30", "39", "42", "21")	94.6 KB	N/A
21:01:32 [2021-05-26T21:01:32.640Z]           └─TableReader_46	2733040.07	3407619	root		time:576.6ms, loops:3319, cop_task: {num: 18, max: 1.04s, min: 469.5ms, avg: 825.4ms, p95: 1.04s, max_proc_keys: 582617, p95_proc_keys: 582617, tot_proc: 14.5s, tot_wait: 3ms, rpc_num: 18, rpc_time: 14.9s, copr_cache: disabled}	data:Selection_45	192.5 MB	N/A
21:01:32 [2021-05-26T21:01:32.640Z]             └─Selection_45	2733040.07	3407619	cop[tikv]		tikv_task:{proc max:973ms, min:437ms, p80:935ms, p95:973ms, iters:7404, tasks:18}, scan_detail: {total_process_keys: 7500000, total_keys: 7500018, rocksdb: {delete_skipped_count: 0, key_skipped_count: 14999982, block: {cache_hit_count: 28451, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.customer.c_acctbal, 5000.602894)	N/A	N/A
21:01:32 [2021-05-26T21:01:32.640Z]               └─TableFullScan_44	7500000.00	7500000	cop[tikv]	table:customer	tikv_task:{proc max:876ms, min:398ms, p80:855ms, p95:876ms, iters:7404, tasks:18}	keep order:false	N/A	N/A
21:01:32 [2021-05-26T21:01:32.640Z] + sync
21:01:32 [2021-05-26T21:01:32.640Z] + /usr/bin/echo 3
21:01:59 [2021-05-26T21:01:59.135Z] + sync
21:01:59 [2021-05-26T21:01:59.135Z] + /usr/bin/echo 3
21:02:31 [2021-05-26T21:02:31.157Z] + sync
21:02:31 [2021-05-26T21:02:31.157Z] + /usr/bin/echo 3
21:02:57 [2021-05-26T21:02:57.655Z] 
21:02:57 [2021-05-26T21:02:57.655Z] queries/22.sql
21:02:57 [2021-05-26T21:02:57.655Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
21:02:57 [2021-05-26T21:02:57.655Z] Sort_39	2186432.06	4	root		time:26.6s, loops:2	Column#27	9.48 KB	0 Bytes
21:02:57 [2021-05-26T21:02:57.655Z] └─Projection_41	2186432.06	4	root		time:26.6s, loops:5, Concurrency:5	Column#27, Column#28, Column#29	23.7 KB	N/A
21:02:57 [2021-05-26T21:02:57.655Z]   └─HashAgg_42	2186432.06	4	root		time:26.6s, loops:5, partial_worker:{wall_time:26.563493383s, concurrency:5, task_num:180, tot_wait:2m12.767126745s, tot_exec:49.15533ms, tot_time:2m12.816397958s, max:26.563417929s, p95:26.563417929s}, final_worker:{wall_time:26.563508698s, concurrency:5, task_num:20, tot_wait:2m12.817155063s, tot_exec:173.526µs, tot_time:2m12.81733728s, max:26.563477584s, p95:26.563477584s}	group by:Column#33, funcs:count(1)->Column#28, funcs:sum(Column#31)->Column#29, funcs:firstrow(Column#32)->Column#27	857.7 KB	N/A
21:02:57 [2021-05-26T21:02:57.655Z]     └─Projection_51	2186432.06	181704	root		time:26.6s, loops:181, Concurrency:5	tpch50.customer.c_acctbal, substring(tpch50.customer.c_phone, 1, 2)->Column#32, substring(tpch50.customer.c_phone, 1, 2)->Column#33	703.6 KB	N/A
21:02:57 [2021-05-26T21:02:57.655Z]       └─HashJoin_43	2186432.06	181704	root		time:26.6s, loops:181, build_hash_table:{total:25.1s, fetch:1.01s, build:24.1s}, probe:{concurrency:5, total:2m12.8s, max:26.6s, probe:6.17s, fetch:2m6.6s}	anti semi join, equal:[eq(tpch50.customer.c_custkey, tpch50.orders.o_custkey)]	590.2 MB	0 Bytes
21:02:57 [2021-05-26T21:02:57.655Z]         ├─TableReader_49(Build)	75000000.00	75000000	root		time:1.04s, loops:73364, cop_task: {num: 153, max: 923ms, min: 210.8ms, avg: 498.9ms, p95: 845ms, max_proc_keys: 723875, p95_proc_keys: 553332, tot_proc: 1m15.6s, tot_wait: 51ms, rpc_num: 153, rpc_time: 1m16.3s, copr_cache: disabled}	data:TableFullScan_48	57.8 MB	N/A
21:02:57 [2021-05-26T21:02:57.655Z]         │ └─TableFullScan_48	75000000.00	75000000	cop[tikv]	table:orders	tikv_task:{proc max:899ms, min:201ms, p80:494ms, p95:821ms, iters:73975, tasks:153}, scan_detail: {total_process_keys: 75000000, total_keys: 75000153, rocksdb: {delete_skipped_count: 0, key_skipped_count: 149999847, block: {cache_hit_count: 220923, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
21:02:57 [2021-05-26T21:02:57.655Z]         └─Selection_47(Probe)	2733040.07	545246	root		time:1.46s, loops:534	in(substring(tpch50.customer.c_phone, 1, 2), "20", "40", "22", "30", "39", "42", "21")	94.6 KB	N/A
21:02:57 [2021-05-26T21:02:57.655Z]           └─TableReader_46	2733040.07	3407619	root		time:625.6ms, loops:3319, cop_task: {num: 18, max: 1.21s, min: 468.6ms, avg: 877.6ms, p95: 1.21s, 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:02:57 [2021-05-26T21:02:57.655Z]             └─Selection_45	2733040.07	3407619	cop[tikv]		tikv_task:{proc max:1.12s, min:426ms, p80:951ms, 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:02:57 [2021-05-26T21:02:57.655Z]               └─TableFullScan_44	7500000.00	7500000	cop[tikv]	table:customer	tikv_task:{proc max:1.05s, min:378ms, p80:870ms, p95:1.05s, iters:7404, tasks:18}	keep order:false	N/A	N/A
21:02:57 [2021-05-26T21:02:57.655Z] 
21:02:57 [2021-05-26T21:02:57.655Z] queries/22.sql
21:02:57 [2021-05-26T21:02:57.655Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
21:02:57 [2021-05-26T21:02:57.655Z] Sort_39	2186432.06	4	root		time:25.9s, loops:2	Column#27	9.48 KB	0 Bytes
21:02:57 [2021-05-26T21:02:57.656Z] └─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:02:57 [2021-05-26T21:02:57.656Z]   └─HashAgg_42	2186432.06	4	root		time:25.9s, loops:5, partial_worker:{wall_time:25.893039879s, concurrency:5, task_num:180, tot_wait:2m9.413350429s, tot_exec:50.616251ms, tot_time:2m9.464077439s, max:25.892982456s, p95:25.892982456s}, final_worker:{wall_time:25.89307037s, concurrency:5, task_num:20, tot_wait:2m9.464839462s, tot_exec:236.137µs, tot_time:2m9.465081404s, max:25.893029462s, p95:25.893029462s}	group by:Column#33, funcs:count(1)->Column#28, funcs:sum(Column#31)->Column#29, funcs:firstrow(Column#32)->Column#27	857.7 KB	N/A
21:02:57 [2021-05-26T21:02:57.656Z]     └─Projection_51	2186432.06	181704	root		time:25.9s, loops:181, Concurrency:5	tpch50.customer.c_acctbal, substring(tpch50.customer.c_phone, 1, 2)->Column#32, substring(tpch50.customer.c_phone, 1, 2)->Column#33	703.6 KB	N/A
21:02:57 [2021-05-26T21:02:57.656Z]       └─HashJoin_43	2186432.06	181704	root		time:25.9s, loops:181, build_hash_table:{total:24.6s, fetch:951ms, build:23.6s}, probe:{concurrency:5, total:2m9.4s, max:25.9s, probe:5.45s, fetch:2m4s}	anti semi join, equal:[eq(tpch50.customer.c_custkey, tpch50.orders.o_custkey)]	590.2 MB	0 Bytes
21:02:57 [2021-05-26T21:02:57.656Z]         ├─TableReader_49(Build)	75000000.00	75000000	root		time:970.8ms, loops:73364, cop_task: {num: 153, max: 964.4ms, min: 243.9ms, avg: 496.4ms, p95: 814.8ms, max_proc_keys: 723875, p95_proc_keys: 553332, tot_proc: 1m15.2s, tot_wait: 23ms, rpc_num: 153, rpc_time: 1m15.9s, copr_cache: disabled}	data:TableFullScan_48	57.8 MB	N/A
21:02:57 [2021-05-26T21:02:57.656Z]         │ └─TableFullScan_48	75000000.00	75000000	cop[tikv]	table:orders	tikv_task:{proc max:934ms, min:233ms, p80:502ms, p95:764ms, iters:73975, tasks:153}, scan_detail: {total_process_keys: 75000000, total_keys: 75000153, rocksdb: {delete_skipped_count: 0, key_skipped_count: 149999847, block: {cache_hit_count: 220923, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
21:02:57 [2021-05-26T21:02:57.656Z]         └─Selection_47(Probe)	2733040.07	545246	root		time:1.4s, loops:534	in(substring(tpch50.customer.c_phone, 1, 2), "20", "40", "22", "30", "39", "42", "21")	94.6 KB	N/A
21:02:57 [2021-05-26T21:02:57.656Z]           └─TableReader_46	2733040.07	3407619	root		time:565.3ms, loops:3319, cop_task: {num: 18, max: 1.26s, min: 444.8ms, avg: 848.9ms, p95: 1.26s, max_proc_keys: 582617, p95_proc_keys: 582617, tot_proc: 14.9s, tot_wait: 6ms, rpc_num: 18, rpc_time: 15.3s, copr_cache: disabled}	data:Selection_45	192.5 MB	N/A
21:02:57 [2021-05-26T21:02:57.656Z]             └─Selection_45	2733040.07	3407619	cop[tikv]		tikv_task:{proc max:1.17s, min:417ms, p80:1s, p95:1.17s, iters:7404, tasks:18}, scan_detail: {total_process_keys: 7500000, total_keys: 7500018, rocksdb: {delete_skipped_count: 0, key_skipped_count: 14999982, block: {cache_hit_count: 28451, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.customer.c_acctbal, 5000.602894)	N/A	N/A
21:02:57 [2021-05-26T21:02:57.656Z]               └─TableFullScan_44	7500000.00	7500000	cop[tikv]	table:customer	tikv_task:{proc max:1.1s, min:390ms, p80:923ms, p95:1.1s, iters:7404, tasks:18}	keep order:false	N/A	N/A
21:02:57 [2021-05-26T21:02:57.656Z] 
21:02:57 [2021-05-26T21:02:57.656Z] queries/22.sql
21:02:57 [2021-05-26T21:02:57.656Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
21:02:57 [2021-05-26T21:02:57.656Z] Sort_39	2186432.06	4	root		time:25.1s, loops:2	Column#27	9.48 KB	0 Bytes
21:02:57 [2021-05-26T21:02:57.656Z] └─Projection_41	2186432.06	4	root		time:25.1s, loops:5, Concurrency:5	Column#27, Column#28, Column#29	23.7 KB	N/A
21:02:57 [2021-05-26T21:02:57.656Z]   └─HashAgg_42	2186432.06	4	root		time:25.1s, loops:5, partial_worker:{wall_time:25.142025704s, concurrency:5, task_num:180, tot_wait:2m5.652095513s, tot_exec:57.550306ms, tot_time:2m5.709815515s, max:25.142002116s, p95:25.142002116s}, final_worker:{wall_time:25.142080635s, concurrency:5, task_num:20, tot_wait:2m5.709923796s, tot_exec:247.112µs, tot_time:2m5.71018235s, max:25.142059576s, p95:25.142059576s}	group by:Column#33, funcs:count(1)->Column#28, funcs:sum(Column#31)->Column#29, funcs:firstrow(Column#32)->Column#27	857.7 KB	N/A
21:02:57 [2021-05-26T21:02:57.656Z]     └─Projection_51	2186432.06	181704	root		time:25.1s, loops:181, Concurrency:5	tpch50.customer.c_acctbal, substring(tpch50.customer.c_phone, 1, 2)->Column#32, substring(tpch50.customer.c_phone, 1, 2)->Column#33	703.6 KB	N/A
21:02:57 [2021-05-26T21:02:57.656Z]       └─HashJoin_43	2186432.06	181704	root		time:25.1s, loops:181, build_hash_table:{total:23.6s, fetch:800.7ms, build:22.7s}, probe:{concurrency:5, total:2m5.7s, max:25.1s, probe:6.26s, fetch:1m59.4s}	anti semi join, equal:[eq(tpch50.customer.c_custkey, tpch50.orders.o_custkey)]	590.2 MB	0 Bytes
21:02:57 [2021-05-26T21:02:57.656Z]         ├─TableReader_49(Build)	75000000.00	75000000	root		time:816.1ms, loops:73364, cop_task: {num: 153, max: 1.03s, min: 233.3ms, avg: 491.3ms, p95: 813.7ms, max_proc_keys: 723875, p95_proc_keys: 553332, tot_proc: 1m14.5s, tot_wait: 37ms, rpc_num: 153, rpc_time: 1m15.2s, copr_cache: disabled}	data:TableFullScan_48	57.8 MB	N/A
21:02:57 [2021-05-26T21:02:57.656Z]         │ └─TableFullScan_48	75000000.00	75000000	cop[tikv]	table:orders	tikv_task:{proc max:1s, min:223ms, p80:490ms, p95:791ms, iters:73975, tasks:153}, scan_detail: {total_process_keys: 75000000, total_keys: 75000153, rocksdb: {delete_skipped_count: 0, key_skipped_count: 149999847, block: {cache_hit_count: 220923, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
21:02:57 [2021-05-26T21:02:57.656Z]         └─Selection_47(Probe)	2733040.07	545246	root		time:1.63s, loops:534	in(substring(tpch50.customer.c_phone, 1, 2), "20", "40", "22", "30", "39", "42", "21")	94.6 KB	N/A
21:02:57 [2021-05-26T21:02:57.656Z]           └─TableReader_46	2733040.07	3407619	root		time:660.1ms, loops:3319, cop_task: {num: 18, max: 1.16s, min: 487.2ms, avg: 887.1ms, p95: 1.16s, max_proc_keys: 582617, p95_proc_keys: 582617, tot_proc: 15.5s, tot_wait: 1ms, rpc_num: 18, rpc_time: 16s, copr_cache: disabled}	data:Selection_45	192.5 MB	N/A
21:02:57 [2021-05-26T21:02:57.656Z]             └─Selection_45	2733040.07	3407619	cop[tikv]		tikv_task:{proc max:1.07s, min:461ms, p80:969ms, p95:1.07s, iters:7404, tasks:18}, scan_detail: {total_process_keys: 7500000, total_keys: 7500018, rocksdb: {delete_skipped_count: 0, key_skipped_count: 14999982, block: {cache_hit_count: 28451, read_count: 0, read_byte: 0 Bytes}}}	gt(tpch50.customer.c_acctbal, 5000.602894)	N/A	N/A
21:02:57 [2021-05-26T21:02:57.656Z]               └─TableFullScan_44	7500000.00	7500000	cop[tikv]	table:customer	tikv_task:{proc max:987ms, min:423ms, p80:888ms, p95:987ms, iters:7404, tasks:18}	keep order:false	N/A	N/A
21:02:57 [2021-05-26T21:02:57.656Z] + sync
21:02:57 [2021-05-26T21:02:57.656Z] + /usr/bin/echo 3
21:03:29 [2021-05-26T21:03:29.700Z] 
21:03:29 [2021-05-26T21:03:29.700Z] queries/22.sql
21:03:29 [2021-05-26T21:03:29.700Z] id	estRows	actRows	task	access object	execution info	operator info	memory	disk
21:03:29 [2021-05-26T21:03:29.700Z] Sort_39	2186432.06	4	root		time:26.2s, loops:2	Column#27	9.48 KB	0 Bytes
21:03:29 [2021-05-26T21:03:29.700Z] └─Projection_41	2186432.06	4	root		time:26.2s, loops:5, Concurrency:5	Column#27, Column#28, Column#29	23.7 KB	N/A
21:03:29 [2021-05-26T21:03:29.700Z]   └─HashAgg_42	2186432.06	4	root		time:26.2s, loops:5, partial_worker:{wall_time:26.219173066s, concurrency:5, task_num:180, tot_wait:2m11.041983526s, tot_exec:52.844018ms, tot_time:2m11.095005833s, max:26.219108971s, p95:26.219108971s}, final_worker:{wall_time:26.219185364s, concurrency:5, task_num:20, tot_wait:2m11.09542605s, tot_exec:271.48µs, tot_time:2m11.095706713s, max:26.219143084s, p95:26.219143084s}	group by:Column#33, funcs:count(1)->Column#28, funcs:sum(Column#31)->Column#29, funcs:firstrow(Column#32)->Column#27	857.7 KB	N/A
21:03:29 [2021-05-26T21:03:29.700Z]     └─Projection_51	2186432.06	181704	root		time:26.2s, loops:181, Concurrency:5	tpch50.customer.c_acctbal, substring(tpch50.customer.c_phone, 1, 2)->Column#32, substring(tpch50.customer.c_phone, 1, 2)->Column#33	703.6 KB	N/A
21:03:29 [2021-05-26T21:03:29.700Z]       └─HashJoin_43	2186432.06	181704	root		time:26.2s, loops:181, build_hash_table:{total:24.7s, fetch:917.2ms, build:23.8s}, probe:{concurrency:5, total:2m11.1s, max:26.2s, probe:6.12s, fetch:2m5s}	anti semi join, equal:[eq(tpch50.customer.c_custkey, tpch50.orders.o_custkey)]	590.2 MB	0 Bytes
21:03:29 [2021-05-26T21:03:29.700Z]         ├─TableReader_49(Build)	75000000.00	75000000	root		time:945.7ms, loops:73364, cop_task: {num: 153, max: 962.8ms, min: 220.5ms, avg: 499.3ms, p95: 888.4ms, max_proc_keys: 723875, p95_proc_keys: 553332, tot_proc: 1m15.7s, tot_wait: 33ms, rpc_num: 153, rpc_time: 1m16.4s, copr_cache: disabled}	data:TableFullScan_48	57.8 MB	N/A
21:03:29 [2021-05-26T21:03:29.700Z]         │ └─TableFullScan_48	75000000.00	75000000	cop[tikv]	table:orders	tikv_task:{proc max:936ms, min:214ms, p80:493ms, p95:863ms, iters:73975, tasks:153}, scan_detail: {total_process_keys: 75000000, total_keys: 75000153, rocksdb: {delete_skipped_count: 0, key_skipped_count: 149999847, block: {cache_hit_count: 220923, read_count: 0, read_byte: 0 Bytes}}}	keep order:false	N/A	N/A
21:03:29 [2021-05-26T21:03:29.700Z]         └─Selection_47(Probe)	2733040.07	545246	root		time:1.53s, loops:534	in(substring(tpch50.customer.c_phone, 1, 2), "20", "40", "22", "30", "39", "42", "21")	94.6 KB	N/A
21:03:29 [2021-05-26T21:03:29.700Z]           └─TableReader_46	2733040.07	3407619	root		time:632.2ms, loops:3319, cop_task: {num: 18, max: 1.2s, min: 492ms, avg: 858.9ms, p95: 1.2s, max_proc_keys: 582617, p95_proc_keys: 582617, tot_proc: 15s, tot_wait: 14ms, rpc_num: 18, rpc_time: 15.5s, copr_cache: disabled}	data:Selection_45	192.5 MB	N/A
21:03:29 [2021-05-26T21:03:29.700Z]             └─Selection_45	2733040.07	3407619	cop[tikv]		tikv_task:{proc max:1.12s, min:452ms, p80:967ms, 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:03:29 [2021-05-26T21:03:29.700Z]               └─TableFullScan_44	7500000.00	7500000	cop[tikv]	table:customer	tikv_task:{proc max:1.02s, min:400ms, p80:856ms, p95:1.02s, iters:7404, tasks:18}	keep order:false	N/A	N/A
21:03:29 [2021-05-26T21:03:29.700Z] 
21:03:29 [2021-05-26T21:03:29.700Z] + tiup cluster stop benchbot
21:03:29 [2021-05-26T21:03:29.700Z] Starting component `cluster`: /home/tidb/.tiup/components/cluster/v1.4.3/tiup-cluster stop benchbot
21:03:30 [2021-05-26T21:03:30.261Z] + [ Serial ] - SSHKeySet: privateKey=/home/tidb/.tiup/storage/cluster/clusters/benchbot/ssh/id_rsa, publicKey=/home/tidb/.tiup/storage/cluster/clusters/benchbot/ssh/id_rsa.pub
21:03:30 [2021-05-26T21:03:30.261Z] + [Parallel] - UserSSH: user=tidb, host=172.16.5.86
21:03:30 [2021-05-26T21:03:30.261Z] + [Parallel] - UserSSH: user=tidb, host=172.16.5.86
21:03:30 [2021-05-26T21:03:30.261Z] + [Parallel] - UserSSH: user=tidb, host=172.16.5.86
21:03:30 [2021-05-26T21:03:30.261Z] + [Parallel] - UserSSH: user=tidb, host=172.16.5.86
21:03:30 [2021-05-26T21:03:30.261Z] + [Parallel] - UserSSH: user=tidb, host=172.16.5.86
21:03:30 [2021-05-26T21:03:30.261Z] + [ Serial ] - StopCluster
21:03:30 [2021-05-26T21:03:30.261Z] Stopping component grafana
21:03:30 [2021-05-26T21:03:30.261Z] 	Stopping instance 172.16.5.86
21:03:31 [2021-05-26T21:03:31.189Z] 	Stop grafana 172.16.5.86:3000 success
21:03:31 [2021-05-26T21:03:31.189Z] Stopping component prometheus
21:03:31 [2021-05-26T21:03:31.189Z] 	Stopping instance 172.16.5.86
21:03:31 [2021-05-26T21:03:31.444Z] 	Stop prometheus 172.16.5.86:9090 success
21:03:31 [2021-05-26T21:03:31.444Z] Stopping component tidb
21:03:31 [2021-05-26T21:03:31.444Z] 	Stopping instance 172.16.5.86
21:03:34 [2021-05-26T21:03:34.707Z] 	Stop tidb 172.16.5.86:4000 success
21:03:34 [2021-05-26T21:03:34.707Z] Stopping component tikv
21:03:34 [2021-05-26T21:03:34.707Z] 	Stopping instance 172.16.5.86
21:03:38 [2021-05-26T21:03:38.869Z] 	Stop tikv 172.16.5.86:20160 success
21:03:38 [2021-05-26T21:03:38.869Z] Stopping component pd
21:03:38 [2021-05-26T21:03:38.869Z] 	Stopping instance 172.16.5.86
21:03:38 [2021-05-26T21:03:38.869Z] 	Stop pd 172.16.5.86:2379 success
21:03:38 [2021-05-26T21:03:38.869Z] Stopping component node_exporter
21:03:38 [2021-05-26T21:03:38.869Z] Stopping component blackbox_exporter
21:03:39 [2021-05-26T21:03:39.124Z] Stopped cluster `benchbot` successfully
21:03:39 [2021-05-26T21:03:39.132Z] [Pipeline] sh
21:03:39 [2021-05-26T21:03:39.414Z] + cat bench_result
21:03:39 [2021-05-26T21:03:39.421Z] [Pipeline] }
21:03:39 [2021-05-26T21:03:39.423Z] [Pipeline] // dir
21:03:39 [2021-05-26T21:03:39.424Z] [Pipeline] }
21:03:39 [2021-05-26T21:03:39.425Z] [Pipeline] // stage
21:03:39 [2021-05-26T21:03:39.427Z] [Pipeline] }
21:03:39 [2021-05-26T21:03:39.428Z] [Pipeline] // node
21:03:39 [2021-05-26T21:03:39.430Z] [Pipeline] }
21:03:39 [2021-05-26T21:03:39.431Z] [Pipeline] // catchError
21:03:39 [2021-05-26T21:03:39.435Z] [Pipeline] stage
21:03:39 [2021-05-26T21:03:39.437Z] [Pipeline] { (Summary)
21:03:39 [2021-05-26T21:03:39.448Z] [Pipeline] slackSend
21:03:39 [2021-05-26T21:03:39.449Z] Slack Send Pipeline step running, values are - baseUrl: <empty>, teamDomain: pingcap, channel: #daily_bench, color: good, botUser: false, tokenCredentialId: slack-pingcap-token, iconEmoji <empty>, username <empty>
21:03:39 [2021-05-26T21:03:39.480Z] sh: line 1: 158343 Terminated              sleep 3
21:03:39 [2021-05-26T21:03:39.493Z] sh: line 1: 158484 Terminated              sleep 3
21:03:40 [2021-05-26T21:03:40.388Z] [Pipeline] }
21:03:40 [2021-05-26T21:03:40.389Z] [Pipeline] // stage
21:03:40 [2021-05-26T21:03:40.391Z] [Pipeline] End of Pipeline
21:03:40 [2021-05-26T21:03:40.415Z] Finished: SUCCESS