Re: Database monitor (again) - Mailing list pgsql-general

From Dann Corbit
Subject Re: Database monitor (again)
Date
Msg-id D425483C2C5C9F49B5B7A41F89441547055A53@postal.corporate.connx.com
Whole thread Raw
In response to Database monitor (again)  (Edson Vilhena de Carvalho <edson_jvc@yahoo.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: "Randy How"
Date:
Subject: DNN Postgres Data Provider
Next
From: Michael Fuhr
Date:
Subject: Re: plpgsql array initialization, what's the story?