Is transvaginal painful?

Mummies, is transvaginal ultrasound scary? The probe looks pretty intimidating😫