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: Spanish
Last updated: 2026-07-28
Level: Intermediate

USD 13

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: To be defined
Tools: To be defined
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

Version history

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