Statement timeout on snippets dashboard
I receive a 500 when visiting /dashboard/snippets
https://sentry.gitlab.net/gitlab/gitlabcom/issues/228153/
PG::QueryCanceled: ERROR: canceling statement due to statement timeout : SELECT "snippets".* FROM "snippets" WHERE (snippets.project_id IN (SELECT "projects"."id" FROM "projects" LEFT JOIN project_features ON projects.id = project_features.project_id WHERE ("project_features"."snippets_access_level" IN (10, 20) OR "project_features"."snippets_access_level" IS NULL)) OR "snippets"."project_id" IS NULL) AND (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 1144264 AND (project_authorizations.project_id = snippets.project_id)) OR snippets.visibility_level IN (0,10,20) or snippets.author_id = (1144264)) AND "snippets"."author_id" = 1144264 ORDER BY created_at DESC LIMIT 20 OFFSET 0
cc @NikolayS
Edited by Mark Fletcher