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

   
   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 c83556fa8af73e2ed41e8c5fdac6a6959f757ceb, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5418    5085    5181    5085
   q2   393     161     166     161
   q3   1460    1177    1233    1177
   q4   1087    908     817     817
   q5   3145    3173    3142    3142
   q6   230     138     137     137
   q7   1001    574     530     530
   q8   2164    2234    2229    2229
   q9   6688    6662    6668    6662
   q10  3193    3166    3079    3079
   q11  358     244     229     229
   q12  397     243     242     242
   q13  4439    3668    3689    3668
   q14  262     225     225     225
   q15  623     566     567     566
   q16  460     419     400     400
   q17  1046    633     508     508
   q18  7128    6836    6781    6781
   q19  1654    1528    1552    1528
   q20  575     364     350     350
   q21  2905    2492    2501    2492
   q22  398     314     337     314
   Total cold run time: 45024 ms
   Total hot run time: 40322 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5089    5092    5072    5072
   q2   344     244     262     244
   q3   3370    3346    3305    3305
   q4   2141    2011    1998    1998
   q5   6005    5935    5945    5935
   q6   231     134     135     134
   q7   2444    1916    1918    1916
   q8   3531    3643    3697    3643
   q9   9077    8993    8982    8982
   q10  3888    3941    3934    3934
   q11  581     505     492     492
   q12  845     633     669     633
   q13  3903    3263    3185    3185
   q14  301     274     284     274
   q15  622     573     568     568
   q16  552     524     502     502
   q17  2040    1798    1795    1795
   q18  8751    8375    8496    8375
   q19  1743    1732    1736    1732
   q20  2292    2009    1981    1981
   q21  5779    5360    5268    5268
   q22  558     465     490     465
   Total cold run time: 64087 ms
   Total hot run time: 60433 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