Advertisement
Guest User

Postgresql locks

a guest
Jan 9th, 2013
333
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.59 KB | None | 0 0
  1. pid | locktype | transactionid | virtualtransaction | mode | granted | relname | relkind | datname | usename| current_query | waiting | query_start | client_addr | client_port
  2. 14791 | relation | | 69/32 | RowShareLock | t | qrtz_mem_locks | r | DBNAME | DBUSER | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | f | 2013-01-09 07:20:42.680568+00 | xx.xx.xx.xx | xxxx
  3. 14791 | relation | | 69/32 | AccessShareLock | t | qrtz_mem_locks_pkey | i | DBNAME | DBUSER | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | f | 2013-01-09 07:20:42.680568+00 | xx.xx.xx.xx | xxxx
  4. 14791 | transactionid | 39329 | 69/32 | ExclusiveLock | t | | | DBNAME | DBUSER | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | f | 2013-01-09 07:20:42.680568+00 | xx.xx.xx.xx | xxxx
  5. 14791 | virtualxid | | 69/32 | ExclusiveLock | t | | | DBNAME | DBUSER | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | f | 2013-01-09 07:20:42.680568+00 | xx.xx.xx.xx | xxxx
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement