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 1rg6s3-004ECN-1A for pgsql-admin@arkaria.postgresql.org; Fri, 01 Mar 2024 17:40:31 +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 1rg6s0-00EI0d-Bq for pgsql-admin@arkaria.postgresql.org; Fri, 01 Mar 2024 17:40:28 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rg6s0-00EI0V-16 for pgsql-admin@lists.postgresql.org; Fri, 01 Mar 2024 17:40:28 +0000 Received: from mail-cy.bbox.fr ([194.158.98.48]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rg6ry-002Hts-1M for pgsql-admin@lists.postgresql.org; Fri, 01 Mar 2024 17:40:27 +0000 Received: from mail.jpp.fr (unknown [176.187.84.182]) by mail-cy.bbox.fr (Postfix) with ESMTP id 5ADF238; Fri, 1 Mar 2024 18:40:24 +0100 (CET) Received: from localhost (localhost [127.0.0.1]) by mail.jpp.fr (Postfix) with ESMTP id 48C37C0084; Fri, 1 Mar 2024 18:40:24 +0100 (CET) Received: from mail.jpp.fr ([127.0.0.1]) by localhost (mail.jpp.fr [127.0.0.1]) (amavis, port 10032) with ESMTP id MFUdPLv8349y; Fri, 1 Mar 2024 18:40:24 +0100 (CET) Received: from localhost (localhost [127.0.0.1]) by mail.jpp.fr (Postfix) with ESMTP id 14CE6C0087; Fri, 1 Mar 2024 18:40:24 +0100 (CET) X-Virus-Scanned: amavis at jpp.fr Received: from mail.jpp.fr ([127.0.0.1]) by localhost (mail.jpp.fr [127.0.0.1]) (amavis, port 10026) with ESMTP id T8eoz9Npkrz3; Fri, 1 Mar 2024 18:40:23 +0100 (CET) Received: from mail.jpp.fr (localhost [127.0.0.1]) by mail.jpp.fr (Postfix) with ESMTP id 948BEC0084; Fri, 1 Mar 2024 18:40:23 +0100 (CET) Date: Fri, 1 Mar 2024 18:40:23 +0100 (CET) From: Jean-Paul POZZI To: Harish Harish Cc: pgsql-admin Message-ID: <1883261458.1984.1709314823544.JavaMail.zextras@jpp.fr> In-Reply-To: References: Subject: RE: Missing indexes MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="=_26141a2a-088d-41f3-979f-65a810ec3d91" X-Originating-IP: [192.168.2.8] X-Mailer: Carbonio 24.1.0_ZEXTRAS_202401 (CarbonioWebClient - Firefox 115.0 (Linux)/24.1.0_ZEXTRAS_202401 carbonio 20240104-1254 FOSS) Thread-Topic: Missing indexes Thread-Index: ++FZEvFHdQ+lWGam9aUh+qiAyx5rVQ== X-VADE-SPAMSTATE: clean X-VADE-SPAMSCORE: 0 X-VADE-SPAMCAUSE: gggruggvucftvghtrhhoucdtuddrgedvledrhedugddutddvucetufdoteggodetrfdotffvucfrrhhofhhilhgvmecuuefqfggjifgfgffupdcuqfgfvfdpucggtfgfnhhsuhgsshgtrhhisggvnecuuegrihhlohhuthemuceftddtnecunecujfgurhepfffhvfevkfgjfhfugggtihfothesrgdttgerredtjeenucfhrhhomheplfgvrghnqdfrrghulhcurffqkggkkfcuoehjphdrphhoiiiiihesihiiiihophdrnhgvtheqnecuggftrfgrthhtvghrnhepteegteetueeuhfejffeiveeiiefffeeuhfethfdtheehkeeujefgledvfeffleevnecukfhppedujeeirddukeejrdekgedrudekvddpudelvddrudeikedrvddrkeenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepihhnvghtpedujeeirddukeejrdekgedrudekvddphhgvlhhopehmrghilhdrjhhpphdrfhhrpdhmrghilhhfrhhomhepjhhprdhpohiiiihisehiiiiiohhprdhnvghtpdhnsggprhgtphhtthhopedvpdhrtghpthhtohephhhptheftddtleesghhmrghilhdrtghomhdprhgtphhtthhopehpghhsqhhlqdgrughmihhnsehlihhsthhsrdhpohhsthhgrhgvshhqlhdrohhrgh List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --=_26141a2a-088d-41f3-979f-65a810ec3d91 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Hello, Some examples of the "bad" sql text should be interesting ... Regards De: "Harish Harish" =C3=80: "undefined" Envoy=C3=A9: vendredi 1 mars 2024 17:39 Objet: Missing indexes Dear Admins, I need help. We are on Postgres 10. and have a feeling there are some index= es missing wich is causing performance=C2=A0issue Please help me find the missing index within=C2=A0 PostgreSQl 10. Your timely help and support=C2=A0is much appreciated. Best=C2=A0Regards, Hari --=_26141a2a-088d-41f3-979f-65a810ec3d91 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable
Hello,
 
Some examples of the "bad" sql text should be = interesting ...
 

Regards

De: "Harish Harish" <hpt3009@gmai= l.com>
=C3=80: "undefined" <pgsql-admin@lists.po= stgresql.org>
Envoy=C3=A9: vendredi 1 mars 2024 17:= 39
Objet: Missing indexes

Dear Admins,
 
I need help. We are on Postgres 10. and have a feeling there are some = indexes missing wich is causing performance issue
 
Please help me find the missing index within  PostgreSQl 10.
 
Your timely help and support is much appreciated.
 
Best Regards,
Hari
--=_26141a2a-088d-41f3-979f-65a810ec3d91--