GresTrace
GresTrace parses PostgreSQL EXPLAIN (ANALYZE, BUFFERS, FORMAT JSON) output pasted in by the user and turns it into a readable, visual breakdown of the query plan, surfacing bottlenecks like unindexed filter scans, disk-bound buffer reads, and nested-loop row misestimates instead of burying them in text.
Results & Impact
The Challenge
PostgreSQL's EXPLAIN output is dense, text-only, and easy to misread. Problems like unindexed filter scans, disk-bound buffer reads, and nested-loop row misestimates stay buried in a wall of text instead of being visible at a glance.
The Solution
Built GresTrace to parse pasted EXPLAIN (ANALYZE, BUFFERS, FORMAT JSON) output and render it as a visual breakdown of the query plan, surfacing join costs, scan types, and buffer behaviour directly. Access is sold as a Stripe-powered one-time purchase.