Re: Heavy postgres process

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/>
> ___________________________________________________
> _____________________________________ _
>