Bug#969311: UDD: please install pg_stat_statements extension
owner 969311 mbanck@debian.org
thanks
On Mon, Aug 31, 2020 at 10:02:52AM +0200, Michael Banck wrote:
> In order to best assess where and how to improve the situation, please
> install the pg_stat_statements extension in the udd database, like
>
> CREATE EXTENSION pg_stat_statements;
Gah, I forgot that pg_stat_statements requires a preloaded library. So
before the above can work, postgresql.conf needs to be changed:
-#shared_preload_libraries = '' # (change requires restart)
+shared_preload_libraries = 'pg_stat_statements' # (change requires restart)
As indicated, this will only take effect after the next server restart,
then the extension can be created.
pg_stat_statements is part of the core set of Postgres extensions and
does not need to be installed via packages.
Michael
Reply to: