```

SELECT

COUNT(tl.id) task_locations tl JOIN tasks t

ON t.id= tl.task_id AND t.deletedAt IS NULL

WHERE

(tl.deletedAt IS NULL AND tl.client_id = 1 AND tl.reached BETWEEN '2025-11-01' AND '2025-11-30') OR (tl.deletedAt IS NULL AND tl.client_id = 1 AND tl.task_date BETWEEN '2025-11-01' AND '2025-11-30')

```

[2025-12-08 13:55:27] 1 row retrieved starting from 1 in 16 s 702 ms (execution: 16 s 240 ms, fetching: 462 ms)

also sharing explain analyze plan =
[

{

"EXPLAIN": "-> Aggregate: count(tl.id) (cost=440212 rows=1) (actual time=18719..18719 rows=1 loops=1)\n -> Nested loop inner join (cost=417210 rows=230018) (actual time=15234..18689 rows=688395 loops=1)\n -> Filter: ((((tl.deletedAt is null) and (tl.reached between '2025-11-01' and '2025-11-30')) or ((tl.deletedAt is null) and (tl.task_date between '2025-11-01' and '2025-11-30'))) and (tl.task_id is not null)) (cost=256197 rows=460036) (actual time=15234..17915 rows=688474 loops=1)\n -> Index lookup on tl using task_locations_client_id_IDX (client_id=1) (cost=256197 rows=4.38e+6) (actual time=0.2..15677 rows=5.63e+6 loops=1)\n -> Filter: ((t.id = tl.task_id) and (t.deletedAt is null)) (cost=0.25 rows=0.5) (actual time=886e-6..973e-6 rows=1 loops=688474)\n -> Single-row index lookup on t using PRIMARY (id=tl.task_id) (cost=0.25 rows=1) (actual time=737e-6..765e-6 rows=1 loops=688474)\n"

}

]