Your free point-in-time diagnostic tool for PostgreSQL, pgNow gives you real-time insight into your database health, configuration and performance. 

Download pgNow

Features 

Workload analysis 

By combining data from the popular pg_stat_statements extension with time slicing, you can view live metrics about the running workloads. This combination provides just the right amount of  analysis when query performance issues are occurring and need the information most. 

Live session information 

Live sessions displays the 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 

Displays metric data on table and index usage, helping identify tables that may benefit by adding indexes and highlighting indexes that are duplicated or unused. 

Configuration recommendations 

Examines how your Postgres environment is configured and provides helpful recommendations about a subset of standard configuration settings which may not be optimal. 

Vacuum health check 

Analyze the health of vacuuming on your tables and identify configuration opportunities to improve the overall health of the vacuum process.