Geo: Slow query on secondary looking for unverified projects

This is taking 100 s!

2018-07-19_23:20:14.81252 LOG:  duration: 98029.197 ms  execute <unnamed> SELECT  "project_registry"."id" FROM "project_registry" INNER JOIN "gitlab_secondary"."project_repository_states" ON "project_registry"."project_id" = "gitlab_secondary"."project_repository_states"."project_id" WHERE ("project_registry"."repository_verification_checksum_sha" IS NULL AND "project_registry"."last_repository_verification_failure" IS NULL AND "project_registry"."resync_repository" = 'f' AND "gitlab_secondary"."project_repository_states"."repository_verification_checksum" IS NOT NULL OR "project_registry"."wiki_verification_checksum_sha" IS NULL AND "project_registry"."last_wiki_verification_failure" IS NULL AND "project_registry"."resync_wiki" = 'f' AND "gitlab_secondary"."project_repository_states"."wiki_verification_checksum" IS NOT NULL) LIMIT 1000
Assignee Loading
Time tracking Loading