From: | "Dawid Kuroczko" <qnex42(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Cc: | "Josh Tolley" <eggyknap(at)gmail(dot)com>, pgsnmpd-devel <pgsnmpd-devel(at)pgfoundry(dot)org> |
Subject: | Re: What do people like to monitor (or in other words, what might be nice in pgsnmpd)? |
Date: | 2007-08-02 18:57:30 |
Message-ID: | 758d5e7f0708021157m41798f8apa337076d4e3c17f6@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I usually monitor blks_read and blks_hit (of block level stats), when
the latter is high
I see shared memory is doing a good job, when the former then it also
shows something
Also, database-wide number of commits and rollbacks (btw, Slony has a habit of
calling ROLLBACK when it done nothing -- I wonder if calling ROLLBACK instead
of COMMIT on a SELECT-only transaction is such a win? It certainly blurrs the
image for me. ;)
And a number of clients waiting on a lock.
By the way, one nice thing to have could be counters which record how much
time did it take to load a page into shared memory (less than 1ms, <2ms, <4ms,
<8ms, <16m and so on. Could help fine-tuning things like vacuum cost/delay
and so on. Seen it somewhere in Oraclish stats tables.
Regards,
Dawid
From | Date | Subject | |
---|---|---|---|
Next Message | Brian Mathis | 2007-08-02 19:05:11 | Re: Linux distro |
Previous Message | Andrej Ricnik-Bay | 2007-08-02 18:44:15 | Re: Linux distro |