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