2023-03-06 13:08:13,835 13:08:13.835 [main] INFO (OhdsiTestToolsAppPropertiesIntegrationTest.java:14) - Starting test... 2023-03-06 13:08:13,840 13:08:13.840 [main] INFO (OhdsiTestToolsAppPropertiesIntegrationTest.java:16) - dbms: postgresql 2023-03-06 13:08:13,840 13:08:13.840 [main] INFO (OhdsiTestToolsAppPropertiesIntegrationTest.java:18) - Done. 2023-03-06 13:08:13,843 13:08:13.843 [main] INFO (PostgresqlConnectionFactory.java:46) - Getting connection for url: jdbc:postgresql://localhost:5432/OHDSI?user=postgres&password=ohdsi¤tSchema=etl_synthea_1k 2023-03-06 13:08:14,352 13:08:14.352 [main] INFO (ConstraintFactoryIntegrationTest.java:21) - Starting test... 2023-03-06 13:08:14,355 13:08:14.355 [main] INFO (ConstraintFactoryIntegrationTest.java:46) - ----------------------------------------------- Got 28 constraints type cols schema_name table_name index_name column_list_as_string sql_string p (1) etl_synthea_1k care_site xpk_care_site care_site_id null p (1) etl_synthea_1k concept xpk_concept concept_id null p (1) etl_synthea_1k concept_class xpk_concept_class concept_class_id null p (1) etl_synthea_1k condition_era xpk_condition_era condition_era_id null p (1) etl_synthea_1k condition_occurrence xpk_condition_occurrence condition_occurrence_id null p (1) etl_synthea_1k cost xpk_cost cost_id null p (1) etl_synthea_1k device_exposure xpk_device_exposure device_exposure_id null p (1) etl_synthea_1k domain xpk_domain domain_id null p (1) etl_synthea_1k dose_era xpk_dose_era dose_era_id null p (1) etl_synthea_1k drug_era xpk_drug_era drug_era_id null p (1) etl_synthea_1k drug_exposure xpk_drug_exposure drug_exposure_id null p (1) etl_synthea_1k episode xpk_episode episode_id null p (1) etl_synthea_1k location xpk_location location_id null p (1) etl_synthea_1k measurement xpk_measurement measurement_id null p (1) etl_synthea_1k metadata xpk_metadata metadata_id null p (1) etl_synthea_1k note xpk_note note_id null p (1) etl_synthea_1k note_nlp xpk_note_nlp note_nlp_id null p (1) etl_synthea_1k observation xpk_observation observation_id null p (1) etl_synthea_1k observation_period xpk_observation_period observation_period_id null p (1) etl_synthea_1k payer_plan_period xpk_payer_plan_period payer_plan_period_id null p (1) etl_synthea_1k person xpk_person person_id null p (1) etl_synthea_1k procedure_occurrence xpk_procedure_occurrence procedure_occurrence_id null p (1) etl_synthea_1k provider xpk_provider provider_id null p (1) etl_synthea_1k relationship xpk_relationship relationship_id null p (1) etl_synthea_1k specimen xpk_specimen specimen_id null p (1) etl_synthea_1k visit_detail xpk_visit_detail visit_detail_id null p (1) etl_synthea_1k visit_occurrence xpk_visit_occurrence visit_occurrence_id null p (1) etl_synthea_1k vocabulary xpk_vocabulary vocabulary_id null Got 28 constraints ----------------------------------------------- 2023-03-06 13:08:14,355 13:08:14.355 [main] INFO (ConstraintFactoryIntegrationTest.java:47) - Done. 2023-03-06 13:08:14,355 13:08:14.355 [main] INFO (PostgresqlConnectionFactory.java:46) - Getting connection for url: jdbc:postgresql://localhost:5432/OHDSI?user=postgres&password=ohdsi¤tSchema=etl_synthea_1k 2023-03-06 13:08:14,407 13:08:14.407 [main] INFO (ConstraintFactoryIntegrationTest.java:21) - Starting test... 2023-03-06 13:08:14,425 13:08:14.425 [main] INFO (ConstraintFactoryIntegrationTest.java:46) - ----------------------------------------------- Got 217 constraints type cols schema_name table_name index_name column_list_as_string sql_string f (1) webapi achilles_cache achilles_cache_fk source_id null f (1) webapi analysis_generation_info fk_cgi_sec_user created_by_id null f (1) webapi batch_job_execution job_inst_exec_fk job_instance_id null f (1) webapi batch_job_execution_context job_exec_ctx_fk job_execution_id null f (1) webapi batch_job_execution_params job_exec_params_fk job_execution_id null f (1) webapi batch_step_execution job_exec_step_fk job_execution_id null f (1) webapi batch_step_execution_context step_exec_ctx_fk step_execution_id null f (1) webapi cc_analysis fk_c_char_a_cc cohort_characterization_id null f (1) webapi cc_analysis fk_c_char_a_fe_analysis fe_analysis_id null f (1) webapi cc_cohort fk_c_char_c_cc cohort_characterization_id null f (1) webapi cc_cohort fk_c_char_c_fe_analysis cohort_id null f (1) webapi cc_param fk_ccp_cc cohort_characterization_id null f (1) webapi cc_strata fk_cc_strata_cc cohort_characterization_id null f (1) webapi cc_strata_conceptset fk_cc_strata_conceptset_cc cohort_characterization_id null f (1) webapi cca cca_created_by_id_fkey created_by_id null f (1) webapi cca cca_modified_by_id_fkey modified_by_id null f (1) webapi cdm_cache cdm_cache_fk source_id null f (1) webapi cohort_analysis_gen_info fk_cagi_cohort_id cohort_id null f (2) webapi cohort_analysis_list_xref fk_calx_source_id cohort_id, source_id null f (1) webapi cohort_characterization fk_cc_ser_user_creator created_by_id null f (1) webapi cohort_characterization fk_cc_ser_user_updater modified_by_id null f (1) webapi cohort_characterization_tag cc_tags_fk_ccs asset_id null f (1) webapi cohort_characterization_tag cc_tags_fk_tags tag_id null f (1) webapi cohort_characterization_version fk_cc_version_asset_id asset_id null f (1) webapi cohort_characterization_version fk_cc_version_sec_user_creator created_by_id null f (1) webapi cohort_definition cohort_definition_created_by_id_fkey created_by_id null f (1) webapi cohort_definition cohort_definition_modified_by_id_fkey modified_by_id null f (1) webapi cohort_definition_details fk_cohort_definition_details_cohort_definition id null f (1) webapi cohort_generation_info cohort_generation_info_created_by_id_fkey created_by_id null f (1) webapi cohort_generation_info fk_cohort_generation_info_cohort_definition id null f (1) webapi cohort_sample fk_cohort_sample_definition_id cohort_definition_id null f (1) webapi cohort_sample fk_cohort_sample_source_id source_id null f (1) webapi cohort_tag cohort_tags_fk_definitions asset_id null f (1) webapi cohort_tag cohort_tags_fk_tags tag_id null f (1) webapi cohort_version fk_cohort_version_asset_id asset_id null f (1) webapi cohort_version fk_cohort_version_sec_user_creator created_by_id null f (1) webapi concept_set concept_set_created_by_id_fkey created_by_id null f (1) webapi concept_set concept_set_modified_by_id_fkey modified_by_id null f (1) webapi concept_set_generation_info fk_concept_set_generation_info_concept_set concept_set_id null f (1) webapi concept_set_tag concept_set_tags_fk_sets asset_id null f (1) webapi concept_set_tag concept_set_tags_fk_tags tag_id null f (1) webapi concept_set_version fk_concept_set_version_asset_id asset_id null f (1) webapi concept_set_version fk_concept_set_version_sec_user_creator created_by_id null f (1) webapi drug_hoi_evidence fk_drug_hoi_relationship drug_hoi_relationship null f (1) webapi drug_hoi_evidence fk_evidence_sources evidence_source_code_id null f (1) webapi estimation fk_estimation_ser_user_creator created_by_id null f (1) webapi estimation fk_estimation_ser_user_updater modified_by_id null f (1) webapi fe_analysis fe_analysis_created_by_id_fkey created_by_id null f (1) webapi fe_analysis fe_analysis_modified_by_id_fkey modified_by_id null f (1) webapi fe_analysis_conceptset fk_fe_conceptset_fe_analysis fe_analysis_id null f (1) webapi fe_analysis_criteria fk_criteria_aggregate fe_aggregate_id null f (1) webapi fe_analysis_criteria fk_fec_fe_analysis fe_analysis_id null f (1) webapi feas_study_generation_info fk_feas_study_generation_info_feasibility_study study_id null f (1) webapi feasibility_inclusion fk_feasibility_inclusion_feasibility_study study_id null f (1) webapi feasibility_study feasibility_study_created_by_id_fkey created_by_id null f (1) webapi feasibility_study feasibility_study_modified_by_id_fkey modified_by_id null f (1) webapi feasibility_study fk_feasibility_study_cohort_definition_index index_def_id null f (1) webapi feasibility_study fk_feasibility_study_cohort_definition_result result_def_id null f (1) webapi generation_cache fk_gc_source_id_source source_id null f (1) webapi ir_analysis ir_analysis_created_by_id_fkey created_by_id null f (1) webapi ir_analysis ir_analysis_modified_by_id_fkey modified_by_id null f (1) webapi ir_analysis_details fk_irad_ira id null f (1) webapi ir_tag ir_tags_fk_irs asset_id null f (1) webapi ir_tag ir_tags_fk_tags tag_id null f (1) webapi ir_version fk_ir_version_asset_id asset_id null f (1) webapi ir_version fk_ir_version_sec_user_creator created_by_id null f (1) webapi output_file_contents fk_ofc_of_id output_file_id null f (1) webapi pathway_event_cohort fk_pec_cd_id cohort_definition_id null f (1) webapi pathway_event_cohort fk_pec_pa_id pathway_analysis_id null f (1) webapi pathway_tag ir_tags_fk_irs asset_id null f (1) webapi pathway_tag ir_tags_fk_tags tag_id null f (1) webapi pathway_target_cohort fk_ptc_cd_id cohort_definition_id null f (1) webapi pathway_target_cohort fk_ptc_pa_id pathway_analysis_id null f (1) webapi pathway_version fk_pathway_version_asset_id asset_id null f (1) webapi pathway_version fk_pathway_version_sec_user_creator created_by_id null f (1) webapi plp plp_created_by_id_fkey created_by_id null f (1) webapi plp plp_modified_by_id_fkey modified_by_id null f (1) webapi prediction fk_prediction_ser_user_creator created_by_id null f (1) webapi prediction fk_prediction_ser_user_updater modified_by_id null f (1) webapi reusable fk_reusable_sec_user_creator created_by_id null f (1) webapi reusable fk_reusable_sec_user_updater modified_by_id null f (1) webapi reusable_tag reusable_tag_fk_reusable asset_id null f (1) webapi reusable_tag reusable_tag_fk_tag tag_id null f (1) webapi reusable_version fk_reusable_version_asset_id asset_id null f (1) webapi reusable_version fk_reusable_version_sec_user_creator created_by_id null f (1) webapi sec_role_group fk_role_group_job job_id null f (1) webapi sec_role_permission fk_role_permission_to_permission permission_id null f (1) webapi sec_role_permission fk_role_permission_to_role role_id null f (1) webapi sec_user_role fk_user_role_to_role role_id null f (1) webapi sec_user_role fk_user_role_to_user user_id null f (1) webapi source source_created_by_id_fkey created_by_id null f (1) webapi source source_modified_by_id_fkey modified_by_id null f (1) webapi source_daimon fk_source_daimon_source_id source_id null f (1) webapi tag fk_tags_sec_user_creator created_by_id null f (1) webapi tag fk_tags_sec_user_updater modified_by_id null f (1) webapi tag_group tag_groups_group_fk group_id null f (1) webapi tag_group tag_groups_tag_fk tag_id null p (1) webapi achilles_cache achilles_cache_pk id null p (1) webapi analysis_generation_info analysis_generation_info_pkey job_execution_id null p (1) webapi batch_job_execution batch_job_execution_pkey job_execution_id null p (1) webapi batch_job_execution_context batch_job_execution_context_pkey job_execution_id null p (1) webapi batch_job_instance batch_job_instance_pkey job_instance_id null p (1) webapi batch_step_execution batch_step_execution_pkey step_execution_id null p (1) webapi batch_step_execution_context batch_step_execution_context_pkey step_execution_id null p (2) webapi cc_analysis cc_analysis_pkey cohort_characterization_id, fe_analysis_id null p (2) webapi cc_cohort cc_cohort_pkey cohort_characterization_id, cohort_id null p (1) webapi cc_param cc_param_pkey id null p (1) webapi cc_strata pk_cc_strata_id id null p (1) webapi cc_strata_conceptset pk_cc_strata_conceptset_id id null p (1) webapi cca pk_cca_cca_id cca_id null p (1) webapi cca_execution cca_execution_pk cca_execution_id null p (1) webapi cca_execution_ext cca_execution_ext_pkey cca_execution_id null p (1) webapi cdm_cache cdm_cache_pk id null p (2) webapi cohort cohort_pkey subject_id, cohort_definition_id null p (2) webapi cohort_analysis_gen_info cohort_analysis_gen_info_pkey source_id, cohort_id null p (3) webapi cohort_analysis_list_xref cohort_analysis_list_xref_pkey source_id, cohort_id, analysis_id null p (1) webapi cohort_characterization cohort_characterization_pkey id null p (2) webapi cohort_characterization_tag pk_cc_tags_id tag_id, asset_id null p (2) webapi cohort_characterization_version pk_cc_version_id version, asset_id null p (1) webapi cohort_concept_map cohort_concept_map_pkey cohort_definition_id null p (1) webapi cohort_definition pk_cohort_definition id null p (1) webapi cohort_definition_details pk_cohort_definition_details id null p (2) webapi cohort_generation_info pk_cohort_generation_info id, source_id null p (1) webapi cohort_inclusion cohort_inclusion_pkey cohort_definition_id null p (1) webapi cohort_inclusion_result cohort_inclusion_result_pkey cohort_definition_id null p (1) webapi cohort_inclusion_stats cohort_inclusion_stats_pkey cohort_definition_id null p (1) webapi cohort_sample cohort_sample_pkey id null p (1) webapi cohort_study pk_cohort_study cohort_study_id null p (1) webapi cohort_summary_stats cohort_summary_stats_pkey cohort_definition_id null p (2) webapi cohort_tag pk_cohort_tags_id asset_id, tag_id null p (2) webapi cohort_version pk_cohort_version_id asset_id, version null p (1) webapi concept_of_interest pk_concept_of_interest id null p (1) webapi concept_set pk_concept_set concept_set_id null p (2) webapi concept_set_generation_info pk_concept_set_generation_info concept_set_id, source_id null p (1) webapi concept_set_item pk_concept_set_item concept_set_item_id null p (1) webapi concept_set_negative_controls pk_concept_set_nc id null p (2) webapi concept_set_tag pk_concept_set_tags_id asset_id, tag_id null p (2) webapi concept_set_version pk_concept_set_version_id version, asset_id null p (1) webapi drug_hoi_evidence pk_drug_hoi_evidence id null p (1) webapi drug_hoi_relationship pk_drug_hoi_relationship id null p (1) webapi drug_labels pk_drug_labels drug_label_id null p (1) webapi ee_analysis_status analysis_execution_pkey id null p (1) webapi estimation pk_estimation estimation_id null p (1) webapi evidence_sources pk_evidence_sources id null p (1) webapi exampleapp_widget exampleapp_widget_pkey id null p (1) webapi fe_analysis fe_analysis_pkey id null p (1) webapi fe_analysis_aggregate pk_fe_aggregate id null p (1) webapi fe_analysis_conceptset pk_fe_conceptset_id id null p (1) webapi fe_analysis_criteria fe_analysis_criteria_pkey id null p (2) webapi feas_study_generation_info pk_feas_study_generation_info study_id, source_id null p (1) webapi feas_study_inclusion_stats feas_study_inclusion_stats_pkey study_id null p (1) webapi feas_study_index_stats feas_study_index_stats_pkey study_id null p (1) webapi feas_study_result feas_study_result_pkey study_id null p (2) webapi feasibility_inclusion feasibility_inclusion_pkey study_id, sequence null p (1) webapi feasibility_study pk_clinical_trial_protocol id null p (1) webapi generation_cache pk_generation_cache id null p (1) webapi heracles_analysis heracles_analysis_pkey analysis_id null p (1) webapi heracles_heel_results heracles_heel_results_pkey id null p (1) webapi heracles_results heracles_results_pkey id null p (1) webapi heracles_results_dist heracles_results_dist_pkey id null p (1) webapi heracles_visualization_data pk_heracles_viz_data id null p (1) webapi input_files input_files_pkey id null p (1) webapi ir_analysis pk_ir_analysis id null p (1) webapi ir_analysis_details pk_ir_analysis_details id null p (1) webapi ir_analysis_dist ir_analysis_dist_pkey id null p (1) webapi ir_analysis_result ir_analysis_result_pkey id null p (1) webapi ir_analysis_strata_stats ir_analysis_strata_stats_pkey id null p (2) webapi ir_execution pk_ir_execution source_id, analysis_id null p (1) webapi ir_strata ir_strata_pkey id null p (2) webapi ir_tag pk_ir_tags_id tag_id, asset_id null p (2) webapi ir_version pk_ir_version_id version, asset_id null p (1) webapi laertes_summary pk_laertes_summary id null p (1) webapi output_file_contents output_file_contents_pkey output_file_id null p (1) webapi output_files output_files_pkey id null p (1) webapi pathway_analysis pk_pathway_analysis id null p (1) webapi pathway_event_cohort pk_pathway_event_cohort id null p (2) webapi pathway_tag pk_pathway_tags_id tag_id, asset_id null p (1) webapi pathway_target_cohort pk_pathway_target_cohort id null p (2) webapi pathway_version pk_pathway_version_id version, asset_id null p (1) webapi penelope_laertes_uni_pivot penelope_laertes_uni_pivot_pkey id null p (1) webapi penelope_laertes_universe penelope_laertes_universe_pkey id null p (1) webapi plp pk_plp_plp_id plp_id null p (1) webapi prediction pk_prediction prediction_id null p (1) webapi reusable pk_reusable_id id null p (2) webapi reusable_tag pk_reusable_tag_id asset_id, tag_id null p (2) webapi reusable_version pk_reusable_version_id version, asset_id null p (1) webapi schema_version schema_version_pk installed_rank null p (1) webapi sec_permission pk_sec_permission id null p (1) webapi sec_role pk_sec_role id null p (1) webapi sec_role_group sec_role_group_pkey id null p (1) webapi sec_role_permission pk_sec_role_permission id null p (1) webapi sec_user pk_sec_user id null p (1) webapi sec_user_role pk_sec_user_role id null p (1) webapi source pk_source source_id null p (1) webapi source_daimon pk_source_daimon source_daimon_id null p (1) webapi tag pk_tags_id id null p (1) webapi user_import_job pk_user_import_job id null p (2) webapi user_import_job_weekdays pk_user_import_job_weekdays day_of_week, user_import_job_id null u (2) webapi batch_job_instance job_inst_un job_key, job_name null u (2) webapi cc_strata cc_strata_name_uq name, cohort_characterization_id null u (2) webapi cdm_cache cdm_cache_un concept_id, source_id null u (1) webapi cohort_characterization uq_cc_name name null u (1) webapi cohort_definition uq_cd_name name null u (1) webapi concept_set uq_cs_name concept_set_name null u (1) webapi estimation uq_es_name name null u (1) webapi fe_analysis uq_fe_name name null u (3) webapi generation_cache uq_gc_hash type, design_hash, source_id null u (1) webapi ir_analysis uq_ir_name name null u (1) webapi pathway_analysis uq_pw_name name null u (1) webapi prediction uq_pd_name name null u (1) webapi sec_permission permission_unique value null u (2) webapi sec_role sec_role_name_uq name, system_role null u (4) webapi sec_role_group uc_provider_group_role provider, job_id, role_id, group_dn null u (2) webapi sec_role_permission role_permission_unique role_id, permission_id null u (1) webapi sec_user sec_user_login_unique login null u (1) webapi source source_key_unique source_key null u (2) webapi source_daimon un_source_daimon source_id, daimon_type null Got 217 constraints ----------------------------------------------- 2023-03-06 13:08:14,426 13:08:14.426 [main] INFO (ConstraintFactoryIntegrationTest.java:47) - Done. 2023-03-06 13:08:14,427 13:08:14.427 [main] INFO (PostgresqlConnectionFactory.java:46) - Getting connection for url: jdbc:postgresql://localhost:5432/OHDSI?user=postgres&password=ohdsi¤tSchema=etl_synthea_1k 2023-03-06 13:08:14,482 13:08:14.482 [main] INFO (IndexFactoryIntegrationTest.java:21) - Starting test... 2023-03-06 13:08:14,483 13:08:14.483 [main] INFO (IndexFactoryIntegrationTest.java:22) - Got 155 indexes 2023-03-06 13:08:14,497 13:08:14.497 [main] INFO (IndexFactoryIntegrationTest.java:40) - cols schema_name table_name index_name column_list_as_string index_definition (1) webapi achilles_cache achilles_cache_pk id CREATE UNIQUE INDEX achilles_cache_pk ON webapi.achilles_cache USING btree (id) (2) webapi achilles_cache achilles_cache_source_id_idx cache_name, source_id CREATE UNIQUE INDEX achilles_cache_source_id_idx ON webapi.achilles_cache USING btree (source_id, cache_name) (1) webapi analysis_generation_info analysis_generation_info_pkey job_execution_id CREATE UNIQUE INDEX analysis_generation_info_pkey ON webapi.analysis_generation_info USING btree (job_execution_id) (1) webapi batch_job_execution batch_job_execution_pkey job_execution_id CREATE UNIQUE INDEX batch_job_execution_pkey ON webapi.batch_job_execution USING btree (job_execution_id) (1) webapi batch_job_execution_context batch_job_execution_context_pkey job_execution_id CREATE UNIQUE INDEX batch_job_execution_context_pkey ON webapi.batch_job_execution_context USING btree (job_execution_id) (2) webapi batch_job_execution_params bjep_job_string_idx job_execution_id, string_val CREATE INDEX bjep_job_string_idx ON webapi.batch_job_execution_params USING btree (job_execution_id, string_val) (1) webapi batch_job_instance batch_job_instance_pkey job_instance_id CREATE UNIQUE INDEX batch_job_instance_pkey ON webapi.batch_job_instance USING btree (job_instance_id) (2) webapi batch_job_instance job_inst_un job_key, job_name CREATE UNIQUE INDEX job_inst_un ON webapi.batch_job_instance USING btree (job_name, job_key) (1) webapi batch_step_execution batch_step_execution_pkey step_execution_id CREATE UNIQUE INDEX batch_step_execution_pkey ON webapi.batch_step_execution USING btree (step_execution_id) (1) webapi batch_step_execution_context batch_step_execution_context_pkey step_execution_id CREATE UNIQUE INDEX batch_step_execution_context_pkey ON webapi.batch_step_execution_context USING btree (step_execution_id) (2) webapi cc_analysis cc_analysis_pkey cohort_characterization_id, fe_analysis_id CREATE UNIQUE INDEX cc_analysis_pkey ON webapi.cc_analysis USING btree (cohort_characterization_id, fe_analysis_id) (2) webapi cc_cohort cc_cohort_pkey cohort_characterization_id, cohort_id CREATE UNIQUE INDEX cc_cohort_pkey ON webapi.cc_cohort USING btree (cohort_characterization_id, cohort_id) (1) webapi cc_param cc_param_pkey id CREATE UNIQUE INDEX cc_param_pkey ON webapi.cc_param USING btree (id) (2) webapi cc_strata cc_strata_name_uq cohort_characterization_id, name CREATE UNIQUE INDEX cc_strata_name_uq ON webapi.cc_strata USING btree (cohort_characterization_id, name) (1) webapi cc_strata pk_cc_strata_id id CREATE UNIQUE INDEX pk_cc_strata_id ON webapi.cc_strata USING btree (id) (1) webapi cc_strata_conceptset pk_cc_strata_conceptset_id id CREATE UNIQUE INDEX pk_cc_strata_conceptset_id ON webapi.cc_strata_conceptset USING btree (id) (1) webapi cca pk_cca_cca_id cca_id CREATE UNIQUE INDEX pk_cca_cca_id ON webapi.cca USING btree (cca_id) (1) webapi cca_execution cca_execution_pk cca_execution_id CREATE UNIQUE INDEX cca_execution_pk ON webapi.cca_execution USING btree (cca_execution_id) (1) webapi cca_execution_ext cca_execution_ext_pkey cca_execution_id CREATE UNIQUE INDEX cca_execution_ext_pkey ON webapi.cca_execution_ext USING btree (cca_execution_id) (2) webapi cdm_cache cdm_cache_concept_id_idx concept_id, source_id CREATE INDEX cdm_cache_concept_id_idx ON webapi.cdm_cache USING btree (concept_id, source_id) (1) webapi cdm_cache cdm_cache_pk id CREATE UNIQUE INDEX cdm_cache_pk ON webapi.cdm_cache USING btree (id) (2) webapi cdm_cache cdm_cache_un concept_id, source_id CREATE UNIQUE INDEX cdm_cache_un ON webapi.cdm_cache USING btree (concept_id, source_id) (2) webapi cohort cohort_pkey cohort_definition_id, subject_id CREATE UNIQUE INDEX cohort_pkey ON webapi.cohort USING btree (cohort_definition_id, subject_id) (2) webapi cohort_analysis_gen_info cohort_analysis_gen_info_pkey cohort_id, source_id CREATE UNIQUE INDEX cohort_analysis_gen_info_pkey ON webapi.cohort_analysis_gen_info USING btree (source_id, cohort_id) (3) webapi cohort_analysis_list_xref cohort_analysis_list_xref_pkey analysis_id, cohort_id, source_id CREATE UNIQUE INDEX cohort_analysis_list_xref_pkey ON webapi.cohort_analysis_list_xref USING btree (source_id, cohort_id, analysis_id) (1) webapi cohort_characterization cohort_characterization_pkey id CREATE UNIQUE INDEX cohort_characterization_pkey ON webapi.cohort_characterization USING btree (id) (1) webapi cohort_characterization uq_cc_name name CREATE UNIQUE INDEX uq_cc_name ON webapi.cohort_characterization USING btree (name) (1) webapi cohort_characterization_tag cc_tags_cc_id_idx asset_id CREATE INDEX cc_tags_cc_id_idx ON webapi.cohort_characterization_tag USING btree (asset_id) (1) webapi cohort_characterization_tag cc_tags_tag_id_idx tag_id CREATE INDEX cc_tags_tag_id_idx ON webapi.cohort_characterization_tag USING btree (tag_id) (2) webapi cohort_characterization_tag pk_cc_tags_id asset_id, tag_id CREATE UNIQUE INDEX pk_cc_tags_id ON webapi.cohort_characterization_tag USING btree (asset_id, tag_id) (1) webapi cohort_characterization_version cc_version_asset_idx asset_id CREATE INDEX cc_version_asset_idx ON webapi.cohort_characterization_version USING btree (asset_id) (2) webapi cohort_characterization_version pk_cc_version_id asset_id, version CREATE UNIQUE INDEX pk_cc_version_id ON webapi.cohort_characterization_version USING btree (asset_id, version) (1) webapi cohort_concept_map cohort_concept_map_pkey cohort_definition_id CREATE UNIQUE INDEX cohort_concept_map_pkey ON webapi.cohort_concept_map USING btree (cohort_definition_id) (1) webapi cohort_definition pk_cohort_definition id CREATE UNIQUE INDEX pk_cohort_definition ON webapi.cohort_definition USING btree (id) (1) webapi cohort_definition uq_cd_name name CREATE UNIQUE INDEX uq_cd_name ON webapi.cohort_definition USING btree (name) (1) webapi cohort_definition_details pk_cohort_definition_details id CREATE UNIQUE INDEX pk_cohort_definition_details ON webapi.cohort_definition_details USING btree (id) (2) webapi cohort_generation_info pk_cohort_generation_info id, source_id CREATE UNIQUE INDEX pk_cohort_generation_info ON webapi.cohort_generation_info USING btree (id, source_id) (1) webapi cohort_inclusion cohort_inclusion_pkey cohort_definition_id CREATE UNIQUE INDEX cohort_inclusion_pkey ON webapi.cohort_inclusion USING btree (cohort_definition_id) (1) webapi cohort_inclusion_result cohort_inclusion_result_pkey cohort_definition_id CREATE UNIQUE INDEX cohort_inclusion_result_pkey ON webapi.cohort_inclusion_result USING btree (cohort_definition_id) (1) webapi cohort_inclusion_stats cohort_inclusion_stats_pkey cohort_definition_id CREATE UNIQUE INDEX cohort_inclusion_stats_pkey ON webapi.cohort_inclusion_stats USING btree (cohort_definition_id) (1) webapi cohort_sample cohort_sample_pkey id CREATE UNIQUE INDEX cohort_sample_pkey ON webapi.cohort_sample USING btree (id) (2) webapi cohort_sample idx_cohort_sample_source cohort_definition_id, source_id CREATE INDEX idx_cohort_sample_source ON webapi.cohort_sample USING btree (cohort_definition_id, source_id) (1) webapi cohort_study pk_cohort_study cohort_study_id CREATE UNIQUE INDEX pk_cohort_study ON webapi.cohort_study USING btree (cohort_study_id) (1) webapi cohort_summary_stats cohort_summary_stats_pkey cohort_definition_id CREATE UNIQUE INDEX cohort_summary_stats_pkey ON webapi.cohort_summary_stats USING btree (cohort_definition_id) (1) webapi cohort_tag cohort_tags_cohort_id_idx asset_id CREATE INDEX cohort_tags_cohort_id_idx ON webapi.cohort_tag USING btree (asset_id) (1) webapi cohort_tag cohort_tags_tag_id_idx tag_id CREATE INDEX cohort_tags_tag_id_idx ON webapi.cohort_tag USING btree (tag_id) (2) webapi cohort_tag pk_cohort_tags_id asset_id, tag_id CREATE UNIQUE INDEX pk_cohort_tags_id ON webapi.cohort_tag USING btree (asset_id, tag_id) (1) webapi cohort_version cohort_version_asset_idx asset_id CREATE INDEX cohort_version_asset_idx ON webapi.cohort_version USING btree (asset_id) (2) webapi cohort_version pk_cohort_version_id asset_id, version CREATE UNIQUE INDEX pk_cohort_version_id ON webapi.cohort_version USING btree (asset_id, version) (1) webapi concept_of_interest pk_concept_of_interest id CREATE UNIQUE INDEX pk_concept_of_interest ON webapi.concept_of_interest USING btree (id) (1) webapi concept_set pk_concept_set concept_set_id CREATE UNIQUE INDEX pk_concept_set ON webapi.concept_set USING btree (concept_set_id) (1) webapi concept_set uq_cs_name concept_set_name CREATE UNIQUE INDEX uq_cs_name ON webapi.concept_set USING btree (concept_set_name) (2) webapi concept_set_generation_info pk_concept_set_generation_info concept_set_id, source_id CREATE UNIQUE INDEX pk_concept_set_generation_info ON webapi.concept_set_generation_info USING btree (concept_set_id, source_id) (1) webapi concept_set_item pk_concept_set_item concept_set_item_id CREATE UNIQUE INDEX pk_concept_set_item ON webapi.concept_set_item USING btree (concept_set_item_id) (1) webapi concept_set_negative_controls pk_concept_set_nc id CREATE UNIQUE INDEX pk_concept_set_nc ON webapi.concept_set_negative_controls USING btree (id) (1) webapi concept_set_tag concept_set_tags_concept_id_idx asset_id CREATE INDEX concept_set_tags_concept_id_idx ON webapi.concept_set_tag USING btree (asset_id) (1) webapi concept_set_tag concept_set_tags_tag_id_idx tag_id CREATE INDEX concept_set_tags_tag_id_idx ON webapi.concept_set_tag USING btree (tag_id) (2) webapi concept_set_tag pk_concept_set_tags_id asset_id, tag_id CREATE UNIQUE INDEX pk_concept_set_tags_id ON webapi.concept_set_tag USING btree (asset_id, tag_id) (1) webapi concept_set_version concept_set_version_asset_idx asset_id CREATE INDEX concept_set_version_asset_idx ON webapi.concept_set_version USING btree (asset_id) (2) webapi concept_set_version pk_concept_set_version_id asset_id, version CREATE UNIQUE INDEX pk_concept_set_version_id ON webapi.concept_set_version USING btree (asset_id, version) (1) webapi drug_hoi_evidence pk_drug_hoi_evidence id CREATE UNIQUE INDEX pk_drug_hoi_evidence ON webapi.drug_hoi_evidence USING btree (id) (1) webapi drug_hoi_relationship pk_drug_hoi_relationship id CREATE UNIQUE INDEX pk_drug_hoi_relationship ON webapi.drug_hoi_relationship USING btree (id) (1) webapi drug_labels pk_drug_labels drug_label_id CREATE UNIQUE INDEX pk_drug_labels ON webapi.drug_labels USING btree (drug_label_id) (1) webapi ee_analysis_status analysis_execution_pkey id CREATE UNIQUE INDEX analysis_execution_pkey ON webapi.ee_analysis_status USING btree (id) (1) webapi estimation pk_estimation estimation_id CREATE UNIQUE INDEX pk_estimation ON webapi.estimation USING btree (estimation_id) (1) webapi estimation uq_es_name name CREATE UNIQUE INDEX uq_es_name ON webapi.estimation USING btree (name) (1) webapi evidence_sources pk_evidence_sources id CREATE UNIQUE INDEX pk_evidence_sources ON webapi.evidence_sources USING btree (id) (1) webapi exampleapp_widget exampleapp_widget_pkey id CREATE UNIQUE INDEX exampleapp_widget_pkey ON webapi.exampleapp_widget USING btree (id) (1) webapi fe_analysis fe_analysis_pkey id CREATE UNIQUE INDEX fe_analysis_pkey ON webapi.fe_analysis USING btree (id) (1) webapi fe_analysis uq_fe_name name CREATE UNIQUE INDEX uq_fe_name ON webapi.fe_analysis USING btree (name) (1) webapi fe_analysis_aggregate pk_fe_aggregate id CREATE UNIQUE INDEX pk_fe_aggregate ON webapi.fe_analysis_aggregate USING btree (id) (1) webapi fe_analysis_conceptset pk_fe_conceptset_id id CREATE UNIQUE INDEX pk_fe_conceptset_id ON webapi.fe_analysis_conceptset USING btree (id) (1) webapi fe_analysis_criteria fe_analysis_criteria_pkey id CREATE UNIQUE INDEX fe_analysis_criteria_pkey ON webapi.fe_analysis_criteria USING btree (id) (2) webapi feas_study_generation_info pk_feas_study_generation_info source_id, study_id CREATE UNIQUE INDEX pk_feas_study_generation_info ON webapi.feas_study_generation_info USING btree (study_id, source_id) (1) webapi feas_study_inclusion_stats feas_study_inclusion_stats_pkey study_id CREATE UNIQUE INDEX feas_study_inclusion_stats_pkey ON webapi.feas_study_inclusion_stats USING btree (study_id) (1) webapi feas_study_index_stats feas_study_index_stats_pkey study_id CREATE UNIQUE INDEX feas_study_index_stats_pkey ON webapi.feas_study_index_stats USING btree (study_id) (1) webapi feas_study_result feas_study_result_pkey study_id CREATE UNIQUE INDEX feas_study_result_pkey ON webapi.feas_study_result USING btree (study_id) (2) webapi feasibility_inclusion feasibility_inclusion_pkey sequence, study_id CREATE UNIQUE INDEX feasibility_inclusion_pkey ON webapi.feasibility_inclusion USING btree (study_id, sequence) (1) webapi feasibility_study pk_clinical_trial_protocol id CREATE UNIQUE INDEX pk_clinical_trial_protocol ON webapi.feasibility_study USING btree (id) (1) webapi generation_cache pk_generation_cache id CREATE UNIQUE INDEX pk_generation_cache ON webapi.generation_cache USING btree (id) (3) webapi generation_cache uq_gc_hash design_hash, source_id, type CREATE UNIQUE INDEX uq_gc_hash ON webapi.generation_cache USING btree (type, design_hash, source_id) (1) webapi heracles_analysis heracles_analysis_pkey analysis_id CREATE UNIQUE INDEX heracles_analysis_pkey ON webapi.heracles_analysis USING btree (analysis_id) (1) webapi heracles_heel_results heracles_heel_results_pkey id CREATE UNIQUE INDEX heracles_heel_results_pkey ON webapi.heracles_heel_results USING btree (id) (2) webapi heracles_heel_results hh_idx_cohort_id_analysis_id analysis_id, cohort_definition_id CREATE INDEX hh_idx_cohort_id_analysis_id ON webapi.heracles_heel_results USING btree (cohort_definition_id, analysis_id) (1) webapi heracles_results heracles_results_pkey id CREATE UNIQUE INDEX heracles_results_pkey ON webapi.heracles_results USING btree (id) (1) webapi heracles_results hr_idx_cohort_def_id cohort_definition_id CREATE INDEX hr_idx_cohort_def_id ON webapi.heracles_results USING btree (cohort_definition_id) (2) webapi heracles_results hr_idx_cohort_def_id_dt cohort_definition_id, last_update_time CREATE INDEX hr_idx_cohort_def_id_dt ON webapi.heracles_results USING btree (cohort_definition_id, last_update_time) (2) webapi heracles_results hr_idx_cohort_id_analysis_id analysis_id, cohort_definition_id CREATE INDEX hr_idx_cohort_id_analysis_id ON webapi.heracles_results USING btree (cohort_definition_id, analysis_id) (4) webapi heracles_results hr_idx_cohort_id_first_res analysis_id, cohort_definition_id, count_value, stratum_1CREATE INDEX hr_idx_cohort_id_first_res ON webapi.heracles_results USING btree (cohort_definition_id, analysis_id, count_value, stratum_1) (1) webapi heracles_results_dist heracles_results_dist_pkey id CREATE UNIQUE INDEX heracles_results_dist_pkey ON webapi.heracles_results_dist USING btree (id) (1) webapi heracles_results_dist hrd_idx_cohort_def_id cohort_definition_id CREATE INDEX hrd_idx_cohort_def_id ON webapi.heracles_results_dist USING btree (cohort_definition_id) (2) webapi heracles_results_dist hrd_idx_cohort_def_id_dt cohort_definition_id, last_update_time CREATE INDEX hrd_idx_cohort_def_id_dt ON webapi.heracles_results_dist USING btree (cohort_definition_id, last_update_time) (2) webapi heracles_results_dist hrd_idx_cohort_id_analysis_id analysis_id, cohort_definition_id CREATE INDEX hrd_idx_cohort_id_analysis_id ON webapi.heracles_results_dist USING btree (cohort_definition_id, analysis_id) (4) webapi heracles_results_dist hrd_idx_cohort_id_first_res analysis_id, cohort_definition_id, count_value, stratum_1CREATE INDEX hrd_idx_cohort_id_first_res ON webapi.heracles_results_dist USING btree (cohort_definition_id, analysis_id, count_value, stratum_1) (3) webapi heracles_visualization_data heracles_viz_data_idx cohort_definition_id, source_id, visualization_keyCREATE INDEX heracles_viz_data_idx ON webapi.heracles_visualization_data USING btree (cohort_definition_id, source_id, visualization_key) (4) webapi heracles_visualization_data heracles_viz_data_unq_idx cohort_definition_id, drilldown_id, source_id, visualization_keyCREATE UNIQUE INDEX heracles_viz_data_unq_idx ON webapi.heracles_visualization_data USING btree (cohort_definition_id, source_id, visualization_key, drilldown_id) (1) webapi heracles_visualization_data pk_heracles_viz_data id CREATE UNIQUE INDEX pk_heracles_viz_data ON webapi.heracles_visualization_data USING btree (id) (1) webapi input_files input_files_pkey id CREATE UNIQUE INDEX input_files_pkey ON webapi.input_files USING btree (id) (1) webapi ir_analysis pk_ir_analysis id CREATE UNIQUE INDEX pk_ir_analysis ON webapi.ir_analysis USING btree (id) (1) webapi ir_analysis uq_ir_name name CREATE UNIQUE INDEX uq_ir_name ON webapi.ir_analysis USING btree (name) (1) webapi ir_analysis_details pk_ir_analysis_details id CREATE UNIQUE INDEX pk_ir_analysis_details ON webapi.ir_analysis_details USING btree (id) (1) webapi ir_analysis_dist ir_analysis_dist_pkey id CREATE UNIQUE INDEX ir_analysis_dist_pkey ON webapi.ir_analysis_dist USING btree (id) (1) webapi ir_analysis_result ir_analysis_result_pkey id CREATE UNIQUE INDEX ir_analysis_result_pkey ON webapi.ir_analysis_result USING btree (id) (1) webapi ir_analysis_strata_stats ir_analysis_strata_stats_pkey id CREATE UNIQUE INDEX ir_analysis_strata_stats_pkey ON webapi.ir_analysis_strata_stats USING btree (id) (2) webapi ir_execution pk_ir_execution analysis_id, source_id CREATE UNIQUE INDEX pk_ir_execution ON webapi.ir_execution USING btree (analysis_id, source_id) (1) webapi ir_strata ir_strata_pkey id CREATE UNIQUE INDEX ir_strata_pkey ON webapi.ir_strata USING btree (id) (1) webapi ir_tag ir_tags_ir_id_idx asset_id CREATE INDEX ir_tags_ir_id_idx ON webapi.ir_tag USING btree (asset_id) (1) webapi ir_tag ir_tags_tag_id_idx tag_id CREATE INDEX ir_tags_tag_id_idx ON webapi.ir_tag USING btree (tag_id) (2) webapi ir_tag pk_ir_tags_id asset_id, tag_id CREATE UNIQUE INDEX pk_ir_tags_id ON webapi.ir_tag USING btree (asset_id, tag_id) (1) webapi ir_version ir_version_asset_idx asset_id CREATE INDEX ir_version_asset_idx ON webapi.ir_version USING btree (asset_id) (2) webapi ir_version pk_ir_version_id asset_id, version CREATE UNIQUE INDEX pk_ir_version_id ON webapi.ir_version USING btree (asset_id, version) (1) webapi laertes_summary pk_laertes_summary id CREATE UNIQUE INDEX pk_laertes_summary ON webapi.laertes_summary USING btree (id) (1) webapi output_file_contents output_file_contents_pkey output_file_id CREATE UNIQUE INDEX output_file_contents_pkey ON webapi.output_file_contents USING btree (output_file_id) (1) webapi output_files output_files_pkey id CREATE UNIQUE INDEX output_files_pkey ON webapi.output_files USING btree (id) (1) webapi pathway_analysis pk_pathway_analysis id CREATE UNIQUE INDEX pk_pathway_analysis ON webapi.pathway_analysis USING btree (id) (1) webapi pathway_analysis uq_pw_name name CREATE UNIQUE INDEX uq_pw_name ON webapi.pathway_analysis USING btree (name) (1) webapi pathway_event_cohort pk_pathway_event_cohort id CREATE UNIQUE INDEX pk_pathway_event_cohort ON webapi.pathway_event_cohort USING btree (id) (1) webapi pathway_tag pathway_tags_pathway_id_idx asset_id CREATE INDEX pathway_tags_pathway_id_idx ON webapi.pathway_tag USING btree (asset_id) (1) webapi pathway_tag pathway_tags_tag_id_idx tag_id CREATE INDEX pathway_tags_tag_id_idx ON webapi.pathway_tag USING btree (tag_id) (2) webapi pathway_tag pk_pathway_tags_id asset_id, tag_id CREATE UNIQUE INDEX pk_pathway_tags_id ON webapi.pathway_tag USING btree (asset_id, tag_id) (1) webapi pathway_target_cohort pk_pathway_target_cohort id CREATE UNIQUE INDEX pk_pathway_target_cohort ON webapi.pathway_target_cohort USING btree (id) (1) webapi pathway_version pathway_version_asset_idx asset_id CREATE INDEX pathway_version_asset_idx ON webapi.pathway_version USING btree (asset_id) (2) webapi pathway_version pk_pathway_version_id asset_id, version CREATE UNIQUE INDEX pk_pathway_version_id ON webapi.pathway_version USING btree (asset_id, version) (2) webapi penelope_laertes_uni_pivot idx_penelope_laertes_uni_pivot condition_concept_id, ingredient_concept_id CREATE INDEX idx_penelope_laertes_uni_pivot ON webapi.penelope_laertes_uni_pivot USING btree (ingredient_concept_id, condition_concept_id) (1) webapi penelope_laertes_uni_pivot penelope_laertes_uni_pivot_pkey id CREATE UNIQUE INDEX penelope_laertes_uni_pivot_pkey ON webapi.penelope_laertes_uni_pivot USING btree (id) (1) webapi penelope_laertes_universe penelope_laertes_universe_pkey id CREATE UNIQUE INDEX penelope_laertes_universe_pkey ON webapi.penelope_laertes_universe USING btree (id) (1) webapi plp pk_plp_plp_id plp_id CREATE UNIQUE INDEX pk_plp_plp_id ON webapi.plp USING btree (plp_id) (1) webapi prediction pk_prediction prediction_id CREATE UNIQUE INDEX pk_prediction ON webapi.prediction USING btree (prediction_id) (1) webapi prediction uq_pd_name name CREATE UNIQUE INDEX uq_pd_name ON webapi.prediction USING btree (name) (1) webapi reusable pk_reusable_id id CREATE UNIQUE INDEX pk_reusable_id ON webapi.reusable USING btree (id) (2) webapi reusable_tag pk_reusable_tag_id asset_id, tag_id CREATE UNIQUE INDEX pk_reusable_tag_id ON webapi.reusable_tag USING btree (asset_id, tag_id) (1) webapi reusable_tag reusable_tag_reusableidx asset_id CREATE INDEX reusable_tag_reusableidx ON webapi.reusable_tag USING btree (asset_id) (1) webapi reusable_tag reusable_tag_tag_id_idx tag_id CREATE INDEX reusable_tag_tag_id_idx ON webapi.reusable_tag USING btree (tag_id) (2) webapi reusable_version pk_reusable_version_id asset_id, version CREATE UNIQUE INDEX pk_reusable_version_id ON webapi.reusable_version USING btree (asset_id, version) (1) webapi reusable_version reusable_version_asset_idx asset_id CREATE INDEX reusable_version_asset_idx ON webapi.reusable_version USING btree (asset_id) (1) webapi schema_version schema_version_pk installed_rank CREATE UNIQUE INDEX schema_version_pk ON webapi.schema_version USING btree (installed_rank) (1) webapi schema_version schema_version_s_idx success CREATE INDEX schema_version_s_idx ON webapi.schema_version USING btree (success) (1) webapi sec_permission permission_unique value CREATE UNIQUE INDEX permission_unique ON webapi.sec_permission USING btree (value) (1) webapi sec_permission pk_sec_permission id CREATE UNIQUE INDEX pk_sec_permission ON webapi.sec_permission USING btree (id) (1) webapi sec_role pk_sec_role id CREATE UNIQUE INDEX pk_sec_role ON webapi.sec_role USING btree (id) (2) webapi sec_role sec_role_name_uq name, system_role CREATE UNIQUE INDEX sec_role_name_uq ON webapi.sec_role USING btree (name, system_role) (1) webapi sec_role_group sec_role_group_pkey id CREATE UNIQUE INDEX sec_role_group_pkey ON webapi.sec_role_group USING btree (id) (4) webapi sec_role_group uc_provider_group_role group_dn, job_id, provider, role_id CREATE UNIQUE INDEX uc_provider_group_role ON webapi.sec_role_group USING btree (provider, group_dn, role_id, job_id) (1) webapi sec_role_permission pk_sec_role_permission id CREATE UNIQUE INDEX pk_sec_role_permission ON webapi.sec_role_permission USING btree (id) (2) webapi sec_role_permission role_permission_unique permission_id, role_id CREATE UNIQUE INDEX role_permission_unique ON webapi.sec_role_permission USING btree (role_id, permission_id) (1) webapi sec_user pk_sec_user id CREATE UNIQUE INDEX pk_sec_user ON webapi.sec_user USING btree (id) (1) webapi sec_user sec_user_login_unique login CREATE UNIQUE INDEX sec_user_login_unique ON webapi.sec_user USING btree (login) (1) webapi sec_user_role pk_sec_user_role id CREATE UNIQUE INDEX pk_sec_user_role ON webapi.sec_user_role USING btree (id) (1) webapi source pk_source source_id CREATE UNIQUE INDEX pk_source ON webapi.source USING btree (source_id) (1) webapi source source_key_unique source_key CREATE UNIQUE INDEX source_key_unique ON webapi.source USING btree (source_key) (1) webapi source_daimon pk_source_daimon source_daimon_id CREATE UNIQUE INDEX pk_source_daimon ON webapi.source_daimon USING btree (source_daimon_id) (2) webapi source_daimon un_source_daimon daimon_type, source_id CREATE UNIQUE INDEX un_source_daimon ON webapi.source_daimon USING btree (source_id, daimon_type) (1) webapi tag pk_tags_id id CREATE UNIQUE INDEX pk_tags_id ON webapi.tag USING btree (id) (1) webapi user_import_job pk_user_import_job id CREATE UNIQUE INDEX pk_user_import_job ON webapi.user_import_job USING btree (id) (2) webapi user_import_job_weekdays pk_user_import_job_weekdays day_of_week, user_import_job_id CREATE UNIQUE INDEX pk_user_import_job_weekdays ON webapi.user_import_job_weekdays USING btree (user_import_job_id, day_of_week) 2023-03-06 13:08:14,498 13:08:14.498 [main] INFO (IndexFactoryIntegrationTest.java:41) - Got 155 indexes 2023-03-06 13:08:14,498 13:08:14.498 [main] INFO (IndexFactoryIntegrationTest.java:42) - Done. 2023-03-06 13:08:14,498 13:08:14.498 [main] INFO (PostgresqlConnectionFactory.java:46) - Getting connection for url: jdbc:postgresql://localhost:5432/OHDSI?user=postgres&password=ohdsi¤tSchema=etl_synthea_1k 2023-03-06 13:08:14,544 13:08:14.544 [main] INFO (IndexFactoryIntegrationTest.java:21) - Starting test... 2023-03-06 13:08:14,544 13:08:14.544 [main] INFO (IndexFactoryIntegrationTest.java:22) - Got 32 indexes 2023-03-06 13:08:14,546 13:08:14.546 [main] INFO (IndexFactoryIntegrationTest.java:40) - cols schema_name table_name index_name column_list_as_string index_definition (1) etl_synthea_1k care_site xpk_care_site care_site_id CREATE UNIQUE INDEX xpk_care_site ON etl_synthea_1k.care_site USING btree (care_site_id) (1) etl_synthea_1k concept xpk_concept concept_id CREATE UNIQUE INDEX xpk_concept ON etl_synthea_1k.concept USING btree (concept_id) (1) etl_synthea_1k concept_class xpk_concept_class concept_class_id CREATE UNIQUE INDEX xpk_concept_class ON etl_synthea_1k.concept_class USING btree (concept_class_id) (1) etl_synthea_1k condition_era xpk_condition_era condition_era_id CREATE UNIQUE INDEX xpk_condition_era ON etl_synthea_1k.condition_era USING btree (condition_era_id) (1) etl_synthea_1k condition_occurrence xpk_condition_occurrence condition_occurrence_id CREATE UNIQUE INDEX xpk_condition_occurrence ON etl_synthea_1k.condition_occurrence USING btree (condition_occurrence_id) (1) etl_synthea_1k cost xpk_cost cost_id CREATE UNIQUE INDEX xpk_cost ON etl_synthea_1k.cost USING btree (cost_id) (1) etl_synthea_1k device_exposure xpk_device_exposure device_exposure_id CREATE UNIQUE INDEX xpk_device_exposure ON etl_synthea_1k.device_exposure USING btree (device_exposure_id) (1) etl_synthea_1k domain xpk_domain domain_id CREATE UNIQUE INDEX xpk_domain ON etl_synthea_1k.domain USING btree (domain_id) (1) etl_synthea_1k dose_era xpk_dose_era dose_era_id CREATE UNIQUE INDEX xpk_dose_era ON etl_synthea_1k.dose_era USING btree (dose_era_id) (1) etl_synthea_1k drug_era xpk_drug_era drug_era_id CREATE UNIQUE INDEX xpk_drug_era ON etl_synthea_1k.drug_era USING btree (drug_era_id) (1) etl_synthea_1k drug_exposure xpk_drug_exposure drug_exposure_id CREATE UNIQUE INDEX xpk_drug_exposure ON etl_synthea_1k.drug_exposure USING btree (drug_exposure_id) (1) etl_synthea_1k episode xpk_episode episode_id CREATE UNIQUE INDEX xpk_episode ON etl_synthea_1k.episode USING btree (episode_id) (1) etl_synthea_1k location xpk_location location_id CREATE UNIQUE INDEX xpk_location ON etl_synthea_1k.location USING btree (location_id) (1) etl_synthea_1k measurement xpk_measurement measurement_id CREATE UNIQUE INDEX xpk_measurement ON etl_synthea_1k.measurement USING btree (measurement_id) (1) etl_synthea_1k metadata xpk_metadata metadata_id CREATE UNIQUE INDEX xpk_metadata ON etl_synthea_1k.metadata USING btree (metadata_id) (1) etl_synthea_1k note xpk_note note_id CREATE UNIQUE INDEX xpk_note ON etl_synthea_1k.note USING btree (note_id) (1) etl_synthea_1k note_nlp xpk_note_nlp note_nlp_id CREATE UNIQUE INDEX xpk_note_nlp ON etl_synthea_1k.note_nlp USING btree (note_nlp_id) (1) etl_synthea_1k observation xpk_observation observation_id CREATE UNIQUE INDEX xpk_observation ON etl_synthea_1k.observation USING btree (observation_id) (1) etl_synthea_1k observation_period xpk_observation_period observation_period_id CREATE UNIQUE INDEX xpk_observation_period ON etl_synthea_1k.observation_period USING btree (observation_period_id) (1) etl_synthea_1k payer_plan_period xpk_payer_plan_period payer_plan_period_id CREATE UNIQUE INDEX xpk_payer_plan_period ON etl_synthea_1k.payer_plan_period USING btree (payer_plan_period_id) (1) etl_synthea_1k person xpk_person person_id CREATE UNIQUE INDEX xpk_person ON etl_synthea_1k.person USING btree (person_id) (1) etl_synthea_1k procedure_occurrence xpk_procedure_occurrence procedure_occurrence_id CREATE UNIQUE INDEX xpk_procedure_occurrence ON etl_synthea_1k.procedure_occurrence USING btree (procedure_occurrence_id) (1) etl_synthea_1k provider xpk_provider provider_id CREATE UNIQUE INDEX xpk_provider ON etl_synthea_1k.provider USING btree (provider_id) (1) etl_synthea_1k relationship xpk_relationship relationship_id CREATE UNIQUE INDEX xpk_relationship ON etl_synthea_1k.relationship USING btree (relationship_id) (1) etl_synthea_1k source_to_source_vocab_map idx_source_vocab_map_source_code source_code CREATE INDEX idx_source_vocab_map_source_code ON etl_synthea_1k.source_to_source_vocab_map USING btree (source_code) (1) etl_synthea_1k source_to_source_vocab_map idx_source_vocab_map_source_vocab_id source_vocabulary_id CREATE INDEX idx_source_vocab_map_source_vocab_id ON etl_synthea_1k.source_to_source_vocab_map USING btree (source_vocabulary_id) (1) etl_synthea_1k source_to_standard_vocab_map idx_vocab_map_source_code source_code CREATE INDEX idx_vocab_map_source_code ON etl_synthea_1k.source_to_standard_vocab_map USING btree (source_code) (1) etl_synthea_1k source_to_standard_vocab_map idx_vocab_map_source_vocab_id source_vocabulary_id CREATE INDEX idx_vocab_map_source_vocab_id ON etl_synthea_1k.source_to_standard_vocab_map USING btree (source_vocabulary_id) (1) etl_synthea_1k specimen xpk_specimen specimen_id CREATE UNIQUE INDEX xpk_specimen ON etl_synthea_1k.specimen USING btree (specimen_id) (1) etl_synthea_1k visit_detail xpk_visit_detail visit_detail_id CREATE UNIQUE INDEX xpk_visit_detail ON etl_synthea_1k.visit_detail USING btree (visit_detail_id) (1) etl_synthea_1k visit_occurrence xpk_visit_occurrence visit_occurrence_id CREATE UNIQUE INDEX xpk_visit_occurrence ON etl_synthea_1k.visit_occurrence USING btree (visit_occurrence_id) (1) etl_synthea_1k vocabulary xpk_vocabulary vocabulary_id CREATE UNIQUE INDEX xpk_vocabulary ON etl_synthea_1k.vocabulary USING btree (vocabulary_id) 2023-03-06 13:08:14,547 13:08:14.547 [main] INFO (IndexFactoryIntegrationTest.java:41) - Got 32 indexes 2023-03-06 13:08:14,547 13:08:14.547 [main] INFO (IndexFactoryIntegrationTest.java:42) - Done. 2023-03-06 13:08:14,547 13:08:14.547 [main] INFO (TableCountsIntegrationTest.java:25) - ------------------------ 2023-03-06 13:08:14,547 13:08:14.547 [main] INFO (TableCountsIntegrationTest.java:26) - TABLE NAMES TEST: 2023-03-06 13:08:14,547 13:08:14.547 [main] INFO (TableCountsIntegrationTest.java:27) - Starting test... 2023-03-06 13:08:14,547 13:08:14.547 [main] INFO (PostgresqlConnectionFactory.java:46) - Getting connection for url: jdbc:postgresql://localhost:5432/OHDSI?user=postgres&password=ohdsi¤tSchema=etl_synthea_1k 2023-03-06 13:08:14,590 13:08:14.590 [main] INFO (TableCountsIntegrationTest.java:32) - Got: 44 tables. 2023-03-06 13:08:14,590 13:08:14.590 [main] INFO (TableCountsIntegrationTest.java:36) - Done. 2023-03-06 13:08:14,590 13:08:14.590 [main] INFO (TableCountsIntegrationTest.java:40) - ------------------------ 2023-03-06 13:08:14,590 13:08:14.590 [main] INFO (TableCountsIntegrationTest.java:41) - TABLE COUNTS TEST: 2023-03-06 13:08:14,590 13:08:14.590 [main] INFO (TableCountsIntegrationTest.java:42) - Starting test... 2023-03-06 13:08:14,590 13:08:14.590 [main] INFO (PostgresqlConnectionFactory.java:46) - Getting connection for url: jdbc:postgresql://localhost:5432/OHDSI?user=postgres&password=ohdsi¤tSchema=etl_synthea_1k 2023-03-06 13:08:14,631 13:08:14.631 [main] INFO (PostgresTableCountFactory.java:25) - Getting count for all_visits 2023-03-06 13:08:14,647 13:08:14.647 [main] INFO (PostgresTableCountFactory.java:25) - Getting count for assign_all_visit_ids 2023-03-06 13:08:14,665 13:08:14.665 [main] INFO (PostgresTableCountFactory.java:25) - Getting count for care_site 2023-03-06 13:08:14,667 13:08:14.667 [main] INFO (PostgresTableCountFactory.java:25) - Getting count for cdm_source 2023-03-06 13:08:14,668 13:08:14.668 [main] INFO (PostgresTableCountFactory.java:25) - Getting count for cohort 2023-03-06 13:08:14,669 13:08:14.669 [main] INFO (PostgresTableCountFactory.java:25) - Getting count for cohort_definition 2023-03-06 13:08:14,670 13:08:14.670 [main] INFO (PostgresTableCountFactory.java:25) - Getting count for concept 2023-03-06 13:08:15,022 13:08:15.022 [main] INFO (PostgresTableCountFactory.java:25) - Getting count for concept_ancestor 2023-03-06 13:08:16,689 13:08:16.689 [main] INFO (PostgresTableCountFactory.java:25) - Getting count for concept_class 2023-03-06 13:08:16,690 13:08:16.690 [main] INFO (PostgresTableCountFactory.java:25) - Getting count for concept_relationship 2023-03-06 13:08:18,070 13:08:18.070 [main] INFO (PostgresTableCountFactory.java:25) - Getting count for concept_synonym 2023-03-06 13:08:18,187 13:08:18.187 [main] INFO (PostgresTableCountFactory.java:25) - Getting count for condition_era 2023-03-06 13:08:18,188 13:08:18.188 [main] INFO (PostgresTableCountFactory.java:25) - Getting count for condition_occurrence 2023-03-06 13:08:18,191 13:08:18.191 [main] INFO (PostgresTableCountFactory.java:25) - Getting count for cost 2023-03-06 13:08:18,195 13:08:18.195 [main] INFO (PostgresTableCountFactory.java:25) - Getting count for death 2023-03-06 13:08:18,195 13:08:18.195 [main] INFO (PostgresTableCountFactory.java:25) - Getting count for device_exposure 2023-03-06 13:08:18,196 13:08:18.196 [main] INFO (PostgresTableCountFactory.java:25) - Getting count for domain 2023-03-06 13:08:18,197 13:08:18.197 [main] INFO (PostgresTableCountFactory.java:25) - Getting count for dose_era 2023-03-06 13:08:18,197 13:08:18.197 [main] INFO (PostgresTableCountFactory.java:25) - Getting count for drug_era 2023-03-06 13:08:18,198 13:08:18.198 [main] INFO (PostgresTableCountFactory.java:25) - Getting count for drug_exposure 2023-03-06 13:08:18,203 13:08:18.203 [main] INFO (PostgresTableCountFactory.java:25) - Getting count for drug_strength 2023-03-06 13:08:18,337 13:08:18.337 [main] INFO (PostgresTableCountFactory.java:25) - Getting count for episode 2023-03-06 13:08:18,338 13:08:18.338 [main] INFO (PostgresTableCountFactory.java:25) - Getting count for episode_event 2023-03-06 13:08:18,338 13:08:18.338 [main] INFO (PostgresTableCountFactory.java:25) - Getting count for fact_relationship 2023-03-06 13:08:18,339 13:08:18.339 [main] INFO (PostgresTableCountFactory.java:25) - Getting count for final_visit_ids 2023-03-06 13:08:18,342 13:08:18.342 [main] INFO (PostgresTableCountFactory.java:25) - Getting count for location 2023-03-06 13:08:18,343 13:08:18.343 [main] INFO (PostgresTableCountFactory.java:25) - Getting count for measurement 2023-03-06 13:08:18,387 13:08:18.387 [main] INFO (PostgresTableCountFactory.java:25) - Getting count for metadata 2023-03-06 13:08:18,388 13:08:18.388 [main] INFO (PostgresTableCountFactory.java:25) - Getting count for note 2023-03-06 13:08:18,389 13:08:18.389 [main] INFO (PostgresTableCountFactory.java:25) - Getting count for note_nlp 2023-03-06 13:08:18,389 13:08:18.389 [main] INFO (PostgresTableCountFactory.java:25) - Getting count for observation 2023-03-06 13:08:18,393 13:08:18.393 [main] INFO (PostgresTableCountFactory.java:25) - Getting count for observation_period 2023-03-06 13:08:18,394 13:08:18.394 [main] INFO (PostgresTableCountFactory.java:25) - Getting count for payer_plan_period 2023-03-06 13:08:18,394 13:08:18.394 [main] INFO (PostgresTableCountFactory.java:25) - Getting count for person 2023-03-06 13:08:18,395 13:08:18.395 [main] INFO (PostgresTableCountFactory.java:25) - Getting count for procedure_occurrence 2023-03-06 13:08:18,397 13:08:18.397 [main] INFO (PostgresTableCountFactory.java:25) - Getting count for provider 2023-03-06 13:08:18,398 13:08:18.398 [main] INFO (PostgresTableCountFactory.java:25) - Getting count for relationship 2023-03-06 13:08:18,399 13:08:18.399 [main] INFO (PostgresTableCountFactory.java:25) - Getting count for source_to_concept_map 2023-03-06 13:08:18,399 13:08:18.399 [main] INFO (PostgresTableCountFactory.java:25) - Getting count for source_to_source_vocab_map 2023-03-06 13:08:18,547 13:08:18.547 [main] INFO (PostgresTableCountFactory.java:25) - Getting count for source_to_standard_vocab_map 2023-03-06 13:08:18,656 13:08:18.656 [main] INFO (PostgresTableCountFactory.java:25) - Getting count for specimen 2023-03-06 13:08:18,657 13:08:18.657 [main] INFO (PostgresTableCountFactory.java:25) - Getting count for visit_detail 2023-03-06 13:08:18,661 13:08:18.661 [main] INFO (PostgresTableCountFactory.java:25) - Getting count for visit_occurrence 2023-03-06 13:08:18,666 13:08:18.666 [main] INFO (PostgresTableCountFactory.java:25) - Getting count for vocabulary 2023-03-06 13:08:18,666 13:08:18.666 [main] INFO (PostgresTableCountFactory.java:34) - Closing connection... 2023-03-06 13:08:18,667 13:08:18.667 [main] INFO (PostgresTableCountFactory.java:36) - Connection closed. 2023-03-06 13:08:18,667 13:08:18.667 [main] INFO (PostgresTableCountFactory.java:38) - Done getting table counts. 2023-03-06 13:08:18,667 13:08:18.667 [main] INFO (TableCountsIntegrationTest.java:47) - Got counts for: 44 tables. 2023-03-06 13:08:18,667 13:08:18.667 [main] INFO (TableCountsIntegrationTest.java:54) - Table counts: /nTABLE COUNTS FOR: etl_synthea_1k 50395 etl_synthea_1k.all_visits 60833 etl_synthea_1k.assign_all_visit_ids 0 etl_synthea_1k.care_site 1 etl_synthea_1k.cdm_source 0 etl_synthea_1k.cohort 0 etl_synthea_1k.cohort_definition 5896259 etl_synthea_1k.concept 69838015 etl_synthea_1k.concept_ancestor 416 etl_synthea_1k.concept_class 47294986 etl_synthea_1k.concept_relationship 2034071 etl_synthea_1k.concept_synonym 7680 etl_synthea_1k.condition_era 7685 etl_synthea_1k.condition_occurrence 66144 etl_synthea_1k.cost 0 etl_synthea_1k.death 78 etl_synthea_1k.device_exposure 50 etl_synthea_1k.domain 0 etl_synthea_1k.dose_era 8177 etl_synthea_1k.drug_era 43001 etl_synthea_1k.drug_exposure 2936602 etl_synthea_1k.drug_strength 0 etl_synthea_1k.episode 0 etl_synthea_1k.episode_event 0 etl_synthea_1k.fact_relationship 51367 etl_synthea_1k.final_visit_ids 0 etl_synthea_1k.location 263253 etl_synthea_1k.measurement 0 etl_synthea_1k.metadata 0 etl_synthea_1k.note 0 etl_synthea_1k.note_nlp 14285 etl_synthea_1k.observation 1171 etl_synthea_1k.observation_period 3801 etl_synthea_1k.payer_plan_period 1171 etl_synthea_1k.person 26974 etl_synthea_1k.procedure_occurrence 5855 etl_synthea_1k.provider 672 etl_synthea_1k.relationship 0 etl_synthea_1k.source_to_concept_map 5896259 etl_synthea_1k.source_to_source_vocab_map 4343057 etl_synthea_1k.source_to_standard_vocab_map 0 etl_synthea_1k.specimen 48097 etl_synthea_1k.visit_detail 48097 etl_synthea_1k.visit_occurrence 59 etl_synthea_1k.vocabulary 2023-03-06 13:08:18,667 13:08:18.667 [main] INFO (TableCountsIntegrationTest.java:58) - Done. 2023-03-06 13:08:18,667 13:08:18.667 [main] INFO (ConnectionFactoryIntegrationTest.java:16) - Getting connection... 2023-03-06 13:08:18,668 13:08:18.668 [main] INFO (PostgresqlConnectionFactory.java:26) - Getting connection for url: jdbc:postgresql://localhost:5432/OHDSI?user=postgres&password=ohdsi¤tSchema=etl_synthea_1k 2023-03-06 13:08:18,702 13:08:18.702 [main] INFO (ConnectionFactoryIntegrationTest.java:18) - Got connection: org.postgresql.jdbc.PgConnection@8dbfffb 2023-03-06 13:08:18,702 13:08:18.702 [main] INFO (ConnectionFactoryIntegrationTest.java:19) - Closing connection... 2023-03-06 13:08:18,702 13:08:18.702 [main] INFO (ConnectionFactoryIntegrationTest.java:21) - Done.