Indexer performance issues on L2's

[kaladinlight]

Overview

There has been a large increase in 500's when fetching tx history from L2's specifically related to accounts with a lot of spam token/nft airdrops in their transaction history

References and additional details

https://indexer.gnosis.shapeshift.com/api/v2/address/0x6bF198c2B5c8E48Af4e876bc2173175b89b1DA0C?details=txs

Acceptance Criteria

• think about any quick monkey patches that could help reduce the amount of 500's
  • lower page size in client
  • owned txhistory flag to remove token transfers that aren't associated with the tx history account
• get a fresh indexer sync to see if there was an issue with db performance due to corruption/bloat
• determine if the issue is related to and fix accordingly:
  • db performance
  • extra node traffic when fetching tx history (indexer side)
  • request payload size affecting performance

Need By Date

No response

Screenshots/Mockups

No response

Estimated effort

No response