pain in one's arsed

adj.

A drinker so far gone that fetching a glass of water becomes an ordeal for the entire household.

Source: Wiktionary