View Single Post

   
  #6 (permalink)  
Old 04-09-2008, 05:22 AM
Csaba Nagy
 
Posts: n/a
Default Re: Query stucked in pg_stat_activity

[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.


---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

Reply With Quote