How bad does sex hurt the first time?

I'm 17 and I feel like I'm ready to lose my virginity. I'm mainly just worried about the pain, especially after hearing so many stories from my friends and their personal experiences. So, is it as bad as everyone makes it out to be or am I just overthinking it?