Production query plans without production data

2026-03-10

PostgreSQL 18 introduces new functions and `pg_dump --statistics-only` to export and inject production optimizer statistics into non-production databases, enabling accurate reproduction and testing of production query plans without needing the actual data.