CREATE INDEX ix_term_enrich_agent_enr_term ON pub2.term_enrichment_agent USING btree (enriched_term_id);

[ Date: 2026-04-30 00:39:46 ]

CREATE INDEX ix_term_enrich_agent_enr_term ON pub2.term_enrichment_agent USING btree (enriched_term_id);

[ Date: 2026-04-30 00:39:46 ]

CREATE INDEX ix_term_enrich_agent_enr_term ON pub2.term_enrichment_agent USING btree (enriched_term_id);

[ Date: 2026-04-30 00:39:46 ]

CREATE INDEX ix_term_enrich_agent_enr_term ON pub2.term_enrichment_agent USING btree (enriched_term_id);

[ Date: 2026-04-30 00:39:46 ]

CREATE INDEX ix_term_enrich_agent_enr_term ON pub2.term_enrichment_agent USING btree (enriched_term_id);

[ Date: 2026-04-30 00:39:46 ]

CREATE INDEX ix_term_enrich_agent_enr_term ON pub2.term_enrichment_agent USING btree (enriched_term_id);

[ Date: 2026-04-30 00:39:46 ]

CREATE INDEX ix_term_enrich_agent_enr_term ON pub2.term_enrichment_agent USING btree (enriched_term_id);

[ Date: 2026-04-30 00:39:47 ]

CREATE INDEX ix_term_enrich_agent_enr_term ON pub2.term_enrichment_agent USING btree (enriched_term_id);

[ Date: 2026-04-30 00:39:47 ]

CREATE INDEX ix_term_enrich_agent_enr_term ON pub2.term_enrichment_agent USING btree (enriched_term_id);

[ Date: 2026-04-30 00:39:47 ]

CREATE INDEX ix_term_enrich_agent_enr_term ON pub2.term_enrichment_agent USING btree (enriched_term_id);

[ Date: 2026-04-30 00:39:47 ]

ALTER TABLE pub2.term_enrichment_agent ADD CONSTRAINT term_enrichment_agent_pk PRIMARY KEY (term_id, enriched_term_id, agent_term_id);

[ Date: 2026-04-30 00:43:01 ]

ALTER TABLE pub2.term_enrichment_agent ADD CONSTRAINT term_enrichment_agent_pk PRIMARY KEY (term_id, enriched_term_id, agent_term_id);

[ Date: 2026-04-30 00:43:01 ]

ALTER TABLE pub2.term_enrichment_agent ADD CONSTRAINT term_enrichment_agent_pk PRIMARY KEY (term_id, enriched_term_id, agent_term_id);

[ Date: 2026-04-30 00:43:01 ]

ALTER TABLE pub2.term_enrichment_agent ADD CONSTRAINT term_enrichment_agent_pk PRIMARY KEY (term_id, enriched_term_id, agent_term_id);

[ Date: 2026-04-30 00:43:01 ]

ALTER TABLE pub2.term_enrichment_agent ADD CONSTRAINT term_enrichment_agent_pk PRIMARY KEY (term_id, enriched_term_id, agent_term_id);

[ Date: 2026-04-30 00:43:01 ]

ALTER TABLE pub2.term_enrichment_agent ADD CONSTRAINT term_enrichment_agent_pk PRIMARY KEY (term_id, enriched_term_id, agent_term_id);

[ Date: 2026-04-30 00:43:01 ]

ALTER TABLE pub2.term_enrichment_agent ADD CONSTRAINT term_enrichment_agent_pk PRIMARY KEY (term_id, enriched_term_id, agent_term_id);

[ Date: 2026-04-30 00:43:01 ]

ALTER TABLE pub2.term_enrichment_agent ADD CONSTRAINT term_enrichment_agent_pk PRIMARY KEY (term_id, enriched_term_id, agent_term_id);

[ Date: 2026-04-30 00:43:02 ]

ALTER TABLE pub2.term_enrichment_agent ADD CONSTRAINT term_enrichment_agent_pk PRIMARY KEY (term_id, enriched_term_id, agent_term_id);

[ Date: 2026-04-30 00:43:02 ]

ALTER TABLE pub2.term_enrichment_agent ADD CONSTRAINT term_enrichment_agent_pk PRIMARY KEY (term_id, enriched_term_id, agent_term_id);

[ Date: 2026-04-30 00:43:02 ]

SELECT maint_term_derive_nm_fts ();

[ Date: 2026-04-30 06:28:34 - Bind query: yes ]

select pub2.maint_term_derive_data ();

[ Date: 2026-04-30 09:48:59 - Bind query: yes ]

select pub2.maint_gene_chem_ref_gene_form_refresh ();

[ Date: 2026-04-30 03:42:08 - Bind query: yes ]

VACUUM FULL ANALYZE;

[ Date: 2026-04-30 07:32:23 - Bind query: yes ]

select pub2.maint_cached_value_refresh_data_metrics ();

[ Date: 2026-04-30 10:36:48 - Bind query: yes ]

SELECT /* AllGDRelationsDAO */ g.nm "GeneSymbol", g.acc_txt "GeneID", d.nm "DiseaseName", d.acc_db_cd || ':' || d.acc_txt "DiseaseID", CASE WHEN gdr.via_chem_id IS NULL THEN ( SELECT STRING_AGG(a.action_type_nm, '|' ORDER BY a.action_type_nm) FROM gene_disease_axn a WHERE a.gene_id = gdr.gene_id AND a.disease_id = gdr.disease_id) ELSE NULL END "DirectEvidence", c.nm "InferenceChemicalName", gdr.network_score "InferenceScore", STRING_AGG(gdr.source_acc_txt, '|' ORDER BY gdr.source_acc_txt) "OmimIDs", STRING_AGG(r.acc_txt, '|' ORDER BY r.acc_txt) "PubMedIDs" FROM gene_disease_reference gdr INNER JOIN term g ON gdr.gene_id = g.id INNER JOIN term d ON gdr.disease_id = d.id LEFT OUTER JOIN reference r ON gdr.reference_id = r.id LEFT OUTER JOIN term c ON gdr.via_chem_id = c.id GROUP BY g.nm, g.acc_txt, d.nm, d.acc_db_cd || ':' || d.acc_txt, CASE WHEN gdr.via_chem_id IS NULL THEN ( SELECT STRING_AGG(a.action_type_nm, '|' ORDER BY a.action_type_nm) FROM gene_disease_axn a WHERE a.gene_id = gdr.gene_id AND a.disease_id = gdr.disease_id) ELSE NULL END, c.nm, gdr.network_score ORDER BY g.nm, d.nm;

[ Date: 2026-04-30 13:36:32 - Database: ctdprd51 - User: qaeu - Bind query: yes ]

update pub2.GENE_DISEASE gd set exposure_reference_qty = ( select count(distinct reference_id) from pub2.GENE_DISEASE_REFERENCE gdr where gd.gene_id = gdr.gene_id and gd.disease_id = gdr.disease_id and reference_id in ( select id from pub2.REFERENCE r where has_exposures = true));

[ Date: 2026-04-30 01:43:11 - Bind query: yes ]

ALTER TABLE pub2.term_enrichment_agent ADD CONSTRAINT term_enr_agent_term_enr_fk FOREIGN KEY (term_id, enriched_term_id) REFERENCES term_enrichment (term_id, enriched_term_id);

[ Date: 2026-04-30 00:37:41 - Bind query: yes ]

/* * Run daily to prune LOG_QUERY, archive old queries to LOG_QUERY_ARCHIVE * and vacuum/analyze the tables. * * $Id: archive_query_logs.sql 10832 2012-03-19 15:27:11Z mcr $ */ SELECT maint_query_logs_archive ();

[ Date: 2026-04-30 00:09:18 - Database: ctdprd51 - User: pubc - Application: psql ]

select pub2.maint_phenotype_term_derive_data ();

[ Date: 2026-04-30 09:59:20 - Bind query: yes ]

ALTER TABLE pub2.term_enrichment_agent ADD CONSTRAINT term_enrichment_agent_pk PRIMARY KEY (term_id, enriched_term_id, agent_term_id);

[ Date: 2026-04-30 00:43:02 - Bind query: yes ]

SELECT maint_term_label_derive_nm_fts ();

[ Date: 2026-04-30 06:31:55 - Bind query: yes ]

SELECT * FROM pgbulkload.pg_bulkload ('{TABLE=pub2.TERM_ENRICHMENT_AGENT,TYPE=CSV,DELIMITER=|,"ESCAPE=\\",PARSE_ERRORS=0,DUPLICATE_ERRORS=0,OFFSET=1,VERBOSE=true,infile=stdin,logfile=/home/load/ctdLoadData/pub/goEnrichment/enrichedTermAgent.txt.log,parse-badfile=/home/load/ctdLoadData/pub/goEnrichment/enrichedTermAgent.txt.BAD,duplicate-badfile=/home/load/ctdLoadData/pub/goEnrichment/enrichedTermAgent.txt.DUPE}');

[ Date: 2026-04-30 00:21:53 - Database: ctdprd51 - User: load - Application: pg_bulkload - Bind query: yes ]

INSERT INTO pub2.TERM_REFERENCE (term_id, object_type_id, reference_id, ixn_type_id) SELECT DISTINCT term_id, object_type_id, reference_id, ixn_type_id FROM ( SELECT gene_id as term_id, ( SELECT object_type_id FROM pub2.TERM WHERE id = gene_id), reference_id, ( SELECT id FROM edit.IXN_TYPE WHERE nm = 'CHEMICAL-GENE') as ixn_type_id FROM pub2.GENE_CHEM_REFERENCE UNION SELECT chem_id as term_id, ( SELECT object_type_id FROM pub2.TERM WHERE id = chem_id), reference_id, ( SELECT id FROM edit.IXN_TYPE WHERE nm = 'CHEMICAL-GENE') as ixn_type_id FROM pub2.GENE_CHEM_REFERENCE UNION SELECT taxon_id as term_id, ( SELECT object_type_id FROM pub2.TERM WHERE id = taxon_id), reference_id, ( SELECT id FROM edit.IXN_TYPE WHERE nm = 'CHEMICAL-GENE') as ixn_type_id FROM pub2.GENE_CHEM_REFERENCE WHERE taxon_id IS NOT NULL UNION SELECT chem_id as term_id, ( SELECT object_type_id FROM pub2.TERM WHERE id = chem_id), reference_id, ( SELECT id FROM edit.IXN_TYPE WHERE nm = 'CHEMICAL-DISEASE') as ixn_type_id FROM pub2.CHEM_DISEASE_REFERENCE WHERE source_cd = 'C' UNION SELECT disease_id as term_id, ( SELECT object_type_id FROM pub2.TERM WHERE id = disease_id), reference_id, ( SELECT id FROM edit.IXN_TYPE WHERE nm = 'CHEMICAL-DISEASE') as ixn_type_id FROM pub2.CHEM_DISEASE_REFERENCE WHERE source_cd = 'C' UNION SELECT gene_id as term_id, ( SELECT object_type_id FROM pub2.TERM WHERE id = gene_id), reference_id, ( SELECT id FROM edit.IXN_TYPE WHERE nm = 'GENE-DISEASE') as ixn_type_id FROM pub2.GENE_DISEASE_REFERENCE WHERE source_cd = 'C' UNION SELECT disease_id as term_id, ( SELECT object_type_id FROM pub2.TERM WHERE id = disease_id), reference_id, ( SELECT id FROM edit.IXN_TYPE WHERE nm = 'GENE-DISEASE') as ixn_type_id FROM pub2.GENE_DISEASE_REFERENCE WHERE source_cd = 'C' UNION SELECT ee.exp_marker_term_id as term_id, ( SELECT object_type_id FROM term WHERE id = exp_marker_term_id), e.reference_id, ( SELECT id FROM edit.ixn_type WHERE nm = 'EXPOSURE') as ixn_type_id FROM pub2.EXPOSURE e, pub2.EXP_EVENT ee WHERE e.exp_event_id = ee.id AND exp_marker_term_id IS NOT NULL UNION SELECT er.term_id, ( SELECT object_type_id FROM term WHERE id = er.term_id), e.reference_id, ( SELECT id FROM edit.ixn_type WHERE nm = 'EXPOSURE') as ixn_type_id FROM pub2.EXPOSURE e, pub2.EXP_RECEPTOR er WHERE e.exp_receptor_id = er.id AND er.term_id IS NOT NULL UNION SELECT chem_id as term_id, ( SELECT object_type_id FROM term WHERE id = chem_id), e.reference_id, ( SELECT id FROM edit.ixn_type WHERE nm = 'EXPOSURE') as ixn_type_id FROM pub2.EXPOSURE e, pub2.EXP_STRESSOR es WHERE e.exp_stressor_id = es.id AND chem_id IS NOT NULL UNION SELECT phenotype_id as term_id, ( SELECT object_type_id FROM term WHERE id = phenotype_id), e.reference_id, ( SELECT id FROM edit.ixn_type WHERE nm = 'EXPOSURE') as ixn_type_id FROM pub2.EXPOSURE e, pub2.EXP_OUTCOME eo WHERE e.exp_outcome_id = eo.id AND phenotype_id IS NOT NULL UNION SELECT disease_id as term_id, ( SELECT object_type_id FROM term WHERE id = disease_id), e.reference_id, ( SELECT id FROM edit.ixn_type WHERE nm = 'EXPOSURE') as ixn_type_id FROM pub2.EXPOSURE e, pub2.EXP_OUTCOME eo WHERE e.exp_outcome_id = eo.id AND disease_id IS NOT NULL UNION SELECT phenotype_id as term_id, ( SELECT object_type_id FROM pub2.TERM WHERE id = phenotype_id), reference_id, ( SELECT id FROM edit.IXN_TYPE WHERE nm = 'PHENOTYPE') as ixn_type_id FROM pub2.PHENOTYPE_TERM_REFERENCE WHERE source_cd = 'C' UNION SELECT term_id, ( SELECT object_type_id FROM pub2.TERM WHERE id = term_id), reference_id, ( SELECT id FROM edit.IXN_TYPE WHERE nm = 'PHENOTYPE') as ixn_type_id FROM pub2.PHENOTYPE_TERM_REFERENCE WHERE source_cd = 'C' UNION SELECT taxon_id as term_id, ( SELECT object_type_id FROM pub2.TERM WHERE id = taxon_id), reference_id, ( SELECT id FROM edit.IXN_TYPE WHERE nm = 'PHENOTYPE') as ixn_type_id FROM pub2.PHENOTYPE_TERM_REFERENCE WHERE source_cd = 'C' AND taxon_id IS NOT NULL UNION SELECT from_gene_id as term_id, ( SELECT object_type_id FROM pub2.TERM WHERE id = from_gene_id), reference_id, ( SELECT id FROM edit.IXN_TYPE WHERE nm = 'GENE-GENE') as ixn_type_id FROM pub2.GENE_GENE_REFERENCE UNION SELECT to_gene_id as term_id, ( SELECT object_type_id FROM pub2.TERM WHERE id = to_gene_id), reference_id, ( SELECT id FROM edit.IXN_TYPE WHERE nm = 'GENE-GENE') as ixn_type_id FROM pub2.GENE_GENE_REFERENCE UNION SELECT from_taxon_id as term_id, ( SELECT object_type_id FROM pub2.TERM WHERE id = from_taxon_id), reference_id, ( SELECT id FROM edit.IXN_TYPE WHERE nm = 'GENE-GENE') as ixn_type_id FROM pub2.GENE_GENE_REFERENCE UNION SELECT to_taxon_id as term_id, ( SELECT object_type_id FROM pub2.TERM WHERE id = to_taxon_id), reference_id, ( SELECT id FROM edit.IXN_TYPE WHERE nm = 'GENE-GENE') as ixn_type_id FROM pub2.GENE_GENE_REFERENCE UNION SELECT DISTINCT t.id as taxon_id, t.object_type_id as taxon_object_id, r.id as reference_id, i.ixn_type_id as ixn_type_id FROM edit.REFERENCE_IXN ri, pub2.TERM t, edit.IXN i, pub2.REFERENCE r WHERE ri.taxon_acc_txt = t.acc_txt AND t.object_type_id = ( SELECT id FROM pub2.OBJECT_TYPE WHERE cd = 'taxon') AND ri.ixn_id = i.root_id AND i.ixn_type_id in ( SELECT id FROM edit.IXN_TYPE WHERE nm in ('CHEMICAL-DISEASE', 'GENE-DISEASE')) AND ri.reference_acc_txt = r.acc_txt AND ri.taxon_acc_txt IS NOT NULL AND ri.taxon_acc_txt <> '') as test UNION select ea.anatomy_id as term_id, ( select id from object_type where cd = 'anatomy') as object_type_id, r.id as reference_id, ( select id from ixn_type where nm = 'EXPOSURE') as ixn_type_id from pub2.EXP_ANATOMY ea, pub2.EXP_OUTCOME eo, pub2.EXPOSURE e, pub2.REFERENCE r where ea.exp_outcome_id = eo.id and eo.id = e.exp_outcome_id and e.reference_acc_txt = r.acc_txt UNION select anatomy_id as term_id, ( select id from object_type where cd = 'anatomy') as object_type_id, r.id as reference_id, ( select id from ixn_type where nm = 'PHENOTYPE') as ixn_type_id from pub2.IXN i, pub2.IXN_ANATOMY ia, edit.REFERENCE_IXN ri, pub2.REFERENCE r where i.id = ri.ixn_id and ri.reference_acc_txt = r.acc_txt and i.id = ia.ixn_id UNION select medium_term_id as term_id, ( select id from object_type where cd = 'anatomy') as object_type_id, r.id, ( select id from ixn_type where nm = 'EXPOSURE') as ixn_type_id from pub2.EXP_EVENT ee, pub2.EXPOSURE e, pub2.REFERENCE r where ee.id = e.exp_event_id and e.reference_acc_txt = r.acc_txt and medium_term_id is not null;