Run two cron jobs, each runs exacty 24 hours apart. Each gets the result of the following query:
SELECT SUM(xact_commit + xact_rollback) FROM pg_stat_database; Then subtract the result of the first cron from the second. That's the number of transactions in a 24 hr period. On Thu, Jul 9, 2015 at 4:07 PM, Scott Marlowe <scott.marl...@gmail.com> wrote: > On Thu, Jul 9, 2015 at 12:04 PM, Sheena, Prabhjot > <prabhjot.si...@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. > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- *Melvin Davidson* I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you.
