Postgres Pro
Downloads
Home   >   mailing lists

Re: How to get total count of queries hitting DB per day or per hour? - Mailing list pgsql-general

From Scott Marlowe
Subject Re: How to get total count of queries hitting DB per day or per hour?
Date
Msg-id CAOR=d=0adwX_F2UsDvraj=W6ok7KY5cGZDOb5hRwVUDr20HnEA@mail.gmail.com
Whole thread Raw
In response to How to get total count of queries hitting DB per day or per hour?  ("Sheena, Prabhjot" <Prabhjot.Singh@classmates.com>)
Responses Re: How to get total count of queries hitting DB per day or per hour?
Re: How to get total count of queries hitting DB per day or per hour?
List pgsql-general
Tree view 
On Thu, Jul 9, 2015 at 12:04 PM, Sheena, Prabhjot
<Prabhjot.Singh@classmates.com> wrote:
> Guys
>
>               Is there a way to get total count of queries hitting
> Postgresql DB(verison 9.3) per day or per hour ? I cannot turn on
> log_statement=all coz that’s too much logging for our log file to handle. Is
> there another way to do that.

If you just need totals, turn on just log_duration and then you can
grep the logs etc for that.

pgsql-general by date:

Previous
From: Vick Khera
Date:
Subject: Re: How to test SSL cert from CA?
Next
From: "Sheena, Prabhjot"
Date:
Subject: Re: How to get total count of queries hitting DB per day or per hour?