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

   
   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 44fec777dc1d389e5bf5447fbcfd3f3a6309c68e, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5515    5175    5178    5175
   q2   402     173     166     166
   q3   1452    1122    1120    1120
   q4   1082    861     810     810
   q5   3084    3136    3157    3136
   q6   223     143     130     130
   q7   981     568     513     513
   q8   2161    2206    2302    2206
   q9   6687    6691    6662    6662
   q10  3184    3093    3112    3093
   q11  339     221     213     213
   q12  383     231     230     230
   q13  4389    3628    3627    3627
   q14  262     225     213     213
   q15  608     557     540     540
   q16  477     400     416     400
   q17  1058    522     528     522
   q18  7057    6777    6780    6777
   q19  1645    1532    1473    1473
   q20  595     362     355     355
   q21  2903    2466    2486    2466
   q22  391     315     315     315
   Total cold run time: 44878 ms
   Total hot run time: 40142 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5137    5027    5137    5027
   q2   331     258     238     238
   q3   3360    3321    3308    3308
   q4   2134    2009    2025    2009
   q5   5937    5944    5924    5924
   q6   225     123     124     123
   q7   2383    1959    1913    1913
   q8   3583    3638    3670    3638
   q9   9049    8982    9019    8982
   q10  3869    3899    3910    3899
   q11  580     476     484     476
   q12  807     649     623     623
   q13  3909    3205    3197    3197
   q14  291     305     277     277
   q15  612     544     552     544
   q16  582     473     524     473
   q17  2043    1820    1823    1820
   q18  8760    8354    8417    8354
   q19  1750    1659    1664    1659
   q20  2284    1994    2001    1994
   q21  5656    5270    5335    5270
   q22  543     526     487     487
   Total cold run time: 63825 ms
   Total hot run time: 60235 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