SELECT
clock_timestamp(),
pg_class.relname,
pg_locks.locktype,
pg_locks. DATABASE,
pg_locks.relation,
pg_locks.page,
pg_locks.tuple,
pg_locks.virtualtransaction,
pg_locks.pid,
pg_locks. MODE,
pg_locks. GRANTED
FROM
pg_locks
JOIN pg_class ON pg_locks.relation = pg_class.oid
WHERE
relname !~ '^pg_'
AND relname <> 'active_locks';