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

   
   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 0bcb3b278c5c8b3d6917a9e23153938d598bda78, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5446    5178    5177    5177
   q2   418     156     161     156
   q3   1472    1115    1169    1115
   q4   1075    839     869     839
   q5   3125    3154    3181    3154
   q6   221     133     139     133
   q7   966     552     518     518
   q8   2158    2213    2224    2213
   q9   6731    6656    6694    6656
   q10  3202    3136    3070    3070
   q11  368     217     228     217
   q12  385     236     230     230
   q13  4362    3625    3685    3625
   q14  249     218     209     209
   q15  575     531     540     531
   q16  454     395     417     395
   q17  1050    508     474     474
   q18  7070    6761    6734    6734
   q19  1652    1528    1543    1528
   q20  560     331     337     331
   q21  2857    2552    2456    2456
   q22  399     310     347     310
   Total cold run time: 44795 ms
   Total hot run time: 40071 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5204    5129    5043    5043
   q2   341     245     228     228
   q3   3364    3338    3313    3313
   q4   2153    2028    2018    2018
   q5   5959    5934    5913    5913
   q6   223     126     132     126
   q7   2380    1897    1915    1897
   q8   3577    3674    3658    3658
   q9   9080    9025    9014    9014
   q10  3885    3900    3933    3900
   q11  584     509     476     476
   q12  798     649     632     632
   q13  3897    3155    3182    3155
   q14  299     290     281     281
   q15  594     539     524     524
   q16  556     521     512     512
   q17  2023    1799    1815    1799
   q18  8737    8321    8394    8321
   q19  1744    1697    1667    1667
   q20  2284    1979    1976    1976
   q21  5738    5330    5285    5285
   q22  549     465     463     463
   Total cold run time: 63969 ms
   Total hot run time: 60201 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