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