[PostgreSQL - List Locks]List database locks w SQL #psql

psql-list-database-locks-by-activity.sql

-- list databse locks hold by SQL statements for current DB instance, source: <https://wiki.postgresql.org/wiki/Lock_Monitoring>
SELECT a.datname,
         l.relation::regclass,
         l.transactionid,
         l.mode,
         l.GRANTED,
         a.usename,
         a.query,
         a.query_start,
         age(now(), a.query_start) AS "age",
         a.pid
FROM pg_stat_activity a
JOIN pg_locks l ON l.pid = a.pid
WHERE datname = current_database()
ORDER BY a.query_start;