Pie-eyed
Extremely drunk or extremely tired from the wide, staring eyes of those afflicted, resembling the tops of pies, dates from the late 19th/early 20th century.