Re: pg_stat_statements does not require shared_preload_libraries to be modified

From: Lukas Fittl <lukas(at)fittl(dot)com>
To: juraj(dot)kristofik(at)enterprisedb(dot)com, pgsql-docs(at)lists(dot)postgresql(dot)org
Subject: Re: pg_stat_statements does not require shared_preload_libraries to be modified
Date: 2026-03-18 22:10:34
Message-ID: CAP53PkyZWm_gV6=jhbRsTzxT=SvWeRCG4ukLakL1GeSJ=h703Q@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-docs

Hi Juraj,

On Wed, Mar 18, 2026 at 5:08 AM PG Doc comments form
<noreply(at)postgresql(dot)org> wrote:
>
> 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;

Can you clarify why you think that's the case?

pg_stat_statements certainly does need to be included in
shared_preload_libraries, or it will emit an error noting its not
loaded: ERROR: pg_stat_statements must be loaded via
"shared_preload_libraries"

The only exception to that is if you're in an environment where the
provider has already included it in the default configuration, e.g. on
Amazon RDS - but that is not the case with the regular Postgres
packages to my knowledge.

Thanks,
Lukas

--
Lukas Fittl

In response to

Browse pgsql-docs by date

  From Date Subject
Next Message nik 2026-03-24 03:30:57 [PATCH] Doc: clarify that pg_upgrade statistics transfer works cross-version
Previous Message David G. Johnston 2026-03-18 16:55:39 Re: Conflict in documentation