hpc=> SELECT relation::regclass, * FROM pg_locks;
           relation                | relation         | database     | transaction   |  pid      |       mode                   | granted 
------------------------------+-----------------+----------------+-----------------+---------+--------------------------+-----------
                                         |                       |                       |     1937675  | 13460 | ExclusiveLock         | t
 unq_jobid_job_sc       | 104407136 |     17230       |                       | 13460 | AccessShareLock  | t
 119630289                   | 119630289 | 119629930 |                       | 16189 | AccessShareLock  | t
 119630518                   | 119630518 | 119629930 |                       | 30216 | AccessShareLock  | t
 jobstat_sc_q1_2005   | 109633116 |     17230      |                       | 13460 | AccessShareLock  | t
 119630272                   | 119630272 | 119629930 |                       | 16189 | AccessShareLock  | t
                                         |                       |                       |     1884803  | 30216 | ExclusiveLock         | t
 119630839                   | 119630839 | 119629930 |                       | 30216 | AccessShareLock  | t
 119630247                   | 119630247 | 119629930 |                       | 30216 | AccessShareLock  | t
 119630285                   | 119630285 | 119629930 |                       | 30216 | AccessShareLock  | t
 job_sc                            |     17464      |     17230       |             | 17137 | AccessShareLock  | t
 119630268                   | 119630268 | 119629930 |             | 30216 | AccessShareLock  | t
 job_sc                            |     17464 |     17230 |                       | 13460 | AccessShareLock  | t
 job_sc                            |     17464 |     17230 |                       | 13460 | RowShareLock     | t
 job_sc                            |     17464 |     17230 |                       | 13460 | RowExclusiveLock | t
 pg_locks                        |     16839 |     17230 |                       |  6087 | AccessShareLock  | t
                                         |                  |                  |     1877725 | 16189 | ExclusiveLock    | t
 119630299                    | 119630299 | 119629930 |             | 30216 | AccessShareLock  | t
 119630266                    | 119630266 | 119629930 |             | 30216 | AccessShareLock  | t
 119630293                    | 119630293 | 119629930 |             | 30216 | AccessShareLock  | t
 jobchars.user_alerts         |     17301 |     17230 |             | 17136 | AccessShareLock  | t
 119630827                    | 119630827 | 119629930 |             | 16189 | AccessShareLock  | t
 119630842                    | 119630842 | 119629930 |             | 16189 | AccessShareLock  | t
 jobchars.user_alerts         |     17301 |     17230 |             | 17137 | AccessShareLock  | t
 job_lc                       |     17455 |     17230 |             | 17136 | AccessShareLock  | t
                              |           |           |     1937668 |  6754 | ExclusiveLock    | t
 119630303                    | 119630303 | 119629930 |             | 30216 | AccessShareLock  | t
 119630311                    | 119630311 | 119629930 |             | 16189 | AccessShareLock  | t
 119630266                    | 119630266 | 119629930 |             | 16189 | AccessShareLock  | t
 jobchars.notification_queue  |     17288 |     17230 |             | 17137 | AccessShareLock  | t
 119630270                    | 119630270 | 119629930 |             | 30216 | AccessShareLock  | t
 119630285                    | 119630285 | 119629930 |             | 16189 | AccessShareLock  | t
 119630321                    | 119630321 | 119629930 |             | 16189 | AccessShareLock  | t
 node_sc                      |     17639 |     17230 |             | 13460 | AccessShareLock  | t
 119630827                    | 119630827 | 119629930 |             | 30216 | AccessShareLock  | t
 pg_type                      |      1247 | 119629930 |             | 30216 | AccessShareLock  | t
 119630293                    | 119630293 | 119629930 |             | 16189 | AccessShareLock  | t
 119630839                    | 119630839 | 119629930 |             | 16189 | AccessShareLock  | t
 119630830                    | 119630830 | 119629930 |             | 30216 | AccessShareLock  | t
 jobstat_lc_q4_2004_fetchtime | 104407276 |     17230 |             |  6754 | AccessShareLock  | t
                              |           |           |     1937676 | 17137 | ExclusiveLock    | t
 pg_type                      |      1247 | 119629930 |             | 16189 | AccessShareLock  | t
 119630851                    | 119630851 | 119629930 |             | 30216 | AccessShareLock  | t
 119630321                    | 119630321 | 119629930 |             | 30216 | AccessShareLock  | t
 actv_jobstat_sc_q1_2005      | 109633040 |     17230 |             | 13460 | AccessShareLock  | t
 actv_jobstat_sc_q1_2005      | 109633040 |     17230 |             | 13460 | RowExclusiveLock | t
                              |           |           |     1937677 |  6087 | ExclusiveLock    | t
 119630272                    | 119630272 | 119629930 |             | 30216 | AccessShareLock  | t
 119630851                    | 119630851 | 119629930 |             | 16189 | AccessShareLock  | t
 119630268                    | 119630268 | 119629930 |             | 16189 | AccessShareLock  | t
 jobstat_lc_q4_2004           |     17565 |     17230 |             |  6754 | AccessShareLock  | t
 119630518                    | 119630518 | 119629930 |             | 16189 | AccessShareLock  | t
 119630830                    | 119630830 | 119629930 |             | 16189 | AccessShareLock  | t
                              |           |           |     1937672 | 17136 | ExclusiveLock    | t
 119630289                    | 119630289 | 119629930 |             | 30216 | AccessShareLock  | t
 119630311                    | 119630311 | 119629930 |             | 30216 | AccessShareLock  | t
 119630842                    | 119630842 | 119629930 |             | 30216 | AccessShareLock  | t
 job_lc                       |     17455 |     17230 |             | 17137 | AccessShareLock  | t
 job_sc                       |     17464 |     17230 |             | 17136 | AccessShareLock  | t
 119630303                    | 119630303 | 119629930 |             | 16189 | AccessShareLock  | t
(60 rows)