QUERY PLAN
Sort (cost=14.81..14.82 rows=1 width=193)
Sort Key: t.settle_at
-> Append (cost=0.28..14.80 rows=1 width=193)
-> Nested Loop (cost=0.28..14.79 rows=1 width=193)
-> Index Scan using tbl_erp_payment_tickets_pkey on tbl_erp_payment_tickets r (cost=0.28..8.30 rows=1 width=103)
Index Cond: (id = 2364)
Filter: (is_payment_settle AND (status = ANY ('{2,6}'::integer[])))
-> Seq Scan on tbl_erp_payment_ticket_bank_outs t (cost=0.00..6.47 rows=1 width=22)
Filter: ((id IS NOT NULL) AND (erp_payment_ticket_id = 2364))