| Sort (cost=16.39..16.40 rows=1 width=84) |
| Sort Key: scpcrd.remind_date DESC |
| -> Nested Loop Left Join (cost=0.00..16.38 rows=1 width=84) |
| Join Filter: (sc.project_id = t0.project_id) |
| -> Nested Loop (cost=0.00..7.12 rows=1 width=40) |
| Join Filter: (scpcrd.project_used_client_id = sc.id) |
| -> Seq Scan on tbl_project_used_clients sc (cost=0.00..5.99 rows=1 width=8) |
| Filter: (project_id = 4184) |
| -> Seq Scan on tbl_project_used_client_payment_collection_remind_dates scpcrd (cost=0.00..1.06 rows=6 width=36) |
| -> GroupAggregate (cost=0.00..7.03 rows=1 width=68) |
| Group Key: t0.project_id |
| -> Nested Loop Left Join (cost=0.00..7.01 rows=1 width=9) |
| Join Filter: (t0.id = t1.project_used_client_id) |
| -> Seq Scan on tbl_project_used_clients t0 (cost=0.00..5.99 rows=1 width=8) |
| Filter: (project_id = 4184) |
| -> Seq Scan on tbl_project_used_client_payments t1 (cost=0.00..1.01 rows=1 width=9) |
| SubPlan 1 |
| -> Aggregate (cost=1.09..1.10 rows=1 width=8) |
| -> Seq Scan on tbl_project_used_client_payment_collection_remind_dates scpcrdsub (cost=0.00..1.09 rows=1 width=4) |
| Filter: ((remind_date <= scpcrd.remind_date) AND (project_used_client_id = scpcrd.project_used_client_id)) |
| SubPlan 2 |
| -> Aggregate (cost=1.09..1.10 rows=1 width=8) |
| -> Seq Scan on tbl_project_used_client_payment_collection_remind_dates scpcrdsub_1 (cost=0.00..1.09 rows=1 width=4) |
| Filter: ((remind_date <= scpcrd.remind_date) AND (project_used_client_id = scpcrd.project_used_client_id)) |