Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

stats: improve query performance using new columns #909

Closed
bragov4ik opened this issue Jun 6, 2024 · 3 comments · Fixed by #1044
Closed

stats: improve query performance using new columns #909

bragov4ik opened this issue Jun 6, 2024 · 3 comments · Fixed by #1044
Assignees
@bragov4ik
Labels
enhancement New feature or request
Milestone
stats

Comments

@bragov4ik
Copy link
Contributor

bragov4ik commented Jun 6, 2024 •
edited
Loading

block_consensus and block_timestamp are now present in transactions table.
migration_status might be used to determine if the columns were actually added.
@bragov4ik bragov4ik added this to the stats milestone Jun 6, 2024
@bragov4ik bragov4ik added the enhancement New feature or request label Jun 6, 2024
@bragov4ik bragov4ik self-assigned this Jun 6, 2024
@vbaranov
Copy link
Member

vbaranov commented Jun 7, 2024

In addition, block_consensus and token_type fields have been added to token_transfers table during its denormalization.

@bragov4ik
Copy link
Contributor Author

bragov4ik commented Aug 26, 2024 •
edited
Loading

Also maybe transaction_stats table may be used for gas-related stats? 🤔 Should verify once I start working on this issue

@bragov4ik bragov4ik linked a pull request Sep 12, 2024 that will close this issue
perf(stats): query optimization #1044
Merged
@bragov4ik
Copy link
Contributor Author

checked metrics after v2 + these optimizations

calculated average time (per 24 hours) spent on SQL queries in three instances:
ETC: -23440 secs
ETH: -30004 secs
OP: -38415 secs

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@bragov4ik bragov4ik

Labels
enhancement New feature or request
Projects
None yet
Milestone
stats
Development

Successfully merging a pull request may close this issue.

perf(stats): query optimization blockscout/blockscout-rs
2 participants
@vbaranov @bragov4ik