pg_locks-exclusivelock for select queries
От
arun chirappurath
Тема
pg_locks-exclusivelock for select queries
Дата
Msg-id
CAA23Sdt_abrMxJnZbJj5-rr5Z5C1J_UXUnORnbuCg8x3TZ6JoA@mail.gmail.com
Список
Дерево обсуждения
pg_locks-exclusivelock for select queries arun chirappurath <arunsnmimt@gmail.com>
Re: pg_locks-exclusivelock for select queries Tom Lane <tgl@sss.pgh.pa.us>
Re: pg_locks-exclusivelock for select queries Laurenz Albe <laurenz.albe@cybertec.at>
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 по дате отправления
От: Laurenz Albe
Дата:
От: Daulat
Дата:
