Options for Postgresql monitoring + trend graphs

general
1

I’m fairly noob to Postgres. More experienced with MySQL. Any advice you guys have for monitoring Postgres? Mainly would like to see the memory usage of db_shared_buffers. I guess also CPU and also graphed so that I can keep an eye for trends.

Looking for self-hosted solutions. I have Zabbix so will be trying that first.

Also trying to use this for one-off runtime info, but not able to connect yet:

2

Not too familiar postgresql but I really like grafana for monitoring, so I found this on the Google’s. Check out the project on git

Here is their demo site::

https://demo.pgwatch.com/d/9bb0d1f56/health-check?orgId=1

1 Like
3

Its also running inside a Docker container. Will update this thread once I have monitoring in place.

1 Like
4

Yes. I truly only use docker for things. I got tired of dirtying my OS. I think years of using Windows has killed baremetal installs for me.

1 Like