Pg stat statements module

pg_stat_statements

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

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;

ERROR: relation pg_stat_statements does not exist at character 18

Related

• pg_stat
• PostgreSQL list extensions: \dx

See also

• pg_stat, pg_stat_activity, pg_stat_statements, pg_stat_replication, pg_stat_io
• PostgreSQL, PostgreSQL extensions, CREATE EXTENSION, List extensions (\dx)