Times Reported Time consuming queries #1

x Hide

[ User: pubeu - Total duration: 47m4s - Times executed: 1 ]

x Hide

SELECT /* AdvancedGeneQueryDAO.getData */ g.id geneId, g.acc_txt acc, g.nm nm, g.nm nmHtml, g.secondary_nm secondaryNm, g.has_chems hasChems, g.has_diseases hasDiseases, g.has_exposures hasExposures, g.has_phenotypes hasPhenotypes, COUNT(*) OVER () fullRowCount FROM term g WHERE g.id IN ( SELECT gcr.gene_id FROM gene_chem_reference gcr WHERE /* CIQH.getIxnWhereCore */ EXISTS ( SELECT /* CIQH.getIxnGeneFormTypeWhere */ 1 FROM gene_chem_ref_gene_form gf WHERE gf.gene_chem_reference_id = gcr.id AND gf.gene_id = gcr.gene_id AND gf.actor_form_type_nm IN ( SELECT tc.nm FROM actor_form_type tp, actor_form_type tc WHERE tc.subset_left_no BETWEEN tp.subset_left_no AND tp.subset_right_no AND (tp.nm = 'mRNA'))) AND gcr.gene_id = ANY (ARRAY (( SELECT /* IQH.getMasterDiseaseWhereEquals.Name.Gene */ gd.gene_id FROM term t INNER JOIN dag_path dp ON t.id = dp.ancestor_object_id INNER JOIN gene_disease gd ON dp.descendant_object_id = gd.disease_id WHERE UPPER(t.nm) LIKE 'OSTEOPOROSIS' AND t.object_type_id = 3 AND gd.curated_reference_qty > 0)))) ORDER BY g.nm_sort, g.id LIMIT 50;

Date: 2025-10-10 12:48:49
Duration: 47m4s
Database: ctdprd51
User: pubeu
Bind query: yes

x Hide

Times Reported Time consuming queries #2

x Hide

[ User: pubeu - Total duration: 8m34s - Times executed: 10 ]

x Hide

SELECT /* BatchChemGODAO */ 'd001152' "Input", sqi.chem_nm "ChemicalName", sqi.chem_acc_txt "ChemicalID", sqi.casRN "CasRN", sqi.gene_symbol "GeneSymbol", sqi.gene_acc_txt "GeneID", sqi.ontology_nm "Ontology", sqi.go_term_nm "GoTermName", sqi.go_acc_txt "GoTermID" FROM ( WITH sq AS ( SELECT DISTINCT c.id chem_id, c.nm chem_nm, c.acc_txt chem_acc_txt, c.secondary_nm casRN, c.nm_sort chem_nm_sort, gcr.gene_id, g.nm gene_symbol, g.acc_txt gene_acc_txt, g.nm_sort gene_symbol_sort FROM term c INNER JOIN gene_chem_reference gcr ON c.id = gcr.chem_id INNER JOIN term g ON gcr.gene_id = g.id WHERE c.id in ( select distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id = 1354580)) SELECT DISTINCT sq.chem_nm, sq.chem_acc_txt, sq.casRN, sq.gene_symbol, sq.gene_acc_txt, gt.nm go_term_nm, gt.acc_txt go_acc_txt, sq.chem_nm_sort, sq.gene_symbol_sort, gt.nm_sort, d.nm ontology_nm FROM sq INNER JOIN gene_go_annot gga ON sq.gene_id = gga.gene_id INNER JOIN dag_node gt ON gga.go_term_id = gt.object_id INNER JOIN dag d ON gt.dag_id = d.id WHERE gga.is_not = false ORDER BY sq.chem_nm_sort, sq.gene_symbol_sort, d.nm, gt.nm_sort) sqi;

Date: 2025-10-10 02:08:25
Duration: 1m57s
Database: ctdprd51
User: pubeu
Bind query: yes

SELECT /* BatchChemGODAO */ 'arsenicals' "Input", sqi.chem_nm "ChemicalName", sqi.chem_acc_txt "ChemicalID", sqi.casRN "CasRN", sqi.gene_symbol "GeneSymbol", sqi.gene_acc_txt "GeneID", sqi.ontology_nm "Ontology", sqi.go_term_nm "GoTermName", sqi.go_acc_txt "GoTermID" FROM ( WITH sq AS ( SELECT DISTINCT c.id chem_id, c.nm chem_nm, c.acc_txt chem_acc_txt, c.secondary_nm casRN, c.nm_sort chem_nm_sort, gcr.gene_id, g.nm gene_symbol, g.acc_txt gene_acc_txt, g.nm_sort gene_symbol_sort FROM term c INNER JOIN gene_chem_reference gcr ON c.id = gcr.chem_id INNER JOIN term g ON gcr.gene_id = g.id WHERE c.id in ( select distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id = 1354580)) SELECT DISTINCT sq.chem_nm, sq.chem_acc_txt, sq.casRN, sq.gene_symbol, sq.gene_acc_txt, gt.nm go_term_nm, gt.acc_txt go_acc_txt, sq.chem_nm_sort, sq.gene_symbol_sort, gt.nm_sort, d.nm ontology_nm FROM sq INNER JOIN gene_go_annot gga ON sq.gene_id = gga.gene_id INNER JOIN dag_node gt ON gga.go_term_id = gt.object_id INNER JOIN dag d ON gt.dag_id = d.id WHERE gga.is_not = false ORDER BY sq.chem_nm_sort, sq.gene_symbol_sort, d.nm, gt.nm_sort) sqi;

Date: 2025-10-10 03:05:51
Duration: 1m56s
Database: ctdprd51
User: pubeu
Bind query: yes

SELECT /* BatchChemGODAO */ 'arsenicals' "Input", sqi.chem_nm "ChemicalName", sqi.chem_acc_txt "ChemicalID", sqi.casRN "CasRN", sqi.gene_symbol "GeneSymbol", sqi.gene_acc_txt "GeneID", sqi.ontology_nm "Ontology", sqi.go_term_nm "GoTermName", sqi.go_acc_txt "GoTermID" FROM ( WITH sq AS ( SELECT DISTINCT c.id chem_id, c.nm chem_nm, c.acc_txt chem_acc_txt, c.secondary_nm casRN, c.nm_sort chem_nm_sort, gcr.gene_id, g.nm gene_symbol, g.acc_txt gene_acc_txt, g.nm_sort gene_symbol_sort FROM term c INNER JOIN gene_chem_reference gcr ON c.id = gcr.chem_id INNER JOIN term g ON gcr.gene_id = g.id WHERE c.id in ( select distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id = 1354580)) SELECT DISTINCT sq.chem_nm, sq.chem_acc_txt, sq.casRN, sq.gene_symbol, sq.gene_acc_txt, gt.nm go_term_nm, gt.acc_txt go_acc_txt, sq.chem_nm_sort, sq.gene_symbol_sort, gt.nm_sort, d.nm ontology_nm FROM sq INNER JOIN gene_go_annot gga ON sq.gene_id = gga.gene_id INNER JOIN dag_node gt ON gga.go_term_id = gt.object_id INNER JOIN dag d ON gt.dag_id = d.id WHERE gga.is_not = false ORDER BY sq.chem_nm_sort, sq.gene_symbol_sort, d.nm, gt.nm_sort) sqi;

Date: 2025-10-10 02:59:50
Duration: 1m56s
Database: ctdprd51
User: pubeu
Bind query: yes

x Hide

Times Reported Time consuming queries #3

x Hide

[ User: pubc - Total duration: 9m14s - Times executed: 1 ]

x Hide

[ Application: psql - Total duration: 9m14s - Times executed: 1 ]

x Hide

/* * Run daily to prune LOG_QUERY, archive old queries to LOG_QUERY_ARCHIVE * and vacuum/analyze the tables. * * $Id: archive_query_logs.sql 10832 2012-03-19 15:27:11Z mcr $ */ SELECT maint_query_logs_archive ();

Date: 2025-10-10 00:09:15
Duration: 9m14s
Database: ctdprd51
User: pubc
Application: psql

x Hide

Times Reported Time consuming queries #4

x Hide

[ User: pubeu - Total duration: 1m11s - Times executed: 2 ]

x Hide

SELECT /* DiseaseGeneAssnsDAO */ d.nm diseaseNm, d.acc_txt diseaseAcc, d.acc_db_cd diseaseAccDbCd, d.id diseaseId, g.nm geneSymbol, g.acc_txt geneAcc, g.acc_db_cd geneAccDbCd, g.id geneId, gd.network_score networkScore, gd.indirect_chem_qty inferredCount, gd.reference_qty referenceCount, gd.exposure_reference_qty exposureReferenceCount, CASE WHEN gd.curated_reference_qty > 0 THEN ( SELECT STRING_AGG(a.action_type_cd || '^' || a.action_type_nm, '|') FROM gene_disease_axn a WHERE a.gene_id = gd.gene_id AND a.disease_id = gd.disease_id) ELSE NULL END actionTypes FROM gene_disease gd INNER JOIN term g ON gd.gene_id = g.id INNER JOIN term d ON gd.disease_id = d.id WHERE gd.disease_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '2120701') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort;

Date: 2025-10-10 22:00:36
Duration: 35s831ms
Database: ctdprd51
User: pubeu
Bind query: yes

SELECT /* DiseaseGeneAssnsDAO */ d.nm diseaseNm, d.acc_txt diseaseAcc, d.acc_db_cd diseaseAccDbCd, d.id diseaseId, g.nm geneSymbol, g.acc_txt geneAcc, g.acc_db_cd geneAccDbCd, g.id geneId, gd.network_score networkScore, gd.indirect_chem_qty inferredCount, gd.reference_qty referenceCount, gd.exposure_reference_qty exposureReferenceCount, CASE WHEN gd.curated_reference_qty > 0 THEN ( SELECT STRING_AGG(a.action_type_cd || '^' || a.action_type_nm, '|') FROM gene_disease_axn a WHERE a.gene_id = gd.gene_id AND a.disease_id = gd.disease_id) ELSE NULL END actionTypes FROM gene_disease gd INNER JOIN term g ON gd.gene_id = g.id INNER JOIN term d ON gd.disease_id = d.id WHERE gd.disease_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '2120701') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort;

Date: 2025-10-10 22:19:23
Duration: 35s648ms
Database: ctdprd51
User: pubeu
Bind query: yes

x Hide

Times Reported Time consuming queries #5

x Hide

[ User: pubeu - Total duration: 46s880ms - Times executed: 9 ]

x Hide

SELECT /* GeneBasicQueryDAO */ sq.*, COUNT(*) OVER () fullRowCount FROM ( SELECT /* label */ t.acc_txt acc, 'name:' || t.nm accQueryStr, t.nm, t.nm_html nmHtml, t.secondary_nm secondaryNm, l.nm matchedNm, lt.nm_display matchedType, CASE WHEN lt.nm_display = 'Symbol' THEN true ELSE false END isNameMatch, CASE WHEN lt.nm_display = 'Name' THEN true ELSE false END isSecondaryNameMatch, t.has_chems hasChems, t.has_diseases hasDiseases, t.has_exposures hasExposures, CASE WHEN UPPER(l.nm) = 'PROTEIN' THEN 1 ELSE 2 END relevance, t.nm_sort, t.id, t.has_phenotypes hasPhenotypes FROM term t INNER JOIN term_label l ON l.term_id = t.id INNER JOIN term_label_type lt ON l.term_label_type_id = lt.id WHERE l.object_type_id = 4 AND t.object_type_id = 4 AND l.id IN ( SELECT FIRST_VALUE(i.id) OVER (PARTITION BY i.term_id ORDER BY it.priority_seq, i.nm) FROM term_label i INNER JOIN term_label_type it ON i.term_label_type_id = it.id WHERE i.object_type_id = 4 AND i.nm_fts @@ to_tsquery('common.english_nostops', 'PROTEIN')) UNION ALL SELECT /* acc */ t.acc_txt acc, 'name:' || t.nm accQueryStr, t.nm, t.nm_html nmHtml, t.secondary_nm secondaryNm, l.acc_txt matchednm, 'Accession' matchedtype, false isNameMatch, false isSecondaryNameMatch, t.has_chems hasChems, t.has_diseases hasDiseases, t.has_exposures hasExposures, 1 relevance, t.nm_sort, t.id, t.has_phenotypes hasPhenotypes FROM db_link l INNER JOIN term t ON l.object_id = t.id WHERE l.type_cd = 'A' AND l.object_type_id = 4 AND (upper(l.acc_txt) = 'PROTEIN') ORDER BY 13, 14) sq;

Date: 2025-10-10 11:00:36
Duration: 5s769ms
Database: ctdprd51
User: pubeu
Bind query: yes

SELECT /* GeneBasicQueryDAO */ sq.*, COUNT(*) OVER () fullRowCount FROM ( SELECT /* label */ t.acc_txt acc, 'name:' || t.nm accQueryStr, t.nm, t.nm_html nmHtml, t.secondary_nm secondaryNm, l.nm matchedNm, lt.nm_display matchedType, CASE WHEN lt.nm_display = 'Symbol' THEN true ELSE false END isNameMatch, CASE WHEN lt.nm_display = 'Name' THEN true ELSE false END isSecondaryNameMatch, t.has_chems hasChems, t.has_diseases hasDiseases, t.has_exposures hasExposures, CASE WHEN UPPER(l.nm) = 'PROTEIN' THEN 1 ELSE 2 END relevance, t.nm_sort, t.id, t.has_phenotypes hasPhenotypes FROM term t INNER JOIN term_label l ON l.term_id = t.id INNER JOIN term_label_type lt ON l.term_label_type_id = lt.id WHERE l.object_type_id = 4 AND t.object_type_id = 4 AND l.id IN ( SELECT FIRST_VALUE(i.id) OVER (PARTITION BY i.term_id ORDER BY it.priority_seq, i.nm) FROM term_label i INNER JOIN term_label_type it ON i.term_label_type_id = it.id WHERE i.object_type_id = 4 AND i.nm_fts @@ to_tsquery('common.english_nostops', 'PROTEIN')) UNION ALL SELECT /* acc */ t.acc_txt acc, 'name:' || t.nm accQueryStr, t.nm, t.nm_html nmHtml, t.secondary_nm secondaryNm, l.acc_txt matchednm, 'Accession' matchedtype, false isNameMatch, false isSecondaryNameMatch, t.has_chems hasChems, t.has_diseases hasDiseases, t.has_exposures hasExposures, 1 relevance, t.nm_sort, t.id, t.has_phenotypes hasPhenotypes FROM db_link l INNER JOIN term t ON l.object_id = t.id WHERE l.type_cd = 'A' AND l.object_type_id = 4 AND (upper(l.acc_txt) = 'PROTEIN') ORDER BY 13, 14) sq;

Date: 2025-10-10 11:22:11
Duration: 5s278ms
Database: ctdprd51
User: pubeu
Bind query: yes

SELECT /* GeneBasicQueryDAO */ sq.*, COUNT(*) OVER () fullRowCount FROM ( SELECT /* label */ t.acc_txt acc, 'name:' || t.nm accQueryStr, t.nm, t.nm_html nmHtml, t.secondary_nm secondaryNm, l.nm matchedNm, lt.nm_display matchedType, CASE WHEN lt.nm_display = 'Symbol' THEN true ELSE false END isNameMatch, CASE WHEN lt.nm_display = 'Name' THEN true ELSE false END isSecondaryNameMatch, t.has_chems hasChems, t.has_diseases hasDiseases, t.has_exposures hasExposures, CASE WHEN UPPER(l.nm) = 'PROTEIN' THEN 1 ELSE 2 END relevance, t.nm_sort, t.id, t.has_phenotypes hasPhenotypes FROM term t INNER JOIN term_label l ON l.term_id = t.id INNER JOIN term_label_type lt ON l.term_label_type_id = lt.id WHERE l.object_type_id = 4 AND t.object_type_id = 4 AND l.id IN ( SELECT FIRST_VALUE(i.id) OVER (PARTITION BY i.term_id ORDER BY it.priority_seq, i.nm) FROM term_label i INNER JOIN term_label_type it ON i.term_label_type_id = it.id WHERE i.object_type_id = 4 AND i.nm_fts @@ to_tsquery('common.english_nostops', 'PROTEIN')) UNION ALL SELECT /* acc */ t.acc_txt acc, 'name:' || t.nm accQueryStr, t.nm, t.nm_html nmHtml, t.secondary_nm secondaryNm, l.acc_txt matchednm, 'Accession' matchedtype, false isNameMatch, false isSecondaryNameMatch, t.has_chems hasChems, t.has_diseases hasDiseases, t.has_exposures hasExposures, 1 relevance, t.nm_sort, t.id, t.has_phenotypes hasPhenotypes FROM db_link l INNER JOIN term t ON l.object_id = t.id WHERE l.type_cd = 'A' AND l.object_type_id = 4 AND (upper(l.acc_txt) = 'PROTEIN') ORDER BY 13, 14) sq;

Date: 2025-10-10 10:51:00
Duration: 5s233ms
Database: ctdprd51
User: pubeu
Bind query: yes

x Hide

Times Reported Time consuming queries #6

x Hide

[ User: pubeu - Total duration: 35s441ms - Times executed: 6 ]

x Hide

SELECT /* BasicCountsDAO gen */ ii.cd, COUNT(ii.id) cnt FROM ( SELECT ot.cd, tl.term_id id FROM object_type ot INNER JOIN term_label tl ON ot.id = tl.object_type_id WHERE tl.nm_fts @@ to_tsquery('common.english_nostops', 'HSA_CIRC_0000662') UNION SELECT 'reference', r.id FROM reference r WHERE r.title_abstract_fts @@ to_tsquery('pg_catalog.english', 'HSA_CIRC_0000662') OR r.id IN ( SELECT rpr.reference_id FROM reference_party_role rpr INNER JOIN reference_party rp ON rpr.reference_party_id = rp.id WHERE (SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'HSA_CIRC_0000662')) UNION SELECT ot.cd, l.object_id FROM db_link l INNER JOIN object_type ot on l.object_type_id = ot.id WHERE l.type_cd = 'A' AND (upper(l.acc_txt) LIKE 'HSA_CIRC_0000662')) ii GROUP BY ii.cd;

Date: 2025-10-10 02:59:37
Duration: 6s39ms
Database: ctdprd51
User: pubeu
Bind query: yes

SELECT /* BasicCountsDAO gen */ ii.cd, COUNT(ii.id) cnt FROM ( SELECT ot.cd, tl.term_id id FROM object_type ot INNER JOIN term_label tl ON ot.id = tl.object_type_id WHERE tl.nm_fts @@ to_tsquery('common.english_nostops', 'HSA_CIRC_0000662') UNION SELECT 'reference', r.id FROM reference r WHERE r.title_abstract_fts @@ to_tsquery('pg_catalog.english', 'HSA_CIRC_0000662') OR r.id IN ( SELECT rpr.reference_id FROM reference_party_role rpr INNER JOIN reference_party rp ON rpr.reference_party_id = rp.id WHERE (SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'HSA_CIRC_0000662')) UNION SELECT ot.cd, l.object_id FROM db_link l INNER JOIN object_type ot on l.object_type_id = ot.id WHERE l.type_cd = 'A' AND (upper(l.acc_txt) LIKE 'HSA_CIRC_0000662')) ii GROUP BY ii.cd;

Date: 2025-10-10 02:59:42
Duration: 5s945ms
Database: ctdprd51
User: pubeu
Bind query: yes

SELECT /* BasicCountsDAO gen */ ii.cd, COUNT(ii.id) cnt FROM ( SELECT ot.cd, tl.term_id id FROM object_type ot INNER JOIN term_label tl ON ot.id = tl.object_type_id WHERE tl.nm_fts @@ to_tsquery('common.english_nostops', 'HSA_CIRC_0000662') UNION SELECT 'reference', r.id FROM reference r WHERE r.title_abstract_fts @@ to_tsquery('pg_catalog.english', 'HSA_CIRC_0000662') OR r.id IN ( SELECT rpr.reference_id FROM reference_party_role rpr INNER JOIN reference_party rp ON rpr.reference_party_id = rp.id WHERE (SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'HSA_CIRC_0000662')) UNION SELECT ot.cd, l.object_id FROM db_link l INNER JOIN object_type ot on l.object_type_id = ot.id WHERE l.type_cd = 'A' AND (upper(l.acc_txt) LIKE 'HSA_CIRC_0000662')) ii GROUP BY ii.cd;

Date: 2025-10-10 02:59:41
Duration: 5s939ms
Database: ctdprd51
User: pubeu
Bind query: yes

x Hide

Times Reported Time consuming queries #7

x Hide

SELECT /* GoGenesDAO */ sq.*, COUNT(*) OVER () fullRowCount FROM ( SELECT DISTINCT gt.nm gonm, gt.nm_html gonmhtml, gt.nm_sort gonmsort, gt.acc_txt goacc, gt.object_id goid, g.nm genesymbol, g.nm_sort genesymbolsort, g.acc_txt geneacc, g.acc_db_cd geneaccdbcd, g.id geneid FROM dag_node gt INNER JOIN gene_go_annot gga ON gt.object_id = gga.go_term_id INNER JOIN term g ON gga.gene_id = g.id WHERE gt.id IN ( SELECT p.descendant_dag_node_id FROM dag_path p WHERE p.ancestor_object_id = '1245038') AND gga.is_not = false) sq ORDER BY sq.gonmsort, sq.genesymbolsort LIMIT 50;

Date: 2025-10-10 07:25:51
Duration: 24s717ms
Bind query: yes

x Hide

Times Reported Time consuming queries #8

x Hide

[ User: pubeu - Total duration: 18s351ms - Times executed: 3 ]

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 = '1326649' AND te.enriched_object_type_id = 5 ORDER BY te.corrected_p_val, d.abbr, gt.nm_sort LIMIT 50;

Date: 2025-10-10 04:26:44
Duration: 6s621ms
Database: ctdprd51
User: pubeu
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 = '1323000' AND te.enriched_object_type_id = 5 ORDER BY te.corrected_p_val, d.abbr, gt.nm_sort LIMIT 50;

Date: 2025-10-10 02:00:43
Duration: 6s581ms
Database: ctdprd51
User: pubeu
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 = '1448872' AND te.enriched_object_type_id = 5 ORDER BY te.corrected_p_val, d.abbr, gt.nm_sort LIMIT 50;

Date: 2025-10-10 07:18:48
Duration: 5s148ms
Database: ctdprd51
User: pubeu
Bind query: yes