A Lorentzian analysis of the cosmological constant problem