From: AmitKumar Jain <amitjain@synechron.com>
To: s.borse@direction.biz
Cc: Vivek_Sharan <Vivek_Sharan@infosys.com>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Heavy postgres process
Date: Wed, 10 Dec 2008 04:27:00 +0530
Message-ID: <493EF7BC.4020900@synechron.com> (raw)
In-Reply-To: <1228905611.6187.1.camel@dss-052.dsslp.com>
References: <5465CC59A600E2408FFBF84350B938345031E95B93@AUSMELMBX01.ad.infosys.com>
<1228905611.6187.1.camel@dss-052.dsslp.com>
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 <http://www.direction.biz/;
> ___________________________________________________
> _____________________________________ _
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: amitjain@synechron.com, s.borse@direction.biz, Vivek_Sharan@infosys.com
Subject: Re: Heavy postgres process
In-Reply-To: <493EF7BC.4020900@synechron.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox