Times Reported Time consuming queries #1

x Hide

[ User: load - Total duration: 9m5s - Times executed: 4 ]

x Hide

select distinct primaryGeneTerm.acc_txt, taxonTerm.acc_txt, gt.gene_acc_txt from pub1.GENE_TAXON gt, pub1.TERM primaryGeneTerm, pub1.TERM taxonTerm where gt.gene_id = primaryGeneTerm.id and gt.taxon_id = taxonTerm.id;

Date: 2024-03-13 16:00:41
Duration: 2m36s
Database: ctddev51
User: load
Bind query: yes

select distinct primaryGeneTerm.acc_txt, taxonTerm.acc_txt, gt.gene_acc_txt from pub1.GENE_TAXON gt, pub1.TERM primaryGeneTerm, pub1.TERM taxonTerm where gt.gene_id = primaryGeneTerm.id and gt.taxon_id = taxonTerm.id;

Date: 2024-03-13 13:56:51
Duration: 2m17s
Database: ctddev51
User: load
Bind query: yes

select distinct primaryGeneTerm.acc_txt, taxonTerm.acc_txt, gt.gene_acc_txt from pub1.GENE_TAXON gt, pub1.TERM primaryGeneTerm, pub1.TERM taxonTerm where gt.gene_id = primaryGeneTerm.id and gt.taxon_id = taxonTerm.id;

Date: 2024-03-13 12:21:23
Duration: 2m9s
Database: ctddev51
User: load
Bind query: yes

x Hide

Times Reported Time consuming queries #2

x Hide

select ID, OBJECT_TYPE_ID, ACC_TXT, t.ACC_DB_CD, NM, NM_SORT, SECONDARY_NM, DESCRIPTION, NOTE from pub1.term t where object_type_id = 1;

Date: 2024-03-13 16:01:45
Duration: 57s773ms
Bind query: yes

select ID, OBJECT_TYPE_ID, ACC_TXT, t.ACC_DB_CD, NM, NM_SORT, SECONDARY_NM, DESCRIPTION, NOTE from pub1.term t where object_type_id = 1;

Date: 2024-03-13 12:40:31
Duration: 48s546ms
Bind query: yes

select ID, OBJECT_TYPE_ID, ACC_TXT, t.ACC_DB_CD, NM, NM_SORT, SECONDARY_NM, DESCRIPTION, NOTE from pub1.term t where object_type_id = 1;

Date: 2024-03-13 12:22:15
Duration: 46s129ms
Bind query: yes

x Hide

Times Reported Time consuming queries #3

x Hide

[ User: editeu - Total duration: 52s916ms - Times executed: 15 ]

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 pub1.TERM t, pub1.TERM_LABEL l where t.OBJECT_TYPE_ID = 4 and t.id = l.TERM_ID;

Date: 2024-03-13 10:01:21
Duration: 5s218ms
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 pub1.TERM t, pub1.TERM_LABEL l where t.OBJECT_TYPE_ID = 4 and t.id = l.TERM_ID;

Date: 2024-03-13 10:16:17
Duration: 5s20ms
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 pub1.TERM t, pub1.TERM_LABEL l where t.OBJECT_TYPE_ID = 4 and t.id = l.TERM_ID;

Date: 2024-03-13 10:13:40
Duration: 4s899ms
Database: ctddev51
User: editeu
Bind query: yes

x Hide

Times Reported Time consuming queries #4

x Hide

SELECT ee.exp_marker_lvl, ee.exp_marker_lvl_range, ee.detection_limit_uom, ee.note, ee.detection_freq, ee.detection_freq_range, ee.collection_end_yr, ee.detection_limit_is_loq, ee.detection_limit, ee.detection_limit_range, ee.assay_note, ee.assay_measurement_stat, ee.exp_marker_actor_form_type_id, ee.exp_marker_acc_db_id, ee.exp_marker_acc_txt, ee.collection_start_yr, ee.assay_uom, -- ,ee.exp_marker_term_id -- get from term table t.id, ee.exp_marker_type_id, ee.medium_id, -- ,ee.medium_nm -- get from pub medium table m.nm, -- ,ee.medium_term_id -- get from pub term table mt.id, -- ,ee.medium_term_acc_txt -- get from pub medium table m.term_acc_txt, ee.has_locations, ee.id, ee.exp_marker_term_nm, t.nm_html FROM EDIT.EXP_EVENT ee LEFT OUTER JOIN pub2.TERM t ON ee.exp_marker_acc_txt = t.acc_txt -- ON ee.exp_marker_term_id = t.id -- get where clause from errant query LEFT OUTER JOIN PUB2.MEDIUM m ON ee.medium_id = m.id LEFT OUTER JOIN PUB2.TERM mt ON m.term_acc_txt = mt.acc_txt INNER JOIN EDIT.EXPOSURE e ON e.exp_event_id = ee.id WHERE e.reference_acc_txt NOT IN ('11874814', '12819278', '14527848', '12003754', '12948893');

Date: 2024-03-13 13:14:01
Duration: 23s18ms

x Hide

Times Reported Time consuming queries #5

x Hide

SELECT ee.exp_marker_lvl, ee.exp_marker_lvl_range, ee.detection_limit_uom, ee.note, ee.detection_freq, ee.detection_freq_range, ee.collection_end_yr, ee.detection_limit_is_loq, ee.detection_limit, ee.detection_limit_range, ee.assay_note, ee.assay_measurement_stat, ee.exp_marker_actor_form_type_id, ee.exp_marker_acc_db_id, ee.exp_marker_acc_txt, ee.collection_start_yr, ee.assay_uom, -- ,ee.exp_marker_term_id -- get from term table t.id, ee.exp_marker_type_id, ee.medium_id, -- ,ee.medium_nm -- get from pub medium table m.nm, -- ,ee.medium_term_id -- get from pub term table mt.id, -- ,ee.medium_term_acc_txt -- get from pub medium table m.term_acc_txt, ee.has_locations, ee.id, ee.exp_marker_term_nm, t.nm_html FROM EDIT.EXP_EVENT ee LEFT OUTER JOIN pub2.TERM t ON ee.exp_marker_acc_txt = t.acc_txt -- ON ee.exp_marker_term_id = t.id -- get where clause from errant query LEFT OUTER JOIN PUB2.MEDIUM m ON ee.medium_id = m.id LEFT OUTER JOIN PUB2.TERM mt ON m.term_acc_txt = mt.acc_txt INNER JOIN EDIT.EXPOSURE e ON e.exp_event_id = ee.id;

Date: 2024-03-13 13:09:46
Duration: 20s918ms

x Hide

Times Reported Time consuming queries #6

x Hide

SELECT ee.exp_marker_lvl, ee.exp_marker_lvl_range, ee.detection_limit_uom, ee.note, ee.detection_freq, ee.detection_freq_range, ee.collection_end_yr, ee.detection_limit_is_loq, ee.detection_limit, ee.detection_limit_range, ee.assay_note, ee.assay_measurement_stat, ee.exp_marker_actor_form_type_id, ee.exp_marker_acc_db_id, ee.exp_marker_acc_txt, ee.collection_start_yr, ee.assay_uom, -- ,ee.exp_marker_term_id -- get from term table t.id, ee.exp_marker_type_id, ee.medium_id, -- ,ee.medium_nm -- get from pub medium table m.nm, -- ,ee.medium_term_id -- get from pub term table mt.id, -- ,ee.medium_term_acc_txt -- get from pub medium table m.term_acc_txt, ee.has_locations, ee.id, ee.exp_marker_term_nm, t.nm_html FROM EDIT.EXP_EVENT ee LEFT OUTER JOIN pub2.TERM t ON ee.exp_marker_acc_txt = t.acc_txt -- ON ee.exp_marker_term_id = t.id -- get where clause from errant query LEFT OUTER JOIN PUB2.MEDIUM m ON ee.medium_id = m.id LEFT OUTER JOIN PUB2.TERM mt ON m.term_acc_txt = mt.acc_txt INNER JOIN EDIT.EXPOSURE e ON e.exp_event_id = ee.id WHERE e.reference_acc_txt NOT IN ('11874814', '12819278', '14527848', '12003754', '12948893') order by ee.id;

Date: 2024-03-13 13:15:14
Duration: 20s774ms

x Hide

Times Reported Time consuming queries #7

x Hide

SELECT ee.exp_marker_lvl, ee.exp_marker_lvl_range, ee.detection_limit_uom, ee.note, ee.detection_freq, ee.detection_freq_range, ee.collection_end_yr, ee.detection_limit_is_loq, ee.detection_limit, ee.detection_limit_range, ee.assay_note, ee.assay_measurement_stat, ee.exp_marker_actor_form_type_id, ee.exp_marker_acc_db_id, ee.exp_marker_acc_txt, ee.collection_start_yr, ee.assay_uom, -- ,ee.exp_marker_term_id -- get from term table t.id, ee.exp_marker_type_id, ee.medium_id -- ,ee.medium_nm -- get from pub medium table -- ,m.nm -- ,ee.medium_term_id -- get from pub term table -- ,mt.id -- ,ee.medium_term_acc_txt -- get from pub medium table , -- ,m.term_acc_txt ee.has_locations, ee.id, ee.exp_marker_term_nm, t.nm_html FROM EDIT.EXP_EVENT ee INNER JOIN EDIT.EXPOSURE e ON e.exp_event_id = ee.id INNER JOIN pub2.EXP_MARKER_TYPE emt ON ee.exp_marker_type_id = emt.id INNER JOIN edit.OBJECT_TYPE o ON emt.object_type_id = o.id LEFT OUTER JOIN pub2.TERM t ON ee.exp_marker_acc_txt = t.acc_txt AND o.id = t.object_type_id -- ON ee.exp_marker_term_id = t.id -- get where clause from errant query -- LEFT OUTER JOIN PUB2.MEDIUM m ON ee.medium_id = m.id -- LEFT OUTER JOIN PUB2.TERM mt ON m.term_acc_txt = mt.acc_txt WHERE e.reference_acc_txt NOT IN ('11874814', '12819278', '14527848', '12003754', '12948893') and ee.exp_marker_acc_txt is not null AND ee.exp_marker_acc_txt <> ''; , ee.exp_marker_lvl_range, ee.detection_limit_uom, ee.note, ee.detection_freq, ee.detection_freq_range, ee.collection_end_yr, ee.detection_limit_is_loq, ee.detection_limit, ee.detection_limit_range, ee.assay_note, ee.assay_measurement_stat, ee.exp_marker_actor_form_type_id, ee.exp_marker_acc_db_id, ee.exp_marker_acc_txt, ee.collection_start_yr, ee.assay_uom, -- ,ee.exp_marker_term_id -- get from term table t.id, ee.exp_marker_type_id, ee.medium_id, -- ,ee.medium_nm -- get from pub medium table m.nm -- ,ee.medium_term_id -- get from pub term table -- ,mt.id , -- ,ee.medium_term_acc_txt -- get from pub medium table m.term_acc_txt, ee.has_locations, ee.id, ee.exp_marker_term_nm, t.nm_html FROM EDIT.EXP_EVENT ee INNER JOIN EDIT.EXPOSURE e ON e.exp_event_id = ee.id INNER JOIN pub2.EXP_MARKER_TYPE emt ON ee.exp_marker_type_id = emt.id INNER JOIN edit.OBJECT_TYPE o ON emt.object_type_id = o.id LEFT OUTER JOIN pub2.TERM t ON ee.exp_marker_acc_txt = t.acc_txt AND o.id = t.object_type_id -- ON ee.exp_marker_term_id = t.id -- get where clause from errant query LEFT OUTER JOIN PUB2.MEDIUM m ON ee.medium_id = m.id -- LEFT OUTER JOIN PUB2.TERM mt ON m.term_acc_txt = mt.acc_txt WHERE e.reference_acc_txt NOT IN ('11874814', '12819278', '14527848', '12003754', '12948893') and ee.exp_marker_acc_txt is not null AND ee.exp_marker_acc_txt <> ''; , ee.exp_marker_lvl_range, ee.detection_limit_uom, ee.note, ee.detection_freq, ee.detection_freq_range, ee.collection_end_yr, ee.detection_limit_is_loq, ee.detection_limit, ee.detection_limit_range, ee.assay_note, ee.assay_measurement_stat, ee.exp_marker_actor_form_type_id, ee.exp_marker_acc_db_id, ee.exp_marker_acc_txt, ee.collection_start_yr, ee.assay_uom, -- ,ee.exp_marker_term_id -- get from term table t.id, ee.exp_marker_type_id, ee.medium_id, -- ,ee.medium_nm -- get from pub medium table m.nm -- ,ee.medium_term_id -- get from pub term table -- ,mt.id , -- ,ee.medium_term_acc_txt -- get from pub medium table m.term_acc_txt, ee.has_locations, ee.id, ee.exp_marker_term_nm, t.nm_html FROM EDIT.EXP_EVENT ee INNER JOIN EDIT.EXPOSURE e ON e.exp_event_id = ee.id INNER JOIN pub2.EXP_MARKER_TYPE emt ON ee.exp_marker_type_id = emt.id INNER JOIN edit.OBJECT_TYPE o ON emt.object_type_id = o.id LEFT OUTER JOIN pub2.TERM t ON ee.exp_marker_acc_txt = t.acc_txt AND o.id = t.object_type_id -- ON ee.exp_marker_term_id = t.id -- get where clause from errant query LEFT OUTER JOIN PUB2.MEDIUM m ON ee.medium_id = m.id -- LEFT OUTER JOIN PUB2.TERM mt ON m.term_acc_txt = mt.acc_txt WHERE e.reference_acc_txt NOT IN ('11874814', '12819278', '14527848', '12003754', '12948893') -- and ee.exp_marker_acc_txt is not null AND ee.exp_marker_acc_txt <> '' ; , ee.exp_marker_lvl_range, ee.detection_limit_uom, ee.note, ee.detection_freq, ee.detection_freq_range, ee.collection_end_yr, ee.detection_limit_is_loq, ee.detection_limit, ee.detection_limit_range, ee.assay_note, ee.assay_measurement_stat, ee.exp_marker_actor_form_type_id, ee.exp_marker_acc_db_id, ee.exp_marker_acc_txt, ee.collection_start_yr, ee.assay_uom, -- ,ee.exp_marker_term_id -- get from term table t.id, ee.exp_marker_type_id, ee.medium_id, -- ,ee.medium_nm -- get from pub medium table m.nm -- ,ee.medium_term_id -- get from pub term table -- ,mt.id , -- ,ee.medium_term_acc_txt -- get from pub medium table m.term_acc_txt, ee.has_locations, ee.id, ee.exp_marker_term_nm, t.nm_html FROM EDIT.EXP_EVENT ee INNER JOIN EDIT.EXPOSURE e ON e.exp_event_id = ee.id INNER JOIN pub2.EXP_MARKER_TYPE emt ON ee.exp_marker_type_id = emt.id INNER JOIN edit.OBJECT_TYPE o ON emt.object_type_id = o.id LEFT OUTER JOIN pub2.TERM t ON ee.exp_marker_acc_txt = t.acc_txt AND o.id = t.object_type_id -- ON ee.exp_marker_term_id = t.id -- get where clause from errant query LEFT OUTER JOIN PUB2.MEDIUM m ON ee.medium_id = m.id -- LEFT OUTER JOIN PUB2.TERM mt ON m.term_acc_txt = mt.acc_txt WHERE e.reference_acc_txt NOT IN ('11874814', '12819278', '14527848', '12003754', '12948893') and ee.exp_marker_acc_txt is not null AND ee.exp_marker_acc_txt <> ''; , ee.exp_marker_lvl_range, ee.detection_limit_uom, ee.note, ee.detection_freq, ee.detection_freq_range, ee.collection_end_yr, ee.detection_limit_is_loq, ee.detection_limit, ee.detection_limit_range, ee.assay_note, ee.assay_measurement_stat, ee.exp_marker_actor_form_type_id, ee.exp_marker_acc_db_id, ee.exp_marker_acc_txt, ee.collection_start_yr, ee.assay_uom, -- ,ee.exp_marker_term_id -- get from term table t.id, ee.exp_marker_type_id, ee.medium_id, -- ,ee.medium_nm -- get from pub medium table m.nm -- ,ee.medium_term_id -- get from pub term table -- ,mt.id , -- ,ee.medium_term_acc_txt -- get from pub medium table m.term_acc_txt, ee.has_locations, ee.id, ee.exp_marker_term_nm, t.nm_html FROM EDIT.EXP_EVENT ee INNER JOIN EDIT.EXPOSURE e ON e.exp_event_id = ee.id INNER JOIN pub2.EXP_MARKER_TYPE emt ON ee.exp_marker_type_id = emt.id INNER JOIN edit.OBJECT_TYPE o ON emt.object_type_id = o.id LEFT OUTER JOIN pub2.TERM t ON ee.exp_marker_acc_txt = t.acc_txt AND o.id = t.object_type_id -- ON ee.exp_marker_term_id = t.id -- get where clause from errant query LEFT OUTER JOIN PUB2.MEDIUM m ON ee.medium_id = m.id -- LEFT OUTER JOIN PUB2.TERM mt ON m.term_acc_txt = mt.acc_txt -- WHERE e.reference_acc_txt NOT IN ('11874814','12819278','14527848','12003754','12948893') and ee.exp_marker_acc_txt is not null AND ee.exp_marker_acc_txt <> ''; , ee.exp_marker_lvl_range, ee.detection_limit_uom, ee.note, ee.detection_freq, ee.detection_freq_range, ee.collection_end_yr, ee.detection_limit_is_loq, ee.detection_limit, ee.detection_limit_range, ee.assay_note, ee.assay_measurement_stat, ee.exp_marker_actor_form_type_id, ee.exp_marker_acc_db_id, ee.exp_marker_acc_txt, ee.collection_start_yr, ee.assay_uom, -- ,ee.exp_marker_term_id -- get from term table t.id, ee.exp_marker_type_id, ee.medium_id, -- ,ee.medium_nm -- get from pub medium table m.nm -- ,ee.medium_term_id -- get from pub term table -- ,mt.id , -- ,ee.medium_term_acc_txt -- get from pub medium table m.term_acc_txt, ee.has_locations, ee.id, ee.exp_marker_term_nm, t.nm_html FROM EDIT.EXP_EVENT ee INNER JOIN EDIT.EXPOSURE e ON e.exp_event_id = ee.id AND e.reference_acc_txt NOT IN ('11874814', '12819278', '14527848', '12003754', '12948893') INNER JOIN edit.EXP_MARKER_TYPE emt ON ee.exp_marker_type_id = emt.id INNER JOIN edit.OBJECT_TYPE o ON emt.object_type_id = o.id LEFT OUTER JOIN pub2.TERM t ON ee.exp_marker_acc_txt = t.acc_txt AND o.id = t.object_type_id -- ON ee.exp_marker_term_id = t.id -- get where clause from errant query LEFT OUTER JOIN PUB2.MEDIUM m ON ee.medium_id = m.id -- LEFT OUTER JOIN PUB2.TERM mt ON m.term_acc_txt = mt.acc_txt -- WHERE e.reference_acc_txt NOT IN ('11874814','12819278','14527848','12003754','12948893') and ee.exp_marker_acc_txt is not null AND ee.exp_marker_acc_txt <> ''; , ee.exp_marker_lvl_range, ee.detection_limit_uom, ee.note, ee.detection_freq, ee.detection_freq_range, ee.collection_end_yr, ee.detection_limit_is_loq, ee.detection_limit, ee.detection_limit_range, ee.assay_note, ee.assay_measurement_stat, ee.exp_marker_actor_form_type_id, ee.exp_marker_acc_db_id, ee.exp_marker_acc_txt, ee.collection_start_yr, ee.assay_uom, -- ,ee.exp_marker_term_id -- get from term table t.id, ee.exp_marker_type_id, ee.medium_id, -- ,ee.medium_nm -- get from pub medium table m.nm -- ,ee.medium_term_id -- get from pub term table -- ,mt.id , -- ,ee.medium_term_acc_txt -- get from pub medium table m.term_acc_txt, ee.has_locations, ee.id, ee.exp_marker_term_nm, t.nm_html FROM EDIT.EXP_EVENT ee INNER JOIN EDIT.EXPOSURE e ON e.exp_event_id = ee.id AND e.reference_acc_txt NOT IN ('11874814', '12819278', '14527848', '12003754', '12948893') INNER JOIN edit.EXP_MARKER_TYPE emt ON ee.exp_marker_type_id = emt.id INNER JOIN edit.OBJECT_TYPE o ON emt.object_type_id = o.id LEFT OUTER JOIN pub2.TERM t ON ee.exp_marker_acc_txt = t.acc_txt AND o.id = t.object_type_id -- ON ee.exp_marker_term_id = t.id -- get where clause from errant query LEFT OUTER JOIN PUB2.MEDIUM m ON ee.medium_id = m.id -- LEFT OUTER JOIN PUB2.TERM mt ON m.term_acc_txt = mt.acc_txt -- WHERE e.reference_acc_txt NOT IN ('11874814','12819278','14527848','12003754','12948893') --and ee.exp_marker_acc_txt is not null AND ee.exp_marker_acc_txt <> '' ; , ee.exp_marker_lvl_range, ee.detection_limit_uom, ee.note, ee.detection_freq, ee.detection_freq_range, ee.collection_end_yr, ee.detection_limit_is_loq, ee.detection_limit, ee.detection_limit_range, ee.assay_note, ee.assay_measurement_stat, ee.exp_marker_actor_form_type_id, ee.exp_marker_acc_db_id, ee.exp_marker_acc_txt, ee.collection_start_yr, ee.assay_uom, -- ,ee.exp_marker_term_id -- get from term table t.id, ee.exp_marker_type_id, ee.medium_id, -- ,ee.medium_nm -- get from pub medium table m.nm -- ,ee.medium_term_id -- get from pub term table -- ,mt.id , -- ,ee.medium_term_acc_txt -- get from pub medium table m.term_acc_txt, ee.has_locations, ee.id, ee.exp_marker_term_nm, t.nm_html FROM EDIT.EXP_EVENT ee INNER JOIN EDIT.EXPOSURE e ON e.exp_event_id = ee.id AND e.reference_acc_txt NOT IN ('11874814', '12819278', '14527848', '12003754', '12948893') INNER JOIN edit.EXP_MARKER_TYPE emt ON ee.exp_marker_type_id = emt.id INNER JOIN edit.OBJECT_TYPE o ON emt.object_type_id = o.id LEFT OUTER JOIN pub2.TERM t ON ee.exp_marker_acc_txt = t.acc_txt AND o.id = t.object_type_id -- ON ee.exp_marker_term_id = t.id -- get where clause from errant query LEFT OUTER JOIN PUB2.MEDIUM m ON ee.medium_id = m.id LEFT OUTER JOIN PUB2.TERM mt ON m.term_acc_txt = mt.acc_txt AND m.term_object_type_id = mt.object_type_id -- LEFT OUTER JOIN PUB2.TERM mt ON m.term_acc_txt = mt.acc_txt -- WHERE e.reference_acc_txt NOT IN ('11874814','12819278','14527848','12003754','12948893') --and ee.exp_marker_acc_txt is not null AND ee.exp_marker_acc_txt <> '' ; , ee.exp_marker_lvl_range, ee.detection_limit_uom, ee.note, ee.detection_freq, ee.detection_freq_range, ee.collection_end_yr, ee.detection_limit_is_loq, ee.detection_limit, ee.detection_limit_range, ee.assay_note, ee.assay_measurement_stat, ee.exp_marker_actor_form_type_id, ee.exp_marker_acc_db_id, ee.exp_marker_acc_txt, ee.collection_start_yr, ee.assay_uom, -- ,ee.exp_marker_term_id -- get from term table t.id, ee.exp_marker_type_id, ee.medium_id, -- ,ee.medium_nm -- get from pub medium table m.nm, -- ,ee.medium_term_id -- get from pub term table mt.id, -- ,ee.medium_term_acc_txt -- get from pub medium table m.term_acc_txt, ee.has_locations, ee.id, ee.exp_marker_term_nm, t.nm_html FROM EDIT.EXP_EVENT ee INNER JOIN EDIT.EXPOSURE e ON e.exp_event_id = ee.id AND e.reference_acc_txt NOT IN ('11874814', '12819278', '14527848', '12003754', '12948893') INNER JOIN edit.EXP_MARKER_TYPE emt ON ee.exp_marker_type_id = emt.id INNER JOIN edit.OBJECT_TYPE o ON emt.object_type_id = o.id LEFT OUTER JOIN pub2.TERM t ON ee.exp_marker_acc_txt = t.acc_txt AND o.id = t.object_type_id -- ON ee.exp_marker_term_id = t.id -- get where clause from errant query LEFT OUTER JOIN PUB2.MEDIUM m ON ee.medium_id = m.id LEFT OUTER JOIN PUB2.TERM mt ON m.term_acc_txt = mt.acc_txt AND m.term_object_type_id = mt.object_type_id -- LEFT OUTER JOIN PUB2.TERM mt ON m.term_acc_txt = mt.acc_txt -- WHERE e.reference_acc_txt NOT IN ('11874814','12819278','14527848','12003754','12948893') --and ee.exp_marker_acc_txt is not null AND ee.exp_marker_acc_txt <> '';

Date: 2024-03-13 14:00:18
Duration: 20s12ms

x Hide

Times Reported Time consuming queries #8

x Hide

select distinct phenotypeTerm.nm AS goNm, phenotypeTerm.nm_html AS goNmHtml, phenotypeTerm.acc_txt AS goAcc, diseaseTerm.nm AS diseaseNm, diseaseTerm.nm_html AS diseaseNmHtml, diseaseTerm.acc_txt AS diseaseAcc, diseaseTerm.acc_db_cd AS diseaseAccDbCd, chemTerm.nm AS chemNm, chemTerm.nm_html AS chemNmHtml, chemTerm.acc_txt AS chemAcc, geneTerm.nm AS geneSymbol, geneTerm.nm_html AS geneSymbolHtml, geneTerm.acc_txt AS geneAcc, COUNT(*) OVER () fullRowCount from PHENOTYPE_TERM_REFERENCE viaChemPTR, PHENOTYPE_TERM_REFERENCE viaGenePTR, TERM phenotypeTerm, TERM diseaseTerm, TERM geneTerm, TERM chemTerm where viaChemPTR.via_term_id IN ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 2 and upper(baseTerm.nm) LIKE 'ZINC')) and chemTerm.id IN ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 2 and upper(baseTerm.nm) LIKE 'ZINC')) and viaGenePTR.via_term_id IN ( select baseTerm.id from term baseTerm WHERE baseTerm.object_type_id = 4 and upper(baseTerm.nm) LIKE 'BCL2') and geneTerm.id IN ( select baseTerm.id from term baseTerm WHERE baseTerm.object_type_id = 4 and upper(baseTerm.nm) LIKE 'BCL2') and phenotypeTerm.id = ANY (ARRAY ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 5 and baseTerm.id in ( select object_id from db_link l where l.acc_txt = 'GO:0006915' AND l.type_cd = 'A' AND l.object_type_id = 5)))) and diseaseTerm.id = ANY (ARRAY ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 3 and upper(baseTerm.nm) LIKE 'NECROSIS'))) and viaChemPTR.phenotype_id = phenotypeTerm.id and viaChemPTR.term_object_type_id = 3 and viaChemPTR.term_id = diseaseTerm.id and viaChemPTR.via_term_object_type_id = 2 and viaChemPTR.via_term_id = chemTerm.id and viaChemPTR.term_id = viaGenePTR.term_id and viaChemPTR.phenotype_id = viaGenePTR.phenotype_id and viaGenePTR.via_term_object_type_id = 4 and viaGenePTR.via_term_id = geneTerm.id and exists ( select 1 from gene_chem_reference where gene_id = geneTerm.id and chem_id = chemTerm.id) GROUP BY phenotypeTerm.nm, phenotypeTerm.nm_html, phenotypeTerm.acc_txt, diseaseTerm.nm, diseaseTerm.nm_html, diseaseTerm.acc_txt, diseaseTerm.acc_db_cd, chemTerm.nm, chemTerm.nm_html, chemTerm.acc_txt, geneTerm.nm, geneTerm.nm_html, geneTerm.acc_txt order by chemTerm.nm LIMIT 50;

Date: 2024-03-13 05:49:11
Duration: 15s180ms
Bind query: yes