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

   
   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 e791b27021f99820180227f335d4d0519061364b, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5552    5137    5107    5107
   q2   393     163     164     163
   q3   1456    1176    1197    1176
   q4   1099    842     811     811
   q5   3139    2994    2949    2949
   q6   229     137     136     136
   q7   979     535     526     526
   q8   2168    2231    2189    2189
   q9   6693    6681    6670    6670
   q10  3184    3152    3132    3132
   q11  335     228     213     213
   q12  381     231     233     231
   q13  4363    3675    3654    3654
   q14  256     222     221     221
   q15  575     546     520     520
   q16  475     399     409     399
   q17  1045    564     495     495
   q18  7089    6851    6979    6851
   q19  1640    1556    1421    1421
   q20  563     339     320     320
   q21  2866    2485    2485    2485
   q22  400     330     346     330
   Total cold run time: 44880 ms
   Total hot run time: 39999 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5110    5095    5106    5095
   q2   335     234     223     223
   q3   3371    3350    3344    3344
   q4   2149    2045    2022    2022
   q5   5964    5931    5934    5931
   q6   225     131     129     129
   q7   2392    1904    1890    1890
   q8   3584    3662    3654    3654
   q9   9103    9018    9039    9018
   q10  3862    3937    3939    3937
   q11  585     479     476     476
   q12  808     634     617     617
   q13  3859    3201    3203    3201
   q14  295     283     286     283
   q15  592     535     533     533
   q16  542     492     507     492
   q17  2061    1866    1799    1799
   q18  8676    8359    8360    8359
   q19  1753    1655    1697    1655
   q20  2278    1984    1997    1984
   q21  5694    5325    5419    5325
   q22  565     533     466     466
   Total cold run time: 63803 ms
   Total hot run time: 60433 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