PostgreSQL Wraparound Age % Alert


Use the Wraparound Age % alert in Mini DBA to monitor PostgreSQL instances and make this condition visible before it becomes a wider database incident.

Screenshot pending: Mini DBA PostgreSQL Wraparound Age % alert screenshot placeholder

Alert Summary

  • Platform: PostgreSQL
  • Alert category: Availability
  • Default enabled: true
  • Default evaluation frequency: Minute
  • Threshold label: % of freeze max age
  • Unit: %

What Mini DBA Checks

Mini DBA describes this alert as: Transaction ID or multixact age is approaching the configured freeze maximum. Severe wraparound risk can force emergency vacuuming or database shutdown behavior. The default evaluation frequency is Minute, so the alert is intended to be close enough to operational reality for live triage.

Why This Alert Is Helpful

This alert gives Mini DBA a focused signal for a condition that can affect PostgreSQL reliability, performance, or operational visibility. It helps the team move from a general problem report to a specific metric, threshold, and investigation path.

When To Enable It

Enable it on any monitored PostgreSQL instance where this condition would require an administrator to investigate or communicate with the application team. Tune noisy development systems after you have a short baseline.

Threshold Guidance

Threshold meaning: % of freeze max age. Major threshold: 90 %. Minor threshold: 75 %. Comparison direction: "over". Use higher thresholds on batch-heavy, development, or intentionally bursty systems where brief pressure is expected. Use lower thresholds on latency-sensitive production systems, small instances with little headroom, and services with strict recovery or availability commitments.

Remediation For An Active Alert

Open the related Mini DBA page for the instance, compare the current value with the recent baseline, identify whether the change is caused by workload, configuration, host capacity, or maintenance, then record the corrective action in the incident notes.

Investigation Workflow

  1. Confirm the alert is still active and note the first seen time, affected instance, and severity.
  2. Review the current metric, the recent trend, and the affected database, login, host, or application in Mini DBA before changing configuration or ending sessions.
  3. Compare the current value with the normal baseline for the same time of day or maintenance window.
  4. Record the cause, corrective action, and whether thresholds or routing should be adjusted after the incident.

Avoiding Alert Noise

If the alert creates repeated noise, review whether it is enabled on the correct instances, whether maintenance windows are configured, and whether the minor and major routes match the real business impact. Keep enough history to prove the new setting before changing it broadly.

Related Pages