| Actor | Fragment | Worker | State |
|---|---|---|---|
| 54312 | 2651 | 3 | running |
| 54313 | 2651 | 3 | running |
| 54341 | 2650 | 3 | running |
| 54342 | 2650 | 3 | running |
| 54351 | 2652 | 3 | running |
| 54352 | 2652 | 3 | running |
| 54353 | 2653 | 3 | running |
| 54354 | 2653 | 3 | running |
CREATE MATERIALIZED VIEW insights.clients_with_accounts_mv AS
SELECT
client_id
FROM (
SELECT
client_id
FROM insights.client_account_direct_mv
UNION ALL
SELECT
client_id
FROM insights.client_account_via_portfolio_mv
) AS paths
GROUP BY
client_id