Monitoring postgres - Mailing list pgsql-hackers

From Kellyton Campos Feitosa - GYN
Subject Monitoring postgres
Date
Msg-id 90A612EE1B6E4C4085ECC7DDED0A004B01EFF61D@gynserv002.gyn.politec.com.br
Whole thread Raw
Responses Re: Monitoring postgres
List pgsql-hackers

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

 

 

            Thanks

 

 

 

Kellyton Campos Feitosa

Analista de Suporte - DBA

Politec Global IT Services

+55(62) 3219-3284

Kellyton.Feitosa@gyn.politec.com.br

www.politec.com.br

 

 

 

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: ctelevelsup is kind of a pain in the neck
Next
From: Tom Lane
Date:
Subject: Shouldn't pg_settings.enumvals be array of text?