I’m delighted to announce version 5 of pgMustard, a tool for helping review Postgres query plans.
Major improvements:
- New tip types: suboptimal JIT compilation, excessive trigger time, and scope for more parallelism.
- Workflow improvements: TEXT format support, add plans as optimizations of one another, and share plans privately within a team.
- New API endpoints: one for saving query plans, and another for returning scored tips.
- Postgres 17 support: SERIALIZE and MEMORY parameters, improved InitPlan and SubPlan reporting.
Requirements:
- TEXT or JSON format query plans, from PostgreSQL 9.6 — 17
- The interface and advice are in English
- A GitHub or Google account, for signing in
pgMustard is commercial software and has a free trial.
If you spend time reviewing query plans, we’d love to hear your thoughts.
—
Michael Christofides
https://www.pgmustard.com