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

The dashboard shows views with no queries as most time taken in database #217

Closed
hvdklauw opened this issue Oct 6, 2017 · 1 comment
Closed

Comments

@hvdklauw
Copy link
Contributor

hvdklauw commented Oct 6, 2017

Database: Postgresql.

It seems the views without queries take the most time because it's sorting on a nullable field/aggregation which in postgresql come first when sorting decending.

I don't think django orm supports the "NULLS FIRST" / "NULLS LAST" options, so the nulls should probably be filtered as they are irrelevant for the specific part of the dashboard.

@avelis
Copy link
Collaborator

avelis commented Nov 4, 2017

@hvdklauw If you can make a PR contributing to optimize this that would be great!

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

No branches or pull requests

2 participants