Postgres Health Check and SQL Performance Analysis

As an Engineering Manager for the recently formed Database team here at GitLab, this tool has proven to be incredibly valuable. We floated the idea of running this on a regular basis back in April <a href="https:&#x2F;&#x2F;gitlab.com&#x2F;gitlab-com&#x2F;gl-infra&#x2F;infrastructure&#x2F;issues&#x2F;6602" rel="nofollow">https:&#x2F;&#x2F;gitlab.com&#x2F;gitlab-com&#x2F;gl-infra&#x2F;infrastructure&#x2F;issues...</a> and now we have daily reports that we review <a href="https:&#x2F;&#x2F;gitlab.com&#x2F;gitlab-com&#x2F;gl-infra&#x2F;infrastructure&#x2F;issues?scope=all&amp;utf8=%E2%9C%93&amp;state=opened&amp;search=postgres-checkup" rel="nofollow">https:&#x2F;&#x2F;gitlab.com&#x2F;gitlab-com&#x2F;gl-infra&#x2F;infrastructure&#x2F;issues...</a><p>samokhvalov helped us to get this set up

Belated. <a href="https:&#x2F;&#x2F;github.com&#x2F;jfcoz&#x2F;postgresqltuner" rel="nofollow">https:&#x2F;&#x2F;github.com&#x2F;jfcoz&#x2F;postgresqltuner</a>

&gt; tested on real-world databases containing 500,000+ tables and 1,000,000+ indexes.<p>Would love to hear about this use case out of curiosity

We have been using postgres-checkup for quite a while. Indeed, we have standardized on it as the basis on which we elaborate the health check and performance report analysis that we provide to our support customers.<p>It is a great project, constantly improving. Keep up with the work!

This seems like a great idea. I used to have a collection of magic Postgres queries that would give me metrics for optimizing data models and indices. I’m surprised there isn’t a visual tool you can bolt into your Postgres install and get valuable metrics out.

Interesting, but how heavy is it on the database server?

This looks really really nice. Does it also work with something like Citus?