X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 0420ED1B526 for ; Fri, 10 Oct 2003 12:48:54 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 03448-05 for ; Fri, 10 Oct 2003 09:48:07 -0300 (ADT) Received: from mta05-svc.ntlworld.com (mta05-svc.ntlworld.com [62.253.162.45]) by svr1.postgresql.org (Postfix) with ESMTP id 7C79AD1B4EE for ; Fri, 10 Oct 2003 09:48:03 -0300 (ADT) Received: from elliott ([81.99.97.206]) by mta05-svc.ntlworld.com (InterMail vM.4.01.03.37 201-229-121-137-20020806) with SMTP id <20031010124806.MEEO2197.mta05-svc.ntlworld.com@elliott> for ; Fri, 10 Oct 2003 13:48:06 +0100 From: "Chris Faulkner" To: "Pgsql-Sql" Subject: monitor sessions Date: Fri, 10 Oct 2003 13:48:13 +0100 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0) X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 Importance: Normal In-Reply-To: <20031006165609.GC27925@wolff.to> X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200310/111 X-Sequence-Number: 15511 Hello Can anyone tell me - is there a system table or view that I can query to show all current sessions ? Thanks Chris