Postgres Pro
Downloads
Home   >   mailing lists

pg_locks-exclusivelock for select queries - Mailing list pgsql-general

From arun chirappurath
Subject pg_locks-exclusivelock for select queries
Date
Msg-id CAA23Sdt_abrMxJnZbJj5-rr5Z5C1J_UXUnORnbuCg8x3TZ6JoA@mail.gmail.com
Whole thread Raw
Responses Re: pg_locks-exclusivelock for select queries
Re: pg_locks-exclusivelock for select queries
List pgsql-general
Tree view
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



pgsql-general by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: uncommitted xmin 3100586 from before xid cutoff 10339367 needs to be frozen
Next
From: Daulat
Date:
Subject: Re: uncommitted xmin 3100586 from before xid cutoff 10339367 needs to be frozen