Postgres Statistics

These are some queries that could be useful, extracted
from Zabbix project.

psql --version|head -n1
psql -t -c "select sum(numbackends) from pg_stat_database"
psql -t -c "select sum(xact_commit) from pg_stat_database"
psql -t -c "select sum(xact_rollback) from pg_stat_database"
psql -t -c "select sum(xact_commit) from pg_stat_database"
psql -t -c "select sum(xact_rollback) from pg_stat_database"
psql -t -c "select pg_database_size('$1')"
psql -t -c "select numbackends from pg_stat_database where datname = '$1'"
psql -t -c "select tup_returned from pg_stat_database where datname = '$1'"
psql -t -c "select tup_fetched from pg_stat_database where datname = '$1'"
psql -t -c "select tup_inserted from pg_stat_database where datname = '$1'"
psql -t -c "select tup_updated from pg_stat_database where datname = '$1'"
psql -t -c "select tup_deleted from pg_stat_database where datname = '$1'" 
psql -t -c "select tup_returned from pg_stat_database where datname = '$1'"
psql -t -c "select tup_fetched from pg_stat_database where datname = '$1'"
psql -t -c "select tup_inserted from pg_stat_database where datname = '$1'"
psql -t -c "select tup_updated from pg_stat_database where datname = '$1'"
psql -t -c "select tup_deleted from pg_stat_database where datname = '$1'"

And oid2name is very useful too, we can know what is the OID code for each
object in our database

 /usr/lib/postgresql/8.3/bin/oid2name  -d database -x