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 1qfoR5-00DE87-Co for pgsql-admin@arkaria.postgresql.org; Mon, 11 Sep 2023 21:27:11 +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 1qfoR3-0034yQ-Mx for pgsql-admin@arkaria.postgresql.org; Mon, 11 Sep 2023 21:27:09 +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 1qfoR3-0034yC-AB for pgsql-admin@lists.postgresql.org; Mon, 11 Sep 2023 21:27:09 +0000 Received: from mail-ej1-x636.google.com ([2a00:1450:4864:20::636]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qfoQv-0041oO-T7 for pgsql-admin@postgresql.org; Mon, 11 Sep 2023 21:27:07 +0000 Received: by mail-ej1-x636.google.com with SMTP id a640c23a62f3a-99c1c66876aso626040066b.2 for ; Mon, 11 Sep 2023 14:27:01 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20221208; t=1694467619; x=1695072419; darn=postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=jCcGrjw/m7Thxnfi3WjQnVrRsYRiHKT77F9/pLdfxMY=; b=R+vwa7ioTGaUemZyP6lue+/NHynvKiNB2O9VKZJbyyLwDIG9e3CyAr/RpqjC/nfY7M jEWvIX4cUDQ52fygoDx75VfAbgu5/7IoYzvrijG1qsomRUPclnPxQA+JP7wpRG+ZesQX S07cW8Euk9c+vyVy8IVyYhrLLXCHRMzlZO0vLL/BQhMDelR9QBrfv+BsqWedg7azDcqj BitwTkft6bKGs1aJ3X4fBg/PWBBKkp5BM0yrwEurn/eUVJePRh3feez9Ye/sZTxqX/ij EAtGKuWaAtQPkcu/WBE9sMjT0KYm45s/KGsaiKRd7Muc+QKPqMc3FLtAZAOEyZglMMlm npWQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1694467619; x=1695072419; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=jCcGrjw/m7Thxnfi3WjQnVrRsYRiHKT77F9/pLdfxMY=; b=A5qP8FY9F/0EscIFqVTL20nzvj68+g3Mj8nfpSNYGj7KeIjMpII62nKvmH12Am7iC0 eTXzNzLYJIc2eO8t7e57cVp83ouew23lfYjgWrox+xki39sFWmLcBbConK22FNmUucXx 4Cqbx7L2S5A9mR7HOapM4LesAwven02zJKDJ+CbjGPN46js5534h2pklKSoMrrDsnuPp mohXtkVSjlwr9oz5d96sW3jUOx6netNYAc1OaFK1SYXjqoLsUEl9ekZo3ZwEy4bX3yQO MaOJmcWoNnX6yakjZRpS2A8vsoS0+i7V26m+53K5VVQLWoOJpVB3wgd1g3cz+kpfVZIq qLWg== X-Gm-Message-State: AOJu0YwX0MmrOLBzjoPIIGlsXWsaz078s0GI41E8EHoedJuyqv85lD/d ZKXi28WPV5oWLU/+NHKS+JqCoT39SCXAowN4ofJQOCU9g2I= X-Google-Smtp-Source: AGHT+IEnbyQNJsCOIIIVN/IvRQ2CJTX3pNdvmkjUCnmpDo6vDhRfJXNpH9k637quI47QkpPhfXe7eAZ1FC64r5kh88c= X-Received: by 2002:a17:906:51c2:b0:9a1:beb2:1cb8 with SMTP id v2-20020a17090651c200b009a1beb21cb8mr10336637ejk.39.1694467618979; Mon, 11 Sep 2023 14:26:58 -0700 (PDT) MIME-Version: 1.0 From: Wells Oliver Date: Mon, 11 Sep 2023 14:26:22 -0700 Message-ID: Subject: pg_stat_statements_info To: pgsql-admin Content-Type: multipart/alternative; boundary="00000000000083423306051bfc0f" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --00000000000083423306051bfc0f Content-Type: text/plain; charset="UTF-8" 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? -- Wells Oliver wells.oliver@gmail.com --00000000000083423306051bfc0f Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
I don't have this view:

ERROR: =C2= =A0relation "pg_stat_statements_info" does not exist
LINE 1: s= elect * 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 query=C2=A0pg_stat_statement= s quite frequently... What gives?

--
Wells Oliver
wells.oliver@gmail= .com
--00000000000083423306051bfc0f--