From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
---|---|
To: | Wells Oliver <wells(dot)oliver(at)gmail(dot)com>, pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: pg_stat_statements_info |
Date: | 2023-09-12 02:24:45 |
Message-ID: | 2f6b87688c68ad392f0456ad796a24e798557b9b.camel@cybertec.at |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Wells Oliver | 2023-09-12 04:08:37 | Re: pg_stat_statements_info |
Previous Message | Rui DeSousa | 2023-09-12 00:51:38 | Re: percentile_cont from array? |