you would use this saying when something is really bad. Like bad bad or smells bad.
Example one: Girl: I was going to go out with my friend tonight, but she canceled.
Girl 2: Isnt that just shit of a thousand horses. Example two: Guy: Oh my god did you smell that guys cologne!!!! Guy 2: Yes it smelt like shit from a thousand horses!!!