Developer Tools

Querycairn: Explain Plans

Read PostgreSQL Plan JSON

iOSfor iPhone and iPad

  • $0.99 one-time purchase
  • No account
  • No ads or app telemetry

View on the App Store

About Querycairn: Explain Plans

Querycairn is a private query-plan interpretation bench for developers, database administrators, consultants, and technical teams who need a focused second screen without pasting schema or plans into a website.

Surface the nodes where row-estimate error and loop amplification make a seemingly small plan expensive.

KEY FEATURES
- PostgreSQL EXPLAIN JSON import
- Recursive plan-node inventory
- Estimated-versus-actual row view
- Loop and predicate risk scoring
- Node owner and hypothesis notes
- Statistics and index checklist
- Plan findings export
- Database credentials never requested
- Native structured-file or CSV import
- Local PDF, workspace JSON, and domain-artifact export
- 48 original offline technical reference plates
- No account, ads, analytics, tracking, IAP, or subscription

Querycairn interprets recorded PostgreSQL plan fields and entered context; it does not connect to a database, execute SQL, recommend an index automatically, or prove a change is safe. EXPLAIN ANALYZE executes the statement. Use controlled data, representative parameters, and expert review.

A Shadowfetch app. Published on the App Store by Robert Corbin.