PGXC_DEADLOCK

PGXC_DEADLOCK displays lock wait information generated due to distributed deadlocks.

Currently, PGXC_DEADLOCK collects only lock wait information about locks whose locktype is relation, partition, page, tuple, or transactionid.

**Table 1** PGXC_DEADLOCK columns
Name	Type	Description
locktype	text	Type of the locked object
nodename	name	Name of the node where the locked object resides
dbname	name	Name of the database where the locked object resides. The value is NULL if the locked object is a transaction.
nspname	name	Name of the namespace of the locked object
relname	name	Name of the relation targeted by the lock. The value is NULL if the object is not a relation or part of a relation.
partname	name	Name of the partition targeted by the lock. The value is NULL if the locked object is not a partition.
page	integer	Number of the page targeted by the lock. The value is NULL if the locked object is neither a page nor a tuple.
tuple	smallint	Number of the tuple targeted by the lock. The value is NULL if the locked object is not a tuple.
transactionid	xid	ID of the transaction targeted by the lock. The value is NULL if the locked object is not a transaction.
waitusername	name	Name of the user who waits for the lock
waitgxid	xid	ID of the transaction that waits for the lock
waitxactstart	timestamp with time zone	Start time of the transaction that waits for the lock
waitqueryid	bigint	Latest query ID of the thread that waits for the lock
waitquery	text	Latest query statement of the thread that waits for the lock
waitpid	bigint	ID of the thread that waits for the lock
waitmode	text	Mode of the waited lock
holdusername	name	Name of the user who holds the lock
holdgxid	xid	ID of the transaction that holds the lock
holdxactstart	timestamp with time zone	Start time of the transaction that holds the lock
holdqueryid	bigint	Latest query ID of the thread that holds the lock
holdquery	text	Latest query statement of the thread that holds the lock
holdpid	bigint	ID of the thread that holds the lock
holdmode	text	Mode of the held lock
waittime	timestamp with time zone	Timestamp when the lock wait starts. This column is available only in clusters of version 9.1.0.200 or later.
holdtime	timestamp with time zone	Timestamp when the lock starts to be held. This column is available only in clusters of version 9.1.0.200 or later.