| Aggregate (cost=376.23..376.24 rows=1 width=8) |
| -> Sort (cost=354.34..357.99 rows=1459 width=301) |
| Sort Key: pci.from_date DESC NULLS LAST, pci.created_at DESC NULLS LAST |
| -> HashAggregate (cost=263.08..277.67 rows=1459 width=301) |
| Group Key: pci.id |
| -> Hash Right Join (cost=143.06..258.79 rows=1714 width=16) |
| Hash Cond: (pcpp.purchase_invoice_id = pci.id) |
| -> Seq Scan on tbl_purchase_invoice_products pcpp (cost=0.00..87.25 rows=3025 width=4) |
| -> Hash (cost=124.82..124.82 rows=1459 width=16) |
| -> Hash Right Join (cost=85.42..124.82 rows=1459 width=16) |
| Hash Cond: (pip.purchase_invoice_id = pci.id) |
| -> Seq Scan on tbl_purchase_invoice_projects pip (cost=0.00..33.69 rows=2169 width=8) |
| -> Hash (cost=67.19..67.19 rows=1459 width=24) |
| -> Seq Scan on tbl_purchase_contract_invoices pci (cost=0.00..67.19 rows=1459 width=24) |
| Filter: ((cover_invoice_id IS NULL) AND ((from_date >= '2024-08-01'::date) OR (NOT is_draft))) |