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...