Performance issues while running select sql query

2018-04-28 Thread David G. Johnston
On Saturday, April 28, 2018, 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

Re: Performance issues while running select sql query

2018-04-28 Thread Kaushal Shriyan
On Sun, Apr 29, 2018 at 10:33 AM, Kaushal Shriyan wrote: > > > On Sun, Apr 29, 2018 at 10:10 AM, Justin Pryzby > wrote: > >> 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 >> > wit

Re: Performance issues while running select sql query

2018-04-28 Thread Kaushal Shriyan
On Sun, Apr 29, 2018 at 10:10 AM, Justin Pryzby wrote: > 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 > > per

Re: Performance issues while running select sql query

2018-04-28 Thread Justin Pryzby
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 *t

Performance issues while running select sql query

2018-04-28 Thread Kaushal Shriyan
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? The select sql query ar