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.

How To Monitor PostgreSQL Like a Pro!

Ajay Patel · February 18, 2020

In this post, we dig into why it's essential to monitor Postgres, and how to do it effectively.

Tools for Monitoring Postgres Databases

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...

EnterpriseDB Updates Tools, and Enhances Security and Alerting

Marc Linster · April 19, 2018

Database administrators need tools for database maintenance, performance optimization, and configuration as well as creating a highly available...

What Happens if You Don’t Monitor Your PostgreSQL Database Effectively?

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...

Monitoring approach for Streaming Replication with Hot Standby in PostgreSQL 9.3.

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

Monitoring Postgres from the Command Line

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...

Monitor CPU and MEMORY percentage used by each process in PostgreSQL

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

Going after load spikes and performance lulls with Postgres Enterprise Manager

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.

Postgres Enterprise Manager Architecture

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.

Monitoring Amazon PostgreSQL RDS with PEM version 6.0

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...

Monitoring in PostgreSQL 9.6

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.

Extending PostgreSQL Monitoring in Postgres Enterprise Manager by Creating Custom Probes

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

Integrating Nagios with EDB 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...

Be the Master of All You Survey with Postgres Enterprise Manager 5.0

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...

Postgres Enterprise Manager; I love it when a plan comes together

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.

Featured Webinar

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.

About Postgres Pulse Live

Postgres Enterprise Manager

Postgres Performance Tuning, Monitoring and Alerting Tool

The only Postgres management tool to combine monitoring, alerting and tuning.

Download Now