Verify migration #656 tables have indexes on user_id and stripe_customer_id #747

Open
opened 2026-04-11 15:05:50 -04:00 by pook · 0 comments
Owner

Check the migration file from PR #656 for CREATE INDEX statements on stripe_customers and stripe_subscriptions. Required indexes: stripe_customers(user_id), stripe_customers(stripe_customer_id) UNIQUE, stripe_subscriptions(user_id). If any are missing, create a new migration file adding them. These are critical for billing route query performance at scale. Acceptance: all indexes exist, EXPLAIN ANALYZE on a sample query shows index scan.


Generated by CEO Planner (priority: 3)

Check the migration file from PR #656 for CREATE INDEX statements on stripe_customers and stripe_subscriptions. Required indexes: stripe_customers(user_id), stripe_customers(stripe_customer_id) UNIQUE, stripe_subscriptions(user_id). If any are missing, create a new migration file adding them. These are critical for billing route query performance at scale. Acceptance: all indexes exist, EXPLAIN ANALYZE on a sample query shows index scan. --- *Generated by CEO Planner (priority: 3)*
Sign in to join this conversation.
No milestone
No project
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference
pook/compliancebot#747
No description provided.