Date: Thu, 3 May 2007 18:16:46 +0200
From: Tobias Brox <tobias@nordicbet.com>
To: Alexander Staubo <alex@purefiction.net>
Cc: Greg Smith <gsmith@gregsmith.com>,
	pgsql-performance@postgresql.org
Subject: Re: pg_stat_* collection
Message-ID: <20070503161646.GA14876@oppetid.no>
References: <Pine.GSO.4.64.0705031039390.12098@westnet.com>
	<88daf38c0705030752sa4e38c3h78bcb64a651e6b1a@mail.gmail.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <88daf38c0705030752sa4e38c3h78bcb64a651e6b1a@mail.gmail.com>
Organization: Group Nordicbet
User-Agent: Mutt/1.5.9i

[Alexander Staubo - Thu at 04:52:55PM +0200]
> I have been considering tarring them up as a proper release at some
> point. Anyone interested?

Yes.

Eventually I have my own collection as well:

db_activity - counts the number of (all, slow, very slow, stuck "idle in transaction") queries in progress; this is one of the better indicators on how busy/overloaded the database is.

(I also have a separate script dumping the contents from
pg_stat_activity to a log file, which I frequentlymonitor by "tail -F").

db_commits + db_rollbacks pr database - I'm not sure if those are useful
for anything, will eventually remove them.  Maybe nice to be able to
compare the activity between different databases running on the same
host, if they are comparable.

db_connections - num of connections compared to max connections.  Useful
for alarms.

db_hanging_transactions - age of oldest transaction.  Useful for alarms,
since hanging transactions can be very bad for the db performance.

db_locks - monitors the number of locks.  I've never actually needed
this for anything, maybe I should remove it.

db_num_backends - number of backends, sorted by databases.  Probably not
so useful.

db_space (one for each database) - monitors space usage, found this
script through google.

db_xid_wraparound - gives alarms if the databases aren't beeing
vacuumed.