| Actor | Fragment | Worker | State |
|---|---|---|---|
| 158936 | 18133 | 33 | running |
| 158937 | 18133 | 33 | running |
| 158940 | 18134 | 33 | running |
| 158941 | 18134 | 33 | running |
| 158942 | 18135 | 33 | running |
| 158943 | 18135 | 33 | running |
| 158944 | 18136 | 33 | running |
| 158945 | 18136 | 33 | running |
| 158948 | 18137 | 33 | running |
| 158949 | 18137 | 33 | running |
| 158953 | 18138 | 33 | running |
| 158954 | 18138 | 33 | running |
CREATE MATERIALIZED VIEW authz.team_to_tasks_mv AS
SELECT
team_id,
task_id,
updated_at
FROM (
SELECT
team_id,
task_id,
updated_at,
ROW_NUMBER() OVER (PARTITION BY team_id, task_id ORDER BY updated_at DESC) AS rn
FROM (
SELECT
ttc.team_id,
t.task_id,
t.updated_at
FROM crm_service.tasks_dm AS t
JOIN authz.team_to_clients_mv AS ttc
ON ttc.client_id = t.resource_client_id
WHERE
t.disabled_at IS NULL
UNION ALL
SELECT
tta.team_id,
t.task_id,
t.updated_at
FROM crm_service.tasks_dm AS t
JOIN authz.team_to_accounts_mv AS tta
ON tta.account_id = t.resource_account_id
WHERE
t.disabled_at IS NULL
UNION ALL
SELECT
ttp.team_id,
t.task_id,
t.updated_at
FROM crm_service.tasks_dm AS t
JOIN authz.team_to_portfolios_mv AS ttp
ON ttp.portfolio_id = t.resource_portfolio_id
WHERE
t.disabled_at IS NULL
UNION ALL
SELECT
ttp.team_id,
t.task_id,
t.updated_at
FROM crm_service.tasks_dm AS t
JOIN authz.team_to_parties_mv AS ttp
ON ttp.party_id = t.resource_party_id
WHERE
t.disabled_at IS NULL
)
)
WHERE
rn = 1