Re: Seeing locks (was Status of gist locking in 8.1.3)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Francisco Reyes <lists(at)stringsutils(dot)com>
Cc: Chris <dmagick(at)gmail(dot)com>, PostgreSQL general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Seeing locks (was Status of gist locking in 8.1.3)
Date: 2006-05-30 16:15:38
Message-ID: 24547.1149005738@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Francisco Reyes <lists(at)stringsutils(dot)com> writes:
> The two records I always see are:
> locktype |....| mode | granted
> ---------------+....+-----------------+---------
> transactionid |....| ExclusiveLock | t
> relation |....| AccessShareLock | t

That would be your own transaction's lock on its own XID, and its share
lock on the pg_locks view. Joining to pg_database.oid and pg_class.oid
will help you interpret the numbers --- see
http://www.postgresql.org/docs/8.1/static/view-pg-locks.html

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Philippe Lang 2006-05-30 16:39:55 Which RPM for RH Linux ES 4? PGDB or RH?
Previous Message Francisco Reyes 2006-05-30 16:05:59 Seeing locks (was Status of gist locking in 8.1.3)