pg_stat_statements

Overview

CONTRIB Built-in Extension: pg_stat_statements : track planning and execution statistics of all SQL statements executed

Information

• Extension ID: 6990
• Extension Name: pg_stat_statements
• Package Name: None
• Category: STAT
• License: PostgreSQL
• Website: https://www.postgresql.org/docs/current/pgstatstatements.html
• Language: C
• Extra Tags: N/A
• Comment: N/A

Metadata

• Latest Version: 1.11
• Postgres Support: 17,16,15,14,13
• Need Load: Explicit Loading Required
• Need DDL: 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

Installation

Extension pg_stat_statements is PostgreSQL Built-in Contrib Extension which is installed along with the kernel/contrib.

Install pg_stat_statements 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 pg_stat_statements 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 pg_stat_statements has to be added to shared_preload_libraries

shared_preload_libraries = 'pg_stat_statements'; # add to pg cluster config

Enable pg_stat_statements extension on PostgreSQL cluster：

CREATE EXTENSION pg_stat_statements;