Times Reported Time consuming queries #1

x Hide

[ User: editeu - Total duration: 1m19s - Times executed: 21 ]

x Hide

select t.ID, t.OBJECT_TYPE_ID, t.ACC_TXT, t.ACC_DB_CD, t.NM, t.NM_SORT, t.SECONDARY_NM, t.DESCRIPTION, t.NOTE, l.NM from pub2.TERM t, pub2.TERM_LABEL l where t.OBJECT_TYPE_ID = 4 and t.id = l.TERM_ID;

Date: 2025-07-12 16:28:19
Duration: 8s257ms
Database: ctddev51
User: editeu
Bind query: yes

select t.ID, t.OBJECT_TYPE_ID, t.ACC_TXT, t.ACC_DB_CD, t.NM, t.NM_SORT, t.SECONDARY_NM, t.DESCRIPTION, t.NOTE, l.NM from pub2.TERM t, pub2.TERM_LABEL l where t.OBJECT_TYPE_ID = 4 and t.id = l.TERM_ID;

Date: 2025-07-12 16:18:03
Duration: 8s84ms
Database: ctddev51
User: editeu
Bind query: yes

select t.ID, t.OBJECT_TYPE_ID, t.ACC_TXT, t.ACC_DB_CD, t.NM, t.NM_SORT, t.SECONDARY_NM, t.DESCRIPTION, t.NOTE, l.NM from pub2.TERM t, pub2.TERM_LABEL l where t.OBJECT_TYPE_ID = 4 and t.id = l.TERM_ID;

Date: 2025-07-12 16:18:03
Duration: 8s1ms
Database: ctddev51
User: editeu
Bind query: yes

x Hide

Times Reported Time consuming queries #2

x Hide

SELECT /* CompsPrepDAO.cg */ DISTINCT gcr.chem_id, gcr.gene_id, gcra.action_degree_type_nm, gcra.action_type_cd FROM gene_chem_reference gcr INNER JOIN gene_chem_reference_axn gcra ON gcr.id = gcra.gene_chem_reference_id WHERE gcra.action_type_nm IN ('activity', 'binding', 'expression');

Date: 2025-07-12 16:17:54
Duration: 4s78ms
Bind query: yes

SELECT /* CompsPrepDAO.cg */ DISTINCT gcr.chem_id, gcr.gene_id, gcra.action_degree_type_nm, gcra.action_type_cd FROM gene_chem_reference gcr INNER JOIN gene_chem_reference_axn gcra ON gcr.id = gcra.gene_chem_reference_id WHERE gcra.action_type_nm IN ('activity', 'binding', 'expression');

Date: 2025-07-12 16:28:32
Duration: 4s1ms
Bind query: yes

SELECT /* CompsPrepDAO.cg */ DISTINCT gcr.chem_id, gcr.gene_id, gcra.action_degree_type_nm, gcra.action_type_cd FROM gene_chem_reference gcr INNER JOIN gene_chem_reference_axn gcra ON gcr.id = gcra.gene_chem_reference_id WHERE gcra.action_type_nm IN ('activity', 'binding', 'expression');

Date: 2025-07-12 16:18:01
Duration: 3s896ms
Bind query: yes

x Hide

Times Reported Time consuming queries #3

x Hide

select p.ancestor_object_id, p.descendant_object_id from DAG_PATH p where p.descendant_object_id in ( select go_term_id from GENE_GO_ANNOT gga where gga.taxon_id = ( select id from TERM where acc_txt = '9606' and object_type_id = ( select id from OBJECT_TYPE where cd = 'taxon')) AND gga.is_not = 'f') and p.ancestor_object_id NOT in ( SELECT c.id FROM TERM c WHERE c.acc_txt in ('ALL') AND c.object_type_id = ( select id from OBJECT_TYPE where cd = 'go'));

Date: 2025-07-12 16:17:35
Duration: 6s547ms
Bind query: yes

select p.ancestor_object_id, p.descendant_object_id from DAG_PATH p where p.descendant_object_id in ( select go_term_id from GENE_GO_ANNOT gga where gga.taxon_id = ( select id from TERM where acc_txt = '9606' and object_type_id = ( select id from OBJECT_TYPE where cd = 'taxon')) AND gga.is_not = 'f') and p.ancestor_object_id NOT in ( SELECT c.id FROM TERM c WHERE c.acc_txt in ('ALL') AND c.object_type_id = ( select id from OBJECT_TYPE where cd = 'go'));

Date: 2025-07-12 16:28:11
Duration: 6s228ms
Bind query: yes

x Hide

Times Reported Time consuming queries #4

x Hide

[ User: pubeu - Total duration: 7s372ms - Times executed: 2 ]

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-12 16:18:14
Duration: 3s695ms
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-12 16:28:30
Duration: 3s676ms
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 = '1449802' 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-12 16:18:15
Duration: 1s160ms
Bind query: yes

x Hide

Times Reported Time consuming queries #5

x Hide

[ User: pubeu - Total duration: 8s562ms - Times executed: 2 ]

x Hide

select count(distinct gene_id) from GENE_TAXON where taxon_id = 559111;

Date: 2025-07-12 16:17:23
Duration: 5s751ms
Database: ctddev51
User: pubeu
Bind query: yes

select count(distinct gene_id) from GENE_TAXON where taxon_id = 559111;

Date: 2025-07-12 16:28:00
Duration: 2s810ms
Database: ctddev51
User: pubeu
Bind query: yes

x Hide

Times Reported Time consuming queries #6

x Hide

select p.ancestor_object_id, p.descendant_object_id from DAG_PATH p where p.descendant_object_id in ( select disease_id from GENE_DISEASE_REFERENCE gdr where gdr.source_cd in ('C', 'O') and gene_id in ( select gene_id from GENE_TAXON where taxon_id = 559111)) and p.ancestor_object_id <> 2101568;

Date: 2025-07-12 16:17:28
Duration: 4s436ms
Bind query: yes

select p.ancestor_object_id, p.descendant_object_id from DAG_PATH p where p.descendant_object_id in ( select disease_id from GENE_DISEASE_REFERENCE gdr where gdr.source_cd in ('C', 'O') and gene_id in ( select gene_id from GENE_TAXON where taxon_id = 559111)) and p.ancestor_object_id <> 2101568;

Date: 2025-07-12 16:28:04
Duration: 3s437ms
Bind query: yes

x Hide

Times Reported Time consuming queries #7

x Hide

select p.ancestor_object_id, p.descendant_object_id from DAG_PATH p where p.descendant_object_id in ( select chem_id from GENE_CHEM_REFERENCE gcr where gcr.gene_id in ( select gene_id from GENE_TAXON where taxon_id = ( select id from TERM where acc_txt = '9606' and object_type_id = ( select id from OBJECT_TYPE where cd = 'taxon')))) AND p.ancestor_object_id != ( SELECT c.id FROM TERM c WHERE c.acc_txt = 'D' AND c.object_type_id = ( select id from OBJECT_TYPE where cd = 'chem'));

Date: 2025-07-12 16:28:25
Duration: 1s347ms
Bind query: yes

select p.ancestor_object_id, p.descendant_object_id from DAG_PATH p where p.descendant_object_id in ( select chem_id from GENE_CHEM_REFERENCE gcr where gcr.gene_id in ( select gene_id from GENE_TAXON where taxon_id = ( select id from TERM where acc_txt = '9606' and object_type_id = ( select id from OBJECT_TYPE where cd = 'taxon')))) AND p.ancestor_object_id != ( SELECT c.id FROM TERM c WHERE c.acc_txt = 'D' AND c.object_type_id = ( select id from OBJECT_TYPE where cd = 'chem'));

Date: 2025-07-12 16:28:14
Duration: 1s306ms
Bind query: yes

select p.ancestor_object_id, p.descendant_object_id from DAG_PATH p where p.descendant_object_id in ( select chem_id from GENE_CHEM_REFERENCE gcr where gcr.gene_id in ( select gene_id from GENE_TAXON where taxon_id = ( select id from TERM where acc_txt = '9606' and object_type_id = ( select id from OBJECT_TYPE where cd = 'taxon')))) AND p.ancestor_object_id != ( SELECT c.id FROM TERM c WHERE c.acc_txt = 'D' AND c.object_type_id = ( select id from OBJECT_TYPE where cd = 'chem'));

Date: 2025-07-12 16:17:39
Duration: 1s279ms
Bind query: yes

x Hide

Times Reported Time consuming queries #8

x Hide

select gene_id, chem_id from GENE_CHEM_REFERENCE r where gene_id in ( select gene_id from GENE_TAXON where taxon_id = ( select id from TERM where acc_txt = '9606' and object_type_id = ( select id from OBJECT_TYPE where cd = 'taxon'))) and gene_id in ( select gene_id from GENE_GO_ANNOT where taxon_id = ( select id from TERM where acc_txt = '9606' and object_type_id = ( select id from OBJECT_TYPE where cd = 'taxon')) AND is_not = 'f' and go_term_id not in ( SELECT c.id FROM TERM c WHERE c.acc_txt in ('ALL') AND c.object_type_id = ( select id from OBJECT_TYPE where cd = 'go'))) and r.id NOT in ( SELECT gene_chem_reference_id FROM GENE_CHEM_REFERENCE_AXN WHERE action_degree_type_nm = 'does not affect');

Date: 2025-07-12 16:28:22
Duration: 2s195ms
Bind query: yes

select gene_id, chem_id from GENE_CHEM_REFERENCE r where gene_id in ( select gene_id from GENE_TAXON where taxon_id = ( select id from TERM where acc_txt = '9606' and object_type_id = ( select id from OBJECT_TYPE where cd = 'taxon'))) and gene_id in ( select gene_id from GENE_GO_ANNOT where taxon_id = ( select id from TERM where acc_txt = '9606' and object_type_id = ( select id from OBJECT_TYPE where cd = 'taxon')) AND is_not = 'f' and go_term_id not in ( SELECT c.id FROM TERM c WHERE c.acc_txt in ('ALL') AND c.object_type_id = ( select id from OBJECT_TYPE where cd = 'go'))) and r.id NOT in ( SELECT gene_chem_reference_id FROM GENE_CHEM_REFERENCE_AXN WHERE action_degree_type_nm = 'does not affect');

Date: 2025-07-12 16:17:44
Duration: 2s45ms
Bind query: yes

x Hide

Times Reported Time consuming queries #9

x Hide

select gene_id, chem_id from GENE_CHEM_REFERENCE r where gene_id in ( select gene_id from GENE_TAXON where taxon_id = ( select id from TERM where acc_txt = '9606' and object_type_id = ( select id from OBJECT_TYPE where cd = 'taxon'))) and gene_id in ( select term_id from TERM_PATHWAY p where p.object_type_id = ( select id from OBJECT_TYPE where cd = 'gene') and term_id in ( select gene_id from GENE_TAXON where taxon_id = ( select id from TERM where acc_txt = '9606' and object_type_id = ( select id from OBJECT_TYPE where cd = 'taxon')))) and r.id NOT in ( SELECT gene_chem_reference_id FROM GENE_CHEM_REFERENCE_AXN WHERE action_degree_type_nm = 'does not affect');

Date: 2025-07-12 16:28:27
Duration: 2s20ms
Bind query: yes

select gene_id, chem_id from GENE_CHEM_REFERENCE r where gene_id in ( select gene_id from GENE_TAXON where taxon_id = ( select id from TERM where acc_txt = '9606' and object_type_id = ( select id from OBJECT_TYPE where cd = 'taxon'))) and gene_id in ( select term_id from TERM_PATHWAY p where p.object_type_id = ( select id from OBJECT_TYPE where cd = 'gene') and term_id in ( select gene_id from GENE_TAXON where taxon_id = ( select id from TERM where acc_txt = '9606' and object_type_id = ( select id from OBJECT_TYPE where cd = 'taxon')))) and r.id NOT in ( SELECT gene_chem_reference_id FROM GENE_CHEM_REFERENCE_AXN WHERE action_degree_type_nm = 'does not affect');

Date: 2025-07-12 16:17:48
Duration: 1s263ms
Bind query: yes

x Hide

Times Reported Time consuming queries #10

x Hide

select gene_id, chem_id from GENE_CHEM_REFERENCE r where gene_id in ( select gene_id from GENE_TAXON where taxon_id = ( select id from TERM where acc_txt = '9606' and object_type_id = ( select id from OBJECT_TYPE where cd = 'taxon'))) and gene_id in ( select gene_id from gene_disease_reference where source_cd in ('C', 'O'));

Date: 2025-07-12 16:28:16
Duration: 1s849ms
Bind query: yes

select gene_id, chem_id from GENE_CHEM_REFERENCE r where gene_id in ( select gene_id from GENE_TAXON where taxon_id = ( select id from TERM where acc_txt = '9606' and object_type_id = ( select id from OBJECT_TYPE where cd = 'taxon'))) and gene_id in ( select gene_id from gene_disease_reference where source_cd in ('C', 'O'));

Date: 2025-07-12 16:17:40
Duration: 1s104ms
Bind query: yes

x Hide

Times Reported Time consuming queries #11

x Hide

SELECT /* TermBrowseIndexDAO */ DISTINCT REGEXP_REPLACE(UPPER(SUBSTRING(t.nm, 1, 1)), '[^A-Z]', '#') indexChar FROM term t WHERE t.object_type_id = '4' ORDER BY 1;

Date: 2025-07-12 16:18:16
Duration: 1s487ms
Bind query: yes

SELECT /* TermBrowseIndexDAO */ DISTINCT REGEXP_REPLACE(UPPER(SUBSTRING(t.nm, 1, 1)), '[^A-Z]', '#') indexChar FROM term t WHERE t.object_type_id = '4' ORDER BY 1;

Date: 2025-07-12 16:28:32
Duration: 1s82ms
Bind query: yes

x Hide

Times Reported Time consuming queries #1

x Hide

[ User: editeu - Total duration: 1m19s - Times executed: 21 ]

x Hide

select t.ID, t.OBJECT_TYPE_ID, t.ACC_TXT, t.ACC_DB_CD, t.NM, t.NM_SORT, t.SECONDARY_NM, t.DESCRIPTION, t.NOTE, l.NM from pub2.TERM t, pub2.TERM_LABEL l where t.OBJECT_TYPE_ID = 4 and t.id = l.TERM_ID;

Date: 2025-07-12 16:28:19
Duration: 8s257ms
Database: ctddev51
User: editeu
Bind query: yes

select t.ID, t.OBJECT_TYPE_ID, t.ACC_TXT, t.ACC_DB_CD, t.NM, t.NM_SORT, t.SECONDARY_NM, t.DESCRIPTION, t.NOTE, l.NM from pub2.TERM t, pub2.TERM_LABEL l where t.OBJECT_TYPE_ID = 4 and t.id = l.TERM_ID;

Date: 2025-07-12 16:18:03
Duration: 8s84ms
Database: ctddev51
User: editeu
Bind query: yes

select t.ID, t.OBJECT_TYPE_ID, t.ACC_TXT, t.ACC_DB_CD, t.NM, t.NM_SORT, t.SECONDARY_NM, t.DESCRIPTION, t.NOTE, l.NM from pub2.TERM t, pub2.TERM_LABEL l where t.OBJECT_TYPE_ID = 4 and t.id = l.TERM_ID;

Date: 2025-07-12 16:18:03
Duration: 8s1ms
Database: ctddev51
User: editeu
Bind query: yes

x Hide

Times Reported Time consuming queries #2

x Hide

SELECT /* CompsPrepDAO.cg */ DISTINCT gcr.chem_id, gcr.gene_id, gcra.action_degree_type_nm, gcra.action_type_cd FROM gene_chem_reference gcr INNER JOIN gene_chem_reference_axn gcra ON gcr.id = gcra.gene_chem_reference_id WHERE gcra.action_type_nm IN ('activity', 'binding', 'expression');

Date: 2025-07-12 16:17:54
Duration: 4s78ms
Bind query: yes

SELECT /* CompsPrepDAO.cg */ DISTINCT gcr.chem_id, gcr.gene_id, gcra.action_degree_type_nm, gcra.action_type_cd FROM gene_chem_reference gcr INNER JOIN gene_chem_reference_axn gcra ON gcr.id = gcra.gene_chem_reference_id WHERE gcra.action_type_nm IN ('activity', 'binding', 'expression');

Date: 2025-07-12 16:28:32
Duration: 4s1ms
Bind query: yes

SELECT /* CompsPrepDAO.cg */ DISTINCT gcr.chem_id, gcr.gene_id, gcra.action_degree_type_nm, gcra.action_type_cd FROM gene_chem_reference gcr INNER JOIN gene_chem_reference_axn gcra ON gcr.id = gcra.gene_chem_reference_id WHERE gcra.action_type_nm IN ('activity', 'binding', 'expression');

Date: 2025-07-12 16:18:01
Duration: 3s896ms
Bind query: yes

x Hide

Times Reported Time consuming queries #3

x Hide

[ User: pubeu - Total duration: 7s372ms - Times executed: 2 ]

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-12 16:18:14
Duration: 3s695ms
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-12 16:28:30
Duration: 3s676ms
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 = '1449802' 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-12 16:18:15
Duration: 1s160ms
Bind query: yes

x Hide

Times Reported Time consuming queries #4

x Hide

select p.ancestor_object_id, p.descendant_object_id from DAG_PATH p where p.descendant_object_id in ( select chem_id from GENE_CHEM_REFERENCE gcr where gcr.gene_id in ( select gene_id from GENE_TAXON where taxon_id = ( select id from TERM where acc_txt = '9606' and object_type_id = ( select id from OBJECT_TYPE where cd = 'taxon')))) AND p.ancestor_object_id != ( SELECT c.id FROM TERM c WHERE c.acc_txt = 'D' AND c.object_type_id = ( select id from OBJECT_TYPE where cd = 'chem'));

Date: 2025-07-12 16:28:25
Duration: 1s347ms
Bind query: yes

select p.ancestor_object_id, p.descendant_object_id from DAG_PATH p where p.descendant_object_id in ( select chem_id from GENE_CHEM_REFERENCE gcr where gcr.gene_id in ( select gene_id from GENE_TAXON where taxon_id = ( select id from TERM where acc_txt = '9606' and object_type_id = ( select id from OBJECT_TYPE where cd = 'taxon')))) AND p.ancestor_object_id != ( SELECT c.id FROM TERM c WHERE c.acc_txt = 'D' AND c.object_type_id = ( select id from OBJECT_TYPE where cd = 'chem'));

Date: 2025-07-12 16:28:14
Duration: 1s306ms
Bind query: yes

select p.ancestor_object_id, p.descendant_object_id from DAG_PATH p where p.descendant_object_id in ( select chem_id from GENE_CHEM_REFERENCE gcr where gcr.gene_id in ( select gene_id from GENE_TAXON where taxon_id = ( select id from TERM where acc_txt = '9606' and object_type_id = ( select id from OBJECT_TYPE where cd = 'taxon')))) AND p.ancestor_object_id != ( SELECT c.id FROM TERM c WHERE c.acc_txt = 'D' AND c.object_type_id = ( select id from OBJECT_TYPE where cd = 'chem'));

Date: 2025-07-12 16:17:39
Duration: 1s279ms
Bind query: yes

x Hide

Times Reported Time consuming queries #5

x Hide

select p.ancestor_object_id, p.descendant_object_id from DAG_PATH p where p.descendant_object_id in ( select go_term_id from GENE_GO_ANNOT gga where gga.taxon_id = ( select id from TERM where acc_txt = '9606' and object_type_id = ( select id from OBJECT_TYPE where cd = 'taxon')) AND gga.is_not = 'f') and p.ancestor_object_id NOT in ( SELECT c.id FROM TERM c WHERE c.acc_txt in ('ALL') AND c.object_type_id = ( select id from OBJECT_TYPE where cd = 'go'));

Date: 2025-07-12 16:17:35
Duration: 6s547ms
Bind query: yes

select p.ancestor_object_id, p.descendant_object_id from DAG_PATH p where p.descendant_object_id in ( select go_term_id from GENE_GO_ANNOT gga where gga.taxon_id = ( select id from TERM where acc_txt = '9606' and object_type_id = ( select id from OBJECT_TYPE where cd = 'taxon')) AND gga.is_not = 'f') and p.ancestor_object_id NOT in ( SELECT c.id FROM TERM c WHERE c.acc_txt in ('ALL') AND c.object_type_id = ( select id from OBJECT_TYPE where cd = 'go'));

Date: 2025-07-12 16:28:11
Duration: 6s228ms
Bind query: yes

x Hide

Times Reported Time consuming queries #6

x Hide

[ User: pubeu - Total duration: 8s562ms - Times executed: 2 ]

x Hide

select count(distinct gene_id) from GENE_TAXON where taxon_id = 559111;

Date: 2025-07-12 16:17:23
Duration: 5s751ms
Database: ctddev51
User: pubeu
Bind query: yes

select count(distinct gene_id) from GENE_TAXON where taxon_id = 559111;

Date: 2025-07-12 16:28:00
Duration: 2s810ms
Database: ctddev51
User: pubeu
Bind query: yes

x Hide

Times Reported Time consuming queries #7

x Hide

select p.ancestor_object_id, p.descendant_object_id from DAG_PATH p where p.descendant_object_id in ( select disease_id from GENE_DISEASE_REFERENCE gdr where gdr.source_cd in ('C', 'O') and gene_id in ( select gene_id from GENE_TAXON where taxon_id = 559111)) and p.ancestor_object_id <> 2101568;

Date: 2025-07-12 16:17:28
Duration: 4s436ms
Bind query: yes

select p.ancestor_object_id, p.descendant_object_id from DAG_PATH p where p.descendant_object_id in ( select disease_id from GENE_DISEASE_REFERENCE gdr where gdr.source_cd in ('C', 'O') and gene_id in ( select gene_id from GENE_TAXON where taxon_id = 559111)) and p.ancestor_object_id <> 2101568;

Date: 2025-07-12 16:28:04
Duration: 3s437ms
Bind query: yes

x Hide

Times Reported Time consuming queries #8

x Hide

select gene_id, chem_id from GENE_CHEM_REFERENCE r where gene_id in ( select gene_id from GENE_TAXON where taxon_id = ( select id from TERM where acc_txt = '9606' and object_type_id = ( select id from OBJECT_TYPE where cd = 'taxon'))) and gene_id in ( select gene_id from GENE_GO_ANNOT where taxon_id = ( select id from TERM where acc_txt = '9606' and object_type_id = ( select id from OBJECT_TYPE where cd = 'taxon')) AND is_not = 'f' and go_term_id not in ( SELECT c.id FROM TERM c WHERE c.acc_txt in ('ALL') AND c.object_type_id = ( select id from OBJECT_TYPE where cd = 'go'))) and r.id NOT in ( SELECT gene_chem_reference_id FROM GENE_CHEM_REFERENCE_AXN WHERE action_degree_type_nm = 'does not affect');

Date: 2025-07-12 16:28:22
Duration: 2s195ms
Bind query: yes

select gene_id, chem_id from GENE_CHEM_REFERENCE r where gene_id in ( select gene_id from GENE_TAXON where taxon_id = ( select id from TERM where acc_txt = '9606' and object_type_id = ( select id from OBJECT_TYPE where cd = 'taxon'))) and gene_id in ( select gene_id from GENE_GO_ANNOT where taxon_id = ( select id from TERM where acc_txt = '9606' and object_type_id = ( select id from OBJECT_TYPE where cd = 'taxon')) AND is_not = 'f' and go_term_id not in ( SELECT c.id FROM TERM c WHERE c.acc_txt in ('ALL') AND c.object_type_id = ( select id from OBJECT_TYPE where cd = 'go'))) and r.id NOT in ( SELECT gene_chem_reference_id FROM GENE_CHEM_REFERENCE_AXN WHERE action_degree_type_nm = 'does not affect');

Date: 2025-07-12 16:17:44
Duration: 2s45ms
Bind query: yes

x Hide

Times Reported Time consuming queries #9

x Hide

select gene_id, chem_id from GENE_CHEM_REFERENCE r where gene_id in ( select gene_id from GENE_TAXON where taxon_id = ( select id from TERM where acc_txt = '9606' and object_type_id = ( select id from OBJECT_TYPE where cd = 'taxon'))) and gene_id in ( select term_id from TERM_PATHWAY p where p.object_type_id = ( select id from OBJECT_TYPE where cd = 'gene') and term_id in ( select gene_id from GENE_TAXON where taxon_id = ( select id from TERM where acc_txt = '9606' and object_type_id = ( select id from OBJECT_TYPE where cd = 'taxon')))) and r.id NOT in ( SELECT gene_chem_reference_id FROM GENE_CHEM_REFERENCE_AXN WHERE action_degree_type_nm = 'does not affect');

Date: 2025-07-12 16:28:27
Duration: 2s20ms
Bind query: yes

select gene_id, chem_id from GENE_CHEM_REFERENCE r where gene_id in ( select gene_id from GENE_TAXON where taxon_id = ( select id from TERM where acc_txt = '9606' and object_type_id = ( select id from OBJECT_TYPE where cd = 'taxon'))) and gene_id in ( select term_id from TERM_PATHWAY p where p.object_type_id = ( select id from OBJECT_TYPE where cd = 'gene') and term_id in ( select gene_id from GENE_TAXON where taxon_id = ( select id from TERM where acc_txt = '9606' and object_type_id = ( select id from OBJECT_TYPE where cd = 'taxon')))) and r.id NOT in ( SELECT gene_chem_reference_id FROM GENE_CHEM_REFERENCE_AXN WHERE action_degree_type_nm = 'does not affect');

Date: 2025-07-12 16:17:48
Duration: 1s263ms
Bind query: yes

x Hide

Times Reported Time consuming queries #10

x Hide

select gene_id, chem_id from GENE_CHEM_REFERENCE r where gene_id in ( select gene_id from GENE_TAXON where taxon_id = ( select id from TERM where acc_txt = '9606' and object_type_id = ( select id from OBJECT_TYPE where cd = 'taxon'))) and gene_id in ( select gene_id from gene_disease_reference where source_cd in ('C', 'O'));

Date: 2025-07-12 16:28:16
Duration: 1s849ms
Bind query: yes

select gene_id, chem_id from GENE_CHEM_REFERENCE r where gene_id in ( select gene_id from GENE_TAXON where taxon_id = ( select id from TERM where acc_txt = '9606' and object_type_id = ( select id from OBJECT_TYPE where cd = 'taxon'))) and gene_id in ( select gene_id from gene_disease_reference where source_cd in ('C', 'O'));

Date: 2025-07-12 16:17:40
Duration: 1s104ms
Bind query: yes

x Hide

Times Reported Time consuming queries #11

x Hide

SELECT /* TermBrowseIndexDAO */ DISTINCT REGEXP_REPLACE(UPPER(SUBSTRING(t.nm, 1, 1)), '[^A-Z]', '#') indexChar FROM term t WHERE t.object_type_id = '4' ORDER BY 1;

Date: 2025-07-12 16:18:16
Duration: 1s487ms
Bind query: yes

SELECT /* TermBrowseIndexDAO */ DISTINCT REGEXP_REPLACE(UPPER(SUBSTRING(t.nm, 1, 1)), '[^A-Z]', '#') indexChar FROM term t WHERE t.object_type_id = '4' ORDER BY 1;

Date: 2025-07-12 16:28:32
Duration: 1s82ms
Bind query: yes

x Hide

Times Reported Time consuming queries #1

x Hide

select p.ancestor_object_id, p.descendant_object_id from DAG_PATH p where p.descendant_object_id in ( select go_term_id from GENE_GO_ANNOT gga where gga.taxon_id = ( select id from TERM where acc_txt = '9606' and object_type_id = ( select id from OBJECT_TYPE where cd = 'taxon')) AND gga.is_not = 'f') and p.ancestor_object_id NOT in ( SELECT c.id FROM TERM c WHERE c.acc_txt in ('ALL') AND c.object_type_id = ( select id from OBJECT_TYPE where cd = 'go'));

Date: 2025-07-12 16:17:35
Duration: 6s547ms
Bind query: yes

select p.ancestor_object_id, p.descendant_object_id from DAG_PATH p where p.descendant_object_id in ( select go_term_id from GENE_GO_ANNOT gga where gga.taxon_id = ( select id from TERM where acc_txt = '9606' and object_type_id = ( select id from OBJECT_TYPE where cd = 'taxon')) AND gga.is_not = 'f') and p.ancestor_object_id NOT in ( SELECT c.id FROM TERM c WHERE c.acc_txt in ('ALL') AND c.object_type_id = ( select id from OBJECT_TYPE where cd = 'go'));

Date: 2025-07-12 16:28:11
Duration: 6s228ms
Bind query: yes

x Hide

Times Reported Time consuming queries #2

x Hide

[ User: pubeu - Total duration: 8s562ms - Times executed: 2 ]

x Hide

select count(distinct gene_id) from GENE_TAXON where taxon_id = 559111;

Date: 2025-07-12 16:17:23
Duration: 5s751ms
Database: ctddev51
User: pubeu
Bind query: yes

select count(distinct gene_id) from GENE_TAXON where taxon_id = 559111;

Date: 2025-07-12 16:28:00
Duration: 2s810ms
Database: ctddev51
User: pubeu
Bind query: yes

x Hide

Times Reported Time consuming queries #3

x Hide

select p.ancestor_object_id, p.descendant_object_id from DAG_PATH p where p.descendant_object_id in ( select disease_id from GENE_DISEASE_REFERENCE gdr where gdr.source_cd in ('C', 'O') and gene_id in ( select gene_id from GENE_TAXON where taxon_id = 559111)) and p.ancestor_object_id <> 2101568;

Date: 2025-07-12 16:17:28
Duration: 4s436ms
Bind query: yes

select p.ancestor_object_id, p.descendant_object_id from DAG_PATH p where p.descendant_object_id in ( select disease_id from GENE_DISEASE_REFERENCE gdr where gdr.source_cd in ('C', 'O') and gene_id in ( select gene_id from GENE_TAXON where taxon_id = 559111)) and p.ancestor_object_id <> 2101568;

Date: 2025-07-12 16:28:04
Duration: 3s437ms
Bind query: yes

x Hide

Times Reported Time consuming queries #4

x Hide

SELECT /* CompsPrepDAO.cg */ DISTINCT gcr.chem_id, gcr.gene_id, gcra.action_degree_type_nm, gcra.action_type_cd FROM gene_chem_reference gcr INNER JOIN gene_chem_reference_axn gcra ON gcr.id = gcra.gene_chem_reference_id WHERE gcra.action_type_nm IN ('activity', 'binding', 'expression');

Date: 2025-07-12 16:17:54
Duration: 4s78ms
Bind query: yes

SELECT /* CompsPrepDAO.cg */ DISTINCT gcr.chem_id, gcr.gene_id, gcra.action_degree_type_nm, gcra.action_type_cd FROM gene_chem_reference gcr INNER JOIN gene_chem_reference_axn gcra ON gcr.id = gcra.gene_chem_reference_id WHERE gcra.action_type_nm IN ('activity', 'binding', 'expression');

Date: 2025-07-12 16:28:32
Duration: 4s1ms
Bind query: yes

SELECT /* CompsPrepDAO.cg */ DISTINCT gcr.chem_id, gcr.gene_id, gcra.action_degree_type_nm, gcra.action_type_cd FROM gene_chem_reference gcr INNER JOIN gene_chem_reference_axn gcra ON gcr.id = gcra.gene_chem_reference_id WHERE gcra.action_type_nm IN ('activity', 'binding', 'expression');

Date: 2025-07-12 16:18:01
Duration: 3s896ms
Bind query: yes

x Hide

Times Reported Time consuming queries #5

x Hide

[ User: editeu - Total duration: 1m19s - Times executed: 21 ]

x Hide

select t.ID, t.OBJECT_TYPE_ID, t.ACC_TXT, t.ACC_DB_CD, t.NM, t.NM_SORT, t.SECONDARY_NM, t.DESCRIPTION, t.NOTE, l.NM from pub2.TERM t, pub2.TERM_LABEL l where t.OBJECT_TYPE_ID = 4 and t.id = l.TERM_ID;

Date: 2025-07-12 16:28:19
Duration: 8s257ms
Database: ctddev51
User: editeu
Bind query: yes

select t.ID, t.OBJECT_TYPE_ID, t.ACC_TXT, t.ACC_DB_CD, t.NM, t.NM_SORT, t.SECONDARY_NM, t.DESCRIPTION, t.NOTE, l.NM from pub2.TERM t, pub2.TERM_LABEL l where t.OBJECT_TYPE_ID = 4 and t.id = l.TERM_ID;

Date: 2025-07-12 16:18:03
Duration: 8s84ms
Database: ctddev51
User: editeu
Bind query: yes

select t.ID, t.OBJECT_TYPE_ID, t.ACC_TXT, t.ACC_DB_CD, t.NM, t.NM_SORT, t.SECONDARY_NM, t.DESCRIPTION, t.NOTE, l.NM from pub2.TERM t, pub2.TERM_LABEL l where t.OBJECT_TYPE_ID = 4 and t.id = l.TERM_ID;

Date: 2025-07-12 16:18:03
Duration: 8s1ms
Database: ctddev51
User: editeu
Bind query: yes

x Hide

Times Reported Time consuming queries #6

x Hide