X-Git-Url: http://git.squeep.com/?a=blobdiff_plain;f=lib%2Fpleroma%2Fstats.ex;h=2e7d747df9c2a6b9a978a005937abbef1c9bc454;hb=fb82f6fc7c5453e34e619c54a88e64e99deb58b4;hp=0484f1a2d5c7bcfbeb2a39c0e86e545aca82c61b;hpb=dffde6631d105949b62c1ff27c22fefcb873b2e8;p=akkoma

diff --git a/lib/pleroma/stats.ex b/lib/pleroma/stats.ex
index 0484f1a2d..2e7d747df 100644
--- a/lib/pleroma/stats.ex
+++ b/lib/pleroma/stats.ex
@@ -1,7 +1,11 @@
+# Pleroma: A lightweight social networking server
+# Copyright © 2017-2019 Pleroma Authors <https://pleroma.social/>
+# SPDX-License-Identifier: AGPL-3.0-only
+
 defmodule Pleroma.Stats do
-  use Agent
   import Ecto.Query
-  alias Pleroma.{User, Repo, Activity}
+  alias Pleroma.Repo
+  alias Pleroma.User
 
   def start_link do
     agent = Agent.start_link(fn -> {[], %{}} end, name: __MODULE__)
@@ -19,22 +23,32 @@ defmodule Pleroma.Stats do
 
   def schedule_update do
     spawn(fn ->
-      Process.sleep(1000 * 60 * 60 * 1) # 1 hour
+      # 1 hour
+      Process.sleep(1000 * 60 * 60)
       schedule_update()
     end)
+
     update_stats()
   end
 
   def update_stats do
-    peers = from(u in Pleroma.User,
-      select: fragment("distinct ?->'host'", u.info),
-      where: u.local != ^true)
-    |> Repo.all()
+    peers =
+      from(
+        u in Pleroma.User,
+        select: fragment("distinct split_part(?, '@', 2)", u.nickname),
+        where: u.local != ^true
+      )
+      |> Repo.all()
+      |> Enum.filter(& &1)
+
     domain_count = Enum.count(peers)
-    status_query = from(u in User.local_user_query,
-      select: fragment("sum((?->>'note_count')::int)", u.info))
-    status_count = Repo.one(status_query) |> IO.inspect
-    user_count = Repo.aggregate(User.local_user_query, :count, :id)
+
+    status_query =
+      from(u in User.local_user_query(), select: fragment("sum((?->>'note_count')::int)", u.info))
+
+    status_count = Repo.one(status_query)
+    user_count = Repo.aggregate(User.active_local_user_query(), :count, :id)
+
     Agent.update(__MODULE__, fn _ ->
       {peers, %{domain_count: domain_count, status_count: status_count, user_count: user_count}}
     end)