| 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: | Whole Thread | Raw Message | 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 |