Postgres Pro
Downloads
Home   >   mailing lists

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

From Justin Pryzby
Subject Re: Performance issues while running select sql query
Date
Msg-id 20180429044019.GO20071@telsasoft.com
Whole thread Raw
In response to Performance issues while running select sql query  (Kaushal Shriyan <kaushalshriyan@gmail.com>)
Responses Re: Performance issues while running select sql query  (Kaushal Shriyan <kaushalshriyan@gmail.com>)
List pgsql-performance
Tree view 
On Sun, Apr 29, 2018 at 10:05:23AM +0530, Kaushal Shriyan 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?

Send the output of "explain(analyze,buffers)" for the query?

Justin

pgsql-performance by date:

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