pgMustard version 5

Posted on 2024-09-23 by pgMustard
Related Proprietary

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