Postgresql’s pg_stat_statements

This is a postgresql module allowing to track planning and execution statistics of all SQL statements executed by a server.

Using this, we can monitor/figure out what the slowest queries executed on the server are.

Resources:

• Postgresql doc: https://www.postgresql.org/docs/13/pgstatstatements.html

• How to enable it: https://www.virtual-dba.com/postgresql-performance-enabling-pg-stat-statements/

• How to use it: https://www.virtual-dba.com/postgresql-performance-identifying-hot-and-slow-queries/