Hi RSD ME
Adding to the wise comments from others, a while ago my partner needed an endoscopic examination. She got a sedative (long time ago so can't remember what it was) but was conscious throughout.
She was a bit drowsy afterwards but once we got home she was fine after a few hours.
I hope that all goes well for you

.