Database activity monitoring

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:

Responses

Browse pgsql-general by date

  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