auto_explain
Provides a means for logging execution plans of slow statements automatically
Module:
Categories:
Overview
CONTRIB Built-in Extension: auto_explain
: Provides a means for logging execution plans of slow statements automatically
Information
- Extension ID: 6980
- Extension Name:
auto_explain
- Package Name:
None
- Category:
STAT
- License: PostgreSQL
- Website: https://www.postgresql.org/docs/current/auto-explain.html
- Language: C
- Extra Tags: N/A
- Comment: N/A
Metadata
- Latest Version: -
- Postgres Support:
17
,16
,15
,14
,13
- Need Load: Explicit Loading Required
- Need DDL: Dd not need
CREATE EXTENSION
DDL - Relocatable: Unknown
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
RPM / DEB
PostgreSQL Built-in Contrib Extension
Packages
OS | Arch | 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 |
Installation
Extension auto_explain
is PostgreSQL Built-in Contrib Extension which is installed along with the kernel/contrib.
Install auto_explain
RPM from YUM repo directly:
dnf install postgresql17-contrib;
dnf install postgresql16-contrib;
dnf install postgresql15-contrib;
dnf install postgresql14-contrib;
dnf install postgresql13-contrib;
Install auto_explain
DEB from APT repo directly:
apt install postgresql-17;
apt install postgresql-16;
apt install postgresql-15;
apt install postgresql-14;
apt install postgresql-13;
Extension auto_explain
has to be added to shared_preload_libraries
shared_preload_libraries = 'auto_explain'; # add to pg cluster config
Extension %s
does not need CREATE EXTENSION
command
Feedback
Was this page helpful?
Glad to hear it! Please tell us how we can improve.
Sorry to hear that. Please tell us how we can improve.