You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "morningman (via GitHub)" <gi...@apache.org> on 2026/01/21 07:13:12 UTC
[PR] [opt](nereids) add nereids id for each scan node [doris]
morningman opened a new pull request, #60104:
URL: https://github.com/apache/doris/pull/60104
### What problem does this PR solve?
Add nereids id in physical plan for better debugging
### 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] [opt](nereids) add nereids id for each scan node [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #60104:
URL: https://github.com/apache/doris/pull/60104#issuecomment-3783214966
<details>
<summary>TPC-H: <b>Total hot run time: 30672 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 1cb8bd400ddd9bb653c02b8536112c8d69a42927, data reload: false
------ Round 1 ----------------------------------
q1 17665 4795 4604 4604
q2 2010 295 195 195
q3 10262 1323 745 745
q4 10199 780 304 304
q5 7476 2099 1819 1819
q6 195 176 149 149
q7 854 730 575 575
q8 9269 1371 1089 1089
q9 5030 4567 4523 4523
q10 6796 1647 1265 1265
q11 494 295 296 295
q12 363 378 235 235
q13 17795 3801 3070 3070
q14 238 239 219 219
q15 592 521 529 521
q16 657 626 592 592
q17 654 750 555 555
q18 6763 6496 6242 6242
q19 1361 994 627 627
q20 385 360 238 238
q21 2683 2174 1836 1836
q22 1074 997 974 974
Total cold run time: 102815 ms
Total hot run time: 30672 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4800 4705 4721 4705
q2 324 388 313 313
q3 2155 2666 2273 2273
q4 1320 1746 1288 1288
q5 4075 4053 4016 4016
q6 219 180 138 138
q7 1861 1839 1718 1718
q8 2845 2509 2466 2466
q9 7344 7176 7265 7176
q10 2567 2614 2325 2325
q11 569 478 458 458
q12 714 745 647 647
q13 3625 4110 3449 3449
q14 288 308 285 285
q15 602 520 519 519
q16 675 702 679 679
q17 1171 1406 1406 1406
q18 7928 7726 7656 7656
q19 903 849 935 849
q20 2071 2075 1954 1954
q21 4608 4262 4097 4097
q22 1068 1040 994 994
Total cold run time: 51732 ms
Total hot run time: 49411 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] [opt](nereids) add nereids id for each scan node [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #60104:
URL: https://github.com/apache/doris/pull/60104#issuecomment-3783257610
<details>
<summary>TPC-DS: <b>Total hot run time: 172584 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 1cb8bd400ddd9bb653c02b8536112c8d69a42927, data reload: false
query5 4439 642 496 496
query6 317 216 196 196
query7 4214 451 259 259
query8 328 229 226 226
query9 8694 2865 2849 2849
query10 447 326 283 283
query11 15299 15097 14977 14977
query12 171 114 113 113
query13 1237 463 406 406
query14 5863 3024 2790 2790
query14_1 2697 2641 2648 2641
query15 210 195 175 175
query16 993 496 462 462
query17 1099 700 569 569
query18 2428 418 336 336
query19 208 176 151 151
query20 123 120 115 115
query21 218 135 121 121
query22 4042 3875 4096 3875
query23 15887 15763 15308 15308
query23_1 15397 15529 15389 15389
query24 7141 1543 1149 1149
query24_1 1174 1165 1190 1165
query25 536 479 421 421
query26 1241 265 152 152
query27 2781 440 274 274
query28 4568 2147 2140 2140
query29 767 532 447 447
query30 310 242 204 204
query31 803 652 577 577
query32 83 80 76 76
query33 532 362 332 332
query34 893 858 530 530
query35 712 753 687 687
query36 907 897 826 826
query37 147 104 90 90
query38 2718 2793 2602 2602
query39 761 764 743 743
query39_1 725 730 717 717
query40 219 136 122 122
query41 73 68 66 66
query42 97 91 94 91
query43 467 435 448 435
query44 1378 751 738 738
query45 184 191 177 177
query46 826 937 576 576
query47 1422 1486 1409 1409
query48 315 330 236 236
query49 596 412 333 333
query50 692 274 201 201
query51 3789 3710 3695 3695
query52 91 94 80 80
query53 197 224 172 172
query54 277 268 245 245
query55 82 83 76 76
query56 285 306 287 287
query57 1002 1010 871 871
query58 264 259 252 252
query59 2130 2197 2172 2172
query60 323 316 305 305
query61 154 154 136 136
query62 409 346 310 310
query63 187 162 158 158
query64 4896 1166 824 824
query65 3806 3700 3671 3671
query66 1449 410 300 300
query67 15473 15526 15473 15473
query68 2416 1050 727 727
query69 404 316 281 281
query70 924 871 929 871
query71 291 296 267 267
query72 5278 3178 3174 3174
query73 608 717 319 319
query74 8677 8764 8511 8511
query75 2285 2327 1909 1909
query76 2267 1048 642 642
query77 355 373 308 308
query78 9666 9785 9118 9118
query79 2362 880 586 586
query80 1741 513 428 428
query81 535 262 234 234
query82 1001 146 118 118
query83 330 255 235 235
query84 258 121 99 99
query85 878 474 394 394
query86 403 298 287 287
query87 2899 2807 2742 2742
query88 3492 2576 2564 2564
query89 300 261 236 236
query90 2008 168 169 168
query91 161 151 133 133
query92 72 74 68 68
query93 1226 998 643 643
query94 627 334 281 281
query95 562 399 330 330
query96 640 500 231 231
query97 2317 2385 2362 2362
query98 216 213 197 197
query99 602 572 513 513
Total cold run time: 246991 ms
Total hot run time: 172584 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] [opt](nereids) add nereids id for each scan node [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #60104:
URL: https://github.com/apache/doris/pull/60104#issuecomment-3783754588
# FE Regression Coverage Report
Increment line coverage ` 50.00% (5/10)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/60104_1cb8bd400ddd9bb653c02b8536112c8d69a42927_merge_fe/increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/60104_1cb8bd400ddd9bb653c02b8536112c8d69a42927_merge_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] [opt](nereids) add nereids id for each scan node [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] closed pull request #60104: [opt](nereids) add nereids id for each scan node
URL: https://github.com/apache/doris/pull/60104
--
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] [opt](nereids) add nereids id for each scan node [doris]
Posted by "morningman (via GitHub)" <gi...@apache.org>.
morningman commented on PR #60104:
URL: https://github.com/apache/doris/pull/60104#issuecomment-3782992375
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] [opt](nereids) add nereids id for each scan node [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #60104:
URL: https://github.com/apache/doris/pull/60104#issuecomment-5769453922
We're closing this PR because it hasn't been updated in a while.
This isn't a judgement on the merit of the PR in any way. It's just a way of keeping the PR queue manageable.
If you'd like to revive this PR, please reopen it and feel free a maintainer to remove the Stale tag!
--
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] [opt](nereids) add nereids id for each scan node [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #60104:
URL: https://github.com/apache/doris/pull/60104#issuecomment-3783279008
<details>
<summary>ClickBench: <b>Total hot run time: 26.81 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 1cb8bd400ddd9bb653c02b8536112c8d69a42927, data reload: false
query1 0.05 0.04 0.04
query2 0.10 0.05 0.04
query3 0.26 0.08 0.09
query4 1.60 0.11 0.12
query5 0.28 0.25 0.25
query6 1.14 0.67 0.65
query7 0.03 0.03 0.03
query8 0.05 0.03 0.03
query9 0.56 0.49 0.48
query10 0.55 0.53 0.55
query11 0.14 0.09 0.10
query12 0.14 0.10 0.11
query13 0.61 0.57 0.58
query14 0.95 0.94 0.93
query15 0.80 0.77 0.79
query16 0.40 0.39 0.39
query17 1.06 1.07 1.07
query18 0.23 0.21 0.22
query19 1.92 1.81 1.81
query20 0.02 0.01 0.01
query21 15.45 0.24 0.14
query22 5.08 0.05 0.05
query23 15.86 0.29 0.10
query24 1.04 0.44 0.48
query25 0.10 0.06 0.05
query26 0.14 0.14 0.14
query27 0.09 0.08 0.05
query28 4.52 1.07 0.88
query29 12.56 3.92 3.10
query30 0.28 0.13 0.11
query31 2.82 0.64 0.39
query32 3.24 0.55 0.46
query33 3.03 2.99 3.04
query34 16.27 5.02 4.46
query35 4.45 4.46 4.47
query36 0.69 0.49 0.49
query37 0.11 0.06 0.06
query38 0.07 0.04 0.03
query39 0.04 0.04 0.02
query40 0.17 0.14 0.12
query41 0.09 0.04 0.03
query42 0.05 0.03 0.02
query43 0.05 0.03 0.04
Total cold run time: 97.09 s
Total hot run time: 26.81 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] [opt](nereids) add nereids id for each scan node [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #60104:
URL: https://github.com/apache/doris/pull/60104#issuecomment-3776534478
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] [opt](nereids) add nereids id for each scan node [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #60104:
URL: https://github.com/apache/doris/pull/60104#issuecomment-3776528759
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] [opt](nereids) add nereids id for each scan node [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #60104:
URL: https://github.com/apache/doris/pull/60104#issuecomment-3776534592
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