Postgres EXPLAIN Reviewer

What you get

Upload a JSON or text EXPLAIN plan plus the original SQL. Receive:

• measured, partial, or insufficient evidence verdict
• ranked scan, join, filter, sort, spill, and I/O bottlenecks
• cardinality-estimate gap table
• up to three index SQL candidates with selectivity, overlap, storage, and write trade-offs
• semantics-preserving query rewrite candidates
• statistics and configuration checks
• before-versus-after benchmark plan
• production-safe index rollout and rollback checklist
• paste-ready engineering review comment

Best input

• EXPLAIN (ANALYZE, BUFFERS, FORMAT JSON) output
• original SQL
• table and existing-index definitions
• Postgres version, query frequency, and latency target

Example output preview

• HIGH: external sort wrote temporary blocks.
• HIGH: estimate was 42x below actual rows at the join input.
• Candidate: (account_id, created_at DESC) only if account selectivity and query frequency justify the write cost.
• Validate with representative parameter ranges before production rollout.

Delivery and boundaries

Important: EXPLAIN ANALYZE executes the statement. Do not use it for mutating SQL or an unsafe production query. This Download profiles supplied files locally. It never connects to a database or executes SQL.

Part of the Postgres Release-Safety Family

• Free Postgres Migration Risk Checker - GREEN/AMBER/RED preflight before merge
• Postgres Migration Review: Locks + Rollback Plan - full PASS/REVISE/BLOCK release artifact
• Postgres Lock Triage - incident-time blocker chains and safe action plan