2018-07-04 Increased sequential reads on projects table in 11.1 RC2

I noticed there were 3 post-deploy migrations that were still down:

  down    20180417102933  Drop repository storage events for geo events
  down    20180604123514  Cleanup stages position migration
  down    20180608150653  Add index to projects on repository storage last repository updated at

I've since applied those, and we are up to date.

I noticed this Geo query is timing out:

SELECT COUNT(*) FROM "projects" INNER JOIN "project_repository_states" ON "project_repository_states"."project_id" = "projects"."id" WHERE ("project_repository_states"."repository_verification_checksum" IS NOT NULL) AND "project_repository_states"."last_repository_verification_failure" IS NULL;

Which seems to be called via the Geo::MetricsUpdateService:

Geo::RepositoryVerificationFinder.new.count_verified_repositories`