pg_stat_kcache
pg_stat_kcache copied to clipboard
Using schema for placing pg_stat_statements and pg_stat_kcache
Hello! If I install extension pg_stat_statement into schema pgss, then I have error:
CREATE EXTENSION pg_stat_statements SCHEMA pgss;
CREATE EXTENSION pg_stat_kcache SCHEMA pgsk;
ERROR: relation "pg_stat_statements" does not exist
But as you can see
show search_path;
search_path
-----------------------------------------------------
"$user", public, pg_profile, pgsk, pgws, pgss, pgps
Is it possible to resolve it?