Re: Query performance !

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: kenny a <kenny(dot)pg18(at)gmail(dot)com>
Cc: pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: Re: Query performance !
Date: 2021-07-27 17:18:15
Message-ID: 20210727171815.GA19767@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Tue, Jul 27, 2021 at 10:44:03PM +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. 

Uh, there is no query, and I think you should read this:

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

--
Bruce Momjian <bruce(at)momjian(dot)us> https://momjian.us
EDB https://enterprisedb.com

If only the physical world exists, free will is an illusion.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Justin Pryzby 2021-07-28 02:27:33 Re: Performance of lateral join
Previous Message kenny a 2021-07-27 17:14:03 Query performance !