API tools faq
paste
Advertisement
Guest User

pg_locks on 10.216.73.202

a guest
Jan 11th, 2013
289
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 31.87 KB | None | 0 0
raw download clone embed print report
  1. pid | locktype | transactionid | virtualtransaction | mode | granted | relname | relkind | datname | usename | current_query | waiting | query_start | client_addr | client_port
  2. -------+---------------+---------------+--------------------+-----------------------+---------+----------------------------------------+---------+---------+----------+--------------------------------------------------------------+---------+-------------------------------+---------------+-------------
  3. 23448 | tuple | | 32/525 | ExclusiveLock | f | qrtz_mem_locks | r | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | t | 2013-01-11 10:25:32.406117+00 | 10.216.73.204 | 46979
  4. 23448 | relation | | 32/525 | RowShareLock | t | qrtz_mem_locks | r | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | t | 2013-01-11 10:25:32.406117+00 | 10.216.73.204 | 46979
  5. 23448 | relation | | 32/525 | AccessShareLock | t | qrtz_mem_locks_pkey | i | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | t | 2013-01-11 10:25:32.406117+00 | 10.216.73.204 | 46979
  6. 23448 | virtualxid | | 32/525 | ExclusiveLock | t | | | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | t | 2013-01-11 10:25:32.406117+00 | 10.216.73.204 | 46979
  7. 23449 | tuple | | 33/88 | ExclusiveLock | f | qrtz_mem_locks | r | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | t | 2013-01-11 10:25:33.18429+00 | 10.216.73.204 | 46982
  8. 23449 | relation | | 33/88 | RowShareLock | t | qrtz_mem_locks | r | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | t | 2013-01-11 10:25:33.18429+00 | 10.216.73.204 | 46982
  9. 23449 | relation | | 33/88 | AccessShareLock | t | qrtz_mem_locks_pkey | i | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | t | 2013-01-11 10:25:33.18429+00 | 10.216.73.204 | 46982
  10. 23449 | virtualxid | | 33/88 | ExclusiveLock | t | | | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | t | 2013-01-11 10:25:33.18429+00 | 10.216.73.204 | 46982
  11. 23451 | relation | | 35/717 | RowShareLock | t | qrtz_mem_locks | r | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | f | 2013-01-11 10:25:32.323659+00 | 10.216.73.204 | 46988
  12. 23451 | relation | | 35/717 | AccessShareLock | t | qrtz_mem_locks_pkey | i | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | f | 2013-01-11 10:25:32.323659+00 | 10.216.73.204 | 46988
  13. 23451 | transactionid | 201515 | 35/717 | ExclusiveLock | t | | | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | f | 2013-01-11 10:25:32.323659+00 | 10.216.73.204 | 46988
  14. 23451 | virtualxid | | 35/717 | ExclusiveLock | t | | | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | f | 2013-01-11 10:25:32.323659+00 | 10.216.73.204 | 46988
  15. 24683 | tuple | | 62/307 | ExclusiveLock | f | qrtz_mem_locks | r | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | t | 2013-01-11 10:25:32.712495+00 | 10.216.73.204 | 47560
  16. 24683 | relation | | 62/307 | RowShareLock | t | qrtz_mem_locks | r | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | t | 2013-01-11 10:25:32.712495+00 | 10.216.73.204 | 47560
  17. 24683 | relation | | 62/307 | AccessShareLock | t | qrtz_mem_locks_pkey | i | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | t | 2013-01-11 10:25:32.712495+00 | 10.216.73.204 | 47560
  18. 24683 | virtualxid | | 62/307 | ExclusiveLock | t | | | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | t | 2013-01-11 10:25:32.712495+00 | 10.216.73.204 | 47560
  19. 24684 | tuple | | 63/252 | ExclusiveLock | f | qrtz_mem_locks | r | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | t | 2013-01-11 10:25:32.478602+00 | 10.216.73.204 | 47562
  20. 24684 | relation | | 63/252 | RowShareLock | t | qrtz_mem_locks | r | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | t | 2013-01-11 10:25:32.478602+00 | 10.216.73.204 | 47562
  21. 24684 | relation | | 63/252 | AccessShareLock | t | qrtz_mem_locks_pkey | i | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | t | 2013-01-11 10:25:32.478602+00 | 10.216.73.204 | 47562
  22. 24684 | virtualxid | | 63/252 | ExclusiveLock | t | | | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | t | 2013-01-11 10:25:32.478602+00 | 10.216.73.204 | 47562
  23. 26351 | tuple | | 67/522 | ExclusiveLock | f | qrtz_mem_locks | r | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | t | 2013-01-11 10:25:32.816671+00 | 10.216.73.204 | 48041
  24. 26351 | relation | | 67/522 | RowShareLock | t | qrtz_mem_locks | r | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | t | 2013-01-11 10:25:32.816671+00 | 10.216.73.204 | 48041
  25. 26351 | relation | | 67/522 | AccessShareLock | t | qrtz_mem_locks_pkey | i | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | t | 2013-01-11 10:25:32.816671+00 | 10.216.73.204 | 48041
  26. 26351 | virtualxid | | 67/522 | ExclusiveLock | t | | | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | t | 2013-01-11 10:25:32.816671+00 | 10.216.73.204 | 48041
  27. 26391 | tuple | | 68/201 | ExclusiveLock | f | qrtz_mem_locks | r | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | t | 2013-01-11 10:25:32.37362+00 | 10.216.73.204 | 48048
  28. 26391 | relation | | 68/201 | RowShareLock | t | qrtz_mem_locks | r | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | t | 2013-01-11 10:25:32.37362+00 | 10.216.73.204 | 48048
  29. 26391 | relation | | 68/201 | AccessShareLock | t | qrtz_mem_locks_pkey | i | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | t | 2013-01-11 10:25:32.37362+00 | 10.216.73.204 | 48048
  30. 26391 | virtualxid | | 68/201 | ExclusiveLock | t | | | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | t | 2013-01-11 10:25:32.37362+00 | 10.216.73.204 | 48048
  31. 26450 | tuple | | 69/131 | ExclusiveLock | f | qrtz_mem_locks | r | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | t | 2013-01-11 10:25:32.653848+00 | 10.216.73.204 | 48068
  32. 26450 | relation | | 69/131 | RowShareLock | t | qrtz_mem_locks | r | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | t | 2013-01-11 10:25:32.653848+00 | 10.216.73.204 | 48068
  33. 26450 | relation | | 69/131 | AccessShareLock | t | qrtz_mem_locks_pkey | i | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | t | 2013-01-11 10:25:32.653848+00 | 10.216.73.204 | 48068
  34. 26450 | virtualxid | | 69/131 | ExclusiveLock | t | | | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | t | 2013-01-11 10:25:32.653848+00 | 10.216.73.204 | 48068
  35. 26451 | tuple | | 71/8 | ExclusiveLock | f | qrtz_mem_locks | r | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | t | 2013-01-11 10:25:32.78064+00 | 10.216.73.204 | 48072
  36. 26451 | relation | | 71/8 | RowShareLock | t | qrtz_mem_locks | r | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | t | 2013-01-11 10:25:32.78064+00 | 10.216.73.204 | 48072
  37. 26451 | relation | | 71/8 | AccessShareLock | t | qrtz_mem_locks_pkey | i | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | t | 2013-01-11 10:25:32.78064+00 | 10.216.73.204 | 48072
  38. 26451 | virtualxid | | 71/8 | ExclusiveLock | t | | | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | t | 2013-01-11 10:25:32.78064+00 | 10.216.73.204 | 48072
  39. 26452 | tuple | | 70/11 | ExclusiveLock | f | qrtz_mem_locks | r | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | t | 2013-01-11 10:25:33.024152+00 | 10.216.73.204 | 48074
  40. 26452 | relation | | 70/11 | RowShareLock | t | qrtz_mem_locks | r | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | t | 2013-01-11 10:25:33.024152+00 | 10.216.73.204 | 48074
  41. 26452 | relation | | 70/11 | AccessShareLock | t | qrtz_mem_locks_pkey | i | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | t | 2013-01-11 10:25:33.024152+00 | 10.216.73.204 | 48074
  42. 26452 | virtualxid | | 70/11 | ExclusiveLock | t | | | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | t | 2013-01-11 10:25:33.024152+00 | 10.216.73.204 | 48074
  43. 26453 | transactionid | 201515 | 72/122 | ShareLock | f | | | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | t | 2013-01-11 10:25:32.351276+00 | 10.216.73.204 | 48077
  44. 26453 | relation | | 72/122 | RowShareLock | t | qrtz_mem_locks | r | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | t | 2013-01-11 10:25:32.351276+00 | 10.216.73.204 | 48077
  45. 26453 | tuple | | 72/122 | ExclusiveLock | t | qrtz_mem_locks | r | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | t | 2013-01-11 10:25:32.351276+00 | 10.216.73.204 | 48077
  46. 26453 | relation | | 72/122 | AccessShareLock | t | qrtz_mem_locks_pkey | i | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | t | 2013-01-11 10:25:32.351276+00 | 10.216.73.204 | 48077
  47. 26453 | virtualxid | | 72/122 | ExclusiveLock | t | | | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | t | 2013-01-11 10:25:32.351276+00 | 10.216.73.204 | 48077
  48. 26454 | tuple | | 73/91 | ExclusiveLock | f | qrtz_mem_locks | r | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | t | 2013-01-11 10:25:32.722663+00 | 10.216.73.204 | 48080
  49. 26454 | relation | | 73/91 | RowShareLock | t | qrtz_mem_locks | r | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | t | 2013-01-11 10:25:32.722663+00 | 10.216.73.204 | 48080
  50. 26454 | relation | | 73/91 | AccessShareLock | t | qrtz_mem_locks_pkey | i | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | t | 2013-01-11 10:25:32.722663+00 | 10.216.73.204 | 48080
  51. 26454 | virtualxid | | 73/91 | ExclusiveLock | t | | | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | t | 2013-01-11 10:25:32.722663+00 | 10.216.73.204 | 48080
  52. 26551 | tuple | | 74/23 | ExclusiveLock | f | qrtz_mem_locks | r | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | t | 2013-01-11 10:25:32.891727+00 | 10.216.73.204 | 48119
  53. 26551 | relation | | 74/23 | RowShareLock | t | qrtz_mem_locks | r | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | t | 2013-01-11 10:25:32.891727+00 | 10.216.73.204 | 48119
  54. 26551 | relation | | 74/23 | AccessShareLock | t | qrtz_mem_locks_pkey | i | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | t | 2013-01-11 10:25:32.891727+00 | 10.216.73.204 | 48119
  55. 26551 | virtualxid | | 74/23 | ExclusiveLock | t | | | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | t | 2013-01-11 10:25:32.891727+00 | 10.216.73.204 | 48119
  56. 26553 | tuple | | 75/5 | ExclusiveLock | f | qrtz_mem_locks | r | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | t | 2013-01-11 10:25:33.097988+00 | 10.216.73.204 | 48123
  57. 26553 | relation | | 75/5 | RowShareLock | t | qrtz_mem_locks | r | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | t | 2013-01-11 10:25:33.097988+00 | 10.216.73.204 | 48123
  58. 26553 | relation | | 75/5 | AccessShareLock | t | qrtz_mem_locks_pkey | i | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | t | 2013-01-11 10:25:33.097988+00 | 10.216.73.204 | 48123
  59. 26553 | virtualxid | | 75/5 | ExclusiveLock | t | | | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | t | 2013-01-11 10:25:33.097988+00 | 10.216.73.204 | 48123
  60. 26554 | tuple | | 76/4 | ExclusiveLock | f | qrtz_mem_locks | r | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | t | 2013-01-11 10:25:33.342111+00 | 10.216.73.204 | 48125
  61. 26554 | relation | | 76/4 | RowShareLock | t | qrtz_mem_locks | r | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | t | 2013-01-11 10:25:33.342111+00 | 10.216.73.204 | 48125
  62. 26554 | relation | | 76/4 | AccessShareLock | t | qrtz_mem_locks_pkey | i | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | t | 2013-01-11 10:25:33.342111+00 | 10.216.73.204 | 48125
  63. 26554 | virtualxid | | 76/4 | ExclusiveLock | t | | | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | t | 2013-01-11 10:25:33.342111+00 | 10.216.73.204 | 48125
  64. 26578 | tuple | | 77/8 | ExclusiveLock | f | qrtz_mem_locks | r | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | t | 2013-01-11 10:25:37.687148+00 | 10.216.73.204 | 48139
  65. 26578 | relation | | 77/8 | RowShareLock | t | qrtz_mem_locks | r | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | t | 2013-01-11 10:25:37.687148+00 | 10.216.73.204 | 48139
  66. 26578 | relation | | 77/8 | AccessShareLock | t | qrtz_mem_locks_pkey | i | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | t | 2013-01-11 10:25:37.687148+00 | 10.216.73.204 | 48139
  67. 26578 | virtualxid | | 77/8 | ExclusiveLock | t | | | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | t | 2013-01-11 10:25:37.687148+00 | 10.216.73.204 | 48139
  68. 26798 | tuple | | 14/184 | ExclusiveLock | f | qrtz_mem_locks | r | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | t | 2013-01-11 10:28:17.519844+00 | 10.216.73.204 | 48246
  69. 26798 | relation | | 14/184 | RowShareLock | t | changed_collection | r | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | t | 2013-01-11 10:28:17.519844+00 | 10.216.73.204 | 48246
  70. 26798 | relation | | 14/184 | RowExclusiveLock | t | changed_collection | r | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | t | 2013-01-11 10:28:17.519844+00 | 10.216.73.204 | 48246
  71. 26798 | relation | | 14/184 | RowExclusiveLock | t | changed_collection_added_entity | r | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | t | 2013-01-11 10:28:17.519844+00 | 10.216.73.204 | 48246
  72. 26798 | relation | | 14/184 | AccessShareLock | t | changed_collection_pkey | i | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | t | 2013-01-11 10:28:17.519844+00 | 10.216.73.204 | 48246
  73. 26798 | relation | | 14/184 | RowExclusiveLock | t | changed_collection_pkey | i | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | t | 2013-01-11 10:28:17.519844+00 | 10.216.73.204 | 48246
  74. 26798 | relation | | 14/184 | RowExclusiveLock | t | custom_property | r | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | t | 2013-01-11 10:28:17.519844+00 | 10.216.73.204 | 48246
  75. 26798 | relation | | 14/184 | RowExclusiveLock | t | custom_property_revision_data | r | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | t | 2013-01-11 10:28:17.519844+00 | 10.216.73.204 | 48246
  76. 26798 | relation | | 14/184 | RowExclusiveLock | t | global_revision | r | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | t | 2013-01-11 10:28:17.519844+00 | 10.216.73.204 | 48246
  77. 26798 | relation | | 14/184 | ShareRowExclusiveLock | t | global_revision | r | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | t | 2013-01-11 10:28:17.519844+00 | 10.216.73.204 | 48246
  78. 26798 | relation | | 14/184 | RowExclusiveLock | t | identifiable | r | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | t | 2013-01-11 10:28:17.519844+00 | 10.216.73.204 | 48246
  79. 26798 | relation | | 14/184 | RowShareLock | t | identifiable | r | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | t | 2013-01-11 10:28:17.519844+00 | 10.216.73.204 | 48246
  80. 26798 | relation | | 14/184 | AccessShareLock | t | identifiable_capacity_group_uuid_index | i | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | t | 2013-01-11 10:28:17.519844+00 | 10.216.73.204 | 48246
  81. 26798 | relation | | 14/184 | AccessShareLock | t | identifiable_clearance_uuid_key | i | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | t | 2013-01-11 10:28:17.519844+00 | 10.216.73.204 | 48246
  82. 26798 | relation | | 14/184 | AccessShareLock | t | identifiable_pkey | i | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | t | 2013-01-11 10:28:17.519844+00 | 10.216.73.204 | 48246
  83. 26798 | relation | | 14/184 | AccessShareLock | t | identifiable_room_id_index | i | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | t | 2013-01-11 10:28:17.519844+00 | 10.216.73.204 | 48246
  84. 26798 | relation | | 14/184 | AccessShareLock | t | identifiable_storage_id_index | i | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | t | 2013-01-11 10:28:17.519844+00 | 10.216.73.204 | 48246
  85. 26798 | relation | | 14/184 | AccessShareLock | t | identifiable_type_index | i | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | t | 2013-01-11 10:28:17.519844+00 | 10.216.73.204 | 48246
  86. 26798 | relation | | 14/184 | AccessShareLock | t | idx_barcode | i | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | t | 2013-01-11 10:28:17.519844+00 | 10.216.73.204 | 48246
  87. 26798 | relation | | 14/184 | RowShareLock | t | qrtz_mem_locks | r | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | t | 2013-01-11 10:28:17.519844+00 | 10.216.73.204 | 48246
  88. 26798 | relation | | 14/184 | AccessShareLock | t | qrtz_mem_locks_pkey | i | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | t | 2013-01-11 10:28:17.519844+00 | 10.216.73.204 | 48246
  89. 26798 | relation | | 14/184 | RowExclusiveLock | t | rack | r | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | t | 2013-01-11 10:28:17.519844+00 | 10.216.73.204 | 48246
  90. 26798 | relation | | 14/184 | RowExclusiveLock | t | revision_data | r | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | t | 2013-01-11 10:28:17.519844+00 | 10.216.73.204 | 48246
  91. 26798 | relation | | 14/184 | RowShareLock | t | revision_data | r | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | t | 2013-01-11 10:28:17.519844+00 | 10.216.73.204 | 48246
  92. 26798 | relation | | 14/184 | RowExclusiveLock | t | revision_data_new_entity | r | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | t | 2013-01-11 10:28:17.519844+00 | 10.216.73.204 | 48246
  93. 26798 | relation | | 14/184 | AccessShareLock | t | revision_data_pkey | i | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | t | 2013-01-11 10:28:17.519844+00 | 10.216.73.204 | 48246
  94. 26798 | relation | | 14/184 | RowExclusiveLock | t | room_data_center_item | r | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | t | 2013-01-11 10:28:17.519844+00 | 10.216.73.204 | 48246
  95. 26798 | virtualxid | | 14/184 | ExclusiveLock | t | | | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | t | 2013-01-11 10:28:17.519844+00 | 10.216.73.204 | 48246
  96. 26798 | transactionid | 201569 | 14/184 | ExclusiveLock | t | | | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | t | 2013-01-11 10:28:17.519844+00 | 10.216.73.204 | 48246
  97. 29691 | tuple | | 17/161 | ExclusiveLock | f | qrtz_mem_locks | r | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | t | 2013-01-11 10:34:21.897875+00 | 10.216.73.204 | 49518
  98. 29691 | relation | | 17/161 | RowShareLock | t | qrtz_mem_locks | r | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | t | 2013-01-11 10:34:21.897875+00 | 10.216.73.204 | 49518
  99. 29691 | relation | | 17/161 | AccessShareLock | t | qrtz_mem_locks_pkey | i | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | t | 2013-01-11 10:34:21.897875+00 | 10.216.73.204 | 49518
  100. 29691 | virtualxid | | 17/161 | ExclusiveLock | t | | | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | t | 2013-01-11 10:34:21.897875+00 | 10.216.73.204 | 49518
  101. 29692 | relation | | 18/203 | ShareRowExclusiveLock | f | global_revision | r | isxo | isxouser | LOCK TABLE global_revision IN SHARE ROW EXCLUSIVE MODE | t | 2013-01-11 10:34:18.890584+00 | 10.216.73.204 | 49521
  102. 29692 | virtualxid | | 18/203 | ExclusiveLock | t | | | isxo | isxouser | LOCK TABLE global_revision IN SHARE ROW EXCLUSIVE MODE | t | 2013-01-11 10:34:18.890584+00 | 10.216.73.204 | 49521
  103. 30427 | tuple | | 51/111 | ExclusiveLock | f | qrtz_mem_locks | r | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | t | 2013-01-11 10:37:17.224976+00 | 10.216.73.204 | 49831
  104. 30427 | relation | | 51/111 | RowShareLock | t | qrtz_mem_locks | r | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | t | 2013-01-11 10:37:17.224976+00 | 10.216.73.204 | 49831
  105. 30427 | relation | | 51/111 | AccessShareLock | t | qrtz_mem_locks_pkey | i | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | t | 2013-01-11 10:37:17.224976+00 | 10.216.73.204 | 49831
  106. 30427 | virtualxid | | 51/111 | ExclusiveLock | t | | | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | t | 2013-01-11 10:37:17.224976+00 | 10.216.73.204 | 49831
  107. 31613 | relation | | 23/167 | ShareRowExclusiveLock | f | global_revision | r | isxo | isxouser | LOCK TABLE global_revision IN SHARE ROW EXCLUSIVE MODE | t | 2013-01-11 10:40:20.972359+00 | 10.216.73.204 | 50334
  108. 31613 | virtualxid | | 23/167 | ExclusiveLock | t | | | isxo | isxouser | LOCK TABLE global_revision IN SHARE ROW EXCLUSIVE MODE | t | 2013-01-11 10:40:20.972359+00 | 10.216.73.204 | 50334
  109. (106 rows)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!