From: Tobias Brox <tobias@nordicbet.com>
To: Alexander Staubo <alex@purefiction.net>
Cc: Greg Smith <gsmith@gregsmith.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: pg_stat_* collection
Date: Thu, 3 May 2007 18:16:46 +0200
Message-ID: <20070503161646.GA14876@oppetid.no> (raw)
In-Reply-To: <88daf38c0705030752sa4e38c3h78bcb64a651e6b1a@mail.gmail.com>
References: <Pine.GSO.4.64.0705031039390.12098@westnet.com>
<88daf38c0705030752sa4e38c3h78bcb64a651e6b1a@mail.gmail.com>
[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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: tobias@nordicbet.com, alex@purefiction.net, gsmith@gregsmith.com
Subject: Re: pg_stat_* collection
In-Reply-To: <20070503161646.GA14876@oppetid.no>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox