owner 969311 mba...@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