QUERY PLAN
Seq Scan on tbl_purchase_contracts (cost=0.00..88.42 rows=1 width=18)
Filter: ((serial_no)::text ~~* '%646456456%'::text)