Is it painful?

I have a consultation for a vasectomy Friday and am nervous as I know I will be awake during the quick procedure, but am curious if it is painful at all?