Resources

PostgreSQL Problems, with the Query to Run and the Warning You Could Have Had

Each guide takes one problem that pages a PostgreSQL DBA: what the server says, the queries that show who or what caused it, the fixes in the order that does not make it worse, and how Radar Engine reports it before the outage. The SQL runs on PostgreSQL 16 or later with a role in pg_monitor.

Space

Load

Replication

Watch every instance for these

Scops runs 29 Radar detectors on every PostgreSQL instance and reports each of these problems while there is still time to act, with no agent on the server and one role in pg_monitor. See PostgreSQL monitoring with Scops.

Other engines