How do you know when NRE is subsiding?

A lot is written here about the dangers of unchecked/uncontrolled NRE or how nice it can be. But I haven’t really seen anything about how it feels when it wears off? How do you know? How much does it affect/change your relationship when it does?