Dear all,
I am running below query on a database. why is it creating a exclusive lock on a virtualxid? I am running some SELECT queries and its creating an ExclusiveLock in virtualxid? is this normal?
SELECT datname, pid, state, query, age(clock_timestamp(), query_start) AS age
FROM pg_stat_activity
WHERE state <> 'idle'
--AND query NOT LIKE '% FROM pg_stat_activity %'
ORDER BY age;
|locktype |database|relation|page|tuple|virtualxid|transactionid|classid|objid|objsubid|virtualtransaction|pid |mode |granted|fastpath|waitstart|
|----------|--------|--------|----|-----|----------|-------------|-------|-----|--------|------------------|------|---------------|-------|--------|---------|
|relation |58,007 |12,073 | | | | | | | |5/165 |21,912|AccessShareLock|true |true | |
|virtualxid| | | | |5/165 | | | | |5/165 |21,912|ExclusiveLock |true |true | |
Thanks,
ACDBA
