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.

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

DB analyzer: sort slow queries with better heuristics #2430

Open
ankush opened this issue Jan 17, 2025 · 1 comment
Open

DB analyzer: sort slow queries with better heuristics #2430

ankush opened this issue Jan 17, 2025 · 1 comment
Assignees

Comments

@ankush
Copy link
Member

ankush commented Jan 17, 2025

I think it's sorted by rows examined, which isn't necessarily a good choice here. Slow query log should be sorted with duration * calls = total_duration IMO.

E.g. First query is rename, that happens rarely and not worth optimizing VS the session query happens frequently and 192 seconds is insane amount of time to spend on that simple query.

Image

@ankush
Copy link
Member Author

ankush commented Jan 17, 2025

Also, we can let users pick a different sort order.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
Status: Todo
Development

No branches or pull requests

2 participants