Extend selective sync scope to the primary checksumming (!174453) · Merge requests · GitLab.org / GitLab

What does this MR do and why?

These changes extend the selective sync scope to the primary checksumming, enabling us to scope the checksumming to a set of groups or shards. This is the foundation work required for the Org Mover, which will enable us to scope by a set of organizations when the sharding work is complete. This is behind a feature flag org_mover_extend_selective_sync_to_primary_checksumming disabled by default.

References

Relates to #504138 (closed)

MR acceptance checklist

Please evaluate this MR against the MR acceptance checklist. It helps you analyze changes to reduce risks in quality, performance, reliability, security, and maintainability.

How to set up and validate locally

Have Geo set up.

In the Rails console on the Geo primary site enable the feature flag

Feature.enable(:org_mover_extend_selective_sync_to_primary_checksumming)

Visit the Geo sites page http://localhost:3000/admin/geo/sites
Click on the Edit Primary Site icon.
Select a set of groups or shards in the Selective synchronization section.
Click on the Save changes button
Wait a few minutes for the Geo::VerificationStateBackfillWorker and the Geo::MetricsUpdateWorker workers to run.
Refresh the page and check the progress bars.

Raw SQLs

Geo Primary Site (Before)

Click to expand

SELECT "ci_secure_files".* FROM "ci_secure_files" WHERE "ci_secure_files"."id" BETWEEN 1 AND 1000
SELECT "container_repositories".* FROM "container_repositories" WHERE "container_repositories"."id" BETWEEN 1 AND 1000
SELECT "dependency_proxy_blobs".* FROM "dependency_proxy_blobs" WHERE "dependency_proxy_blobs"."id" BETWEEN 1 AND 1000
SELECT "dependency_proxy_manifests".* FROM "dependency_proxy_manifests" WHERE "dependency_proxy_manifests"."id" BETWEEN 1 AND 1000
SELECT "design_management_repositories".* FROM "design_management_repositories" WHERE "design_management_repositories"."id" BETWEEN 1 AND 1000
SELECT "group_wiki_repositories".* FROM "group_wiki_repositories" WHERE "group_wiki_repositories"."group_id" BETWEEN 1 AND 1000
SELECT "p_ci_job_artifacts".* FROM "p_ci_job_artifacts" WHERE "p_ci_job_artifacts"."id" BETWEEN 1 AND 1000
SELECT "lfs_objects".* FROM "lfs_objects" WHERE "lfs_objects"."id" BETWEEN 1 AND 1000
SELECT "merge_request_diffs".* FROM "merge_request_diffs" WHERE ("merge_request_diffs"."state" NOT IN ('without_files','empty')) AND "merge_request_diffs"."stored_externally" = TRUE AND "merge_request_diffs"."id" BETWEEN 1 AND 1000
SELECT "packages_package_files".* FROM "packages_package_files" WHERE "packages_package_files"."id" BETWEEN 1 AND 1000
SELECT "pages_deployments".* FROM "pages_deployments" WHERE "pages_deployments"."id" BETWEEN 1 AND 1000
SELECT "ci_pipeline_artifacts".* FROM "ci_pipeline_artifacts" WHERE "ci_pipeline_artifacts"."id" BETWEEN 1 AND 1000
SELECT "projects"."id", "projects"."name", "projects"."path", "projects"."description", "projects"."created_at", "projects"."updated_at", "projects"."creator_id", "projects"."namespace_id", "projects"."last_activity_at", "projects"."import_url", "projects"."visibility_level", "projects"."archived", "projects"."avatar", "projects"."merge_requests_template", "projects"."star_count", "projects"."merge_requests_rebase_enabled", "projects"."import_type", "projects"."import_source", "projects"."approvals_before_merge", "projects"."reset_approvals_on_push", "projects"."merge_requests_ff_only_enabled", "projects"."issues_template", "projects"."mirror", "projects"."mirror_last_update_at", "projects"."mirror_last_successful_update_at", "projects"."mirror_user_id", "projects"."shared_runners_enabled", "projects"."runners_token", "projects"."build_allow_git_fetch", "projects"."build_timeout", "projects"."mirror_trigger_builds", "projects"."pending_delete", "projects"."public_builds", "projects"."last_repository_check_failed", "projects"."last_repository_check_at", "projects"."only_allow_merge_if_pipeline_succeeds", "projects"."has_external_issue_tracker", "projects"."repository_storage", "projects"."repository_read_only", "projects"."request_access_enabled", "projects"."has_external_wiki", "projects"."ci_config_path", "projects"."lfs_enabled", "projects"."description_html", "projects"."only_allow_merge_if_all_discussions_are_resolved", "projects"."repository_size_limit", "projects"."printing_merge_request_link_enabled", "projects"."auto_cancel_pending_pipelines", "projects"."service_desk_enabled", "projects"."cached_markdown_version", "projects"."delete_error", "projects"."last_repository_updated_at", "projects"."disable_overriding_approvers_per_merge_request", "projects"."storage_version", "projects"."resolve_outdated_diff_discussions", "projects"."remote_mirror_available_overridden", "projects"."only_mirror_protected_branches", "projects"."pull_mirror_available_overridden", "projects"."jobs_cache_index", "projects"."external_authorization_classification_label", "projects"."mirror_overwrites_diverged_branches", "projects"."pages_https_only", "projects"."external_webhook_token", "projects"."packages_enabled", "projects"."merge_requests_author_approval", "projects"."pool_repository_id", "projects"."runners_token_encrypted", "projects"."bfg_object_map", "projects"."detected_repository_languages", "projects"."merge_requests_disable_committers_approval", "projects"."require_password_to_approve", "projects"."max_pages_size", "projects"."max_artifacts_size", "projects"."pull_mirror_branch_prefix", "projects"."remove_source_branch_after_merge", "projects"."marked_for_deletion_at", "projects"."marked_for_deletion_by_user_id", "projects"."autoclose_referenced_issues", "projects"."suggestion_commit_message", "projects"."project_namespace_id", "projects"."hidden", "projects"."organization_id" FROM "projects" WHERE "projects"."id" BETWEEN 1 AND 1000
SELECT "project_wiki_repositories".* FROM "project_wiki_repositories" WHERE "project_wiki_repositories"."id" BETWEEN 1 AND 1000
SELECT "snippet_repositories".* FROM "snippet_repositories" WHERE "snippet_repositories"."snippet_id" BETWEEN 1 AND 1000
SELECT "terraform_state_versions".* FROM "terraform_state_versions" WHERE "terraform_state_versions"."id" BETWEEN 1 AND 1000
SELECT "uploads".* FROM "uploads" WHERE "uploads"."id" BETWEEN 1 AND 1000

Geo Primary Site (After)

Click to expand

Feature Flag disabled

SELECT "ci_secure_files".* FROM "ci_secure_files" WHERE "ci_secure_files"."id" BETWEEN 1 AND 1000
SELECT "container_repositories".* FROM "container_repositories" WHERE "container_repositories"."id" BETWEEN 1 AND 1000
SELECT "dependency_proxy_blobs".* FROM "dependency_proxy_blobs" WHERE "dependency_proxy_blobs"."id" BETWEEN 1 AND 1000
SELECT "dependency_proxy_manifests".* FROM "dependency_proxy_manifests" WHERE "dependency_proxy_manifests"."id" BETWEEN 1 AND 1000
SELECT "design_management_repositories".* FROM "design_management_repositories" WHERE "design_management_repositories"."id" BETWEEN 1 AND 1000
SELECT "group_wiki_repositories".* FROM "group_wiki_repositories" WHERE "group_wiki_repositories"."group_id" BETWEEN 1 AND 1000
SELECT "p_ci_job_artifacts".* FROM "p_ci_job_artifacts" WHERE "p_ci_job_artifacts"."id" BETWEEN 1 AND 1000
SELECT "lfs_objects".* FROM "lfs_objects" WHERE "lfs_objects"."id" BETWEEN 1 AND 1000
SELECT "merge_request_diffs".* FROM "merge_request_diffs" WHERE ("merge_request_diffs"."state" NOT IN ('without_files','empty')) AND "merge_request_diffs"."stored_externally" = TRUE AND "merge_request_diffs"."id" BETWEEN 1 AND 1000
SELECT "packages_package_files".* FROM "packages_package_files" WHERE "packages_package_files"."id" BETWEEN 1 AND 1000
SELECT "pages_deployments".* FROM "pages_deployments" WHERE "pages_deployments"."id" BETWEEN 1 AND 1000
SELECT "ci_pipeline_artifacts".* FROM "ci_pipeline_artifacts" WHERE "ci_pipeline_artifacts"."id" BETWEEN 1 AND 1000
SELECT "projects"."id", "projects"."name", "projects"."path", "projects"."description", "projects"."created_at", "projects"."updated_at", "projects"."creator_id", "projects"."namespace_id", "projects"."last_activity_at", "projects"."import_url", "projects"."visibility_level", "projects"."archived", "projects"."avatar", "projects"."merge_requests_template", "projects"."star_count", "projects"."merge_requests_rebase_enabled", "projects"."import_type", "projects"."import_source", "projects"."approvals_before_merge", "projects"."reset_approvals_on_push", "projects"."merge_requests_ff_only_enabled", "projects"."issues_template", "projects"."mirror", "projects"."mirror_last_update_at", "projects"."mirror_last_successful_update_at", "projects"."mirror_user_id", "projects"."shared_runners_enabled", "projects"."runners_token", "projects"."build_allow_git_fetch", "projects"."build_timeout", "projects"."mirror_trigger_builds", "projects"."pending_delete", "projects"."public_builds", "projects"."last_repository_check_failed", "projects"."last_repository_check_at", "projects"."only_allow_merge_if_pipeline_succeeds", "projects"."has_external_issue_tracker", "projects"."repository_storage", "projects"."repository_read_only", "projects"."request_access_enabled", "projects"."has_external_wiki", "projects"."ci_config_path", "projects"."lfs_enabled", "projects"."description_html", "projects"."only_allow_merge_if_all_discussions_are_resolved", "projects"."repository_size_limit", "projects"."printing_merge_request_link_enabled", "projects"."auto_cancel_pending_pipelines", "projects"."service_desk_enabled", "projects"."cached_markdown_version", "projects"."delete_error", "projects"."last_repository_updated_at", "projects"."disable_overriding_approvers_per_merge_request", "projects"."storage_version", "projects"."resolve_outdated_diff_discussions", "projects"."remote_mirror_available_overridden", "projects"."only_mirror_protected_branches", "projects"."pull_mirror_available_overridden", "projects"."jobs_cache_index", "projects"."external_authorization_classification_label", "projects"."mirror_overwrites_diverged_branches", "projects"."pages_https_only", "projects"."external_webhook_token", "projects"."packages_enabled", "projects"."merge_requests_author_approval", "projects"."pool_repository_id", "projects"."runners_token_encrypted", "projects"."bfg_object_map", "projects"."detected_repository_languages", "projects"."merge_requests_disable_committers_approval", "projects"."require_password_to_approve", "projects"."max_pages_size", "projects"."max_artifacts_size", "projects"."pull_mirror_branch_prefix", "projects"."remove_source_branch_after_merge", "projects"."marked_for_deletion_at", "projects"."marked_for_deletion_by_user_id", "projects"."autoclose_referenced_issues", "projects"."suggestion_commit_message", "projects"."project_namespace_id", "projects"."hidden", "projects"."organization_id" FROM "projects" WHERE "projects"."id" BETWEEN 1 AND 1000
SELECT "project_wiki_repositories".* FROM "project_wiki_repositories" WHERE "project_wiki_repositories"."id" BETWEEN 1 AND 1000
SELECT "snippet_repositories".* FROM "snippet_repositories" WHERE "snippet_repositories"."snippet_id" BETWEEN 1 AND 1000
SELECT "terraform_state_versions".* FROM "terraform_state_versions" WHERE "terraform_state_versions"."id" BETWEEN 1 AND 1000
SELECT "uploads".* FROM "uploads" WHERE "uploads"."id" BETWEEN 1 AND 1000

Feature Flag enabled

Selective Sync disabled

SELECT "ci_secure_files".* FROM "ci_secure_files" WHERE "ci_secure_files"."id" BETWEEN 1 AND 1000
SELECT "container_repositories".* FROM "container_repositories" WHERE "container_repositories"."id" BETWEEN 1 AND 1000
SELECT "dependency_proxy_blobs".* FROM "dependency_proxy_blobs" WHERE "dependency_proxy_blobs"."id" BETWEEN 1 AND 1000
SELECT "dependency_proxy_manifests".* FROM "dependency_proxy_manifests" WHERE "dependency_proxy_manifests"."id" BETWEEN 1 AND 1000
SELECT "design_management_repositories".* FROM "design_management_repositories" WHERE "design_management_repositories"."id" BETWEEN 1 AND 1000
SELECT "group_wiki_repositories".* FROM "group_wiki_repositories" WHERE "group_wiki_repositories"."group_id" BETWEEN 1 AND 1000
SELECT "p_ci_job_artifacts".* FROM "p_ci_job_artifacts" WHERE "p_ci_job_artifacts"."id" BETWEEN 1 AND 1000
SELECT "lfs_objects".* FROM "lfs_objects" WHERE "lfs_objects"."id" BETWEEN 1 AND 1000
SELECT "merge_request_diffs".* FROM "merge_request_diffs" WHERE ("merge_request_diffs"."state" NOT IN ('without_files','empty')) AND "merge_request_diffs"."stored_externally" = TRUE AND "merge_request_diffs"."id" BETWEEN 1 AND 1000
SELECT "packages_package_files".* FROM "packages_package_files" WHERE "packages_package_files"."id" BETWEEN 1 AND 1000
SELECT "pages_deployments".* FROM "pages_deployments" WHERE "pages_deployments"."id" BETWEEN 1 AND 1000
SELECT "ci_pipeline_artifacts".* FROM "ci_pipeline_artifacts" WHERE "ci_pipeline_artifacts"."id" BETWEEN 1 AND 1000
SELECT "projects"."id", "projects"."name", "projects"."path", "projects"."description", "projects"."created_at", "projects"."updated_at", "projects"."creator_id", "projects"."namespace_id", "projects"."last_activity_at", "projects"."import_url", "projects"."visibility_level", "projects"."archived", "projects"."avatar", "projects"."merge_requests_template", "projects"."star_count", "projects"."merge_requests_rebase_enabled", "projects"."import_type", "projects"."import_source", "projects"."approvals_before_merge", "projects"."reset_approvals_on_push", "projects"."merge_requests_ff_only_enabled", "projects"."issues_template", "projects"."mirror", "projects"."mirror_last_update_at", "projects"."mirror_last_successful_update_at", "projects"."mirror_user_id", "projects"."shared_runners_enabled", "projects"."runners_token", "projects"."build_allow_git_fetch", "projects"."build_timeout", "projects"."mirror_trigger_builds", "projects"."pending_delete", "projects"."public_builds", "projects"."last_repository_check_failed", "projects"."last_repository_check_at", "projects"."only_allow_merge_if_pipeline_succeeds", "projects"."has_external_issue_tracker", "projects"."repository_storage", "projects"."repository_read_only", "projects"."request_access_enabled", "projects"."has_external_wiki", "projects"."ci_config_path", "projects"."lfs_enabled", "projects"."description_html", "projects"."only_allow_merge_if_all_discussions_are_resolved", "projects"."repository_size_limit", "projects"."printing_merge_request_link_enabled", "projects"."auto_cancel_pending_pipelines", "projects"."service_desk_enabled", "projects"."cached_markdown_version", "projects"."delete_error", "projects"."last_repository_updated_at", "projects"."disable_overriding_approvers_per_merge_request", "projects"."storage_version", "projects"."resolve_outdated_diff_discussions", "projects"."remote_mirror_available_overridden", "projects"."only_mirror_protected_branches", "projects"."pull_mirror_available_overridden", "projects"."jobs_cache_index", "projects"."external_authorization_classification_label", "projects"."mirror_overwrites_diverged_branches", "projects"."pages_https_only", "projects"."external_webhook_token", "projects"."packages_enabled", "projects"."merge_requests_author_approval", "projects"."pool_repository_id", "projects"."runners_token_encrypted", "projects"."bfg_object_map", "projects"."detected_repository_languages", "projects"."merge_requests_disable_committers_approval", "projects"."require_password_to_approve", "projects"."max_pages_size", "projects"."max_artifacts_size", "projects"."pull_mirror_branch_prefix", "projects"."remove_source_branch_after_merge", "projects"."marked_for_deletion_at", "projects"."marked_for_deletion_by_user_id", "projects"."autoclose_referenced_issues", "projects"."suggestion_commit_message", "projects"."project_namespace_id", "projects"."hidden", "projects"."organization_id" FROM "projects" WHERE "projects"."id" BETWEEN 1 AND 1000
SELECT "project_wiki_repositories".* FROM "project_wiki_repositories" WHERE "project_wiki_repositories"."id" BETWEEN 1 AND 1000
SELECT "snippet_repositories".* FROM "snippet_repositories" WHERE "snippet_repositories"."snippet_id" BETWEEN 1 AND 1000
SELECT "terraform_state_versions".* FROM "terraform_state_versions" WHERE "terraform_state_versions"."id" BETWEEN 1 AND 1000
SELECT "uploads".* FROM "uploads" WHERE "uploads"."id" BETWEEN 1 AND 1000

Selective Sync enabled - Project in certain groups (2 groups selected)

SELECT "ci_secure_files".* FROM "ci_secure_files" WHERE "ci_secure_files"."project_id" IN (2, 7) AND "ci_secure_files"."id" BETWEEN 1 AND 1000
SELECT "container_repositories".* FROM "container_repositories" INNER JOIN "projects" ON "projects"."id" = "container_repositories"."project_id" WHERE "projects"."id" IN (SELECT "projects"."id" FROM "projects" WHERE "projects"."namespace_id" IN (WITH RECURSIVE "base_and_descendants" AS ((SELECT "geo_node_namespace_links"."namespace_id" AS id FROM "geo_node_namespace_links" WHERE "geo_node_namespace_links"."geo_node_id" = 1) UNION (SELECT "namespaces"."id" FROM "namespaces", "base_and_descendants" WHERE "namespaces"."parent_id" = "base_and_descendants"."id")) SELECT "id" FROM "base_and_descendants" AS "namespaces")) AND "container_repositories"."id" BETWEEN 1 AND 1000
SELECT "dependency_proxy_blobs".* FROM "dependency_proxy_blobs" INNER JOIN "namespaces" ON "namespaces"."id" = "dependency_proxy_blobs"."group_id" AND "namespaces"."type" = 'Group' WHERE "namespaces"."id" IN (33, 24) AND "dependency_proxy_blobs"."id" BETWEEN 1 AND 1000
SELECT "dependency_proxy_manifests".* FROM "dependency_proxy_manifests" INNER JOIN "namespaces" ON "namespaces"."id" = "dependency_proxy_manifests"."group_id" AND "namespaces"."type" = 'Group' WHERE "namespaces"."id" IN (33, 24) AND "dependency_proxy_manifests"."id" BETWEEN 1 AND 1000
SELECT "design_management_repositories".* FROM "design_management_repositories" WHERE "design_management_repositories"."project_id" IN (2, 7) AND "design_management_repositories"."id" BETWEEN 1 AND 1000
SELECT "group_wiki_repositories".* FROM "group_wiki_repositories" INNER JOIN "namespaces" ON "namespaces"."id" = "group_wiki_repositories"."group_id" AND "namespaces"."type" = 'Group' WHERE "group_wiki_repositories"."group_id" IN (WITH RECURSIVE "base_and_descendants" AS ((SELECT "geo_node_namespace_links"."namespace_id" AS id FROM "geo_node_namespace_links" WHERE "geo_node_namespace_links"."geo_node_id" = 1) UNION (SELECT "namespaces"."id" FROM "namespaces", "base_and_descendants" WHERE "namespaces"."parent_id" = "base_and_descendants"."id")) SELECT "id" FROM "base_and_descendants" AS "namespaces") AND "group_wiki_repositories"."group_id" BETWEEN 1 AND 1000
SELECT "p_ci_job_artifacts".* FROM "p_ci_job_artifacts" WHERE "p_ci_job_artifacts"."project_id" = 2 AND "p_ci_job_artifacts"."id" BETWEEN 1 AND 1000
SELECT "lfs_objects".* FROM "lfs_objects" WHERE "lfs_objects"."id" IN (SELECT DISTINCT "lfs_objects_projects"."lfs_object_id" FROM "lfs_objects_projects" WHERE "lfs_objects_projects"."project_id" IN (SELECT "projects"."id" FROM "projects" WHERE "projects"."namespace_id" IN (WITH RECURSIVE "base_and_descendants" AS ((SELECT "geo_node_namespace_links"."namespace_id" AS id FROM "geo_node_namespace_links" WHERE "geo_node_namespace_links"."geo_node_id" = 1) UNION (SELECT "namespaces"."id" FROM "namespaces", "base_and_descendants" WHERE "namespaces"."parent_id" = "base_and_descendants"."id")) SELECT "id" FROM "base_and_descendants" AS "namespaces"))) AND "lfs_objects"."id" BETWEEN 1 AND 1000
SELECT "merge_request_diffs".* FROM "merge_request_diffs" WHERE ("merge_request_diffs"."state" NOT IN ('without_files','empty')) AND "merge_request_diffs"."stored_externally" = TRUE AND "merge_request_diffs"."merge_request_id" IN (SELECT "merge_requests"."id" FROM "merge_requests" WHERE "merge_requests"."target_project_id" IN (SELECT "projects"."id" FROM "projects" WHERE "projects"."namespace_id" IN (WITH RECURSIVE "base_and_descendants" AS ((SELECT "geo_node_namespace_links"."namespace_id" AS id FROM "geo_node_namespace_links" WHERE "geo_node_namespace_links"."geo_node_id" = 1) UNION (SELECT "namespaces"."id" FROM "namespaces", "base_and_descendants" WHERE "namespaces"."parent_id" = "base_and_descendants"."id")) SELECT "id" FROM "base_and_descendants" AS "namespaces"))) AND "merge_request_diffs"."id" BETWEEN 1 AND 1000
SELECT "packages_package_files".* FROM "packages_package_files" INNER JOIN "packages_packages" ON "packages_packages"."id" = "packages_package_files"."package_id" WHERE "packages_packages"."project_id" IN (SELECT "projects"."id" FROM "projects" WHERE "projects"."namespace_id" IN (WITH RECURSIVE "base_and_descendants" AS ((SELECT "geo_node_namespace_links"."namespace_id" AS id FROM "geo_node_namespace_links" WHERE "geo_node_namespace_links"."geo_node_id" = 1) UNION (SELECT "namespaces"."id" FROM "namespaces", "base_and_descendants" WHERE "namespaces"."parent_id" = "base_and_descendants"."id")) SELECT "id" FROM "base_and_descendants" AS "namespaces")) AND "packages_package_files"."id" BETWEEN 1 AND 1000
SELECT "pages_deployments".* FROM "pages_deployments" WHERE "pages_deployments"."project_id" IN (SELECT "projects"."id" FROM "projects" WHERE "projects"."namespace_id" IN (WITH RECURSIVE "base_and_descendants" AS ((SELECT "geo_node_namespace_links"."namespace_id" AS id FROM "geo_node_namespace_links" WHERE "geo_node_namespace_links"."geo_node_id" = 1) UNION (SELECT "namespaces"."id" FROM "namespaces", "base_and_descendants" WHERE "namespaces"."parent_id" = "base_and_descendants"."id")) SELECT "id" FROM "base_and_descendants" AS "namespaces")) AND "pages_deployments"."id" BETWEEN 1 AND 1000
SELECT "ci_pipeline_artifacts".* FROM "ci_pipeline_artifacts" WHERE "ci_pipeline_artifacts"."project_id" IN (2, 7) AND "ci_pipeline_artifacts"."id" BETWEEN 1 AND 1000
SELECT "projects"."id", "projects"."name", "projects"."path", "projects"."description", "projects"."created_at", "projects"."updated_at", "projects"."creator_id", "projects"."namespace_id", "projects"."last_activity_at", "projects"."import_url", "projects"."visibility_level", "projects"."archived", "projects"."avatar", "projects"."merge_requests_template", "projects"."star_count", "projects"."merge_requests_rebase_enabled", "projects"."import_type", "projects"."import_source", "projects"."approvals_before_merge", "projects"."reset_approvals_on_push", "projects"."merge_requests_ff_only_enabled", "projects"."issues_template", "projects"."mirror", "projects"."mirror_last_update_at", "projects"."mirror_last_successful_update_at", "projects"."mirror_user_id", "projects"."shared_runners_enabled", "projects"."runners_token", "projects"."build_allow_git_fetch", "projects"."build_timeout", "projects"."mirror_trigger_builds", "projects"."pending_delete", "projects"."public_builds", "projects"."last_repository_check_failed", "projects"."last_repository_check_at", "projects"."only_allow_merge_if_pipeline_succeeds", "projects"."has_external_issue_tracker", "projects"."repository_storage", "projects"."repository_read_only", "projects"."request_access_enabled", "projects"."has_external_wiki", "projects"."ci_config_path", "projects"."lfs_enabled", "projects"."description_html", "projects"."only_allow_merge_if_all_discussions_are_resolved", "projects"."repository_size_limit", "projects"."printing_merge_request_link_enabled", "projects"."auto_cancel_pending_pipelines", "projects"."service_desk_enabled", "projects"."cached_markdown_version", "projects"."delete_error", "projects"."last_repository_updated_at", "projects"."disable_overriding_approvers_per_merge_request", "projects"."storage_version", "projects"."resolve_outdated_diff_discussions", "projects"."remote_mirror_available_overridden", "projects"."only_mirror_protected_branches", "projects"."pull_mirror_available_overridden", "projects"."jobs_cache_index", "projects"."external_authorization_classification_label", "projects"."mirror_overwrites_diverged_branches", "projects"."pages_https_only", "projects"."external_webhook_token", "projects"."packages_enabled", "projects"."merge_requests_author_approval", "projects"."pool_repository_id", "projects"."runners_token_encrypted", "projects"."bfg_object_map", "projects"."detected_repository_languages", "projects"."merge_requests_disable_committers_approval", "projects"."require_password_to_approve", "projects"."max_pages_size", "projects"."max_artifacts_size", "projects"."pull_mirror_branch_prefix", "projects"."remove_source_branch_after_merge", "projects"."marked_for_deletion_at", "projects"."marked_for_deletion_by_user_id", "projects"."autoclose_referenced_issues", "projects"."suggestion_commit_message", "projects"."project_namespace_id", "projects"."hidden", "projects"."organization_id" FROM "projects" WHERE "projects"."namespace_id" IN (WITH RECURSIVE "base_and_descendants" AS ((SELECT "geo_node_namespace_links"."namespace_id" AS id FROM "geo_node_namespace_links" WHERE "geo_node_namespace_links"."geo_node_id" = 1) UNION (SELECT "namespaces"."id" FROM "namespaces", "base_and_descendants" WHERE "namespaces"."parent_id" = "base_and_descendants"."id")) SELECT "id" FROM "base_and_descendants" AS "namespaces") AND "projects"."id" BETWEEN 1 AND 1000
SELECT "project_wiki_repositories".* FROM "project_wiki_repositories" WHERE "project_wiki_repositories"."project_id" IN (2, 7, 3) AND "project_wiki_repositories"."id" BETWEEN 1 AND 1000
SELECT "snippet_repositories".* FROM ((SELECT "snippet_repositories".* FROM "snippet_repositories" INNER JOIN "snippets" ON "snippets"."id" = "snippet_repositories"."snippet_id" INNER JOIN "projects" ON "projects"."id" = "snippets"."project_id" WHERE "snippets"."project_id" IN (SELECT "projects"."id" FROM "projects" WHERE "projects"."namespace_id" IN (WITH RECURSIVE "base_and_descendants" AS ((SELECT "geo_node_namespace_links"."namespace_id" AS id FROM "geo_node_namespace_links" WHERE "geo_node_namespace_links"."geo_node_id" = 1) UNION (SELECT "namespaces"."id" FROM "namespaces", "base_and_descendants" WHERE "namespaces"."parent_id" = "base_and_descendants"."id")) SELECT "id" FROM "base_and_descendants" AS "namespaces"))) UNION (SELECT "snippet_repositories".* FROM "snippet_repositories" INNER JOIN "snippets" ON "snippets"."id" = "snippet_repositories"."snippet_id" WHERE "snippet_repositories"."snippet_id" IN (SELECT "snippets"."id" FROM "snippets" WHERE "snippets"."project_id" IS NULL))) snippet_repositories WHERE "snippet_repositories"."snippet_id" BETWEEN 1 AND 1000
SELECT "terraform_state_versions".* FROM "terraform_state_versions" INNER JOIN "terraform_states" ON "terraform_states"."id" = "terraform_state_versions"."terraform_state_id" WHERE "terraform_states"."project_id" IN (SELECT "projects"."id" FROM "projects" WHERE "projects"."namespace_id" IN (WITH RECURSIVE "base_and_descendants" AS ((SELECT "geo_node_namespace_links"."namespace_id" AS id FROM "geo_node_namespace_links" WHERE "geo_node_namespace_links"."geo_node_id" = 1) UNION (SELECT "namespaces"."id" FROM "namespaces", "base_and_descendants" WHERE "namespaces"."parent_id" = "base_and_descendants"."id")) SELECT "id" FROM "base_and_descendants" AS "namespaces")) AND "terraform_state_versions"."id" BETWEEN 1 AND 1000
SELECT "uploads".* FROM "uploads" WHERE ("uploads"."model_type" = 'Namespace' AND "uploads"."model_id" IN (WITH RECURSIVE "base_and_descendants" AS ((SELECT "geo_node_namespace_links"."namespace_id" AS id FROM "geo_node_namespace_links" WHERE "geo_node_namespace_links"."geo_node_id" = 1) UNION (SELECT "namespaces"."id" FROM "namespaces", "base_and_descendants" WHERE "namespaces"."parent_id" = "base_and_descendants"."id")) SELECT "id" FROM "base_and_descendants" AS "namespaces") OR "uploads"."model_type" = 'Project' AND "uploads"."model_id" IN (SELECT "projects"."id" FROM "projects" WHERE "projects"."namespace_id" IN (WITH RECURSIVE "base_and_descendants" AS ((SELECT "geo_node_namespace_links"."namespace_id" AS id FROM "geo_node_namespace_links" WHERE "geo_node_namespace_links"."geo_node_id" = 1) UNION (SELECT "namespaces"."id" FROM "namespaces", "base_and_descendants" WHERE "namespaces"."parent_id" = "base_and_descendants"."id")) SELECT "id" FROM "base_and_descendants" AS "namespaces")) OR "uploads"."model_type" NOT IN ('Namespace', 'Project')) AND "uploads"."id" BETWEEN 1 AND 1000

Selective Sync enabled - Project in certain shards (1 shard selected)

SELECT "ci_secure_files".* FROM "ci_secure_files" WHERE "ci_secure_files"."project_id" IN (2, 7) AND "ci_secure_files"."id" BETWEEN 1 AND 1000
SELECT "container_repositories".* FROM "container_repositories" INNER JOIN "projects" ON "projects"."id" = "container_repositories"."project_id" WHERE "projects"."id" IN (SELECT "projects"."id" FROM "projects" WHERE "projects"."repository_storage" = 'default') AND "container_repositories"."id" BETWEEN 1 AND 1000
SELECT "dependency_proxy_blobs".* FROM "dependency_proxy_blobs" INNER JOIN "namespaces" ON "namespaces"."id" = "dependency_proxy_blobs"."group_id" AND "namespaces"."type" = 'Group' WHERE "namespaces"."id" IN (WITH RECURSIVE "base_and_ancestors" AS ((SELECT "namespaces"."id", "namespaces"."parent_id" FROM "namespaces" WHERE "namespaces"."id" IN (SELECT "projects"."namespace_id" FROM "projects" WHERE "projects"."repository_storage" = 'default')) UNION (SELECT "namespaces"."id", "namespaces"."parent_id" FROM "namespaces", "base_and_ancestors" WHERE "namespaces"."id" = "base_and_ancestors"."parent_id")) SELECT "id" FROM "base_and_ancestors" AS "namespaces") AND "dependency_proxy_blobs"."id" BETWEEN 1 AND 1000
SELECT "dependency_proxy_manifests".* FROM "dependency_proxy_manifests" INNER JOIN "namespaces" ON "namespaces"."id" = "dependency_proxy_manifests"."group_id" AND "namespaces"."type" = 'Group' WHERE "namespaces"."id" IN (WITH RECURSIVE "base_and_ancestors" AS ((SELECT "namespaces"."id", "namespaces"."parent_id" FROM "namespaces" WHERE "namespaces"."id" IN (SELECT "projects"."namespace_id" FROM "projects" WHERE "projects"."repository_storage" = 'default')) UNION (SELECT "namespaces"."id", "namespaces"."parent_id" FROM "namespaces", "base_and_ancestors" WHERE "namespaces"."id" = "base_and_ancestors"."parent_id")) SELECT "id" FROM "base_and_ancestors" AS "namespaces") AND "dependency_proxy_manifests"."id" BETWEEN 1 AND 1000
SELECT "design_management_repositories".* FROM "design_management_repositories" WHERE "design_management_repositories"."project_id" IN (2, 7) AND "design_management_repositories"."id" BETWEEN 1 AND 1000
SELECT "group_wiki_repositories".* FROM "group_wiki_repositories" INNER JOIN "shards" ON "shards"."id" = "group_wiki_repositories"."shard_id" WHERE "shards"."name" = 'default' AND "group_wiki_repositories"."group_id" BETWEEN 1 AND 1000
SELECT "p_ci_job_artifacts".* FROM "p_ci_job_artifacts" WHERE "p_ci_job_artifacts"."project_id" IN (2, 4, 8, 6, 5) AND "p_ci_job_artifacts"."id" BETWEEN 1 AND 1000
SELECT "lfs_objects".* FROM "lfs_objects" WHERE "lfs_objects"."id" IN (SELECT DISTINCT "lfs_objects_projects"."lfs_object_id" FROM "lfs_objects_projects" WHERE "lfs_objects_projects"."project_id" IN (SELECT "projects"."id" FROM "projects" WHERE "projects"."repository_storage" = 'default')) AND "lfs_objects"."id" BETWEEN 1 AND 1000
SELECT "merge_request_diffs".* FROM "merge_request_diffs" WHERE ("merge_request_diffs"."state" NOT IN ('without_files','empty')) AND "merge_request_diffs"."stored_externally" = TRUE AND "merge_request_diffs"."merge_request_id" IN (SELECT "merge_requests"."id" FROM "merge_requests" WHERE "merge_requests"."target_project_id" IN (SELECT "projects"."id" FROM "projects" WHERE "projects"."repository_storage" = 'default')) AND "merge_request_diffs"."id" BETWEEN 1 AND 1000
SELECT "packages_package_files".* FROM "packages_package_files" INNER JOIN "packages_packages" ON "packages_packages"."id" = "packages_package_files"."package_id" WHERE "packages_packages"."project_id" IN (SELECT "projects"."id" FROM "projects" WHERE "projects"."repository_storage" = 'default') AND "packages_package_files"."id" BETWEEN 1 AND 1000
SELECT "pages_deployments".* FROM "pages_deployments" WHERE "pages_deployments"."project_id" IN (SELECT "projects"."id" FROM "projects" WHERE "projects"."repository_storage" = 'default') AND "pages_deployments"."id" BETWEEN 1 AND 1000
SELECT "ci_pipeline_artifacts".* FROM "ci_pipeline_artifacts" WHERE "ci_pipeline_artifacts"."project_id" IN (2, 7) AND "ci_pipeline_artifacts"."id" BETWEEN 1 AND 1000
SELECT "projects"."id", "projects"."name", "projects"."path", "projects"."description", "projects"."created_at", "projects"."updated_at", "projects"."creator_id", "projects"."namespace_id", "projects"."last_activity_at", "projects"."import_url", "projects"."visibility_level", "projects"."archived", "projects"."avatar", "projects"."merge_requests_template", "projects"."star_count", "projects"."merge_requests_rebase_enabled", "projects"."import_type", "projects"."import_source", "projects"."approvals_before_merge", "projects"."reset_approvals_on_push", "projects"."merge_requests_ff_only_enabled", "projects"."issues_template", "projects"."mirror", "projects"."mirror_last_update_at", "projects"."mirror_last_successful_update_at", "projects"."mirror_user_id", "projects"."shared_runners_enabled", "projects"."runners_token", "projects"."build_allow_git_fetch", "projects"."build_timeout", "projects"."mirror_trigger_builds", "projects"."pending_delete", "projects"."public_builds", "projects"."last_repository_check_failed", "projects"."last_repository_check_at", "projects"."only_allow_merge_if_pipeline_succeeds", "projects"."has_external_issue_tracker", "projects"."repository_storage", "projects"."repository_read_only", "projects"."request_access_enabled", "projects"."has_external_wiki", "projects"."ci_config_path", "projects"."lfs_enabled", "projects"."description_html", "projects"."only_allow_merge_if_all_discussions_are_resolved", "projects"."repository_size_limit", "projects"."printing_merge_request_link_enabled", "projects"."auto_cancel_pending_pipelines", "projects"."service_desk_enabled", "projects"."cached_markdown_version", "projects"."delete_error", "projects"."last_repository_updated_at", "projects"."disable_overriding_approvers_per_merge_request", "projects"."storage_version", "projects"."resolve_outdated_diff_discussions", "projects"."remote_mirror_available_overridden", "projects"."only_mirror_protected_branches", "projects"."pull_mirror_available_overridden", "projects"."jobs_cache_index", "projects"."external_authorization_classification_label", "projects"."mirror_overwrites_diverged_branches", "projects"."pages_https_only", "projects"."external_webhook_token", "projects"."packages_enabled", "projects"."merge_requests_author_approval", "projects"."pool_repository_id", "projects"."runners_token_encrypted", "projects"."bfg_object_map", "projects"."detected_repository_languages", "projects"."merge_requests_disable_committers_approval", "projects"."require_password_to_approve", "projects"."max_pages_size", "projects"."max_artifacts_size", "projects"."pull_mirror_branch_prefix", "projects"."remove_source_branch_after_merge", "projects"."marked_for_deletion_at", "projects"."marked_for_deletion_by_user_id", "projects"."autoclose_referenced_issues", "projects"."suggestion_commit_message", "projects"."project_namespace_id", "projects"."hidden", "projects"."organization_id" FROM "projects" WHERE "projects"."repository_storage" = 'default' AND "projects"."id" BETWEEN 1 AND 1000
SELECT "project_wiki_repositories".* FROM "project_wiki_repositories" WHERE "project_wiki_repositories"."project_id" IN (2, 7, 16, 17, 13, 11, 12, 4, 1, 3, 8, 6, 9, 10, 14, 15, 5) AND "project_wiki_repositories"."id" BETWEEN 1 AND 1000
SELECT "snippet_repositories".* FROM "snippet_repositories" INNER JOIN "shards" ON "shards"."id" = "snippet_repositories"."shard_id" WHERE "shards"."name" = 'default' AND "snippet_repositories"."snippet_id" BETWEEN 1 AND 1000
SELECT "terraform_state_versions".* FROM "terraform_state_versions" INNER JOIN "terraform_states" ON "terraform_states"."id" = "terraform_state_versions"."terraform_state_id" WHERE "terraform_states"."project_id" IN (SELECT "projects"."id" FROM "projects" WHERE "projects"."repository_storage" = 'default') AND "terraform_state_versions"."id" BETWEEN 1 AND 1000
SELECT "uploads".* FROM "uploads" WHERE ("uploads"."model_type" = 'Namespace' AND "uploads"."model_id" IN (WITH RECURSIVE "base_and_ancestors" AS ((SELECT "namespaces"."id", "namespaces"."parent_id" FROM "namespaces" WHERE "namespaces"."id" IN (SELECT "projects"."namespace_id" FROM "projects" WHERE "projects"."repository_storage" = 'default')) UNION (SELECT "namespaces"."id", "namespaces"."parent_id" FROM "namespaces", "base_and_ancestors" WHERE "namespaces"."id" = "base_and_ancestors"."parent_id")) SELECT "id" FROM "base_and_ancestors" AS "namespaces") OR "uploads"."model_type" = 'Project' AND "uploads"."model_id" IN (SELECT "projects"."id" FROM "projects" WHERE "projects"."repository_storage" = 'default') OR "uploads"."model_type" NOT IN ('Namespace', 'Project')) AND "uploads"."id" BETWEEN 1 AND 1000

Geo Secondary Site (Before)

Click to expand

Selective Sync Disabled

SELECT "ci_secure_files".* FROM "ci_secure_files" WHERE "ci_secure_files"."id" BETWEEN 1 AND 1000 AND "ci_secure_files"."file_store" = 1
SELECT "container_repositories".* FROM "container_repositories" WHERE "container_repositories"."id" BETWEEN 1 AND 1000
SELECT "dependency_proxy_blobs".* FROM "dependency_proxy_blobs" WHERE "dependency_proxy_blobs"."id" BETWEEN 1 AND 1000 AND "dependency_proxy_blobs"."file_store" = 1
SELECT "dependency_proxy_manifests".* FROM "dependency_proxy_manifests" WHERE "dependency_proxy_manifests"."id" BETWEEN 1 AND 1000 AND "dependency_proxy_manifests"."file_store" = 1
SELECT "design_management_repositories".* FROM "design_management_repositories" WHERE "design_management_repositories"."id" BETWEEN 1 AND 1000
SELECT "group_wiki_repositories".* FROM "group_wiki_repositories" WHERE "group_wiki_repositories"."group_id" BETWEEN 1 AND 1000
SELECT "p_ci_job_artifacts".* FROM "p_ci_job_artifacts" WHERE "p_ci_job_artifacts"."id" BETWEEN 1 AND 1000 AND "p_ci_job_artifacts"."file_store" = 1
SELECT "lfs_objects".* FROM "lfs_objects" WHERE "lfs_objects"."id" BETWEEN 1 AND 1000 AND "lfs_objects"."file_store" = 1
SELECT "merge_request_diffs".* FROM "merge_request_diffs" WHERE ("merge_request_diffs"."state" NOT IN ('without_files','empty')) AND "merge_request_diffs"."stored_externally" = TRUE AND "merge_request_diffs"."id" BETWEEN 1 AND 1000 AND "merge_request_diffs"."external_diff_store" = 1
SELECT "packages_package_files".* FROM "packages_package_files" WHERE "packages_package_files"."id" BETWEEN 1 AND 1000 AND "packages_package_files"."file_store" = 1
SELECT "pages_deployments".* FROM "pages_deployments" WHERE "pages_deployments"."id" BETWEEN 1 AND 1000 AND "pages_deployments"."file_store" = 1
SELECT "ci_pipeline_artifacts".* FROM "ci_pipeline_artifacts" WHERE "ci_pipeline_artifacts"."id" BETWEEN 1 AND 1000 AND "ci_pipeline_artifacts"."file_store" = 1
SELECT "projects"."id", "projects"."name", "projects"."path", "projects"."description", "projects"."created_at", "projects"."updated_at", "projects"."creator_id", "projects"."namespace_id", "projects"."last_activity_at", "projects"."import_url", "projects"."visibility_level", "projects"."archived", "projects"."avatar", "projects"."merge_requests_template", "projects"."star_count", "projects"."merge_requests_rebase_enabled", "projects"."import_type", "projects"."import_source", "projects"."approvals_before_merge", "projects"."reset_approvals_on_push", "projects"."merge_requests_ff_only_enabled", "projects"."issues_template", "projects"."mirror", "projects"."mirror_last_update_at", "projects"."mirror_last_successful_update_at", "projects"."mirror_user_id", "projects"."shared_runners_enabled", "projects"."runners_token", "projects"."build_allow_git_fetch", "projects"."build_timeout", "projects"."mirror_trigger_builds", "projects"."pending_delete", "projects"."public_builds", "projects"."last_repository_check_failed", "projects"."last_repository_check_at", "projects"."only_allow_merge_if_pipeline_succeeds", "projects"."has_external_issue_tracker", "projects"."repository_storage", "projects"."repository_read_only", "projects"."request_access_enabled", "projects"."has_external_wiki", "projects"."ci_config_path", "projects"."lfs_enabled", "projects"."description_html", "projects"."only_allow_merge_if_all_discussions_are_resolved", "projects"."repository_size_limit", "projects"."printing_merge_request_link_enabled", "projects"."auto_cancel_pending_pipelines", "projects"."service_desk_enabled", "projects"."cached_markdown_version", "projects"."delete_error", "projects"."last_repository_updated_at", "projects"."disable_overriding_approvers_per_merge_request", "projects"."storage_version", "projects"."resolve_outdated_diff_discussions", "projects"."remote_mirror_available_overridden", "projects"."only_mirror_protected_branches", "projects"."pull_mirror_available_overridden", "projects"."jobs_cache_index", "projects"."external_authorization_classification_label", "projects"."mirror_overwrites_diverged_branches", "projects"."pages_https_only", "projects"."external_webhook_token", "projects"."packages_enabled", "projects"."merge_requests_author_approval", "projects"."pool_repository_id", "projects"."runners_token_encrypted", "projects"."bfg_object_map", "projects"."detected_repository_languages", "projects"."merge_requests_disable_committers_approval", "projects"."require_password_to_approve", "projects"."max_pages_size", "projects"."max_artifacts_size", "projects"."pull_mirror_branch_prefix", "projects"."remove_source_branch_after_merge", "projects"."marked_for_deletion_at", "projects"."marked_for_deletion_by_user_id", "projects"."autoclose_referenced_issues", "projects"."suggestion_commit_message", "projects"."project_namespace_id", "projects"."hidden", "projects"."organization_id" FROM "projects" WHERE "projects"."id" BETWEEN 1 AND 1000
SELECT "project_wiki_repositories".* FROM "project_wiki_repositories" WHERE "project_wiki_repositories"."id" BETWEEN 1 AND 1000
SELECT "snippet_repositories".* FROM "snippet_repositories" WHERE "snippet_repositories"."snippet_id" BETWEEN 1 AND 1000
SELECT "terraform_state_versions".* FROM "terraform_state_versions" WHERE "terraform_state_versions"."id" BETWEEN 1 AND 1000 AND "terraform_state_versions"."file_store" = 1
SELECT "uploads".* FROM "uploads" WHERE "uploads"."id" BETWEEN 1 AND 1000 AND "uploads"."store" = 1

Selective Sync enabled - Project in certain groups (2 groups selected)

SELECT "ci_secure_files".* FROM "ci_secure_files" WHERE "ci_secure_files"."id" BETWEEN 1 AND 1000 AND "ci_secure_files"."file_store" = 1 AND "ci_secure_files"."project_id" IN (2, 7)
SELECT "container_repositories".* FROM "container_repositories" WHERE "container_repositories"."id" BETWEEN 1 AND 1000
SELECT "dependency_proxy_blobs".* FROM "dependency_proxy_blobs" INNER JOIN "namespaces" ON "namespaces"."id" = "dependency_proxy_blobs"."group_id" AND "namespaces"."type" = 'Group' WHERE "dependency_proxy_blobs"."id" BETWEEN 1 AND 1000 AND "namespaces"."id" IN (33, 24) AND "dependency_proxy_blobs"."file_store" = 1
SELECT "dependency_proxy_manifests".* FROM "dependency_proxy_manifests" INNER JOIN "namespaces" ON "namespaces"."id" = "dependency_proxy_manifests"."group_id" AND "namespaces"."type" = 'Group' WHERE "dependency_proxy_manifests"."id" BETWEEN 1 AND 1000 AND "namespaces"."id" IN (33, 24) AND "dependency_proxy_manifests"."file_store" = 1
SELECT "design_management_repositories".* FROM "design_management_repositories" WHERE "design_management_repositories"."id" BETWEEN 1 AND 1000 AND "design_management_repositories"."project_id" IN (2, 7)
SELECT "group_wiki_repositories".* FROM "group_wiki_repositories" INNER JOIN "namespaces" ON "namespaces"."id" = "group_wiki_repositories"."group_id" AND "namespaces"."type" = 'Group' WHERE "group_wiki_repositories"."group_id" IN (WITH RECURSIVE "base_and_descendants" AS ((SELECT "geo_node_namespace_links"."namespace_id" AS id FROM "geo_node_namespace_links" WHERE "geo_node_namespace_links"."geo_node_id" = 2) UNION (SELECT "namespaces"."id" FROM "namespaces", "base_and_descendants" WHERE "namespaces"."parent_id" = "base_and_descendants"."id")) SELECT "id" FROM "base_and_descendants" AS "namespaces") AND "group_wiki_repositories"."group_id" BETWEEN 1 AND 1000
SELECT "p_ci_job_artifacts".* FROM "p_ci_job_artifacts" WHERE "p_ci_job_artifacts"."id" BETWEEN 1 AND 1000 AND "p_ci_job_artifacts"."file_store" = 1 AND "p_ci_job_artifacts"."project_id" = 2
SELECT "lfs_objects".* FROM "lfs_objects" WHERE "lfs_objects"."id" IN (SELECT DISTINCT "lfs_objects_projects"."lfs_object_id" FROM "lfs_objects_projects" WHERE "lfs_objects_projects"."project_id" IN (SELECT "projects"."id" FROM "projects" WHERE "projects"."namespace_id" IN (WITH RECURSIVE "base_and_descendants" AS ((SELECT "geo_node_namespace_links"."namespace_id" AS id FROM "geo_node_namespace_links" WHERE "geo_node_namespace_links"."geo_node_id" = 2) UNION (SELECT "namespaces"."id" FROM "namespaces", "base_and_descendants" WHERE "namespaces"."parent_id" = "base_and_descendants"."id")) SELECT "id" FROM "base_and_descendants" AS "namespaces")) AND "lfs_objects_projects"."lfs_object_id" BETWEEN 1 AND 1000) AND "lfs_objects"."file_store" = 1
SELECT "merge_request_diffs".* FROM "merge_request_diffs" WHERE ("merge_request_diffs"."state" NOT IN ('without_files','empty')) AND "merge_request_diffs"."stored_externally" = TRUE AND "merge_request_diffs"."id" BETWEEN 1 AND 1000 AND "merge_request_diffs"."merge_request_id" IN (SELECT "merge_requests"."id" FROM "merge_requests" WHERE "merge_requests"."target_project_id" IN (SELECT "projects"."id" FROM "projects" WHERE "projects"."namespace_id" IN (WITH RECURSIVE "base_and_descendants" AS ((SELECT "geo_node_namespace_links"."namespace_id" AS id FROM "geo_node_namespace_links" WHERE "geo_node_namespace_links"."geo_node_id" = 2) UNION (SELECT "namespaces"."id" FROM "namespaces", "base_and_descendants" WHERE "namespaces"."parent_id" = "base_and_descendants"."id")) SELECT "id" FROM "base_and_descendants" AS "namespaces"))) AND "merge_request_diffs"."external_diff_store" = 1
SELECT "packages_package_files".* FROM "packages_package_files" INNER JOIN "packages_packages" ON "packages_packages"."id" = "packages_package_files"."package_id" WHERE "packages_package_files"."id" BETWEEN 1 AND 1000 AND "packages_packages"."project_id" IN (SELECT "projects"."id" FROM "projects" WHERE "projects"."namespace_id" IN (WITH RECURSIVE "base_and_descendants" AS ((SELECT "geo_node_namespace_links"."namespace_id" AS id FROM "geo_node_namespace_links" WHERE "geo_node_namespace_links"."geo_node_id" = 2) UNION (SELECT "namespaces"."id" FROM "namespaces", "base_and_descendants" WHERE "namespaces"."parent_id" = "base_and_descendants"."id")) SELECT "id" FROM "base_and_descendants" AS "namespaces")) AND "packages_package_files"."file_store" = 1
SELECT "pages_deployments".* FROM "pages_deployments" WHERE "pages_deployments"."id" BETWEEN 1 AND 1000 AND "pages_deployments"."project_id" IN (SELECT "projects"."id" FROM "projects" WHERE "projects"."namespace_id" IN (WITH RECURSIVE "base_and_descendants" AS ((SELECT "geo_node_namespace_links"."namespace_id" AS id FROM "geo_node_namespace_links" WHERE "geo_node_namespace_links"."geo_node_id" = 2) UNION (SELECT "namespaces"."id" FROM "namespaces", "base_and_descendants" WHERE "namespaces"."parent_id" = "base_and_descendants"."id")) SELECT "id" FROM "base_and_descendants" AS "namespaces")) AND "pages_deployments"."file_store" = 1
SELECT "ci_pipeline_artifacts".* FROM "ci_pipeline_artifacts" WHERE "ci_pipeline_artifacts"."id" BETWEEN 1 AND 1000 AND "ci_pipeline_artifacts"."file_store" = 1
SELECT "projects"."id", "projects"."name", "projects"."path", "projects"."description", "projects"."created_at", "projects"."updated_at", "projects"."creator_id", "projects"."namespace_id", "projects"."last_activity_at", "projects"."import_url", "projects"."visibility_level", "projects"."archived", "projects"."avatar", "projects"."merge_requests_template", "projects"."star_count", "projects"."merge_requests_rebase_enabled", "projects"."import_type", "projects"."import_source", "projects"."approvals_before_merge", "projects"."reset_approvals_on_push", "projects"."merge_requests_ff_only_enabled", "projects"."issues_template", "projects"."mirror", "projects"."mirror_last_update_at", "projects"."mirror_last_successful_update_at", "projects"."mirror_user_id", "projects"."shared_runners_enabled", "projects"."runners_token", "projects"."build_allow_git_fetch", "projects"."build_timeout", "projects"."mirror_trigger_builds", "projects"."pending_delete", "projects"."public_builds", "projects"."last_repository_check_failed", "projects"."last_repository_check_at", "projects"."only_allow_merge_if_pipeline_succeeds", "projects"."has_external_issue_tracker", "projects"."repository_storage", "projects"."repository_read_only", "projects"."request_access_enabled", "projects"."has_external_wiki", "projects"."ci_config_path", "projects"."lfs_enabled", "projects"."description_html", "projects"."only_allow_merge_if_all_discussions_are_resolved", "projects"."repository_size_limit", "projects"."printing_merge_request_link_enabled", "projects"."auto_cancel_pending_pipelines", "projects"."service_desk_enabled", "projects"."cached_markdown_version", "projects"."delete_error", "projects"."last_repository_updated_at", "projects"."disable_overriding_approvers_per_merge_request", "projects"."storage_version", "projects"."resolve_outdated_diff_discussions", "projects"."remote_mirror_available_overridden", "projects"."only_mirror_protected_branches", "projects"."pull_mirror_available_overridden", "projects"."jobs_cache_index", "projects"."external_authorization_classification_label", "projects"."mirror_overwrites_diverged_branches", "projects"."pages_https_only", "projects"."external_webhook_token", "projects"."packages_enabled", "projects"."merge_requests_author_approval", "projects"."pool_repository_id", "projects"."runners_token_encrypted", "projects"."bfg_object_map", "projects"."detected_repository_languages", "projects"."merge_requests_disable_committers_approval", "projects"."require_password_to_approve", "projects"."max_pages_size", "projects"."max_artifacts_size", "projects"."pull_mirror_branch_prefix", "projects"."remove_source_branch_after_merge", "projects"."marked_for_deletion_at", "projects"."marked_for_deletion_by_user_id", "projects"."autoclose_referenced_issues", "projects"."suggestion_commit_message", "projects"."project_namespace_id", "projects"."hidden", "projects"."organization_id" FROM "projects" WHERE "projects"."namespace_id" IN (WITH RECURSIVE "base_and_descendants" AS ((SELECT "geo_node_namespace_links"."namespace_id" AS id FROM "geo_node_namespace_links" WHERE "geo_node_namespace_links"."geo_node_id" = 2) UNION (SELECT "namespaces"."id" FROM "namespaces", "base_and_descendants" WHERE "namespaces"."parent_id" = "base_and_descendants"."id")) SELECT "id" FROM "base_and_descendants" AS "namespaces") AND "projects"."id" BETWEEN 1 AND 1000
SELECT "project_wiki_repositories".* FROM "project_wiki_repositories" WHERE "project_wiki_repositories"."id" BETWEEN 1 AND 1000 AND "project_wiki_repositories"."project_id" IN (2, 7, 3)
SELECT "snippet_repositories".* FROM ((SELECT "snippet_repositories".* FROM "snippet_repositories" INNER JOIN "snippets" ON "snippets"."id" = "snippet_repositories"."snippet_id" INNER JOIN "projects" ON "projects"."id" = "snippets"."project_id" WHERE "snippets"."project_id" IN (SELECT "projects"."id" FROM "projects" WHERE "projects"."namespace_id" IN (WITH RECURSIVE "base_and_descendants" AS ((SELECT "geo_node_namespace_links"."namespace_id" AS id FROM "geo_node_namespace_links" WHERE "geo_node_namespace_links"."geo_node_id" = 2) UNION (SELECT "namespaces"."id" FROM "namespaces", "base_and_descendants" WHERE "namespaces"."parent_id" = "base_and_descendants"."id")) SELECT "id" FROM "base_and_descendants" AS "namespaces"))) UNION (SELECT "snippet_repositories".* FROM "snippet_repositories" INNER JOIN "snippets" ON "snippets"."id" = "snippet_repositories"."snippet_id" WHERE "snippet_repositories"."snippet_id" IN (SELECT "snippets"."id" FROM "snippets" WHERE "snippets"."project_id" IS NULL))) snippet_repositories WHERE "snippet_repositories"."snippet_id" BETWEEN 1 AND 1000
SELECT "terraform_state_versions".* FROM "terraform_state_versions" INNER JOIN "terraform_states" ON "terraform_states"."id" = "terraform_state_versions"."terraform_state_id" WHERE "terraform_state_versions"."id" BETWEEN 1 AND 1000 AND "terraform_states"."project_id" IN (SELECT "projects"."id" FROM "projects" WHERE "projects"."namespace_id" IN (WITH RECURSIVE "base_and_descendants" AS ((SELECT "geo_node_namespace_links"."namespace_id" AS id FROM "geo_node_namespace_links" WHERE "geo_node_namespace_links"."geo_node_id" = 2) UNION (SELECT "namespaces"."id" FROM "namespaces", "base_and_descendants" WHERE "namespaces"."parent_id" = "base_and_descendants"."id")) SELECT "id" FROM "base_and_descendants" AS "namespaces")) AND "terraform_state_versions"."file_store" = 1
SELECT "uploads".* FROM "uploads" WHERE "uploads"."id" BETWEEN 1 AND 1000 AND ("uploads"."model_type" = 'Namespace' AND "uploads"."model_id" IN (WITH RECURSIVE "base_and_descendants" AS ((SELECT "geo_node_namespace_links"."namespace_id" AS id FROM "geo_node_namespace_links" WHERE "geo_node_namespace_links"."geo_node_id" = 2) UNION (SELECT "namespaces"."id" FROM "namespaces", "base_and_descendants" WHERE "namespaces"."parent_id" = "base_and_descendants"."id")) SELECT "id" FROM "base_and_descendants" AS "namespaces") OR "uploads"."model_type" = 'Project' AND "uploads"."model_id" IN (SELECT "projects"."id" FROM "projects" WHERE "projects"."namespace_id" IN (WITH RECURSIVE "base_and_descendants" AS ((SELECT "geo_node_namespace_links"."namespace_id" AS id FROM "geo_node_namespace_links" WHERE "geo_node_namespace_links"."geo_node_id" = 2) UNION (SELECT "namespaces"."id" FROM "namespaces", "base_and_descendants" WHERE "namespaces"."parent_id" = "base_and_descendants"."id")) SELECT "id" FROM "base_and_descendants" AS "namespaces")) OR "uploads"."model_type" NOT IN ('Namespace', 'Project')) AND "uploads"."store" = 1

Selective Sync enabled - Project in certain shards (1 shard selected)

SELECT "ci_secure_files".* FROM "ci_secure_files" WHERE "ci_secure_files"."id" BETWEEN 1 AND 1000 AND "ci_secure_files"."file_store" = 1 AND "ci_secure_files"."project_id" IN (2, 7)
SELECT "container_repositories".* FROM "container_repositories" WHERE "container_repositories"."id" BETWEEN 1 AND 1000
SELECT "dependency_proxy_blobs".* FROM "dependency_proxy_blobs" INNER JOIN "namespaces" ON "namespaces"."id" = "dependency_proxy_blobs"."group_id" AND "namespaces"."type" = 'Group' WHERE "dependency_proxy_blobs"."id" BETWEEN 1 AND 1000 AND "namespaces"."id" IN (WITH RECURSIVE "base_and_ancestors" AS ((SELECT "namespaces"."id", "namespaces"."parent_id" FROM "namespaces" WHERE "namespaces"."id" IN (SELECT "projects"."namespace_id" FROM "projects" WHERE "projects"."repository_storage" = 'default')) UNION (SELECT "namespaces"."id", "namespaces"."parent_id" FROM "namespaces", "base_and_ancestors" WHERE "namespaces"."id" = "base_and_ancestors"."parent_id")) SELECT "id" FROM "base_and_ancestors" AS "namespaces") AND "dependency_proxy_blobs"."file_store" = 1
SELECT "dependency_proxy_manifests".* FROM "dependency_proxy_manifests" INNER JOIN "namespaces" ON "namespaces"."id" = "dependency_proxy_manifests"."group_id" AND "namespaces"."type" = 'Group' WHERE "dependency_proxy_manifests"."id" BETWEEN 1 AND 1000 AND "namespaces"."id" IN (WITH RECURSIVE "base_and_ancestors" AS ((SELECT "namespaces"."id", "namespaces"."parent_id" FROM "namespaces" WHERE "namespaces"."id" IN (SELECT "projects"."namespace_id" FROM "projects" WHERE "projects"."repository_storage" = 'default')) UNION (SELECT "namespaces"."id", "namespaces"."parent_id" FROM "namespaces", "base_and_ancestors" WHERE "namespaces"."id" = "base_and_ancestors"."parent_id")) SELECT "id" FROM "base_and_ancestors" AS "namespaces") AND "dependency_proxy_manifests"."file_store" = 1
SELECT "design_management_repositories".* FROM "design_management_repositories" WHERE "design_management_repositories"."id" BETWEEN 1 AND 1000 AND "design_management_repositories"."project_id" IN (2, 7)
SELECT "group_wiki_repositories".* FROM "group_wiki_repositories" INNER JOIN "shards" ON "shards"."id" = "group_wiki_repositories"."shard_id" WHERE "shards"."name" = 'default' AND "group_wiki_repositories"."group_id" BETWEEN 1 AND 1000
SELECT "p_ci_job_artifacts".* FROM "p_ci_job_artifacts" WHERE "p_ci_job_artifacts"."id" BETWEEN 1 AND 1000 AND "p_ci_job_artifacts"."file_store" = 1 AND "p_ci_job_artifacts"."project_id" IN (2, 4, 8, 6, 5)
SELECT "lfs_objects".* FROM "lfs_objects" WHERE "lfs_objects"."id" IN (SELECT DISTINCT "lfs_objects_projects"."lfs_object_id" FROM "lfs_objects_projects" WHERE "lfs_objects_projects"."project_id" IN (SELECT "projects"."id" FROM "projects" WHERE "projects"."repository_storage" = 'default') AND "lfs_objects_projects"."lfs_object_id" BETWEEN 1 AND 1000) AND "lfs_objects"."file_store" = 1
SELECT "merge_request_diffs".* FROM "merge_request_diffs" WHERE ("merge_request_diffs"."state" NOT IN ('without_files','empty')) AND "merge_request_diffs"."stored_externally" = TRUE AND "merge_request_diffs"."id" BETWEEN 1 AND 1000 AND "merge_request_diffs"."merge_request_id" IN (SELECT "merge_requests"."id" FROM "merge_requests" WHERE "merge_requests"."target_project_id" IN (SELECT "projects"."id" FROM "projects" WHERE "projects"."repository_storage" = 'default')) AND "merge_request_diffs"."external_diff_store" = 1
SELECT "packages_package_files".* FROM "packages_package_files" INNER JOIN "packages_packages" ON "packages_packages"."id" = "packages_package_files"."package_id" WHERE "packages_package_files"."id" BETWEEN 1 AND 1000 AND "packages_packages"."project_id" IN (SELECT "projects"."id" FROM "projects" WHERE "projects"."repository_storage" = 'default') AND "packages_package_files"."file_store" = 1
SELECT "pages_deployments".* FROM "pages_deployments" WHERE "pages_deployments"."id" BETWEEN 1 AND 1000 AND "pages_deployments"."project_id" IN (SELECT "projects"."id" FROM "projects" WHERE "projects"."repository_storage" = 'default') AND "pages_deployments"."file_store" = 1
SELECT "ci_pipeline_artifacts".* FROM "ci_pipeline_artifacts" WHERE "ci_pipeline_artifacts"."id" BETWEEN 1 AND 1000 AND "ci_pipeline_artifacts"."file_store" = 1
SELECT "projects"."id", "projects"."name", "projects"."path", "projects"."description", "projects"."created_at", "projects"."updated_at", "projects"."creator_id", "projects"."namespace_id", "projects"."last_activity_at", "projects"."import_url", "projects"."visibility_level", "projects"."archived", "projects"."avatar", "projects"."merge_requests_template", "projects"."star_count", "projects"."merge_requests_rebase_enabled", "projects"."import_type", "projects"."import_source", "projects"."approvals_before_merge", "projects"."reset_approvals_on_push", "projects"."merge_requests_ff_only_enabled", "projects"."issues_template", "projects"."mirror", "projects"."mirror_last_update_at", "projects"."mirror_last_successful_update_at", "projects"."mirror_user_id", "projects"."shared_runners_enabled", "projects"."runners_token", "projects"."build_allow_git_fetch", "projects"."build_timeout", "projects"."mirror_trigger_builds", "projects"."pending_delete", "projects"."public_builds", "projects"."last_repository_check_failed", "projects"."last_repository_check_at", "projects"."only_allow_merge_if_pipeline_succeeds", "projects"."has_external_issue_tracker", "projects"."repository_storage", "projects"."repository_read_only", "projects"."request_access_enabled", "projects"."has_external_wiki", "projects"."ci_config_path", "projects"."lfs_enabled", "projects"."description_html", "projects"."only_allow_merge_if_all_discussions_are_resolved", "projects"."repository_size_limit", "projects"."printing_merge_request_link_enabled", "projects"."auto_cancel_pending_pipelines", "projects"."service_desk_enabled", "projects"."cached_markdown_version", "projects"."delete_error", "projects"."last_repository_updated_at", "projects"."disable_overriding_approvers_per_merge_request", "projects"."storage_version", "projects"."resolve_outdated_diff_discussions", "projects"."remote_mirror_available_overridden", "projects"."only_mirror_protected_branches", "projects"."pull_mirror_available_overridden", "projects"."jobs_cache_index", "projects"."external_authorization_classification_label", "projects"."mirror_overwrites_diverged_branches", "projects"."pages_https_only", "projects"."external_webhook_token", "projects"."packages_enabled", "projects"."merge_requests_author_approval", "projects"."pool_repository_id", "projects"."runners_token_encrypted", "projects"."bfg_object_map", "projects"."detected_repository_languages", "projects"."merge_requests_disable_committers_approval", "projects"."require_password_to_approve", "projects"."max_pages_size", "projects"."max_artifacts_size", "projects"."pull_mirror_branch_prefix", "projects"."remove_source_branch_after_merge", "projects"."marked_for_deletion_at", "projects"."marked_for_deletion_by_user_id", "projects"."autoclose_referenced_issues", "projects"."suggestion_commit_message", "projects"."project_namespace_id", "projects"."hidden", "projects"."organization_id" FROM "projects" WHERE "projects"."repository_storage" = 'default' AND "projects"."id" BETWEEN 1 AND 1000
SELECT "project_wiki_repositories".* FROM "project_wiki_repositories" WHERE "project_wiki_repositories"."id" BETWEEN 1 AND 1000 AND "project_wiki_repositories"."project_id" IN (2, 7, 16, 17, 13, 11, 12, 4, 1, 3, 8, 6, 9, 10, 14, 15, 5)
SELECT "snippet_repositories".* FROM "snippet_repositories" INNER JOIN "shards" ON "shards"."id" = "snippet_repositories"."shard_id" WHERE "shards"."name" = 'default' AND "snippet_repositories"."snippet_id" BETWEEN 1 AND 1000
SELECT "terraform_state_versions".* FROM "terraform_state_versions" INNER JOIN "terraform_states" ON "terraform_states"."id" = "terraform_state_versions"."terraform_state_id" WHERE "terraform_state_versions"."id" BETWEEN 1 AND 1000 AND "terraform_states"."project_id" IN (SELECT "projects"."id" FROM "projects" WHERE "projects"."repository_storage" = 'default') AND "terraform_state_versions"."file_store" = 1
SELECT "uploads".* FROM "uploads" WHERE "uploads"."id" BETWEEN 1 AND 1000 AND ("uploads"."model_type" = 'Namespace' AND "uploads"."model_id" IN (WITH RECURSIVE "base_and_ancestors" AS ((SELECT "namespaces"."id", "namespaces"."parent_id" FROM "namespaces" WHERE "namespaces"."id" IN (SELECT "projects"."namespace_id" FROM "projects" WHERE "projects"."repository_storage" = 'default')) UNION (SELECT "namespaces"."id", "namespaces"."parent_id" FROM "namespaces", "base_and_ancestors" WHERE "namespaces"."id" = "base_and_ancestors"."parent_id")) SELECT "id" FROM "base_and_ancestors" AS "namespaces") OR "uploads"."model_type" = 'Project' AND "uploads"."model_id" IN (SELECT "projects"."id" FROM "projects" WHERE "projects"."repository_storage" = 'default') OR "uploads"."model_type" NOT IN ('Namespace', 'Project')) AND "uploads"."store" = 1

Geo Secondary Site (After)

Click to expand

Selective Sync Disabled

SELECT "ci_secure_files".* FROM "ci_secure_files" WHERE "ci_secure_files"."id" BETWEEN 1 AND 1000 AND "ci_secure_files"."file_store" = 1
SELECT "container_repositories".* FROM "container_repositories" WHERE "container_repositories"."id" BETWEEN 1 AND 1000
SELECT "dependency_proxy_blobs".* FROM "dependency_proxy_blobs" WHERE "dependency_proxy_blobs"."id" BETWEEN 1 AND 1000 AND "dependency_proxy_blobs"."file_store" = 1
SELECT "dependency_proxy_manifests".* FROM "dependency_proxy_manifests" WHERE "dependency_proxy_manifests"."id" BETWEEN 1 AND 1000 AND "dependency_proxy_manifests"."file_store" = 1
SELECT "design_management_repositories".* FROM "design_management_repositories" WHERE "design_management_repositories"."id" BETWEEN 1 AND 1000
SELECT "group_wiki_repositories".* FROM "group_wiki_repositories" WHERE "group_wiki_repositories"."group_id" BETWEEN 1 AND 1000
SELECT "p_ci_job_artifacts".* FROM "p_ci_job_artifacts" WHERE "p_ci_job_artifacts"."id" BETWEEN 1 AND 1000 AND "p_ci_job_artifacts"."file_store" = 1
SELECT "lfs_objects".* FROM "lfs_objects" WHERE "lfs_objects"."file_store" = 1 AND "lfs_objects"."id" BETWEEN 1 AND 1000
SELECT "merge_request_diffs".* FROM "merge_request_diffs" WHERE ("merge_request_diffs"."state" NOT IN ('without_files','empty')) AND "merge_request_diffs"."stored_externally" = TRUE AND "merge_request_diffs"."id" BETWEEN 1 AND 1000 AND "merge_request_diffs"."external_diff_store" = 1
SELECT "packages_package_files".* FROM "packages_package_files" WHERE "packages_package_files"."id" BETWEEN 1 AND 1000 AND "packages_package_files"."file_store" = 1
SELECT "pages_deployments".* FROM "pages_deployments" WHERE "pages_deployments"."id" BETWEEN 1 AND 1000 AND "pages_deployments"."file_store" = 1
SELECT "ci_pipeline_artifacts".* FROM "ci_pipeline_artifacts" WHERE "ci_pipeline_artifacts"."id" BETWEEN 1 AND 1000 AND "ci_pipeline_artifacts"."file_store" = 1
SELECT "projects"."id", "projects"."name", "projects"."path", "projects"."description", "projects"."created_at", "projects"."updated_at", "projects"."creator_id", "projects"."namespace_id", "projects"."last_activity_at", "projects"."import_url", "projects"."visibility_level", "projects"."archived", "projects"."avatar", "projects"."merge_requests_template", "projects"."star_count", "projects"."merge_requests_rebase_enabled", "projects"."import_type", "projects"."import_source", "projects"."approvals_before_merge", "projects"."reset_approvals_on_push", "projects"."merge_requests_ff_only_enabled", "projects"."issues_template", "projects"."mirror", "projects"."mirror_last_update_at", "projects"."mirror_last_successful_update_at", "projects"."mirror_user_id", "projects"."shared_runners_enabled", "projects"."runners_token", "projects"."build_allow_git_fetch", "projects"."build_timeout", "projects"."mirror_trigger_builds", "projects"."pending_delete", "projects"."public_builds", "projects"."last_repository_check_failed", "projects"."last_repository_check_at", "projects"."only_allow_merge_if_pipeline_succeeds", "projects"."has_external_issue_tracker", "projects"."repository_storage", "projects"."repository_read_only", "projects"."request_access_enabled", "projects"."has_external_wiki", "projects"."ci_config_path", "projects"."lfs_enabled", "projects"."description_html", "projects"."only_allow_merge_if_all_discussions_are_resolved", "projects"."repository_size_limit", "projects"."printing_merge_request_link_enabled", "projects"."auto_cancel_pending_pipelines", "projects"."service_desk_enabled", "projects"."cached_markdown_version", "projects"."delete_error", "projects"."last_repository_updated_at", "projects"."disable_overriding_approvers_per_merge_request", "projects"."storage_version", "projects"."resolve_outdated_diff_discussions", "projects"."remote_mirror_available_overridden", "projects"."only_mirror_protected_branches", "projects"."pull_mirror_available_overridden", "projects"."jobs_cache_index", "projects"."external_authorization_classification_label", "projects"."mirror_overwrites_diverged_branches", "projects"."pages_https_only", "projects"."external_webhook_token", "projects"."packages_enabled", "projects"."merge_requests_author_approval", "projects"."pool_repository_id", "projects"."runners_token_encrypted", "projects"."bfg_object_map", "projects"."detected_repository_languages", "projects"."merge_requests_disable_committers_approval", "projects"."require_password_to_approve", "projects"."max_pages_size", "projects"."max_artifacts_size", "projects"."pull_mirror_branch_prefix", "projects"."remove_source_branch_after_merge", "projects"."marked_for_deletion_at", "projects"."marked_for_deletion_by_user_id", "projects"."autoclose_referenced_issues", "projects"."suggestion_commit_message", "projects"."project_namespace_id", "projects"."hidden", "projects"."organization_id" FROM "projects" WHERE "projects"."id" BETWEEN 1 AND 1000
SELECT "project_wiki_repositories".* FROM "project_wiki_repositories" WHERE "project_wiki_repositories"."id" BETWEEN 1 AND 1000
SELECT "snippet_repositories".* FROM "snippet_repositories" WHERE "snippet_repositories"."snippet_id" BETWEEN 1 AND 1000
SELECT "terraform_state_versions".* FROM "terraform_state_versions" WHERE "terraform_state_versions"."id" BETWEEN 1 AND 1000 AND "terraform_state_versions"."file_store" = 1
SELECT "uploads".* FROM "uploads" WHERE "uploads"."id" BETWEEN 1 AND 1000 AND "uploads"."store" = 1

Selective Sync enabled - Project in certain groups (2 groups selected)

SELECT "ci_secure_files".* FROM "ci_secure_files" WHERE "ci_secure_files"."id" BETWEEN 1 AND 1000 AND "ci_secure_files"."file_store" = 1 AND "ci_secure_files"."project_id" IN (2, 7)
SELECT "container_repositories".* FROM "container_repositories" WHERE "container_repositories"."id" BETWEEN 1 AND 1000
SELECT "dependency_proxy_blobs".* FROM "dependency_proxy_blobs" INNER JOIN "namespaces" ON "namespaces"."id" = "dependency_proxy_blobs"."group_id" AND "namespaces"."type" = 'Group' WHERE "dependency_proxy_blobs"."id" BETWEEN 1 AND 1000 AND "dependency_proxy_blobs"."file_store" = 1 AND "namespaces"."id" IN (33, 24)
SELECT "dependency_proxy_manifests".* FROM "dependency_proxy_manifests" INNER JOIN "namespaces" ON "namespaces"."id" = "dependency_proxy_manifests"."group_id" AND "namespaces"."type" = 'Group' WHERE "dependency_proxy_manifests"."id" BETWEEN 1 AND 1000 AND "dependency_proxy_manifests"."file_store" = 1 AND "namespaces"."id" IN (33, 24)
SELECT "design_management_repositories".* FROM "design_management_repositories" WHERE "design_management_repositories"."id" BETWEEN 1 AND 1000 AND "design_management_repositories"."project_id" IN (2, 7)
SELECT "group_wiki_repositories".* FROM "group_wiki_repositories" INNER JOIN "namespaces" ON "namespaces"."id" = "group_wiki_repositories"."group_id" AND "namespaces"."type" = 'Group' WHERE "group_wiki_repositories"."group_id" IN (WITH RECURSIVE "base_and_descendants" AS ((SELECT "geo_node_namespace_links"."namespace_id" AS id FROM "geo_node_namespace_links" WHERE "geo_node_namespace_links"."geo_node_id" = 2) UNION (SELECT "namespaces"."id" FROM "namespaces", "base_and_descendants" WHERE "namespaces"."parent_id" = "base_and_descendants"."id")) SELECT "id" FROM "base_and_descendants" AS "namespaces") AND "group_wiki_repositories"."group_id" BETWEEN 1 AND 1000
SELECT "p_ci_job_artifacts".* FROM "p_ci_job_artifacts" WHERE "p_ci_job_artifacts"."id" BETWEEN 1 AND 1000 AND "p_ci_job_artifacts"."file_store" = 1 AND "p_ci_job_artifacts"."project_id" = 2
SELECT "lfs_objects".* FROM "lfs_objects" WHERE "lfs_objects"."file_store" = 1 AND "lfs_objects"."id" BETWEEN 1 AND 1000 AND "lfs_objects"."id" IN (SELECT DISTINCT "lfs_objects_projects"."lfs_object_id" FROM "lfs_objects_projects" WHERE "lfs_objects_projects"."project_id" IN (SELECT "projects"."id" FROM "projects" WHERE "projects"."namespace_id" IN (WITH RECURSIVE "base_and_descendants" AS ((SELECT "geo_node_namespace_links"."namespace_id" AS id FROM "geo_node_namespace_links" WHERE "geo_node_namespace_links"."geo_node_id" = 2) UNION (SELECT "namespaces"."id" FROM "namespaces", "base_and_descendants" WHERE "namespaces"."parent_id" = "base_and_descendants"."id")) SELECT "id" FROM "base_and_descendants" AS "namespaces")) AND "lfs_objects_projects"."lfs_object_id" BETWEEN 1 AND 1000)
SELECT "merge_request_diffs".* FROM "merge_request_diffs" WHERE ("merge_request_diffs"."state" NOT IN ('without_files','empty')) AND "merge_request_diffs"."stored_externally" = TRUE AND "merge_request_diffs"."id" BETWEEN 1 AND 1000 AND "merge_request_diffs"."external_diff_store" = 1 AND "merge_request_diffs"."merge_request_id" IN (SELECT "merge_requests"."id" FROM "merge_requests" WHERE "merge_requests"."target_project_id" IN (SELECT "projects"."id" FROM "projects" WHERE "projects"."namespace_id" IN (WITH RECURSIVE "base_and_descendants" AS ((SELECT "geo_node_namespace_links"."namespace_id" AS id FROM "geo_node_namespace_links" WHERE "geo_node_namespace_links"."geo_node_id" = 2) UNION (SELECT "namespaces"."id" FROM "namespaces", "base_and_descendants" WHERE "namespaces"."parent_id" = "base_and_descendants"."id")) SELECT "id" FROM "base_and_descendants" AS "namespaces")))
SELECT "packages_package_files".* FROM "packages_package_files" INNER JOIN "packages_packages" ON "packages_packages"."id" = "packages_package_files"."package_id" WHERE "packages_package_files"."id" BETWEEN 1 AND 1000 AND "packages_package_files"."file_store" = 1 AND "packages_packages"."project_id" IN (SELECT "projects"."id" FROM "projects" WHERE "projects"."namespace_id" IN (WITH RECURSIVE "base_and_descendants" AS ((SELECT "geo_node_namespace_links"."namespace_id" AS id FROM "geo_node_namespace_links" WHERE "geo_node_namespace_links"."geo_node_id" = 2) UNION (SELECT "namespaces"."id" FROM "namespaces", "base_and_descendants" WHERE "namespaces"."parent_id" = "base_and_descendants"."id")) SELECT "id" FROM "base_and_descendants" AS "namespaces"))
SELECT "pages_deployments".* FROM "pages_deployments" WHERE "pages_deployments"."id" BETWEEN 1 AND 1000 AND "pages_deployments"."file_store" = 1 AND "pages_deployments"."project_id" IN (SELECT "projects"."id" FROM "projects" WHERE "projects"."namespace_id" IN (WITH RECURSIVE "base_and_descendants" AS ((SELECT "geo_node_namespace_links"."namespace_id" AS id FROM "geo_node_namespace_links" WHERE "geo_node_namespace_links"."geo_node_id" = 2) UNION (SELECT "namespaces"."id" FROM "namespaces", "base_and_descendants" WHERE "namespaces"."parent_id" = "base_and_descendants"."id")) SELECT "id" FROM "base_and_descendants" AS "namespaces"))
SELECT "ci_pipeline_artifacts".* FROM "ci_pipeline_artifacts" WHERE "ci_pipeline_artifacts"."id" BETWEEN 1 AND 1000 AND "ci_pipeline_artifacts"."file_store" = 1
SELECT "projects"."id", "projects"."name", "projects"."path", "projects"."description", "projects"."created_at", "projects"."updated_at", "projects"."creator_id", "projects"."namespace_id", "projects"."last_activity_at", "projects"."import_url", "projects"."visibility_level", "projects"."archived", "projects"."avatar", "projects"."merge_requests_template", "projects"."star_count", "projects"."merge_requests_rebase_enabled", "projects"."import_type", "projects"."import_source", "projects"."approvals_before_merge", "projects"."reset_approvals_on_push", "projects"."merge_requests_ff_only_enabled", "projects"."issues_template", "projects"."mirror", "projects"."mirror_last_update_at", "projects"."mirror_last_successful_update_at", "projects"."mirror_user_id", "projects"."shared_runners_enabled", "projects"."runners_token", "projects"."build_allow_git_fetch", "projects"."build_timeout", "projects"."mirror_trigger_builds", "projects"."pending_delete", "projects"."public_builds", "projects"."last_repository_check_failed", "projects"."last_repository_check_at", "projects"."only_allow_merge_if_pipeline_succeeds", "projects"."has_external_issue_tracker", "projects"."repository_storage", "projects"."repository_read_only", "projects"."request_access_enabled", "projects"."has_external_wiki", "projects"."ci_config_path", "projects"."lfs_enabled", "projects"."description_html", "projects"."only_allow_merge_if_all_discussions_are_resolved", "projects"."repository_size_limit", "projects"."printing_merge_request_link_enabled", "projects"."auto_cancel_pending_pipelines", "projects"."service_desk_enabled", "projects"."cached_markdown_version", "projects"."delete_error", "projects"."last_repository_updated_at", "projects"."disable_overriding_approvers_per_merge_request", "projects"."storage_version", "projects"."resolve_outdated_diff_discussions", "projects"."remote_mirror_available_overridden", "projects"."only_mirror_protected_branches", "projects"."pull_mirror_available_overridden", "projects"."jobs_cache_index", "projects"."external_authorization_classification_label", "projects"."mirror_overwrites_diverged_branches", "projects"."pages_https_only", "projects"."external_webhook_token", "projects"."packages_enabled", "projects"."merge_requests_author_approval", "projects"."pool_repository_id", "projects"."runners_token_encrypted", "projects"."bfg_object_map", "projects"."detected_repository_languages", "projects"."merge_requests_disable_committers_approval", "projects"."require_password_to_approve", "projects"."max_pages_size", "projects"."max_artifacts_size", "projects"."pull_mirror_branch_prefix", "projects"."remove_source_branch_after_merge", "projects"."marked_for_deletion_at", "projects"."marked_for_deletion_by_user_id", "projects"."autoclose_referenced_issues", "projects"."suggestion_commit_message", "projects"."project_namespace_id", "projects"."hidden", "projects"."organization_id" FROM "projects" WHERE "projects"."id" BETWEEN 1 AND 1000 AND "projects"."namespace_id" IN (WITH RECURSIVE "base_and_descendants" AS ((SELECT "geo_node_namespace_links"."namespace_id" AS id FROM "geo_node_namespace_links" WHERE "geo_node_namespace_links"."geo_node_id" = 2) UNION (SELECT "namespaces"."id" FROM "namespaces", "base_and_descendants" WHERE "namespaces"."parent_id" = "base_and_descendants"."id")) SELECT "id" FROM "base_and_descendants" AS "namespaces")
SELECT "project_wiki_repositories".* FROM "project_wiki_repositories" WHERE "project_wiki_repositories"."id" BETWEEN 1 AND 1000 AND "project_wiki_repositories"."project_id" IN (2, 7, 3)
SELECT "snippet_repositories".* FROM ((SELECT "snippet_repositories".* FROM "snippet_repositories" INNER JOIN "snippets" ON "snippets"."id" = "snippet_repositories"."snippet_id" INNER JOIN "projects" ON "projects"."id" = "snippets"."project_id" WHERE "snippets"."project_id" IN (SELECT "projects"."id" FROM "projects" WHERE "projects"."namespace_id" IN (WITH RECURSIVE "base_and_descendants" AS ((SELECT "geo_node_namespace_links"."namespace_id" AS id FROM "geo_node_namespace_links" WHERE "geo_node_namespace_links"."geo_node_id" = 2) UNION (SELECT "namespaces"."id" FROM "namespaces", "base_and_descendants" WHERE "namespaces"."parent_id" = "base_and_descendants"."id")) SELECT "id" FROM "base_and_descendants" AS "namespaces"))) UNION (SELECT "snippet_repositories".* FROM "snippet_repositories" INNER JOIN "snippets" ON "snippets"."id" = "snippet_repositories"."snippet_id" WHERE "snippet_repositories"."snippet_id" IN (SELECT "snippets"."id" FROM "snippets" WHERE "snippets"."project_id" IS NULL))) snippet_repositories WHERE "snippet_repositories"."snippet_id" BETWEEN 1 AND 1000
SELECT "terraform_state_versions".* FROM "terraform_state_versions" INNER JOIN "terraform_states" ON "terraform_states"."id" = "terraform_state_versions"."terraform_state_id" WHERE "terraform_state_versions"."id" BETWEEN 1 AND 1000 AND "terraform_state_versions"."file_store" = 1 AND "terraform_states"."project_id" IN (SELECT "projects"."id" FROM "projects" WHERE "projects"."namespace_id" IN (WITH RECURSIVE "base_and_descendants" AS ((SELECT "geo_node_namespace_links"."namespace_id" AS id FROM "geo_node_namespace_links" WHERE "geo_node_namespace_links"."geo_node_id" = 2) UNION (SELECT "namespaces"."id" FROM "namespaces", "base_and_descendants" WHERE "namespaces"."parent_id" = "base_and_descendants"."id")) SELECT "id" FROM "base_and_descendants" AS "namespaces"))
SELECT "uploads".* FROM "uploads" WHERE "uploads"."id" BETWEEN 1 AND 1000 AND "uploads"."store" = 1 AND ("uploads"."model_type" = 'Namespace' AND "uploads"."model_id" IN (WITH RECURSIVE "base_and_descendants" AS ((SELECT "geo_node_namespace_links"."namespace_id" AS id FROM "geo_node_namespace_links" WHERE "geo_node_namespace_links"."geo_node_id" = 2) UNION (SELECT "namespaces"."id" FROM "namespaces", "base_and_descendants" WHERE "namespaces"."parent_id" = "base_and_descendants"."id")) SELECT "id" FROM "base_and_descendants" AS "namespaces") OR "uploads"."model_type" = 'Project' AND "uploads"."model_id" IN (SELECT "projects"."id" FROM "projects" WHERE "projects"."namespace_id" IN (WITH RECURSIVE "base_and_descendants" AS ((SELECT "geo_node_namespace_links"."namespace_id" AS id FROM "geo_node_namespace_links" WHERE "geo_node_namespace_links"."geo_node_id" = 2) UNION (SELECT "namespaces"."id" FROM "namespaces", "base_and_descendants" WHERE "namespaces"."parent_id" = "base_and_descendants"."id")) SELECT "id" FROM "base_and_descendants" AS "namespaces")) OR "uploads"."model_type" NOT IN ('Namespace', 'Project')

Selective Sync enabled - Project in certain shards (1 shard selected)

SELECT "ci_secure_files".* FROM "ci_secure_files" WHERE "ci_secure_files"."id" BETWEEN 1 AND 1000 AND "ci_secure_files"."file_store" = 1 AND "ci_secure_files"."project_id" IN (2, 7)
SELECT "container_repositories".* FROM "container_repositories" WHERE "container_repositories"."id" BETWEEN 1 AND 1000
SELECT "dependency_proxy_blobs".* FROM "dependency_proxy_blobs" INNER JOIN "namespaces" ON "namespaces"."id" = "dependency_proxy_blobs"."group_id" AND "namespaces"."type" = 'Group' WHERE "dependency_proxy_blobs"."id" BETWEEN 1 AND 1000 AND "dependency_proxy_blobs"."file_store" = 1 AND "namespaces"."id" IN (WITH RECURSIVE "base_and_ancestors" AS ((SELECT "namespaces"."id", "namespaces"."parent_id" FROM "namespaces" WHERE "namespaces"."id" IN (SELECT "projects"."namespace_id" FROM "projects" WHERE "projects"."repository_storage" = 'default')) UNION (SELECT "namespaces"."id", "namespaces"."parent_id" FROM "namespaces", "base_and_ancestors" WHERE "namespaces"."id" = "base_and_ancestors"."parent_id")) SELECT "id" FROM "base_and_ancestors" AS "namespaces")
SELECT "dependency_proxy_manifests".* FROM "dependency_proxy_manifests" INNER JOIN "namespaces" ON "namespaces"."id" = "dependency_proxy_manifests"."group_id" AND "namespaces"."type" = 'Group' WHERE "dependency_proxy_manifests"."id" BETWEEN 1 AND 1000 AND "dependency_proxy_manifests"."file_store" = 1 AND "namespaces"."id" IN (WITH RECURSIVE "base_and_ancestors" AS ((SELECT "namespaces"."id", "namespaces"."parent_id" FROM "namespaces" WHERE "namespaces"."id" IN (SELECT "projects"."namespace_id" FROM "projects" WHERE "projects"."repository_storage" = 'default')) UNION (SELECT "namespaces"."id", "namespaces"."parent_id" FROM "namespaces", "base_and_ancestors" WHERE "namespaces"."id" = "base_and_ancestors"."parent_id")) SELECT "id" FROM "base_and_ancestors" AS "namespaces")
SELECT "design_management_repositories".* FROM "design_management_repositories" WHERE "design_management_repositories"."id" BETWEEN 1 AND 1000 AND "design_management_repositories"."project_id" IN (2, 7)
SELECT "group_wiki_repositories".* FROM "group_wiki_repositories" INNER JOIN "shards" ON "shards"."id" = "group_wiki_repositories"."shard_id" WHERE "group_wiki_repositories"."group_id" BETWEEN 1 AND 1000 AND "shards"."name" = 'default'
SELECT "p_ci_job_artifacts".* FROM "p_ci_job_artifacts" WHERE "p_ci_job_artifacts"."id" BETWEEN 1 AND 1000 AND "p_ci_job_artifacts"."file_store" = 1 AND "p_ci_job_artifacts"."project_id" IN (2, 4, 8, 6, 5)
SELECT "lfs_objects".* FROM "lfs_objects" WHERE "lfs_objects"."file_store" = 1 AND "lfs_objects"."id" BETWEEN 1 AND 1000 AND "lfs_objects"."id" IN (SELECT DISTINCT "lfs_objects_projects"."lfs_object_id" FROM "lfs_objects_projects" WHERE "lfs_objects_projects"."project_id" IN (SELECT "projects"."id" FROM "projects" WHERE "projects"."repository_storage" = 'default') AND "lfs_objects_projects"."lfs_object_id" BETWEEN 1 AND 1000)
SELECT "merge_request_diffs".* FROM "merge_request_diffs" WHERE ("merge_request_diffs"."state" NOT IN ('without_files','empty')) AND "merge_request_diffs"."stored_externally" = TRUE AND "merge_request_diffs"."id" BETWEEN 1 AND 1000 AND "merge_request_diffs"."external_diff_store" = 1 AND "merge_request_diffs"."merge_request_id" IN (SELECT "merge_requests"."id" FROM "merge_requests" WHERE "merge_requests"."target_project_id" IN (SELECT "projects"."id" FROM "projects" WHERE "projects"."repository_storage" = 'default'))
SELECT "packages_package_files".* FROM "packages_package_files" INNER JOIN "packages_packages" ON "packages_packages"."id" = "packages_package_files"."package_id" WHERE "packages_package_files"."id" BETWEEN 1 AND 1000 AND "packages_package_files"."file_store" = 1 AND "packages_packages"."project_id" IN (SELECT "projects"."id" FROM "projects" WHERE "projects"."repository_storage" = 'default')
SELECT "pages_deployments".* FROM "pages_deployments" WHERE "pages_deployments"."id" BETWEEN 1 AND 1000 AND "pages_deployments"."file_store" = 1 AND "pages_deployments"."project_id" IN (SELECT "projects"."id" FROM "projects" WHERE "projects"."repository_storage" = 'default')
SELECT "ci_pipeline_artifacts".* FROM "ci_pipeline_artifacts" WHERE "ci_pipeline_artifacts"."id" BETWEEN 1 AND 1000 AND "ci_pipeline_artifacts"."file_store" = 1
SELECT "projects"."id", "projects"."name", "projects"."path", "projects"."description", "projects"."created_at", "projects"."updated_at", "projects"."creator_id", "projects"."namespace_id", "projects"."last_activity_at", "projects"."import_url", "projects"."visibility_level", "projects"."archived", "projects"."avatar", "projects"."merge_requests_template", "projects"."star_count", "projects"."merge_requests_rebase_enabled", "projects"."import_type", "projects"."import_source", "projects"."approvals_before_merge", "projects"."reset_approvals_on_push", "projects"."merge_requests_ff_only_enabled", "projects"."issues_template", "projects"."mirror", "projects"."mirror_last_update_at", "projects"."mirror_last_successful_update_at", "projects"."mirror_user_id", "projects"."shared_runners_enabled", "projects"."runners_token", "projects"."build_allow_git_fetch", "projects"."build_timeout", "projects"."mirror_trigger_builds", "projects"."pending_delete", "projects"."public_builds", "projects"."last_repository_check_failed", "projects"."last_repository_check_at", "projects"."only_allow_merge_if_pipeline_succeeds", "projects"."has_external_issue_tracker", "projects"."repository_storage", "projects"."repository_read_only", "projects"."request_access_enabled", "projects"."has_external_wiki", "projects"."ci_config_path", "projects"."lfs_enabled", "projects"."description_html", "projects"."only_allow_merge_if_all_discussions_are_resolved", "projects"."repository_size_limit", "projects"."printing_merge_request_link_enabled", "projects"."auto_cancel_pending_pipelines", "projects"."service_desk_enabled", "projects"."cached_markdown_version", "projects"."delete_error", "projects"."last_repository_updated_at", "projects"."disable_overriding_approvers_per_merge_request", "projects"."storage_version", "projects"."resolve_outdated_diff_discussions", "projects"."remote_mirror_available_overridden", "projects"."only_mirror_protected_branches", "projects"."pull_mirror_available_overridden", "projects"."jobs_cache_index", "projects"."external_authorization_classification_label", "projects"."mirror_overwrites_diverged_branches", "projects"."pages_https_only", "projects"."external_webhook_token", "projects"."packages_enabled", "projects"."merge_requests_author_approval", "projects"."pool_repository_id", "projects"."runners_token_encrypted", "projects"."bfg_object_map", "projects"."detected_repository_languages", "projects"."merge_requests_disable_committers_approval", "projects"."require_password_to_approve", "projects"."max_pages_size", "projects"."max_artifacts_size", "projects"."pull_mirror_branch_prefix", "projects"."remove_source_branch_after_merge", "projects"."marked_for_deletion_at", "projects"."marked_for_deletion_by_user_id", "projects"."autoclose_referenced_issues", "projects"."suggestion_commit_message", "projects"."project_namespace_id", "projects"."hidden", "projects"."organization_id" FROM "projects" WHERE "projects"."id" BETWEEN 1 AND 1000 AND "projects"."repository_storage" = 'default'
SELECT "project_wiki_repositories".* FROM "project_wiki_repositories" WHERE "project_wiki_repositories"."id" BETWEEN 1 AND 1000 AND "project_wiki_repositories"."project_id" IN (2, 7, 16, 17, 13, 11, 12, 4, 1, 3, 8, 6, 9, 10, 14, 15, 5)
SELECT "snippet_repositories".* FROM "snippet_repositories" INNER JOIN "shards" ON "shards"."id" = "snippet_repositories"."shard_id" WHERE "snippet_repositories"."snippet_id" BETWEEN 1 AND 1000 AND "shards"."name" = 'default'
SELECT "terraform_state_versions".* FROM "terraform_state_versions" INNER JOIN "terraform_states" ON "terraform_states"."id" = "terraform_state_versions"."terraform_state_id" WHERE "terraform_state_versions"."id" BETWEEN 1 AND 1000 AND "terraform_state_versions"."file_store" = 1 AND "terraform_states"."project_id" IN (SELECT "projects"."id" FROM "projects" WHERE "projects"."repository_storage" = 'default')
SELECT "uploads".* FROM "uploads" WHERE "uploads"."id" BETWEEN 1 AND 1000 AND "uploads"."store" = 1 AND ("uploads"."model_type" = 'Namespace' AND "uploads"."model_id" IN (WITH RECURSIVE "base_and_ancestors" AS ((SELECT "namespaces"."id", "namespaces"."parent_id" FROM "namespaces" WHERE "namespaces"."id" IN (SELECT "projects"."namespace_id" FROM "projects" WHERE "projects"."repository_storage" = 'default'))\nUNION\n(SELECT "namespaces"."id", "namespaces"."parent_id" FROM "namespaces", "base_and_ancestors" WHERE "namespaces"."id" = "base_and_ancestors"."parent_id")) SELECT "id" FROM "base_and_ancestors" AS "namespaces") OR "uploads"."model_type" = 'Project' AND "uploads"."model_id" IN (SELECT "projects"."id" FROM "projects" WHERE "projects"."repository_storage" = 'default') OR "uploads"."model_type" NOT IN ('Namespace', 'Project'))

Edited Jan 13, 2025 by Douglas Barbosa Alexandre

Extend selective sync scope to the primary checksumming

What does this MR do and why?

References

MR acceptance checklist

How to set up and validate locally

Raw SQLs

Geo Primary Site (Before)

Geo Primary Site (After)

Feature Flag disabled

Feature Flag enabled

Selective Sync disabled

Selective Sync enabled - Project in certain groups (2 groups selected)

Selective Sync enabled - Project in certain shards (1 shard selected)

Geo Secondary Site (Before)

Selective Sync Disabled

Selective Sync enabled - Project in certain groups (2 groups selected)

Selective Sync enabled - Project in certain shards (1 shard selected)

Geo Secondary Site (After)

Selective Sync Disabled

Selective Sync enabled - Project in certain groups (2 groups selected)

Selective Sync enabled - Project in certain shards (1 shard selected)

Merge request reports