vacuum FULL analyze db_link;

Date: 2025-04-01 11:04:35
Duration: 2m35s

vacuum FULL analyze db_link;

Date: 2025-04-01 11:02:16
Duration: 0ms
Database: ctdprd51
User: pub1
Application: pgAdmin 4 - CONN:1029688

x Hide

SELECT /* TermDAO */ t.id, t.nm, t.nm_html, t.secondary_nm, t.acc_db_cd, t.is_leaf, t.has_chems, t.has_diseases, t.has_genes, t.has_go, t.has_pathways, t.has_ixns, t.has_references, t.has_comps, t.has_exposures, t.has_phenotypes FROM term t WHERE t.id = ( SELECT l.object_id FROM db_link l WHERE l.type_cd = 'A' AND l.object_type_id = 1 AND l.acc_txt = $1 LIMIT 1);

Date: 2025-04-01 11:04:32

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', 'NFKB & SIGNALING') UNION SELECT 'reference', r.id FROM reference r WHERE r.title_abstract_fts @@ to_tsquery('pg_catalog.english', 'NFKB & SIGNALING') 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 'NFKB' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'SIGNALING')) 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 'NFKB' OR upper(l.acc_txt) LIKE 'SIGNALING')) ii GROUP BY ii.cd;

Date: 2025-04-01 11:04:35
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', $1) UNION SELECT 'reference', r.id FROM reference r WHERE r.title_abstract_fts @@ to_tsquery('pg_catalog.english', $2) 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 $3 OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE $4)) 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 $5 OR upper(l.acc_txt) LIKE $6)) ii GROUP BY ii.cd;

Date: 2025-04-01 11:04:32

x Hide

select root_id, edit.get_ixn_prose (i.id) from edit.ixn i, edit.reference_ixn ri where ri.ixn_id = i.id and ri.reference_acc_txt = '38488668' order by root_id desc;

Date: 2025-04-01 11:04:32

x Hide

SELECT /* TermLinksDAO */ COALESCE(d.abbr_display, d.nm_display) dbnm, d.cd dbcd, d.id dbid, COALESCE(d.abbr, d.nm) anchor, l.acc_txt acc, get_acc_sort_num (l.acc_txt) accsort, l.is_primary isprimary, dbrs.nm sitenm, dbr.nm reportnm, get_encoded_acc_url (dbrs.url, l.acc_txt) url, COUNT(dbrs.id) OVER (PARTITION BY l.acc_txt, l.db_id, dbr.id) sitesPerAccCount, COUNT(l.acc_txt) OVER (PARTITION BY l.db_id, dbrs.id) accsPerDbCount FROM db_link l INNER JOIN db d ON l.db_id = d.id INNER JOIN db_report dbr ON d.id = dbr.db_id AND dbr.object_type_id = 7 INNER JOIN db_report_site dbrs ON dbr.id = dbrs.db_report_id WHERE l.object_id = $1 AND l.object_type_id = 7 AND l.type_cd = 'A' AND dbr.type_cd = 'PAV' ORDER BY 1, 7 DESC, 6, 5, 8;

Date: 2025-04-01 11:04:32

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', 'SMG_1') UNION SELECT 'reference', r.id FROM reference r WHERE r.title_abstract_fts @@ to_tsquery('pg_catalog.english', 'SMG_1') 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 'SMG_1')) 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 'SMG_1')) ii GROUP BY ii.cd;

Date: 2025-04-01 04:47:25
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', 'CTD_6648') UNION SELECT 'reference', r.id FROM reference r WHERE r.title_abstract_fts @@ to_tsquery('pg_catalog.english', 'CTD_6648') 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 'CTD_6648')) 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 'CTD_6648')) ii GROUP BY ii.cd;

Date: 2025-04-01 12:38:33
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', 'MELANOMA') UNION SELECT 'reference', r.id FROM reference r WHERE r.title_abstract_fts @@ to_tsquery('pg_catalog.english', 'MELANOMA') 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 'MELANOMA')) 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 'MELANOMA')) ii GROUP BY ii.cd;

Date: 2025-04-01 11:04:35
Bind query: yes

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) = $1 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', $2)) 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) = $3) ORDER BY 13, 14) sq LIMIT 50;

Date: 2025-04-01 11:04:32

x Hide

SELECT /* TermLinksDAO */ COALESCE(d.abbr_display, d.nm_display) dbnm, d.cd dbcd, d.id dbid, COALESCE(d.abbr, d.nm) anchor, l.acc_txt acc, get_acc_sort_num (l.acc_txt) accsort, l.is_primary isprimary, dbrs.nm sitenm, dbr.nm reportnm, get_encoded_acc_url (dbrs.url, l.acc_txt) url, COUNT(dbrs.id) OVER (PARTITION BY l.acc_txt, l.db_id, dbr.id) sitesPerAccCount, COUNT(l.acc_txt) OVER (PARTITION BY l.db_id, dbrs.id) accsPerDbCount, CASE WHEN l.type_cd = 'A' THEN ( SELECT t.nm FROM gene_taxon gt INNER JOIN term t ON gt.taxon_id = t.id WHERE gt.gene_acc_txt = l.acc_txt) ELSE NULL END description FROM db_link l INNER JOIN db d ON l.db_id = d.id INNER JOIN db_report dbr ON d.id = dbr.db_id AND dbr.object_type_id = 4 INNER JOIN db_report_site dbrs ON dbr.id = dbrs.db_report_id WHERE l.object_id = $1 AND l.object_type_id = 4 AND l.type_cd = 'A' AND dbr.type_cd = 'PAV' ORDER BY 1, 7 DESC, 6, 5, 8;

Date: 2025-04-01 11:04:32

x Hide

SELECT /* TermDAO */ t.id, t.nm, t.nm_html, t.secondary_nm, t.acc_db_cd, t.is_leaf, t.has_chems, t.has_diseases, t.has_genes, t.has_go, t.has_pathways, t.has_ixns, t.has_references, t.has_comps, t.has_exposures, t.has_phenotypes FROM term t WHERE t.id = ( SELECT l.object_id FROM db_link l WHERE l.type_cd = 'A' AND l.object_type_id = 3 AND l.acc_txt = $1 AND l.db_id = $2 LIMIT 1);

Date: 2025-04-01 11:04:32

x Hide

SELECT /* GoBasicQueryDAO */ sq.*, COUNT(*) OVER () fullRowCount FROM ( SELECT /* label */ n.acc_txt acc, n.acc_txt accQueryStr, n.nm, n.nm_html nmHtml, l.nm matchednm, lt.nm_display matchedtype, CASE WHEN lt.nm_display = 'Name' THEN true ELSE false END isNameMatch, d.nm rankNm, CASE WHEN UPPER(l.nm) = $1 THEN 1 ELSE 2 END relevance, n.nm_sort, n.object_id id, n.has_genes hasGenes, n.has_diseases hasDiseases, n.has_exposures hasExposures, n.has_phenotypes hasPhenotypes FROM dag_node n INNER JOIN term_label l ON l.term_id = n.object_id INNER JOIN term_label_type lt ON l.term_label_type_id = lt.id INNER JOIN dag d ON n.dag_id = d.id WHERE l.object_type_id = 5 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 = 5 AND i.nm_fts @@ to_tsquery('common.english_nostops', $2)) UNION ALL SELECT /* acc */ n.acc_txt acc, n.acc_txt accQueryStr, n.nm, n.nm_html nmHtml, n.acc_txt matchednm, 'Accession' matchedtype, false isNameMatch, d.nm rankNm, 1 relevance, n.nm_sort, n.object_id id, n.has_genes hasGenes, n.has_diseases hasDiseases, n.has_exposures hasExposures, n.has_phenotypes hasPhenotypes FROM db_link l INNER JOIN dag_node n ON l.object_id = n.object_id INNER JOIN dag d ON n.dag_id = d.id WHERE l.type_cd = 'A' AND l.object_type_id = 5 AND (upper(l.acc_txt) = $3) ORDER BY 9, 10) sq LIMIT 50;

Date: 2025-04-01 11:04:32

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) = $1 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', $2)) 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) = $3 OR upper(l.acc_txt) = $4 OR upper(l.acc_txt) = $5 OR upper(l.acc_txt) = $6) ORDER BY 13, 14) sq LIMIT 50;

Date: 2025-04-01 11:04:32

x Hide