Helps you review Postgres query plans quickly

A simple yet powerful tool to help you speed up queries

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.