plain-postgres-doctor

You can diagnose slow queries and optimize indexes by running operational health checks that identify vacuum health and index performance issues. The tool analyzes your database to pinpoint problems before they impact users.

Schema correctness checks validate that your actual database matches your models. By running schema validation, you can detect schema drift and ensure your database structure aligns with your application expectations.

Yes, Postgres health checks are applicable to both development and production environments. They validate migrations and diagnose operational health without applying mutations unless you explicitly approve them.

The recommended workflow involves running schema and operational health checks against your target database. This validates schema correctness and diagnoses performance issues, helping teams verify changes before deployment.

No, the tool never applies mutations without explicit user approval. It diagnoses health by validating schema correctness and identifying operational issues, leaving remediation decisions entirely to you.

Schema drift occurs when your actual database diverges from your models. Running schema checks validates correctness by comparing the live database structure against expected models to detect discrepancies.