I looked up and it is not so clear that the PMM plugin for prometheus has support for Postgresql. Can someone tell me please ?
Does the PMM plugin for prometheus work with postgresql and has the same functionality as the standalone PMM?
Can you be more explicit? if you’re looking at the plugin listed on the Grafana site, that’s VERY old and we are unable to remove it (lost the credentials) so are trying to work with them to get it taken down…and it was a predecessor to Percona Monitoring and Management (PMM) v1. PMM 2.0 does support PostgreSQL quite well and we’re working on a plugin that will provide even deeper query analytics similar to what’s available in MySQL via pg_stat_monitor plugin.
@steve.hoffman Ah I see. Thanks for the reply. I was thinking it is still supported and the grafana site only shows the mysql stuff, not anything about postgresql. The reason I was thinking about plugin was to avoid the extra maintenance, since we already have prometheus and grafana. Sorry for not being clear to the original question.
No worries…keep an eye out for a blog coming out about how you can have a PMM instance running to be able to dive DEEP into your databases but that feed into a broader Grafana instance where you might collect metrics from more places but probably not quite as in depth. It’s not something we formally support but is very doable. The gist of it is exposing your PMM’s VictoriaMetrics port to your existing Grafana and adding it as a datasource.
@steve.hoffman Good to hear that, and waiting for the blog