2008/3/14, Alvaro Herrera <alvherre@commandprompt.com>:
> Clodoaldo escribió:
>
> > 2008/3/14, Alvaro Herrera <alvherre@commandprompt.com>:
>
>
> > > A quick look into pg_locks should tell you if it's blocking.
> >
> > pg_prepared_xacts is empty and pg_locks has 288 rows:
> >
> > # select locktype, mode, count(*) as total
> > from pg_locks group by locktype, mode;
> > locktype | mode | total
> > ---------------+------------------+-------
> > transactionid | ExclusiveLock | 30
> > relation | RowExclusiveLock | 2
> > relation | AccessShareLock | 256
> > (3 rows)
>
>
> How many of them have granted=false?
=> select locktype, mode, granted, count(*) as total
from pg_locks group by locktype, mode, granted;
locktype | mode | granted | total
---------------+-----------------+---------+-------
relation | AccessShareLock | t | 112
transactionid | ExclusiveLock | t | 17
(2 rows)
Regards, Clodoaldo Pinto Neto
