Why is the permissions screen slow to load

Subject 

Artifactory permissions UI and API can be slow when loading a large amount of permission targets

Affected Versions

5.8.9 to 6.0

Description

This is caused by by a change in Access queries that joins a non-indexed column.  This can cause slowness as permission targets approach 20k permission targets

Resolution

The Issue is fixed in 6.1.0
If an upgrade is not immediately feasible, the issue can be mitigated by adding the following index to the table ACCESS_PERMISSION_ACTION on the table perm_ID:

articapital=# CREATE INDEX access_perm_action_perm_id_idx ON access_permission_action (perm_id);