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

   
   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 d168f34f61e6a312c22cf5c082ae696b083ed908, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5548    5114    5150    5114
   q2   395     161     187     161
   q3   1442    1126    1164    1126
   q4   1101    814     816     814
   q5   3105    3042    3104    3042
   q6   223     147     130     130
   q7   972     533     545     533
   q8   2154    2287    2220    2220
   q9   6662    6715    6643    6643
   q10  3204    3194    3158    3158
   q11  342     210     221     210
   q12  389     233     237     233
   q13  4391    3643    3615    3615
   q14  259     217     232     217
   q15  607     560     537     537
   q16  459     410     403     403
   q17  1054    539     485     485
   q18  7039    6794    6936    6794
   q19  1642    1490    1467    1467
   q20  598     357     333     333
   q21  2928    2410    2563    2410
   q22  384     314     323     314
   Total cold run time: 44898 ms
   Total hot run time: 39959 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5175    5115    5083    5083
   q2   332     252     242     242
   q3   3361    3305    3335    3305
   q4   2134    2017    2016    2016
   q5   5923    5914    5912    5912
   q6   229     127     126     126
   q7   2367    1925    1903    1903
   q8   3576    3642    3680    3642
   q9   9043    9005    8983    8983
   q10  3878    3908    3908    3908
   q11  575     473     475     473
   q12  797     641     631     631
   q13  3891    3244    3185    3185
   q14  301     261     289     261
   q15  596     542     527     527
   q16  547     544     498     498
   q17  2058    1831    1834    1831
   q18  8840    8326    8327    8326
   q19  1731    1697    1666    1666
   q20  2268    1992    1992    1992
   q21  5740    5388    5358    5358
   q22  566     535     495     495
   Total cold run time: 63928 ms
   Total hot run time: 60363 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