pg_stat_statements

Brand Details

Type: Product

Description: pg_stat_statements is a PostgreSQL extension that tracks the execution statistics of all SQL statements run on a server, providing details like planning and execution times to identify performance bottlenecks and optimize queries. It requires enabling shared_preload_libraries in postgresql.conf and restarting the server. It offers views (pg_stat_statements, pg_stat_statements_info) and functions (pg_stat_statements_reset, pg_stat_statements) to manage statistics. The number of tracked statements has a default limit (often 5000, configurable).

Website: https://www.postgresql.org/docs/current/pgstatstatements.html