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

   
   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 7efc5b4eed452bde2538bc04baa4973905e03bec, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5416    5109    5180    5109
   q2   404     158     158     158
   q3   1464    1190    1145    1145
   q4   1078    786     876     786
   q5   3089    3130    3103    3103
   q6   238     133     132     132
   q7   987     553     508     508
   q8   2158    2286    2254    2254
   q9   6691    6666    6677    6666
   q10  3154    3060    3112    3060
   q11  348     216     204     204
   q12  379     233     233     233
   q13  4376    3658    3662    3658
   q14  250     219     218     218
   q15  606     556     536     536
   q16  460     395     405     395
   q17  1048    590     544     544
   q18  7064    6823    6818    6818
   q19  1640    1520    1426    1426
   q20  602     343     323     323
   q21  2918    2472    2449    2449
   q22  380     316     315     315
   Total cold run time: 44750 ms
   Total hot run time: 40040 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5156    5138    5064    5064
   q2   349     243     252     243
   q3   3359    3324    3297    3297
   q4   2160    2019    1999    1999
   q5   5947    5909    6050    5909
   q6   228     128     127     127
   q7   2383    1965    1909    1909
   q8   3551    3660    3667    3660
   q9   9054    8949    8987    8949
   q10  3859    3900    3902    3900
   q11  582     473     494     473
   q12  788     617     647     617
   q13  3893    3209    3241    3209
   q14  297     271     281     271
   q15  609     541     545     541
   q16  568     516     510     510
   q17  2062    1813    1813    1813
   q18  8776    8459    8294    8294
   q19  1748    1710    1713    1710
   q20  2280    1993    1970    1970
   q21  5762    5293    5291    5291
   q22  571     477     491     477
   Total cold run time: 63982 ms
   Total hot run time: 60233 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