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/05/08 15:46:53 UTC
[PR] branch-3.0: [Opt](profile) More profile for `OlapScanLocalState::hold_tablets` #50564 [doris]
github-actions[bot] opened a new pull request, #50725:
URL: https://github.com/apache/doris/pull/50725
Cherry-picked from #50564
--
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.0: [Opt](profile) More profile for `OlapScanLocalState::hold_tablets` #50564 [doris]
Posted by "dataroaring (via GitHub)" <gi...@apache.org>.
dataroaring closed pull request #50725: branch-3.0: [Opt](profile) More profile for `OlapScanLocalState::hold_tablets` #50564
URL: https://github.com/apache/doris/pull/50725
--
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.0: [Opt](profile) More profile for `OlapScanLocalState::hold_tablets` #50564 [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #50725:
URL: https://github.com/apache/doris/pull/50725#issuecomment-2863685278
<details>
<summary>ClickBench: <b>Total hot run time: 32.46 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 ba6adae7cb7bd7ef23df3ad4e9fb4fbe4237b54d, data reload: false
query1 0.03 0.02 0.03
query2 0.07 0.04 0.03
query3 0.24 0.07 0.07
query4 1.62 0.10 0.10
query5 0.50 0.50 0.52
query6 1.13 0.72 0.73
query7 0.02 0.01 0.02
query8 0.03 0.03 0.03
query9 0.56 0.49 0.51
query10 0.55 0.56 0.55
query11 0.15 0.10 0.11
query12 0.14 0.11 0.11
query13 0.62 0.60 0.59
query14 2.73 2.77 2.74
query15 0.89 0.82 0.83
query16 0.38 0.39 0.38
query17 1.07 1.06 1.04
query18 0.24 0.22 0.22
query19 1.95 1.88 2.06
query20 0.01 0.01 0.02
query21 15.36 0.59 0.58
query22 2.56 2.20 2.25
query23 17.04 1.02 0.88
query24 3.36 1.14 0.84
query25 0.26 0.17 0.12
query26 0.33 0.14 0.13
query27 0.05 0.05 0.05
query28 10.34 0.48 0.46
query29 12.59 3.22 3.20
query30 0.24 0.06 0.06
query31 2.87 0.38 0.37
query32 3.26 0.47 0.46
query33 2.98 3.01 3.02
query34 17.03 4.42 4.46
query35 4.51 4.51 4.51
query36 0.66 0.47 0.51
query37 0.09 0.06 0.06
query38 0.05 0.04 0.03
query39 0.03 0.03 0.02
query40 0.15 0.12 0.13
query41 0.08 0.03 0.02
query42 0.04 0.02 0.03
query43 0.04 0.03 0.02
Total cold run time: 106.85 s
Total hot run time: 32.46 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.0: [Opt](profile) More profile for `OlapScanLocalState::hold_tablets` #50564 [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #50725:
URL: https://github.com/apache/doris/pull/50725#issuecomment-2863640651
<details>
<summary>TPC-H: <b>Total hot run time: 39962 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 ba6adae7cb7bd7ef23df3ad4e9fb4fbe4237b54d, data reload: false
------ Round 1 ----------------------------------
q1 17628 6877 6531 6531
q2 2072 172 171 171
q3 10587 1080 1150 1080
q4 10571 748 723 723
q5 7762 2867 2812 2812
q6 220 133 127 127
q7 975 621 594 594
q8 9503 1954 2029 1954
q9 6603 6344 6437 6344
q10 6987 2265 2315 2265
q11 458 258 250 250
q12 398 214 205 205
q13 17790 3002 3004 3002
q14 246 208 211 208
q15 504 459 456 456
q16 646 590 577 577
q17 965 555 562 555
q18 7219 6722 6771 6722
q19 1382 1074 1106 1074
q20 486 202 206 202
q21 4046 3250 3141 3141
q22 1080 969 990 969
Total cold run time: 108128 ms
Total hot run time: 39962 ms
----- Round 2, with runtime_filter_mode=off -----
q1 6530 6531 6529 6529
q2 324 242 227 227
q3 2915 2830 2936 2830
q4 2058 1764 1719 1719
q5 5813 5769 5749 5749
q6 218 127 121 121
q7 2283 1806 1843 1806
q8 3385 3528 3529 3528
q9 8821 8891 8911 8891
q10 3536 3496 3491 3491
q11 587 496 484 484
q12 814 621 637 621
q13 8895 3200 3121 3121
q14 317 280 278 278
q15 500 473 459 459
q16 716 659 652 652
q17 1828 1629 1622 1622
q18 8330 7830 7759 7759
q19 1674 1533 1364 1364
q20 2084 1924 1855 1855
q21 5508 5196 5308 5196
q22 1117 1035 1010 1010
Total cold run time: 68253 ms
Total hot run time: 59312 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.0: [Opt](profile) More profile for `OlapScanLocalState::hold_tablets` #50564 [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #50725:
URL: https://github.com/apache/doris/pull/50725#issuecomment-2863528579
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.0: [Opt](profile) More profile for `OlapScanLocalState::hold_tablets` #50564 [doris]
Posted by "bobhan1 (via GitHub)" <gi...@apache.org>.
bobhan1 commented on PR #50725:
URL: https://github.com/apache/doris/pull/50725#issuecomment-2874990731
run p0
--
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.0: [Opt](profile) More profile for `OlapScanLocalState::hold_tablets` #50564 [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #50725:
URL: https://github.com/apache/doris/pull/50725#issuecomment-2863528759
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] branch-3.0: [Opt](profile) More profile for `OlapScanLocalState::hold_tablets` #50564 [doris]
Posted by "bobhan1 (via GitHub)" <gi...@apache.org>.
bobhan1 commented on PR #50725:
URL: https://github.com/apache/doris/pull/50725#issuecomment-2865218607
run p0
--
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.0: [Opt](profile) More profile for `OlapScanLocalState::hold_tablets` #50564 [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #50725:
URL: https://github.com/apache/doris/pull/50725#issuecomment-2863651765
# BE UT Coverage Report
Increment line coverage `0.00% (0/47)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/ba6adae7cb7bd7ef23df3ad4e9fb4fbe4237b54d_ba6adae7cb7bd7ef23df3ad4e9fb4fbe4237b54d/increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/ba6adae7cb7bd7ef23df3ad4e9fb4fbe4237b54d_ba6adae7cb7bd7ef23df3ad4e9fb4fbe4237b54d/report/index.html)
| Category | Coverage |
|-------------------|--------------------|
| Function Coverage | 40.95% (10796/26363) |
| Line Coverage | 31.79% (92135/289807) |
| Region Coverage | 30.88% (47565/154045) |
| Branch Coverage | 27.38% (24377/89020) |
--
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.0: [Opt](profile) More profile for `OlapScanLocalState::hold_tablets` #50564 [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #50725:
URL: https://github.com/apache/doris/pull/50725#issuecomment-2863671580
<details>
<summary>TPC-DS: <b>Total hot run time: 197639 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 ba6adae7cb7bd7ef23df3ad4e9fb4fbe4237b54d, data reload: false
query1 1289 920 881 881
query2 6266 2041 1985 1985
query3 10815 4578 4404 4404
query4 61449 30150 23934 23934
query5 5190 462 438 438
query6 393 171 178 171
query7 5432 315 312 312
query8 319 236 220 220
query9 8547 2596 2569 2569
query10 450 282 258 258
query11 17489 15151 15666 15151
query12 162 101 108 101
query13 1439 456 433 433
query14 10210 7106 7169 7106
query15 214 181 184 181
query16 7337 452 504 452
query17 1189 587 588 587
query18 1847 326 318 318
query19 212 166 165 165
query20 123 113 111 111
query21 207 102 104 102
query22 4652 4677 4503 4503
query23 34832 34136 34151 34136
query24 6157 2914 2955 2914
query25 537 415 413 413
query26 653 169 176 169
query27 1847 375 370 370
query28 4432 2468 2447 2447
query29 682 468 411 411
query30 242 169 163 163
query31 983 820 837 820
query32 64 58 57 57
query33 411 288 283 283
query34 915 503 505 503
query35 859 735 743 735
query36 1074 947 960 947
query37 112 65 69 65
query38 4011 3943 3898 3898
query39 1522 1503 1462 1462
query40 204 100 104 100
query41 47 52 48 48
query42 121 104 104 104
query43 530 475 475 475
query44 1147 802 813 802
query45 190 167 172 167
query46 1144 709 727 709
query47 2046 1942 1937 1937
query48 464 383 378 378
query49 726 401 398 398
query50 854 435 420 420
query51 7422 7336 7373 7336
query52 102 87 94 87
query53 272 187 190 187
query54 573 457 474 457
query55 81 79 76 76
query56 260 262 236 236
query57 1254 1158 1156 1156
query58 210 211 222 211
query59 3171 3040 3015 3015
query60 290 259 265 259
query61 151 107 106 106
query62 766 693 687 687
query63 221 186 191 186
query64 1385 693 655 655
query65 3278 3182 3194 3182
query66 697 292 302 292
query67 16037 15545 15586 15545
query68 4120 563 557 557
query69 433 261 257 257
query70 1136 1111 1059 1059
query71 345 256 249 249
query72 6373 3965 4212 3965
query73 745 341 362 341
query74 10031 9235 8972 8972
query75 3359 2638 2639 2638
query76 2211 1193 1070 1070
query77 483 277 271 271
query78 10615 9685 9584 9584
query79 1890 579 583 579
query80 1328 428 441 428
query81 529 239 235 235
query82 1089 86 85 85
query83 163 145 140 140
query84 277 86 80 80
query85 972 301 295 295
query86 350 300 258 258
query87 4371 4238 4212 4212
query88 4002 2361 2353 2353
query89 413 291 293 291
query90 2016 183 183 183
query91 183 150 149 149
query92 64 47 51 47
query93 2204 541 537 537
query94 777 309 273 273
query95 350 255 258 255
query96 621 283 276 276
query97 3364 3128 3145 3128
query98 208 197 207 197
query99 1537 1317 1289 1289
Total cold run time: 314766 ms
Total hot run time: 197639 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.0: [Opt](profile) More profile for `OlapScanLocalState::hold_tablets` #50564 [doris]
Posted by "dataroaring (via GitHub)" <gi...@apache.org>.
dataroaring merged PR #50725:
URL: https://github.com/apache/doris/pull/50725
--
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