PostgreSQL Indexes and Query Plans Cheat Sheet
Design PostgreSQL indexes, inspect query plans, read estimates and runtime metrics, maintain statistics, and deploy indexes safely on busy tables.
Open cheat sheetSQL · 6 guides
Performance and Planning
Understand indexes, plans, statistics, caching, partitioning, and parallel work.
Focused references
Performance and Planning cheat sheets
Each guide includes copy-ready syntax, detailed examples, and authoritative references.
PostgreSQL Parallel Query and JIT Cheat Sheet
Tune and verify PostgreSQL parallel plans and LLVM JIT with EXPLAIN, worker limits, cost thresholds, function safety, and workload-aware testing.
Open cheat sheetPostgreSQL Prepared Statements and Plan Caching Cheat Sheet
Prepare, inspect, tune, and safely retire PostgreSQL statements while diagnosing generic plans, custom plans, invalidation, poolers, and parameter skew.
Open cheat sheetPostgreSQL Statistics and Cardinality Estimation Cheat Sheet
Diagnose row-estimate errors with ANALYZE, pg_stats, statistics targets, extended statistics, EXPLAIN, and partition-aware maintenance.
Open cheat sheetPostgreSQL System Catalogs and Information Schema Cheat Sheet
Inspect PostgreSQL metadata safely with information_schema, pg_catalog, regclass casts, privilege helpers, dependency catalogs, and portable queries.
Open cheat sheetPostgreSQL Table Partitioning and Pruning Cheat Sheet
Design PostgreSQL range, list, and hash partitions; preserve constraints and indexes; verify partition pruning; and operate rolling partition sets safely.
Open cheat sheet