This issue may occur on systems where the T_AV_EXPLODEDUSERENTITLEMENTS table is very large. Normally database statistics is run on this table after each collection. In some instances, the cost of this run may be more than the benefit.
This issue is resolved in the following versions that introduce a Custom Parameter CollectorStatsConditional that can be used to enable conditional Database Statistics on the T_AV_EXPLODEDUSERENTITLEMENTS table.
RSA Identity Governance & Lifecycle 7.2.1 P04
RSA Identity Governance & Lifecycle 7.5.0
After patching to the version where this is resolved, set the following parameter from Admin > System > Settings > Custom section. When this parameter is set, the Database Statistics will only run on the T_AV_EXPLODEDUSERENTITLEMENTS table if more than 5% of the table has changed.