Re: To find process that lock a table

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: manuel antonio ochoa <manuel8aalfaro(at)gmail(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: To find process that lock a table
Date: 2011-06-06 23:21:02
Message-ID: BANLkTikTOtGhx-sbdXYp0=jc_J=hgmiV5g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Mon, Jun 6, 2011 at 5:16 PM, manuel antonio ochoa
<manuel8aalfaro(at)gmail(dot)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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Andreas 2011-06-09 13:43:24 need help with some aggregation magic
Previous Message manuel antonio ochoa 2011-06-06 23:16:05 To find process that lock a table