near / near-indexer-for-explorer

Watch NEAR network and store all the data from NEAR blockchain to PostgreSQL database
https://near-indexers.io/docs/projects/near-indexer-for-explorer
GNU General Public License v3.0
123 stars 56 forks source link

feat: Store index in chunk and block timestamp in transactions and receipts tables for better indexing #21

Closed khorolets closed 4 years ago

frol commented 4 years ago

Also, add the block_timestamp column, so we can easily order the transactions and count how many transactions were processed in the last 24 hours without a need to do an expensive JOIN.

frol commented 4 years ago

We also need to have indices on block_timestamp columns

khorolets commented 4 years ago

Closed by #30