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

   
   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 d5541e4211d80ff8a7765a2d8fac08a14fdbc544, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5464    5120    5243    5120
   q2   401     171     166     166
   q3   1463    1235    1118    1118
   q4   1111    831     787     787
   q5   3021    3114    3163    3114
   q6   228     143     132     132
   q7   984     557     517     517
   q8   2153    2266    2161    2161
   q9   6708    6654    6661    6654
   q10  3151    3111    3121    3111
   q11  349     226     223     223
   q12  375     240     237     237
   q13  4459    3609    3618    3609
   q14  253     212     211     211
   q15  598     544     543     543
   q16  450     405     417     405
   q17  1040    555     536     536
   q18  7057    6770    6784    6770
   q19  1635    1520    1512    1512
   q20  633     353     337     337
   q21  2893    2460    2509    2460
   q22  396     325     343     325
   Total cold run time: 44822 ms
   Total hot run time: 40048 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5219    5164    5176    5164
   q2   340     243     236     236
   q3   3393    3326    3309    3309
   q4   2149    1999    1974    1974
   q5   5916    5917    5911    5911
   q6   229     128     125     125
   q7   2386    1965    1889    1889
   q8   3553    3643    3687    3643
   q9   9078    9011    8978    8978
   q10  3871    3911    3887    3887
   q11  581     484     465     465
   q12  808     638     631     631
   q13  3893    3197    3173    3173
   q14  299     282     263     263
   q15  617     541     545     541
   q16  563     512     491     491
   q17  2039    1827    1801    1801
   q18  8798    8324    8309    8309
   q19  1743    1660    1669    1660
   q20  2293    1981    1996    1981
   q21  5703    5278    5324    5278
   q22  567     510     498     498
   Total cold run time: 64038 ms
   Total hot run time: 60207 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