If the players head is partially above and below water, all terrain under sea level is visible, along with the terrain above sea level. The effect will activate and deactivate instantly, and has no "warm up" like the new underwater viewing mechanic. The screen shot is from creative mode, with my characters head half above and below the sea.