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
_________________________________________________________________________________________
|
|
