Visualizing PostgreSQL Query Plans

I am sure, there are great tools to visualize PostgreSQL Query Plans, so why not add another one to the list? Let me introduce you to pgplan-viz, which is a web app to visualize PostgreSQL EXPLAIN query plans and export them as PNG.

CSV Explorer

You can find it here:

The code is in a Git Repository at:

Creating the EXPLAIN as JSON

The following PL/SQL statement creates a JSON-formatted Query Plan for you to analyze:

 EXPLAIN (ANALYZE, COSTS, VERBOSE, BUFFERS, FORMAT JSON) <QUERY>

How to contribute

One of the easiest ways to contribute is to participate in discussions. You can also contribute by submitting pull requests.

General feedback and discussions?

Do you have questions or feedback on this article? Please create an issue on the Repositories issue tracker.

Something is wrong or missing?

There may be something wrong or missing in this article. If you want to help fixing it, then please make a Pull Request to this file.