| HashAggregate (cost=113.08..114.49 rows=94 width=84) |
| Group Key: gc.id |
| -> Hash Left Join (cost=29.67..112.14 rows=94 width=30) |
| Hash Cond: (prod.product_component = gc.id) |
| -> Nested Loop (cost=24.07..106.28 rows=94 width=14) |
| -> Hash Join (cost=23.79..36.77 rows=94 width=14) |
| Hash Cond: (sp.id = eipss.erp_sales_outbound_spent_product_id) |
| -> Seq Scan on tbl_erp_sales_outbound_spent_products sp (cost=0.00..10.34 rows=534 width=8) |
| -> Hash (cost=22.62..22.62 rows=94 width=14) |
| -> Hash Join (cost=8.95..22.62 rows=94 width=14) |
| Hash Cond: (eipss.erp_sales_outbound_id = t.id) |
| -> Seq Scan on tbl_erp_inventory_product_spents eipss (cost=0.00..12.65 rows=384 width=18) |
| Filter: (erp_sales_outbound_spent_product_id IS NOT NULL) |
| -> Hash (cost=8.36..8.36 rows=47 width=4) |
| -> Seq Scan on tbl_erp_sales_outbounds t (cost=0.00..8.36 rows=47 width=4) |
| Filter: ((created_at >= '2026-01-01 00:00:00+08'::timestamp with time zone) AND (created_at <= '2026-12-31 23:59:59+08'::timestamp with time zone) AND (status = 2)) |
| -> Index Scan using tbl_products_pkey on tbl_products prod (cost=0.28..0.74 rows=1 width=8) |
| Index Cond: (id = sp.product_id) |
| -> Hash (cost=3.60..3.60 rows=160 width=20) |
| -> Seq Scan on tbl_product_components gc (cost=0.00..3.60 rows=160 width=20) |