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

   
   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 a7921ee0b68d0fdd5f0e4040b53a2f284f1cec63, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5510    5127    5189    5127
   q2   407     178     178     178
   q3   1465    1182    1216    1182
   q4   1111    853     841     841
   q5   3148    3161    3083    3083
   q6   239     140     137     137
   q7   995     566     526     526
   q8   2159    2257    2231    2231
   q9   6692    6676    6659    6659
   q10  3222    3138    3090    3090
   q11  358     242     236     236
   q12  383     244     236     236
   q13  4409    3702    3704    3702
   q14  260     214     217     214
   q15  580     548     540     540
   q16  459     415     390     390
   q17  1036    514     595     514
   q18  7101    6715    6734    6715
   q19  1641    1564    1557    1557
   q20  556     369     357     357
   q21  2884    2453    2547    2453
   q22  412     327     349     327
   Total cold run time: 45027 ms
   Total hot run time: 40295 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5100    5053    5079    5053
   q2   340     236     261     236
   q3   3366    3304    3304    3304
   q4   2135    2015    2038    2015
   q5   5978    5943    5945    5943
   q6   228     125     128     125
   q7   2394    1934    1934    1934
   q8   3591    3656    3673    3656
   q9   9132    9047    9048    9047
   q10  3905    3917    3912    3912
   q11  600     495     472     472
   q12  815     630     646     630
   q13  3899    3218    3199    3199
   q14  301     268     262     262
   q15  618     551     545     545
   q16  543     518     524     518
   q17  2055    1815    1804    1804
   q18  8736    8416    8309    8309
   q19  1739    1710    1686    1686
   q20  2278    2015    1970    1970
   q21  5743    5477    5335    5335
   q22  571     506     467     467
   Total cold run time: 64067 ms
   Total hot run time: 60422 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