Re: What do people like to monitor (or in other words, what might be nice in pgsnmpd)?

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: "Josh Tolley" <eggyknap(at)gmail(dot)com>
Cc: pgsnmpd-devel <pgsnmpd-devel(at)pgfoundry(dot)org>, pgsql-general(at)postgresql(dot)org
Subject: Re: What do people like to monitor (or in other words, what might be nice in pgsnmpd)?
Date: 2007-08-02 16:44:58
Message-ID: dcc563d10708020944r18d22a82x8dc0d76521893253@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'd like to know what the age of the oldest running transaction is.
i.e. hunt look out for old idle in transaction transactions that are
holding up vacuuming.

Info on the shared buffers like % used, % that hasn't been updated or
seen in x minutes / hours / days.

% used on various tablespaces

connection stats: how many clients connected, by what accounts, %
failed auths, stale connections harvested by tcp_keepalive timeouts...

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Davis 2007-08-02 16:58:33 Re: why is the LIMIT clause slowing down this SELECT?
Previous Message Gregory Stark 2007-08-02 16:35:14 Re: GiST index implementation