From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
---|---|
To: | Wells Oliver <wells(dot)oliver(at)gmail(dot)com> |
Cc: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>, pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: pg_stat_statements_info |
Date: | 2023-09-12 05:31:19 |
Message-ID: | CAECtzeW1F=FmR7G3gAPy7yMpxdJSaqw49Zrqjx8uRCFogGPtEA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Le mar. 12 sept. 2023, 06:51, Wells Oliver <wells(dot)oliver(at)gmail(dot)com> a
écrit :
> Odd... definitely running Postgres 14.8.
>
Then you probably forgot to update your extension. What does "select * from
pg_available_extensions" show for the pg_stat_statements line?
>
> On Mon, Sep 11, 2023 at 9:44 PM Guillaume Lelarge <guillaume(at)lelarge(dot)info>
> wrote:
>
>> Hi,
>>
>> Le mar. 12 sept. 2023, 06:22, Wells Oliver <wells(dot)oliver(at)gmail(dot)com> a
>> écrit :
>>
>>> Does this make sense?
>>>
>>> SELECT extversion, extnamespace::regnamespace
>>> FROM pg_extension
>>> WHERE extname = 'pg_stat_statements';
>>>
>>> Shows 1.8 and public, but..
>>>
>>> SELECT * FROM public.pg_stat_statements_info();
>>>
>>> ERROR: function public.pg_stat_statements_info() does not exist
>>> LINE 1: SELECT * FROM public.pg_stat_statements_info();
>>> ^
>>> HINT: No function matches the given name and argument types. You might
>>> need to add explicit type casts.
>>>
>>> This is on RDS, I am not sure if the extension should somehow behave
>>> differently installed there.
>>>
>>
>> 1.8 seems to be PostgreSQL 13. You need at least PostgreSQL 14 to have
>> pg_stat_statements_info.
>>
>>
>>
>>>
>>> On Mon, Sep 11, 2023 at 7:24 PM Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
>>> wrote:
>>>
>>>> On Mon, 2023-09-11 at 14:26 -0700, Wells Oliver wrote:
>>>> > 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?
>>>>
>>>> This query will show you the version installed and the schema:
>>>>
>>>> SELECT extversion, extnamespace::regnamespace
>>>> FROM pg_extension
>>>> WHERE extname = 'pg_stat_statements';
>>>>
>>>> "pg_stat_statements_info" is not a view, but a function, so if the
>>>> extension
>>>> schema is "public", try
>>>>
>>>> SELECT * FROM public.pg_stat_statements_info();
>>>>
>>>> Yours,
>>>> Laurenz Albe
>>>>
>>>
>>>
>>> --
>>> Wells Oliver
>>> wells(dot)oliver(at)gmail(dot)com <wellsoliver(at)gmail(dot)com>
>>>
>>
>>
>> --
>> Guillaume
>>
>>>
>
> --
> Wells Oliver
> wells(dot)oliver(at)gmail(dot)com <wellsoliver(at)gmail(dot)com>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Wells Oliver | 2023-09-12 05:53:50 | Re: pg_stat_statements_info |
Previous Message | Wells Oliver | 2023-09-12 04:50:59 | Re: pg_stat_statements_info |