Postgres Compare with Date in Where Clause
Postgres will do the string to date conversion just once, because to_date is a STABLE function and the argument is a constant.

But if you’re worried about this, use the date literal syntax: date '2020-10-01'.

See https://www.postgresql.org/docs/current/datatype-datetime.html#DATATYPE-DATETIME-INPUT