goauthentik / goauthentik/authentik
Admin Applications and Users pages are slow because of redundant GET /core/applications/
- Dominant language
- Python
- Stars
- 25.6k
- Forks
- 2k
- Avg merge
- 1d 1h
- Merged PRs (30d)
- 644
Description
## What
admin Applications/Users pages are extremely slow because GET /core/applications/ does redundant work / stale planner stats.
## Want
- Admin Applications/Users pages are extremely slow because GET /core/applications/ does redundant work / stale planner stats
## Ideas this came from
- [#20829 GET /api/v3/core/applications/ takes 5-6s due to stale query planner statistics on small policy tables + redundant queryset evaluation](https://github.com/goauthentik/authentik/issues/20829) — GET /api/v3/core/applications/?onlywithlaunchurl=true takes 5–6 seconds for authenticated users on every request, even when the application-level policy cache i
- [#21570 admin interface: slow performance for applications and users](https://github.com/goauthentik/authentik/issues/21570) — In the admin interface, applications enlist slow, providers enlist fast. users enlist slow, groups enlist fast. It looks like database indexes are missing for a
Contributor guide
Research direction
Start by profiling GET /core/applications/ while loading the admin Applications and Users pages. Review the related context in issues #20829 and #21570, focusing on the reported redundant work and stale planner statistics. Done means those pages no longer exhibit the reported extreme slowness and the endpoint's redundant work is addressed.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- python
- Domain
- backend, performance
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Active
- Clarity
- Needs clarification
- Newbie friendliness
- 35/100