Hello all, hope you're keeping safe out there.
We're pleased to announce version 3 of pgMustard – a tool that gives
you performance advice from query plans.
Major improvements:
* Tip scoring – Each tip is now rated from 0-5, making it quicker and
easier to determine the relative importance of issues.
* Tip improvements – New tips for planning time and slow count
operations. Improvements to most of our other tips too, meaning they
are more likely to be relevant and to give better advice.
* Better subplan analysis – Improved some tricky cases around
calculations between call sites and added more information to help.
Thank you to Felix G (https://twitter.com/felixge) for working with us
on this!
* Interface improvements – Major changes to our tree and reading pane
to make problem-solving easier, not least for large query plans (with
many operations or lots of nesting).
Requirements:
* JSON format query plans
* PostgreSQL 9.6 and newer
* Interface and advice are in English
* A GitHub or Google account, for authentication on our hosted version
(no installation or database access required)
* Self-hosted option available, via Docker
pgMustard is commercial software and has a free trial:
https://www.pgmustard.com/
If you have any slow queries to speed up, we’d love to hear how you get on.
Cheers,
Michael and David