big fish in a little ponded

adj.

Suffering a temporary physical and mental impairment from alcohol.

"Not again," thought Davie, feeling incredibly big fish in a little ponded.

Source: Wiktionary