Similar to shitfaced - when you've hit your limits using a drug, such as weed or shrooms, and you become incoherent, having difficulty remembering simple things you usually would. The difference is, however, is how it's usually a mellow, calm feeling, rather than a
nauseous and
sickly one (very different to a
Bad Trip).