For Mastodon, it depends how popular you get. The more followers on other instances you have, the more instances your instance has to send your post to whenever you make a post.

For Lemmy, I think the equivalent would be if you were hosting a community and you/others are posting in it, it then has to send to everyone who’s subbed. If you’re only hosting an instance to have an account, then it’s probably pretty lightweight.