Обсуждение: To find process that lock a table

Hello ,<br /><br />do you know how to find a process that is locking a table  ? I try to run a vacuum analyze  , an it
takea state of waiting , I canceled it after 20 minutes , then <br />I try to run an analyze  and the same happen, take
astate waiting.<br /><br /><br />see youu.<br /><br /> 

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