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

   
   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 dcdfc71dd74974dd1980ccd649780ebf0da38ff3, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5556    5090    5158    5090
   q2   390     184     157     157
   q3   1468    1170    1161    1161
   q4   1159    812     838     812
   q5   3132    3127    3085    3085
   q6   219     133     131     131
   q7   981     562     515     515
   q8   2154    2300    2244    2244
   q9   6683    6657    6649    6649
   q10  3157    3119    3131    3119
   q11  344     229     221     221
   q12  386     231     231     231
   q13  4414    3643    3642    3642
   q14  243     226     211     211
   q15  579     533     537     533
   q16  461     411     419     411
   q17  1054    473     597     473
   q18  7085    6736    6822    6736
   q19  1644    1536    1446    1446
   q20  561     351     322     322
   q21  2921    2411    2497    2411
   q22  399     330     342     330
   Total cold run time: 44990 ms
   Total hot run time: 39930 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5055    5081    5067    5067
   q2   336     227     233     227
   q3   3374    3337    3333    3333
   q4   2163    2051    2039    2039
   q5   5954    5932    5952    5932
   q6   225     124     126     124
   q7   2372    1916    1912    1912
   q8   3549    3629    3662    3629
   q9   9029    9030    9051    9030
   q10  3880    3898    3903    3898
   q11  562     486     472     472
   q12  809     639     630     630
   q13  3903    3216    3196    3196
   q14  309     286     284     284
   q15  600     528     539     528
   q16  569     504     505     504
   q17  2026    1805    1797    1797
   q18  8735    8338    8292    8292
   q19  1753    1668    1674    1668
   q20  2250    1996    1974    1974
   q21  5728    5375    5363    5363
   q22  564     482     504     482
   Total cold run time: 63745 ms
   Total hot run time: 60381 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