pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedMonitoring postgres
2+ messages / 2 participants
[nested] [flat]
* Monitoring postgres
@ 2008-10-06 13:22 Kellyton Campos Feitosa - GYN <Kellyton.Feitosa@gyn.politec.com.br>
0 siblings, 1 reply; 2+ messages in thread
From: Kellyton Campos Feitosa - GYN @ 2008-10-06 13:22 UTC (permalink / raw)
To: hackers@postgresql.org
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
Attachments:
image001.gif (image/gif, 2.7K) download
view image
* Re: [HACKERS] Monitoring postgres
@ 2008-10-06 15:47 Steve Crawford <scrawford@pinpointresearch.com>
parent: Kellyton Campos Feitosa - GYN <Kellyton.Feitosa@gyn.politec.com.br>
0 siblings, 0 replies; 2+ messages in thread
From: Steve Crawford @ 2008-10-06 15:47 UTC (permalink / raw)
To: Kellyton Campos Feitosa - GYN <Kellyton.Feitosa@gyn.politec.com.br>; +Cc: pgsql-admin
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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2008-10-06 15:47 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-10-06 13:22 Monitoring postgres Kellyton Campos Feitosa - GYN <Kellyton.Feitosa@gyn.politec.com.br>
2008-10-06 15:47 ` Steve Crawford <scrawford@pinpointresearch.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox