outdated (bad) information in pg_stat_activity - Mailing list pgsql-general

From hubert depesz lubaczewski
Subject outdated (bad) information in pg_stat_activity
Date
Msg-id 9e4684ce0512140602y4f541a64o4ffadacfc6188883@mail.gmail.com
Whole thread Raw
Responses Re: outdated (bad) information in pg_stat_activity
List pgsql-general
hi
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

i found this:
http://www.issociate.de/board/post/264560/possibly_outdated_info_in_pg_stat_activity.html

is there any workaround? what can be done to fix the data - i am using pg_stat_activity a lot, and this thing really ruined my day.

best regards

depesz

pgsql-general by date:

Previous
From: Jerry LeVan
Date:
Subject: ANN: PgBrowse 1.4
Next
From: David Rysdam
Date:
Subject: Re: "incomplete startup packet" on SGI