| HashAggregate (cost=114.24..114.86 rows=41 width=80) |
| Group Key: gt.id |
| -> Hash Left Join (cost=99.22..113.83 rows=41 width=29) |
| Hash Cond: (prod.product_type = gt.id) |
| -> Hash Join (cost=96.80..111.30 rows=41 width=17) |
| Hash Cond: (eip.product_id = prod.id) |
| -> Seq Scan on tbl_erp_inventory_products eip (cost=0.00..14.39 rows=41 width=17) |
| Filter: (((erp_purchase_inbound_id IS NOT NULL) OR (erp_purchase_gift_id IS NOT NULL) OR (erp_inventory_build_id IS NOT NULL) OR (erp_inventory_disassemble_id IS NOT NULL) OR (erp_inventory_start_id IS NOT NULL)) AND (inventory > '0'::numeric)) |
| -> Hash (cost=70.80..70.80 rows=2080 width=8) |
| -> Seq Scan on tbl_products prod (cost=0.00..70.80 rows=2080 width=8) |
| -> Hash (cost=1.63..1.63 rows=63 width=16) |
| -> Seq Scan on tbl_product_types gt (cost=0.00..1.63 rows=63 width=16) |