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.
Column |
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. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.