Skip to content
masterclass Buddy
Start learning

PostgreSQL · Concept

Query planner

PostgreSQL query-planning settings influence which plan types the optimizer considers. They are mainly temporary controls; better results often come from accurate statistics and suitable cost settings.

Last updated

Syntax

SET parameter_name = value;

In-depth API docs are only for subscribers: parameters, examples, common mistakes and interview practice.

Subscribe
  • EXPLAIN
  • ANALYZE
  • enable_seqscan
  • enable_indexscan
  • enable_indexonlyscan
  • enable_memoize
  • default_statistics_target
  • plan_cache_mode

Source: PostgreSQL: Documentation: 18: 19.7. Query Planning. Checked 2026-11-03.