Postgres Pro
Downloads
Home   >   mailing lists

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

From aditya desai
Subject Re: View taking time to show records
Date
Msg-id CAN0SRDFb6Su_EiedAK7xgWAwtHvXhPYedr1w+559jp7Hu=2vVQ@mail.gmail.com
Whole thread Raw
In response to View taking time to show records  ("Kumar, Mukesh" <MKumar@peabodyenergy.com>)
List pgsql-performance
Tree view
Hi,
1. Have you tried creating indexes on columns for which it is showing sequential scans?
2. In my experience if the view is referring some other view inside it, it is advisable to directly query on tables instead on child view.
3. This table 'so_vendor_address_base' definitely needs indexing to remove sequentials scans.

Regards,
AD.


On Fri, Mar 25, 2022 at 3:35 PM Kumar, Mukesh <MKumar@peabodyenergy.com> wrote:

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: "Kumar, Mukesh"
Date:
Subject: View taking time to show records
Next
From: hubert depesz lubaczewski
Date:
Subject: Re: View taking time to show records