Re: [SQL] To find process that lock a table

On Mon, Jun 6, 2011 at 5:16 PM, manuel antonio ochoa 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 s

[SQL] To find process that lock a table

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. see youu.