I find it interesting that the PostgreSQL comment table in Lemmy has no concept of which instance the comment came from, nor does it have local flag. Well, a comment row does have the ap_id field, but it is in a format that doesn’t really allow you to sort trivially by origin-instance.
Interestingly, from the “stuck join/subscribe” at LemmyRS, I can’t comment. I tried to comment twice and each time it just hangs after I post the comment: https://lemmyrs.org/post/31651