Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

单表大数据量查询，使用group by超时 #28744

Open
jlshao1206 opened this issue Nov 12, 2024 · 0 comments
Open

单表大数据量查询，使用group by超时 #28744

jlshao1206 opened this issue Nov 12, 2024 · 0 comments
Labels
bug Something isn't working

Comments

@jlshao1206
Copy link

问题描述：单张主表1.7亿左右数据，针对单个字段使用group by分组查询，结合last_row获取最新值，查询出现超时；如果加上时间（ts）过滤条件，1月查询耗时1.3秒左右；
服务器资源：内存、cpu很充裕
docker镜像版本3.3.3.0
@jlshao1206 jlshao1206 added the bug Something isn't working label Nov 12, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
bug Something isn't working
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@jlshao1206