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

Thu, 09 Jul 2015 11:12:12 -0700 

On 7/9/2015 1:04 PM, Sheena, Prabhjot 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.

Thanks

Prabhjot



My collectd config:

<Plugin postgresql>
    <Query ttlbackends>
Statement "SELECT sum(numbackends) AS count, sum(xact_commit) as ttlcommit FROM pg_stat_database;" 
        <Result>
            Type "pg_numbackends"
            ValuesFrom "count"
        </Result>
        <Result>
            Type "pg_xact"
            ValuesFrom "ttlcommit"
        </Result>
    </Query>

    <Database postgres>
        #Interval 60
        Host "/tmp"
        Port "5432"
        SSLMode "disable"
        Query ttlbackends
    </Database>
</Plugin>



--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to