Data Monitoring
A PostgreSQL application slows while the database remains reachable. Inspect pg_stat_activity with state, wait event, query start and application identity.
PostgreSQL Monitoring2 min read
Read article : PostgreSQL: Active session triage
Data Monitoring
An apparently idle connection keeps a transaction open for a long time. Compare xact_start, state and application ownership with blocking and cleanup symptoms.
PostgreSQL Monitoring2 min read
Read article : PostgreSQL: Idle-in-transaction sessions
Data Monitoring
Many PostgreSQL sessions wait on locks during a deployment. Use pg_blocking_pids with activity evidence and capture the head transaction's context.
PostgreSQL Monitoring2 min read
Read article : PostgreSQL: Blocking session relationships
Data Monitoring
A query performance dashboard is empty on a new PostgreSQL host. Check whether pg_stat_statements is installed and configured for the intended collection scope.
PostgreSQL Monitoring2 min read
Read article : PostgreSQL: Statement statistics coverage
Data Monitoring
Per-query rates spike after statistics are reset. Record the statistics reset time and compare consecutive counters only within a continuous series.
PostgreSQL Monitoring1 min read
Read article : PostgreSQL: Statement counter reset boundaries
Data Monitoring
Rollback counts rise but user-visible errors remain unclear. Compare commits and rollbacks with application error categories and transaction volume.
PostgreSQL Monitoring1 min read
Read article : PostgreSQL: Transaction rollback rates
Data Monitoring
Dead tuples increase while updates continue. Compare table statistics, autovacuum history and long-running transactions that may delay cleanup.
PostgreSQL Monitoring1 min read
Read article : PostgreSQL: Autovacuum backlog
Data Monitoring
A quiet database approaches an urgent transaction age limit. Compare transaction ID age for databases and tables with configured maintenance behavior.
PostgreSQL Monitoring2 min read
Read article : PostgreSQL: Transaction ID wraparound headroom
Data Monitoring
A standby is connected but returns stale query results. Compare the replication positions and replay timing with a known business transaction.
PostgreSQL Monitoring1 min read
Read article : PostgreSQL: Replication write flush and replay
Data Monitoring
Disk usage grows because a replication consumer stops progressing. Inspect slot activity, retained WAL distance and consumer recovery needs.
PostgreSQL Monitoring2 min read
Read article : PostgreSQL: Replication slot WAL retention
Data Monitoring
Write-ahead log volume spikes during a maintenance batch. Compare WAL rate, batch changes and replication or archival throughput.
PostgreSQL Monitoring1 min read
Read article : PostgreSQL: WAL generation bursts
Data Monitoring
Periodic latency spikes line up with checkpoint activity. Correlate checkpoint statistics and logs with write latency for the same interval.
PostgreSQL Monitoring1 min read
Read article : PostgreSQL: Checkpoint I/O patterns