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.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
