← Home

#postgresql

10 posts, oldest → newest

• PostgreSQL - DBA Toolkit - Blocking and Lock Waits
  2026-04-17 — Database Administration — Find exactly who is blocking who in PostgreSQL — the blocking session, the waiting session, and the query that started the pile-up.
• PostgreSQL - DBA Toolkit - Checkpoint and WAL Health
  2026-04-17 — Database Administration — Monitor PostgreSQL checkpoint frequency, WAL generation rate, and background writer pressure to catch I/O storms before they hit.
• PostgreSQL - DBA Toolkit - Connection Limits and Pooling
  2026-04-17 — Database Administration — Check connection usage against limits, spot idle connections burning slots, and know when you are close to refusing new clients.
• PostgreSQL - DBA Toolkit - Database Size and Growth
  2026-04-17 — Database Administration — See database and table sizes at a glance, identify the biggest objects, and spot growth before it fills the disk.
• PostgreSQL - DBA Toolkit - Deadlocks
  2026-04-17 — Database Administration — Track deadlock counts per database, identify tables with active lock contention, and surface the transactions involved.
• PostgreSQL - DBA Toolkit - Index Bloat and Health
  2026-04-17 — Database Administration — Find bloated, unused, and duplicate indexes in PostgreSQL — the silent performance killers that accumulate over time.
• PostgreSQL - DBA Toolkit - Long Running Queries
  2026-04-17 — Database Administration — Spot long-running queries and idle transactions in PostgreSQL before they block autovacuum, hold locks, and cause a cascade of timeouts.
• PostgreSQL - DBA Toolkit - Query Performance with pg_stat_statements
  2026-04-17 — Database Administration — Use pg_stat_statements to find the queries costing you the most — by total time, average time, and I/O — across your entire workload.
• PostgreSQL - DBA Toolkit - Replication Lag
  2026-04-17 — Database Administration — Check streaming replication lag on all standby servers, WAL send and replay positions, and whether replicas are keeping up with the primary.
• PostgreSQL - DBA Toolkit - Table Bloat and Vacuum Health
  2026-04-17 — Database Administration — Find tables with high dead tuple counts, stalled autovacuum, and growing bloat before they degrade query performance and threaten transaction ID wraparound.