KeyCloak - List group members API - takes long duration (25 sec for 360 users)

[Harshith DA]

Hi All,

 

We are using keycloak for our application as Auth provider. We have around 360 users in our test environment and we are using keycloak group feature as well. 

API to list group members takes around 25 seconds to return 360 users list as JSON response. 

• https://keycloak-test-env/auth/admin/realms/pwc-realm/groups/70188e5e-9eb1-4c39-8f1a-4d38850299cb/members?first=1&max=500

 

Upon checking the DB queries we found that for every user this API hits 3 DB queries from CREDENTIAL , USER_REQUIRED_ACTION and USER_ATTRIBUTE, so for 360 users its querying DB 1080 times (360 * 3), please find attached logs for DB queries. is this expected behaviour? Is there any way we can enhance this API performance? 

 

Is this behaviour already known? And is this something that will be fixed? 

 

Note – we are already aware that about the parameter briefRepresentation=true, which returns basic information and reduces the response time. But we do need the additional information returned without this parameter. 

 

Thanks,

Harshith