nostr:nprofile1qy2hwumn8ghj7un9d3shjtnyd968gmewwp6kyqpqdacfrkvy6d97wefx87pqk9as542ptmdll3cwur82z0zclejywjkse0ccqc that is probably correct, but I would still like to make sure that my number is correc...
@utzer you can run SELECT network, COUNT(*) AS total_profiles
FROM contact
WHERE uid = 0
AND self = 0
AND network NOT IN ('feed', 'mail', '')
AND url NOT LIKE 'https://your-instance-domain.com%'
GROUP BY network;
from you sql, I got network
Network of the contact
total_profiles
apub
1313909
bsky
41664
dfrn
20073
dspr
478
stat
20
tmbl
2
that will give you a clear picture to what your instance is seeing and interacting in terms of actual users, then you can use that info to extrapolate across the broader fediverse get a cleaner picture of realistic numbers compared to what your admin instance reports,
FROM contact
WHERE uid = 0
AND self = 0
AND network NOT IN ('feed', 'mail', '')
AND url NOT LIKE 'https://your-instance-domain.com%'
GROUP BY network;
from you sql, I got network
Network of the contact
total_profiles
apub
1313909
bsky
41664
dfrn
20073
dspr
478
stat
20
tmbl
2
that will give you a clear picture to what your instance is seeing and interacting in terms of actual users, then you can use that info to extrapolate across the broader fediverse get a cleaner picture of realistic numbers compared to what your admin instance reports,