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, 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