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

Analytics DB: Set up materialized views for dashboard queries #741

Open
jjnesbitt opened this issue Jan 23, 2024 · 0 comments
Open

Analytics DB: Set up materialized views for dashboard queries #741

jjnesbitt opened this issue Jan 23, 2024 · 0 comments

Comments

@jjnesbitt
Copy link
Collaborator

The queries we make for the grafana dashboards can be quite heavy, and without any caching, are executed far more often than is necessary. Simply loading the page sends all of the necessary queries, along with refreshing every x seconds.

We should create materialized views for these queries. We could store them in a new dashboard schema, and use un-managed Django models, along with celery cron tasks, to periodically refresh these views.

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

No branches or pull requests

1 participant