doris-robot commented on PR #28228:
URL: https://github.com/apache/doris/pull/28228#issuecomment-1874922555

   
   TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G', run with 
scripts in https://github.com/apache/doris/tree/master/tools/tpch-tools
   ```
   Tpch sf100 test result on commit 7bc692f9e87070d5c5ffdeb52d5a4b257493b501, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5430    5112    5188    5112
   q2   390     163     160     160
   q3   1484    1130    1120    1120
   q4   1096    812     824     812
   q5   3147    2994    3151    2994
   q6   225     146     130     130
   q7   991     550     548     548
   q8   2167    2299    2270    2270
   q9   6679    6642    6657    6642
   q10  3207    3110    3189    3110
   q11  340     224     222     222
   q12  389     235     236     235
   q13  4446    3666    3658    3658
   q14  254     211     217     211
   q15  608     571     553     553
   q16  455     409     396     396
   q17  1053    626     538     538
   q18  7091    6750    6860    6750
   q19  1651    1539    1593    1539
   q20  589     520     338     338
   q21  2866    2482    2435    2435
   q22  398     320     338     320
   Total cold run time: 44956 ms
   Total hot run time: 40093 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5176    5065    5072    5065
   q2   341     257     247     247
   q3   3376    3321    3266    3266
   q4   2188    2020    2006    2006
   q5   5950    5906    5949    5906
   q6   229     129     128     128
   q7   2388    1901    1961    1901
   q8   3539    3663    3675    3663
   q9   9061    8994    9068    8994
   q10  3865    3887    3940    3887
   q11  596     485     484     484
   q12  800     632     653     632
   q13  3913    3216    3209    3209
   q14  304     268     265     265
   q15  602     545     550     545
   q16  544     507     504     504
   q17  2022    1824    1829    1824
   q18  8778    8353    8312    8312
   q19  1752    1698    1702    1698
   q20  2288    1990    2004    1990
   q21  5727    5371    5335    5335
   q22  573     472     482     472
   Total cold run time: 64012 ms
   Total hot run time: 60333 ms
   ```
   


-- 
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-unsubscr...@doris.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org

Reply via email to