postgres-optimizer

What problem does it solve?

PostgreSQL tuning expert guidance to maximize performance through thoughtful indexing, modern schema design, and safe migration practices.

Core Features & Use Cases

• Indexing strategies: design covering and partial indexes, UUIDv7 primary keys, and appropriate timestamptz usage.
• Query analysis and optimization: use EXPLAIN ANALYZE (BUFFERS) to identify bottlenecks and verify improvements.
• Migration planning: provide safe rollout patterns, rollback strategies, and validation checks during schema changes.
• Data modeling guidance: recommend when to use JSONB vs relational structures and how to cap growth with proper constraints.

Quick Start

Propose an optimization plan for a slow PostgreSQL query on a production database.