Re: How to get total count of queries hitting DB per day or per hour?

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: How to get total count of queries hitting DB per day or per hour?
Дата
Msg-id CAOR=d=0adwX_F2UsDvraj=W6ok7KY5cGZDOb5hRwVUDr20HnEA@mail.gmail.com
обсуждение исходный текст
Ответ на How to get total count of queries hitting DB per day or per hour?  ("Sheena, Prabhjot" <Prabhjot.Singh@classmates.com>)
Ответы Re: How to get total count of queries hitting DB per day or per hour?  ("Sheena, Prabhjot" <Prabhjot.Singh@classmates.com>)
Re: How to get total count of queries hitting DB per day or per hour?  (Melvin Davidson <melvin6925@gmail.com>)
Список pgsql-general
Дерево обсуждения 
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 по дате отправления:

Предыдущее
От: Vick Khera
Дата:
Сообщение: Re: How to test SSL cert from CA?
Следующее
От: "Sheena, Prabhjot"
Дата:
Сообщение: Re: How to get total count of queries hitting DB per day or per hour?