Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 9B011475CB1 for ; Mon, 9 Sep 2002 13:53:00 -0400 (EDT) Received: from mail-relay.trade-india.com (mail-relay.trade-india.com [203.196.129.235]) by postgresql.org (Postfix) with SMTP id 94D66475B68 for ; Mon, 9 Sep 2002 13:52:56 -0400 (EDT) Received: (qmail 5896 invoked from network); 9 Sep 2002 17:45:01 -0000 Received: from news1.trade-india.com (HELO www.trade-india.com) (130.94.20.27) by infocom-236-129-del.trade-india.com with SMTP; 9 Sep 2002 17:45:01 -0000 Received: (qmail 2908 invoked by uid 99); 9 Sep 2002 17:52:41 -0000 Received: from 203.145.129.36 (proxying for 203.145.131.140) (SquirrelMail authenticated user mallah) by mail.trade-india.com with HTTP; Mon, 9 Sep 2002 23:22:41 +0530 (IST) Message-ID: <44589.203.145.129.36.1031593961.squirrel@mail.trade-india.com> Date: Mon, 9 Sep 2002 23:22:41 +0530 (IST) Subject: Re: Displaying current queries on the database? From: To: In-Reply-To: <5.1.1.6.2.20020909123226.00affae0@mail.nashlinux.com> References: <5.1.1.6.2.20020909123226.00affae0@mail.nashlinux.com> X-Priority: 3 Importance: Normal X-MSMail-Priority: Normal Cc: X-Mailer: SquirrelMail (version 1.2.6) MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200209/57 X-Sequence-Number: 9334 its possible, select * from pg_stat_activity after AS connect as postgres. THOUGH NEEd to configure postgresql.conf accordigly regds mallaH > I was wondering if there is a way to display all of the current queries that are being > submitted to the database. Thanks in advance. > > -Sloan Bowman > > > ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' > the postmaster ----------------------------------------- Get your free web based email at trade-india.com. "India's Leading B2B eMarketplace.!" http://www.trade-india.com/