A dashboard in Grafana is used to plot several metrics as panels for a meaningful visualization. You may wish to observe the CPU and memory utilization trend for the past 2 hours and relate it to the trend of active connections in the past 2 hours. For such a visualization, we can use PromQL, which is a query language used to fetch time series data from Prometheus. This time series data will be used by Grafana to build visualizations.
There are many such dashboards that are built/contributed by users for both Linux and Postgres monitoring. These dashboards are available at https://grafana.com/grafana/dashboards.
In this recipe, we shall discuss how to import one of the most widely used dashboards for Linux metrics that works accurately for the metrics being collected by node_exporter.
Getting ready
In order to import the dashboards discussed in this recipe, you should have already set up monitoring of your PostgreSQL server using node_exporter...
