AminPG Jaffer <aminjaffer.pg@gmail.com> writes:
> We are facing an issue where the cost shows up "cost=10000000000.00" so
> trying to find where that is set.
That means you've turned off enable_seqscan (or one of its siblings)
but the planner is choosing a seqscan plan (or other plan type you
tried to disable) anyway because it has no other alternative.
> Could anyone point me to the code where the cost "cost=10000000000.00" is
> set?
Look for disable_cost.
regards, tom lane