How exactly an Ecto stream works?

You know if to a Redshift database the Repo.stream can avoid brings the entire table at once?

I am using a postgres adapter to connect to Redshift.