It is mentioned in the hadith of al-Bara' ibn 'Azib (may Allah be pleased with him) that the Messenger (peace and blessings be upon him) spoke of the man when he is on his deathbed, the believer and the disbeliever.

The questioner : May Allah reward the honorableThe Shaykh : In the hadith of al-Bara' ibn 'Azib (may Allah be pleased with him), the Messenger (peace and blessings be upon him) spoke of the man when he is on his deathbed, the believer and the disbeliever: that for the believer, the gates of the heavens are opened for his soul, he is called by his best name, and his record is written in 'Ilyayn. And it is reported regarding the disbeliever that he is in Sijjin, and he is spread out in his grave from the Fire. Is there anything other than these two states?

The Shaykh : What appears, and Allah knows best, is that the soul of the believer ascends to the heavens and the gates of the heavens are opened for him. And the disbeliever, no. We are left with the disobedient believer. The disobedient believer is certainly not like the disbeliever. But does he join the pious believer or not? Allah knows best. We do not know. Then I say, O my brothers: Do not inquire into the matters of the unseen. Take what has been conveyed to you and leave what has not been conveyed, because the matters of the unseen are beyond the level of man. Do you see now your souls in your bodies? Can any one of you describe his soul? Answer. Never, except what has reached us from the Book and the Sunnah. And it is his soul between his two shoulders. On the Day of Resurrection, the sun will approach the creatures by the distance of a mile. The mile: either it is the distance, or it is the mile of the kohl stick, like a finger. This sun, which is far from us now, if it descended by the distance of a mile from its current course, the world would burn. And on the Day of Resurrection, it will not burn the people, even though it descends this descent, because the conditions of the Hereafter can never be measured by the conditions of this world. On the Day of Resurrection, the believers: May Allah make us and you among them. The disbelievers are in darkness. The hypocrites say to the believers: . And yet, the people are on the same plain. These, their light moves before them and on their right. And these are in darkness. This is it. So the mind does not comprehend this thing. But what is obligatory for us regarding the matters of the unseen is to say: We have heard and we have obeyed and we have believed. And not to measure it by the conditions of this world, due to the apparent great difference between this and that.
Last question.