Content-Type: text/plain; charset="utf-8"
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable
Subject: pg_stat_statements does not require shared_preload_libraries to be
 modified
To: pgsql-docs@lists.postgresql.org
From: PG Doc comments form <noreply@postgresql.org>
Cc: juraj.kristofik@enterprisedb.com
Reply-To: juraj.kristofik@enterprisedb.com, pgsql-docs@lists.postgresql.org
Date: Wed, 18 Mar 2026 02:37:09 +0000
Message-ID: <177380142997.811.12346365369880204472@wrigleys.postgresql.org>
Auto-Submitted: auto-generated
Archived-At: 
 <https://www.postgresql.org/message-id/177380142997.811.12346365369880204472%40wrigleys.postgresql.org>
Precedence: bulk

The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/18/pgstatstatements.html
Description:

Hi,

This is inaccurate at
https://www.postgresql.org/account/comments/new/18/pgstatstatements.html/
the module just needs the contrib package;
The docs:
The pg_stat_statements module provides a means for tracking planning and
execution statistics of all SQL statements executed by a server.

The module must be loaded by adding pg_stat_statements to
shared_preload_libraries in postgresql.conf, because it requires additional
shared memory. This means that a server restart is needed to add or remove
the module. In addition, query identifier calculation must be enabled in
order for the module to be active, which is done automatically if
compute_query_id is set to auto or on, or any third-party module that
calculates query identifiers is loaded.

When pg_stat_statements is active, it tracks statistics across all databases
of the server. To access and manipulate these statistics, the module
provides views pg_stat_statements and pg_stat_statements_info, and the
utility functions pg_stat_statements_reset and pg_stat_statements. These are
not available globally but can be enabled for a specific database with
CREATE EXTENSION pg_stat_statements.