How to Monitor PostgreSQL with Prometheus & Grafana ? #prometheus #grafana #postgresql #database

This tutorial helps you to monitor "POSTGRES" DB with "Prometheus & Grafana".
Follow the below steps:
sudo cp postgres_exporter /usr/local/bin

cd /opt/postgres_exporter

sudo useradd -rs /bin/false postgres

[Unit]
Description=Prometheus exporter for Postgresql
[Service]
User=postgres
Group=postgres
WorkingDirectory=/opt/postgres_exporter
Restart=always
[Install]

sudo systemctl daemon-reload
sudo systemctl start postgres_exporter
sudo systemctl enable postgres_exporter
sudo systemctl status postgres_exporter

## Steps to perform on Prometheus Server
systemctl stop prometheus

systemctl start prometheus
systemctl status prometheus

[GabrielaLopezUrquiaga]

Great video. The ports/services debugging fragment is very useful. Thanks!

[jalandharbehera]

Very much informative to understand ❤❤

[RaviShankar-xfqx]

Thanks a lot - it's helped me to configure postgres exporter - only problem i am facing was not getting data in grafana dashboard - just getting N/A - not sure what causing the problem.

[ahmedsecad]

Hey Avinash. Nice job. Wondering have you tried multiple PG DBs using multi-target exporter?

[bindhusingaraj]

It was very useful sir.I have a doubt, Why Prometheus is taking more RAM

[MrPrajyod]

how did you create prometheus data source in the Import? you have skipped this step. Can you show how to create Prometheus data source.
While creating Prometheus Data Source I am getting error

[janupriyo]

how i use docker for postgre_exporter?

[dlccwij]

its works ! but every metric show N/A. you can help me about create Grafana user in postgresql DB & give appropriate permissions to it so it can fetch the data ?

[subhashudata]

Hi Avinash, In the end, in the dashboard, every metric is shown as "N/A".
were you be able to resolve that issue?

[rafa]

Hello, I performed all step, but postgres_exported doesn't colleg statistics from database. At the end of vide when you show grafana we can only basic stat like CPU. There isn't any data connected to postgres stats lige pgwriter, shared_buffer etc. Can you please advice how configure it to enable to collect stats from postgres?

[singhpandi]

Hi, in grafana how to find slow running queries?

[rajdeokumar]

Hi Avinash, I did the same configuration but we are not able achieve the success.

[philbongborces]

got 404 error @Avinashkumar . what is the download path?