Inspector Knackered

adj.

The state of being drunk and investigating the morning's wreckage with a policeman's solemn authority.

Rilee was Inspector Knackered, examining the carpet for clues beside the abandoned glass.

Source: Wiktionary