Answer the question
In order to leave comments, you need to log in
Why do "pg_buffercache" and "pg_stat_statements" show up in the log as not installed?
postgresql-9.5
Installed extensions CREATE EXTENSION pg_buffercache
CREATE EXTENSION pg_stat_statements
Postgresql.conf changes
shared_preload_libraries = 'pg_stat_statements'
pg_stat_statements.track = all
\dx
+--------------------+-----------+------------+-----------------------------------------------------------+
| Name | Version | Schema | Description |
|--------------------+-----------+------------+-----------------------------------------------------------|
| pg_buffercache | 1.1 | public | examine the shared buffer cache |
| pg_stat_statements | 1.3 | public | track execution statistics of all SQL statements executed |
| plpgsql | 1.0 | pg_catalog | PL/pgSQL procedural language |
+--------------------+-----------+------------+-----------------------------------------------------------+
\dx+
Objects in extension "pg_buffercache"
+-------------------------------------------+
| Object Description |
|-------------------------------------------|
| function plpgsql_call_handler() |
| function plpgsql_inline_handler(internal) |
| function plpgsql_validator(oid) |
| language plpgsql |
+-------------------------------------------+
SELECT 2
Objects in extension "pg_stat_statements"
+----------------------+
| Object Description |
|----------------------|
+----------------------+
SELECT 3
Objects in extension "plpgsql"
+----------------------+
| Object Description |
|----------------------|
+----------------------+
[email protected] ERROR: relation "pg_stat_statements" does not exist at character 62
[email protected] ERROR: relation "pg_buffercache" does not exist at character 511
ERROR: function pg_size_bytes(text) does not exist at character 36
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question