explain_ui

Overview

PIGSTY 3rd Party Extension: pg_explain_ui : easily jump into a visual plan UI for any SQL query

Information

• Extension ID: 6370
• Extension Name: explain_ui
• Package Name: pg_explain_ui
• Category: STAT
• License: PostgreSQL
• Website: https://github.com/davidgomes/pg-explain-ui
• Language: Rust
• Extra Tags: pgrx
• Comment: N/A

Metadata

• Latest Version: 0.0.1
• Postgres Support: 17,16,15,14,13
• Need Load: Shared library do not need explicit loading
• Need DDL: Need CREATE EXTENSION DDL
• Relocatable: Can be installed into other schemas
• Trusted: Trusted, Can be created by user with CREATE Privilege
• Schemas: N/A
• Requires: N/A

RPM / DEB

• RPM Repo: PIGSTY
• RPM Name: pg_explain_ui_$v
• RPM Ver : 0.0.1
• RPM Deps: N/A
• DEB Repo: PIGSTY
• DEB Name: postgresql-$v-pg-explain-ui
• DEB Ver : 0.0.1
• DEB Deps: N/A

Packages

Installation

Install explain_ui via the pig CLI tool:

pig ext install pg_explain_ui; # Extension Namepig ext install explain_ui; # normalized package name

Install pg_explain_ui via Pigsty playbook:

./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pg_explain_ui"]}' # -l <cls>

Install pg_explain_ui RPM from YUM repo directly:

dnf install pg_explain_ui_17;
dnf install pg_explain_ui_16;
dnf install pg_explain_ui_15;
dnf install pg_explain_ui_14;
dnf install pg_explain_ui_13;

Install pg_explain_ui DEB from APT repo directly:

apt install postgresql-17-pg-explain-ui;
apt install postgresql-16-pg-explain-ui;
apt install postgresql-15-pg-explain-ui;
apt install postgresql-14-pg-explain-ui;
apt install postgresql-13-pg-explain-ui;

Enable explain_ui extension on PostgreSQL cluster：

CREATE EXTENSION explain_ui;