Literally, a pissing contest is one in which a group of (usually drunk) men line up and see who can pee farther. This is supposed to be some sort of vague measure of a man's virility.
Figuratively, a pissing contest refers to any trivial or meaningless competition.