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

   
   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 366f65c7ee6695d2e797035c2357433b3186be84, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5544    5166    5163    5163
   q2   393     182     158     158
   q3   1464    1110    1180    1110
   q4   1114    837     793     793
   q5   3140    3091    3130    3091
   q6   228     138     129     129
   q7   996     583     527     527
   q8   2144    2263    2254    2254
   q9   6722    6672    6656    6656
   q10  3147    3149    3125    3125
   q11  341     231     214     214
   q12  382     238     237     237
   q13  4439    3641    3657    3641
   q14  263     212     220     212
   q15  602     565     545     545
   q16  453     405     408     405
   q17  1044    500     521     500
   q18  7095    6819    6789    6789
   q19  1660    1572    1423    1423
   q20  592     329     339     329
   q21  2822    2481    2439    2439
   q22  386     324     352     324
   Total cold run time: 44971 ms
   Total hot run time: 40064 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5171    5107    5137    5107
   q2   336     256     250     250
   q3   3386    3323    3297    3297
   q4   2143    2058    2084    2058
   q5   5954    5936    5967    5936
   q6   233     124     126     124
   q7   2378    1922    1952    1922
   q8   3578    3630    3698    3630
   q9   9114    9048    9079    9048
   q10  3912    3930    3946    3930
   q11  603     483     478     478
   q12  803     662     651     651
   q13  3940    3241    3193    3193
   q14  311     275     269     269
   q15  630     545     544     544
   q16  561     537     509     509
   q17  2051    1839    1819    1819
   q18  8754    8343    8333    8333
   q19  1752    1712    1694    1694
   q20  2299    1985    1999    1985
   q21  5855    5356    5359    5356
   q22  574     467     500     467
   Total cold run time: 64338 ms
   Total hot run time: 60600 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