Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qfojC-00DFNO-EN for pgsql-admin@arkaria.postgresql.org; Mon, 11 Sep 2023 21:45:54 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qfojB-0039wk-41 for pgsql-admin@arkaria.postgresql.org; Mon, 11 Sep 2023 21:45:52 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qfojA-0039wW-OM for pgsql-admin@lists.postgresql.org; Mon, 11 Sep 2023 21:45:52 +0000 Received: from jakobs.com ([85.214.83.89] helo=rs.plausibolo.de) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qfoj6-0041xe-G6 for pgsql-admin@lists.postgresql.org; Mon, 11 Sep 2023 21:45:51 +0000 Received: from localhost (localhost [127.0.0.1]) by rs.plausibolo.de (Postfix) with ESMTP id 66C3238047C for ; Mon, 11 Sep 2023 23:45:45 +0200 (CEST) Received: from rs.plausibolo.de ([127.0.0.1]) by localhost (h2367442.stratoserver.net [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id HzjQjsm2J_Wv for ; Mon, 11 Sep 2023 23:45:45 +0200 (CEST) Received: from [127.0.0.1] (dynamic-046-114-107-069.46.114.pool.telefonica.de [46.114.107.69]) by rs.plausibolo.de (Postfix) with ESMTPSA id DC8C738025E for ; Mon, 11 Sep 2023 23:45:44 +0200 (CEST) Date: Mon, 11 Sep 2023 23:45:43 +0200 From: Holger Jakobs To: pgsql-admin@lists.postgresql.org Subject: Re: pg_stat_statements_info User-Agent: K-9 Mail for Android In-Reply-To: References: Message-ID: <3047F5E5-A503-44EB-9F12-642E80CCD5DC@jakobs.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=----JZFBBCZC1Y9WE0BG479K9GHH72R998 Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------JZFBBCZC1Y9WE0BG479K9GHH72R998 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable It's just not in a schema contained in you search_path Am 11=2E September 2023 23:26:22 MESZ schrieb Wells Oliver : >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=2E=2E=2E What gives? > >--=20 >Wells Oliver >wells=2Eoliver@gmail=2Ecom ------JZFBBCZC1Y9WE0BG479K9GHH72R998 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable
It's just not in a schema contai= ned in you search_path


Am 11=2E September 2023 23:26:22 MESZ schrieb Wells Oliver <wells= =2Eoliver@gmail=2Ecom>:
I don't have this view:

ERROR:  r= elation "pg_stat_statements_info" does not exist
LINE 1: select * from p= g_stat_statements_info;
             =         ^
But I definitely have the pg_stat_st= atements extension installed and query pg_stat_statements quite freque= ntly=2E=2E=2E What gives?

------JZFBBCZC1Y9WE0BG479K9GHH72R998--