I wouldn't consider it "good" more of just a random bacterial bloom which doesn't really have any effect on your water other than clouding it up. I've seen them last from a week all the way up to a month so it just depends on how long it will be around.