search

hashgraph / hedera-mirror-node

Hedera Mirror Node archives data from consensus nodes and serves it via an API
Apache License 2.0
117 stars 110 forks source link

Update contract log query for Citus performance (0.107) #8624

Closed edwin-greene closed 6 days ago

edwin-greene commented 6 days ago

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

Related issue(s):

Fixes https://github.com/hashgraph/hedera-mirror-node/issues/8573 Fixes https://github.com/hashgraph/hedera-mirror-node/issues/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

sonarcloud[bot] commented 6 days ago

Quality Gate Passed 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

codecov[bot] commented 6 days ago

Codecov Report

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

Project coverage is 92.42%. Comparing base (9f0f155) to head (b84209e).

Additional details and impacted files ```diff @@ Coverage Diff @@ ## release/0.107 #8624 +/- ## =================================================== - Coverage 92.42% 92.42% -0.01% Complexity 7474 7474 =================================================== Files 913 913 Lines 29789 29807 +18 Branches 3623 3628 +5 =================================================== + Hits 27533 27548 +15 - Misses 1437 1440 +3 Partials 819 819 ```

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