Re: Perl + Determine active connections on Pg 8.0.x and Pg 8.2.x

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Richard Huxton <dev(at)archonet(dot)com>
Cc: CAJ CAJ <pguser(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Perl + Determine active connections on Pg 8.0.x and Pg 8.2.x
Date: 2007-05-21 21:14:47
Message-ID: 28882.1179782087@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Richard Huxton <dev(at)archonet(dot)com> writes:
> CAJ CAJ wrote:
>> SELECT count(*) from pg_stat_activity;
>>
>> The above query always returns 0 rows for Pg 8.0.x and 1 row for Pg 8.2.x.

> The pg_stat_activity view is never completely up-to-date, there is
> always some time lag.

It *is* up-to-date as of 8.2, but in prior releases there can be as much
as half a second time lag.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bill Moseley 2007-05-21 21:42:15 Schema sanity check
Previous Message Chris Browne 2007-05-21 21:10:41 Re: What is "Postgresql Hot"?