EGD. If you are referring to an EGD where the use a scope to look into your esophagus and stomach, then it should be painless since they will sedate you first.
Gastroscopy. Not at all! Have it done by a board certified gastroenterologist in a unit that uses propofol.
Meds help. Medications given during the procedure should keep you very comfortable during the time you have the procedure.