db_name => select * from pg_locks where pid = 45726;
locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath
------------+----------+----------+------+-------+------------+---------------+---------+-------+----------+--------------------+-------+-----------------+---------+----------
relation | 20485 | 11682 | | | | | | | | 306/1927 | 45726 | AccessShareLock | t | t
virtualxid | | | | | 306/1927 | | | | | 306/1927 | 45726 | ExclusiveLock | t | t
relation | 0 | 1262 | | | | | | | | 306/1927 | 45726 | AccessShareLock | t | f
relation | 0 | 2677 | | | | | | | | 306/1927 | 45726 | AccessShareLock | t | f
relation | 0 | 2671 | | | | | | | | 306/1927 | 45726 | AccessShareLock | t | f
relation | 0 | 1260 | | | | | | | | 306/1927 | 45726 | AccessShareLock | t | f
relation | 0 | 2672 | | | | | | | | 306/1927 | 45726 | AccessShareLock | t | f
relation | 0 | 2676 | | | | | | | | 306/1927 | 45726 | AccessShareLock | t | f
(8 rows)