Tips for a Healthier Postgres Database

This page summarizes the projects mentioned and recommended in the original post on

Our great sponsors
  • SonarLint - Clean code begins in your IDE with SonarLint
  • Mergify - Tired of breaking your main and manually rebasing outdated pull requests?
  • InfluxDB - Collect and Analyze Billions of Data Points in Real Time
  • PgHero

    A performance dashboard for Postgres

    If you are using rails, pghero is a great gem to get better visibility on your Postgres performance

  • postgres_exporter

    A PostgreSQL metric exporter for Prometheus

    New server and want a basic config for a production server? (I'm assuming brand new app here, no prior monitoring and knowledge on what to tune.)

    Use this to get the values you need .

    This saved me a lot of headaches, and it just gets the server into a good enough state from which you can observe and optimise later.

    I'd also add in monitoring early, add a Prometheus exporter and alerts . There are a few Grafana dashboards available for the prometheus exporter, start with those.

  • SonarLint

    Clean code begins in your IDE with SonarLint. Up your coding game and discover issues early. SonarLint is a free plugin that helps you find & fix bugs and security issues from the moment you start writing code. Install from your favorite IDE marketplace today.

NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a more popular project.

Suggest a related project

Related posts