You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "github-actions[bot] (via GitHub)" <gi...@apache.org> on 2025/10/24 14:26:49 UTC

[PR] branch-3.1: [fix](nereids)relase physical plan in Profile.releaseMemory() #57257 [doris]

github-actions[bot] opened a new pull request, #57316:
URL: https://github.com/apache/doris/pull/57316

   Cherry-picked from #57257


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] branch-3.1: [fix](nereids)relase physical plan in Profile.releaseMemory() #57257 [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #57316:
URL: https://github.com/apache/doris/pull/57316#issuecomment-3443603594

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 32421 ms</b></summary>
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit dfd2251097b55583548f37a9dd23d28db1f89c32, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	17642	5432	5397	5397
   q2	2031	385	276	276
   q3	11606	1245	747	747
   q4	10325	856	440	440
   q5	9705	2348	2082	2082
   q6	200	162	127	127
   q7	898	729	622	622
   q8	9343	1415	1105	1105
   q9	5171	5005	4900	4900
   q10	6755	2248	1810	1810
   q11	476	276	259	259
   q12	350	347	207	207
   q13	17758	3551	3008	3008
   q14	225	244	220	220
   q15	534	458	469	458
   q16	411	422	374	374
   q17	596	857	362	362
   q18	6832	6471	6348	6348
   q19	1337	942	533	533
   q20	319	337	211	211
   q21	2754	2136	1953	1953
   q22	1052	1036	982	982
   Total cold run time: 106320 ms
   Total hot run time: 32421 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	5606	5535	5525	5525
   q2	242	331	231	231
   q3	2274	2665	2279	2279
   q4	1330	1817	1342	1342
   q5	4431	4932	4936	4932
   q6	167	164	135	135
   q7	2097	1987	1837	1837
   q8	2643	2812	2724	2724
   q9	7248	7235	7247	7235
   q10	3040	3344	2692	2692
   q11	554	495	493	493
   q12	679	772	636	636
   q13	3405	3791	3146	3146
   q14	281	303	267	267
   q15	531	485	480	480
   q16	426	483	425	425
   q17	1246	1732	1265	1265
   q18	7682	7512	7309	7309
   q19	768	1116	1105	1105
   q20	2081	2075	1940	1940
   q21	5392	4933	4489	4489
   q22	1081	1066	1037	1037
   Total cold run time: 53204 ms
   Total hot run time: 51524 ms
   ```
   </details>
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] branch-3.1: [fix](nereids)relase physical plan in Profile.releaseMemory() #57257 [doris]

Posted by "dataroaring (via GitHub)" <gi...@apache.org>.
dataroaring closed pull request #57316: branch-3.1: [fix](nereids)relase physical plan in Profile.releaseMemory() #57257
URL: https://github.com/apache/doris/pull/57316


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] branch-3.1: [fix](nereids)relase physical plan in Profile.releaseMemory() #57257 [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #57316:
URL: https://github.com/apache/doris/pull/57316#issuecomment-3443655607

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 192932 ms</b></summary>
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
   TPC-DS sf100 test result on commit dfd2251097b55583548f37a9dd23d28db1f89c32, data reload: false
   
   query1	959	406	419	406
   query2	6218	1970	1884	1884
   query3	8688	197	193	193
   query4	33986	23917	23557	23557
   query5	3656	598	452	452
   query6	285	185	191	185
   query7	4200	487	316	316
   query8	300	243	224	224
   query9	9247	2598	2590	2590
   query10	493	313	256	256
   query11	17871	15825	15273	15273
   query12	158	110	109	109
   query13	1556	555	419	419
   query14	9466	7724	7126	7126
   query15	257	202	180	180
   query16	8088	659	560	560
   query17	1555	779	573	573
   query18	2159	425	309	309
   query19	219	189	168	168
   query20	131	124	120	120
   query21	215	130	105	105
   query22	4551	4642	4569	4569
   query23	35230	34434	34141	34141
   query24	7672	2671	2683	2671
   query25	539	482	407	407
   query26	863	290	175	175
   query27	2050	482	374	374
   query28	5145	2256	2206	2206
   query29	738	631	475	475
   query30	260	201	161	161
   query31	971	938	827	827
   query32	98	64	63	63
   query33	509	389	338	338
   query34	719	848	514	514
   query35	792	813	727	727
   query36	1011	1070	939	939
   query37	105	103	70	70
   query38	4011	3971	4001	3971
   query39	1524	1658	1493	1493
   query40	217	127	111	111
   query41	54	53	52	52
   query42	131	109	105	105
   query43	528	515	498	498
   query44	1356	836	843	836
   query45	193	181	173	173
   query46	875	1052	666	666
   query47	2019	1982	1940	1940
   query48	446	429	360	360
   query49	736	505	430	430
   query50	699	706	445	445
   query51	7358	7216	7344	7216
   query52	101	103	96	96
   query53	242	257	194	194
   query54	555	541	484	484
   query55	81	82	78	78
   query56	284	290	266	266
   query57	1278	1312	1232	1232
   query58	250	222	240	222
   query59	3134	3187	3066	3066
   query60	299	311	267	267
   query61	120	111	116	111
   query62	820	778	694	694
   query63	229	196	196	196
   query64	3823	1034	649	649
   query65	3371	3282	3302	3282
   query66	951	414	319	319
   query67	16404	16075	15568	15568
   query68	7754	807	530	530
   query69	495	310	263	263
   query70	1146	1076	1123	1076
   query71	424	295	264	264
   query72	5120	3807	3900	3807
   query73	629	749	366	366
   query74	10205	9271	9059	9059
   query75	3979	3120	2664	2664
   query76	3401	1203	749	749
   query77	760	375	281	281
   query78	10348	10435	9756	9756
   query79	2908	839	593	593
   query80	658	519	429	429
   query81	491	258	223	223
   query82	575	122	94	94
   query83	164	160	155	155
   query84	288	98	80	80
   query85	793	356	302	302
   query86	359	283	307	283
   query87	4310	4342	4222	4222
   query88	4504	2398	2398	2398
   query89	397	335	297	297
   query90	1855	189	189	189
   query91	140	145	110	110
   query92	61	57	54	54
   query93	1793	889	526	526
   query94	635	405	292	292
   query95	346	277	263	263
   query96	482	610	280	280
   query97	3219	3228	3109	3109
   query98	217	211	205	205
   query99	1534	1406	1331	1331
   Total cold run time: 293039 ms
   Total hot run time: 192932 ms
   ```
   </details>
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] branch-3.1: [fix](nereids)relase physical plan in Profile.releaseMemory() #57257 [doris]

Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #57316:
URL: https://github.com/apache/doris/pull/57316#issuecomment-3443775795

   # FE UT Coverage Report
   Increment line coverage `  100.00% (3/3)` :tada:
   [Increment coverage report](http://coverage.selectdb-in.cc/coverage/57316_dfd2251097b55583548f37a9dd23d28db1f89c32/fe_increment_report/index.html)
   [Complete coverage report](http://coverage.selectdb-in.cc/coverage/57316_dfd2251097b55583548f37a9dd23d28db1f89c32/fe_report/index.html)
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] branch-3.1: [fix](nereids)relase physical plan in Profile.releaseMemory() #57257 [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #57316:
URL: https://github.com/apache/doris/pull/57316#issuecomment-3443674250

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 28.78 s</b></summary>
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit dfd2251097b55583548f37a9dd23d28db1f89c32, data reload: false
   
   query1	0.03	0.04	0.03
   query2	0.07	0.03	0.04
   query3	0.24	0.06	0.06
   query4	1.61	0.11	0.10
   query5	0.49	0.50	0.52
   query6	1.14	0.73	0.72
   query7	0.02	0.01	0.01
   query8	0.04	0.03	0.03
   query9	0.56	0.50	0.50
   query10	0.54	0.56	0.56
   query11	0.15	0.11	0.10
   query12	0.13	0.11	0.11
   query13	0.63	0.60	0.59
   query14	0.78	0.80	0.81
   query15	0.87	0.83	0.83
   query16	0.37	0.41	0.38
   query17	1.00	1.01	1.05
   query18	0.24	0.22	0.21
   query19	1.85	1.81	1.77
   query20	0.01	0.01	0.02
   query21	15.40	0.99	0.59
   query22	0.73	0.85	0.69
   query23	15.00	1.42	0.54
   query24	3.43	0.82	1.23
   query25	0.16	0.10	0.06
   query26	0.30	0.14	0.15
   query27	0.04	0.04	0.05
   query28	13.37	1.02	0.42
   query29	12.57	3.97	3.26
   query30	0.24	0.08	0.07
   query31	2.82	0.60	0.39
   query32	3.22	0.52	0.46
   query33	2.97	3.04	3.11
   query34	16.62	5.11	4.57
   query35	4.54	4.58	4.59
   query36	0.65	0.50	0.47
   query37	0.08	0.05	0.06
   query38	0.04	0.04	0.03
   query39	0.04	0.02	0.02
   query40	0.16	0.13	0.12
   query41	0.08	0.02	0.02
   query42	0.03	0.02	0.02
   query43	0.04	0.03	0.03
   Total cold run time: 103.3 s
   Total hot run time: 28.78 s
   ```
   </details>
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] branch-3.1: [fix](nereids)relase physical plan in Profile.releaseMemory() #57257 [doris]

Posted by "morrySnow (via GitHub)" <gi...@apache.org>.
morrySnow merged PR #57316:
URL: https://github.com/apache/doris/pull/57316


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] branch-3.1: [fix](nereids)relase physical plan in Profile.releaseMemory() #57257 [doris]

Posted by "Thearas (via GitHub)" <gi...@apache.org>.
Thearas commented on PR #57316:
URL: https://github.com/apache/doris/pull/57316#issuecomment-3443458385

   
   Thank you for your contribution to Apache Doris.
   Don't know what should be done next? See [How to process your PR](https://cwiki.apache.org/confluence/display/DORIS/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?
       


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] branch-3.1: [fix](nereids)relase physical plan in Profile.releaseMemory() #57257 [doris]

Posted by "Thearas (via GitHub)" <gi...@apache.org>.
Thearas commented on PR #57316:
URL: https://github.com/apache/doris/pull/57316#issuecomment-3443458789

   run buildall


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org