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.

You can find it here:

• https://www.bytefish.de/static/apps/pgplan-viz/ (English)

The code is in a Git Repository at:

• https://github.com/bytefish/misc/tree/main/pgplan-viz

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>