From: Holger Jakobs <holger@jakobs.com>
To: pgsql-admin@lists.postgresql.org
Subject: Re: pg_stat_statements_info
Date: Mon, 11 Sep 2023 23:45:43 +0200
Message-ID: <3047F5E5-A503-44EB-9F12-642E80CCD5DC@jakobs.com> (raw)
In-Reply-To: <CAOC+FBXkM6PpQ+w3QnMZSPeXaTeeJbG0CsTT-R9ToyDwbpD52w@mail.gmail.com>
References: <CAOC+FBXkM6PpQ+w3QnMZSPeXaTeeJbG0CsTT-R9ToyDwbpD52w@mail.gmail.com>
It's just not in a schema contained in you search_path
Am 11. September 2023 23:26:22 MESZ schrieb Wells Oliver <wells.oliver@gmail.com>:
>I don't have this view:
>
>ERROR: relation "pg_stat_statements_info" does not exist
>LINE 1: select * from pg_stat_statements_info;
> ^
>But I definitely have the pg_stat_statements extension installed and
>query pg_stat_statements quite frequently... What gives?
>
>--
>Wells Oliver
>wells.oliver@gmail.com <wellsoliver@gmail.com>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: holger@jakobs.com, pgsql-admin@lists.postgresql.org
Subject: Re: pg_stat_statements_info
In-Reply-To: <3047F5E5-A503-44EB-9F12-642E80CCD5DC@jakobs.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox