PostgreSQL Documentation: enable

Type:	`bool`
Default:	`on`
Context:	`user`
Restart:	`false`

Enables the planner's use of sequential-scan plans

Enables or disables the query planner's use of sequential scan plan types. It is impossible to suppress sequential scans entirely, but turning this variable off discourages the planner from using one if there are other methods available. The default is on.

Official docs

Search in source code

Recommendations

For interactive session use only when troubleshooting queries.

By annotated.conf

On StackOverflow

set enable_seqscan = off, through jdbc | Postgres
Setting enable_seqscan = off in a single SELECT query
Fast tags searching in PostgreSQL (arrays, GIN, seqscan)
postgres chooses an aweful query plan , how can that be fixed
Deducing estimated time taken with EXPLAIN

On pgsql-hackers

Re: explain HashAggregate to report bucket and memory stats
Tid scan increments value of pg_stat_all_tables.seq_scan. (but not seq_tup_read)
Re: [PATCH] Incremental sort (was: PoC: Partial sort)
Re: kill_prior_tuple and index scan costing
Re: Tid scan increments value of pg_stat_all_tables.seq_scan. (but not seq_tup_read)

enable_seqscan

Recommendations

On StackOverflow

On pgsql-hackers

Comments