Aggregate (cost=28.01..28.02 rows=1 width=32) |
-> Hash Join (cost=13.69..28.00 rows=2 width=32) |
Hash Cond: (esrps.erp_sales_return_id = t.id) |
-> Seq Scan on tbl_erp_sales_return_products esrps (cost=0.00..13.40 rows=340 width=36) |
-> Hash (cost=13.68..13.68 rows=1 width=4) |
-> Seq Scan on tbl_erp_sales_returns t (cost=0.00..13.68 rows=1 width=4) |
Filter: ((status = ANY ('{2,5}'::integer[])) AND (created_at >= '2025-08-01 00:00:00+08'::timestamp with time zone) AND (created_at <= '2025-08-31 23:59:59+08'::timestamp with time zone)) |