You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "hello-stephen (via GitHub)" <gi...@apache.org> on 2026/05/12 10:00:54 UTC
Re: [PR] [Feature](scan) support runtime partition prune [doris]
hello-stephen commented on PR #62589:
URL: https://github.com/apache/doris/pull/62589#issuecomment-4429384142
<details>
<summary>TPC-H: <b>Total hot run time: 30022 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 2391ea7f407dcc42f8f4ddc3bcd8e0838059d15c, data reload: false
------ Round 1 ----------------------------------
orders Doris NULL NULL 0 0 0 NULL 0 NULL NULL 2023-12-26 18:27:23 2023-12-26 18:42:55 NULL utf-8 NULL NULL
============================================
q1 17712 4007 4041 4007
q2 q3 10796 878 622 622
q4 4709 469 344 344
q5 8187 1339 1134 1134
q6 362 167 138 138
q7 933 970 748 748
q8 11213 1408 1273 1273
q9 7448 5645 5428 5428
q10 6447 2079 1812 1812
q11 481 265 261 261
q12 688 421 291 291
q13 18224 3421 2756 2756
q14 290 286 262 262
q15 q16 903 870 793 793
q17 996 1016 790 790
q18 6559 5837 5729 5729
q19 1207 1389 1105 1105
q20 538 410 275 275
q21 4876 2313 1913 1913
q22 438 385 341 341
Total cold run time: 103007 ms
Total hot run time: 30022 ms
----- Round 2, with runtime_filter_mode=off -----
orders Doris NULL NULL 150000000 42 6422171781 NULL 22778155 NULL NULL 2023-12-26 18:27:23 2023-12-26 18:42:55 NULL utf-8 NULL NULL
============================================
q1 4828 4733 4798 4733
q2 q3 4670 4795 4201 4201
q4 2161 2217 1402 1402
q5 5033 5057 5216 5057
q6 196 171 133 133
q7 2046 1817 1855 1817
q8 3355 3152 3165 3152
q9 8510 8482 8559 8482
q10 4515 4564 4265 4265
q11 601 438 414 414
q12 705 756 535 535
q13 3348 3609 2923 2923
q14 314 308 287 287
q15 q16 778 788 690 690
q17 1341 1320 1307 1307
q18 8002 7115 7186 7115
q19 1173 1151 1132 1132
q20 2216 2206 1940 1940
q21 6198 5470 4922 4922
q22 527 476 398 398
Total cold run time: 60517 ms
Total hot run time: 54905 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