da=# SELECT locktype,(SELECT datname FROM pg_database WHERE oid=database),relation::regclass,page,tuple,virtualxid,transactionid,classid,objid,objsubid,virtualtransaction,pid,mode,granted,fastpath FROM pg_locks WHERE pid IN (22607) ORDER BY pid;
  locktype  | datname |     relation      | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction |  pid  |      mode       | granted | fastpath
------------+---------+-------------------+------+-------+------------+---------------+---------+-------+----------+--------------------+-------+-----------------+---------+----------
 virtualxid |         |                   |      |       | 2/136      |               |         |       |          | 2/136              | 22607 | ExclusiveLock   | t       | t
 relation   | da      | files             |      |       |            |               |         |       |          | 2/136              | 22607 | AccessShareLock | f       | f
 relation   | da      | kaltura_file_meta |      |       |            |               |         |       |          | 2/136              | 22607 | AccessShareLock | t       | f
(3 rows)
da=# SELECT locktype,(SELECT datname FROM pg_database WHERE oid=database),relation::regclass,page,tuple,virtualxid,transactionid,classid,objid,objsubid,virtualtransaction,pid,mode,granted,fastpath FROM pg_locks WHERE pid IN (22591) AND relation IN ('files'::regclass, 'kaltura_file_meta'::regclass) ORDER BY pid;
 locktype | datname |     relation      | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction |  pid  |        mode         | granted | fastpath
----------+---------+-------------------+------+-------+------------+---------------+---------+-------+----------+--------------------+-------+---------------------+---------+----------
 relation | da      | files             |      |       |            |               |         |       |          | 1/0                | 22591 | AccessExclusiveLock | t       | f
 relation | da      | kaltura_file_meta |      |       |            |               |         |       |          | 1/0                | 22591 | AccessExclusiveLock | f       | f
(2 rows)