| From: | Wells Oliver <wells(dot)oliver(at)gmail(dot)com> |
|---|---|
| To: | Holger Jakobs <holger(at)jakobs(dot)com> |
| Cc: | pgsql-admin(at)lists(dot)postgresql(dot)org |
| Subject: | Re: pg_stat_statements_info |
| Date: | 2023-09-11 21:51:53 |
| Message-ID: | CAOC+FBWfKTNQzf2pNLEscQAHdRwW8aQ_A43rYuUNOOLzGTnFoQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Hmm, what schema is it in? Why would pg_stat_statements be in a different,
available schema?
On Mon, Sep 11, 2023 at 2:46 PM Holger Jakobs <holger(at)jakobs(dot)com> wrote:
> It's just not in a schema contained in you search_path
>
>
> Am 11. September 2023 23:26:22 MESZ schrieb Wells Oliver <
> wells(dot)oliver(at)gmail(dot)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(dot)oliver(at)gmail(dot)com <wellsoliver(at)gmail(dot)com>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Wells Oliver | 2023-09-11 22:19:06 | btree/gist index on date and searching using BETWEEN or >= and <= |
| Previous Message | Holger Jakobs | 2023-09-11 21:45:43 | Re: pg_stat_statements_info |