This article is a QuickStart setup guide for Redgate pgNow activity monitoring on Azure Database for PostgreSQL Flexible Server. Once you’ve completed the setup, you can start using live query activity, health, and performance data to troubleshoot current issues on your PostgreSQL instances, all without writing any SQL scripts. Read more
This article is a QuickStart guide for configuring Amazon Aurora PostgreSQL so you can use Redgate pgNow to view live query activity, health and performance data for your PostgreSQL instances, without writing any SQL scripts. Read more
Current Activity for PostgreSQL in Redgate Monitor provides a real-time view of queries currently running on your PostgreSQL instances. It will allow you to identify quickly any queries that are currently causing blocking and resource contention issues on an instance. Read more
When processing a query in PostgreSQL that requires more memory than it's configured to allocate, data will be spilled to disk to complete the query operations. This can introduce performance bottlenecks. Redgate Monitor now includes recommendations for PostgreSQL that warn you when a spill occurs and will help you understand why and what you can do to avoid it. Read more
This article describes six performance metrics that ought to be central to your PostgreSQL monitoring strategy. By using a tool like Redgate Monitor to track these metrics over time, and establish baselines for them, you'll be able to spot resource pressure or performance issues immediately, quickly diagnose the cause, and prevent them becoming problems that affect users. Read more
An overview of how PostgreSQL monitoring in Redgate Monitor will help you improve performance and reduce downtime in your PostgreSQL instances. Read more