pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedpg_stat_statements_info
9+ messages / 4 participants
[nested] [flat]
* pg_stat_statements_info
@ 2023-09-11 21:26 Wells Oliver <wells.oliver@gmail.com>
0 siblings, 2 replies; 9+ messages in thread
From: Wells Oliver @ 2023-09-11 21:26 UTC (permalink / raw)
To: pgsql-admin
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.oliver@gmail.com <wellsoliver@gmail.com>
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: pg_stat_statements_info
@ 2023-09-11 21:45 Holger Jakobs <holger@jakobs.com>
parent: Wells Oliver <wells.oliver@gmail.com>
1 sibling, 1 reply; 9+ messages in thread
From: Holger Jakobs @ 2023-09-11 21:45 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
It's just not in a schema contained in you search_path
Am 11. September 2023 23:26:22 MESZ schrieb Wells Oliver <wells.oliver@gmail.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.oliver@gmail.com <wellsoliver@gmail.com>
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: pg_stat_statements_info
@ 2023-09-11 21:51 Wells Oliver <wells.oliver@gmail.com>
parent: Holger Jakobs <holger@jakobs.com>
0 siblings, 0 replies; 9+ messages in thread
From: Wells Oliver @ 2023-09-11 21:51 UTC (permalink / raw)
To: Holger Jakobs <holger@jakobs.com>; +Cc: pgsql-admin@lists.postgresql.org
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@jakobs.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.oliver@gmail.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.oliver@gmail.com <wellsoliver@gmail.com>
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: pg_stat_statements_info
@ 2023-09-12 02:24 Laurenz Albe <laurenz.albe@cybertec.at>
parent: Wells Oliver <wells.oliver@gmail.com>
1 sibling, 1 reply; 9+ messages in thread
From: Laurenz Albe @ 2023-09-12 02:24 UTC (permalink / raw)
To: Wells Oliver <wells.oliver@gmail.com>; pgsql-admin
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
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: pg_stat_statements_info
@ 2023-09-12 04:08 Wells Oliver <wells.oliver@gmail.com>
parent: Laurenz Albe <laurenz.albe@cybertec.at>
0 siblings, 1 reply; 9+ messages in thread
From: Wells Oliver @ 2023-09-12 04:08 UTC (permalink / raw)
To: Laurenz Albe <laurenz.albe@cybertec.at>; +Cc: pgsql-admin
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.
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>
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: pg_stat_statements_info
@ 2023-09-12 04:44 Guillaume Lelarge <guillaume@lelarge.info>
parent: Wells Oliver <wells.oliver@gmail.com>
0 siblings, 1 reply; 9+ messages in thread
From: Guillaume Lelarge @ 2023-09-12 04:44 UTC (permalink / raw)
To: Wells Oliver <wells.oliver@gmail.com>; +Cc: Laurenz Albe <laurenz.albe@cybertec.at>; pgsql-admin
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
>
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: pg_stat_statements_info
@ 2023-09-12 04:50 Wells Oliver <wells.oliver@gmail.com>
parent: Guillaume Lelarge <guillaume@lelarge.info>
0 siblings, 1 reply; 9+ messages in thread
From: Wells Oliver @ 2023-09-12 04:50 UTC (permalink / raw)
To: Guillaume Lelarge <guillaume@lelarge.info>; +Cc: Laurenz Albe <laurenz.albe@cybertec.at>; pgsql-admin
Odd... definitely running Postgres 14.8.
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>
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: pg_stat_statements_info
@ 2023-09-12 05:31 Guillaume Lelarge <guillaume@lelarge.info>
parent: Wells Oliver <wells.oliver@gmail.com>
0 siblings, 1 reply; 9+ messages in thread
From: Guillaume Lelarge @ 2023-09-12 05:31 UTC (permalink / raw)
To: Wells Oliver <wells.oliver@gmail.com>; +Cc: Laurenz Albe <laurenz.albe@cybertec.at>; pgsql-admin
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>
>
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: pg_stat_statements_info
@ 2023-09-12 05:53 Wells Oliver <wells.oliver@gmail.com>
parent: Guillaume Lelarge <guillaume@lelarge.info>
0 siblings, 0 replies; 9+ messages in thread
From: Wells Oliver @ 2023-09-12 05:53 UTC (permalink / raw)
To: Guillaume Lelarge <guillaume@lelarge.info>; +Cc: Laurenz Albe <laurenz.albe@cybertec.at>; 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@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>
^ permalink raw reply [nested|flat] 9+ messages in thread
end of thread, other threads:[~2023-09-12 05:53 UTC | newest]
Thread overview: 9+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-09-11 21:26 pg_stat_statements_info Wells Oliver <wells.oliver@gmail.com>
2023-09-11 21:45 ` Holger Jakobs <holger@jakobs.com>
2023-09-11 21:51 ` Wells Oliver <wells.oliver@gmail.com>
2023-09-12 02:24 ` Laurenz Albe <laurenz.albe@cybertec.at>
2023-09-12 04:08 ` Wells Oliver <wells.oliver@gmail.com>
2023-09-12 04:44 ` Guillaume Lelarge <guillaume@lelarge.info>
2023-09-12 04:50 ` Wells Oliver <wells.oliver@gmail.com>
2023-09-12 05:31 ` Guillaume Lelarge <guillaume@lelarge.info>
2023-09-12 05:53 ` Wells Oliver <wells.oliver@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox