pg stat statements module

From wikieduonline
Jump to navigation Jump to search

pg_stat_statements [1] 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

See also

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