QUERY PLAN
Aggregate (cost=568.48..568.49 rows=1 width=8)
-> Append (cost=103.88..568.31 rows=66 width=0)
-> Subquery Scan on sub (cost=103.88..104.21 rows=22 width=0)
-> Group (cost=103.88..103.99 rows=22 width=293)
Group Key: r.id
-> Sort (cost=103.88..103.94 rows=22 width=4)
Sort Key: r.id
-> Result (cost=0.00..103.39 rows=22 width=4)
One-Time Filter: (20012 = ANY ('{20012,20019}'::integer[]))
-> Seq Scan on tbl_erp_payment_tickets r (cost=0.00..103.39 rows=22 width=4)
Filter: ((NOT is_payment_settle) AND (status = 2))
-> Subquery Scan on "*SELECT* 2" (cost=445.76..446.29 rows=35 width=0)
-> Group (cost=445.76..445.94 rows=35 width=293)
Group Key: r_1.id
-> Sort (cost=445.76..445.85 rows=35 width=4)
Sort Key: r_1.id
-> Result (cost=0.00..444.87 rows=35 width=4)
One-Time Filter: (20018 = ANY ('{20012,20019}'::integer[]))
-> Seq Scan on tbl_erp_cash_cost_tickets r_1 (cost=0.00..444.87 rows=35 width=4)
Filter: ((NOT is_payment_settle) AND (status = 2))
-> Subquery Scan on "*SELECT* 3" (cost=12.01..12.03 rows=1 width=0)
-> Group (cost=12.01..12.02 rows=1 width=293)
Group Key: r_2.id
-> Sort (cost=12.01..12.02 rows=1 width=4)
Sort Key: r_2.id
-> Result (cost=0.00..12.00 rows=1 width=4)
One-Time Filter: (20019 = ANY ('{20012,20019}'::integer[]))
-> Seq Scan on tbl_erp_advance_payment_tickets r_2 (cost=0.00..12.00 rows=1 width=4)
Filter: ((NOT is_payment_settle) AND (status = 2))
-> Subquery Scan on "*SELECT* 4" (cost=1.22..1.30 rows=4 width=0)
-> HashAggregate (cost=1.22..1.26 rows=4 width=293)
Group Key: r_3.id
-> Result (cost=0.00..1.21 rows=4 width=4)
One-Time Filter: (20023 = ANY ('{20012,20019}'::integer[]))
-> Seq Scan on tbl_erp_wage_tickets r_3 (cost=0.00..1.21 rows=4 width=4)
Filter: ((settle_amount < amount) AND (status = 2))
-> Subquery Scan on "*SELECT* 5" (cost=1.14..1.15 rows=1 width=0)
-> Group (cost=1.14..1.14 rows=1 width=293)
Group Key: r_4.id
-> Sort (cost=1.14..1.14 rows=1 width=4)
Sort Key: r_4.id
-> Result (cost=0.00..1.13 rows=1 width=4)
One-Time Filter: (20024 = ANY ('{20012,20019}'::integer[]))
-> Seq Scan on tbl_erp_social_insurances r_4 (cost=0.00..1.13 rows=1 width=4)
Filter: ((NOT is_payment_settle) AND (status = 2))
-> Subquery Scan on "*SELECT* 6" (cost=1.10..1.12 rows=1 width=0)
-> Group (cost=1.10..1.11 rows=1 width=293)
Group Key: r_5.id
-> Sort (cost=1.10..1.10 rows=1 width=4)
Sort Key: r_5.id
-> Result (cost=0.00..1.09 rows=1 width=4)
One-Time Filter: (20025 = ANY ('{20012,20019}'::integer[]))
-> Seq Scan on tbl_erp_provident_funds r_5 (cost=0.00..1.09 rows=1 width=4)
Filter: ((NOT is_payment_settle) AND (status = 2))
-> Subquery Scan on "*SELECT* 7" (cost=1.11..1.13 rows=1 width=0)
-> Group (cost=1.11..1.12 rows=1 width=293)
Group Key: r_6.id
-> Sort (cost=1.11..1.12 rows=1 width=4)
Sort Key: r_6.id
-> Result (cost=0.00..1.10 rows=1 width=4)
One-Time Filter: (20026 = ANY ('{20012,20019}'::integer[]))
-> Seq Scan on tbl_erp_personal_taxs r_6 (cost=0.00..1.10 rows=1 width=4)
Filter: ((NOT is_payment_settle) AND (status = 2))
-> Subquery Scan on "*SELECT* 8" (cost=1.06..1.08 rows=1 width=0)
-> Group (cost=1.06..1.07 rows=1 width=293)
Group Key: r_7.id
-> Sort (cost=1.06..1.07 rows=1 width=4)
Sort Key: r_7.id
-> Result (cost=0.00..1.05 rows=1 width=4)
One-Time Filter: (20027 = ANY ('{20012,20019}'::integer[]))
-> Seq Scan on tbl_erp_wage_prizes r_7 (cost=0.00..1.05 rows=1 width=4)
Filter: ((NOT is_payment_settle) AND (status = 2))