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 2023/11/20 09:40:42 UTC
Re: [PR] [opt](Nereids) AssertNumRows node should triger runtime filter pruning [doris]
doris-robot commented on PR #27279:
URL: https://github.com/apache/doris/pull/27279#issuecomment-1818649092
<details>
<summary>TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'</summary>
```
Tpch sf100 test result on commit cbc88cd9f861abe81d94406ec0afa9890fc4c4d7, data reload: false
run tpch-sf100 query with default conf and session variables
q1 4918 4641 4649 4641
q2 383 171 157 157
q3 2049 1984 1908 1908
q4 1396 1289 1253 1253
q5 3982 3974 4003 3974
q6 247 125 125 125
q7 1403 892 900 892
q8 2767 2781 2786 2781
q9 9941 9641 9649 9641
q10 3479 3538 3514 3514
q11 368 251 237 237
q12 434 291 293 291
q13 4580 3856 3831 3831
q14 311 287 279 279
q15 589 538 523 523
q16 670 588 581 581
q17 1143 984 931 931
q18 7899 7427 7325 7325
q19 1666 1678 1670 1670
q20 526 303 289 289
q21 4361 3969 3950 3950
q22 460 378 369 369
Total cold run time: 53572 ms
Total hot run time: 49162 ms
run tpch-sf100 query with default conf and set session variable runtime_filter_mode=off
q1 4566 4552 4543 4543
q2 337 224 263 224
q3 4014 4000 3987 3987
q4 2686 2687 2684 2684
q5 9734 9618 9649 9618
q6 245 120 120 120
q7 2991 2483 2476 2476
q8 4488 4524 4532 4524
q9 13189 13075 13185 13075
q10 4125 4168 4211 4168
q11 804 663 670 663
q12 983 820 802 802
q13 4256 3556 3543 3543
q14 392 357 343 343
q15 566 513 516 513
q16 744 669 663 663
q17 3917 3877 3928 3877
q18 9618 9094 8888 8888
q19 1795 1777 1767 1767
q20 2394 2039 2052 2039
q21 8746 8754 8707 8707
q22 879 799 795 795
Total cold run time: 81469 ms
Total hot run time: 78019 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