Night Visions (1990)

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. This leaves only one person that would fit the profile...