Thread: Query 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@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

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

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.