You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "HappenLee (via GitHub)" <gi...@apache.org> on 2026/01/09 10:05:23 UTC
[PR] [Exec](profile) add max row count one backend in materialization profile [doris]
HappenLee opened a new pull request, #59728:
URL: https://github.com/apache/doris/pull/59728
### What problem does this PR solve?
Issue Number: close #xxx
Related PR: #xxx
Problem Summary:
### 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] [Exec](profile) add max row count one backend in materialization profile [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #59728:
URL: https://github.com/apache/doris/pull/59728#issuecomment-3728220684
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] [Exec](profile) add max row count one backend in materialization profile [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #59728:
URL: https://github.com/apache/doris/pull/59728#issuecomment-3736796666
skip check_coverage
--
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] [Exec](profile) add max row count one backend in materialization profile [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #59728:
URL: https://github.com/apache/doris/pull/59728#issuecomment-3737123526
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] [Exec](profile) add max row count one backend in materialization profile [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #59728:
URL: https://github.com/apache/doris/pull/59728#issuecomment-3728305818
<details>
<summary>TPC-H: <b>Total hot run time: 32266 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 a7c4d93595cf63dfe17601d676a6ab5da4e636a0, data reload: false
------ Round 1 ----------------------------------
q1 17629 4220 4091 4091
q2 2051 363 241 241
q3 10130 1290 753 753
q4 10209 850 317 317
q5 7529 2103 1884 1884
q6 188 175 144 144
q7 955 837 670 670
q8 9291 1441 1153 1153
q9 4859 4546 4688 4546
q10 6760 1828 1404 1404
q11 526 304 299 299
q12 716 745 592 592
q13 17776 3854 3085 3085
q14 292 306 277 277
q15 586 502 515 502
q16 729 697 661 661
q17 663 824 536 536
q18 6706 6592 7009 6592
q19 1154 1034 643 643
q20 432 390 269 269
q21 3289 2669 2583 2583
q22 1175 1096 1024 1024
Total cold run time: 103645 ms
Total hot run time: 32266 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4473 4262 4331 4262
q2 327 422 331 331
q3 2273 2809 2436 2436
q4 1418 1899 1461 1461
q5 4408 4376 4364 4364
q6 215 167 129 129
q7 1947 2154 1731 1731
q8 2541 2389 2373 2373
q9 7160 7026 7089 7026
q10 2476 2665 2328 2328
q11 552 484 456 456
q12 747 805 652 652
q13 3652 4159 3343 3343
q14 281 302 274 274
q15 542 543 493 493
q16 654 695 655 655
q17 1130 1315 1343 1315
q18 7557 7411 7195 7195
q19 871 803 833 803
q20 1888 1962 1831 1831
q21 4681 4299 4162 4162
q22 1083 1012 960 960
Total cold run time: 50876 ms
Total hot run time: 48580 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] [Exec](profile) add max row count one backend in materialization profile [doris]
Posted by "HappenLee (via GitHub)" <gi...@apache.org>.
HappenLee merged PR #59728:
URL: https://github.com/apache/doris/pull/59728
--
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] [Exec](profile) add max row count one backend in materialization profile [doris]
Posted by "HappenLee (via GitHub)" <gi...@apache.org>.
HappenLee commented on PR #59728:
URL: https://github.com/apache/doris/pull/59728#issuecomment-3728221274
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] [Exec](profile) add max row count one backend in materialization profile [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #59728:
URL: https://github.com/apache/doris/pull/59728#issuecomment-3728343785
<details>
<summary>TPC-DS: <b>Total hot run time: 173255 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 a7c4d93595cf63dfe17601d676a6ab5da4e636a0, data reload: false
query5 4507 594 427 427
query6 347 240 253 240
query7 4234 461 273 273
query8 349 273 252 252
query9 8805 2646 2615 2615
query10 515 389 321 321
query11 15281 15264 14921 14921
query12 203 116 114 114
query13 1261 501 385 385
query14 6821 2974 2804 2804
query14_1 2616 2639 2617 2617
query15 198 193 169 169
query16 993 479 443 443
query17 1070 649 543 543
query18 2697 435 332 332
query19 228 222 203 203
query20 128 121 116 116
query21 214 140 126 126
query22 3753 4150 3957 3957
query23 16090 15509 15243 15243
query23_1 15377 15533 15418 15418
query24 7282 1560 1196 1196
query24_1 1202 1176 1206 1176
query25 562 473 424 424
query26 1249 268 161 161
query27 2748 462 287 287
query28 4509 2160 2149 2149
query29 824 566 478 478
query30 313 246 218 218
query31 810 653 557 557
query32 83 81 75 75
query33 549 358 324 324
query34 910 892 528 528
query35 722 778 698 698
query36 848 893 806 806
query37 132 94 81 81
query38 2765 2686 2681 2681
query39 770 761 730 730
query39_1 708 722 725 722
query40 220 136 122 122
query41 73 73 67 67
query42 110 104 107 104
query43 436 442 458 442
query44 1309 764 716 716
query45 189 186 179 179
query46 855 972 589 589
query47 1439 1509 1367 1367
query48 312 318 241 241
query49 606 428 331 331
query50 634 266 205 205
query51 3771 3807 3772 3772
query52 107 109 101 101
query53 288 331 278 278
query54 288 255 251 251
query55 80 73 72 72
query56 283 280 302 280
query57 1082 1012 954 954
query58 264 255 255 255
query59 1955 2044 1993 1993
query60 314 321 299 299
query61 155 158 155 155
query62 402 353 328 328
query63 304 264 273 264
query64 4932 1302 972 972
query65 3833 3761 3777 3761
query66 1366 417 292 292
query67 14893 15196 15107 15107
query68 3433 1025 701 701
query69 477 349 318 318
query70 1032 895 911 895
query71 349 309 281 281
query72 6033 3371 3512 3371
query73 757 721 303 303
query74 8781 8752 8605 8605
query75 2827 2861 2469 2469
query76 3857 1066 642 642
query77 524 390 274 274
query78 9558 9689 9219 9219
query79 1521 925 580 580
query80 650 556 501 501
query81 521 265 235 235
query82 212 143 112 112
query83 270 253 241 241
query84 257 113 103 103
query85 893 512 447 447
query86 391 304 300 300
query87 2837 2877 2777 2777
query88 3181 2225 2226 2225
query89 385 360 325 325
query90 2008 151 143 143
query91 174 160 143 143
query92 78 67 61 61
query93 1159 906 538 538
query94 558 321 291 291
query95 579 322 351 322
query96 577 458 207 207
query97 2307 2393 2290 2290
query98 243 214 197 197
query99 568 580 600 580
Total cold run time: 249205 ms
Total hot run time: 173255 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] [Exec](profile) add max row count one backend in materialization profile [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #59728:
URL: https://github.com/apache/doris/pull/59728#issuecomment-3737123468
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