select * from pg_stat_statements;
Error message:
ERROR: relation "pg_stat_statements" does not exist
LINE 1: select * from pg_stat_statements
^
Cause:
pg_stat_statements is not available globally but can be enabled for a specific database with CREATE EXTENSION.
Solution:
Enable pg_stat_statements:
CREATE EXTENSION pg_stat_statements;
Check it:
SELECT * FROM pg_available_extensions WHERE name = 'pg_stat_statements';
SELECT * FROM pg_available_extension_versions WHERE name = 'pg_stat_statements';
No comments:
Post a Comment