Monitoring postgres

Kellyton Campos Feitosa - GYN wrote:

Dears,

I need monitor a postgres database, but I don’t know which tool to use.

The tool need perform the below actions

1. show transactions pendents
2. show the statistics per session actives
3. show the statistics per database
4. show metrics per session and database
5. show rows locks
6. show slow activities statements (SELECT, INSERT, UPDATE, DELETE)
7. to allow set a trace to a specific session, similar the tool
dbms_system.SET_SQL_TRACE_IN_SESSION include in Oracle Database

This is better asked in the administration (or general) mailing list. I
don't know of a single magic-bullet tool that does everything you list
but you might try with the PostgreSQL docs starting with the monitoring
and logging sections.
http://www.postgresql.org/docs/8.3/interactive/monitoring.html
http://www.postgresql.org/docs/8.3/interactive/runtime-config-logging.html

Then Google "postgresql monitoring tool" and see what's available
including commercial products from EnterpriseDB:
http://www.enterprisedb.com/products/postgres_plus_as.do (dig into the
docs and see what their monitoring stuff does)
and monitoring tools such as Hyperic that have PostgreSQL plugins:
http://www.hyperic.com/products/managed/postgresql-management.htm

Cheers,
Steve