Received: from localhost (pluto.hub.org [200.46.204.4]) by postgresql.org (Postfix) with ESMTP id 44C249FA463 for ; Wed, 22 Nov 2006 09:32:52 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.4]) (amavisd-new, port 10024) with ESMTP id 94543-04 for ; Wed, 22 Nov 2006 09:32:37 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.172]) by postgresql.org (Postfix) with ESMTP id 5875D9FA265 for ; Wed, 22 Nov 2006 09:32:46 -0400 (AST) Received: by ug-out-1314.google.com with SMTP id k3so135608ugf for ; Wed, 22 Nov 2006 05:32:44 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:sender:to:subject:mime-version:content-type:x-google-sender-auth; b=FhRdUJYVzkSonN2Fn3y2TFn6zWwuLGZjUnWvAknIuriORDJq+9Jp25fsVqM2YvUEs2WrkdMzr0r5ifjHRkfpnDaQKKXIAl6Vbe9jRFE5UYlAh/B3zLZK4H+NwgjyyiuPdFyPAmsj29TFp+MMSmQu4LF0qdTYwZ1Q6XuQhnR212Q= Received: by 10.78.75.15 with SMTP id x15mr7343795hua.1164174588512; Tue, 21 Nov 2006 21:49:48 -0800 (PST) Received: by 10.78.136.6 with HTTP; Tue, 21 Nov 2006 21:49:48 -0800 (PST) Message-ID: Date: Tue, 21 Nov 2006 23:49:48 -0600 From: "Aaron Bono" To: pgsql-admin@postgresql.org Subject: Monitoring PostgreSQL Process MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_54075_20580278.1164174588428" X-Google-Sender-Auth: 73f785517844429e X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/193 X-Sequence-Number: 23720 ------=_Part_54075_20580278.1164174588428 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline 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 ================================================================== ------=_Part_54075_20580278.1164174588428 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline 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
================================================================== ------=_Part_54075_20580278.1164174588428--