Database Observability: Dashboards

Fleet Overview

PostgreSQL fleet status and load on a single dashboard.

Instance State

Availability, transactions, connections, cache, and input/output for a PostgreSQL instance.

Queries

PostgreSQL query cost, regressions, errors, and execution plans.

Locks and Transactions

Lock waits, long-running transactions, and PostgreSQL deadlocks.

Replication and HA

PostgreSQL replication, slots, Patroni, and PgBouncer queues.

Capacity and Growth

Growth of databases, tables, and indexes, WAL volume, and the risk of XID exhaustion.

Access Audit

PostgreSQL user actions and object coverage by pgaudit.

Collection Diagnostics

Data collection completeness, delays, and errors in Database Observability.