# Extension-backed plan audits These fixtures create disposable PostgreSQL environments for plan evidence that stock PostgreSQL cannot produce: - PostgreSQL 18 with pgvector 0.8.6, including a populated HNSW index. - PostgreSQL 18 with Citus 14.1.0, one coordinator, and two workers. The images are pinned in `docker-compose.plan-audit.yml`. Database storage uses Docker `tmpfs`, so the audit cluster is isolated from the manuscript's ordinary development database and is rebuilt from deterministic SQL fixtures. Run the complete capture and regeneration workflow with: ```sh python3 scripts/run_extension_plan_audits.py ``` Pass `--keep-running` when you want to inspect the databases afterward. The pgvector database is exposed on port `55432`; the Citus coordinator is exposed on port `55433`. On Apple Silicon, the official Citus image runs through Docker's `linux/amd64` emulation. This can change wall-clock timing, but not the PostgreSQL/Citus plan shape being audited. Captured evidence records the server and extension versions.