IdStory Identity Manager

Please implement some feature that allow removing workflow instances after synchronization. Or update behavior of synchronization with execute workflow that workflow will not be archived, just executed.

• project has daily reconciliation with some end system,
• for every situation exists project specific workflow,
• daily is created about 16.000 operations by this reconciliation,
• activity tables has now about 1.300.000,
• user request for roles now sometimes ended with exception with timeout,
• in logs or etc doesn't exists any error log.

We founded this by checking database and lock on tables. Examples:

SELECT relation::regclass, * FROM pg_locks;

SELECT datname
, usename
, wait_event_type
, wait_event
, pg_blocking_pids(pid) AS blocked_by
, query
FROM pg_stat_activity
WHERE wait_event IS NOT NULL;