Question: are foreign keys indexed postgres?
Answer: Index at the target of a foreign key The referenced columns in the target table must have a primary key or unique constraint. Such constraints are implemented with unique indexes in PostgreSQL. Consequently, the target side of a foreign key is automatically indexed.