CREATE INDEX CONCURRENTLY idx_gga_gene_not_go ON gene_go_annot (gene_id, is_not, go_term_id);

Date: 2026-05-20 11:09:58
Duration: 26s620ms

CREATE INDEX CONCURRENTLY idx_gga_gene_not_go ON gene_go_annot (gene_id, is_not, go_term_id);

Date: 2026-05-20 11:09:46
Duration: 0ms
Database: ctddev51
User: pub1
Application: pgAdmin 4 - CONN:7673166

x Hide

CREATE INDEX idx_gga_gene_not_go ON gene_go_annot (gene_id, is_not, go_term_id);

Date: 2026-05-20 11:12:33
Duration: 14s7ms

CREATE INDEX idx_gga_gene_not_go ON gene_go_annot (gene_id, is_not, go_term_id);

Date: 2026-05-20 11:12:33
Duration: 0ms

x Hide

Times Reported Time consuming queries #1

x Hide

[ User: pub2 - Total duration: 2m2s - Times executed: 1 ]

[ User: pub1 - Total duration: 40s831ms - Times executed: 1 ]

x Hide

[ Application: pgAdmin 4 - CONN:2477865 - Total duration: 2m2s - Times executed: 1 ]

[ Application: pgAdmin 4 - CONN:1855680 - Total duration: 40s831ms - Times executed: 1 ]

x Hide

WITH sq AS ( SELECT c.id AS chem_id, c.nm AS chem_nm, c.acc_txt AS chem_acc_txt, c.secondary_nm AS casRN, gcr.gene_id, g.nm AS gene_symbol, g.acc_txt AS gene_acc_txt FROM term c JOIN gene_chem_reference gcr ON gcr.chem_id = c.id JOIN term g ON g.id = gcr.gene_id WHERE c.acc_txt = 'D015056' GROUP BY c.id, c.nm, c.acc_txt, c.secondary_nm, gcr.gene_id, g.nm, g.acc_txt ) SELECT 'D015056' AS "Input", sq.chem_nm AS "ChemicalName", sq.chem_acc_txt AS "ChemicalID", sq.casRN AS "CasRN", sq.gene_symbol AS "GeneSymbol", sq.gene_acc_txt AS "GeneID", d.nm AS "Ontology", gt.nm AS "GoTermName", gt.acc_txt AS "GoTermID" FROM sq JOIN gene_go_annot gga ON gga.gene_id = sq.gene_id AND gga.is_not = false JOIN dag_node gt ON gt.object_id = gga.go_term_id JOIN dag d ON d.id = gt.dag_id GROUP BY sq.chem_nm, sq.chem_acc_txt, sq.casRN, sq.gene_symbol, sq.gene_acc_txt, d.nm, gt.nm, gt.acc_txt ORDER BY sq.chem_nm, sq.gene_symbol, d.nm, gt.nm;

Date: 2026-05-20 11:07:20
Duration: 2m2s
Database: ctddev51
User: pub2
Application: pgAdmin 4 - CONN:2477865

WITH sq AS ( SELECT c.id AS chem_id, c.nm AS chem_nm, c.acc_txt AS chem_acc_txt, c.secondary_nm AS casRN, gcr.gene_id, g.nm AS gene_symbol, g.acc_txt AS gene_acc_txt FROM term c JOIN gene_chem_reference gcr ON gcr.chem_id = c.id JOIN term g ON g.id = gcr.gene_id WHERE c.acc_txt = 'D015056' GROUP BY c.id, c.nm, c.acc_txt, c.secondary_nm, gcr.gene_id, g.nm, g.acc_txt ) SELECT 'D015056' AS "Input", sq.chem_nm AS "ChemicalName", sq.chem_acc_txt AS "ChemicalID", sq.casRN AS "CasRN", sq.gene_symbol AS "GeneSymbol", sq.gene_acc_txt AS "GeneID", d.nm AS "Ontology", gt.nm AS "GoTermName", gt.acc_txt AS "GoTermID" FROM sq JOIN gene_go_annot gga ON gga.gene_id = sq.gene_id AND gga.is_not = false JOIN dag_node gt ON gt.object_id = gga.go_term_id JOIN dag d ON d.id = gt.dag_id GROUP BY sq.chem_nm, sq.chem_acc_txt, sq.casRN, sq.gene_symbol, sq.gene_acc_txt, d.nm, gt.nm, gt.acc_txt ORDER BY sq.chem_nm, sq.gene_symbol, d.nm, gt.nm;

Date: 2026-05-20 11:11:13
Duration: 40s831ms
Database: ctddev51
User: pub1
Application: pgAdmin 4 - CONN:1855680

x Hide

Times Reported Time consuming queries #2

x Hide

[ User: pub1 - Total duration: 48s62ms - Times executed: 1 ]

x Hide

[ Application: pgAdmin 4 - CONN:9681020 - Total duration: 48s62ms - Times executed: 1 ]

x Hide

SELECT 'D015056' AS "Input", sqi.chem_nm AS "ChemicalName", sqi.chem_acc_txt AS "ChemicalID", sqi.casRN AS "CasRN", sqi.gene_symbol AS "GeneSymbol", sqi.gene_acc_txt AS "GeneID", sqi.ontology_nm AS "Ontology", sqi.go_term_nm AS "GoTermName", sqi.go_acc_txt AS "GoTermID" FROM ( WITH sq AS ( SELECT DISTINCT c.id AS chem_id, c.nm AS chem_nm, c.acc_txt AS chem_acc_txt, c.secondary_nm AS casRN, c.nm_sort AS chem_nm_sort, gcr.gene_id, g.nm AS gene_symbol, g.acc_txt AS gene_acc_txt, g.nm_sort AS 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.acc_txt = 'D015056' ) SELECT DISTINCT sq.chem_nm, sq.chem_acc_txt, sq.casRN, sq.gene_symbol, sq.gene_acc_txt, gt.nm AS go_term_nm, gt.acc_txt AS go_acc_txt, sq.chem_nm_sort, sq.gene_symbol_sort, gt.nm_sort, d.nm AS 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 /* optional DAG filters */ ORDER BY sq.chem_nm_sort, sq.gene_symbol_sort, d.nm, gt.nm_sort) sqi;

Date: 2026-05-20 11:16:56
Duration: 48s62ms
Database: ctddev51
User: pub1
Application: pgAdmin 4 - CONN:9681020

x Hide

Times Reported Time consuming queries #3

x Hide

WITH sq AS ( SELECT c.id AS chem_id, c.nm AS chem_nm, c.acc_txt AS chem_acc_txt, c.secondary_nm AS casRN, gcr.gene_id, g.nm AS gene_symbol, g.acc_txt AS gene_acc_txt FROM term c JOIN gene_chem_reference gcr ON gcr.chem_id = c.id JOIN term g ON g.id = gcr.gene_id WHERE c.acc_txt = 'D015056' GROUP BY c.id, c.nm, c.acc_txt, c.secondary_nm, gcr.gene_id, g.nm, g.acc_txt ) SELECT 'D015056' AS "Input", sq.chem_nm AS "ChemicalName", sq.chem_acc_txt AS "ChemicalID", sq.casRN AS "CasRN", sq.gene_symbol AS "GeneSymbol", sq.gene_acc_txt AS "GeneID", d.nm AS "Ontology", gt.nm AS "GoTermName", gt.acc_txt AS "GoTermID" FROM sq JOIN gene_go_annot gga ON gga.gene_id = sq.gene_id AND gga.is_not = false JOIN dag_node gt ON gt.object_id = gga.go_term_id JOIN dag d ON d.id = gt.dag_id GROUP BY sq.chem_nm, sq.chem_acc_txt, sq.casRN, sq.gene_symbol, sq.gene_acc_txt, d.nm, gt.nm, gt.acc_txt ORDER BY sq.chem_nm, sq.gene_symbol, d.nm, gt.nm; --CREATE INDEX idx_gga_gene_not_go -- ON gene_go_annot ( -- gene_id, is_not, -- go_term_id );

Date: 2026-05-20 11:13:25
Duration: 40s736ms

x Hide

Times Reported Time consuming queries #4

x Hide

CREATE INDEX CONCURRENTLY idx_gga_gene_not_go ON gene_go_annot (gene_id, is_not, go_term_id);

Date: 2026-05-20 11:09:58
Duration: 26s620ms

CREATE INDEX CONCURRENTLY idx_gga_gene_not_go ON gene_go_annot (gene_id, is_not, go_term_id);

Date: 2026-05-20 11:09:46
Duration: 0ms
Database: ctddev51
User: pub1
Application: pgAdmin 4 - CONN:7673166

x Hide

Times Reported Time consuming queries #5

x Hide

CREATE INDEX idx_gga_gene_not_go ON gene_go_annot (gene_id, is_not, go_term_id);

Date: 2026-05-20 11:12:33
Duration: 14s7ms

CREATE INDEX idx_gga_gene_not_go ON gene_go_annot (gene_id, is_not, go_term_id);

Date: 2026-05-20 11:12:33
Duration: 0ms

x Hide

Times Reported Time consuming queries #6

x Hide

select distinct /* ChemPhenotypesAssnsDAO */ associatedTerm.nm || '^' || o.cd || '^' || associatedTerm.nm_html || '^' || associatedTerm.acc_txt || '^' || associatedTerm.acc_db_cd as associatedTerm, associatedTerm.id associatedTermId, ptr.ixn_id ixnId, associatedTerm.object_type_id || '|' || associatedTerm.nm_sort associatedTermNmSort, COALESCE(associatedTerm.secondary_nm, '') casRN, phenotypeTerm.nm || '^' || 'go' || '^' || phenotypeTerm.nm_html || '^' || phenotypeTerm.acc_txt || '^' || phenotypeTerm.acc_db_cd as phenotype, phenotypeTerm.id phenotypeId, ( 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 anatomyTerm.nm_html || '^' || anatomyTerm.acc_txt || '^' || ia.level_seq || '^' || anatomyTerm.acc_db_cd || '^' || anatomyTerm.nm, '|')) as anatomyTerms, COUNT(DISTINCT taxonTerm.nm) taxonCount, i.ixn_prose_html ixnProseHtml, i.ixn_prose_txt ixnProse, i.sort_txt ixnSort, ( SELECT STRING_AGG(distinct r.acc_txt, '|')) as references, COUNT(DISTINCT ptr.reference_id) refCount, pt.indirect_term_qty inferredCount, COUNT(*) OVER () fullRowCount from phenotype_term_reference ptr inner join phenotype_term pt on ptr.term_id = pt.term_id and ptr.phenotype_id = pt.phenotype_id inner join term associatedTerm on ptr.term_id = associatedTerm.id inner join term phenotypeTerm on ptr.phenotype_id = phenotypeTerm.id left outer join term taxonTerm on ptr.taxon_id = taxonTerm.id inner join reference r on ptr.reference_id = r.id inner join ixn i on ptr.ixn_id = i.id inner join object_type o on associatedTerm.object_type_id = o.id left outer join ixn_anatomy ia on ptr.ixn_id = ia.ixn_id left outer join term anatomyTerm on ia.anatomy_id = anatomyTerm.id where ptr.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 baseTerm.id in ( select term_id from term_label tl WHERE UPPER(tl.nm) = 'COPPER' AND tl.object_type_id = 2))) and i.id in ( select ixn_id from ixn_axn where action_type_nm = 'phenotype' and action_degree_type_nm in ('increases', 'decreases', 'affects')) group by associatedTerm, associatedTermNmSort, phenotype, casRN, ixnId, ixnProseHtml, ixnProse, ixnSort, associatedTermId, phenotypeId, inferredCount ORDER BY associatedTermNmSort asc, pt.indirect_term_qty desc LIMIT 50;

Date: 2026-05-20 10:16:43
Duration: 7s628ms
Bind query: yes

x Hide

Times Reported Time consuming queries #7

x Hide

[ User: pubeu - Total duration: 6s707ms - Times executed: 1 ]

x Hide

select distinct /* ChemPhenotypesAssnsDAO */ associatedTerm.nm || '^' || o.cd || '^' || associatedTerm.nm_html || '^' || associatedTerm.acc_txt || '^' || associatedTerm.acc_db_cd as associatedTerm, associatedTerm.id associatedTermId, ptr.ixn_id ixnId, associatedTerm.object_type_id || '|' || associatedTerm.nm_sort associatedTermNmSort, COALESCE(associatedTerm.secondary_nm, '') casRN, phenotypeTerm.nm || '^' || 'go' || '^' || phenotypeTerm.nm_html || '^' || phenotypeTerm.acc_txt || '^' || phenotypeTerm.acc_db_cd as phenotype, phenotypeTerm.id phenotypeId, ( 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 anatomyTerm.nm_html || '^' || anatomyTerm.acc_txt || '^' || ia.level_seq || '^' || anatomyTerm.acc_db_cd || '^' || anatomyTerm.nm, '|')) as anatomyTerms, COUNT(DISTINCT taxonTerm.nm) taxonCount, i.ixn_prose_html ixnProseHtml, i.ixn_prose_txt ixnProse, i.sort_txt ixnSort, ( SELECT STRING_AGG(distinct r.acc_txt, '|')) as references, COUNT(DISTINCT ptr.reference_id) refCount, pt.indirect_term_qty inferredCount, COUNT(*) OVER () fullRowCount from phenotype_term_reference ptr inner join phenotype_term pt on ptr.term_id = pt.term_id and ptr.phenotype_id = pt.phenotype_id inner join term associatedTerm on ptr.term_id = associatedTerm.id inner join term phenotypeTerm on ptr.phenotype_id = phenotypeTerm.id left outer join term taxonTerm on ptr.taxon_id = taxonTerm.id inner join reference r on ptr.reference_id = r.id inner join ixn i on ptr.ixn_id = i.id inner join object_type o on associatedTerm.object_type_id = o.id left outer join ixn_anatomy ia on ptr.ixn_id = ia.ixn_id left outer join term anatomyTerm on ia.anatomy_id = anatomyTerm.id where ptr.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 'COPPER')) and ptr.term_object_type_id = 2 and ptr.phenotype_id IN ( SELECT /* DBConstants.getContainsSQL */ t.id FROM term t WHERE t.nm_fts @@ to_tsquery('common.english_nostops', 'HOPPER') AND t.object_type_id = 5) and i.id in ( select ixn_id from ixn_anatomy where anatomy_id IN ( SELECT /* DBConstants.getContainsSQL */ t.id FROM term t WHERE t.nm_fts @@ to_tsquery('common.english_nostops', 'TOPPER') AND t.object_type_id = 10)) and taxonTerm.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 = 1 and upper(baseTerm.nm) LIKE 'IJIMAIA LOPPEI')) and i.id in ( select ixn_id from ixn_axn where action_type_nm = 'phenotype' and action_degree_type_nm in ('affects')) group by associatedTerm, associatedTermNmSort, phenotype, casRN, ixnId, ixnProseHtml, ixnProse, ixnSort, associatedTermId, phenotypeId, inferredCount ORDER BY associatedTermNmSort asc, pt.indirect_term_qty desc LIMIT 500;

Date: 2026-05-20 10:35:51
Duration: 6s707ms
Database: ctddev51
User: pubeu
Bind query: yes

x Hide

Times Reported Time consuming queries #1

x Hide

[ User: pub2 - Total duration: 2m2s - Times executed: 1 ]

[ User: pub1 - Total duration: 40s831ms - Times executed: 1 ]

x Hide

[ Application: pgAdmin 4 - CONN:2477865 - Total duration: 2m2s - Times executed: 1 ]

[ Application: pgAdmin 4 - CONN:1855680 - Total duration: 40s831ms - Times executed: 1 ]

x Hide

WITH sq AS ( SELECT c.id AS chem_id, c.nm AS chem_nm, c.acc_txt AS chem_acc_txt, c.secondary_nm AS casRN, gcr.gene_id, g.nm AS gene_symbol, g.acc_txt AS gene_acc_txt FROM term c JOIN gene_chem_reference gcr ON gcr.chem_id = c.id JOIN term g ON g.id = gcr.gene_id WHERE c.acc_txt = 'D015056' GROUP BY c.id, c.nm, c.acc_txt, c.secondary_nm, gcr.gene_id, g.nm, g.acc_txt ) SELECT 'D015056' AS "Input", sq.chem_nm AS "ChemicalName", sq.chem_acc_txt AS "ChemicalID", sq.casRN AS "CasRN", sq.gene_symbol AS "GeneSymbol", sq.gene_acc_txt AS "GeneID", d.nm AS "Ontology", gt.nm AS "GoTermName", gt.acc_txt AS "GoTermID" FROM sq JOIN gene_go_annot gga ON gga.gene_id = sq.gene_id AND gga.is_not = false JOIN dag_node gt ON gt.object_id = gga.go_term_id JOIN dag d ON d.id = gt.dag_id GROUP BY sq.chem_nm, sq.chem_acc_txt, sq.casRN, sq.gene_symbol, sq.gene_acc_txt, d.nm, gt.nm, gt.acc_txt ORDER BY sq.chem_nm, sq.gene_symbol, d.nm, gt.nm;

Date: 2026-05-20 11:07:20
Duration: 2m2s
Database: ctddev51
User: pub2
Application: pgAdmin 4 - CONN:2477865

WITH sq AS ( SELECT c.id AS chem_id, c.nm AS chem_nm, c.acc_txt AS chem_acc_txt, c.secondary_nm AS casRN, gcr.gene_id, g.nm AS gene_symbol, g.acc_txt AS gene_acc_txt FROM term c JOIN gene_chem_reference gcr ON gcr.chem_id = c.id JOIN term g ON g.id = gcr.gene_id WHERE c.acc_txt = 'D015056' GROUP BY c.id, c.nm, c.acc_txt, c.secondary_nm, gcr.gene_id, g.nm, g.acc_txt ) SELECT 'D015056' AS "Input", sq.chem_nm AS "ChemicalName", sq.chem_acc_txt AS "ChemicalID", sq.casRN AS "CasRN", sq.gene_symbol AS "GeneSymbol", sq.gene_acc_txt AS "GeneID", d.nm AS "Ontology", gt.nm AS "GoTermName", gt.acc_txt AS "GoTermID" FROM sq JOIN gene_go_annot gga ON gga.gene_id = sq.gene_id AND gga.is_not = false JOIN dag_node gt ON gt.object_id = gga.go_term_id JOIN dag d ON d.id = gt.dag_id GROUP BY sq.chem_nm, sq.chem_acc_txt, sq.casRN, sq.gene_symbol, sq.gene_acc_txt, d.nm, gt.nm, gt.acc_txt ORDER BY sq.chem_nm, sq.gene_symbol, d.nm, gt.nm;

Date: 2026-05-20 11:11:13
Duration: 40s831ms
Database: ctddev51
User: pub1
Application: pgAdmin 4 - CONN:1855680

x Hide

Times Reported Time consuming queries #2

x Hide

[ User: pub1 - Total duration: 48s62ms - Times executed: 1 ]

x Hide

[ Application: pgAdmin 4 - CONN:9681020 - Total duration: 48s62ms - Times executed: 1 ]

x Hide

SELECT 'D015056' AS "Input", sqi.chem_nm AS "ChemicalName", sqi.chem_acc_txt AS "ChemicalID", sqi.casRN AS "CasRN", sqi.gene_symbol AS "GeneSymbol", sqi.gene_acc_txt AS "GeneID", sqi.ontology_nm AS "Ontology", sqi.go_term_nm AS "GoTermName", sqi.go_acc_txt AS "GoTermID" FROM ( WITH sq AS ( SELECT DISTINCT c.id AS chem_id, c.nm AS chem_nm, c.acc_txt AS chem_acc_txt, c.secondary_nm AS casRN, c.nm_sort AS chem_nm_sort, gcr.gene_id, g.nm AS gene_symbol, g.acc_txt AS gene_acc_txt, g.nm_sort AS 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.acc_txt = 'D015056' ) SELECT DISTINCT sq.chem_nm, sq.chem_acc_txt, sq.casRN, sq.gene_symbol, sq.gene_acc_txt, gt.nm AS go_term_nm, gt.acc_txt AS go_acc_txt, sq.chem_nm_sort, sq.gene_symbol_sort, gt.nm_sort, d.nm AS 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 /* optional DAG filters */ ORDER BY sq.chem_nm_sort, sq.gene_symbol_sort, d.nm, gt.nm_sort) sqi;

Date: 2026-05-20 11:16:56
Duration: 48s62ms
Database: ctddev51
User: pub1
Application: pgAdmin 4 - CONN:9681020

x Hide

Times Reported Time consuming queries #3

x Hide

WITH sq AS ( SELECT c.id AS chem_id, c.nm AS chem_nm, c.acc_txt AS chem_acc_txt, c.secondary_nm AS casRN, gcr.gene_id, g.nm AS gene_symbol, g.acc_txt AS gene_acc_txt FROM term c JOIN gene_chem_reference gcr ON gcr.chem_id = c.id JOIN term g ON g.id = gcr.gene_id WHERE c.acc_txt = 'D015056' GROUP BY c.id, c.nm, c.acc_txt, c.secondary_nm, gcr.gene_id, g.nm, g.acc_txt ) SELECT 'D015056' AS "Input", sq.chem_nm AS "ChemicalName", sq.chem_acc_txt AS "ChemicalID", sq.casRN AS "CasRN", sq.gene_symbol AS "GeneSymbol", sq.gene_acc_txt AS "GeneID", d.nm AS "Ontology", gt.nm AS "GoTermName", gt.acc_txt AS "GoTermID" FROM sq JOIN gene_go_annot gga ON gga.gene_id = sq.gene_id AND gga.is_not = false JOIN dag_node gt ON gt.object_id = gga.go_term_id JOIN dag d ON d.id = gt.dag_id GROUP BY sq.chem_nm, sq.chem_acc_txt, sq.casRN, sq.gene_symbol, sq.gene_acc_txt, d.nm, gt.nm, gt.acc_txt ORDER BY sq.chem_nm, sq.gene_symbol, d.nm, gt.nm; --CREATE INDEX idx_gga_gene_not_go -- ON gene_go_annot ( -- gene_id, is_not, -- go_term_id );

Date: 2026-05-20 11:13:25
Duration: 40s736ms

x Hide

Times Reported Time consuming queries #4

x Hide

CREATE INDEX CONCURRENTLY idx_gga_gene_not_go ON gene_go_annot (gene_id, is_not, go_term_id);

Date: 2026-05-20 11:09:58
Duration: 26s620ms

CREATE INDEX CONCURRENTLY idx_gga_gene_not_go ON gene_go_annot (gene_id, is_not, go_term_id);

Date: 2026-05-20 11:09:46
Duration: 0ms
Database: ctddev51
User: pub1
Application: pgAdmin 4 - CONN:7673166

x Hide

Times Reported Time consuming queries #5

x Hide

CREATE INDEX idx_gga_gene_not_go ON gene_go_annot (gene_id, is_not, go_term_id);

Date: 2026-05-20 11:12:33
Duration: 14s7ms

CREATE INDEX idx_gga_gene_not_go ON gene_go_annot (gene_id, is_not, go_term_id);

Date: 2026-05-20 11:12:33
Duration: 0ms

x Hide