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

   
   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 3983874481039ef84b338ad0fc614fef2a4cbd02, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5574    5317    5141    5141
   q2   393     161     159     159
   q3   1491    1140    1149    1140
   q4   1094    813     795     795
   q5   3112    3114    3117    3114
   q6   236     136     131     131
   q7   990     560     523     523
   q8   2157    2314    2239    2239
   q9   6616    6678    6687    6678
   q10  3185    3169    3140    3140
   q11  340     229     206     206
   q12  379     232     233     232
   q13  4391    3635    3650    3635
   q14  247     229     222     222
   q15  606     556     543     543
   q16  459     400     411     400
   q17  1049    550     523     523
   q18  7086    6713    6713    6713
   q19  1653    1553    1447    1447
   q20  590     339     323     323
   q21  2858    2517    2454    2454
   q22  398     312     321     312
   Total cold run time: 44904 ms
   Total hot run time: 40070 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5170    5128    5156    5128
   q2   341     262     239     239
   q3   3352    3289    3310    3289
   q4   2152    2002    1978    1978
   q5   5923    5924    5926    5924
   q6   232     127     125     125
   q7   2344    1900    1963    1900
   q8   3583    3675    3683    3675
   q9   9040    8983    9040    8983
   q10  3875    3927    3908    3908
   q11  589     476     472     472
   q12  800     669     660     660
   q13  3905    3238    3200    3200
   q14  310     271     270     270
   q15  603     551     546     546
   q16  570     508     506     506
   q17  2036    1805    1810    1805
   q18  8767    8484    8431    8431
   q19  1739    1670    1659    1659
   q20  2298    2011    1983    1983
   q21  5649    5255    5367    5255
   q22  565     504     470     470
   Total cold run time: 63843 ms
   Total hot run time: 60406 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