I just execute `SELECT count(*) FROM events` in the database the events are stored in
Please Login to reply.
select count(distinct author) from event; for nostr-rs-relay
Oh lol, I misread the thread, I thought Ounos asked about the total amount of events. Yes, this is the query I run for finding distinct pubkeys.
great, thank you