TE
TechEcho
Home24h TopNewestBestAskShowJobs
GitHubTwitter
Home

TechEcho

A tech news platform built with Next.js, providing global tech news and discussions.

GitHubTwitter

Home

HomeNewestBestAskShowJobs

Resources

HackerNews APIOriginal HackerNewsNext.js

© 2025 TechEcho. All rights reserved.

Postgres Health Check and SQL Performance Analysis

169 pointsby torvaldover 5 years ago

7 comments

craiggover 5 years ago
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
评论 #21469664 未加载
evadneover 5 years ago
Belated. <a href="https:&#x2F;&#x2F;github.com&#x2F;jfcoz&#x2F;postgresqltuner" rel="nofollow">https:&#x2F;&#x2F;github.com&#x2F;jfcoz&#x2F;postgresqltuner</a>
评论 #21465383 未加载
matthewaveryusaover 5 years ago
&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
评论 #21466555 未加载
评论 #21466179 未加载
ahacheteover 5 years ago
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!
nbrempelover 5 years ago
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.
1996over 5 years ago
Interesting, but how heavy is it on the database server?
评论 #21465887 未加载
zlepperover 5 years ago
This looks really really nice. Does it also work with something like Citus?