Try pgNow out today!
Published 22 January 2025
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.