agora inbox for pgsql-performance@postgresql.org
help / color / mirror / Atom feedFrom: Justin Pryzby <pryzby@telsasoft.com>
To: kenny a <kenny.pg18@gmail.com>
Cc: pgsql-performance@lists.postgresql.org
Subject: Re: Query performance !
Date: Thu, 29 Jul 2021 10:10:24 -0500
Message-ID: <20210729151024.GF12533@telsasoft.com> (raw)
In-Reply-To: <CABfOcveprJXDODWgD+7-LtsYzRAKJq+1sftGo5=b7YzdMsEm9g@mail.gmail.com>
References: <CABfOcveprJXDODWgD+7-LtsYzRAKJq+1sftGo5=b7YzdMsEm9g@mail.gmail.com>
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.
view thread (48+ messages) latest in thread
Message-ID: <20210729151024.GF12533@telsasoft.com>
Permalink: ../20210729151024.GF12533@telsasoft.com/
Also on: postgresql.org/message-id/20210729151024.GF12533@telsasoft.com
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: pryzby@telsasoft.com, kenny.pg18@gmail.com, pgsql-performance@lists.postgresql.org
Subject: Re: Query performance !
In-Reply-To: <20210729151024.GF12533@telsasoft.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox