Skip to content

Use fixed intervals instead of NOW() in queries#225

Merged
stordahl merged 1 commit intomainfrom
stordahl/query-perf
Sep 24, 2025
Merged

Use fixed intervals instead of NOW() in queries#225
stordahl merged 1 commit intomainfrom
stordahl/query-perf

Conversation

@stordahl
Copy link
Copy Markdown
Collaborator

@stordahl stordahl commented Sep 23, 2025

Closes #65

Queries are now using fixed intervals (5 minutes) which is already causing the dashboard to load faster. As called out in the issue, we're using toStartOfInterval to achieve this

@codecov
Copy link
Copy Markdown

codecov bot commented Sep 23, 2025

Codecov Report

✅ All modified and coverable lines are covered by tests.
✅ Project coverage is 80.36%. Comparing base (66c8505) to head (e1b0ef0).
⚠️ Report is 1 commits behind head on main.

Additional details and impacted files
@@            Coverage Diff             @@
##             main     #225      +/-   ##
==========================================
+ Coverage   80.34%   80.36%   +0.01%     
==========================================
  Files          56       56              
  Lines        4406     4410       +4     
  Branches      580      580              
==========================================
+ Hits         3540     3544       +4     
  Misses        857      857              
  Partials        9        9              

☔ View full report in Codecov by Sentry.
📢 Have feedback on the report? Share it here.

🚀 New features to boost your workflow:
  • ❄️ Test Analytics: Detect flaky tests, report on failures, and find test suite problems.
  • 📦 JS Bundle Analysis: Save yourself from yourself by tracking and limiting bundle sizes in JS merges.

@stordahl stordahl marked this pull request as ready for review September 23, 2025 15:11
@stordahl stordahl merged commit 80c31f5 into main Sep 24, 2025
3 checks passed
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

None yet

Projects

None yet

Development

Successfully merging this pull request may close these issues.

Investigate using fixed interval boundaries instead of NOW() when making date range queries

1 participant