Database
Foglight for PostgreSQL
True enterprise-class monitoring for open-source Postgres
Overview
Foglight for PostgreSQL brings, for the first time, true enterprise-class monitoring to this open-source solution. It provides comprehensive performance monitoring, diagnosis, and analytics for virtualized and non-virtualized PostgreSQL databases, gathering detailed information on all PostgreSQL instances running on or associated with Foglight monitored hosts. It is easy to deploy so you can be up and running in no time, with minimal footprint and without agent overhead drag on monitored hosts.
From high-level server operations to database and table-level statistics, Foglight for PostgreSQL offers real-time monitoring and alerting, leveraging the holistic and intuitive data analysis presentation that has made Foglight a leading APM solution. The addition of PostgreSQL provides customers with the ability to analyze Postgres performance in context with application and end user experience data.
Rich Dashboards & Data Analysis
With rich dashboards and robust data analysis, the solution monitors a variety of server operations including the background writer and write-ahead logs, as well as exposing information on connections, locks, and replication status. The solution integrates with Foglight's host monitoring and incorporates these metrics into key dashboards, permitting vital system data to be presented alongside rich database metrics.
Database and table-level statistics are exposed and include both raw and derived metrics: memory hit rates, read rates, tuple modifications, transaction commits/rollbacks, standby server conflicts, disk sizes, and deadlocks. To facilitate capacity planning, a tablespaces dashboard exposes growth trends over time, a breakdown of disk space usage on the host machine, and remaining available space. Alerts can be triggered based on the rich rule set provided by the solution and leverage both static and dynamic thresholds.
Screenshots
Ready to see PostgreSQL in action?
Request a free trial or talk to our engineers about your environment.