Re: Query stucked in pg_stat_activity - Mailing list pgsql-general

From Csaba Nagy
Subject Re: Query stucked in pg_stat_activity
Date
Msg-id 1123601350.2837.320.camel@coppola.muc.ecircle.de
Whole thread Raw
In response to Query stucked in pg_stat_activity  (Csaba Nagy <nagy@ecircle-ag.com>)
Responses Re: Query stucked in pg_stat_activity  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
[snip]
> > I've executed a "select pg_stat_reset();" as superuser, and all went
> > away except the offending row...
>
> That only resets the I/O counts (and only for one database), not the
> backend activity info.
>
>             regards, tom lane

This reminds me I've forgot to ask, is there any other way of getting
rid of those ghost entries than via big load ? The next big load will
leave another set of ghosts behind it...

Cheers,
Csaba.


pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: best way to reference tables
Next
From: Tom Lane
Date:
Subject: Re: Query stucked in pg_stat_activity