Skip site navigation (1) Skip section navigation (2)

Monitoring PostgreSQL Process

From: "Aaron Bono" <postgresql(at)aranya(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Monitoring PostgreSQL Process
Date: 2006-11-22 05:49:48
Message-ID: bf05e51c0611212149q340c54cdj8763d117ae9f43eb@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
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
==================================================================

Responses

pgsql-admin by date

Next:From: Tomeh, HusamDate: 2006-11-22 18:02:08
Subject: Re: Monitoring PostgreSQL Process
Previous:From: Richard Broersma JrDate: 2006-11-22 02:01:42
Subject: Re: Fw: postgres database crash

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group