Re: pg_stat_statements_info
| От | Wells Oliver |
|---|---|
| Тема | Re: pg_stat_statements_info |
| Дата | |
| Msg-id | CAOC+FBV7ub_e0SdM1Tzvva4d1UVfso5GApiK=upAc=h4VW9hDw@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: pg_stat_statements_info (Laurenz Albe <laurenz.albe@cybertec.at>) |
| Ответы |
Re: pg_stat_statements_info
|
| Список | pgsql-admin |
Does this make sense?
SELECT extversion, extnamespace::regnamespace
FROM pg_extension
WHERE extname = 'pg_stat_statements';
FROM pg_extension
WHERE extname = 'pg_stat_statements';
Shows 1.8 and public, but..
SELECT * FROM public.pg_stat_statements_info();
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.
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
wells.oliver@gmail.com
В списке pgsql-admin по дате отправления: