Night Visions (1990) by Wes Craven

Stubborn detective Tom Mackey, assigned to a Los Angeles murder case involving a couple of serial killings, gets increasingly frustrated with the dead end leads he’s following and the lack of appreciation he gets from his chief, police captain Keller. Enter Dr. Sally Powers, a fresh, clean cut psychology graduate who possesses supernatural powers. In a loose partnership the twosome gradually succeed in unraveling the killer’s motive and working-pattern.