Re: Heavy postgres process

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 _________________________________________________________________________________________