I too have had issues with "stuck" entries in the pg_stat_activity view -- the real pid is long gone but postgres still thinks the process is there.
It would be real sweet to have a way of cleaning this table with bringing postgres off-line. My $0.02 worth ... Greg Williamson DBA GlobeXplorer LLC -----Original Message----- From: [EMAIL PROTECTED] on behalf of Chris Browne Sent: Wed 12/14/2005 11:06 AM To: pgsql-general@postgresql.org Cc: Subject: Re: [GENERAL] outdated (bad) information in pg_stat_activity [EMAIL PROTECTED] (hubert depesz lubaczewski) writes: > On 12/14/05, Tom Lane <[EMAIL PROTECTED]> wrote: > > > hubert depesz lubaczewski <[EMAIL PROTECTED]> writes: > > my pg_stat_activity is raporting process working on a query for 12 > hours > > straight! (query_start). > > 2 problems: > > 1. this particular query runs typically between 80 and 200 miliseconds! > > 2. procpid of this backend does not exists anymore in system > It's possible that the "backend exited" message got dropped by the stats > mechanism --- the stats code is deliberately designed to lose messages > rather than delay the rest of the system, so it's not 100% reliable. > > > > is it possible to "by hand" remove bad entries from this stats? > depesz The only answer I have been able to come to is that restarting the postmaster will clear this all up. If there is some less intrusive way of accomplishing this, I'd be keen on hearing about it... -- "cbbrowne","@","cbbrowne.com" http://cbbrowne.com/info/nonrdbms.html "Funny, the only thing that makes me go Keanu about Microsoft is the fact that they are constantly behind the times and yet claim to be innovating." -- Steve Lamb <[EMAIL PROTECTED]> ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org !DSPAM:43a07aed148321697067737! ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
