From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
---|---|
To: | Alexandre Arruda <alepaes(at)aldeiadigital(dot)com(dot)br> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: pg_locks: who is locking ? |
Date: | 2006-10-16 21:02:04 |
Message-ID: | 20061016210203.GE27790@alvh.no-ip.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Alexandre Arruda wrote:
> Hi,
>
> My Database have a lot of locks not granted every moments in a day.
>
> Can I create a view that returns someting like this ?
>
> User Granted Table Who_is_locking_me PID
> ---- ------- ----- ----------------- ---
> joe f foo frank 1212
> jeff f foo frank 1313
> ann f foo frank 1414
> frank t foo 1111
> (...)
>
> (Or the locked transactions, if the table cold't be retrived)
You can look up more data about a backend by joining pg_locks to
pg_stat_activity, using the PID (I think it's called procpid on one view
and pid on the other).
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
From | Date | Subject | |
---|---|---|---|
Next Message | Madison Kelly | 2006-10-16 21:12:15 | Re: A query planner that learns |
Previous Message | Alvaro Herrera | 2006-10-16 21:00:46 | Re: A query planner that learns |