PGSQL - DBA - Blocking Queries

gistfile1.txt

SELECT 
    bl.pid as Blocked_PID,
    a.usename as Blocked_User,
    a.query as blocked_query,
    kl.pid as Blocking_PID,
    ka.usename as Blocking_User,
    ka.query as blocking_query,
    kl.locktype,
    to_char(age(now(), a.query_start),'HH24h:MIm:SSs') as Age
FROM (pg_catalog.pg_locks bl join pg_catalog.pg_stat_activity a on bl.pid = a.pid)
JOIN (pg_catalog.pg_locks kl join pg_catalog.pg_stat_activity ka on kl.pid = ka.pid)
ON bl.locktype = kl.locktype
        and bl.database is not distinct from kl.database
        and bl.relation is not distinct from kl.relation
        and bl.page is not distinct from kl.page
        and bl.tuple is not distinct from kl.tuple
        and bl.virtualxid is not distinct from kl.virtualxid
        and bl.transactionid is not distinct from kl.transactionid
        and bl.classid is not distinct from kl.classid
        and bl.objid is not distinct from kl.objid
        and bl.objsubid is not distinct from kl.objsubid
        and bl.pid != kl.pid
WHERE kl.granted and not bl.granted