Issue dashboard is slow or unusable due to slow SQL

When I hit https://gitlab.com/dashboard/issues without any filter, I'm always getting a 500 (presumably due to SQL timeouts).

Data from Grafana: