search

flashbots / mev-inspect-rs

Discover historic Miner Extractable Value (MEV) opportunities
MIT License
547 stars 127 forks source link

Add inserted_at field to DB table #27

Closed jparyani closed 3 years ago

jparyani commented 3 years ago

It defaults to now(), so we don't need to explicitly fill it in

jparyani commented 3 years ago

Yep, I'll try to run the ALTER. I'm worried it might take a very long time. I'm also going to add an index to this column as well as block_number. I'll document the commands in https://github.com/flashbots/sql/tree/main/scripts

jparyani commented 3 years ago

Done in https://github.com/flashbots/sql/blob/main/scripts/onetime/mev_inspections_add_inserted_at.sql and added indices in https://github.com/flashbots/sql/blob/main/scripts/create_indices_on_transactions.sql