when you don't specify

host

in the query, it goes and gets all. When you do, the pg optimizer only hits the ones you said to