Database activity monitoring
От | Gino.Barille@gmail.com |
---|---|
Тема | Database activity monitoring |
Дата | |
Msg-id | 1180535209.334598.46020@m36g2000hse.googlegroups.com обсуждение исходный текст |
Ответы |
Re: Database activity monitoring
|
Список | 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:
В списке pgsql-general по дате отправления: