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/25 02:15:09 UTC
Re: [PR] [opt](nereids) skip null-check access path for physically non-nullable columns [doris]
hello-stephen commented on PR #63468:
URL: https://github.com/apache/doris/pull/63468#issuecomment-4531018295
<details>
<summary>TPC-H: <b>Total hot run time: 31131 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 f5a56fe03cca6c250a44abda7c30c32f0ce04daa, 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 17913 4000 3976 3976
q2 q3 10867 1402 822 822
q4 4684 479 350 350
q5 7579 2275 2131 2131
q6 351 177 138 138
q7 937 793 650 650
q8 9433 1739 1613 1613
q9 6764 4953 4961 4953
q10 6437 2253 1889 1889
q11 449 276 244 244
q12 685 423 312 312
q13 18184 3413 2783 2783
q14 270 259 241 241
q15 q16 822 792 705 705
q17 957 822 963 822
q18 6786 5757 5524 5524
q19 1254 1319 1069 1069
q20 508 400 254 254
q21 5716 2537 2352 2352
q22 437 355 303 303
Total cold run time: 101033 ms
Total hot run time: 31131 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 4385 4310 4291 4291
q2 q3 4573 4943 4338 4338
q4 2129 2236 1442 1442
q5 4467 4328 4752 4328
q6 250 200 150 150
q7 2095 1940 1616 1616
q8 2533 2191 2183 2183
q9 8059 7942 8003 7942
q10 4892 4836 4540 4540
q11 591 410 391 391
q12 753 766 556 556
q13 3295 3706 3078 3078
q14 284 318 280 280
q15 q16 733 772 682 682
q17 1380 1373 1314 1314
q18 7918 7469 6992 6992
q19 1139 1098 1115 1098
q20 2243 2241 1958 1958
q21 5345 4632 4531 4531
q22 521 460 411 411
Total cold run time: 57585 ms
Total hot run time: 52121 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