You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "Tech-Circle-48 (via GitHub)" <gi...@apache.org> on 2026/01/08 08:30:15 UTC

[PR] [Enhancement] print the detail of workload group in query profile [doris]

Tech-Circle-48 opened a new pull request, #59673:
URL: https://github.com/apache/doris/pull/59673

   ### What problem does this PR solve?
   
   Issue Number: close #xxx
   
   Related PR: #xxx
   
   Problem Summary:
   Problem Summary:
   Currently, the query profile does not show which Workload Group is used by the query, nor does it contain any configuration details of the Workload Group.
   This makes it difficult for users to diagnose performance issues related to resource control, such as CPU share, concurrency restriction, I/O bandwidth throttling, memory watermark, and queue behavior.
   
   This PR enhances the query profile by:
   • Printing the name of the Workload Group used by the query
   • Printing the detailed configuration of that Workload Group, including:
   • CPU related settings (cpu share, cpu hard limit)
   • Memory limits and watermarks
   • Query concurrency / queue settings
   • Scan thread settings
   • I/O throughput limits (read bytes per second, remote read bytes per second)
   • Tag / compute group info
   
   ### Release note
   
   None
   
   ### Check List (For Author)
   
   - Test <!-- At least one of them must be included. -->
       - [ ] 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 <!-- Add your reason?  -->
   
   - Behavior changed:
       - [ ] No.
       - [ ] Yes. <!-- Explain the behavior change -->
   
   - Does this need documentation?
       - [ ] No.
       - [ ] Yes. <!-- Add document PR link here. eg: https://github.com/apache/doris-website/pull/1214 -->
   
   ### Check List (For Reviewer who merge this PR)
   
   - [ ] Confirm the release note
   - [ ] Confirm test cases
   - [ ] Confirm document
   - [ ] Add branch pick label <!-- Add branch pick label that this PR should merge into -->
   
   


-- 
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] [Enhancement] print the detail of workload group in query profile [doris]

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

   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


Re: [PR] [Enhancement] print the detail of workload group in query profile [doris]

Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #59673:
URL: https://github.com/apache/doris/pull/59673#issuecomment-3743581154

   PR approved by anyone and no changes requested.


-- 
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] [Enhancement] print the detail of workload group in query profile [doris]

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

   # FE UT Coverage Report
   Increment line coverage `  42.33% (69/163)` :tada:
   [Increment coverage report](http://coverage.selectdb-in.cc/coverage/59673_9506f6845814fbc9ff3d071613050f84b136a46b/fe_increment_report/index.html)
   [Complete coverage report](http://coverage.selectdb-in.cc/coverage/59673_9506f6845814fbc9ff3d071613050f84b136a46b/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] [Enhancement] print the detail of workload group in query profile [doris]

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

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 31125 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 9506f6845814fbc9ff3d071613050f84b136a46b, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	17592	4164	4073	4073
   q2	2044	349	236	236
   q3	10151	1275	704	704
   q4	10218	900	336	336
   q5	7469	2038	1850	1850
   q6	184	174	140	140
   q7	890	786	654	654
   q8	9271	1382	1111	1111
   q9	4994	4437	4612	4437
   q10	6790	1791	1401	1401
   q11	538	282	280	280
   q12	687	726	583	583
   q13	17774	3847	3065	3065
   q14	305	298	268	268
   q15	598	517	510	510
   q16	656	672	630	630
   q17	670	759	570	570
   q18	6619	6576	6321	6321
   q19	1121	972	563	563
   q20	391	361	256	256
   q21	2954	2409	2199	2199
   q22	1028	995	938	938
   Total cold run time: 102944 ms
   Total hot run time: 31125 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	4084	4030	4023	4023
   q2	312	390	330	330
   q3	2098	2586	2203	2203
   q4	1297	1742	1319	1319
   q5	4143	3990	3963	3963
   q6	212	168	131	131
   q7	1892	1800	1674	1674
   q8	2704	2474	2486	2474
   q9	7333	7136	7181	7136
   q10	2494	2779	2298	2298
   q11	537	492	458	458
   q12	732	753	624	624
   q13	3586	4061	3341	3341
   q14	292	304	293	293
   q15	591	601	507	507
   q16	648	698	640	640
   q17	1133	1317	1374	1317
   q18	7998	7757	7533	7533
   q19	898	847	844	844
   q20	2003	2122	1907	1907
   q21	4809	4450	4047	4047
   q22	1082	994	966	966
   Total cold run time: 50878 ms
   Total hot run time: 48028 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] [Enhancement] print the detail of workload group in query profile [doris]

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

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 173013 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 9506f6845814fbc9ff3d071613050f84b136a46b, data reload: false
   
   query5	4428	569	428	428
   query6	330	229	204	204
   query7	4223	455	254	254
   query8	347	244	230	230
   query9	8746	2623	2630	2623
   query10	483	383	309	309
   query11	15230	15154	15103	15103
   query12	176	118	110	110
   query13	1278	466	373	373
   query14	5804	2976	2729	2729
   query14_1	2656	2631	2615	2615
   query15	220	197	179	179
   query16	1006	462	471	462
   query17	1110	684	566	566
   query18	2438	457	325	325
   query19	223	216	183	183
   query20	118	119	113	113
   query21	211	139	119	119
   query22	3852	4040	3956	3956
   query23	16054	15684	15519	15519
   query23_1	15424	15603	15734	15603
   query24	7384	1534	1155	1155
   query24_1	1159	1133	1207	1133
   query25	530	440	394	394
   query26	1241	262	149	149
   query27	2775	452	279	279
   query28	4555	2122	2109	2109
   query29	784	520	431	431
   query30	302	245	211	211
   query31	792	620	551	551
   query32	73	68	64	64
   query33	523	323	277	277
   query34	889	871	524	524
   query35	715	791	662	662
   query36	868	886	806	806
   query37	126	89	79	79
   query38	2694	2649	2646	2646
   query39	768	742	728	728
   query39_1	723	712	710	710
   query40	216	130	111	111
   query41	64	64	62	62
   query42	102	100	103	100
   query43	430	445	416	416
   query44	1309	733	710	710
   query45	183	182	174	174
   query46	834	960	582	582
   query47	1371	1452	1379	1379
   query48	305	317	244	244
   query49	593	417	320	320
   query50	631	281	191	191
   query51	3777	3824	3789	3789
   query52	105	104	95	95
   query53	293	338	276	276
   query54	277	264	241	241
   query55	81	73	76	73
   query56	292	298	275	275
   query57	1059	998	969	969
   query58	268	254	244	244
   query59	2113	2203	1948	1948
   query60	314	311	296	296
   query61	170	159	164	159
   query62	417	357	334	334
   query63	304	264	262	262
   query64	4955	1404	1098	1098
   query65	3806	3661	3740	3661
   query66	1476	437	330	330
   query67	15226	15315	15283	15283
   query68	4756	996	718	718
   query69	530	358	317	317
   query70	1058	936	955	936
   query71	356	305	279	279
   query72	6325	3357	3490	3357
   query73	735	713	294	294
   query74	8795	8718	8560	8560
   query75	2814	2788	2412	2412
   query76	3797	1046	636	636
   query77	528	377	298	298
   query78	9723	9761	9179	9179
   query79	1476	890	572	572
   query80	663	548	476	476
   query81	523	262	229	229
   query82	197	144	111	111
   query83	264	254	235	235
   query84	253	115	98	98
   query85	912	512	452	452
   query86	386	339	281	281
   query87	2871	2869	2794	2794
   query88	3172	2215	2187	2187
   query89	379	362	325	325
   query90	2031	151	145	145
   query91	182	184	140	140
   query92	75	69	62	62
   query93	1238	906	541	541
   query94	565	318	279	279
   query95	582	369	295	295
   query96	576	454	204	204
   query97	2349	2387	2299	2299
   query98	227	195	191	191
   query99	592	567	500	500
   Total cold run time: 250626 ms
   Total hot run time: 173013 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] [Enhancement] print the detail of workload group in query profile [doris]

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

   
   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] [Enhancement] print the detail of workload group in query profile [doris]

Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #59673:
URL: https://github.com/apache/doris/pull/59673#issuecomment-3743580983

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


-- 
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] [Enhancement] print the detail of workload group in query profile [doris]

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


-- 
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