fix(eventindexer): add indexes for struggling queries

[cyberhorsey]

Jolnir is having some data querying and long lived connection issues due to the size of the tables. Before we tackle this on a devops level and introduce database partitioning and other such things, we can pre-meditatively set ourselves up on the next testnet by identifying indexes on struggling queries, and also changing a bunch of our existing queries to use columns that have indexes.

[vercel]

The latest updates on your projects. Learn more about Vercel for Git ↗︎

Name	Status	Preview	Updated (UTC)
bridge-ui-v2-a5	✅ Ready (Inspect)	Visit Preview	Jan 11, 2024 11:46pm
bridge-ui-v2-a6	✅ Ready (Inspect)	Visit Preview	Jan 11, 2024 11:46pm
bridge-ui-v2-internal	✅ Ready (Inspect)	Visit Preview	Jan 11, 2024 11:46pm

[codecov]

Codecov Report

All modified and coverable lines are covered by tests ✅

❗ No coverage uploaded for pull request base (alpha-6@62eebe4). Click here to learn what that means.

Additional details and impacted files

@@            Coverage Diff             @@
##             alpha-6   #15483   +/-   ##
==========================================
  Coverage           ?   27.23%           
==========================================
  Files              ?       92           
  Lines              ?     5683           
  Branches           ?        0           
==========================================
  Hits               ?     1548           
  Misses             ?     3972           
  Partials           ?      163           

Flag	Coverage Δ		*Carryforward flag
eventindexer	17.45% <0.00%> (?)
guardian-prover-health-check	34.84% <0.00%> (?)		Carriedforward from 5204b72
relayer	39.98% <0.00%> (?)		Carriedforward from 5204b72

*This pull request uses carry forward flags. Click here to find out more.

☔ View full report in Codecov by Sentry.
📢 Have feedback on the report? Share it here.