Postgres Monitoring & Query Performance

Monitoring is the eyes and the ears of the database world. It tells you when your Postgres databases are performing well, when they are performing properly and, more importantly, when they are not... and what you can do about it.

Postgres Enterprise Manager

Postgres Enterprise Manager is the best way to manage, monitor and optimize PostgreSQL and EDB Postgres Advanced Server.

pem performance diagnostic

Fully Managed Means Fully Monitored

Get the benefits of fully managed Postgres with EDB BigAnimal.

Feature Comparison

Database Administration

pgAdmin Postgres Enterprise Manager
 
Server connection manager
​​ ​​
 
Cluster objects management
​​ ​​
 
Database objects management
​​ ​​
 
Log manager
- ​​
 
Table editor
​​ ​​
 
Restore points
​​ ​​
 
Password management
​​ ​​
 
Grant wizard
​​ ​​
 
Data export/import
​​ ​​
 
Maintenance operations
​​ ​​
 
Storage manager
​​ ​​
 
Backup & restore
​​ ​​
 
Core usage reports
  ​​

Developer tools

pgAdmin Postgres Enterprise Manager
 
PL/pgSQL & EDB-SPL debugger
​​ ​​
 
Query editor
​​ ​​
 
Query history
​​ ​​
 
Data viewer and editor
​​ ​​
 
Geometry data viewer
​​ ​​
 
JSON data editor
​​ ​​
 
Schema diff
​​ ​​
 
Entity Relationship Diagrams (ERD)
​​ ​​
 
psql command-line interface
​​  

Job/Task scheduling

pgAdmin Postgres Enterprise Manager
 
pgAgent
​​ -
 
PEM agent
- ​​
 
   System jobs scheduling
​​ ​​
 
   User-defined tasks scheduling
​​ ​​
 
   Alert blackouts scheduling
- ​​

Monitoring

pgAdmin Postgres Enterprise Manager
 
Probes
- ​​
 
Dashboards
- ​​
 
Alerting
- ​​
 
Email groups
- ​​
 
SNMP traps
- ​​
 
Remote
- ​​

Performance

pgAdmin Postgres Enterprise Manager
 
Server performance expert
- ​​
 
Log analysis expert
- ​​
 
Tuning wizard
- ​​
 
Capacity management reports
- ​​
 
Performance diagnostic dashboard
- ​​
 
SQL profiler
- ​​
 
Index advisor
- ​​

Integration

pgAdmin Postgres Enterprise Manager
 
EDB Backup and Recovery Tool (BART) management and monitoring
- ​​
 
EDB Failover Manager (EFM) management and monitoring
- ​​
 
Alerts pushed to Nagios
- ​​
 
EDB Postgres Distributed multi-master replication monitoring
- ​​
 
Slony replication monitoring
- ​​
 
xDB replication clusters monitoring
- ​​
 
Third-party REST API
- ​​
 
Third-party Webhooks
- ​​

Security & Compliance

pgAdmin Postgres Enterprise Manager
 
Audit logging manager
- ​​
 
Kerberos authentication (GSSAPI)
​​ ​​
 
Active Directory Domain Services for Kerberos (SSPI)
​​ ​​
 
Two-Factor Authentication (2FA)
​​ ​​
 
Server security expert
- ​​
 
Voluntary Product Accessibility Template (VPAT)
- ​​

Configuration

pgAdmin Postgres Enterprise Manager
 
High Availability Setup
- ​​
 
Server configuration expert
- ​​
 
System configuration reports
- ​​

Have questions or ready to get started?

Sign up for an EDB account to access free trials, software, training and support. Signing up is free and takes less than 60 seconds.