API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jul 15th, 2010
983
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 62.71 KB | None | 0 0
raw download clone embed print report
  1. Looking for queries that are running and waiting
  2. datname | usename | procpid | client_addr | waiting | query_start | current_query
  3. -----------+------------+---------+--------------+---------+-------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  4. scheduler | ressystems | 2926 | 192.168.1.10 | f | 2010-07-15 04:00:03.410499-05 | <IDLE>
  5. scheduler | ressystems | 929 | 192.168.1.10 | f | 2010-07-15 06:03:27.810419-05 | <IDLE>
  6. scheduler | ressystems | 4531 | 192.168.1.10 | f | 2010-07-15 06:03:38.43122-05 | <IDLE>
  7. scheduler | ressystems | 5913 | 192.168.1.10 | f | 2010-07-15 06:03:38.502318-05 | <IDLE>
  8. scheduler | ressystems | 4590 | 192.168.1.10 | f | 2010-07-15 06:08:15.250793-05 | <IDLE>
  9. scheduler | ressystems | 5912 | 192.168.1.10 | f | 2010-07-15 06:08:15.25353-05 | <IDLE>
  10. scheduler | ressystems | 25248 | 192.168.1.10 | f | 2010-07-15 06:32:57.191222-05 | <IDLE>
  11. scheduler | ressystems | 8982 | 192.168.1.10 | t | 2010-07-15 06:41:20.251917-05 | update employee set min_hours_per_day=NULL, max_hours_per_day=NULL, min_hours=NULL, max_hours=NULL, min_pay=NULL, max_pay=NULL, max_shifts=NULL, min_shifts=NULL, dateCreated='2010-05-06 15:34:43.060000 -05:00:00', user_id=87493, overtime=1.5, notice_timeframe=2, hire_date='2009-09-14 00:00:00.000000 -05:00:00', termination_date=NULL, active_attendance_block=823292, internal_number='', internal_password=NULL, max_shifts_per_week=NULL, min_shifts_per_week=NULL, birth_date='1961-03-04 00:00:00.000000 -06:00:00', ssn='69f4396b5ca59a76765b9771469d31ef', ssn_suffix='...9874', payroll_id=0087, home_location_id=NULL, home_department_id=NULL, parent_id=NULL, deleted='N', startTimestamp='2010-07-15 06:24:55.835000 -05:00:00', endTimestamp=NULL where id=2112876;
  12. scheduler | ressystems | 8157 | 192.168.1.10 | f | 2010-07-15 06:41:21.479519-05 | <IDLE>
  13. scheduler | ressystems | 30637 | 192.168.1.10 | f | 2010-07-15 06:42:21.610575-05 | <IDLE> in transaction
  14. scheduler | ressystems | 21128 | 192.168.1.10 | f | 2010-07-15 06:42:21.909071-05 | <IDLE> in transaction
  15. scheduler | ressystems | 9611 | 192.168.1.10 | f | 2010-07-15 06:42:25.204829-05 | <IDLE>
  16. scheduler | ressystems | 6336 | 192.168.1.10 | f | 2010-07-15 06:42:27.532651-05 | <IDLE> in transaction
  17. scheduler | ressystems | 28715 | 192.168.1.10 | f | 2010-07-15 06:42:27.535569-05 | <IDLE> in transaction
  18. scheduler | postgres | 9666 | | f | 2010-07-15 06:42:32.008036-05 | SELECT datname,usename,procpid,client_addr,waiting,query_start,current_query FROM pg_stat_activity order by query_start asc;
  19. scheduler | ressystems | 9612 | 192.168.1.10 | f | | <IDLE>
  20. (16 rows)
  21.  
  22.  
  23. Looking for blocked rows
  24. blocked_pid | blocked_user | blocking_pid | blocking_user | blocked_statement
  25. -------------+--------------+--------------+---------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  26. 8982 | ressystems | 30637 | ressystems | update employee set min_hours_per_day=NULL, max_hours_per_day=NULL, min_hours=NULL, max_hours=NULL, min_pay=NULL, max_pay=NULL, max_shifts=NULL, min_shifts=NULL, dateCreated='2010-05-06 15:34:43.060000 -05:00:00', user_id=87493, overtime=1.5, notice_timeframe=2, hire_date='2009-09-14 00:00:00.000000 -05:00:00', termination_date=NULL, active_attendance_block=823292, internal_number='', internal_password=NULL, max_shifts_per_week=NULL, min_shifts_per_week=NULL, birth_date='1961-03-04 00:00:00.000000 -06:00:00', ssn='69f4396b5ca59a76765b9771469d31ef', ssn_suffix='...9874', payroll_id=0087, home_location_id=NULL, home_department_id=NULL, parent_id=NULL, deleted='N', startTimestamp='2010-07-15 06:24:55.835000 -05:00:00', endTimestamp=NULL where id=2112876;
  27. (1 row)
  28.  
  29.  
  30. Looking for pg_locks
  31. relname | locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted
  32. -----------------------------------+----------+----------+----------+-------+-------+------------+---------------+---------+-------+----------+--------------------+-------+------------------+---------
  33. date_etl_pkey | relation | 6456840 | 9901208 | | | | | | | | 3/1909581 | 21128 | AccessShareLock | t
  34. timeblock_location | relation | 6456840 | 9901461 | | | | | | | | 15/1028898 | 28715 | AccessShareLock | t
  35. user_role_user_id | relation | 6456840 | 9901470 | | | | | | | | 12/1460917 | 30637 | AccessShareLock | t
  36. position_code_pkey | relation | 6456840 | 9901266 | | | | | | | | 15/1028898 | 28715 | AccessShareLock | t
  37. app_user_del | relation | 6456840 | 9901381 | | | | | | | | 15/1028898 | 28715 | AccessShareLock | t
  38. position_desc | relation | 6456840 | 9901426 | | | | | | | | 3/1909581 | 21128 | AccessShareLock | t
  39. app_user_corp | relation | 6456840 | 9901380 | | | | | | | | 15/1028898 | 28715 | AccessShareLock | t
  40. i_attendance_deleted_idx | relation | 6456840 | 9901398 | | | | | | | | 12/1460917 | 30637 | AccessShareLock | t
  41. position_del | relation | 6456840 | 9901425 | | | | | | | | 12/1460917 | 30637 | AccessShareLock | t
  42. app_user_pkey | relation | 6456840 | 9901184 | | | | | | | | 15/1028898 | 28715 | AccessShareLock | t
  43. loc_del | relation | 6456840 | 9901411 | | | | | | | | 15/1028898 | 28715 | AccessShareLock | t
  44. corporation_pkey | relation | 6456840 | 9901204 | | | | | | | | 3/1909581 | 21128 | AccessShareLock | t
  45. user_loc_loc_id | relation | 6456840 | 9901468 | | | | | | | | 12/1460917 | 30637 | AccessShareLock | t
  46. multi_level_pay_rate_pkey | relation | 6456840 | 9901260 | | | | | | | | 3/1909581 | 21128 | AccessShareLock | t
  47. emp_pos_del | relation | 6456840 | 9901388 | | | | | | | | 3/1909581 | 21128 | AccessShareLock | t
  48. app_user | relation | 6456840 | 6456900 | | | | | | | | 12/1460917 | 30637 | AccessShareLock | t
  49. date_etl | relation | 6456840 | 6456954 | | | | | | | | 3/1909581 | 21128 | AccessShareLock | t
  50. app_user_email_key | relation | 6456840 | 9901182 | | | | | | | | 15/1028898 | 28715 | AccessShareLock | t
  51. i_date_year | relation | 6456840 | 9901404 | | | | | | | | 3/1909581 | 21128 | AccessShareLock | t
  52. user_location | relation | 6456840 | 6457360 | | | | | | | | 3/1909581 | 21128 | AccessShareLock | t
  53. role_pkey | relation | 6456840 | 9901314 | | | | | | | | 12/1460917 | 30637 | AccessShareLock | t
  54. app_user | relation | 6456840 | 6456900 | | | | | | | | 15/1028898 | 28715 | AccessShareLock | t
  55. location | relation | 6456840 | 6457041 | | | | | | | | 7/1596694 | 6336 | RowShareLock | t
  56. app_user_email_key | relation | 6456840 | 9901182 | | | | | | | | 12/1460917 | 30637 | AccessShareLock | t
  57. department_roll_up_pkey | relation | 6456840 | 18238576 | | | | | | | | 12/1460917 | 30637 | AccessShareLock | t
  58. corporation_del | relation | 6456840 | 9901384 | | | | | | | | 3/1909581 | 21128 | AccessShareLock | t
  59. location | relation | 6456840 | 6457041 | | | | | | | | 3/1909581 | 21128 | AccessShareLock | t
  60. pref_fri | relation | 6456840 | 9901434 | | | | | | | | 7/1596694 | 6336 | RowExclusiveLock | t
  61. user_loc_loc_id | relation | 6456840 | 9901468 | | | | | | | | 15/1028898 | 28715 | AccessShareLock | t
  62. loc_creator_id | relation | 6456840 | 9901410 | | | | | | | | 3/1909581 | 21128 | AccessShareLock | t
  63. department_roll_up | relation | 6456840 | 18238573 | | | | | | | | 12/1460917 | 30637 | AccessShareLock | t
  64. pref_fri | relation | 6456840 | 9901434 | | | | | | | | 3/1909581 | 21128 | AccessShareLock | t
  65. app_user_username_key | relation | 6456840 | 9901186 | | | | | | | | 3/1909581 | 21128 | AccessShareLock | t
  66. preference_pkey | relation | 6456840 | 9901276 | | | | | | | | 3/1909581 | 21128 | AccessShareLock | t
  67. app_user_pkey | relation | 6456840 | 9901184 | | | | | | | | 12/1460917 | 30637 | AccessShareLock | t
  68. loc_del | relation | 6456840 | 9901411 | | | | | | | | 12/1460917 | 30637 | AccessShareLock | t
  69. preference_pkey | relation | 6456840 | 9901276 | | | | | | | | 7/1596694 | 6336 | AccessShareLock | t
  70. preference_pkey | relation | 6456840 | 9901276 | | | | | | | | 7/1596694 | 6336 | RowExclusiveLock | t
  71. sales_paf_location_id | relation | 6456840 | 9901444 | | | | | | | | 12/1460917 | 30637 | AccessShareLock | t
  72. app_user_corp | relation | 6456840 | 9901380 | | | | | | | | 12/1460917 | 30637 | AccessShareLock | t
  73. station | relation | 6456840 | 6457292 | | | | | | | | 12/1460917 | 30637 | AccessShareLock | t
  74. position_del | relation | 6456840 | 9901425 | | | | | | | | 15/1028898 | 28715 | AccessShareLock | t
  75. pref_mon | relation | 6456840 | 9901435 | | | | | | | | 7/1596694 | 6336 | RowExclusiveLock | t
  76. app_user_del | relation | 6456840 | 9901381 | | | | | | | | 12/1460917 | 30637 | AccessShareLock | t
  77. pref_mon | relation | 6456840 | 9901435 | | | | | | | | 3/1909581 | 21128 | AccessShareLock | t
  78. attendance_block | relation | 6456840 | 6456912 | | | | | | | | 12/1460917 | 30637 | AccessShareLock | t
  79. preference_date_etl_pkey | relation | 6456840 | 9901274 | | | | | | | | 3/1909581 | 21128 | AccessShareLock | t
  80. timeblock_location | relation | 6456840 | 9901461 | | | | | | | | 12/1460917 | 30637 | AccessShareLock | t
  81. position_code_pkey | relation | 6456840 | 9901266 | | | | | | | | 12/1460917 | 30637 | AccessShareLock | t
  82. preference_date_etl_pkey | relation | 6456840 | 9901274 | | | | | | | | 7/1596694 | 6336 | AccessShareLock | t
  83. preference_date_etl_pkey | relation | 6456840 | 9901274 | | | | | | | | 7/1596694 | 6336 | RowExclusiveLock | t
  84. pref_all | relation | 6456840 | 9901427 | | | | | | | | 3/1909581 | 21128 | AccessShareLock | t
  85. employee_position_pkey | relation | 6456840 | 9901224 | | | | | | | | 12/1460917 | 30637 | AccessShareLock | t
  86. pref_all | relation | 6456840 | 9901427 | | | | | | | | 7/1596694 | 6336 | RowExclusiveLock | t
  87. attendance_block_pkey | relation | 6456840 | 9901188 | | | | | | | | 12/1460917 | 30637 | AccessShareLock | t
  88. pref_thur | relation | 6456840 | 9901439 | | | | | | | | 7/1596694 | 6336 | RowExclusiveLock | t
  89. timeblock_deleted | relation | 6456840 | 9901457 | | | | | | | | 12/1460917 | 30637 | AccessShareLock | t
  90. position_code | relation | 6456840 | 6457113 | | | | | | | | 12/1460917 | 30637 | AccessShareLock | t
  91. pg_class | relation | 6456840 | 1259 | | | | | | | | 6/1287459 | 9670 | AccessShareLock | t
  92. pref_thur | relation | 6456840 | 9901439 | | | | | | | | 3/1909581 | 21128 | AccessShareLock | t
  93. i_pref_idx | relation | 6456840 | 9901406 | | | | | | | | 3/1909581 | 21128 | RowExclusiveLock | t
  94. i_pref_idx | relation | 6456840 | 9901406 | | | | | | | | 7/1596694 | 6336 | AccessShareLock | t
  95. i_pref_idx | relation | 6456840 | 9901406 | | | | | | | | 7/1596694 | 6336 | RowExclusiveLock | t
  96. i_attendance_location_idx | relation | 6456840 | 9901399 | | | | | | | | 12/1460917 | 30637 | AccessShareLock | t
  97. user_role | relation | 6456840 | 6457363 | | | | | | | | 12/1460917 | 30637 | AccessShareLock | t
  98. invoice | relation | 6456840 | 6457035 | | | | | | | | 3/1909581 | 21128 | AccessShareLock | t
  99. e_attendanceb_idx | relation | 6456840 | 18831197 | | | | | | | | 2/2005817 | 8982 | RowExclusiveLock | t
  100. user_location_pkey | relation | 6456840 | 9901370 | | | | | | | | 15/1028898 | 28715 | AccessShareLock | t
  101. ft_start_idx | relation | 6456840 | 18830574 | | | | | | | | 12/1460917 | 30637 | AccessShareLock | t
  102. ft_start_idx | relation | 6456840 | 18830574 | | | | | | | | 12/1460917 | 30637 | RowExclusiveLock | t
  103. e_attendanceb_idx | relation | 6456840 | 18831197 | | | | | | | | 15/1028898 | 28715 | AccessShareLock | t
  104. sales_paf_pkey | relation | 6456840 | 9901316 | | | | | | | | 12/1460917 | 30637 | AccessShareLock | t
  105. employee | relation | 6456840 | 6456981 | | | | | | | | 3/1909581 | 21128 | AccessShareLock | t
  106. station_pkey | relation | 6456840 | 9901344 | | | | | | | | 12/1460917 | 30637 | AccessShareLock | t
  107. employee | relation | 6456840 | 6456981 | | | | | | | | 7/1596694 | 6336 | RowShareLock | t
  108. emp_del | relation | 6456840 | 9901387 | | | | | | | | 3/1909581 | 21128 | AccessShareLock | t
  109. sales_paf | relation | 6456840 | 6457228 | | | | | | | | 12/1460917 | 30637 | AccessShareLock | t
  110. idx_notify_sms | relation | 6456840 | 9901408 | | | | | | | | 12/1460917 | 30637 | AccessShareLock | t
  111. corporation_creator | relation | 6456840 | 9901383 | | | | | | | | 12/1460917 | 30637 | AccessShareLock | t
  112. i_attendance_allocated | relation | 6456840 | 9901394 | | | | | | | | 12/1460917 | 30637 | AccessShareLock | t
  113. user_loc_user_id | relation | 6456840 | 9901469 | | | | | | | | 15/1028898 | 28715 | AccessShareLock | t
  114. timeblock_schedule | relation | 6456840 | 9901463 | | | | | | | | 12/1460917 | 30637 | AccessShareLock | t
  115. emp_user_id | relation | 6456840 | 9901391 | | | | | | | | 15/1028898 | 28715 | AccessShareLock | t
  116. position_corp_id | relation | 6456840 | 9901424 | | | | | | | | 12/1460917 | 30637 | AccessShareLock | t
  117. emp_user_id | relation | 6456840 | 9901391 | | | | | | | | 2/2005817 | 8982 | RowExclusiveLock | t
  118. loc_corporation_id | relation | 6456840 | 9901409 | | | | | | | | 12/1460917 | 30637 | AccessShareLock | t
  119. user_corporation_id | relation | 6456840 | 9901466 | | | | | | | | 3/1909581 | 21128 | AccessShareLock | t
  120. schedule_loc | relation | 6456840 | 9901448 | | | | | | | | 15/1028898 | 28715 | AccessShareLock | t
  121. schedule_pkey | relation | 6456840 | 9901322 | | | | | | | | 15/1028898 | 28715 | AccessShareLock | t
  122. emp_pos_employee_id | relation | 6456840 | 9901389 | | | | | | | | 12/1460917 | 30637 | AccessShareLock | t
  123. app_user_lower_username_key | relation | 6456840 | 9901382 | | | | | | | | 3/1909581 | 21128 | AccessShareLock | t
  124. schedule_loc | relation | 6456840 | 9901448 | | | | | | | | 12/1460917 | 30637 | AccessShareLock | t
  125. schedule_pkey | relation | 6456840 | 9901322 | | | | | | | | 12/1460917 | 30637 | AccessShareLock | t
  126. employee_position | relation | 6456840 | 6456997 | | | | | | | | 3/1909581 | 21128 | AccessShareLock | t
  127. pref_enddate | relation | 6456840 | 9901432 | | | | | | | | 7/1596694 | 6336 | RowExclusiveLock | t
  128. loc_corporation_id | relation | 6456840 | 9901409 | | | | | | | | 15/1028898 | 28715 | AccessShareLock | t
  129. pref_enddate | relation | 6456840 | 9901432 | | | | | | | | 3/1909581 | 21128 | AccessShareLock | t
  130. user_loc_del | relation | 6456840 | 9901467 | | | | | | | | 3/1909581 | 21128 | AccessShareLock | t
  131. pid_preference_date_etl | relation | 6456840 | 9901419 | | | | | | | | 3/1909581 | 21128 | AccessShareLock | t
  132. user_role_pkey | relation | 6456840 | 9901372 | | | | | | | | 3/1909581 | 21128 | AccessShareLock | t
  133. emp_user_id | relation | 6456840 | 9901391 | | | | | | | | 12/1460917 | 30637 | AccessShareLock | t
  134. position_corp_id | relation | 6456840 | 9901424 | | | | | | | | 15/1028898 | 28715 | AccessShareLock | t
  135. pid_preference_date_etl | relation | 6456840 | 9901419 | | | | | | | | 7/1596694 | 6336 | AccessShareLock | t
  136. pid_preference_date_etl | relation | 6456840 | 9901419 | | | | | | | | 7/1596694 | 6336 | RowExclusiveLock | t
  137. idx_notify_sms | relation | 6456840 | 9901408 | | | | | | | | 15/1028898 | 28715 | AccessShareLock | t
  138. user_loc_user_id | relation | 6456840 | 9901469 | | | | | | | | 12/1460917 | 30637 | AccessShareLock | t
  139. forecast_timeblock_position_id | relation | 6456840 | 9901393 | | | | | | | | 12/1460917 | 30637 | AccessShareLock | t
  140. forecast_timeblock_position_id | relation | 6456840 | 9901393 | | | | | | | | 12/1460917 | 30637 | RowExclusiveLock | t
  141. invoice_pkey | relation | 6456840 | 9901236 | | | | | | | | 3/1909581 | 21128 | AccessShareLock | t
  142. timeblock_schedule | relation | 6456840 | 9901463 | | | | | | | | 15/1028898 | 28715 | AccessShareLock | t
  143. i_corp_petl | relation | 6456840 | 9901401 | | | | | | | | 3/1909581 | 21128 | AccessShareLock | t
  144. corporation | relation | 6456840 | 6456944 | | | | | | | | 12/1460917 | 30637 | AccessShareLock | t
  145. location_pkey | relation | 6456840 | 9901242 | | | | | | | | 3/1909581 | 21128 | AccessShareLock | t
  146. i_corp_petl | relation | 6456840 | 9901401 | | | | | | | | 7/1596694 | 6336 | AccessShareLock | t
  147. i_corp_petl | relation | 6456840 | 9901401 | | | | | | | | 7/1596694 | 6336 | RowExclusiveLock | t
  148. location_pkey | relation | 6456840 | 9901242 | | | | | | | | 7/1596694 | 6336 | AccessShareLock | t
  149. preference_conflict_etl_pkey | relation | 6456840 | 9901272 | | | | | | | | 3/1909581 | 21128 | AccessShareLock | t
  150. preference_conflict_etl_pkey | relation | 6456840 | 9901272 | | | | | | | | 3/1909581 | 21128 | RowExclusiveLock | t
  151. i_employee_termdate | relation | 6456840 | 9901405 | | | | | | | | 3/1909581 | 21128 | AccessShareLock | t
  152. user_location_pkey | relation | 6456840 | 9901370 | | | | | | | | 12/1460917 | 30637 | AccessShareLock | t
  153. preference_conflict_etl_pkey | relation | 6456840 | 9901272 | | | | | | | | 7/1596694 | 6336 | AccessShareLock | t
  154. preference_conflict_etl_pkey | relation | 6456840 | 9901272 | | | | | | | | 7/1596694 | 6336 | RowExclusiveLock | t
  155. e_attendanceb_idx | relation | 6456840 | 18831197 | | | | | | | | 12/1460917 | 30637 | AccessShareLock | t
  156. i_conf_idx | relation | 6456840 | 9901400 | | | | | | | | 3/1909581 | 21128 | RowExclusiveLock | t
  157. emp_pos_position_id | relation | 6456840 | 9901390 | | | | | | | | 3/1909581 | 21128 | AccessShareLock | t
  158. employee_pkey | relation | 6456840 | 9901222 | | | | | | | | 3/1909581 | 21128 | AccessShareLock | t
  159. i_conf_idx | relation | 6456840 | 9901400 | | | | | | | | 7/1596694 | 6336 | AccessShareLock | t
  160. i_conf_idx | relation | 6456840 | 9901400 | | | | | | | | 7/1596694 | 6336 | RowExclusiveLock | t
  161. sales_paf_salestype_id | relation | 6456840 | 9901445 | | | | | | | | 12/1460917 | 30637 | AccessShareLock | t
  162. employee_pkey | relation | 6456840 | 9901222 | | | | | | | | 7/1596694 | 6336 | AccessShareLock | t
  163. timeblock_deleted | relation | 6456840 | 9901457 | | | | | | | | 15/1028898 | 28715 | AccessShareLock | t
  164. position_code | relation | 6456840 | 6457113 | | | | | | | | 15/1028898 | 28715 | AccessShareLock | t
  165. multi_level_pay_rate | relation | 6456840 | 6457089 | | | | | | | | 12/1460917 | 30637 | AccessShareLock | t
  166. pref_weight | relation | 6456840 | 9901442 | | | | | | | | 3/1909581 | 21128 | AccessShareLock | t
  167. app_user | relation | 6456840 | 6456900 | | | | | | | | 7/1596694 | 6336 | RowShareLock | t
  168. location | relation | 6456840 | 6457041 | | | | | | | | 15/1028898 | 28715 | AccessShareLock | t
  169. sales_paf_type | relation | 6456840 | 9901446 | | | | | | | | 12/1460917 | 30637 | AccessShareLock | t
  170. pref_del | relation | 6456840 | 9901430 | | | | | | | | 3/1909581 | 21128 | AccessShareLock | t
  171. user_location | relation | 6456840 | 6457360 | | | | | | | | 12/1460917 | 30637 | AccessShareLock | t
  172. pref_weight | relation | 6456840 | 9901442 | | | | | | | | 7/1596694 | 6336 | RowExclusiveLock | t
  173. app_user | relation | 6456840 | 6456900 | | | | | | | | 3/1909581 | 21128 | AccessShareLock | t
  174. pref_del | relation | 6456840 | 9901430 | | | | | | | | 7/1596694 | 6336 | RowExclusiveLock | t
  175. i_date_local_date | relation | 6456840 | 9901402 | | | | | | | | 3/1909581 | 21128 | AccessShareLock | t
  176. timeblock_starttime | relation | 6456840 | 9901465 | | | | | | | | 12/1460917 | 30637 | AccessShareLock | t
  177. corporation_pkey | relation | 6456840 | 9901204 | | | | | | | | 12/1460917 | 30637 | AccessShareLock | t
  178. schedule_del | relation | 6456840 | 9901447 | | | | | | | | 12/1460917 | 30637 | AccessShareLock | t
  179. app_user_username_key | relation | 6456840 | 9901186 | | | | | | | | 15/1028898 | 28715 | AccessShareLock | t
  180. i_attendance_block_pos_id_idx | relation | 6456840 | 9901396 | | | | | | | | 12/1460917 | 30637 | AccessShareLock | t
  181. pg_locks | relation | 6456840 | 10969 | | | | | | | | 6/1287459 | 9670 | AccessShareLock | t
  182. emp_pos_del | relation | 6456840 | 9901388 | | | | | | | | 12/1460917 | 30637 | AccessShareLock | t
  183. user_loc_loc_id | relation | 6456840 | 9901468 | | | | | | | | 3/1909581 | 21128 | AccessShareLock | t
  184. multi_level_pay_rate_pkey | relation | 6456840 | 9901260 | | | | | | | | 12/1460917 | 30637 | AccessShareLock | t
  185. loc_creator_id | relation | 6456840 | 9901410 | | | | | | | | 15/1028898 | 28715 | AccessShareLock | t
  186. pref_approvalstatus | relation | 6456840 | 9901428 | | | | | | | | 7/1596694 | 6336 | RowExclusiveLock | t
  187. pg_class_relname_nsp_index | relation | 6456840 | 2663 | | | | | | | | 6/1287459 | 9670 | AccessShareLock | t
  188. timeblock_position | relation | 6456840 | 9901462 | | | | | | | | 15/1028898 | 28715 | AccessShareLock | t
  189. pref_approvalstatus | relation | 6456840 | 9901428 | | | | | | | | 3/1909581 | 21128 | AccessShareLock | t
  190. position_desc | relation | 6456840 | 9901426 | | | | | | | | 12/1460917 | 30637 | AccessShareLock | t
  191. schedule | relation | 6456840 | 6457234 | | | | | | | | 15/1028898 | 28715 | AccessShareLock | t
  192. timeblock_date_published | relation | 6456840 | 9901456 | | | | | | | | 12/1460917 | 30637 | AccessShareLock | t
  193. position_del | relation | 6456840 | 9901425 | | | | | | | | 3/1909581 | 21128 | AccessShareLock | t
  194. pref_sun | relation | 6456840 | 9901438 | | | | | | | | 3/1909581 | 21128 | AccessShareLock | t
  195. i_attendance_block_start_date_idx | relation | 6456840 | 9901397 | | | | | | | | 12/1460917 | 30637 | AccessShareLock | t
  196. pref_sun | relation | 6456840 | 9901438 | | | | | | | | 7/1596694 | 6336 | RowExclusiveLock | t
  197. preference | relation | 6456840 | 6457119 | | | | | | | | 7/1596694 | 6336 | RowShareLock | t
  198. preference | relation | 6456840 | 6457119 | | | | | | | | 7/1596694 | 6336 | RowExclusiveLock | t
  199. preference | relation | 6456840 | 6457119 | | | | | | | | 3/1909581 | 21128 | AccessShareLock | t
  200. preference | relation | 6456840 | 6457119 | | | | | | | | 3/1909581 | 21128 | RowShareLock | t
  201. pref_wed | relation | 6456840 | 9901441 | | | | | | | | 3/1909581 | 21128 | AccessShareLock | t
  202. timeblock_employee_id | relation | 6456840 | 9901459 | | | | | | | | 12/1460917 | 30637 | AccessShareLock | t
  203. pref_wed | relation | 6456840 | 9901441 | | | | | | | | 7/1596694 | 6336 | RowExclusiveLock | t
  204. role_name | relation | 6456840 | 9901443 | | | | | | | | 12/1460917 | 30637 | AccessShareLock | t
  205. user_role_user_id | relation | 6456840 | 9901470 | | | | | | | | 3/1909581 | 21128 | AccessShareLock | t
  206. position_code_pkey | relation | 6456840 | 9901266 | | | | | | | | 3/1909581 | 21128 | AccessShareLock | t
  207. preference_conflict_etl | relation | 6456840 | 6457125 | | | | | | | | 7/1596694 | 6336 | RowShareLock | t
  208. preference_conflict_etl | relation | 6456840 | 6457125 | | | | | | | | 7/1596694 | 6336 | RowExclusiveLock | t
  209. timeblock_employee_id | relation | 6456840 | 9901459 | | | | | | | | 15/1028898 | 28715 | AccessShareLock | t
  210. preference_conflict_etl | relation | 6456840 | 6457125 | | | | | | | | 3/1909581 | 21128 | RowShareLock | t
  211. preference_conflict_etl | relation | 6456840 | 6457125 | | | | | | | | 3/1909581 | 21128 | RowExclusiveLock | t
  212. employee_position_pkey | relation | 6456840 | 9901224 | | | | | | | | 3/1909581 | 21128 | AccessShareLock | t
  213. forecast_timeblock_location_id | relation | 6456840 | 9901392 | | | | | | | | 12/1460917 | 30637 | AccessShareLock | t
  214. forecast_timeblock_location_id | relation | 6456840 | 9901392 | | | | | | | | 12/1460917 | 30637 | RowExclusiveLock | t
  215. app_user_corp | relation | 6456840 | 9901380 | | | | | | | | 3/1909581 | 21128 | AccessShareLock | t
  216. station | relation | 6456840 | 6457292 | | | | | | | | 3/1909581 | 21128 | AccessShareLock | t
  217. pref_startdate | relation | 6456840 | 9901437 | | | | | | | | 3/1909581 | 21128 | AccessShareLock | t
  218. timeblock_position | relation | 6456840 | 9901462 | | | | | | | | 12/1460917 | 30637 | AccessShareLock | t
  219. app_user_del | relation | 6456840 | 9901381 | | | | | | | | 3/1909581 | 21128 | AccessShareLock | t
  220. position_desc | relation | 6456840 | 9901426 | | | | | | | | 15/1028898 | 28715 | AccessShareLock | t
  221. schedule | relation | 6456840 | 6457234 | | | | | | | | 12/1460917 | 30637 | AccessShareLock | t
  222. pref_startdate | relation | 6456840 | 9901437 | | | | | | | | 7/1596694 | 6336 | RowExclusiveLock | t
  223. timeblock_date_published | relation | 6456840 | 9901456 | | | | | | | | 15/1028898 | 28715 | AccessShareLock | t
  224. forecast_timeblock | relation | 6456840 | 6457025 | | | | | | | | 12/1460917 | 30637 | AccessShareLock | t
  225. forecast_timeblock | relation | 6456840 | 6457025 | | | | | | | | 12/1460917 | 30637 | RowExclusiveLock | t
  226. loc_creator_id | relation | 6456840 | 9901410 | | | | | | | | 12/1460917 | 30637 | AccessShareLock | t
  227. app_user_pkey | relation | 6456840 | 9901184 | | | | | | | | 7/1596694 | 6336 | AccessShareLock | t
  228. schedule_del | relation | 6456840 | 9901447 | | | | | | | | 15/1028898 | 28715 | AccessShareLock | t
  229. app_user_username_key | relation | 6456840 | 9901186 | | | | | | | | 12/1460917 | 30637 | AccessShareLock | t
  230. app_user_pkey | relation | 6456840 | 9901184 | | | | | | | | 3/1909581 | 21128 | AccessShareLock | t
  231. loc_del | relation | 6456840 | 9901411 | | | | | | | | 3/1909581 | 21128 | AccessShareLock | t
  232. pid_preference_conflict_etl | relation | 6456840 | 9901418 | | | | | | | | 3/1909581 | 21128 | AccessShareLock | t
  233. pid_preference_conflict_etl | relation | 6456840 | 9901418 | | | | | | | | 3/1909581 | 21128 | RowExclusiveLock | t
  234. timeblock_starttime | relation | 6456840 | 9901465 | | | | | | | | 15/1028898 | 28715 | AccessShareLock | t
  235. pid_preference_conflict_etl | relation | 6456840 | 9901418 | | | | | | | | 7/1596694 | 6336 | AccessShareLock | t
  236. pid_preference_conflict_etl | relation | 6456840 | 9901418 | | | | | | | | 7/1596694 | 6336 | RowExclusiveLock | t
  237. corporation_del | relation | 6456840 | 9901384 | | | | | | | | 12/1460917 | 30637 | AccessShareLock | t
  238. location | relation | 6456840 | 6457041 | | | | | | | | 12/1460917 | 30637 | AccessShareLock | t
  239. location | relation | 6456840 | 6457041 | | | | | | | | 12/1460917 | 30637 | RowShareLock | t
  240. user_location | relation | 6456840 | 6457360 | | | | | | | | 15/1028898 | 28715 | AccessShareLock | t
  241. app_user_email_key | relation | 6456840 | 9901182 | | | | | | | | 3/1909581 | 21128 | AccessShareLock | t
  242. user_loc_del | relation | 6456840 | 9901467 | | | | | | | | 15/1028898 | 28715 | AccessShareLock | t
  243. role | relation | 6456840 | 6457225 | | | | | | | | 12/1460917 | 30637 | AccessShareLock | t
  244. loc_corporation_id | relation | 6456840 | 9901409 | | | | | | | | 3/1909581 | 21128 | AccessShareLock | t
  245. user_corporation_id | relation | 6456840 | 9901466 | | | | | | | | 12/1460917 | 30637 | AccessShareLock | t
  246. emp_pos_employee_id | relation | 6456840 | 9901389 | | | | | | | | 3/1909581 | 21128 | AccessShareLock | t
  247. pg_class_oid_index | relation | 6456840 | 2662 | | | | | | | | 6/1287459 | 9670 | AccessShareLock | t
  248. app_user_lower_username_key | relation | 6456840 | 9901382 | | | | | | | | 15/1028898 | 28715 | AccessShareLock | t
  249. idx_notify_sms | relation | 6456840 | 9901408 | | | | | | | | 3/1909581 | 21128 | AccessShareLock | t
  250. corporation_creator | relation | 6456840 | 9901383 | | | | | | | | 3/1909581 | 21128 | AccessShareLock | t
  251. timeblock_deletedflag | relation | 6456840 | 9901458 | | | | | | | | 12/1460917 | 30637 | AccessShareLock | t
  252. timeblock_start_date | relation | 6456840 | 9901464 | | | | | | | | 15/1028898 | 28715 | AccessShareLock | t
  253. position_corp_id | relation | 6456840 | 9901424 | | | | | | | | 3/1909581 | 21128 | AccessShareLock | t
  254. timeblock_end_date | relation | 6456840 | 9901460 | | | | | | | | 12/1460917 | 30637 | AccessShareLock | t
  255. i_employee_termdate | relation | 6456840 | 9901405 | | | | | | | | 2/2005817 | 8982 | RowExclusiveLock | t
  256. timeblock_pkey | relation | 6456840 | 9901364 | | | | | | | | 15/1028898 | 28715 | AccessShareLock | t
  257. user_role | relation | 6456840 | 6457363 | | | | | | | | 3/1909581 | 21128 | AccessShareLock | t
  258. i_employee_termdate | relation | 6456840 | 9901405 | | | | | | | | 15/1028898 | 28715 | AccessShareLock | t
  259. i_date_petl | relation | 6456840 | 9901403 | | | | | | | | 3/1909581 | 21128 | AccessShareLock | t
  260. emp_del | relation | 6456840 | 9901387 | | | | | | | | 12/1460917 | 30637 | AccessShareLock | t
  261. pref_sat | relation | 6456840 | 9901436 | | | | | | | | 7/1596694 | 6336 | RowExclusiveLock | t
  262. i_date_petl | relation | 6456840 | 9901403 | | | | | | | | 7/1596694 | 6336 | AccessShareLock | t
  263. i_date_petl | relation | 6456840 | 9901403 | | | | | | | | 7/1596694 | 6336 | RowExclusiveLock | t
  264. employee | relation | 6456840 | 6456981 | | | | | | | | 12/1460917 | 30637 | AccessShareLock | t
  265. employee | relation | 6456840 | 6456981 | | | | | | | | 12/1460917 | 30637 | RowShareLock | t
  266. station_pkey | relation | 6456840 | 9901344 | | | | | | | | 3/1909581 | 21128 | AccessShareLock | t
  267. pref_sat | relation | 6456840 | 9901436 | | | | | | | | 3/1909581 | 21128 | AccessShareLock | t
  268. location_pkey | relation | 6456840 | 9901242 | | | | | | | | 15/1028898 | 28715 | AccessShareLock | t
  269. preference_date_etl | relation | 6456840 | 6457128 | | | | | | | | 7/1596694 | 6336 | AccessShareLock | t
  270. preference_date_etl | relation | 6456840 | 6457128 | | | | | | | | 7/1596694 | 6336 | RowExclusiveLock | t
  271. sales_date_idx | relation | 6456840 | 18831463 | | | | | | | | 12/1460917 | 30637 | AccessShareLock | t
  272. preference_date_etl | relation | 6456840 | 6457128 | | | | | | | | 3/1909581 | 21128 | AccessShareLock | t
  273. position_code | relation | 6456840 | 6457113 | | | | | | | | 3/1909581 | 21128 | AccessShareLock | t
  274. i_pref_petl | relation | 6456840 | 9901407 | | | | | | | | 7/1596694 | 6336 | AccessShareLock | t
  275. i_pref_petl | relation | 6456840 | 9901407 | | | | | | | | 7/1596694 | 6336 | RowExclusiveLock | t
  276. employee_pkey | relation | 6456840 | 9901222 | | | | | | | | 2/2005817 | 8982 | RowExclusiveLock | t
  277. forecast_timeblock_pkey | relation | 6456840 | 9901232 | | | | | | | | 12/1460917 | 30637 | AccessShareLock | t
  278. forecast_timeblock_pkey | relation | 6456840 | 9901232 | | | | | | | | 12/1460917 | 30637 | RowExclusiveLock | t
  279. timeblock | relation | 6456840 | 6457336 | | | | | | | | 12/1460917 | 30637 | AccessShareLock | t
  280. i_pref_petl | relation | 6456840 | 9901407 | | | | | | | | 3/1909581 | 21128 | AccessShareLock | t
  281. employee_pkey | relation | 6456840 | 9901222 | | | | | | | | 15/1028898 | 28715 | AccessShareLock | t
  282. pref_datecreated | relation | 6456840 | 9901429 | | | | | | | | 3/1909581 | 21128 | AccessShareLock | t
  283. timeblock | relation | 6456840 | 6457336 | | | | | | | | 15/1028898 | 28715 | AccessShareLock | t
  284. pref_datecreated | relation | 6456840 | 9901429 | | | | | | | | 7/1596694 | 6336 | RowExclusiveLock | t
  285. emp_pos_position_id | relation | 6456840 | 9901390 | | | | | | | | 12/1460917 | 30637 | AccessShareLock | t
  286. employee_pkey | relation | 6456840 | 9901222 | | | | | | | | 12/1460917 | 30637 | AccessShareLock | t
  287. pref_tue | relation | 6456840 | 9901440 | | | | | | | | 7/1596694 | 6336 | RowExclusiveLock | t
  288. pref_tue | relation | 6456840 | 9901440 | | | | | | | | 3/1909581 | 21128 | AccessShareLock | t
  289. multi_level_pay_rate | relation | 6456840 | 6457089 | | | | | | | | 3/1909581 | 21128 | AccessShareLock | t
  290. employee | relation | 6456840 | 6456981 | | | | | | | | 2/2005817 | 8982 | RowExclusiveLock | t
  291. emp_del | relation | 6456840 | 9901387 | | | | | | | | 15/1028898 | 28715 | AccessShareLock | t
  292. employee | relation | 6456840 | 6456981 | | | | | | | | 15/1028898 | 28715 | AccessShareLock | t
  293. emp_del | relation | 6456840 | 9901387 | | | | | | | | 2/2005817 | 8982 | RowExclusiveLock | t
  294. corporation | relation | 6456840 | 6456944 | | | | | | | | 3/1909581 | 21128 | AccessShareLock | t
  295. location_pkey | relation | 6456840 | 9901242 | | | | | | | | 12/1460917 | 30637 | AccessShareLock | t
  296. user_location_pkey | relation | 6456840 | 9901370 | | | | | | | | 3/1909581 | 21128 | AccessShareLock | t
  297. pref_freq | relation | 6456840 | 9901433 | | | | | | | | 3/1909581 | 21128 | AccessShareLock | t
  298. e_attendanceb_idx | relation | 6456840 | 18831197 | | | | | | | | 3/1909581 | 21128 | AccessShareLock | t
  299. timeblock_pkey | relation | 6456840 | 9901364 | | | | | | | | 12/1460917 | 30637 | AccessShareLock | t
  300. employee | tuple | 6456840 | 6456981 | 18805 | 99 | | | | | | 2/2005817 | 8982 | ExclusiveLock | t
  301. pref_employee_id | relation | 6456840 | 9901431 | | | | | | | | 7/1596694 | 6336 | RowExclusiveLock | t
  302. i_employee_termdate | relation | 6456840 | 9901405 | | | | | | | | 12/1460917 | 30637 | AccessShareLock | t
  303. pref_freq | relation | 6456840 | 9901433 | | | | | | | | 7/1596694 | 6336 | RowExclusiveLock | t
  304. pref_employee_id | relation | 6456840 | 9901431 | | | | | | | | 3/1909581 | 21128 | AccessShareLock | t
  305. timeblock_deletedflag | relation | 6456840 | 9901458 | | | | | | | | 15/1028898 | 28715 | AccessShareLock | t
  306. timeblock_start_date | relation | 6456840 | 9901464 | | | | | | | | 12/1460917 | 30637 | AccessShareLock | t
  307. i_attendance_block_emp_id_idx | relation | 6456840 | 9901395 | | | | | | | | 12/1460917 | 30637 | AccessShareLock | t
  308. timeblock_end_date | relation | 6456840 | 9901460 | | | | | | | | 15/1028898 | 28715 | AccessShareLock | t
  309. user_role_pkey | relation | 6456840 | 9901372 | | | | | | | | 12/1460917 | 30637 | AccessShareLock | t
  310. emp_user_id | relation | 6456840 | 9901391 | | | | | | | | 3/1909581 | 21128 | AccessShareLock | t
  311. user_loc_user_id | relation | 6456840 | 9901469 | | | | | | | | 3/1909581 | 21128 | AccessShareLock | t
  312. user_corporation_id | relation | 6456840 | 9901466 | | | | | | | | 15/1028898 | 28715 | AccessShareLock | t
  313. app_user_lower_username_key | relation | 6456840 | 9901382 | | | | | | | | 12/1460917 | 30637 | AccessShareLock | t
  314. user_loc_del | relation | 6456840 | 9901467 | | | | | | | | 12/1460917 | 30637 | AccessShareLock | t
  315. employee_position | relation | 6456840 | 6456997 | | | | | | | | 12/1460917 | 30637 | AccessShareLock | t
  316. (283 rows)
  317.  
  318. Looking for pg_locks for this pid
  319. relation | pid | mode | granted | relname
  320. ----------+-------+------------------+---------+----------------------
  321. 6457228 | 30637 | AccessShareLock | t | sales_paf
  322. 6457234 | 30637 | AccessShareLock | t | schedule
  323. 6457106 | 30637 | RowShareLock | t | position
  324. 6457106 | 30637 | AccessShareLock | t | position
  325. 6457137 | 30637 | AccessShareLock | t | price_object
  326. 6457225 | 30637 | AccessShareLock | t | role
  327. 6457041 | 30637 | RowShareLock | t | location
  328. 6457041 | 30637 | AccessShareLock | t | location
  329. 6456997 | 30637 | AccessShareLock | t | employee_position
  330. 6457025 | 30637 | RowExclusiveLock | t | forecast_timeblock
  331. 6457025 | 30637 | AccessShareLock | t | forecast_timeblock
  332. 6456981 | 30637 | RowShareLock | t | employee
  333. 6456981 | 30637 | AccessShareLock | t | employee
  334. 6457336 | 30637 | AccessShareLock | t | timeblock
  335. 18238573 | 30637 | AccessShareLock | t | department_roll_up
  336. 6457360 | 30637 | AccessShareLock | t | user_location
  337. 6457089 | 30637 | AccessShareLock | t | multi_level_pay_rate
  338. 6456912 | 30637 | AccessShareLock | t | attendance_block
  339. 6456958 | 30637 | RowShareLock | t | department
  340. 6456958 | 30637 | AccessShareLock | t | department
  341. 6456944 | 30637 | AccessShareLock | t | corporation
  342. 6457113 | 30637 | AccessShareLock | t | position_code
  343. 6457292 | 30637 | AccessShareLock | t | station
  344. 6456900 | 30637 | AccessShareLock | t | app_user
  345. 6457363 | 30637 | AccessShareLock | t | user_role
  346. (25 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!