auto_explain

Provides a means for logging execution plans of slow statements automatically

Overview

ID	Extension	Package	Version	Category	License	Language
6980	auto_explain	auto_explain	`-`	STAT	PostgreSQL	C

Attribute	Has Binary	Has Library	Need Load	Has DDL	Relocatable	Trusted
--sL---	No	Yes	Yes	No	no	no

Relationships
See Also	pg_show_plans pg_store_plans pg_stat_statements pg_hint_plan plprofiler pg_stat_monitor pg_qualstats pg_track_settings

PG18	PG17	PG16	PG15	PG14	PG13
-	-	-	-	-	-

This is a built-in contrib extension ship with the PostgreSQL kernel

shared_preload_libraries = 'auto_explain';  -- comma-separated list

Create this extension with:

CREATE EXTENSION auto_explain;

Last updated on 2025-10-28