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 C6A8BD1B553
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri, 10 Oct 2003 13:44:05 +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 12347-10
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri, 10 Oct 2003 10:43:21 -0300 (ADT)
Received: from lucifer.oficina (unknown [200.69.203.237])
	by svr1.postgresql.org (Postfix) with ESMTP id 8CCB6D1B4EE
	for <pgsql-sql@postgresql.org>; Fri, 10 Oct 2003 10:43:16 -0300 (ADT)
Received: from [192.168.1.174] (taz.oficina [192.168.1.174])
	(authenticated bits=0)
	by lucifer.oficina (8.12.9/8.12.9) with ESMTP id h9ADhGlN042347;
	Fri, 10 Oct 2003 10:43:17 -0300 (ART)
	(envelope-from franco@akyasociados.com.ar)
Subject: Re: monitor sessions
From: Franco Bruno Borghesi <franco@akyasociados.com.ar>
To: Chris Faulkner <chrisf@oramap.com>
Cc: Pgsql-Sql <pgsql-sql@postgresql.org>
In-Reply-To: <DGENKIKMJILAAKJGFHKFKEJFCIAA.chrisf@oramap.com>
References: <DGENKIKMJILAAKJGFHKFKEJFCIAA.chrisf@oramap.com>
Content-Type: multipart/signed; micalg=pgp-sha1;
	protocol="application/pgp-signature";
	boundary="=-ve4uW1Bj3h5uEy0egmx3"
Organization: AK y Asociados S.R.L.
Message-Id: <1065793395.7220.9.camel@taz>
Mime-Version: 1.0
X-Mailer: Ximian Evolution 1.4.4 
Date: Fri, 10 Oct 2003 10:43:16 -0300
X-MailScanner-Information: Please contact the ISP for more information
X-MailScanner: Found to be clean
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200310/112
X-Sequence-Number: 15512

--=-ve4uW1Bj3h5uEy0egmx3
Content-Type: multipart/alternative; boundary="=-+oT8KGfSZ+5YVtC7TGlZ"

--=-+oT8KGfSZ+5YVtC7TGlZ
Content-Type: text/plain
Content-Transfer-Encoding: quoted-printable

SELECT * FROM pg_stat_activity;

On Fri, 2003-10-10 at 09:48, Chris Faulkner wrote:

> Hello
>=20
> Can anyone tell me - is there a system table or view that I can query to
> show all current sessions ?
>=20
> Thanks
>=20
>=20
> Chris
>=20
>=20
>=20
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
>=20

--=-+oT8KGfSZ+5YVtC7TGlZ
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
  <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; CHARSET=3DUTF-8">
  <META NAME=3D"GENERATOR" CONTENT=3D"GtkHTML/3.0.8">
</HEAD>
<BODY>
SELECT * FROM pg_stat_activity;<BR>
<BR>
On Fri, 2003-10-10 at 09:48, Chris Faulkner wrote:
<BLOCKQUOTE TYPE=3DCITE>
<PRE><FONT COLOR=3D"#737373"><I>Hello

Can anyone tell me - is there a system table or view that I can query to
show all current sessions ?

Thanks


Chris



---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
</I></FONT></PRE>
</BLOCKQUOTE>
</BODY>
</HTML>

--=-+oT8KGfSZ+5YVtC7TGlZ--

--=-ve4uW1Bj3h5uEy0egmx3
Content-Type: application/pgp-signature; name=signature.asc
Content-Description: This is a digitally signed message part

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.2 (FreeBSD)

iD8DBQA/hrdz21dVnhLsBV0RAh35AJ4ol+q5VH+OfjVuLp5wXZPhT0+6UgCfTtRD
wF211DHm2oS3weXXDkExpNc=
=B4S5
-----END PGP SIGNATURE-----

--=-ve4uW1Bj3h5uEy0egmx3--