Find your next open-source project

Search by name, purpose, or keyword — or paste a GitHub repository URL
All skills

postgres-pro

Diagnose slow PostgreSQL queries with EXPLAIN and deliver verified index and query fixes.

When to use it

You have a slow query or high dead-tuple table and need concrete EXPLAIN analysis, index design, or VACUUM tuning.

For example

You say

Use postgres-pro to fix this slow query: SELECT * FROM orders WHERE customer_id = 42 AND status = 'pending' takes 3 seconds on a 10M-row table.

You get
  • EXPLAIN ANALYZE interpretation
  • Partial index definition
  • Before/after verification

How it works

  • Recommends CREATE INDEX CONCURRENTLY to avoid locking production tables.
  • Covers JSONB GIN indexing, replication lag checks, and autovacuum tuning.