Postgres Pro
Downloads
Home   >   mailing lists

Slow Running Queries in Azure PostgreSQL - Mailing list pgsql-performance

From Kumar, Mukesh
Subject Slow Running Queries in Azure PostgreSQL
Date
Msg-id CH0P221MB0474E218EBD5515523B737EFDE3B9@CH0P221MB0474.NAMP221.PROD.OUTLOOK.COM
Whole thread Raw
Responses Re: Slow Running Queries in Azure PostgreSQL  (Justin Pryzby <pryzby@telsasoft.com>)
List pgsql-performance
Tree view

 

Hi Team,

 

Greetings,

 

We are facing an issue with long running queries in PostgreSQL Database. We recently migrated the database from Oracle to PostgreSQL and we found that there are approx. 4 to 5 queries which was running in oracle in 5 mins and it is taking more than 50 mins in PostgreSQL. We checked every parameter in PostgreSQL, but it is not helping.

 

I am attaching the query and explain plan with Analyze option in the attachment, but it is not helping.

 

Request you to please help and assist on this as it is hampering the productivity and effecting the business.

 

Thanks and Regards,

Mukesh Kumar

 

Attachment

pgsql-performance by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: Poor performance PostgreSQL 13/ PostGIS 3.x
Next
From: Justin Pryzby
Date:
Subject: Re: Slow Running Queries in Azure PostgreSQL