May 2018
Intermediate to advanced
576 pages
30h 25m
English
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
List of installed extensions:
-[ RECORD 1 ]---------------------------------------------------------- Name | pg_stat_statements Version | 1.4 Schema | public Description | track execution statistics of all SQL statements executed
If not, 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 module and Managing installed extensions ...