How to get the total number of groups in Jira Data Center
Platform Notice: Data Center - This article applies to Atlassian products on the Data Center platform.
Note that this knowledge base article was created for the Data Center version of the product. Data Center knowledge base articles for non-Data Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Purpose
Having too many groups in your Jira Server and Data Center instance can impact instance stability — including outages and noticeable performance drops under heavy load — increase the time for directory synchronization and user authentication, and cause the unresponsiveness of the application access and group management UI.
If you’re experiencing performance issues or want to make sure that you don’t exceed the recommended guardrails, check the total number of groups.
Solution
To get the total number of groups in your system, run the appropriate query against your database:
PostgreSQL, MySQL, Oracle Database
SELECT DISTINCT count(*)
AS group_count
FROM cwd_group; Microsoft SQL Server
SELECT DISTINCT count(*)
as group_count
FROM [jiraschema].cwd_group;