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

   
   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 3b6c4597805ac7e02556f49b823e065ddbc741b2, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5512    5135    5116    5116
   q2   390     165     158     158
   q3   1461    1178    1190    1178
   q4   1084    842     857     842
   q5   3107    3096    3014    3014
   q6   235     136     144     136
   q7   1016    569     522     522
   q8   2141    2237    2193    2193
   q9   6692    6697    6667    6667
   q10  3182    3146    3091    3091
   q11  352     222     223     222
   q12  396     245     239     239
   q13  4379    3647    3633    3633
   q14  256     226     221     221
   q15  630     572     567     567
   q16  467     410     415     410
   q17  1042    516     587     516
   q18  7078    6782    8093    6782
   q19  1638    1534    1510    1510
   q20  609     366     343     343
   q21  2917    2497    2525    2497
   q22  404     332     343     332
   Total cold run time: 44988 ms
   Total hot run time: 40189 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5133    5066    5047    5047
   q2   346     258     246     246
   q3   3369    3310    3310    3310
   q4   2161    2001    2037    2001
   q5   5979    5939    5952    5939
   q6   234     136     138     136
   q7   2360    1966    1927    1927
   q8   3560    3644    3666    3644
   q9   9041    9006    8969    8969
   q10  3867    3942    3924    3924
   q11  588     486     488     486
   q12  837     639     670     639
   q13  3877    3203    3206    3203
   q14  309     291     269     269
   q15  635     566     577     566
   q16  566     534     508     508
   q17  2029    1825    1804    1804
   q18  8754    8354    8329    8329
   q19  1753    1736    1748    1736
   q20  2286    1986    2009    1986
   q21  5796    5443    5411    5411
   q22  547     534     520     520
   Total cold run time: 64027 ms
   Total hot run time: 60600 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