0
0
Fork 0
mirror of https://github.com/discourse/discourse.git synced 2026-08-12 05:37:26 +08:00
discourse/app/models/concerns/reports
Alan Guo Xiang Tan 395077a745
PERF: Use daily rollups for DAU/MAU reports (#41958)
DAU/MAU reports previously calculated every requested date from the full
user visit history, so dashboard requests became slower as that history
grew.

Persist the daily DAU and trailing-30-day MAU values and have the shared
report read only those rollups. The scheduled job builds all existing
history on its first successful run, then refreshes yesterday and today
every three hours. Replacements are atomic, so a failed calculation
leaves the previous report data intact.
2026-07-24 09:52:40 +08:00
..
activity_by_category.rb PERF: Improve activity by category report by doing it one-pass across the (e.g.) 2 year date period (#40945) 2026-06-16 23:45:06 +08:00
admin_logins.rb DEV: rename staff_logins report to admin_logins (#39840) 2026-05-11 10:49:09 +10:00
associated_accounts_by_provider.rb
bookmarks.rb
consolidated_api_requests.rb
consolidated_page_views.rb
consolidated_page_views_browser_detection.rb
daily_engaged_users.rb PERF: Compute dashboard KPIs in a single pass (#40705) 2026-06-10 21:09:27 +08:00
dau_by_mau.rb PERF: Use daily rollups for DAU/MAU reports (#41958) 2026-07-24 09:52:40 +08:00
emails.rb
flags.rb
flags_status.rb
likes.rb
mobile_visits.rb
moderator_warning_private_messages.rb
moderators_activity.rb
new_contributors.rb PERF: Compute dashboard KPIs in a single pass (#40705) 2026-06-10 21:09:27 +08:00
notify_moderators_private_messages.rb
notify_user_private_messages.rb
post_edits.rb SECURITY: Do not leak PM post edits to moderators 2026-03-19 15:21:28 +00:00
posters_by_member_type.rb FEATURE: Make "Who's posting?" category filter multi-select (#41837) 2026-07-22 15:55:28 +03:00
posts.rb
profile_views.rb
signups.rb
site_traffic.rb FEATURE: Add site traffic dashboard section (#40023) 2026-05-19 14:08:21 +08:00
storage_stats.rb
suspicious_logins.rb FIX: Suspicious login IPs bypass the moderator IP-visibility setting (#40154) 2026-05-22 13:22:32 +08:00
system_private_messages.rb
time_to_first_response.rb DEV: Fix assigned but unused variable Prism warnings (#39436) 2026-04-22 12:42:14 +02:00
top_countries_by_browser_pageviews.rb FEATURE: Drill-down and pagination for top referrers/countries (#40364) 2026-06-02 09:57:39 +08:00
top_ignored_users.rb
top_referred_topics.rb
top_referrers.rb
top_referrers_by_browser_pageviews.rb Revert "FEATURE: Surface Direct traffic in the Top referrers dashboard card (#40470)" (#40508) 2026-06-03 10:24:24 +08:00
top_traffic_sources.rb
top_uploads.rb
top_users_by_likes_received.rb
top_users_by_likes_received_from_a_variety_of_people.rb
top_users_by_likes_received_from_inferior_trust_level.rb
topic_view_stats.rb
topics.rb
topics_with_no_response.rb
trending_search.rb
trust_level_growth.rb
trust_level_pipeline.rb UX: Trust level section functional redesign (#41231) 2026-07-02 13:31:28 +08:00
user_flagging_ratio.rb
user_to_user_private_messages.rb
user_to_user_private_messages_with_replies.rb
users_by_trust_level.rb
users_by_type.rb
visits.rb DEV: Remove reporting_improvements upcoming change (#41259) 2026-07-01 07:52:02 +08:00
web_crawlers.rb
web_hook_events_daily_aggregate.rb