pgmonitor
pgmonitor copied to clipboard
PostgreSQL Monitoring, Metrics Collection and Alerting Resources from Crunchy Data
# Description Update slot monitoring query to account for logical slots on replicas (patroni feature) Update changelog and documentation for next release. Update PR Template & CODEOWNERS Get pgbouncer fix...
Using the pgbouncer_fdw to monitor pgbouncer means that there's only a single connection configuration possible. This means that if pgbouncer is running on a replica and readonly queries are being...
**Describe the enhancement you are proposing:** We should add Tower metrics as a source for use in Crunchy HA. See https://www.ansible.com/blog/red-hat-ansible-tower-monitoring-using-prometheus-node-exporter-grafana for details
Add a new query file for doing more in-depth vacuum analysis. See this blog post for details - http://dtrace.org/blogs/dap/2019/05/22/visualizing-postgresql-vacuum-progress/ Keep this as a separate file to allow it to be...
**Describe the issue:** postgres_exporter gives scrape error warnings on replicas when permanent logical replication slots are in use with patroni. ``` postgres=# SELECT slot_name, active::int, pg_wal_lsn_diff(pg_current_wal_insert_lsn(), restart_lsn) AS retained_bytes FROM...
**Describe the enhancement you are proposing:** New columns in PG13+ allow per-query WAL statistics. Add metric to collect the top WAL producing queries based on PG_STAT_STATEMENTS_LIMIT
**Describe the issue:** As cgroup v2 support/adoption within Kubernetes continues to progress, I am starting to run into issues with certain exporter queries when a PostgreSQL container is running on...
See about separating out Alertmanager into its own documentation section and expanding the setup information provided
**Describe the enhancement you are proposing:** Any plans to add a dashboard similar to https://grafana.com/grafana/dashboards/2428 to show what's going on with HAProxy as part of an HA cluster?
Grafana 8.x appears to support external alertmanagers for its alerting section now. Investigate whether Prometheus Alertmanager works here https://github.com/grafana/grafana/pull/35759 https://github.com/grafana/grafana/issues/35711