TIL that adding a unique constraint to a table in #postgres will automatically create an index.

I've discovered after noticing duplicated indexes in one of our tables.