PIGSTY

pg_stat_statements

track planning and execution statistics of all SQL statements executed

Overview

6990pg_stat_statementspg_stat_statements1.11
STAT
PostgreSQL
C

Attributes

YesNoYesYesYesUnknownNo-

Packages

EL
CONTRIB
postgresql$v-contrib1.11-
17
16
15
14
13
Debian
CONTRIB
postgresql-$v1.11-
17
16
15
14
13

Dependent Extensions

The following extensions depend on this extension: pg_stat_kcache, powa

Availability

PG17PG16PG15PG14PG13
el8.x86_64
1.11
1.11
1.11
1.11
1.11
el8.aarch64
1.11
1.11
1.11
1.11
1.11
el9.x86_64
1.11
1.11
1.11
1.11
1.11
el9.aarch64
1.11
1.11
1.11
1.11
1.11
d12.x86_64
1.11
1.11
1.11
1.11
1.11
d12.aarch64
1.11
1.11
1.11
1.11
1.11
u22.x86_64
1.11
1.11
1.11
1.11
1.11
u22.aarch64
1.11
1.11
1.11
1.11
1.11
u24.x86_64
1.11
1.11
1.11
1.11
1.11
u24.aarch64
1.11
1.11
1.11
1.11
1.11
CONTRIB
PGDG
PIGSTY

Download

This extension is built-in with PostgreSQL and does not need separate download.

Install

Extension pg_stat_statements 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_stat_statements'  # add to existing extensions if any
After modifying the configuration, restart PostgreSQL to load the extension.
Create this extension with:
CREATE EXTENSION pg_stat_statements;