pg_locks.relation question

From: Daniel Westermann <daniel(dot)westermann(at)dbi-services(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: pg_locks.relation question
Date: 2018-04-18 12:05:37
Message-ID: 1717499812.27146.1524053137683.JavaMail.zimbra@dbi-services.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

session one:

locks=# begin;
BEGIN
locks=# alter table test add column b text;
ALTER TABLE
locks=#

Session 2 querying pg_locks for the PID from above:

locks=# select locktype,relation::regclass,mode from pg_locks where pid = 2026 and locktype = 'relation';
locktype | relation | mode
----------+----------+---------------------
relation | test | AccessExclusiveLock
relation | 17728 | AccessExclusiveLock
relation | 17726 | ShareLock
(3 rows)

What are these 17728 and 17726 OIDs? Nothing else is happening except these two sessions.

Thanks in advance
Daniel

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Vitaliy Garnashevich 2018-04-18 12:15:50 Tricking the optimizer
Previous Message Akshay Ballarpure 2018-04-18 12:02:57 Re: pg_upgrade help