Usage

This function will explain query and post it to the explain.dalibo.com to visualize the plan

WARNING: http post will be sent to the internet service!

SELECT explain_ui($$query$$);

There’s a blog post on the idea behind this extension: Writing a Postgres Extension With Pgrx for Visual Query Plans

Example

Let’s generate pgbench sample tables

pgbench -is10

Then explain the query with:

CREATE EXTENSION explain_ui;
SELECT explain_ui($$SELECT * FROM pgbench_accounts;$$);

You’ll get an URL for the visual plan:

postgres@u22:5432/postgres=# SELECT explain_ui($$SELECT * FROM pgbench_accounts;$$);
                    explain_ui
--------------------------------------------------
 https://explain.dalibo.com/plan/05377227a29f0418
(1 row)

Time: 2284.667 ms (00:02.285)

Click or open that URL with your browser.