Postgres Pro
Downloads
Home   >   mailing lists

Monitoring PostgreSQL Process - Mailing list pgsql-admin

From Aaron Bono
Subject Monitoring PostgreSQL Process
Date
Msg-id bf05e51c0611212149q340c54cdj8763d117ae9f43eb@mail.gmail.com
Whole thread Raw
Responses Re: Monitoring PostgreSQL Process  ("Tomeh, Husam" <htomeh@firstam.com>)
Re: Monitoring PostgreSQL Process  (adey <adey11@gmail.com>)
List pgsql-admin
Tree view
I have a couple processes/connections to one of our databases that appears to be eating up most of the CPU and we are trying to determine what these processes are doing that is taking so much CPU time.

Is there a way to monitor the SQL being run for a specific connection/process?

We are using PostgreSQL 8.1.5 on CentOS Linux.

Thanks,
Aaron

--
==================================================================
   Aaron Bono
   Aranya Software Technologies, Inc.
   http://www.aranya.com
   http://codeelixir.com
==================================================================

pgsql-admin by date:

Previous
From: Richard Broersma Jr
Date:
Subject: Re: Fw: postgres database crash
Next
From: "Tomeh, Husam"
Date:
Subject: Re: Monitoring PostgreSQL Process