Re: autovacuum hung?

Tom Lane [tgl@sss.pgh.pa.us] wrote:
>
> Are those processes actually doing anything, or just waiting?  strace
> or local equivalent would be the most conclusive check.
These must not have been hung, because they finally completed (after
10-15 hrs - some time between 11pm and 8am). Question is why does it
take so long to do this on such a relatively small table?

> This query isn't very helpful because it fails to show locks that are
> not directly associated with tables.
How can that (locks not directly associated...) be determined?


Thanks,
Brian