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

   
   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 b86e2653299d8b63da865005a4933351163ac00b, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5431    5111    5055    5055
   q2   384     171     159     159
   q3   1475    1150    1149    1149
   q4   1069    830     793     793
   q5   3168    3153    3116    3116
   q6   225     140     136     136
   q7   1002    548     562     548
   q8   2170    2287    2233    2233
   q9   6708    6723    6671    6671
   q10  3199    3160    3202    3160
   q11  343     233     221     221
   q12  388     246     245     245
   q13  4400    3663    3633    3633
   q14  250     225     224     224
   q15  617     562     559     559
   q16  451     427     406     406
   q17  1041    665     507     507
   q18  7066    6815    6866    6815
   q19  1660    1529    1504    1504
   q20  634     354     345     345
   q21  2917    2553    2517    2517
   q22  408     335     321     321
   Total cold run time: 45006 ms
   Total hot run time: 40317 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5180    5056    5072    5056
   q2   342     256     253     253
   q3   3367    3337    3301    3301
   q4   2153    2038    2017    2017
   q5   5963    5923    5947    5923
   q6   235     134     134     134
   q7   2404    1964    1921    1921
   q8   3565    3684    3679    3679
   q9   9111    8928    8936    8928
   q10  3862    3885    3943    3885
   q11  578     483     478     478
   q12  820     644     641     641
   q13  3898    3200    3162    3162
   q14  295     291     276     276
   q15  635     560     583     560
   q16  561     515     511     511
   q17  2057    1853    1822    1822
   q18  8766    8315    8327    8315
   q19  1760    1717    1743    1717
   q20  2279    1993    1999    1993
   q21  5670    5349    5317    5317
   q22  550     470     469     469
   Total cold run time: 64051 ms
   Total hot run time: 60358 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