To find process that lock a table

From: manuel antonio ochoa <manuel8aalfaro(at)gmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: To find process that lock a table
Date: 2011-06-06 23:16:05
Message-ID: BANLkTi=X6+GW8fSvdpEhZ60RexCRuSN-zQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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.

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Scott Marlowe 2011-06-06 23:21:02 Re: To find process that lock a table
Previous Message lists-pgsql 2011-06-05 19:42:52 Re: selecting records X minutes apart