QUERY PLAN
Aggregate (cost=502.41..502.42 rows=1 width=32)
-> Append (cost=0.00..501.64 rows=307 width=5)
-> Subquery Scan on "*SELECT* 1" (cost=0.00..490.09 rows=288 width=5)
-> Seq Scan on tbl_erp_cash_cost_tickets r (cost=0.00..487.21 rows=288 width=13)
Filter: (is_payment_settle AND (bank_settle_at >= '2026-01-01 00:00:00+08'::timestamp with time zone) AND (bank_settle_at <= '2026-06-30 23:59:59+08'::timestamp with time zone) AND (status = 2))
-> Subquery Scan on "*SELECT* 2" (cost=0.00..4.53 rows=9 width=5)
-> Seq Scan on tbl_erp_cost_tickets r_1 (cost=0.00..4.44 rows=9 width=13)
Filter: ((verify_at >= '2026-01-01 00:00:00+08'::timestamp with time zone) AND (verify_at <= '2026-06-30 23:59:59+08'::timestamp with time zone) AND (status = 2))
-> Subquery Scan on "*SELECT* 3" (cost=0.00..1.19 rows=1 width=32)
-> Seq Scan on tbl_erp_cost_convert_tickets r_2 (cost=0.00..1.18 rows=1 width=40)
Filter: ((verify_at >= '2026-01-01 00:00:00+08'::timestamp with time zone) AND (verify_at <= '2026-06-30 23:59:59+08'::timestamp with time zone) AND (status = 2))
-> Subquery Scan on "*SELECT* 4" (cost=0.00..1.30 rows=5 width=4)
-> Seq Scan on tbl_erp_wage_tickets r_3 (cost=0.00..1.25 rows=5 width=12)
Filter: ((verify_at >= '2026-01-01 00:00:00+08'::timestamp with time zone) AND (verify_at <= '2026-06-30 23:59:59+08'::timestamp with time zone) AND (status = 2))
-> Subquery Scan on "*SELECT* 5" (cost=0.00..1.19 rows=1 width=32)
-> Seq Scan on tbl_erp_social_insurances r_4 (cost=0.00..1.18 rows=1 width=40)
Filter: ((verify_at >= '2026-01-01 00:00:00+08'::timestamp with time zone) AND (verify_at <= '2026-06-30 23:59:59+08'::timestamp with time zone) AND (status = 2))
-> Subquery Scan on "*SELECT* 6" (cost=0.00..1.13 rows=1 width=32)
-> Seq Scan on tbl_erp_provident_funds r_5 (cost=0.00..1.12 rows=1 width=40)
Filter: ((verify_at >= '2026-01-01 00:00:00+08'::timestamp with time zone) AND (verify_at <= '2026-06-30 23:59:59+08'::timestamp with time zone) AND (status = 2))
-> Subquery Scan on "*SELECT* 7" (cost=0.00..1.15 rows=1 width=32)
-> Seq Scan on tbl_erp_personal_taxs r_6 (cost=0.00..1.14 rows=1 width=40)
Filter: ((verify_at >= '2026-01-01 00:00:00+08'::timestamp with time zone) AND (verify_at <= '2026-06-30 23:59:59+08'::timestamp with time zone) AND (status = 2))
-> Subquery Scan on "*SELECT* 8" (cost=0.00..1.08 rows=1 width=32)
-> Seq Scan on tbl_erp_wage_prizes r_7 (cost=0.00..1.07 rows=1 width=40)
Filter: ((verify_at >= '2026-01-01 00:00:00+08'::timestamp with time zone) AND (verify_at <= '2026-06-30 23:59:59+08'::timestamp with time zone) AND (status = 2))