2008/3/14, Alvaro Herrera <[EMAIL PROTECTED]>: > Clodoaldo escribió: > > > 2008/3/14, Alvaro Herrera <[EMAIL PROTECTED]>: > > > > > 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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general