PostgreSQL Aggregates and Grouping Cheat Sheet
Summarize PostgreSQL data with count, sum, averages, filtered and ordered aggregates, HAVING, GROUPING SETS, ROLLUP, CUBE, and grouping indicators.
Open cheat sheet6 organized subcategories
SQL
Queries, joins, aggregation, filtering, and data updates.
Choose a focus
SQL subcategories
48 focused guides grouped by the kind of task you need to complete.
9 guides
Querying and Joins
Retrieve, combine, aggregate, and navigate relational data.
Browse subcategory 9 guidesModeling and Data Types
Design tables, constraints, identifiers, and PostgreSQL data representations.
Browse subcategory 5 guidesData Change and Programmability
Modify, import, transform, automate, and expose database data.
Browse subcategory 6 guidesPerformance and Planning
Understand indexes, plans, statistics, caching, partitioning, and parallel work.
Browse subcategory 7 guidesTransactions and Security
Coordinate concurrent work and protect database objects and data.
Browse subcategory 12 guidesOperations, Replication, and Storage
Configure, monitor, back up, replicate, and maintain PostgreSQL systems.
Browse subcategory9 cheat sheets
Querying and Joins
Retrieve, combine, aggregate, and navigate relational data.
PostgreSQL CTEs and Subqueries Cheat Sheet
Structure PostgreSQL queries with scalar, table, correlated, EXISTS, LATERAL, common table, recursive, and data-modifying expressions.
Open cheat sheetPostgreSQL Cursors and Batched Fetching Cheat Sheet
Stream PostgreSQL query results safely with cursors, bounded FETCH batches, holdability, row locking, refcursor APIs, and resumable alternatives.
Open cheat sheetPostgreSQL LATERAL Joins and Set-Returning Functions Cheat Sheet
Write PostgreSQL LATERAL and set-returning-function queries for top-N lookups, JSON, arrays, time series, optional expansion, and efficient plans.
Open cheat sheetPostgreSQL NULLs and Conditional Expressions Cheat Sheet
Handle PostgreSQL unknown values with IS NULL, three-valued logic, COALESCE, NULLIF, CASE, comparison predicates, and null-aware ordering.
Open cheat sheetPostgreSQL Recursive Queries and Graph Traversal Cheat Sheet
Build safe PostgreSQL recursive CTEs for hierarchies and graphs with anchors, termination, paths, SEARCH ordering, CYCLE detection, and bounded execution.
Open cheat sheetPostgreSQL Window Functions Cheat Sheet
Analyze PostgreSQL rows with ranking, offsets, partitioned aggregates, explicit frames, named windows, and post-window filtering.
Open cheat sheetSQL Joins Cheat Sheet
Combine related PostgreSQL tables with inner, outer, cross, self, multi-table, aggregate, and lateral joins using clear predicates.
Open cheat sheetSQL SELECT Queries Cheat Sheet
Query, filter, sort, group, join, and compose relational data with practical SQL SELECT examples.
Open cheat sheet9 cheat sheets
Modeling and Data Types
Design tables, constraints, identifiers, and PostgreSQL data representations.
PostgreSQL Arrays, Ranges, and Multiranges Cheat Sheet
Query PostgreSQL arrays, ranges, and multiranges with correct bounds, containment, expansion, exclusion constraints, and GIN or GiST indexing.
Open cheat sheetPostgreSQL Binary Data: bytea and Large Objects Cheat Sheet
Store PostgreSQL binary data safely with bytea, encoding functions, TOAST, large objects, privileges, cleanup, backup, and replication planning.
Open cheat sheetPostgreSQL Collations and Locale Cheat Sheet
Design PostgreSQL text ordering and comparison with ICU, builtin, and libc collations, safe indexes, version audits, and Unicode-aware rules.
Open cheat sheetPostgreSQL Custom Types, Domains, Enums, and Composites Cheat Sheet
Design and evolve PostgreSQL domains, enums, and composite types with safe constraints, explicit casts, privileges, migrations, and replication-aware rollouts.
Open cheat sheetPostgreSQL Dates, Times, and Intervals Cheat Sheet
Store, convert, compare, bucket, format, and calculate PostgreSQL dates, timestamps, time zones, and intervals without ambiguous temporal logic.
Open cheat sheetPostgreSQL Identity, Generated Columns, and Sequences Cheat Sheet
Design PostgreSQL identity keys, generated columns, and sequences with safe overrides, correct privileges, migration repairs, and concurrency-aware semantics.
Open cheat sheetPostgreSQL JSON and JSONB Cheat Sheet
Store, query, construct, update, index, expand, and validate PostgreSQL JSONB documents while keeping relational constraints where they belong.
Open cheat sheetPostgreSQL Table Constraints Cheat Sheet
Design reliable PostgreSQL tables with identity columns, defaults, checks, keys, foreign keys, referential actions, and safe constraint changes.
Open cheat sheetPostgreSQL Temporary and Unlogged Tables Cheat Sheet
Use PostgreSQL temporary and unlogged tables safely with explicit lifetimes, statistics, privileges, WAL tradeoffs, backups, locks, and replication limits.
Open cheat sheet5 cheat sheets
Data Change and Programmability
Modify, import, transform, automate, and expose database data.
PostgreSQL COPY Import and Export Cheat Sheet
Import and export PostgreSQL data safely with COPY and psql \copy, strict CSV contracts, staging tables, bounded reject handling, query exports, privileges, and progress monitoring.
Open cheat sheetPostgreSQL Functions, Procedures, and Triggers Cheat Sheet
Create safe PostgreSQL SQL and PL/pgSQL functions, procedures, trigger functions, exception blocks, security-definer routines, volatility declarations, and tests.
Open cheat sheetPostgreSQL Pattern Matching and Full-Text Search Cheat Sheet
Search PostgreSQL text with LIKE, POSIX regular expressions, normalized tsvector documents, safe tsquery constructors, ranking, headlines, and GIN indexes.
Open cheat sheetPostgreSQL Views and Materialized Views Cheat Sheet
Create, secure, update, refresh, index, inspect, replace, and remove PostgreSQL views and materialized views with clear freshness contracts.
Open cheat sheetSQL Data Modification Cheat Sheet
Insert, update, delete, upsert, return, and safely group SQL data changes with PostgreSQL transactions.
Open cheat sheet6 cheat sheets
Performance and Planning
Understand indexes, plans, statistics, caching, partitioning, and parallel work.
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 sheetPostgreSQL 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 sheet7 cheat sheets
Transactions and Security
Coordinate concurrent work and protect database objects and data.
PostgreSQL Advisory Locks Cheat Sheet
Coordinate application-defined work with PostgreSQL transaction and session advisory locks, try-locks, shared modes, timeouts, ordering, and monitoring.
Open cheat sheetPostgreSQL Deadlocks, Timeouts, and Cancellation Cheat Sheet
Prevent and diagnose PostgreSQL blocking with consistent lock order, bounded transactions, timeout scopes, wait graphs, cancellation, and safe retries.
Open cheat sheetPostgreSQL Extensions and Extension Security Cheat Sheet
Install, audit, update, package, and replicate PostgreSQL extensions with pinned versions, secure schemas, trusted-script controls, and rehearsed rollback plans.
Open cheat sheetPostgreSQL pgcrypto and Data Encryption Cheat Sheet
Use pgcrypto responsibly for hashing, HMAC, password verification, PGP encryption, random data, privileges, key handling, and FIPS-aware deployments.
Open cheat sheetPostgreSQL Row-Level Security Cheat Sheet
Design and audit PostgreSQL row-level security with command-specific policies, USING and WITH CHECK, permissive and restrictive rules, FORCE RLS, and tenant-safe testing.
Open cheat sheetPostgreSQL Schemas, Roles, and Privileges Cheat Sheet
Organize and secure PostgreSQL objects with schemas, search_path, login and group roles, ownership, GRANT, REVOKE, default privileges, and privilege inspection.
Open cheat sheetPostgreSQL Transactions and Locking Cheat Sheet
Control PostgreSQL units of work with BEGIN, COMMIT, ROLLBACK, savepoints, isolation levels, read-only mode, row locks, NOWAIT, SKIP LOCKED, and retries.
Open cheat sheet12 cheat sheets
Operations, Replication, and Storage
Configure, monitor, back up, replicate, and maintain PostgreSQL systems.
PostgreSQL Backup, Restore, and Point-in-Time Recovery Cheat Sheet
Plan and verify PostgreSQL logical dumps, custom archives, parallel restore, role and database globals, physical base backups, WAL archiving, and point-in-time recovery.
Open cheat sheetPostgreSQL Connection Authentication and pg_hba.conf Cheat Sheet
Design, audit, and roll out PostgreSQL 18 client authentication with ordered pg_hba.conf rules, SCRAM, TLS, certificates, GSSAPI, LDAP, and safe secret handling.
Open cheat sheetPostgreSQL Database Configuration and Session Settings Cheat Sheet
Operate PostgreSQL settings safely across cluster, database, role, session, and transaction scopes with validation, privileges, and rollback plans.
Open cheat sheetPostgreSQL LISTEN, NOTIFY, and Event Messaging Cheat Sheet
Build reliable PostgreSQL event signals with LISTEN, NOTIFY, transactional outboxes, queue monitoring, secure payloads, and reconnect recovery.
Open cheat sheetPostgreSQL Logical Replication Cheat Sheet
Operate PostgreSQL logical publications and subscriptions with safe initial copies, replica identity, filtering, security, monitoring, and failover planning.
Open cheat sheetPostgreSQL Monitoring: Sessions, Waits, and Progress Cheat Sheet
Monitor PostgreSQL sessions, blockers, long transactions, query statistics, I/O, replication, and maintenance progress with production-safe diagnostics.
Open cheat sheetPostgreSQL postgres_fdw and Foreign Tables Cheat Sheet
Configure postgres_fdw securely, import foreign schemas, verify remote pushdown, tune transfers, write safely, and diagnose remote PostgreSQL access.
Open cheat sheetPostgreSQL psql CLI and Meta-Commands Cheat Sheet
Operate PostgreSQL safely with psql connection options, output controls, variables, scripts, transactions, introspection, and automation patterns.
Open cheat sheetPostgreSQL Streaming Replication and Failover Cheat Sheet
Operate PostgreSQL physical streaming standbys with base backups, WAL retention, replication slots, lag monitoring, synchronous durability, and safe failover.
Open cheat sheetPostgreSQL Tablespaces, Storage, and Fillfactor Cheat Sheet
Place and tune PostgreSQL relations with tablespaces, fillfactor, TOAST settings, per-table autovacuum controls, safe moves, and storage observability.
Open cheat sheetPostgreSQL VACUUM, Autovacuum, and Bloat Cheat Sheet
Operate PostgreSQL VACUUM and autovacuum safely, inspect dead tuples, protect transaction ID age, diagnose cleanup blockers, and limit table bloat.
Open cheat sheetPostgreSQL WAL, Checkpoints, and Durability Cheat Sheet
Operate PostgreSQL WAL and checkpoints safely with durability settings, replication awareness, capacity monitoring, and crash-recovery tradeoffs.
Open cheat sheet