I got mine done twice (my school forced me to take it out so I got it done again after I had finished school). The first time I did it, the pain was alright. My eye was just watering a bit but it wasn't too bad. The second time however, I got it done a bit higher up on my other nostril and it killedddddd! I'm convinced it struck a nerve or something; my left eye was constantly having water come out from it, it was like having a river going down my face. It's a tolerable amount of pain and it's definitely worth it but there might be a subtle pain for the next couple of days. I got mine done with a gun so I'm not sure if getting it done with a needle will give you a different amount of pain. By the way, make sure to clean it twice a day, and although they say you shouldn't take it out after 2 months, keep it in for around 4-5 months if you can. I took mine out after 2 months to replace it with the ring piercing instead of the stud, because everyone gets the stud at the beginning, and almost got an infection.