Skip to content

[enhancement](profile) profile counter should always gt than 0 #59335

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom
Open
yiguolei wants to merge 10 commits into
base: master
Choose a base branch
from
Open

[enhancement](profile) profile counter should always gt than 0 #59335

yiguolei wants to merge 10 commits into from
+83 −15

Conversation

@yiguolei
Copy link
Contributor

@yiguolei yiguolei commented Dec 24, 2025

What problem does this PR solve?

Issue Number: close #xxx

Related PR: #xxx

Problem Summary:

Release note

None

Check List (For Author)

  • Test

    • Regression test
    • Unit Test
    • Manual test (add detailed scripts or steps below)
    • No need to test or manual test. Explain why:
      • This is a refactor/code format and no logic has been changed.
      • Previous test can cover this change.
      • No code files have been changed.
      • Other reason

  • Behavior changed:

    • No.
    • Yes.

  • Does this need documentation?

    • No.
    • Yes.

Check List (For Reviewer who merge this PR)

  • Confirm the release note
  • Confirm test cases
  • Confirm document
  • Add branch pick label

@Thearas
Copy link
Contributor

Thearas commented Dec 24, 2025

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

Please clearly describe your PR:

  1. What problem was fixed (it's best to include specific error reporting information). How it was fixed.
  2. Which behaviors were modified. What was the previous behavior, what is it now, why was it modified, and what possible impacts might there be.
  3. What features were added. Why was this function added?
  4. Which code was refactored and why was this part of the code refactored?
  5. Which functions were optimized and what is the difference before and after the optimization?

@yiguolei
Copy link
Contributor Author

yiguolei commented Dec 24, 2025

run buildall

@yiguolei
Copy link
Contributor Author

yiguolei commented Dec 29, 2025

run buildall

@doris-robot
Copy link

doris-robot commented Dec 29, 2025

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

------ Round 1 ----------------------------------
q1	17672	4206	4031	4031
q2	2035	359	238	238
q3	10200	1307	742	742
q4	10203	828	336	336
q5	7599	2131	1936	1936
q6	230	168	139	139
q7	964	806	667	667
q8	9268	1428	1141	1141
q9	6883	5137	5209	5137
q10	6840	1794	1446	1446
q11	484	317	295	295
q12	735	751	583	583
q13	17775	3835	3113	3113
q14	293	292	278	278
q15	578	511	507	507
q16	704	670	633	633
q17	717	739	611	611
q18	8042	7609	8014	7609
q19	1504	1096	672	672
q20	426	390	255	255
q21	4599	4338	4258	4258
q22	1136	1124	1048	1048
Total cold run time: 108887 ms
Total hot run time: 35675 ms

----- Round 2, with runtime_filter_mode=off -----
q1	4289	4259	4235	4235
q2	316	391	327	327
q3	2369	2798	2423	2423
q4	1399	1917	1442	1442
q5	4492	4432	4412	4412
q6	214	168	130	130
q7	1876	1994	1776	1776
q8	2544	2425	2450	2425
q9	7014	7251	6917	6917
q10	2391	2518	2111	2111
q11	535	444	426	426
q12	684	705	583	583
q13	3357	3813	3068	3068
q14	274	278	248	248
q15	522	488	494	488
q16	608	643	604	604
q17	1092	1321	1294	1294
q18	7287	7329	7321	7321
q19	842	857	869	857
q20	1863	2011	1818	1818
q21	4489	4303	4226	4226
q22	1107	1022	1005	1005
Total cold run time: 49564 ms
Total hot run time: 48136 ms

@doris-robot
Copy link

doris-robot commented Dec 29, 2025

TPC-DS: Total hot run time: 174172 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 1559f0112717d9f2b134cb7abe4843beb9ab32c7, data reload: false

query5	4376	584	450	450
query6	323	238	214	214
query7	4224	466	273	273
query8	340	254	245	245
query9	8780	2618	2626	2618
query10	512	366	322	322
query11	15204	15278	14759	14759
query12	173	116	121	116
query13	1286	505	394	394
query14	6107	3029	2699	2699
query14_1	2567	2623	2628	2623
query15	199	192	177	177
query16	968	468	461	461
query17	1084	667	541	541
query18	2418	425	333	333
query19	230	217	188	188
query20	125	115	112	112
query21	217	143	121	121
query22	4091	3964	4041	3964
query23	15903	15738	15193	15193
query23_1	15341	15469	15373	15373
query24	6602	1608	1190	1190
query24_1	1225	1206	1200	1200
query25	560	490	428	428
query26	836	273	160	160
query27	2667	456	305	305
query28	3102	2185	2191	2185
query29	799	566	454	454
query30	316	244	214	214
query31	779	629	557	557
query32	79	72	71	71
query33	537	356	302	302
query34	890	893	544	544
query35	750	801	698	698
query36	847	887	852	852
query37	134	98	83	83
query38	2714	2794	2617	2617
query39	778	746	747	746
query39_1	706	706	722	706
query40	225	141	121	121
query41	74	75	67	67
query42	104	107	105	105
query43	431	477	444	444
query44	1346	768	760	760
query45	196	189	177	177
query46	923	989	623	623
query47	1484	1480	1328	1328
query48	321	343	261	261
query49	610	441	352	352
query50	667	279	213	213
query51	3750	3766	3775	3766
query52	113	112	96	96
query53	302	338	279	279
query54	300	271	263	263
query55	86	81	74	74
query56	304	305	313	305
query57	992	984	954	954
query58	268	262	268	262
query59	2152	2172	2152	2152
query60	331	349	358	349
query61	158	159	154	154
query62	369	359	302	302
query63	297	264	276	264
query64	3982	1280	971	971
query65	3666	3688	3725	3688
query66	1387	439	307	307
query67	15023	15909	14660	14660
query68	8080	1009	724	724
query69	491	345	310	310
query70	997	951	945	945
query71	361	313	277	277
query72	6043	4868	4991	4868
query73	730	650	309	309
query74	8840	8768	8642	8642
query75	2897	2887	2539	2539
query76	3763	1076	692	692
query77	515	391	282	282
query78	9740	10076	9131	9131
query79	1162	863	616	616
query80	633	588	499	499
query81	481	262	230	230
query82	232	143	109	109
query83	260	253	244	244
query84	254	115	103	103
query85	876	507	452	452
query86	347	292	307	292
query87	2982	2911	2747	2747
query88	3238	2300	2263	2263
query89	383	346	318	318
query90	1914	158	155	155
query91	172	168	145	145
query92	74	65	71	65
query93	986	918	570	570
query94	573	316	284	284
query95	567	384	312	312
query96	592	468	215	215
query97	2317	2354	2287	2287
query98	235	211	196	196
query99	582	590	530	530
Total cold run time: 248818 ms
Total hot run time: 174172 ms

@doris-robot
Copy link

doris-robot commented Dec 29, 2025

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

query1	0.06	0.04	0.05
query2	0.10	0.04	0.05
query3	0.26	0.09	0.09
query4	1.60	0.11	0.12
query5	0.25	0.28	0.24
query6	1.17	0.67	0.65
query7	0.04	0.03	0.03
query8	0.06	0.04	0.05
query9	0.58	0.51	0.51
query10	0.56	0.55	0.54
query11	0.15	0.11	0.12
query12	0.17	0.13	0.13
query13	0.60	0.58	0.58
query14	0.99	0.95	0.97
query15	0.79	0.79	0.80
query16	0.38	0.39	0.40
query17	1.06	1.05	1.05
query18	0.22	0.21	0.21
query19	1.85	1.81	1.78
query20	0.01	0.02	0.01
query21	15.45	0.29	0.14
query22	4.91	0.05	0.04
query23	16.05	0.27	0.10
query24	1.38	0.27	2.02
query25	0.12	0.09	0.05
query26	0.14	0.14	0.13
query27	0.06	0.06	0.07
query28	6.24	1.03	0.88
query29	12.62	4.07	3.22
query30	0.27	0.14	0.15
query31	2.81	0.62	0.37
query32	3.22	0.55	0.46
query33	3.02	3.06	3.11
query34	16.68	5.15	4.46
query35	4.49	4.47	4.51
query36	0.67	0.49	0.48
query37	0.12	0.07	0.06
query38	0.07	0.04	0.04
query39	0.04	0.03	0.03
query40	0.17	0.14	0.13
query41	0.10	0.03	0.03
query42	0.05	0.03	0.03
query43	0.04	0.03	0.04
Total cold run time: 99.62 s
Total hot run time: 26.97 s

@yiguolei
Copy link
Contributor Author

yiguolei commented Dec 30, 2025

run p0

@yiguolei
Copy link
Contributor Author

yiguolei commented Dec 30, 2025

run buildall

@doris-robot
Copy link

doris-robot commented Dec 30, 2025

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

------ Round 1 ----------------------------------
q1	17632	4208	4054	4054
q2	2034	361	237	237
q3	10203	1311	769	769
q4	10222	860	322	322
q5	7856	2198	1880	1880
q6	242	170	136	136
q7	949	803	669	669
q8	9276	1406	1130	1130
q9	6973	5177	5273	5177
q10	6823	1795	1421	1421
q11	513	308	302	302
q12	741	715	610	610
q13	17787	3879	3086	3086
q14	283	292	273	273
q15	587	509	506	506
q16	700	683	622	622
q17	697	794	629	629
q18	7873	7521	8191	7521
q19	1183	996	647	647
q20	437	376	270	270
q21	4676	4219	4246	4219
q22	1164	1060	1042	1042
Total cold run time: 108851 ms
Total hot run time: 35522 ms

----- Round 2, with runtime_filter_mode=off -----
q1	4289	4297	4191	4191
q2	311	401	304	304
q3	2283	2941	2395	2395
q4	1501	1956	1517	1517
q5	4369	4396	4327	4327
q6	213	172	122	122
q7	1889	1901	1761	1761
q8	2543	2331	2342	2331
q9	7436	7091	7161	7091
q10	2526	2592	2170	2170
q11	532	465	435	435
q12	643	686	552	552
q13	3318	3772	3147	3147
q14	269	286	252	252
q15	529	487	487	487
q16	616	676	598	598
q17	1080	1259	1293	1259
q18	7455	7484	7334	7334
q19	879	857	852	852
q20	1901	1974	1811	1811
q21	4454	4218	4137	4137
q22	1074	1027	1030	1027
Total cold run time: 50110 ms
Total hot run time: 48100 ms

@doris-robot
Copy link

doris-robot commented Dec 30, 2025

TPC-DS: Total hot run time: 175016 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 b128dbd7fdf01f1cc1c7d53962e0ab682a89c582, data reload: false

query5	4749	597	434	434
query6	332	229	241	229
query7	4201	453	280	280
query8	347	257	247	247
query9	8769	2625	2630	2625
query10	519	368	312	312
query11	15169	15072	14827	14827
query12	178	118	115	115
query13	1272	504	418	418
query14	6115	2928	2692	2692
query14_1	2565	2568	2589	2568
query15	203	191	170	170
query16	998	476	470	470
query17	1059	666	557	557
query18	2455	429	335	335
query19	223	216	189	189
query20	122	116	114	114
query21	218	140	126	126
query22	3862	4032	4212	4032
query23	16103	15496	15302	15302
query23_1	15373	15413	15569	15413
query24	7399	1587	1224	1224
query24_1	1212	1188	1214	1188
query25	565	493	423	423
query26	1257	267	159	159
query27	2771	461	294	294
query28	4558	2194	2184	2184
query29	819	567	463	463
query30	318	241	212	212
query31	776	631	560	560
query32	84	73	74	73
query33	555	332	306	306
query34	891	892	531	531
query35	764	788	711	711
query36	864	881	759	759
query37	136	100	79	79
query38	2737	2668	2632	2632
query39	788	750	724	724
query39_1	727	711	700	700
query40	227	141	121	121
query41	71	69	68	68
query42	107	102	104	102
query43	454	473	416	416
query44	1342	766	756	756
query45	193	184	178	178
query46	863	989	635	635
query47	1447	1441	1300	1300
query48	318	333	252	252
query49	632	441	344	344
query50	641	281	221	221
query51	3734	3848	3689	3689
query52	113	109	97	97
query53	300	331	272	272
query54	307	283	269	269
query55	80	79	74	74
query56	307	307	300	300
query57	1029	1019	958	958
query58	280	266	259	259
query59	2059	2202	2207	2202
query60	339	371	294	294
query61	162	160	157	157
query62	367	348	301	301
query63	298	270	269	269
query64	5008	1316	986	986
query65	3743	3754	3747	3747
query66	1450	426	311	311
query67	14883	15203	14987	14987
query68	7901	1016	720	720
query69	502	354	316	316
query70	1066	961	884	884
query71	372	306	276	276
query72	6179	4944	4948	4944
query73	724	674	314	314
query74	8848	8762	8564	8564
query75	2915	2898	2494	2494
query76	3796	1053	669	669
query77	507	368	284	284
query78	9674	9830	9227	9227
query79	1249	918	608	608
query80	619	569	481	481
query81	510	263	228	228
query82	216	143	114	114
query83	267	259	240	240
query84	257	116	102	102
query85	913	499	451	451
query86	391	306	311	306
query87	2846	2857	2805	2805
query88	3196	2282	2279	2279
query89	388	360	313	313
query90	2202	159	148	148
query91	174	165	138	138
query92	84	68	62	62
query93	1379	912	564	564
query94	572	301	300	300
query95	579	391	315	315
query96	594	448	205	205
query97	2336	2466	2300	2300
query98	240	204	192	192
query99	573	599	517	517
Total cold run time: 253925 ms
Total hot run time: 175016 ms

@doris-robot
Copy link

doris-robot commented Dec 30, 2025

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

query1	0.06	0.05	0.04
query2	0.10	0.06	0.05
query3	0.26	0.08	0.08
query4	1.60	0.12	0.11
query5	0.28	0.25	0.25
query6	1.15	0.67	0.66
query7	0.03	0.02	0.02
query8	0.06	0.05	0.04
query9	0.56	0.51	0.51
query10	0.54	0.55	0.55
query11	0.15	0.11	0.10
query12	0.17	0.13	0.13
query13	0.62	0.60	0.59
query14	0.98	1.00	0.99
query15	0.81	0.80	0.81
query16	0.41	0.40	0.42
query17	1.04	1.08	1.06
query18	0.23	0.21	0.22
query19	1.98	1.86	1.83
query20	0.02	0.02	0.01
query21	15.46	0.26	0.14
query22	5.41	0.05	0.05
query23	15.85	0.29	0.10
query24	0.91	0.46	0.59
query25	0.12	0.07	0.12
query26	0.14	0.13	0.14
query27	0.13	0.06	0.20
query28	4.76	1.05	0.88
query29	12.59	4.00	3.19
query30	0.28	0.14	0.12
query31	2.82	0.63	0.39
query32	3.23	0.55	0.48
query33	2.96	3.02	3.02
query34	16.63	5.16	4.44
query35	4.52	4.45	4.46
query36	0.66	0.51	0.48
query37	0.10	0.06	0.06
query38	0.07	0.05	0.03
query39	0.05	0.03	0.03
query40	0.17	0.14	0.14
query41	0.08	0.03	0.03
query42	0.04	0.02	0.02
query43	0.05	0.03	0.04
Total cold run time: 98.08 s
Total hot run time: 27.23 s

@yiguolei
Copy link
Contributor Author

yiguolei commented Dec 30, 2025

run buildall

@doris-robot
Copy link

doris-robot commented Dec 30, 2025

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

------ Round 1 ----------------------------------
q1	17596	4236	4062	4062
q2	2034	358	249	249
q3	10121	1284	738	738
q4	10223	868	317	317
q5	7516	2075	1999	1999
q6	182	169	138	138
q7	952	808	659	659
q8	9263	1440	1123	1123
q9	6834	5135	5116	5116
q10	6750	1824	1434	1434
q11	478	294	289	289
q12	681	723	622	622
q13	17798	3874	3089	3089
q14	301	298	280	280
q15	595	532	510	510
q16	696	675	628	628
q17	711	712	629	629
q18	7693	7539	7998	7539
q19	1769	1171	623	623
q20	407	381	258	258
q21	4507	4206	4137	4137
q22	1131	1117	1029	1029
Total cold run time: 108238 ms
Total hot run time: 35468 ms

----- Round 2, with runtime_filter_mode=off -----
q1	4365	4214	4225	4214
q2	316	376	332	332
q3	2305	3019	2423	2423
q4	1422	1875	1457	1457
q5	4406	4345	4246	4246
q6	216	165	129	129
q7	2191	1882	1754	1754
q8	2489	2377	2364	2364
q9	7087	7225	7261	7225
q10	2412	2630	2134	2134
q11	524	460	440	440
q12	668	726	589	589
q13	3346	3800	3119	3119
q14	273	286	262	262
q15	526	496	482	482
q16	617	664	598	598
q17	1086	1187	1295	1187
q18	7317	7354	7213	7213
q19	872	809	847	809
q20	1950	2020	1795	1795
q21	4523	4390	4152	4152
q22	1088	1036	1004	1004
Total cold run time: 49999 ms
Total hot run time: 47928 ms

@doris-robot
Copy link

doris-robot commented Dec 30, 2025

TPC-DS: Total hot run time: 173806 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 8d503c9c79c01aeace4af1d48e0d745fb76be0fe, data reload: false

query5	4414	574	445	445
query6	355	239	230	230
query7	4230	460	270	270
query8	342	256	244	244
query9	8758	2626	2628	2626
query10	534	358	319	319
query11	15322	15107	14773	14773
query12	190	116	115	115
query13	1264	497	404	404
query14	6192	2949	2730	2730
query14_1	2666	2589	2611	2589
query15	203	190	174	174
query16	1004	488	448	448
query17	1108	708	585	585
query18	2453	437	390	390
query19	218	220	189	189
query20	122	123	111	111
query21	210	134	121	121
query22	4003	3969	3932	3932
query23	16080	15618	15404	15404
query23_1	15398	15444	15351	15351
query24	7319	1556	1183	1183
query24_1	1196	1188	1198	1188
query25	526	464	436	436
query26	1246	268	153	153
query27	2761	459	293	293
query28	4521	2208	2185	2185
query29	791	522	446	446
query30	315	247	212	212
query31	809	654	558	558
query32	79	71	67	67
query33	539	347	295	295
query34	863	889	530	530
query35	747	788	701	701
query36	872	878	777	777
query37	134	95	79	79
query38	2712	2642	2688	2642
query39	788	746	738	738
query39_1	704	688	726	688
query40	220	130	115	115
query41	66	62	61	61
query42	106	99	102	99
query43	438	448	412	412
query44	1367	774	763	763
query45	184	184	175	175
query46	870	952	610	610
query47	1374	1431	1387	1387
query48	310	323	239	239
query49	609	411	332	332
query50	634	288	212	212
query51	3761	3759	3744	3744
query52	104	107	95	95
query53	290	324	279	279
query54	277	247	252	247
query55	78	76	71	71
query56	302	278	287	278
query57	991	1017	915	915
query58	271	257	257	257
query59	2144	2180	2016	2016
query60	329	321	294	294
query61	160	166	156	156
query62	395	370	326	326
query63	314	273	275	273
query64	5152	1432	1085	1085
query65	3782	3654	3713	3654
query66	1448	448	326	326
query67	15188	15490	14616	14616
query68	4756	1039	737	737
query69	496	353	319	319
query70	1051	954	941	941
query71	362	304	279	279
query72	6308	4761	4820	4761
query73	667	576	319	319
query74	8797	8761	8613	8613
query75	2877	2902	2526	2526
query76	3774	1076	656	656
query77	507	375	286	286
query78	9768	9862	9101	9101
query79	1516	911	601	601
query80	677	576	478	478
query81	509	262	231	231
query82	413	140	110	110
query83	263	259	244	244
query84	261	114	104	104
query85	936	538	474	474
query86	396	321	324	321
query87	2900	2880	2762	2762
query88	3272	2252	2247	2247
query89	395	350	346	346
query90	2053	151	150	150
query91	176	159	144	144
query92	73	67	61	61
query93	1405	944	562	562
query94	569	337	297	297
query95	577	327	366	327
query96	597	469	203	203
query97	2339	2366	2298	2298
query98	232	204	212	204
query99	574	570	549	549
Total cold run time: 251558 ms
Total hot run time: 173806 ms

@doris-robot
Copy link

doris-robot commented Dec 30, 2025

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

query1	0.05	0.05	0.05
query2	0.10	0.05	0.05
query3	0.25	0.09	0.08
query4	1.61	0.12	0.11
query5	0.29	0.25	0.25
query6	1.15	0.67	0.66
query7	0.04	0.02	0.02
query8	0.05	0.05	0.04
query9	0.57	0.50	0.49
query10	0.56	0.55	0.54
query11	0.14	0.11	0.11
query12	0.16	0.13	0.12
query13	0.61	0.60	0.59
query14	0.98	1.00	0.99
query15	0.82	0.80	0.81
query16	0.42	0.40	0.38
query17	0.99	1.09	0.98
query18	0.23	0.22	0.22
query19	1.90	1.75	1.81
query20	0.02	0.01	0.01
query21	15.44	0.31	0.14
query22	4.91	0.06	0.04
query23	15.95	0.28	0.11
query24	1.02	0.66	0.20
query25	0.12	0.08	0.08
query26	0.13	0.14	0.13
query27	0.06	0.05	0.05
query28	3.11	1.06	0.88
query29	12.59	3.95	3.18
query30	0.28	0.15	0.12
query31	2.83	0.63	0.38
query32	3.24	0.56	0.46
query33	3.02	3.00	3.04
query34	16.60	5.10	4.53
query35	4.48	4.46	4.58
query36	0.67	0.50	0.49
query37	0.10	0.06	0.06
query38	0.07	0.05	0.03
query39	0.05	0.03	0.03
query40	0.17	0.14	0.14
query41	0.09	0.04	0.03
query42	0.05	0.03	0.03
query43	0.04	0.04	0.04
Total cold run time: 95.96 s
Total hot run time: 26.85 s

@yiguolei
Copy link
Contributor Author

yiguolei commented Dec 31, 2025

run buildall

@doris-robot
Copy link

doris-robot commented Dec 31, 2025

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

------ Round 1 ----------------------------------
q1	17658	4280	4032	4032
q2	2079	354	245	245
q3	10228	1320	787	787
q4	10216	860	343	343
q5	7800	2124	2042	2042
q6	215	176	141	141
q7	962	805	685	685
q8	9284	1441	1192	1192
q9	6803	5147	5205	5147
q10	6857	1793	1395	1395
q11	518	302	289	289
q12	749	764	595	595
q13	17779	3918	3137	3137
q14	287	291	289	289
q15	586	504	501	501
q16	715	697	621	621
q17	713	755	642	642
q18	7287	7509	8040	7509
q19	1216	998	644	644
q20	428	408	263	263
q21	4523	4266	4242	4242
q22	1157	1085	1046	1046
Total cold run time: 108060 ms
Total hot run time: 35787 ms

----- Round 2, with runtime_filter_mode=off -----
q1	4260	4296	4179	4179
q2	343	402	333	333
q3	2332	2955	2341	2341
q4	1381	1806	1403	1403
q5	4545	4366	4371	4366
q6	213	169	135	135
q7	1988	1931	1752	1752
q8	2549	2425	2649	2425
q9	7002	7281	7033	7033
q10	2443	2528	2148	2148
q11	519	454	432	432
q12	670	712	564	564
q13	3392	3824	3107	3107
q14	266	284	258	258
q15	529	491	486	486
q16	633	653	627	627
q17	1102	1205	1317	1205
q18	7504	7406	7313	7313
q19	878	850	855	850
q20	1925	1969	1805	1805
q21	4491	4250	4127	4127
q22	1109	1052	999	999
Total cold run time: 50074 ms
Total hot run time: 47888 ms

@doris-robot
Copy link

doris-robot commented Dec 31, 2025

TPC-DS: Total hot run time: 175110 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 2cb3df729eed151d6764b9c95bfd8232e7db95b3, data reload: false

query5	4433	594	439	439
query6	332	217	213	213
query7	4204	472	266	266
query8	330	246	230	230
query9	8772	2608	2612	2608
query10	477	369	314	314
query11	15181	15113	14781	14781
query12	178	119	116	116
query13	1268	491	380	380
query14	6193	3036	2773	2773
query14_1	2673	2686	2732	2686
query15	201	198	175	175
query16	995	493	459	459
query17	1114	719	611	611
query18	2482	441	353	353
query19	237	232	200	200
query20	127	122	116	116
query21	220	143	128	128
query22	3969	4016	3962	3962
query23	16090	15506	15428	15428
query23_1	15443	15446	15523	15446
query24	7638	1622	1201	1201
query24_1	1235	1221	1220	1220
query25	576	487	441	441
query26	1248	277	162	162
query27	2756	470	301	301
query28	4517	2194	2175	2175
query29	830	565	457	457
query30	329	244	211	211
query31	807	639	562	562
query32	74	78	69	69
query33	562	370	308	308
query34	901	901	536	536
query35	736	811	727	727
query36	850	856	853	853
query37	136	141	79	79
query38	2802	2713	2735	2713
query39	793	747	712	712
query39_1	722	709	687	687
query40	219	131	117	117
query41	67	67	63	63
query42	106	105	107	105
query43	438	498	418	418
query44	1364	752	766	752
query45	187	180	174	174
query46	900	986	636	636
query47	1413	1486	1397	1397
query48	315	330	244	244
query49	599	429	326	326
query50	655	291	213	213
query51	3763	3811	3849	3811
query52	107	119	102	102
query53	311	336	285	285
query54	288	264	251	251
query55	81	75	76	75
query56	304	305	303	303
query57	1046	994	900	900
query58	270	247	248	247
query59	1994	2230	2048	2048
query60	321	313	303	303
query61	154	202	154	154
query62	418	364	335	335
query63	296	281	270	270
query64	5044	1305	982	982
query65	3789	3693	3737	3693
query66	1429	439	321	321
query67	15199	15845	15104	15104
query68	7513	1040	731	731
query69	515	344	310	310
query70	1078	967	858	858
query71	365	308	286	286
query72	6245	4859	5114	4859
query73	750	718	313	313
query74	8892	8737	8573	8573
query75	2925	2926	2563	2563
query76	3896	1075	669	669
query77	528	380	290	290
query78	9697	9881	9097	9097
query79	1505	949	625	625
query80	700	570	491	491
query81	515	263	225	225
query82	216	145	110	110
query83	273	261	250	250
query84	277	126	98	98
query85	909	526	469	469
query86	388	326	315	315
query87	2893	2914	2764	2764
query88	3299	2301	2265	2265
query89	390	359	326	326
query90	2099	163	157	157
query91	178	165	146	146
query92	81	66	65	65
query93	1322	941	570	570
query94	575	318	274	274
query95	589	342	364	342
query96	593	476	210	210
query97	2290	2353	2268	2268
query98	241	201	208	201
query99	592	566	516	516
Total cold run time: 255562 ms
Total hot run time: 175110 ms

@doris-robot
Copy link

doris-robot commented Dec 31, 2025

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

query1	0.06	0.05	0.05
query2	0.11	0.06	0.05
query3	0.27	0.10	0.09
query4	1.62	0.11	0.11
query5	0.27	0.26	0.25
query6	1.16	0.67	0.67
query7	0.04	0.03	0.03
query8	0.06	0.04	0.05
query9	0.57	0.51	0.53
query10	0.55	0.55	0.55
query11	0.16	0.12	0.12
query12	0.16	0.13	0.13
query13	0.63	0.61	0.60
query14	0.99	0.98	0.99
query15	0.82	0.80	0.80
query16	0.41	0.42	0.43
query17	1.05	1.07	1.08
query18	0.24	0.22	0.21
query19	1.95	1.92	1.87
query20	0.02	0.02	0.02
query21	15.42	0.30	0.14
query22	4.76	0.06	0.05
query23	16.12	0.29	0.12
query24	1.99	0.51	0.49
query25	0.13	0.06	0.08
query26	0.14	0.15	0.13
query27	0.07	0.08	0.05
query28	5.50	1.04	0.88
query29	12.58	3.90	3.13
query30	0.31	0.17	0.15
query31	2.82	0.64	0.38
query32	3.23	0.56	0.48
query33	2.97	3.03	3.00
query34	16.70	5.15	4.48
query35	4.50	4.52	4.47
query36	0.68	0.50	0.50
query37	0.12	0.07	0.07
query38	0.08	0.05	0.04
query39	0.05	0.03	0.04
query40	0.18	0.15	0.15
query41	0.09	0.04	0.03
query42	0.05	0.04	0.03
query43	0.04	0.04	0.04
Total cold run time: 99.67 s
Total hot run time: 27.47 s

@yiguolei
Copy link
Contributor Author

yiguolei commented Dec 31, 2025

run buildall

@doris-robot
Copy link

doris-robot commented Dec 31, 2025

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

------ Round 1 ----------------------------------
q1	17660	4375	4062	4062
q2	2041	363	239	239
q3	10186	1297	766	766
q4	10205	847	321	321
q5	7501	2202	1896	1896
q6	200	177	151	151
q7	949	819	673	673
q8	9309	1434	1189	1189
q9	6920	5171	5234	5171
q10	6790	1816	1443	1443
q11	520	316	284	284
q12	704	714	583	583
q13	17784	3822	3070	3070
q14	299	290	286	286
q15	587	511	513	511
q16	726	702	632	632
q17	720	762	634	634
q18	7522	7609	7991	7609
q19	1202	989	699	699
q20	410	386	265	265
q21	4590	4316	4182	4182
q22	1150	1108	1081	1081
Total cold run time: 107975 ms
Total hot run time: 35747 ms

----- Round 2, with runtime_filter_mode=off -----
q1	4250	4482	4286	4286
q2	352	415	318	318
q3	2287	2795	2442	2442
q4	1380	1853	1460	1460
q5	4352	4297	4407	4297
q6	230	169	124	124
q7	1917	1956	1782	1782
q8	2575	2383	2353	2353
q9	7286	7142	7138	7138
q10	2572	2686	2391	2391
q11	555	486	450	450
q12	700	739	635	635
q13	3324	3837	3237	3237
q14	271	283	270	270
q15	540	496	490	490
q16	603	670	623	623
q17	1091	1225	1301	1225
q18	7552	7187	7241	7187
q19	848	809	841	809
q20	1876	1984	1799	1799
q21	4514	4289	4151	4151
q22	1077	1038	1013	1013
Total cold run time: 50152 ms
Total hot run time: 48480 ms

@doris-robot
Copy link

doris-robot commented Dec 31, 2025

TPC-DS: Total hot run time: 174847 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 a7e864d0f1d289294545fcb205631655d524a37a, data reload: false

query5	4779	613	471	471
query6	345	244	237	237
query7	4222	463	275	275
query8	336	252	265	252
query9	8808	2637	2642	2637
query10	523	372	329	329
query11	15374	15151	14784	14784
query12	181	117	115	115
query13	1273	539	393	393
query14	6483	3014	2790	2790
query14_1	2647	2643	2650	2643
query15	204	196	173	173
query16	1001	497	455	455
query17	1066	726	605	605
query18	2670	445	346	346
query19	222	232	204	204
query20	128	122	117	117
query21	220	142	123	123
query22	4388	4341	4193	4193
query23	16194	15561	15349	15349
query23_1	15456	15517	15350	15350
query24	7421	1599	1207	1207
query24_1	1223	1194	1207	1194
query25	570	484	421	421
query26	1240	267	163	163
query27	2746	458	296	296
query28	4461	2216	2192	2192
query29	782	611	434	434
query30	307	233	209	209
query31	776	618	548	548
query32	76	68	69	68
query33	532	339	277	277
query34	894	872	533	533
query35	767	777	689	689
query36	866	865	823	823
query37	129	91	78	78
query38	2697	2690	2672	2672
query39	789	758	741	741
query39_1	710	703	705	703
query40	215	132	116	116
query41	67	63	77	63
query42	113	103	106	103
query43	451	427	423	423
query44	1332	755	747	747
query45	183	183	183	183
query46	883	985	623	623
query47	1430	1493	1472	1472
query48	322	317	245	245
query49	608	414	325	325
query50	647	279	211	211
query51	3763	3807	3788	3788
query52	104	107	98	98
query53	295	323	266	266
query54	284	258	235	235
query55	80	74	73	73
query56	282	278	281	278
query57	1052	1019	989	989
query58	263	246	249	246
query59	2126	2061	2062	2061
query60	354	313	295	295
query61	160	160	154	154
query62	408	379	342	342
query63	312	262	264	262
query64	4854	1278	985	985
query65	3797	3740	3747	3740
query66	1373	431	308	308
query67	15134	15556	14813	14813
query68	7948	1015	725	725
query69	514	340	312	312
query70	1071	948	950	948
query71	375	296	271	271
query72	6282	4711	4943	4711
query73	718	637	307	307
query74	8818	8789	8562	8562
query75	2898	2903	2519	2519
query76	3924	1064	651	651
query77	517	379	275	275
query78	9789	9918	9199	9199
query79	1492	919	609	609
query80	670	583	499	499
query81	531	263	243	243
query82	212	139	111	111
query83	262	255	240	240
query84	258	120	104	104
query85	932	516	464	464
query86	382	323	297	297
query87	2846	2817	2743	2743
query88	3234	2291	2258	2258
query89	398	340	327	327
query90	2077	159	147	147
query91	175	166	142	142
query92	77	65	61	61
query93	1337	926	564	564
query94	559	329	284	284
query95	564	391	319	319
query96	583	464	208	208
query97	2296	2371	2281	2281
query98	227	203	205	203
query99	579	575	508	508
Total cold run time: 255888 ms
Total hot run time: 174847 ms

@doris-robot
Copy link

doris-robot commented Dec 31, 2025

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

query1	0.05	0.04	0.04
query2	0.09	0.05	0.05
query3	0.25	0.09	0.09
query4	1.61	0.12	0.11
query5	0.26	0.26	0.25
query6	1.14	0.67	0.64
query7	0.03	0.03	0.02
query8	0.05	0.05	0.04
query9	0.56	0.50	0.50
query10	0.54	0.54	0.55
query11	0.15	0.10	0.10
query12	0.15	0.13	0.12
query13	0.61	0.59	0.60
query14	1.02	0.99	0.98
query15	0.80	0.78	0.79
query16	0.40	0.40	0.40
query17	1.04	1.03	1.00
query18	0.23	0.21	0.21
query19	1.85	1.92	1.82
query20	0.03	0.02	0.02
query21	15.46	0.29	0.13
query22	4.89	0.05	0.05
query23	16.10	0.29	0.11
query24	1.32	0.25	0.51
query25	0.08	0.05	0.19
query26	0.14	0.13	0.13
query27	0.11	0.05	0.09
query28	5.56	1.05	0.87
query29	12.60	3.95	3.16
query30	0.29	0.13	0.12
query31	2.82	0.61	0.38
query32	3.24	0.55	0.46
query33	2.99	3.00	3.01
query34	16.63	5.13	4.45
query35	4.51	4.47	4.53
query36	0.66	0.49	0.48
query37	0.11	0.06	0.06
query38	0.07	0.04	0.03
query39	0.05	0.03	0.03
query40	0.16	0.14	0.13
query41	0.09	0.04	0.03
query42	0.05	0.03	0.03
query43	0.03	0.04	0.03
Total cold run time: 98.82 s
Total hot run time: 26.8 s

@yiguolei
Copy link
Contributor Author

yiguolei commented Jan 1, 2026

run buildall

@doris-robot
Copy link

doris-robot commented Jan 1, 2026

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

------ Round 1 ----------------------------------
q1	17591	4150	4021	4021
q2	2040	367	245	245
q3	10141	1373	779	779
q4	10192	848	336	336
q5	7523	2166	1940	1940
q6	183	171	138	138
q7	969	816	681	681
q8	9293	1497	1196	1196
q9	5506	4765	4878	4765
q10	6842	1786	1427	1427
q11	521	316	295	295
q12	687	729	591	591
q13	17784	3986	3088	3088
q14	318	312	273	273
q15	607	517	517	517
q16	766	706	674	674
q17	717	753	659	659
q18	7354	6566	7701	6566
q19	1118	1012	646	646
q20	450	408	298	298
q21	3473	2727	2602	2602
q22	1132	1137	1061	1061
Total cold run time: 105207 ms
Total hot run time: 32798 ms

----- Round 2, with runtime_filter_mode=off -----
q1	4276	4365	4221	4221
q2	336	405	324	324
q3	2268	2802	2414	2414
q4	1420	1869	1414	1414
q5	4452	4379	4464	4379
q6	232	189	137	137
q7	2017	1939	1895	1895
q8	2611	2438	2382	2382
q9	7108	7205	7039	7039
q10	2427	2863	2308	2308
q11	550	463	470	463
q12	699	808	646	646
q13	3566	4247	3126	3126
q14	266	274	280	274
q15	539	499	482	482
q16	662	735	612	612
q17	1091	1278	1270	1270
q18	7784	7537	7311	7311
q19	867	820	842	820
q20	1950	1988	1815	1815
q21	4682	4372	4150	4150
q22	1084	1008	1004	1004
Total cold run time: 50887 ms
Total hot run time: 48486 ms

@doris-robot
Copy link

doris-robot commented Jan 1, 2026

TPC-DS: Total hot run time: 173040 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 77a45292eb81815bbd30626cedaa1c762b97efdd, data reload: false

query5	4833	571	435	435
query6	321	240	207	207
query7	4207	462	277	277
query8	332	247	239	239
query9	8779	2622	2667	2622
query10	527	375	311	311
query11	15425	15167	14903	14903
query12	164	112	115	112
query13	1248	488	364	364
query14	6283	2930	2689	2689
query14_1	2597	2566	2581	2566
query15	201	197	176	176
query16	981	477	462	462
query17	1055	664	612	612
query18	2481	425	345	345
query19	227	215	184	184
query20	118	116	118	116
query21	213	149	117	117
query22	3786	4030	3903	3903
query23	16181	15561	15243	15243
query23_1	15548	15412	15447	15412
query24	7442	1594	1203	1203
query24_1	1226	1198	1239	1198
query25	525	463	414	414
query26	1243	260	155	155
query27	2779	448	289	289
query28	4604	2219	2192	2192
query29	773	517	438	438
query30	301	240	208	208
query31	792	649	554	554
query32	77	72	65	65
query33	550	346	279	279
query34	911	879	530	530
query35	764	794	717	717
query36	887	872	730	730
query37	130	92	81	81
query38	2745	2738	2673	2673
query39	778	746	741	741
query39_1	705	710	731	710
query40	217	134	125	125
query41	68	63	63	63
query42	107	105	108	105
query43	469	453	415	415
query44	1340	763	759	759
query45	184	183	174	174
query46	864	963	607	607
query47	1397	1436	1338	1338
query48	317	324	247	247
query49	599	421	329	329
query50	639	280	217	217
query51	3714	3776	3746	3746
query52	107	104	99	99
query53	306	335	280	280
query54	323	271	264	264
query55	83	77	74	74
query56	312	310	317	310
query57	1018	1009	954	954
query58	281	269	260	260
query59	2165	2104	2088	2088
query60	323	314	318	314
query61	213	195	192	192
query62	413	364	323	323
query63	311	275	276	275
query64	5077	1425	1122	1122
query65	3783	3701	3729	3701
query66	1459	439	340	340
query67	15474	15525	15187	15187
query68	4862	1043	754	754
query69	515	362	318	318
query70	1048	945	935	935
query71	373	306	291	291
query72	6258	3429	3502	3429
query73	767	730	314	314
query74	8788	8762	8609	8609
query75	2841	2848	2486	2486
query76	3847	1062	677	677
query77	511	374	288	288
query78	9646	9747	9059	9059
query79	1230	913	620	620
query80	621	557	490	490
query81	513	263	227	227
query82	216	146	112	112
query83	274	262	235	235
query84	260	121	108	108
query85	910	504	455	455
query86	394	294	333	294
query87	2852	2895	2746	2746
query88	3304	2274	2285	2274
query89	391	348	328	328
query90	2203	153	145	145
query91	176	165	144	144
query92	86	63	61	61
query93	1704	921	578	578
query94	574	309	295	295
query95	595	395	315	315
query96	585	476	212	212
query97	2323	2366	2274	2274
query98	239	209	202	202
query99	585	584	506	506
Total cold run time: 253392 ms
Total hot run time: 173040 ms

@doris-robot
Copy link

doris-robot commented Jan 1, 2026

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

query1	0.06	0.05	0.05
query2	0.11	0.05	0.06
query3	0.26	0.08	0.08
query4	1.61	0.11	0.11
query5	0.28	0.27	0.25
query6	1.14	0.67	0.66
query7	0.03	0.02	0.02
query8	0.06	0.04	0.04
query9	0.58	0.51	0.51
query10	0.56	0.56	0.55
query11	0.15	0.11	0.11
query12	0.16	0.12	0.13
query13	0.62	0.61	0.61
query14	0.99	0.98	1.00
query15	0.81	0.80	0.80
query16	0.40	0.40	0.41
query17	1.03	1.09	1.05
query18	0.24	0.21	0.22
query19	1.90	1.87	1.87
query20	0.02	0.01	0.02
query21	15.45	0.29	0.14
query22	4.71	0.06	0.05
query23	15.90	0.28	0.10
query24	0.98	0.72	0.34
query25	0.12	0.06	0.06
query26	0.15	0.13	0.13
query27	0.05	0.06	0.04
query28	3.46	1.05	0.89
query29	12.58	3.92	3.16
query30	0.28	0.13	0.14
query31	2.81	0.62	0.39
query32	3.23	0.56	0.46
query33	3.03	2.96	3.03
query34	16.54	5.10	4.51
query35	4.47	4.46	4.42
query36	0.65	0.52	0.49
query37	0.10	0.07	0.06
query38	0.07	0.04	0.04
query39	0.05	0.03	0.03
query40	0.16	0.14	0.13
query41	0.08	0.03	0.03
query42	0.04	0.03	0.03
query43	0.04	0.03	0.03
Total cold run time: 95.96 s
Total hot run time: 27.1 s

@yiguolei
Copy link
Contributor Author

yiguolei commented Jan 1, 2026

run buildall

@doris-robot
Copy link

doris-robot commented Jan 1, 2026

TPC-DS: Total hot run time: 2031 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 1a253887b20ec0e050935679ffb430bf28d11b4b, data reload: false

query5	
query6	
query7	
query8	
query9	
query10	
query11	
query12	
query13	
query14	
query14_1	
query15	
query16	
query17	
query18	
query19	
query20	
query21	
query22	
query23	
query23_1	
query24	
query24_1	
query25	
query26	
query27	
query28	
query29	
query30	
query31	
query32	
query33	
query34	
query35	
query36	
query37	
query38	
query39	
query39_1	
query40	
query41	
query42	
query43	
query44	
query45	
query46	
query47	
query48	
query49	
query50	
query51	
query52	
query53	
query54	
query55	
query56	
query57	
query58	
query59	
query60	
query61	
query62	
query63	
query64	
query65	
query66	
query67	
query68	
query69	
query70	
query71	
query72	
query73	
query74	
query75	
query76	
query77	
query78	
query79	
query80	
query81	
query82	
query83	
query84	
query85	
query86	
query87	
query88	
query89	
query90	
query91	
query92	
query93	
query94	
query95	
query96	
query97	
query98	
query99	
Total cold run time: 14307 ms
Total hot run time: 2031 ms

@doris-robot
Copy link

doris-robot commented Jan 1, 2026

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

query1	0.06	0.05	0.05
query2	0.10	0.05	0.05
query3	0.25	0.09	0.09
query4	1.62	0.11	0.12
query5	0.27	0.26	0.25
query6	1.14	0.65	0.65
query7	0.04	0.03	0.02
query8	0.05	0.04	0.05
query9	0.55	0.48	0.50
query10	0.54	0.55	0.55
query11	0.15	0.11	0.12
query12	0.17	0.13	0.13
query13	0.60	0.60	0.59
query14	0.99	0.99	0.99
query15	0.81	0.79	0.81
query16	0.39	0.40	0.39
query17	1.00	0.98	1.05
query18	0.23	0.21	0.21
query19	1.92	1.85	1.85
query20	0.02	0.02	0.01
query21	15.40	0.28	0.14
query22	4.65	0.05	0.05
query23	15.93	0.28	0.10
query24	1.22	0.74	0.28
query25	0.06	0.11	0.08
query26	0.15	0.13	0.13
query27	0.08	0.06	0.04
query28	3.71	1.05	0.89
query29	12.60	3.96	3.17
query30	0.27	0.13	0.12
query31	2.82	0.63	0.37
query32	3.23	0.56	0.46
query33	3.03	3.06	2.97
query34	16.56	5.07	4.45
query35	4.54	4.45	5.16
query36	0.69	0.58	0.56
query37	0.11	0.07	0.07
query38	0.07	0.04	0.04
query39	0.05	0.03	0.02
query40	0.16	0.15	0.14
query41	0.08	0.03	0.03
query42	0.04	0.03	0.03
query43	0.05	0.04	0.04
Total cold run time: 96.4 s
Total hot run time: 26.97 s

@yiguolei
Copy link
Contributor Author

yiguolei commented Jan 1, 2026

run buildall

@doris-robot
Copy link

doris-robot commented Jan 1, 2026

TPC-DS: Total hot run time: 26230 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 ed42eaf6b344ed3db8d1c48e6bfbab7aeb05d7af, data reload: false

query5	5873	584	425	425
query6	331	225	208	208
query7	4229	466	275	275
query8	347	253	234	234
query9	
query10	
query11	
query12	
query13	
query14	
query14_1	
query15	
query16	
query17	
query18	
query19	
query20	
query21	
query22	
query23	
query23_1	
query24	
query24_1	
query25	
query26	
query27	
query28	
query29	
query30	
query31	
query32	
query33	
query34	
query35	
query36	
query37	
query38	
query39	
query39_1	
query40	
query41	
query42	
query43	
query44	
query45	
query46	
query47	
query48	
query49	
query50	
query51	
query52	
query53	
query54	
query55	
query56	
query57	
query58	
query59	
query60	
query61	
query62	
query63	
query64	
query65	
query66	
query67	
query68	
query69	
query70	
query71	
query72	
query73	
query74	
query75	
query76	
query77	
query78	
query79	
query80	
query81	
query82	
query83	
query84	
query85	
query86	
query87	
query88	
query89	
query90	
query91	
query92	
query93	
query94	
query95	
query96	
query97	
query98	
query99	
Total cold run time: 49865 ms
Total hot run time: 26230 ms

@doris-robot
Copy link

doris-robot commented Jan 1, 2026

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

query1	0.06	0.05	0.05
query2	0.11	0.05	0.05
query3	0.26	0.09	0.08
query4	1.61	0.12	0.11
query5	0.28	0.27	0.25
query6	1.14	0.65	0.65
query7	0.03	0.02	0.03
query8	0.05	0.04	0.04
query9	0.58	0.51	0.51
query10	0.54	0.55	0.55
query11	0.16	0.11	0.11
query12	0.16	0.13	0.14
query13	0.61	0.60	0.59
query14	1.00	0.98	0.97
query15	0.81	0.80	0.80
query16	0.40	0.40	0.43
query17	1.00	1.07	1.04
query18	0.23	0.21	0.21
query19	1.94	1.86	1.88
query20	0.02	0.01	0.01
query21	15.40	0.30	0.14
query22	5.05	0.05	0.04
query23	16.10	0.29	0.10
query24	0.98	0.47	0.21
query25	0.12	0.08	0.06
query26	0.13	0.14	0.14
query27	0.08	0.04	0.07
query28	3.22	1.06	0.90
query29	12.59	3.90	3.15
query30	0.28	0.13	0.11
query31	2.82	0.60	0.38
query32	3.23	0.55	0.46
query33	2.98	3.03	3.06
query34	16.62	5.08	4.45
query35	4.52	4.50	5.23
query36	0.71	0.56	0.53
query37	0.12	0.07	0.06
query38	0.07	0.04	0.04
query39	0.04	0.03	0.03
query40	0.17	0.15	0.14
query41	0.09	0.03	0.02
query42	0.04	0.03	0.02
query43	0.04	0.03	0.04
Total cold run time: 96.39 s
Total hot run time: 27.01 s

@yiguolei
Copy link
Contributor Author

yiguolei commented Jan 1, 2026

run buildall

@yiguolei
Copy link
Contributor Author

yiguolei commented Jan 1, 2026

run buildall

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Reviewers

No reviews

Assignees

No one assigned

Labels

None yet

Projects

None yet

Milestone

No milestone

Development

Successfully merging this pull request may close these issues.

3 participants

@yiguolei @Thearas @doris-robot