Optimize query: Model Scopes

File: ee/app/models/ai/duo_workflows/checkpoint.rb (Lines 30-31)

scope :ordered_with_writes, -> { includes(:checkpoint_writes).order(thread_ts: :desc) }
scope :with_checkpoint_writes, -> { includes(:checkpoint_writes) }

Generated SQL (ordered_with_writes):

SELECT "p_duo_workflows_checkpoints".* 
FROM "p_duo_workflows_checkpoints" 
WHERE "p_duo_workflows_checkpoints"."workflow_id" = $1 
ORDER BY "p_duo_workflows_checkpoints"."thread_ts" DESC

-- Followed by eager loading:
SELECT "p_duo_workflows_checkpoint_writes".* 
FROM "p_duo_workflows_checkpoint_writes" 
WHERE "p_duo_workflows_checkpoint_writes"."thread_ts" IN (...)
  AND "p_duo_workflows_checkpoint_writes"."workflow_id" = $1

Optimization needed: Ensure queries include created_at filter for partition pruning.