Times Reported Time consuming queries #1

x Hide

[ User: load - Total duration: 10m51s - Times executed: 18 ]

x Hide

select t.ID, t.OBJECT_TYPE_ID, t.ACC_TXT, db.CD, t.NM, t.NM_SORT, t.SECONDARY_NM, t.DESCRIPTION, t.NOTE, l.NM from load.TERM t, load.TERM_LABEL l, edit.DB db where t.object_type_id = 2 and t.id = l.term_id and t.acc_db_id = db.id;

Date: 2025-08-13 12:23:43
Duration: 52s914ms
Database: ctddev51
User: load
Bind query: yes

select t.ID, t.OBJECT_TYPE_ID, t.ACC_TXT, db.CD, t.NM, t.NM_SORT, t.SECONDARY_NM, t.DESCRIPTION, t.NOTE, l.NM from load.TERM t, load.TERM_LABEL l, edit.DB db where t.object_type_id = 2 and t.id = l.term_id and t.acc_db_id = db.id;

Date: 2025-08-13 12:10:51
Duration: 52s580ms
Database: ctddev51
User: load
Bind query: yes

select t.ID, t.OBJECT_TYPE_ID, t.ACC_TXT, db.CD, t.NM, t.NM_SORT, t.SECONDARY_NM, t.DESCRIPTION, t.NOTE, l.NM from load.TERM t, load.TERM_LABEL l, edit.DB db where t.object_type_id = 2 and t.id = l.term_id and t.acc_db_id = db.id;

Date: 2025-08-13 10:27:46
Duration: 51s196ms
Database: ctddev51
User: load
Bind query: yes

x Hide

Times Reported Time consuming queries #2

x Hide

SELECT /* ChemGODAO */ d.abbr dagAbbr, d.nm dagNm, gt.level_min_no dagLevelMin, gt.nm gonm, gt.nm_html gonmhtml, gt.acc_txt goacc, gt.object_id goid, te.corrected_p_val pValCorrected, te.raw_p_val pValRaw, te.target_match_qty targetmatchqty, te.target_total_qty targettotalqty, te.background_match_qty backgroundmatchqty, te.background_total_qty backgroundtotalqty, COUNT(*) OVER () fullRowCount FROM term_enrichment te INNER JOIN dag_node gt ON te.enriched_term_id = gt.object_id INNER JOIN dag d ON gt.dag_id = d.id WHERE te.term_id = '1284036' AND te.enriched_object_type_id = 5 ORDER BY te.corrected_p_val, d.abbr, gt.nm_sort LIMIT 50;

Date: 2025-08-14 11:22:30
Duration: 5s529ms
Bind query: yes

SELECT /* ChemGODAO */ d.abbr dagAbbr, d.nm dagNm, gt.level_min_no dagLevelMin, gt.nm gonm, gt.nm_html gonmhtml, gt.acc_txt goacc, gt.object_id goid, te.corrected_p_val pValCorrected, te.raw_p_val pValRaw, te.target_match_qty targetmatchqty, te.target_total_qty targettotalqty, te.background_match_qty backgroundmatchqty, te.background_total_qty backgroundtotalqty, COUNT(*) OVER () fullRowCount FROM term_enrichment te INNER JOIN dag_node gt ON te.enriched_term_id = gt.object_id INNER JOIN dag d ON gt.dag_id = d.id WHERE te.term_id = '1284036' AND te.enriched_object_type_id = 5 ORDER BY te.corrected_p_val, d.abbr, gt.nm_sort LIMIT 50;

Date: 2025-08-14 11:22:31
Duration: 5s138ms
Bind query: yes

SELECT /* ChemGODAO */ d.abbr dagAbbr, d.nm dagNm, gt.level_min_no dagLevelMin, gt.nm gonm, gt.nm_html gonmhtml, gt.acc_txt goacc, gt.object_id goid, te.corrected_p_val pValCorrected, te.raw_p_val pValRaw, te.target_match_qty targetmatchqty, te.target_total_qty targettotalqty, te.background_match_qty backgroundmatchqty, te.background_total_qty backgroundtotalqty, COUNT(*) OVER () fullRowCount FROM term_enrichment te INNER JOIN dag_node gt ON te.enriched_term_id = gt.object_id INNER JOIN dag d ON gt.dag_id = d.id WHERE te.term_id = '1284036' AND te.enriched_object_type_id = 5 ORDER BY te.corrected_p_val, d.abbr, gt.nm_sort LIMIT 50;

Date: 2025-08-14 11:22:28
Duration: 5s45ms
Bind query: yes

x Hide

Times Reported Time consuming queries #1

x Hide

[ User: load - Total duration: 10m51s - Times executed: 18 ]

x Hide

select t.ID, t.OBJECT_TYPE_ID, t.ACC_TXT, db.CD, t.NM, t.NM_SORT, t.SECONDARY_NM, t.DESCRIPTION, t.NOTE, l.NM from load.TERM t, load.TERM_LABEL l, edit.DB db where t.object_type_id = 2 and t.id = l.term_id and t.acc_db_id = db.id;

Date: 2025-08-13 12:23:43
Duration: 52s914ms
Database: ctddev51
User: load
Bind query: yes

select t.ID, t.OBJECT_TYPE_ID, t.ACC_TXT, db.CD, t.NM, t.NM_SORT, t.SECONDARY_NM, t.DESCRIPTION, t.NOTE, l.NM from load.TERM t, load.TERM_LABEL l, edit.DB db where t.object_type_id = 2 and t.id = l.term_id and t.acc_db_id = db.id;

Date: 2025-08-13 12:10:51
Duration: 52s580ms
Database: ctddev51
User: load
Bind query: yes

select t.ID, t.OBJECT_TYPE_ID, t.ACC_TXT, db.CD, t.NM, t.NM_SORT, t.SECONDARY_NM, t.DESCRIPTION, t.NOTE, l.NM from load.TERM t, load.TERM_LABEL l, edit.DB db where t.object_type_id = 2 and t.id = l.term_id and t.acc_db_id = db.id;

Date: 2025-08-13 10:27:46
Duration: 51s196ms
Database: ctddev51
User: load
Bind query: yes

x Hide

Times Reported Time consuming queries #2

x Hide

SELECT /* ChemGODAO */ d.abbr dagAbbr, d.nm dagNm, gt.level_min_no dagLevelMin, gt.nm gonm, gt.nm_html gonmhtml, gt.acc_txt goacc, gt.object_id goid, te.corrected_p_val pValCorrected, te.raw_p_val pValRaw, te.target_match_qty targetmatchqty, te.target_total_qty targettotalqty, te.background_match_qty backgroundmatchqty, te.background_total_qty backgroundtotalqty, COUNT(*) OVER () fullRowCount FROM term_enrichment te INNER JOIN dag_node gt ON te.enriched_term_id = gt.object_id INNER JOIN dag d ON gt.dag_id = d.id WHERE te.term_id = '1284036' AND te.enriched_object_type_id = 5 ORDER BY te.corrected_p_val, d.abbr, gt.nm_sort LIMIT 50;

Date: 2025-08-14 11:22:30
Duration: 5s529ms
Bind query: yes

SELECT /* ChemGODAO */ d.abbr dagAbbr, d.nm dagNm, gt.level_min_no dagLevelMin, gt.nm gonm, gt.nm_html gonmhtml, gt.acc_txt goacc, gt.object_id goid, te.corrected_p_val pValCorrected, te.raw_p_val pValRaw, te.target_match_qty targetmatchqty, te.target_total_qty targettotalqty, te.background_match_qty backgroundmatchqty, te.background_total_qty backgroundtotalqty, COUNT(*) OVER () fullRowCount FROM term_enrichment te INNER JOIN dag_node gt ON te.enriched_term_id = gt.object_id INNER JOIN dag d ON gt.dag_id = d.id WHERE te.term_id = '1284036' AND te.enriched_object_type_id = 5 ORDER BY te.corrected_p_val, d.abbr, gt.nm_sort LIMIT 50;

Date: 2025-08-14 11:22:31
Duration: 5s138ms
Bind query: yes

SELECT /* ChemGODAO */ d.abbr dagAbbr, d.nm dagNm, gt.level_min_no dagLevelMin, gt.nm gonm, gt.nm_html gonmhtml, gt.acc_txt goacc, gt.object_id goid, te.corrected_p_val pValCorrected, te.raw_p_val pValRaw, te.target_match_qty targetmatchqty, te.target_total_qty targettotalqty, te.background_match_qty backgroundmatchqty, te.background_total_qty backgroundtotalqty, COUNT(*) OVER () fullRowCount FROM term_enrichment te INNER JOIN dag_node gt ON te.enriched_term_id = gt.object_id INNER JOIN dag d ON gt.dag_id = d.id WHERE te.term_id = '1284036' AND te.enriched_object_type_id = 5 ORDER BY te.corrected_p_val, d.abbr, gt.nm_sort LIMIT 50;

Date: 2025-08-14 11:22:28
Duration: 5s45ms
Bind query: yes

x Hide

Times Reported Time consuming queries #1

x Hide

[ User: load - Total duration: 10m51s - Times executed: 18 ]

x Hide

select t.ID, t.OBJECT_TYPE_ID, t.ACC_TXT, db.CD, t.NM, t.NM_SORT, t.SECONDARY_NM, t.DESCRIPTION, t.NOTE, l.NM from load.TERM t, load.TERM_LABEL l, edit.DB db where t.object_type_id = 2 and t.id = l.term_id and t.acc_db_id = db.id;

Date: 2025-08-13 12:23:43
Duration: 52s914ms
Database: ctddev51
User: load
Bind query: yes

select t.ID, t.OBJECT_TYPE_ID, t.ACC_TXT, db.CD, t.NM, t.NM_SORT, t.SECONDARY_NM, t.DESCRIPTION, t.NOTE, l.NM from load.TERM t, load.TERM_LABEL l, edit.DB db where t.object_type_id = 2 and t.id = l.term_id and t.acc_db_id = db.id;

Date: 2025-08-13 12:10:51
Duration: 52s580ms
Database: ctddev51
User: load
Bind query: yes

select t.ID, t.OBJECT_TYPE_ID, t.ACC_TXT, db.CD, t.NM, t.NM_SORT, t.SECONDARY_NM, t.DESCRIPTION, t.NOTE, l.NM from load.TERM t, load.TERM_LABEL l, edit.DB db where t.object_type_id = 2 and t.id = l.term_id and t.acc_db_id = db.id;

Date: 2025-08-13 10:27:46
Duration: 51s196ms
Database: ctddev51
User: load
Bind query: yes

x Hide

Times Reported Time consuming queries #2

x Hide

SELECT /* ChemGODAO */ d.abbr dagAbbr, d.nm dagNm, gt.level_min_no dagLevelMin, gt.nm gonm, gt.nm_html gonmhtml, gt.acc_txt goacc, gt.object_id goid, te.corrected_p_val pValCorrected, te.raw_p_val pValRaw, te.target_match_qty targetmatchqty, te.target_total_qty targettotalqty, te.background_match_qty backgroundmatchqty, te.background_total_qty backgroundtotalqty, COUNT(*) OVER () fullRowCount FROM term_enrichment te INNER JOIN dag_node gt ON te.enriched_term_id = gt.object_id INNER JOIN dag d ON gt.dag_id = d.id WHERE te.term_id = '1284036' AND te.enriched_object_type_id = 5 ORDER BY te.corrected_p_val, d.abbr, gt.nm_sort LIMIT 50;

Date: 2025-08-14 11:22:30
Duration: 5s529ms
Bind query: yes

SELECT /* ChemGODAO */ d.abbr dagAbbr, d.nm dagNm, gt.level_min_no dagLevelMin, gt.nm gonm, gt.nm_html gonmhtml, gt.acc_txt goacc, gt.object_id goid, te.corrected_p_val pValCorrected, te.raw_p_val pValRaw, te.target_match_qty targetmatchqty, te.target_total_qty targettotalqty, te.background_match_qty backgroundmatchqty, te.background_total_qty backgroundtotalqty, COUNT(*) OVER () fullRowCount FROM term_enrichment te INNER JOIN dag_node gt ON te.enriched_term_id = gt.object_id INNER JOIN dag d ON gt.dag_id = d.id WHERE te.term_id = '1284036' AND te.enriched_object_type_id = 5 ORDER BY te.corrected_p_val, d.abbr, gt.nm_sort LIMIT 50;

Date: 2025-08-14 11:22:31
Duration: 5s138ms
Bind query: yes

SELECT /* ChemGODAO */ d.abbr dagAbbr, d.nm dagNm, gt.level_min_no dagLevelMin, gt.nm gonm, gt.nm_html gonmhtml, gt.acc_txt goacc, gt.object_id goid, te.corrected_p_val pValCorrected, te.raw_p_val pValRaw, te.target_match_qty targetmatchqty, te.target_total_qty targettotalqty, te.background_match_qty backgroundmatchqty, te.background_total_qty backgroundtotalqty, COUNT(*) OVER () fullRowCount FROM term_enrichment te INNER JOIN dag_node gt ON te.enriched_term_id = gt.object_id INNER JOIN dag d ON gt.dag_id = d.id WHERE te.term_id = '1284036' AND te.enriched_object_type_id = 5 ORDER BY te.corrected_p_val, d.abbr, gt.nm_sort LIMIT 50;

Date: 2025-08-14 11:22:28
Duration: 5s45ms
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: column "term_id" does not exist at character 60

Statement: select * from term_label_type where object_type_id = 2 and term_id = 2116706 order by id

Date: 2025-08-12 08:51:19
Database: ctddev51
Application: pgAdmin 4 - CONN:6137117
User: edit
Remote: 

ERROR: column "term_id" does not exist at character 55

Statement: select * from term_label where object_type_id = 2 and term_id = 2116706 order by id

Date: 2025-08-12 08:51:29

ERROR: column "object_type_id" does not exist at character 37

Statement: select * from load.term_label where object_type_id = 2 and term_id = 2116706 order by id

Date: 2025-08-12 08:52:15

x Hide

Times Reported Most Frequent Error / Event #4

x Hide

ERROR: missing FROM-clause entry for table "n" at character 36

Statement: SELECT * FROM pubc.news_item WHERE n.start_tm <= CURRENT_TIMESTAMP AND n.end_tm >= CURRENT_TIMESTAMP

Date: 2025-08-12 11:15:27
Database: ctddev51
Application: pgAdmin 4 - CONN:7464580
User: pubeu
Remote: 

x Hide

Times Reported Most Frequent Error / Event #5

x Hide

LOG: could not send data to client: Connection reset by peer

Statement: select t.ID ,t.OBJECT_TYPE_ID ,t.ACC_TXT ,db.CD ,t.NM ,t.NM_SORT ,t.SECONDARY_NM ,t.DESCRIPTION ,t.NOTE ,l.NM from load.TERM t ,load.TERM_LABEL l ,edit.DB db where t.object_type_id = 2 and t.id = l.term_id and t.acc_db_id = db.id

Date: 2025-08-11 14:27:44
Database: ctddev51
Application: 
User: load
Remote: 

x Hide

Times Reported Most Frequent Error / Event #6

x Hide

ERROR: current transaction is aborted, commands ignored until end of transaction block

Statement: select * from term_label_type where id = 36

Date: 2025-08-12 10:29:21

x Hide

Times Reported Most Frequent Error / Event #7

x Hide

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

Statement: elect count(*) from exp_event WHERE detection_limit = '' OR detection_limit_uom = '' OR detection_freq = '' OR exp_marker_term_nm = '' OR exp_marker_acc_txt = '' OR exp_marker_lvl = '' OR note = '' OR assay_note = '' OR assay_uom = '' OR assay_measurement_stat = '';

Date: 2025-08-13 10:03:53
Database: ctddev51
Application: pgAdmin 4 - CONN:8322130
User: edit
Remote: 

x Hide

Times Reported Most Frequent Error / Event #8

x Hide

ERROR: permission denied for table term_label

Statement: begin transaction; delete from load.term_label where term_id = 2116706 and term_label_type_id in ( 35, 36 )

Date: 2025-08-12 10:15:51

x Hide

Times Reported Most Frequent Error / Event #9

x Hide

FATAL: connection to client lost

Statement: select t.ID ,t.OBJECT_TYPE_ID ,t.ACC_TXT ,db.CD ,t.NM ,t.NM_SORT ,t.SECONDARY_NM ,t.DESCRIPTION ,t.NOTE ,l.NM from load.TERM t ,load.TERM_LABEL l ,edit.DB db where t.object_type_id = 2 and t.id = l.term_id and t.acc_db_id = db.id

Date: 2025-08-11 14:27:44

x Hide

Times Reported Most Frequent Error / Event #10

x Hide

FATAL: terminating background worker "parallel worker" due to administrator command

Statement: select t.ID ,t.OBJECT_TYPE_ID ,t.ACC_TXT ,db.CD ,t.NM ,t.NM_SORT ,t.SECONDARY_NM ,t.DESCRIPTION ,t.NOTE ,l.NM from load.TERM t ,load.TERM_LABEL l ,edit.DB db where t.object_type_id = 2 and t.id = l.term_id and t.acc_db_id = db.id

Date: 2025-08-11 14:27:44

x Hide

Times Reported Most Frequent Error / Event #11

x Hide

x Hide