I am so sorry you did not have access to some sort of pain med to help you through the procedure. I will admit with my anxiety that I would never sit still for the test without sedation of some sort. We are lucky to have access to pain coverage most of the time with procedures.
I wish you luck with the manometry test.