pg_stat_statements

pg_stat_statements

track planning and execution statistics of all SQL statements executed

Overview

IDExtensionPackageVersionCategoryLicenseLanguage
6990
pg_stat_statements
pg_stat_statements
1.11
STAT
PostgreSQL
C
AttributeHas BinaryHas LibraryNeed LoadHas DDLRelocatableTrusted
--sLd--
No
Yes
Yes
Yes
no
no
Relationships
Need By
pg_stat_kcache
powa
See Also
pg_qualstats
pg_store_plans
pg_track_settings
pg_stat_monitor
auto_explain
pg_profile
pg_show_plans
pg_hint_plan

Packages

PG18PG17PG16PG15PG14PG13
1.11
1.11
1.11
1.11
1.11
1.11

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

Install

Add this extension to shared_preload_libraries:

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

Create this extension with:

CREATE EXTENSION pg_stat_statements;
Last updated on