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.