CREATE index
  reconciliation__entity_id__seen_on__entity_type ON
  reconciliation(
  entity_id,
  seen_on,
  entity_type
);


CREATE INDEX reconciled_entity_types__entity_type ON reconciled_entity_types(entity_type);

-- NOTE: unreconciled entities view here  https://pastebin.com/td3Z6Pr5