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