From: | Gino(dot)Barille(at)gmail(dot)com |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Database activity monitoring |
Date: | 2007-05-30 14:26:49 |
Message-ID: | 1180535209.334598.46020@m36g2000hse.googlegroups.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
The following is an extract of the output from the DB monitoring tool
that was delivered with the Progress DB. Sorry for the formatting but
I am hopeful you get an idea of what I am talking about. Counters
would be updated every x seconds. Is there something - commercial, non-
commercial, does not matter - available for Postgres.
This was an invaluable tool for monitoring the system both during
development and production support. Naturally the counters would
differ from that of the Progress DB.
Activity - Sampled at 05/30/107 16:21 for 2739:52:42.
Event Total Per Sec Event Total Per
Sec
Commits 3 0.0 Undos 0
0.0
Record Updates 2 0.0 Record Reads 5281
0.0
Record Creates 1 0.0 Record Deletes 0
0.0
DB Writes 8 0.0 DB Reads 160
0.0
BI Writes 4 0.0 BI Reads 70
0.0
AI Writes 0 0.0
Record Locks 27 0.0 Record Waits 0
0.0
Checkpoints 0 0.0 Buffers Flushed 0
0.0
Rec Lock Waits 0 % BI Buf Waits 0 % AI Buf Waits 0
%
Writes by APW 50 % Writes by BIW 0 % Writes by AIW 0
%
Buffer Hits 98 %
DB Size 448 K BI Size 2048 K AI Size 0
K
FR chain 83 blocks RM chain 141 blocks
Shared Memory 14176 K Segments 1
2 Servers, 0 Users (0 Local, 0 Remote, 0 Batch),2 Apws
RETURN - repeat, U - continue uninterrupted, Q - quit:
From | Date | Subject | |
---|---|---|---|
Next Message | Gino.Barille | 2007-05-30 14:32:41 | On-line / off-line trace of SQL statements presented to the Postgres SQL engine |
Previous Message | Andrew Sullivan | 2007-05-30 14:17:30 | Re: 8.3 |