We support Postgres 9.6 and higher, but we welcome issue reports on earlier versions too
We use Google for authentication (with only very basic permissions), so you'll need a (free) Google account attached to the email you want to use
We currently need plans to be in the JSON format, and work best with the following flags set: EXPLAIN (ANALYZE, BUFFERS, VERBOSE, FORMAT JSON)
Submit a query plan
Once you're in, all we need from you is a query plan.
If you don’t have a plan in JSON format and just want to see what pgMustard can do, select one of the examples and then Submit.
Work out what’s happening and what to do next
Once we have your plan, we'll display it back to you as a timing bar, a tree, and a table.
The timing bar shows the proportion of time each of the longest operations take (ordered by length).
With the tree, we mirror the indentation of the text plans you may be used to.
With the table, we try to display the most relevant performance information not already in the side bar.
Some options from here are:
Each operation node in the timing bar and tree is linked to a table row, and clicking one will highlight the others.
Click the sections in the reading pane for tips on what to do next, and links to further information where relevant.
We hope to save you time and effort understanding query plans and working out what to do next!