CREATE INDEX IF NOT EXISTS face_person_group_migration_idx ON public.face
(
  id_user,
  id_person_group
);
CREATE INDEX IF NOT EXISTS person_group_cluster_migration_idx ON public.person_group
(
  id_user,
  id_cluster
);
CREATE INDEX IF NOT EXISTS face_person_group_list_idx ON public.face
(
  id_user,
  id_person_group,
  id
) WHERE feature IS NOT NULL;
CREATE INDEX IF NOT EXISTS person_group_cluster_list_idx ON public.person_group
(
  id_user,
  id_cluster,
  id
);
CREATE INDEX IF NOT EXISTS face_unit_face_list_idx ON public.face
(
  id_user,
  id_unit,
  id
) WHERE is_manual IS false;