Literally, a pissing contest is a 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.