Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 7D9CE64FD46 for ; Wed, 10 Dec 2008 06:49:32 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 99168-05 for ; Wed, 10 Dec 2008 06:49:23 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from ns1.aaaonlinux.net (NS1.AAAONLINUX.net [70.84.189.18]) by mail.postgresql.org (Postfix) with ESMTP id E88AE64FC4C for ; Wed, 10 Dec 2008 06:49:20 -0400 (AST) Received: (qmail 19944 invoked by uid 508); 10 Dec 2008 10:55:49 -0000 Received: from unknown (HELO direction.biz) (59.163.21.147) by ns1.aaaonlinux.net with SMTP; 10 Dec 2008 10:55:48 -0000 Received: from [172.16.2.20] ([172.16.2.20]) (authenticated user s.borse@direction.biz) by direction.biz (direction.biz) (MDaemon PRO v9.0.0) with ESMTP id md50000212121.msg for ; Wed, 10 Dec 2008 16:16:39 +0530 Subject: Re: Heavy postgres process From: Suresh Borse Reply-To: s.borse@direction.biz To: Vivek_Sharan Cc: "pgsql-admin@postgresql.org" In-Reply-To: <5465CC59A600E2408FFBF84350B938345031E95B93@AUSMELMBX01.ad.infosys.com> References: <5465CC59A600E2408FFBF84350B938345031E95B93@AUSMELMBX01.ad.infosys.com> Content-Type: multipart/alternative; boundary="=-MR4MhxA51LVKdBKvzgQn" Organization: DSS Date: Wed, 10 Dec 2008 16:10:11 +0530 Message-Id: <1228905611.6187.1.camel@dss-052.dsslp.com> Mime-Version: 1.0 X-Mailer: Evolution 2.10.3 (2.10.3-9.fc7) X-Authenticated-Sender: s.borse@direction.biz X-Spam-Processed: direction.biz, Wed, 10 Dec 2008 16:16:39 +0530 (not processed: spam filter heuristic analysis disabled) X-MDRemoteIP: 172.16.2.20 X-Return-Path: s.borse@direction.biz X-MDaemon-Deliver-To: pgsql-admin@postgresql.org X-MDAV-Processed: direction.biz, Wed, 10 Dec 2008 16:16:41 +0530 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200812/90 X-Sequence-Number: 30923 --=-MR4MhxA51LVKdBKvzgQn Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 8bit Hi, Try to monitor the o/p of following command. psql > select * from pg_Stat_activity; It gives all the connection detail. On Fri, 2008-09-12 at 18:12 +1000, Vivek_Sharan wrote: > Hi Admin, > > > > I’m new to this I have few queries as listed below > > > > 1) Number of connections made with a particular database. > > 2) And how can I check which process (PID) is responsible for the > connection and > > 3) what all can make a postgres process as heavy as 70-80 MB in > size > > > > Need to know these answers ASAP so I would highly appreciate if you > can find time to answer my questions. > > > > Regards, > > ~Vivek > > > > > > **************** CAUTION - Disclaimer ***************** > This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely > for the use of the addressee(s). If you are not the intended recipient, please > notify the sender by e-mail and delete the original message. Further, you are not > to copy, disclose, or distribute this e-mail or its contents to any other person and > any such actions are unlawful. This e-mail may contain viruses. Infosys has taken > every reasonable precaution to minimize this risk, but is not liable for any damage > you may sustain as a result of any virus in this e-mail. You should carry out your > own virus checks before opening the e-mail or attachment. Infosys reserves the > right to monitor and review the content of all messages sent to or from this e-mail > address. Messages sent to or from this e-mail address may be stored on the > Infosys e-mail system. > ***INFOSYS******** End of Disclaimer ********INFOSYS*** Thanks & Regards, Suresh Borse (DBA) _________________________________________________________________________________________ DIRECTION SOFTWARE SOLUTIONS 5, Brady Gladys Plaza, 1/447, Senapati Bapat Marg, Lower Parel, Mumbai - 400 013 Tel. : 91 22 66615000 (Ext: 350) Fax : 91 22 24911046 Cell : 91 9422 239338 Site : www.direction.biz _________________________________________________________________________________________ --=-MR4MhxA51LVKdBKvzgQn Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 7bit Hi,

Try to monitor the o/p of following command.

psql > select * from pg_Stat_activity;

It gives all the connection detail.


On Fri, 2008-09-12 at 18:12 +1000, Vivek_Sharan wrote:
Hi Admin,

 

I’m new to this I have few queries as listed below

 

1)     Number of connections made with a particular database.

2)     And how can I check which process (PID) is responsible for the connection and

3)     what all can make a postgres process as heavy as 70-80 MB in size

 

Need to know these answers ASAP so I would highly appreciate if you can find time to answer my questions.

 

Regards,

~Vivek

 


**************** CAUTION - Disclaimer *****************
This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely 
for the use of the addressee(s). If you are not the intended recipient, please 
notify the sender by e-mail and delete the original message. Further, you are not 
to copy, disclose, or distribute this e-mail or its contents to any other person and 
any such actions are unlawful. This e-mail may contain viruses. Infosys has taken 
every reasonable precaution to minimize this risk, but is not liable for any damage 
you may sustain as a result of any virus in this e-mail. You should carry out your 
own virus checks before opening the e-mail or attachment. Infosys reserves the 
right to monitor and review the content of all messages sent to or from this e-mail 
address. Messages sent to or from this e-mail address may be stored on the 
Infosys e-mail system.
***INFOSYS******** End of Disclaimer ********INFOSYS***
Thanks & Regards,

Suresh Borse
(DBA)
_________________________________________________________________________________________
DIRECTION SOFTWARE SOLUTIONS
5, Brady Gladys Plaza, 1/447, Senapati Bapat Marg, Lower Parel, Mumbai - 400 013
Tel.   : 91 22 66615000     (Ext: 350)             Fax    : 91 22 24911046             
Cell   : 91 9422 239338                               Site    : www.direction.biz
_________________________________________________________________________________________
--=-MR4MhxA51LVKdBKvzgQn--