pg stat statements module

pg_stat_statements module

SELECT queryid, query from pg_stat_statements where query like 'YOUR_QUERY_GOES_HERE'

CREATE EXTENSION pg_stat_statements;

CREATE EXTENSION IF NOT EXISTS pg_stat_statements WITH SCHEMA public;

From timescale documentation:

CREATE EXTENSION IF NOT EXISTS pg_stat_statements VERSION '1.10' CASCADE;

ERROR: relation pg_stat_statements does not exist at character 18

Related

• pg_stat
• PostgreSQL list extensions: \dx
• PostgreSQL modules
• pg_read_all_stats
• pgbench
• TimescaleDB: pg_stat_statements
• Amazon RDS Performance Insights
• EXPLAIN

See also

• pg_stat, pg_stat_activity, pg_stat_statements, pg_stat_replication, pg_stat_io, pg_stat_archiver, pg_catalog
• CREATE EXTENSION pg_stat_statements, postgis, timescaledb, ~/brew/share/postgresql@17/extension/
• PostgreSQL, PostgreSQL extensions, modules, CREATE EXTENSION, List extensions (\dx)

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