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

   
   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 040bcbfdd149ed88e3cca952ceadb5debde9602e, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5527    5117    5118    5117
   q2   399     178     159     159
   q3   1462    1211    1160    1160
   q4   1089    777     790     777
   q5   3167    3123    3068    3068
   q6   228     141     146     141
   q7   982     550     566     550
   q8   2156    2308    2214    2214
   q9   6725    6683    6693    6683
   q10  3196    3116    3126    3116
   q11  371     233     222     222
   q12  396     244     249     244
   q13  4414    3654    3637    3637
   q14  262     216     228     216
   q15  627     578     551     551
   q16  453     396     415     396
   q17  1045    589     595     589
   q18  7105    6726    6742    6726
   q19  1640    1575    1476    1476
   q20  571     344     374     344
   q21  2905    2578    2493    2493
   q22  387     316     336     316
   Total cold run time: 45107 ms
   Total hot run time: 40195 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5112    5135    5110    5110
   q2   347     266     279     266
   q3   3384    3361    3316    3316
   q4   2143    2019    2025    2019
   q5   5994    5923    5907    5907
   q6   231     133     133     133
   q7   2385    1896    1919    1896
   q8   3601    3631    3672    3631
   q9   9032    8883    8952    8883
   q10  3887    3935    3937    3935
   q11  574     479     475     475
   q12  825     652     654     652
   q13  3918    3187    3173    3173
   q14  309     278     276     276
   q15  633     566     569     566
   q16  559     493     495     493
   q17  2022    1804    1825    1804
   q18  8788    8353    8358    8353
   q19  1742    1680    1715    1680
   q20  2293    1986    1990    1986
   q21  5708    5336    5379    5336
   q22  563     515     548     515
   Total cold run time: 64050 ms
   Total hot run time: 60405 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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to