polling pg_stat_activity

gistfile1.txt

#!/bin/bash

NUMMIN=$(($1 * 2 + 10))
CURMIN=0

while [ $CURMIN -lt $NUMMIN ] 
do

    psql -q -t -A -c "SELECT now() as ts, state, client_addr, count(*) as num_conn, avg(now() - query_start) as avg_query, \
max(now() - query_start) as max_query, avg(now() - xact_start) as avg_xact, \
max(now() - xact_start) as max_xact FROM pg_stat_activity GROUP BY state, client_addr" >> connstats.log
 
    sleep 30
    let CURMIN=CURMIN+1 

done

exit 0