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

   
   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 5810b1f92f2659188e2370677ef62a259d98f8d4, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5474    5150    5144    5144
   q2   380     173     169     169
   q3   1462    1202    1156    1156
   q4   1076    805     803     803
   q5   3126    3123    3098    3098
   q6   221     133     140     133
   q7   985     556     532     532
   q8   2138    2246    2259    2246
   q9   6686    6693    6640    6640
   q10  3150    3115    3118    3115
   q11  331     216     206     206
   q12  378     238     240     238
   q13  4376    3611    3628    3611
   q14  252     214     216     214
   q15  589     542     527     527
   q16  457     397     404     397
   q17  1043    546     448     448
   q18  7094    6767    6702    6702
   q19  1637    1486    1588    1486
   q20  541     338     334     334
   q21  2869    2470    2445    2445
   q22  398     311     337     311
   Total cold run time: 44663 ms
   Total hot run time: 39955 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5137    5184    5049    5049
   q2   339     242     237     237
   q3   3375    3322    3309    3309
   q4   2171    2017    2029    2017
   q5   5918    5900    5896    5896
   q6   221     128     133     128
   q7   2376    1921    1901    1901
   q8   3524    3630    3654    3630
   q9   9033    8997    8975    8975
   q10  3888    3914    3927    3914
   q11  583     495     462     462
   q12  797     632     639     632
   q13  3878    3206    3155    3155
   q14  306     261     281     261
   q15  592     534     528     528
   q16  550     539     555     539
   q17  2018    1824    1785    1785
   q18  8756    8313    8454    8313
   q19  1735    1644    1663    1644
   q20  2287    1986    1982    1982
   q21  5747    5298    5281    5281
   q22  571     487     499     487
   Total cold run time: 63802 ms
   Total hot run time: 60125 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