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

From Scott Marlowe
Subject Re: What do people like to monitor (or in other words, what might be nice in pgsnmpd)?
Date
Msg-id dcc563d10708020944r18d22a82x8dc0d76521893253@mail.gmail.com
Whole thread Raw
In response to What do people like to monitor (or in other words, what might be nice in pgsnmpd)?  ("Josh Tolley" <eggyknap@gmail.com>)
Responses Re: What do people like to monitor (or in other words, what might be nice in pgsnmpd)?  ("Dawid Kuroczko" <qnex42@gmail.com>)
List 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...

pgsql-general by date:

Previous
From: Gregory Stark
Date:
Subject: Re: GiST index implementation
Next
From: Tony Caduto
Date:
Subject: Re: pgTray - win32 tray tool for monitoring PostgreSQL service