QUERY PLAN
Limit (cost=56.02..56.03 rows=1 width=155)
-> Sort (cost=56.02..56.03 rows=1 width=155)
Sort Key: sci.from_date DESC, sci.created_at DESC
-> Group (cost=56.00..56.01 rows=1 width=155)
Group Key: sci.id
-> Sort (cost=56.00..56.01 rows=1 width=155)
Sort Key: sci.id
-> Seq Scan on tbl_sales_contract_invoices sci (cost=0.00..55.99 rows=1 width=155)
Filter: ((cover_invoice_id IS NULL) AND (NOT is_cancel) AND ((invoice_type <> '-1'::smallint) OR (invoice_type IS NULL)) AND (contract_id = 4484))