| Actor | Fragment | Worker | State |
|---|---|---|---|
| 53295 | 2362 | 3 | running |
| 53296 | 2362 | 3 | running |
| 53337 | 2363 | 3 | running |
| 53338 | 2363 | 3 | running |
| 53339 | 2364 | 3 | running |
| 53340 | 2364 | 3 | running |
| 53341 | 2365 | 3 | running |
| 53342 | 2365 | 3 | running |
| 53343 | 2366 | 3 | running |
| 53344 | 2366 | 3 | running |
| 53347 | 2369 | 3 | running |
| 53348 | 2369 | 3 | running |
CREATE MATERIALIZED VIEW authz.user_accessible_portfolios_mv AS SELECT tm.user_id, cp.portfolio_id, MAX(GREATEST(tm.updated_at, etm.updated_at)) AS updated_at FROM olap.teams_memberships_dm AS tm JOIN olap.entity_to_teams_dm AS etm ON tm.team_id = etm.team_id AND etm.entity_type = 'CLIENT' JOIN olap.clients_portfolios_dm AS cp ON etm.entity_id = cp.client_id WHERE tm.disabled_at IS NULL AND NOT tm.temporary IS TRUE AND etm.disabled_at IS NULL AND etm.effective_end_date IS NULL AND cp.disabled_at IS NULL AND cp.effective_end_date IS NULL GROUP BY tm.user_id, cp.portfolio_id UNION ALL SELECT tm.user_id, etm.entity_id AS portfolio_id, MAX(tm.updated_at) AS updated_at FROM olap.teams_memberships_dm AS tm JOIN olap.entity_to_teams_dm AS etm ON tm.team_id = etm.team_id AND etm.entity_type = 'PORTFOLIO' WHERE tm.disabled_at IS NULL AND NOT tm.temporary IS TRUE AND etm.disabled_at IS NULL AND etm.effective_end_date IS NULL GROUP BY tm.user_id, etm.entity_id