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`
Edited by John Jarvis