postgres-operations

name	postgres-operations
type	skill
description	PostgreSQL operational runbooks — health checks, vacuum, bloat, locks, PITR, connection pool management.
related-rules	["backup-policy.md","access-control.md","migration-runbook.md"]
allowed-tools	Read, Bash

Skill: PostgreSQL Operations

Expertise: PostgreSQL health, vacuuming, lock analysis, PITR, WAL archiving, PgBouncer, K8s-hosted PostgreSQL.

When to load

When investigating a slow database, diagnosing lock waits, running PITR recovery, or managing a PostgreSQL instance.

Health Check Commands

-- Database size overview
SELECT
  datname,
  pg_size_pretty(pg_database_size(datname)) AS size,
  numbackends AS active_connections
FROM pg_stat_database
ORDER BY pg_database_size(datname) DESC;

-- Table sizes (top 20)

  schemaname    tablename  ,
  pg_size_pretty(pg_total_relation_size(schemaname    tablename))  total_size,
  pg_size_pretty(pg_relation_size(schemaname    tablename))  table_size,
  pg_size_pretty(pg_indexes_size(schemaname    tablename))  index_size
 pg_tables
  pg_total_relation_size(schemaname    tablename) 
LIMIT ;



  client_addr,
  state,
  pg_size_pretty(pg_wal_lsn_diff(sent_lsn, replay_lsn))  replication_lag
 pg_stat_replication;