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

   
   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 031709da4f9f62ba99e2f0a92a91b61040881cbe, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5491    5137    5149    5137
   q2   385     210     161     161
   q3   1480    1163    1069    1069
   q4   1071    749     735     735
   q5   3139    3145    3032    3032
   q6   222     133     137     133
   q7   987     557     535     535
   q8   2180    2321    2224    2224
   q9   6730    6945    6677    6677
   q10  3147    3101    3145    3101
   q11  343     222     222     222
   q12  384     238     239     238
   q13  4417    3641    3629    3629
   q14  252     226     208     208
   q15  584     535     533     533
   q16  448     399     402     399
   q17  1049    522     545     522
   q18  7093    6712    6821    6712
   q19  1657    1496    1435    1435
   q20  539     361     322     322
   q21  2905    2463    2506    2463
   q22  402     327     328     327
   Total cold run time: 44905 ms
   Total hot run time: 39814 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5115    5087    5073    5073
   q2   333     241     232     232
   q3   3358    3336    3331    3331
   q4   2162    2043    2051    2043
   q5   5953    5934    5926    5926
   q6   222     124     130     124
   q7   2381    1948    1938    1938
   q8   3565    3662    3668    3662
   q9   9075    9002    8929    8929
   q10  3857    3907    3914    3907
   q11  592     469     501     469
   q12  817     641     644     641
   q13  3908    3269    3166    3166
   q14  304     278     262     262
   q15  607     530     520     520
   q16  546     505     504     504
   q17  2030    1828    1859    1828
   q18  8754    8321    8645    8321
   q19  1747    1708    1689    1689
   q20  2275    1989    1964    1964
   q21  5767    5393    5361    5361
   q22  562     464     492     464
   Total cold run time: 63930 ms
   Total hot run time: 60354 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: commits-unsubscr...@doris.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org

Reply via email to