Postgres Pro
Downloads
Home   >   mailing lists

Performance issues while running select sql query - Mailing list pgsql-performance

From David G. Johnston
Subject Performance issues while running select sql query
Date
Msg-id CAKFQuwYBtGfcaJscYNKft8C+FTKO9N1xy_Le6tTj26ggwLSC+Q@mail.gmail.com
Whole thread Raw
In response to Performance issues while running select sql query  (Kaushal Shriyan <kaushalshriyan@gmail.com>)
List pgsql-performance
Tree view
On Saturday, April 28, 2018, Kaushal Shriyan <kaushalshriyan@gmail.com> wrote:
Hi,

I am running postgresql db server 9.4.14 on AWS of C4.2xlarge instance type with 500 GB volume of volume type io1 with 25000 IOPS and I am seeing performance issues. The sql query response takes around 127713.413 ms time. Is there a way to find out the bottleneck?

I would suggest reading the following and providing some additional details, in particular your table and/or view definitions.  Specifically I'd be looking for indexes on "serorgid", your apparent partitioning setup, and your use of indexes in general.


You may also wish to attach the explain output as a text file.

David J.

pgsql-performance by date:

Previous
From: Kaushal Shriyan
Date:
Subject: Re: Performance issues while running select sql query
Next
From: Justin Pryzby
Date:
Subject: Re: Performance issues while running select sql query