Yes a discogram is very painful. I had to have one before my lumbar fusion, 4 levels. I was given a valium but you have to be awake. They test the discs in order to find the pain generator.

Hope that this helps