[Bug] 4.1.1 版本 FE 规划阶段(Nereids Rewrite) 消耗很多的时间
- Dominant language
- Java
- Stars
- 15.9k
- Forks
- 3.9k
- Avg merge
- 2d 23h
- Merged PRs (30d)
- 520
Description
### Search before asking
- [x] I had searched in the [issues](https://github.com/apache/doris/issues?q=is%3Aissue) and found no similar issues.
### Version
doris 4.1.1 版本
### What's Wrong?
从doris 2.1.8 版本升级到 从doris 4.1.1 版本后相同的SQL 执行时间从 2秒变到了10秒。排查问题发现 doris 4.1.1 版本 FE 规划阶段(Nereids Rewrite)花了8秒多。这个问题随着查询字段的增加进一步恶化 但是 2.1.8版本则没有类似的问题发生。附件是doris 4.1.1 的profile文件和explain 文件
[query_result_doris4_慢.csv](https://github.com/user-attachments/files/30038712/query_result_doris4_.csv)
[profile.txt](https://github.com/user-attachments/files/30038563/profile.txt)
### What You Expected?
希望能优化FE 规划阶段(Nereids Rewrite)或者是否可以通过修改配置参数解决这个问题
### How to Reproduce?
_No response_
### Anything Else?
_No response_
### Are you willing to submit PR?
- [x] Yes I am willing to submit a PR!
### Code of Conduct
- [x] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct)
Contributor guide
Research direction
Start by reviewing the attached profile.txt and query-result CSV, focusing on the FE planning stage and Nereids Rewrite time reported for Doris 4.1.1. Compare the reported behavior with Doris 2.1.8 and inspect the query fields and explain information mentioned in the issue. Done means identifying the regression cause or a configuration-based mitigation, with measured planning-time improvement.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- java, sql
- Domain
- databases, performance
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Quiet
- Clarity
- Needs clarification
- Newbie friendliness
- 35/100