| Aggregate (cost=110.56..110.57 rows=1 width=32) |
| -> Hash Join (cost=65.64..108.94 rows=645 width=6) |
| Hash Cond: (tbl_sales_contract_invoices.id = sci.id) |
| -> Seq Scan on tbl_sales_contract_invoices (cost=0.00..38.45 rows=1845 width=10) |
| -> Hash (cost=57.58..57.58 rows=645 width=4) |
| -> HashAggregate (cost=44.67..51.12 rows=645 width=4) |
| Group Key: sci.id |
| -> Seq Scan on tbl_sales_contract_invoices sci (cost=0.00..43.06 rows=645 width=4) |
| Filter: ((from_date >= '2024-08-01'::date) OR (NOT is_draft)) |