| Actor | Fragment | Worker | State |
|---|---|---|---|
| 741774 | 44378 | 51 | running |
| 741775 | 44378 | 51 | running |
| 741776 | 44377 | 51 | running |
| 741777 | 44377 | 51 | running |
| 741778 | 44379 | 51 | running |
| 741779 | 44379 | 51 | running |
| 741780 | 44380 | 51 | running |
| 741781 | 44380 | 51 | running |
| 741782 | 44381 | 51 | running |
| 741783 | 44381 | 51 | running |
CREATE MATERIALIZED VIEW alinma_bff.expiring_identifiers_mv WITH ( backfill_order=FIXED(party.parties -> party.party_identifiers) ) AS SELECT pi.id AS identifier_id, pi.party_id, pi.type AS identifier_type, pi.expiry_date FROM party.party_identifiers AS pi JOIN party.parties AS p ON p.id = pi.party_id WHERE pi.disabled_at IS NULL AND p.disabled_at IS NULL AND NOT pi.expiry_date IS NULL