Postgres Pro
Downloads
Home   >   mailing lists

Re: To find process that lock a table - Mailing list pgsql-sql

From Scott Marlowe
Subject Re: To find process that lock a table
Date
Msg-id BANLkTikTOtGhx-sbdXYp0=jc_J=hgmiV5g@mail.gmail.com
Whole thread Raw
In response to To find process that lock a table  (manuel antonio ochoa <manuel8aalfaro@gmail.com>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: manuel antonio ochoa
Date:
Subject: To find process that lock a table
Next
From: Andreas
Date:
Subject: need help with some aggregation magic