Possibly Useful Indexes for XNAT

CREATE INDEX wrk_workflowdata_category_btree

  ON wrk_workflowdata

  USING btree

  (category);

CREATE INDEX wrk_workflowdata_current_step_launch_time_btree

  ON wrk_workflowdata

  USING btree

  (current_step_launch_time );

CREATE INDEX wrk_workflowdata_id_btree

  ON wrk_workflowdata

  USING btree

  (id );

CREATE INDEX wrk_workflowdata_launch_time_btree

  ON wrk_workflowdata

  USING btree

  (launch_time);

CREATE INDEX wrk_workflowdata_pipeline_name_btree

  ON wrk_workflowdata

  USING btree

  (pipeline_name);

CREATE INDEX wrk_workflowdata_status_btree

  ON wrk_workflowdata

  USING btree

  (status );

CREATE INDEX xdat_element_access_xdat_element_access_id1_btree

  ON xdat_element_access

  USING btree

  (xdat_element_access_id);

CREATE INDEX xdat_element_access_xdat_usergroup_xdat_usergroup_id1

  ON xdat_element_access

  USING btree

  (xdat_usergroup_xdat_usergroup_id);

CREATE INDEX xdat_element_security_element_name1_btree

  ON xdat_element_security

  USING btree

  (element_name);

CREATE INDEX xdat_field_mapping_field_btree

  ON xdat_field_mapping

  USING btree

  (field);

CREATE INDEX xdat_field_mapping_field_value_btree

  ON xdat_field_mapping

  USING btree

  (field_value);

CREATE INDEX xdat_field_mapping_read_element_btree

  ON xdat_field_mapping

  USING btree

  (read_element);

CREATE INDEX xdat_field_mapping_set_xdat_field_mapping_set_id1_btree

  ON xdat_field_mapping_set

  USING btree

  (xdat_field_mapping_set_id);

CREATE INDEX xdat_meta_element_element_name_btree

  ON xdat_meta_element

  USING btree

  (element_name);

CREATE INDEX xdat_meta_element_xdat_meta_element_id1_btree

  ON xdat_meta_element

  USING btree

  (xdat_meta_element_id);

CREATE INDEX xdat_usergroup_id1_btree

  ON xdat_usergroup

  USING btree

  (id);

CREATE INDEX xdat_user_groupid_groupid1_btree

  ON xdat_user_groupid

  USING btree

  (groupid);

CREATE INDEX xdat_usergroup_xdat_usergroup_id1_btree

  ON xdat_usergroup

  USING btree

  (xdat_usergroup_id);

CREATE INDEX xdat_user_login1_btree

  ON xdat_user

  USING btree

  (login);

CREATE INDEX xdat_user_login_login_date_btree

  ON xdat_user_login

  USING btree

  (login_date );

CREATE INDEX xdat_user_login_session_id_btree

  ON xdat_user_login

  USING btree

  (session_id);

CREATE INDEX xdat_user_login_session_id_hash

  ON xdat_user_login

  USING hash

  (session_id);

CREATE INDEX xdat_user_xdat_user_id1_btree

  ON xdat_user

  USING btree

  (xdat_user_id);

CREATE INDEX xnat_experimentdata_id_btree

  ON xnat_experimentdata

  USING btree

  (id );

  CREATE INDEX xnat_experimentdata_meta_data_activation_date_btree

  ON xnat_experimentdata_meta_data

  USING btree

  (activation_date );

CREATE INDEX xnat_experimentdata_meta_data_insert_date_btree

  ON xnat_experimentdata_meta_data

  USING btree

  (insert_date );

CREATE INDEX xnat_experimentdata_meta_data_last_modified_btree

  ON xnat_experimentdata_meta_data

  USING btree

  (last_modified );

CREATE INDEX xnat_experimentdata_meta_data_meta_data_id_btree

  ON xnat_experimentdata_meta_data

  USING btree

  (meta_data_id );

  CREATE INDEX xnat_experimentdata_meta_data_status_btree

  ON xnat_experimentdata_meta_data

  USING btree

  (status );

CREATE INDEX xnat_experimentdata_project_btree

  ON xnat_experimentdata

  USING btree

  (project );

CREATE INDEX xnat_experimentdata_share_project_btree

   ON xnat_experimentdata_share

   USING btree

   (project );

CREATE INDEX xnat_imageassessordata_imagesession_id_btree

  ON xnat_imageassessordata

  USING btree

  (imagesession_id );

CREATE INDEX xnat_imagescandata_image_session_id_btree

  ON xnat_imagescandata

  USING btree

  (image_session_id);

CREATE INDEX xnat_projectdata_id_btree

  ON xnat_projectdata

  USING btree

  (id );

CREATE INDEX xnat_projectdata_secondary_id_btree

  ON xnat_projectdata

  USING btree

  (secondary_id );

CREATE INDEX xnat_projectparticipant_project_btree

  ON xnat_projectparticipant

  USING btree

  (project);

CREATE INDEX xnat_projectparticipant_subject_id_btree

  ON xnat_projectparticipant

  USING btree

  (subject_id );

CREATE INDEX xnat_subjectassessordata_subject_id_btree

  ON xnat_subjectassessordata

  USING btree

  (subject_id );

CREATE INDEX xnat_subjectdata_meta_data_status_btree

  ON xnat_subjectdata_meta_data

  USING btree

  (status);

CREATE INDEX xnat_subjectdata_project_btree

  ON xnat_subjectdata

  USING btree

  (project );

CREATE INDEX xs_item_cache_elementname_btree

  ON xs_item_cache

  USING btree

  (elementname );

CREATE INDEX xs_item_cache_ids_btree

  ON xs_item_cache

  USING btree

  (ids );