PostgreSQL Advanced.

pgvector, partitioning, logical replication, query planner, lock contention. Covers 8 sub-skills.

• PostgreSQL Advanced · 1 of 3

  EXPLAIN ANALYZE, cost model, work_mem

  Which EXPLAIN option causes the statement to actually be executed rather than just planned?

  ABUFFERSBANALYZECSUMMARYDVERBOSE

• PostgreSQL Advanced · 2 of 3

  EXPLAIN ANALYZE, cost model, work_mem

  Comparing prepared-statement custom plans vs generic plans, which configuration knob controls the threshold and strategy for switching to a generic plan after several executions?

  Athe constraint_exclusion modeBthe cursor_tuple_fractionCthe from_collapse_limitDthe plan_cache_mode setting

• PostgreSQL Advanced · 3 of 3

  Range / list / hash partitioning

  What does the EXPLAIN node header print for the SELECT below?

  CREATE TABLE m (id int, d date) PARTITION BY RANGE (d);CREATE TABLE m_2025 PARTITION OF m  FOR VALUES FROM ('2025-01-01') TO ('2026-01-01');EXPLAIN SELECT * FROM m WHERE d = DATE '1970-01-01';

  AAppend (cost=0.00..0.00 rows=0 width=44)BGather (cost=0.00..0.00 rows=0 width=44)CSeq Scan on m (cost=0.00..0.00 rows=0 width=44)DResult (cost=0.00..0.00 rows=0 width=0)