Temporarily discourage sequential scans while investigating plans.
Section: Planner Settings and Statistics
Disable seqscan for investigation
sql
sql
SET enable_seqscan = off;Explanation
Do not use as a permanent performance fix.
Learn the surrounding workflow
Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.
Related commands
Same sheet · prioritizing Planner Settings and Statistics
Show effective_cache_size
Inspect a planner estimate of OS cache availability.
Show random_page_cost
Inspect a cost parameter that influences index-vs-seqscan decisions.