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)
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)
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
