Home > mailing lists

Need help on Query Tunning and Not using the Index Scan - Mailing list pgsql-performance

From	Kumar, Mukesh
Subject	Need help on Query Tunning and Not using the Index Scan
Date	May 20, 2022 10:37:44
Msg-id	CH0P221MB047466D1A74C13298CD84B30DED39@CH0P221MB0474.NAMP221.PROD.OUTLOOK.COM Whole thread Raw
Responses	Re: Need help on Query Tunning and Not using the Index Scan
List	pgsql-performance

Hi Team,

We are facing an issue in running the query which takes at least 30 sec to run in PostgreSQL.

We have tried to create the indexes and done the maintenance and still that query is taking same time.

Below are the explain plan for the query.

We have noticed that maximum time it is takin is do a Seq Scan on Table ps_delay_statistic which consist of approx. 35344812 records .

Can anyone please help on the above issue.

Thanks and Regards,

Mukesh Kumar

From: Justin Pryzby
Date: 13 May 2022, 07:08:28
Subject: Re: DB connection issue suggestions

From: aditya desai
Date: 20 May 2022, 11:27:50
Subject: Selecting RAM and CPU based on max_connections