Slow SQL queryid 120235503 in production
A new SQL query running since RC7 in production is now our second-largest consumer of database time.
SELECT "projects"."id" FROM "projects" INNER JOIN "project_repository_states" ON "project_repository_states"."project_id" = "projects"."id" LEFT OUTER JOIN "routes" ON "routes"."source_id" = "projects"."id" AND "routes"."source_type" = ? WHERE ("project_repository_states"."repository_verification_checksum" IS NULL AND "project_repository_states"."last_repository_verification_failure" IS NULL OR "project_repository_states"."wiki_verification_checksum" IS NULL AND "project_repository_states"."last_wiki_verification_failure" IS NULL) AND "projects"."repository_storage" = ? ORDER BY projects.last_repository_updated_at ASC NULLS LAST LIMIT ?