> Fair point. I think if the user wants, she can join with > pg_stat_subscription based on PID and find the corresponding > subscription. However, if we want to identify everything via pg_locks > then I think we should also mention classid or database id as field1. > So, it would look like: field1: (pg_subscription's oid or current db > id); field2: OID of subscription in pg_subscription; field3: local or > remote xid; field4: 0/1 to differentiate between remote and local xid.
Sorry I missed the discussion related with LOCKTAG. +1 for adding a new tag like LOCKTAG_PARALLEL_APPLY, and I prefer field1 should be dbid because it is more useful for reporting a lock in DescribeLockTag(). Best Regards, Hayato Kuroda FUJITSU LIMITED
