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 | - | 18 17 16 15 14 13 |
| Debian | CONTRIB | postgresql-$v | 1.0 | - | 18 17 16 15 14 13 |
See Also
Availability
| PG18 | PG17 | PG16 | PG15 | PG14 | PG13 | |
|---|---|---|---|---|---|---|
el8.x86_64 | 1.0 | ✗ | ✗ | ✗ | ✗ | ✗ |
el8.aarch64 | 1.0 | ✗ | ✗ | ✗ | ✗ | ✗ |
el9.x86_64 | 1.0 | ✗ | ✗ | ✗ | ✗ | ✗ |
el9.aarch64 | 1.0 | ✗ | ✗ | ✗ | ✗ | ✗ |
d12.x86_64 | 1.0 | ✗ | ✗ | ✗ | ✗ | ✗ |
d12.aarch64 | 1.0 | ✗ | ✗ | ✗ | ✗ | ✗ |
u22.x86_64 | 1.0 | ✗ | ✗ | ✗ | ✗ | ✗ |
u22.aarch64 | 1.0 | ✗ | ✗ | ✗ | ✗ | ✗ |
u24.x86_64 | 1.0 | ✗ | ✗ | ✗ | ✗ | ✗ |
u24.aarch64 | 1.0 | ✗ | ✗ | ✗ | ✗ | ✗ |
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.