+# 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__)
- schedule_update()
+ spawn(fn -> schedule_update() end)
agent
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)
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 split_part(?, '@', 2)", u.nickname),
+ where: u.local != ^true
+ )
+ |> Repo.all()
+ |> Enum.filter(& &1)
+
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)
- 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)