gpadmin=# \d gp_toolkit.gp_locks_on_resqueue

View "gp_toolkit.gp_locks_on_resqueue"

     Column     |  Type   | Modifiers 

----------------+---------+-----------

 lorusename     | name    | 

 lorrsqname     | name    | 

 lorlocktype    | text    | 

 lorobjid       | oid     | 

 lortransaction | xid     | 

 lorpid         | integer | 

 lormode        | text    | 

 lorgranted     | boolean | 

 lorwaiting     | boolean | 

View definition:

 SELECT pgsa.usename AS lorusename, pgrq.rsqname AS lorrsqname, pgl.locktype AS lorlocktype, pgl.objid AS lorobjid, pgl.transaction AS lortransaction, pgl.pid AS lorpid, pgl.mode AS lormode, pgl.granted AS lorgranted, pgsa.waiting AS lorwaiting

   FROM pg_stat_activity pgsa

   JOIN pg_locks pgl ON pgsa.procpid = pgl.pid

   JOIN pg_resqueue pgrq ON pgl.objid = pgrq.oid;

lorusename=>Name of the user executing the session.

lorrsqname=>The resource queue name.

lorlocktype=>Type of the lockable object: resource queue

lorobjid=>The ID of the locked transaction.

lortransaction=>The ID of the transaction that is affected by the lock.

lorpid=>The process ID of the transaction that is affected by the lock.

lormode=>The name of the lock mode held or desired by this process.

lorgranted=>Displays whether the lock is granted (true) or not granted (false).

lorwaiting=>Displays whether or not the session is waiting.