Skip site navigation (1) Skip section navigation (2)

Seeing locks (was Status of gist locking in 8.1.3)

From: Francisco Reyes <lists(at)stringsutils(dot)com>
To: Chris <dmagick(at)gmail(dot)com>
Cc: PostgreSQL general <pgsql-general(at)postgresql(dot)org>
Subject: Seeing locks (was Status of gist locking in 8.1.3)
Date: 2006-05-30 16:05:59
Message-ID: cone.1149005159.108600.48418.1000@zoraida.natserv.net (view raw or flat)
Thread:
Lists: pgsql-general
Chris writes:

>>> SELECT * from pg_locks ;
>> And this is per DB right?
> No, this is per system.

On a DB doing no/little work I always see two records returned. One has a 
value in the 'database' column. How can I find what database it is?

Looking for it in pg_database did not yield any databases with a matching 
number. The number in the 'database' column did not match any number of the 
columns in pg_database.

The two records I always see are:
   locktype    |....|      mode       | granted
---------------+....+-----------------+---------
 transactionid |....| ExclusiveLock   | t
 relation      |....| AccessShareLock | t



In response to

Responses

pgsql-general by date

Next:From: Tom LaneDate: 2006-05-30 16:15:38
Subject: Re: Seeing locks (was Status of gist locking in 8.1.3)
Previous:From: SCassidyDate: 2006-05-30 16:05:42
Subject: Re: UTF-8 context of BYTEA datatype??

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group