Posgtres Needs Indices

[baileyckelly]

We need to add indexes to the dataservice postgres instance - especially with the growth of the link tables (biospecimen_genomic_file for example).

We should start with having indexes on the foreign keys where we're doing joins.

Commonly used ones:
Biospecimen: participant_id
Diagnosis: participant_id
Phenotype: participant_id
biospecimen_genomic_file: biospecimen_id & genomic_file_file
biospecimen_diagnosis: biospecimen_id & diganosis_id
family_relationship: participant1_id & participant2_id
sequencing_experiment_genomic_file: sequencing_experiment_id & genomic_file_id
task_genomic_file: genomic_file_id & task_id