LAFU Sales Reports

Missing FK indexes on cpanel_provisioned_service and enhance_db_access_rules

FeatureOpenView on roadmap· 28 days ago

Imported from GitHub issue El-SaMa/oma#96 by @El-SaMa.


`cpanel_provisioned_service` has no index on `(organization_id, service_id, credential_id)` despite `enhance_provisioned_service` having them for the same access pattern — joins will seq-scan.

`enhance_db_access_rules` (new, migration 0052) is missing the same: no index on `(service_id, organization_id)`.

Fix: ```sql create index cpanel_provisioned_service_org_idx on cpanel_provisioned_service(organization_id); create index cpanel_provisioned_service_service_idx on cpanel_provisioned_service(service_id); create index enhance_db_access_rules_service_idx on enhance_db_access_rules(service_id); ```

Comments (0)

No comments yet.

Join the discussion

Sign in to leave a comment on this thread.

HollahoopGet yours