As Frank said - be SURE it is transperineal biopsy!! Also be sure the uro has done plenty if them - if not go somewhere else. I know 2 people who were told it was going to be TP and then got standard painful rectal with complications. Also, the local anesthetic should be delivered by NERVE BLOCKS - 2 shots should do it.
Believe me, the idea of the biopsy was worse than the idea of having cancer, having heard so many horror stories. In fact it stopped me from seeking treatment sooner.
Best of luck to you and remember, this forum is where you go if you have any questions at all. The people here have done so much research and have been thru it all….