Re: Query performance !

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.