From: | Wells Oliver <wells(dot)oliver(at)gmail(dot)com> |
---|---|
To: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
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:53:50 |
Message-ID: | CAOC+FBVYOzi68fMzdAi=K-ZhyfypdqKiC0Q7p+t7WjbxWA5GLA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Ah, that's indeed. Thanks all. Just needed: alter extension
pg_stat_statements update to '1.9';
On Mon, Sep 11, 2023 at 10:31 PM Guillaume Lelarge <guillaume(at)lelarge(dot)info>
wrote:
> 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>
>>
>
--
Wells Oliver
wells(dot)oliver(at)gmail(dot)com <wellsoliver(at)gmail(dot)com>
From | Date | Subject | |
---|---|---|---|
Next Message | Rajesh Kumar | 2023-09-12 07:04:12 | Service outage list |
Previous Message | Guillaume Lelarge | 2023-09-12 05:31:19 | Re: pg_stat_statements_info |