Check out this before/after shot of our retainer client deploying a bunch of missing foreign key indexes identified by ids_must_be_indexed.

https://github.com/speedshop/ids_must_be_indexed