PostgreSQL Performance Monitoring and Alerting
An essential task of a DBA is to monitor PostgreSQL for faults. The primary reason to monitor PostgreSQL are availability, system optimization, identify performance problems, business process improvement, and capacity planning. There are many tools available to help monitor PostgreSQL at scale. While some of these tools are free, most are paid and more suitable for enterprise deployment environments. To monitor PostgreSQL effectively, DBA's and system administrators use tools to create custom alerts and notifications that can provide live and proactive alerts for faults. In this archive, once can find tips, tricks, and tutorials to monitor PostgreSQL.
Ajay Patel · February 18, 2020
In this post, we dig into why it's essential to monitor Postgres, and how to do it effectively.
Bhavani Rao · September 24, 2019
Users depend on databases to carry out meaningful work. Whether it’s connected to a mission-critical application or helping a single user carry out a...
Marc Linster · April 19, 2018
Database administrators need tools for database maintenance, performance optimization, and configuration as well as creating a highly available...
Ajay Patel · February 6, 2018
A good DBA is someone who knows how to monitor the databases EFFECTIVELY and when it comes to a production or business critical database, the job...
Vibhor Kumar · May 21, 2014
The people using PostgreSQL and the Streaming Replication feature seem to ask many of the same questions. In light of these commonly asked questions, I thought a blog would help. The following are some methods I’ve found to be useful
Bruce Momjian · August 6, 2012
You might already be aware that Postgres updates the process title of all its running processes. For example, this is a Debian Linux ps display for an...
Vibhor Kumar · July 23, 2012
PostgreSQL has pg_stat_activity view which can be use to get the session details. This view gives following information
EDB Team · December 2, 2011
Bruce Momjian recently did a blog on Postgres Monitoring tools. I want to point out a unique and useful feature of Postgres Enterprise Manager from...
EnterpriseDB integrates Backup and Recovery tools with Postgres Enterprise Manager for superior database management
Vishal Sawale · February 4, 2020
This post discusses the EDB Backup and Recovery Tool integration into EDB Postgres Enterprise Manager.
Dave Page · November 19, 2019
Postgres Enterprise Manager or PEM is a comprehensive monitoring and management solution for PostgreSQL and EDB Postgres Advanced Server (EPAS) from EnterpriseDB. It is a distributed application with a number of components that can be installed in many different configurations. The following sections explain what those components are, what their purpose is, and how they work.
Vibhor Kumar · February 10, 2017
The EDB Postgres™ Enterprise Manager is an enterprise management tool designed to tune, manage, and monitor a large number of Postgres deployments on...
Thom Brown · April 26, 2016
This is part 2 in a 4 part blog series on improvements coming in PostgreSQL 9.6. Part 1 - Horizontal Scalability Join Pushdown Sort Pushdown "Walk and...
How to replace Postgres Enterprise Manager self-signed certificates with certificates provided by Certificate Authority (CA)
Shubham Agarwal · May 5, 2020
This article provides instructions for how to replace self-signed certificates for Postgres Enterprise Manager with authorized certificates issued by Certificate Authority.
Nidhi Bhammar · April 24, 2020
This article defines a probe and provides instructions for creating custom probes for PostgreSQL using EDB Postgres Enterprise Manager (PEM).
How to Replacing httpd self signed SSL certificates with trusted CA signed certificates in Postgres Enterprise Manager
Ankit Shukla · July 22, 2019
In this blog post we will go trough the steps to replace httpd self signed SSL certificates with trusted CA signed cerficates in Postgres Enterprise Manager
Dave Page · November 16, 2016
A cornerstone of the Management Suite in the EDB Postgres Platform is EDB Postgres Enterprise Manager (PEM). The suite provides key management...
Gary Carter · March 2, 2015
With the most recent release of Postgres Plus Advanced Server 9.4, EnterpriseDB (EDB) has also upgraded our database enterprise management console...
Dave Page · August 23, 2011
After 9 months of heads-down work, I'm glad to finally be able to talk about the project I and a number of colleagues here at EnterpriseDB have been...
Get Postgres tips & tricks
Subscribe to our newsletter to get advanced Postgres how-tos.
- Developer Resources
- High Availability
- Replication and Failover
- Performance Tuning
- Performance Monitoring and Alerting
- Containers, Kubernetes, Docker
- Oracle To Postgres Migration
- DBA and Admin Resources
- Tools and Extensions
How to Monitor Postgres Like a Pro!
Monitoring is a critical element for the overall performance of the database. Learn how to ensure your database is healthy and contributing to the long term stability of your database and application.Watch Now
Introducing Postgres Pulse Live
Free To Attend: Every other Monday 11AM ET
A biweekly blog and live video forum series built to offer insight into how we analyze problems and develop solutions using Postgres.
Postgres Enterprise Manager
Postgres Performance Tuning, Monitoring and Alerting Tool
The only Postgres management tool to combine monitoring, alerting and tuning.Download Now