Local is only posts that have been made in your instance, the one you registered you account with.

Subscribed shows you posts from communities you’ve subscribed to, local or not.

All is every post made in every instance you’re federated with. But admins can block whole instances without your input and there’s no way for you to see defederated posts without making a new account on a federated instance so there’s that