gp_locks_on_resqueue

The gp_toolkit.gp_locks_on_resqueue view shows any locks currently being held on a resource queue, and associated session information about the query. This view is accessible to all users. However, non‑superusers will only be able to see the locks associated with their own sessions.

Column Description

Column	Description
lorusename	Name of the user running the session
lorrsqname	The resource queue name
lorlocktype	Type of the lockable object: `resource queue`
lorobjid	The OID of the resource queue on which the lock is held
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

lorusename

Name of the user running the session

lorrsqname

The resource queue name

lorlocktype

Type of the lockable object: resource queue

lorobjid

The OID of the resource queue on which the lock is held

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

gp_locks_on_relation

gp_log_command_timings