We discussed how to import a dashboard to display Linux metrics in the previous recipe. In this recipe, we shall discuss a popular PostgreSQL dashboard and see how it can be imported to your Grafana server.
Getting ready
In order to import the dashboard discussed in this recipe, you should have already set up monitoring of your PostgreSQL server using postgres_exporter. Grafana should be up and running on your monitoring server.
How to do it...
We will import the dashboard as follows:
- Import a popular dashboard for Postgres built based on the default queries being used by the Postgres exporter: https://grafana.com/grafana/dashboards/9628.
- We can import this dashboard and choose Prometheus as a data source:
- Once successfully imported, we will automatically see the metrics for the PostgreSQL server on the dashboard:
How it works...
The following is one of the popular dashboards available for visualizing PostgreSQL metrics...
