Difference between revisions of "Pg stat statements module"
Jump to navigation
Jump to search
↑ https://www.postgresql.org/docs/current/pgstatstatements.html
| (9 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
{{lc}} | {{lc}} | ||
| − | <code>[[pg_stat_statements]]</code> | + | <code>[[pg_stat_statements]]</code> <ref>https://www.postgresql.org/docs/current/pgstatstatements.html</ref> [[module]] |
| − | |||
[[SELECT]] queryid, query from pg_stat_statements where query like 'YOUR_QUERY_GOES_HERE' | [[SELECT]] queryid, query from pg_stat_statements where query like 'YOUR_QUERY_GOES_HERE' | ||
| Line 9: | Line 8: | ||
[[CREATE EXTENSION]] IF NOT EXISTS pg_stat_statements WITH SCHEMA public; | [[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 | ERROR: relation pg_stat_statements does not exist at character 18 | ||
| Line 15: | Line 17: | ||
* <code>[[pg_stat]]</code> | * <code>[[pg_stat]]</code> | ||
* [[PostgreSQL list extensions]]: <code>[[\dx]]</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 == | == 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:
