Difference between revisions of "Pg stat statements module"

Latest revision as of 08:12, 31 August 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;

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

@@ Line 1: / Line 1: @@
 {{lc}}
+<code>[[pg_stat_statements]]</code> <ref>https://www.postgresql.org/docs/current/pgstatstatements.html</ref> [[module]]
-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;
+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 ==
 * <code>[[pg_stat]]</code>
+* [[PostgreSQL list extensions]]: <code>[[\dx]]</code>
+* [[PostgreSQL modules]]
+* <code>[[pg_read_all_stats]]</code>
+* <code>[[pgbench]]</code>
+* [[TimescaleDB: pg_stat_statements]]
+* [[Amazon RDS Performance Insights]]
 == See also ==
-* {{PostgreSQL}}
+* {{pg_stat}}
+* {{PostgreSQL extensions}}
 [[Category:PostgreSQL]]