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

   
   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 93597f1021879e0d37471fe47cd04c7f90fd25e3, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5524    5100    5118    5100
   q2   385     178     197     178
   q3   1467    1162    1148    1148
   q4   1086    810     756     756
   q5   3149    3147    3071    3071
   q6   222     138     135     135
   q7   983     574     519     519
   q8   2144    2210    2234    2210
   q9   6688    6658    6683    6658
   q10  3176    3140    3124    3124
   q11  330     220     209     209
   q12  389     233     230     230
   q13  4383    3670    3659    3659
   q14  245     222     212     212
   q15  573     543     525     525
   q16  469     408     400     400
   q17  1046    520     507     507
   q18  7154    6773    6835    6773
   q19  1651    1581    1568    1568
   q20  567     336     411     336
   q21  2875    2550    2494    2494
   q22  371     324     323     323
   Total cold run time: 44877 ms
   Total hot run time: 40135 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5063    5091    5103    5091
   q2   333     237     231     231
   q3   3393    3357    3346    3346
   q4   2173    2055    2030    2030
   q5   5994    5949    5986    5949
   q6   228     129     130     129
   q7   2375    1942    1955    1942
   q8   3573    3666    3662    3662
   q9   9033    9009    9036    9009
   q10  3878    3941    3894    3894
   q11  595     486     474     474
   q12  814     619     647     619
   q13  3909    3197    3210    3197
   q14  295     286     273     273
   q15  584     520     526     520
   q16  535     498     513     498
   q17  2018    1875    1838    1838
   q18  8750    8342    8369    8342
   q19  1755    1700    1722    1700
   q20  2251    1981    1967    1967
   q21  5787    5324    5368    5324
   q22  568     515     479     479
   Total cold run time: 63904 ms
   Total hot run time: 60514 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