PostgreSQL 11 Administration Cookbook

Getting ready

Connect to the database as the user whose statements you want to investigate or as a superuser to investigate all users' queries.

Check that you have the pg_stat_statements extension installed:

 postgres=# \x postgres=# \dx pg_stat_statements

The following is a list of our installed extensions:

-[ RECORD 1 ]---------------------------------------------------------- Name        | pg_stat_statements Version     | 1.4 Schema      | public Description | track execution statistics of all SQL statements executed

If you can't see them, then issue the following command:

postgres=# CREATE EXTENSION pg_stat_statements; postgres=# ALTER SYSTEM          SET shared_preload_libraries = 'pg_stat_statements';

Then, restart the server, or refer to the Using an installed ...