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
