How will I feel after having the sedative for gastroscopy?

Relaxed and sleepy. You should feel relaxed and sleepy, and the procedure won't bother you at all.
Good! You will feel well and rested, particularly if they use propafol!