Thread: Re: [HACKERS] 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