| Aggregate (cost=611.10..611.11 rows=1 width=8) |
| -> Append (cost=73.06..586.00 rows=10040 width=0) |
| -> Subquery Scan on sub (cost=73.06..116.76 rows=2185 width=0) |
| -> HashAggregate (cost=73.06..94.91 rows=2185 width=293) |
| Group Key: r.id |
| -> Seq Scan on tbl_erp_payment_tickets r (cost=0.00..67.60 rows=2185 width=4) |
| Filter: (status = 2) |
| -> Subquery Scan on "*SELECT* 2" (cost=294.75..451.65 rows=7845 width=0) |
| -> HashAggregate (cost=294.75..373.20 rows=7845 width=293) |
| Group Key: r_1.id |
| -> Seq Scan on tbl_erp_cash_cost_tickets r_1 (cost=0.00..275.14 rows=7845 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=1.15..1.25 rows=5 width=0) |
| -> HashAggregate (cost=1.15..1.20 rows=5 width=293) |
| Group Key: r_3.id |
| -> Seq Scan on tbl_erp_wage_tickets r_3 (cost=0.00..1.14 rows=5 width=4) |
| Filter: (status = 2) |
| -> Subquery Scan on "*SELECT* 5" (cost=1.08..1.10 rows=1 width=0) |
| -> Group (cost=1.08..1.09 rows=1 width=293) |
| Group Key: r_4.id |
| -> Sort (cost=1.08..1.09 rows=1 width=4) |
| Sort Key: r_4.id |
| -> Seq Scan on tbl_erp_social_insurances r_4 (cost=0.00..1.07 rows=1 width=4) |
| Filter: (status = 2) |
| -> Subquery Scan on "*SELECT* 6" (cost=1.05..1.06 rows=1 width=0) |
| -> Group (cost=1.05..1.05 rows=1 width=293) |
| Group Key: r_5.id |
| -> Sort (cost=1.05..1.05 rows=1 width=4) |
| Sort Key: r_5.id |
| -> Seq Scan on tbl_erp_provident_funds r_5 (cost=0.00..1.04 rows=1 width=4) |
| Filter: (status = 2) |
| -> Subquery Scan on "*SELECT* 7" (cost=1.06..1.08 rows=1 width=0) |
| -> Group (cost=1.06..1.07 rows=1 width=293) |
| Group Key: r_6.id |
| -> Sort (cost=1.06..1.06 rows=1 width=4) |
| Sort Key: r_6.id |
| -> Seq Scan on tbl_erp_personal_taxs r_6 (cost=0.00..1.05 rows=1 width=4) |
| Filter: (status = 2) |
| -> Subquery Scan on "*SELECT* 8" (cost=1.05..1.06 rows=1 width=0) |
| -> Group (cost=1.05..1.05 rows=1 width=293) |
| Group Key: r_7.id |
| -> Sort (cost=1.05..1.05 rows=1 width=4) |
| Sort Key: r_7.id |
| -> Seq Scan on tbl_erp_wage_prizes r_7 (cost=0.00..1.04 rows=1 width=4) |
| Filter: (status = 2) |