|
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 |
