Times Reported Time consuming queries #1

x Hide

[ User: pubeu - Total duration: 5m32s - Times executed: 10 ]

x Hide

WITH anatomy AS ( SELECT chem_conc_id, array_agg(anatomy_id ORDER BY anatomy_id) AS anatomy_ids, string_agg(DISTINCT anatomy_nm_html || '^' || anatomy_acc_txt || '^' || position_seq || '^' || anatomy_acc_db_id || '^' || anatomy_nm, '|') AS anatomyTerms FROM chem_conc_anatomy GROUP BY chem_conc_id ) SELECT /* ChemConcentrationDao */ cc.chem_id chem_id, t.nm chem, t.nm_html chemNmHtml, t.acc_txt chemAcc, t.secondary_nm casRN, cc.chem_conc || ' ' || cc.chem_conc_uom_nm as concentration, cc.ixn_qualifier_nm vivoVitro, cc.chem_conc_exp_route_nm expRoute, cc.taxon_nm_html organism, a1.anatomyTerms anatomyTerms, a1.anatomyTerms anatomyTermsSort, cc.action_type_cd directEvidence, cc.action_type_cd directEvidenceSort, d.nm diseasenm, d.acc_txt diseaseacc, d.acc_db_cd diseaseaccdbcd, d.id diseaseid, tx.nm taxonnm, tx.secondary_nm taxoncomnm, tx.id taxonid, tx.acc_txt taxonacc, string_agg(distinct cc2.acc_txt, '|') AS refAcc, COUNT(DISTINCT cc2.reference_id) as referenceCount, COUNT(*) OVER () fullRowCount FROM chem_conc cc INNER JOIN term t ON cc.chem_id = t.id INNER JOIN term tx ON cc.taxon_id = tx.id LEFT JOIN term d ON cc.disease_id = d.id INNER JOIN ( SELECT cc2.*, refer.acc_txt FROM chem_conc cc2 LEFT OUTER JOIN REFERENCE refer ON cc2.reference_id = refer.id) cc2 ON cc2.chem_id IS NOT DISTINCT FROM cc.chem_id AND cc2.chem_conc IS NOT DISTINCT FROM cc.chem_conc AND cc2.chem_conc_uom_nm IS NOT DISTINCT FROM cc.chem_conc_uom_nm AND cc2.taxon_id IS NOT DISTINCT FROM cc.taxon_id AND cc2.disease_id IS NOT DISTINCT FROM cc.disease_id AND cc2.chem_conc_exp_route_nm IS NOT DISTINCT FROM cc.chem_conc_exp_route_nm AND cc2.ixn_qualifier_nm IS NOT DISTINCT FROM cc.ixn_qualifier_nm AND cc2.action_type_cd IS NOT DISTINCT FROM cc.action_type_cd LEFT JOIN anatomy a1 ON a1.chem_conc_id = cc.id LEFT JOIN anatomy a2 ON a2.chem_conc_id = cc2.id AND a1.anatomy_ids = a2.anatomy_ids LEFT JOIN ( SELECT cca.chem_conc_id, string_agg(distinct cca.anatomy_nm_html || '^' || cca.anatomy_acc_txt || '^' || cca.position_seq || '^' || cca.anatomy_acc_db_id || '^' || cca.anatomy_nm, '|') AS anatomyTerms FROM chem_conc_anatomy cca GROUP BY cca.chem_conc_id) cca ON cc.id = cca.chem_conc_id WHERE cc.reference_id in ( select distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id = '203364') GROUP BY cc.chem_id, chem, chemNmHtml, chemAcc, casRN, concentration, vivoVitro, expRoute, organism, a1.anatomyTerms, anatomyTermsSort, directEvidence, directEvidenceSort, diseasenm, diseaseacc, diseaseaccdbcd, diseaseid, taxonnm, taxoncomnm, taxonid, taxonacc ORDER BY organism LIMIT 50;

Date: 2026-08-11 12:43:17
Duration: 34s120ms
Bind query: yes

WITH anatomy AS ( SELECT chem_conc_id, array_agg(anatomy_id ORDER BY anatomy_id) AS anatomy_ids, string_agg(DISTINCT anatomy_nm_html || '^' || anatomy_acc_txt || '^' || position_seq || '^' || anatomy_acc_db_id || '^' || anatomy_nm, '|') AS anatomyTerms FROM chem_conc_anatomy GROUP BY chem_conc_id ) SELECT /* ChemConcentrationDao */ cc.chem_id chem_id, t.nm chem, t.nm_html chemNmHtml, t.acc_txt chemAcc, t.secondary_nm casRN, cc.chem_conc || ' ' || cc.chem_conc_uom_nm as concentration, cc.ixn_qualifier_nm vivoVitro, cc.chem_conc_exp_route_nm expRoute, cc.taxon_nm_html organism, a1.anatomyTerms anatomyTerms, a1.anatomyTerms anatomyTermsSort, cc.action_type_cd directEvidence, cc.action_type_cd directEvidenceSort, d.nm diseasenm, d.acc_txt diseaseacc, d.acc_db_cd diseaseaccdbcd, d.id diseaseid, tx.nm taxonnm, tx.secondary_nm taxoncomnm, tx.id taxonid, tx.acc_txt taxonacc, string_agg(distinct cc2.acc_txt, '|') AS refAcc, COUNT(DISTINCT cc2.reference_id) as referenceCount, COUNT(*) OVER () fullRowCount FROM chem_conc cc INNER JOIN term t ON cc.chem_id = t.id INNER JOIN term tx ON cc.taxon_id = tx.id LEFT JOIN term d ON cc.disease_id = d.id INNER JOIN ( SELECT cc2.*, refer.acc_txt FROM chem_conc cc2 LEFT OUTER JOIN REFERENCE refer ON cc2.reference_id = refer.id) cc2 ON cc2.chem_id IS NOT DISTINCT FROM cc.chem_id AND cc2.chem_conc IS NOT DISTINCT FROM cc.chem_conc AND cc2.chem_conc_uom_nm IS NOT DISTINCT FROM cc.chem_conc_uom_nm AND cc2.taxon_id IS NOT DISTINCT FROM cc.taxon_id AND cc2.disease_id IS NOT DISTINCT FROM cc.disease_id AND cc2.chem_conc_exp_route_nm IS NOT DISTINCT FROM cc.chem_conc_exp_route_nm AND cc2.ixn_qualifier_nm IS NOT DISTINCT FROM cc.ixn_qualifier_nm AND cc2.action_type_cd IS NOT DISTINCT FROM cc.action_type_cd LEFT JOIN anatomy a1 ON a1.chem_conc_id = cc.id LEFT JOIN anatomy a2 ON a2.chem_conc_id = cc2.id AND a1.anatomy_ids = a2.anatomy_ids LEFT JOIN ( SELECT cca.chem_conc_id, string_agg(distinct cca.anatomy_nm_html || '^' || cca.anatomy_acc_txt || '^' || cca.position_seq || '^' || cca.anatomy_acc_db_id || '^' || cca.anatomy_nm, '|') AS anatomyTerms FROM chem_conc_anatomy cca GROUP BY cca.chem_conc_id) cca ON cc.id = cca.chem_conc_id WHERE cc.reference_id in ( select distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id = '198615') GROUP BY cc.chem_id, chem, chemNmHtml, chemAcc, casRN, concentration, vivoVitro, expRoute, organism, a1.anatomyTerms, anatomyTermsSort, directEvidence, directEvidenceSort, diseasenm, diseaseacc, diseaseaccdbcd, diseaseid, taxonnm, taxoncomnm, taxonid, taxonacc ORDER BY organism LIMIT 50;

Date: 2026-08-11 11:59:37
Duration: 34s71ms
Database: ctddev51
User: pubeu
Bind query: yes

WITH anatomy AS ( SELECT chem_conc_id, array_agg(anatomy_id ORDER BY anatomy_id) AS anatomy_ids, string_agg(DISTINCT anatomy_nm_html || '^' || anatomy_acc_txt || '^' || position_seq || '^' || anatomy_acc_db_id || '^' || anatomy_nm, '|') AS anatomyTerms FROM chem_conc_anatomy GROUP BY chem_conc_id ) SELECT /* ChemConcentrationDao */ cc.chem_id chem_id, t.nm chem, t.nm_html chemNmHtml, t.acc_txt chemAcc, t.secondary_nm casRN, cc.chem_conc || ' ' || cc.chem_conc_uom_nm as concentration, cc.ixn_qualifier_nm vivoVitro, cc.chem_conc_exp_route_nm expRoute, cc.taxon_nm_html organism, a1.anatomyTerms anatomyTerms, a1.anatomyTerms anatomyTermsSort, cc.action_type_cd directEvidence, cc.action_type_cd directEvidenceSort, d.nm diseasenm, d.acc_txt diseaseacc, d.acc_db_cd diseaseaccdbcd, d.id diseaseid, tx.nm taxonnm, tx.secondary_nm taxoncomnm, tx.id taxonid, tx.acc_txt taxonacc, string_agg(distinct cc2.acc_txt, '|') AS refAcc, COUNT(DISTINCT cc2.reference_id) as referenceCount, COUNT(*) OVER () fullRowCount FROM chem_conc cc INNER JOIN term t ON cc.chem_id = t.id INNER JOIN term tx ON cc.taxon_id = tx.id LEFT JOIN term d ON cc.disease_id = d.id INNER JOIN ( SELECT cc2.*, refer.acc_txt FROM chem_conc cc2 LEFT OUTER JOIN REFERENCE refer ON cc2.reference_id = refer.id) cc2 ON cc2.chem_id IS NOT DISTINCT FROM cc.chem_id AND cc2.chem_conc IS NOT DISTINCT FROM cc.chem_conc AND cc2.chem_conc_uom_nm IS NOT DISTINCT FROM cc.chem_conc_uom_nm AND cc2.taxon_id IS NOT DISTINCT FROM cc.taxon_id AND cc2.disease_id IS NOT DISTINCT FROM cc.disease_id AND cc2.chem_conc_exp_route_nm IS NOT DISTINCT FROM cc.chem_conc_exp_route_nm AND cc2.ixn_qualifier_nm IS NOT DISTINCT FROM cc.ixn_qualifier_nm AND cc2.action_type_cd IS NOT DISTINCT FROM cc.action_type_cd LEFT JOIN anatomy a1 ON a1.chem_conc_id = cc.id LEFT JOIN anatomy a2 ON a2.chem_conc_id = cc2.id AND a1.anatomy_ids = a2.anatomy_ids LEFT JOIN ( SELECT cca.chem_conc_id, string_agg(distinct cca.anatomy_nm_html || '^' || cca.anatomy_acc_txt || '^' || cca.position_seq || '^' || cca.anatomy_acc_db_id || '^' || cca.anatomy_nm, '|') AS anatomyTerms FROM chem_conc_anatomy cca GROUP BY cca.chem_conc_id) cca ON cc.id = cca.chem_conc_id WHERE cc.reference_id in ( select distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id = '198615') GROUP BY cc.chem_id, chem, chemNmHtml, chemAcc, casRN, concentration, vivoVitro, expRoute, organism, a1.anatomyTerms, anatomyTermsSort, directEvidence, directEvidenceSort, diseasenm, diseaseacc, diseaseaccdbcd, diseaseid, taxonnm, taxoncomnm, taxonid, taxonacc ORDER BY organism LIMIT 50;

Date: 2026-08-11 12:17:04
Duration: 34s49ms
Database: ctddev51
User: pubeu
Bind query: yes

x Hide

Times Reported Time consuming queries #2

x Hide

WITH anatomy AS ( SELECT chem_conc_id, array_agg(anatomy_id ORDER BY anatomy_id) AS anatomy_ids, string_agg(DISTINCT anatomy_nm_html || '^' || anatomy_acc_txt || '^' || position_seq || '^' || anatomy_acc_db_id || '^' || anatomy_nm, '|') AS anatomyTerms FROM chem_conc_anatomy GROUP BY chem_conc_id ) SELECT /* ChemConcentrationDao */ cc.chem_id chem_id, t.nm chem, t.nm_html chemNmHtml, t.acc_txt chemAcc, t.secondary_nm casRN, cc.chem_conc || ' ' || cc.chem_conc_uom_nm as concentration, cc.ixn_qualifier_nm vivoVitro, cc.chem_conc_exp_route_nm expRoute, cc.taxon_nm_html organism, a1.anatomyTerms anatomyTerms, a1.anatomyTerms anatomyTermsSort, cc.action_type_cd directEvidence, cc.action_type_cd directEvidenceSort, d.nm diseasenm, d.acc_txt diseaseacc, d.acc_db_cd diseaseaccdbcd, d.id diseaseid, tx.nm taxonnm, tx.secondary_nm taxoncomnm, tx.id taxonid, tx.acc_txt taxonacc, string_agg(distinct cc2.acc_txt, '|') AS refAcc, COUNT(DISTINCT cc2.reference_id) as referenceCount, COUNT(*) OVER () fullRowCount FROM chem_conc cc INNER JOIN term t ON cc.chem_id = t.id INNER JOIN term tx ON cc.taxon_id = tx.id LEFT JOIN term d ON cc.disease_id = d.id INNER JOIN ( SELECT cc2.*, refer.acc_txt FROM chem_conc cc2 LEFT OUTER JOIN REFERENCE refer ON cc2.reference_id = refer.id) cc2 ON cc2.chem_id IS NOT DISTINCT FROM cc.chem_id AND cc2.chem_conc IS NOT DISTINCT FROM cc.chem_conc AND cc2.chem_conc_uom_nm IS NOT DISTINCT FROM cc.chem_conc_uom_nm AND cc2.taxon_id IS NOT DISTINCT FROM cc.taxon_id AND cc2.disease_id IS NOT DISTINCT FROM cc.disease_id AND cc2.chem_conc_exp_route_nm IS NOT DISTINCT FROM cc.chem_conc_exp_route_nm AND cc2.ixn_qualifier_nm IS NOT DISTINCT FROM cc.ixn_qualifier_nm AND cc2.action_type_cd IS NOT DISTINCT FROM cc.action_type_cd LEFT JOIN anatomy a1 ON a1.chem_conc_id = cc.id LEFT JOIN anatomy a2 ON a2.chem_conc_id = cc2.id AND a1.anatomy_ids = a2.anatomy_ids INNER JOIN ( SELECT cca.chem_conc_id, string_agg(distinct cca.anatomy_nm_html || '^' || cca.anatomy_acc_txt || '^' || cca.position_seq || '^' || cca.anatomy_acc_db_id || '^' || cca.anatomy_nm, '|') AS anatomyTerms FROM chem_conc_anatomy cca WHERE cca.chem_conc_id IN ( SELECT chem_conc_id FROM chem_conc_anatomy WHERE anatomy_id in ( select distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id = '2208555')) GROUP BY cca.chem_conc_id) cca ON cc.id = cca.chem_conc_id GROUP BY cc.chem_id, chem, chemNmHtml, chemAcc, casRN, concentration, vivoVitro, expRoute, organism, a1.anatomyTerms, anatomyTermsSort, directEvidence, directEvidenceSort, diseasenm, diseaseacc, diseaseaccdbcd, diseaseid, taxonnm, taxoncomnm, taxonid, taxonacc ORDER BY organism LIMIT 50;

Date: 2026-08-11 12:56:11
Duration: 34s19ms
Bind query: yes

WITH anatomy AS ( SELECT chem_conc_id, array_agg(anatomy_id ORDER BY anatomy_id) AS anatomy_ids, string_agg(DISTINCT anatomy_nm_html || '^' || anatomy_acc_txt || '^' || position_seq || '^' || anatomy_acc_db_id || '^' || anatomy_nm, '|') AS anatomyTerms FROM chem_conc_anatomy GROUP BY chem_conc_id ) SELECT /* ChemConcentrationDao */ cc.chem_id chem_id, t.nm chem, t.nm_html chemNmHtml, t.acc_txt chemAcc, t.secondary_nm casRN, cc.chem_conc || ' ' || cc.chem_conc_uom_nm as concentration, cc.ixn_qualifier_nm vivoVitro, cc.chem_conc_exp_route_nm expRoute, cc.taxon_nm_html organism, a1.anatomyTerms anatomyTerms, a1.anatomyTerms anatomyTermsSort, cc.action_type_cd directEvidence, cc.action_type_cd directEvidenceSort, d.nm diseasenm, d.acc_txt diseaseacc, d.acc_db_cd diseaseaccdbcd, d.id diseaseid, tx.nm taxonnm, tx.secondary_nm taxoncomnm, tx.id taxonid, tx.acc_txt taxonacc, string_agg(distinct cc2.acc_txt, '|') AS refAcc, COUNT(DISTINCT cc2.reference_id) as referenceCount, COUNT(*) OVER () fullRowCount FROM chem_conc cc INNER JOIN term t ON cc.chem_id = t.id INNER JOIN term tx ON cc.taxon_id = tx.id LEFT JOIN term d ON cc.disease_id = d.id INNER JOIN ( SELECT cc2.*, refer.acc_txt FROM chem_conc cc2 LEFT OUTER JOIN REFERENCE refer ON cc2.reference_id = refer.id) cc2 ON cc2.chem_id IS NOT DISTINCT FROM cc.chem_id AND cc2.chem_conc IS NOT DISTINCT FROM cc.chem_conc AND cc2.chem_conc_uom_nm IS NOT DISTINCT FROM cc.chem_conc_uom_nm AND cc2.taxon_id IS NOT DISTINCT FROM cc.taxon_id AND cc2.disease_id IS NOT DISTINCT FROM cc.disease_id AND cc2.chem_conc_exp_route_nm IS NOT DISTINCT FROM cc.chem_conc_exp_route_nm AND cc2.ixn_qualifier_nm IS NOT DISTINCT FROM cc.ixn_qualifier_nm AND cc2.action_type_cd IS NOT DISTINCT FROM cc.action_type_cd LEFT JOIN anatomy a1 ON a1.chem_conc_id = cc.id LEFT JOIN anatomy a2 ON a2.chem_conc_id = cc2.id AND a1.anatomy_ids = a2.anatomy_ids INNER JOIN ( SELECT cca.chem_conc_id, string_agg(distinct cca.anatomy_nm_html || '^' || cca.anatomy_acc_txt || '^' || cca.position_seq || '^' || cca.anatomy_acc_db_id || '^' || cca.anatomy_nm, '|') AS anatomyTerms FROM chem_conc_anatomy cca WHERE cca.chem_conc_id IN ( SELECT chem_conc_id FROM chem_conc_anatomy WHERE anatomy_id in ( select distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id = '2206931')) GROUP BY cca.chem_conc_id) cca ON cc.id = cca.chem_conc_id GROUP BY cc.chem_id, chem, chemNmHtml, chemAcc, casRN, concentration, vivoVitro, expRoute, organism, a1.anatomyTerms, anatomyTermsSort, directEvidence, directEvidenceSort, diseasenm, diseaseacc, diseaseaccdbcd, diseaseid, taxonnm, taxoncomnm, taxonid, taxonacc ORDER BY organism LIMIT 50;

Date: 2026-08-11 13:09:37
Duration: 33s502ms
Bind query: yes

WITH anatomy AS ( SELECT chem_conc_id, array_agg(anatomy_id ORDER BY anatomy_id) AS anatomy_ids, string_agg(DISTINCT anatomy_nm_html || '^' || anatomy_acc_txt || '^' || position_seq || '^' || anatomy_acc_db_id || '^' || anatomy_nm, '|') AS anatomyTerms FROM chem_conc_anatomy GROUP BY chem_conc_id ) SELECT /* ChemConcentrationDao */ cc.chem_id chem_id, t.nm chem, t.nm_html chemNmHtml, t.acc_txt chemAcc, t.secondary_nm casRN, cc.chem_conc || ' ' || cc.chem_conc_uom_nm as concentration, cc.ixn_qualifier_nm vivoVitro, cc.chem_conc_exp_route_nm expRoute, cc.taxon_nm_html organism, a1.anatomyTerms anatomyTerms, a1.anatomyTerms anatomyTermsSort, cc.action_type_cd directEvidence, cc.action_type_cd directEvidenceSort, d.nm diseasenm, d.acc_txt diseaseacc, d.acc_db_cd diseaseaccdbcd, d.id diseaseid, tx.nm taxonnm, tx.secondary_nm taxoncomnm, tx.id taxonid, tx.acc_txt taxonacc, string_agg(distinct cc2.acc_txt, '|') AS refAcc, COUNT(DISTINCT cc2.reference_id) as referenceCount, COUNT(*) OVER () fullRowCount FROM chem_conc cc INNER JOIN term t ON cc.chem_id = t.id INNER JOIN term tx ON cc.taxon_id = tx.id LEFT JOIN term d ON cc.disease_id = d.id INNER JOIN ( SELECT cc2.*, refer.acc_txt FROM chem_conc cc2 LEFT OUTER JOIN REFERENCE refer ON cc2.reference_id = refer.id) cc2 ON cc2.chem_id IS NOT DISTINCT FROM cc.chem_id AND cc2.chem_conc IS NOT DISTINCT FROM cc.chem_conc AND cc2.chem_conc_uom_nm IS NOT DISTINCT FROM cc.chem_conc_uom_nm AND cc2.taxon_id IS NOT DISTINCT FROM cc.taxon_id AND cc2.disease_id IS NOT DISTINCT FROM cc.disease_id AND cc2.chem_conc_exp_route_nm IS NOT DISTINCT FROM cc.chem_conc_exp_route_nm AND cc2.ixn_qualifier_nm IS NOT DISTINCT FROM cc.ixn_qualifier_nm AND cc2.action_type_cd IS NOT DISTINCT FROM cc.action_type_cd LEFT JOIN anatomy a1 ON a1.chem_conc_id = cc.id LEFT JOIN anatomy a2 ON a2.chem_conc_id = cc2.id AND a1.anatomy_ids = a2.anatomy_ids INNER JOIN ( SELECT cca.chem_conc_id, string_agg(distinct cca.anatomy_nm_html || '^' || cca.anatomy_acc_txt || '^' || cca.position_seq || '^' || cca.anatomy_acc_db_id || '^' || cca.anatomy_nm, '|') AS anatomyTerms FROM chem_conc_anatomy cca WHERE cca.chem_conc_id IN ( SELECT chem_conc_id FROM chem_conc_anatomy WHERE anatomy_id in ( select distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id = '2207989')) GROUP BY cca.chem_conc_id) cca ON cc.id = cca.chem_conc_id GROUP BY cc.chem_id, chem, chemNmHtml, chemAcc, casRN, concentration, vivoVitro, expRoute, organism, a1.anatomyTerms, anatomyTermsSort, directEvidence, directEvidenceSort, diseasenm, diseaseacc, diseaseaccdbcd, diseaseid, taxonnm, taxoncomnm, taxonid, taxonacc ORDER BY organism LIMIT 50;

Date: 2026-08-11 12:19:41
Duration: 33s453ms
Bind query: yes