Monitor Postgres Read-Only Replica Query Performance
PostgreSQL read replicas (standby servers) operate in read-only mode and do not allow writes. Because Redgate Monitor relies on writing to the redgatemonitor repository database on each instance, it cannot collect query performance data from read replicas.
In our environment, read replicas handle a significant portion of reporting and read workload capacity. Without visibility into query performance on these replicas, we lack critical insight for troubleshooting and capacity planning.
While tools like pgNow can monitor read replicas without requiring local writes, they do not provide the historical performance data and trend analysis available in Redgate Monitor.
We are requesting support for monitoring PostgreSQL read replicas without requiring writes to a local repository database, so that query performance metrics and historical data can be captured for these instances.