From: Suresh Borse <s.borse@direction.biz>
To: Vivek_Sharan <Vivek_Sharan@infosys.com>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Heavy postgres process
Date: Wed, 10 Dec 2008 16:10:11 +0530
Message-ID: <1228905611.6187.1.camel@dss-052.dsslp.com> (raw)
In-Reply-To: <5465CC59A600E2408FFBF84350B938345031E95B93@AUSMELMBX01.ad.infosys.com>
References: <5465CC59A600E2408FFBF84350B938345031E95B93@AUSMELMBX01.ad.infosys.com>
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
_________________________________________________________________________________________
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: s.borse@direction.biz, Vivek_Sharan@infosys.com
Subject: Re: Heavy postgres process
In-Reply-To: <1228905611.6187.1.camel@dss-052.dsslp.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox