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

   
   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 fb840b802807f00f52bb22674b0cfad30ea00754, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5418    5122    5208    5122
   q2   390     164     169     164
   q3   1459    1207    1180    1180
   q4   1084    877     840     840
   q5   3180    3136    3128    3128
   q6   225     136     142     136
   q7   978     564     534     534
   q8   2158    2308    2246    2246
   q9   6755    6688    6647    6647
   q10  3187    3131    3150    3131
   q11  340     215     217     215
   q12  381     234     247     234
   q13  4428    3653    3651    3651
   q14  251     215     212     212
   q15  603     549     554     549
   q16  460     445     399     399
   q17  1046    586     488     488
   q18  7054    6763    6812    6763
   q19  1652    1540    1434    1434
   q20  601     335     328     328
   q21  2894    2483    2511    2483
   q22  398     328     327     327
   Total cold run time: 44942 ms
   Total hot run time: 40211 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5107    5097    5107    5097
   q2   334     252     229     229
   q3   3440    3333    3288    3288
   q4   2172    2041    2017    2017
   q5   5957    5923    5947    5923
   q6   227     123     132     123
   q7   2342    1940    1898    1898
   q8   3585    3675    3690    3675
   q9   9115    8944    8953    8944
   q10  3861    3892    3924    3892
   q11  582     485     497     485
   q12  815     634     676     634
   q13  3894    3214    3218    3214
   q14  298     280     276     276
   q15  604     534     537     534
   q16  566     517     509     509
   q17  2041    1799    1796    1796
   q18  8753    8383    8396    8383
   q19  1746    1710    1656    1656
   q20  2267    2004    1987    1987
   q21  5834    5360    5405    5360
   q22  590     525     514     514
   Total cold run time: 64130 ms
   Total hot run time: 60434 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