Geo: `count_verified_repositories` doesn't scale
!9939 (merged) helps, but is insufficient.
We already perform an index-only scan on the partial index here. It doesn't get much faster for the given criteria. The problem is that this returns some 8M records. I'm thinking this may be another use case for gitlab-ce#52096 where we would be able to use a stateful transactional counter instead of counting things on demand, but I'm not sure.