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