2008/3/14, Alvaro Herrera <alvherre@xxxxxxxxxxxxxxxxx>:> Clodoaldo escribió:>> > 2008/3/14, Alvaro Herrera <alvherre@xxxxxxxxxxxxxxxxx>:>>> > > 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 totalfrom 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@xxxxxxxxxxxxxx)To make changes to your subscription:http://www.postgresql.org/mailpref/pgsql-general
