Skip to content

Conversation

@morningman
Copy link
Contributor

@morningman morningman commented Aug 14, 2025

introduced from #52061

@morningman morningman requested a review from morrySnow as a code owner August 14, 2025 03:54
@hello-stephen
Copy link
Contributor

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?

@morningman
Copy link
Contributor Author

run buildall

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	17625	5617	5560	5560
q2	2029	402	288	288
q3	12266	1253	741	741
q4	10311	904	465	465
q5	9111	2433	2212	2212
q6	186	165	135	135
q7	907	735	613	613
q8	9328	1464	1249	1249
q9	5362	4971	4982	4971
q10	6774	2288	1799	1799
q11	497	274	271	271
q12	330	358	211	211
q13	17761	3601	2997	2997
q14	224	239	207	207
q15	544	472	457	457
q16	419	442	364	364
q17	620	888	373	373
q18	7081	6489	6339	6339
q19	1198	970	562	562
q20	355	350	211	211
q21	2858	2241	1998	1998
q22	1034	1008	993	993
Total cold run time: 106820 ms
Total hot run time: 33016 ms

----- Round 2, with runtime_filter_mode=off -----
q1	5521	5489	5493	5489
q2	233	330	237	237
q3	2282	2569	2363	2363
q4	1375	1765	1375	1375
q5	4405	5046	4959	4959
q6	179	164	126	126
q7	2105	2035	1810	1810
q8	2699	2851	2737	2737
q9	7294	7245	7225	7225
q10	3052	3272	2735	2735
q11	600	522	497	497
q12	691	805	626	626
q13	3416	3757	3150	3150
q14	274	308	273	273
q15	524	493	467	467
q16	442	493	448	448
q17	1253	1757	1281	1281
q18	7656	7337	7228	7228
q19	815	1086	1118	1086
q20	2013	2066	1907	1907
q21	5383	4951	4558	4558
q22	1072	1079	1013	1013
Total cold run time: 53284 ms
Total hot run time: 51590 ms

@doris-robot
Copy link

TPC-DS: Total hot run time: 192243 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 84122fd8f6392b47e1ae28deebebf233830e5e24, data reload: false

query1	977	409	405	405
query2	6262	1934	1861	1861
query3	8681	199	192	192
query4	33097	23735	23859	23735
query5	3633	571	453	453
query6	306	191	177	177
query7	4204	476	309	309
query8	308	231	261	231
query9	9283	2609	2579	2579
query10	472	328	251	251
query11	18150	15388	15238	15238
query12	164	106	105	105
query13	1555	560	433	433
query14	8909	7353	7015	7015
query15	256	193	178	178
query16	7997	675	513	513
query17	1567	782	594	594
query18	2119	419	335	335
query19	210	185	168	168
query20	133	118	131	118
query21	209	130	108	108
query22	4642	4591	4525	4525
query23	35590	33848	34086	33848
query24	7311	2699	2708	2699
query25	518	489	431	431
query26	1112	268	179	179
query27	2195	486	368	368
query28	5756	2238	2191	2191
query29	591	578	457	457
query30	242	196	162	162
query31	974	938	826	826
query32	93	64	58	58
query33	495	389	314	314
query34	756	897	531	531
query35	791	823	745	745
query36	1032	1025	986	986
query37	112	94	67	67
query38	4025	4020	3900	3900
query39	1535	1483	1460	1460
query40	212	122	105	105
query41	50	49	48	48
query42	136	109	109	109
query43	494	520	459	459
query44	1385	841	853	841
query45	183	186	174	174
query46	894	1080	672	672
query47	1945	2013	1948	1948
query48	423	432	345	345
query49	778	497	417	417
query50	666	708	425	425
query51	7310	7405	7242	7242
query52	107	100	91	91
query53	230	256	191	191
query54	553	563	473	473
query55	81	78	81	78
query56	278	273	257	257
query57	1285	1248	1239	1239
query58	228	212	216	212
query59	3114	3180	2943	2943
query60	291	278	262	262
query61	112	115	111	111
query62	802	751	699	699
query63	232	194	187	187
query64	4751	993	642	642
query65	3412	3320	3348	3320
query66	964	434	318	318
query67	16570	16134	15815	15815
query68	7815	822	556	556
query69	490	314	284	284
query70	1180	1140	1114	1114
query71	388	286	267	267
query72	5649	3716	3546	3546
query73	638	737	345	345
query74	10562	9359	8955	8955
query75	3301	3131	2684	2684
query76	3230	1175	763	763
query77	767	358	282	282
query78	10429	10491	9633	9633
query79	4397	812	586	586
query80	735	541	429	429
query81	516	264	216	216
query82	592	126	88	88
query83	180	158	142	142
query84	290	101	81	81
query85	793	358	291	291
query86	402	320	297	297
query87	4354	4300	4199	4199
query88	5167	2394	2384	2384
query89	440	334	296	296
query90	1780	186	187	186
query91	133	158	113	113
query92	63	57	50	50
query93	3182	878	541	541
query94	667	412	311	311
query95	338	277	266	266
query96	491	613	287	287
query97	3210	3304	3197	3197
query98	231	212	199	199
query99	1601	1429	1287	1287
Total cold run time: 297759 ms
Total hot run time: 192243 ms

@doris-robot
Copy link

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

query1	0.03	0.03	0.03
query2	0.07	0.03	0.03
query3	0.24	0.07	0.07
query4	1.63	0.11	0.10
query5	0.51	0.52	0.50
query6	1.15	0.73	0.73
query7	0.02	0.02	0.02
query8	0.04	0.04	0.03
query9	0.56	0.49	0.48
query10	0.55	0.55	0.54
query11	0.14	0.10	0.10
query12	0.13	0.11	0.11
query13	0.61	0.58	0.60
query14	0.76	0.79	0.79
query15	0.84	0.82	0.81
query16	0.39	0.39	0.41
query17	1.05	1.01	1.02
query18	0.23	0.22	0.23
query19	1.96	1.84	1.84
query20	0.01	0.01	0.01
query21	15.38	0.90	0.57
query22	0.73	0.76	0.83
query23	15.01	1.46	0.59
query24	3.09	0.72	0.98
query25	0.25	0.15	0.10
query26	0.32	0.14	0.14
query27	0.05	0.05	0.04
query28	13.23	1.06	0.43
query29	12.61	3.98	3.31
query30	0.24	0.10	0.06
query31	2.82	0.57	0.38
query32	3.22	0.54	0.46
query33	3.00	3.03	3.06
query34	16.78	5.15	4.47
query35	4.55	4.53	4.59
query36	0.66	0.49	0.47
query37	0.08	0.06	0.06
query38	0.05	0.04	0.03
query39	0.04	0.02	0.02
query40	0.16	0.13	0.13
query41	0.08	0.03	0.03
query42	0.04	0.03	0.02
query43	0.04	0.02	0.03
Total cold run time: 103.35 s
Total hot run time: 28.76 s

@morrySnow morrySnow merged commit 4f2a280 into apache:branch-3.1 Aug 14, 2025
24 checks passed
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Projects

None yet

Development

Successfully merging this pull request may close these issues.

4 participants