pg_overexplain
Allow EXPLAIN to dump even more details
Overview
| 6880 | pg_overexplain | pg_overexplain | 1.0 | STAT | PostgreSQL | C |
Attributes
| Yes | No | Yes | Yes | No | No | No | - |
Packages
| EL | CONTRIB | postgresql$v-contrib | 1.0 | - | 17 16 15 14 13 |
| Debian | CONTRIB | postgresql-$v | 1.0 | - | 17 16 15 14 13 |
Availability
| PG17 | PG16 | PG15 | PG14 | PG13 | |
|---|---|---|---|---|---|
el8.x86_64 | ✗ | ✗ | ✗ | ✗ | ✗ |
el8.aarch64 | ✗ | ✗ | ✗ | ✗ | ✗ |
el9.x86_64 | ✗ | ✗ | ✗ | ✗ | ✗ |
el9.aarch64 | ✗ | ✗ | ✗ | ✗ | ✗ |
d12.x86_64 | ✗ | ✗ | ✗ | ✗ | ✗ |
d12.aarch64 | ✗ | ✗ | ✗ | ✗ | ✗ |
u22.x86_64 | ✗ | ✗ | ✗ | ✗ | ✗ |
u22.aarch64 | ✗ | ✗ | ✗ | ✗ | ✗ |
u24.x86_64 | ✗ | ✗ | ✗ | ✗ | ✗ |
u24.aarch64 | ✗ | ✗ | ✗ | ✗ | ✗ |
CONTRIB
PGDG
PIGSTY
Download
This extension is built-in with PostgreSQL and does not need separate download.
Install
Extension
pg_overexplain is PostgreSQL Built-in Contrib Extension which is installed along with the kernel/contrib.Load this extension by adding it to shared_preload_libraries:
# postgresql.conf
shared_preload_libraries = 'pg_overexplain' # add to existing extensions if anyAfter modifying the configuration, restart PostgreSQL to load the extension.