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

   
   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 c248d70b77f2d159e5466f3d33869ee35932d705, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5479    5192    5138    5138
   q2   384     172     166     166
   q3   1486    1156    1250    1156
   q4   1099    857     789     789
   q5   3099    3010    3029    3010
   q6   225     138     139     138
   q7   997     550     542     542
   q8   2154    2321    2233    2233
   q9   6721    6707    6660    6660
   q10  3165    3145    3165    3145
   q11  364     229     224     224
   q12  393     252     243     243
   q13  4429    3648    3629    3629
   q14  259     227     231     227
   q15  631     577     562     562
   q16  451     412     420     412
   q17  1068    547     525     525
   q18  7089    6764    6939    6764
   q19  1642    1536    1573    1536
   q20  637     339     343     339
   q21  2910    2499    2456    2456
   q22  393     338     324     324
   Total cold run time: 45075 ms
   Total hot run time: 40218 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5159    5081    5057    5057
   q2   350     261     250     250
   q3   3386    3343    3304    3304
   q4   2148    2017    1987    1987
   q5   5931    5944    5922    5922
   q6   235     132     135     132
   q7   2397    1965    1912    1912
   q8   3569    3677    3675    3675
   q9   9078    9086    8999    8999
   q10  3881    3925    3934    3925
   q11  592     488     482     482
   q12  819     645     651     645
   q13  3880    3220    3181    3181
   q14  306     276     283     276
   q15  620     566     570     566
   q16  565     527     515     515
   q17  2065    1798    1770    1770
   q18  8766    8421    8372    8372
   q19  1750    1705    1737    1705
   q20  2298    2009    1982    1982
   q21  5747    5357    5362    5357
   q22  557     460     498     460
   Total cold run time: 64099 ms
   Total hot run time: 60474 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