Difference between revisions of "Pg stat statements module"
Jump to navigation
Jump to search
↑ https://www.postgresql.org/docs/current/pgstatstatements.html
| Line 1: | Line 1: | ||
{{lc}} | {{lc}} | ||
| − | <code>[[pg_stat_statements]]</code> <ref>https://www.postgresql.org/docs/current/pgstatstatements.html</ref> | + | <code>[[pg_stat_statements]]</code> <ref>https://www.postgresql.org/docs/current/pgstatstatements.html</ref> [[module]] |
Revision as of 09:17, 3 July 2023
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
See also
pg_stat, pg_stat_activity, pg_stat_statements, pg_stat_replication, pg_stat_io- PostgreSQL, PostgreSQL extensions,
CREATE EXTENSION, List extensions (\dx)
Advertising:
