It’s an extra output on top of any transaction. The size depends on the length of the name, but it’s quite small.

If you choose a 4 byte name “owen” then it would be 42 vbytes in total to register. That’s 4200 sats fee, or $1.54 at current prices + the cost for the rest of the transaction (it can be any transaction as I said).