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?
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support