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

   
   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 3307f265748cca2b80b41050558e436928bba976, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5552    5086    5186    5086
   q2   401     167     197     167
   q3   1455    1245    1188    1188
   q4   1087    776     807     776
   q5   3119    3104    3140    3104
   q6   225     136     143     136
   q7   973     562     512     512
   q8   2158    2236    2227    2227
   q9   6727    6661    6657    6657
   q10  3168    3102    3194    3102
   q11  359     218     212     212
   q12  380     237     248     237
   q13  4410    3659    3634    3634
   q14  247     217     215     215
   q15  609     548     548     548
   q16  452     405     441     405
   q17  1043    531     527     527
   q18  7066    6792    6884    6792
   q19  1636    1540    1591    1540
   q20  627     311     361     311
   q21  2911    2386    2502    2386
   q22  396     330     331     330
   Total cold run time: 45001 ms
   Total hot run time: 40092 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5114    5127    5076    5076
   q2   338     244     246     244
   q3   3388    3341    3288    3288
   q4   2130    2006    2010    2006
   q5   5942    5953    5891    5891
   q6   226     127     127     127
   q7   2391    1900    1937    1900
   q8   3588    3675    3661    3661
   q9   9084    8951    8942    8942
   q10  3876    3908    3925    3908
   q11  596     494     481     481
   q12  810     654     661     654
   q13  3891    3232    3248    3232
   q14  310     268     270     268
   q15  604     538     551     538
   q16  549     532     517     517
   q17  2033    1837    1778    1778
   q18  8805    8341    8549    8341
   q19  1744    1662    1708    1662
   q20  2294    1990    1990    1990
   q21  5737    5403    5204    5204
   q22  571     469     525     469
   Total cold run time: 64021 ms
   Total hot run time: 60177 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