For the best web experience, please use IE11+, Chrome, Firefox, or Safari

Foglight for PostgreSQL

Rapidly detect, diagnose and resolve performance issues with PostgreSQL monitoring. Your organization turned to PostgreSQL because it’s a cost-effective, stable and scalable database option. However, introducing open source technology into your enterprise database ecosystem can challenge DBAs like you to realize the benefits and cost savings that the platform can provide. 
Foglight for PostgreSQL
Foglight for PostgreSQL ensures the health of your PostgreSQL infrastructure 02:13
What if you could proactively manage the health of your PostgreSQL infrastructure while helping your organization realize the cost efficiency of leveraging open source databases? What if you could do this without sacrificing your ability to monitor and diagnose problems? Foglight® for PostgreSQL addresses these and broader cross platform needs. Make your job easier by monitoring and tuning the performance of your entire PostgreSQL database environment.

Features

Query analysis

Evaluate the performance of critical statements with a complete breakdown showing the running queries , number of calls, average response time and more. View, sort or search the top statements collected from the server.

Background Writer monitoring

Prevent database performance problems by monitoring write delays, which can limit the amount of memory in the shared buffer pool.

Function analysis

Analyze the behavior of critical PostgreSQL functions, including call rates, functions with the highest average self-time and functions with the highest average total time.

Table visualization

Quickly visualize all tables for a given database on a single screen, with table health, basic properties and calculated table-level operations. Understand if reads from table indexes are successfully sourced from buffer cache rather than physical disk, and see the percentage of tuples returned from index versus sequential scans.

Intelligent alerting

Avoid false alerts with adaptive Intelli profile thresholds, which ensure alarms are only triggered when baselines are breached. Easily manage and annotate alarms, including scheduling blackouts for maintenance periods.

Easy troubleshooting

Speed problem resolution and discover chronic issues with embedded expert advice and convenient drill-down to granular details.

Enterprise-scale monitoring

Monitor hundreds of PostgreSQL database servers from a single management server.

Low overhead

Execute data collection through remote agents that ensure minimal overhead (no more than 2% CPU) is added to monitored database instances.

High granularity

Ensure high-integrity data collection with frequent collections, or customize collection frequency to meet your business requirements.

Tour

Databases
Tables
Statements
Databases

Databases

Get health, storage and performance-related database information

Specifications

  • PostgreSQL 9.1 and above
  • EnterpriseDB (EDB) Postgres 9.1 and above
  • Both on-premises and cloud deployments
  • Foglight Management Server (FMS) 5.7.5 or higher

Resources

Datasheet

Foglight for PostgreSQL

Proactively manage the health and performance of your PostgreSQL database infrastructure.
E-book

A Zombie's Survival Guide in a Changing Database World

With the rise of autonomous databases – and all the other scary changes in database management systems – you, as a DBA may be wondering...
Technical Brief

The Importance of Continuous Monitoring in a DevOps Pipeline

A common challenge in many IT teams is the “blame game” where developers blame DBAs for stability and performance issues and vice...
White Paper

DBAs Face New Challenges: Trends in Database Administration

To gain insight into the evolving challenges for DBAs, Quest commissioned DBTA to survey DBAs and those responsible for the management...
Technical Brief

Tools for the Evolving Database Administrator

Databases evolve fast and smart database administrators (DBAs) evolve even faster. As the landscape shifts from reliance on relational...
Infographic

New Trends and Challenges for DBAs

Research reveals how continued data growth, evolving responsibilities and cloud technology are affecting DBAs.
Case Study

Healthcare company monitors 3,000+ diverse databases with a single solution

Envision Healthcare staffs emergency rooms and clinical departments with doctors. Their Services extend to as many as 1,800 clinical...
White Paper

Key Methods for Managing Complex Database Environments

This white paper addresses key methods for successfully managing today’s complex cross-platform database infrastructures.

Support and services

Product Support

Self-service tools will help you to install, configure and troubleshoot your product.

Support Offerings

Find the right level of support to accommodate the unique needs of your organization.

Professional Services

Search from a wide range of available service offerings delivered onsite or remote to best suit your needs.

Education Services

Training courses delivered through online web-based, on-site or virtual instructor-led.