pasjrwoctx👽 on Nostr: utzer you can run SELECT network, COUNT(*) AS total_profiles FROM contact WHERE uid = ...

utzer (nprofile…8a9w) 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,