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

   
   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 b6f1d1ac388fc503595752d297aaf4c67866b73e, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5516    5084    5098    5084
   q2   389     156     168     156
   q3   1467    1126    1134    1126
   q4   1087    813     823     813
   q5   3157    3149    3189    3149
   q6   219     135     133     133
   q7   944     567     515     515
   q8   2156    2308    2392    2308
   q9   6713    6694    6682    6682
   q10  3166    3120    3173    3120
   q11  348     228     211     211
   q12  378     233     229     229
   q13  4386    3641    3658    3641
   q14  254     218     214     214
   q15  580     533     535     533
   q16  465     408     393     393
   q17  1055    536     520     520
   q18  7057    6711    6977    6711
   q19  1645    1503    1559    1503
   q20  564     346     347     346
   q21  2858    2472    2507    2472
   q22  404     322     329     322
   Total cold run time: 44808 ms
   Total hot run time: 40181 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5093    5105    5083    5083
   q2   352     230     230     230
   q3   3361    3344    3324    3324
   q4   2172    2062    2054    2054
   q5   5946    5927    5944    5927
   q6   224     127     129     127
   q7   2405    1920    1945    1920
   q8   3552    3672    3698    3672
   q9   9074    9050    9034    9034
   q10  3903    3918    3947    3918
   q11  578     489     479     479
   q12  807     625     647     625
   q13  3846    3175    3166    3166
   q14  290     269     281     269
   q15  595     532     529     529
   q16  569     495     492     492
   q17  2020    1838    1826    1826
   q18  8735    8381    8390    8381
   q19  1747    1667    1705    1667
   q20  2259    1983    1967    1967
   q21  5813    5347    5326    5326
   q22  541     472     467     467
   Total cold run time: 63882 ms
   Total hot run time: 60483 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