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: