explain_ui

pig build pkg pg_explain_ui;		# build rpm/deb

pig repo add pgsql -u   # add both repo and update cache

pig install pg_explain_ui;		# install via package name, for the active PG version
pig install explain_ui;		# install by extension name, for the current active PG version

pig install explain_ui -v 18;   # install for PG 18
pig install explain_ui -v 17;   # install for PG 17
pig install explain_ui -v 16;   # install for PG 16
pig install explain_ui -v 15;   # install for PG 15
pig install explain_ui -v 14;   # install for PG 14

CREATE EXTENSION explain_ui;

SELECT explain_ui($$
  SELECT b.title, a.name, p.name
  FROM books b
  INNER JOIN authors a ON b.author_id = a.author_id
  INNER JOIN publishers p ON b.publisher_id = p.publisher_id
  ORDER BY b.publication_date DESC
$$);

                    explain_ui
--------------------------------------------------
 https://explain.dalibo.com/plan/ccg2e5fedd913bb7