<commit_before>BEGIN; -- transaction

CREATE INDEX tmpidx_pk_corpus ON _corpus USING HASH  (id);
CREATE INDEX tmpidx_pk_node ON _node USING HASH (id);
CREATE INDEX tmpidx_pk_node_token ON _node(id) WHERE token_index is not null;
CREATE INDEX tmpidx_fk_node_annotation ON _node_annotation USING HASH (node_ref);
CREATE INDEX tmpidx_pk_component ON _component USING HASH (id);
CREATE INDEX tmpidx_fk1_rank ON _rank USING HASH (node_ref);
CREATE INDEX tmpidx_fk2_rank ON _rank USING HASH (component_ref);
CREATE INDEX tmpidx_rank_pre ON _rank USING HASH (pre);
CREATE INDEX tmpidx_fk2_component_type ON _component ("type");
CREATE INDEX tmpidx_fk_edge_annotation ON _edge_annotation USING HASH (rank_ref);

END; -- transaction<commit_msg>arg...<commit_after>BEGIN; -- transaction

CREATE INDEX tmpidx_pk_corpus ON _corpus USING HASH  (id);
CREATE INDEX tmpidx_pk_node ON _node USING HASH (id);
CREATE INDEX tmpidx_pk_node_token ON _node(id) WHERE token_index is not null;
CREATE INDEX tmpidx_fk_node_annotation ON _node_annotation USING HASH (node_ref);
CREATE INDEX tmpidx_pk_component ON _component USING HASH (id);
CREATE INDEX tmpidx_fk1_rank ON _rank USING HASH (node_ref);
CREATE INDEX tmpidx_fk2_rank ON _rank USING HASH (component_ref);
CREATE INDEX tmpidx_rank_pre ON _rank (pre);
CREATE INDEX tmpidx_rank_parent ON _rank USING HASH (parent);
CREATE INDEX tmpidx_fk2_component_type ON _component ("type");
CREATE INDEX tmpidx_fk_edge_annotation ON _edge_annotation USING HASH (rank_ref);

END; -- transaction
{'fraction_non_alphanumeric': 0.05812417437252312, 'fraction_numerical': 0.003963011889035667, 'mean_word_length': 6.809278350515464, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 3, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '6638014', 'n_tokens_mistral': 520, 'n_tokens_neox': 517, 'n_words': 173}