Describe the bug
Neither request_log nor validator_log tables have any indexes beyond the primary key. As data grows, queries filtering by request_id, status, or inserted_at will degrade. Add indexing in both the request_log and validator_log tables.
To Reproduce
Steps to reproduce the behavior:
- Go to '...'
- Click on '....'
- Scroll down to '....'
- See error
Expected behavior
A clear and concise description of what you expected to happen.
Screenshots
If applicable, add screenshots to help explain your problem.
Additional context
Add any other context about the problem here.
Describe the bug
Neither request_log nor validator_log tables have any indexes beyond the primary key. As data grows, queries filtering by request_id, status, or inserted_at will degrade. Add indexing in both the request_log and validator_log tables.
To Reproduce
Steps to reproduce the behavior:
Expected behavior
A clear and concise description of what you expected to happen.
Screenshots
If applicable, add screenshots to help explain your problem.
Additional context
Add any other context about the problem here.