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

   
   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 5f46c3875942e6b03d5fc1780c3b340155136ac5, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5449    5104    5137    5104
   q2   390     172     162     162
   q3   1457    1122    1146    1122
   q4   1093    841     803     803
   q5   3192    3056    3005    3005
   q6   226     140     130     130
   q7   1003    544     534     534
   q8   2152    2286    2170    2170
   q9   6679    6698    6670    6670
   q10  3191    3161    3063    3063
   q11  356     214     225     214
   q12  387     226     233     226
   q13  4431    3678    3634    3634
   q14  250     211     219     211
   q15  597     563     548     548
   q16  451     397     405     397
   q17  1046    559     507     507
   q18  7102    6754    6806    6754
   q19  1641    1539    1486    1486
   q20  593     347     363     347
   q21  2859    2474    2478    2474
   q22  400     343     329     329
   Total cold run time: 44945 ms
   Total hot run time: 39890 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5061    5109    5057    5057
   q2   331     236     247     236
   q3   3372    3317    3268    3268
   q4   2152    2040    2050    2040
   q5   5956    5936    5949    5936
   q6   230     128     123     123
   q7   2381    1938    1928    1928
   q8   3550    3654    3643    3643
   q9   9068    9018    8986    8986
   q10  3862    3919    3886    3886
   q11  584     482     491     482
   q12  810     629     630     629
   q13  3880    3256    3201    3201
   q14  295     284     255     255
   q15  610     544     534     534
   q16  531     523     530     523
   q17  2006    1825    1812    1812
   q18  8730    8337    8514    8337
   q19  1745    1721    1685    1685
   q20  2278    2010    1987    1987
   q21  5685    5380    5393    5380
   q22  567     508     490     490
   Total cold run time: 63684 ms
   Total hot run time: 60418 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