EDB Postgres Enterprise Manager

Postgres Performance Tuning, Monitoring and Alerting Tool

Easily manage Postgres at scale across your organization.

The only Postgres management tool to combine monitoring, alerting and tuning of multiple open source PostgreSQL and/or EDB Postgres Advanced Server clusters, whether on-premise or in the cloud into a single GUI.

Manage Image

Manage Postgres at Scale

Enable every development/DevOps team with Postgres without increasing your administrative burden

Bull's eye Image

Gain Visibility

Monitor multiple database servers with intuitive dashboards, email, SNMP alerts, and rich APIs

Icon Meter Image

Increase Performance

Tune slow running queries, identify resource bottlenecks, and forecast future needs

Architecture

EDB Postgres Enterprise Manager collects performance and status data from databases, O/S, and jobs on the database host using agents. Data is stored and aggregated with key metrics displayed in at-a-glance dashboards. Alerts can be relayed via built-in or custom charts and dashboards, email, or SNMP notifications, and can be integrated with other monitoring tools. DBAs and developers can execute SQL, tune queries, run backups, replace the master, and deploy software updates.

 
Postgres Enterprise Manager Diagram
 

Features

 
Icon magnifying glass

Dashboards & APIs

More than a dozen dashboards offer views by time period with drill down down to monitored objects. Robust REST APIs to retrieve information, perform health checks or manage servers.

Icon alert

Alerts

Configure thresholds for over 200 alerts on load, bloat, memory utilization, agents/servers down, connections, etc. Create custom alerts by utilizing predefined or custom probes, set probe frequency and data retention.

Icon clock

GUI & Job Scheduler

Manage multiple servers with an easy to use GUI to create tables, manipulate schema, create stored procedures, run ad hoc queries, commit/rollback queries, and schedule jobs for routine tasks.

Icon guage

Performance Diagnostics

Users can visually identify why a query isn't executing such as waiting on locks, pinned buffers, I/O with the wait states monitor and resolve resource bottlenecks during production.

Icon wrench

Trace Slow Queries

Trace/track queries with SQL Profiler to visualize, analyze and troubleshoot results. When used with EDB Postgres Advanced Server, identify indexes to optimize performance.

Intuitive GUI

Postgres Enterprise Manager's easy to use GUI allows non-experts to be productive without knowing SQL. Making it straightforward to create tables, manipulate schema, create stored procedures, run ad hoc queries, commit/rollback queries, and schedule jobs for routine tasks.

Postgres Enterprise Manager Dashboard