No, the procedure isn't painful at all. It is performed under local or general anaesthesia, and the patient may be given some sedative, so they are more relaxed. It is not likely that you will feel pain after that, only slight discomfort.