Times Reported Time consuming queries #1

x Hide

[ User: edit - Total duration: 21s152ms - Times executed: 2 ]

x Hide

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

Date: 2025-12-02 13:46:26
Duration: 1m14s
Bind query: yes

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

Date: 2025-12-02 08:44:00
Duration: 57s371ms
Bind query: yes

select ID, OBJECT_TYPE_ID, ACC_TXT, t.ACC_DB_ID, NM, NM_SORT, SECONDARY_NM, DESCRIPTION, NOTE from load.term t where object_type_id = 2;

Date: 2025-12-02 08:43:01
Duration: 10s843ms
Database: ctddev51
User: edit
Bind query: yes

x Hide

Times Reported Time consuming queries #2

x Hide

select DISTINCT ri.reference_acc_txt, iaChem.acc_txt, at.cd, iaDisease.acc_txt, ri.taxon_acc_txt, i.root_id, chemTerm.nm, diseaseTerm.nm, ( SELECT STRING_AGG(DISTINCT iq.nm, '|')) from edit.IXN i INNER JOIN edit.IXN_ACTOR iaChem ON i.root_id = iaChem.ixn_id INNER JOIN edit.IXN_ACTOR iaDisease ON i.root_id = iaDisease.ixn_id INNER JOIN edit.IXN_ACTION iAct ON i.root_id = iAct.ixn_id INNER JOIN edit.ACTION_TYPE at ON iAct.action_type_id = at.id INNER JOIN edit.REFERENCE_IXN ri ON i.root_id = ri.ixn_id INNER JOIN pub2.TERM chemTerm ON iaChem.acc_txt = chemTerm.acc_txt and chemTerm.object_type_id = 2 INNER JOIN pub2.TERM diseaseTerm ON iaDisease.acc_txt = diseaseTerm.acc_txt and diseaseTerm.object_type_id = 3 LEFT OUTER JOIN edit.REFERENCE_IXN_QUALIFIER riq ON ri.id = riq.reference_ixn_id LEFT OUTER JOIN edit.IXN_QUALIFIER iq ON riq.ixn_qualifier_id = iq.id where i.ixn_type_id = 2 and iaChem.object_type_id = 2 and iaDisease.object_type_id = 3 group by ri.reference_acc_txt, iaChem.acc_txt, at.cd, iaDisease.acc_txt, ri.taxon_acc_txt, i.root_id, chemTerm.nm, diseaseTerm.nm;

Date: 2025-12-02 13:46:42
Duration: 13s779ms
Bind query: yes

select DISTINCT ri.reference_acc_txt, iaChem.acc_txt, at.cd, iaDisease.acc_txt, ri.taxon_acc_txt, i.root_id, chemTerm.nm, diseaseTerm.nm, ( SELECT STRING_AGG(DISTINCT iq.nm, '|')) from edit.IXN i INNER JOIN edit.IXN_ACTOR iaChem ON i.root_id = iaChem.ixn_id INNER JOIN edit.IXN_ACTOR iaDisease ON i.root_id = iaDisease.ixn_id INNER JOIN edit.IXN_ACTION iAct ON i.root_id = iAct.ixn_id INNER JOIN edit.ACTION_TYPE at ON iAct.action_type_id = at.id INNER JOIN edit.REFERENCE_IXN ri ON i.root_id = ri.ixn_id INNER JOIN pub2.TERM chemTerm ON iaChem.acc_txt = chemTerm.acc_txt and chemTerm.object_type_id = 2 INNER JOIN pub2.TERM diseaseTerm ON iaDisease.acc_txt = diseaseTerm.acc_txt and diseaseTerm.object_type_id = 3 LEFT OUTER JOIN edit.REFERENCE_IXN_QUALIFIER riq ON ri.id = riq.reference_ixn_id LEFT OUTER JOIN edit.IXN_QUALIFIER iq ON riq.ixn_qualifier_id = iq.id where i.ixn_type_id = 2 and iaChem.object_type_id = 2 and iaDisease.object_type_id = 3 group by ri.reference_acc_txt, iaChem.acc_txt, at.cd, iaDisease.acc_txt, ri.taxon_acc_txt, i.root_id, chemTerm.nm, diseaseTerm.nm;

Date: 2025-12-02 08:44:12
Duration: 11s105ms
Bind query: yes

x Hide

Times Reported Time consuming queries #3

x Hide

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

x Hide

SELECT /* DiseasePathwayAssnsDAO */ d.nm diseasenm, d.acc_txt diseaseacc, d.acc_db_cd diseaseaccdbcd, d.id diseaseid, tp.pathway_nm pathwaynm, tp.pathway_acc_db_cd pathwayaccdbcd, tp.pathway_acc_txt pathwayacc, tp.pathway_id pathwayId, COUNT(gd.gene_id) inferredCount, COUNT(*) OVER () fullRowCount FROM gene_disease gd INNER JOIN term_pathway tp ON gd.gene_id = tp.term_id INNER JOIN term d ON gd.disease_id = d.id WHERE tp.object_type_id = 4 AND gd.curated_reference_qty > 0 AND tp.pathway_id = '2125620' GROUP BY d.nm, d.nm_sort, d.acc_txt, d.acc_db_cd, d.id, tp.pathway_nm, tp.pathway_acc_db_cd, tp.pathway_acc_txt, tp.pathway_id ORDER BY COUNT(gd.gene_id) DESC, tp.pathway_nm, d.nm_sort LIMIT 50;

Date: 2025-12-05 13:31:47
Duration: 5s549ms
Database: ctddev51
User: pubeu
Bind query: yes

x Hide

Times Reported Time consuming queries #1

x Hide

[ User: edit - Total duration: 21s152ms - Times executed: 2 ]

x Hide

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

Date: 2025-12-02 13:46:26
Duration: 1m14s
Bind query: yes

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

Date: 2025-12-02 08:44:00
Duration: 57s371ms
Bind query: yes

select ID, OBJECT_TYPE_ID, ACC_TXT, t.ACC_DB_ID, NM, NM_SORT, SECONDARY_NM, DESCRIPTION, NOTE from load.term t where object_type_id = 2;

Date: 2025-12-02 08:43:01
Duration: 10s843ms
Database: ctddev51
User: edit
Bind query: yes

x Hide

Times Reported Time consuming queries #2

x Hide

select DISTINCT ri.reference_acc_txt, iaChem.acc_txt, at.cd, iaDisease.acc_txt, ri.taxon_acc_txt, i.root_id, chemTerm.nm, diseaseTerm.nm, ( SELECT STRING_AGG(DISTINCT iq.nm, '|')) from edit.IXN i INNER JOIN edit.IXN_ACTOR iaChem ON i.root_id = iaChem.ixn_id INNER JOIN edit.IXN_ACTOR iaDisease ON i.root_id = iaDisease.ixn_id INNER JOIN edit.IXN_ACTION iAct ON i.root_id = iAct.ixn_id INNER JOIN edit.ACTION_TYPE at ON iAct.action_type_id = at.id INNER JOIN edit.REFERENCE_IXN ri ON i.root_id = ri.ixn_id INNER JOIN pub2.TERM chemTerm ON iaChem.acc_txt = chemTerm.acc_txt and chemTerm.object_type_id = 2 INNER JOIN pub2.TERM diseaseTerm ON iaDisease.acc_txt = diseaseTerm.acc_txt and diseaseTerm.object_type_id = 3 LEFT OUTER JOIN edit.REFERENCE_IXN_QUALIFIER riq ON ri.id = riq.reference_ixn_id LEFT OUTER JOIN edit.IXN_QUALIFIER iq ON riq.ixn_qualifier_id = iq.id where i.ixn_type_id = 2 and iaChem.object_type_id = 2 and iaDisease.object_type_id = 3 group by ri.reference_acc_txt, iaChem.acc_txt, at.cd, iaDisease.acc_txt, ri.taxon_acc_txt, i.root_id, chemTerm.nm, diseaseTerm.nm;

Date: 2025-12-02 13:46:42
Duration: 13s779ms
Bind query: yes

select DISTINCT ri.reference_acc_txt, iaChem.acc_txt, at.cd, iaDisease.acc_txt, ri.taxon_acc_txt, i.root_id, chemTerm.nm, diseaseTerm.nm, ( SELECT STRING_AGG(DISTINCT iq.nm, '|')) from edit.IXN i INNER JOIN edit.IXN_ACTOR iaChem ON i.root_id = iaChem.ixn_id INNER JOIN edit.IXN_ACTOR iaDisease ON i.root_id = iaDisease.ixn_id INNER JOIN edit.IXN_ACTION iAct ON i.root_id = iAct.ixn_id INNER JOIN edit.ACTION_TYPE at ON iAct.action_type_id = at.id INNER JOIN edit.REFERENCE_IXN ri ON i.root_id = ri.ixn_id INNER JOIN pub2.TERM chemTerm ON iaChem.acc_txt = chemTerm.acc_txt and chemTerm.object_type_id = 2 INNER JOIN pub2.TERM diseaseTerm ON iaDisease.acc_txt = diseaseTerm.acc_txt and diseaseTerm.object_type_id = 3 LEFT OUTER JOIN edit.REFERENCE_IXN_QUALIFIER riq ON ri.id = riq.reference_ixn_id LEFT OUTER JOIN edit.IXN_QUALIFIER iq ON riq.ixn_qualifier_id = iq.id where i.ixn_type_id = 2 and iaChem.object_type_id = 2 and iaDisease.object_type_id = 3 group by ri.reference_acc_txt, iaChem.acc_txt, at.cd, iaDisease.acc_txt, ri.taxon_acc_txt, i.root_id, chemTerm.nm, diseaseTerm.nm;

Date: 2025-12-02 08:44:12
Duration: 11s105ms
Bind query: yes

x Hide

Times Reported Time consuming queries #3

x Hide

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

x Hide

SELECT /* DiseasePathwayAssnsDAO */ d.nm diseasenm, d.acc_txt diseaseacc, d.acc_db_cd diseaseaccdbcd, d.id diseaseid, tp.pathway_nm pathwaynm, tp.pathway_acc_db_cd pathwayaccdbcd, tp.pathway_acc_txt pathwayacc, tp.pathway_id pathwayId, COUNT(gd.gene_id) inferredCount, COUNT(*) OVER () fullRowCount FROM gene_disease gd INNER JOIN term_pathway tp ON gd.gene_id = tp.term_id INNER JOIN term d ON gd.disease_id = d.id WHERE tp.object_type_id = 4 AND gd.curated_reference_qty > 0 AND tp.pathway_id = '2125620' GROUP BY d.nm, d.nm_sort, d.acc_txt, d.acc_db_cd, d.id, tp.pathway_nm, tp.pathway_acc_db_cd, tp.pathway_acc_txt, tp.pathway_id ORDER BY COUNT(gd.gene_id) DESC, tp.pathway_nm, d.nm_sort LIMIT 50;

Date: 2025-12-05 13:31:47
Duration: 5s549ms
Database: ctddev51
User: pubeu
Bind query: yes

x Hide

Times Reported Time consuming queries #1

x Hide

[ User: edit - Total duration: 21s152ms - Times executed: 2 ]

x Hide

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

Date: 2025-12-02 13:46:26
Duration: 1m14s
Bind query: yes

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

Date: 2025-12-02 08:44:00
Duration: 57s371ms
Bind query: yes

select ID, OBJECT_TYPE_ID, ACC_TXT, t.ACC_DB_ID, NM, NM_SORT, SECONDARY_NM, DESCRIPTION, NOTE from load.term t where object_type_id = 2;

Date: 2025-12-02 08:43:01
Duration: 10s843ms
Database: ctddev51
User: edit
Bind query: yes

x Hide

Times Reported Time consuming queries #2

x Hide

select DISTINCT ri.reference_acc_txt, iaChem.acc_txt, at.cd, iaDisease.acc_txt, ri.taxon_acc_txt, i.root_id, chemTerm.nm, diseaseTerm.nm, ( SELECT STRING_AGG(DISTINCT iq.nm, '|')) from edit.IXN i INNER JOIN edit.IXN_ACTOR iaChem ON i.root_id = iaChem.ixn_id INNER JOIN edit.IXN_ACTOR iaDisease ON i.root_id = iaDisease.ixn_id INNER JOIN edit.IXN_ACTION iAct ON i.root_id = iAct.ixn_id INNER JOIN edit.ACTION_TYPE at ON iAct.action_type_id = at.id INNER JOIN edit.REFERENCE_IXN ri ON i.root_id = ri.ixn_id INNER JOIN pub2.TERM chemTerm ON iaChem.acc_txt = chemTerm.acc_txt and chemTerm.object_type_id = 2 INNER JOIN pub2.TERM diseaseTerm ON iaDisease.acc_txt = diseaseTerm.acc_txt and diseaseTerm.object_type_id = 3 LEFT OUTER JOIN edit.REFERENCE_IXN_QUALIFIER riq ON ri.id = riq.reference_ixn_id LEFT OUTER JOIN edit.IXN_QUALIFIER iq ON riq.ixn_qualifier_id = iq.id where i.ixn_type_id = 2 and iaChem.object_type_id = 2 and iaDisease.object_type_id = 3 group by ri.reference_acc_txt, iaChem.acc_txt, at.cd, iaDisease.acc_txt, ri.taxon_acc_txt, i.root_id, chemTerm.nm, diseaseTerm.nm;

Date: 2025-12-02 13:46:42
Duration: 13s779ms
Bind query: yes

select DISTINCT ri.reference_acc_txt, iaChem.acc_txt, at.cd, iaDisease.acc_txt, ri.taxon_acc_txt, i.root_id, chemTerm.nm, diseaseTerm.nm, ( SELECT STRING_AGG(DISTINCT iq.nm, '|')) from edit.IXN i INNER JOIN edit.IXN_ACTOR iaChem ON i.root_id = iaChem.ixn_id INNER JOIN edit.IXN_ACTOR iaDisease ON i.root_id = iaDisease.ixn_id INNER JOIN edit.IXN_ACTION iAct ON i.root_id = iAct.ixn_id INNER JOIN edit.ACTION_TYPE at ON iAct.action_type_id = at.id INNER JOIN edit.REFERENCE_IXN ri ON i.root_id = ri.ixn_id INNER JOIN pub2.TERM chemTerm ON iaChem.acc_txt = chemTerm.acc_txt and chemTerm.object_type_id = 2 INNER JOIN pub2.TERM diseaseTerm ON iaDisease.acc_txt = diseaseTerm.acc_txt and diseaseTerm.object_type_id = 3 LEFT OUTER JOIN edit.REFERENCE_IXN_QUALIFIER riq ON ri.id = riq.reference_ixn_id LEFT OUTER JOIN edit.IXN_QUALIFIER iq ON riq.ixn_qualifier_id = iq.id where i.ixn_type_id = 2 and iaChem.object_type_id = 2 and iaDisease.object_type_id = 3 group by ri.reference_acc_txt, iaChem.acc_txt, at.cd, iaDisease.acc_txt, ri.taxon_acc_txt, i.root_id, chemTerm.nm, diseaseTerm.nm;

Date: 2025-12-02 08:44:12
Duration: 11s105ms
Bind query: yes

x Hide

Times Reported Time consuming queries #3

x Hide

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

x Hide

SELECT /* DiseasePathwayAssnsDAO */ d.nm diseasenm, d.acc_txt diseaseacc, d.acc_db_cd diseaseaccdbcd, d.id diseaseid, tp.pathway_nm pathwaynm, tp.pathway_acc_db_cd pathwayaccdbcd, tp.pathway_acc_txt pathwayacc, tp.pathway_id pathwayId, COUNT(gd.gene_id) inferredCount, COUNT(*) OVER () fullRowCount FROM gene_disease gd INNER JOIN term_pathway tp ON gd.gene_id = tp.term_id INNER JOIN term d ON gd.disease_id = d.id WHERE tp.object_type_id = 4 AND gd.curated_reference_qty > 0 AND tp.pathway_id = '2125620' GROUP BY d.nm, d.nm_sort, d.acc_txt, d.acc_db_cd, d.id, tp.pathway_nm, tp.pathway_acc_db_cd, tp.pathway_acc_txt, tp.pathway_id ORDER BY COUNT(gd.gene_id) DESC, tp.pathway_nm, d.nm_sort LIMIT 50;

Date: 2025-12-05 13:31:47
Duration: 5s549ms
Database: ctddev51
User: pubeu
Bind query: yes

x Hide

Times Reported Most Frequent Error / Event #1

x Hide

x Hide

Times Reported Most Frequent Error / Event #2

x Hide

x Hide

Times Reported Most Frequent Error / Event #3

x Hide

ERROR: syntax error at or near "10" at character 32

Statement: select * from log_query lilmit 10

Date: 2025-12-01 15:40:36
Database: ctddev51
Application: pgAdmin 4 - CONN:2027954
User: pubc
Remote: 

ERROR: syntax error at or near "ELECT" at character 1

Statement: ELECT /* ChemGeneIxnsDAO */ g.nm geneSymbol ,g.acc_txt geneAcc ,g.acc_db_cd geneAccDbCd ,g.id geneId ,c.nm chemnm ,c.nm_html chemnmhtml ,c.acc_txt chemacc ,c.secondary_nm casRN ,c.id chemId ,i.ixn_prose_txt ixnProse ,i.ixn_prose_html ixnProseHtml ,i.actions_txt ixnActions ,i.id ixnId ,COUNT(DISTINCT gcr.reference_id) refCount ,COUNT(DISTINCT gcr.taxon_id) taxonCount ,COUNT(*) OVER() fullRowCount FROM gene_chem_reference gcr INNER JOIN ixn i ON gcr.ixn_id = i.id INNER JOIN term g ON gcr.gene_id = g.id INNER JOIN term c ON gcr.chem_id = c.id WHERE gcr.chem_id IN (SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = $1) GROUP BY g.nm ,g.nm_sort ,g.acc_txt ,g.acc_db_cd ,g.id ,c.nm ,c.nm_html ,c.nm_sort ,c.acc_txt ,c.id ,i.ixn_prose_txt ,i.ixn_prose_html ,i.sort_txt ,i.actions_txt ,i.id ORDER BY g.nm_sort ,c.nm_sort ,i.sort_txt LIMIT 50

Date: 2025-12-03 12:04:30
Database: ctddev51
Application: 
User: qaeu
Remote: 

ERROR: syntax error at or near "ELECT" at character 1

Statement: ELECT /* ChemGeneIxnsDAO */ g.nm geneSymbol ,g.acc_txt geneAcc ,g.acc_db_cd geneAccDbCd ,g.id geneId ,c.nm chemnm ,c.nm_html chemnmhtml ,c.acc_txt chemacc ,c.secondary_nm casRN ,c.id chemId ,i.ixn_prose_txt ixnProse ,i.ixn_prose_html ixnProseHtml ,i.actions_txt ixnActions ,i.id ixnId ,COUNT(DISTINCT gcr.reference_id) refCount ,COUNT(DISTINCT gcr.taxon_id) taxonCount ,( SELECT STRING_AGG( distinct taxonTerm.nm || '^' || 'taxon' || '^' || taxonTerm.nm_html || '^' || taxonTerm.acc_txt || '^' || taxonTerm.acc_db_cd || '^' || COALESCE( taxonTerm.secondary_nm, '' ) ,'|' ) ) as taxonTerms ,( SELECT STRING_AGG( distinct r.acc_txt,'|' ) ) as references ,COUNT(*) OVER() fullRowCount FROM gene_chem_reference gcr INNER JOIN ixn i ON gcr.ixn_id = i.id INNER JOIN term g ON gcr.gene_id = g.id INNER JOIN term c ON gcr.chem_id = c.id WHERE gcr.chem_id IN (SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = $1) GROUP BY g.nm ,g.nm_sort ,g.acc_txt ,g.acc_db_cd ,g.id ,c.nm ,c.nm_html ,c.nm_sort ,c.acc_txt ,c.id ,i.ixn_prose_txt ,i.ixn_prose_html ,i.sort_txt ,i.actions_txt ,i.id ORDER BY g.nm_sort ,c.nm_sort ,i.sort_txt LIMIT 50

Date: 2025-12-05 16:09:50
Database: ctddev51
Application: 
User: qaeu
Remote: 

x Hide

Times Reported Most Frequent Error / Event #4

x Hide

ERROR: column "exp_marker_level" does not exist at character 17

Hint: Perhaps you meant to reference the column "exp_event.exp_marker_lvl".
Statement: select distinct(exp_marker_level) from exp_event

Date: 2025-12-04 15:00:01
Database: ctddev51
Application: pgAdmin 4 - CONN:8848835
User: pub1
Remote: 

x Hide

Times Reported Most Frequent Error / Event #5

x Hide

ERROR: missing FROM-clause entry for table "taxonterm" at character 440

Statement: SELECT /* ChemGeneIxnsDAO */ g.nm geneSymbol ,g.acc_txt geneAcc ,g.acc_db_cd geneAccDbCd ,g.id geneId ,c.nm chemnm ,c.nm_html chemnmhtml ,c.acc_txt chemacc ,c.secondary_nm casRN ,c.id chemId ,i.ixn_prose_txt ixnProse ,i.ixn_prose_html ixnProseHtml ,i.actions_txt ixnActions ,i.id ixnId ,COUNT(DISTINCT gcr.reference_id) refCount ,COUNT(DISTINCT gcr.taxon_id) taxonCount ,( SELECT STRING_AGG( distinct taxonTerm.nm || '^' || 'taxon' || '^' || taxonTerm.nm_html || '^' || taxonTerm.acc_txt || '^' || taxonTerm.acc_db_cd || '^' || COALESCE( taxonTerm.secondary_nm, '' ) ,'|' ) ) as taxonTerms ,( SELECT STRING_AGG( distinct r.acc_txt,'|' ) ) as references ,COUNT(*) OVER() fullRowCount FROM gene_chem_reference gcr INNER JOIN ixn i ON gcr.ixn_id = i.id INNER JOIN term g ON gcr.gene_id = g.id INNER JOIN term c ON gcr.chem_id = c.id WHERE gcr.chem_id IN (SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = $1) GROUP BY g.nm ,g.nm_sort ,g.acc_txt ,g.acc_db_cd ,g.id ,c.nm ,c.nm_html ,c.nm_sort ,c.acc_txt ,c.id ,i.ixn_prose_txt ,i.ixn_prose_html ,i.sort_txt ,i.actions_txt ,i.id ORDER BY g.nm_sort ,c.nm_sort ,i.sort_txt LIMIT 50

Date: 2025-12-05 16:12:31
Database: ctddev51
Application: 
User: qaeu
Remote: 

x Hide