X-Git-Url: https://git.openstreetmap.org./rails.git/blobdiff_plain/b10dd0949ddb7c6002b2bb1513c4c0a54f5fac4f..7c75767c9bee739b72e37f6508b8db8c1d9d02f9:/script/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