WHo is locking me?

Hi,

A process hangs forever.
When using this query...

SELECT pg_stat_get_backend_pid(s.backendid) AS procpid,
pg_stat_get_backend_activity(s.backendid) AS current_query
FROM (SELECT pg_stat_get_backend_idset() AS backendid) AS s
where pg_stat_get_backend_activity(s.backendid) not like '<insuff%'
and pg_stat_get_backend_activity(s.backendid) not like '<IDLE>';

I get...

procpid | current_query
---------+---------------------------------------------------------------------
26702 | SELECT pg_stat_get_backend_pid(s.backendid) AS procpid,
: pg_stat_get_backend_activity(s.backendid) AS current_query
: FROM (SELECT pg_stat_get_backend_idset() AS backendid) AS s
: where pg_stat_get_backend_activity(s.backendid) not like '<insuff%'
: and pg_stat_get_backend_activity(s.backendid) not like '<IDLE>';
21282 | update cmr_lastno set lastisn=lastisn+1 where tablename='DANNY';
25936 | <IDLE> in transaction <== This is the locker

And the question:
- What exactly is the locker doing?
- Can I retrieve the Client PID somewhere (then by process name I will dive into the code).

Thanks a lot

Danny Abraham
BMC Software
CTM&D Business Unit
972-52-4286-513
danny_abraham(at)bmc(dot)com