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 _________________________________________________________________________________________
