---

BEGIN;

SET LOCAL statement_timeout = '20s';

EXPLAIN (ANALYZE, BUFFERS, TIMING OFF)
SELECT count(*)
FROM back_office.operation o
WHERE o.operation_type_id = (
    SELECT id
    FROM back_office.operation_type
    WHERE code = 'CHARGE_FROM_RESERVE'
)
  AND o.ops_assignee_decision_id IS NOT NULL
  AND o.approved IS NOT NULL
  AND o.deleted IS NULL
  AND o.effective_date <= current_date;

ROLLBACK;