apache / apache/doris

[Bug] 4.1.1 版本 FE 规划阶段(Nereids Rewrite) 消耗很多的时间

Open
#65,638 2 comments 0 reactions 0 assignees View on GitHub
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

Open the contributing 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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.