pain in one's arsed

adj.

Exhibiting physical and cognitive impairment from alcohol.

Source: Wiktionary