On Sun, Apr 29, 2018 at 7:48 PM, Justin Pryzby wrote:
> On Sun, Apr 29, 2018 at 10:05:23AM +0530, Kaushal Shriyan wrote:
> > # SELECT serorgid,appname,sum(message_count) AS mtrc0,date_trunc('day',
> > client_received_start_timestamp at time zone '+5:30:0')::timestamp
> without
> > time zone AS ti
On Sun, Apr 29, 2018 at 10:05:23AM +0530, Kaushal Shriyan wrote:
> # SELECT serorgid,appname,sum(message_count) AS mtrc0,date_trunc('day',
> client_received_start_timestamp at time zone '+5:30:0')::timestamp without
> time zone AS time_unit FROM analytics."test.prod.fact" WHERE
> client_received_st
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
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
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
