Group issues / MRs count in the sidebar is slow and can timeout
Summary
visiting a group with many subgroups may cause a timeout issue
Steps to reproduce
- Have a group with many subgroups
- Try to open the group
- Observe error
Example Project
/
What is the current bug behavior?
The UI doesn't load due to the query being too expensive
What is the expected correct behavior?
The page loads without issues
Relevant logs and/or screenshots
- https://log.gprd.gitlab.net/app/r/s/cZ2cJ
- https://console.postgres.ai/gitlab/gitlab-production-main/sessions/32452/commands/100188#visualize-pev2
Output of checks
This bug happens on GitLab.com Enterprise Edition 17.5.0-pre 28210a8a
Possible fixes
Edited by Filip Aleksic