X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id D4AD99FA65C for ; Thu, 4 May 2006 17:29:18 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 55248-04 for ; Thu, 4 May 2006 17:28:58 -0300 (ADT) X-Greylist: delayed 00:06:39.358559 by SQLgrey- Received: from rediffmail.com (unknown [203.199.83.31]) by postgresql.org (Postfix) with SMTP id D21A29F9B76 for ; Thu, 4 May 2006 17:28:57 -0300 (ADT) Received: (qmail 32051 invoked by uid 510); 4 May 2006 20:21:17 -0000 Date: 4 May 2006 20:21:17 -0000 Message-ID: <20060504202117.32050.qmail@webmail46.rediffmail.com> Received: from unknown (210.214.208.141) by rediffmail.com via HTTP; 04 may 2006 20:21:17 -0000 MIME-Version: 1.0 From: "Shivaji S" Reply-To: "Shivaji S" To: "Tomeh,Husam" Cc: pgsql-admin@postgresql.org Subject: Re: How to find current running process Content-type: multipart/alternative; boundary="Next_1146774077---0-203.199.83.31-32046" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.876 tagged_above=0 required=5 tests=AWL, BAYES_00, HTML_30_40, HTML_IMAGE_ONLY_28, HTML_MESSAGE, MSGID_FROM_MTA_HEADER X-Spam-Level: * X-Archive-Number: 200605/47 X-Sequence-Number: 21579 This is a multipart mime message --Next_1146774077---0-203.199.83.31-32046 Content-type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline tom thanks for the input ,but the below queries doesn't support for my post= gres version 7.1.1 it shows the error =0A=0AERROR: Function 'pg_postmaster= _start_time()' does not exist=0AUnable to identify a function that satisfie= s the given argument types=0AYou may need to add explicit typecasts=0A=0ARe= gards,=0AShivaji=0A=0AOn Thu, 04 May 2006 Tomeh,Husam wrote :=0A>You may us= e the pg_stat_activity view to find out what's running on the=0A>database, = ie. select * from pg_stat_activity ;=0A>You may also use the pg_postmaster_= start_time() function to find out=0A>postmaster startup time, ie. select pg= _postmaster_start_time() ;=0A>=0A>----=0A>=0A> Husam=0A> http://fir= stdba.googlepages.com=0A>=0A>=0A>________________________________=0A>=0A> F= rom: pgsql-admin-owner@postgresql.org=0A>[mailto:pgsql-admin-owner@postgres= ql.org] On Behalf Of Shivaji S=0A>Sent: Thursday, May 04, 2006 11:06 AM=0A>= To: pgsql-admin@postgresql.org=0A>Subject: [ADMIN] How to find current runn= ing process=0A>=0A>=0A>=0A>=0A>Hi,=0A>=0A>=0A>Is there any command to find = current running threads/queries on=0A>postgres.=0A>=0A>and how to find the = uptime of my database.Please guide me=0A>=0A>Regards,=0A>Shivaji=0A>=0A>=0A= >=0A>=0A>ignature-home.htm/1507191490@Middle5?PARTNER=3D3>=0A>=0A>********= **************************************************************=0A>This mess= age contains confidential information intended only for the use of the addr= essee(s) named above and may contain information that is legally privileged= . If you are not the addressee, or the person responsible for delivering i= t to the addressee, you are hereby notified that reading, disseminating, di= stributing or copying this message is strictly prohibited. If you have rec= eived this message by mistake, please immediately notify us by replying to = the message and delete the original message immediately thereafter.=0A>=0A>= Thank you.=0A>=0A> FADLD Tag=0A>********= **************************************************************=0A --Next_1146774077---0-203.199.83.31-32046 Content-type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline

=0Atom thanks for the input ,but the below queries doesn't support for m= y postgres version 7.1.1 it shows the error
=0A
=0AERROR:  Func= tion 'pg_postmaster_start_time()' does not exist
=0AUnable to identify a= function that satisfies the given argument types
=0AYou may need to add= explicit typecasts
=0A
=0ARegards,
=0AShivaji
=0A
=0AOn Thu= , 04 May 2006 Tomeh,Husam wrote :
=0A>You may use the pg_stat_activit= y view to find out what's running on the
=0A>database, ie. select * f= rom pg_stat_activity ;
=0A>You may also use the pg_postmaster_start_t= ime() function to find out
=0A>postmaster startup time, ie. select pg= _postmaster_start_time() ;
=0A>
=0A>----
=0A>
=0A>&= nbsp;   Husam
=0A>    http://firstdba.googlepages.co= m
=0A>
=0A>
=0A>________________________________
=0A&g= t;
=0A> From: pgsql-admin-owner@postgresql.org
=0A>[mailto:pgsq= l-admin-owner@postgresql.org] On Behalf Of Shivaji S
=0A>Sent: Thursd= ay, May 04, 2006 11:06 AM
=0A>To: pgsql-admin@postgresql.org
=0A&g= t;Subject: [ADMIN] How to find current running process
=0A>
=0A>= ;
=0A>
=0A>
=0A>Hi,
=0A>
=0A>
=0A>Is th= ere any command to find current running threads/queries on
=0A>postgr= es.
=0A>
=0A>and how to find the uptime of my database.Please g= uide me
=0A>
=0A>Regards,
=0A>Shivaji
=0A>
=0A&g= t;
=0A>
=0A>
=0A><http://adworks.rediff.com/cgi-bin/Ad= Works/sigclick.cgi/www.rediff.com/s
=0A>ignature-home.htm/1507191490@= Middle5?PARTNER=3D3>
=0A>
=0A>******************************= ****************************************
=0A>This message contains co= nfidential information intended only for the use of the addressee(s) named = above and may contain information that is legally privileged.  If you = are not the addressee, or the person responsible for delivering it to the a= ddressee, you are hereby notified that reading, disseminating, distributing= or copying this message is strictly prohibited.  If you have received= this message by mistake, please immediately notify us by replying to the m= essage and delete the original message immediately thereafter.
=0A>=0A>Thank you.
=0A>
=0A>         =                     &nbs= p;     FADLD Tag
=0A>**************************************= ********************************
=0A=0A

=0A

=0A=0A --Next_1146774077---0-203.199.83.31-32046--