Skip site navigation (1) Skip section navigation (2)

Re: Stale entries in pg_stat_activity

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Stale entries in pg_stat_activity
Date: 2004-10-17 04:30:12
Message-ID: 20041017043011.GA82898@winnie.fuhr.org (view raw or flat)
Thread:
Lists: pgsql-bugs
On Sun, Oct 17, 2004 at 12:01:45AM -0400, Tom Lane wrote:
> Michael Fuhr <mike(at)fuhr(dot)org> writes:
> > pg_stat_activity sometimes shows old connections that have already
> > terminated.
> 
> Define "old"?  There's a built-in delay of up to half a second (if
> memory serves) in the statistics views.

Fourteen minutes and counting.

I just noticed the problem this evening so I don't know how long
the stale connections remain in the view.  During my testing I was
restarting the backend frequently to start each run afresh; I'll
leave the current situation alone for a while and see what happens.

-- 
Michael Fuhr
http://www.fuhr.org/~mfuhr/

In response to

Responses

pgsql-bugs by date

Next:From: Michael FuhrDate: 2004-10-17 06:23:58
Subject: Re: Stale entries in pg_stat_activity
Previous:From: Tom LaneDate: 2004-10-17 04:01:45
Subject: Re: Stale entries in pg_stat_activity

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group