According to Longman Dictionary of Phrasal Verbs, to go out like a light means to lose consciousness.
According to Oxford Advanced Learner's Dictionary, to go out like a light means to go to sleep very quickly.
Which explanation is correct?