pain in the arsed

adj.

The condition of a drinker who has become an irritation to everyone within reach of the sofa.

Source: Wiktionary