You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "doris-robot (via GitHub)" <gi...@apache.org> on 2024/07/30 03:46:50 UTC
Re: [PR] [fix](nereids) optimize cost model to make join order good for runtime filter when stats is not available [doris]
doris-robot commented on PR #38444:
URL: https://github.com/apache/doris/pull/38444#issuecomment-2257400507
<details>
<summary>TPC-H: <b>Total hot run time: 41642 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 88268d646da0aa48cc2642ad629cadef4f3bd76b, data reload: false
------ Round 1 ----------------------------------
q1 17604 4115 4075 4075
q2 2015 211 210 210
q3 10422 1280 1328 1280
q4 10157 819 963 819
q5 7559 2937 2980 2937
q6 220 136 135 135
q7 1040 625 628 625
q8 9425 1961 1925 1925
q9 8564 6615 6607 6607
q10 8783 3859 3838 3838
q11 427 248 253 248
q12 436 229 230 229
q13 17750 2968 2933 2933
q14 272 246 239 239
q15 524 483 495 483
q16 522 395 382 382
q17 968 912 904 904
q18 8013 7242 7238 7238
q19 1496 1223 1212 1212
q20 564 329 344 329
q21 5333 4707 4781 4707
q22 353 294 287 287
Total cold run time: 112447 ms
Total hot run time: 41642 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4056 4014 3994 3994
q2 334 227 224 224
q3 2988 2989 3146 2989
q4 2017 2010 1947 1947
q5 5660 5475 5457 5457
q6 222 131 131 131
q7 2137 1814 1784 1784
q8 3343 3388 3367 3367
q9 8710 8666 8859 8666
q10 3930 4068 3910 3910
q11 550 467 463 463
q12 806 605 608 605
q13 15145 3131 3112 3112
q14 318 279 269 269
q15 536 495 479 479
q16 463 429 439 429
q17 1768 1783 1756 1756
q18 8255 7669 7648 7648
q19 1707 1742 1722 1722
q20 2098 1829 1837 1829
q21 5907 5521 5354 5354
q22 551 465 468 465
Total cold run time: 71501 ms
Total hot run time: 56600 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