PGXC_LOCK_CONFLICTS
PGXC_LOCK_CONFLICTS displays information about conflicting locks in the cluster.
When a lock is waiting for another lock or another lock is waiting for this one, a lock conflict occurs.
Currently, PGXC_LOCK_CONFLICTS collects only information about locks whose locktype is relation, partition, page, tuple, or transactionid.
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. |
username |
name |
Name of the user who applies for the lock |
gxid |
xid |
ID of the transaction that applies for the lock |
xactstart |
timestamp with time zone |
Start time of the transaction that applies for the lock |
queryid |
bigint |
Latest query ID of the thread that applies for the lock |
query |
text |
Latest query statement of the thread that applies for the lock |
pid |
bigint |
ID of the thread that applies for the lock |
mode |
text |
Lock mode |
granted |
boolean |
|
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot