First, let us consider what is already available. Here are some tools
that perform similar purposes to what you are proposing:
1. Transaction monitor (requires custom modifications to PostgreSQL):
http://starccm.sourceforge.net/
2. Statistics monitor (this is built in to the product):
http://www.postgresql.org/docs/current/static/monitoring-stats.html
3. You can examine the database locks here:
http://www.postgresql.org/docs/current/static/monitoring-locks.html
4. This is a very nice general purpose administration tool:
http://www.pgadmin.org/
I think something like SQL*Server's sp_who might be useful:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref
/ts_sp_wa-wz_3v8v.asp
I think intrusion detection would be nice. If (for instance) it appears
that a denial of service attack was going on, it would be good to log
the ip of the offending process.
Some more esoteric things that would be handy:
1. Index creation suggester that watches column access and notices
frequent filtered table scans that could benefit from an index. It
would give the SQL to create the suggested index. A setting could allow
automatic creation of indexes, if usage passes a user given threshold.
2. Index type suggester that notices that a hashed index would be of
benefit or a btree or an rtree or whatever.
3. Graphical tools that will depict table or query usage as a bar chart
to show where the majority of the time is going.
Probably others can think up a lot more.
Since I am not sure about the scope of your project, it is hard for me
to know what might be a good suggestion.
-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of Edson Vilhena
de Carvalho
Sent: Wednesday, March 30, 2005 7:23 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Database monitor (again)
Sorry but perhaps it is a database monitorizer that
makes the monitorization on the databases.
It's my english
Edson Carvalho
__________________________________________________
Converse com seus amigos em tempo real com o Yahoo! Messenger
http://br.download.yahoo.com/messenger/
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org