Brian Cox <brian....@ca.com> writes:
> select locktype,database,relation,virtualxid,virtualtransaction,pid,mode
> from pg_locks order by mode;
If you hadn't left out the "granted" column we could be more sure,
but what it looks like to me is the DROP (pid 13842) is stuck behind
the <IDLE> transaction (pid 13833). In particular these two rows of
pg_locks look like a possible conflict:
> relation | 26472437 | 26472508 | | 15/69749
> | 13842 | AccessExclusiveLock
> relation | 26472437 | 26472508 | | 11/131
> | 13833 | AccessShareLock
regards, tom lane
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
