The pg_stat_statements extension adds the capability to track execution statistics of queries that are run in a database, including the number of calls, total execution time, total number of returned rows, and internal information on memory and I/O access.
It is evident how this approach opens up new opportunities in PostgreSQL performance analysis by allowing DBAs to get insights directly from the database through SQL and in real time.
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...