Hope the endo went well. I do all that stuff without sedation. Versed doesn't do anthing for pain, just makes you forget it.
Which side is the chest pain? Arm and jaw pain, especially on the left indicate heart.
The least invasive and least nasty of the tests to see if you have a hernia is the barium swallow. They can also get an dea if you are swallowing ok or have something like nutcracker esophagus.
It's common for women to get a hernia from pregnancy. If it's just the garden variety hiatal hernia, it's no big deal. If it's paraesophageal (stuck in chest), then you need surgery because the stomach can twist and strangulate.
Having had all the tests and finally ending up needing the surgery, I recommend asking for the barium, even before an endoscopy or other esophagus tests. No sedation!