X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 5BA85329E58 for ; Mon, 20 Sep 2004 10:00:07 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 55135-08 for ; Mon, 20 Sep 2004 09:00:01 +0000 (GMT) Received: from anchor-post-32.mail.demon.net (anchor-post-32.mail.demon.net [194.217.242.90]) by svr1.postgresql.org (Postfix) with ESMTP id 14F1A329D83 for ; Mon, 20 Sep 2004 09:59:59 +0100 (BST) Received: from lfix.demon.co.uk ([80.177.205.209] helo=cerberus.lfix.co.uk) by anchor-post-32.mail.demon.net with esmtp (Exim 3.35 #1) id 1C9K1e-0006dx-0W; Mon, 20 Sep 2004 08:59:58 +0000 Received: from linda.lfix.co.uk ([192.168.1.1]) by cerberus.lfix.co.uk with esmtp (Exim 4.34) id 1C9K1X-0004Od-FS; Mon, 20 Sep 2004 09:59:51 +0100 Subject: Re: connections manager From: Oliver Elphick Reply-To: olly@lfix.co.uk To: "\"Lic. Guillermo" =?ISO-8859-1?Q?Gonz=E1lez=22?= Cc: pgsql-admin@postgresql.org In-Reply-To: <41499E94.8000904@cybira.biz> References: <41499E94.8000904@cybira.biz> Content-Type: text/plain; charset=iso-8859-1 Organization: LFIX Limited Message-Id: <1095670791.17403.51.camel@linda> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 Date: Mon, 20 Sep 2004 09:59:51 +0100 Content-Transfer-Encoding: quoted-printable X-LFIX-MailScanner: Found to be clean X-MailScanner-From: olly@lfix.co.uk X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200409/169 X-Sequence-Number: 14872 On Thu, 2004-09-16 at 15:09, "Lic. Guillermo Gonz=E1lez" wrote: > Hi, >=20 > I would like to know if there is a script or software that can bring me= =20 > information about the connections on my PostgreSQL databases. select * from pg_stat_activity; --=20 Oliver Elphick olly@lfix.co.uk Isle of Wight http://www.lfix.co.uk/oliver GPG: 1024D/A54310EA 92C8 39E7 280E 3631 3F0E 1EC0 5664 7A2F A543 10EA =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D "But my God shall supply all your need according to his riches in glory by Christ Jesus." Philippians 4:19