Aggregate (cost=2.99..3.00 rows=1 width=8) |
-> Append (cost=0.00..2.98 rows=2 width=0) |
-> Subquery Scan on "*SELECT* 1" (cost=0.00..1.67 rows=1 width=0) |
-> Seq Scan on tbl_erp_other_payment_tickets (cost=0.00..1.66 rows=1 width=198) |
Filter: ((status = 2) AND (client_id = 3281) AND ((amount - settle_amount) > '0'::numeric)) |
-> Subquery Scan on "*SELECT* 2" (cost=0.00..1.31 rows=1 width=0) |
-> Seq Scan on tbl_erp_cost_tickets (cost=0.00..1.30 rows=1 width=198) |
Filter: ((status = 2) AND (client_id = 3281) AND ((amount - settle_amount) > '0'::numeric)) |