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

Re: how to find transaction associated with a lock

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: schen(at)graciousstyle(dot)com
Cc: pgsql-general(at)postgresql(dot)org, pgsql-novice(at)postgresql(dot)org,pgsql-admin(at)postgresql(dot)org
Subject: Re: how to find transaction associated with a lock
Date: 2004-07-22 20:45:03
Message-ID: 12341.1090529103@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-generalpgsql-novice
Si Chen <schen(at)graciousstyle(dot)com> writes:
> Does anyone know of a way to go from transactions identifiers to the 
> actual transaction--which tables, which statements, etc. etc.?

See pg_stat_activity.

The pg_locks entries you are looking at do *not* represent table locks
of any kind.  This:
> NULL NULL 3366868 27149 ExclusiveLock TRUE
simply says that transaction 3366868 is still running.  This:
> NULL NULL 3366868 1069 ShareLock FALSE
says that process 1069 has elected to wait until transaction 3366868
finishes.  Normally the reason for doing that would be that transaction
3366868 holds a row lock (SELECT FOR UPDATE lock) on some row that
process 1069's transaction wants to acquire row lock on.

However, I suspect what you are really wishing is to find out the
individual row that is being contended for, and there is not enough
information in the system views to do that (mainly because we do not
keep per-row locking information in shared memory).

			regards, tom lane

In response to

Responses

pgsql-novice by date

Next:From: Si ChenDate: 2004-07-22 21:44:29
Subject: Re: [ADMIN] how to find transaction associated with a lock
Previous:From: Si ChenDate: 2004-07-22 19:16:38
Subject: how to find transaction associated with a lock

pgsql-admin by date

Next:From: Si ChenDate: 2004-07-22 21:44:29
Subject: Re: [ADMIN] how to find transaction associated with a lock
Previous:From: Tom LaneDate: 2004-07-22 20:19:53
Subject: Re: [HACKERS] Point in Time Recovery

pgsql-general by date

Next:From: Si ChenDate: 2004-07-22 21:44:29
Subject: Re: [ADMIN] how to find transaction associated with a lock
Previous:From: Si ChenDate: 2004-07-22 19:16:38
Subject: how to find transaction associated with a lock

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