Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id D06C564FD3E for ; Wed, 10 Dec 2008 07:00:46 -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 01375-06 for ; Wed, 10 Dec 2008 07:00:40 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail.synechron.com (mail.synechron.com [74.205.14.240]) by mail.postgresql.org (Postfix) with ESMTP id 3B69B64FC4F for ; Wed, 10 Dec 2008 07:00:38 -0400 (AST) Received: from [10.31.9.119] [220.225.40.2] by mail.synechron.com with ESMTP (SMTPD-9.23) id A15209C4; Wed, 10 Dec 2008 06:00:34 -0500 Message-ID: <493EF7BC.4020900@synechron.com> Date: Wed, 10 Dec 2008 04:27:00 +0530 From: AmitKumar Jain User-Agent: Thunderbird 2.0.0.18 (X11/20081105) MIME-Version: 1.0 To: s.borse@direction.biz CC: Vivek_Sharan , "pgsql-admin@postgresql.org" Subject: Re: Heavy postgres process References: <5465CC59A600E2408FFBF84350B938345031E95B93@AUSMELMBX01.ad.infosys.com> <1228905611.6187.1.camel@dss-052.dsslp.com> In-Reply-To: <1228905611.6187.1.camel@dss-052.dsslp.com> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=4.201 tagged_above=0 required=5 tests=DATE_IN_PAST_12_24=1.77, DNS_FROM_OPENWHOIS=2.431 X-Spam-Level: **** X-Archive-Number: 200812/91 X-Sequence-Number: 30924 VACUUM activiy can make any process size so much heavy... Suresh Borse wrote: > 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 > (D BA ) > ______________________________________________________ > ________________________________ _ __ > * DIRECTION SOFTWARE SOLUTIONS * > 5, Brady Gladys Plaza, 1/447, Senapati Bapat Marg, Lower Parel, M > umbai - 400 013 > Tel. : 91 22 66615000 (Ext: 35 0 ) Fax : 91 22 > 24911046 > Cell : 91 9 4 2 2 239338 Site : > www.direction.biz > ___________________________________________________ > _____________________________________ _ >