In supply and consumption certain nutrient ratios matter but not in water concentrations (standing stock of nutrients).
If we take the example of the Redfield ratio N:P 16:1 and you have for example a culture of plankton algae, it makes sense if the supply is also in the ratio 16:1 to create a steady state if you want to run a
chemostat culture.
You may run a reef tank similar to a chemostat by creating a steady state of supply and consumption. Then the nutrient concentrations in your reef tank remain constant and, if you want, at low concentrations without getting limiting. Ratios of consumption in reef tanks will differ from the Redfield ratio.