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
columnbut 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