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/02/06 11:28:56 UTC
Re: [PR] [fix](nereids)collect all correlated slots from subquery in correct way [doris]
doris-robot commented on PR #30908:
URL: https://github.com/apache/doris/pull/30908#issuecomment-1929323856
<details>
<summary>TPC-H: <b>Total hot run time: 37085 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 217b431447f8fba482f6b264a2fd7e4f5a9c7b2b, data reload: false
------ Round 1 ----------------------------------
q1 17635 4532 4402 4402
q2 2050 140 132 132
q3 10859 1012 952 952
q4 5278 704 735 704
q5 8055 2840 2818 2818
q6 187 124 122 122
q7 1181 762 748 748
q8 9804 2041 2028 2028
q9 7746 6410 6348 6348
q10 8105 2445 2448 2445
q11 421 195 204 195
q12 786 260 279 260
q13 18027 3297 3267 3267
q14 276 246 243 243
q15 523 504 495 495
q16 467 412 408 408
q17 945 543 565 543
q18 6786 5931 5932 5931
q19 1586 1355 1353 1353
q20 628 364 330 330
q21 7009 3091 3060 3060
q22 813 317 301 301
Total cold run time: 109167 ms
Total hot run time: 37085 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4401 4427 4349 4349
q2 334 220 237 220
q3 2972 2884 2829 2829
q4 1780 1701 1613 1613
q5 5159 5219 5261 5219
q6 187 113 113 113
q7 2170 1840 1754 1754
q8 3104 3221 3229 3221
q9 8257 8355 8372 8355
q10 5750 3545 3515 3515
q11 552 457 475 457
q12 760 565 583 565
q13 6487 3100 3062 3062
q14 295 257 262 257
q15 526 488 487 487
q16 530 477 473 473
q17 1847 1691 1738 1691
q18 7944 7808 7628 7628
q19 6738 1492 1515 1492
q20 2138 1915 1881 1881
q21 4838 4570 4523 4523
q22 564 462 469 462
Total cold run time: 67333 ms
Total hot run time: 54166 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