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? -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
