QUERY PLAN
Aggregate (cost=37.76..37.77 rows=1 width=8)
-> Sort (cost=37.37..37.43 rows=26 width=546)
Sort Key: sub.wrote_date DESC
-> Result (cost=18.72..36.75 rows=26 width=546)
-> Append (cost=18.72..36.49 rows=26 width=4)
-> Subquery Scan on sub (cost=18.72..18.94 rows=10 width=4)
-> HashAggregate (cost=18.72..18.84 rows=10 width=546)
Group Key: r.id
Filter: (sum(eip.inventory) > '0'::numeric)
-> Hash Join (cost=4.36..18.67 rows=10 width=11)
Hash Cond: (rp.erp_inventory_start_id = r.id)
-> Hash Right Join (cost=1.64..15.92 rows=10 width=7)
Hash Cond: (eip.erp_inventory_start_product_id = rp.id)
-> Seq Scan on tbl_erp_inventory_products eip (cost=0.00..12.97 rows=497 width=11)
-> Hash (cost=1.62..1.62 rows=1 width=8)
-> Seq Scan on tbl_erp_inventory_start_products rp (cost=0.00..1.62 rows=1 width=8)
Filter: (product_id = 2177)
-> Hash (cost=2.32..2.32 rows=32 width=8)
-> Seq Scan on tbl_erp_inventory_starts r (cost=0.00..2.32 rows=32 width=8)
-> Subquery Scan on "*SELECT* 2" (cost=0.00..0.02 rows=1 width=4)
-> HashAggregate (cost=0.00..0.01 rows=1 width=546)
Group Key: id
-> Result (cost=0.00..0.00 rows=0 width=8)
One-Time Filter: false
-> Subquery Scan on "*SELECT* 3" (cost=17.19..17.53 rows=15 width=4)
-> HashAggregate (cost=17.19..17.38 rows=15 width=546)
Group Key: r_1.id
Filter: (sum(eip_1.inventory) > '0'::numeric)
-> Hash Join (cost=2.71..17.07 rows=24 width=11)
Hash Cond: (rp_1.erp_purchase_gift_id = r_1.id)
-> Hash Right Join (cost=1.27..15.56 rows=24 width=7)
Hash Cond: (eip_1.erp_purchase_gift_product_id = rp_1.id)
-> Seq Scan on tbl_erp_inventory_products eip_1 (cost=0.00..12.97 rows=497 width=11)
-> Hash (cost=1.26..1.26 rows=1 width=8)
-> Seq Scan on tbl_erp_purchase_gift_products rp_1 (cost=0.00..1.26 rows=1 width=8)
Filter: (product_id = 2177)
-> Hash (cost=1.25..1.25 rows=15 width=8)
-> Seq Scan on tbl_erp_purchase_gifts r_1 (cost=0.00..1.25 rows=15 width=8)
Filter: (status = ANY ('{2,5}'::integer[]))