pg_overexplain

Overview

CONTRIB Built-in Extension: pg_overexplain : Allow EXPLAIN to dump even more details

Information

• Extension ID: 6880
• Extension Name: pg_overexplain
• Package Name: None
• Category: STAT
• License: PostgreSQL
• Website: https://www.postgresql.org/docs/devel/pgoverexplain.html
• Language: C
• Extra Tags: N/A
• Comment: N/A

Metadata

• Latest Version: 1.0
• Postgres Support: 18
• Need Load: Explicit Loading Required
• Need DDL: Dd not need CREATE EXTENSION DDL
• Relocatable: Can be installed into other schemas
• Trusted: Untrusted, Require Superuser to Create
• Schemas: N/A
• Requires: N/A

RPM / DEB

PostgreSQL Built-in Contrib Extension

Availability

Installation

Extension pg_overexplain is PostgreSQL Built-in Contrib Extension which is installed along with the kernel/contrib.

Install pg_overexplain RPM from YUM repo directly:

dnf install postgresql18-contrib;

Install pg_overexplain DEB from APT repo directly:

apt install postgresql-18;

Extension pg_overexplain has to be loaded via shared_preload_libraries

shared_preload_libraries = 'pg_overexplain'; # add to pg cluster config

Extension %s does not need CREATE EXTENSION command