The song, on its own, is about being "comfortably numb" to the experience of being a rockstar. Roger Waters (the songwriter) realized this after being so pissed at a show one time that he spit on a rowdy fan. The part about the pinprick before the show
masterchicken's recent comments: