It depends on the area you're getting your piece done on. Some areas are more sensitive than others. If your tattooist is legit and professional hell tell you how to care for your new tattoo. Most will say apply some A+D ointment on it for a week.
Some say , tattoos hurt to test your resolve. Yes and don't sleep on it or it's gonna ruin the ink and you'll have to get it redone. I refer you to the TAT MASTAH who has a GIANT PIECE on his pec. @Ihav2fart
My friend got a pretty sizeable tattoo across her back, and she said it hurt but not absolutely horribly. However, she said it was sensitive and hurt still afterwards. Just build up some mental power and brace yourself. You can do this! :D