| Sort (cost=32.30..32.31 rows=1 width=200) |
| Sort Key: t.settle_at |
| -> Append (cost=0.29..32.29 rows=1 width=200) |
| -> Nested Loop (cost=0.29..32.28 rows=1 width=200) |
| -> Index Scan using tbl_erp_cash_cost_tickets_pkey on tbl_erp_cash_cost_tickets r (cost=0.29..8.30 rows=1 width=103) |
| Index Cond: (id = 8490) |
| Filter: (is_payment_settle AND (status = ANY ('{2,6}'::integer[]))) |
| -> Seq Scan on tbl_erp_cash_cost_ticket_bank_outs t (cost=0.00..23.96 rows=1 width=21) |
| Filter: ((id IS NOT NULL) AND (erp_cash_cost_ticket_id = 8490)) |