| From: | Justin Pryzby <pryzby(at)telsasoft(dot)com> |
|---|---|
| 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-29 15:10:24 |
| Message-ID: | 20210729151024.GF12533@telsasoft.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Please don't cross post to multiple lists like this.
Cc: pgsql-sql(at)lists(dot)postgresql(dot)org, pgsql-performance(at)lists(dot)postgresql(dot)org,
pgsql-general(at)lists(dot)postgresql(dot)org,
pgsql-admin(at)lists(dot)postgresql(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Daniel Westermann (DWE) | 2021-07-30 07:12:17 | Performance issue with thousands of calls to procedures and functions? |
| Previous Message | ldh@laurent-hasson.com | 2021-07-28 20:12:53 | RE: Big performance slowdown from 11.2 to 13.3 |