Aggregate (cost=268.66..268.67 rows=1 width=32) |
-> Hash Join (cost=194.86..266.42 rows=895 width=7) |
Hash Cond: (tbl_inventory_products.id = "ANY_subquery".id) |
-> Seq Scan on tbl_inventory_products (cost=0.00..56.90 rows=1790 width=11) |
-> Hash (cost=192.36..192.36 rows=200 width=4) |
-> HashAggregate (cost=190.36..192.36 rows=200 width=4) |
Group Key: "ANY_subquery".id |
-> Subquery Scan on "ANY_subquery" (cost=184.56..189.72 rows=258 width=4) |
-> HashAggregate (cost=184.56..187.14 rows=258 width=8) |
Group Key: ip.id, pci.id |
-> Hash Right Join (cost=143.16..183.27 rows=258 width=8) |
Hash Cond: (pip.purchase_invoice_id = pci.id) |
-> Seq Scan on tbl_purchase_invoice_projects pip (cost=0.00..30.52 rows=1952 width=8) |
-> Hash (cost=139.93..139.93 rows=258 width=8) |
-> Hash Left Join (cost=77.88..139.93 rows=258 width=8) |
Hash Cond: (ip.purchase_invoice_id = pci.id) |
-> Seq Scan on tbl_inventory_products ip (cost=0.00..61.38 rows=258 width=8) |
Filter: (inventory > '0'::numeric) |
-> Hash (cost=50.17..50.17 rows=2217 width=8) |
-> Seq Scan on tbl_purchase_contract_invoices pci (cost=0.00..50.17 rows=2217 width=8) |