QUERY PLAN
Aggregate (cost=99.99..100.00 rows=1 width=8)
-> Append (cost=12.26..99.97 rows=8 width=0)
-> Subquery Scan on sub (cost=12.26..12.28 rows=1 width=0)
-> Group (cost=12.26..12.27 rows=1 width=293)
Group Key: r.id
-> Sort (cost=12.26..12.27 rows=1 width=4)
Sort Key: r.id
-> Seq Scan on tbl_erp_payment_tickets r (cost=0.00..12.25 rows=1 width=4)
Filter: (status = 2)
-> Subquery Scan on "*SELECT* 2" (cost=12.38..12.40 rows=1 width=0)
-> Group (cost=12.38..12.39 rows=1 width=293)
Group Key: r_1.id
-> Sort (cost=12.38..12.39 rows=1 width=4)
Sort Key: r_1.id
-> Seq Scan on tbl_erp_cash_cost_tickets r_1 (cost=0.00..12.38 rows=1 width=4)
Filter: (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
-> Seq Scan on tbl_erp_advance_payment_tickets r_2 (cost=0.00..12.00 rows=1 width=4)
Filter: (status = 2)
-> Subquery Scan on "*SELECT* 4" (cost=12.63..12.65 rows=1 width=0)
-> Group (cost=12.63..12.64 rows=1 width=293)
Group Key: r_3.id
-> Sort (cost=12.63..12.64 rows=1 width=4)
Sort Key: r_3.id
-> Seq Scan on tbl_erp_wage_tickets r_3 (cost=0.00..12.62 rows=1 width=4)
Filter: (status = 2)
-> Subquery Scan on "*SELECT* 5" (cost=12.63..12.65 rows=1 width=0)
-> Group (cost=12.63..12.64 rows=1 width=293)
Group Key: r_4.id
-> Sort (cost=12.63..12.64 rows=1 width=4)
Sort Key: r_4.id
-> Seq Scan on tbl_erp_social_insurances r_4 (cost=0.00..12.62 rows=1 width=4)
Filter: (status = 2)
-> Subquery Scan on "*SELECT* 6" (cost=12.63..12.65 rows=1 width=0)
-> Group (cost=12.63..12.64 rows=1 width=293)
Group Key: r_5.id
-> Sort (cost=12.63..12.64 rows=1 width=4)
Sort Key: r_5.id
-> Seq Scan on tbl_erp_provident_funds r_5 (cost=0.00..12.62 rows=1 width=4)
Filter: (status = 2)
-> Subquery Scan on "*SELECT* 7" (cost=12.63..12.65 rows=1 width=0)
-> Group (cost=12.63..12.64 rows=1 width=293)
Group Key: r_6.id
-> Sort (cost=12.63..12.64 rows=1 width=4)
Sort Key: r_6.id
-> Seq Scan on tbl_erp_personal_taxs r_6 (cost=0.00..12.62 rows=1 width=4)
Filter: (status = 2)
-> Subquery Scan on "*SELECT* 8" (cost=12.63..12.65 rows=1 width=0)
-> Group (cost=12.63..12.64 rows=1 width=293)
Group Key: r_7.id
-> Sort (cost=12.63..12.64 rows=1 width=4)
Sort Key: r_7.id
-> Seq Scan on tbl_erp_wage_prizes r_7 (cost=0.00..12.62 rows=1 width=4)
Filter: (status = 2)