Please don't cross post to multiple lists like this. Cc: pgsql-sql@xxxxxxxxxxxxxxxxxxxx, pgsql-performance@xxxxxxxxxxxxxxxxxxxx, pgsql-general@xxxxxxxxxxxxxxxxxxxx, pgsql-admin@xxxxxxxxxxxxxxxxxxxx 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.
