Times Reported Time consuming queries #1

x Hide

SELECT /* DiseaseGeneAssnsDAO */ d.nm diseaseNm, d.acc_txt diseaseAcc, d.acc_db_cd diseaseAccDbCd, d.id diseaseId, g.nm geneSymbol, g.acc_txt geneAcc, g.acc_db_cd geneAccDbCd, g.id geneId, gd.network_score networkScore, gd.indirect_chem_qty inferredCount, gd.reference_qty referenceCount, gd.exposure_reference_qty exposureReferenceCount, CASE WHEN gd.curated_reference_qty > 0 THEN ( SELECT STRING_AGG(a.action_type_cd || '^' || a.action_type_nm, '|') FROM gene_disease_axn a WHERE a.gene_id = gd.gene_id AND a.disease_id = gd.disease_id) ELSE NULL END actionTypes FROM gene_disease gd INNER JOIN term g ON gd.gene_id = g.id INNER JOIN term d ON gd.disease_id = d.id WHERE gd.disease_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '2096715') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort LIMIT 50;

Date: 2025-07-18 23:32:52
Duration: 53s186ms
Bind query: yes

x Hide

Times Reported Time consuming queries #2

x Hide

[ User: pubeu - Total duration: 44s106ms - Times executed: 1 ]

x Hide

SELECT /* DiseaseGeneAssnsDAO */ ;

Date: 2025-07-18 23:32:52
Duration: 44s106ms
Database: ctddev51
User: pubeu
Bind query: yes

SELECT /* GeneDiseaseChemsDAO */ ;

Date: 2025-07-18 23:32:58
Duration: 1s482ms
Bind query: yes

SELECT /* GeneDiseaseChemsDAO */ ;

Date: 2025-07-18 23:33:00
Duration: 1s414ms
Bind query: yes

x Hide

Times Reported Time consuming queries #3

x Hide

[ User: pubeu - Total duration: 13s172ms - Times executed: 4 ]

x Hide

WITH recursive sub_node ( object_id, id, path, lvl ) AS ( SELECT n.object_id, n.id, ARRAY[n.nm_sort], 1 FROM dag_node n WHERE n.object_id = '597156' UNION ALL SELECT n.object_id, n.id, CAST(path || n.nm_sort AS varchar(600)[]), sn.lvl + 1 FROM dag_node n INNER JOIN sub_node sn ON (n.parent_id = sn.id)) SELECT /* TreeTermBasicsDAO.getDescendants */ DISTINCT t.nm priNm, t.nm_html priNmHtml, t.secondary_nm secondaryNm, t.acc_db_cd accDbCd, t.acc_txt termAcc, t.is_leaf isLeaf, t.has_chems hasChems, t.has_diseases hasDiseases, t.has_exposures hasExposures, t.has_genes hasGenes, sn.lvl, sn.path, MAX(sn.lvl) OVER () maxLvl, t.has_phenotypes hasPhenotypes FROM sub_node sn INNER JOIN term t ON sn.object_id = t.id WHERE sn.lvl <= 2 ORDER BY sn.path;

Date: 2025-07-18 21:25:49
Duration: 3s552ms
Database: ctddev51
User: pubeu
Bind query: yes

WITH recursive sub_node ( object_id, id, path, lvl ) AS ( SELECT n.object_id, n.id, ARRAY[n.nm_sort], 1 FROM dag_node n WHERE n.object_id = '597156' UNION ALL SELECT n.object_id, n.id, CAST(path || n.nm_sort AS varchar(600)[]), sn.lvl + 1 FROM dag_node n INNER JOIN sub_node sn ON (n.parent_id = sn.id)) SELECT /* TreeTermBasicsDAO.getDescendants */ DISTINCT t.nm priNm, t.nm_html priNmHtml, t.secondary_nm secondaryNm, t.acc_db_cd accDbCd, t.acc_txt termAcc, t.is_leaf isLeaf, t.has_chems hasChems, t.has_diseases hasDiseases, t.has_exposures hasExposures, t.has_genes hasGenes, sn.lvl, sn.path, MAX(sn.lvl) OVER () maxLvl, t.has_phenotypes hasPhenotypes FROM sub_node sn INNER JOIN term t ON sn.object_id = t.id WHERE sn.lvl <= 2 ORDER BY sn.path;

Date: 2025-07-18 17:11:29
Duration: 3s252ms
Database: ctddev51
User: pubeu
Bind query: yes

WITH recursive sub_node ( object_id, id, path, lvl ) AS ( SELECT n.object_id, n.id, ARRAY[n.nm_sort], 1 FROM dag_node n WHERE n.object_id = '597156' UNION ALL SELECT n.object_id, n.id, CAST(path || n.nm_sort AS varchar(600)[]), sn.lvl + 1 FROM dag_node n INNER JOIN sub_node sn ON (n.parent_id = sn.id)) SELECT /* TreeTermBasicsDAO.getDescendants */ DISTINCT t.nm priNm, t.nm_html priNmHtml, t.secondary_nm secondaryNm, t.acc_db_cd accDbCd, t.acc_txt termAcc, t.is_leaf isLeaf, t.has_chems hasChems, t.has_diseases hasDiseases, t.has_exposures hasExposures, t.has_genes hasGenes, sn.lvl, sn.path, MAX(sn.lvl) OVER () maxLvl, t.has_phenotypes hasPhenotypes FROM sub_node sn INNER JOIN term t ON sn.object_id = t.id WHERE sn.lvl <= 2 ORDER BY sn.path;

Date: 2025-07-18 11:29:30
Duration: 3s195ms
Database: ctddev51
User: pubeu
Bind query: yes

x Hide

Times Reported Time consuming queries #4

x Hide

[ User: pubeu - Total duration: 5s783ms - Times executed: 1 ]

x Hide

SELECT /* ChemDiseaseAssnsDAO */ c.nm chemnm, c.nm_html chemnmhtml, c.acc_txt chemacc, c.secondary_nm casRN, c.id chemid, d.nm diseasenm, d.acc_txt diseaseacc, d.acc_db_cd diseaseaccdbcd, d.id diseaseid, cd.network_score networkscore, cd.indirect_gene_qty inferredcount, cd.reference_qty referencecount, cd.exposure_reference_qty exposureReferenceCount, CASE WHEN cd.curated_reference_qty > 0 THEN ( SELECT STRING_AGG(a.action_type_cd || '^' || a.action_type_nm, '|') FROM chem_disease_axn a WHERE a.chem_id = cd.chem_id AND a.disease_id = cd.disease_id) ELSE NULL END actiontypes FROM chem_disease cd INNER JOIN term c ON cd.chem_id = c.id INNER JOIN term d ON cd.disease_id = d.id WHERE cd.disease_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '2096715') ORDER BY actionTypes, cd.network_score DESC NULLS LAST, d.nm_sort, c.nm_sort LIMIT 50;

Date: 2025-07-18 23:29:08
Duration: 5s783ms
Database: ctddev51
User: pubeu
Bind query: yes

x Hide

Times Reported Time consuming queries #5

x Hide

[ User: pubeu - Total duration: 5s378ms - Times executed: 1 ]

x Hide

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

Date: 2025-07-18 23:32:24
Duration: 5s378ms
Database: ctddev51
User: pubeu
Bind query: yes

x Hide

Times Reported Time consuming queries #6

x Hide

[ User: pubeu - Total duration: 1s596ms - Times executed: 1 ]

x Hide

SELECT /* GeneDiseaseChemsDAO */ c.nm chemnm, c.nm_html chemnmhtml, c.acc_txt chemacc, c.id chemid FROM term c WHERE c.id IN ( SELECT gdr.via_chem_id FROM gene_disease_reference gdr WHERE gdr.gene_id = '1462977' AND gdr.disease_id = '2089693') ORDER BY c.nm_sort;

Date: 2025-07-18 23:32:55
Duration: 1s596ms
Database: ctddev51
User: pubeu
Bind query: yes

SELECT /* GeneDiseaseChemsDAO */ c.nm chemnm, c.nm_html chemnmhtml, c.acc_txt chemacc, c.id chemid FROM term c WHERE c.id IN ( SELECT gdr.via_chem_id FROM gene_disease_reference gdr WHERE gdr.gene_id = '1478601' AND gdr.disease_id = '2089693') ORDER BY c.nm_sort;

Date: 2025-07-18 23:33:01
Duration: 1s391ms
Bind query: yes

SELECT /* GeneDiseaseChemsDAO */ c.nm chemnm, c.nm_html chemnmhtml, c.acc_txt chemacc, c.id chemid FROM term c WHERE c.id IN ( SELECT gdr.via_chem_id FROM gene_disease_reference gdr WHERE gdr.gene_id = '1450558' AND gdr.disease_id = '2089693') ORDER BY c.nm_sort;

Date: 2025-07-18 23:33:09
Duration: 1s94ms
Bind query: yes

x Hide

Times Reported Time consuming queries #7

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 = '1297956') 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 = '1297956') 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: 2025-07-18 23:32:39
Duration: 4s325ms
Bind query: yes

x Hide

Times Reported Time consuming queries #8

x Hide

SELECT /* GeneDiseaseChemsDAO */ c.nm chemnm, c.nm_html chemnmhtml, c.acc_txt chemacc, c.id chemid;

Date: 2025-07-18 23:32:57
Duration: 1s602ms
Bind query: yes

x Hide

Times Reported Time consuming queries #9

x Hide

SELECT /* GeneDiseaseChemsDAO */ c.nm chemnm, c.nm_html chemnmhtml, c.acc_txt chemacc, c.id chemid FROM term c WHERE c.id IN ( SELECT gdr.via_chem_id FROM gene_disease_reference gdr;

Date: 2025-07-18 23:32:55
Duration: 1s587ms
Bind query: yes

x Hide

Times Reported Time consuming queries #1

x Hide

[ User: pubeu - Total duration: 44s106ms - Times executed: 1 ]

x Hide

SELECT /* DiseaseGeneAssnsDAO */ ;

Date: 2025-07-18 23:32:52
Duration: 44s106ms
Database: ctddev51
User: pubeu
Bind query: yes

SELECT /* GeneDiseaseChemsDAO */ ;

Date: 2025-07-18 23:32:58
Duration: 1s482ms
Bind query: yes

SELECT /* GeneDiseaseChemsDAO */ ;

Date: 2025-07-18 23:33:00
Duration: 1s414ms
Bind query: yes

x Hide

Times Reported Time consuming queries #2

x Hide

[ User: pubeu - Total duration: 13s172ms - Times executed: 4 ]

x Hide

WITH recursive sub_node ( object_id, id, path, lvl ) AS ( SELECT n.object_id, n.id, ARRAY[n.nm_sort], 1 FROM dag_node n WHERE n.object_id = '597156' UNION ALL SELECT n.object_id, n.id, CAST(path || n.nm_sort AS varchar(600)[]), sn.lvl + 1 FROM dag_node n INNER JOIN sub_node sn ON (n.parent_id = sn.id)) SELECT /* TreeTermBasicsDAO.getDescendants */ DISTINCT t.nm priNm, t.nm_html priNmHtml, t.secondary_nm secondaryNm, t.acc_db_cd accDbCd, t.acc_txt termAcc, t.is_leaf isLeaf, t.has_chems hasChems, t.has_diseases hasDiseases, t.has_exposures hasExposures, t.has_genes hasGenes, sn.lvl, sn.path, MAX(sn.lvl) OVER () maxLvl, t.has_phenotypes hasPhenotypes FROM sub_node sn INNER JOIN term t ON sn.object_id = t.id WHERE sn.lvl <= 2 ORDER BY sn.path;

Date: 2025-07-18 21:25:49
Duration: 3s552ms
Database: ctddev51
User: pubeu
Bind query: yes

WITH recursive sub_node ( object_id, id, path, lvl ) AS ( SELECT n.object_id, n.id, ARRAY[n.nm_sort], 1 FROM dag_node n WHERE n.object_id = '597156' UNION ALL SELECT n.object_id, n.id, CAST(path || n.nm_sort AS varchar(600)[]), sn.lvl + 1 FROM dag_node n INNER JOIN sub_node sn ON (n.parent_id = sn.id)) SELECT /* TreeTermBasicsDAO.getDescendants */ DISTINCT t.nm priNm, t.nm_html priNmHtml, t.secondary_nm secondaryNm, t.acc_db_cd accDbCd, t.acc_txt termAcc, t.is_leaf isLeaf, t.has_chems hasChems, t.has_diseases hasDiseases, t.has_exposures hasExposures, t.has_genes hasGenes, sn.lvl, sn.path, MAX(sn.lvl) OVER () maxLvl, t.has_phenotypes hasPhenotypes FROM sub_node sn INNER JOIN term t ON sn.object_id = t.id WHERE sn.lvl <= 2 ORDER BY sn.path;

Date: 2025-07-18 17:11:29
Duration: 3s252ms
Database: ctddev51
User: pubeu
Bind query: yes

WITH recursive sub_node ( object_id, id, path, lvl ) AS ( SELECT n.object_id, n.id, ARRAY[n.nm_sort], 1 FROM dag_node n WHERE n.object_id = '597156' UNION ALL SELECT n.object_id, n.id, CAST(path || n.nm_sort AS varchar(600)[]), sn.lvl + 1 FROM dag_node n INNER JOIN sub_node sn ON (n.parent_id = sn.id)) SELECT /* TreeTermBasicsDAO.getDescendants */ DISTINCT t.nm priNm, t.nm_html priNmHtml, t.secondary_nm secondaryNm, t.acc_db_cd accDbCd, t.acc_txt termAcc, t.is_leaf isLeaf, t.has_chems hasChems, t.has_diseases hasDiseases, t.has_exposures hasExposures, t.has_genes hasGenes, sn.lvl, sn.path, MAX(sn.lvl) OVER () maxLvl, t.has_phenotypes hasPhenotypes FROM sub_node sn INNER JOIN term t ON sn.object_id = t.id WHERE sn.lvl <= 2 ORDER BY sn.path;

Date: 2025-07-18 11:29:30
Duration: 3s195ms
Database: ctddev51
User: pubeu
Bind query: yes

x Hide

Times Reported Time consuming queries #3

x Hide

[ User: pubeu - Total duration: 1s596ms - Times executed: 1 ]

x Hide

SELECT /* GeneDiseaseChemsDAO */ c.nm chemnm, c.nm_html chemnmhtml, c.acc_txt chemacc, c.id chemid FROM term c WHERE c.id IN ( SELECT gdr.via_chem_id FROM gene_disease_reference gdr WHERE gdr.gene_id = '1462977' AND gdr.disease_id = '2089693') ORDER BY c.nm_sort;

Date: 2025-07-18 23:32:55
Duration: 1s596ms
Database: ctddev51
User: pubeu
Bind query: yes

SELECT /* GeneDiseaseChemsDAO */ c.nm chemnm, c.nm_html chemnmhtml, c.acc_txt chemacc, c.id chemid FROM term c WHERE c.id IN ( SELECT gdr.via_chem_id FROM gene_disease_reference gdr WHERE gdr.gene_id = '1478601' AND gdr.disease_id = '2089693') ORDER BY c.nm_sort;

Date: 2025-07-18 23:33:01
Duration: 1s391ms
Bind query: yes

SELECT /* GeneDiseaseChemsDAO */ c.nm chemnm, c.nm_html chemnmhtml, c.acc_txt chemacc, c.id chemid FROM term c WHERE c.id IN ( SELECT gdr.via_chem_id FROM gene_disease_reference gdr WHERE gdr.gene_id = '1450558' AND gdr.disease_id = '2089693') ORDER BY c.nm_sort;

Date: 2025-07-18 23:33:09
Duration: 1s94ms
Bind query: yes

x Hide

Times Reported Time consuming queries #4

x Hide

SELECT /* DiseaseGeneAssnsDAO */ d.nm diseaseNm, d.acc_txt diseaseAcc, d.acc_db_cd diseaseAccDbCd, d.id diseaseId, g.nm geneSymbol, g.acc_txt geneAcc, g.acc_db_cd geneAccDbCd, g.id geneId, gd.network_score networkScore, gd.indirect_chem_qty inferredCount, gd.reference_qty referenceCount, gd.exposure_reference_qty exposureReferenceCount, CASE WHEN gd.curated_reference_qty > 0 THEN ( SELECT STRING_AGG(a.action_type_cd || '^' || a.action_type_nm, '|') FROM gene_disease_axn a WHERE a.gene_id = gd.gene_id AND a.disease_id = gd.disease_id) ELSE NULL END actionTypes FROM gene_disease gd INNER JOIN term g ON gd.gene_id = g.id INNER JOIN term d ON gd.disease_id = d.id WHERE gd.disease_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '2096715') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort LIMIT 50;

Date: 2025-07-18 23:32:52
Duration: 53s186ms
Bind query: yes

x Hide

Times Reported Time consuming queries #5

x Hide

[ User: pubeu - Total duration: 5s783ms - Times executed: 1 ]

x Hide

SELECT /* ChemDiseaseAssnsDAO */ c.nm chemnm, c.nm_html chemnmhtml, c.acc_txt chemacc, c.secondary_nm casRN, c.id chemid, d.nm diseasenm, d.acc_txt diseaseacc, d.acc_db_cd diseaseaccdbcd, d.id diseaseid, cd.network_score networkscore, cd.indirect_gene_qty inferredcount, cd.reference_qty referencecount, cd.exposure_reference_qty exposureReferenceCount, CASE WHEN cd.curated_reference_qty > 0 THEN ( SELECT STRING_AGG(a.action_type_cd || '^' || a.action_type_nm, '|') FROM chem_disease_axn a WHERE a.chem_id = cd.chem_id AND a.disease_id = cd.disease_id) ELSE NULL END actiontypes FROM chem_disease cd INNER JOIN term c ON cd.chem_id = c.id INNER JOIN term d ON cd.disease_id = d.id WHERE cd.disease_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '2096715') ORDER BY actionTypes, cd.network_score DESC NULLS LAST, d.nm_sort, c.nm_sort LIMIT 50;

Date: 2025-07-18 23:29:08
Duration: 5s783ms
Database: ctddev51
User: pubeu
Bind query: yes

x Hide

Times Reported Time consuming queries #6

x Hide

[ User: pubeu - Total duration: 5s378ms - Times executed: 1 ]

x Hide

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

Date: 2025-07-18 23:32:24
Duration: 5s378ms
Database: ctddev51
User: pubeu
Bind query: yes

x Hide

Times Reported Time consuming queries #7

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 = '1297956') 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 = '1297956') 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: 2025-07-18 23:32:39
Duration: 4s325ms
Bind query: yes

x Hide

Times Reported Time consuming queries #8

x Hide

SELECT /* GeneDiseaseChemsDAO */ c.nm chemnm, c.nm_html chemnmhtml, c.acc_txt chemacc, c.id chemid;

Date: 2025-07-18 23:32:57
Duration: 1s602ms
Bind query: yes

x Hide

Times Reported Time consuming queries #9

x Hide

SELECT /* GeneDiseaseChemsDAO */ c.nm chemnm, c.nm_html chemnmhtml, c.acc_txt chemacc, c.id chemid FROM term c WHERE c.id IN ( SELECT gdr.via_chem_id FROM gene_disease_reference gdr;

Date: 2025-07-18 23:32:55
Duration: 1s587ms
Bind query: yes

x Hide

Times Reported Time consuming queries #1

x Hide

SELECT /* DiseaseGeneAssnsDAO */ d.nm diseaseNm, d.acc_txt diseaseAcc, d.acc_db_cd diseaseAccDbCd, d.id diseaseId, g.nm geneSymbol, g.acc_txt geneAcc, g.acc_db_cd geneAccDbCd, g.id geneId, gd.network_score networkScore, gd.indirect_chem_qty inferredCount, gd.reference_qty referenceCount, gd.exposure_reference_qty exposureReferenceCount, CASE WHEN gd.curated_reference_qty > 0 THEN ( SELECT STRING_AGG(a.action_type_cd || '^' || a.action_type_nm, '|') FROM gene_disease_axn a WHERE a.gene_id = gd.gene_id AND a.disease_id = gd.disease_id) ELSE NULL END actionTypes FROM gene_disease gd INNER JOIN term g ON gd.gene_id = g.id INNER JOIN term d ON gd.disease_id = d.id WHERE gd.disease_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '2096715') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort LIMIT 50;

Date: 2025-07-18 23:32:52
Duration: 53s186ms
Bind query: yes

x Hide

Times Reported Time consuming queries #2

x Hide

[ User: pubeu - Total duration: 44s106ms - Times executed: 1 ]

x Hide

SELECT /* DiseaseGeneAssnsDAO */ ;

Date: 2025-07-18 23:32:52
Duration: 44s106ms
Database: ctddev51
User: pubeu
Bind query: yes

SELECT /* GeneDiseaseChemsDAO */ ;

Date: 2025-07-18 23:32:58
Duration: 1s482ms
Bind query: yes

SELECT /* GeneDiseaseChemsDAO */ ;

Date: 2025-07-18 23:33:00
Duration: 1s414ms
Bind query: yes

x Hide

Times Reported Time consuming queries #3

x Hide

[ User: pubeu - Total duration: 5s783ms - Times executed: 1 ]

x Hide

SELECT /* ChemDiseaseAssnsDAO */ c.nm chemnm, c.nm_html chemnmhtml, c.acc_txt chemacc, c.secondary_nm casRN, c.id chemid, d.nm diseasenm, d.acc_txt diseaseacc, d.acc_db_cd diseaseaccdbcd, d.id diseaseid, cd.network_score networkscore, cd.indirect_gene_qty inferredcount, cd.reference_qty referencecount, cd.exposure_reference_qty exposureReferenceCount, CASE WHEN cd.curated_reference_qty > 0 THEN ( SELECT STRING_AGG(a.action_type_cd || '^' || a.action_type_nm, '|') FROM chem_disease_axn a WHERE a.chem_id = cd.chem_id AND a.disease_id = cd.disease_id) ELSE NULL END actiontypes FROM chem_disease cd INNER JOIN term c ON cd.chem_id = c.id INNER JOIN term d ON cd.disease_id = d.id WHERE cd.disease_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '2096715') ORDER BY actionTypes, cd.network_score DESC NULLS LAST, d.nm_sort, c.nm_sort LIMIT 50;

Date: 2025-07-18 23:29:08
Duration: 5s783ms
Database: ctddev51
User: pubeu
Bind query: yes

x Hide

Times Reported Time consuming queries #4

x Hide

[ User: pubeu - Total duration: 5s378ms - Times executed: 1 ]

x Hide

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

Date: 2025-07-18 23:32:24
Duration: 5s378ms
Database: ctddev51
User: pubeu
Bind query: yes

x Hide

Times Reported Time consuming queries #5

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 = '1297956') 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 = '1297956') 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: 2025-07-18 23:32:39
Duration: 4s325ms
Bind query: yes

x Hide

Times Reported Time consuming queries #6

x Hide

[ User: pubeu - Total duration: 13s172ms - Times executed: 4 ]

x Hide

WITH recursive sub_node ( object_id, id, path, lvl ) AS ( SELECT n.object_id, n.id, ARRAY[n.nm_sort], 1 FROM dag_node n WHERE n.object_id = '597156' UNION ALL SELECT n.object_id, n.id, CAST(path || n.nm_sort AS varchar(600)[]), sn.lvl + 1 FROM dag_node n INNER JOIN sub_node sn ON (n.parent_id = sn.id)) SELECT /* TreeTermBasicsDAO.getDescendants */ DISTINCT t.nm priNm, t.nm_html priNmHtml, t.secondary_nm secondaryNm, t.acc_db_cd accDbCd, t.acc_txt termAcc, t.is_leaf isLeaf, t.has_chems hasChems, t.has_diseases hasDiseases, t.has_exposures hasExposures, t.has_genes hasGenes, sn.lvl, sn.path, MAX(sn.lvl) OVER () maxLvl, t.has_phenotypes hasPhenotypes FROM sub_node sn INNER JOIN term t ON sn.object_id = t.id WHERE sn.lvl <= 2 ORDER BY sn.path;

Date: 2025-07-18 21:25:49
Duration: 3s552ms
Database: ctddev51
User: pubeu
Bind query: yes

WITH recursive sub_node ( object_id, id, path, lvl ) AS ( SELECT n.object_id, n.id, ARRAY[n.nm_sort], 1 FROM dag_node n WHERE n.object_id = '597156' UNION ALL SELECT n.object_id, n.id, CAST(path || n.nm_sort AS varchar(600)[]), sn.lvl + 1 FROM dag_node n INNER JOIN sub_node sn ON (n.parent_id = sn.id)) SELECT /* TreeTermBasicsDAO.getDescendants */ DISTINCT t.nm priNm, t.nm_html priNmHtml, t.secondary_nm secondaryNm, t.acc_db_cd accDbCd, t.acc_txt termAcc, t.is_leaf isLeaf, t.has_chems hasChems, t.has_diseases hasDiseases, t.has_exposures hasExposures, t.has_genes hasGenes, sn.lvl, sn.path, MAX(sn.lvl) OVER () maxLvl, t.has_phenotypes hasPhenotypes FROM sub_node sn INNER JOIN term t ON sn.object_id = t.id WHERE sn.lvl <= 2 ORDER BY sn.path;

Date: 2025-07-18 17:11:29
Duration: 3s252ms
Database: ctddev51
User: pubeu
Bind query: yes

WITH recursive sub_node ( object_id, id, path, lvl ) AS ( SELECT n.object_id, n.id, ARRAY[n.nm_sort], 1 FROM dag_node n WHERE n.object_id = '597156' UNION ALL SELECT n.object_id, n.id, CAST(path || n.nm_sort AS varchar(600)[]), sn.lvl + 1 FROM dag_node n INNER JOIN sub_node sn ON (n.parent_id = sn.id)) SELECT /* TreeTermBasicsDAO.getDescendants */ DISTINCT t.nm priNm, t.nm_html priNmHtml, t.secondary_nm secondaryNm, t.acc_db_cd accDbCd, t.acc_txt termAcc, t.is_leaf isLeaf, t.has_chems hasChems, t.has_diseases hasDiseases, t.has_exposures hasExposures, t.has_genes hasGenes, sn.lvl, sn.path, MAX(sn.lvl) OVER () maxLvl, t.has_phenotypes hasPhenotypes FROM sub_node sn INNER JOIN term t ON sn.object_id = t.id WHERE sn.lvl <= 2 ORDER BY sn.path;

Date: 2025-07-18 11:29:30
Duration: 3s195ms
Database: ctddev51
User: pubeu
Bind query: yes

x Hide

Times Reported Time consuming queries #7

x Hide

SELECT /* GeneDiseaseChemsDAO */ c.nm chemnm, c.nm_html chemnmhtml, c.acc_txt chemacc, c.id chemid;

Date: 2025-07-18 23:32:57
Duration: 1s602ms
Bind query: yes

x Hide

Times Reported Time consuming queries #8

x Hide

SELECT /* GeneDiseaseChemsDAO */ c.nm chemnm, c.nm_html chemnmhtml, c.acc_txt chemacc, c.id chemid FROM term c WHERE c.id IN ( SELECT gdr.via_chem_id FROM gene_disease_reference gdr;

Date: 2025-07-18 23:32:55
Duration: 1s587ms
Bind query: yes

x Hide

Times Reported Time consuming queries #9

x Hide

[ User: pubeu - Total duration: 1s596ms - Times executed: 1 ]

x Hide

SELECT /* GeneDiseaseChemsDAO */ c.nm chemnm, c.nm_html chemnmhtml, c.acc_txt chemacc, c.id chemid FROM term c WHERE c.id IN ( SELECT gdr.via_chem_id FROM gene_disease_reference gdr WHERE gdr.gene_id = '1462977' AND gdr.disease_id = '2089693') ORDER BY c.nm_sort;

Date: 2025-07-18 23:32:55
Duration: 1s596ms
Database: ctddev51
User: pubeu
Bind query: yes

SELECT /* GeneDiseaseChemsDAO */ c.nm chemnm, c.nm_html chemnmhtml, c.acc_txt chemacc, c.id chemid FROM term c WHERE c.id IN ( SELECT gdr.via_chem_id FROM gene_disease_reference gdr WHERE gdr.gene_id = '1478601' AND gdr.disease_id = '2089693') ORDER BY c.nm_sort;

Date: 2025-07-18 23:33:01
Duration: 1s391ms
Bind query: yes

SELECT /* GeneDiseaseChemsDAO */ c.nm chemnm, c.nm_html chemnmhtml, c.acc_txt chemacc, c.id chemid FROM term c WHERE c.id IN ( SELECT gdr.via_chem_id FROM gene_disease_reference gdr WHERE gdr.gene_id = '1450558' AND gdr.disease_id = '2089693') ORDER BY c.nm_sort;

Date: 2025-07-18 23:33:09
Duration: 1s94ms
Bind query: yes