Re: "slow" queries - Mailing list pgsql-performance

From Tom Lane
Subject Re: "slow" queries
Date
Msg-id 22227.1236022171@sss.pgh.pa.us
Whole thread Raw
In response to Re: "slow" queries  (Brian Cox <brian.cox@ca.com>)
Responses Re: "slow" queries
List pgsql-performance
Brian Cox <brian.cox@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

pgsql-performance by date:

Previous
From: Robert Haas
Date:
Subject: Re: "slow" queries
Next
From: Brian Cox
Date:
Subject: Re: "slow" queries