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