Skip to content

Geo - Improve the performance of slow count queries triggered by the Geo::MetricsUpdateWorker

Implementation Guide

The Geo::MetricsUpdateWorker can trigger very slow queries to update the Geo node status and Prometheus metrics. In #370158 (closed), we used the Gitlab::Database::BatchCount to improve the slow total replicable count. So, to avoid having performance problems on large GitLab instances, we should change the other (*)_count methods to use the same approach.

Edited by Christos Bacharakis