AI engineering · interactive portfolio work

Postgres Query Plan Regression Lab

Compare EXPLAIN JSON plans against explicit thresholds. Inspect cost shifts, plan-node changes and newly introduced large sequential scans.

Browser-only demonstration
Plan comparison lab
Spot structural and budget regressions

Paste PostgreSQL EXPLAIN (FORMAT JSON) outputs. The starter pair reproduces the repository's index-scan → sequential-scan fixture.

Baseline plan JSON
Candidate plan JSON

Planner cost is not wall-clock time.

Threshold applied to Plan Rows.

Result
Ready

Run the comparison to see a report.

Estimated cost change—
Node shape—
New seq scan rows—
Gate—

This tool compares plan JSON; it never connects to PostgreSQL or executes SQL. Estimated cost depends on database statistics and settings. EXPLAIN ANALYZE executes the query.

Companion demo for the source repository. Starter plan JSON comes from the source repository; no database is queried.