On Mon, Jun 6, 2011 at 5:16 PM, manuel antonio ochoa
<manuel8aalfaro@gmail.com> wrote:
> Hello ,
>
> do you know how to find a process that is locking a table ? I try to run a
> vacuum analyze , an it take a state of waiting , I canceled it after 20
> minutes , then
> I try to run an analyze and the same happen, take a state waiting.
Try the queries here: http://wiki.postgresql.org/wiki/Lock_Monitoring