| Sort (cost=12.69..12.69 rows=1 width=188) |
| Sort Key: t.settle_at |
| -> Append (cost=0.28..12.68 rows=1 width=188) |
| -> Nested Loop (cost=0.28..12.67 rows=1 width=188) |
| -> Index Scan using tbl_erp_collect_tickets_pkey on tbl_erp_collect_tickets r (cost=0.28..8.30 rows=1 width=97) |
| Index Cond: (id = 2199) |
| Filter: (status = ANY ('{2,6}'::integer[])) |
| -> Seq Scan on tbl_erp_collect_ticket_bank_ins t (cost=0.00..4.35 rows=1 width=22) |
| Filter: ((id IS NOT NULL) AND (erp_collect_ticket_id = 2199)) |