Message-ID: <2f6b87688c68ad392f0456ad796a24e798557b9b.camel@cybertec.at>
Subject: Re: pg_stat_statements_info
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Wells Oliver <wells.oliver@gmail.com>, pgsql-admin
	 <pgsql-admin@postgresql.org>
Date: Tue, 12 Sep 2023 04:24:45 +0200
In-Reply-To: 
 <CAOC+FBXkM6PpQ+w3QnMZSPeXaTeeJbG0CsTT-R9ToyDwbpD52w@mail.gmail.com>
References: 
	<CAOC+FBXkM6PpQ+w3QnMZSPeXaTeeJbG0CsTT-R9ToyDwbpD52w@mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
User-Agent: Evolution 3.48.4 (3.48.4-1.fc38) 
MIME-Version: 1.0
Archived-At: 
 <https://www.postgresql.org/message-id/2f6b87688c68ad392f0456ad796a24e798557b9b.camel%40cybertec.at>
Precedence: bulk

On Mon, 2023-09-11 at 14:26 -0700, Wells Oliver wrote:
> I don't have this view:
>=20
> ERROR: =C2=A0relation "pg_stat_statements_info" does not exist
> LINE 1: select * from pg_stat_statements_info;
> =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 ^
> But I definitely have the pg_stat_statements extension installed and quer=
y=C2=A0pg_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 =3D 'pg_stat_statements';

"pg_stat_statements_info" is not a view, but a function, so if the extensio=
n
schema is "public", try

  SELECT * FROM public.pg_stat_statements_info();

Yours,
Laurenz Albe