Demo
A walkthrough of one investigation, start to finish: a slow query, its execution plan, a candidate fix, a measured comparison, and a verified report.
The web app: paste a slow query, get a verified rewrite.
pqn from the terminal: semantic search, then a proven query fix.
What happens in the walkthrough
- Start with a problematic PostgreSQL query
- Inspect the execution plan and its findings
- Evaluate a candidate rewrite or index
- Compare the original and candidate plans, measured with EXPLAIN (ANALYZE)
- Verify the candidate returns the same rows
- Produce an investigation report citing the evidence
Each step is a real feature in the current codebase, not a planned one.