From: Tom Hughes Date: Tue, 5 Aug 2014 08:24:20 +0000 (+0100) Subject: Restore original limits for user lists in statistics X-Git-Tag: live~4336 X-Git-Url: https://git.openstreetmap.org/rails.git/commitdiff_plain/7c75767c9bee739b72e37f6508b8db8c1d9d02f9 Restore original limits for user lists in statistics --- diff --git a/script/statistics b/script/statistics index c5d401227..ce785bb07 100755 --- a/script/statistics +++ b/script/statistics @@ -62,9 +62,9 @@ begin puts "" puts "" - day_users = OldNode.where("timestamp > NOW() - '1 DAY'::INTERVAL").joins(:changeset).order("count_all DESC").limit(50).group(:user_id).count - week_users = OldNode.where("timestamp > NOW() - '7 DAYS'::INTERVAL").joins(:changeset).order("count_all DESC").limit(50).group(:user_id).count - month_users = OldNode.where("timestamp > NOW() - '28 DAYS'::INTERVAL").joins(:changeset).order("count_all DESC").limit(50).group(:user_id).count + day_users = OldNode.where("timestamp > NOW() - '1 DAY'::INTERVAL").joins(:changeset).order("count_all DESC").group(:user_id).count + week_users = OldNode.where("timestamp > NOW() - '7 DAYS'::INTERVAL").joins(:changeset).order("count_all DESC").limit(60).group(:user_id).count + month_users = OldNode.where("timestamp > NOW() - '28 DAYS'::INTERVAL").joins(:changeset).order("count_all DESC").limit(60).group(:user_id).count day_users.zip(week_users, month_users).each do |row| puts ""
DayWeekMonth