Postgres AT TIME ZONE 'UTC' does NOT do what you think it does
And why you may need to repeat AT TIME ZONE 'UTC' twice.
SUMMARY
* AT TIME ZONE 'UTC' converts the data type from timestamptz to timestamp (example).
* Now you are inadvertently using the timestamp without time zone (aka timestamp) data type, which is markedly discouraged.
* There are