On Thu, Mar 15, 2018 at 1:30 PM, Enrico Thierbach <e...@open-lab.org> wrote:
> Now I wonder if it is possible, given the id of one of the locked rows in > the queue table, to find out which connection/which transaction owns the > lock > I'd start here: https://www.postgresql.org/docs/10/static/view-pg-locks.html and the pg_stat_activity view: https://www.postgresql.org/docs/10/static/monitoring-stats.html#MONITORING-STATS-VIEWS-TABLE The system doesn't really understand your model ID/PK field - the system views and catalogs using system identifiers. David J.
