Re: pg_stat_statements_info

Odd... definitely running Postgres 14.8.

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>