Unable to load the Vulnerability Report filtered by Severity

Summary

Filtering by Low severity on https://gitlab.com/gitlab-org/gitlab/-/security/vulnerability_report/?severity=LOW causes an error.

Steps to reproduce

1. Visit https://gitlab.com/gitlab-org/gitlab/-/security/vulnerability_report/?severity=LOW

Example Project

What is the current bug behavior?

When visiting the vulnerability report and filtering by Low severity an error is produced and data is not loaded.

What is the expected correct behavior?

The filtered data should appear.

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)

Possible fixes

• database Create index on vulnerability_reads using btree(project_id, state, report_type, severity DESC, vulnerability_id DESC)