Re: Cost and execution plan

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: AminPG Jaffer <aminjaffer(dot)pg(at)gmail(dot)com>
Cc: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: Cost and execution plan
Date: 2019-06-27 04:03:14
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

AminPG Jaffer <aminjaffer(dot)pg(at)gmail(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2019-06-27 04:04:30 Re: mcvstats serialization code is still shy of a load
Previous Message AminPG Jaffer 2019-06-27 03:49:08 Cost and execution plan