Six foreign keys have no index on the referencing column, so deleting the parent scans the child table: identity_aliases and identity_subjects on identity_id, memberships and org_agents on org_id, installed_package_requirements on (org_id, required_name), and tasks on handoff_from_task_id.
Wanted: one index per foreign key that needs it. The small tables matter little today, but tasks.handoff_from_task_id grows with task volume.
Done when: each listed foreign key has a supporting index, and the migration that adds them passes the integrity checks.
Six foreign keys have no index on the referencing column, so deleting the parent scans the child table: identity_aliases and identity_subjects on identity_id, memberships and org_agents on org_id, installed_package_requirements on (org_id, required_name), and tasks on handoff_from_task_id.
Wanted: one index per foreign key that needs it. The small tables matter little today, but `tasks.handoff_from_task_id` grows with task volume.
Done when: each listed foreign key has a supporting index, and the migration that adds them passes the integrity checks.
Already fixed on main by 0033933a (perf(store): index the six unindexed foreign keys). Migration 0074_fk_indexes.sql adds one index per listed key: identity_aliases(identity_id), identity_subjects(identity_id), memberships(org_id), org_agents(org_id), installed_package_requirements(org_id, required_name), tasks(handoff_from_task_id). No further change needed.
Already fixed on main by 0033933a (perf(store): index the six unindexed foreign keys). Migration 0074_fk_indexes.sql adds one index per listed key: identity_aliases(identity_id), identity_subjects(identity_id), memberships(org_id), org_agents(org_id), installed_package_requirements(org_id, required_name), tasks(handoff_from_task_id). No further change needed.
Blocking a user prevents them from interacting with repositories, such as opening or commenting on pull requests or issues. Learn more about blocking a user.
Six foreign keys have no index on the referencing column, so deleting the parent scans the child table: identity_aliases and identity_subjects on identity_id, memberships and org_agents on org_id, installed_package_requirements on (org_id, required_name), and tasks on handoff_from_task_id.
Wanted: one index per foreign key that needs it. The small tables matter little today, but
tasks.handoff_from_task_idgrows with task volume.Done when: each listed foreign key has a supporting index, and the migration that adds them passes the integrity checks.
Already fixed on main by
0033933a(perf(store): index the six unindexed foreign keys). Migration 0074_fk_indexes.sql adds one index per listed key: identity_aliases(identity_id), identity_subjects(identity_id), memberships(org_id), org_agents(org_id), installed_package_requirements(org_id, required_name), tasks(handoff_from_task_id). No further change needed.