Postgres Pro
Downloads
Home   >   mailing lists

View taking time to show records - Mailing list pgsql-performance

From Kumar, Mukesh
Subject View taking time to show records
Date
Msg-id CH0P221MB04748BF130CDFF2625EDB396DE199@CH0P221MB0474.NAMP221.PROD.OUTLOOK.COM
Whole thread Raw
Responses Re: View taking time to show records  (aditya desai <admad123@gmail.com>)
Re: View taking time to show records  (hubert depesz lubaczewski <depesz@depesz.com>)
Re: View taking time to show records  (Laurenz Albe <laurenz.albe@cybertec.at>)
List pgsql-performance
Tree view

Hi Team and All ,

 

Greeting for the day.

 

We have recently migrated from Oracle to PostgreSQL on version 11.4 on azure postgres PaaS instance.

 

There is 1 query which is taking approx. 10 secs in Oracle and when we ran the same query it is taking approx. 1 min

 

Can anyone suggest to improve the query as from application end 1 min time is not accepted by client.

 

Please find the query and explain analyze report from below link

 

https://explain.depesz.com/s/RLJn#stats

 

 

Thanks and Regards,

Mukesh Kumar

 

pgsql-performance by date:

Previous
From: Justin Pryzby
Date:
Subject: Re: Performance issue post upgrade on Version 13 - Incorrect Estimation Cost choosing Hash Aggregate-Nested Left Loop Join
Next
From: aditya desai
Date:
Subject: Re: View taking time to show records