| Sort (cost=275.13..275.14 rows=5 width=113) |
| Sort Key: scpcrd.remind_date DESC |
| -> Nested Loop Left Join (cost=6.30..275.07 rows=5 width=113) |
| Join Filter: (sc.project_id = p.project_id) |
| -> Hash Join (cost=3.15..24.18 rows=5 width=69) |
| Hash Cond: (scpcrd.project_used_client_id = sc.id) |
| -> Seq Scan on tbl_project_used_client_payment_collection_remind_dates scpcrd (cost=0.00..18.70 rows=870 width=65) |
| -> Hash (cost=3.14..3.14 rows=1 width=8) |
| -> Seq Scan on tbl_project_used_clients sc (cost=0.00..3.14 rows=1 width=8) |
| Filter: (project_id = 3488) |
| -> Materialize (cost=3.15..20.17 rows=1 width=36) |
| -> Subquery Scan on p (cost=3.15..20.16 rows=1 width=36) |
| -> GroupAggregate (cost=3.15..20.15 rows=1 width=68) |
| Group Key: t0.project_id |
| -> Hash Right Join (cost=3.15..20.13 rows=3 width=36) |
| Hash Cond: (t1.project_used_client_id = t0.id) |
| -> Seq Scan on tbl_project_used_client_payments t1 (cost=0.00..15.50 rows=550 width=36) |
| -> Hash (cost=3.14..3.14 rows=1 width=8) |
| -> Seq Scan on tbl_project_used_clients t0 (cost=0.00..3.14 rows=1 width=8) |
| Filter: (project_id = 3488) |
| SubPlan 1 |
| -> Aggregate (cost=23.05..23.06 rows=1 width=8) |
| -> Seq Scan on tbl_project_used_client_payment_collection_remind_dates scpcrdsub (cost=0.00..23.05 rows=1 width=4) |
| Filter: ((remind_date <= scpcrd.remind_date) AND (project_used_client_id = scpcrd.project_used_client_id)) |
| SubPlan 2 |
| -> Aggregate (cost=23.05..23.06 rows=1 width=8) |
| -> Seq Scan on tbl_project_used_client_payment_collection_remind_dates scpcrdsub_1 (cost=0.00..23.05 rows=1 width=4) |
| Filter: ((remind_date <= scpcrd.remind_date) AND (project_used_client_id = scpcrd.project_used_client_id)) |