Difference between revisions of "Pg stat statements module"
Jump to navigation
Jump to search
↑ https://www.postgresql.org/docs/current/pgstatstatements.html
| (3 intermediate revisions by the same user not shown) | |||
| Line 10: | Line 10: | ||
From timescale documentation: | From timescale documentation: | ||
| − | CREATE EXTENSION IF NOT EXISTS pg_stat_statements VERSION '1.10' CASCADE; | + | [[CREATE EXTENSION]] IF NOT EXISTS pg_stat_statements VERSION '1.10' CASCADE; |
ERROR: relation pg_stat_statements does not exist at character 18 | ERROR: relation pg_stat_statements does not exist at character 18 | ||
| Line 19: | Line 19: | ||
* [[PostgreSQL modules]] | * [[PostgreSQL modules]] | ||
* <code>[[pg_read_all_stats]]</code> | * <code>[[pg_read_all_stats]]</code> | ||
| + | * <code>[[pgbench]]</code> | ||
| + | * [[TimescaleDB: pg_stat_statements]] | ||
| + | * [[Amazon RDS Performance Insights]] | ||
== See also == | == See also == | ||
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
Related[edit]
pg_stat- PostgreSQL list extensions:
\dx - PostgreSQL modules
pg_read_all_statspgbench- TimescaleDB: pg_stat_statements
- Amazon RDS Performance Insights
See also[edit]
pg_stat, pg_stat_activity, pg_stat_statements, pg_stat_replication, pg_stat_io- PostgreSQL, PostgreSQL extensions,
CREATE EXTENSION, List extensions (\dx)
Advertising:
