VACUUM FULL ANALYZE;

Date: 2025-10-01 10:34:11
Duration: 49m4s

VACUUM FULL ANALYZE;

Date: 2025-10-01 03:49:14
Duration: 0ms

x Hide

CLUSTER pub1.TERM;

Date: 2025-10-01 03:48:32
Duration: 1m5s

CLUSTER pub1.TERM;

Date: 2025-10-01 09:44:27
Duration: 1m

CLUSTER pub1.TERM;

Date: 2025-10-01 03:47:38
Duration: 0ms

x Hide

CLUSTER pub1.TERM_LABEL;

Date: 2025-10-01 03:49:11
Duration: 39s527ms

CLUSTER pub1.TERM_LABEL;

Date: 2025-10-01 09:45:05
Duration: 38s115ms

CLUSTER pub1.TERM_LABEL;

Date: 2025-10-01 03:48:39
Duration: 0ms

x Hide

select pub1.maint_cached_value_refresh_data_metrics ();

Date: 2025-10-01 13:30:46
Duration: 37m9s

select pub1.maint_cached_value_refresh_data_metrics ();

Date: 2025-10-01 13:26:11
Duration: 0ms

x Hide

Times Reported Time consuming queries #1

x Hide

select pub1.maint_term_derive_data ();

Date: 2025-10-01 12:43:23
Duration: 2h8m48s
Bind query: yes

x Hide

Times Reported Time consuming queries #2

x Hide

SELECT maint_term_derive_nm_fts ();

Date: 2025-10-01 03:43:12
Duration: 1h40s
Bind query: yes

SELECT maint_term_derive_nm_fts ();

Date: 2025-10-01 09:38:32
Duration: 7m21s
Bind query: yes

x Hide

Times Reported Time consuming queries #3

x Hide

VACUUM FULL ANALYZE;

Date: 2025-10-01 10:34:11
Duration: 49m4s
Bind query: yes

VACUUM FULL ANALYZE;

Date: 2025-10-01 03:49:14
Duration: 0ms

x Hide

Times Reported Time consuming queries #4

x Hide

select pub1.maint_cached_value_refresh_data_metrics ();

Date: 2025-10-01 13:30:46
Duration: 37m9s
Bind query: yes

select pub1.maint_cached_value_refresh_data_metrics ();

Date: 2025-10-01 13:26:11
Duration: 0ms

x Hide

Times Reported Time consuming queries #5

x Hide

[ User: qaeu - Total duration: 35m44s - Times executed: 1 ]

x Hide

SELECT /* AllGDRelationsDAO */ g.nm "GeneSymbol", g.acc_txt "GeneID", d.nm "DiseaseName", d.acc_db_cd || ':' || d.acc_txt "DiseaseID", CASE WHEN gdr.via_chem_id IS NULL THEN ( SELECT STRING_AGG(a.action_type_nm, '|' ORDER BY a.action_type_nm) FROM gene_disease_axn a WHERE a.gene_id = gdr.gene_id AND a.disease_id = gdr.disease_id) ELSE NULL END "DirectEvidence", c.nm "InferenceChemicalName", gdr.network_score "InferenceScore", STRING_AGG(gdr.source_acc_txt, '|' ORDER BY gdr.source_acc_txt) "OmimIDs", STRING_AGG(r.acc_txt, '|' ORDER BY r.acc_txt) "PubMedIDs" FROM gene_disease_reference gdr INNER JOIN term g ON gdr.gene_id = g.id INNER JOIN term d ON gdr.disease_id = d.id LEFT OUTER JOIN reference r ON gdr.reference_id = r.id LEFT OUTER JOIN term c ON gdr.via_chem_id = c.id GROUP BY g.nm, g.acc_txt, d.nm, d.acc_db_cd || ':' || d.acc_txt, CASE WHEN gdr.via_chem_id IS NULL THEN ( SELECT STRING_AGG(a.action_type_nm, '|' ORDER BY a.action_type_nm) FROM gene_disease_axn a WHERE a.gene_id = gdr.gene_id AND a.disease_id = gdr.disease_id) ELSE NULL END, c.nm, gdr.network_score ORDER BY g.nm, d.nm;

Date: 2025-10-01 15:20:38
Duration: 35m44s
Database: ctdprd51
User: qaeu
Bind query: yes

SELECT /* AllGDRelationsDAO */ g.nm "GeneSymbol", g.acc_txt "GeneID", d.nm "DiseaseName", d.acc_db_cd || ':' || d.acc_txt "DiseaseID", CASE WHEN gdr.via_chem_id IS NULL THEN ( SELECT STRING_AGG(a.action_type_nm, '|' ORDER BY a.action_type_nm) FROM gene_disease_axn a WHERE a.gene_id = gdr.gene_id AND a.disease_id = gdr.disease_id) ELSE NULL END "DirectEvidence", c.nm "InferenceChemicalName", gdr.network_score "InferenceScore", STRING_AGG(gdr.source_acc_txt, '|' ORDER BY gdr.source_acc_txt) "OmimIDs", STRING_AGG(r.acc_txt, '|' ORDER BY r.acc_txt) "PubMedIDs" FROM gene_disease_reference gdr INNER JOIN term g ON gdr.gene_id = g.id INNER JOIN term d ON gdr.disease_id = d.id LEFT OUTER JOIN reference r ON gdr.reference_id = r.id LEFT OUTER JOIN term c ON gdr.via_chem_id = c.id GROUP BY g.nm, g.acc_txt, d.nm, d.acc_db_cd || ':' || d.acc_txt, CASE WHEN gdr.via_chem_id IS NULL THEN ( SELECT STRING_AGG(a.action_type_nm, '|' ORDER BY a.action_type_nm) FROM gene_disease_axn a WHERE a.gene_id = gdr.gene_id AND a.disease_id = gdr.disease_id) ELSE NULL END, c.nm, gdr.network_score ORDER BY g.nm, d.nm;

Date: 2025-10-01 15:41:05
Duration: 5s451ms
Bind query: yes

SELECT /* AllGDRelationsDAO */ g.nm "GeneSymbol", g.acc_txt "GeneID", d.nm "DiseaseName", d.acc_db_cd || ':' || d.acc_txt "DiseaseID", CASE WHEN gdr.via_chem_id IS NULL THEN ( SELECT STRING_AGG(a.action_type_nm, '|' ORDER BY a.action_type_nm) FROM gene_disease_axn a WHERE a.gene_id = gdr.gene_id AND a.disease_id = gdr.disease_id) ELSE NULL END "DirectEvidence", c.nm "InferenceChemicalName", gdr.network_score "InferenceScore", STRING_AGG(gdr.source_acc_txt, '|' ORDER BY gdr.source_acc_txt) "OmimIDs", STRING_AGG(r.acc_txt, '|' ORDER BY r.acc_txt) "PubMedIDs" FROM gene_disease_reference gdr INNER JOIN term g ON gdr.gene_id = g.id INNER JOIN term d ON gdr.disease_id = d.id LEFT OUTER JOIN reference r ON gdr.reference_id = r.id LEFT OUTER JOIN term c ON gdr.via_chem_id = c.id GROUP BY g.nm, g.acc_txt, d.nm, d.acc_db_cd || ':' || d.acc_txt, CASE WHEN gdr.via_chem_id IS NULL THEN ( SELECT STRING_AGG(a.action_type_nm, '|' ORDER BY a.action_type_nm) FROM gene_disease_axn a WHERE a.gene_id = gdr.gene_id AND a.disease_id = gdr.disease_id) ELSE NULL END, c.nm, gdr.network_score ORDER BY g.nm, d.nm;

Date: 2025-10-01 15:34:17
Duration: 5s285ms
Bind query: yes

x Hide

Times Reported Time consuming queries #6

x Hide

select pub1.maint_phenotype_term_derive_data ();

Date: 2025-10-01 12:53:37
Duration: 9m4s
Bind query: yes

x Hide

Times Reported Time consuming queries #7

x Hide

SELECT maint_term_label_derive_nm_fts ();

Date: 2025-10-01 09:41:57
Duration: 3m5s
Bind query: yes

SELECT maint_term_label_derive_nm_fts ();

Date: 2025-10-01 03:46:00
Duration: 2m36s
Bind query: yes

x Hide

Times Reported Time consuming queries #8

x Hide

[ User: qaeu - Total duration: 2m32s - Times executed: 2 ]

x Hide

SELECT /* PhenotypeDiseasesDAO */ phenotypeTerm.nm "GOName", phenotypeTerm.acc_txt "GOID", diseaseTerm.nm "DiseaseName", diseaseTerm.acc_db_cd || ':' || diseaseTerm.acc_txt "DiseaseID", pt.via_chem_qty "InferenceChemicalQty", ( SELECT STRING_AGG(DISTINCT chemTermNetwork.nm, '|')) "InferenceChemicalNames", pt.via_gene_qty "InferenceGeneQty", ( SELECT STRING_AGG(DISTINCT geneTermNetwork.nm, '|')) "InferenceGeneSymbols" FROM phenotype_term_reference ptr INNER JOIN phenotype_term pt on ptr.phenotype_id = pt.phenotype_id AND ptr.term_id = pt.term_id INNER JOIN term phenotypeTerm on ptr.phenotype_id = phenotypeTerm.id INNER JOIN term diseaseTerm on ptr.term_id = diseaseTerm.id AND diseaseTerm.object_type_id = ( select id from object_type where cd = 'disease') LEFT OUTER JOIN term geneTermNetwork on ptr.via_term_id = geneTermNetwork.id AND geneTermNetwork.object_type_id = ( select id from object_type where cd = 'gene') LEFT OUTER JOIN term chemTermNetwork on ptr.via_term_id = chemTermNetwork.id AND chemTermNetwork.object_type_id = ( select id from object_type where cd = 'chem') WHERE phenotypeTerm.id IN ( SELECT dp.descendant_dag_node_id FROM dag_path dp WHERE dp.ancestor_object_id = ( select id from term where nm = 'biological_process')) AND ptr.source_cd = 'I' AND ptr.phenotype_id = phenotypeTerm.id AND ptr.term_id = diseaseTerm.id GROUP BY phenotypeTerm.nm, phenotypeTerm.acc_txt, diseaseTerm.nm, diseaseTerm.acc_db_cd || ':' || diseaseTerm.acc_txt, pt.via_chem_qty, pt.via_gene_qty;

Date: 2025-10-01 16:32:04
Duration: 2m20s
Database: ctdprd51
User: qaeu
Bind query: yes

SELECT /* PhenotypeDiseasesDAO */ phenotypeTerm.nm "GOName", phenotypeTerm.acc_txt "GOID", diseaseTerm.nm "DiseaseName", diseaseTerm.acc_db_cd || ':' || diseaseTerm.acc_txt "DiseaseID", pt.via_chem_qty "InferenceChemicalQty", ( SELECT STRING_AGG(DISTINCT chemTermNetwork.nm, '|')) "InferenceChemicalNames", pt.via_gene_qty "InferenceGeneQty", ( SELECT STRING_AGG(DISTINCT geneTermNetwork.nm, '|')) "InferenceGeneSymbols" FROM phenotype_term_reference ptr INNER JOIN phenotype_term pt on ptr.phenotype_id = pt.phenotype_id AND ptr.term_id = pt.term_id INNER JOIN term phenotypeTerm on ptr.phenotype_id = phenotypeTerm.id INNER JOIN term diseaseTerm on ptr.term_id = diseaseTerm.id AND diseaseTerm.object_type_id = ( select id from object_type where cd = 'disease') LEFT OUTER JOIN term geneTermNetwork on ptr.via_term_id = geneTermNetwork.id AND geneTermNetwork.object_type_id = ( select id from object_type where cd = 'gene') LEFT OUTER JOIN term chemTermNetwork on ptr.via_term_id = chemTermNetwork.id AND chemTermNetwork.object_type_id = ( select id from object_type where cd = 'chem') WHERE phenotypeTerm.id IN ( SELECT dp.descendant_dag_node_id FROM dag_path dp WHERE dp.ancestor_object_id = ( select id from term where nm = 'molecular_function')) AND ptr.source_cd = 'I' AND ptr.phenotype_id = phenotypeTerm.id AND ptr.term_id = diseaseTerm.id GROUP BY phenotypeTerm.nm, phenotypeTerm.acc_txt, diseaseTerm.nm, diseaseTerm.acc_db_cd || ':' || diseaseTerm.acc_txt, pt.via_chem_qty, pt.via_gene_qty;

Date: 2025-10-01 16:34:01
Duration: 12s935ms
Database: ctdprd51
User: qaeu
Bind query: yes

SELECT /* PhenotypeDiseasesDAO */ phenotypeTerm.nm "GOName", phenotypeTerm.acc_txt "GOID", diseaseTerm.nm "DiseaseName", diseaseTerm.acc_db_cd || ':' || diseaseTerm.acc_txt "DiseaseID", pt.via_chem_qty "InferenceChemicalQty", ( SELECT STRING_AGG(DISTINCT chemTermNetwork.nm, '|')) "InferenceChemicalNames", pt.via_gene_qty "InferenceGeneQty", ( SELECT STRING_AGG(DISTINCT geneTermNetwork.nm, '|')) "InferenceGeneSymbols" FROM phenotype_term_reference ptr INNER JOIN phenotype_term pt on ptr.phenotype_id = pt.phenotype_id AND ptr.term_id = pt.term_id INNER JOIN term phenotypeTerm on ptr.phenotype_id = phenotypeTerm.id INNER JOIN term diseaseTerm on ptr.term_id = diseaseTerm.id AND diseaseTerm.object_type_id = ( select id from object_type where cd = 'disease') LEFT OUTER JOIN term geneTermNetwork on ptr.via_term_id = geneTermNetwork.id AND geneTermNetwork.object_type_id = ( select id from object_type where cd = 'gene') LEFT OUTER JOIN term chemTermNetwork on ptr.via_term_id = chemTermNetwork.id AND chemTermNetwork.object_type_id = ( select id from object_type where cd = 'chem') WHERE phenotypeTerm.id IN ( SELECT dp.descendant_dag_node_id FROM dag_path dp WHERE dp.ancestor_object_id = ( select id from term where nm = 'biological_process')) AND ptr.source_cd = 'I' AND ptr.phenotype_id = phenotypeTerm.id AND ptr.term_id = diseaseTerm.id GROUP BY phenotypeTerm.nm, phenotypeTerm.acc_txt, diseaseTerm.nm, diseaseTerm.acc_db_cd || ':' || diseaseTerm.acc_txt, pt.via_chem_qty, pt.via_gene_qty;

Date: 2025-10-01 16:32:17
Duration: 6s581ms
Bind query: yes

x Hide

Times Reported Time consuming queries #9

x Hide

[ User: qaeu - Total duration: 2m18s - Times executed: 1 ]

x Hide

SELECT /* AllCuratedChemPhenoIxnsDAO */ chemTerm.nm ChemicalName, chemTerm.acc_txt ChemicalID, chemTerm.secondary_nm CasRN, phenoTerm.nm PhenotypeName, phenoTerm.acc_txt PhenotypeID, ( SELECT STRING_AGG(distinct coMentionTerm.nm || '^' || coMentionTerm.acc_txt || '^' || coMentionTerm.acc_db_cd, '|')) as coMentionedTerms, taxonTerm.nm Organism, taxonTerm.acc_txt OrganismID, i.ixn_prose_txt Interaction, i.actions_txt InteractionActions, ( SELECT STRING_AGG(distinct ia.level_seq + 1 || '^' || anatomyTerm.nm || '^' || anatomyTerm.acc_txt, '|' ORDER BY ia.level_seq + 1 || '^' || anatomyTerm.nm || '^' || anatomyTerm.acc_txt)) as anatomyTerms, STRING_AGG(distinct inferredTerm.nm || '^' || inferredTerm.acc_txt || '^' || inferredTerm.acc_db_cd, '|' ORDER BY inferredTerm.nm || '^' || inferredTerm.acc_txt || '^' || inferredTerm.acc_db_cd) InferenceGeneSymbols, STRING_AGG(distinct r.acc_txt, '|' ORDER BY r.acc_txt) PubMedIDs, ptr.ixn_id ignorecolumnIxnId FROM phenotype_term_reference ptr LEFT OUTER JOIN term taxonTerm ON ptr.taxon_id = taxonTerm.id INNER JOIN ixn i ON ptr.ixn_id = i.id INNER JOIN term phenoTerm ON ptr.phenotype_id = phenoTerm.id INNER JOIN reference r ON ptr.reference_id = r.id INNER JOIN term chemTerm ON ptr.term_id = chemTerm.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 LEFT OUTER JOIN phenotype_term_reference ptr2 ON ptr.ixn_id = ptr2.ixn_id and (ptr.term_id <> ptr2.term_id or ptr.phenotype_id <> ptr2.phenotype_id) LEFT OUTER JOIN phenotype_term_reference ptr3 ON ptr.term_id = ptr3.term_id and (ptr.phenotype_id = ptr3.phenotype_id and ptr3.source_cd = 'I') LEFT OUTER JOIN term coMentionTerm ON coMentionTerm.id = ptr2.term_id LEFT OUTER JOIN term inferredTerm ON inferredTerm.id = ptr3.via_term_id WHERE ptr.source_cd = 'C' AND ptr.term_object_type_id = ( SELECT ot.id FROM object_type ot WHERE ot.cd = 'chem') GROUP BY chemTerm.nm, chemTerm.acc_txt, chemTerm.secondary_nm, phenoTerm.nm, phenoTerm.acc_txt, taxonTerm.nm, taxonTerm.acc_txt, i.ixn_prose_txt, i.actions_txt, ptr.ixn_id ORDER BY chemTerm.nm, phenoTerm.nm;

Date: 2025-10-01 16:29:02
Duration: 2m18s
Database: ctdprd51
User: qaeu
Bind query: yes

x Hide

Times Reported Time consuming queries #10

x Hide

CLUSTER pub1.TERM;

Date: 2025-10-01 03:48:32
Duration: 1m5s
Bind query: yes

CLUSTER pub1.TERM;

Date: 2025-10-01 09:44:27
Duration: 1m
Bind query: yes

CLUSTER pub1.TERM;

Date: 2025-10-01 03:47:38
Duration: 0ms

x Hide

Times Reported Time consuming queries #11

x Hide

[ User: qaeu - Total duration: 1m22s - Times executed: 1 ]

x Hide

SELECT /* AllCDRelationsDAO */ c.nm "ChemicalName", c.acc_txt "ChemicalID", c.secondary_nm "CasRN", d.nm "DiseaseName", d.acc_db_cd || ':' || d.acc_txt "DiseaseID", a.action_type_nm "DirectEvidence", g.nm "InferenceGeneSymbol", cdr.network_score "InferenceScore", STRING_AGG(cdr.source_acc_txt, '|' ORDER BY cdr.source_acc_txt) "OmimIDs", STRING_AGG(r.acc_txt, '|' ORDER BY r.acc_txt) "PubMedIDs" FROM chem_disease_reference cdr INNER JOIN term d ON cdr.disease_id = d.id INNER JOIN term c ON cdr.chem_id = c.id LEFT OUTER JOIN chem_disease_reference_axn a ON cdr.id = a.chem_disease_reference_id LEFT OUTER JOIN reference r ON cdr.reference_id = r.id LEFT OUTER JOIN term g ON cdr.via_gene_id = g.id GROUP BY c.nm, c.nm_sort, c.acc_txt, c.secondary_nm, d.nm, d.acc_db_cd || ':' || d.acc_txt, a.action_type_nm, g.nm, cdr.network_score ORDER BY c.nm_sort, d.nm;

Date: 2025-10-01 14:37:44
Duration: 1m22s
Database: ctdprd51
User: qaeu
Bind query: yes

x Hide

Times Reported Time consuming queries #12

x Hide

CLUSTER pub1.TERM_LABEL;

Date: 2025-10-01 03:49:11
Duration: 39s527ms
Bind query: yes

CLUSTER pub1.TERM_LABEL;

Date: 2025-10-01 09:45:05
Duration: 38s115ms
Bind query: yes

CLUSTER pub1.TERM_LABEL;

Date: 2025-10-01 03:48:39
Duration: 0ms

x Hide

Times Reported Time consuming queries #13

x Hide

CREATE INDEX ftsix_term_nm ON pub1.TERM USING gin (nm_fts);

Date: 2025-10-01 03:46:40
Duration: 34s157ms
Bind query: yes

CREATE INDEX ftsix_term_nm ON pub1.TERM USING gin (nm_fts);

Date: 2025-10-01 09:42:39
Duration: 32s913ms
Bind query: yes

x Hide

Times Reported Time consuming queries #14

x Hide

VACUUM ANALYZE pub1.TERM;

Date: 2025-10-01 09:38:51
Duration: 19s605ms
Bind query: yes

VACUUM ANALYZE pub1.TERM;

Date: 2025-10-01 03:43:23
Duration: 11s384ms
Bind query: yes

VACUUM ANALYZE pub1.TERM;

Date: 2025-10-01 10:34:19
Duration: 8s336ms
Bind query: yes

x Hide

Times Reported Time consuming queries #15

x Hide

[ User: qaeu - Total duration: 40s186ms - Times executed: 1 ]

x Hide

SELECT /* AllGenesDAO */ t.nm "GeneSymbol", t.secondary_nm "GeneName", t.acc_txt "GeneID", ( SELECT STRING_AGG(DISTINCT l.acc_txt, '|' ORDER BY l.acc_txt) FROM db_link l WHERE l.object_type_id = t.object_type_id AND l.object_id = t.id AND l.type_cd = 'A' AND l.is_primary = false) "AltGeneIDs", ( SELECT STRING_AGG(DISTINCT tl.nm, '|' ORDER BY tl.nm) FROM term_label tl INNER JOIN term_label_type tlt ON tl.term_label_type_id = tlt.id WHERE tl.term_id = t.id AND tlt.nm = 'SYNONYM') "Synonyms", ( SELECT STRING_AGG(l.acc_txt, '|' ORDER BY l.acc_txt) FROM db_link l INNER JOIN db d on l.db_id = d.id WHERE l.object_id = t.id AND d.cd = 'BIOGRID' AND l.type_cd = 'X') "BioGRIDIDs", ( SELECT STRING_AGG(l.acc_txt, '|' ORDER BY l.acc_txt) FROM db_link l INNER JOIN db d on l.db_id = d.id WHERE l.object_id = t.id AND d.cd = 'PGKB' AND l.type_cd = 'X') "PharmGKBIDs", ( SELECT STRING_AGG(l.acc_txt, '|' ORDER BY l.acc_txt) FROM db_link l INNER JOIN db d on l.db_id = d.id WHERE l.object_id = t.id AND d.cd = 'SPTREM' AND l.type_cd = 'X') "UniProtIDs" FROM term t WHERE t.object_type_id = ( SELECT ot.id FROM object_type ot WHERE ot.cd = 'gene') ORDER BY t.nm_sort;

Date: 2025-10-01 14:28:11
Duration: 40s186ms
Database: ctdprd51
User: qaeu
Bind query: yes

SELECT /* AllGenesDAO */ t.nm "GeneSymbol", t.secondary_nm "GeneName", t.acc_txt "GeneID", ( SELECT STRING_AGG(DISTINCT l.acc_txt, '|' ORDER BY l.acc_txt) FROM db_link l WHERE l.object_type_id = t.object_type_id AND l.object_id = t.id AND l.type_cd = 'A' AND l.is_primary = false) "AltGeneIDs", ( SELECT STRING_AGG(DISTINCT tl.nm, '|' ORDER BY tl.nm) FROM term_label tl INNER JOIN term_label_type tlt ON tl.term_label_type_id = tlt.id WHERE tl.term_id = t.id AND tlt.nm = 'SYNONYM') "Synonyms", ( SELECT STRING_AGG(l.acc_txt, '|' ORDER BY l.acc_txt) FROM db_link l INNER JOIN db d on l.db_id = d.id WHERE l.object_id = t.id AND d.cd = 'BIOGRID' AND l.type_cd = 'X') "BioGRIDIDs", ( SELECT STRING_AGG(l.acc_txt, '|' ORDER BY l.acc_txt) FROM db_link l INNER JOIN db d on l.db_id = d.id WHERE l.object_id = t.id AND d.cd = 'PGKB' AND l.type_cd = 'X') "PharmGKBIDs", ( SELECT STRING_AGG(l.acc_txt, '|' ORDER BY l.acc_txt) FROM db_link l INNER JOIN db d on l.db_id = d.id WHERE l.object_id = t.id AND d.cd = 'SPTREM' AND l.type_cd = 'X') "UniProtIDs" FROM term t WHERE t.object_type_id = ( SELECT ot.id FROM object_type ot WHERE ot.cd = 'gene') ORDER BY t.nm_sort;

Date: 2025-10-01 14:28:34
Duration: 11s195ms
Bind query: yes