Postgresql stats dashboard

Grafana PostgreSQL
1

Hello Team,

We have installed and configured the Grafana over Ubuntu18.04. Now we want to monitor our postgresql database with the help of Grafana. We have added the data source using postgresql plugin and its showing the connection status ok. Please refer the below screenshot:

Selection_039
Selection_0391003×985 68.5 KB

We integrate Postgresql machine directly with Grafana using postgresql plugin.

But now we want to monitor the stats of our postgresql database over grafana dashboard. We have tried to create new dashboard but didn’t found any data source with the name psql.

Note:- psql is the data sources name given by us.

Please help me how we can monitor the postgresql stats over grafana. May be its very easy but i am very new in grafana. Any help will be appreciated.

Thanks.

2

Hello Team,

Can you please help me on above issue?

Thanks.

3

Hello Team,

I have imported the dashboard PostgreSQL Infrastructure | Grafana Labs but when i am checking the dashboard didn’t seeing any data over it.

Selection_040
Selection_0401793×511 27.7 KB

Error pq: relation "collectd" does not exist
Error Templating init failed
pq: relation "identifiers" does not exist

I have installed the collectd package also at postgresql machine. But still getting same error.
Please help me.

Thanks.

4

Hello Team,

Can you please help me on above issue?

Thanks.

5

Hello World,

Can you please help me how we can monitor postgresql using Grafana? I have tried all things but no success. I have integrated Zabbix with Grafana and its working fine.

Thanks.

6

Hi

Try set search_path for your user in Postgres
ALTER ROLE grafana SET search_path TO "namedatabase";