Postgres Log Monitoring Guide

Using logs to resolve blocked queries and deadlocks in Postgres

Those of us who operate production PostgreSQL databases have many jobs to do - and often there isn’t enough time to take a regular look at the Postgres log files.

However, often times those logs contain critical details on how new application code is affecting the database due to locking issues, or how certain configuration parameters cause the database to produce I/O spikes.

This post highlights three common performance problems you can find by looking at, and automatically filtering your Postgres logs.