Date: Thu, 29 Jul 2021 10:10:24 -0500
From: Justin Pryzby <pryzby@telsasoft.com>
To: kenny a <kenny.pg18@gmail.com>
Cc: pgsql-performance@lists.postgresql.org
Subject: Re: Query performance !
Message-ID: <20210729151024.GF12533@telsasoft.com>
References: 
 <CABfOcveprJXDODWgD+7-LtsYzRAKJq+1sftGo5=b7YzdMsEm9g@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: 
 <CABfOcveprJXDODWgD+7-LtsYzRAKJq+1sftGo5=b7YzdMsEm9g@mail.gmail.com>
User-Agent: Mutt/1.9.4 (2018-02-28)
Archived-At: 
 <https://www.postgresql.org/message-id/20210729151024.GF12533%40telsasoft.com>
Precedence: bulk

Please don't cross post to multiple lists like this.

Cc: pgsql-sql@lists.postgresql.org, pgsql-performance@lists.postgresql.org,
	pgsql-general@lists.postgresql.org,
	pgsql-admin@lists.postgresql.org

If you're hoping for help on the -performance list, see this page and send the
"explain analyze" for this query.

https://wiki.postgresql.org/wiki/Slow_Query_Questions

On Tue, Jul 27, 2021 at 05:29:19AM +0530, kenny a wrote:
> Hi Experts,
> 
> The attached query is performing slow, this needs to be optimized to
> improve the performance.
> 
> Could you help me with query rewrite (or) on new indexes to be created to
> improve the performance?
> 
> Thanks a ton in advance for your support.