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.
{
"@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/112478092727004509",
"type": "Note",
"summary": null,
"inReplyTo": "https://fosstodon.org/users/derekkraan/statuses/112478091225839118",
"published": "2024-05-21T08:18:11Z",
"url": "https://fosstodon.org/@derekkraan/112478092727004509",
"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/112478092727004509",
"inReplyToAtomUri": "https://fosstodon.org/users/derekkraan/statuses/112478091225839118",
"conversation": "tag:fosstodon.org,2024-05-21:objectId=210523424:objectType=Conversation",
"content": "<p>Because a long-running transaction then causes dead rows to accumulate! And THIS is a problem because when you do a SELECT query, Postgres has to read all the rows (also dead ones) to know which rows you need. Indexes can't save you since they also point to dead rows.</p><p>Now your database has to do way more work to process the same queries. And this trend continues until the transaction ends, meaning that a crash is inevitable if the transaction continues indefinitely.</p><p>4/🧵</p>",
"contentMap": {
"en": "<p>Because a long-running transaction then causes dead rows to accumulate! And THIS is a problem because when you do a SELECT query, Postgres has to read all the rows (also dead ones) to know which rows you need. Indexes can't save you since they also point to dead rows.</p><p>Now your database has to do way more work to process the same queries. And this trend continues until the transaction ends, meaning that a crash is inevitable if the transaction continues indefinitely.</p><p>4/🧵</p>"
},
"attachment": [],
"tag": [],
"replies": {
"id": "https://fosstodon.org/users/derekkraan/statuses/112478092727004509/replies",
"type": "Collection",
"first": {
"type": "CollectionPage",
"next": "https://fosstodon.org/users/derekkraan/statuses/112478092727004509/replies?min_id=112478094490042982&page=true",
"partOf": "https://fosstodon.org/users/derekkraan/statuses/112478092727004509/replies",
"items": [
"https://fosstodon.org/users/derekkraan/statuses/112478094490042982"
]
}
},
"likes": {
"id": "https://fosstodon.org/users/derekkraan/statuses/112478092727004509/likes",
"type": "Collection",
"totalItems": 1
},
"shares": {
"id": "https://fosstodon.org/users/derekkraan/statuses/112478092727004509/shares",
"type": "Collection",
"totalItems": 0
}
}