MetricsDAO / harmony_dbt

DBT Project for the Harmony Blockchain
12 stars 8 forks source link

Bug Report: Gas Used not matching the explorer #133

Closed forgxyz closed 2 years ago

forgxyz commented 2 years ago

Flipside user has reported that the gas used is not matching what Harmony explorer shows.

Example tx: 0x6efe00fc988884b9c5cc97960716e28aa4ec2743a23c851c8d5ff46270dfb33d

Screenshot 2022-07-06 at 10 29 32 AM Screenshot 2022-07-06 at 10 29 41 AM
eevui commented 2 years ago

I'd like to pick this up.

Cursory peek at it, it's because the model uses the cumulative gas field of the receipts. Understandably, it could be read as the cumulative gas used for the entire transaction. However, this actually refers to the cumulative gas used for the entire block.

I'll write up a new query to account for this and will submit a PR later on.