Update contract log query for Citus performance

[edwin-greene]

Description: Updates the contract log query to increase performance in V2

Related issue(s):

Fixes #8573 Fixes #8574

Notes for reviewer: Prior explain analyze for query with data from mainnet-staging: Execution Time: 2149.675 ms Explain analyze for the updated query: Execution Time: 4.447 ms

Checklist

• [ ] Documented (Code comments, README, etc.)
• [x] Tested (unit, integration, etc.)

[codecov[bot]]

Codecov Report

All modified and coverable lines are covered by tests :white_check_mark:

Project coverage is 92.54%. Comparing base (fc9dd68) to head (3560512). Report is 21 commits behind head on main.

Additional details and impacted files

```diff @@ Coverage Diff @@ ## main #8595 +/- ## ============================================ + Coverage 92.42% 92.54% +0.12% + Complexity 7474 7372 -102 ============================================ Files 913 895 -18 Lines 29792 29571 -221 Branches 3626 3615 -11 ============================================ - Hits 27534 27366 -168 + Misses 1439 1384 -55 - Partials 819 821 +2 ```

:umbrella: View full report in Codecov by Sentry.
:loudspeaker: Have feedback on the report? Share it here.

[sonarcloud[bot]]

Quality Gate passed

Issues
0 New issues
0 Accepted issues

Measures
0 Security Hotspots
0.0% Coverage on New Code
0.0% Duplication on New Code

See analysis details on SonarCloud