MonPG Labs

PostgreSQL Diagnostic Tools

A small set of incident-grade tools for teams who need evidence, rollout discipline, and a defensible next move. We keep this list intentionally short.

• pgvector HNSW Index Tuner (HNSW Tuning Lab) — Benchmark 48 HNSW configurations against your real pgvector data in 10 minutes. Get the optimal m, ef_construction, and ef_search plus zero-downtime migration SQL.
• PostgreSQL Plan Autopsy (Plan Autopsy) — Paste EXPLAIN ANALYZE output and get an incident-style read of the plan: planner estimate drift, loop explosions, disk spills, buffer pressure, and the evidence SQL to prove the fix.
• PostgreSQL Index Rollout Simulator (Index Rollout) — Model a proposed PostgreSQL index as a production rollout: DDL shape, lock level, WAL pressure, write amplification, replica lag risk, validation SQL, and rollback criteria.