Blogs
Test a PostgreSQL Index Before You Build It with HypoPG
Compare PostgreSQL index candidates with HypoPG, then measure the real index. A reproducible 500,000-row lab shows what the estimates can tell you.
From EXPLAIN to a Verified Rewrite: Introducing PgQueryNarrative
A DATE_TRUNC predicate that forces a 49-partition scan, the sargable rewrite PgQueryNarrative proposes from the query's own parse tree, and how the tool checks the rewrite returns the same rows before calling it safe.
Introducing PgQueryNarrative
A PostgreSQL query investigation tool that proposes bounded changes and requires measurement before calling anything improved.