This is an adjectival expression best used to describe people, places, things, moments, and events that are so annoying/stupid/ridiculous/grating that patience diminishes, moods deflate, and the threat of violence increases. Basically, this phrase can be used to describe anything or anyone that grates on your last nerve.

A polite term for shoving a lubricated probe into the Earth's hole to release gas.