Introducing Redgate pgNow – your free point-in-time diagnostic tool for PostgreSQL. Get real-time insights into your database health, configuration, and performance.

Are you responsible for:

• Managing the health, configuration and performance of PostgreSQL instances?
• Troubleshooting and diagnosing what is happening on the server?
• Configuring Vacuuming processes to maintain health database instances?
• Ensuring optimal Server Configuration to maintain a healthy database environment and reduce the risk of downtime?

If so, you need Redgate pgNow.

Delivered as a user-friendly desktop application, with no setup or storage required, Redgate pgNow will help you quickly identify and resolve your database issues, ensuring your PostgreSQL environment runs smoothly.

Redgate pgNow is in public preview. As an early user, you’ll have the unique opportunity to influence and shape the tool from the start. Download today.

“I’ve been using Redgate pgNow tool for the last few weeks and I’m asking myself how I lived before without it” Goran Paunović, Full Stack Developer at buildfast.com

Features:

• Workload analysis: View live metrics about running workloads by combining data from the popular pg_stat_statements extension with time slicing.
• Live session formation: Get point-in-time information from pg_stat_activity, including the queries that are executing with each process and what they’re waiting on.
• Index inspection: Identify tables that may benefit from adding indexes, along with indexes that are duplicated or unused.
• Configuration recommendations: Examine how your PostgreSQL environment is configured and get helpful recommendations.
• Vacuum health check: Inspect the health of vacuuming, analyze across your environment, and identify opportunities to improve the overall health of the vacuum process.

Resources

Check out these resources to learn more about Redgate pgNow:

• Introducing pgNow: A free, point-in-time diagnostic tool for PostgreSQL by Ryan Booz
• Introducing pgNow: Indexing by Ryan Booz
• Documentation