Skip to content

Shard abuse_reports

What does this MR do and why?

Shard abuse_reports

Addresses #571831 (closed) && #398199

Changelog: other

References

Number of rows where organization_id IS NULL -> https://postgres.ai/console/gitlab/gitlab-production-main/sessions/44901/commands/138048

Total number of rows in table -> https://postgres.ai/console/gitlab/gitlab-production-main/sessions/44901/commands/138049

SQL

UPDATE "abuse_reports" SET updated_at = updated_at WHERE "abuse_reports"."id" >= 1000 AND "abuse_reports"."id" < 2000 AND "abuse_reports"."organization_id" IS NULL

Explain query: https://postgres.ai/console/gitlab/gitlab-production-main/sessions/44901/commands/138043

MR acceptance checklist

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

Edited by Tomasz Skorupa

Merge request reports

Loading