Is your feature request related to a problem? Please describe.
It appears that the separate index on campaign_contact_tag.campaign_contact_id is unecessary, given the composite primary key index on (campaign_contact_id, tag_id) already exists https://www.postgresql.org/docs/current/indexes-multicolumn.html
Describe the solution you'd like
Drop the extra index (after verifying it doesn't actually have any effect
Describe alternatives you've considered
Keep it
Is your feature request related to a problem? Please describe.
It appears that the separate index on
campaign_contact_tag.campaign_contact_idis unecessary, given the composite primary key index on(campaign_contact_id, tag_id)already exists https://www.postgresql.org/docs/current/indexes-multicolumn.htmlDescribe the solution you'd like
Drop the extra index (after verifying it doesn't actually have any effect
Describe alternatives you've considered
Keep it