Skip site navigation (1) Skip section navigation (2)

Re: Heavy postgres process

From: AmitKumar Jain <amitjain(at)synechron(dot)com>
To: s(dot)borse(at)direction(dot)biz
Cc: Vivek_Sharan <Vivek_Sharan(at)infosys(dot)com>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Heavy postgres process
Date: 2008-12-09 22:57:00
Message-ID: 493EF7BC.4020900@synechron.com (view raw or flat)
Thread:
Lists: pgsql-admin
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/>
> ___________________________________________________ 
> _____________________________________ _
>

In response to

pgsql-admin by date

Next:From: Steve KecskesDate: 2008-12-09 23:10:06
Subject: Connection Limit Exceeded
Previous:From: Guido BarosioDate: 2008-12-09 22:30:56
Subject: Re: uninstall

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group