doris icon indicating copy to clipboard operation
doris copied to clipboard

[Improment](executor)Add scanbytes/scanrows condition

Open wangbo opened this issue 1 year ago • 9 comments

Proposed changes

Add scanbytes/scanrows condition for workload schedule policy.

wangbo avatar Feb 24 '24 05:02 wangbo

Thank you for your contribution to Apache Doris. Don't know what should be done next? See How to process your PR

doris-robot avatar Feb 24 '24 05:02 doris-robot

run buildall

wangbo avatar Feb 24 '24 05:02 wangbo

clang-tidy review says "All clean, LGTM! :+1:"

github-actions[bot] avatar Feb 24 '24 05:02 github-actions[bot]

TPC-H: Total hot run time: 41157 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 4c2d205d7c9bc4f4e7dd9d0f5847d97d60f90033, data reload: false

------ Round 1 ----------------------------------
q1	17659	5008	4912	4912
q2	2044	141	133	133
q3	10684	1001	985	985
q4	4699	964	980	964
q5	7599	3151	3220	3151
q6	195	134	128	128
q7	1259	785	770	770
q8	9337	2064	2060	2060
q9	7447	6623	6591	6591
q10	8333	2664	2642	2642
q11	414	223	220	220
q12	827	337	331	331
q13	17941	3603	3608	3603
q14	300	290	255	255
q15	575	507	493	493
q16	474	406	423	406
q17	922	884	859	859
q18	7536	6592	6604	6592
q19	1566	1510	1498	1498
q20	550	290	265	265
q21	7196	4025	3971	3971
q22	874	346	328	328
Total cold run time: 108431 ms
Total hot run time: 41157 ms

----- Round 2, with runtime_filter_mode=off -----
q1	4867	4857	4864	4857
q2	295	183	184	183
q3	3599	3586	3582	3582
q4	2528	2523	2501	2501
q5	5764	5783	5765	5765
q6	209	123	125	123
q7	2244	1653	1641	1641
q8	3081	3106	3108	3106
q9	8719	8721	8704	8704
q10	6791	4235	4253	4235
q11	535	388	359	359
q12	769	545	560	545
q13	4436	3402	3436	3402
q14	266	238	240	238
q15	627	502	502	502
q16	478	448	464	448
q17	1676	1623	1633	1623
q18	8316	7640	7589	7589
q19	1632	1642	1639	1639
q20	2126	1839	1825	1825
q21	6608	6229	6202	6202
q22	577	529	510	510
Total cold run time: 66143 ms
Total hot run time: 59579 ms

doris-robot avatar Feb 24 '24 05:02 doris-robot

TPC-DS: Total hot run time: 176186 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
TPC-DS sf100 test result on commit 4c2d205d7c9bc4f4e7dd9d0f5847d97d60f90033, data reload: false

query1	921	353	347	347
query2	6525	1785	1710	1710
query3	6698	208	199	199
query4	23209	21205	21104	21104
query5	4296	376	376	376
query6	256	178	175	175
query7	4612	290	287	287
query8	242	193	217	193
query9	8430	2767	2767	2767
query10	406	234	224	224
query11	15050	14503	14530	14503
query12	147	81	83	81
query13	1705	420	422	420
query14	9133	7574	7649	7574
query15	205	192	188	188
query16	7494	250	246	246
query17	1409	565	530	530
query18	1943	263	265	263
query19	190	144	147	144
query20	86	81	86	81
query21	187	122	121	121
query22	4850	4442	4661	4442
query23	32515	31653	31472	31472
query24	12749	3386	3371	3371
query25	646	368	355	355
query26	1902	160	156	156
query27	3049	320	320	320
query28	6603	1834	1825	1825
query29	1118	617	612	612
query30	285	140	143	140
query31	934	748	757	748
query32	93	62	57	57
query33	719	241	235	235
query34	1092	498	491	491
query35	932	828	809	809
query36	999	902	875	875
query37	181	61	61	61
query38	3265	3174	3231	3174
query39	1399	1331	1333	1331
query40	285	108	107	107
query41	38	35	34	34
query42	105	97	99	97
query43	477	458	446	446
query44	1078	685	699	685
query45	199	177	176	176
query46	1048	768	747	747
query47	1640	1553	1604	1553
query48	422	362	359	359
query49	1247	304	308	304
query50	762	366	368	366
query51	4417	4280	4311	4280
query52	112	88	100	88
query53	404	301	302	301
query54	290	218	222	218
query55	83	84	83	83
query56	220	210	196	196
query57	1013	967	970	967
query58	215	191	197	191
query59	2478	2208	2178	2178
query60	244	218	209	209
query61	90	83	84	83
query62	587	375	377	375
query63	338	285	288	285
query64	6404	3068	3126	3068
query65	3299	3256	3245	3245
query66	1327	324	329	324
query67	14528	14381	14120	14120
query68	4164	561	561	561
query69	482	353	350	350
query70	1243	1202	1231	1202
query71	343	268	251	251
query72	6106	2788	2606	2606
query73	704	318	310	310
query74	6882	6558	6403	6403
query75	3189	2601	2561	2561
query76	3036	1116	1188	1116
query77	320	241	236	236
query78	9460	8825	8800	8800
query79	1046	497	514	497
query80	709	356	344	344
query81	441	206	204	204
query82	1244	89	84	84
query83	241	125	118	118
query84	226	77	91	77
query85	1163	368	347	347
query86	313	325	310	310
query87	3451	3324	3266	3266
query88	2723	2288	2289	2288
query89	429	362	356	356
query90	2165	163	170	163
query91	158	131	127	127
query92	55	49	49	49
query93	1036	521	503	503
query94	1154	180	177	177
query95	441	341	340	340
query96	568	264	263	263
query97	4412	4283	4282	4282
query98	222	204	191	191
query99	1115	712	737	712
Total cold run time: 269066 ms
Total hot run time: 176186 ms

doris-robot avatar Feb 24 '24 06:02 doris-robot

ClickBench: Total hot run time: 30.37 s
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit 4c2d205d7c9bc4f4e7dd9d0f5847d97d60f90033, data reload: false

query1	0.04	0.03	0.02
query2	0.06	0.03	0.02
query3	0.22	0.07	0.08
query4	1.65	0.09	0.09
query5	0.49	0.49	0.49
query6	1.39	0.60	0.61
query7	0.02	0.01	0.01
query8	0.04	0.03	0.03
query9	0.54	0.46	0.46
query10	0.49	0.49	0.49
query11	0.12	0.09	0.10
query12	0.13	0.10	0.11
query13	0.59	0.59	0.58
query14	0.78	0.79	0.80
query15	0.84	0.79	0.80
query16	0.32	0.33	0.34
query17	0.92	0.92	0.91
query18	0.18	0.16	0.16
query19	1.76	1.70	1.69
query20	0.02	0.01	0.01
query21	15.40	0.62	0.61
query22	3.37	3.92	1.87
query23	17.57	1.05	1.00
query24	2.21	0.89	0.16
query25	0.56	0.07	0.06
query26	0.16	0.14	0.13
query27	0.05	0.05	0.06
query28	11.78	0.82	0.84
query29	12.69	3.28	3.35
query30	0.53	0.50	0.49
query31	2.78	0.35	0.36
query32	3.34	0.48	0.47
query33	3.16	3.12	3.14
query34	15.36	4.49	4.53
query35	4.51	4.50	4.51
query36	1.07	0.95	0.97
query37	0.08	0.06	0.05
query38	0.04	0.03	0.03
query39	0.02	0.01	0.02
query40	0.17	0.15	0.14
query41	0.07	0.02	0.02
query42	0.03	0.02	0.02
query43	0.03	0.02	0.02
Total cold run time: 105.58 s
Total hot run time: 30.37 s

doris-robot avatar Feb 24 '24 06:02 doris-robot

Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'

Load test result on commit 4c2d205d7c9bc4f4e7dd9d0f5847d97d60f90033 with default session variables
Stream load json:         19 seconds loaded 2358488459 Bytes, about 118 MB/s
Stream load orc:          58 seconds loaded 1101869774 Bytes, about 18 MB/s
Stream load parquet:      31 seconds loaded 861443392 Bytes, about 26 MB/s
Insert into select:       15.7 seconds inserted 10000000 Rows, about 636K ops/s

doris-robot avatar Feb 24 '24 06:02 doris-robot

TeamCity be ut coverage result: Function Coverage: 35.71% (8548/23938) Line Coverage: 27.53% (69375/251998) Region Coverage: 26.69% (35986/134842) Branch Coverage: 23.49% (18393/78300) Coverage Report: http://coverage.selectdb-in.cc/coverage/4c2d205d7c9bc4f4e7dd9d0f5847d97d60f90033_4c2d205d7c9bc4f4e7dd9d0f5847d97d60f90033/report/index.html

doris-robot avatar Feb 24 '24 06:02 doris-robot

clang-tidy review says "All clean, LGTM! :+1:"

github-actions[bot] avatar Feb 25 '24 08:02 github-actions[bot]

run buildall

wangbo avatar Feb 26 '24 01:02 wangbo

TeamCity be ut coverage result: Function Coverage: 35.70% (8547/23938) Line Coverage: 27.52% (69359/251999) Region Coverage: 26.68% (35978/134842) Branch Coverage: 23.49% (18390/78300) Coverage Report: http://coverage.selectdb-in.cc/coverage/58418c0b69f683725553c1fa5219537696ef8a40_58418c0b69f683725553c1fa5219537696ef8a40/report/index.html

doris-robot avatar Feb 26 '24 01:02 doris-robot

TPC-H: Total hot run time: 40901 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 58418c0b69f683725553c1fa5219537696ef8a40, data reload: false

------ Round 1 ----------------------------------
q1	17636	5032	4905	4905
q2	2039	138	130	130
q3	10579	988	972	972
q4	4654	967	973	967
q5	7613	3097	3180	3097
q6	189	137	135	135
q7	1241	763	749	749
q8	9232	2045	2046	2045
q9	7487	6546	6582	6546
q10	8297	2644	2631	2631
q11	409	219	214	214
q12	774	334	333	333
q13	17935	3608	3611	3608
q14	302	263	276	263
q15	572	523	496	496
q16	485	407	414	407
q17	923	873	851	851
q18	7368	6592	6561	6561
q19	1558	1487	1473	1473
q20	559	283	284	283
q21	6496	3915	3983	3915
q22	878	339	320	320
Total cold run time: 107226 ms
Total hot run time: 40901 ms

----- Round 2, with runtime_filter_mode=off -----
q1	4928	4852	4908	4852
q2	299	184	191	184
q3	3620	3601	3602	3601
q4	2583	2555	2583	2555
q5	5748	5724	5731	5724
q6	213	124	128	124
q7	2273	1697	1668	1668
q8	3013	3064	3108	3064
q9	8674	8701	8636	8636
q10	6821	4241	4256	4241
q11	555	414	432	414
q12	801	538	546	538
q13	5189	3420	3390	3390
q14	277	234	239	234
q15	633	501	506	501
q16	502	459	433	433
q17	1686	1631	1606	1606
q18	8304	7639	7574	7574
q19	1628	1631	1628	1628
q20	2094	1856	1850	1850
q21	6693	6294	6274	6274
q22	566	515	487	487
Total cold run time: 67100 ms
Total hot run time: 59578 ms

doris-robot avatar Feb 26 '24 01:02 doris-robot

TPC-DS: Total hot run time: 176591 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
TPC-DS sf100 test result on commit 58418c0b69f683725553c1fa5219537696ef8a40, data reload: false

query1	918	347	353	347
query2	6524	1653	1834	1653
query3	6707	202	204	202
query4	23237	21046	21017	21017
query5	4301	379	376	376
query6	286	174	170	170
query7	4616	292	305	292
query8	252	196	199	196
query9	8454	2831	2820	2820
query10	418	221	220	220
query11	15188	14444	14488	14444
query12	153	83	84	83
query13	1716	412	419	412
query14	9235	7787	7719	7719
query15	218	189	189	189
query16	7480	254	245	245
query17	1412	538	509	509
query18	1952	267	259	259
query19	195	148	154	148
query20	95	83	81	81
query21	188	125	124	124
query22	4744	4717	4681	4681
query23	32573	31505	31535	31505
query24	12826	3356	3392	3356
query25	645	357	361	357
query26	1886	157	162	157
query27	3036	315	326	315
query28	6583	1815	1800	1800
query29	1165	610	629	610
query30	280	134	148	134
query31	919	754	744	744
query32	96	66	57	57
query33	733	238	226	226
query34	1096	473	498	473
query35	955	828	837	828
query36	1011	847	873	847
query37	191	62	63	62
query38	3311	3147	3161	3147
query39	1386	1327	1346	1327
query40	279	103	102	102
query41	37	36	34	34
query42	103	101	104	101
query43	477	451	437	437
query44	1063	677	696	677
query45	194	181	171	171
query46	1050	762	739	739
query47	1672	1502	1594	1502
query48	430	348	347	347
query49	1220	307	301	301
query50	771	374	374	374
query51	4457	4311	4292	4292
query52	107	92	91	91
query53	400	315	295	295
query54	291	218	232	218
query55	84	80	78	78
query56	220	205	209	205
query57	1064	941	932	932
query58	224	201	198	198
query59	2347	2198	2240	2198
query60	240	220	213	213
query61	83	82	81	81
query62	588	382	377	377
query63	345	301	297	297
query64	6301	3085	3105	3085
query65	3272	3267	3242	3242
query66	1339	323	320	320
query67	14566	14413	14383	14383
query68	5159	546	543	543
query69	529	357	345	345
query70	1288	1200	1251	1200
query71	429	254	255	254
query72	6294	2807	2626	2626
query73	696	308	316	308
query74	6906	6467	6440	6440
query75	3212	2553	2549	2549
query76	3283	1137	1210	1137
query77	364	242	236	236
query78	9403	8917	8745	8745
query79	982	506	492	492
query80	512	352	339	339
query81	441	204	207	204
query82	239	90	91	90
query83	137	120	116	116
query84	226	79	77	77
query85	1027	350	335	335
query86	289	290	294	290
query87	3499	3289	3359	3289
query88	2859	2363	2363	2363
query89	468	375	377	375
query90	1904	165	165	165
query91	162	123	129	123
query92	56	49	48	48
query93	1026	497	494	494
query94	1127	180	178	178
query95	431	334	341	334
query96	583	262	264	262
query97	4439	4266	4264	4264
query98	218	201	198	198
query99	1059	750	767	750
Total cold run time: 269452 ms
Total hot run time: 176591 ms

doris-robot avatar Feb 26 '24 01:02 doris-robot

ClickBench: Total hot run time: 30.92 s
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit 58418c0b69f683725553c1fa5219537696ef8a40, data reload: false

query1	0.03	0.02	0.02
query2	0.06	0.02	0.02
query3	0.23	0.07	0.08
query4	1.64	0.09	0.09
query5	0.50	0.50	0.50
query6	1.38	0.62	0.62
query7	0.02	0.01	0.01
query8	0.04	0.03	0.03
query9	0.56	0.46	0.45
query10	0.50	0.49	0.48
query11	0.13	0.10	0.10
query12	0.12	0.10	0.10
query13	0.59	0.60	0.60
query14	0.76	0.80	0.78
query15	0.82	0.81	0.80
query16	0.33	0.33	0.34
query17	0.93	0.92	0.90
query18	0.18	0.20	0.20
query19	1.83	1.72	1.71
query20	0.01	0.01	0.01
query21	15.40	0.61	0.59
query22	2.99	3.97	2.21
query23	17.06	1.08	1.01
query24	2.12	0.27	0.74
query25	0.59	0.06	0.05
query26	0.15	0.14	0.14
query27	0.07	0.06	0.07
query28	11.76	0.83	0.82
query29	12.52	3.28	3.33
query30	0.52	0.49	0.50
query31	2.79	0.35	0.36
query32	3.33	0.47	0.47
query33	3.10	3.16	3.16
query34	15.35	4.51	4.50
query35	4.51	4.46	4.48
query36	1.08	0.98	0.97
query37	0.08	0.05	0.05
query38	0.04	0.03	0.03
query39	0.02	0.01	0.02
query40	0.16	0.14	0.14
query41	0.06	0.01	0.02
query42	0.02	0.02	0.01
query43	0.03	0.02	0.02
Total cold run time: 104.41 s
Total hot run time: 30.92 s

doris-robot avatar Feb 26 '24 02:02 doris-robot

Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'

Load test result on commit 58418c0b69f683725553c1fa5219537696ef8a40 with default session variables
Stream load json:         19 seconds loaded 2358488459 Bytes, about 118 MB/s
Stream load orc:          60 seconds loaded 1101869774 Bytes, about 17 MB/s
Stream load parquet:      32 seconds loaded 861443392 Bytes, about 25 MB/s
Insert into select:       16.4 seconds inserted 10000000 Rows, about 609K ops/s

doris-robot avatar Feb 26 '24 02:02 doris-robot

clang-tidy review says "All clean, LGTM! :+1:"

github-actions[bot] avatar Feb 26 '24 02:02 github-actions[bot]

run buildall

wangbo avatar Feb 26 '24 03:02 wangbo

TPC-H: Total hot run time: 41436 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 406fad3e3cbc1b25a00e99dc22252e481ab26c63, data reload: false

------ Round 1 ----------------------------------
q1	17607	5026	4941	4941
q2	2043	147	133	133
q3	10699	997	989	989
q4	4719	981	976	976
q5	7614	3187	3198	3187
q6	199	133	135	133
q7	1284	779	779	779
q8	9353	2079	2090	2079
q9	7483	6620	6594	6594
q10	8309	2659	2657	2657
q11	423	206	213	206
q12	763	338	327	327
q13	17923	3601	3628	3601
q14	292	268	262	262
q15	589	550	513	513
q16	474	411	421	411
q17	938	879	894	879
q18	7534	6702	6703	6702
q19	1541	1493	1498	1493
q20	549	276	287	276
q21	7100	4024	3954	3954
q22	881	345	344	344
Total cold run time: 108317 ms
Total hot run time: 41436 ms

----- Round 2, with runtime_filter_mode=off -----
q1	4911	4883	4920	4883
q2	293	185	182	182
q3	3606	3601	3590	3590
q4	2549	2556	2553	2553
q5	5782	5746	5773	5746
q6	212	127	128	127
q7	2261	1677	1655	1655
q8	3019	3063	3116	3063
q9	8750	8720	8684	8684
q10	6816	4224	4250	4224
q11	513	382	385	382
q12	766	541	554	541
q13	4259	3402	3397	3397
q14	279	254	235	235
q15	598	548	519	519
q16	491	438	468	438
q17	1666	1600	1614	1600
q18	8395	7610	7646	7610
q19	1648	1657	1643	1643
q20	2118	1845	1852	1845
q21	6608	6295	6207	6207
q22	574	523	522	522
Total cold run time: 66114 ms
Total hot run time: 59646 ms

doris-robot avatar Feb 26 '24 04:02 doris-robot

TPC-DS: Total hot run time: 176590 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
TPC-DS sf100 test result on commit 406fad3e3cbc1b25a00e99dc22252e481ab26c63, data reload: false

query1	918	346	345	345
query2	6520	1654	1784	1654
query3	6695	207	204	204
query4	23008	21158	21096	21096
query5	4237	377	385	377
query6	257	164	174	164
query7	4595	303	294	294
query8	268	198	193	193
query9	8436	2816	2807	2807
query10	422	241	239	239
query11	14991	14706	14440	14440
query12	145	82	85	82
query13	1691	407	409	407
query14	9013	7609	7576	7576
query15	205	194	191	191
query16	7457	258	247	247
query17	1422	550	523	523
query18	1962	266	264	264
query19	189	143	148	143
query20	86	84	83	83
query21	190	123	122	122
query22	5020	4752	4803	4752
query23	32564	31555	31552	31552
query24	12659	3477	3409	3409
query25	641	366	376	366
query26	1876	151	162	151
query27	3044	315	314	314
query28	6632	1799	1788	1788
query29	1123	625	613	613
query30	277	135	149	135
query31	931	740	762	740
query32	96	59	57	57
query33	722	229	235	229
query34	1077	494	498	494
query35	932	826	825	825
query36	1040	946	862	862
query37	173	61	65	61
query38	3302	3200	3194	3194
query39	1344	1337	1329	1329
query40	284	106	102	102
query41	37	37	34	34
query42	101	99	97	97
query43	462	428	431	428
query44	1064	692	707	692
query45	199	178	181	178
query46	1060	782	764	764
query47	1625	1567	1591	1567
query48	435	354	350	350
query49	1212	311	306	306
query50	771	372	369	369
query51	4423	4333	4322	4322
query52	100	96	90	90
query53	398	307	305	305
query54	302	220	224	220
query55	90	84	81	81
query56	219	208	198	198
query57	1051	971	924	924
query58	221	194	206	194
query59	2223	2077	2159	2077
query60	231	220	217	217
query61	87	86	85	85
query62	591	393	370	370
query63	330	293	286	286
query64	6437	3066	3111	3066
query65	3308	3276	3239	3239
query66	1350	326	329	326
query67	14506	14400	14406	14400
query68	4148	529	537	529
query69	489	358	376	358
query70	1255	1178	1184	1178
query71	317	251	255	251
query72	6132	2807	2641	2641
query73	696	323	313	313
query74	6931	6508	6469	6469
query75	3170	2569	2568	2568
query76	3025	1114	1198	1114
query77	341	243	237	237
query78	9397	8885	8699	8699
query79	949	503	492	492
query80	548	384	351	351
query81	441	205	207	205
query82	160	84	82	82
query83	146	122	120	120
query84	225	81	76	76
query85	1083	349	345	345
query86	292	299	306	299
query87	3439	3321	3267	3267
query88	2672	2308	2297	2297
query89	437	358	370	358
query90	2083	165	163	163
query91	151	124	127	124
query92	55	53	47	47
query93	1018	502	486	486
query94	1200	173	173	173
query95	435	333	331	331
query96	571	264	267	264
query97	4462	4285	4285	4285
query98	217	208	200	200
query99	1064	659	708	659
Total cold run time: 266826 ms
Total hot run time: 176590 ms

doris-robot avatar Feb 26 '24 04:02 doris-robot

ClickBench: Total hot run time: 30.56 s
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit 406fad3e3cbc1b25a00e99dc22252e481ab26c63, data reload: false

query1	0.04	0.02	0.02
query2	0.07	0.03	0.02
query3	0.23	0.08	0.08
query4	1.63	0.09	0.09
query5	0.49	0.48	0.48
query6	1.38	0.61	0.60
query7	0.02	0.02	0.01
query8	0.03	0.02	0.02
query9	0.50	0.44	0.46
query10	0.47	0.49	0.50
query11	0.12	0.10	0.09
query12	0.12	0.10	0.10
query13	0.59	0.59	0.60
query14	0.78	0.79	0.77
query15	0.82	0.80	0.79
query16	0.32	0.33	0.32
query17	0.91	0.91	0.91
query18	0.17	0.18	0.18
query19	1.78	1.70	1.59
query20	0.02	0.01	0.01
query21	15.39	0.61	0.60
query22	2.85	4.05	1.84
query23	17.67	1.06	1.00
query24	1.98	0.76	0.37
query25	0.65	0.06	0.07
query26	0.15	0.13	0.14
query27	0.05	0.06	0.05
query28	11.81	0.84	0.82
query29	12.60	3.36	3.33
query30	0.54	0.49	0.46
query31	2.77	0.37	0.37
query32	3.33	0.48	0.48
query33	3.14	3.17	3.15
query34	15.35	4.54	4.53
query35	4.54	4.54	4.54
query36	1.09	0.94	0.95
query37	0.07	0.05	0.06
query38	0.04	0.03	0.03
query39	0.02	0.02	0.02
query40	0.17	0.15	0.16
query41	0.08	0.01	0.02
query42	0.02	0.01	0.02
query43	0.02	0.02	0.02
Total cold run time: 104.82 s
Total hot run time: 30.56 s

doris-robot avatar Feb 26 '24 04:02 doris-robot

Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'

Load test result on commit 406fad3e3cbc1b25a00e99dc22252e481ab26c63 with default session variables
Stream load json:         19 seconds loaded 2358488459 Bytes, about 118 MB/s
Stream load orc:          59 seconds loaded 1101869774 Bytes, about 17 MB/s
Stream load parquet:      31 seconds loaded 861443392 Bytes, about 26 MB/s
Insert into select:       16.4 seconds inserted 10000000 Rows, about 609K ops/s

doris-robot avatar Feb 26 '24 04:02 doris-robot

TeamCity be ut coverage result: Function Coverage: 35.73% (8548/23924) Line Coverage: 27.53% (69364/251950) Region Coverage: 26.68% (35972/134829) Branch Coverage: 23.49% (18392/78298) Coverage Report: http://coverage.selectdb-in.cc/coverage/406fad3e3cbc1b25a00e99dc22252e481ab26c63_406fad3e3cbc1b25a00e99dc22252e481ab26c63/report/index.html

doris-robot avatar Feb 26 '24 04:02 doris-robot

PR approved by at least one committer and no changes requested.

github-actions[bot] avatar Feb 26 '24 10:02 github-actions[bot]

PR approved by anyone and no changes requested.

github-actions[bot] avatar Feb 26 '24 10:02 github-actions[bot]