PostgreSQL 12 High Availability Cookbook - Third Edition

How to do it...

Begin by installing the pg_stat_statements module. Follow these steps:

1. Modify the shared_preload_libraries line in postgresql.conf to include the module, like this:

shared_preload_libraries = 'pg_stat_statements'

2. If you are using PostgreSQL 9.1 or older, add this line to postgresql.conf:

custom_variable_classes = 'pg_stat_statements' 

3. Restart PostgreSQL with a command similar to this:

pg_ctl -D /db/pgdata restart

4. Log in to PostgreSQL as a superuser into any database that should have access to pg_stat_statements and execute the following SQL statement:

CREATE EXTENSION pg_stat_statements; 

Perform the following steps to prepare pg_stat_statements for generalized use:

1. Execute this SQL statement as a database superuser ...