What is the most efficient way to count total user sessions? #42748

xgp · 2025-09-18T17:24:41Z

xgp
Sep 18, 2025

In order to get a count of the current number of total sessions, we're currently calling the /client-session-stats endpoint and adding up all of the results from each client's count. E.g.

      Http.Response response =
          Http.doGet(adminApi(host, realm, "client-session-stats"), session)
              .auth(keycloak.tokenManager().getAccessTokenString())
              .asResponse();
      List<ClientSessionStats> stats =
          response.asJson(new TypeReference<List<ClientSessionStats>>() {});
      long cnt = 0;
      for (ClientSessionStats stat : stats) {
        cnt += stat.getTotalSessions();
      }
      return cnt;

We have noticed that the request can take several seconds on the server side if there are 10's or 100's of thousands of sessions.

Is there a better way to count total user sessions? We can do this as an extension, so I'm curious if anyone has found a better way, either with the Admin API, some internal interface, either for Keycloak or Infinispan?

Navigation Menu

Repository navigation

What is the most efficient way to count total user sessions? #42748

Uh oh!

{{title}}

Uh oh!

Replies: 0 comments

Select a reply

Uh oh!

What is the most efficient way to count total user sessions? #42748

Uh oh!

xgp Sep 18, 2025

Replies: 0 comments

xgp
Sep 18, 2025