| From: | Justin Pryzby <pryzby(at)telsasoft(dot)com> |
|---|---|
| To: | "Kumar, Mukesh" <MKumar(at)peabodyenergy(dot)com> |
| Cc: | pgsql-performance(at)postgresql(dot)org, MUKESH KUMAR <mukesh(dot)kumar14(at)tcs(dot)com> |
| Subject: | Re: Query Tunning related to function |
| Date: | 2022-04-17 03:13:15 |
| Message-ID: | 20220417031315.GY26620@telsasoft.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Thu, Apr 14, 2022 at 06:03:33AM +0000, Kumar, Mukesh wrote:
> We are running the below query in PostgreSQL and its taking approx. 8 to 9 sec to run the query.
>
> Query - 1 ...
>
> The explain plan and other details are placed at below link for more information. We have checked the indexes on column but in the explain plan it is showing as Seq Scan which we have to find out.
>
> https://explain.depesz.com/s/Jsiw#stats
There's a list of information to provide in the postgres wiki, and people here
sent you a link to that wiki page on Feb 27, Mar 1, and Apr 12. Your problem
report is still missing a lot of that information. Asking for it piece by
piece would be tedious.
--
Justin
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2022-04-17 16:09:09 | Re: Query Planner not taking advantage of HASH PARTITION |
| Previous Message | Kumar, Mukesh | 2022-04-15 16:46:16 | RE: Query Tunning related to function |