Group dependency list times out for some groups
Summary
Some groups are experiencing a timeout when trying to load the dependency list due to this query
https://console.postgres.ai/gitlab/gitlab-production-main/sessions/30803/commands/95639
It is not utilizing an index to scan traversal_ids, which results in scanning the entire table.
We only have partial indexes WHERE archived = false on the traversal_ids column and these are the only dependencies which we show on the dependency list so we should also have that condition here.
Steps to reproduce
Example Project
What is the current bug behavior?
What is the expected correct behavior?
Relevant logs and/or screenshots
Output of checks
Results of GitLab environment info
Expand for output related to GitLab environment info
(For installations with omnibus-gitlab package run and paste the output of: `sudo gitlab-rake gitlab:env:info`) (For installations from source run and paste the output of: `sudo -u git -H bundle exec rake gitlab:env:info RAILS_ENV=production`)
Results of GitLab application Check
Expand for output related to the GitLab application check
(For installations with omnibus-gitlab package run and paste the output of:
sudo gitlab-rake gitlab:check SANITIZE=true)(For installations from source run and paste the output of:
sudo -u git -H bundle exec rake gitlab:check RAILS_ENV=production SANITIZE=true)(we will only investigate if the tests are passing)