defmodule Pleroma.Stats do
- use Agent
import Ecto.Query
- alias Pleroma.{User, Repo, Activity}
+ alias Pleroma.{User, Repo}
def start_link do
- agent = Agent.start_link(fn -> %{} end, name: __MODULE__)
- schedule_update()
+ agent = Agent.start_link(fn -> {[], %{}} end, name: __MODULE__)
+ spawn(fn -> schedule_update() end)
agent
end
- def get do
- Agent.get(__MODULE__, fn stats -> stats end)
+ def get_stats do
+ Agent.get(__MODULE__, fn {_, stats} -> stats end)
+ end
+
+ def get_peers do
+ Agent.get(__MODULE__, fn {peers, _} -> peers end)
end
def schedule_update do
- update_stats()
spawn(fn ->
- Process.sleep(1000 * 60 * 60 * 1) # 1 hour
+ # 1 hour
+ Process.sleep(1000 * 60 * 60 * 1)
schedule_update()
end)
+
+ update_stats()
end
def update_stats do
- peers = from(u in Pleroma.User,
- select: fragment("?->'host'", u.info),
- where: u.local != ^true)
- |> Repo.all() |> Enum.uniq()
+ peers =
+ from(
+ u in Pleroma.User,
+ select: fragment("distinct ?->'host'", u.info),
+ where: u.local != ^true
+ )
+ |> Repo.all()
+
domain_count = Enum.count(peers)
- status_query = from p in Activity,
- where: p.local == ^true,
- where: fragment("?->'object'->>'type' = ?", p.data, ^"Note")
- status_count = Repo.aggregate(status_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.local_user_query(), :count, :id)
+
Agent.update(__MODULE__, fn _ ->
- %{peers: peers, domain_count: domain_count, status_count: status_count}
+ {peers, %{domain_count: domain_count, status_count: status_count, user_count: user_count}}
end)
end
end