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