May 2018
Intermediate to advanced
576 pages
30h 25m
English
The pg_stat_statements module is available as a contrib module of PostgreSQL. The extension must be installed as a superuser in the desired databases. It also requires administrators to add the library in the postgresql.conf file, as follows:
shared_preload_libraries = 'pg_stat_statements'
This change requires restarting the PostgreSQL server.
Finally, in order to use it, the extension must be installed in the desired database through the usual CREATE EXTENSION command (run as a superuser):
gabriele=# CREATE EXTENSION pg_stat_statements;CREATE EXTENSION