Re: Performance issues while running select sql query

From: Justin Pryzby <pryzby(at)telsasoft(dot)com>
To: Kaushal Shriyan <kaushalshriyan(at)gmail(dot)com>
Cc: pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: Re: Performance issues while running select sql query
Date: 2018-04-29 04:40:19
Message-ID: 20180429044019.GO20071@telsasoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Kaushal Shriyan 2018-04-29 05:03:11 Re: Performance issues while running select sql query
Previous Message Kaushal Shriyan 2018-04-29 04:35:23 Performance issues while running select sql query