| Sort (cost=483.70..483.72 rows=9 width=105) |
| Sort Key: scpcrd.remind_date DESC |
| -> Nested Loop Left Join (cost=4.70..483.55 rows=9 width=105) |
| Join Filter: (sc.project_id = p.project_id) |
| -> Hash Join (cost=2.35..24.53 rows=9 width=61) |
| Hash Cond: (scpcrd.project_used_client_id = sc.id) |
| -> Seq Scan on tbl_project_used_client_payment_collection_remind_dates scpcrd (cost=0.00..19.60 rows=960 width=57) |
| -> Hash (cost=2.34..2.34 rows=1 width=8) |
| -> Seq Scan on tbl_project_used_clients sc (cost=0.00..2.34 rows=1 width=8) |
| Filter: (project_id = 3809) |
| -> Materialize (cost=2.35..19.38 rows=1 width=36) |
| -> Subquery Scan on p (cost=2.35..19.37 rows=1 width=36) |
| -> GroupAggregate (cost=2.35..19.36 rows=1 width=68) |
| Group Key: t0.project_id |
| -> Hash Right Join (cost=2.35..19.33 rows=5 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=2.34..2.34 rows=1 width=8) |
| -> Seq Scan on tbl_project_used_clients t0 (cost=0.00..2.34 rows=1 width=8) |
| Filter: (project_id = 3809) |
| SubPlan 1 |
| -> Aggregate (cost=24.40..24.41 rows=1 width=8) |
| -> Seq Scan on tbl_project_used_client_payment_collection_remind_dates scpcrdsub (cost=0.00..24.40 rows=2 width=4) |
| Filter: ((remind_date <= scpcrd.remind_date) AND (project_used_client_id = scpcrd.project_used_client_id)) |
| SubPlan 2 |
| -> Aggregate (cost=24.40..24.41 rows=1 width=8) |
| -> Seq Scan on tbl_project_used_client_payment_collection_remind_dates scpcrdsub_1 (cost=0.00..24.40 rows=2 width=4) |
| Filter: ((remind_date <= scpcrd.remind_date) AND (project_used_client_id = scpcrd.project_used_client_id)) |