[prev in list] [next in list] [prev in thread] [next in thread]
List: postgresql-admin
Subject: Re: pg_stat_statements_info
From: Wells Oliver <wells.oliver () gmail ! com>
Date: 2023-09-12 5:53:50
Message-ID: CAOC+FBVYOzi68fMzdAi=K-ZhyfypdqKiC0Q7p+t7WjbxWA5GLA () mail ! gmail ! com
[Download RAW message or body]
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@lelarge.info>
wrote:
> Le mar. 12 sept. 2023, 06:51, Wells Oliver <wells.oliver@gmail.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@lelarge.info>
>> wrote:
>>
>>> Hi,
>>>
>>> Le mar. 12 sept. 2023, 06:22, Wells Oliver <wells.oliver@gmail.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.albe@cybertec.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.oliver@gmail.com <wellsoliver@gmail.com>
>>>>
>>>
>>>
>>> --
>>> Guillaume
>>>
>>>>
>>
>> --
>> Wells Oliver
>> wells.oliver@gmail.com <wellsoliver@gmail.com>
>>
>
--
Wells Oliver
wells.oliver@gmail.com <wellsoliver@gmail.com>
[Attachment #3 (text/html)]
<div dir="ltr">Ah, that's indeed. Thanks all. Just needed: alter extension \
pg_stat_statements update to '1.9';</div><br><div class="gmail_quote"><div \
dir="ltr" class="gmail_attr">On Mon, Sep 11, 2023 at 10:31 PM Guillaume Lelarge \
<<a href="mailto:guillaume@lelarge.info">guillaume@lelarge.info</a>> \
wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px \
0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="auto"><div \
dir="auto">Le mar. 12 sept. 2023, 06:51, Wells Oliver <<a \
href="mailto:wells.oliver@gmail.com" target="_blank">wells.oliver@gmail.com</a>> a \
écrit :<br></div><div class="gmail_quote" dir="auto"><blockquote \
class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid \
rgb(204,204,204);padding-left:1ex"><div dir="ltr">Odd... definitely running Postgres \
14.8.<div></div></div></blockquote></div><div dir="auto"><br></div><div \
dir="auto">Then you probably forgot to update your extension. What does "select \
* from pg_available_extensions" show for the pg_stat_statements line?</div><div \
dir="auto"><br></div><div class="gmail_quote" dir="auto"><blockquote \
class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid \
rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div><br></div></div><br><div \
class="gmail_quote"><div dir="ltr" class="gmail_attr">On Mon, Sep 11, 2023 at \
9:44 PM Guillaume Lelarge <<a href="mailto:guillaume@lelarge.info" \
rel="noreferrer" target="_blank">guillaume@lelarge.info</a>> \
wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px \
0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div \
dir="auto">Hi,<br><br><div class="gmail_quote" dir="auto"><div dir="ltr" \
class="gmail_attr">Le mar. 12 sept. 2023, 06:22, Wells Oliver <<a \
href="mailto:wells.oliver@gmail.com" rel="noreferrer" \
target="_blank">wells.oliver@gmail.com</a>> a écrit :<br></div><blockquote \
class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid \
rgb(204,204,204);padding-left:1ex"><div dir="ltr">Does this make \
sense?<div><br></div><div>SELECT extversion, extnamespace::regnamespace<br>FROM \
pg_extension<br>WHERE extname = \
'pg_stat_statements';</div><div><br></div><div>Shows 1.8 and public, \
but..<br><br>SELECT * FROM \
public.pg_stat_statements_info();<br></div><div><br></div><div>ERROR: function \
public.pg_stat_statements_info() does not exist<br>LINE 1: SELECT * FROM \
public.pg_stat_statements_info();<br> ^<br>HINT: No \
function matches the given name and argument types. You might need to add explicit \
type casts.<br></div><div><br></div><div>This is on RDS, I am not sure if the \
extension should somehow behave differently installed \
there.</div><div></div></div></blockquote></div><div dir="auto"><br></div><div \
dir="auto">1.8 seems to be PostgreSQL 13. You need at least PostgreSQL 14 to have \
pg_stat_statements_info.</div><div dir="auto"><br></div><div \
dir="auto"><br></div><div class="gmail_quote" dir="auto"><blockquote \
class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid \
rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div><br></div></div><br><div \
class="gmail_quote"><div dir="ltr" class="gmail_attr">On Mon, Sep 11, 2023 at \
7:24 PM Laurenz Albe <<a href="mailto:laurenz.albe@cybertec.at" rel="noreferrer \
noreferrer" target="_blank">laurenz.albe@cybertec.at</a>> \
wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px \
0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">On Mon, 2023-09-11 at \
14:26 -0700, Wells Oliver wrote:<br> > I don't have this view:<br>
> <br>
> ERROR: relation "pg_stat_statements_info" does not exist<br>
> LINE 1: select * from pg_stat_statements_info;<br>
> ^<br>
> But I definitely have the pg_stat_statements extension installed and query \
pg_stat_statements quite frequently... What gives?<br> <br>
This query will show you the version installed and the schema:<br>
<br>
SELECT extversion, extnamespace::regnamespace<br>
FROM pg_extension<br>
WHERE extname = 'pg_stat_statements';<br>
<br>
"pg_stat_statements_info" is not a view, but a function, so if the \
extension<br> schema is "public", try<br>
<br>
SELECT * FROM public.pg_stat_statements_info();<br>
<br>
Yours,<br>
Laurenz Albe<br>
</blockquote></div><br clear="all"><div><br></div><span \
class="gmail_signature_prefix">-- </span><br><div dir="ltr" \
class="gmail_signature"><div dir="ltr"><div>Wells Oliver<br><a \
href="mailto:wellsoliver@gmail.com" rel="noreferrer noreferrer" \
target="_blank">wells.oliver@gmail.com</a></div></div></div></blockquote></div><div \
dir="auto"><br></div><div dir="auto"><br></div><div dir="auto">-- </div><div \
dir="auto">Guillaume</div><div class="gmail_quote" dir="auto"><blockquote \
class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid \
rgb(204,204,204);padding-left:1ex"> </blockquote></div></div>
</blockquote></div><br clear="all"><div><br></div><span \
class="gmail_signature_prefix">-- </span><br><div dir="ltr" \
class="gmail_signature"><div dir="ltr"><div>Wells Oliver<br><a \
href="mailto:wellsoliver@gmail.com" rel="noreferrer" \
target="_blank">wells.oliver@gmail.com</a></div></div></div> \
</blockquote></div></div> </blockquote></div><br clear="all"><div><br></div><span \
class="gmail_signature_prefix">-- </span><br><div dir="ltr" \
class="gmail_signature"><div dir="ltr"><div>Wells Oliver<br><a \
href="mailto:wellsoliver@gmail.com" \
target="_blank">wells.oliver@gmail.com</a></div></div></div>
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic