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 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
