It was the least painful of any procedure I've had done, getting my teeth cleaned at the dentist was worse.
Basically, its about a 30 min. procedure. The only discomfort you'll have is in the first 3 days, if you do not wear briefs, or something to hold your sac up tight, then it'll become alittle sore. Wear a good pair of tight fitting briefs (the doc will tell you this) and your good to go.
Also, do not do ANYTHING for 3 days, no lifting anything heavier than 5 lbs. I made the mistake of lifting a couple of 25lb. LP tanks off my travel trailer into my pick up truck and had some black and blue marks down there!
Really, a trip to the dentist is worse than a V-sectomy.