I did try that but that’s too much logging as well. Prabhjot Singh Database Administrator CLASSMATES 1501 4th Ave., Suite 400 Seattle, WA 98101 206.301.4937 o 206.301.5701 f -----Original Message----- From: Scott Marlowe [mailto:scott.marlowe@xxxxxxxxx] Sent: Thursday, July 9, 2015 1:07 PM To: Sheena, Prabhjot Cc: pgsql-general@xxxxxxxxxxxxxx Subject: Re: How to get total count of queries hitting DB per day or per hour? On Thu, Jul 9, 2015 at 12:04 PM, Sheena, Prabhjot <Prabhjot.Singh@xxxxxxxxxxxxxx> 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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
