About explain.dalibo.com

This service lets you analyze, visualize and share Postgres Query Plans. It will compute and highlight the most important information to make them easier to understand.

It is brought to you by Dalibo.

Acknowledgements

This app was inspired and heavily influenced by the excellent explain.depesz.com. Both the tool and the corresponding help files are a great resource to learn about Postgres and its planner.

It's also heavily inspired by PEV of which it can be considered a fork.

Usage tips

Format

To get the most out of it, we recommend generating a query plan using the following line: EXPLAIN (ANALYZE, COSTS, VERBOSE, BUFFERS, FORMAT JSON). It is recommend submitting a (decently formatted) SQL query that generated the plan.

PEV2 can also parse text although the JSON format usually has better support.

POST

You can send plans using HTTP POST.
Here's an example using cURL:
$ curl -Ls -w %{url_effective} -d '{"plan":"Result (cost=0.00..0.01 rows=1 width=32)"}' -H "Content-Type: application/json" -X POST https://explain.dalibo.com/new -o /dev/null | xargs xdg-open

Help us improve this service

This application uses PEV2 JS library to analyze and display the plan.

Please report bugs on github.

Retention

All plans and queries are saved in a database so that you can access them later or share them. If you don't want your plans to be saved you can either:

  • use the delete link provided when the plan is posted to remove the data from database,
  • use the standalone (browser only) version of this app available at https://dalibo.github.io/pev2/.