Question: who was piffy on a rock?
Answer: says an early form, known from the 1930s, is “sitting here like Piffy” or “sitting like Piffy on a rock bun”. It seems to be a humorous echo of “sitting like Patience on a monument”. As you say, it refers to a person who is being left out, ignored, or kept hanging about pointlessly.