Midrash su Salmi 90:14

Rabbi Zechariah said: The sleep at night is like this world, and the awakening of the morning is like the world to come. And just as || in the sleep of the night a man lies down and sleeps, and his spirit wanders over all the earth, and tells him in a dream whatever happens, as it is said, "In a dream, in a vision of the night… then he openeth the ears of men" (Job 33:15, 16), likewise (with) the dead, their spirit wanders over all the earth, and tells them all things that happen in the world, but they are silent and (yet) they give song and praise to God, who will quicken them in the future, as it is said, "Let the saints exult in glory" (Ps. 149:5). The awakening in the morning is like the future world. A parable—unto what is the matter to be likened? To a man who awakens out of his sleep, in like manner will the dead awaken in the future world, as it is said, "O satisfy us in the morning with thy loving-kindness" (Ps. 90:14).