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

   
   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 5ea45c5dbaa530cfef408482160980ae4aa10a21, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5509    5164    5154    5154
   q2   401     172     148     148
   q3   1469    1173    1119    1119
   q4   1108    857     831     831
   q5   3135    3143    3051    3051
   q6   225     148     130     130
   q7   989     583     529     529
   q8   2159    2229    2286    2229
   q9   6707    6666    6680    6666
   q10  3214    3101    3103    3101
   q11  355     212     210     210
   q12  379     229     239     229
   q13  4378    3674    3684    3674
   q14  252     228     220     220
   q15  600     551     549     549
   q16  455     425     400     400
   q17  1041    513     567     513
   q18  7078    6772    7097    6772
   q19  1641    1518    1473    1473
   q20  587     334     353     334
   q21  2887    2559    2519    2519
   q22  397     338     329     329
   Total cold run time: 44966 ms
   Total hot run time: 40180 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5160    5091    5151    5091
   q2   344     229     247     229
   q3   3358    3320    3317    3317
   q4   2173    1976    1999    1976
   q5   5934    5911    5924    5911
   q6   229     124     124     124
   q7   2388    1932    1985    1932
   q8   3574    3668    3700    3668
   q9   9041    9018    8971    8971
   q10  3872    3900    3895    3895
   q11  583     531     495     495
   q12  820     620     623     620
   q13  3889    3211    3193    3193
   q14  309     269     272     269
   q15  606     542     545     542
   q16  561     520     510     510
   q17  2034    1830    1819    1819
   q18  8705    8347    8402    8347
   q19  1745    1663    1673    1663
   q20  2288    1994    1998    1994
   q21  5725    5436    5308    5308
   q22  575     536     507     507
   Total cold run time: 63913 ms
   Total hot run time: 60381 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