Reading EXPLAIN ANALYZE output can be tough.
Even if you know how, Postgres includes so much useful information, it is easy to miss something important. And for queries that do a lot, the plans are even more useful-yet-time-consuming.
pgMustard speeds up your journey from knowing which query is a problem to working out what can be done about it.
You’ll be able to see at a glance where the time is going, as well as jump straight to the important statistics. If you need a refresher on what something means, or want to read up on how it works, those are there for you too.
We have also put effort into minimizing red-herrings, helping you avoid distractions like a sequential scan on a small table, or a bad row estimate on a fast subplan.
In short, pgMustard makes it quick and easy to understand a query plan, while staying focused on your main aim: making the query faster.
Features wise, you’ll get
Performance advice – scored by estimated time-saving potential
Per-operation timings¹
The number of rows¹ returned by each operation
A timing bar – that pins to keep it in context
Collapsible subtrees – with fast ones collapsed by default
Descriptions of operations
Links to blog posts for further reading
¹ Taking loops, threads, subplans, and CTEs into account.
The screenshot below shows an example where a large amount of the work could potentially be avoided, and there’s a conspicuous bad row estimate to boot.