X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 4186C53372;
	Mon,  2 May 2005 19:11:56 -0300 (ADT)
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 16773-01; Mon,  2 May 2005 22:11:52 +0000 (GMT)
Received: from mail.logix-tt.com (wallaby.dingens.org [212.75.36.180])
	by svr1.postgresql.org (Postfix) with ESMTP id 9094A52971;
	Mon,  2 May 2005 19:11:51 -0300 (ADT)
Received: from kingfisher.intern.logi-track.com (pD95DD20F.dip0.t-ipconnect.de
	[217.93.210.15])
	(using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits))
	(No client certificate requested)
	by mail.logix-tt.com (Postfix) with ESMTP id 1E73EA8682;
	Tue,  3 May 2005 00:11:47 +0200 (CEST)
Received: from [127.0.0.1] (localhost [127.0.0.1])
	by kingfisher.intern.logi-track.com (Postfix) with ESMTP id BB23EACA17;
	Tue,  3 May 2005 00:10:01 +0200 (CEST)
Message-ID: <4276A534.7060607@logix-tt.com>
Date: Tue, 03 May 2005 00:09:56 +0200
From: Markus Schaber <schabi@logix-tt.com>
Organization: Logical Tracking and Tracing International AG, Switzerland
User-Agent: Debian Thunderbird 1.0.2 (X11/20050331)
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: Cosimo Streppone <cosimo@streppone.it>
Cc: pgsql-announce@postgresql.org,
	"\"\"DBD:\"@svr1.postgresql.org\"@logix-tt.com:Pg list"
	<dbdpg-general@gborg.postgresql.org>, pgsql-sql@postgresql.org
Subject: Re: [ANNOUNCE] pgtop, display PostgreSQL processes in `top' style
References: <42740256.4090200@streppone.it>
In-Reply-To: <42740256.4090200@streppone.it>
X-Enigmail-Version: 0.91.0.0
Content-Type: multipart/signed; micalg=pgp-ripemd160;
	protocol="application/pgp-signature";
	boundary="------------enigE564154C070ABE8EBBE571F0"
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.05 tagged_above=0 required=5 tests=FORGED_RCVD_HELO
X-Spam-Level: 
X-Archive-Number: 200505/26
X-Sequence-Number: 21339

This is an OpenPGP/MIME signed message (RFC 2440 and 3156)
--------------enigE564154C070ABE8EBBE571F0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

Hi, Cosimo,

Cosimo Streppone wrote:

> 1) is it possible to know Pg backend uptime with
>    SQL queries? Or must I look at postmaster.pid file?
>    or even something else?

In contrib, there's a function caled backend_pid() defined in
misc_utils.sql, it may be helpful for you.

markus

--------------enigE564154C070ABE8EBBE571F0
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.5 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFCdqU5yHQIGEs7eeARAw6IAKCVQRg6mwD4GVjRYo8Dfm0JbU7UugCgs5Ip
hD8oxE2ZqofA318rTfOik8w=
=p9OR
-----END PGP SIGNATURE-----

--------------enigE564154C070ABE8EBBE571F0--