Basic Administration Manual: Blocking, Performance, and Basic Configuration in PostgreSQL

Ready-to-run scripts to review active blocking, identify slow queries, and validate basic memory and autovacuum configuration.

PostgreSQL 13+

Language: English
Last updated: 2026-08-08
Level: Intermediate

USD 10 Buy now

100% digital delivery. The manual and files are sent by email after payment is confirmed.

Summary

Problem it solves

Have a set of proven scripts on hand for the daily check of blocking, performance, and configuration in PostgreSQL, without having to rebuild them every time.

Who it is for

DBAs or system administrators who operate PostgreSQL in production and need a repeatable technical checklist.

Who it is not for

Anyone looking for an advanced tuning guide for a specific architecture (see the PostgreSQL migration and high-availability guides in the catalog).

What's included

Reviewing blocking: pg_locks and pg_stat_activity
Identifying the blocking vs. blocked session
Safely terminating sessions (pg_cancel_backend / pg_terminate_backend)
Reviewing performance: pg_stat_statements and the most costly queries
Index usage per table and detecting avoidable sequential scans
Bloat and the need for VACUUM
Basic configuration: shared_buffers, work_mem, maintenance_work_mem
Autovacuum and checkpoints
Connections and pooling with PgBouncer
Consolidated daily health-check script

Technical information

Engines: PostgreSQL 13+
Operating systems: Cualquiera con cliente de PostgreSQL (Linux, Windows, macOS) — los scripts se ejecutan contra la instancia, no dependen del sistema operativo anfitrión
Tools: psql, pgAdmin (opcional)
Level: Intermediate
Estimated duration: 30-45 minutos
Prerequisites: A role with pg_monitor or superuser for the diagnostic views, Access to postgresql.conf or ALTER SYSTEM for configuration changes

Included files

PDF manual with the diagnostic scripts included in the text

Lab evidence

Lab evidence: in preparation

This guide has no public evidence yet. Once published, it will include anonymized screenshots of the real execution, with no hostnames, private IPs, usernames or client data.

Licenses

Choose your license Individual — USD 10 — One buyer. Personal or professional use by a single person.

International secure payment processed by Lemon Squeezy. ConsultorDBA does not store card data. The final charge, exchange rate and applicable taxes are shown at the secure checkout.

Version history

1.0 — 2026-07-28: First published edition.