Replying to Avatar Matty-kun

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)
Avatar
anime graf mays 🛰️🪐 2y ago

you would be, the count doesnt include people who deleted accounts (and their posts deleted)

pleroma=# select count(*) from activities where data->>'type' IN ('Create') and local = true;

count

---------

6442673

Reply to this note

Please Login to reply.

Discussion

Avatar
Matty-kun 2y ago

Ahh that's what I figured.

Avatar
mullvad 2y ago

Soon to be 6 MILLION OOOY VEEEY