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: (view raw or whole 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

We are using PostgreSQL 8.1.5 on CentOS Linux.


   Aaron Bono
   Aranya Software Technologies, Inc.


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-2015 The PostgreSQL Global Development Group