Grafana Dashboard

[gravgaard]

First off, thanks for maintaining this helpful project! I've been using pgxpool-prometheus to monitor PostgreSQL connection pool metrics in Prometheus, and it works out of the box.

However, I was wondering if there are any recommended Grafana dashboards available to visualize these metrics effectively. Or someone can give an example of what works for them. If any dashboards are available or if you have suggestions on how to set one up, it would be really helpful.

[cmackenzie1]

Hey @gravgaard, I unfortunately don't have any pre-built Grafana dashboards for these prometheus metrics but I'd be happy to add them if you end up building any!

[gravgaard]

@cmackenzie1 I did construct a tiny one here. Its not much but better than nothing and it helped me :)
pgxpool-prometheus-grafana-dashboard.json

It has a variable constructed for a namespace label on the metrics which is templated using "my-namespace" this meaning that the prometheus metrics are with "namepsace": "my-namespace". This can be done

Here is a tiny example from developer environment where there is a deadlock going on.