Postgres Exporter

Postgres Exporter

Overview Installation Dashboards Alerting rules Grafana Cloud Integration

Introduction

The following quickstart provides setup instructions and preconfigured dashboards and alerting rules for the Postgres Exporter. After running through the steps in this quickstart, you will have:

  • Set up and configured Postgres Exporter to collect Postgres metrics like queries per second (QPS) and rows fetched/returned/inserted/updated/deleted per second. Postgres Exporter will expose these as Prometheus-style metrics.

  • Configured Prometheus to scrape Postgres Exporter metrics and optionally ship them to Grafana Cloud.

  • Imported Grafana dashboards to visualize your metrics data.

  • Set up Prometheus alerting rules to alert on your metrics data.

Metrics usage

This exporter publishes roughly 450 Prometheus time series by default. To see a list of metrics shipped by default with this exporter, please download a sample metrics scrape here.

Note that depending on its configuration, Postgres Exporter may collect and publish far more metrics than this default set. To learn more about configuring Postgres Exporter and toggling its collectors, please see the Postgres Exporter GitHub repository.

Beyond toggling Postgres Exporter’s settings, you can reduce metrics usage by dropping time series you don’t need to store in Prometheus or Grafana Cloud. To learn how to do this, please see Reducing Prometheus metrics usage with relabeling from the Grafana Cloud docs.

Grafana Cloud’s Postgres Exporter Integration

If you’re using Grafana Cloud, you can skip all of the steps in this guide by installing the Postgres Exporter Integration, which is designed to help you get up and running in a few commands and clicks. Sign up for free.

To learn how to set up Postgres Exporter using the Postgres Exporter Integration, please see Postgres Exporter Integration from the Grafana Cloud docs.