Re: Cost and execution plan

2019-06-26 Thread Tom Lane
AminPG Jaffer writes: > We are facing an issue where the cost shows up "cost=100.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

Cost and execution plan

2019-06-26 Thread AminPG Jaffer
Hi We are facing an issue where the cost shows up "cost=100.00" so trying to find where that is set. Could anyone point me to the code where the cost "cost=100.00" is set? It doesn't show up when searching through find. find . -type f -print | xargs grep 100 | grep -v