Times Reported Time consuming queries #1

x Hide

[ User: pubeu - Total duration: 57m31s - Times executed: 12 ]

x Hide

SELECT /* GoDiseasesDAO */ phenotypeTerm.nm goNm, phenotypeTerm.nm_html goNmHTML, phenotypeTerm.acc_txt goAcc, phenotypeTerm.id goId, diseaseTerm.nm diseaseNm, diseaseTerm.acc_txt diseaseAcc, diseaseTerm.acc_db_cd diseaseAccDBCd, diseaseTerm.id diseaseId, via_gene_qty geneNetworkCount, via_chem_qty chemNetworkCount, indirect_reference_qty referenceCount, COUNT(*) OVER () fullRowCount FROM phenotype_term pt inner join term phenotypeTerm on pt.phenotype_id = phenotypeTerm.id inner join term diseaseTerm on pt.term_id = diseaseTerm.id WHERE phenotypeTerm.id IN ( select distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id = '1232823') and diseaseTerm.object_type_id = 3 ORDER BY chemNetworkCount desc, geneNetworkCount desc LIMIT 50;

Date: 2024-05-02 14:09:23
Duration: 17m24s
Database: ctdprd51
User: pubeu
Bind query: yes

SELECT /* GoDiseasesDAO */ phenotypeTerm.nm goNm, phenotypeTerm.nm_html goNmHTML, phenotypeTerm.acc_txt goAcc, phenotypeTerm.id goId, diseaseTerm.nm diseaseNm, diseaseTerm.acc_txt diseaseAcc, diseaseTerm.acc_db_cd diseaseAccDBCd, diseaseTerm.id diseaseId, via_gene_qty geneNetworkCount, via_chem_qty chemNetworkCount, indirect_reference_qty referenceCount, COUNT(*) OVER () fullRowCount FROM phenotype_term pt inner join term phenotypeTerm on pt.phenotype_id = phenotypeTerm.id inner join term diseaseTerm on pt.term_id = diseaseTerm.id WHERE phenotypeTerm.id IN ( select distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id = '1232823') and diseaseTerm.object_type_id = 3 ORDER BY chemNetworkCount desc, geneNetworkCount desc LIMIT 50;

Date: 2024-05-02 14:09:11
Duration: 17m2s
Database: ctdprd51
User: pubeu
Bind query: yes

SELECT /* GoDiseasesDAO */ phenotypeTerm.nm goNm, phenotypeTerm.nm_html goNmHTML, phenotypeTerm.acc_txt goAcc, phenotypeTerm.id goId, diseaseTerm.nm diseaseNm, diseaseTerm.acc_txt diseaseAcc, diseaseTerm.acc_db_cd diseaseAccDBCd, diseaseTerm.id diseaseId, via_gene_qty geneNetworkCount, via_chem_qty chemNetworkCount, indirect_reference_qty referenceCount, COUNT(*) OVER () fullRowCount FROM phenotype_term pt inner join term phenotypeTerm on pt.phenotype_id = phenotypeTerm.id inner join term diseaseTerm on pt.term_id = diseaseTerm.id WHERE phenotypeTerm.id IN ( select distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id = '1223120') and diseaseTerm.object_type_id = 3 ORDER BY chemNetworkCount desc, geneNetworkCount desc LIMIT 50;

Date: 2024-05-02 18:39:49
Duration: 5m59s
Bind query: yes

x Hide

Times Reported Time consuming queries #2

x Hide

/* * 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: 2024-05-02 00:15:44
Duration: 15m43s

x Hide

Times Reported Time consuming queries #3

x Hide

[ User: pubeu - Total duration: 2m2s - Times executed: 47 ]

x Hide

SELECT /* ChemExposureStudiesAssnsDAO */ e.reference_acc_txt || '^' || r.abbr_authors_txt || '^' || r.pub_start_yr as ref, ( SELECT STRING_AGG(DISTINCT expStudyFactor.study_factor_nm, ' | ')) as studyFactorNms, ( SELECT STRING_AGG(DISTINCT eventProject.project_nm, ' | ')) as associatedStudyTitles, ( SELECT STRING_AGG(distinct stressorTerm.nm || '^' || ( select cd from object_type where id = stressorTerm.object_type_id) || '^' || stressorTerm.nm_html || '^' || stressorTerm.acc_txt || '^' || stressorTerm.acc_db_cd, '|')) as stressorAgents, ( SELECT STRING_AGG(distinct COALESCE(receptorTerm.nm, '') || '^' || COALESCE(( select cd from object_type where id = receptorTerm.object_type_id), '') || '^' || COALESCE(receptorTerm.nm_html, '') || '^' || COALESCE(receptorTerm.acc_txt, '') || '^' || COALESCE(receptorTerm.acc_db_cd, '') || '^' || receptor.description, '|')) as receptors, ( SELECT STRING_AGG(distinct country.nm, ' | ')) as studyCountries, ( SELECT STRING_AGG(distinct location.locality_txt, ' | ')) as localities, ( SELECT STRING_AGG(distinct event.medium_nm || '^' || COALESCE(event.medium_term_acc_txt, ''), ' | ')) as assayMediums, ( SELECT STRING_AGG(distinct exposureMarkerTerm.nm || '^' || ( select cd from object_type where id = exposureMarkerTerm.object_type_id) || '^' || exposureMarkerTerm.nm_html || '^' || exposureMarkerTerm.acc_txt || '^' || exposureMarkerTerm.acc_db_cd, '|')) as assayedMarkers, ( SELECT STRING_AGG(distinct diseaseTerm.nm || '^' || ( select cd from object_type where id = diseaseTerm.object_type_id) || '^' || diseaseTerm.nm_html || '^' || diseaseTerm.acc_txt || '^' || diseaseTerm.acc_db_cd, '|')) as diseases, ( SELECT STRING_AGG(distinct phenotypeTerm.nm || '^' || ( select cd from object_type where id = phenotypeTerm.object_type_id) || '^' || phenotypeTerm.nm_html || '^' || phenotypeTerm.acc_txt || '^' || phenotypeTerm.acc_db_cd, '|')) as phenotypes, ( SELECT STRING_AGG(distinct anatomyTerm.nm_html || '^' || anatomyTerm.acc_txt || '^' || anatomyTerm.id || '^' || anatomyTerm.acc_db_cd || '^' || anatomyTerm.nm, '|')) as anatomyTerms, re.author_summary summary, COUNT(*) OVER () fullRowCount FROM exposure e inner join reference r ON e.reference_id = r.id inner join exp_stressor stressor ON e.exp_stressor_id = stressor.id left outer join exp_receptor receptor ON e.exp_receptor_id = receptor.id left outer join term receptorTerm ON receptor.term_id = receptorTerm.id left outer join exp_event event ON e.exp_event_id = event.id left outer join exp_event_project eventProject ON event.id = eventProject.exp_event_id left outer join exp_event_location location ON e.exp_event_id = location.exp_event_id left outer join country ON location.country_id = country.id left outer join term exposureMarkerTerm ON event.exp_marker_term_id = exposureMarkerTerm.id left outer join exp_outcome outcome ON e.exp_outcome_id = outcome.id left outer join term diseaseTerm ON outcome.disease_id = diseaseTerm.id left outer join term phenotypeTerm ON outcome.phenotype_id = phenotypeTerm.id inner join term stressorTerm ON stressor.chem_id = stressorTerm.id left outer join exp_anatomy expAnatomy ON outcome.id = expAnatomy.exp_outcome_id Left outer join term anatomyTerm ON expAnatomy.anatomy_id = anatomyTerm.id inner join reference_exp re ON e.reference_id = re.reference_id left outer join exp_study_factor expStudyFactor on re.id = expStudyFactor.reference_exp_id where e.reference_id = ANY (ARRAY ( select reference_id from exposure e1, term chem, exp_stressor s1 where chem.id in ( select descendant_object_id from dag_path where ancestor_object_id = '1384112') and chem.id = s1.chem_id and s1.id = e1.exp_stressor_id union select reference_id from exposure e1, term t, exp_event event1 where t.id in ( select descendant_object_id from dag_path where ancestor_object_id = '1384112') and t.id = event1.exp_marker_term_id and event1.exp_marker_type_id in ( select id from exp_marker_type where nm like 'chem%') and event1.id = e1.exp_event_id)) group by e.reference_acc_txt, r.abbr_authors_txt, pub_start_yr, re.author_summary order by stressorAgents LIMIT 50;

Date: 2024-05-02 16:41:53
Duration: 5s353ms
Database: ctdprd51
User: pubeu
Bind query: yes

SELECT /* ChemExposureStudiesAssnsDAO */ e.reference_acc_txt || '^' || r.abbr_authors_txt || '^' || r.pub_start_yr as ref, ( SELECT STRING_AGG(DISTINCT expStudyFactor.study_factor_nm, ' | ')) as studyFactorNms, ( SELECT STRING_AGG(DISTINCT eventProject.project_nm, ' | ')) as associatedStudyTitles, ( SELECT STRING_AGG(distinct stressorTerm.nm || '^' || ( select cd from object_type where id = stressorTerm.object_type_id) || '^' || stressorTerm.nm_html || '^' || stressorTerm.acc_txt || '^' || stressorTerm.acc_db_cd, '|')) as stressorAgents, ( SELECT STRING_AGG(distinct COALESCE(receptorTerm.nm, '') || '^' || COALESCE(( select cd from object_type where id = receptorTerm.object_type_id), '') || '^' || COALESCE(receptorTerm.nm_html, '') || '^' || COALESCE(receptorTerm.acc_txt, '') || '^' || COALESCE(receptorTerm.acc_db_cd, '') || '^' || receptor.description, '|')) as receptors, ( SELECT STRING_AGG(distinct country.nm, ' | ')) as studyCountries, ( SELECT STRING_AGG(distinct location.locality_txt, ' | ')) as localities, ( SELECT STRING_AGG(distinct event.medium_nm || '^' || COALESCE(event.medium_term_acc_txt, ''), ' | ')) as assayMediums, ( SELECT STRING_AGG(distinct exposureMarkerTerm.nm || '^' || ( select cd from object_type where id = exposureMarkerTerm.object_type_id) || '^' || exposureMarkerTerm.nm_html || '^' || exposureMarkerTerm.acc_txt || '^' || exposureMarkerTerm.acc_db_cd, '|')) as assayedMarkers, ( SELECT STRING_AGG(distinct diseaseTerm.nm || '^' || ( select cd from object_type where id = diseaseTerm.object_type_id) || '^' || diseaseTerm.nm_html || '^' || diseaseTerm.acc_txt || '^' || diseaseTerm.acc_db_cd, '|')) as diseases, ( SELECT STRING_AGG(distinct phenotypeTerm.nm || '^' || ( select cd from object_type where id = phenotypeTerm.object_type_id) || '^' || phenotypeTerm.nm_html || '^' || phenotypeTerm.acc_txt || '^' || phenotypeTerm.acc_db_cd, '|')) as phenotypes, ( SELECT STRING_AGG(distinct anatomyTerm.nm_html || '^' || anatomyTerm.acc_txt || '^' || anatomyTerm.id || '^' || anatomyTerm.acc_db_cd || '^' || anatomyTerm.nm, '|')) as anatomyTerms, re.author_summary summary, COUNT(*) OVER () fullRowCount FROM exposure e inner join reference r ON e.reference_id = r.id inner join exp_stressor stressor ON e.exp_stressor_id = stressor.id left outer join exp_receptor receptor ON e.exp_receptor_id = receptor.id left outer join term receptorTerm ON receptor.term_id = receptorTerm.id left outer join exp_event event ON e.exp_event_id = event.id left outer join exp_event_project eventProject ON event.id = eventProject.exp_event_id left outer join exp_event_location location ON e.exp_event_id = location.exp_event_id left outer join country ON location.country_id = country.id left outer join term exposureMarkerTerm ON event.exp_marker_term_id = exposureMarkerTerm.id left outer join exp_outcome outcome ON e.exp_outcome_id = outcome.id left outer join term diseaseTerm ON outcome.disease_id = diseaseTerm.id left outer join term phenotypeTerm ON outcome.phenotype_id = phenotypeTerm.id inner join term stressorTerm ON stressor.chem_id = stressorTerm.id left outer join exp_anatomy expAnatomy ON outcome.id = expAnatomy.exp_outcome_id Left outer join term anatomyTerm ON expAnatomy.anatomy_id = anatomyTerm.id inner join reference_exp re ON e.reference_id = re.reference_id left outer join exp_study_factor expStudyFactor on re.id = expStudyFactor.reference_exp_id where e.reference_id = ANY (ARRAY ( select reference_id from exposure e1, term chem, exp_stressor s1 where chem.id in ( select descendant_object_id from dag_path where ancestor_object_id = '1384112') and chem.id = s1.chem_id and s1.id = e1.exp_stressor_id union select reference_id from exposure e1, term t, exp_event event1 where t.id in ( select descendant_object_id from dag_path where ancestor_object_id = '1384112') and t.id = event1.exp_marker_term_id and event1.exp_marker_type_id in ( select id from exp_marker_type where nm like 'chem%') and event1.id = e1.exp_event_id)) group by e.reference_acc_txt, r.abbr_authors_txt, pub_start_yr, re.author_summary order by stressorAgents LIMIT 50;

Date: 2024-05-02 17:43:14
Duration: 5s147ms
Bind query: yes

SELECT /* ChemExposureStudiesAssnsDAO */ e.reference_acc_txt || '^' || r.abbr_authors_txt || '^' || r.pub_start_yr as ref, ( SELECT STRING_AGG(DISTINCT expStudyFactor.study_factor_nm, ' | ')) as studyFactorNms, ( SELECT STRING_AGG(DISTINCT eventProject.project_nm, ' | ')) as associatedStudyTitles, ( SELECT STRING_AGG(distinct stressorTerm.nm || '^' || ( select cd from object_type where id = stressorTerm.object_type_id) || '^' || stressorTerm.nm_html || '^' || stressorTerm.acc_txt || '^' || stressorTerm.acc_db_cd, '|')) as stressorAgents, ( SELECT STRING_AGG(distinct COALESCE(receptorTerm.nm, '') || '^' || COALESCE(( select cd from object_type where id = receptorTerm.object_type_id), '') || '^' || COALESCE(receptorTerm.nm_html, '') || '^' || COALESCE(receptorTerm.acc_txt, '') || '^' || COALESCE(receptorTerm.acc_db_cd, '') || '^' || receptor.description, '|')) as receptors, ( SELECT STRING_AGG(distinct country.nm, ' | ')) as studyCountries, ( SELECT STRING_AGG(distinct location.locality_txt, ' | ')) as localities, ( SELECT STRING_AGG(distinct event.medium_nm || '^' || COALESCE(event.medium_term_acc_txt, ''), ' | ')) as assayMediums, ( SELECT STRING_AGG(distinct exposureMarkerTerm.nm || '^' || ( select cd from object_type where id = exposureMarkerTerm.object_type_id) || '^' || exposureMarkerTerm.nm_html || '^' || exposureMarkerTerm.acc_txt || '^' || exposureMarkerTerm.acc_db_cd, '|')) as assayedMarkers, ( SELECT STRING_AGG(distinct diseaseTerm.nm || '^' || ( select cd from object_type where id = diseaseTerm.object_type_id) || '^' || diseaseTerm.nm_html || '^' || diseaseTerm.acc_txt || '^' || diseaseTerm.acc_db_cd, '|')) as diseases, ( SELECT STRING_AGG(distinct phenotypeTerm.nm || '^' || ( select cd from object_type where id = phenotypeTerm.object_type_id) || '^' || phenotypeTerm.nm_html || '^' || phenotypeTerm.acc_txt || '^' || phenotypeTerm.acc_db_cd, '|')) as phenotypes, ( SELECT STRING_AGG(distinct anatomyTerm.nm_html || '^' || anatomyTerm.acc_txt || '^' || anatomyTerm.id || '^' || anatomyTerm.acc_db_cd || '^' || anatomyTerm.nm, '|')) as anatomyTerms, re.author_summary summary, COUNT(*) OVER () fullRowCount FROM exposure e inner join reference r ON e.reference_id = r.id inner join exp_stressor stressor ON e.exp_stressor_id = stressor.id left outer join exp_receptor receptor ON e.exp_receptor_id = receptor.id left outer join term receptorTerm ON receptor.term_id = receptorTerm.id left outer join exp_event event ON e.exp_event_id = event.id left outer join exp_event_project eventProject ON event.id = eventProject.exp_event_id left outer join exp_event_location location ON e.exp_event_id = location.exp_event_id left outer join country ON location.country_id = country.id left outer join term exposureMarkerTerm ON event.exp_marker_term_id = exposureMarkerTerm.id left outer join exp_outcome outcome ON e.exp_outcome_id = outcome.id left outer join term diseaseTerm ON outcome.disease_id = diseaseTerm.id left outer join term phenotypeTerm ON outcome.phenotype_id = phenotypeTerm.id inner join term stressorTerm ON stressor.chem_id = stressorTerm.id left outer join exp_anatomy expAnatomy ON outcome.id = expAnatomy.exp_outcome_id Left outer join term anatomyTerm ON expAnatomy.anatomy_id = anatomyTerm.id inner join reference_exp re ON e.reference_id = re.reference_id left outer join exp_study_factor expStudyFactor on re.id = expStudyFactor.reference_exp_id where e.reference_id = ANY (ARRAY ( select reference_id from exposure e1, term chem, exp_stressor s1 where chem.id in ( select descendant_object_id from dag_path where ancestor_object_id = '1384112') and chem.id = s1.chem_id and s1.id = e1.exp_stressor_id union select reference_id from exposure e1, term t, exp_event event1 where t.id in ( select descendant_object_id from dag_path where ancestor_object_id = '1384112') and t.id = event1.exp_marker_term_id and event1.exp_marker_type_id in ( select id from exp_marker_type where nm like 'chem%') and event1.id = e1.exp_event_id)) group by e.reference_acc_txt, r.abbr_authors_txt, pub_start_yr, re.author_summary order by stressorAgents LIMIT 50;

Date: 2024-05-02 05:17:00
Duration: 5s144ms
Database: ctdprd51
User: pubeu
Bind query: yes

x Hide

Times Reported Time consuming queries #4

x Hide

[ User: pubeu - Total duration: 1m6s - Times executed: 17 ]

x Hide

SELECT /* ChemDiseasesBySlimDAO */ COALESCE(st.alt_nm, t.nm) slimTermNm, ( SELECT COUNT(*) FROM slim_term_mapping stm INNER JOIN chem_disease cd ON cd.disease_id = stm.mapped_term_id WHERE cd.chem_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '1288778') AND stm.slim_term_id = st.slim_term_id AND cd.curated_reference_qty > 0) curatedCount, ( SELECT COUNT(*) FROM slim_term_mapping stm INNER JOIN chem_disease cd ON cd.disease_id = stm.mapped_term_id WHERE cd.chem_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '1288778') AND stm.slim_term_id = st.slim_term_id AND cd.indirect_gene_qty > 0) inferredCount FROM slim_term st INNER JOIN term t ON st.slim_term_id = t.id WHERE st.slim_id = 1 ORDER BY 1;

Date: 2024-05-02 15:08:37
Duration: 4s98ms
Bind query: yes

SELECT /* ChemDiseasesBySlimDAO */ COALESCE(st.alt_nm, t.nm) slimTermNm, ( SELECT COUNT(*) FROM slim_term_mapping stm INNER JOIN chem_disease cd ON cd.disease_id = stm.mapped_term_id WHERE cd.chem_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '1333164') AND stm.slim_term_id = st.slim_term_id AND cd.curated_reference_qty > 0) curatedCount, ( SELECT COUNT(*) FROM slim_term_mapping stm INNER JOIN chem_disease cd ON cd.disease_id = stm.mapped_term_id WHERE cd.chem_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '1333164') AND stm.slim_term_id = st.slim_term_id AND cd.indirect_gene_qty > 0) inferredCount FROM slim_term st INNER JOIN term t ON st.slim_term_id = t.id WHERE st.slim_id = 1 ORDER BY 1;

Date: 2024-05-02 10:51:58
Duration: 4s91ms
Bind query: yes

SELECT /* ChemDiseasesBySlimDAO */ COALESCE(st.alt_nm, t.nm) slimTermNm, ( SELECT COUNT(*) FROM slim_term_mapping stm INNER JOIN chem_disease cd ON cd.disease_id = stm.mapped_term_id WHERE cd.chem_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '1273595') AND stm.slim_term_id = st.slim_term_id AND cd.curated_reference_qty > 0) curatedCount, ( SELECT COUNT(*) FROM slim_term_mapping stm INNER JOIN chem_disease cd ON cd.disease_id = stm.mapped_term_id WHERE cd.chem_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '1273595') AND stm.slim_term_id = st.slim_term_id AND cd.indirect_gene_qty > 0) inferredCount FROM slim_term st INNER JOIN term t ON st.slim_term_id = t.id WHERE st.slim_id = 1 ORDER BY 1;

Date: 2024-05-02 05:13:19
Duration: 4s59ms
Bind query: yes

x Hide

Times Reported Time consuming queries #5

x Hide

[ User: pubeu - Total duration: 1m2s - Times executed: 10 ]

x Hide

SELECT /* BatchChemGODAO */ 'd002746' "Input", sqi.chem_nm "ChemicalName", sqi.chem_acc_txt "ChemicalID", sqi.casRN "CasRN", sqi.gene_symbol "GeneSymbol", sqi.gene_acc_txt "GeneID", sqi.ontology_nm "Ontology", sqi.go_term_nm "GoTermName", sqi.go_acc_txt "GoTermID" FROM ( WITH sq AS ( SELECT DISTINCT c.id chem_id, c.nm chem_nm, c.acc_txt chem_acc_txt, c.secondary_nm casRN, c.nm_sort chem_nm_sort, gcr.gene_id, g.nm gene_symbol, g.acc_txt gene_acc_txt, g.nm_sort gene_symbol_sort FROM term c INNER JOIN gene_chem_reference gcr ON c.id = gcr.chem_id INNER JOIN term g ON gcr.gene_id = g.id WHERE (c.id = 1300542)) SELECT DISTINCT sq.chem_nm, sq.chem_acc_txt, sq.casRN, sq.gene_symbol, sq.gene_acc_txt, gt.nm go_term_nm, gt.acc_txt go_acc_txt, sq.chem_nm_sort, sq.gene_symbol_sort, gt.nm_sort, d.nm ontology_nm FROM sq INNER JOIN gene_go_annot gga ON sq.gene_id = gga.gene_id INNER JOIN dag_node gt ON gga.go_term_id = gt.object_id INNER JOIN dag d ON gt.dag_id = d.id WHERE gga.is_not = false AND (d.id = 6) ORDER BY sq.chem_nm_sort, sq.gene_symbol_sort, d.nm, gt.nm_sort) sqi;

Date: 2024-05-02 10:42:49
Duration: 7s924ms
Bind query: yes

SELECT /* BatchChemGODAO */ 'd002746' "Input", sqi.chem_nm "ChemicalName", sqi.chem_acc_txt "ChemicalID", sqi.casRN "CasRN", sqi.gene_symbol "GeneSymbol", sqi.gene_acc_txt "GeneID", sqi.ontology_nm "Ontology", sqi.go_term_nm "GoTermName", sqi.go_acc_txt "GoTermID" FROM ( WITH sq AS ( SELECT DISTINCT c.id chem_id, c.nm chem_nm, c.acc_txt chem_acc_txt, c.secondary_nm casRN, c.nm_sort chem_nm_sort, gcr.gene_id, g.nm gene_symbol, g.acc_txt gene_acc_txt, g.nm_sort gene_symbol_sort FROM term c INNER JOIN gene_chem_reference gcr ON c.id = gcr.chem_id INNER JOIN term g ON gcr.gene_id = g.id WHERE (c.id = 1300542)) SELECT DISTINCT sq.chem_nm, sq.chem_acc_txt, sq.casRN, sq.gene_symbol, sq.gene_acc_txt, gt.nm go_term_nm, gt.acc_txt go_acc_txt, sq.chem_nm_sort, sq.gene_symbol_sort, gt.nm_sort, d.nm ontology_nm FROM sq INNER JOIN gene_go_annot gga ON sq.gene_id = gga.gene_id INNER JOIN dag_node gt ON gga.go_term_id = gt.object_id INNER JOIN dag d ON gt.dag_id = d.id WHERE gga.is_not = false AND (d.id = 6) ORDER BY sq.chem_nm_sort, sq.gene_symbol_sort, d.nm, gt.nm_sort) sqi;

Date: 2024-05-02 10:38:06
Duration: 7s492ms
Database: ctdprd51
User: pubeu
Bind query: yes

SELECT /* BatchChemGODAO */ 'd002746' "Input", sqi.chem_nm "ChemicalName", sqi.chem_acc_txt "ChemicalID", sqi.casRN "CasRN", sqi.gene_symbol "GeneSymbol", sqi.gene_acc_txt "GeneID", sqi.ontology_nm "Ontology", sqi.go_term_nm "GoTermName", sqi.go_acc_txt "GoTermID" FROM ( WITH sq AS ( SELECT DISTINCT c.id chem_id, c.nm chem_nm, c.acc_txt chem_acc_txt, c.secondary_nm casRN, c.nm_sort chem_nm_sort, gcr.gene_id, g.nm gene_symbol, g.acc_txt gene_acc_txt, g.nm_sort gene_symbol_sort FROM term c INNER JOIN gene_chem_reference gcr ON c.id = gcr.chem_id INNER JOIN term g ON gcr.gene_id = g.id WHERE (c.id = 1300542)) SELECT DISTINCT sq.chem_nm, sq.chem_acc_txt, sq.casRN, sq.gene_symbol, sq.gene_acc_txt, gt.nm go_term_nm, gt.acc_txt go_acc_txt, sq.chem_nm_sort, sq.gene_symbol_sort, gt.nm_sort, d.nm ontology_nm FROM sq INNER JOIN gene_go_annot gga ON sq.gene_id = gga.gene_id INNER JOIN dag_node gt ON gga.go_term_id = gt.object_id INNER JOIN dag d ON gt.dag_id = d.id WHERE gga.is_not = false AND (d.id = 6) ORDER BY sq.chem_nm_sort, sq.gene_symbol_sort, d.nm, gt.nm_sort) sqi;

Date: 2024-05-02 11:21:37
Duration: 7s283ms
Bind query: yes

x Hide