Matty-kun on Nostr: huh maybe we’re already over one million posts.. pleroma=# select count(*) from ...
huh maybe we’re already over one million posts..
pleroma=# select count(*) from activities where data->>'type' IN ('Create') and local = true;
count
---------
1003114
(1 row)
Published at
2023-08-06 19:09:45Event JSON
{
"id": "df740c21c76d217b1dc28c7412d75232350a0ad2a50d134bc44171255a3ef953",
"pubkey": "8b347916be2cb3ab9687c9eb78a8d05224c045bce5b416bdd50169965eb0f45c",
"created_at": 1691348985,
"kind": 1,
"tags": [
[
"proxy",
"https://nicecrew.digital/objects/da5c8c02-f49a-4e90-aebd-cb271da8a4a5",
"activitypub"
]
],
"content": "huh maybe we’re already over one million posts..\n\npleroma=# select count(*) from activities where data-\u003e\u003e'type' IN ('Create') and local = true;\n count\n---------\n 1003114\n(1 row)",
"sig": "e979ab3c08db06f8f47fa6b3d7737ba07118d5e1fe1c0ee649c47543a10a8270289bbedf51e8d6ef1a2d70184ede69b8e92b23b57a4931a5cac1c114daaf8bc4"
}
