ActivityPub Viewer

A small tool to view real-world ActivityPub objects as JSON! Enter a URL or username from Mastodon or a similar service below, and we'll send a request with the right Accept header to the server to view the underlying object.

Open in browser →
{ "@context": [ "https://www.w3.org/ns/activitystreams", { "ostatus": "http://ostatus.org#", "atomUri": "ostatus:atomUri", "inReplyToAtomUri": "ostatus:inReplyToAtomUri", "conversation": "ostatus:conversation", "sensitive": "as:sensitive", "toot": "http://joinmastodon.org/ns#", "votersCount": "toot:votersCount" } ], "id": "https://fosstodon.org/users/derekkraan/statuses/112478091225839118", "type": "Note", "summary": null, "inReplyTo": "https://fosstodon.org/users/derekkraan/statuses/112478088689962575", "published": "2024-05-21T08:17:48Z", "url": "https://fosstodon.org/@derekkraan/112478091225839118", "attributedTo": "https://fosstodon.org/users/derekkraan", "to": [ "https://www.w3.org/ns/activitystreams#Public" ], "cc": [ "https://fosstodon.org/users/derekkraan/followers" ], "sensitive": false, "atomUri": "https://fosstodon.org/users/derekkraan/statuses/112478091225839118", "inReplyToAtomUri": "https://fosstodon.org/users/derekkraan/statuses/112478088689962575", "conversation": "tag:fosstodon.org,2024-05-21:objectId=210523424:objectType=Conversation", "content": "<p>What are dead rows anyways? Postgres runs on MVCC - Multi Version Concurrency Control. Basically, an UPDATE does not change a row in-place.</p><p>Instead, a new row is written, and the old row becomes &quot;dead&quot;. Dead rows can&#39;t be deleted right away, because they might still be visible to another transaction!</p><p>So VACUUM comes along later and cleans them up. But, VACUUM is smart, it doesn&#39;t delete any dead rows that a running transaction might be able to see! This is a problem, ...</p><p>3/🧵</p>", "contentMap": { "en": "<p>What are dead rows anyways? Postgres runs on MVCC - Multi Version Concurrency Control. Basically, an UPDATE does not change a row in-place.</p><p>Instead, a new row is written, and the old row becomes &quot;dead&quot;. Dead rows can&#39;t be deleted right away, because they might still be visible to another transaction!</p><p>So VACUUM comes along later and cleans them up. But, VACUUM is smart, it doesn&#39;t delete any dead rows that a running transaction might be able to see! This is a problem, ...</p><p>3/🧵</p>" }, "attachment": [], "tag": [], "replies": { "id": "https://fosstodon.org/users/derekkraan/statuses/112478091225839118/replies", "type": "Collection", "first": { "type": "CollectionPage", "next": "https://fosstodon.org/users/derekkraan/statuses/112478091225839118/replies?min_id=112478092727004509&page=true", "partOf": "https://fosstodon.org/users/derekkraan/statuses/112478091225839118/replies", "items": [ "https://fosstodon.org/users/derekkraan/statuses/112478092727004509" ] } }, "likes": { "id": "https://fosstodon.org/users/derekkraan/statuses/112478091225839118/likes", "type": "Collection", "totalItems": 1 }, "shares": { "id": "https://fosstodon.org/users/derekkraan/statuses/112478091225839118/shares", "type": "Collection", "totalItems": 0 } }