search

filecoin-project / lily

capturing on-chain state for the filecoin network
Other
48 stars 45 forks source link

Add index to fevm_transactions and fevm_traces #1260

Open birdychang opened 1 year ago

birdychang commented 1 year ago 
CREATE INDEX IF NOT EXISTS fevm_transactions_from_idx ON visor.fevm_transactions USING BTREE ("from");
CREATE INDEX IF NOT EXISTS fevm_transactions_to_idx ON visor.fevm_transactions USING BTREE ("to");
CREATE INDEX IF NOT EXISTS fevm_traces_from_idx ON visor.fevm_traces USING BTREE ("from");
CREATE INDEX IF NOT EXISTS fevm_traces_to_idx ON visor.fevm_traces USING BTREE ("to");
birdychang commented 1 year ago

@Terryhung this is done?