Difference between revisions of "Pg stat statements module"
Jump to navigation
Jump to search
↑ https://www.postgresql.org/docs/current/pgstatstatements.html
| (5 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 18: | Line 18: | ||
* [[PostgreSQL list extensions]]: <code>[[\dx]]</code> | * [[PostgreSQL list extensions]]: <code>[[\dx]]</code> | ||
* [[PostgreSQL modules]] | * [[PostgreSQL modules]] | ||
| + | * <code>[[pg_read_all_stats]]</code> | ||
| + | * <code>[[pgbench]]</code> | ||
| + | * [[TimescaleDB: pg_stat_statements]] | ||
| + | * [[Amazon RDS Performance Insights]] | ||
== See also == | == See also == | ||
* {{pg_stat}} | * {{pg_stat}} | ||
| + | * {{create extension}} | ||
* {{PostgreSQL extensions}} | * {{PostgreSQL extensions}} | ||
[[Category:PostgreSQL]] | [[Category:PostgreSQL]] | ||
Latest revision as of 14:55, 19 December 2024
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_ioCREATE EXTENSION pg_stat_statements, ~/brew/share/postgresql@17/extension/- PostgreSQL, PostgreSQL extensions,
CREATE EXTENSION, List extensions (\dx)
Advertising:
