| From: | "Kellyton Campos Feitosa - GYN" <Kellyton(dot)Feitosa(at)gyn(dot)politec(dot)com(dot)br> |
|---|---|
| To: | <hackers(at)postgresql(dot)org> |
| Subject: | Monitoring postgres |
| Date: | 2008-10-06 13:22:00 |
| Message-ID: | 90A612EE1B6E4C4085ECC7DDED0A004B01EFF61D@gynserv002.gyn.politec.com.br |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin 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(dot)Feitosa(at)gyn(dot)politec(dot)com(dot)br
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Marcelo Martins | 2008-10-06 13:23:13 | Re: Shared_buffers hint |
| Previous Message | Rafael Domiciano | 2008-10-06 11:52:59 | Shared_buffers hint |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2008-10-06 13:36:17 | ctelevelsup is kind of a pain in the neck |
| Previous Message | Magnus Hagander | 2008-10-06 13:07:05 | Re: Add default_val to pg_settings |