Good day,
Could someone update the last query here (it no longer works with current
postgres)?
https://wiki.postgresql.org/wiki/Lock_Monitoring
New query:
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
ORDER BY a.query_start;
Thanks!