Optimise your Postgres queries
pgMustard helps you and your team diagnose and fix performance issues.
Understand current performance
Postgres query plans contain a lot of useful information, but aren’t always easy to decipher.
The tree and table views work in unison to help you understand what’s happening right now, and code snippets help you tie operations back to your original query.
Skip straight to the important bits
Immediately see which operations are running slowly, so you know where best to direct your time and effort.
See high-level summaries of memory and timing statistics, rather than having to wade through every number.
Tips to improve
Advice to speed up your query - whether it be adding an index, improving internal statistics or tinkering with config parameters.
Links to in-depth articles on performance topics to help you understand any problems and how to fix them.
Been a while since you did any database work? Forgotten the difference between a bitmap index scan and an index-only scan?
pgMustard includes explanations of operation types and key concepts to refresh your memory.