| Actor | Fragment | Worker | State |
|---|---|---|---|
| 54252 | 2598 | 3 | running |
| 54253 | 2598 | 3 | running |
| 54254 | 2599 | 3 | running |
| 54255 | 2599 | 3 | running |
| 54256 | 2600 | 3 | running |
| 54257 | 2600 | 3 | running |
| 54258 | 2601 | 3 | running |
| 54259 | 2601 | 3 | running |
CREATE MATERIALIZED VIEW insights.benchmark_values_by_distribution_mv AS SELECT c.benchmark_id, c.fact_date, ad.distribution_type, ad.item_id, SUM(c.weight * ad.share) AS weight FROM olap.basket_index_benchmark_constituents_ft AS c JOIN insights.asset_distributions_for_consumers_mv AS ad ON ad.asset_id = c.asset_id AND c.fact_date >= ad.effective_start_date AND c.fact_date < ad.effective_end_date WHERE c.disabled_at IS NULL GROUP BY c.benchmark_id, c.fact_date, ad.distribution_type, ad.item_id