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

   
   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 93597f1021879e0d37471fe47cd04c7f90fd25e3, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5539    5154    5110    5110
   q2   392     174     158     158
   q3   1479    1099    1200    1099
   q4   1095    807     787     787
   q5   3141    3117    3091    3091
   q6   232     137     135     135
   q7   993     554     534     534
   q8   2162    2266    2308    2266
   q9   6772    6673    6716    6673
   q10  3187    3176    3153    3153
   q11  339     219     208     208
   q12  378     233     242     233
   q13  4384    3630    3653    3630
   q14  251     216     214     214
   q15  588     529     530     529
   q16  463     401     394     394
   q17  1049    493     574     493
   q18  7089    6845    6918    6845
   q19  1665    1540    1599    1540
   q20  594     347     329     329
   q21  2912    2471    2523    2471
   q22  395     348     324     324
   Total cold run time: 45099 ms
   Total hot run time: 40216 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5170    5075    5078    5075
   q2   332     238     238     238
   q3   3357    3335    3329    3329
   q4   2194    2131    2100    2100
   q5   5992    5931    5907    5907
   q6   225     129     130     129
   q7   2407    1921    1927    1921
   q8   3562    3682    3707    3682
   q9   9107    9054    9037    9037
   q10  3869    3905    3927    3905
   q11  584     489     464     464
   q12  812     626     621     621
   q13  3890    3219    3183    3183
   q14  295     278     272     272
   q15  584     541     529     529
   q16  569     527     502     502
   q17  2043    1840    1817    1817
   q18  8837    8363    8332    8332
   q19  1736    1674    1664    1664
   q20  2252    1974    1967    1967
   q21  5827    5360    5337    5337
   q22  570     501     480     480
   Total cold run time: 64214 ms
   Total hot run time: 60491 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